MYSQL Fehler - Moderatoren

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `bb1_moderators`
-- 

CREATE TABLE `bb1_moderators` (
  `userid` int(11) unsigned NOT NULL default '0',
  `boardid` int(11) unsigned NOT NULL default '0',
  `notify_newpost` tinyint(1) NOT NULL default '0',
  `notify_newthread` tinyint(1) NOT NULL default '0',
  `m_can_thread_close` tinyint(1) NOT NULL default '-1',
  `m_can_thread_move` tinyint(1) NOT NULL default '-1',
  `m_can_thread_edit` tinyint(1) NOT NULL default '-1',
  `m_can_post_del` tinyint(1) NOT NULL default '-1',
  `m_can_thread_del` tinyint(1) NOT NULL default '-1',
  `m_can_thread_merge` tinyint(1) NOT NULL default '-1',
  `m_can_thread_cut` tinyint(1) NOT NULL default '-1',
  `m_can_thread_top` tinyint(1) NOT NULL default '-1',
  `m_can_add_poll` tinyint(1) NOT NULL default '-1',
  `m_can_post_edit` tinyint(1) NOT NULL default '-1',
  `m_can_announce` tinyint(1) NOT NULL default '-1',
  `m_can_edit_poll` tinyint(1) NOT NULL default '-1',
  PRIMARY KEY  (`userid`,`boardid`),
  KEY `userid` (`userid`)
) TYPE=MyISAM;

-- 
-- Daten für Tabelle `bb1_moderators`
-- 

INSERT INTO `bb1_moderators` VALUES (1, 10, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 9, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 8, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 12, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 11, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 6, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 7, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 13, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (7, 15, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 41, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 17, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (7, 18, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 46, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 20, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 21, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 18, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 45, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 15, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (5, 34, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 24, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (5, 25, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 26, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (5, 8, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 25, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 27, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 28, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 29, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 30, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (5, 16, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 31, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (7, 19, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (7, 23, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (5, 32, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (7, 11, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (5, 33, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 17, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (6, 34, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 8, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 25, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 33, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 32, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 32, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 33, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 35, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 36, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 37, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 38, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 39, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 40, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 41, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (6, 16, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 43, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 47, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 55, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 45, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (8, 46, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 49, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 50, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 51, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 52, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 53, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 56, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 57, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (70, 16, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (70, 34, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
INSERT INTO `bb1_moderators` VALUES (1, 58, 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:

<?php
require ("./global.php");
isAdmin();

if(isset($_REQUEST['action'])) $action=$_REQUEST['action'];
else $action="view";

function makeboardlist($boardid,$x=0) {
 global $boardcache, $session, $maxcolspan;

 if(!isset($boardcache[$boardid])) return;

 while (list($key1,$val1) = each($boardcache[$boardid])) {
  while(list($key2,$boards) = each($val1)) {
   $count = countboards($boardcache[$boardid]);
   unset($options);
   for($i = 1; $i <= $count; $i++) $options .= makeoption($i,$i,$boards['boardorder'],1);
   $colspan=$maxcolspan-$x;
   $temp=$maxcolspan-($maxcolspan-$x);
   if($temp) $tds=str_repeat("<td class=\"secondrow\">&nbsp;&nbsp;</td>",$temp);
   else $tds="";
   eval ("\$out .= \"".gettemplate("board_viewbit")."\";");
   $out .= makeboardlist($boards['boardid'],$x+1);
  }
 }
 unset($boardcache[$boardid]);
 return $out;
}

function countboards($array) {
 $count=0;
 reset($array);
 while(list($key,$val)=each($array)) $count+=count($val);
 return $count;
}

if($action == "view") {
 if(isset($_POST['send'])) {
  reset($_POST['boardorder']);
  while(list($key,$val)=each($_POST['boardorder'])) $db->query("UPDATE bb".$n."_boards SET boardorder='$val' WHERE boardid = '$key'");
 }

 $maxcolspan=0;
 $result = $db->query("SELECT boardid, parentid, boardorder, title, parentlist FROM bb".$n."_boards ORDER by parentid ASC, boardorder ASC");
 while ($row = $db->fetch_array($result)) {
  $temp=count(explode(",",$row['parentlist']));
  if($temp>$maxcolspan) $maxcolspan=$temp;
  $boardcache[$row['parentid']][$row['boardorder']][$row['boardid']] = $row;
 }
 $boardlist = makeboardlist(0);
 $maxcolspan+=2;
 eval("print(\"".gettemplate("board_view")."\");");
}

if($action == "add") {
 if(isset($_POST['send'])) {
  reset($_POST);
  while(list($key,$val)=each($_POST)) $$key=$val;

  if($parentid==0) $parentlist="0";
  else {
   $result = $db->query_first("SELECT parentlist FROM bb".$n."_boards WHERE boardid = '$parentid'");
   $parentlist = $result['parentlist'].",".$parentid;
  }

  $prefix = preg_replace("/\s*\n\s*/","\n",trim($prefix));

  list($boardorder)=$db->query_first("SELECT MAX(boardorder) FROM bb".$n."_boards WHERE parentid = '$parentid'");
  $boardorder+=1;

  $db->query("INSERT INTO bb".$n."_boards (styleid,parentid,parentlist,childlist,boardorder,title,password,description,allowbbcode,allowimages,allowhtml,allowsmilies,allowicons,daysprune,threadsperpage,postsperpage,postorder,hotthread_reply,hotthread_view,closed,isboard,invisible,countuserposts)
  VALUES ('$style_set','$parentid','$parentlist','0','$boardorder','".addslashes($title)."','".addslashes($password)."','".addslashes($description)."','$allowbbcode','$allowimages','$allowhtml','$allowsmilies','$allowicons','$daysprune','".intval($threadsperpage)."','".intval($postsperpage)."','$postorder','".intval($hotthread_reply)."','".intval($hotthread_view)."','$closed','$isboard','$invisible','$countuserposts')");
  $insertid = $db->insert_id();

  if($parentlist!='0') $db->query("UPDATE bb".$n."_boards SET childlist=CONCAT(childlist,',$insertid') WHERE boardid IN ($parentlist)");

  if($isboard==1) for($i = 0; $i < count($boardmods); $i++) $db->query("REPLACE INTO bb".$n."_moderators VALUES ('$boardmods[$i]','$insertid')");

  $tempbp=array();
  $tempsp=array();
  $temprp=array();
  if(is_array($boardpermission)) while(list($key,$val)=each($boardpermission)) if($val!='*') $tempbp[$val]=1;
  if(is_array($startpermission)) while(list($key,$val)=each($startpermission)) if($val!='*') $tempsp[$val]=1;
  if(is_array($replypermission)) while(list($key,$val)=each($replypermission)) if($val!='*') $temprp[$val]=1;

  $result = $db->query("SELECT groupid FROM bb".$n."_groups");
  while($row=$db->fetch_array($result)) $db->query("REPLACE INTO bb".$n."_permissions VALUES ('$insertid','$row[groupid]','".ifelse($boardpermission[0]=='*',"1",$tempbp[$row[groupid]])."','".ifelse($startpermission[0]=='*',"1",$tempsp[$row[groupid]])."','".ifelse($replypermission[0]=='*',"1",$temprp[$row[groupid]])."')");

  header("Location: board.php?action=view&sid=$session[hash]");
  exit();
 }

 $result = $db->query("SELECT boardid, parentid, boardorder, title FROM bb".$n."_boards ORDER by parentid ASC, boardorder ASC");
 while ($row = $db->fetch_array($result)) $boardcache[$row['parentid']][$row['boardorder']][$row['boardid']] = $row;

 $parentid_options = makeboardoptions(0);

 $result = $db->query("SELECT groupid, title FROM bb".$n."_groups ORDER BY title ASC");
 while($row = $db->fetch_array($result)) $groupoptions.=makeoption($row['groupid'],$row['title'],"",0);
 $db->free_result($result);

 $result = $db->query("SELECT styleid, stylename FROM bb".$n."_styles WHERE default_style <> 1 ORDER BY stylename ASC");
 while($row = $db->fetch_array($result)) $style_options .= makeoption($row['styleid'],$row['stylename'],"",0);
 $db->free_result($result);

 $result = $db->query("SELECT userid, username FROM bb".$n."_users LEFT JOIN bb".$n."_groups USING (groupid) WHERE ismod = 1 OR issupermod = 1 ORDER BY username ASC");
 while($row = $db->fetch_array($result)) $mod_options .= makeoption($row['userid'],$row['username'],"",0);
 $db->free_result($result);

 eval("print(\"".gettemplate("board_add")."\");");
}

if($action == "edit") {
 $boardid=intval($_REQUEST[boardid]);
 $board = $db->query_first("SELECT * FROM bb".$n."_boards WHERE boardid = '$boardid'");
 if(isset($_POST['send'])) {
  reset($_POST);
  while(list($key,$val)=each($_POST)) $$key=$val;

  if($board['parentid']!=$parentid) {
   $threadcount=$board['threadcount'];
   $postcount=$board['postcount'];

   if($parentid!=0) {
    list($parentlist)=$db->query_first("SELECT parentlist FROM bb".$n."_boards WHERE boardid='$parentid'");
    $parentlist.=",$parentid";
    $db->query("UPDATE bb".$n."_boards SET threadcount=threadcount+$threadcount, postcount=postcount+$postcount WHERE boardid IN ($parentlist)");
    updateList($parentlist,"$boardid,$board[childlist]","childlist");
   }
   else $parentlist=0;
   $parentchange=" parentid='$parentid', parentlist='$parentlist',";

   if($board['parentlist']!="0") {
    $db->query("UPDATE bb".$n."_boards SET threadcount=threadcount-$threadcount, postcount=postcount-$postcount WHERE boardid IN ($board[parentlist])");
    updateList($board['parentlist'],"$boardid,$board[childlist]","childlist",true);

    updateBoardInfo("$board[parentlist]",$board['lastposttime']);
   }

   if($parentlist!="0") updateBoardInfo("$parentlist",$board['lastposttime']);
  }

  if($board['parentid']!=$parentid && $board['childlist']!="0" && $board['childlist']!="") {
   updateList($board['childlist'],"$board[parentlist],$boardid","parentlist",true);
   updateList($board['childlist'],"$parentlist,$boardid","parentlist");
  }

  $prefix = preg_replace("/\s*\n\s*/","\n",trim($prefix));

  $db->query("UPDATE bb".$n."_boards SET
  styleid='$style_set',$parentchange title='".addslashes($title)."', password='".addslashes($password)."', description='".addslashes($description)."', allowbbcode='$allowbbcode', allowimages='$allowimages', allowhtml='$allowhtml', allowsmilies='$allowsmilies', allowicons='$allowicons', daysprune='$daysprune',
  threadsperpage='".intval($threadsperpage)."', postsperpage='".intval($postsperpage)."', postorder='$postorder', hotthread_reply='".intval($hotthread_reply)."', hotthread_view='".intval($hotthread_view)."', closed='$closed', isboard='$isboard', invisible='$invisible', countuserposts='$countuserposts'


  WHERE boardid='$boardid'");

  $db->query("DELETE FROM bb".$n."_moderators WHERE boardid='$boardid'");
  if($isboard==1) for($i = 0; $i < count($boardmods); $i++) $db->query("INSERT INTO bb".$n."_moderators VALUES ('$boardmods[$i]','$boardid')");

  $db->query("DELETE FROM bb".$n."_permissions WHERE boardid='$boardid'");

  $tempbp=array();
  $tempsp=array();
  $temprp=array();
  for($i=0;$i<count($boardpermission);$i++) if($boardpermission[$i]!='*') $tempbp[$boardpermission[$i]]=1;
  for($i=0;$i<count($startpermission);$i++) if($startpermission[$i]!='*') $tempsp[$startpermission[$i]]=1;
  for($i=0;$i<count($replypermission);$i++) if($replypermission[$i]!='*') $temprp[$replypermission[$i]]=1;

  $result = $db->query("SELECT groupid FROM bb".$n."_groups");
  while($row=$db->fetch_array($result)) $db->query("INSERT INTO bb".$n."_permissions VALUES ('$boardid','$row[groupid]','".ifelse($boardpermission[0]=='*',"1",$tempbp[$row[groupid]])."','".ifelse($startpermission[0]=='*',"1",$tempsp[$row[groupid]])."','".ifelse($replypermission[0]=='*',"1",$temprp[$row[groupid]])."')");

  header("Location: board.php?action=view&sid=$session[hash]");
  exit();
 }

 reset($board);
 while(list($key,$val)=each($board)) $board[$key]=htmlspecialchars($val);

 $sel_isboard[$board['isboard']]=" selected";
 $sel_closed[$board['closed']]=" selected";
 $sel_invisible[$board['invisible']]=" selected";
 $sel_allowbbcode[$board['allowbbcode']]=" selected";
 $sel_allowimages[$board['allowimages']]=" selected";
 $sel_allowhtml[$board['allowhtml']]=" selected";
 $sel_allowsmilies[$board['allowsmilies']]=" selected";
 $sel_allowicons[$board['allowicons']]=" selected";
 $sel_daysprune[$board['daysprune']]=" selected";
 $sel_postorder[$board['postorder']]=" selected";
 $sel_countuserposts[$board['countuserposts']]=" selected";

 $result = $db->query("SELECT boardid, parentid, boardorder, title FROM bb".$n."_boards WHERE boardid <> '$boardid' ORDER by parentid ASC, boardorder ASC");
 while ($row = $db->fetch_array($result)) $boardcache[$row['parentid']][$row['boardorder']][$row['boardid']] = $row;
 $db->free_result($result);

 $parentid_options = makeboardoptions(0,1,1,$board['parentid']);

 $result = $db->query("SELECT userid FROM bb".$n."_moderators WHERE boardid='$boardid'");
 while($row=$db->fetch_array($result)) $mods[]=$row['userid'];
 $db->free_result($result);

 $result = $db->query("SELECT userid, username FROM bb".$n."_users LEFT JOIN bb".$n."_groups USING (groupid) WHERE ismod = 1 OR issupermod = 1 ORDER BY username ASC");
 while($row = $db->fetch_array($result)) $mod_options .= makeoption($row['userid'],$row['username'],$mods,1);
 $db->free_result($result);

 $result = $db->query("SELECT styleid, stylename FROM bb".$n."_styles WHERE default_style <> 1 ORDER BY stylename ASC");
 while($row = $db->fetch_array($result)) $style_options .= makeoption($row['styleid'],$row['stylename'],$board['styleid'],1);
 $db->free_result($result);

 $count_bp = 0;
 $count_sp = 0;
 $count_rp = 0;
 $result = $db->query("SELECT * FROM bb".$n."_permissions WHERE boardid='$boardid'");
 while($row=$db->fetch_array($result)) {
  if($row['boardpermission']==1) $bps[]=$row['groupid'];
  if($row['startpermission']==1) $sps[]=$row['groupid'];
  if($row['replypermission']==1) $rps[]=$row['groupid'];
  $count_bp += $row['boardpermission'];
  $count_sp += $row['startpermission'];
  $count_rp += $row['replypermission'];
 }
 $db->free_result($result);

 $result = $db->query("SELECT groupid, title FROM bb".$n."_groups ORDER BY groupid ASC");
 $count=$db->num_rows($result);

 if($count==$count_bp) $bp_selected = " selected";
 if($count==$count_sp) $sp_selected = " selected";
 if($count==$count_rp) $rp_selected = " selected";

 while($row = $db->fetch_array($result)) {
  $bp_options .= makeoption($row['groupid'],$row['title'],$bps,ifelse($bp_selected,0,1));
  $sp_options .= makeoption($row['groupid'],$row['title'],$sps,ifelse($sp_selected,0,1));
  $rp_options .= makeoption($row['groupid'],$row['title'],$rps,ifelse($rp_selected,0,1));
 }
 $db->free_result($result);

 eval("print(\"".gettemplate("board_edit")."\");");
}

function emptyboard($boardid) {
 global $board, $db, $n;

 /* countuserposts */
 if($board['countuserposts']==1) {
  $result = $db->query("SELECT COUNT(p.postid) AS posts, p.userid FROM bb".$n."_posts p, bb".$n."_threads t WHERE p.threadid=t.threadid AND t.boardid='$boardid' AND p.visible = 1 AND p.userid>0 GROUP BY p.userid");
  while($row=$db->fetch_array($result)) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'",1);
 }

 /* delete posts & threads */
 $threadids="";
 $result = $db->query("SELECT threadid FROM bb".$n."_threads WHERE boardid='$boardid'");
 while($row=$db->fetch_array($result)) $threadids.=",".$row['threadid'];
 $db->unbuffered_query("DELETE FROM bb".$n."_posts WHERE threadid IN (0$threadids)",1);
 $db->unbuffered_query("DELETE FROM bb".$n."_threads WHERE pollid IN (0$threadids) AND closed=3",1);
 $db->unbuffered_query("DELETE FROM bb".$n."_announcements WHERE threadid IN (0$threadids)",1);
 $db->unbuffered_query("DELETE FROM bb".$n."_threads WHERE boardid='$boardid'",1);
 $db->unbuffered_query("DELETE FROM bb".$n."_subscribethreads WHERE threadid IN (0$threadids)",1);

 /* delete poll(options|votes) */
 $pollids="";
 $result = $db->query("SELECT pollid FROM bb".$n."_polls WHERE threadid IN (0$threadids)");
 while($row=$db->fetch_array($result)) $pollids.=",".$row['pollid'];
 $db->unbuffered_query("DELETE FROM bb".$n."_polloptions WHERE pollid IN (0$pollids)",1);
 $db->unbuffered_query("DELETE FROM bb".$n."_votes WHERE id IN (0$pollids) AND votemode=1",1);
 $db->unbuffered_query("DELETE FROM bb".$n."_polls WHERE pollid IN (0$pollids)",1);

 /* update parent boards */
 if($board['parentid']!=0) {
  $db->unbuffered_query("UPDATE bb".$n."_boards SET threadcount=threadcount-'$board[threadcount]', postcount=postcount-'$board[postcount]' WHERE boardid IN ($board[parentlist])",1);
  updateBoardInfo("$board[parentlist]",0,$board['lastthreadid']);
 }
}

if($action=="del") {
 $boardid=intval($_REQUEST['boardid']);
 $board=$db->query_first("SELECT * FROM bb".$n."_boards WHERE boardid = '$boardid'");

 if(isset($_POST['send'])) {
  emptyboard($boardid);
  $db->unbuffered_query("DELETE FROM bb".$n."_boards WHERE boardid = '$boardid'",1);
  if($board['parentid']!=0) $db->unbuffered_query("UPDATE bb".$n."_boards SET childlist = SUBSTRING(REPLACE(CONCAT(',',childlist,','),',$boardid,',','),2,LENGTH(REPLACE(CONCAT(',',childlist,','),',$boardid,',','))-2) WHERE boardid IN ($board[parentlist])",1);

  if($board['childlist']!="0") {
   $db->unbuffered_query("UPDATE bb".$n."_boards SET parentlist = SUBSTRING(REPLACE(CONCAT(',',parentlist,','),',$boardid,',','),2,LENGTH(REPLACE(CONCAT(',',parentlist,','),',$boardid,',','))-2) WHERE boardid IN ($board[childlist])",1);
   $db->unbuffered_query("UPDATE bb".$n."_boards SET parentid='$board[parentid]' WHERE parentid = '$boardid'",1);
  }
  $db->unbuffered_query("DELETE FROM bb".$n."_moderators WHERE boardid = '$boardid'",1);
  $db->unbuffered_query("DELETE FROM bb".$n."_permissions WHERE boardid = '$boardid'",1);
  $db->unbuffered_query("DELETE FROM bb".$n."_subscribeboards WHERE boardid = '$boardid'",1);

  header("Location: board.php?action=view&sid=$session[hash]");
  exit();
 }

 eval("print(\"".gettemplate("board_del")."\");");
}

if($action=="sync") {
 $result = $db->query("SELECT boardid, parentid FROM bb".$n."_boards ORDER by parentid ASC");
 while ($row = $db->fetch_array($result)) $boardcache[$row['parentid']][$row['boardid']] = $row;

 function syncBoards($parentid,$parentlist="0") {
  global $boardcache, $db, $n;

  if(!isset($boardcache[$parentid])) {
   if($parentid!=0) $db->query("UPDATE bb".$n."_boards SET childlist='0' WHERE boardid='$parentid'");
   return;
  }

  $childlist="";
  $updatelist="";
  while(list($boardid,$board)=each($boardcache[$parentid])) {
   $childlist.=",$boardid";
   $childlist.=syncBoards($boardid,$parentlist.",$boardid");

   $updatelist.=",$boardid";
  }

  $db->query("UPDATE bb".$n."_boards SET parentlist='$parentlist' WHERE boardid IN (0$updatelist)");
  if($parentid!=0) $db->query("UPDATE bb".$n."_boards SET childlist='0$childlist' WHERE boardid='$parentid'");

  return $childlist;
 }

 syncBoards(0);

 header("Location: board.php?action=view&sid=$session[hash]");
 exit();
}
?>

1:

$db->query("INSERT INTO bb".$n."_moderators VALUES ('$boardmods[$i]','$boardid')");

1:

$db->query("INSERT INTO bb".$n."_moderators (userid,boardid) VALUES ('$boardmods[$i]','$boardid')");