/**
* Tests the serialization of the Questions array first
* serializes and then it unserilizes and then checks
* to see if they are the same.
*
* @since 2.0
*/
public function testQuestionsSerializationBothways()
{
$question = array("text" => "Test Question", "section" => "Section One", "points" => "3", "difficulty" => "easy", "add_text" => "Fix this.", "type" => "question");
$serializedQuestion = array();
list($serializedQuestion['text'], $serializedQuestion['type'], $serializedQuestion['difficulty'], $serializedQuestion['section'], $serializedQuestion['meta']) = Wpsqt_System::serializeQuestion($question, $_GET['subsection'], 'quiz');
$unserializedQuestion = Wpsqt_System::unserializeQuestion($serializedQuestion, 'quiz');
$this->assertEquals($question, $unserializedQuestion, "Arrays don't match up.");
}
public function execute()
{
global $wpdb;
$wpdb->query("CREATE TABLE IF NOT EXISTS `" . WPSQT_TABLE_QUESTIONS . "` (\n\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `name` varchar(255) NOT NULL,\n\t\t\t\t\t `type` varchar(255) NOT NULL,\n\t\t\t\t\t `item_id` int(11) NOT NULL,\n\t\t\t\t\t `section_id` int(11) NOT NULL,\n\t\t\t\t\t `difficulty` varchar(255) NOT NULL,\n\t\t\t\t\t `meta` longtext NOT NULL,\n\t\t\t\t\t `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;\n\t\t");
$wpdb->query("CREATE TABLE IF NOT EXISTS `" . WPSQT_TABLE_RESULTS . "`(\n\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `item_id` int(11) NOT NULL,\n\t\t\t\t\t `timetaken` int(11) NOT NULL,\n\t\t\t\t\t `person` longtext NOT NULL,\n\t\t\t\t\t `sections` longtext NOT NULL,\n\t\t\t\t\t `person_name` varchar(255) NOT NULL,\n\t\t\t\t\t `ipaddress` varchar(255) NOT NULL,\n\t\t\t\t\t `timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\t\t `status` varchar(255) NOT NULL DEFAULT 'unviewed',\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;\n\t\t");
$wpdb->query("CREATE TABLE IF NOT EXISTS `" . WPSQT_TABLE_FORMS . "` (\n\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `item_id` int(11) NOT NULL,\n\t\t\t\t\t `name` varchar(255) NOT NULL,\n\t\t\t\t\t `type` varchar(255) NOT NULL,\n\t\t\t\t\t `required` varchar(255) NOT NULL,\n\t\t\t\t\t `validation` varchar(355) NOT NULL,\n\t\t\t\t\t `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;\n\t\t\t");
$wpdb->query("CREATE TABLE IF NOT EXISTS `" . WPSQT_TABLE_QUIZ_SURVEYS . "` (\n\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `name` varchar(255) NOT NULL,\n\t\t\t\t\t `settings` longtext NOT NULL,\n\t\t\t\t\t `type` varchar(266) NOT NULL,\n\t\t\t\t\t `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
$wpdb->query("CREATE TABLE IF NOT EXISTS `" . WPSQT_TABLE_SECTIONS . "` (\n\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `item_id` int(11) NOT NULL,\n\t\t\t\t\t `name` varchar(255) NOT NULL,\n\t\t\t\t\t `limit` varchar(255) NOT NULL,\n\t\t\t\t\t `order` varchar(11) NOT NULL,\n\t\t\t\t\t `difficulty` varchar(255) NOT NULL,\n\t\t\t\t\t `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\t\t UNIQUE KEY `id` (`id`)\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;\n\t\t");
$wpdb->query("CREATE TABLE IF NOT EXISTS `" . WPSQT_TABLE_SURVEY_CACHE . "` (\n\t\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t `sections` longtext NOT NULL,\n\t\t\t\t\t `total` int(11) NOT NULL,\n\t\t\t\t\t `item_id` int(11) NOT NULL,\n\t\t\t\t\t `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\t\t PRIMARY KEY (`id`)\n\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;\n\t\t");
$quizzes = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_quiz`", ARRAY_A);
foreach ($quizzes as $quiz) {
$sectionIds = array();
$quiz['display'] = $quiz['display_result'];
$quiz['finish_message'] = '';
$quizId = Wpsqt_System::insertItemDetails($quiz, 'quiz');
$questions = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_questions` WHERE quizid = " . $quiz['id'], ARRAY_A);
$sections = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_quiz_sections` WHERE quizid = " . $quiz['id'], ARRAY_A);
$results = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_results` WHERE quizid = " . $quiz['id'], ARRAY_A);
$forms = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_forms` WHERE quizid = " . $quiz['id'], ARRAY_A);
if (!empty($forms)) {
foreach ($forms as $form) {
Wpsqt_System::insertFormItem($quizId, $form['name'], $form['type'], $form['required'], 'none');
}
}
foreach ($sections as $section) {
// So we can relate the old sectionId with the new one.
$sectionIds[$section['id']] = Wpsqt_System::insertSection($quizId, $section['name'], $section['number'], $section['orderby'], $section['difficulty']);
}
foreach ($questions as $question) {
$question['name'] = $question['text'];
$question['section'] = $question['sectionid'];
unset($question['text']);
unset($question['sectionid']);
$sectionId = $sectionIds[$question['section']];
$answers = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_answer` WHERE questionid = " . $question['id'], ARRAY_A);
if (!empty($answers)) {
$question['answers'] = $answers;
}
list($questionText, $questionType, $questionDifficulty, $questionSection, $questionMeta) = Wpsqt_System::serializeQuestion($question, 'quiz');
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSQT_TABLE_QUESTIONS . "` \n\t\t\t\t\t\t\t\t\t(name,type,item_id,section_id,difficulty,meta) \n\t\t\t\t\t\t\t\t\tVALUES (%s,%s,%d,%d,%s,%s)", array($questionText, $questionType, $quizId, $sectionId, $questionDifficulty, $questionMeta)));
}
foreach ($results as $result) {
$sections = unserialize($result['sections']);
foreach ($sections as &$section) {
foreach ($section['questions'] as $key => &$value) {
$value['name'] = $value['text'];
unset($value['text']);
}
}
$result['sections'] = serialize($sections);
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSQT_TABLE_RESULTS . "` (timetaken,person,sections,item_id,person_name,ipaddress,status) \n\t\t\t\t\t\t\t\t\tVALUES (%d,%s,%s,%d,%s,%s,%s)", array($result['timetaken'], $result['person'], $result['sections'], $quizId, $result['person_name'], $result['ipaddress'], $result['status'])));
}
}
$surveys = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_survey`", ARRAY_A);
foreach ($surveys as $survey) {
$sectionIds = array();
$surveyId = Wpsqt_System::insertItemDetails($survey, 'survey');
$questions = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_survey_questions` WHERE surveyid = " . $survey['id'], ARRAY_A);
$sections = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_survey_sections` WHERE surveyid = " . $survey['id'], ARRAY_A);
$results = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_survey_single_results` WHERE surveyid = " . $survey['id'], ARRAY_A);
$forms = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_forms` WHERE surveyid = " . $survey['id'], ARRAY_A);
if (!empty($forms)) {
foreach ($forms as $form) {
Wpsqt_System::insertFormItem($surveyId, $form['name'], $form['type'], $form['required'], 'none');
}
}
foreach ($sections as $section) {
// So we can relate the old sectionId with the new one.
$sectionIds[$section['id']] = Wpsqt_System::insertSection($surveyId, $section['name'], $section['number'], $section['orderby'], false);
}
foreach ($questions as $question) {
$question['name'] = $question['text'];
$question['section'] = $question['sectionid'];
unset($question['text']);
unset($question['sectionid']);
$sectionId = $sectionIds[$question['section']];
$answers = $wpdb->get_results("SELECT * FROM `" . $wpdb->get_blog_prefix() . "wpsqt_survey_questions_answers` WHERE questionid = " . $question['id'], ARRAY_A);
if (!empty($answers)) {
$question['answers'] = $answers;
}
$question['difficulty'] = false;
list($questionText, $questionType, $questionDifficulty, $questionSection, $questionMeta) = Wpsqt_System::serializeQuestion($question, 'survey');
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSQT_TABLE_QUESTIONS . "` \n\t\t\t\t\t\t\t\t\t(name,type,item_id,section_id,difficulty,meta) \n\t\t\t\t\t\t\t\t\tVALUES (%s,%s,%d,%d,%s,%s)", array($questionText, ucfirst($questionType), $surveyId, $sectionId, $questionDifficulty, $questionMeta)));
}
$cachedSections = array();
foreach ($results as $result) {
$sections = unserialize($result['results']);
foreach ($sections as $sectionKey => &$section) {
$section['answers'] = array();
foreach ($section['questions'] as $key => &$value) {
$questionId = $value['id'];
$value['name'] = $value['text'];
$section['answers'][$questionId]['given'] = array($value['answer']);
$value['type'] = ucfirst($value['type']);
if ($value['type'] == 'Multiple') {
$value['type'] = 'Multiple Choice';
}
unset($value['text']);
}
if (!array_key_exists($sectionKey, $cachedSections)) {
$cachedSections[$sectionKey] = array();
$cachedSections[$sectionKey]['questions'] = array();
}
foreach ($section['questions'] as $questionKey => $question) {
$questionId = $question['id'];
if (!array_key_exists($question['id'], $cachedSections[$sectionKey]['questions'])) {
$cachedSections[$sectionKey]['questions'][$questionId] = array();
$cachedSections[$sectionKey]['questions'][$questionId]['name'] = $question['name'];
$cachedSections[$sectionKey]['questions'][$questionId]['type'] = $question['type'];
$cachedSections[$sectionKey]['questions'][$questionId]['answers'] = array();
}
if ($cachedSections[$sectionKey]['questions'][$questionId]['type'] == "Multiple Choice" || $cachedSections[$sectionKey]['questions'][$questionId]['type'] == "Dropdown") {
if (empty($cachedSections[$sectionKey]['questions'][$questionId]['answers'])) {
foreach ($question['answers'] as $answerKey => $answers) {
$answerId = $answers['id'];
$cachedSections[$sectionKey]['questions'][$questionId]['answers'][$answerId] = array("text" => $answers['text'], "count" => 0);
}
}
} elseif ($cachedSections[$sectionKey]['questions'][$questionId]['type'] == "Likert" || $cachedSections[$sectionKey]['questions'][$questionId]['type'] == "Scale") {
if (empty($cachedSections[$sectionKey]['questions'][$questionId]['answers'])) {
for ($i = 0; $i < 10; ++$i) {
$cachedSections[$sectionKey]['questions'][$questionId]['answers'][$i] = array('count' => 0);
}
}
} elseif ($cachedSections[$sectionKey]['questions'][$questionId]['type'] == "Free Text") {
if (empty($cachedSections[$sectionKey]['questions'][$questionId]['answers'])) {
$cachedSections[$sectionKey]['questions'][$questionId]['answers'] = 'None Cached - Free Text Result';
}
continue;
} else {
if (empty($cachedSections[$sectionKey]['questions'][$questionId]['answers'])) {
$cachedSections[$sectionKey]['questions'][$questionId]['answers'] = 'None Cached - Not a default question type.';
}
continue;
}
$givenAnswer = (int) current($section['answers'][$questionId]['given']);
$cachedSections[$sectionKey]['questions'][$questionId]['answers'][$givenAnswer]["count"]++;
}
}
$result['results'] = serialize($sections);
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSQT_TABLE_RESULTS . "` (timetaken,person,sections,item_id,person_name,ipaddress,status) \n\t\t\t\t\t\t\t\t\tVALUES (%d,%s,%s,%d,%s,%s,%s)", array(0, $result['person'], $result['results'], $surveyId, $result['name'], $result['ipaddress'], 'unviewed')));
}
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSQT_TABLE_SURVEY_CACHE . "` (sections,item_id) VALUES (%s,%d)", array(serialize($cachedSections), $surveyId)));
}
}
/**
* (non-PHPdoc)
* @see Wpsqt_Page::process()
*/
public function process()
{
global $wpdb;
if ($this->_type == "survey") {
$questionTypes = Wpsqt_System::getSurveyQuestionTypes();
} else {
if ($this->_type == "poll") {
$questionTypes = Wpsqt_System::getPollQuestionTypes();
} else {
$questionTypes = Wpsqt_System::getQuizQuestionTypes();
}
}
$rawSections = Wpsqt_System::fetchSections($_GET['id']);
$sections = array();
foreach ($rawSections as $section) {
if ($section['name'] !== false) {
$sections[] = $section['name'];
if (isset($this->_question['wpsqt_section_id']) && $section['id'] == $this->_question['wpsqt_section_id']) {
$this->_question['wpsqt_section'] = $section['name'];
}
}
}
$this->_pageVars['objForm'] = new Wpsqt_Form_Question($questionTypes, $sections);
$this->_pageVars['objForm']->setValues($this->_question);
$this->_pageVars['sections'] = $sections;
$this->_pageVars['subForm'] = "";
$questionObjects = array();
foreach ($questionTypes as $type => $description) {
$objQuestion = Wpsqt_Question::getObject($type);
$questionObjects[$type] = $objQuestion;
$this->_pageVars['subForm'] .= $objQuestion->processValues($this->_question)->form();
}
if ($this->_type == "poll") {
$this->_pageView = "admin/questions/pollform.php";
} else {
$this->_pageView = "admin/questions/form.php";
}
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$this->_pageVars['errorArray'] = $this->_pageVars['objForm']->getMessages($_POST);
$question = array();
foreach ($questionObjects as $type => $objQuestion) {
if ($type != $_POST['wpsqt_type']) {
continue;
}
$result = $objQuestion->processForm($_POST);
if (!is_array($result)) {
continue;
}
$question[$result['name']] = $result['content'];
$this->_pageVars['errorArray'] = array_merge($this->_pageVars['errorArray'], $result['errors']);
}
if (!empty($this->_pageVars['errorArray'])) {
return;
}
foreach ($_POST as $key => $value) {
$question[str_ireplace("wpsqt_", "", $key)] = $value;
}
list($questionText, $questionType, $questionDifficulty, $questionSection, $questionMeta) = Wpsqt_System::serializeQuestion($question, $_GET['subsection']);
foreach ($rawSections as $section) {
if ($section['name'] == $_POST['wpsqt_section']) {
$sectionId = $section['id'];
break;
}
}
if ($this->_action == "add") {
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSQT_TABLE_QUESTIONS . "` \n\t\t\t\t\t\t\t\t\t(name,type,item_id,section_id,difficulty,meta) \n\t\t\t\t\t\t\t\t\tVALUES (%s,%s,%d,%d,%s,%s)", array($questionText, $questionType, $_GET['id'], $sectionId, $questionDifficulty, $questionMeta)));
$this->_pageVars['redirectLocation'] = WPSQT_URL_MAIN . "§ion=questions&subsection=" . strtolower($_GET['subsection']) . "&id=" . $_GET['id'] . "&new=true";
} else {
$wpdb->query($wpdb->prepare("UPDATE `" . WPSQT_TABLE_QUESTIONS . "` SET\n\t\t\t\t\t\t\t\t\tname = %s, type = %s,section_id = %d,\n\t\t\t\t\t\t\t\t\tdifficulty = %s,meta = %s WHERE id = %d", array($questionText, $questionType, $sectionId, $questionDifficulty, $questionMeta, $_GET['questionid'])));
$this->_pageVars['redirectLocation'] = WPSQT_URL_MAIN . "§ion=questions&subsection=" . strtolower($_GET['subsection']) . "&id=" . $_GET['id'] . "&edit=true";
}
$this->_pageView = "admin/misc/redirect.php";
}
}
