From 24503e3abe705acde2df159aeae61be0d009f92e Mon Sep 17 00:00:00 2001 From: Starla Insigna Date: Wed, 19 Nov 2008 17:27:03 -0500 Subject: Imported sources --- pages/quotes.php | 166 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 166 insertions(+) create mode 100644 pages/quotes.php (limited to 'pages/quotes.php') diff --git a/pages/quotes.php b/pages/quotes.php new file mode 100644 index 0000000..78cd543 --- /dev/null +++ b/pages/quotes.php @@ -0,0 +1,166 @@ +adds_block('SUBMITTED',array('QUOTE' => (nl2br(htmlspecialchars($_POST['rash_quote'])) . "\n"))); + if (!isLoggedIn()) + { + $insquote = "INSERT INTO rash_queue (quote) VALUES(\"" . addslashes(htmlspecialchars($_POST['rash_quote'])) . "\")"; + } else { + $today = mktime(date('G'),date('i'),date('s'),date('m'),date('d'),date('Y')); + $insquote = "INSERT INTO rash_quotes (quote, rating, flag, date) VALUES (\"" . addslashes($_POST['rash_quote']) . "\", 0, 0, \"" . $today . "\")"; + } + $insquote2 = mysql_query($insquote); + } + $template->display(); +} elseif ($_GET['act'] == 'bottom') +{ + $query = "SELECT id, quote, rating, flag FROM rash_quotes WHERE rating < 0 ORDER BY rating ASC LIMIT 50"; + quote_generation($query, "Bottom", -1); +} elseif ($_GET['act'] == 'browse') +{ + $query = "SELECT id, quote, rating, flag FROM rash_quotes ORDER BY id ASC "; + quote_generation($query, "Browse", (isset($_GET['page']) ? $_GET['page'] : 1), 10, 5); +} elseif ($_GET['act'] == 'flag') +{ + $template = new FITemplate('msg'); + $tracking_verdict = user_quote_status('flag', $quote_num, $template); + if ($tracking_verdict < 3) + { + $getfla = "SELECT flag FROM rash_quotes WHERE id = " . $quote_num . " LIMIT 0,1"; + $getfla2 = mysql_query($getfla); + $getfla3 = mysql_fetch_array($getfla2); + + if ($getfla3['flag'] == 2) + { + $template->add('MSG',"This quote has been flagged and rechecked by a moderator already."); + } elseif ($getfla3['flag'] == 1) + { + $template->add('MSG',"This quote is currently pending deletion."); + } else { + $template->add('MSG',"You have marked this quote for deletion."); + $setfla = "UPDATE rash_quotes SET flag = 1 WHERE id = " . $quote_num; + $setfla2 = mysql_query($setfla); + } + } + $template->add('BACK','Quote #' . $quote_num); + $template->display(); +} elseif ($_GET['act'] == 'latest') +{ + $query = "SELECT id, quote, rating, flag FROM rash_quotes ORDER BY id DESC LIMIT 50"; + quote_generation($query, "Latest", -1); +} elseif ($_GET['act'] == 'random') +{ + $query = "SELECT id, quote, rating, flag FROM rash_quotes ORDER BY rand() LIMIT 50"; + quote_generation($query, "Random", -1); +} elseif ($_GET['act'] == 'random2') +{ + $query = "SELECT id, quote, rating, flag FROM rash_quotes WHERE rating > 1 ORDER BY rand() LIMIT 50"; + quote_generation($query, "Random2", -1); +} elseif ($_GET['act'] == 'search') +{ + if (isset($_GET['fetch'])) + { + if ($_POST['sortby'] == 'rating') + { + $how = 'desc'; + } else { + $how = 'asc'; + } + $getquotes = "SELECT id, quote, rating, flag FROM rash_quotes WHERE quote LIKE \"%" . $_POST['search'] . "%\" ORDER BY " . $_POST['sortby'] . " " . $how . " LIMIT 0," . $_POST['number']; + quote_generation($getquotes, "Query Results", -1); + } + $template = new FITemplate('quotes/search'); + $template->display(); +} elseif ($_GET['act'] == 'top') +{ + $query = "SELECT id, quote, rating, flag FROM rash_quotes WHERE rating > 0 ORDER BY rating DESC LIMIT 50"; + quote_generation($query, "Top", -1); +} elseif ($_GET['act'] == 'vote') +{ + $template = new FITemplate('msg'); + $tracking_verdict = user_quote_status('vote', $quote_num,$template); + $template->add('BACK','Quote #' . $quote_num); + $template->display(); + if ($tracking_verdict < 3) + { + if ($_GET['dir'] == "plus") + { + $setquote = "UPDATE rash_quotes SET rating = rating+1 WHERE id = " . $quote_num; + $setquote2 = mysql_query($setquote); + } elseif($_GET['dir'] == "minus") + { + $setquote = "UPDATE rash_quotes SET rating = rating-1 WHERE id = " . $quote_num; + $setquote2 = mysql_query($setquote); + } + } +} else { + if ((is_int($_GET['act']) || ($_GET['act'] != false)) && (verify_int($_GET['act']))) + { + $query = "SELECT id, quote, rating, flag FROM rash_quotes WHERE id = " . $_GET['act']; + quote_generation($query, "#" . $_GET['act'], -1); + $page_id = 'quote-' . $_GET['act']; + } else { + $template = new FITemplate('post'); + $template->adds_block('INTERNAL',array('exi'=>1)); + + $getpost = "SELECT * FROM updates WHERE tag1 = \"quotes\" OR tag2 = \"tag2\" OR tag3 = \"tag3\" ORDER BY id DESC LIMIT 0,1"; + $getpost2 = mysql_query($getpost); + $getpost3 = mysql_fetch_array($getpost2); + + $title = $getpost3['title'] . ' - Blog Archive'; + + $template->adds_block('POST', array( 'ID' => $getpost3['id'], + 'YEARID' => ((date('Y',strtotime($getpost3['pubDate']))-2006) % 4), + 'DATE' => date('F dS Y \a\\t g:i:s a',strtotime($getpost3['pubDate'])), + 'MONTH' => date('M',strtotime($getpost3['pubDate'])), + 'DAY' => date('d',strtotime($getpost3['pubDate'])), + 'CODED' => urlencode($getpost3['title']), + 'TITLE' => $getpost3['title'], + 'AUTHOR' => $getpost3['author'], + 'TAG1' => $getpost3['tag1'], + 'TAG2' => $getpost3['tag2'], + 'TAG3' => $getpost3['tag3'], + 'TEXT' => parseBBCode($getpost3['text']))); + + $template->display(); + $page_id = 'updates-' . $getpost3['id']; + } + include('includes/comments.php'); +} + +?> -- cgit 1.4.1