Wiec mam malutki problem
mam shoutboxa u gory forum i wiadomosci wysweitlaja sie od najstarszej do najnowszej
tj. wiadomosci te najnowsze pojawiaja sie na samym dole, a chcialbym zeby one byly na samej gorze (tak lepiej)
jak to zrobic?
z gory dzieki za pomoc!
ShoutBox by przemo wyswietlanie wiadomosci
hmmm nie wiem czy od tego select:
Kod: Zaznacz cały
$sql = "SELECT COUNT(id) AS total
FROM " . SHOUTBOX_TABLE . "";
if ( !($result = $db->sql_query($sql)) )
{ message_die(GENERAL_ERROR, 'Could not query shoutbox count messages', '', __LINE__, __FILE__, $sql); }
$row = $db->sql_fetchrow($result);
return $row['total'];
}
$msg_count = get_shout_msg();
$number = $shoutbox_config['count_msg'];
$start = $msg_count - $number;
if ( $msg_count < $number ) $start = 0;
$sql = "SELECT s.id, s.sb_user_id, s.msg, s.timestamp, s.sb_username,u.user_rank,u.user_posts
FROM (" . SHOUTBOX_TABLE . " s LEFT JOIN ".USERS_TABLE." u ON s.sb_user_id=u.user_id)
ORDER by timestamp LIMIT $start, $number";
if( !($result = $db->sql_query($sql)) )
{ message_die(GENERAL_ERROR, 'Could not query shoutbox messages', '', __LINE__, __FILE__, $sql); }
if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
$user_id = $row['sb_user_id'];
$username = $row['sb_username'];
$username = stripslashes(htmlspecialchars(trim($username)));
$crc=USERNAME_STATIC;
if ( $shoutbox_config['links_names'] )
$crc=USERNAME_SHOUT;
if ( $user_id == ANONYMOUS )
$name = $lang['Guest'];
else
$name = color_username($user_id, $username,$row['user_rank'], $row['user_posts'], $crc, true);
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
if ( $shoutbox_config['date_on'] )
{
$make_date = create_date($shoutbox_config['date_format'], $row['timestamp'], $board_config['board_timezone']);
$date = '[' . $make_date . ']';
}
$msg = $row['msg'];
$msg = htmlspecialchars(trim($msg));
if ( $shoutbox_config['allow_smilies'] )
{
$msg = smilies_pass($msg);
$msg = preg_replace('/images\/smiles/', 'images/smiles', $msg);
}
if ( $shoutbox_config['make_links'] ) $msg = make_clickable($msg);
if ( $shoutbox_config['allow_bbcode'] )
{
$msg = str_replace("[/i]","</i>",$msg); $msg = str_replace("[i]","<i>",$msg);
$msg = str_replace("[/b]","</b>",$msg); $msg = str_replace("[b]","<b>",$msg);
$msg = str_replace("[/u]","</u>",$msg); $msg = str_replace("[u]","<u>",$msg);
}
else
{
$msg = str_replace("[/i]","",$msg); $msg = str_replace("[i]","",$msg);
$msg = str_replace("[/b]","",$msg); $msg = str_replace("[b]","",$msg);
$msg = str_replace("[/u]","",$msg); $msg = str_replace("[u]","",$msg);
}
$id = $row['id'];
if ( $shoutbox_config['allow_edit_all'] && $username != Anonymous && $sb_user_id == $name_id ) $aedit = 1; else $aedit = 0;
if ( $shoutbox_config['allow_delete_all'] && $username != Anonymous && $sb_user_id == $name_id ) $adel = 1; else $adel = 0;
if ( $shoutbox_config['allow_edit'] ) if ( $userdata['user_level'] == MOD || $userdata['user_level'] == ADMIN ) $aedit = 1;
if ( $shoutbox_config['allow_delete'] ) if ( $userdata['user_level'] == MOD || $userdata['user_level'] == ADMIN ) $adel = 1;
if ( $adel )
{
$temp_url = append_sid("shoutbox_view.$phpEx?mode=delete&id=$id&del_sb_id=$sb_user_id");
$delmsg = '<a href="' . $temp_url . '" class="mainmenu" title="' . $lang['Delete_message'] . '"><b>X</b></a>';
}
else
{
$delmsg = '';
}
if ( $aedit )
{
$date_edit = $row['timestamp'];
$name_edit = $row['sb_username'];
$clean_msg = $row['msg'];
$temp_url_e = append_sid("shoutbox_view.$phpEx?mode=edit&id=$id&name_id=$name_id&date_edit=$date_edit&name_edit=$name_edit&clean_msg=$clean_msg");
$editmsg = '<a href="' . $temp_url_e . '" class="mainmenu" title=" ' .$lang['Edit_pm'] . '"><b>E</b></a>';
}
else
{
$editmsg = '';
}
$template->assign_block_vars('shoutrow', array(
'DELMSG' => $delmsg,
'EDITMSG' => $editmsg,
'ROW_CLASS' => $row_class,
'NAME' => color_username($user_id, $name, $rank, $posts, $style=USERNAME_SHOUT),
'DATE' => $date,
'MSG' => $msg
)
);
$i++;
}
while ( $row = $db->sql_fetchrow($result) );
}
}
$template->assign_vars(array(
'S_CONTENT_ENCODING' => $lang['ENCODING'])
);
$template->pparse('body');
?>
Zamień
na
Kod: Zaznacz cały
ORDER by timestamp
Kod: Zaznacz cały
ORDER by timestamp DESC