Topics in viewforum.php alfabetische volgorde weergeven

[Eminemzdogz]

Lees m'n topictitel maar hoe doe ik zoiets..? Ik heb de code van de memberlist al eens bekeken omdat je daar de username op alfabetische volgorde kan laten weergeven, maar daar werd ik niet veel wijzer van. Hoe en wat moet ik veranderen om de topics in alfabetische volgorde te laten weergeven??

[Eminemzdogz]

Ik heb het zelf gevonden. Voor diegene die d'r ooit nog naar zoeken en dit topic via de zoekfunctie vonden zal ik aangeven wat je moet doen

Verander in viewforum.php

Code: Selecteer alles

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
	FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
	WHERE t.forum_id = $forum_id
		AND t.topic_poster = u.user_id
		AND p.post_id = t.topic_first_post_id
		AND p2.post_id = t.topic_last_post_id
		AND u2.user_id = p2.poster_id 
		AND t.topic_type <> " . POST_ANNOUNCE . " 
		$limit_topics_time
	ORDER BY t.topic_type DESC, t.topic_last_post_id DESC 
	LIMIT $start, ".$board_config['topics_per_page'];

in:

Code: Selecteer alles

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
	FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
	WHERE t.forum_id = $forum_id
		AND t.topic_poster = u.user_id
		AND p.post_id = t.topic_first_post_id
		AND p2.post_id = t.topic_last_post_id
		AND u2.user_id = p2.poster_id 
		AND t.topic_type <> " . POST_ANNOUNCE . " 
		$limit_topics_time
	ORDER BY t.topic_type DESC, t.topic_title ASC 
	LIMIT $start, ".$board_config['topics_per_page'];