Kommt direkt der Fehler !!
MySQL Error:
1064 : 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 'FROM ic1_user WHERE id = 1 LIMIT 1' at line 1
in Query:
SELECT right FROM ic1_user WHERE id = 1 LIMIT 1Debug backtrace:
@ mysql.php:32 -- debug_bt()
@ mysql.php:50 -- db_check_error(...)
@ user_details.php:197 -- db_query(...)
@ user.php:25 -- require_once(...)
@ index.php:36 -- require_once(...)
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u00875210816/public_html/include/includes/func/db/mysql.php on line 54
hier mal meine user_details.php vllt hilfts ja !!
<?php
# Copyright by: Manuel Staechele
# Support: www.ilch.de
function user_get_teams ($uid) {
$erg = db_query("SELECT b.name, c.name as posi
FROM prefix_groupusers a
LEFT JOIN prefix_groups b ON b.id = a.gid
LEFT JOIN prefix_groupfuncs c ON a.fid = c.id
WHERE a.uid = ".$uid);
if (db_num_rows($erg) > 0 ) {
while ($r = db_fetch_assoc($erg)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$l .= '<td class="'.$class.'" width="70%">'.$r['name'].'</td><td class="'.$class.'" width="30%">'.$r['posi'].'</td></tr>';
}
} else {
$l .= '<td class="Cmite" width="10%">Keine Teams</td>';
}
return ($l);
}
$uid = $menu->get(2);
$abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
#Award Ausgabe
$awards = ''; $ax = 0;
$sqlA = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = ".$uid." ORDER BY `time` ASC");
while($rowA = db_fetch_assoc($sqlA))
{
$ax++; if ($ax == 8) {$awards .= "<br>"; $ax = 0;}
$awards .= (!empty($rowA['bild']) ? '<img style="width:100;height:100px;padding:1px;border:0px;" src="'.$rowA['bild'].'" alt="'.$rowA['wofur'].'" title="'.$rowA['wofur'].'"/>' : $rowA['wofur']);
}
$awards = '<b><b><br><div style="text-align:center;">'.$awards.'</div>';
function get_last_user_wars($userid,$game){
$s = '';
$q = db_query("SELECT `wid` FROM `prefix_warmember` WHERE uid = '".$userid."' AND aktion = '1' ORDER BY wid DESC LIMIT 20");
if (db_num_rows($q) > 0 ) {
$wids = array();
while ($row = db_fetch_object($q)) {
$wids[] = $row->wid;
}
$wids = implode(', ',$wids);
}
if( !empty($wids) ) {
$erg = db_query("SELECT id, gegner, tag, wlp, land, owp, opp
FROM prefix_wars
WHERE id IN ($wids) AND status = '3' AND game = '".$game."'");
if (db_num_rows($erg) > 0 ) {
while ($r = db_fetch_assoc($erg)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$r['tag'] = ( empty($r['tag']) ? $r['gegner'] : $r['tag'] );
if ($r['wlp'] == 1) {
$bild = 'include/images/icons/win.gif';
$color = '#558e3d';
} elseif ($r['wlp'] == 2) {
$bild = 'include/images/icons/los.gif';
$color = '#a91d1d';
} elseif ($r['wlp'] == 3) {
$bild = 'include/images/icons/pad.gif';
$color = '#f0770d';
}
$s .= '<td class="'.$class.'" width="1%"><img src="'.$bild.'" alt="" / ></td><td class="'.$class.'" width="99%"><div style="width:80%; float:left"><img src="include/images/flags/'.$r['land'].'" alt="'.$r['land'].'"/> <a href="index.php?wars-more-'.$r['id'].'">'.$r['tag'].'</a></div><div style="float:left; text-align:right; color:'.$color.'; width:20%;">'.$r['owp'].':'.$r['opp'].'</div></td></tr>';
}
} else {
$s .= '<td class="Cmite" width="10%">Keine Wars</td>';
}
} else {
$s .= '<td class="Cmite" width="10%">Keine Wars</td>';
}
return ($s);
}
defined ('main') or die ( 'no direct access' );
$uid = $menu->get(2);
$abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
$regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row['regist'];
$regday = round($regsek / 86400);
$postpday = ( $regday == 0 ? 0 : round($row['posts'] / $regday, 2 ) );
$rp=rangcount($row['id'],$row['posts'],$row['cpoints'],$row['fwarn']);
$row['koms'] = db_count_query('SELECT COUNT(id) FROM `prefix_koms` WHERE name="'.$row['name'].'"');
if(empty($row['xfire']))
{$xfire_online = ''; $xfire_onlinet = '';}else{
if($allgAr['xfire_online'] == '1'){ $xfire_online = '<img src="http://de.miniprofile.xfire.com/bg/co/type/1/'.$row['xfire'].'.png" />'; }else{ $xfire_online = ''; }
if($allgAr['xfire_online'] == '1'){ $xfire_onlinet = 'X-Fire'; }else{ $xfire_onlinet = ''; }
}
if(empty($row['steampro']))
{
$steam = ''; }else{
$steam = '<img src="include/steamprofile/spimage.php?id='.$row['steampro'].'" />';
}
$row['sig'] = ( empty($row['sig']) ? '' : '<br /><hr style="width: 50%;" align="left">'.bbcode($row['sig']) );
$regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row['regist'];
$regday = round($regsek / 86400);
$postpday = ( $regday == 0 ? 0 : round($row['posts'] / $regday, 2 ) );
if($row['posts'] != 0)
{
$postar = array(0,1,25,50,75,150,250,500,1000,2000,5000,7000,10000);
$i=0;
while($postar[$i] < $row['posts'])
{
$next = 100/($postar[$i+1]-$postar[$i])*($row['posts']-$postar[$i]);
$i++;
}
}
else
{
$next = "0";
}
$erfahrung = 100/200000*$row['posts'];
array(0,1,25,50,75,150,250,500,1000,2000,5000,7000,10000);
$ar = array (
'NAME' => $row['name'],
'ROWSP'=>10,
'JOINED' => date('d M Y',$row['regist']),
'LASTAK' => date('d M Y - H:i',$row['llogin']),
'POSTS' => $row['posts'],
'postpday' => $postpday,
'RANG' => rangbild ($rp),
'SRANK' => spezrang ($row['id']),
'RECHT' => getlistrecht($row['recht']),
'POINTS' =>$row['cpoints'],
'RPOINT' =>$rp,
'STEAM' => $steam,
'XFIRE' => $xfire_online,
'XFIREt' => $xfire_onlinet,
'koms' => $row['koms'],
'UID' => $uid,
'GAMES' => getteams($row['id']),
'VERW' => verwarnstu($row['fwarn'],0),
'dze'=>getmedal(1,$row['regist']),
'fze'=>getmedal(2,$row['posts']),
'wze'=>getmedal(3,$row['cpoints']),
'cme' =>getmedal(4,$row['medal']),
'sig' =>$row['sig'],
'ERFAHRUNG' => $erfahrung,
'NEXT' => $next,
'AWARDS' => $awards,
);
$title = $allgAr['title'].' :: Users :: Details von '.$row['name'];
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> Details von '.$row['name'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
[b]$tpl = new tpl ('user/userdetails'); HATTE ES HIERFÜR EINGEFÜGT!!!!![/b]
$l = profilefields_show ( $uid );
$ar['rowspan'] = 4 + substr_count($l, '<tr><td class="');
$ar['profilefields'] = $l;
$tpl->set_ar_out($ar,0);
$tpl->set_out('teams', user_get_teams($uid),1);
$tpl->set_out('Battlefield 2', get_last_user_wars($uid,'Battlefield 2'),2);
$tpl->set_out('Medal of Honor', get_last_user_wars($uid,'Medal of Honor'),3);
$tpl->set_out('Battlefield 3', get_last_user_wars($uid,'Battlefield 3'),4);
$design->footer();
?>