Best&Worst Thread of the day-Week-Month

Best&Worst Thread of the day-Week-Month

Description::.

This hack shows in forum home Best&Worst Thread of the day-Week-Month

[Hack Features::.

1-easy yo install
[See Screen Shots]

Admin Controllable

From vBulletin Options ==> vBulletin Options ==> Best&Worst Thread of the (day,week,month) Statistics.]

Installation::.

1-Import The Product.
2-Edit Template FORUMHOME

Find:

<!-- end what's going on box -->

Add After it

<if condition="$vboptions[enbwt]"><if condition="$vboptions[enbt]"><table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" height="10"><tbody>
	<tr>
		<td class="thead" height="10" colspan="3">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('bthread')"><img id="collapseimg_bthread" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_bthread].gif" alt="" border="0" /></a>
		$vbphrase[bthread]</td>
	</tr>
</tbody>
<tbody id="collapseobj_bthread" style="$vbcollapse[collapseobj_bthread]"
<tr>
<if condition="$vboptions[encolbt1]"><td class='alt1' width='33%' height='20%'>$devebdt</td></if>
<if condition="$vboptions[encolbt2]"><td class='alt1' width='33%' height='20%'>$devebwt</td></if>
<if condition="$vboptions[encolbt3]"><td class='alt1' width='33%' height='20%'>$devebmt</td></if>
</tr>
</tbody></table></if>
<if condition="$vboptions[enwt]"><table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" height="10"><tbody>
	<tr>
		<td class="thead" height="10" colspan="3">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('wthreads')"><img id="collapseimg_wthreads" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_wthreads].gif" alt="" border="0" /></a>
        $vbphrase[wthread]</td>
	</tr>
</tbody>
<tbody id="collapseobj_wthreads" style="$vbcollapse[collapseobj_wthreads]">
<tr>
<if condition="$vboptions[encolwt1]"><td class='alt1' width='33%' height='20%'>$devewdt</td></if>
<if condition="$vboptions[encolwt2]"><td class='alt1' width='33%' height='20%'>$devewwt</td></if>
<if condition="$vboptions[encolwt3]"><td class='alt1' width='33%' height='20%'>$devewmt</td></if>
</tr>
</tbody></table></if><br></if>

History::.

1.0 On 11. Feb 2006 Initial Version.
1.1 On 12 feb 2006 Fixes SQL Query

Hack Languages::.

allan Had translate the hack to french. here
Hellraider Had translate the hack to german. here

Details::.

6 plugin, 26 phrases, 12 options, 6 queries(reading only not change or add)

Donation::.

Feel Free To

aT lAsT::.

IF YOu lIkE iT cLIcK INSTALL
vbulletin.org

Support Given For Who Clicked Install {ONLY}

[klaush]

Same here!

[Developer]

Fixes Sql Query But it was Working fine with me CUZ:I Don't use Table_Prefix any way thnx for who support the hack especially PHPGeek2k3
you have to import the new product from the ZIP make sure you allowed overwrite
regards

[klaush]

Originally Posted by Developer

Fixes Sql Query But it was Working fine with me CUZ:I Don't use Table_Prefix any way thnx for who support the hack especially PHPGeek2k3
you have to import the new product from the ZIP make sure you allowed overwrite
regards

Yep, that?s it! Thanks!

[Mr Chad]

Still wont work
[sql]
Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT thread.postusername,
thread.postuserid,
thread.title AS fth,
thread.lastposter,
thread.replycount,
thread.views,
thread.threadid,
thread.forumid tid,
forum.forumid AS fid,
forum.title AS ft
FROM BlizzedOut_thread AS thread, BlizzedOut_forum AS forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1137213119 AND 1142397119
AND thread.forumid NOT IN ()
AND thread.threadid NOT IN ()
ORDER BY thread.replycount AND thread.views ASC LIMIT 1;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.threadid NOT IN ()
ORD
Error Number : 1064
Date : Sunday, February 12th 2006 @ 11:32:01 PM
Script : http://www.BeastToast.com/forums/index.php?
Referrer : http://www.BeastToast.com/forums/showthread.php?t=2115
IP Address : 1.2.3.4
Username : Chad
Classname : vb_database[/sql]

[Developer]

you didn't but 0 in exclude threads and exclude forums
https://vborg.vbsupport.ru/attachmen...chmentid=42564
look at the sceernshot

[Mr Chad]

Originally Posted by Developer

you didn't but 0 in exclude threads and exclude forums
https://vborg.vbsupport.ru/attachmen...chmentid=42564
look at the sceernshot

lol i feel stupid, thanks that did the trick

[lazytown]

thanks for the mod.

How is "BEST" determined? If it's just replies, those usually aren't the "best" on my forum. I guess the best on my forum would be the ones that have the highest star rating or the highest rep power given over the entire thread.

How is "WORST" determined? Should be lowest rated thread or thread with the most negative reps given.

-vissa

[lairnoc]

ok question how can i get it on the top of my forumhome?

[Developer]

Originally Posted by lairnoc

ok question how can i get it on the top of my forumhome?

after $navbar add the code

[Developer]

Originally Posted by vissa

thanks for the mod.

How is "BEST" determined? If it's just replies, those usually aren't the "best" on my forum. I guess the best on my forum would be the ones that have the highest star rating or the highest rep power given over the entire thread.

How is "WORST" determined? Should be lowest rated thread or thread with the most negative reps given.

-vissa

as i said this hack requested