Example #1
0
 function answer()
 {
     $answer_handler = new sfAnswerHandler($this->db);
     switch ($this->status()) {
         case _SF_STATUS_SUBMITTED:
             $theAnswers =& $answer_handler->getAllAnswers($this->faqid(), _SF_AN_STATUS_APPROVED, 1, 0);
             //echo "test";
             //exit;
             $this->_answer =& $theAnswers[0];
             break;
         case _SF_STATUS_ANSWERED:
             $theAnswers =& $answer_handler->getAllAnswers($this->faqid(), _SF_AN_STATUS_PROPOSED, 1, 0);
             //echo "test";
             //exit;
             $this->_answer =& $theAnswers[0];
             break;
         case _SF_STATUS_PUBLISHED:
         case _SF_STATUS_NEW_ANSWER:
         case _SF_STATUS_OFFLINE:
             $this->_answer =& $answer_handler->getOfficialAnswer($this->faqid());
             break;
         case _SF_STATUS_ASKED:
             $this->_answer =& $answer_handler->create();
         case _SF_STATUS_OPENED:
             $this->_answer =& $answer_handler->create();
             break;
     }
     if ($this->_answer) {
         $this->_answer->setVar('dohtml', $this->getVar('html'));
         $this->_answer->setVar('doxcode', $this->getVar('xcodes'));
         $this->_answer->setVar('dosmiley', $this->getVar('smiley'));
         $this->_answer->setVar('doimage', $this->getVar('image'));
         $this->_answer->setVar('dobr', $this->getVar('linebreak'));
     }
     return $this->_answer;
 }
Example #2
0
     // Send answer notifications
     if (!empty($notifToDo_answer)) {
         $answerObj->sendNotifications($notifToDo_answer);
     }
     redirect_header("index.php", 2, $redirect_msg);
     exit;
     break;
 case "del":
     global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB;
     $faqid = isset($_POST['faqid']) ? intval($_POST['faqid']) : 0;
     $faqid = isset($_GET['faqid']) ? intval($_GET['faqid']) : $faqid;
     $answerid = isset($_POST['answerid']) ? intval($_POST['answerid']) : 0;
     $answerid = isset($_GET['answerid']) ? intval($_GET['answerid']) : $answerid;
     $confirm = isset($_POST['confirm']) ? intval($_POST['confirm']) : 0;
     $faqObj = new sfFaq($faqid);
     $answerObj = new sfAnswer($answerid);
     if ($confirm) {
         $answerObj->setVar('status', _SF_AN_STATUS_REJECTED);
         $answerObj->store();
         switch ($faqObj->status()) {
             // Open Question for which we are rejecting an answer
             case _SF_STATUS_ANSWERED:
                 $redirect_page = "index.php";
                 $redirect_msg = _AM_SF_ANSWER_REJECTED_OPEN_QUESTION;
                 $faqObj->setVar('status', _SF_STATUS_OPENED);
                 break;
             case _SF_STATUS_NEW_ANSWER:
                 $proposed_answers = $answer_handler->getAllAnswers($faqid, _SF_AN_STATUS_PROPOSED);
                 if (count($proposed_answers) > 0) {
                     // This question has other proposed answer
                     $redirect_page = "answer.php?op=mod&faqid=" . $faqid;
Example #3
0
 function getLastPublishedByFaq($faqids)
 {
     $ret = array();
     $sql = "SELECT faqid, answer, uid, datesub FROM " . $this->db->prefix("smartfaq_answers") . "\r\n\t           WHERE faqid IN (" . implode(',', $faqids) . ") AND status = " . _SF_AN_STATUS_APPROVED . " GROUP BY faqid";
     $result = $this->db->query($sql);
     if (!$result) {
         return $ret;
     }
     while ($row = $this->db->fetchArray($result)) {
         $answer = new sfAnswer();
         $answer->assignVars($row);
         $ret[$row['faqid']] =& $answer;
         unset($answer);
     }
     return $ret;
 }
Example #4
0
function editfaq($showmenu = false, $faqid = -1, $answerid = -1, $merge = false)
{
    global $answer_handler, $faq_handler, $category_handler, $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $modify, $xoopsModuleConfig, $xoopsModule, $XOOPS_URL, $myts;
    include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
    // If there is a parameter, and the id exists, retrieve data: we're editing a faq
    if ($faqid != -1) {
        // Creating the FAQ object
        $faqObj = new sfFaq($faqid);
        if ($faqObj->notLoaded()) {
            redirect_header("faq.php", 1, _AM_SF_NOFAQSELECTED);
            exit;
        }
        if ($answerid == -1) {
            // Creating the object for the official answer
            $answerObj =& $faqObj->answer();
            if (!$answerObj) {
                $answerObj = $answer_handler->create();
            }
        } else {
            $answerObj = new sfAnswer($answerid);
            $originalAnswerObj =& $faqObj->answer();
        }
        switch ($faqObj->status()) {
            case _SF_STATUS_ASKED:
                $breadcrumb_action1 = _AM_SF_ASKED;
                $breadcrumb_action2 = _AM_SF_APPROVING;
                $collapsableBar_title = _AM_SF_ASKED_TITLE;
                $collapsableBar_info = _AM_SF_ASKED_TITLE_INFO;
                $button_caption = _AM_SF_PUBLISHED;
                $an_status = _SF_AN_STATUS_APPROVED;
                $answerObj->setVar('uid', $xoopsUser->getVar('uid'));
                break;
            case _SF_STATUS_ANSWERED:
                $breadcrumb_action1 = _AM_SF_ANSWERED;
                $breadcrumb_action2 = _AM_SF_APPROVING;
                $collapsableBar_title = _AM_SF_ANSWERED_TITLE;
                $collapsableBar_info = _AM_SF_ANSWERED_TITLE_INFO;
                $button_caption = _AM_SF_APPROVE;
                $an_status = _SF_AN_STATUS_PROPOSED;
                break;
            case _SF_STATUS_SUBMITTED:
                $breadcrumb_action1 = _AM_SF_SUBMITTED;
                $breadcrumb_action2 = _AM_SF_APPROVING;
                $collapsableBar_title = _AM_SF_SUBMITTED_TITLE;
                $collapsableBar_info = _AM_SF_SUBMITTED_INFO;
                $button_caption = _AM_SF_APPROVE;
                $an_status = _SF_AN_STATUS_PROPOSED;
                break;
            case _SF_STATUS_PUBLISHED:
                $breadcrumb_action1 = _AM_SF_PUBLISHED;
                $breadcrumb_action2 = _AM_SF_EDITING;
                $collapsableBar_title = _AM_SF_PUBLISHEDEDITING;
                $collapsableBar_info = _AM_SF_PUBLISHEDEDITING_INFO;
                $button_caption = _AM_SF_MODIFY;
                $an_status = _SF_AN_STATUS_APPROVED;
                break;
            case _SF_STATUS_OFFLINE:
                $breadcrumb_action1 = _AM_SF_OFFLINE;
                $breadcrumb_action2 = _AM_SF_EDITING;
                $collapsableBar_title = _AM_SF_OFFLINEEDITING;
                $collapsableBar_info = _AM_SF_OFFLINEEDITING_INFO;
                $button_caption = _AM_SF_MODIFY;
                $an_status = _SF_AN_STATUS_APPROVED;
                break;
            case _SF_STATUS_OPENED:
                $breadcrumb_action1 = _AM_SF_OPEN_QUESTIONS;
                $breadcrumb_action2 = _AM_SF_ANSWERING;
                $collapsableBar_title = _AM_SF_OPEN_QUESTION_ANSWERING;
                $collapsableBar_info = _AM_SF_OPEN_QUESTION_ANSWERING_INFO;
                $button_caption = _AM_SF_PUBLISH;
                $an_status = _SF_AN_STATUS_NOTSET;
                $answerObj->setVar('uid', $xoopsUser->getVar('uid'));
                break;
            case _SF_STATUS_NEW_ANSWER:
                $breadcrumb_action1 = _AM_SF_PUBLISHED;
                $breadcrumb_action2 = _AM_SF_EDITING;
                $collapsableBar_title = _AM_SF_NEW_ANSWER_EDITING;
                $collapsableBar_info = _AM_SF_NEW_ANSWER_EDITING_INFO;
                $button_caption = _AM_SF_PUBLISH;
                $an_status = _SF_AN_STATUS_NOTSET;
                break;
            case "default":
            default:
                break;
        }
        /*		if (!$answerObj) {
        			redirect_header("faq.php", 2, _AM_SF_ANSWERNOTFOUND);
        			exit();
        		}		*/
        // Creating the category of this FAQ
        $categoryObj =& $faqObj->category();
        if ($showmenu) {
            sf_adminMenu(2, $breadcrumb_action1 . " > " . $breadcrumb_action2);
        }
        echo "<br />\n";
        sf_collapsableBar('bottomtable', 'bottomtableicon');
        echo "<img id='bottomtableicon' src=" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/close12.gif alt='' /></a>&nbsp;" . $collapsableBar_title . "</h3>";
        echo "<div id='bottomtable'>";
        echo "<span style=\"color: #567; margin: 3px 0 12px 0; font-size: small; display: block; \">" . $collapsableBar_info . "</span>";
    } else {
        // there's no parameter, so we're adding a faq
        $faqObj =& $faq_handler->create();
        $faqObj->setVar('uid', $xoopsUser->getVar('uid'));
        $categoryObj =& $category_handler->create();
        $answerObj =& $answer_handler->create();
        $answerObj->setVar('uid', $xoopsUser->getVar('uid'));
        $breadcrumb_action1 = _AM_SF_SMARTFAQS;
        $breadcrumb_action2 = _AM_SF_CREATINGNEW;
        $button_caption = _AM_SF_CREATE;
        if ($showmenu) {
            sf_adminMenu(2, $breadcrumb_action1 . " > " . $breadcrumb_action2);
        }
        sf_collapsableBar('bottomtable', 'bottomtableicon');
        echo "<img id='bottomtableicon' src=" . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/images/icon/close12.gif alt='' /></a>&nbsp;" . _AM_SF_CREATESMARTFAQ . "</h3>";
        echo "<div id='bottomtable'>";
    }
    $sform = new XoopsThemeForm(_AM_SF_SMARTFAQ, "op", xoops_getenv('PHP_SELF'));
    $sform->setExtra('enctype="multipart/form-data"');
    // faq requester
    $sform->addElement(new XoopsFormLabel(_AM_SF_REQUESTED_BY, sf_getLinkedUnameFromId($faqObj->uid(), $xoopsModuleConfig['userealname'])));
    // faq answered by
    $sform->addElement(new XoopsFormLabel(_AM_SF_ANSWERED_BY, sf_getLinkedUnameFromId($answerObj->uid(), $xoopsModuleConfig['userealname'])));
    // CATEGORY
    /*
     * Get information for pulldown menu using XoopsTree.
     * First var is the database table
     * Second var is the unique field ID for the categories
     * Last one is not set as we do not have sub menus in Smartfaq
     */
    $mytree = new XoopsTree($xoopsDB->prefix("smartfaq_categories"), "categoryid", "parentid");
    ob_start();
    $mytree->makeMySelBox("name", "weight", $categoryObj->categoryid());
    $sform->addElement(new XoopsFormLabel(_AM_SF_CATEGORY_FAQ, ob_get_contents()));
    ob_end_clean();
    // faq QUESTION
    $sform->addElement(new XoopsFormTextArea(_AM_SF_QUESTION, 'question', $faqObj->question(0, 'e'), 7, 60));
    // ANSWER
    if ($merge) {
        $theanswer = $originalAnswerObj->answer('e') . "\n\n" . sprintf(_AM_SF_NEW_CONTRIBUTION, sf_getLinkedUnameFromId($answerObj->uid(), $xoopsModuleConfig['userealname']), $answerObj->datesub(), $answerObj->answer('e'));
    } else {
        $theanswer = $answerObj->answer('e');
    }
    $sform->addElement(new XoopsFormDhtmlTextArea(_AM_SF_ANSWER_FAQ, 'answer', $theanswer, 15, 60), true);
    // HOW DO I
    $sform->addElement(new XoopsFormText(_AM_SF_HOWDOI_FAQ, 'howdoi', 50, 255, $faqObj->howdoi('e')), false);
    // DIDUNO
    $sform->addElement(new XoopsFormTextArea(_AM_SF_DIDUNO_FAQ, 'diduno', $faqObj->diduno('e'), 3, 60));
    // CONTEXT MODULE LINK
    // Retreive the list of module currently installed. The key value is the dirname
    $module_handler =& xoops_gethandler('module');
    $modules_array = $module_handler->getList(null, true);
    $modulelink_select_array = array("url" => _AM_SF_SPECIFIC_URL_SELECT);
    $modulelink_select_array = array_merge($modules_array, $modulelink_select_array);
    $modulelink_select_array = array_merge(array("None" => _AM_SF_NONE, "All" => _AM_SF_ALL), $modulelink_select_array);
    $modulelink_select = new XoopsFormSelect('', 'modulelink', $faqObj->modulelink());
    $modulelink_select->addOptionArray($modulelink_select_array);
    $modulelink_tray = new XoopsFormElementTray(_AM_SF_CONTEXTMODULELINK_FAQ, '&nbsp;');
    $modulelink_tray->addElement($modulelink_select);
    $sform->addElement($modulelink_tray);
    // SPECIFICURL
    $sform->addElement(new XoopsFormText(_AM_SF_SPECIFIC_URL, 'contextpage', 50, 60, $faqObj->contextpage()), false);
    // EXACT URL?
    $excaturl_radio = new XoopsFormRadioYN(_AM_SF_EXACTURL, 'exacturl', $faqObj->exacturl(), ' ' . _AM_SF_YES . '', ' ' . _AM_SF_NO . '');
    $sform->addElement($excaturl_radio);
    // WEIGHT
    $sform->addElement(new XoopsFormText(_AM_SF_WEIGHT, 'weight', 5, 5, $faqObj->weight()), true);
    // COMMENTS
    // Code to allow comments
    $addcomments_radio = new XoopsFormRadioYN(_AM_SF_ALLOWCOMMENTS, 'cancomment', $faqObj->cancomment(), ' ' . _AM_SF_YES . '', ' ' . _AM_SF_NO . '');
    $sform->addElement($addcomments_radio);
    // PER ITEM PERMISSIONS
    $member_handler =& xoops_gethandler('member');
    $group_list =& $member_handler->getGroupList();
    $groups_checkbox = new XoopsFormCheckBox(_AM_SF_PERMISSIONS_FAQ, 'groups[]', $faqObj->getGroups_read());
    foreach ($group_list as $group_id => $group_name) {
        if ($group_id != XOOPS_GROUP_ADMIN) {
            $groups_checkbox->addOption($group_id, $group_name);
        }
    }
    $sform->addElement($groups_checkbox);
    $partial_view = new XoopsFormRadioYN(_AM_SF_PARTIALVIEW, 'partialview', $faqObj->partialview(), ' ' . _AM_SF_YES . '', ' ' . _AM_SF_NO . '');
    $sform->addElement($partial_view);
    // VARIOUS OPTIONS
    $options_tray = new XoopsFormElementTray(_AM_SF_OPTIONS, '<br />');
    $html_checkbox = new XoopsFormCheckBox('', 'html', $faqObj->html());
    $html_checkbox->addOption(1, _AM_SF_DOHTML);
    $options_tray->addElement($html_checkbox);
    $smiley_checkbox = new XoopsFormCheckBox('', 'smiley', $faqObj->smiley());
    $smiley_checkbox->addOption(1, _AM_SF_DOSMILEY);
    $options_tray->addElement($smiley_checkbox);
    $xcodes_checkbox = new XoopsFormCheckBox('', 'xcodes', $faqObj->xcodes());
    $xcodes_checkbox->addOption(1, _AM_SF_DOXCODE);
    $options_tray->addElement($xcodes_checkbox);
    $sform->addElement($options_tray);
    // OFFLINE
    if ($faqObj->status() == _SF_STATUS_OFFLINE) {
        // Back OnLine
        $offline_radio = new XoopsFormRadioYN(_AM_SF_OFFLINE_FIELD, 'offline', 1, ' ' . _AM_SF_YES . '', ' ' . _AM_SF_NO . '');
        $sform->addElement($offline_radio);
    }
    // faq ID
    $sform->addElement(new XoopsFormHidden('faqid', $faqObj->faqid()));
    // requester id
    $sform->addElement(new XoopsFormHidden('requester_uid', $faqObj->uid()));
    // answerer id
    $sform->addElement(new XoopsFormHidden('answerer_uid', $answerObj->uid()));
    // ANSWER ID
    $sform->addElement(new XoopsFormHidden('answerid', $answerObj->answerid()));
    $button_tray = new XoopsFormElementTray('', '');
    $hidden = new XoopsFormHidden('op', 'addfaq');
    $button_tray->addElement($hidden);
    $sform->addElement(new XoopsFormHidden('status', $faqObj->status()));
    // Setting the FAQ Status
    /*	$status_select = new XoopsFormSelect('', 'status', $status);
    	$status_select->addOptionArray(sf_getStatusArray());
    	$status_tray = new XoopsFormElementTray(_AM_SF_STATUS_EXP , '&nbsp;');
    	$status_tray->addElement($status_select);
    	$sform->addElement($status_tray);
    	*/
    if (!$faqid) {
        // there's no faqid? Then it's a new faq
        // $button_tray -> addElement( new XoopsFormButton( '', 'mod', _AM_SF_CREATE, 'submit' ) );
        $butt_create = new XoopsFormButton('', '', _AM_SF_CREATE, 'submit');
        $butt_create->setExtra('onclick="this.form.elements.op.value=\'addfaq\'"');
        $button_tray->addElement($butt_create);
        $butt_clear = new XoopsFormButton('', '', _AM_SF_CLEAR, 'reset');
        $button_tray->addElement($butt_clear);
        $butt_cancel = new XoopsFormButton('', '', _AM_SF_CANCEL, 'button');
        $butt_cancel->setExtra('onclick="history.go(-1)"');
        $button_tray->addElement($butt_cancel);
    } else {
        // else, we're editing an existing faq
        // $button_tray -> addElement( new XoopsFormButton( '', 'mod', _AM_SF_MODIFY, 'submit' ) );
        $butt_create = new XoopsFormButton('', '', $button_caption, 'submit');
        $butt_create->setExtra('onclick="this.form.elements.op.value=\'addfaq\'"');
        $button_tray->addElement($butt_create);
        $butt_cancel = new XoopsFormButton('', '', _AM_SF_CANCEL, 'button');
        $butt_cancel->setExtra('onclick="history.go(-1)"');
        $button_tray->addElement($butt_cancel);
    }
    $sform->addElement($button_tray);
    $sform->display();
    echo "</div>";
    unset($hidden);
}