ShoutBox by przemo wyswietlanie wiadomosci

AKURAT · Post autor: **AKURAT** » 30 czerwca 2007, 08:14

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!

Post autor: **daroPL** » 30 czerwca 2007, 08:56

Jak możesz to wytnij z pliku shoutbox_view.php zapytania zaczynające się od SELECT i wstaw tutaj.

AKURAT · Post autor: **AKURAT** » 30 czerwca 2007, 09:26

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');

?>

Post autor: **daroPL** » 30 czerwca 2007, 09:42

Zamień

Kod: Zaznacz cały

ORDER by timestamp

na

Kod: Zaznacz cały

ORDER by timestamp DESC

AKURAT · Post autor: **AKURAT** » 30 czerwca 2007, 15:30

oka wsztstko dziala jak nalezy

dzieki wielkie !!