From 542a06e8f7d1dd205f4040e1a64d7aca38603388 Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Sat, 18 Jul 2009 03:27:09 +0000 Subject: [PATCH] In admin cp forum tool you can now copy permissions from another forum. git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@274 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/admin/forums.php | 58 ++++++++++++++++++++++++++++++++++++++++++++++++---- inc/versioninfo.php | 4 ++-- 2 files changed, 56 insertions(+), 6 deletions(-) diff --git a/inc/admin/forums.php b/inc/admin/forums.php index 7fbaa15..d04d6ce 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: 7/17/2009 SVN 273 - Author: cooldude2k $ + $FileInfo: forums.php - Last Update: 7/17/2009 SVN 274 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="forums.php"||$File3Name=="/forums.php") { @@ -145,6 +145,26 @@ if ($InForumType!="redirect"&&$AiFiInSubForum=="0") { + + + @@ -207,6 +227,7 @@ if ($Error!="Yes") { $admincptitle = " ".$ThemeSet['TitleDivider']." Updating Settings"; $query = query("INSERT INTO `".$Settings['sqltable']."forums` VALUES (%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'])); mysql_query($query); +if(!is_numeric($_POST['CPermissions'])) { $_POST['CPermissions'] = "0"; } $getperidq = query("SELECT DISTINCT `PermissionID` FROM `".$Settings['sqltable']."permissions` ORDER BY `PermissionID` ASC", array(null)); $getperidr=mysql_query($getperidq); $getperidnum=mysql_num_rows($getperidr); @@ -214,12 +235,41 @@ $getperidi = 0; $nextperid = getnextid($Settings['sqltable'],"permissions"); while ($getperidi < $getperidnum) { $getperidID=mysql_result($getperidr,$getperidi,"PermissionID"); -$getperidq2 = query("SELECT * FROM `".$Settings['sqltable']."permissions` WHERE `PermissionID`=%i", array($getperidID)); +if($_POST['CPermissions']=="0") { +$getperidq2 = query("SELECT * FROM `".$Settings['sqltable']."permissions` WHERE `PermissionID`=%i", array($getperidID)); } +if($_POST['CPermissions']!="0") { +$getperidq2 = query("SELECT * FROM `".$Settings['sqltable']."permissions` WHERE `PermissionID`=%i AND ForumID=%i", array($getperidID,$_POST['CPermissions'])); } $getperidr2=mysql_query($getperidq2); $getperidnum2=mysql_num_rows($getperidr2); -$getperidName=mysql_result($getperidr2,0,"Name"); +$PermissionNum=mysql_result($getperidr2,0,"id"); +$PermissionID=mysql_result($getperidr2,0,"PermissionID"); +$PermissionName=mysql_result($getperidr2,0,"Name"); +$PermissionForumID=mysql_result($getperidr2,0,"ForumID"); +$CanViewForum=mysql_result($getperidr2,0,"CanViewForum"); +$CanMakeTopics=mysql_result($getperidr2,0,"CanMakeTopics"); +$CanMakeReplys=mysql_result($getperidr2,0,"CanMakeReplys"); +$CanMakeReplysCT=mysql_result($getperidr2,0,"CanMakeReplysCT"); +$CanEditTopics=mysql_result($getperidr2,0,"CanEditTopics"); +$CanEditTopicsCT=mysql_result($getperidr2,0,"CanEditTopicsCT"); +$CanEditReplys=mysql_result($getperidr2,0,"CanEditReplys"); +$CanEditReplysCT=mysql_result($getperidr2,0,"CanEditReplysCT"); +$CanDeleteTopics=mysql_result($getperidr2,0,"CanDeleteTopics"); +$CanDeleteTopicsCT=mysql_result($getperidr2,0,"CanDeleteTopicsCT"); +$CanDeleteReplys=mysql_result($getperidr2,0,"CanDeleteReplys"); +$CanDeleteReplysCT=mysql_result($getperidr2,0,"CanDeleteReplysCT"); +$CanCloseTopics=mysql_result($getperidr2,0,"CanCloseTopics"); +$CanPinTopics=mysql_result($getperidr2,0,"CanPinTopics"); +$CanDohtml=mysql_result($getperidr2,0,"CanDohtml"); +$CanUseBBags=mysql_result($getperidr2,0,"CanUseBBags"); +$CanModForum=mysql_result($getperidr2,0,"CanModForum"); @mysql_free_result($getperidr2); -$query = query("INSERT IGNORE INTO `".$Settings['sqltable']."permissions` VALUES (%i, %i, '%s', %i, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no')", array($nextperid,$getperidID,$getperidName,$_POST['ForumID'])); +if($_POST['CPermissions']=="0") { +$query = query("INSERT IGNORE INTO `".$Settings['sqltable']."permissions` VALUES (%i, %i, '%s', %i, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no')", array($nextperid,$PermissionID,$PermissionName,$_POST['ForumID'])); } +if($_POST['CPermissions']!="0") { +if($getperidnum2>0) { +$query = query("INSERT IGNORE INTO `".$Settings['sqltable']."permissions` VALUES (%i, %i, '%s', %i, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", array($nextperid,$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 = query("INSERT IGNORE INTO `".$Settings['sqltable']."permissions` VALUES (%i, %i, '%s', %i, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no')", array($nextperid,$PermissionID,$PermissionName,$_POST['ForumID'])); } } mysql_query($query); ++$getperidi; ++$nextperid; } @mysql_free_result($getperidr); diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 57e78f5..3c68d00 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: 7/17/2009 SVN 273 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 7/17/2009 SVN 274 - 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] = 2; $VER1[2] = 8; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 273; $RName = "iDB"; $SFName = "IntDB"; +$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 274; $RName = "iDB"; $SFName = "IntDB"; $SVNDay[0] = 7; $SVNDay[1] = 17; $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