// // ------------------------------------------------------------------------ // // This program is free software; you can redistribute it and/or modify // // it under the terms of the GNU General Public License as published by // // the Free Software Foundation; either version 2 of the License, or // // (at your option) any later version. // // // // You may not change or alter any portion of this comment or credits // // of supporting developers from this source code or any supporting // // source code which is considered copyrighted (c) material of the // // original comment or credit authors. // // // // This program is distributed in the hope that it will be useful, // // but WITHOUT ANY WARRANTY; without even the implied warranty of // // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // // GNU General Public License for more details. // // // // You should have received a copy of the GNU General Public License // // along with this program; if not, write to the Free Software // // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // // ------------------------------------------------------------------------ // include '../../../include/cp_header.php'; if ( file_exists("../language/".$xoopsConfig['language']."/main.php") ) { include "../language/".$xoopsConfig['language']."/main.php"; } else { include "../language/english/main.php"; } $op = "listcat"; if (!empty($_GET['op'])) { $cat_id = !empty($_GET['cat_id']) ? intval($_GET['cat_id']) : 0; $op = $_GET['op']; } elseif (!empty($_POST['op'])) { $op = $_POST['op']; } if ( !empty($_POST['contents_preview']) ) { $myts =& MyTextSanitizer::getInstance(); xoops_cp_header(); $contents_nohtml = !empty($_POST['contents_nohtml']) ? 1 : 0; $contents_nosmiley = !empty($_POST['contents_nosmiley']) ? 1 : 0; $contents_noxcode = !empty($_POST['contents_noxcode']) ? 1 : 0; $html = empty($contents_nohtml) ? 1 : 0; $smiley = empty($contents_nosmiley) ? 1 : 0; $xcode = empty($contents_noxcode) ? 1 : 0; $contents_visible = !empty($_POST['contents_visible']) ? 1 : 0; $contents_order = !empty($_POST['contents_order']) ? intval($_POST['contents_order']) : 0; $contents_id = !empty($_POST['contents_id']) ? intval($_POST['contents_id']) : 0; $category_id = !empty($_POST['category_id']) ? intval($_POST['category_id']) : 0; $p_title = $myts->makeTboxData4Preview($_POST['contents_title']); $p_contents = $myts->makeTareaData4Preview($_POST['contents_contents'], $contents_nohtml, $contents_nosmiley, $contents_noxcode); echo"

$p_title

$p_contents

"; $contents_title = $myts->makeTboxData4PreviewInForm($_POST['contents_title']); $contents_contents = $myts->makeTareaData4PreviewInForm($_POST['contents_contents']); include "contentsform.php"; xoops_cp_footer(); exit(); } if ($op == "listcat") { $myts =& MyTextSanitizer::getInstance(); xoops_cp_header(); echo "

"._XD_DOCS."

"._XD_ADDCAT."

"; xoops_cp_footer(); exit(); } if ($op == "addcatgo") { $myts =& MyTextSanitizer::getInstance(); $category = $myts->stripSlashesGPC($_POST['category']); $newid = $xoopsDB->genId($xoopsDB->prefix("xoopsfaq_categories")."_category_id_seq"); $sql = "INSERT INTO ".$xoopsDB->prefix("xoopsfaq_categories")." (category_id, category_title, category_order) VALUES ($newid, ".$xoopsDB->quoteString($category).", ".intval($_POST['order']).")"; if (!$xoopsDB->query($sql)) { xoops_cp_header(); echo "Could not add category"; xoops_cp_footer(); } else { redirect_header("index.php?op=listcat",1,_XD_DBSUCCESS); } exit(); } if ($op == "editcatgo") { $myts =& MyTextSanitizer::getInstance(); $count = count($_POST['newcategory']); for ($i = 0; $i < $count; $i++) { if ( $_POST['newcategory'][$i] != $_POST['oldcategory'][$i] || $_POST['neworder'][$i] != $_POST['oldorder'][$i] ) { $category = $myts->stripSlashesGPC($_POST['newcategory'][$i]); $sql = "UPDATE ".$xoopsDB->prefix("xoopsfaq_categories")." SET category_title=".$xoopsDB->quoteString($category).", category_order=".intval($_POST['neworder'][$i])." WHERE category_id=".intval($_POST['cat_id'][$i]); $xoopsDB->query($sql); } } redirect_header("index.php?op=listcat",1,_XD_DBSUCCESS); exit(); } if ($op == "listcontents") { $myts =& MyTextSanitizer::getInstance(); xoops_cp_header(); $sql = "SELECT category_title FROM ".$xoopsDB->prefix("xoopsfaq_categories")." WHERE category_id=".$cat_id; $result = $xoopsDB->query($sql); list($category) = $xoopsDB->fetchRow($result); $category = $myts->makeTboxData4Show($category); echo "" ._XD_MAIN." »» ".$category."

"._XD_CONTENTS."

"._XD_ADDCONTENTS."

"; $contents_title = ""; $contents_contents = ""; $contents_order = 0; $contents_visible = 1; $contents_nohtml = 0; $contents_nosmiley = 0; $contents_noxcode = 0; $contents_id = 0; $category_id = $cat_id; $op = "addcontentsgo"; include "contentsform.php"; xoops_cp_footer(); exit(); } if ($op == "quickeditcontents") { $myts =& MyTextSanitizer::getInstance(); $cat_id = !empty($_POST['cat_id']) ? intval($_POST['cat_id']) : 0; $count = count($_POST['id']); for ($i = 0; $i < $count; $i++) { $index = intval($_POST['id'][$i]); if ( $_POST['neworder'][$index] != $_POST['oldorder'][$index] || $_POST['newvisible'][$index] != $_POST['oldvisible'][$index] ) { $xoopsDB->query("UPDATE ".$xoopsDB->prefix("xoopsfaq_contents")." SET contents_order=".intval($_POST['neworder'][$index]).", contents_visible=".intval($_POST['newvisible'][$index])." WHERE contents_id=".$index); } } redirect_header("index.php?op=listcontents&cat_id=$cat_id",1,_XD_DBSUCCESS); exit(); } if ($op == "addcontentsgo") { $category_id = !empty($_POST['category_id']) ? intval($_POST['category_id']) : 0; if ($category_id > 0) { $contents_nohtml = !empty($_POST['contents_nohtml']) ? 1 : 0; $contents_nosmiley = !empty($_POST['contents_nosmiley']) ? 1 : 0; $contents_noxcode = !empty($_POST['contents_noxcode']) ? 1 : 0; $contents_visible = !empty($_POST['contents_visible']) ? 1 : 0; $contents_order = !empty($_POST['contents_order']) ? intval($_POST['contents_order']) : 0; $myts =& MyTextSanitizer::getInstance(); $title = $myts->stripSlashesGPC($_POST['contents_title']); $contents = $myts->makeTareaData4Save($_POST['contents_contents']); $newid = $xoopsDB->genId($xoopsDB->prefix("xoopsfaq_contents")."_contents_id_seq"); $sql = "INSERT INTO ".$xoopsDB->prefix("xoopsfaq_contents")." (contents_id, category_id, contents_title, contents_contents, contents_time, contents_order, contents_visible, contents_nohtml, contents_nosmiley, contents_noxcode) VALUES ($newid, $category_id, ".$xoopsDB->quoteString($title).", ".$xoopsDB->quoteString($contents).", ".time().", ".$contents_order.", ".$contents_visible.", ".$contents_nohtml.", ".$contents_nosmiley.", ".$contents_noxcode.")"; if (!$xoopsDB->query($sql)) { xoops_cp_header(); echo "Could not add contents"; xoops_cp_footer(); } else { redirect_header("index.php?op=listcontents&cat_id=$category_id",1,_XD_DBSUCCESS); } } exit(); } if ($op == "editcontents") { $id = !empty($_GET['id']) ? intval($_GET['id']) : 0; if ($id <= 0 || $cat_id <= 0) { exit(); } $myts =& MyTextSanitizer::getInstance(); xoops_cp_header(); $sql = "SELECT category_title FROM ".$xoopsDB->prefix("xoopsfaq_categories")." WHERE category_id=".$cat_id; $result = $xoopsDB->query($sql); list($category) = $xoopsDB->fetchRow($result); $category = $myts->makeTboxData4Show($category); $result = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("xoopsfaq_contents")." WHERE contents_id=$id"); $myrow = $xoopsDB->fetchArray($result); $contents_title = $myts->makeTboxData4Edit($myrow['contents_title']); $contents_contents = $myts->makeTareaData4Edit($myrow['contents_contents']); $contents_order = $myrow['contents_order']; $contents_visible = $myrow['contents_visible']; $contents_nohtml = $myrow['contents_nohtml']; $contents_nosmiley = $myrow['contents_nosmiley']; $contents_noxcode = $myrow['contents_noxcode']; $contents_id = $myrow['contents_id']; $category_id = $myrow['category_id']; $op = "editcontentsgo"; echo "" ._XD_MAIN." »» ".$category." »» "._XD_EDITCONTENTS."

"._XD_EDITCONTENTS."

"; include "contentsform.php"; xoops_cp_footer(); exit(); } if ($op == "editcontentsgo") { $contents_id = !empty($_POST['contents_id']) ? intval($_POST['contents_id']) : 0; $myts =& MyTextSanitizer::getInstance(); $title = !empty($_POST['contents_title']) ? $myts->stripSlashesGPC($_POST['contents_title']) : ''; $contents = !empty($_POST['contents_contents']) ? $myts->stripSlashesGPC($_POST['contents_contents']) : ''; $contents_nohtml = empty($_POST['contents_nohtml']) ? 0 : 1; $contents_nosmiley = empty($_POST['contents_nosmiley']) ? 0 : 1; $contents_noxcode = empty($_POST['contents_noxcode']) ? 0 : 1; $contents_visible = !empty($_POST['contents_visible']) ? 1 : 0; $contents_order = !empty($_POST['contents_order']) ? intval($_POST['contents_order']) : 0; $sql = "UPDATE ".$xoopsDB->prefix("xoopsfaq_contents")." set contents_title=".$xoopsDB->quoteSTring($title).", contents_contents=".$xoopsDB->quoteSTring($contents).", contents_time=".time().", contents_order=".$contents_order.", contents_visible=".$contents_visible.", contents_nohtml=".$contents_nohtml.", contents_nosmiley=".$contents_nosmiley.", contents_noxcode=".$contents_noxcode." WHERE contents_id=".$contents_id; if (!$xoopsDB->query($sql)) { xoops_cp_header(); echo "Could not update contents"; xoops_cp_footer(); } else { redirect_header("index.php?op=listcontents&cat_id=".intval($_POST['category_id']),1,_XD_DBSUCCESS); } exit(); } if ($op == "delcatgo") { $cat_id = !empty($_POST['cat_id']) ? intval($_POST['cat_id']) : 0; if ($cat_id <= 0) { exit(); } $sql = sprintf("DELETE FROM %s WHERE category_id = %u", $xoopsDB->prefix("xoopsfaq_categories"), $cat_id); if (!$xoopsDB->query($sql)) { xoops_cp_header(); echo "Could not delete category"; xoops_cp_footer(); } else { $sql = sprintf("DELETE FROM %s WHERE category_id = %u", $xoopsDB->prefix("xoopsfaq_contents"), $cat_id); $xoopsDB->query($sql); // delete comments xoops_comment_delete($xoopsModule->getVar('mid'), $cat_id); redirect_header("index.php?op=listcat",1,_XD_DBSUCCESS); } exit(); } if ($op == 'delcat') { xoops_cp_header(); xoops_confirm(array('op' => 'delcatgo', 'cat_id' => $cat_id), 'index.php', _XD_RUSURECAT); xoops_cp_footer(); exit(); } if ($op == "delcontentsgo") { $id = !empty($_POST['id']) ? intval($_POST['id']) : 0; if ($id <= 0) { exit(); } $sql = sprintf("DELETE FROM %s WHERE contents_id = %u", $xoopsDB->prefix("xoopsfaq_contents"), $id); if (!$xoopsDB->query($sql)) { xoops_cp_header(); echo "Could not delete contents"; xoops_cp_footer(); } else { redirect_header("index.php?op=listcontents&cat_id=".intval($_POST['cat_id']),1,_XD_DBSUCCESS); } exit(); } if ($op == "delcontents") { $id = !empty($_GET['id']) ? intval($_GET['id']) : 0; xoops_cp_header(); xoops_confirm(array('op' => 'delcontentsgo', 'id' => $id, 'cat_id' => $cat_id), 'index.php', _XD_RUSURECAT); xoops_cp_footer(); exit(); } ?>