Forum fungiert als externer Link |
|
wolte fratgen ob es auch die möglichkeit gibt das er eine neue seite aufmacht oder tab ??? das würde mir weiter helfen
|
|
25.01.08 19:26 |
E-Mail
Finden
Als Freund hinzufügen
|
|
Kate
Mitglied
Dabei seit: 24.01.07
Beiträge: 31
Forenversion: Lite 1.0
|
|
Hallo,
gibt es eigentlich die Möglichkeit, dass das Forum nicht bei der Unterforenanzeige aufgelistet wird?
|
|
29.02.08 14:46 |
E-Mail
Finden
Als Freund hinzufügen
|
|
XeRanoN
Mitglied
Dabei seit: 23.04.04
Beiträge: 1.298
Fähigkeiten: WBB Lite 1 Profi Forenversion: Lite 1.0
Themenstarter
|
|
@hamsterklaue
Gibt es
Schau mal im myWBB Forum
@Kate
Wie meinen? Als nru auf der Startseite?
|
|
22.03.08 19:12 |
E-Mail
Finden
Als Freund hinzufügen
|
|
LilyJumper
Mitglied
Dabei seit: 11.09.08
Beiträge: 14
Fähigkeiten: WBB Lite 1 Anfänger Forenversion: Lite 1.0
|
|
Hallo,
ich habe auch das Problem mit folgender Fehlermeldung. Bin leider noch blutiger Anfänger und hab gar keine Ahnung, wo der Fehler sein könnte. Hab mir diese Datei (acp/board.php) schon mehrfach durchgesehen und mit der Installationsanleitung verglichen Wer kann helfen?
PS: Installationsdatei habe ich ausgeführt bzw zumindest habe ich sie geöffnet und da stand Installation abgeschlossen. Allerdings bin ich mir nicht sicher, ob ich da noch mehr machen muss. Bei mir kam nämlich nur das... Oder fehlt mir womöglich die nötige PHP version?
Zitat: |
SQL-DATABASE ERROR
Database error in WoltLab Burning Board: Invalid SQL: INSERT INTO bb1_boards (styleid,parentid,parentlist,childlist,boardorder,title,password,descriptio
n,allowbbcode,allowimages,allowhtml,allowsmilies,allowicons,daysprune,threa
dsperpage,postsperpage,postorder,hotthread_reply,hotthread_view,closed,isbo
ard,invisible,exurl) VALUES ('','0','0','0','5','trap','','','1','1','0','1','1','0','0','0','0','0','0
','0','1','0','')
mysql error: Unknown column 'exurl' in 'field list'
mysql error number: 1054
Date: 11.09.2008 @ 16:09
Script: /Forum/wbblite/acp/board.php
Referer: http://trapelus.tr.funpic.de/Forum/wbbli...action=add&sid= |
Zitat: |
<?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\"> </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 MA
boardorder) FROM bb".$n."_boards WHERE parentid = '$parentid'");
$boardorder+=1;
$db->query("INSERT INTO bb".$n."_boards (styleid,parentid,parentlist,childlist,boardorder,title,password,descriptio
n,allowbbcode,allowimages,allowhtml,allowsmilies,allowicons,daysprune,threa
dsperpage,postsperpage,postorder,hotthread_reply,hotthread_view,closed,isbo
ard,invisible,exurl)
VALUES ('$style_set','$parentid','$parentlist','0','$boardorder','".addslashes($ti
tle)."','".addslashes($password)."','".addslashes($description)."','$allowb
bcode','$allowimages','$allowhtml','$allowsmilies','$allowicons','$daysprun
e','".intval($threadsperpage)."','".intval($postsperpage)."','$postorder','
".intval($hotthread_reply)."','".intval($hotthread_view)."','$closed','$isb
oard','$invisible','$exurl')");
$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[gro
upid]])."','".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",tr
ue);
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",t
rue);
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', exurl='$exurl'
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[grou
pid]])."','".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";
$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(REPL
ACE(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(REP
LACE(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();
}
?> |
Dieser Beitrag wurde 5 mal editiert, zum letzten Mal von LilyJumper: 11.09.08 17:31.
|
|
11.09.08 16:09 |
E-Mail
Finden
Als Freund hinzufügen
|
|
XeRanoN
Mitglied
Dabei seit: 23.04.04
Beiträge: 1.298
Fähigkeiten: WBB Lite 1 Profi Forenversion: Lite 1.0
Themenstarter
|
|
Für spätere Problemhaber:
Die Install wurde nicht korrekt ausgeführt.
|
|
29.03.09 15:35 |
E-Mail
Finden
Als Freund hinzufügen
|
|
EmoPunk
Mitglied
Dabei seit: 07.05.08
Beiträge: 1
Forenversion: Lite 1.0
|
|
Huhu,
ich hab folgendes prob ich finde
php: |
1:
|
if(!isset($boardid)) eval("error(\"".$tpl->get("error_falselink")."\");"); |
|
in meiner board.php nicht
meine board.php sieht so aus
code: |
1:
|
<?php require ("./global.php"); isAdmin(); if(isset($_REQUEST['action'])) $action=$_REQUEST['action']; else $action="view"; function makeboardlist($boardid,$x=0) { global $boardcache, $session, $maxcolspan,$db,$n; if(!isset($boardcache[])) 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\"> </td>",$temp); else $tds=""; //LieblingsArea by Bruse & SeVenup $lainfo=$db->query("SELECT laarea, isboard FROM bb".$n."_boards WHERE boardid='$boards[boardid]'"); while ($row2 = $db->fetch_array($lainfo)) { if ($row2['isboard'] == 1) { if($row2['laarea'] == 0) $lieblings = "<a href='board.php?action=aktiv&do=send&boardid=$boards[boardid]&sid=$session[hash]'><b><font color='red'>Area Off</font></b></a>"; else $lieblings = "<a href='board.php?action=deaktiv&do=send&boardid=$boards[boardid]&sid=$session[hash]'><b><font color='green'>Area On</font></b></a>"; } else $lieblings=""; } //LieblingsArea ENDE 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+=3;; 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 (sbanzeige,styleid,parentid,parentlist,childlist,boardorder,title,password,description,allowbbcode,allowimages,allowhtml,allowsmilies,allowicons,daysprune,threadsperpage,postsperpage,postorder,hotthread_reply,hotthread_view,closed,isboard,invisible,exurl,countghpost) VALUES ('$sbanzeige','$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','$exurl','$countghpost')"); $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 sbanzeige='$sbanzeige',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', countghpost='$countghpost', threadsperpage='".intval($threadsperpage)."', postsperpage='".intval($postsperpage)."', postorder='$postorder', hotthread_reply='".intval($hotthread_reply)."', hotthread_view='".intval($hotthread_view)."', closed='$closed', isboard='$isboard', invisible='$invisible', exurl='$exurl' 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_sbanzeige[$board['sbanzeige']]=" 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_countghpost[$board['countghpost']]=" 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")."\");"); } //LieblingsArea Hack v.1 by Bruse if($_REQUEST['action'] == "aktiv") { $boardid=intval($_REQUEST['boardid']); $board=$db->query_first("SELECT * FROM bb".$n."_boards WHERE boardid = '$boardid'"); if($_REQUEST['do']=='send') { $db->unbuffered_query("UPDATE bb".$n."_boards SET laarea='1' WHERE boardid='$boardid'"); $db->query("INSERT INTO bb".$n."_lieblingsarea_boards (id,boardid,title) VALUES ('','".addslashes($boardid)."','".addslashes($board[title])."')"); } header("Location: board.php?action=view&sid=$session[hash]"); exit(); } if($_REQUEST['action'] == "deaktiv") { $boardid=intval($_REQUEST['boardid']); $la_info = $db->query_first("SELECT * FROM bb".$n."_lieblingsarea_boards WHERE boardid = '$boardid'"); if($_REQUEST['do']=='send') { $db->unbuffered_query("UPDATE bb".$n."_boards SET laarea='0' WHERE boardid='$boardid'"); $db->unbuffered_query("UPDATE bb".$n."_users SET laweahlt='0' WHERE laareaid='$la_info[id]'"); $db->unbuffered_query("DELETE FROM bb".$n."_lieblingsarea_boards WHERE boardid = '$boardid'"); } header("Location: board.php?action=view&sid=$session[hash]"); exit(); } //LieblingsArea Hack v.1 by Bruse 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(); } ?> |
|
Hatt sich erledigt wurde durch ein anderes addon verändern hab es gefunden
Dieser Beitrag wurde 3 mal editiert, zum letzten Mal von EmoPunk: 09.02.12 17:54.
|
|
09.02.12 17:48 |
E-Mail
Finden
Als Freund hinzufügen
|
|
Beckebans
Alternativ Mitglied
Dabei seit: 10.07.05
Beiträge: 481
Fähigkeiten: WBB Lite 1 Fortgeschritten Herkunft: Paderborn Forenversion: Lite 1.0
|
|
Wie kann ich denn die Foren, die als Link dienen in der Forenliste der Suche ausblenden?
Ich habe dies versucht, aber das klappt nicht. Der scheint das exurl nicht zu kennen:
==> acp/lib/functions.php
Suche (bei function makeboardselect):
php: |
1:
|
if($boards['invisible']==1 && $permissioncache[$boards['boardid']]['boardpermission'] == 0) continue; |
|
Darunter einfügen:
php: |
1:
|
if($boards['exurl']) continue; |
|
__________________ Meine Hacks:
- Userpage
- Geburtstagsliste
- Beitrag bedanken
- User verlinken
- PHP-Fehler anzeigen
- Umfragedauer
- Neue Beiträge während Eigenem
- Gruppenspezifische Mitgliederliste
- und weitere...
|
|
07.10.12 16:20 |
E-Mail
WWW
Finden
Als Freund hinzufügen
|
|
|