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'll try it, thanks !!

[Gizmo5h1t3]

qyuestion : is this a hack that just calls a random thread for a section?
or are the threads selectable??

[Marco van Herwaarden]

just a question: is good or bad only determined by the number of replies?

Also when you are not using an exclude (thread or forum) you are still using it in the where clause. This make the query perform less good. I suggest you only include those in the where if you are excluding something.

I would also suggest you prefix all the used Phraseid's and Varnames, for example with the productid, so there can be no problems with other hacks or future vB versions for using the same names.

[Developer]

Originally Posted by MarcoH64

just a question: is good or bad only determined by the number of replies?
__________________________________________________ ___________
i think it's good and this hack requested in vbh.com with just hack of the day ordered by replies only

Also when you are not using an exclude (thread or forum) you are still using it in the where clause. This make the query perform less good. I suggest you only include those in the where if you are excluding something.
__________________________________________________ ___________
i think this is the best way :surprised:

I would also suggest you prefix all the used Phraseid's and Varnames, for example with the productid, so there can be no problems with other hacks or future vB versions for using the same names.
__________________________________________________ ___________
ok i'll keep this in mind and now i am putting such a codes like devel,developer,first letter hack name like this hack i used bwt (best&worst thread)

my reply in green

[Developer]

Originally Posted by Gizmo5h1t3

qyuestion : is this a hack that just calls a random thread for a section?
or are the threads selectable??

it calls all threads that's not in the exclude forums and threads then ordered by posts

[kofoid]

Do you think that code for FORUMHOME could easily be put into a CMPS Module?

[GamerJunk.net]

Database error in vBulletin 3.5.2:

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 vb3_thread, forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1139591779 AND 1139764579
AND thread.forumid NOT IN (0)
AND thread.threadid NOT IN (0)
ORDER BY thread.replycount DESC LIMIT 1;

MySQL Error : Table '******_*****.forum' doesn't exist
Error Number : 1146
Date : Saturday, February 11th 2006 @ 12:16:19 PM

[apdcanari]

same error :speechless:

[Mr Chad]

When i enable this i get:

[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, forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1139613221 AND 1139786021
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 ()
ORD
Error Number : 1064
Date : Saturday, February 11th 2006 @ 06:13:42 PM
Script : http://www.BeastToast.com/forums/index.php?
Referrer :
IP Address : *.*.*.*
Username : Chad
Classname : vb_database
[/sql]