$sql = "UPDATE cms_faq_quests\n SET category_id = {$category_id},\n quest='{$quest}',\n answer='{$answer}',\n user_id='{$user_id}',\n published={$published},\n answeruser_id={$answeruser_id},\n pubdate='{$pubdate}',\n answerdate='{$answerdate}'\n WHERE id = {$id}\n LIMIT 1"; $inDB->query($sql); } if (!isset($_SESSION['editlist']) || @sizeof($_SESSION['editlist']) == 0) { cmsCore::redirect('?view=components&do=config&opt=list_items&id=' . (int) $_REQUEST['id']); } else { cmsCore::redirect('?view=components&do=config&opt=edit_item&id=' . (int) $_REQUEST['id']); } } if ($opt == 'delete_item') { if (!isset($_REQUEST['item'])) { if (isset($_REQUEST['item_id'])) { $model->deleteQuest((int) $_REQUEST['item_id']); } } else { $model->deleteQuests($_REQUEST['item']); } cmsCore::redirect('?view=components&do=config&opt=list_items&id=' . $id); } if ($opt == 'show_cat') { if (isset($_REQUEST['item_id'])) { $id = (int) $_REQUEST['item_id']; $sql = "UPDATE cms_faq_cats SET published = 1 WHERE id = {$id}"; $inDB->query($sql); echo '1'; exit; } } if ($opt == 'hide_cat') { if (isset($_REQUEST['item_id'])) { $id = (int) $_REQUEST['item_id'];
$answerdate = (int) $date[2] . '-' . (int) $date[1] . '-' . (int) $date[0]; $sql = "UPDATE cms_faq_quests\r\n SET category_id = {$category_id},\r\n quest='{$quest}',\r\n answer='{$answer}',\r\n user_id='{$user_id}',\r\n published={$published},\r\n answeruser_id={$answeruser_id},\r\n pubdate='{$pubdate}',\r\n answerdate='{$answerdate}'\r\n WHERE id = {$id}\r\n LIMIT 1"; $inDB->query($sql); if (!isset($_SESSION['editlist']) || @sizeof($_SESSION['editlist']) == 0) { cmsCore::redirect('?view=components&do=config&opt=list_items&id=' . (int) $_REQUEST['id']); } else { cmsCore::redirect('?view=components&do=config&opt=edit_item&id=' . (int) $_REQUEST['id']); } } if ($opt == 'delete_item') { if (!isset($_REQUEST['item'])) { if (isset($_REQUEST['item_id'])) { $model->deleteQuest(cmsCore::request('item_id', 'int', 0)); } } else { $model->deleteQuests(cmsCore::request('item', 'array_int', 0)); } cmsCore::redirect('?view=components&do=config&opt=list_items&id=' . $id); } if ($opt == 'show_cat') { $id = cmsCore::request('item_id', 'int', 0); $sql = "UPDATE cms_faq_cats SET published = 1 WHERE id = {$id}"; $inDB->query($sql); echo '1'; exit; } if ($opt == 'hide_cat') { $id = cmsCore::request('item_id', 'int', 0); $sql = "UPDATE cms_faq_cats SET published = 0 WHERE id = {$id}"; $inDB->query($sql); echo '1';