yourWBB | [WBB Lite 1.0.x] Allg. Fragen und Probleme

SQL-DATABASE ERROR Database error in WoltLab Burning Board: Invalid SQL: SELECT u.userid, u.username, u.invisible, u.receivepm, u.lastactivity, uf.* FROM bb1_users u, bb1_groups g LEFT JOIN bb1_userfields uf ON (u.userid=uf.userid) WHERE u.groupid = g.groupid AND g.ismod=1 ORDER BY u.username ASC mysql error: Unknown column 'u.userid' in 'on clause' mysql error number: 1054 Date: 12.04.2006 @ 20:21 Script: /Foren/wbblite/team.php?sid= Referer: http://localhost/Foren/wbblite/index.php

code:

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:

<?php
$filename="team.php";

require("./global.php");

$users = $db->query("SELECT
 u.userid, u.username, u.invisible, u.receivepm, u.lastactivity,
 uf.*,
 g.canuseacp
 FROM bb".$n."_groups g, bb".$n."_users u
 LEFT JOIN bb".$n."_userfields uf ON (u.userid=uf.userid)
 WHERE u.groupid = g.groupid AND (g.canuseacp = 1 OR g.issupermod = 1) ORDER BY g.canuseacp DESC, u.username ASC");

$acount=1;
$scount=1;

while($user = $db->fetch_array($users)) {
 $pm="";

 $posts['userid']=$user['userid'];
 $posts['username']=$user['username'];
 if(($user['invisible']==0 || $wbbuserdata['canuseacp']==1) && $user['lastactivity']>=time()-$useronlinetimeout*60) eval ("\$user_online = \"".$tpl->get("thread_user_online")."\";");
 else eval ("\$user_online = \"".$tpl->get("thread_user_offline")."\";");
 if($wbbuserdata['canusepms']==1 && $user['receivepm']!=0) eval ("\$pm = \"".$tpl->get("thread_pm")."\";");

 if($user['canuseacp']) {
  $tdbgcolor=getone($acount,"{tablecolorb}","{tablecolora}");
  $tdid=getone($acount,"tableb","tablea");
  eval("\$adminbits .= \"".$tpl->get("team_adminbit")."\";");
  $acount++;
 }
 else {
  $tdbgcolor=getone($scount,"{tablecolorb}","{tablecolora}");
  $tdid=getone($scount,"tableb","tablea");
  eval("\$supermodbits .= \"".$tpl->get("team_adminbit")."\";");
  $scount++;
 }
}

$boardids="";
$boardcache=array();
$modcache=array();
$result = $db->query("SELECT b.boardid, b.title, b.invisible, p.boardpermission FROM bb".$n."_boards b LEFT JOIN bb".$n."_permissions p ON (b.boardid=p.boardid AND p.groupid='$wbbuserdata[groupid]')");
while($row=$db->fetch_array($result)) {
 if($row['invisible']==1) continue;
 $boardcache[$row['boardid']]=$row;
 $boardids.=",".$row['boardid'];
}

$count=1;
$result = $db->query("SELECT userid, boardid FROM bb".$n."_moderators WHERE boardid IN (0$boardids) ORDER BY userid ASC");
while ($row = $db->fetch_array($result)) $modcache[$row['userid']][] = $row['boardid'];

$users = $db->query("SELECT
 u.userid, u.username, u.invisible, u.receivepm, u.lastactivity,
 uf.*
 FROM bb".$n."_users u, bb".$n."_groups g
 LEFT JOIN bb".$n."_userfields uf ON (u.userid=uf.userid)
 WHERE u.groupid = g.groupid AND g.ismod=1 ORDER BY u.username ASC");

while ($user = $db->fetch_array($users)) {
 $forumbits="";
 $pm="";

 $tdbgcolor=getone($count,"{tablecolorb}","{tablecolora}");
 $tdid=getone($count,"tableb","tablea");

 $posts['userid']=$user['userid'];
 $posts['username']=$user['username'];
 if(($user['invisible']==0 || $wbbuserdata['canuseacp']==1) && $user['lastactivity']>=time()-$useronlinetimeout*60) eval ("\$user_online = \"".$tpl->get("thread_user_online")."\";");
 else eval ("\$user_online = \"".$tpl->get("thread_user_offline")."\";");
 if($wbbuserdata['canusepms']==1 && $user['receivepm']!=0) eval ("\$pm = \"".$tpl->get("thread_pm")."\";");

 for($i=0;$i<count($modcache[$user['userid']]);$i++) {
  $boardid=$modcache[$user['userid']][$i];
  if(!$boardcache[$boardid]['boardpermission'] && $boardcache[$boardid]['invisible']==1) continue;
  $forumbits .= makehreftag("board.php?boardid=$boardid&sid=$session[hash]",$boardcache[$boardid]['title'])."<br>";
 }

 eval("\$moderatorbits .= \"".$tpl->get("team_modbit")."\";");
 $count++;
}

unset($boardcache);

if($showboardjump==1) $boardjump=makeboardjump(0);
eval("\$tpl->output(\"".$tpl->get("team")."\");");
?>

$users = $db->query("SELECT u.userid, u.username, u.invisible, u.receivepm, u.lastactivity, uf.* FROM bb".$n."_users u, bb".$n."_groups g LEFT JOIN bb".$n."_userfields uf ON (u.userid=uf.userid) WHERE u.groupid = g.groupid AND g.ismod=1 ORDER BY u.username ASC");