rendered paste body<?phprequire_once('global/_top.php');$listFile = THIS_PAGE;check_access_page('Activities/Modules');check_access_page('Translate Zips');if(isset($_REQUEST['doThis']) && $_REQUEST['doThis']!='') $action=$_REQUEST['doThis'];else $action='list';if(isset($_REQUEST['moduleID']) && $_REQUEST['moduleID']!='' && is_numeric($_REQUEST['moduleID'])) { $zipID = $_REQUEST['moduleID']; //echo("Setting quizID to '$zipID'"); }if(isset($_REQUEST['questionID']) && $_REQUEST['questionID']!='' && is_numeric($_REQUEST['questionID'])){ $questionID = $_REQUEST['questionID']; //die($questionID);} else {$questionID = "new";}if($questionID == "new" && !isset($zipID)){ die("Don't know where to save!"); //die("The quiz ID should be ".$zipID.".");}switch ($action) { case 'edit' : edit($questionID); break; case 'save' : save($questionID); break; case 'delete' : delete($questionID); break; case 'list' : listQuestions($zipID); break; default : listQuestions($zipID); break;}function edit($questionID) {global $db; /* echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=fillword">New Fill In Word</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=fillphrase">New Fill In Phrase</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=typeword">New f In Word</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=typephrase">New Type In Phrase</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=arrange">New Arrange</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterword">New Word Scatter</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterpicture">New Picture Scatter</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=spaceout">New Space Out</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=listen">New Listen</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterphrase">New Phrase Scatter</a><br> '; */ $questiontype = $_GET['question_type']; $modulid = $_GET['moduleID']; //function select_all($fields, $tables, $conditions = null, $order = null $words = $db->select_all( array( 'content_items.id' => 'wordID', 'content_items.value' => 'word' ), array( 'content_items', 'content_groups' => array('content_groups.id' => 'content_items.group_id'), 'content_types' => array('content_types.id' => 'content_groups.content_type_id') ), array( 'content_groups.content_type_id' => $db->select('id', 'content_types', array('type_name' => 'word')), 'content_items.primary_locale_id' => $_SESSION['secondary_locale'] ) ); //die($questiontype); switch ($questiontype){ case 'fillin': case 'fillIn' : fillin($questionID, $words, $modulid); break; case 'typeIn' : typeIn($questionID, $words, $modulid); break; case 'arrange' : arrange($questionID, $words, $modulid); break; case 'scatterword' : scatterword($questionID, $words, $modulid); break; case 'scatterpicture' : scatterpicture($questionID, $words, $modulid); break; case 'spaceout': case 'spaceOut' : spaceout($questionID, $words, $modulid); break; case 'listen' : listen($questionID, $words, $modulid); break; case 'scatterphrase': case 'scatterPhrase': scatterphrase($questionID, $words, $modulid); break; default : echo 'Invalid Question Type: '.$questiontype.''; break; }}function save($questionID) { /* echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=fillword">New Fill In Word</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=fillphrase">New Fill In Phrase</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=typeword">New Type In Word</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=typephrase">New Type In Phrase</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=arrange">New Arrange</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterword">New Word Scatter</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterpicture">New Picture Scatter</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=spaceout">New Space Out</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=listen">New Listen</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterphrase">New Phrase Scatter</a><br> '; */echo '<pre>';print_r($_GET);echo '</pre>'; $questiontype = $_GET['question_type']; switch ($questiontype){ case 'fillin': case 'fillIn' : savefillin($questionID); break; case 'typeIn' : savetypeIn($questionID); break; case 'arrange' : savearrange($questionID); break; case 'scatterword' : savescatterword($questionID); break; case 'scatterpicture' : savescatterpicture($questionID); break; case 'spaceout': case 'spaceOut' : savespaceout($questionID); break; case 'listen' : savelisten($questionID); break; case 'scatterphrase': case 'scatterPhrase' : savescatterphrase($questionID); break; default : echo 'broke'; break; }}function delete($questionID){global $db; $table = 'module_elements'; //$conditions = array('id' => $_GET['questionID']); //$conditions['module_id'] = $quizID; $db->delete($table, array( 'module_id' => $_REQUEST['moduleID'], 'id' => $questionID ) ); header('location:'.THIS_PAGE.'?doThis=list&moduleID='.$_REQUEST['moduleID']);}function listQuestions($zipID) { //default action - lists the questions associated with this quiz //$zipID = 405; //debugging global $db; //$db->echo = true; $games = $db->select_all(array( 'game_type.type_name' => 'type', 'word_element.id' => 'wordID', 'module_group.sequence' => 'dir', 'answer_element.value' => 'correctAnswer', 'clue_element.value' => 'clueData', 'prompt_element.value' => 'prePop', 'audio.location' => 'audioFile', 'word_audio.location' => 'wordAudioFile', 'module_elements.id' => 'KE_value', ), array( 'module_elements', 'module_group' => array('on' => 'content_groups', 'module_group.id' => 'module_elements.content_group_id'), 'game_type' => array('on' => 'content_types', 'game_type.id' => 'module_group.content_type_id'), 'word_element' => array('on' => 'content_items', 'word_element.id' => 'module_elements.content_item_id'), 'word_audio' => array('on' => 'media_assets', 'word_audio.content_group_id' => 'word_element.group_id'), 'clue_rel' => array( 'on' => 'content_group_relationships', 'clue_rel.primary_group_id' => 'module_group.id', 'clue_rel.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue')), ), 'clue_group' => array('on' => 'content_groups', 'clue_group.id' => 'clue_rel.secondary_group_id'), 'clue_element' => array( 'on' => 'content_items', 'clue_element.group_id' => 'clue_group.id', 'clue_element.primary_locale_id' => 'module_elements.primary_locale_id', 'clue_element.secondary_locale_id' => 'module_elements.secondary_locale_id', 'clue_element.weave_level' => 'module_elements.weave_level', ), 'prompt_rel' => array( 'on' => 'content_group_relationships', 'prompt_rel.primary_group_id' => 'module_group.id', 'prompt_rel.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt')), ), 'prompt_group' => array('on' => 'content_groups', 'prompt_group.id' => 'prompt_rel.secondary_group_id'), 'prompt_element' => array( 'on' => 'content_items', 'prompt_element.group_id' => 'prompt_group.id', 'prompt_element.primary_locale_id' => 'module_elements.primary_locale_id', 'prompt_element.secondary_locale_id' => 'module_elements.secondary_locale_id', 'prompt_element.weave_level' => 'module_elements.weave_level', ), 'answer_rel' => array( 'on' => 'content_group_relationships', 'answer_rel.primary_group_id' => 'module_group.id', 'answer_rel.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer')), ), 'answer_group' => array('on' => 'content_groups', 'answer_group.id' => 'answer_rel.secondary_group_id'), 'answer_element' => array( 'on' => 'content_items', 'answer_element.group_id' => 'answer_group.id', 'answer_element.primary_locale_id' => 'module_elements.primary_locale_id', 'answer_element.secondary_locale_id' => 'module_elements.secondary_locale_id', 'answer_element.weave_level' => 'module_elements.weave_level', ), 'audio' => array('on' => 'media_assets', 'audio.content_group_id' => 'answer_group.id') ), array( 'module_elements.module_id' => $zipID, ), 'module_elements.sequence'); echo '<pre>'; print_r($games); echo '</pre>'; HEAD_Includes(); echo ' <h1>Questions for Translate Zip '.$zipID.'</h1>'; echo '<table class="moduleList" cellpadding="0" cellspacing="0"> <tr> <th>id</th> <th>Type</th> <th>PrePop</th> <th>Clue(if one exsists)</th> <th>Answer(s)</th> <th> </th> </tr>'; $fanfold = true; /* echo '<pre>'; print_r($questions); echo '</pre>'; */ //function count($fields, $tables, $conditions = null, $allow_deleted = false) { foreach($games AS $question) { if($fanfold){ $rowStyle="fanfold2"; $fanfold = !$fanfold; } else{ $fanfold=!$fanfold; $rowStyle="fanfold1"; } //function select($fields, $tables, $conditions = null, $allow_deleted = false, $group = null) { /* echo '<pre>'; print_r(get_answers($question)); echo '</pre>'; */ /* die(); */ switch ($question['type']) { case 'fillIn': $quest = $question['clueData']; $ans = $db->select( array( 'content_items.value' ), array( 'module_elements', 'content_items' => array('content_items.id' => 'module_elements.content_item_id') ), array( 'module_elements.module_id' => $zipID, 'content_items.id' => $question['wordID'] ) ); if (empty($ans['value'])) { $ans = $question['correctAnswer']; } else { $ans = implode(" ", $ans); } break; case 'arrange': $quest = $question['clueData']; $ans = $db->select( array( 'content_items.value' ), array( 'module_elements', 'content_items' => array('content_items.id' => 'module_elements.content_item_id') ), array( 'module_elements.module_id' => $zipID, 'content_items.id' => $question['wordID'] ) ); $ans = implode(" ", $ans); break; case 'typeIn': $quest = $question['clueData']; $ans = $db->select( array( 'content_items.value' ), array( 'module_elements', 'content_items' => array('content_items.id' => 'module_elements.content_item_id') ), array( 'module_elements.module_id' => $zipID, 'content_items.id' => $question['wordID'] ) ); if (empty($ans['value'])) { $ans = $question['correctAnswer']; } else { $ans = implode(" ", $ans); } break; case 'spaceOut': $quest = $question['clueData']; $ans = $question['correctAnswer']; break; case 'scatterWords': $quest = 'No Clue'; $qex = explode(",", $question['prePop']); $ans = array(); for ($i = 0; $i < count($qex); $i++) { $ans[$i] = $db->select( array( 'content_items.value' ), array( 'module_elements', 'content_items' => array('content_items.id' => 'module_elements.content_item_id') ), array( 'module_elements.module_id' => $zipID, 'content_items.id' => $qex[$i] ) ); } $ans = implode(", ", $ans[0]); break; case 'scatterPhrase': $index = $db->select( 'answer.value', array( 'module_elements', 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'module_elements.content_group_id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('relationship_types.type_name' => 'correct answer')) ), 'answer' => array('on' => 'content_items', 'answer.group_id' => 'content_group_relationships.secondary_group_id') ), array( 'module_elements.id' => $question['KE_value'] ) ); $quest = $question['clueData']; $qex = explode(":::", $question['prePop']); $prompt = implode(", ", $qex); $ans = $qex[$index]; break; default: die('Broken'); break; } if (isset($prompt)){ $preprompt = $prompt; } elseif (!empty($question['prePop'])){ $preprompt = $question['prePop']; } else { $preprompt = 'none'; } echo '<pre>'; print_r($preprompt); echo '</pre>'; echo ' <tr> <td class="'.$rowStyle.' smallGray">'.$question['KE_value'].'</td> <td class="'.$rowStyle.' smallGray">'.$question['type'].'</td> <td class="'.$rowStyle.'">'.$preprompt.'</td> <td class="'.$rowStyle.'"><a href="'.THIS_PAGE.'?doThis=edit&questionID='.$question['KE_value'].'&question_type='.$question['type'].'&moduleID='.$zipID.'">'.(!empty($quest)?$quest:'none').'</a></td> <td class="'.$rowStyle.'">'.$ans.'</td> <td class="'.$rowStyle.'"><a href="'.THIS_PAGE.'?doThis=edit&questionID='.$question['KE_value'].'&question_type='.$question['type'].'&moduleID='.$zipID.'"><img src="'.ROOT_PATH.'images/i_sm_edit.gif"></a> <a href="'.THIS_PAGE.'?doThis=delete&questionID='.$question['KE_value'].'&moduleID='.$zipID.'" onclick="return confirm(\'Are you sure you want to delete this question?\')"><img src="'.ROOT_PATH.'images/i_sm_del.gif"></a> </td> </tr>'; } echo '<pre>'; echo '</pre>'; echo '</table>'; /* echo '<pre>'; print_r($zipID); echo '</pre>'; TypeIn word TypeIn Phrase FillIn Word Arrange Scatter words Scatter Pictures FillIn Phrase Space Out Listen Scatter Phrase */ echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=fillin">New Fill In</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=typeIn">New Type In</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=arrange">New Arrange(Not Working)</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterpicture">New Picture Scatter(Not Working)</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=spaceout">New Space Out</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=listen">New Listen(Not Working)</a><br> '; echo '<a href="'.THIS_PAGE.'?doThis=edit&moduleID='.$zipID.'&question_type=scatterphrase">New Phrase Scatter(Not Working)</a><br> '; HTML_Footer();}function get_questions($moduleID = null, $questionID = null) { global $db; //$db->echo = true; $conditions = array('content_types.type_name'=>array('typeIn', 'fillIn', 'arrange', 'spaceOut', 'listen', 'scatterWords', 'scatterPictures', 'scatterPhrase')); if ($moduleID != null) $conditions['module_elements.module_id'] = $moduleID; if ($questionID != null) $conditions['module_elements.id'] = $questionID; $questions = $db->select_all( array( 'content_groups.id' => 'groupID', 'module_elements.id' =>'element_id', 'module_elements.sequence', 'module_elements.module_id', 'content_items.value'=>'question', 'content_types.type_name'=>'question_type' ), array( 'module_elements', 'content_groups' => array('content_groups.id'=>'module_elements.content_group_id'), 'content_types' => array('content_types.id'=>'content_groups.content_type_id'), 'content_items' => array('content_items.group_id'=>'content_groups.id') ), $conditions ); foreach($questions as $question) { $questionData = get_answers($question); } return $questionData;}function get_answers($question) { global $db; //$db->echo = true; $answerData = array(); switch($question['question_type']) { case 'multiple-choice question' : //$db->echo=true; $question['answers'] = $db->select_all( array(//fields 'answerGroup.id', 'answerGroup.sequence', 'content_items.value'=>'answer', 'relationship_types.type_name'=>'value' ), array(//tables 'content_groups', 'content_group_relationships' => array('content_group_relationships.primary_group_id'=>'content_groups.id'), 'answerGroup' => array('on'=>'content_groups','answerGroup.id'=>'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id'=>'answerGroup.id'), 'content_types' => array('content_types.id'=>'answerGroup.content_type_id'), 'relationship_types' => array('relationship_types.id'=>'content_group_relationships.relationship_type_id') ), array(//conditions 'content_group_relationships.primary_group_id'=>$question['groupID'], 'content_types.type_name'=>"question answer", 'content_items.primary_locale_id' => $_SESSION['primary_locale'], 'content_items.secondary_locale_id' => $_SESSION['secondary_locale'] ), //order array('sequence','id') ); //die(print_r($question)); break; case 'true/false question' : //return the options True/false, with correct status //$db->echo=true; $answerData = $db->select( //$fields 'property_options.value', array(//$tables 'content_group_properties', 'property_options' => array('property_options.id' => 'content_group_properties.property_id') ), array(//$conditions = null 'content_group_properties.item_id' => $question['groupID'] ) );//select only the correct response $question['answers'] = array(0=>array('value' => $answerData)); break; case 'short-answer question' : //select and return only the correct response// default : //echo '<div class="blueText">DEFAULT was selected in get_answers</div>'; $question['answers'] = $db->select_all( array(//$fields 'answerGroup.id' => 'answerGroup_id', 'answerGroup.sequence', //'questionGroup.id' => 'questionGroup_id', //'questionItem.value' => 'question', 'content_items.value' => 'answer', 'relationship_types.type_name' => 'value' ), array(//$tables 'questionGroup' => 'content_groups', 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'questionGroup.id'), 'answerGroup' => array('on'=>'content_groups','answerGroup.id'=>'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id'=>'answerGroup.id'), 'content_types' => array('content_types.id'=>'answerGroup.content_type_id'), 'relationship_types' => array('relationship_types.id'=>'content_group_relationships.relationship_type_id') ), array(//$conditions = null 'content_group_relationships.primary_group_id'=>$question['groupID'], 'content_types.type_name'=>"question answer", 'content_items.primary_locale_id' => $_SESSION['primary_locale'], 'content_items.secondary_locale_id' => $_SESSION['secondary_locale'] ) ); break; default: $question['answers'] = 'undefined'; break; } return $question;}function fillin($questionID, $wordlist, $modulid){global $db; //die('I will now end so that I dont create to many things'); echo '<pre>'; print_r($questionID); echo '</pre>'; $db->echo=true; //Todo: finish ME $questiondata = $db->select( array( 'answer_item.value' => 'answer', 'clue_item.value' => 'clue', 'prepop_item.value' => 'prepop', 'word_item.value' => 'word', 'module_group.sequence' => 'dir' ), array( 'module_elements', 'word_item' => array('on' => 'content_items', 'word_item.id' => 'module_elements.content_item_id'), 'module_group' => array('on' => 'content_groups', 'module_group.id' => 'module_elements.content_group_id'), 'answer_relation' => array('on' => 'content_group_relationships', 'answer_relation.primary_group_id' => 'module_group.id', 'answer_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer'))), 'answer_group' => array('on' => 'content_groups', 'answer_group.id' => 'answer_relation.secondary_group_id'), 'answer_item' => array('on' => 'content_items', 'answer_item.group_id' => 'answer_group.id'), 'clue_relation' => array('on' => 'content_group_relationships', 'clue_relation.primary_group_id' => 'module_group.id', 'clue_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'clue_group' => array('on' => 'content_groups', 'clue_group.id' => 'clue_relation.secondary_group_id'), 'clue_item' => array('on' => 'content_items', 'clue_item.group_id' => 'clue_group.id'), 'prepop_relation' => array('on' => 'content_group_relationships', 'prepop_relation.primary_group_id' => 'module_group.id', 'prepop_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt'))), 'prepop_group' => array('on' => 'content_groups', 'prepop_group.id' => 'prepop_relation.secondary_group_id'), 'prepop_item' => array('on' => 'content_items', 'prepop_item.group_id' => 'prepop_group.id'), ), array( 'module_elements.id' => $questionID ) ); echo '<pre>'; print_r($questiondata); echo '</pre>'; echo '<h2>Fill Word</h2>'; echo '<form name="fillword" method="post" action="'.THIS_PAGE.'?doThis=save&moduleID='.$modulid.'&question_type='.$_GET['question_type'].'">'; echo' <input type="hidden" name="doThis" value="save"> <input type="hidden" name="questionID" value="'.$questionID.'"> <input type="hidden" name="question_type" value="fillin"> <input type="radio" name="dir" value="0" '.(($questiondata['dir'] == 0)?'checked=checked':'').'>'.$_SESSION['primary_locale_name'].' to '.$_SESSION['secondary_locale_name'].' <br> <input type="radio" name="dir" value="1" '.(($questiondata['dir'] == 1)?'checked=checked':'').'>'.$_SESSION['secondary_locale_name'].' to '.$_SESSION['primary_locale_name'].' <p class="instructions">Instructions: Write your Clue in the box below and the answer in the field labeled Answer. The student will be asked to fill in a word.</p>'; echo '<h3>Prompt: </h3> <input type="text" name="prepop" value="'; if (!empty($questiondata['prepop'])){ echo $questiondata['prepop']; } echo '">'; echo '<h3>Clue: </h3> <input type="text" name="question" value="'; if (!empty($questiondata['clue'])){ echo $questiondata['clue']; } echo '">'; echo '<h3>Answer:</h3> <input type="text" name="answer" value="'; if (!empty($questiondata['answer'])){ echo $questiondata['answer']; }else{ if (!empty($questiondata['word'])) { echo $questiondata['word']; } } echo '"><br /><br /></sel ect><input type="submit" name="submitMC" value="Save Question and Answers"> <input type="hidden" name="module_id" value="'.$_GET['moduleID'].'"> </form>';}function savefillin($questionID){ global $db; echo 'I am Now on Fillword with the following to work with <br /><br />'; echo 'POST = '; echo '<pre>'; print_r($_POST); echo '</pre>'; echo '<br />'; echo 'GET = '; echo '<pre>'; print_r($_GET); echo '</pre>'; echo '<br />'; echo 'QuestionID = '; echo '<pre>'; print_r($questionID); echo '</pre>'; echo '<br />'; $db->echo=true; if ($questionID == 'new'){ //A fill in word first needs a Group $element_group_id = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'fillIn')), 'sequence' => $_POST['dir'] ) ); //Lets create a module element! WOO $element_id = $db->insert('module_elements', array( 'module_id' => $_POST['module_id'], 'content_group_id' => $element_group_id, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'] ) ); //Fillin Phrase Elements //CorrectAnswer -> content_group_relationship -> Content_Group -> Content_items //clueData -> content_group_relationship -> content_group -> content_items //prePop -> content_group_relationships -> content_group -> content_items //correctAnswer //answer_group $answer_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'question answer')) ) ); //answer_item $answer_item = $db->insert( 'content_items', array( 'group_id' => $answer_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['answer'] ) ); //answer_relation $answer_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $answer_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer')) ) ); //clueData //clue_group $clue_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'clue')) ) ); //clue_item $clue_item = $db->insert( 'content_items', array( 'group_id' => $clue_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['question'] ) ); //clue_relation $clue_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $clue_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue')) ) ); //prePop //prePop_group $prePop_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'prompt')) ) ); //prePop_item $prePop_item = $db->insert( 'content_items', array( 'group_id' => $prePop_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['prepop'] ) ); //clue_relation $prePop_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $prePop_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt')) ) ); } else { //TODO SELECT SOMETHIAGN $element_group_id = $db->select('content_groups.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id') ), array( 'module_elements.id' => $questionID ) ); $db->update( array( 'content_groups' ), array( 'content_groups.sequence' => $_POST['dir'] ), array( 'content_groups.id' => $element_group_id ) ); $answer_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); if (!$answer_id){ $answer_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'question answer')) ) ); //answer_item $answer_item = $db->insert( 'content_items', array( 'group_id' => $answer_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['answer'] ) ); //answer_relation $answer_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $answer_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer')) ) ); } else { $answer_item = $db->save( array( 'content_items' ), array( 'value' => $_POST['answer'] ), array( 'id' => $answer_id ) ); } $clue_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); if (!$clue_id) { //clueData //clue_group $clue_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'clue')) ) ); //clue_item $clue_item = $db->insert( 'content_items', array( 'group_id' => $clue_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['question'] ) ); //clue_relation $clue_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $clue_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue')) ) ); } else { //clue_item $clue_item = $db->save( 'content_items', array( 'value' => $_POST['question'] ), array( 'id' => $clue_id ) ); } //prePop //prePop_group $prepop_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); if (!$prepop_id) { //prePop_group $prePop_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'prompt')) ) ); //prePop_item $prePop_item = $db->insert( 'content_items', array( 'group_id' => $prePop_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['prepop'] ) ); //clue_relation $prePop_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $prePop_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt')) ) ); } else{ //prePop_item $prePop_item = $db->save( 'content_items', array( 'value' => $_POST['prepop'] ), array( 'id' => $prepop_id ) ); } //function update($table, $updates, $conditions) { $db->update('module_elements', array( 'content_item_id' => NULL ), array( 'id' => $questionID ) ); } }function typeIn($questionID, $wordlist, $modulid){global $db; //die('I will now end so that I dont create to many things'); echo '<pre>'; print_r($questionID); echo '</pre>'; $db->echo=true; //Todo: finish ME $questiondata = $db->select( array( 'answer_item.value' => 'answer', 'clue_item.value' => 'clue', 'word_item.value' => 'word', 'module_group.sequence' => 'dir' ), array( 'module_elements', 'word_item' => array('on' => 'content_items', 'word_item.id' => 'module_elements.content_item_id'), 'module_group' => array('on' => 'content_groups', 'module_group.id' => 'module_elements.content_group_id'), 'answer_relation' => array('on' => 'content_group_relationships', 'answer_relation.primary_group_id' => 'module_group.id', 'answer_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer'))), 'answer_group' => array('on' => 'content_groups', 'answer_group.id' => 'answer_relation.secondary_group_id'), 'answer_item' => array('on' => 'content_items', 'answer_item.group_id' => 'answer_group.id'), 'clue_relation' => array('on' => 'content_group_relationships', 'clue_relation.primary_group_id' => 'module_group.id', 'clue_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'clue_group' => array('on' => 'content_groups', 'clue_group.id' => 'clue_relation.secondary_group_id'), 'clue_item' => array('on' => 'content_items', 'clue_item.group_id' => 'clue_group.id') ), array( 'module_elements.id' => $questionID ) ); echo '<pre>'; print_r($questiondata); echo '</pre>'; echo '<h2>Type Word</h2>'; echo '<form name="fillword" method="post" action="'.THIS_PAGE.'?doThis=save&moduleID='.$modulid.'&question_type='.$_GET['question_type'].'">'; echo' <input type="hidden" name="doThis" value="save"> <input type="hidden" name="questionID" value="'.$questionID.'"> <input type="hidden" name="question_type" value="typeIn"> <input type="radio" name="dir" value="0" '.(($questiondata['dir'] == 0)?'checked=checked':'').'>'.$_SESSION['primary_locale_name'].' to '.$_SESSION['secondary_locale_name'].' <br> <input type="radio" name="dir" value="1" '.(($questiondata['dir'] == 1)?'checked=checked':'').'>'.$_SESSION['secondary_locale_name'].' to '.$_SESSION['primary_locale_name'].' <p class="instructions">Instructions: Write your Clue in the box below and the answer in the field labeled Answer. The student will be asked to fill in a word.</p>'; echo '<h3>Clue: </h3> <input type="text" name="question" value="'; if (!empty($questiondata['clue'])){ echo $questiondata['clue']; } echo '">'; echo '<h3>Answer:</h3> <input type="text" name="answer" value="'; if (!empty($questiondata['answer'])){ echo $questiondata['answer']; }else{ if (!empty($questiondata['word'])) { echo $questiondata['word']; } } echo '"><br /><br /></sel ect><input type="submit" name="submitMC" value="Save Question and Answers"> <input type="hidden" name="module_id" value="'.$_GET['moduleID'].'"> </form>';} function savetypeIn($questionID){ global $db; echo 'I am Now on typeIn with the following to work with <br /><br />'; echo 'POST = '; echo '<pre>'; print_r($_POST); echo '</pre>'; echo '<br />'; echo 'GET = '; echo '<pre>'; print_r($_GET); echo '</pre>'; echo '<br />'; echo 'QuestionID = '; echo '<pre>'; print_r($questionID); echo '</pre>'; echo '<br />'; $db->echo=true; if ($questionID == 'new'){ //A fill in word first needs a Group $element_group_id = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'typeIn')), 'sequence' => $_POST['dir'] ) ); //Lets create a module element! WOO $element_id = $db->insert('module_elements', array( 'module_id' => $_POST['module_id'], 'content_group_id' => $element_group_id, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'] ) ); //Fillin Phrase Elements //CorrectAnswer -> content_group_relationship -> Content_Group -> Content_items //clueData -> content_group_relationship -> content_group -> content_items //prePop -> content_group_relationships -> content_group -> content_items //correctAnswer //answer_group $answer_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'question answer')) ) ); //answer_item $answer_item = $db->insert( 'content_items', array( 'group_id' => $answer_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['answer'] ) ); //answer_relation $answer_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $answer_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer')) ) ); //clueData //clue_group $clue_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'clue')) ) ); //clue_item $clue_item = $db->insert( 'content_items', array( 'group_id' => $clue_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['question'] ) ); //clue_relation $clue_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $clue_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue')) ) ); } else { //TODO SELECT SOMETHIAGN $element_group_id = $db->select('content_groups.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id') ), array( 'module_elements.id' => $questionID ) ); $db->update( array( 'content_groups' ), array( 'content_groups.sequence' => $_POST['dir'] ), array( 'content_groups.id' => $element_group_id ) ); $answer_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); if (!$answer_id){ $answer_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'question answer')) ) ); //answer_item $answer_item = $db->insert( 'content_items', array( 'group_id' => $answer_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['answer'] ) ); //answer_relation $answer_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $answer_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer')) ) ); } else { $answer_item = $db->save('content_items', array( 'value' => $_POST['answer'] ), array( 'id' => $answer_id ) ); } $clue_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); if (!$clue_id){ $clue_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'clue')) ) ); //clue_item $clue_item = $db->insert( 'content_items', array( 'group_id' => $clue_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['question'] ) ); //clue_relation $clue_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $clue_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue')) ) ); } else { //clue_item $clue_item = $db->save( 'content_items', array( 'value' => $_POST['question'] ), array( 'id' => $clue_id ) ); } //function update($table, $updates, $conditions) { $db->update('module_elements', array( 'content_item_id' => NULL ), array( 'id' => $questionID ) ); }}function spaceout($questionID, $words, $modulid){global $db; //die('I will now end so that I dont create to many things'); echo '<pre>'; print_r($questionID); echo '</pre>'; $db->echo=true; //Todo: finish ME $questiondata = $db->select( array( 'answer_item.value' => 'answer', 'clue_item.value' => 'clue', 'word_item.value' => 'word', 'module_group.sequence' => 'dir', 'prepop_item.value' => 'prepop' ), array( 'module_elements', 'word_item' => array('on' => 'content_items', 'word_item.id' => 'module_elements.content_item_id'), 'module_group' => array('on' => 'content_groups', 'module_group.id' => 'module_elements.content_group_id'), 'answer_relation' => array('on' => 'content_group_relationships', 'answer_relation.primary_group_id' => 'module_group.id', 'answer_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer'))), 'answer_group' => array('on' => 'content_groups', 'answer_group.id' => 'answer_relation.secondary_group_id'), 'answer_item' => array('on' => 'content_items', 'answer_item.group_id' => 'answer_group.id'), 'clue_relation' => array('on' => 'content_group_relationships', 'clue_relation.primary_group_id' => 'module_group.id', 'clue_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'clue_group' => array('on' => 'content_groups', 'clue_group.id' => 'clue_relation.secondary_group_id'), 'clue_item' => array('on' => 'content_items', 'clue_item.group_id' => 'clue_group.id'), 'prepop_relation' => array('on' => 'content_group_relationships', 'prepop_relation.primary_group_id' => 'module_group.id', 'prepop_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt'))), 'prepop_group' => array('on' => 'content_groups', 'prepop_group.id' => 'prepop_relation.secondary_group_id'), 'prepop_item' => array('on' => 'content_items', 'prepop_item.group_id' => 'prepop_group.id') ), array( 'module_elements.id' => $questionID ) ); echo '<pre>'; print_r($questiondata); echo '</pre>'; echo '<h2>Space Out</h2>'; echo '<form name="fillword" method="post" action="'.THIS_PAGE.'?doThis=save&moduleID='.$modulid.'&question_type='.$_GET['question_type'].'">'; echo' <input type="hidden" name="doThis" value="save"> <input type="hidden" name="questionID" value="'.$questionID.'"> <input type="hidden" name="question_type" value="spaceout"> <input type="radio" name="dir" value="0" '.(($questiondata['dir'] == 0)?'checked=checked':'').'>'.$_SESSION['primary_locale_name'].' to '.$_SESSION['secondary_locale_name'].' <br> <input type="radio" name="dir" value="1" '.(($questiondata['dir'] == 1)?'checked=checked':'').'>'.$_SESSION['secondary_locale_name'].' to '.$_SESSION['primary_locale_name'].' <p class="instructions">Instructions: Write your Clue in the box below and the answer in the field labeled Answer. The student will be asked to fill in a word.</p>'; echo '<h3>Prompt: </h3> <input type="text" name="prepop" value="'; if (!empty($questiondata['prepop'])){ echo $questiondata['prepop']; } echo '">'; echo '<h3>Clue: </h3> <input type="text" name="question" value="'; if (!empty($questiondata['clue'])){ echo $questiondata['clue']; } echo '">'; echo '<h3>Answer:</h3> <input type="text" name="answer" value="'; if (!empty($questiondata['answer'])){ echo $questiondata['answer']; }else{ if (!empty($questiondata['word'])) { echo $questiondata['word']; } } echo '"><br /><br /></select><input type="submit" name="submitMC" value="Save Question and Answers"> <input type="hidden" name="module_id" value="'.$_GET['moduleID'].'"> </form>';}function savespaceout($questionID){global $db; echo 'I am Now on Fillword with the following to work with <br /><br />'; echo 'POST = '; echo '<pre>'; print_r($_POST); echo '</pre>'; echo '<br />'; echo 'GET = '; echo '<pre>'; print_r($_GET); echo '</pre>'; echo '<br />'; echo 'QuestionID = '; echo '<pre>'; print_r($questionID); echo '</pre>'; echo '<br />'; $db->echo=true; if ($questionID == 'new'){ //A fill in word first needs a Group $element_group_id = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'spaceOut')), 'sequence' => $_POST['dir'] ) ); //Lets create a module element! WOO $element_id = $db->insert('module_elements', array( 'module_id' => $_POST['module_id'], 'content_group_id' => $element_group_id, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'] ) ); //Fillin Phrase Elements //CorrectAnswer -> content_group_relationship -> Content_Group -> Content_items //clueData -> content_group_relationship -> content_group -> content_items //prePop -> content_group_relationships -> content_group -> content_items //correctAnswer //answer_group $answer_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'question answer')) ) ); //answer_item $answer_item = $db->insert( 'content_items', array( 'group_id' => $answer_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['answer'] ) ); //answer_relation $answer_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $answer_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer')) ) ); //clueData //clue_group $clue_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'clue')) ) ); //clue_item $clue_item = $db->insert( 'content_items', array( 'group_id' => $clue_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['question'] ) ); //clue_relation $clue_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $clue_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue')) ) ); //prePop //prePop_group $prePop_group = $db->insert('content_groups', array( 'content_type_id' => $db->select('id', 'content_types', array('type_name' => 'prompt')) ) ); //prePop_item $prePop_item = $db->insert( 'content_items', array( 'group_id' => $prePop_group, 'primary_locale_id' => $_SESSION['primary_locale'], 'secondary_locale_id' => $_SESSION['secondary_locale'], 'value' => $_POST['prepop'] ) ); //clue_relation $prePop_relation = $db->insert('content_group_relationships', array( 'primary_group_id' => $element_group_id, 'secondary_group_id' => $prePop_group, 'relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt')) ) ); } else { //TODO SELECT SOMETHIAGN $element_group_id = $db->select('content_groups.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id') ), array( 'module_elements.id' => $questionID ) ); $db->update( array( 'content_groups' ), array( 'content_groups.sequence' => $_POST['dir'] ), array( 'content_groups.id' => $element_group_id ) ); $answer_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'correct answer'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); $answer_item = $db->save( array( 'content_items' ), array( 'value' => $_POST['answer'] ), array( 'id' => $answer_id ) ); $clue_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); //clue_item $clue_item = $db->save( 'content_items', array( 'value' => $_POST['question'] ), array( 'id' => $clue_id ) ); //prePp //prePop_group $prepop_id = $db->select( 'content_items.id', array( 'module_elements', 'content_groups' => array('content_groups.id' => 'module_elements.content_group_id'), 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'content_groups.id', 'content_group_relationships.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt'))), 'answer_groups' => array('on' => 'content_groups', 'answer_groups.id' => 'content_group_relationships.secondary_group_id'), 'content_items' => array('content_items.group_id' => 'answer_groups.id') ), array( 'module_elements.id' => $questionID ) ); //prePop_item $prePop_item = $db->save( 'content_items', array( 'value' => $_POST['prepop'] ), array( 'id' => $prepop_id ) ); //function update($table, $updates, $conditions) { $db->update('module_elements', array( 'content_item_id' => NULL ), array( 'id' => $questionID ) ); }}function scatterphrase($questionID, $words, $modulid){global $db; //die('I will now end so that I dont create to many things'); echo '<pre>'; print_r($questionID); echo '</pre>'; $db->echo=true; //Todo: finish ME $questiondata = $db->select( array( 'clue_item.value' => 'clue', 'word_item.value' => 'word', 'module_group.sequence' => 'dir', 'prepop_item.value' => 'prepop' ), array( 'module_elements', 'word_item' => array('on' => 'content_items', 'word_item.id' => 'module_elements.content_item_id'), 'module_group' => array('on' => 'content_groups', 'module_group.id' => 'module_elements.content_group_id'), 'clue_relation' => array('on' => 'content_group_relationships', 'clue_relation.primary_group_id' => 'module_group.id', 'clue_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip clue'))), 'clue_group' => array('on' => 'content_groups', 'clue_group.id' => 'clue_relation.secondary_group_id'), 'clue_item' => array('on' => 'content_items', 'clue_item.group_id' => 'clue_group.id'), 'prepop_relation' => array('on' => 'content_group_relationships', 'prepop_relation.primary_group_id' => 'module_group.id', 'prepop_relation.relationship_type_id' => $db->select('id', 'relationship_types', array('type_name' => 'transzip prompt'))), 'prepop_group' => array('on' => 'content_groups', 'prepop_group.id' => 'prepop_relation.secondary_group_id'), 'prepop_item' => array('on' => 'content_items', 'prepop_item.group_id' => 'prepop_group.id') ), array( 'module_elements.id' => $questionID ) ); $answers = $db->select_all( array( 'answer.id', 'relationship_types.type_name' => 'con' ), array( 'module_elements', 'content_group_relationships' => array('content_group_relationships.primary_group_id' => 'module_elements.content_group_id'), 'relationship_types' => array('relationship_types.id' => 'content_group_relationships.relationship_type_id'), 'content_groups' => array('content_groups.id' => 'content_group_relationships.secondary_group_id', 'content_groups.content_type_id' => $db->select('id', 'content_types', array('content_types.type_name' => 'question answer'))), 'answer' => array('on' => 'content_items', 'answer.group_id' => 'content_groups.id') ), array( '' ) ); echo '<pre>'; print_r($questiondata); echo '</pre>'; echo '<h2>Space Out</h2>'; echo '<form name="fillword" method="post" action="'.THIS_PAGE.'?doThis=save&moduleID='.$modulid.'&question_type='.$_GET['question_type'].'">'; echo' <input type="hidden" name="doThis" value="save"> <input type="hidden" name="questionID" value="'.$questionID.'"> <input type="hidden" name="question_type" value="spaceout"> <input type="radio" name="dir" value="0" '.(($questiondata['dir'] == 0)?'checked=checked':'').'>'.$_SESSION['primary_locale_name'].' to '.$_SESSION['secondary_locale_name'].' <br> <input type="radio" name="dir" value="1" '.(($questiondata['dir'] == 1)?'checked=checked':'').'>'.$_SESSION['secondary_locale_name'].' to '.$_SESSION['primary_locale_name'].' <p class="instructions">Instructions: Write your Clue in the box below and the answer in the field labeled Answer. The student will be asked to fill in a word.</p>'; echo '<h3>Prompt: </h3> <input type="text" name="prepop" value="'; if (!empty($questiondata['prepop'])){ echo $questiondata['prepop']; } echo '">'; echo '<h3>Clue: </h3> <input type="text" name="question" value="'; if (!empty($questiondata['clue'])){ echo $questiondata['clue']; } echo '">'; echo '<h3>Answer:</h3> <input type="text" name="answer" value="'; if (!empty($questiondata['answer'])){ echo $questiondata['answer']; }else{ if (!empty($questiondata['word'])) { echo $questiondata['word']; } } echo '"><br /><br /></select><input type="submit" name="submitMC" value="Save Question and Answers"> <input type="hidden" name="module_id" value="'.$_GET['moduleID'].'"> </form>';}function savescatterphrase($questionID){}?>