The Arcive of Official vBulletin Modifications Site.

Zacharicus · #1 06-16-2004, 02:43 AM

I'm running vB3.0.1 and I would love to be able to have hot topic listing like shown on the attached jpg image on my forumhome.

Is this feasible? Is there anything out there similar?

Thanks guys

Zacharicus
www.intelligencenetwork.net
www.mindsofintelligence.com

MindTrix · #2 06-16-2004, 05:37 AM

<a href="https://vborg.vbsupport.ru/showthread.php?t=60544&highlight=recent+threads" target="_blank">https://vborg.vbsupport.ru/showt...recent+threads</a>

that one shows the last 10 threads made

rharbison · #3 08-07-2004, 07:24 PM

Instead of just showing the last 10 threads made, any way to show the 10 most active, based on number of posts in X days, with X being set by the mod?

aranthorn · #4 08-10-2005, 03:35 AM

Well, I modified NTLDR's 'Latest Threads On Forum Home' hack to do it
In Index.php

PHP Code:


			
// #################### PROCESS LATEST THREADS #######################

// fetch the permissions for each forum

$forumperms = array();



foreach($forumcache AS $forum) {



    $forumperms["$forum[forumid]"] = fetch_permissions($forum['forumid']);



    // ## HIDE FORUMS WITHOUT THE CANVIEW OR CANVIEWOTHERS PERMISSION ##

    if (!($forumperms["$forum[forumid]"] & CANVIEW) || !($forumperms["$forum[forumid]"] & CANVIEWOTHERS)) {

        $limitfids .= ','.$forum['forumid'];

    }

}

unset($forum);



if ($vboptions['threadpreview'] > 0) {

    $previewfield = ', post.pagetext AS preview';

    $previewjoin = 'LEFT JOIN '.TABLE_PREFIX.'post AS post ON(post.postid = thread.firstpostid)';

}

$datecut2 = TIMENOW - (7*24*60*60);

$getthreads = $DB_site->query("

    ## GET LATEST THREADS ##

    SELECT thread.*,thread.iconid AS threadiconid $previewfield

    FROM ".TABLE_PREFIX."thread AS thread

    LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')

    $previewjoin

    WHERE thread.dateline > $datecut2

    AND open = '1'

    AND forumid NOT IN (0$limitfids)

    AND thread.visible = '1'

    AND deletionlog.primaryid IS NULL

    ORDER BY replycount

    DESC LIMIT 50");



while($thread = $DB_site->fetch_array($getthreads)) {



    $threads = true;

    $thread['title'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 22));

    $thread['date'] = vbdate($vboptions['dateformat'], $thread['lastpost'], 1);

    $thread['time'] = vbdate($vboptions['timeformat'], $thread['lastpost']);

    $thread['preview'] = preg_replace('#\[quote(=(&quot;|"|\'|).*\\2)?\](.*)\[/quote\]#siU', '', $thread['preview']);

    $thread['preview'] = htmlspecialchars_uni(fetch_trimmed_title(strip_bbcode(fetch_censored_text($thread['preview']), false, true), $vboptions['threadpreview']));

    $thread['replycount'] = vb_number_format($thread['replycount']);

    $thread['views'] = vb_number_format($thread['views']);



    // thread icon

    $show['icon'] = false;

  $icon = fetch_iconinfo($thread['iconid']);



  if (is_array($icon)) {

      $show['icon'] = true;

      $thread['threadiconpath'] = $icon['iconpath'];

      $thread['threadicontitle'] = $icon['title'];

  }



    // show goto new post

    $show['firstnew'] = false;

    $bbforumview = fetch_bbarray_cookie('forum_view', $thread['forumid']);



    if ($bbforumview > $bbuserinfo['lastvisit']) {

        $lastread = $bbforumview;

    } else {

        $lastread = $bbuserinfo['lastvisit'];

    }



    if ($thread['lastpost'] > $lastread) {



        $threadview = fetch_bbarray_cookie('thread_lastview', $thread['threadid']);



        if ($thread['lastpost'] > $threadview) {

            $show['firstnew'] = true;

            $show['icon'] = false;

        }

    }



    exec_switch_bg();



    eval("\$dungeonbit2 .= \"".fetch_template('dungeonbit_2')."\";");

}

if ($threads) {

    $show['latestthreads'] = true;

}

// memory saving

unset($thread, $threads);

$DB_site->free_result($getthreads);

Then made a template called 'dungeonbit_2'

HTML Code:

<div class="smallfont">
	<if condition="$show['firstnew']">
		<a href="showthread.php?$session[sessionurl]threadid=$thread[threadid]&goto=newpost"><img src="$thread[threadiconpath]" alt="$thread[threadicontitle]" border="0" /></a>
	</if>
	<if condition="$show['icon'] && !$show['firstnew']">
		<img src="$thread[threadiconpath]" border="0" alt="$thread[threadicontitle]" title="$thread[threadicontitle]" style="vertical-align: text-middle" /> 
	</if>
	<a href="showthread.php?$session[sessionurl]threadid=$thread[threadid]" title="$thread[preview]"><strong>$thread[title]</strong></a>
	</if> <phrase 1="member.php?$session[sessionurl]find=lastposter&threadid=$thread[threadid]" 2="$thread[postusername]">$vbphrase[by_x]</phrase>
</div>

Then just plopped the $dungeonbit2 string on the FORUMHOME template where I wanted it.

PennylessZ28 · #5 09-16-2005, 03:24 AM

Quote:

Originally Posted by aranthorn