<?php
/***************************************************************************
                          admin_forums.php  -  description
                             -------------------
    begin                : Wed July 19 2000
    copyright            : (C) 2001 The phpBB Group
    email                : support@phpbb.com

    $Id: admin_forums.php,v 1.2.6.2.2.1 2005/06/11 02:50:12 onokazu Exp $
 ***************************************************************************/

/***************************************************************************
 *
 *   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.
 *
 ***************************************************************************/

include '../../../include/cp_header.php';
include '../functions.php';
include '../config.php';

if (!empty($_GET['mode'])){
    $mode = $_GET['mode'];
} elseif (!empty($_POST['mode'])) {
    $mode = $_POST['mode'];
}

switch (trim($mode)) {
case 'editforum':
    $myts =& MyTextSanitizer::getInstance();
    if ( isset($_POST['save']) && $_POST['save'] != "" ) {
        if ( empty($_POST['delete']) ) {
            foreach (array('name', 'desc') as $k) {
                $$k = !empty($_POST[$k]) ? trim($myts->stripSlashesGPC($_POST[$k])) : '';
            }
            foreach (array('type', 'cat', 'forum_access', 'html', 'sig', 'ppp', 'hot', 'tpp', 'forum') as $k) {
                $$k = !empty($_POST[$k]) ? intval($_POST[$k]) : 0;
            }
            $sql = sprintf("UPDATE %s SET forum_name = %s, forum_desc = %s, forum_type = %s, cat_id = %u, forum_access = %u, allow_html = %s, allow_sig = %s, posts_per_page = %u, hot_threshold = %u, topics_per_page = %u WHERE forum_id = %u", $xoopsDB->prefix("bb_forums"), $xoopsDB->quoteString($name), $xoopsDB->quoteString($desc), $xoopsDB->quoteString($type), $cat, $forum_access, $xoopsDB->quoteString($html), $xoopsDB->quoteString($sig), $ppp, $hot, $tpp, $forum);

            if ( !$r = $xoopsDB->query($sql) ) {
                redirect_header("./index.php", 1);
                exit();
            }
            $count = 0;
            if ( isset($_POST["mods"]) ) {
                while ( list($null, $mod) = each($_POST["mods"]) ) {
                    $mod_data = new XoopsUser($mod);
                    if ( $mod_data->isActive() ) {
                        $sql = sprintf("INSERT INTO %s (forum_id, user_id) VALUES (%u, %u)", $xoopsDB->prefix("bb_forum_mods"), $forum, $mod);
                        if ( !$xoopsDB->query($sql) ) {
                            redirect_header("./index.php", 1);
                            exit();
                        }
                    }
                }
            }
            if (empty($_POST["mods"])) {
                $current_mods = "SELECT count(*) AS total FROM ".$xoopsDB->prefix("bb_forum_mods")." WHERE forum_id = $forum";
                $r = $xoopsDB->query($current_mods);
                list($total) = $xoopsDB->fetchRow($r);
            } else {
                $total = count($_POST["mods"]) + 1;
            }

            if ( !empty($_POST["rem_mods"]) && $total > 1 ) {
                while ( list($null, $mod) = each($_POST["rem_mods"]) ) {
                    $sql = sprintf("DELETE FROM %s WHERE forum_id = %u AND user_id = %u", $xoopsDB->prefix("bb_forum_mods"), $forum, $mod);
                    if ( !$xoopsDB->query($sql) ) {
                        redirect_header("./index.php", 1);
                        exit();
                    }
                }
            } else {
                if (!empty($_POST["rem_mods"])) {
                    $mod_not_removed = 1;
                }
            }
            if (!empty($mod_not_removed)) {
                redirect_header("./index.php", 1, _MD_A_FORUMUPDATED."<br />"._MD_A_HTSMHNBRBITHBTWNLBAMOTF);
            }else{
                redirect_header("./index.php", 1, _MD_A_FORUMUPDATED);
            }
        } else {
            $forum = !empty($_POST['forum']) ? intval($_POST['forum']) : 0;
            $sql = "SELECT post_id FROM ".$xoopsDB->prefix("bb_posts")." WHERE forum_id = $forum";
            if ( !$r = $xoopsDB->query($sql) ) {
                redirect_header("./index.php", 1);
                exit();
            }
            if ( $xoopsDB->getRowsNum($r) > 0 ) {
                $sql = "DELETE FROM ".$xoopsDB->prefix("bb_posts_text")." WHERE ";
                $looped = false;
                while ( $ids = $xoopsDB->fetchArray($r) ) {
                    if ( $looped == true ) {
                        $sql .= " OR ";
                    }
                    $sql .= "post_id = ".$ids["post_id"]." ";
                    $looped = true;
                }
                if ( !$r = $xoopsDB->query($sql) ) {
                    redirect_header("./index.php", 1);
                    exit();
                }
                $sql = sprintf("DELETE FROM %s WHERE forum_id = %u", $xoopsDB->prefix("bb_posts"), $forum);
                if ( !$r = $xoopsDB->query($sql) ) {
                    redirect_header("./index.php", 1);
                    exit();
                }
            }
            // RMV-NOTIFY
            xoops_notification_deletebyitem ($xoopsModule->getVar('mid'), 'forum', $forum);
            // Get list of all topics in forum, to delete them too
            $sql = sprintf("SELECT topic_id FROM %s WHERE forum_id = %u", $xoopsDB->prefix("bb_topics"), $forum);
            if ($r = $xoopsDB->query($sql)) {
                while ($row = $xoopsDB->fetchArray($r)) {
                    xoops_notification_deletebyitem ($xoopsModule->getVar('mid'), 'thread', $row['topic_id']);
                }
            }

            $sql = sprintf("DELETE FROM %s WHERE forum_id = %u", $xoopsDB->prefix("bb_topics"), $forum);
            if ( !$r = $xoopsDB->query($sql) ) {
                redirect_header("./index.php", 1);
                exit();
            }
            $sql = sprintf("DELETE FROM %s WHERE forum_id = %u", $xoopsDB->prefix("bb_forums"), $forum);
            if ( !$r = $xoopsDB->query($sql) ) {
                redirect_header("./index.php", 1);
                exit();
            }

            $sql = sprintf("DELETE FROM %s WHERE forum_id = %u", $xoopsDB->prefix("bb_forum_mods"), $forum);
            if ( !$r = $xoopsDB->query($sql) ) {
                redirect_header("./index.php", 1);
                exit();
            }
            redirect_header("./index.php", 1, _MD_A_FORUMREMOVED);
        }
    }
    if ( isset($_POST['submit']) && !isset($_POST['save']) ) {
        $forum = !empty($_POST['forum']) ? intval($_POST['forum']) : 0;
        $sql = "SELECT * FROM ".$xoopsDB->prefix("bb_forums")." WHERE forum_id = $forum";
        if ( !$result = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        if ( !$myrow = $xoopsDB->fetchArray($result) ) {
             redirect_header("./index.php", 1, _MD_A_NOSUCHFORUM);
        }
        $name = $myts->makeTboxData4Edit($myrow['forum_name']);
        $desc = $myts->makeTareaData4Edit($myrow['forum_desc']);
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' valign="top" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_EDITTHISFORUM;?></b></span></td>
        </tr>
        <tr class='bg1' align='left'>
        <td colspan=2><input type="checkbox" name='delete' value="1" /><span class='fg2'> <?php echo _MD_A_DTFTWARAPITF;?></span></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_FORUMNAME;?></span></td>
        <td><input type='text' name='name' size="40" maxlength="150" value="<?php echo $name?>" /></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_FORUMDESCRIPTION;?></span></td>
        <td><textarea name='desc' rows="15" cols="45" wrap="virtual"><?php echo $desc?></textarea></td>
        </tr>
        <tr class='bg1' align='left'>
        <td valign="top"><span class='fg2'><?php echo _MD_A_MODERATOR;?></span></td>
        <td><b>Current:</b><br />
        <?php
        $sql = "SELECT u.uname, u.uid FROM ".$xoopsDB->prefix("users")." u, ".$xoopsDB->prefix("bb_forum_mods")." f WHERE f.forum_id = $forum AND u.uid = f.user_id";
        if ( !$r = $xoopsDB->query($sql) ) {
            echo"</td></tr></table></td></tr></table></form></td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        $current_mods = array();
        if ( $row = $xoopsDB->fetchArray($r) ) {
            do {
                echo $row['uname']." (<input type=\"checkbox\" name=\"rem_mods[]\" value=\"".$row['uid']."\" /> "._MD_A_REMOVE.")<br />";
                $current_mods[] = $row['uid'];
            } while ( $row = $xoopsDB->fetchArray($r) );
            echo "<br />";
        } else {
            echo _MD_A_NOMODERATORASSIGNED."<br /><br />\n";
        }

        ?>
        <b>Add:</b><br />
        <select name='mods[]' size="5" multiple>
        <?php
        $sql = "SELECT uid, uname FROM ".$xoopsDB->prefix("users")." WHERE uid > 0 AND level > 0 ";
        while ( list($null, $currMod) = each($current_mods) ) {
            $sql .= "AND uid != $currMod ";
        }
        $sql .= "ORDER BY uname";
        if ( !$r = $xoopsDB->query($sql) ) {
            echo"</td></tr></table></td></tr></table></form></td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        if ( $row = $xoopsDB->fetchArray($r) ) {
            do {
                $s = "";
                if ( $row['uid'] == $myrow['forum_moderator'] ) {
                    $s = " selected='selected'";
                }
                echo "<option value=\"".$row['uid']."\"$s>".$row['uname']."</option>\n";
            } while ( $row = $xoopsDB->fetchArray($r) );
        } else {
            echo "<option value=\"0\">"._MD_A_NONE."</option>\n";
        }
        ?>
        </select></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_CATEGORY;?></span></td>
        <td><select name='cat'>
        <?php
        $sql = "SELECT * FROM ".$xoopsDB->prefix("bb_categories")."";
        if ( !$r = $xoopsDB->query($sql) ) {
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        if ( $row = $xoopsDB->fetchArray($r) ) {
            do {
                $s = "";
                if ( $row['cat_id'] == $myrow['cat_id'] ) {
                    $s = " selected='selected'";
                }
                echo "<option value=\"".$row['cat_id']."\"$s>".$row['cat_title']."</option>\n";
            } while ( $row = $xoopsDB->fetchArray($r) );
        } else {
            echo "<option value=\"0\">"._MD_A_NONE."</option>\n";
        }
        ?>
        </select></td>
        <?php
        $access1 = $access2 = $access3 = '';
        if ( $myrow['forum_access'] == 1 ) {
            $access1 = " selected='selected'";
        }
        if ( $myrow['forum_access'] == 2 ) {
            $access2 = " selected='selected'";
        }
        if ( $myrow['forum_access'] == 3 ) {
            $access3 = " selected='selected'";
        }
        ?>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'>Access Level:</span></td>
        <td><select name='forum_access'>
        <option value="2"<?php echo $access2?>><?php echo _MD_A_ANONYMOUSPOST;?></option>
        <option value="1"<?php echo $access1?>><?php echo _MD_A_REGISTERUSERONLY;?></option>
        <option value="3"<?php echo $access3?>><?php echo _MD_A_MODERATORANDADMINONLY;?></option>
        </select>
        </td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_TYPE;?></span></td>
        <td><select name='type'>
        <?php
        $pub = $priv = '';
        if ( $myrow['forum_type'] == 1 ) {
            $priv = " selected='selected'";
        } else {
            $pub = " selected='selected'";
        }
        ?>
        <option value="0"<?php echo $pub?>><?php echo _MD_A_PUBLIC;?></option>
        <option value="1"<?php echo $priv?>><?php echo _MD_A_PRIVATE;?></option>
        </select>
        </td>
        </tr>
        <?php
        $html_yes = $html_no = $sig_yes = $sig_no = "";
        if ( $myrow['allow_html'] == 1 ) {
            $html_yes = " checked='checked'";
        } else {
            $html_no = " checked='checked'";
        }
        if ( $myrow['allow_sig'] == 1) {
            $sig_yes = " checked='checked'";
        } else {
            $sig_no = " checked='checked'";
        }
        echo "<tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_ALLOWHTML ."</span></td>          <td><input type='radio' name='html' value='1'".$html_yes." />"._MD_A_YES."<input type='radio' name='html' value='0'".$html_no." />"._MD_A_NO ."</td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_ALLOWSIGNATURES ."</span></td>
        <td><input type='radio' name='sig' value='1'$sig_yes />". _MD_A_YES ."<input type='radio' name='sig' value='0'$sig_no />". _MD_A_NO ."</td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_HOTTOPICTHRESHOLD ."</span></td><td><input type='text' name='hot' size='3' maxlength='3' value='". $myrow['hot_threshold']."' /></td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_POSTPERPAGE ."</span><br /><span class='fg2'><i>". _MD_A_TITNOPPTTWBDPPOT ."</i></span></td>
        <td><input type='text' name='ppp' size='3' maxlength='3' value='".$myrow['posts_per_page']."' /></td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_TOPICPERFORUM ."</span><br /><span class='fg2'><i>". _MD_A_TITNOTPFTWBDPPOAF ."</i></span></td><td><input type='text' name='tpp' size='3' maxlength='3' value='". $myrow['topics_per_page'] ."' /></td></tr>";
        echo "<tr class='bg3' align='left'><td align='center' colspan='2'><input type='hidden' name='mode' value='editforum' /><input type='hidden' name='forum' value='$forum' /><input type='submit' name='save' value='". _MD_A_SAVECHANGES ."' />&nbsp;&nbsp;<input type='reset' value='". _MD_A_CLEAR ."' /></td></tr>";
        echo "</table></td></tr></table></form>";
    }
    if ( !isset($_POST['submit']) && !isset($_POST['save']) ) {
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' valign="TOP" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_SELECTFORUMEDIT;?></b><span class='fg2'></td>
        </tr>
        <tr class='bg1' align='left'>
        <td align='center' colspan="2"><select name='forum' size="0">
        <?php
        $sql = "SELECT forum_name, forum_id FROM ".$xoopsDB->prefix("bb_forums")." ORDER BY forum_id";
        if ( $result = $xoopsDB->query($sql) ) {
            if ( $myrow = $xoopsDB->fetchArray($result) ) {
                do {
                    $name = $myts->makeTboxData4Show($myrow['forum_name']);
                    echo "<option value=\"".$myrow['forum_id']."\">$name</option>\n";
                } while ( $myrow = $xoopsDB->fetchArray($result) );
            } else {
                echo "<option value=\"-1\">"._MD_A_NOFORUMINDATABASE."</option>\n";
            }
        } else {
            echo "<option value=\"-1\">"._MD_A_DATABASEERROR."</option>\n";
        }
        ?>
        </select></td>
        </tr>
        <tr class='bg3' align='left'>
        <td align='center' colspan="2">
        <input type="hidden" name='mode' value="editforum" />
        <input type='submit' name='submit' value="<?php echo _MD_A_EDIT;?>" />&nbsp;&nbsp;
        </td>
        </tr>
        </table></td></tr></table></form>
        <?php
    }
    break;

case 'editcat':
    $myts =& MyTextSanitizer::getInstance();
    if ( isset($_POST['submit']) && isset($_POST['save']) ) {
        $new_title = $myts->stripSlashesGPC($_POST['new_title']);
        $cat_id = !empty($_POST['cat_id']) ? intval($_POST['cat_id']) : 0;
        $sql = "UPDATE ".$xoopsDB->prefix("bb_categories")." SET cat_title = ".$xoopsDB->quoteString($new_title)." WHERE cat_id = $cat_id";
        if ( !$result = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        } else {
            redirect_header("./index.php", 1, _MD_A_CATEGORYUPDATED);
        }
    } else if(isset($_POST['submit']) && $_POST['submit'] != "") {
        $sql = "SELECT cat_title FROM ".$xoopsDB->prefix("bb_categories")." WHERE cat_id = ".intval($_POST['cat']);
        if ( !$result = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        $cat_data = $xoopsDB->fetchArray($result);
        $cat_title = $myts->makeTboxData4Edit($cat_data["cat_title"]);
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' valign="top" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_EDITCATEGORY;?> <?php echo $cat_title ?></b><span class='fg2'></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><?php echo _MD_A_CATEGORYTITLE;?></td>
        <td><input type="text" name="new_title" value="<?php echo $cat_title ?>" size="45" maxlength="100" /></td>
        </tr>
        <tr class='bg3' align='left'>
        <td align='center' colspan="2">
        <input type="hidden" name='mode' value="editcat" />
        <input type="hidden" name="save" value="true" />
        <input type="hidden" name="cat_id" value="<?php echo intval($_POST['cat']);?>" />
        <input type='submit' name='submit' value="<?php echo _MD_A_SAVECHANGES;?>" />
        </td>
        </tr>
        </table></td></tr></table></form>
        <?php
    } else {
        $sql = "SELECT cat_id, cat_title FROM ".$xoopsDB->prefix("bb_categories")." ORDER BY cat_order";
        if ( !$result = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' valign="top" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_SELECTACATEGORYEDIT;?></b><span class='fg2'></td>
        </tr>
        <tr class='bg1' align='left'>
        <td align='center' colspan="2"><select name='cat' size="0">
        <?php
        while ( $cat_data = $xoopsDB->fetchArray($result) ) {
            echo "<option value=\"".$cat_data["cat_id"]."\">".$myts->makeTboxData4Show($cat_data["cat_title"])."</option>\n";
        }
        ?>
        </select></td></tr>
        <tr class='bg3' align='left'>
        <td align='center' colspan="2">
        <input type="hidden" name='mode' value="editcat" />
        <input type='submit' name='submit' value="<?php echo _MD_A_EDIT;?>" />&nbsp;&nbsp;
        </td>
        </tr>
        </table></td></tr></table></form>
        <?php
    }
    break;
case 'remcat':
    $myts =& MyTextSanitizer::getInstance();
    if ( isset($_POST['submit']) && $_POST['submit'] != "" ) {
        $sql = sprintf("DELETE FROM %s WHERE cat_id = %u", $xoopsDB->prefix("bb_categories"), $_POST['cat']);
        if ( !$r = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        redirect_header("./index.php", 1, _MD_A_CATEGORYDELETED);
    } else {
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_RMVACAT;?></b></span></td>
        </tr>
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><i><?php echo _MD_A_NTWNRTFUTCYMDTVTEFS;?></i></span></td>
        </tr>
        <tr class='bg1'>
        <td align='center' colspan="2"><span class='fg2'>
        <select name='cat'>
        <?php
        $sql = "SELECT * FROM ".$xoopsDB->prefix("bb_categories")." ORDER BY cat_title";
        if ( !$r = $xoopsDB->query($sql) ) {
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        while (  $m = $xoopsDB->fetchArray($r) ) {
            echo "<option value=\"".$m['cat_id']."\">".$myts->makeTboxData4Show($m['cat_title'])."</option>\n";
        }
        ?>
        </select>
        <input type='hidden' name='mode' value='<?php echo $mode ?>' /></td>
        </tr>
        <tr class='bg3'>
        <td align='center' colspan="2"><span class='fg2'>
        <input type="submit" name="submit" value="<?php echo _MD_A_REMOVECATEGORY;?>" /></td></tr>
        </table></td></tr></table></form>
        <?php
    }
    break;
case 'addcat':
    $myts =& MyTextSanitizer::getInstance();
    if ( isset($_POST['submit']) && $_POST['submit'] != "" ) {
        $nextid = $xoopsDB->genId($xoopsDB->prefix("bb_categories")."_cat_id_seq");
        $sql = "SELECT max(cat_order) AS highest FROM ".$xoopsDB->prefix("bb_categories")."";
        if ( !$r = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        list($highest) = $xoopsDB->fetchRow($r);
        $highest++;
        $title = $myts->stripSlashesGPC($_POST['title']);
        $sql = sprintf("INSERT INTO %s (cat_id, cat_title, cat_order) VALUES (%u, %s, %u)", $xoopsDB->prefix("bb_categories"), $nextid, $xoopsDB->quoteString($title), $highest);
        if ( !$result = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        redirect_header("./index.php", 1, _MD_A_CATEGORYCREATED);
    } else {
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' valign="top" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_CREATENEWCATEGORY;?></b></span></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_CATEGORYTITLE;?></span></td>
        <td><input type="text" name="title" size="40" maxlength="100" /></td>
        </tr>
        <tr class='bg3' align="left">
        <td align='center' colspan="2">
        <input type="hidden" name="mode" value="addcat" />
        <input type="submit" name="submit" value="<?php echo _MD_A_CREATENEWCATEGORY;?>" />&nbsp;&nbsp;
        <input type="reset" value="<?php echo _MD_A_CLEAR;?>" />
        </td>
        </tr>
        </table></td></tr></table></form>
        <?php
    }
    break;
case 'addforum':
    $myts =& MyTextSanitizer::getInstance();
    if ( isset($_POST['submit']) && $_POST['submit'] != "" ) {
        foreach (array('name', 'desc') as $k) {
            $$k = !empty($_POST[$k]) ? trim($myts->stripSlashesGPC($_POST[$k])) : '';
        }
        foreach (array('type', 'cat', 'forum_access', 'html', 'sig', 'ppp', 'hot', 'tpp', 'forum') as $k) {
            $$k = !empty($_POST[$k]) ? intval($_POST[$k]) : 0;
        }
        $mods = !empty($_POST['mods']) ? $_POST['mods'] : array();
        if ( $name == '' || $desc == '' || empty($mods) ) {
            xoops_cp_header();
            echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
            ."<tr><td class=\"odd\">";
            echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
            echo _MD_A_YDNFOATPOTFDYAA;
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        $nextid = $xoopsDB->genId($xoopsDB->prefix("bb_forums")."_forum_id_seq");
        $sql = "INSERT INTO ".$xoopsDB->prefix("bb_forums")." (forum_id, forum_name, forum_desc, forum_access, cat_id, forum_type, allow_html, allow_sig,posts_per_page,hot_threshold,topics_per_page) VALUES ($nextid, ".$xoopsDB->quoteString($name).", ".$xoopsDB->quoteString($desc).", $forum_access, $cat, $type, ".$xoopsDB->quoteString($html).", ".$xoopsDB->quoteString($sig).", $ppp, $hot, $tpp)";
        if ( !$result = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        if ( $nextid == 0 ) {
            $nextid = $xoopsDB->getInsertId();
        }
        // RMV-NOTIFY
        $tags = array();
        $tags['FORUM_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/viewforum.php?forum=' . $nextid;
        $tags['FORUM_NAME'] = $name;
        $tags['FORUM_DESCRIPTION'] = $desc;
        $notification_handler =& xoops_gethandler('notification');
        $notification_handler->triggerEvents('global', 0, 'new_forum', $tags);

        $count = 0;
        while ( list($mod_number, $mod) = each($mods) ) {
            $mod = intval($mod);
            $mod_data = new XoopsUser($mod);
            if (is_object($mod_data) && $mod_data->isActive() && $mod_data->level() < 2 ) {
                if ( !isset($user_query) ) {
                    $user_query = "UPDATE ".$xoopsDB->prefix("users")." SET level = 2 WHERE ";
                }
                if ( $count > 0 ) {
                    $user_query .= "OR ";
                }
                $user_query .= "uid = $mod ";
                $count++;
            }
            $mod_query = "INSERT INTO ".$xoopsDB->prefix("bb_forum_mods")." (forum_id, user_id) VALUES ($nextid, $mod)";
            if ( !$xoopsDB->query($mod_query) ) {
                redirect_header("./index.php", 1);
                exit();
            }
        }

        if ( isset($user_query) ) {
            if ( !$xoopsDB->query($user_query) ) {
                redirect_header("./index.php", 1);
                exit();
            }
        }
        redirect_header("./index.php", 1, _MD_A_FORUMCREATED);
    } else {
        $sql = "SELECT count(*) AS total FROM ".$xoopsDB->prefix("bb_categories")."";
        if ( !$r = $xoopsDB->query($sql) ) {
            redirect_header("./index.php", 1);
            exit();
        }
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        list($total) = $xoopsDB->fetchRow($r);
        if ( $total < 1 || !isset($total) ) {
            echo _MD_A_EYMAACBYAF;
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        ?>
        <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
        <table border="0" cellpadding="1" cellspacing="0" align='center' valign="top" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td align='center' colspan="2"><span class='fg2'><b><?php echo _MD_A_CREATENEWFORUM;?></b></span></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_FORUMNAME;?></span></td>
        <td><input type='text' name='name' size="40" maxlength="150" /></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_FORUMDESCRIPTION;?></span></td>
        <td><textarea name='desc' rows="15" cols="45" wrap="virtual"></textarea></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_MODERATOR;?></span></td>
        <td><select name='mods[]' size='5' multiple='multiple'>
        <?php
        $sql = "SELECT uid, uname FROM ".$xoopsDB->prefix("users")." WHERE uid > 0 AND level > 0 ORDER BY uname";
        if ( !$result = $xoopsDB->query($sql) ) {
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        if ( $myrow = $xoopsDB->fetchArray($result) ) {
            do {
                echo "<option value=\"".$myrow['uid']."\">".$myrow['uname']."</option>\n";
            } while ( $myrow = $xoopsDB->fetchArray($result) );
        } else {
            echo "<option value=\"0\">"._MD_A_NONE."</option>\n";
        }
        ?>
        </select></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_CATEGORY;?></span></td>
        <td><select name="cat">
        <?php
        $sql = "SELECT * FROM ".$xoopsDB->prefix("bb_categories")."";
        if ( !$result = $xoopsDB->query($sql) ) {
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        if ( $myrow = $xoopsDB->fetchArray($result) ) {
            do {
                echo "<option value=\"".$myrow['cat_id']."\">".$myrow['cat_title']."</option>\n";
            } while ( $myrow = $xoopsDB->fetchArray($result) );
        } else {
            echo "<option value=\"0\">"._MD_A_NONE."</option>\n";
        }
        ?>
        </select></td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_ACCESSLEVEL;?></span></td>
        <td><select name="forum_access">
        <option value="2"><?php echo _MD_A_ANONYMOUSPOST;?></option>
        <option value="1"><?php echo _MD_A_REGISTERUSERONLY;?></option>
        <option value="3"><?php echo _MD_A_MODERATORANDADMINONLY;?></option>
        </select>
        </td>
        </tr>
        <tr class='bg1' align='left'>
        <td><span class='fg2'><?php echo _MD_A_TYPE;?></span></td>
        <td><select name="type">
        <option value="0"><?php echo _MD_A_PUBLIC;?></option>
        <option value="1"><?php echo _MD_A_PRIVATE;?></option>
        </select>
        </td>
        </tr>
        <?php
        echo "<tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_ALLOWHTML ."</span></td>          <td><input type='radio' name='html' value='1' />"._MD_A_YES."<input type='radio' name='html' value='0' checked='checked'  />"._MD_A_NO ."</td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_ALLOWSIGNATURES ."</span></td>
        <td><input type='radio' name='sig' value='1' checked='checked' />". _MD_A_YES ."<input type='radio' name='sig' value='0' />". _MD_A_NO ."</td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_HOTTOPICTHRESHOLD ."</span></td><td><input type='text' name='hot' size='3' maxlength='3' value='10' /></td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_POSTPERPAGE ."</span><br /><span class='fg2'><i>". _MD_A_TITNOPPTTWBDPPOT ."</i></span></td>
        <td><input type='text' name='ppp' size='3' maxlength='3' value='10' /></td></tr>
        <tr class='bg1' align='left'><td><span class='fg2'>". _MD_A_TOPICPERFORUM ."</span><br /><span class='fg2'><i>". _MD_A_TITNOTPFTWBDPPOAF ."</i></span></td><td><input type='text' name='tpp' size='3' maxlength='3' value='20' /></td></tr>";
        ?>
        <tr class='bg3' align='left'>
        <td align='center' colspan="2">
        <input type="hidden" name="mode" value="addforum" />
        <input type="submit" name="submit" value="<?php echo _MD_A_CREATENEWFORUM;?>" />&nbsp;&nbsp;
        <input type="reset" value="<?php echo _MD_A_CLEAR;?>" />
        </td>
        </tr>
        </table></td></tr></table></form>
        <?php
    }
    break;
case 'catorder':
    $myts =& MyTextSanitizer::getInstance();
    xoops_cp_header();
    echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
    ."<tr><td class=\"odd\">";
    echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
    $cat_id = !empty($_POST['cat_id']) ? intval($_POST['cat_id']) : 0;
    $last_id = !empty($_POST['last_id']) ? intval($_POST['last_id']) : 0;
    $current_order = !empty($_POST['current_order']) ? intval($_POST['current_order']) : 0;
    if (!empty($_POST['up'])) {
        if ( $current_order > 1 ) {
            $order = $current_order - 1;
            $sql1 = "UPDATE ".$xoopsDB->prefix("bb_categories")." SET cat_order = $order WHERE cat_id = $cat_id";
            if ( !$r = $xoopsDB->query($sql1) ) {
                echo"</td></tr></table>";
                xoops_cp_footer();
                exit();
            }
            $sql2 = "UPDATE ".$xoopsDB->prefix("bb_categories")." SET cat_order = $current_order WHERE cat_id = $last_id";
            if ( !$r = $xoopsDB->query($sql2) ) {
                echo"</td></tr></table>";
                xoops_cp_footer();
                exit();
            }
            echo "<div>"._MD_A_CATEGORYMOVEUP."</div><br />";
        } else {
            echo "<div>"._MD_A_TCIATHU."</div><br />";
        }
    } else if (!empty($_POST['down'])) {
        $sql = "SELECT cat_order FROM ".$xoopsDB->prefix("bb_categories")." ORDER BY cat_order DESC";
        if ( !$r  = $xoopsDB->query($sql,1,0) ) {
            echo"</td></tr></table>";
            xoops_cp_footer();
            exit();
        }
        list($last_number) = $xoopsDB->fetchRow($r);
        if ( $last_number != $current_order ) {
            $order = $current_order + 1;
            $sql = "UPDATE ".$xoopsDB->prefix("bb_categories")." SET cat_order = $current_order WHERE cat_order = $order";
            if ( !$r  = $xoopsDB->query($sql) ) {
                echo"</td></tr></table>";
                xoops_cp_footer();
                exit();
            }
            $sql = "UPDATE ".$xoopsDB->prefix("bb_categories")." SET cat_order = $order where cat_id = $cat_id";
            if ( !$r  = $xoopsDB->query($sql) ) {
                echo"</td></tr></table>";
                xoops_cp_footer();
                exit();
            }
            echo "<div>"._MD_A_CATEGORYMOVEDOWN."</div><br />";
        } else {
            echo "<div>"._MD_A_TCIATLD."</div><br />";
        }
    }
    ?>
    <form action="<?php echo $_SERVER['PHP_SELF'];?>" method='post'>
    <table border="0" cellpadding="1" cellspacing="0" align='center' valign="top" width="95%"><tr><td class='bg2'>
    <table border="0" cellpadding="1" cellspacing="1" width="100%">
    <tr class='bg3' align='left'>
    <td align='center' colspan="3"><span class='fg2'><b><?php echo _MD_A_SETCATEGORYORDER;?></b></span><br />
    <?php echo _MD_A_TODHITOTCWDOTIP;?><br />
    <?php echo _MD_A_ECWMTCPUODITO;?></td>
    </tr>
    <tr class='bg3' align='center'>
    <td><?php echo _MD_A_CATEGORY1;?></td><td><?php echo _MD_A_MOVEUP;?></td><td><?php echo _MD_A_MOVEDOWN;?></td>
    </tr>
    <?php
    $sql = "SELECT * FROM ".$xoopsDB->prefix("bb_categories")." ORDER BY cat_order";
    if ( !$r = $xoopsDB->query($sql) ) {
        exit();
    }
    while ( $m = $xoopsDB->fetchArray($r) ) {
        echo "<!-- New Row -->\n";
        echo "<form action=\"".$_SERVER['PHP_SELF']."\" METHOD=\"POST\">\n";
        echo "<tr class='bg1' align='center'>\n";
        echo "<td>".$myts->makeTboxData4Show($m['cat_title'])."</td>\n";
        echo "<td><input type=\"hidden\" name=\"mode\" value=\"$mode\" />\n";
        echo "<input type=\"hidden\" name=\"cat_id\" value=\"".$m['cat_id']."\" />\n";
        echo "<input type=\"hidden\" name=\"last_id\" value=\"";
        if ( isset($last_id) ) {
            echo $last_id;
        }
        echo "\" />\n";
        echo "<input type=\"hidden\" name=\"current_order\" value=\"".$m['cat_order']."\" /><input type=\"submit\" name=\"up\" value=\""._MD_A_MOVEUP."\" /></td>\n";
        echo "<td><input type=\"submit\" name=\"down\" value=\""._MD_A_MOVEDOWN."\" /></td></tr></form>\n<!-- End of Row -->\n";
        $last_id = $m['cat_id'];
    }
    ?>
    </table></td></tr></table></form>
    <?php
    break;
case 'sync':
    if ( !empty($_POST['submit']) ) {
        flush();
        sync(null, "all forums");
        flush();
        sync(null, "all topics");
        redirect_header("./index.php", 1, _MD_A_SYNCHING);
    } else {
        xoops_cp_header();
        echo"<table width='100%' border='0' cellspacing='1' class='outer'>"
        ."<tr><td class=\"odd\">";
        echo "<a href='./index.php'><h4>"._MD_A_FORUMCONF."</h4></a>";
        ?>
        <table border="0" cellpadding="1" cellspacing="0" align="center" width="95%"><tr><td class='bg2'>
        <table border="0" cellpadding="1" cellspacing="1" width="100%">
        <tr class='bg3' align='left'>
        <td><?php echo _MD_A_CLICKBELOWSYNC;?></td>
        </tr>
        <tr class='bg1' align='center'>
        <td><form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
        <input type="hidden" name="mode" value="<?php echo $mode?>" /><input type="submit" name="submit" value="<?php echo _MD_A_SYNCFORUM;?>" /></form></td>
        </td>
        </tr>
        </table>
        </td></tr></table>
        <?php
    }
    break;
}

echo"</td></tr></table>";
xoops_cp_footer();
?>
