3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the Revised BSD License.
6 This program is distributed in the hope that it will be useful,
7 but WITHOUT ANY WARRANTY; without even the implied warranty of
8 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
9 Revised BSD License for more details.
11 Copyright 2004-2009 iDB Support - http://idb.berlios.de/
12 Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
14 $FileInfo: groupsetup.php - Last Update: 12/02/2009 SVN 371 - Author: cooldude2k $
16 $File3Name = basename($_SERVER['SCRIPT_NAME']);
17 if ($File3Name=="groupsetup.php"||$File3Name=="/groupsetup.php") {
20 //Set members temp location
21 $_SESSION['ViewingPage'] = url_maker(null,"no+ext","act=view","&","=",$prexqstr['index'],$exqstr['index']);
22 if($Settings['file_ext']!="no+ext"&&$Settings['file_ext']!="no ext") {
23 $_SESSION['ViewingFile'] = $exfile['index'].$Settings['file_ext']; }
24 if($Settings['file_ext']=="no+ext"||$Settings['file_ext']=="no ext") {
25 $_SESSION['ViewingFile'] = $exfile['index']; }
26 $_SESSION['PreViewingTitle'] = "Viewing";
27 $_SESSION['ViewingTitle'] = "Board index";
28 /*$ggidquery = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `name`='%s' LIMIT 1", array($Settings['GuestGroup']));
29 $ggidresult=sql_query($ggidquery);
30 $Settings['GuestGroupID']=sql_result($ggidresult,0,"id");*/
31 // Check to make sure MemberInfo is right
32 $MyPostCountChk = null; $MyKarmaCount = null;
33 if(!isset($_SESSION['UserID'])) { $_SESSION['UserID'] = 0; }
34 if($_SESSION['UserID']!=0&&$_SESSION['UserID']!=null) { $BanError = null;
35 $kgbquerychkusr = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."members` WHERE `Name`='%s' AND `Password`='%s' AND `id`=%i LIMIT 1", array($_SESSION['MemberName'],$_SESSION['UserPass'],$_SESSION['UserID']));
36 $resultchkusr=sql_query($kgbquerychkusr);
37 $numchkusr=sql_num_rows($resultchkusr);
39 $ChkUsrID=sql_result($resultchkusr,0,"id");
40 $ChkUsrName=sql_result($resultchkusr,0,"Name");
41 $ChkUsrGroup=sql_result($resultchkusr,0,"GroupID");
42 $ChkUsrGroupID=$ChkUsrGroup;
43 $ChkUsrPass=sql_result($resultchkusr,0,"Password");
44 $ChkUsrTimeZone=sql_result($resultchkusr,0,"TimeZone");
45 $ChkUsrTheme=sql_result($resultchkusr,0,"UseTheme");
46 $ChkUsrLastPostTime=sql_result($resultchkusr,0,"LastPostTime");
47 $MyPostCountChk=sql_result($resultchkusr,0,"PostCount");
48 $MyKarmaCount=sql_result($resultchkusr,0,"Karma");
49 $MyKarmaUpdate=sql_result($resultchkusr,0,"KarmaUpdate");
50 $MyRepliesPerPage=sql_result($resultchkusr,0,"RepliesPerPage");
51 $Settings['max_posts'] = $MyRepliesPerPage;
52 $MyTopicsPerPage=sql_result($resultchkusr,0,"TopicsPerPage");
53 $Settings['max_topics'] = $MyTopicsPerPage;
54 $MyMessagesPerPage=sql_result($resultchkusr,0,"MessagesPerPage");
55 $Settings['max_memlist'] = $MyMessagesPerPage;
56 $Settings['max_pmlist'] = $MyMessagesPerPage;
57 $ChkUsrDST=sql_result($resultchkusr,0,"DST");
58 $svrquery = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `id`=%i LIMIT 1", array($ChkUsrGroup));
59 $svrgresultkgb=sql_query($svrquery);
60 $ChkUsrGroup=sql_result($svrgresultkgb,0,"Name");
61 $ChkUsrBanTime=sql_result($resultchkusr,0,"BanTime");
62 $ChkUsrGMTime = GMTimeStamp();
63 if($ChkUsrBanTime!=0&&$ChkUsrBanTime!=null) {
64 if($ChkUsrBanTime>=$ChkUsrGMTime) { $BanError = "yes"; } }
65 if($BanError!="yes") {
66 $_SESSION['Theme']=$ChkUsrTheme;
67 $_SESSION['MemberName']=$ChkUsrName;
68 $_SESSION['UserID']=$ChkUsrID;
69 $_SESSION['UserIP']=$_SERVER['REMOTE_ADDR'];
70 $_SESSION['UserTimeZone']=$ChkUsrTimeZone;
71 $_SESSION['UserGroup']=$ChkUsrGroup;
72 $_SESSION['UserGroupID']=$ChkUsrGroupID;
73 $_SESSION['UserDST']=$ChkUsrDST;
74 $_SESSION['UserPass']=$ChkUsrPass;
75 $_SESSION['LastPostTime'] = $ChkUsrLastPostTime; } }
76 if($numchkusr<=0||$numchkusr>1||$BanError=="yes") { session_unset();
77 if($cookieDomain==null) {
78 setcookie("MemberName", null, GMTimeStamp() - 3600, $cbasedir);
79 setcookie("UserID", null, GMTimeStamp() - 3600, $cbasedir);
80 setcookie("SessPass", null, GMTimeStamp() - 3600, $cbasedir);
81 setcookie(session_name(), "", GMTimeStamp() - 3600, $cbasedir); }
82 if($cookieDomain!=null) {
83 if($cookieSecure===true) {
84 setcookie("MemberName", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
85 setcookie("UserID", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
86 setcookie("SessPass", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
87 setcookie(session_name(), "", GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1); }
88 if($cookieSecure===false) {
89 setcookie("MemberName", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
90 setcookie("UserID", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
91 setcookie("SessPass", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
92 setcookie(session_name(), "", GMTimeStamp() - 3600, $cbasedir, $cookieDomain); } }
93 unset($_COOKIE[session_name()]);
94 $_SESSION = array(); session_unset(); session_destroy();
95 redirect("location",$basedir.url_maker($exfile['member'],$Settings['file_ext'],"act=login",$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member'],false)); sql_free_result($resultchkusr); sql_free_result($svrgresultkgb);
96 ob_clean(); header("Content-Type: text/plain; charset=".$Settings['charset']);
97 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
98 sql_free_result($resultchkusr); sql_free_result($svrgresultkgb); }
99 if($_SESSION['UserID']==0||$_SESSION['UserID']==null) {
100 $_SESSION['UserIP']=$_SERVER['REMOTE_ADDR'];
101 $_SESSION['MemberName'] = null;
102 $_SESSION['UserGroup'] = $Settings['GuestGroup'];
103 $gidquery = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `name`='%s' LIMIT 1", array($Settings['GuestGroup']));
104 $gidresult=sql_query($gidquery);
105 $_SESSION['UserGroupID']=sql_result($gidresult,0,"id");
106 sql_free_result($gidresult); }
107 if($_SESSION['MemberName']==null) { $_SESSION['UserID'] = "0";
108 $_SESSION['UserIP']=$_SERVER['REMOTE_ADDR'];
109 $_SESSION['UserGroup'] = $Settings['GuestGroup'];
110 $gidquery = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `name`='%s' LIMIT 1", array($Settings['GuestGroup']));
111 $gidresult=sql_query($gidquery);
112 $_SESSION['UserGroupID']=sql_result($gidresult,0,"id");
113 sql_free_result($gidresult); }
114 // Member Group Setup
115 if(!isset($_SESSION['UserGroup'])) { $_SESSION['UserGroup'] = null; }
116 if($_SESSION['UserGroup']==null) {
117 $_SESSION['UserGroup']=$Settings['GuestGroup']; } $GruError = null;
118 $gruquery = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `Name`='%s' LIMIT 1", array($_SESSION['UserGroup']));
119 $gruresult=sql_query($gruquery);
120 $grunum=sql_num_rows($gruresult);
121 if($grunum<=0) { $GruError = true; sql_free_result($gruresult);
122 header("Content-Type: text/plain; charset=".$Settings['charset']);
123 ob_clean(); echo "Sorry could not find group data in database.\nContact the board admin about error.";
124 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
126 $GroupInfo['ID']=sql_result($gruresult,0,"id");
127 if(!is_numeric($GroupInfo['ID'])) { $GruError = true; }
128 $GroupInfo['Name']=sql_result($gruresult,0,"Name");
129 $GroupInfo['PermissionID']=sql_result($gruresult,0,"PermissionID");
130 if(!is_numeric($GroupInfo['PermissionID'])) { $GruError = true; }
131 $GroupInfo['NamePrefix']=sql_result($gruresult,0,"NamePrefix");
132 $GroupInfo['NameSuffix']=sql_result($gruresult,0,"NameSuffix");
133 $GroupInfo['CanViewBoard']=sql_result($gruresult,0,"CanViewBoard");
134 if($GroupInfo['CanViewBoard']!="yes"&&$GroupInfo['CanViewBoard']!="no") {
136 $GroupInfo['CanViewOffLine']=sql_result($gruresult,0,"CanViewOffLine");
137 if($GroupInfo['CanViewOffLine']!="yes"&&$GroupInfo['CanViewOffLine']!="no") {
139 $GroupInfo['FloodControl']=sql_result($gruresult,0,"FloodControl");
140 if(!is_numeric($GroupInfo['FloodControl'])) { $GroupInfo['FloodControl'] = 30; }
141 $GroupInfo['SearchFlood']=sql_result($gruresult,0,"SearchFlood");
142 if(!is_numeric($GroupInfo['SearchFlood'])) { $GroupInfo['SearchFlood'] = 30; }
143 $GroupInfo['CanEditProfile']=sql_result($gruresult,0,"CanEditProfile");
144 if($GroupInfo['CanEditProfile']!="yes"&&$GroupInfo['CanEditProfile']!="no") {
146 $GroupInfo['CanAddEvents']=sql_result($gruresult,0,"CanAddEvents");
147 if($GroupInfo['CanAddEvents']!="yes"&&$GroupInfo['CanAddEvents']!="no") {
149 $GroupInfo['CanPM']=sql_result($gruresult,0,"CanPM");
150 if($GroupInfo['CanPM']!="yes"&&$GroupInfo['CanPM']!="no") {
152 $GroupInfo['CanSearch']=sql_result($gruresult,0,"CanSearch");
153 if($GroupInfo['CanSearch']!="yes"&&$GroupInfo['CanSearch']!="no") {
155 $GroupInfo['PromoteTo']=sql_result($gruresult,0,"PromoteTo");
156 $GroupInfo['PromotePosts']=sql_result($gruresult,0,"PromotePosts");
157 if(!is_numeric($GroupInfo['PromotePosts'])) {
158 $GroupInfo['PromotePosts'] = 0; $GroupInfo['PromoteTo'] = 0; }
159 $GroupInfo['PromoteKarma']=sql_result($gruresult,0,"PromoteKarma");
160 if(!is_numeric($GroupInfo['PromoteKarma'])) {
161 $GroupInfo['PromoteKarma'] = 0; $GroupInfo['PromoteTo'] = 0; }
162 if(!isset($Settings['KarmaBoostDays'])) {
163 $Settings['KarmaBoostDays'] = null; }
164 $Settings['OldKarmaBoostDays'] = $Settings['KarmaBoostDays'];
165 if(!isset($Settings['KBoostPercent'])) {
166 $Settings['KBoostPercent'] = "6|10"; }
167 //Update karma and group upgrade on post count or karma count.
168 if($_SESSION['UserID']!=0) { $BoostTotal = null;
169 $KarmaExp = explode("&",$Settings['KarmaBoostDays']);
170 $KarmaNow = GMTimeGet("md",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
172 if(in_array($KarmaNow,$KarmaExp)) {
173 $KarmaNum = count($KarmaExp);
175 while ($Karmai < $KarmaNum) {
176 if($KarmaExp[$Karmai]==$KarmaNow) {
177 $Settings['KarmaBoostDays'] = $KarmaExp[$Karmai];
178 $kupdate = true; break 1; }
180 if($kupdate===false) {
181 $Settings['KarmaBoostDays'] = $KarmaExp[0]; }
182 $NewKarmaUpdate = GMTimeGet("Ymd",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
183 $ThisYearUpdate = GMTimeGet("Y",$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
184 if($MyKarmaUpdate<$NewKarmaUpdate&&$MyPostCountChk>0) {
185 $KarmaBoostDay = $Settings['KarmaBoostDays'];
186 $KBoostPercent = explode("|",$Settings['KBoostPercent']);
187 if(count($KBoostPercent)<1) {
188 $KBoostPercent[0] = rand(1,4); }
189 if(!is_numeric($KBoostPercent[0])) {
190 $KBoostPercent[0] = 6; }
191 if(count($KBoostPercent)==1) {
192 $KBoostPercent[1] = $KBoostPercent[0] + rand(3,6); }
193 if(!is_numeric($KBoostPercent[1])) {
194 $KBoostPercent[0] = 10; }
195 $KBoostPercent = rand($KBoostPercent[0],$KBoostPercent[1]);
196 if($ThisYearUpdate.$KarmaBoostDay==$NewKarmaUpdate&&
197 is_numeric($KarmaBoostDay)) {
198 $KBoostPercent = $KBoostPercent / 100;
199 $BoostTotal = $MyKarmaCount * $KBoostPercent;
200 $BoostTotal = round($BoostTotal,0); }
201 if($BoostTotal!=null) {
202 $MyKarmaCount = $MyKarmaCount + $BoostTotal; }
203 if($BoostTotal==null) {
204 $MyKarmaCount = $MyKarmaCount + 1; }
205 $querykarmaup = sql_pre_query("UPDATE `".$Settings['sqltable']."members` SET `Karma`=%i,`KarmaUpdate`=%i WHERE `id`=%i", array($MyKarmaCount,$NewKarmaUpdate,$_SESSION['UserID']));
206 sql_query($querykarmaup); }
207 $Settings['KarmaBoostDays'] = $Settings['OldKarmaBoostDays'];
208 if($GroupInfo['PromoteTo']!=0&&$MyPostCountChk>=$GroupInfo['PromotePosts']) {
209 $sql_group_check = sql_query(sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `id`=%i LIMIT 1", array($GroupInfo['PromoteTo'])));
210 $group_check = sql_num_rows($sql_group_check);
211 sql_free_result($sql_group_check);
212 if($group_check > 0) {
213 $queryupgrade = sql_pre_query("UPDATE `".$Settings['sqltable']."members` SET `GroupID`=%i WHERE `id`=%i", array($GroupInfo['PromoteTo'],$_SESSION['UserID']));
214 sql_query($queryupgrade); } }
215 if($GroupInfo['PromotePosts']==0&&$GroupInfo['PromoteTo']!=0&&$MyKarmaCount>=$GroupInfo['PromoteKarma']) {
216 $sql_group_check = sql_query(sql_pre_query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `id`=%i LIMIT 1", array($GroupInfo['PromoteTo'])));
217 $group_check = sql_num_rows($sql_group_check);
218 sql_free_result($sql_group_check);
219 if($group_check > 0) {
220 $queryupgrade = sql_pre_query("UPDATE `".$Settings['sqltable']."members` SET `GroupID`=%i WHERE `id`=%i", array($GroupInfo['PromoteTo'],$_SESSION['UserID']));
221 sql_query($queryupgrade); } } }
222 $GroupInfo['HasModCP']=sql_result($gruresult,0,"HasModCP");
223 if($GroupInfo['HasModCP']!="yes"&&$GroupInfo['HasModCP']!="no") {
224 $GroupInfo['HasModCP'] = "no"; }
225 $GroupInfo['HasAdminCP']=sql_result($gruresult,0,"HasAdminCP");
226 if($GroupInfo['HasAdminCP']!="yes"&&$GroupInfo['HasAdminCP']!="no") {
227 $GroupInfo['HasAdminCP'] = "no"; }
228 $GroupInfo['ViewDBInfo']=sql_result($gruresult,0,"ViewDBInfo");
229 if($GroupInfo['ViewDBInfo']!="yes"&&$GroupInfo['ViewDBInfo']!="no") {
230 $GroupInfo['ViewDBInfo'] = "no"; }
231 if($GruError==true) {
232 header("Content-Type: text/plain; charset=".$Settings['charset']); sql_free_result($gruresult);
233 ob_clean(); echo "Sorry could not load all group data in database.\nContact the board admin about error.";
234 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } }
235 sql_free_result($gruresult);
236 if($GroupInfo['CanViewBoard']=="no") {
237 header("Content-Type: text/plain; charset=".$Settings['charset']);
238 ob_clean(); echo "Sorry you can not view the board.";
239 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
240 // Member Group Permissions Setup
241 $perquery = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."permissions` WHERE `PermissionID`=%i ORDER BY `ForumID` ASC", array($GroupInfo['PermissionID']));
242 $peresult=sql_query($perquery);
243 $pernum=sql_num_rows($peresult);
244 $peri=0; $PerError = null;
245 if($pernum<=0) { $PerError = true; sql_free_result($peresult);
246 header("Content-Type: text/plain; charset=".$Settings['charset']);
247 ob_clean(); echo "Sorry could not find permission data in database.\nContact the board admin about error.";
248 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
249 if($pernum>=1) { while ($peri < $pernum) {
250 $PerForumID=sql_result($peresult,$peri,"ForumID");
251 if(!is_numeric($PerForumID)) { $PerError = true; }
252 $PermissionInfo['ID'][$PerForumID]=sql_result($peresult,$peri,"ID");
253 if(!is_numeric($PermissionInfo['ID'][$PerForumID])) { $PerError = true; }
254 $PermissionInfo['PermissionID'][$PerForumID]=sql_result($peresult,$peri,"PermissionID");
255 if(!is_numeric($PermissionInfo['PermissionID'][$PerForumID])) { $PerError = true; }
256 $PermissionInfo['Name'][$PerForumID]=sql_result($peresult,$peri,"Name");
257 $PermissionInfo['ForumID'][$PerForumID]=sql_result($peresult,$peri,"ForumID");
258 if(!is_numeric($PermissionInfo['ForumID'][$PerForumID])) { $PerError = true; }
259 $PermissionInfo['CanViewForum'][$PerForumID]=sql_result($peresult,$peri,"CanViewForum");
260 if($PermissionInfo['CanViewForum'][$PerForumID]!="yes"&&$PermissionInfo['CanViewForum'][$PerForumID]!="no") {
262 $PermissionInfo['CanMakeTopics'][$PerForumID]=sql_result($peresult,$peri,"CanMakeTopics");
263 if($PermissionInfo['CanMakeTopics'][$PerForumID]!="yes"&&$PermissionInfo['CanMakeTopics'][$PerForumID]!="no") {
265 $PermissionInfo['CanMakeReplys'][$PerForumID]=sql_result($peresult,$peri,"CanMakeReplys");
266 if($PermissionInfo['CanMakeReplys'][$PerForumID]!="yes"&&$PermissionInfo['CanMakeReplys'][$PerForumID]!="no") {
268 $PermissionInfo['CanMakeReplysClose'][$PerForumID]=sql_result($peresult,$peri,"CanMakeReplysCT");
269 if($PermissionInfo['CanMakeReplysClose'][$PerForumID]!="yes"&&$PermissionInfo['CanMakeReplysClose'][$PerForumID]!="no") {
271 $PermissionInfo['CanEditTopics'][$PerForumID]=sql_result($peresult,$peri,"CanEditTopics");
272 if($PermissionInfo['CanEditTopics'][$PerForumID]!="yes"&&$PermissionInfo['CanEditTopics'][$PerForumID]!="no") {
273 $PermissionInfo['CanEditTopics'][$PerForumID] = "no"; }
274 $PermissionInfo['CanEditTopicsClose'][$PerForumID]=sql_result($peresult,$peri,"CanEditTopicsCT");
275 if($PermissionInfo['CanEditTopicsClose'][$PerForumID]!="yes"&&$PermissionInfo['CanEditTopicsClose'][$PerForumID]!="no") {
276 $PermissionInfo['CanEditTopicsClose'][$PerForumID] = "no"; }
277 $PermissionInfo['CanEditReplys'][$PerForumID]=sql_result($peresult,$peri,"CanEditReplys");
278 if($PermissionInfo['CanEditReplys'][$PerForumID]!="yes"&&$PermissionInfo['CanEditReplys'][$PerForumID]!="no") {
279 $PermissionInfo['CanEditReplys'][$PerForumID] = "no"; }
280 $PermissionInfo['CanEditReplysClose'][$PerForumID]=sql_result($peresult,$peri,"CanEditReplysCT");
281 if($PermissionInfo['CanEditReplysClose'][$PerForumID]!="yes"&&$PermissionInfo['CanEditReplysClose'][$PerForumID]!="no") {
282 $PermissionInfo['CanEditReplysClose'][$PerForumID] = "no"; }
283 $PermissionInfo['CanDeleteTopics'][$PerForumID]=sql_result($peresult,$peri,"CanDeleteTopics");
284 if($PermissionInfo['CanDeleteTopics'][$PerForumID]!="yes"&&$PermissionInfo['CanDeleteTopics'][$PerForumID]!="no") {
285 $PermissionInfo['CanDeleteTopics'][$PerForumID] = "no"; }
286 $PermissionInfo['CanDeleteTopicsClose'][$PerForumID]=sql_result($peresult,$peri,"CanDeleteTopicsCT");
287 if($PermissionInfo['CanDeleteTopicsClose'][$PerForumID]!="yes"&&$PermissionInfo['CanDeleteTopicsClose'][$PerForumID]!="no") {
288 $PermissionInfo['CanDeleteTopicsClose'][$PerForumID] = "no"; }
289 $PermissionInfo['CanDeleteReplys'][$PerForumID]=sql_result($peresult,$peri,"CanDeleteReplys");
290 if($PermissionInfo['CanDeleteReplys'][$PerForumID]!="yes"&&$PermissionInfo['CanDeleteReplys'][$PerForumID]!="no") {
291 $PermissionInfo['CanDeleteReplys'][$PerForumID] = "no"; }
292 $PermissionInfo['CanDeleteReplysClose'][$PerForumID]=sql_result($peresult,$peri,"CanDeleteReplysCT");
293 if($PermissionInfo['CanDeleteReplysClose'][$PerForumID]!="yes"&&$PermissionInfo['CanDeleteReplysClose'][$PerForumID]!="no") {
294 $PermissionInfo['CanDeleteReplysClose'][$PerForumID] = "no"; }
295 $PermissionInfo['CanCloseTopics'][$PerForumID]=sql_result($peresult,$peri,"CanCloseTopics");
296 if($PermissionInfo['CanCloseTopics'][$PerForumID]!="yes"&&$PermissionInfo['CanCloseTopics'][$PerForumID]!="no") {
297 $PermissionInfo['CanCloseTopics'][$PerForumID] = "no"; }
298 $PermissionInfo['CanPinTopics'][$PerForumID]=sql_result($peresult,$peri,"CanPinTopics");
299 if($PermissionInfo['CanPinTopics'][$PerForumID]!="yes"&&$PermissionInfo['CanPinTopics'][$PerForumID]!="no") {
300 $PermissionInfo['CanPinTopics'][$PerForumID] = "no"; }
301 $PermissionInfo['CanDohtml'][$PerForumID]=sql_result($peresult,$peri,"CanDohtml");
302 if($PermissionInfo['CanDohtml'][$PerForumID]!="yes"&&$PermissionInfo['CanDohtml'][$PerForumID]!="no") {
303 $PermissionInfo['CanDohtml'][$PerForumID] = "no"; }
304 $PermissionInfo['CanUseBBags'][$PerForumID]=sql_result($peresult,$peri,"CanUseBBags");
305 if($PermissionInfo['CanUseBBags'][$PerForumID]!="yes"&&$PermissionInfo['CanUseBBags'][$PerForumID]!="no") {
306 $PermissionInfo['CanUseBBags'][$PerForumID] = "no"; }
307 $PermissionInfo['CanModForum'][$PerForumID]=sql_result($peresult,$peri,"CanModForum");
308 if($PermissionInfo['CanModForum'][$PerForumID]!="yes"&&$PermissionInfo['CanModForum'][$PerForumID]!="no") {
309 $PermissionInfo['CanModForum'][$PerForumID] = "no"; }
310 if($PerError===true) { $peri = $pernum; }
311 ++$peri; } if($PerError===true) {
312 header("Content-Type: text/plain; charset=".$Settings['charset']); sql_free_result($peresult);
313 ob_clean(); echo "Sorry could not load all permission data in database.\nContact the board admin about error.";
314 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } }
315 sql_free_result($peresult);
316 $per2query = sql_pre_query("SELECT * FROM `".$Settings['sqltable']."catpermissions` WHERE `PermissionID`=%i ORDER BY `CategoryID` ASC", array($GroupInfo['PermissionID']));
317 $per2esult=sql_query($per2query);
318 $per2num=sql_num_rows($per2esult);
319 $per2i=0; $Per2Error = null;
320 if($per2num<=0) { $Per2Error = true; sql_free_result($per2esult);
321 header("Content-Type: text/plain; charset=".$Settings['charset']);
322 ob_clean(); echo "Sorry could not find permission data in database.\nContact the board admin about error.";
323 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
324 if($per2num>=1) { while ($per2i < $per2num) {
325 $PerCatID=sql_result($per2esult,$per2i,"CategoryID");
326 if(!is_numeric($PerCatID)) { $Per2Error = true; }
327 $CatPermissionInfo['ID'][$PerCatID]=sql_result($per2esult,$per2i,"id");
328 if(!is_numeric($CatPermissionInfo['ID'][$PerCatID])) { $Per2Error = true; }
329 $CatPermissionInfo['PermissionID'][$PerCatID]=sql_result($per2esult,$per2i,"PermissionID");
330 if(!is_numeric($CatPermissionInfo['PermissionID'][$PerCatID])) { $Per2Error = true; }
331 $CatPermissionInfo['Name'][$PerCatID]=sql_result($per2esult,$per2i,"Name");
332 $CatPermissionInfo['CategoryID'][$PerCatID]=sql_result($per2esult,$per2i,"CategoryID");
333 if(!is_numeric($CatPermissionInfo['CategoryID'][$PerCatID])) { $Per2Error = true; }
334 $CatPermissionInfo['CanViewCategory'][$PerCatID]=sql_result($per2esult,$per2i,"CanViewCategory");
335 if($CatPermissionInfo['CanViewCategory'][$PerCatID]!="yes"&&$CatPermissionInfo['CanViewCategory'][$PerCatID]!="no") { $Per2Error = true; }
336 if($Per2Error===true) { $per2i = $per2num; }
337 ++$per2i; } if($Per2Error===true) {
338 header("Content-Type: text/plain; charset=".$Settings['charset']); sql_free_result($per2esult);
339 ob_clean(); echo "Sorry could not load all permission data in database.\nContact the board admin about error.";
340 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); } }
341 sql_free_result($per2esult);