MyBB Hacks

• Display three threads from Brands forum on index in this box
• Have these threads ordered based on # of replies in previous [x] days
• Display rank image of 1st, 2nd, and 3rd next to each of them (optional but desired)
• Fetch thumbnail with exact dimensions to display with thread
• Short description and tags are custom thread fields
  

(05-10-2012 08:26 PM)leefish Wrote: [ -> ]I think that the sticking point is going to be the number of replies in X days Brad. As far as I know, MYBB stores the replies data in the threads table without a date range on the replies. You would have to make a plugin or something that calculated that for you.

$forumid = 2;
$xdays = 10;
$tlimit = 3;

Edit mnxt_mrtxpd_threads and/or mnxt_mrtxpd_threads_thread templates as our needs.

By default, we can find thread subject inside the mnxt_mrtxpd_threads_thread.
Use {$thread['profilelink']} for thread author username (linked to profile).

In the template, we can use {$threadfields['key']} for non attachments fields (description, category and etc), and {$threadfields['key']['item']} for attachments fields (image and/or files).

We can use something like this if we want the thumbnail displayed in the side box has a different size with the thumbnail displayed in threadlist/showthread:

<a href="{$thread['threadlink']}"><img src="{$threadfields['key']['thumbs']['thumbnail_size']['url']}" alt="{$thread['subject']} Preview" title="{$thread['subject']}" width="{$threadfields['key']['thumbs']['thumbnail_size']['w']}" height="{$threadfields['key']['thumbs']['thumbnail_size']['h']}" /></a>

Modify it as our needs, depends on the Key for our image custom fields. And make sure that the thumbnail size is in our Image Thumbnail Generation list settings (or we can add it there, and run the Rebuild XThreads Attachment Thumbnails tools).

{$forumurl_q} followed by filtertf_key will lead us to the forumdisplay (filtered).

Use {$thread['rank']} for the rank.
If we want to use image for the rank, we can use it something like this:

<img src="images/hottest_threads_{$thraed['rank']}.png" alt="" />

Then upload hottest_threads_1.png, hottest_threads_2.png, hottest_threads_3.png and etc, depends on the limit, where 1 is the hottest threads.

Please tell me if there is something wrong with the code. I'm still learning.

WHERE t.fid='.intval($forumid).' AND t.visible=1 AND t.closed NOT LIKE "moved|%" AND p.visible=1 AND t.replies>0 AND p.dateline>'.$cutdate.' AND p.pid!=t.firstpost

If I was to make the fid variable a comma separated list and changed the line in the query as below, would that also work?

if(is_array(explode(',', $forumid])))
		{
			foreach(explode(',', $forumid']) as $forum_fid)
			{
				$forum_fid_array[] = intval($forum_fid);
			}
		}
if(!empty($threadfieldscache)){
		$xtfields = '';
		foreach($threadfieldscache as &$tf){
			$xtfields .= ',tf.'.$tf['field'].' AS xthreads_'.$tf['field'];
		}
	}
	$query = $db->query('SELECT COUNT(p.pid) as posts,t.tid,t.fid,t.subject,t.username as threadusername,u.username,u.usergroup,u.displaygroup'.$xtfields.'
		FROM '.TABLE_PREFIX.'threads t
		LEFT JOIN '.TABLE_PREFIX.'threadfields_data tf ON(tf.tid=t.tid)
		LEFT JOIN '.TABLE_PREFIX.'posts p ON(p.tid=t.tid)
		LEFT JOIN '.TABLE_PREFIX.'users u ON(u.uid=t.uid)
		WHERE t.fid IN ('".implode("','", $forum_fid_array)."') AND t.visible=1 AND t.closed NOT LIKE "moved|%" AND p.visible=1 AND t.replies>0 AND p.dateline>'.$cutdate.' AND p.pid!=t.firstpost
		GROUP BY p.tid
		ORDER BY posts desc
		LIMIT 0,'.intval($tlimit).'
	');