public function actionScrollview($text = "") { if ($text == "") { $query = "SELECT article_modulecomponentid FROM scrolltext WHERE page_modulecomponentid=" . $this->moduleComponentId; $result = mysql_query($query); $row = mysql_fetch_assoc($result); $articleid = $row['article_modulecomponentid']; $query = "SELECT article_content,article_lastupdated FROM article_content WHERE page_modulecomponentid=" . $articleid; $result = mysql_query($query); if ($row = mysql_fetch_assoc($result)) { $text = $row['article_content']; global $PAGELASTUPDATED; $PAGELASTUPDATED = $row['article_lastupdated']; } else { return "Article not yet created."; } } $content = "<HEAD><META HTTP-EQUIV=REFRESH CONTENT=300></HEAD><body><div><div align=\"center\"><fieldset><marquee behavior=scroll scrollAmount=\"1\" scrolldelay=\"0\" onmouseover=\"this.stop()\" direction=\"up\" onmouseout=\"this.start()\" vspce=\"800px\"style=\"height:800px;width:800px;font-size:15px;color:#880000;\">" . $text . "</div></fieldset></marquee></body>"; global $sourceFolder; global $moduleFolder; require_once $sourceFolder . "/pngRender.class.php"; if (get_magic_quotes_gpc()) { $content = stripslashes($content); } $render = new pngrender(); echo $render->transform($content); disconnect(); exit; }
public function actionView() { global $sourceFolder, $cmsFolder, $templateFolder, $moduleFolder, $urlRequestRoot; require_once "{$sourceFolder}/{$moduleFolder}/faculty/template_edit.php"; $viewDetail = ""; $templateId = getTemplateId($this->moduleComponentId); $sectionDetail = getTemplateDataFromModuleComponentId($this->moduleComponentId); $title = getPageTitle(getPageIdFromModuleComponentId("faculty", $this->moduleComponentId)); $getImage = "SELECT * FROM `faculty_module` WHERE `page_moduleComponentId`={$this->moduleComponentId}"; $getImageQuery = mysql_query($getImage); $isExistPh = mysql_fetch_assoc($getImageQuery); $viewDetail .= <<<IMG \t <div style="text-align:center;"> \t <img src="{$isExistPh['photo']}" /> \t </div> IMG; require_once $sourceFolder . "/pngRender.class.php"; $render = new pngrender(); $emailId = getEmailForFaculty($this->moduleComponentId); $ret = $render->transform("[tex]" . $emailId . "[/tex]"); $viewDetail .= "<h3 style='text-align:center;'>Email:{$ret}</h3>"; while ($sectionDetailArray = mysql_fetch_assoc($sectionDetail)) { $sectionId = $sectionDetailArray['template_sectionId']; $printFacData = printFacultyData($sectionId, $this->moduleComponentId, 0); if ($printFacData != "") { $viewDetail .= <<<facultyName \t\t<h2>{$sectionDetailArray['template_sectionName']}</h2><hr> facultyName; } $viewDetail .= "<br/><br/>"; $sectionChildNode1DetailQuery = "SELECT * FROM `faculty_template` WHERE `template_id`={$templateId} AND "; $sectionChildNode1DetailQuery .= "`template_sectionParentId`={$sectionDetailArray['template_sectionId']}"; $sectionChildNode1DetailResult = mysql_query($sectionChildNode1DetailQuery); $viewDetail .= $printFacData; while ($sectionChildNode1DetailArray = mysql_fetch_assoc($sectionChildNode1DetailResult)) { $facultyData = printFacultyData($sectionChildNode1DetailArray['template_sectionId'], $this->moduleComponentId, 1); $viewDetail .= <<<facultyName \t\t<h3>{$facultyData}</h3> facultyName; $sectionChildNode2DetailQuery = "SELECT * FROM `faculty_template` WHERE `template_id`={$templateId} AND "; $sectionChildNode2DetailQuery .= "`template_sectionParentId`={$sectionChildNode1DetailArray['template_sectionId']}"; $sectionChildNode2DetailResult = mysql_query($sectionChildNode2DetailQuery); while ($sectionChildNode2DetailArray = mysql_fetch_assoc($sectionChildNode2DetailResult)) { $facultyDataChild = printFacultyData($sectionChildNode2DetailArray['template_sectionId'], $this->moduleComponentId, 1); $viewDetail .= <<<facultyName \t\t <h4>{$facultyDataChild}</h4> facultyName; } $viewDetail .= "<br/>"; } } return $viewDetail; }
/** * function getQuestionTableHtml: * displays all the questions in a given section, quiz * with proper formatting */ function getQuestionTableHtml($quizId, $sectionId) { global $urlRequestRoot, $sourceFolder, $templateFolder, $cmsFolder; $editImage = "<img style=\"padding:0px\" src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/apps/accessories-text-editor.png\" alt=\"Edit\" />"; $deleteImage = "{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/actions/edit-delete.png"; $moveUpImage = "<img src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/actions/go-up.png\" alt=\"Move Section Up\" />"; $moveDownImage = "<img src=\"{$urlRequestRoot}/{$cmsFolder}/{$templateFolder}/common/icons/16x16/actions/go-down.png\" alt=\"Move Section Down\" />"; $questionQuery = "SELECT * FROM `quiz_questions` WHERE `page_modulecomponentid` = '{$quizId}' AND `quiz_sectionid` = '{$sectionId}' ORDER BY `quiz_questionrank`"; $questionResult = mysql_query($questionQuery); $questionListHtml = '<table border="1"><tr><th>Question</th><th>Type</th><th></th></tr>'; $questionCount = mysql_num_rows($questionResult); $i = 0; while ($questionRow = mysql_fetch_assoc($questionResult)) { $questionId = $questionRow['quiz_questionid']; $rightAnswer = $questionRow['quiz_rightanswer']; $optionsText = ''; $optionsQuery = "SELECT * FROM `quiz_objectiveoptions` WHERE `page_modulecomponentid` = '{$quizId}' AND `quiz_sectionid` = '{$sectionId}' AND `quiz_questionid` = '{$questionId}' ORDER BY `quiz_optionrank"; $optionsResult = mysql_query($optionsQuery); $j = 1; while ($optionsRow = mysql_fetch_assoc($optionsResult)) { $style = ''; if ($j == $rightAnswer) { $style = 'font-weight: bold;'; } $optionsText .= "<p style=\"margin-left: 12px; {$style}\">{$optionsRow['quiz_optiontext']}</p>\n"; ++$j; } global $sourceFolder, $moduleFolder; require_once $sourceFolder . "/pngRender.class.php"; $render = new pngrender(); $optionsText = $render->transform($optionsText); $questionDesc = $render->transform($questionRow['quiz_question']); $moveUp = $i == 0 ? '' : "<a href=\"./+edit&subaction=movequestion&direction=up§ionid={$sectionId}&questionid={$questionId}\">{$moveUpImage}</a>"; $moveDown = $i == $questionCount - 1 ? '' : "<a href=\"./+edit&subaction=movequestion&direction=down§ionid={$sectionId}&questionid={$questionId}\">{$moveDownImage}</a>"; $questionListHtml .= <<<QUESTIONROW \t\t<tr> \t\t\t<td>{$questionDesc}<br />{$optionsText}</td><td>{$questionRow['quiz_questiontype']}</td> \t\t\t<td nowrap="nowrap"> \t\t\t\t<a href="./+edit&subaction=editquestion§ionid={$sectionId}&questionid={$questionRow['quiz_questionid']}">{$editImage}</a> \t\t\t\t<form style="display:inline;margin:0;padding:0;border:0" method="POST" action="./+edit&subaction=deletequestion"> \t\t\t\t\t<input type="hidden" name="hdnSectionId" value="{$sectionId}" /> \t\t\t\t\t<input type="hidden" name="hdnQuestionId" value="{$questionId}" /> \t\t\t\t\t<input type="image" name="btnDelete" src="{$deleteImage}" title="Delete" /> \t\t\t\t</form> \t\t\t\t{$moveUp} \t\t\t\t{$moveDown} \t\t\t</td> \t\t</tr> QUESTIONROW; ++$i; } return $questionListHtml . '</table>'; }
public function actionView($text = "") { if (isset($_GET['draft']) && isset($_POST['CKEditor1'])) { //$query = "UPDATE `article_draft` SET `draft_content` = '" . $_POST["CKEditor1"] . "' WHERE `page_modulecomponentid` =".$this->moduleComponentId; $query = "SELECT MAX(draft_number) AS MAX FROM `article_draft` WHERE page_modulecomponentid ='{$this->moduleComponentId}'"; $result = mysql_query($query); if (!$result) { displayerror(mysql_error() . "article.lib L:44"); return; } if (mysql_num_rows($result)) { $drow = mysql_fetch_assoc($result); $draftId = $drow['MAX'] + 1; } else { $draftId = 1; } $query = "INSERT INTO `article_draft` (`page_modulecomponentid`,`draft_number`,`draft_content`,`draft_lastsaved`,`user_id`) VALUES ('" . $this->moduleComponentId . "','" . $draftId . "','" . $_POST['CKEditor1'] . "',now(),'" . $this->userId . "')"; $result = mysql_query($query) or die(mysql_error()); if (mysql_affected_rows() < 1) { displayerror("Unable to draft the article"); } } if ($this->isCommentsEnabled() && isset($_POST['btnSubmit'])) { $id = mysql_fetch_array(mysql_query("SELECT MAX(`comment_id`) AS MAX FROM `article_comments`")); $id = $id['MAX'] + 1; $user = getUserName($this->userId); $comment = escape(safe_html($_POST['comment'])); mysql_query("INSERT INTO `article_comments`(`comment_id`,`page_modulecomponentid`,`user`,`comment`) VALUES('{$id}','{$this->moduleComponentId}','{$user}','{$comment}')"); if (mysql_affected_rows()) { displayinfo("Post successful"); } else { displayerror("Error in posting comment"); } } if ($text == "") { $query = "SELECT article_content,article_lastupdated FROM article_content WHERE page_modulecomponentid='" . $this->moduleComponentId . "'"; $result = mysql_query($query); if ($row = mysql_fetch_assoc($result)) { $text = $row['article_content']; $text = censor_words($text); global $PAGELASTUPDATED; $PAGELASTUPDATED = $row['article_lastupdated']; } else { return "Article not yet created."; } } global $sourceFolder; global $moduleFolder; require_once $sourceFolder . "/pngRender.class.php"; if (get_magic_quotes_gpc()) { $text = stripslashes($text); } $render = new pngrender(); $ret = $render->transform($text); require_once $sourceFolder . "/googleMaps.class.php"; $maps = new googlemaps(); $ret = $maps->render($ret); if ($this->isCommentsEnabled()) { $comments = mysql_query("SELECT `comment_id`,`user`,`timestamp`,`comment` FROM `article_comments` WHERE `page_modulecomponentid` = '{$this->moduleComponentId}' ORDER BY `timestamp`"); if (mysql_num_rows($comments) > 0) { $ret .= "<fieldset><legend>Comments</legend>"; } while ($row = mysql_fetch_array($comments)) { $ret .= $this->renderComment($row['comment_id'], $row['user'], $row['timestamp'], censor_words($row['comment'])); } if (mysql_num_rows($comments) > 0) { $ret .= "</fieldset>"; } $ret .= $this->commentBox(); } return $ret; }
/** * function formatQuestion: * Given a question row, return HTML for the question. * @param $questionRow * @return string Question in HTML. */ private function formatQuestion($questionRow, $questionNumber = -1) { $questionType = $questionRow['quiz_questiontype']; if ($questionType == 'subjective') { $fieldName = 'txtAnswer' . $questionRow['quiz_sectionid'] . '_' . $questionRow['quiz_questionid']; $answer = '<textarea style="width:95%;height:100px;" name="' . $fieldName . '" id="' . $fieldName . '"></textarea>'; } else { $optionList = getQuestionOptionList($this->quizId, $questionRow['quiz_sectionid'], $questionRow['quiz_questionid']); $answer = '<table class="objectivecontainer" width="100%">'; for ($i = 0; $i < count($optionList); ++$i) { $fieldType = $questionType == 'sso' ? 'radio' : 'checkbox'; $fieldName = ''; $fieldId = ''; if ($questionType == 'sso') { $fieldName = 'optAnswer' . $questionRow['quiz_sectionid'] . '_' . $questionRow['quiz_questionid']; $fieldId = $fieldName . '_' . $optionList[$i]['quiz_optionid']; } elseif ($questionType == 'mso') { $fieldName = 'chkAnswer' . $questionRow['quiz_sectionid'] . '_' . $questionRow['quiz_questionid'] . '_' . $optionList[$i]['quiz_optionid']; $fieldId = $fieldName; } $answer .= "<tr><td width=\"24\"><input type=\"{$fieldType}\" name=\"{$fieldName}\" id=\"{$fieldId}\" value=\"{$optionList[$i]['quiz_optionid']}\" /> </td><td><label for=\"{$fieldId}\"> {$optionList[$i]['quiz_optiontext']}</label></td></tr>\n"; } $answer .= '</table>'; } $hiddenFieldName = "hdnQuestion{$questionRow['quiz_sectionid']}_{$questionRow['quiz_questionid']}"; $questionDesc = $questionRow['quiz_question']; if ($questionNumber > 0) { $questionDesc = $questionNumber . ') ' . $questionDesc; } global $sourceFolder, $moduleFolder; require_once $sourceFolder . "/pngRender.class.php"; $render = new pngrender(); $questionDesc = $render->transform($questionDesc); $answer = $render->transform($answer); return <<<QUESTIONFORM \t\t\t<input type="hidden" name="{$hiddenFieldName}" id="{$hiddenFieldName}" value="" /> \t\t\t<div class="quiz_questioncontainer"> \t\t\t\t<br /><b>{$questionDesc}</b><br /><br /> \t\t\t</div> \t\t\t<div class="quiz_answercontainer"> \t\t\t\t{$answer} \t\t\t</div> QUESTIONFORM; }