4seven hat mal diesen Code entwickelt, leider macht dieser Code seit einiger Zeit hin und wieder ein SQL Fehler in der Wer ist online Liste. Weiss nicht weit welchen Update das genau ist!
Code: Alles auswählen
// Which Profile is Watching / 4seven / 2009
$sess_id = explode("&u=", $row['session_page']);
if (!empty($sess_id[1])){
$sql = 'SELECT username, user_id
FROM ' . USERS_TABLE . "
WHERE user_id = $sess_id[1]";
$results = $db->sql_query($sql);
$session_pages = $row['session_page'];
while ($rows = $db->sql_fetchrow($results)){
$location = (strpos($session_pages, 'mode=viewprofile') !== false) ? $user->lang['VIEWING_MEMBER_PROFILE'] . ' (' . $rows['username'] . ')' : $user->lang['VIEWING_MEMBERS'];
$location_url = append_sid("{$phpbb_root_path}memberlist.$phpEx" . '?mode=viewprofile&u=' . $rows['user_id'] );
}
$db->sql_freeresult($results);
}
else{
$location = (strpos($row['session_page'], 'mode=viewprofile') !== false) ? $user->lang['VIEWING_MEMBER_PROFILE'] : $user->lang['VIEWING_MEMBERS'];
$location_url = append_sid("{$phpbb_root_path}memberlist.$phpEx");
}
// Which Profile is Watching / 4seven / 2009
Code: Alles auswählen
SQL ERROR [ mysql4 ]
Unknown column '3730index.php' in 'where clause' [1054]
SQL
SELECT username, user_id FROM neu_users WHERE user_id = 3730index.php
BACKTRACE
FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()
FILE: viewonline.php
LINE: 418
CALL: dbal_mysql->sql_query()