mysql error number: 1064 |
saen
Mitglied
Dabei seit: 12.02.13
Beiträge: 65
Fähigkeiten: WBB Lite 1 Anfänger Forenversion: Lite 1.0
|
|
Hallo Leute
ich hab ein Problem. Ich hab allerdings keine Ahnung mehr was ich noch machen soll
Zitat: |
SQL-DATABASE ERROR
Database error in WoltLab Burning Board: Invalid SQL: SELECT p.*, u.userposts, u.regdate, u.signature, u.email, u.homepage, u.icq, u.aim, u.yim, u.msn, u.showemail, u.receivepm, u.usercanemail, u.gender, u.invisible, u.title, u.lastactivity, u.useronlinemarking AS marking, g.useronlinemarking, u.groupid, ar.ranktitle AS altranktitle, ar.rankimages AS altrankimages, r.ranktitle, r.rankimages, , uf.* , i.iconpath, i.icontitle , av.avatarid, av.avatarextension, av.width, av.height FROM bb1_posts p LEFT JOIN bb1_users u USING (userid) LEFT JOIN bb1_groups g ON (g.groupid=u.groupid) LEFT JOIN bb1_groups g USING (groupid) LEFT JOIN bb1_ranks r USING (rankid) LEFT JOIN bb1_altranks ar ON (ar.rankid=u.altrankid) LEFT JOIN bb1_userfields uf ON (u.userid=uf.userid) LEFT JOIN bb1_icons i ON (p.iconid=i.iconid) LEFT JOIN bb1_avatars av ON (u.avatarid=av.avatarid) WHERE p.postid IN (0,3) ORDER BY p.posttime ASC
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' uf.* , i.iconpath, i.icontitle , av.avatarid, av.avatarextension, av.width, av.' at line 24
mysql error number: 1064
Date: 30.04.2013 @ 09:38
Script: /wbblite/thread.php?sid=&postid=3
Referer: http://justreally.ju.ohost.de/wbblite/
|
Wo oder nach was muss ich denn jetzt suchen? Ich weiß nich mehr weiter
lg
Saen
|
|
30.04.13 09:46 |
E-Mail
WWW
Finden
Als Freund hinzufügen
|
|
C-Board unregistriert
|
|
Direkt vor
ist ein Komma zuviel.
Gruß Mike
|
|
30.04.13 11:51 |
|
|
saen
Mitglied
Dabei seit: 12.02.13
Beiträge: 65
Fähigkeiten: WBB Lite 1 Anfänger Forenversion: Lite 1.0
Themenstarter
|
|
ahhh super, dann is das schon ma weg :d danke.. ^^ aber was is das jetzt?
Zitat: |
|SQL-DATABASE ERROR
Database error in WoltLab Burning Board: Invalid SQL: SELECT p.*, u.userposts, u.regdate, u.signature, u.email, u.homepage, u.icq, u.aim, u.yim, u.msn, u.showemail, u.receivepm, u.usercanemail, u.gender, u.invisible, u.title, u.lastactivity, u.useronlinemarking AS marking, g.useronlinemarking, u.groupid, ar.ranktitle AS altranktitle, ar.rankimages AS altrankimages, r.ranktitle, r.rankimages , uf.* , i.iconpath, i.icontitle , av.avatarid, av.avatarextension, av.width, av.height FROM bb1_posts p LEFT JOIN bb1_users u USING (userid) LEFT JOIN bb1_groups g ON (g.groupid=u.groupid) LEFT JOIN bb1_groups g USING (groupid) LEFT JOIN bb1_ranks r USING (rankid) LEFT JOIN bb1_altranks ar ON (ar.rankid=u.altrankid) LEFT JOIN bb1_userfields uf ON (u.userid=uf.userid) LEFT JOIN bb1_icons i ON (p.iconid=i.iconid) LEFT JOIN bb1_avatars av ON (u.avatarid=av.avatarid) WHERE p.postid IN (0,4) ORDER BY p.posttime ASC
mysql error: Not unique table/alias: 'g'
mysql error number: 1066
Date: 30.04.2013 @ 12:48
Script: /wbblite/thread.php?sid=&postid=4
Referer: http://justreally.ju.ohost.de/wbblite/index.php?sid= |
ich kopier mal das ganze:
php: |
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:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
|
<?php
$filename="thread.php";
require("./global.php");
require("./acp/lib/class_parse.php");
if((!isset($postid) && !isset($threadid)) || $thread['closed']==3) eval("error(\"".$tpl->get("error_falselink")."\");");
if($wbbuserdata['canuseacp']==1 || $wbbuserdata['issupermod']==1 || ($wbbuserdata['ismod']==1 && $modpermissions['userid'])) $visible="";
else $visible="AND visible=1";
if($_REQUEST['goto']=="lastpost") {
$result = $db->query_first("SELECT postid FROM bb".$n."_posts WHERE threadid = '$threadid' $visible ORDER BY posttime DESC LIMIT 1");
header("Location: thread.php?sid=$session[hash]&postid=$result[postid]#post$result[postid]");
exit();
}
if(isset($_COOKIE['threadvisit'])) $threadvisit=decode_cookie($_COOKIE['threadvisit']);
else $threadvisit=array();
if(isset($_COOKIE['postvisit'])) $postvisit=decode_cookie($_COOKIE['postvisit']);
else $postvisit=array();
if($_REQUEST['goto']=="firstnew") {
if($threadvisit[$threadid]<$wbbuserdata['lastvisit']) $threadvisit[$threadid]=$wbbuserdata['lastvisit'];
$result = $db->query_first("SELECT postid FROM bb".$n."_posts WHERE threadid='$threadid' AND posttime>'".intval($threadvisit[$threadid])."' $visible ORDER BY posttime ASC",1);
if($result['postid']) header("Location: thread.php?sid=$session[hash]&postid=$result[postid]#post$result[postid]");
else header("Location: thread.php?goto=lastpost&threadid=$threadid&sid=$session[hash]");
exit();
}
if($_REQUEST['goto']=="nextnewest") {
$result = $db->query_first("SELECT threadid FROM bb".$n."_threads WHERE visible = 1 AND lastposttime>'$thread[lastposttime]' AND closed <> 3 AND boardid = '$boardid' ORDER BY lastposttime ASC",1);
if(!$result['threadid']) eval("error(\"".$tpl->get("error_nonextnewest")."\");");
$threadid=$result['threadid'];
$thread = $db->query_first("SELECT * FROM bb".$n."_threads WHERE threadid = '$threadid'");
}
if($_REQUEST['goto']=="nextoldest") {
$result = $db->query_first("SELECT threadid FROM bb".$n."_threads WHERE visible = 1 AND lastposttime<'$thread[lastposttime]' AND closed <> 3 AND boardid = '$boardid' ORDER BY lastposttime DESC",1);
if(!$result['threadid']) eval("error(\"".$tpl->get("error_nonextoldest")."\");");
$threadid=$result['threadid'];
$thread = $db->query_first("SELECT * FROM bb".$n."_threads WHERE threadid = '$threadid'");
}
if($wbbuserdata['umaxposts']) $postsperpage=$wbbuserdata['umaxposts'];
elseif($board['postsperpage']) $postsperpage=$board['postsperpage'];
else $postsperpage=$default_postsperpage;
$postorder=$board['postorder'];
if(isset($postid)) {
if($postorder==0) $result = $db->query_first("SELECT COUNT(*) AS posts FROM bb".$n."_posts WHERE threadid='$threadid' AND postid<='$postid' $visible");
else $result = $db->query_first("SELECT COUNT(*) AS posts FROM bb".$n."_posts WHERE threadid='$threadid' AND postid>='$postid' $visible");
$_GET['page']=ceil($result['posts']/$postsperpage);
}
$db->unbuffered_query("UPDATE bb".$n."_threads SET views=views+1 WHERE threadid='$threadid'",1);
$boardnavcache=array();
if($showboardjump==1) $boardjump=makeboardjump($boardid);
$navbar=getNavbar($board['parentlist']);
eval ("\$navbar .= \"".$tpl->get("navbar_board")."\";");
/* flat view */
if($threadview==0) {
$result = $db->query_first("SELECT COUNT(*) FROM bb".$n."_posts WHERE threadid = '$threadid' $visible");
$postcount = $result[0];
if(isset($_GET['page'])) {
$page=intval($_GET['page']);
if($page==0) $page=1;
}
else $page=1;
$pages = ceil($postcount/$postsperpage);
if($pages>1) $pagelink=makepagelink("thread.php?threadid=$threadid&sid=$session[hash]",$page,$pages,$showpagelinks-1);
$postids="";
$result = $db->query("SELECT postid FROM bb".$n."_posts WHERE threadid = '$threadid' $visible ORDER BY posttime ".ifelse($postorder,"DESC","ASC")." LIMIT ".($postsperpage*($page-1)).",".$postsperpage);
while($row=$db->fetch_array($result)) $postids .= ",".$row['postid'];
}
$parse = new parse($docensor,75,$board['allowsmilies'],$board['allowbbcode'],$wbbuserdata['showimages'],$usecode);
if($showuserfieldsinthread){
$userfields=", uf.*";
$userfieldsjoin=" LEFT JOIN bb".$n."_userfields uf ON (u.userid=uf.userid)";
$result=$db->query("SELECT * FROM bb".$n."_profilefields WHERE showinthread=1 ".(!$wbbuserdata['canuseacp']?" AND hidden=0":"")." ORDER BY fieldorder ASC");
while($row=$db->fetch_array($result)){
if(!$row['group_pfexist']) continue;
$temp=explode(",",$row['group_pfexist']);
while(list(,$val)=each($temp)) $userfieldcache[$val][]=$row['profilefieldid'];
$profilefieldcache[$row['profilefieldid']]=$row;
}
} else {
$userfields="";
$userfieldsjoin="";
}
if($showavatar==1) {
$avatar=", av.avatarid, av.avatarextension, av.width, av.height";
$avatarjoin="LEFT JOIN bb".$n."_avatars av ON (u.avatarid=av.avatarid)";
}
else {
$avatar="";
$avatarjoin="";
}
if($board['allowicons']==1) {
$icon=", i.iconpath, i.icontitle";
$iconjoin="LEFT JOIN bb".$n."_icons i ON (p.iconid=i.iconid)";
}
else {
$icon="";
$iconjoin="";
}
$exists = $db->query_first("SHOW COLUMNS FROM bb".$n."_groups LIKE 'showonteam'");
if($exists) $group = " g.showonteam,";
$result = $db->query("SELECT
p.*,
u.userposts,
u.regdate,
u.signature,
u.email,
u.homepage,
u.icq,
u.aim,
u.yim,
u.msn,
u.showemail,
u.receivepm,
u.usercanemail,
u.gender,
u.invisible,
u.title,
u.lastactivity,
u.useronlinemarking AS marking,
g.useronlinemarking,
u.groupid,
ar.ranktitle AS altranktitle, ar.rankimages AS altrankimages,
r.ranktitle, r.rankimages
$userfields
$icon
$avatar
FROM bb".$n."_posts p
LEFT JOIN bb".$n."_users u USING (userid)
LEFT JOIN bb".$n."_groups g ON (g.groupid=u.groupid)
LEFT JOIN bb".$n."_groups g USING (groupid)
LEFT JOIN bb".$n."_ranks r USING (rankid)
LEFT JOIN bb".$n."_altranks ar ON (ar.rankid=u.altrankid)
$userfieldsjoin
$iconjoin
$avatarjoin
WHERE p.postid IN (0$postids)
ORDER BY p.posttime ".ifelse($postorder,"DESC","ASC"));
$count=0;
while($posts=$db->fetch_array($result)) {
if($userfieldcache[$posts['groupid']]) reset($userfieldcache[$posts['groupid']]);
$signature="";
$threadstarter="";
$lastedit="";
$search="";
$homie="";
$email="";
$homepage="";
$icq="";
$aim="";
$yim="";
$user_online="";
$userfields="";
$gender="";
$useravatar="";
$rankimages="";
$setvisible="";
$pm="";
$invisible="";
/** mod/admin option -> set visible post **/
if($posts['visible']==0 && $posts['posttime']!=$thread['starttime']) eval ("\$invisible = \"".$tpl->get("thread_invisible")."\";");
$tdbgcolor=getone($count,"{tablecolorb}","{tablecolora}");
$tdid=getone($count,"tableb","tablea");
$posts['message']=$parse->doparse($posts['message'],$posts['allowsmilies']*$board['allowsmilies'],$board['allowhtml'],$board['allowbbcode'],$board['allowimages']);
$posts['posttopic']=$parse->textwrap($posts['posttopic'],30);
if($posts['iconid'] && $board['allowicons']==1) $posticon=makeimgtag($posts['iconpath'],$posts['icontitle']);
else $posticon="";
if($wbbuserdata['lastvisit']<=$posts['posttime'] && $postvisit[$posts['postid']]!=1) eval ("\$postsign = \"".$tpl->get("thread_newpost")."\";");
else eval ("\$postsign = \"".$tpl->get("thread_nonewpost")."\";");
$postdate=formatdate($dateformat,$posts['posttime'],1);
$posttime=formatdate($timeformat,$posts['posttime']);
if($posts['editorid']) {
$editdate=formatdate($dateformat,$posts['edittime']);
$edittime=formatdate($timeformat,$posts['edittime']);
eval ("\$lastedit = \"".$tpl->get("thread_lastedit")."\";");
}
if($posts['userid']) {
if($posts['altrankimages']) $rankimages=formatRI($posts['altrankimages']);
else $rankimages=formatRI($posts['rankimages']);
if($rankimages) eval ("\$rankimages = \"".$tpl->get("thread_rankimages")."\";");
if($posts['title']) $posts['ranktitle']=$posts['title'];
else if($posts['altranktitle']) $posts['ranktitle']=$posts['altranktitle'];
if($showonlineinthread==1) {
if(($posts['invisible']==0 || $wbbuserdata['canuseacp']==1) && $posts['lastactivity']>=time()-$useronlinetimeout*60) eval ("\$user_online = \"".$tpl->get("thread_user_online")."\";");
else eval ("\$user_online = \"".$tpl->get("thread_user_offline")."\";");
}
if($showregdateinthread==1) {
$posts['regdate']=formatdate($dateformat,$posts['regdate']);
eval ("\$posts['regdate'] = \"".$tpl->get("thread_regdate")."\";");
}
else $posts['regdate']="";
if($showuserfieldsinthread==1 && is_array($userfieldcache[$posts['groupid']]) && count($userfieldcache[$posts['groupid']])) {
while(list($key,$val)= each($userfieldcache[$posts['groupid']])) {
$fieldid="field".$val;
if(!$posts[$fieldid]) continue;
$fieldoptions=$profilefieldcache[$val]['fieldoptions'];
switch ($profilefieldcache[$val]['fieldkind']){
case "date":
if($posts[$fieldid] && $posts[$fieldid]!="0000-00-00") {
$date_array = explode("-",$posts[$fieldid]);
if($date_array[0]=="0000") $posts[$fieldid] = $date_array[2].".".$date_array[1].".";
else $posts[$fieldid] = $date_array[2].".".$date_array[1].".".$date_array[0];
} else unset($posts[$fieldid]);
break;
case "multiselect":
if(!$posts[$fieldid]) continue;
$multiselect_array=explode("\n",$posts[$fieldid]);
$posts[$fieldid]="";
while(list($key,$val)=each($multiselect_array)) eval ("\$posts[$fieldid].=\"".$tpl->get("userfields_multiselect_show")."\";");
break;
case "tlong" or "tshort":
$fieldoptions=explode("\n",preg_replace("(\n|\r\n|\r)","\n",$fieldoptions));
$posts[$fieldid]=$parse->doparse(stripslashes($posts[$fieldid]),intval($fieldoptions[0]),intval($fieldoptions[1]),intval($fieldoptions[2]),intval($fieldoptions[3]));
break;
default:
$posts['$fieldid']=parse::textwrap($posts[$fieldid],50);
break;
}
$title=$profilefieldcache[$val]['title'];
if($posts[$fieldid]) eval ("\$userfields .= \"".$tpl->get("thread_userfields")."\";");
}
}
if($showgenderinthread==1 && $posts['gender']>0) {
if($posts['gender']==1) eval ("\$gender = \"".$tpl->get("thread_gender_male")."\";");
if($posts['gender']==2) eval ("\$gender = \"".$tpl->get("thread_gender_female")."\";");
}
if($showuserpostsinthread==1) eval ("\$posts['userposts'] = \"".$tpl->get("thread_userposts")."\";");
else $posts['userposts']="";
eval ("\$search = \"".$tpl->get("thread_search")."\";");
eval ("\$homie = \"".$tpl->get("thread_homie")."\";");
if($posts['showemail']==1) eval ("\$email = \"".$tpl->get("thread_email")."\";");
elseif($posts['usercanemail']==1) eval ("\$email = \"".$tpl->get("thread_formmail")."\";");
if($posts['homepage']) eval ("\$homepage = \"".$tpl->get("thread_homepage")."\";");
if($posts['receivepm']==1 && $wbbuserdata['canusepms']==1) eval ("\$pm = \"".$tpl->get("thread_pm")."\";");
if($posts['icq']) eval ("\$icq = \"".$tpl->get("thread_icq")."\";");
if($posts['aim']) eval ("\$aim = \"".$tpl->get("thread_aim")."\";");
if($posts['yim']) eval ("\$yim = \"".$tpl->get("thread_yim")."\";");
if($posts['avatarid'] && $showavatar==1 && $wbbuserdata['showavatars']==1) {
if((($posts['invisible']==0 || $wbbuserdata['canuseacp']==1) && $posts['lastactivity']>=time()-$useronlinetimeout*60) || ($posts['canuseacp']==0 && $posts['issupermod']==0 && $posts['ismod']==0 && $posts['showonteam']==0) || !file_exists("images/avatars/grey_avatar-$posts[avatarid].$posts[avatarextension]")) $avatarname="images/avatars/avatar-$posts[avatarid].$posts[avatarextension]";
else $avatarname="images/avatars/grey_avatar-$posts[avatarid].$posts[avatarextension]";
$avatarwidth=$posts['width'];
$avatarheight=$posts['height'];
eval ("\$useravatar = \"".$tpl->get("avatar_image")."\";");
eval ("\$useravatar = \"".$tpl->get("thread_useravatar")."\";");
}
#### Anfang Member ~ Groupcolor ####
$uname = ($posts['username']);
$gridf = $db->query_first("SELECT groupid FROM bb".$n."_users WHERE username LIKE '".$uname."'");
$autorgrid = ($gridf['groupid']);
$autornamecolorfrage = $db->query_first("Select postcolor From bb".$n."_groups WHERE groupid LIKE '".$autorgrid."'");
$autornamecolor = ($autornamecolorfrage['postcolor']);
if($autornamecolor != "") {
$posts['username'] = '</font><normalfont color="'.$autornamecolor.'">'.$posts['username'].'';
}
#### ENDE Member ~ Groupcolor ####
if($authormarking==1) {
if($posts['marking']!="%s") $posts['username'] = sprintf($posts['marking'],$posts['username']);
else $posts['username'] = sprintf($posts['useronlinemarking'],$posts['username']);
}
eval ("\$posts['username'] = \"".$tpl->get("thread_username")."\";");
if($posts['showsignature']==1 && $wbbuserdata['showsignatures']==1 && $posts['signature']) {
$posts['signature']=$parse->doparse($posts['signature'],$posts['allowsmilies']*$allowsigsmilies,$allowsightml,$allowsigbbcode,$maxsigimage);
eval ("\$signature = \"".$tpl->get("thread_signature")."\";");
}
}
else {
eval ("\$posts[ranktitle] = \"".$tpl->get("anonymous")."\";");
}
if($wbbuserdata['issupermod']==1 || $modpermissions['userid']) {
eval ("\$thread_delete = \"".$tpl->get("thread_moddelete")."\";");
}
eval ("\$postbit .= \"".$tpl->get("thread_postbit")."\";");
$count++;
}
if($wbbuserdata['issupermod']==1 || $modpermissions['userid']) eval ("\$modoptions = \"".$tpl->get("thread_modoptions")."\";");
elseif($wbbuserdata['userid'] && $wbbuserdata['userid']==$thread['starterid'] && ($wbbuserdata['cancloseowntopic']==1 || $wbbuserdata['candelowntopic']==1 || $wbbuserdata['caneditowntopic']==1)) eval ("\$modoptions = \"".$tpl->get("thread_useroptions")."\";");
if($thread['pollid']) {
if($wbbuserdata['issupermod']==1 || $modpermissions['userid']==1) eval ("\$mod_poll_edit = \"".$tpl->get("mod_poll_edit")."\";");
unset($votecheck);
$poll=$db->query_first("SELECT * FROM bb".$n."_polls WHERE pollid='$thread[pollid]'");
if($poll['timeout']==0) $timeout=time()+1;
else $timeout=$poll['starttime']+$poll['timeout']*86400;
if($_REQUEST['preresult']!=1 && $wbbuserdata['canvotepoll'] && $timeout>=time()) {
if($wbbuserdata['userid']) $votecheck=$db->query_first("SELECT id AS pollid FROM bb".$n."_votes WHERE id='$thread[pollid]' AND votemode=1 AND userid='$wbbuserdata[userid]'");
else $votecheck=$db->query_first("SELECT id AS pollid FROM bb".$n."_votes WHERE id='$thread[pollid]' AND votemode=1 AND ipaddress='$REMOTE_ADDR'");
}
if($_REQUEST['preresult']==1 || $votecheck['pollid'] || !$wbbuserdata['canvotepoll'] || $timeout<time()) { // already voted; show result
$votes=0;
unset($polloption);
$totalvotes=0;
//list($totalvotes)=$db->query_first("SELECT SUM(votes) FROM bb".$n."_polloptions WHERE pollid='$thread[pollid]'");
$result=$db->query("SELECT * FROM bb".$n."_polloptions WHERE pollid='$thread[pollid]' ORDER BY votes DESC");
while($row=$db->fetch_array($result)) {
$totalvotes+=$row['votes'];
$polloptions[]=$row;
}
$i=1;
while(list($key,$row)=each($polloptions)) {
$row['polloption']=$parse->doparse($row['polloption'],$board['allowsmilies'],$board['allowhtml'],$board['allowbbcode'],$board['allowimages']);
if($totalvotes) {
$percent_float = $row['votes']*100/$totalvotes;
$percent = number_format($percent_float, 2);
$percent_int = floor($percent_float)*3;
$percent_int += 1;
}
else $percent = $percent_int = 0;
eval ("\$thread_poll_resultbit .= \"".$tpl->get("thread_poll_resultbit")."\";");
if($i==5) $i=0;
$i++;
}
eval ("\$thread_poll = \"".$tpl->get("thread_poll_result")."\";");
}
else {
if($poll['choicecount']>1) $inputtype="checkbox";
else $inputtype="radio";
$result=$db->query("SELECT * FROM bb".$n."_polloptions WHERE pollid='$thread[pollid]' ORDER BY showorder ASC");
while($row=$db->fetch_array($result)) {
$row['polloption']=$parse->doparse($row['polloption'],$board['allowsmilies'],$board['allowhtml'],$board['allowbbcode'],$board['allowimages']);
eval ("\$thread_pollbit .= \"".$tpl->get("thread_pollbit")."\";");
}
eval ("\$thread_poll = \"".$tpl->get("thread_poll")."\";");
}
}
if($thread['voted']) {
$avarage=number_format($thread['votepoints']/$thread['voted'],2);
$threads['voted']=$thread['voted'];
eval ("\$threadrating = \"".$tpl->get("board_threadbit_rating")."\";");
$threadrating=str_repeat($threadrating, round($avarage));
}
else $threadrating="";
$threadvisit[$threadid]=time();
if($wbbuserdata['usecookies']==1) encode_cookie("threadvisit");
$postids = explode(",",$postids);
for($i=0;$i<count($postids);$i++) $postvisit[$postids[$i]]=1;
if($wbbuserdata['usecookies']==1) encode_cookie("postvisit",0,false);
if($board['closed']==0) eval ("\$newthread = \"".$tpl->get("board_newthread")."\";");
$addreply_link="threadid=$threadid";
if($thread['closed']!=0) eval ("\$addreply = \"".$tpl->get("thread_closed")."\";");
elseif($board['closed']==0) eval ("\$addreply = \"".$tpl->get("thread_addreply")."\";");
if(strlen($thread['topic'])>60) $thread['topic']=parse::textwrap($thread['topic'],60);
if($showuseronlineinthread==1) {
include("./acp/lib/class_useronline.php");
$guestcount=0;
$threaduseronline = '';
$online = new useronline($wbbuserdata['canuseacp']);
$result = $db->query("SELECT bb".$n."_sessions.userid, username, groupid, invisible FROM bb".$n."_sessions LEFT JOIN bb".$n."_users USING (userid) WHERE bb". $n."_sessions.lastactivity >= '".(time()-60*$useronlinetimeout)."' AND threadid=$threadid ORDER BY username ASC");
while($row = $db->fetch_array($result)) {
if($row['userid']==0) $guestcount++;
else $online->user($row['userid'],htmlspecialchars($row['username']),$row['invisible']);
}
$threaduseronlinebit = $online->useronlinebit;
if($guestcount<>0) $guestcounter="$guestcount Besucher";
else $guestcounter="";
if($guestcount<>0 && $threaduseronlinebit!='') $konj=" und ";
else $konj="";
if($guestcount<>0 || $threaduseronlinebit!='') $threaduseronline="(Benutzer im Thema aktiv: $threaduseronlinebit$konj$guestcounter)";
}
eval("\$tpl->output(\"".$tpl->get("thread")."\");");
?>
|
|
Dieser Beitrag wurde 1 mal editiert, zum letzten Mal von saen: 30.04.13 12:50.
|
|
30.04.13 12:49 |
E-Mail
WWW
Finden
Als Freund hinzufügen
|
|
C-Board unregistriert
|
|
Wenn Du SQL-Statements in einem Editor "umbrichst", siehst Du i.d.R. auf den ersten Blick, wo der Hammer hängt:
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:
|
SELECT
p.*,
u.userposts,
u.regdate,
u.signature,
u.email,
u.homepage,
u.icq,
u.aim,
u.yim,
u.msn,
u.showemail,
u.receivepm,
u.usercanemail,
u.gender,
u.invisible,
u.title,
u.lastactivity,
u.useronlinemarking AS marking,
g.useronlinemarking, u.groupid,
ar.ranktitle AS altranktitle,
ar.rankimages AS altrankimages,
r.ranktitle,
r.rankimages ,
uf.* ,
i.iconpath,
i.icontitle ,
av.avatarid,
av.avatarextension,
av.width,
av.height
FROM bb1_posts p
LEFT JOIN bb1_users u USING (userid)
LEFT JOIN bb1_groups g ON (g.groupid=u.groupid)
LEFT JOIN bb1_groups g USING (groupid)
LEFT JOIN bb1_ranks r USING (rankid)
LEFT JOIN bb1_altranks ar ON (ar.rankid=u.altrankid)
LEFT JOIN bb1_userfields uf ON (u.userid=uf.userid)
LEFT JOIN bb1_icons i ON (p.iconid=i.iconid)
LEFT JOIN bb1_avatars av ON (u.avatarid=av.avatarid)
WHERE p.postid IN (0,4)
ORDER BY p.posttime ASC
|
|
Schau Dir die Zeilen 34 und 35 mal genauer an.
Gruß Mike
|
|
30.04.13 16:00 |
|
|
Schrimm
Banned
Dabei seit: 21.08.11
Beiträge: 700
|
|
Zitat: |
Original von saen
Es wird nur noch hier nach gefragt <3 |
Ich will "einseinself" oder andere Foren, die eine wbb-Sektion haben, nicht schlecht machen, aber was Fragen bezüglich des wbb angeht, ist man hier immer noch am Besten aufgehoben.
Speziell dann, wenn es sogar um Fragen zu Hacks geht, die hier angeboten werden.
|
|
03.05.13 15:38 |
Finden
Als Freund hinzufügen
|
|
|