Update of /cvsroot/pn-modules/PN_phpBB_14/html/modules/phpBB_14/admin/modules In directory usw-pr-cvs1:/tmp/cvs-serv1647 Added Files: CAdd.php CAddS.php CDel.php CEdit.php CEditF.php CEditS.php COrder.php COrderF.php COrderS.php FAdd.php FAddS.php FDel.php FEdit.php FEditF.php FEditS.php FOrder.php FOrderF.php FOrderS.php FPAssign.php FPAssignF.php FPAssignS.php FSync.php PEdit.php PEditS.php REdit.php REditS.php RHAssign.php RHAssignS.php RHEdit.php RHEditS.php Removed Files: phpBB_14_AddCategory.php phpBB_14_AddCategorySubmit.php phpBB_14_AddForum.php phpBB_14_AddForumSave.php phpBB_14_EditCategory.php phpBB_14_EditCategoryForm.php phpBB_14_EditCategorySave.php phpBB_14_EditForum.php phpBB_14_EditForumForm.php phpBB_14_EditForumSave.php phpBB_14_HonoraryRanks.php phpBB_14_HonoraryRanksAssign.php phpBB_14_HonoraryRanksAssignSave.php phpBB_14_HonoraryRanksSave.php phpBB_14_Preferences.php phpBB_14_PreferencesSave.php phpBB_14_PrivateForumAssign.php phpBB_14_PrivateForumAssignForm.php phpBB_14_PrivateForumAssignSave.php phpBB_14_Ranks.php phpBB_14_RanksSave.php phpBB_14_ReorderForums.php phpBB_14_ReorderForumsCat.php phpBB_14_ReorderForumsMove.php phpBB_14_SyncForums.php Log Message: moving to short names --- NEW FILE: CAdd.php --- <?php // $Id: CAdd.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_AddCategory() { global $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PHPBB_ADMINCATADD."</font></center><br><br>"; //show the form for adding a category echo "<form name=\"addcatform\" action=\"admin.php?op=phpBB_14_AddCategorySubmit\" method=\"post\">\n" ."<font class=\"pn-title\">"._CATEGORY.":</font><br>" ."<input type=\"text\" name=\"cat_title\" size=\"100\" maxlength=\"100\">\n" ."<input type=\"submit\" value=\"submit\">\n" ."</form>"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: CAddS.php --- <?php // $Id: CAddS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_AddCategorySubmit($cat_title) { global $bbtable; $cat_title = addslashes($cat_title); // compare ASAP $cat_title = StripSlashes(FixQuotes($cat_title)); $sql = "SELECT cat_id FROM $bbtable[categories]"; if(!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } $numcats = mysql_num_rows($result); $neworder = $numcats + 1; $sql = "INSERT INTO $bbtable[categories] (cat_title, cat_order) VALUES ('$cat_title', $neworder)"; if(!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } header("Location: admin.php?op=phpBB_14"); } ?> --- NEW FILE: CDel.php --- <?php // $Id: CDel.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_DeleteCategory($cat_id, $ok) { global $bbtable, $pntable, $hlpfile; if($ok=="1") { mysql_query("DELETE FROM $bbtable[forums] WHERE forum_id = $forum_id"); $result = mysql_query("SELECT post_id FROM $bbtable[posts] WHERE forum_id = $forum_id"); while(list($post_id) = mysql_fetch_row($result)) { mysql_query("DELETE FROM $bbtable[posts_text] WHERE post_id = $post_id"); mysql_query("DELETE FROM $bbtable[posts] WHERE post_id = $post_id"); } header("Location: admin.php?op=phpBB_14_SyncForums"); } else { include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo ""._PBOKTODELETE."<br>\n"; echo "<a class=\"pn-normal\" href=\"admin.php?op=phpBB_14_DeleteForum&forum_id=$forum_id&ok=1\">"._YES."</a> <a class=\"pn-normal\" href=\"admin.php?op=phpBB_14\">"._NO."</a>\n"; CloseTable(); include("footer.php"); } } /* case 'remcat': if($HTTP_POST_VARS['submit']) { $sql = "DELETE FROM $bbtable[categories] WHERE cat_id = '$cat'"; if(!$r = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); header("Location: $baseurl2&action=admin"); } else { include "$basepath/page_header.php"; print '<form action="modules.php" method="post">' ."<input type=\"hidden\" name=\"name\" value=\"$ModName\">" .'<input type="hidden" name="file" value="index">' .'<input type="hidden" name="op" value="modload">' .'<input type="hidden" name="action" value="admin_forums">' ; ?> <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%"><TR><TD BGCOLOR="<?php echo $bgcolor2?>"> <TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="100%"> <TR BGCOLOR="<?php echo $bgcolor2?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"><font class="pn-title">Remove a Category</FONT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"><font class="pn-normal"><i>Note: This will NOT remove the forums under the category, you must do that via the Edit Forum section.</i></FONT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor1?>"> <TD ALIGN="CENTER" COLSPAN="2"> <SELECT NAME="cat"> <?php $sql = "SELECT * FROM $bbtable[categories] ORDER BY cat_title"; if(!$r = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); while($m = mysql_fetch_array($r)) { echo "<OPTION VALUE=\"$m[cat_id]\">".stripslashes($m[cat_title])."</OPTION>\n"; } ?> </SELECT> <INPUT TYPE="HIDDEN" NAME="mode" VALUE="<?php echo $mode ?>"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>"> <TD ALIGN="CENTER" COLSPAN="2"> <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Remove Category"></TD></TR> </TABLE></TABLE></FORM> <?php } break; */ ?> --- NEW FILE: CEdit.php --- <?php // $Id: CEdit.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_EditCategory() { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PHPBB_ADMINCATEDIT."</font></center><br><br>"; //select a category to edit $sql = "SELECT cat_id, cat_title FROM $bbtable[categories] ORDER BY cat_order"; if(!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } echo "<font class=\"pn-title\">"._PHPBB_SELECTEDITCAT."</font><br>\n"; echo "<form name=\"addcatform\" action=\"admin.php?op=phpBB_14_EditCategoryForm\" method=\"post\">\n"; echo "<select name=\"cat_id\">"; while($cat_data = mysql_fetch_array($result)) { echo "<option value=\"".$cat_data["cat_id"]."\">".stripslashes($cat_data["cat_title"])."</option>\n"; } /* while(list($cat_id, $cat_title, $cat_order) = mysql_fetch_row($result)) { echo "<option value=\"$cat_id\">$cat_title</option>"; } */ echo "</select><br>\n" ; echo "<input type=\"radio\" name=\"actiontype\" value=\"Edit\" checked> "._EDIT." "; echo "<input type=\"radio\" name=\"actiontype\" value=\"Delete\"> "._DELETE."\n"; echo "<input type=\"submit\" value=\"Submit\">\n" ."</form>"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: CEditF.php --- <?php // $Id: CEditF.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_EditCategoryForm($cat_id,$actiontype) { global $bbtable, $hlpfile; switch($actiontype) { case 'Edit': include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PHPBB_EDITCAT."</font></center><br><br>"; $sql = "SELECT cat_title FROM $bbtable[categories] WHERE cat_id = $cat_id"; $result = mysql_query($sql); list($cat_title) = mysql_fetch_row($result); //show the form for editing a category echo "<form name=\"editcatform\" action=\"admin.php?op=phpBB_14_EditCategorySave\" method=\"post\">\n" ."<font class=\"pn-title\">"._PHPBB_CATEGORY.":</font><br>" ."<input type=\"text\" name=\"cat_title\" size=\"100\" maxlength=\"100\" value=\"$cat_title\">\n" ."<input type=\"hidden\" name=\"cat_id\" value=\"$cat_id\">" ."<input type=\"submit\" value=\"submit\">\n" ."</form>"; CloseTable(); include("footer.php"); break; case 'Delete': $sql = "DELETE FROM $bbtable[categories] WHERE cat_id = '$cat_id'"; if(!$r = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } header("Location: admin.php?op=phpBB_14"); } } ?> --- NEW FILE: CEditS.php --- <?php // $Id: CEditS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_EditCategorySave($cat_id, $cat_title) { global $bbtable; $cat_title = addslashes($cat_title); // compare ASAP $cat_title = StripSlashes(FixQuotes($cat_title)); $sql = "UPDATE $bbtable[categories] SET cat_title='$cat_title' WHERE cat_id = $cat_id"; $result = mysql_query($sql); header("Location: admin.php?op=phpBB_14"); } ?> --- NEW FILE: COrder.php --- <?php // $Id: COrder.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_ReorderForumsCat() { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PBREORDERFORUM."</font></center><br><br>"; $result = mysql_query("SELECT cat_id, cat_title FROM $bbtable[categories] ORDER BY cat_id"); echo "<font class=\"pn-title\">"._PBCHOOSECATREORDERFORUMS."</font><br>\n"; echo "<form name=\"forummods\" action=\"admin.php?op=phpBB_14_ReorderForums\" method=\"post\">\n"; echo "<select name=\"cat_id\">"; while(list($cat_id, $cat_title) = mysql_fetch_row($result)) { echo "<option value=\"$cat_id\">$cat_title</option>"; } echo "</select>\n"; echo "<input type=\"submit\" name=\"submit\" value=\"Submit\"></form>\n"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: COrderF.php --- <?php // $Id: COrderF.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_ReorderForums($cat_id) { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PBREORDERFORUM."</font></center><br><br>"; //list the categories to be reordered $result = mysql_query("SELECT forum_id, forum_name, forum_order FROM $bbtable[forums] WHERE cat_id='".$cat_id."' ORDER BY forum_order"); echo "<table width=\"100%\">"; $numforums = mysql_num_rows($result); $currentrow = 1; while(list($forum_id, $forum_name, $forum_order) = mysql_fetch_row($result)) { echo "<tr>"; echo "<td class=\"pn-normal\">$forum_name</td>"; if ($currentrow != 1) { echo "<td align=\"center\"><a class=\"pn-normal\" href=\"admin.php?op=phpBB_14_ReorderForumsMove&forum_id=$forum_id&forum_order=$forum_order&direction=up\">Move Up</a></td>"; }else{ echo "<td> </td>"; } if ($currentrow != $numforums) { echo "<td align=\"center\"><a class=\"pn-normal\" href=\"admin.php?op=phpBB_14_ReorderForumsMove&forum_id=$forum_id&forum_order=$forum_order&direction=down\">Move Down</td>"; }else{ echo "<td> </td>"; } echo "</tr>"; $currentrow++; } echo "</table>"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: COrderS.php --- <?php // $Id: COrderS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_ReorderForumsMove($forum_id, $forum_order, $direction) { global $bbtable; $foruminfo = mysql_query("SELECT cat_id FROM $bbtable[forums] WHERE forum_id = $forum_id"); list($forumcat) = mysql_fetch_row($foruminfo); if ($direction=='up') { if ($forum_order>1) { $order = $forum_order - 1; $sql = "UPDATE $bbtable[forums] SET forum_order = $order WHERE forum_id = '$forum_id'"; if (!$result = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); $sql = "UPDATE $bbtable[forums] SET forum_order=".$forum_order." WHERE forum_order=".$order." AND forum_id<>".$forum_id.""; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } } } else { $forums = mysql_query("SELECT forum_id FROM $bbtable[forums]"); $numforums = mysql_num_rows($forums); if ($forum_order < $numforums) { $newno = $forum_order + 1; $sql = "UPDATE $bbtable[forums] SET forum_order=$newno WHERE forum_id=$forum_id"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } $sql = "UPDATE $bbtable[forums] SET forum_order=".$forum_order." WHERE forum_order = ".$newno." AND forum_id<>".$forum_id.""; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } } } header("Location: admin.php?op=phpBB_14_ReorderForums&cat_id=$forumcat"); } ?> --- NEW FILE: FAdd.php --- <?php // $Id: FAdd.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_AddForum() { global $pntable, $bbtable, $bgcolor1,$bgcolor2,$bgcolor3; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; $sql = "SELECT count(*) AS total FROM $bbtable[categories]"; if(!$r = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } list($total) = mysql_fetch_array($r); if($total < 1 || !isset($total)) error_die(_PHPBB_CAT_NOEXIST); ?> <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="100%"> <TR> <TD BGCOLOR="<?php echo $bgcolor2?>"> <TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="100%"> <form name="createforumform" action="admin.php?op=phpBB_14_AddForumSave" method="post"> <TR BGCOLOR="<?php echo $bgcolor2?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"><font class="pn-pagetitle"><?php echo _PHPBB_ADMINFORUMADD; ?></FONT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Forum Name:</FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="forum_name" SIZE="110" MAXLENGTH="150"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Forum Description:</FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><TEXTAREA NAME="desc" ROWS="5" COLS="90" WRAP="VIRTUAL"></TEXTAREA></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Moderator:</FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><SELECT NAME="mods[]" size="5" multiple> <?php $sql = "SELECT n.uid, n.uname FROM $pntable[users] AS n LEFT JOIN $bbtable[users] AS u ON u.user_id=n.uid WHERE n.uid != 1 AND u.user_level != -1 ORDER BY n.uname"; if(!$result = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); if($myrow = mysql_fetch_array($result)) { do { echo "<OPTION VALUE=\"".$myrow['uid']."\">".$myrow['uname']."</OPTION>\n"; } while($myrow = mysql_fetch_array($result)); } else { echo "<OPTION VALUE=\"0\">None</OPTION>\n"; } ?> </SELECT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Category:</FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><SELECT NAME="cat"> <?php $sql = "SELECT * FROM $bbtable[categories] "; if(!$result = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); if($myrow = mysql_fetch_array($result)) { do { echo "<OPTION VALUE=\"$myrow[cat_id]\">$myrow[cat_title]</OPTION>\n"; } while($myrow = mysql_fetch_array($result)); } else { echo "<OPTION VALUE=\"0\">None</OPTION>\n"; } ?> </SELECT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Access Level:</font></TD> <TD bgcolor="<?php echo $bgcolor1?>"><SELECT NAME="forum_access"> <OPTION VALUE="2">Anonymous Posting</OPTION> <OPTION VALUE="1">Registered users only</OPTION> <OPTION VALUE="3">Moderators/Administrators only</OPTION> </SELECT> </TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Type:</FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><SELECT NAME="type"> <OPTION VALUE="0">Public</OPTION> <OPTION VALUE="1">Private</OPTION> </SELECT> </TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"> <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Submit"> <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Submit"> </TD> </TR> </table> </TD> </TR> </table> <?php include("footer.php"); } ?> --- NEW FILE: FAddS.php --- <?php // $Id: FAddS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_AddForumSave($forum_id, $forum_name, $desc, $cat, $mods, $forum_access,$type) { global $bbtable, $pntable, $hlpfile; if($forum_name == '' || !is_array($mods)) error_die(_PHPBB_CREATEFORUM_INCOMPLETE); if (!$desc) { $desc = ''; } $desc = str_replace("\n", "<BR>", $desc); $desc = addslashes($desc); $forum_name = addslashes($forum_name); // $forum_desc = StripSlashes(FixQuotes($forum_desc)); // $forum_name = StripSlashes(FixQuotes($forum_name)); $sql = "SELECT max(forum_order) AS highest FROM $bbtable[forums] WHERE cat_id=$cat"; if(!$r = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } list($highest) = mysql_fetch_array($r); $highest++; $sql = "INSERT INTO $bbtable[forums] (forum_name, forum_desc, forum_access, cat_id, forum_type, forum_order) VALUES ('".$forum_name."', '".$desc."', '".$forum_access."', '".$cat."', '".$type."', '".$highest."')"; if(!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } $forum = mysql_insert_id(); $count = 0; while(list($mod_number, $mod) = each($mods)) { $mod_data = phpbb14_get_userdata_from_id($mod); if($mod_data['user_level'] < 2) { if(!isset($user_query)) $user_query = "UPDATE $bbtable[users] SET user_level = 2 WHERE "; if($count > 0) $user_query .= "OR "; $user_query .= "user_id = '$mod' "; $count++; } $mod_query = "INSERT INTO $bbtable[forum_mods] (forum_id, user_id) VALUES ('$forum', '$mod')"; if(!mysql_query($mod_query)) error_die(_PHPBB_ERROR_CONNECT,$mod_query,mysql_errno(),mysql_error()); } if(isset($user_query)) { if(!mysql_query($user_query)) error_die(_PHPBB_ERROR_CONNECT,$user_query,mysql_errno(),mysql_error()); } header("Location: admin.php?op=phpBB_14"); } ?> --- NEW FILE: FDel.php --- <?php // $Id: FDel.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_DeleteForum($forum_id, $ok) { global $bbtable, $pntable, $hlpfile; if($ok=="1") { mysql_query("DELETE FROM $bbtable[forums] WHERE forum_id = $forum_id"); $result = mysql_query("SELECT post_id FROM $bbtable[posts] WHERE forum_id = $forum_id"); while(list($post_id) = mysql_fetch_row($result)) { mysql_query("DELETE FROM $bbtable[posts_text] WHERE post_id = $post_id"); mysql_query("DELETE FROM $bbtable[posts] WHERE post_id = $post_id"); } header("Location: admin.php?op=phpBB_14_SyncForums"); } else { include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo ""._PBOKTODELETE."<br>\n"; echo "<a class=\"pn-normal\" href=\"admin.php?op=phpBB_14_DeleteForum&forum_id=$forum_id&ok=1\">"._YES."</a> <a class=\"pn-normal\" href=\"admin.php?op=phpBB_14\">"._NO."</a>\n"; CloseTable(); include("footer.php"); } } ?> --- NEW FILE: FEdit.php --- <?php // $Id: FEdit.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_EditForum() { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PBEDITFORUM."</font></center><br><br>\n"; echo "<font class=\"pn-title\">"._PBCHOOSEFORUMEDIT."</font><br>\n"; echo "<form name=\"editforum\" action=\"admin.php?op=phpBB_14_EditForumForm\" method=\"post\">\n"; echo "<select name=\"forum_id\">"; $sql = "SELECT f.forum_name, f.forum_id, c.cat_title FROM $bbtable[forums] AS f LEFT JOIN $bbtable[categories] AS c ON c.cat_id=f.cat_id ORDER BY c.cat_order, f.forum_order"; if(!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } if($myrow = mysql_fetch_array($result)) { do { $forum_name = stripslashes($myrow[cat_title]).""._PHPBB_SEPARATOR."".stripslashes($myrow[forum_name]); echo "<OPTION VALUE=\"$myrow[forum_id]\">$forum_name</OPTION>\n"; } while($myrow = mysql_fetch_array($result)); } else { echo "<OPTION VALUE=\"-1\">No Forums in Database</OPTION>\n"; } echo "</select><br>\n"; echo "<input type=\"radio\" name=\"actiontype\" value=\"EditForum\" checked> "._EDIT." "; echo "<input type=\"radio\" name=\"actiontype\" value=\"DeleteForum\"> "._DELETE."\n"; echo "<input type=\"submit\" value=\"Submit\"></form> \n"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: FEditF.php --- <?php // $Id: FEditF.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_EditForumForm($forum_id,$actiontype) { global $bbtable, $hlpfile, $pntable; if ($actiontype == "DeleteForum") { header("Location: admin.php?op=phpBB_14_DeleteForum&forum_id=".$forum_id."&ok=0"); } include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PHPBB_EDITFORUM."</font></center>"; //get the forum info from the id // $forumresult = mysql_query("SELECT forum_name, forum_desc, forum_readaccess, forum_cat_id, forum_writeaccess FROM $pntablemod[forums] WHERE forum_id = $forum_id"); // list($forum_name, $forum_desc, $forum_readaccess, $forum_cat_id, $forum_writeaccess) = mysql_fetch_row($forumresult); //form for adding forum information echo "<form name=\"editforumform\" action=\"admin.php?op=phpBB_14_EditForumSave\" method=\"post\">"; $sql = "SELECT * FROM $bbtable[forums] WHERE forum_id = '$forum_id'"; if(!$result = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); if(!$myrow = mysql_fetch_array($result)) { error_die( "No such forum"); } $forum_name = stripslashes($myrow['forum_name']); $desc = stripslashes($myrow['forum_desc']); ?> <TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="100%"> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Forum Name:</FONT></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="forum_name" SIZE="100" MAXLENGTH="150" VALUE="<?php echo $forum_name?>"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Forum Description:</FONT></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><TEXTAREA NAME="desc" ROWS="5" COLS="85" WRAP="soft"><?php echo $desc?></TEXTAREA></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD valign="top"><font class="pn-title">Moderator(s):</FONT></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><b>Current:</b><BR> <?php $sql = "SELECT u.uname, u.uid FROM $pntable[users] u, $bbtable[forum_mods] f WHERE f.forum_id = '$forum' AND u.uid = f.user_id"; if(!$r = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); if($row = mysql_fetch_array($r)) { do { echo $row['uname']." (<input type=\"checkbox\" name=\"rem_mods[]\" value=\"$row[uid]\"> Remove)<BR>"; $current_mods[] = $row['uid']; } while($row = mysql_fetch_array($r)); echo "<BR>"; } else { echo "No Moderators Assigned<BR><BR>\n"; } ?> <b>Add:</b><BR> <SELECT NAME="mods[]" size="5" multiple> <?php $sql = "SELECT n.uid, n.uname FROM $pntable[users] AS n LEFT JOIN $bbtable[users] AS u ON u.user_id=n.uid WHERE n.uid != 1 AND u.user_level != -1 "; while(list($null, $currMod) = each($current_mods)) { $sql .= "AND n.uid != $currMod "; } $sql .= "ORDER BY uname"; if(!$r = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); if($row = mysql_fetch_array($r)) { do { $s = ""; if($row[uid] == $myrow[forum_moderator]) $s = "SELECTED"; echo "<OPTION VALUE=\"$row[uid]\" $s>$row[uname]</OPTION>\n"; } while($row = mysql_fetch_array($r)); } else { echo "<OPTION VALUE=\"0\">None</OPTION>\n"; } ?> </SELECT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Category:</FONT></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><SELECT NAME="cat"> <?php $sql = "SELECT * FROM $bbtable[categories] "; if(!$r = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); if($row = mysql_fetch_array($r)) { do { $s = ""; if($row[cat_id] == $myrow[cat_id]) $s = "SELECTED"; echo "<OPTION VALUE=\"$row[cat_id]\" $s>$row[cat_title]</OPTION>\n"; } while($row = mysql_fetch_array($r)); } else { echo "<OPTION VALUE=\"0\">None</OPTION>\n"; } ?> </SELECT></TD> <?php if($myrow['forum_access'] == 1) $access1 = "SELECTED"; if($myrow['forum_access'] == 2) $access2 = "SELECTED"; if($myrow['forum_access'] == 3) $access3 = "SELECTED"; ?> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Access Level:</font></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><SELECT NAME="forum_access"> <OPTION VALUE="2" <?php echo $access2?>>Anonymous Posting</OPTION> <OPTION VALUE="1" <?php echo $access1?>>Registered users only</OPTION> <OPTION VALUE="3" <?php echo $access3?>>Moderators/Administrators only</OPTION> </SELECT> </TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><font class="pn-title">Type:</FONT></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><SELECT NAME="type"> <?php if($myrow[forum_type] == 1) $priv = "SELECTED"; else $pub = "SELECTED"; ?> <OPTION VALUE="0" <?php echo $pub?>>Public</OPTION> <OPTION VALUE="1" <?php echo $priv?>>Private</OPTION> </SELECT> </TD> </TR> <?php ?> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"> <INPUT TYPE="HIDDEN" NAME="forum_id" VALUE="<?php echo $forum_id?>"> <INPUT TYPE="SUBMIT" NAME="save" VALUE="Save Changes"> </TD> </TR> </TR> </form> </TABLE> <?php CloseTable(); include("footer.php"); } ?> --- NEW FILE: FEditS.php --- <?php // $Id: FEditS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; global $ModName; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_EditForumSave($forum_id, $forum_name, $desc, $cat, $mods, $forum_access, $type) { global $bbtable, $pntable; $forum_desc = StripSlashes(FixQuotes($desc)); $forum_name = StripSlashes(FixQuotes($forum_name)); $sql = "UPDATE $bbtable[forums] SET forum_name='".$forum_name."', forum_desc='".$desc."', forum_access='".$forum_access."', cat_id='".$cat."', forum_type='".$type."' WHERE forum_id=".$forum_id.""; if(!$result = mysql_query($sql)){ error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } header("Location: admin.php?op=phpBB_14"); } ?> --- NEW FILE: FOrder.php --- <?php // $Id: FOrder.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_ReorderForumsCat() { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PBREORDERFORUM."</font></center><br><br>"; $result = mysql_query("SELECT cat_id, cat_title FROM $bbtable[categories] ORDER BY cat_id"); echo "<font class=\"pn-title\">"._PBCHOOSECATREORDERFORUMS."</font><br>\n"; echo "<form name=\"forummods\" action=\"admin.php?op=phpBB_14_ReorderForums\" method=\"post\">\n"; echo "<select name=\"cat_id\">"; while(list($cat_id, $cat_title) = mysql_fetch_row($result)) { echo "<option value=\"$cat_id\">$cat_title</option>"; } echo "</select>\n"; echo "<input type=\"submit\" name=\"submit\" value=\"Submit\"></form>\n"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: FOrderF.php --- <?php // $Id: FOrderF.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_ReorderForums($cat_id) { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<center><font class=\"pn-title\">"._PBREORDERFORUM."</font></center><br><br>"; //list the categories to be reordered $result = mysql_query("SELECT forum_id, forum_name, forum_order FROM $bbtable[forums] WHERE cat_id='".$cat_id."' ORDER BY forum_order"); echo "<table width=\"100%\">"; $numforums = mysql_num_rows($result); $currentrow = 1; while(list($forum_id, $forum_name, $forum_order) = mysql_fetch_row($result)) { echo "<tr>"; echo "<td class=\"pn-normal\">$forum_name</td>"; if ($currentrow != 1) { echo "<td align=\"center\"><a class=\"pn-normal\" href=\"admin.php?op=phpBB_14_ReorderForumsMove&forum_id=$forum_id&forum_order=$forum_order&direction=up\">Move Up</a></td>"; }else{ echo "<td> </td>"; } if ($currentrow != $numforums) { echo "<td align=\"center\"><a class=\"pn-normal\" href=\"admin.php?op=phpBB_14_ReorderForumsMove&forum_id=$forum_id&forum_order=$forum_order&direction=down\">Move Down</td>"; }else{ echo "<td> </td>"; } echo "</tr>"; $currentrow++; } echo "</table>"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: FOrderS.php --- <?php // $Id: FOrderS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_ReorderForumsMove($forum_id, $forum_order, $direction) { global $bbtable; $foruminfo = mysql_query("SELECT cat_id FROM $bbtable[forums] WHERE forum_id = $forum_id"); list($forumcat) = mysql_fetch_row($foruminfo); if ($direction=='up') { if ($forum_order>1) { $order = $forum_order - 1; $sql = "UPDATE $bbtable[forums] SET forum_order = $order WHERE forum_id = '$forum_id'"; if (!$result = mysql_query($sql)) error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); $sql = "UPDATE $bbtable[forums] SET forum_order=".$forum_order." WHERE forum_order=".$order." AND forum_id<>".$forum_id.""; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } } } else { $forums = mysql_query("SELECT forum_id FROM $bbtable[forums]"); $numforums = mysql_num_rows($forums); if ($forum_order < $numforums) { $newno = $forum_order + 1; $sql = "UPDATE $bbtable[forums] SET forum_order=$newno WHERE forum_id=$forum_id"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } $sql = "UPDATE $bbtable[forums] SET forum_order=".$forum_order." WHERE forum_order = ".$newno." AND forum_id<>".$forum_id.""; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } } } header("Location: admin.php?op=phpBB_14_ReorderForums&cat_id=$forumcat"); } ?> --- NEW FILE: FPAssign.php --- <?php // $Id: FPAssign.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } // $index=True; // $hlpfile = "manual/phpBB_14.html"; modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_PrivateForumAssign() { global $bbtable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); $sql = "SELECT f.forum_name, f.forum_id, c.cat_title FROM $bbtable[forums] AS f LEFT JOIN $bbtable[categories] AS c ON c.cat_id=f.cat_id WHERE f.forum_type = 1 ORDER BY c.cat_order, f.forum_order"; if(!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } echo "<center><font class=\"pn-title\">"._PBEDITFORUM."</font></center><br><br>\n"; echo "<font class=\"pn-title\">"._PBCHOOSEFORUMEDIT."</font><br>\n"; echo "<form name=\"editforum\" action=\"admin.php?op=phpBB_14_PrivateForumAssignForm\" method=\"post\">\n"; echo "<select name=\"forum_id\">"; if($myrow = mysql_fetch_array($result)) { do { $forum_name = stripslashes($myrow['cat_title']).""._PHPBB_SEPARATOR."".stripslashes($myrow['forum_name']); echo "<OPTION VALUE=\"".$myrow['forum_id']."\">".$forum_name."</OPTION>\n"; } while($myrow = mysql_fetch_array($result)); } else { echo "<OPTION VALUE=\"-1\">No Forums in Database</OPTION>\n"; } echo "</select>\n"; echo "<input type=\"submit\" name=\"submit\" value=\""._PBEDITFORUM."\"></form> \n"; CloseTable(); include("footer.php"); } ?> --- NEW FILE: FPAssignF.php --- <?php // $Id: FPAssignF.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_PrivateForumAssignForm($forum_id) { global $bbtable, $pntable, $hlpfile; include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; $sql = "SELECT forum_name FROM $bbtable[forums] WHERE forum_id = $forum_id"; if ((!$result = mysql_query($sql)) || ($forum_id == -1)) { error_die(_PHPBB_ERROR_CONNECT, $sql,mysql_errno(),mysql_error()); } $forum_name = ""; if ($row = mysql_fetch_array($result)) { $forum_name = $row['forum_name']; } ?> <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" ALIGN="CENTER" VALIGN="TOP" WIDTH="<?php echo $TableWidth?>"> <TR> <TD BGCOLOR="<?php echo $bgcolor2?>"> <TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="100%"> <TR BGCOLOR="<?php echo $bgcolor2?>" ALIGN="LEFT"> <form name="editforum" action="admin.php?op=phpBB_14_PrivateForumAssignSave" method="post"> <td colspan="3" align="center"><font class="pn-title">Editing Forum Permissions for: <b><?php echo $forum_name?></b></font></td> </tr> <tr> <td bgcolor="<?php echo $bgcolor3?>" align="center" width="40%"> <font class="pn-title"> <b>Users Without Access:</b> </font> </TD> <TD bgcolor="<?php echo $bgcolor3?>" align="center" width="20%"> </TD> <TD bgcolor="<?php echo $bgcolor3?>" align="center"> <font class="pn-title"> <b>Users With Access:</b> </font> </TD> </TR> <TR> <TD VALIGN="TOP" bgcolor="<?php echo $bgcolor1?>" align="center" width="40%"> <font class="pn-title"> <SELECT NAME="userids[]" SIZE="20" MULTIPLE> <?php $sql = "SELECT u.uid FROM $pntable[users] AS u, $bbtable[forum_access] AS f WHERE (u.uid = f.user_id) AND (f.forum_id = '$forum_id')"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } $current_users = Array(); while ($row = mysql_fetch_array($result)) { $current_users[] = $row['uid']; } $sql = "SELECT n.uid, n.uname FROM $pntable[users] AS n LEFT JOIN $bbtable[users] AS u ON u.user_id=n.uid WHERE (n.uid != 1) AND (u.user_level != -1) "; while(list($null, $curr_userid) = each($current_users)) { $sql .= "AND (n.uid != '$curr_userid') "; } $sql .= "ORDER BY n.uname"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } while ($row = mysql_fetch_array($result)) { ?> <OPTION VALUE="<?php echo $row['uid'] ?>"> <?php echo $row['uname'] ?> </OPTION> <?php } ?> </SELECT> </TD> <TD bgcolor="<?php echo $bgcolor3?>" align="center"> <font class="pn-title"> <INPUT TYPE="HIDDEN" NAME="actiontype" VALUE="AddUser"> <INPUT TYPE="HIDDEN" NAME="forum_id" VALUE="<?php echo $forum_id ?>"> <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Add Users -->"> <br><br> <!-- <b><A HREF="<?php print "$baseurl&action=admin_priv_forums&forum=$forum&act=clearusers"?>">Clear all users</A></b> --> </font> </TD> <TD VALIGN="TOP" bgcolor="<?php echo $bgcolor1?>" align="center"> <?php $sql = "SELECT u.uname, u.uid, f.can_post FROM $pntable[users] AS u, $bbtable[forum_access] AS f WHERE (u.uid = f.user_id) AND (f.forum_id = $forum_id) ORDER BY u.uname"; if (!$result = mysql_query($sql)) { error_die (_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } ?> <TABLE BORDER="0" CELLPADDING="10" CELLSPACING="0"> <?php while ($row = mysql_fetch_array($result)) { $post_text = ($row[can_post]) ? "can" : "can't"; $post_text .= " post"; $post_toggle_link = "<A HREF=\"admin.php?op=phpBB_14_PrivateForumAssignSave&forum_id=$forum_id&op_userid=$row[uid]&actiontype="; if ($row[can_post]) { $post_toggle_link .= "RevokeUserPost\">revoke posting</A>"; } else { $post_toggle_link .= "GrantUserPost\">grant posting</A>"; } $remove_link = "<A HREF=\"admin.php?op=phpBB_14_PrivateForumAssignSave&forum_id=$forum_id&actiontype=DeleteUser&op_userid=$row[uid]\">remove</A>"; ?> <TR> <TD> <font class="pn-normal"> <b><?php echo $row['uname']?></b> </font> </TD> <TD> <font class="pn-normal"> <?php echo $post_text ?> </font> </TD> <TD> <font class="pn-normal"> <?php echo $post_toggle_link ?> </font> </TD> <TD> <font class="pn-normal"> <?php echo $remove_link ?> </font> </TD> <TR> <?php } ?> </TABLE> </TD> </FORM> </TR> </TABLE> </table> <?php include("footer.php"); } ?> --- NEW FILE: FPAssignS.php --- <?php // $Id: FPAssignS.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/functions.php"); function phpBB_14_PrivateForumAssignSave($forum_id, $op_userid, $userids, $actiontype) { global $pntable, $bbtable,$dbconn; switch($actiontype) { case 'AddUser': // Add user(s) to the list for this forum. if ($userids) { while(list($null, $curr_userid) = each($userids)) { $sql = "INSERT INTO $bbtable[forum_access] (forum_id, user_id, can_post) VALUES ($forum_id, $curr_userid, 0)"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } subscribe_forum($curr_userid, $forum_id); } } break; case 'DeleteUser': // Remove a user from the list for this forum. $sql = "DELETE FROM $bbtable[forum_access] WHERE (forum_id = $forum_id) AND (user_id = $op_userid)"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } unsubscribe_forum($op_userid, $forum_id); break; case 'ClearAllUsers': // Remove all users from the list for this forum. $sql = "DELETE FROM $bbtable[forum_access] WHERE (forum_id = $forum_id)"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } break; case 'GrantUserPost': // Add posting rights for this user in this forum. $sql = "UPDATE $bbtable[forum_access] SET can_post=1 WHERE (forum_id = ".$forum_id.") AND (user_id = ".$op_userid.")"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } break; case 'RevokeUserPost': // Revoke posting rights for this user in this forum. $sql = "UPDATE $bbtable[forum_access] SET can_post=0 WHERE (forum_id = $forum_id) AND (user_id = $op_userid)"; if (!$result = mysql_query($sql)) { error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error()); } break; } $post_toggle_link = "<A HREF=\"admin.php?op=phpBB_14_PrivateForumAssignSave&forum_id=$forum_id&op_userid=$row[uid]&actiontype="; header("Location: admin.php?op=phpBB_14_PrivateForumAssignForm&forum_id=".$forum_id.""); } ?> --- NEW FILE: FSync.php --- <?php // $Id: FSync.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); include("modules/$ModName/config.php"); include("modules/$ModName/functions.php"); function phpBB_14_SyncForums($silent=1) { global $bbtable, $hlpfile; if ($silent != 1) { include("header.php"); GraphicAdmin($hlpfile); opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); echo "<br>"; OpenTable(); echo "<div align=\"center\">Syncing forum index (This may take a while)<br>"; } flush(); sync(NULL, "all forums"); if ($silent != 1) { echo "Forum index synced<br>"; echo "Syncing topics (This may take longer!)<br>"; } flush(); sync(NULL, "all topics"); if ($silent != 1) { echo "Topics synced<br>"; } flush(); sync(NULL, "all posts"); if ($silent != 1) { echo "Posts counters synced<br>"; } flush(); sync(NULL, "users"); if ($silent != 1) { echo "Nuke and phpBB_14 users synced<br>"; echo "Done!</div>"; } } ?> --- NEW FILE: PEdit.php --- <?php // $Id: PEdit.php,v 1.1 2002/01/31 09:44:48 chv Exp $ if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); } if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { echo "Access Denied"; } modules_get_language(); include("modules/$ModName/phpBB_14tables.php"); function phpBB_14_Preferences() { global $pntable, $bbtable,$dbconn,$bgcolor2, $bgcolor3, $bgcolor1; include("header.php"); GraphicAdmin($hlpfile); $sql = "SELECT posts_per_page, hot_threshold, topics_per_page, email_from, default_lang FROM $bbtable[config]"; $result = $dbconn->Execute($sql); list($posts_per_page, $hot_threshold, $topics_per_page, $email_from, $default_lang) = $result->fields; opentable(); echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>"; closetable(); ?> <br> <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" ALIGN="CENTER" VALIGN="TOP" WIDTH="100%"> <form action="admin.php?op=phpBB_14_PreferencesSave" method="post"> <TR> <TD BGCOLOR="<?php echo $bgcolor2?>"> <TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="100%"> <TR BGCOLOR="<?php echo $bgcolor2?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"><FONT class="pn-pagetitle">Set Forum Wide Options</FONT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"><FONT class="pn-normal"><I>NOTE: These settings will be stored in the database and will override any settings in config.<?php // echo $phpEx?></I></FONT></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><FONT class="pn-title">Email From Address:</FONT><BR> <font class="pn-normal"><i>(This is the address that will appear on every email sent by the forums)</i></font></TD> <TD bgcolor="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="email_from" SIZE="30" MAXLENGTH="100" VALUE="<?php echo $email_from?>"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><FONT class="pn-title">Default charset:</FONT><BR> <font class="pn-normal"><i>(This is the chraset that will be used in e-mail headers)</i></font></TD> <TD bgcolor="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="default_lang" SIZE="30" MAXLENGTH="30" VALUE="<?php echo $default_lang; ?>"></TD> </TR> <!-- <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD valign="top"><FONT class="pn-title">Email Signature:</FONT><BR> <font class="pn-normal"><i>(This is the signature that will appear on every email sent by the forums)</i></font></TD> <TD bgcolor="<?php echo $bgcolor1?>"><TEXTAREA NAME="email_sig" ROWS="5" COLS="20"><?php echo stripslashes($email_sig)?></TEXTAREA></TD> </TR> --> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><FONT class="pn-title">Hot Topic Threshold:</FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="hot_threshold" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $hot_threshold?>"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><FONT class="pn-title">Posts per Page:</FONT><br> <FONT class="pn-normal"><I>(This is the number of posts per topic that will be displayed per page of a topic. 15 by default.)</I></FONT></TD> <TD bgcolor="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="posts_per_page" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $posts_per_page?>"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT"> <TD><FONT class="pn-title">Topics per Forum:</FONT><br> <FONT class="pn-normal"><I>(This is the number of topics per forum that will be displayed per page of a forum. 15 by default.)</I></FONT></TD> <TD BGCOLOR="<?php echo $bgcolor1?>"><INPUT TYPE="TEXT" NAME="topics_per_page" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $topics_per_page?>"></TD> </TR> <TR BGCOLOR="<?php echo $bgcolor1?>" ALIGN="LEFT"> <TD ALIGN="CENTER" COLSPAN="2"> <INPUT TYPE="SUBMIT" NAME="submit" VALUE="Save Changes"> </TD> </TR> </TABLE></TD></TR></TABLE> <?php CloseTable(); include("footer.php"); } ?> --- NEW FILE: PEditS.php --- <?php // ... [truncated message content] |