prefix . ‘random_q_table’);
add_action(‘admin_menu’, ‘randomquote_menu’);

function randomquote_menu()
{
$allowed_group = ‘manage_options’;

//Add the admin panel for randomquote
if(function_exists(‘add_menu_page’))
{
add_menu_page(__(‘Random Quote Maker’,'rndmqmker’), __(‘Random Quote Maker’,'rndmqmker’),$allowed_group,’rndmqmker’,'edit_options’);
}
}

function edit_options()
{
global $wpdb;

$action = !empty($_REQUEST['action']) ? $_REQUEST['action'] : ‘add’;

//echo $action;
//for deleting
$quote_id = !empty($_REQUEST['quote_id']) ? $_REQUEST['quote_id'] : ”;
//the quote itself
$quote = !empty($_REQUEST['quote']) ? $_REQUEST['quote'] : ”;
//the author of the quote… Anonymous if left blank…
$author = !empty($_REQUEST['author']) ? $_REQUEST['author'] : ‘Anonymous’;

//check to see if the database is installed… and if they have the right version later…
check_random_quote_database();

//if there is a quote ready to be saved let’s save it right away
if(!empty($quote)&&$action!=’edit’)
{
//some security.
$quote = trim(htmlspecialchars(mysql_real_escape_string($quote)));
//trust no one and escape everything.
$author = trim(htmlspecialchars(mysql_real_escape_string($author)));
//the query.
$sql = “INSERT INTO ” . RANDOM_Q_TABLE . ” (rq_quote,rq_author) VALUES (‘” . $quote . “‘,’” . $author . “‘);”;
//run the query.
$wpdb->get_results($sql);
//See if the query successfully went through…
$sql = “SELECT * FROM ” . RANDOM_Q_TABLE . ” WHERE rq_quote=’” . mysql_real_escape_string($quote) . “‘”;
$results = $wpdb->get_results($sql);
//if it returned a non empty quote we know it worked
if(!empty($results[0]->rq_quote))
{
//pre setup class for the div to display that nice updated message…
?>

get_results($sql);
//check that it worked… The query
$sql = “SELECT * FROM ” . RANDOM_Q_TABLE . ” WHERE rq_id=’” . mysql_real_escape_string($quote_id) . “‘”;
//run it
$results = $wpdb->get_results($sql);
//did we get anything back? If so it didn’t delete
if(empty($results) || empty($results[0]->rq_id))
{
?>

get_results($sql);
//check that it worked… The query
$sql = “SELECT * FROM ” . RANDOM_Q_TABLE . ” WHERE rq_id=’” . mysql_real_escape_string($quote_id) . “‘”;
//run it
$results = $wpdb->get_results($sql);
//did we get anything back? If so it didn’t delete
if(empty($results) || empty($results[0]->rq_id))
{
?>

get_var(“SHOW TABLES LIKE ‘$table_name’”) != $table_name)
{
$sql = “CREATE TABLE ” . $table_name . ” (
rq_id INT(11) NOT NULL AUTO_INCREMENT,
rq_quote TEXT,
rq_author VARCHAR(100) NOT NULL DEFAULT ‘anonymous’,
PRIMARY KEY id (rq_id)
);”;

require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’);
dbDelta($sql);

$insert = “INSERT INTO ” . $table_name .
” (rq_quote, rq_author) ” .
“VALUES (‘A penny saved is a penny earned.’,'Ben Franklin’)”;

$results = $wpdb->query( $insert );
add_option(“rq_db_version”, $rq_db_version);
}
//for updates
$installed_ver = get_option( “cl_db_version” );
}
function rq_display_quotes()
{
//we need the wp database functions
global $wpdb;

//get all the quotes and authors
$quotes = $wpdb->get_results( ‘SELECT * FROM ‘ . RANDOM_Q_TABLE . ‘ ORDER BY ‘ . RANDOM_Q_TABLE . ‘.rq_author ASC’);

//if we got quotes back…
if( !empty($quotes))
{
?>
<a href="?page=rndmqmker”>Add New Quote

rq_quote) > 30)
{
//if this quote is longer than 30 do a dot dot dot
$new_quote = substr($quote->rq_quote,0, 30);
$new_quote .= “…”;
}
else
{
$new_quote = $quote->rq_quote;
}
$url = get_bloginfo(‘wpurl’);
//output the info into the table.. It will call itelf when they press delete… PHP_SELF
?>
<tr class="”>
rq_id;?>

rq_author; ?>
<a href="?page=rndmqmker&action=delete&quote_id=rq_id;?>” class=”delete” onclick=”return confirm(”)”>
<a href="?page=rndmqmker&action=edit&rq_id=rq_id;?>” class=”delete” >

get_results( ‘SELECT * FROM ‘ . RANDOM_Q_TABLE . ‘ where rq_id=’.$_REQUEST['rq_id'].”);
foreach($quotes as $quote)
{
$str1 = preg_replace(“//”, “”, $quote->rq_quote);
$str = strip_tags($str1, ”);
//echo $str;
$auth= preg_replace(“//”, “”,$quote->rq_author);
}
?>
<form class="wrap" method="post" action="?page=rndmqmker&action=&rq_id=”>

<input type="text" name="author" class="input" size="40" maxlength="200" value="” />

<input type="submit" name="save" class="button bold" value=" »” />

get_row(‘SELECT * FROM ‘ . RANDOM_Q_TABLE . ‘ ORDER BY RAND() LIMIT 1′);

return $result->rq_quote . ‘–’ . $result->rq_author;
}

add_shortcode(‘randomquote’, ‘random_quote’);

?>