// // ------------------------------------------------------------------------ // // Based on: // // myPHPNUKE Web Portal System - http://myphpnuke.com/ // // PHP-NUKE Web Portal System - http://phpnuke.org/ // // Thatware - http://thatware.org/ // // ------------------------------------------------------------------------- // // 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"; } /*********************************************************/ /* Sections Manager Functions */ /*********************************************************/ function sections() { global $xoopsConfig, $xoopsDB, $xoopsModule; xoops_cp_header(); echo "

"._AM_SECCONF."

"; $result = $xoopsDB->query("select secid, secname from ".$xoopsDB->prefix("sections")." order by secid"); if ($xoopsDB->getRowsNum($result) > 0) { $myts =& MyTextSanitizer::getInstance(); echo "

"._MD_CURACTIVESEC."
"._MD_CLICK2EDIT."

"; echo "

".$secname."

"; echo "

"; ?>

"; ?>

query("select secid, secname from ".$xoopsDB->prefix("sections")." order by secid"); $checked = " checked='checked'"; // select first section by default while(list($secid, $secname) = $xoopsDB->fetchRow($result)) { $secname=$myts->makeTboxData4Show($secname); echo "$secname
"; $checked = ''; } ?>

$title ($secname) [ "._MD_EDIT." ]

"; ?> "; ?>

"; ?>

"._AM_SECCONF.""; $result = $xoopsDB->query("select artid, secid, title, content from ".$xoopsDB->prefix("seccont")." where artid='$artid'"); list($artid, $secid, $title, $content) = $xoopsDB->fetchRow($result); $title = $myts->makeTboxData4Edit($title); $content = $myts->makeTareaData4Edit($content); ?>

"; ?>

" />

query("select secid, secname from ".$xoopsDB->prefix("sections")." order by secname"); while(list($secid2, $secname) = $xoopsDB->fetchRow($result2)) { $secname = $myts->makeTboxData4Show($secname); if ($secid2==$secid) { $che = " checked='checked'"; } echo "$secname
"; $che = ""; } ?>

" />

"; ?> " />

"._AM_SECCONF."
"; $myts =& MyTextSanitizer::getInstance(); $result = $xoopsDB->query("select secid, secname, image from ".$xoopsDB->prefix("sections")." where secid=$secid"); list($secid, $secname, $image) = $xoopsDB->fetchRow($result); $secname = $myts->makeTboxData4Edit($secname); $image = $myts->makeTboxData4Edit($image); $result2 = $xoopsDB->query("select artid from ".$xoopsDB->prefix("seccont")." where secid=$secid"); $number = $xoopsDB->getRowsNum($result2); ?>

"; ?>

"; ?>

" />

" />

" />

"; ?> " />

stripSlashesGPC($_POST['secname']) : ''; if (empty($secname)) { redirect_header("index.php", 2, _MD_ERRORSECNAME); } $image = !empty($_POST['image']) ? $myts->stripSlashesGPC($_POST['image']) : ''; $newid = $xoopsDB->genId($xoopsDB->prefix("sections")."_secid_seq"); $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("sections")." (secid, secname, image) VALUES ($newid, ".$xoopsDB->quoteString($secname).", ".$xoopsDB->quoteString($image).")"); redirect_header("index.php?op=sections",2,_MD_DBUPDATED); break; case "secartdelete": xoops_cp_header(); echo "

"._AM_SECCONF."

"; $myts =& MyTextSanitizer::getInstance(); $artid = !empty($_POST['artid']) ? intval($_POST['artid']) : 0; $result = $xoopsDB->query("select title from ".$xoopsDB->prefix("seccont")." where artid=$artid"); list($title) = $xoopsDB->fetchRow($result); $title = $myts->makeTboxData4Show($title); xoops_confirm(array('op' => 'secartdelete_ok', 'artid' => $artid), 'index.php', sprintf(_MD_DELETETHISART,$title).'

'._MD_RUSUREDELART); break; case 'secartdelete_ok': $artid = !empty($_POST['artid']) ? intval($_POST['artid']) : 0; if ($artid <= 0) { redirect_header("index.php?op=sections",2,_MD_DBNOTUPDATED); } $sql = sprintf("DELETE FROM %s WHERE artid = %u", $xoopsDB->prefix("seccont"), $artid); $xoopsDB->query($sql); redirect_header("index.php?op=sections",2,_MD_DBUPDATED); break; case "sectionchange": if ($secid <= 0) { redirect_header("index.php?op=sections",2,_MD_DBNOTUPDATED); } $myts =& MyTextSanitizer::getInstance(); $secname = !empty($_POST['secname']) ? $myts->stripSlashesGPC($_POST['secname']) : ''; if (empty($secname)) { redirect_header("index.php", 2, _MD_ERRORSECNAME); } $image = !empty($_POST['image']) ? $myts->stripSlashesGPC($_POST['image']) : ''; $xoopsDB->query("update ".$xoopsDB->prefix("sections")." set secname=".$xoopsDB->quoteString($secname).", image=".$xoopsDB->quoteString($image)." where secid=$secid"); redirect_header("index.php?op=sections",2,_MD_DBUPDATED); break; case "secarticleadd": if ($secid <= 0) { redirect_header("index.php?op=sections",2,_MD_DBNOTUPDATED); } $myts =& MyTextSanitizer::getInstance(); $title = !empty($_POST['title']) ? $myts->stripSlashesGPC($_POST['title']) : ''; $content = !empty($_POST['content']) ? $myts->stripSlashesGPC($_POST['content']) : ''; $newid = $xoopsDB->genId($xoopsDB->prefix("seccont")."_artid_seq"); $success = $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("seccont")." (artid, secid, title, content, counter) VALUES ($newid, $secid, ".$xoopsDB->quoteString($title).", ".$xoopsDB->quoteString($content).", 0)"); if ( !$success ) { xoops_cp_header(); echo "

"; echo "

"._AM_SECCONF."

"; echo _MD_DBNOTUPDATED; echo"

"; xoops_cp_footer(); exit(); } redirect_header("index.php?op=sections",2,_MD_DBUPDATED); break; case "secartedit": $artid = !empty($_REQUEST['artid']) ? intval($_REQUEST['artid']) : 0; if ($artid > 0) { secartedit($artid); } break; case "secartchange": $artid = !empty($_POST['artid']) ? intval($_POST['artid']) : 0; if ($artid <= 0) { redirect_header("index.php?op=sections",2,_MD_DBNOTUPDATED); } $myts =& MyTextSanitizer::getInstance(); $title = !empty($_POST['title']) ? $myts->stripSlashesGPC($_POST['title']) : ''; $content = !empty($_POST['content']) ? $myts->stripSlashesGPC($_POST['content']) : ''; $xoopsDB->query("update ".$xoopsDB->prefix("seccont")." set secid=$secid, title=".$xoopsDB->quoteString($title).", content=".$xoopsDB->quoteString($content)." where artid=$artid"); redirect_header("index.php?op=sections",2,_MD_DBUPDATED); break; case "sectiondelete": xoops_cp_header(); echo "

"._AM_SECCONF."

"; xoops_confirm(array('op' => 'sectiondelete_ok', 'secid' => $secid), 'index.php', _MD_RUSUREDELSEC.'
'._MD_THISDELETESALL); break; case 'sectiondelete_ok': $sql = sprintf("DELETE FROM %s WHERE secid = %u", $xoopsDB->prefix("seccont"), $secid); $xoopsDB->query($sql); $sql = sprintf("DELETE FROM %s WHERE secid = %u", $xoopsDB->prefix("sections"), $secid); $xoopsDB->query($sql); redirect_header("index.php?op=sections",2,_MD_DBUPDATED); break; default: sections(); break; } xoops_cp_footer(); ?>