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}

[Invalid ID]

One of the best I have ever seen <claps>

[MorrisMcD]

Does this hack take forum permissions into account? Meaning.. Does a user see the best thread of the month or whatever if it is in a forum they dont have access to?

[csidlernet]

preety cool thanks. everyone sure loves statistics!

[Invalid ID]

It's working fine on the default template, but not working on the other skins that I uploaded later.

What to do?

[ShadowOne]

what i dont understand is everytime ive uploaded this hack for a numerous amount of boards, the best thread of the day and worst thread of the day disappear after a couple days...then i would disable it, click save, then enable it, and then it works for a lil while, etc...so i uninstalled

[lightwave]

when i enable this hack i get this error

Database error in vBulletin 3.5.4:

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 thread AS thread, forum AS forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1145207911 AND 1150391911
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 ()
ORDER BY thread.repl' at line 14
Error Number : 1064
Date : Tuesday, May 16th 2006 @ 01:18:31 PM
Script : http://www.rhyme4fame.com/forums/index.php
Referrer : http://www.rhyme4fame.com/forums/adm...ex.php?do=head
IP Address : 68.38.252.172
Username : ??řķ ρřǿЈ??†
Classname : vB_Database

[Lottis]

I think the Developer is away;
Exams peroid: no-support NOR custom work to 8-6-06
See his signatur.

[vbreal]

Originally Posted by lightwave

when i enable this hack i get this error

Database error in vBulletin 3.5.4:

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 thread AS thread, forum AS forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1145207911 AND 1150391911
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 ()
ORDER BY thread.repl' at line 14
Error Number : 1064
Date : Tuesday, May 16th 2006 @ 01:18:31 PM
Script : http://www.rhyme4fame.com/forums/index.php
Referrer : http://www.rhyme4fame.com/forums/adm...ex.php?do=head
IP Address : 68.38.252.172
Username : ??řķ ρřǿЈ领
Classname : vB_Database

Originally Posted by Developer

https://vborg.vbsupport.ru/attachmen...4&d=1139667840
u have to put at leaset 0 in ex. forums & threads

this may help

[Pcparts]

Is it possible to break down this hack in such a way, that it also shows the same "thread of the day/week/month" in each forum?

*installed*

Thanks.

[Arios]

Sweet!