$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';
