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}

[RFViet]

I want to change phrase of day, week, month => How can I do that ?? Thanks.

[Annie^.^]

Is there a way to see more than one most replied threads?

[Gizmo5h1t3]

cant see how having "WORST THREAD" on a forum board is condusive to getting people to post.....knowing that the thread they created might pop up in that section.

surely that would discourage posters from creating threads??

just my 2p`s worth..otherwise its a decent addition....

[ogden2k]

You really need to put spaces after words and colons... :|

[MarsNIIT]

Originally Posted by cuphongle

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 thread AS thread, forum AS forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1140588991 AND 1140761791
AND thread.forumid NOT IN ()
AND thread.threadid NOT IN ()
ORDER BY thread.replycount DESC 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 : Wednesday, February 22nd 2006 @ 10:16:31 PM
Script : http://yndforum.com/index.php
Referrer : http://yndforum.com/showthread.php?t=6475
IP Address : 131.191.45.163
Username : realesthomie
Classname : vb_database

Error same me, it not support vbb install with prefix table. Please fix it. Thank you verry much.

[Developer]

Originally Posted by Annie^.^

So what is to the solution the above thread??? I am getting the same error and I use table prefix

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

[Developer]

Originally Posted by Annie^.^

Is there a way to see more than one most replied threads?

currently:no

[Developer]

Originally Posted by MarsNIIT

Error same me, it not support vbb install with prefix table. Please fix it. Thank you verry much.

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

[MarsNIIT]

yes, thank you, it work

[Amaranth]

This looks really promising. How about adding functionality for more than 1 post? Top x posts of the day, week, month? That would be fantastic.