W Operze ShoutBox źle troche chodzi. Oto poprawka:
Z Color Ranks
Kod:
#
#-----[ OPEN ]------------------------------------------
#
shoutbox_view.php
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT id, sb_user_id, msg, timestamp, sb_username
FROM " . SHOUTBOX_TABLE . "
ORDER by timestamp LIMIT $start, $number";
#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = "SELECT s.id, s.sb_user_id, s.msg, s.timestamp, u.username as sb_username
FROM (" . SHOUTBOX_TABLE . " s LEFT JOIN ".USERS_TABLE." u ON s.sb_user_id=u.user_id)
ORDER by timestamp LIMIT $start, $number";
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Bez color ranksKod:
#
#-----[ OPEN ]------------------------------------------
#
shoutbox_view.php
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT id, sb_user_id, msg, timestamp, sb_username
FROM " . SHOUTBOX_TABLE . "
ORDER by timestamp LIMIT $start, $number";
#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = "SELECT s.id, s.sb_user_id, s.msg, s.timestamp
FROM (" . SHOUTBOX_TABLE . " s LEFT JOIN ".USERS_TABLE." u ON s.sb_user_id=u.user_id)
ORDER by timestamp LIMIT $start, $number";
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Autor postu otrzymał pochwałę
APF 2.0 - patch | phpBB2 r0x | BeerMod 1.0.0 RC3 | My MODs