[How To?] Add Threads With Most Replies on Sidebar

[harlenjoy]

Good Day,

I have done adding Latest Threads on index sidebar by using the portal.php code. Now I can't make it work to add the Threads with Most Replies to my sidebar. I don't want to use plugins for that. Hope you can help me guys thank you!

Also if you can manage to help me also on the Top Poster (5 users only) to show on my index sidebar.

Thank You again Guys!

[borbole]

Good Day,

I have done adding Latest Threads on index sidebar by using the portal.php code. Now I can't make it work to add the Threads with Most Replies to my sidebar. I don't want to use plugins for that. Hope you can help me guys thank you!

Also if you can manage to help me also on the Top Poster (5 users only) to show on my index sidebar.

Thank You again Guys!

At the portal.php file or at whatever mod you are using to pull the latest threads from the portal page find this code

	$altbg = alt_trow();
	$threadlist = '';
	$query = $db->query("
		SELECT t.*, u.username
		FROM ".TABLE_PREFIX."threads t
		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
		WHERE 1=1 $unviewwhere AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
		ORDER BY t.lastpost DESC 
		LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
	);

And change this part

ORDER BY t.lastpost DESC  

to

 ORDER BY t.replies DESC 

Whereas for the last top 5 posters in the sidebar have a look at my plugin here. It does just that.

http://community.mybb.com/thread-128769.html

[harlenjoy]

Wow great thank you for that! Can I have another question? What is the variable for whose online and forum statistics on portal. Thank You!

[borbole]

Wow great thank you for that! Can I have another question? What is the variable for whose online and forum statistics on portal. Thank You!

You are welcome.

You can see them at the portal template. They are respectively {$whosonline} and {$stats}.

[harlenjoy]

I tried using it copying the portal codes to my index page and use the variables on my sidebar but it is not working. I dunno why. .