phpBB.de

Datenbank-Fehler

DEBUG MODE

SQL 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 'SELECT avg(auswartstipp) as atore, auswarts FROM tippspiel_user

SELECT hilfe2.heim, round((htore + atore)/2) as htore FROM (SELECT avg(auswartstipp) as atore, auswarts FROM tippspiel_usertips u, tippspiel_spieltage s WHERE userid='2' and u.spielid = s.spielid group by auswarts) hilfe, (SELECT avg(heimtipp) as htore, heim FROM tippspiel_usertips u, tippspiel_spieltage s wHERE userid='2' and u.spielid = s.spielid group by heim) hilfe2 Where hilfe.auswarts=hilfe2.heim order by hilfe2.heim

Line : 1476
File : userstatistik.php

Datenbank-Fehler

DEBUG MODE

SQL 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 'select distinct spielerid from buli2_tippspiel_torschuetzen_use

SELECT * FROM buli2_tippspiel_torschuetzen where spielerid in (select distinct spielerid from buli2_tippspiel_torschuetzen_user) ORDER BY tore DESC

Line : 52
File : admin_meister2.php

if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))

$perstoptreffer['treffer'][] = $row['treffer'];
$perstoptreffer['tag'][] = $row['spieltag'];
}

$sql = "SELECT hilfe2.heim, round((htore + atore)/2) as htore FROM (SELECT avg(auswartstipp) as atore, auswarts FROM tippspiel_usertips u, tippspiel_spieltage s WHERE userid='$recordid' and u.spielid = s.spielid "
. " group by auswarts) hilfe, (SELECT avg(heimtipp) as htore, heim FROM tippspiel_usertips u, tippspiel_spieltage s wHERE userid='$recordid' and u.spielid = s.spielid group by heim) hilfe2 Where hilfe.auswarts=hilfe2.heim order by hilfe2.heim";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))

$verein[] = $row['name'];
$select[] = '';
}

$sql = "SELECT * FROM tippspiel_torschuetzen where spielerid in (select distinct spielerid from tippspiel_torschuetzen_user) ORDER BY tore DESC ";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))

if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))