ama kişinin profiline bakmak istediğimde şu hatayı alıyorum
- Kod: Tümünü seç
phpBB : Critical Error
Could not query information
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 '' at line 1
SELECT * FROM phpbb_renommee WHERE ziel_id = '2' ORDER BY datum DESC LIMIT 0,
Line : 283
File : usercp_viewprofile.php
ilgili kodda aşağıda kodda kalın yazılmış olan satır 283tür
- Kod: Tümünü seç
//
// Start -> Renommee - Mod
//
include_once('includes/bbcode.php');
// Auslesen der Konfigurationsdaten
$sql = "SELECT * FROM " . RENOMMEE_KONFIG;
if ( !$result = $db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, "Could not query information", "", __LINE__, __FILE__, $sql);
}
else
{
while( $row = $db->sql_fetchrow($result) )
{
$config_name = $row['name'];
$config_value = $row['wert'];
$renommee_konfig[$config_name] = $config_value;
}
}
// Auslesen der Renommee - Daten
$sql = "SELECT * FROM " . RENOMMEE . " WHERE ziel_id = '$profiledata[user_id]' ORDER BY datum DESC LIMIT 0, " . $renommee_konfig[beitrags_anzahl];
if ( !$result = $db->sql_query($sql) )
{
[b]message_die(CRITICAL_ERROR, "Could not query information", "", __LINE__, __FILE__, $sql);[/b]
}
else
{
while( $row = $db->sql_fetchrow($result) )
{
$renommee_rowset[] = $row;
$total_bewertungen++;
}
}
// Bestimmen der Rechte für Renommee - Ansicht und Aufbereitung der Daten
if ( (isset($userdata['session_logged_in']) AND $userdata['user_id'] == $profiledata['user_id']) OR ($userdata['user_level'] >= 1) )
{
$template->assign_block_vars('renommee_anzeige', array(
"GESAMT_RENOMMEE" => $profiledata['renommee_gesamt']
)
);
for ( $i = 0; $i < $total_bewertungen; $i++ )
{
$sql = "SELECT u.username, u.user_id, t.topic_title
FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t
WHERE u.user_id = '" . $renommee_rowset[$i]['quell_id'] . "' AND p.post_id = '" . $renommee_rowset[$i]['post_id'] . "' AND t.topic_id = p.topic_id";
if ( !$result = $db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, "Could not query information", "", __LINE__, __FILE__, $sql);
}
else
{
while ( $row = $db->sql_fetchrow($result) )
{
$bewerter_daten = $row;
}
}
// Löschen von Bewertungen dürfen nur Moderatoren und Admins. Erstere aber nicht die eigenen.
if ( ($userdata['user_level'] == 2 AND $userdata['user_id'] != $profiledata['user_id']) OR $userdata['user_level'] == 1 )
{
$loeschen = '<a href="#" alt="' . $lang['renommee_delete'] . '" title="' . $lang['renommee_delete'] . '" onclick="return renommee_del(' . $renommee_rowset[$i]['id'] . ')" target="' . $lang['renommee_delete'] . '" class="nav"><img src="images/icon_delete.gif" alt="' . $lang['renommee_delete'] . '" title="' . $lang['renommee_delete'] . '" border=0></a>';
}
else
{
$loeschen = ' ';
}
$p = $renommee_rowset[$i]['post_id'];
if ( $bewerter_daten['topic_title'] != "" )
{
$link = '<a href="' . append_sid("viewtopic." . $phpEx . "?p=" . $p . "#" . $p) . '">' . $bewerter_daten['topic_title'] . '</a>';
}
else
{
$link = '<span class="negative"><b>' . $lang['renommee_posting_deleted'] . '</b></span>';
}
$datum = date("d.m.Y, G:i", $renommee_rowset[$i]['datum']);
$autor = '<a href="profile.php?mode=viewprofile&u=' . $bewerter_daten['user_id'] . '">' . $bewerter_daten['username'] . '</a>';
if ( $renommee_rowset[$i]['renommee_wert'] == 0 )
{
$bild = '<img src="images/renommee_grau.gif" alt="' . $lang['renommee_neutral_reputation'] . '" title="' . $lang['renommee_neutral_reputation'] . '">';
}
elseif ($renommee_rowset[$i]['renommee_wert'] > 0)
{
$bild = '<img src="images/renommee_gruen.gif" alt="' . $lang['renommee_positive_reputation'] . '" title="' . $lang['renommee_positive_reputation'] . '">';
}
else
{
$bild = '<img src="images/renommee_rot.gif" alt="' . $lang['renommee_negative_reputation'] . '" title="' . $lang['renommee_negative_reputation'] . '">';
}
$kommentar = $renommee_rowset[$i]['kommentar'];
if ( $board_config['allow_smilies'] )
{
$kommentar = smilies_pass($renommee_rowset[$i]['kommentar']);
}
$template->assign_block_vars('renommee_anzeige.renommeerow', array(
'AUTOR' => $autor,
'KOMMENTAR' => $kommentar,
'DATUM' => $datum,
'LINK' => $link,
'BILD' => $bild,
'LOESCHEN' => $loeschen
)
);
}
// Standardbewertung etwas in die Liste geschummelt
if ( $total_bewertungen < $renommee_konfig['beitrags_anzahl'] )
{
$template->assign_block_vars('renommee_anzeige.renommeerow', array(
'AUTOR' => $lang['renommee_system'],
'KOMMENTAR' => $lang['renommee_standard_points'],
'DATUM' => '',
'LINK' => '<a href="#">' . $board_config['sitename'] . '</a>',
'BILD' => '<img src="images/renommee_gruen.gif" alt="' . $lang['renommee_positive_reputation'] . '" title="' . $lang['renommee_positive_reputation'] . '">',
'LOESCHEN' => ''
)
);
}
}
//
// End -> Renommee - Mod
//
