From 915a56c40eb0c7eef95f008d239022127d778ab0 Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Fri, 18 Dec 2009 11:01:59 +0000 Subject: [PATCH] Small bug fix. git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@423 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/admin/forums.php | 2 +- inc/forums.php | 1670 ++++++-------------------------------------------- inc/versioninfo.php | 4 +- 3 files changed, 190 insertions(+), 1486 deletions(-) diff --git a/inc/admin/forums.php b/inc/admin/forums.php index 451aa79..fc01794 100644 --- a/inc/admin/forums.php +++ b/inc/admin/forums.php @@ -11,7 +11,7 @@ Copyright 2004-2009 iDB Support - http://idb.berlios.de/ Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: forums.php - Last Update: 12/16/2009 SVN 412 - Author: cooldude2k $ + $FileInfo: forums.php - Last Update: 12/18/2009 SVN 421 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="forums.php"||$File3Name=="/forums.php") { diff --git a/inc/forums.php b/inc/forums.php index fc01794..f75713c 100644 --- a/inc/forums.php +++ b/inc/forums.php @@ -11,1505 +11,209 @@ Copyright 2004-2009 iDB Support - http://idb.berlios.de/ Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: forums.php - Last Update: 12/18/2009 SVN 421 - Author: cooldude2k $ + $FileInfo: forums.php - Last Update: 12/18/2009 SVN 423 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="forums.php"||$File3Name=="/forums.php") { - require('index.php'); - exit(); } - -// Check if we can goto admin cp -if($_SESSION['UserGroup']==$Settings['GuestGroup']||$GroupInfo['HasAdminCP']=="no") { -redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false)); -ob_clean(); header("Content-Type: text/plain; charset=".$Settings['charset']); -gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } -if(!isset($_POST['update'])) { $_POST['update'] = null; } -$Error = null; $errorstr = null; -?> - - - - + + + + + + -
- -
-">Fixing Reply User Names
- -
- - - -
- -
-">Recounting Topics
- - - - - - - - - - - - - - - -
-">Recounting Topics - 
- Recounting Topics: -  -
-
-
Forums Topics & Posts stats recounted.
- ">Click here to back to admin cp.
  -
-
 
-
- +
">Board index
+
 
+=1) { ?> -
+
-
-">Recounting Replies
+
+ +">
- +
- - - - - - - - + - - - - -
-">Recounting Replies - 
- Recounting Replies: -  -
-
-
Topics Replys stats recounted.
- ">Click here to back to admin cp.
  -
+
+">
 
-
- -
- -
-">Fixing Topic User Names
- - - - - - - - - - - - - - -
-">Fixing Topic User Names - 
- Fixing Topic User Names: -  -
-
-
Topic User Names fixed.
- ">Click here to back to admin cp.
  -
-
 
-
-" class="TableRow2"> +
 ForumTopicsPostsLast Topic
- - - - - - - - - - - - - -
-">Fixing Reply User Names - 
- Fixing Reply User Names: -  -
-
-
Reply User Names fixed.
- ">Click here to back to admin cp.
  -
-
 
- - -
- -
-">iDB Forum Manager
- - - - - - - - - - - - - - - -
-">iDB Forum Manager - 
- Adding new Forum: -  -
-
"> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
- - - - -
-
-
 
-
-\n"; } -if ($_POST['ForumDesc']==null) { $Error="Yes"; -$errorstr = $errorstr."You need to enter a description.
\n"; } -if ($_POST['ForumID']==null|| - !is_numeric($_POST['ForumID'])) { $Error="Yes"; -$errorstr = $errorstr."You need to enter a forum ID.
\n"; } -if($id_check > 0) { $Error="Yes"; -$errorstr = $errorstr."This ID number is already used.
\n"; } -if($order_check > 0) { $Error="Yes"; -$errorstr = $errorstr."This order number is already used.
\n"; } -if (pre_strlen($_POST['ForumName'])>"150") { $Error="Yes"; -$errorstr = $errorstr."Your Forum Name is too big.
\n"; } -if (pre_strlen($_POST['ForumDesc'])>"300") { $Error="Yes"; -$errorstr = $errorstr."Your Forum Description is too big.
\n"; } -if ($Error!="Yes") { -redirect("refresh",$basedir.url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin'],FALSE),"4"); -$admincptitle = " ".$ThemeSet['TitleDivider']." Updating Settings"; -$query = sql_pre_query("INSERT INTO \"".$Settings['sqltable']."forums\" (\"id\", \"CategoryID\", \"OrderID\", \"Name\", \"ShowForum\", \"ForumType\", \"InSubForum\", \"RedirectURL\", \"Redirects\", \"NumViews\", \"Description\", \"PostCountAdd\", \"PostCountView\", \"KarmaCountView\", \"CanHaveTopics\", \"HotTopicPosts\", \"NumPosts\", \"NumTopics\") VALUES\n". -"(%i, %i, %i, '%s', '%s', '%s', %i, '%s', 0, 0, '%s', '%s', %i, %i, '%s', %i, 0, 0)", array($_POST['ForumID'],$_POST['ForumCatID'],$_POST['OrderID'],$_POST['ForumName'],$_POST['ShowForum'],$_POST['ForumType'],$_POST['InSubForum'],$_POST['RedirectURL'],$_POST['ForumDesc'],$_POST['PostCountAdd'],$_POST['NumPostView'],$_POST['NumKarmaView'],$_POST['CanHaveTopics'],$_POST['NumPostHotTopic'])); -sql_query($query,$SQLStat); -if(!is_numeric($_POST['CPermissions'])) { $_POST['CPermissions'] = "0"; } -$getperidq = sql_pre_query("SELECT DISTINCT * FROM \"".$Settings['sqltable']."permissions\" ORDER BY \"PermissionID\" ASC", array(null)); -$getperidr=sql_query($getperidq,$SQLStat); -$getperidnum=sql_num_rows($getperidr); -$getperidi = 0; -$nextperid = null; -/* -if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli" - ||$Settings['sqltype']=="pgsql") { -$nextperid = sql_get_next_id($Settings['sqltable'],"permissions",$SQLStat); } -if($Settings['sqltype']=="sqlite") { -$nextperid = sql_get_next_id($Settings['sqltable'],"\"permissions\"",$SQLStat); } -*/ -while ($getperidi < $getperidnum) { -$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); -if($_POST['CPermissions']=="0") { -$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."permissions\" WHERE \"PermissionID\"=%i", array($getperidID)); } -if($_POST['CPermissions']!="0") { -$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."permissions\" WHERE \"PermissionID\"=%i AND \"ForumID\"=%i", array($getperidID,$_POST['CPermissions'])); } -$getperidr2=sql_query($getperidq2,$SQLStat); -$getperidnum2=sql_num_rows($getperidr2); -$PermissionNum=sql_result($getperidr2,0,"id"); -$PermissionID=sql_result($getperidr2,0,"PermissionID"); -$PermissionName=sql_result($getperidr2,0,"Name"); -$PermissionForumID=sql_result($getperidr2,0,"ForumID"); -$CanViewForum=sql_result($getperidr2,0,"CanViewForum"); -$CanMakeTopics=sql_result($getperidr2,0,"CanMakeTopics"); -$CanMakeReplys=sql_result($getperidr2,0,"CanMakeReplys"); -$CanMakeReplysCT=sql_result($getperidr2,0,"CanMakeReplysCT"); -$CanEditTopics=sql_result($getperidr2,0,"CanEditTopics"); -$CanEditTopicsCT=sql_result($getperidr2,0,"CanEditTopicsCT"); -$CanEditReplys=sql_result($getperidr2,0,"CanEditReplys"); -$CanEditReplysCT=sql_result($getperidr2,0,"CanEditReplysCT"); -$CanDeleteTopics=sql_result($getperidr2,0,"CanDeleteTopics"); -$CanDeleteTopicsCT=sql_result($getperidr2,0,"CanDeleteTopicsCT"); -$CanDeleteReplys=sql_result($getperidr2,0,"CanDeleteReplys"); -$CanDeleteReplysCT=sql_result($getperidr2,0,"CanDeleteReplysCT"); -$CanCloseTopics=sql_result($getperidr2,0,"CanCloseTopics"); -$CanPinTopics=sql_result($getperidr2,0,"CanPinTopics"); -$CanDohtml=sql_result($getperidr2,0,"CanDohtml"); -$CanUseBBags=sql_result($getperidr2,0,"CanUseBBags"); -$CanModForum=sql_result($getperidr2,0,"CanModForum"); -sql_free_result($getperidr2); -if($_POST['CPermissions']=="0") { -$query = sql_pre_query("INSERT INTO \"".$Settings['sqltable']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanDohtml\", \"CanUseBBags\", \"CanModForum\") VALUES (%i, '%s', %i, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no')", array($PermissionID,$PermissionName,$_POST['ForumID'])); } -if($_POST['CPermissions']!="0") { -if($getperidnum2>0) { -$query = sql_pre_query("INSERT INTO \"".$Settings['sqltable']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanDohtml\", \"CanUseBBags\", \"CanModForum\") VALUES (%i, '%s', %i, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", array($PermissionID,$PermissionName,$_POST['ForumID'],$CanViewForum,$CanMakeTopics,$CanMakeReplys,$CanMakeReplysCT,$CanEditTopics,$CanEditTopicsCT,$CanEditReplys,$CanEditReplysCT,$CanDeleteTopics,$CanDeleteTopicsCT,$CanDeleteReplys,$CanDeleteReplysCT,$CanCloseTopics,$CanPinTopics,$CanDohtml,$CanUseBBags,$CanModForum)); } -if($getperidnum2<=0) { -$query = sql_pre_query("INSERT INTO \"".$Settings['sqltable']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanDohtml\", \"CanUseBBags\", \"CanModForum\") VALUES (%i, '%s', %i, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no')", array($PermissionID,$PermissionName,$_POST['ForumID'])); } } -sql_query($query,$SQLStat); -++$getperidi; /*++$nextperid;*/ } -sql_free_result($getperidr); -?> - -
- -
-">iDB Forum Manager
- - - - - - - - - - - - - - - -
-">iDB Forum Manager - 
- Deleting a Forum: -  -
-
"> - - - - - - - - - - - - - -
- - -
- - - - -
-
-
 
-
-\n"; } -if($prenum>0&&$Error!="Yes") { -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."forums\" WHERE \"id\"=%i", array($_POST['DelID'])); -sql_query($dtquery,$SQLStat); -if($_POST['DelForums']=="yes") { -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."topics\" WHERE \"ForumID\"=%i", array($_POST['DelID'])); -sql_query($dtquery,$SQLStat); -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."posts\" WHERE \"ForumID\"=%i", array($_POST['DelID'])); -sql_query($dtquery,$SQLStat); } -if($_POST['DelPermission']=="yes") { -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."permissions\" WHERE \"ForumID\"=%i", array($_POST['DelID'])); -sql_query($dtquery,$SQLStat); } -if($_POST['DelForums']=="yes") { -$apcquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."forums\" WHERE \"InSubForum\"=%i ORDER BY \"OrderID\" ASC, \"id\" ASC", array($_POST['DelID'])); +$ForumID=sql_result($result,$i,"id"); +$ForumName=sql_result($result,$i,"Name"); +$ForumShow=sql_result($result,$i,"ShowForum"); +$ForumType=sql_result($result,$i,"ForumType"); +$ForumShowTopics=sql_result($result,$i,"CanHaveTopics"); +$ForumShowTopics = strtolower($ForumShowTopics); +$NumTopics=sql_result($result,$i,"NumTopics"); +$NumPosts=sql_result($result,$i,"NumPosts"); +$NumRedirects=sql_result($result,$i,"Redirects"); +$ForumDescription=sql_result($result,$i,"Description"); +$ForumType = strtolower($ForumType); $sflist = null; +$gltf = array(null); $gltf[0] = $ForumID; +if ($ForumType=="subforum") { +$apcquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."forums\" WHERE \"ShowForum\"='yes' AND \"InSubForum\"=%i ORDER BY \"OrderID\" ASC, \"id\" ASC", array($ForumID)); $apcresult=sql_query($apcquery,$SQLStat); $apcnum=sql_num_rows($apcresult); $apci=0; $apcl=1; if($apcnum>=1) { while ($apci < $apcnum) { -$DelSubsForumID=sql_result($apcresult,$apci,"id"); -if($_POST['DelForums']=="yes") { -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."topics\" WHERE \"ForumID\"=%i", array($DelSubsForumID)); -sql_query($dtquery,$SQLStat); -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."posts\" WHERE \"ForumID\"=%i", array($DelSubsForumID)); -sql_query($dtquery,$SQLStat); } -if($_POST['DelPermission']=="yes") { -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."permissions\" WHERE \"ForumID\"=%i", array($DelSubsForumID)); -sql_query($dtquery,$SQLStat); } -$dtquery = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."forums\" WHERE \"id\"=%i", array($DelSubsForumID)); -sql_query($dtquery,$SQLStat); +$NumsTopics=sql_result($apcresult,$apci,"NumTopics"); +$NumTopics = $NumsTopics + $NumTopics; +$NumsPosts=sql_result($apcresult,$apci,"NumPosts"); +$NumPosts = $NumsPosts + $NumPosts; +$SubsForumID=sql_result($apcresult,$apci,"id"); +$SubsForumName=sql_result($apcresult,$apci,"Name"); +$SubsForumType=sql_result($apcresult,$apci,"ForumType"); +if(isset($PermissionInfo['CanViewForum'][$SubsForumID])&& + $PermissionInfo['CanViewForum'][$SubsForumID]=="yes") { +$sfurl = "".$SubsForumName.""; +if($apcl==1) { +$sflist = "Subforums:"; +$sflist = $sflist." ".$sfurl; } +if($apcl>1) { +$sflist = $sflist.", ".$sfurl; } +$gltf[$apcl] = $SubsForumID; ++$apcl; } ++$apci; } sql_free_result($apcresult); } } -?> - -
- -
-">iDB Forum Manager
- - - - - - - - - - - - - - - -
-">iDB Forum Manager - 
- Editing a Forum: -  -
-
"> - - - - -
- - -
- - - -
-
-
 
-
-=1) { -$ForumID=sql_result($preresult,0,"id"); -$ForumCatID=sql_result($preresult,0,"CategoryID"); -$ForumOrder=sql_result($preresult,0,"OrderID"); -$ForumName=sql_result($preresult,0,"Name"); -$ForumName = htmlspecialchars($ForumName, ENT_QUOTES, $Settings['charset']); -$ShowForum=sql_result($preresult,0,"ShowForum"); -$ForumType=sql_result($preresult,0,"ForumType"); -$InSubForum=sql_result($preresult,0,"InSubForum"); -$RedirectURL=sql_result($preresult,0,"RedirectURL"); -$RedirectTimes=sql_result($preresult,0,"Redirects"); -$NumberViews=sql_result($preresult,0,"NumViews"); -$ForumDescription=sql_result($preresult,0,"Description"); -$ForumDescription = htmlspecialchars($ForumDescription, ENT_QUOTES, $Settings['charset']); -$PostCountAdd=sql_result($preresult,0,"PostCountAdd"); -$PostCountView=sql_result($preresult,0,"PostCountView"); -$KarmaCountView=sql_result($preresult,0,"KarmaCountView"); -$CanHaveTopics=sql_result($preresult,0,"CanHaveTopics"); -$HotTopicPosts=sql_result($preresult,0,"HotTopicPosts"); -$NumberPosts=sql_result($preresult,0,"NumPosts"); -$NumberTopics=sql_result($preresult,0,"NumTopics"); -sql_free_result($preresult); -$ForumType = strtolower($ForumType); $CanHaveTopics = strtolower($CanHaveTopics); -?> -
- -
-">iDB Forum Manager
- - - - - - - - - - - - - - - -
-">iDB Forum Manager - 
- Editing a Forum: -  -
-
"> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
- - - - - -
-
-
 
-
-=1) { -$OldID=sql_result($preresult,0,"id"); -$OldOrder=sql_result($preresult,0,"OrderID"); -sql_free_result($preresult); -$sql_id_check = sql_query(sql_pre_query("SELECT \"id\" FROM \"".$Settings['sqltable']."forums\" WHERE \"id\"=%i LIMIT 1", array($_POST['ForumID'])),$SQLStat); -$sql_order_check = sql_query(sql_pre_query("SELECT \"OrderID\" FROM \"".$Settings['sqltable']."forums\" WHERE \"OrderID\"=%i LIMIT 1", array($_POST['OrderID'])),$SQLStat); -$id_check = sql_num_rows($sql_id_check); $order_check = sql_num_rows($sql_order_check); -sql_free_result($sql_id_check); sql_free_result($sql_order_check); -if ($_POST['NumPostView']==null|| - !is_numeric($_POST['NumPostView'])) { - $_POST['NumPostView'] = 0; } -if ($_POST['NumKarmaView']==null|| - !is_numeric($_POST['NumKarmaView'])) { - $_POST['NumKarmaView'] = 0; } -if ($Settings['hot_topic_num']==null|| - !is_numeric($Settings['hot_topic_num'])) { - $Settings['hot_topic_num'] = 10; } -if ($_POST['NumPostHotTopic']==null|| - !is_numeric($_POST['NumPostHotTopic'])) { - $_POST['NumPostHotTopic'] = $Settings['hot_topic_num']; } -if ($_POST['ForumName']==null|| - $_POST['ForumName']=="ShowMe") { $Error="Yes"; -$errorstr = $errorstr."You need to enter a forum name.
\n"; } -if ($_POST['ForumDesc']==null) { $Error="Yes"; -$errorstr = $errorstr."You need to enter a description.
\n"; } -if ($_POST['ForumID']==null|| - !is_numeric($_POST['ForumID'])) { $Error="Yes"; -$errorstr = $errorstr."You need to enter a forum ID.
\n"; } -if($id_check > 0&&$_POST['ForumID']!=$OldID) { $Error="Yes"; -$errorstr = $errorstr."This ID number is already used.
\n"; } -if($order_check > 0&&$_POST['OrderID']!=$OldOrder) { $Error="Yes"; -$errorstr = $errorstr."This order number is already used.
\n"; } -if (pre_strlen($_POST['ForumName'])>"150") { $Error="Yes"; -$errorstr = $errorstr."Your Forum Name is too big.
\n"; } -if (pre_strlen($_POST['ForumDesc'])>"300") { $Error="Yes"; -$errorstr = $errorstr."Your Forum Description is too big.
\n"; } -if ($Error!="Yes") { -redirect("refresh",$basedir.url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin'],FALSE),"4"); -$admincptitle = " ".$ThemeSet['TitleDivider']." Updating Settings"; -$query = sql_pre_query("UPDATE \"".$Settings['sqltable']."forums\" SET \"id\"=%i,\"CategoryID\"=%i,\"OrderID\"=%i,\"Name\"='%s',\"ShowForum\"='%s',\"ForumType\"='%s',\"InSubForum\"=%i,\"RedirectURL\"='%s',\"Description\"='%s',\"PostCountAdd\"='%s',\"PostCountView\"=%i,\"KarmaCountView\"=%i,\"CanHaveTopics\"='%s',\"HotTopicPosts\"=%i WHERE \"id\"=%i", array($_POST['ForumID'],$_POST['ForumCatID'],$_POST['OrderID'],$_POST['ForumName'],$_POST['ShowForum'],$_POST['ForumType'],$_POST['InSubForum'],$_POST['RedirectURL'],$_POST['ForumDesc'],$_POST['PostCountAdd'],$_POST['NumPostView'],$_POST['NumKarmaView'],$_POST['CanHaveTopics'],$_POST['NumPostHotTopic'],$_POST['id'])); -sql_query($query,$SQLStat); } } } -if($_GET['act']=="fpermissions"&&$_POST['update']!="now") { -$admincptitle = " ".$ThemeSet['TitleDivider']." Forum Permissions Manager"; -if(!isset($_POST['id'])) { -?> -
- -
-">Forum Permissions Manager
- - - - - - - - - - - - - - - -
-">Forum Permissions Manager - 
- Forum Permissions Manager: -  -
-
"> - - - - -
- - -
- - - -
-
-
 
-
- -
- -
-">Forum Permissions Manager
- - - - - - - - - - - - - - - -
-">Forum Permissions Manager - 
- Forum Permissions Manager: -  -
-0) { -$getperidNumz=sql_result($getperidr,0,"id"); -$getperidID=sql_result($getperidr,0,"PermissionID"); } -?> -
"> - - -
-0) { ?> -Permissions for are set:
- - - - - -Permissions for are not set:
- - - - - - -
-
- -
 
-
-=1) { -$PermissionNum=sql_result($preresult,0,"id"); -$PermissionID=sql_result($preresult,0,"PermissionID"); -$PermissionName=sql_result($preresult,0,"Name"); -$PermissionForumID=sql_result($preresult,0,"ForumID"); -$CanViewForum=sql_result($preresult,0,"CanViewForum"); -$CanMakeTopics=sql_result($preresult,0,"CanMakeTopics"); -$CanMakeReplys=sql_result($preresult,0,"CanMakeReplys"); -$CanMakeReplysCT=sql_result($preresult,0,"CanMakeReplysCT"); -$CanEditTopics=sql_result($preresult,0,"CanEditTopics"); -$CanEditTopicsCT=sql_result($preresult,0,"CanEditTopicsCT"); -$CanEditReplys=sql_result($preresult,0,"CanEditReplys"); -$CanEditReplysCT=sql_result($preresult,0,"CanEditReplysCT"); -$CanDeleteTopics=sql_result($preresult,0,"CanDeleteTopics"); -$CanDeleteTopicsCT=sql_result($preresult,0,"CanDeleteTopicsCT"); -$CanDeleteReplys=sql_result($preresult,0,"CanDeleteReplys"); -$CanDeleteReplysCT=sql_result($preresult,0,"CanDeleteReplysCT"); -$CanCloseTopics=sql_result($preresult,0,"CanCloseTopics"); -$CanPinTopics=sql_result($preresult,0,"CanPinTopics"); -$CanDohtml=sql_result($preresult,0,"CanDohtml"); -$CanUseBBags=sql_result($preresult,0,"CanUseBBags"); -$CanModForum=sql_result($preresult,0,"CanModForum"); -sql_free_result($preresult); } -$PermissionName = stripcslashes(htmlspecialchars($PermissionName, ENT_QUOTES, $Settings['charset'])); -//$_POST['ForumName'] = preg_replace("/&#(x[a-f0-9]+|[0-9]+);/i", "&#$1;", $_POST['ForumName']); -?> -
- -
-">Forum Permissions Manager
- - - - - - - - - - - - - - - -
-">Forum Permissions Manager - 
- Editing Forum Permissions: -  -
-
"> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
- - - - - -
-
-
 
-
- -
- -
-">Forum Permissions Manager
- - - - - - - - - - - - - - - -
-">Forum Permissions Manager - 
- Editing Forum Permissions: -  -
-
"> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -
- - - - - - -
-
-
 
-
-=1) { -$PermissionName=sql_result($preresult,0,"Name"); -sql_free_result($preresult); } -//$nextidnum = sql_get_next_id($Settings['sqltable'],"permissions",$SQLStat); -$nextidnum = null; -$query = sql_pre_query("INSERT INTO \"".$Settings['sqltable']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanDohtml\", \"CanUseBBags\", \"CanModForum\") VALUES\n". -"(%i, '%s', %i, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", array($_POST['permid'], $PermissionName, $_POST['id'], $_POST['CanViewForum'], $_POST['CanMakeTopics'], $_POST['CanMakeReplys'], $_POST['CanMakeReplysCT'], $_POST['CanEditTopics'], $_POST['CanEditTopicsCT'], $_POST['CanEditReplys'], $_POST['CanEditReplysCT'], $_POST['CanDeleteTopics'], $_POST['CanDeleteTopicsCT'], $_POST['CanDeleteReplys'], $_POST['CanDeleteReplysCT'], $_POST['CanCloseTopics'], $_POST['CanPinTopics'], $_POST['CanDohtml'], $_POST['CanUseBBags'], $_POST['CanModForum'])); -sql_query($query,$SQLStat); } } -$doupdate = false; -if(isset($_POST['id'])&&$_POST['subact']=="editnow") { - $doupdate = true; } -if(isset($_POST['id'])&&isset($_POST['permid'])&&$_POST['subact']=="makenow") { - $doupdate = true; } -if($_POST['act']=="addforum"&&$_POST['update']=="now"&&$_GET['act']=="addforum") { - $doupdate = true; } -if($_GET['act']=="deleteforum"&&$_POST['update']=="now"&&$_GET['act']=="deleteforum") { - $doupdate = true; } -if($_POST['act']=="editforum"&&$_POST['update']=="now"&&$_GET['act']=="editforum"&& - isset($_POST['id'])) { - $doupdate = true; } -if($doupdate===true&&$Error!="Yes") { ?> -
- -
-">Updating Settings
- - - - - - - - - - - - - -
-">Updating Settings - 
Updating Settings
- -
-
The permission was edited successfully. ">Click here to go back. ^_^
  -
- -
-
The permission was created successfully. ">Click here to go back. ^_^
  -
- -
-
The forum was created successfully. ">Click here to go back. ^_^
  -
- -
-
The forum was deleted successfully. ">Click here to go back. ^_^
  -
- -
-
The forum was edited successfully. ">Click here to go back. ^_^
  -
- -
 
- -
- -
-">Updating Settings
- - - - - - - - - - - - - -
-">Updating Settings - 
Updating Settings
-
-
- ">Click here to back to admin cp.
  -
-
 
- - - -
 
+if(isset($PermissionInfo['CanViewForum'][$ForumID])&& + $PermissionInfo['CanViewForum'][$ForumID]=="yes") { +$LastTopic = " 
 
 "; +if(!isset($LastTopic)) { $LastTopic = null; } +$gltnum = count($gltf); $glti = 0; +$OldUpdateTime = 0; $UseThisFonum = null; +if ($ForumType=="subforum") { +while ($glti < $gltnum) { +$gltfoquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"ForumID\"=%i ORDER BY \"LastUpdate\" DESC LIMIT 1", array($gltf[$glti])); +$gltforesult=sql_query($gltfoquery,$SQLStat); +$gltfonum=sql_num_rows($gltforesult); +if($gltfonum>0) { +$NewUpdateTime=sql_result($gltforesult,0,"LastUpdate"); +if($NewUpdateTime>$OldUpdateTime) { + $UseThisFonum = $gltf[$glti]; +$OldUpdateTime = $NewUpdateTime; } } +sql_free_result($gltforesult); +++$glti; } } +if ($ForumType!="subforum"&&$ForumType!="redirect") { $UseThisFonum = $gltf[0]; } +if ($ForumType!="redirect") { +$gltquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."topics\" WHERE \"ForumID\"=%i ORDER BY \"LastUpdate\" DESC LIMIT 1", array($UseThisFonum)); +$gltresult=sql_query($gltquery,$SQLStat); +$gltnum=sql_num_rows($gltresult); +if($gltnum>0){ +$TopicID=sql_result($gltresult,0,"id"); +$TopicName=sql_result($gltresult,0,"TopicName"); +$NumReplys=sql_result($gltresult,0,"NumReply"); +$NumPages = null; $NumRPosts = $NumReplys + 1; +if(!isset($Settings['max_posts'])) { $Settings['max_posts'] = 10; } +if($NumRPosts>$Settings['max_posts']) { +$NumPages = ceil($NumRPosts/$Settings['max_posts']); } +if($NumRPosts<=$Settings['max_posts']) { $NumPages = 1; } +$TopicName1 = pre_substr($TopicName,0,20); +$oldtopicname=$TopicName; +if (pre_strlen($TopicName)>20) { +$TopicName1 = $TopicName1."..."; $TopicName=$TopicName1; } +$glrquery = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."posts\" WHERE \"TopicID\"=%i ORDER BY \"TimeStamp\" DESC LIMIT 1", array($TopicID)); +$glrresult=sql_query($glrquery,$SQLStat); +$glrnum=sql_num_rows($glrresult); +if($glrnum>0){ +$ReplyID=sql_result($glrresult,0,"id"); +$UsersID=sql_result($glrresult,0,"UserID"); +$GuestsName=sql_result($glrresult,0,"GuestName"); +$TimeStamp=sql_result($glrresult,0,"TimeStamp"); +$TimeStamp=GMTimeChange("F j Y, g:i a",$TimeStamp,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); +sql_free_result($glrresult); } +$PreUsersName = GetUserName($UsersID,$Settings['sqltable'],$SQLStat); +if($PreUsersName['Name']===null) { $UsersID = -1; +$PreUsersName = GetUserName($UsersID,$Settings['sqltable'],$SQLStat); } +$UsersName = $PreUsersName['Name']; +$UsersHidden = $PreUsersName['Hidden']; +$UsersName1 = pre_substr($UsersName,0,20); +if($UsersName=="Guest") { $UsersName=$GuestsName; +if($UsersName==null) { $UsersName="Guest"; } } +$oldusername=$UsersName; +if (pre_strlen($UsersName)>20) { +$UsersName1 = $UsersName1."..."; $UsersName=$UsersName1; } +$lul = null; +if($UsersID>0&&$UsersHidden=="no") { +$lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); +$LastTopic = $TimeStamp."
\nTopic: ".$TopicName."
\nUser: ".$UsersName.""; } +if($UsersID<=0||$UsersHidden=="yes") { +if($UsersID==-1) { $UserPre = "Guest:"; } +if(($UsersID<-1&&$UsersHidden=="yes")||$UsersID==0||($UsersID>0&&$UsersHidden=="yes")) { + $UserPre = "Hidden:"; } +$LastTopic = $TimeStamp."
\nTopic: ".$TopicName."
\n".$UserPre." ".$UsersName.""; } } +if($LastTopic==null) { $LastTopic=" 
 "; } +sql_free_result($gltresult); } +if ($ForumType=="redirect") { $LastTopic=" 
Redirects: ".$NumRedirects."
 "; } +$PreForum = $ThemeSet['ForumIcon']; +if ($ForumType=="forum") { $PreForum=$ThemeSet['ForumIcon']; } +if ($ForumType=="subforum") { $PreForum=$ThemeSet['SubForumIcon']; } +if ($ForumType=="redirect") { $PreForum=$ThemeSet['RedirectIcon']; } +$ExStr = ""; if ($ForumType!="redirect"&& + $ForumShowTopics!="no") { $ExStr = "&page=1"; } +?> + +
+
+
">
+
+
+
+ + + + +=1) { +?> + +  + + + +
 
+ +
 
+ diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 1b9b4af..88a3b71 100644 --- a/inc/versioninfo.php +++ b/inc/versioninfo.php @@ -11,7 +11,7 @@ Copyright 2004-2009 iDB Support - http://idb.berlios.de/ Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: versioninfo.php - Last Update: 12/18/2009 SVN 422 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 12/18/2009 SVN 423 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="versioninfo.php"||$File3Name=="/versioninfo.php") { @@ -27,7 +27,7 @@ function version_info($proname,$subver,$ver,$supver,$reltype,$svnver,$showsvn) { return $return_var; } // Version number and date stuff. :P $VER1[0] = 0; $VER1[1] = 3; $VER1[2] = 5; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 422; $RName = "iDB"; $SFName = "IntDB"; +$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 423; $RName = "iDB"; $SFName = "IntDB"; $SVNDay[0] = 12; $SVNDay[1] = 18; $SVNDay[2] = 2009; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; $VerInfo['iDB_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,false); $VerInfo['iDB_Ver_SVN'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,true); -- 2.11.0