From b5736e3ad3830fa732dcbd1a518ec3dd6ea7b98a Mon Sep 17 00:00:00 2001 From: Starla Insigna Date: Thu, 13 Aug 2009 17:46:09 -0400 Subject: Rewrote Admin panel The following database changes must be made: * A TEXT column called "text" must be added to the end of "polloftheweek" * The transferPollRss.php script must be run * The "pollrss" table must be dropped Closes #113 --- admin/editQuote.php | 69 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 69 insertions(+) create mode 100644 admin/editQuote.php (limited to 'admin/editQuote.php') diff --git a/admin/editQuote.php b/admin/editQuote.php new file mode 100644 index 0000000..b250ece --- /dev/null +++ b/admin/editQuote.php @@ -0,0 +1,69 @@ +add('TITLE', 'Edit Quote'); +$template->add('ACTION', '/admin/editQuote.php?id=' . $_GET['id'] . '&submit='); + +if (isset($_GET['submit'])) +{ + if (isset($errors)) + { + $template->adds_block('ISERROR',array('exi'=>1)); + + $eid = 0; + foreach ($errors as $error) + { + $template->adds_block('ERROR', array( 'ID' => $eid, + 'TEXT' => $error['text'])); + $template->add('IS' . strtoupper($error['field']) . 'ERROR', ' error'); + $template->adds_block(strtoupper($error['field']) . 'ERROR', array( 'ID' => $eid, + 'TEXT' => $error['text'])); + + $eid++; + } + + $template->add('QUOTEVALUE', $_POST['quote']); + } else { + $insquote = "UPDATE rash_quotes SET quote = \"" . mysql_real_escape_string($_POST['quote']) . "\" WHERE id = " . $_GET['id']; + $insquote2 = mysql_query($insquote); + + $template->add('QUOTEVALUE', $_POST['quote']); + + $template->adds_block('FLASH', array('TEXT' => 'Your quote has been sucessfully edited. View quote.')); + } +} else { + $getquote = "SELECT * FROM rash_quotes WHERE id = " . $_GET['id']; + $getquote2 = mysql_query($getquote); + $getquote3 = mysql_fetch_array($getquote2); + + $template->add('QUOTEVALUE', $getquote3['quote']); +} + +$template->display(); + +?> -- cgit 1.4.1