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/newPoll.php | 104 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 104 insertions(+) create mode 100644 admin/newPoll.php (limited to 'admin/newPoll.php') diff --git a/admin/newPoll.php b/admin/newPoll.php new file mode 100644 index 0000000..0373980 --- /dev/null +++ b/admin/newPoll.php @@ -0,0 +1,104 @@ + 'question', + 'text' => 'Question is a required field'); + } + + if (empty($_POST['option1'])) + { + $errors[] = array( 'field' => 'option1', + 'text' => 'Option 1 is a required field'); + } + + if (empty($_POST['option2'])) + { + $errors[] = array( 'field' => 'option2', + 'text' => 'Option 2 is a required field'); + } + + if (empty($_POST['option3'])) + { + $errors[] = array( 'field' => 'option3', + 'text' => 'Option 3 is a required field'); + } + + if (empty($_POST['option4'])) + { + $errors[] = array( 'field' => 'option4', + 'text' => 'Option 4 is a required field'); + } + + 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('TITLE', 'New Poll'); + $template->add('ACTION', '/admin/newPoll.php?submit='); + } else { + $inspoll = "INSERT INTO polloftheweek (question,option1,option2,option3,option4,text) VALUES (\"" . mysql_real_escape_string($_POST['question']) . "\",\"" . mysql_real_escape_string($_POST['option1']) . "\",\"" . mysql_real_escape_string($_POST['option2']) . "\",\"" . mysql_real_escape_string($_POST['option3']) . "\",\"" . mysql_real_escape_string($_POST['option4']) . "\",\"" . mysql_real_escape_string($_POST['text']) . "\")"; + $inspoll2 = mysql_query($inspoll); + + $id = mysql_insert_id(); + + $template->add('QUESTIONVALUE', $_POST['question']); + $template->add('OPTION1VALUE', $_POST['option1']); + $template->add('OPTION2VALUE', $_POST['option2']); + $template->add('OPTION3VALUE', $_POST['option3']); + $template->add('OPTION4VALUE', $_POST['option4']); + $template->add('TEXTVALUE', $_POST['text']); + + $template->add('TITLE', 'Edit Poll'); + $template->add('ACTION', '/admin/editPoll.php?id=' . $id . '&submit='); + $template->adds_block('FLASH', array('TEXT' => 'Your poll has been sucessfully created. View poll.')); + } +} else { + $template->add('TITLE', 'New Poll'); + $template->add('ACTION', '/admin/newPoll.php?submit='); +} + +$template->display(); + +?> -- cgit 1.4.1