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}

[Developer]

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

[LadyBeth]

I think this is a very cool hack, and I would LOVE it if the poster who created the post of the day/week/month could automatically have a little something show up in their postbit to recognize their efforts in the forums. Can this be done???

LB~

[Hornstar]

Originally Posted by LadyBeth

I think this is a very cool hack, and I would LOVE it if the poster who created the post of the day/week/month could automatically have a little something show up in their postbit to recognize their efforts in the forums. Can this be done???

LB~

Nice Suggestion, maybe the person of the month could have a trophy or something, but it should be different then the trophy the arcade users.

[Developer]

Originally Posted by hornstar1337

Nice Suggestion, maybe the person of the month could have a trophy or something, but it should be different then the trophy the arcade users.

there is no person of the month
anyway
what it is the trophy you suggest? an image? or add 20 posts to his post cont or something like that?

[Hornstar]

Originally Posted by Developer

there is no person of the month
anyway
what it is the trophy you suggest? an image? or add 20 posts to his post cont or something like that?

No but there is thread of the month which make the person who posted it person of the month lol.....you knew what i meant anyway lol


Maybe you could give us the option pic on/off.....points/posts on/off and we select how much so its not always 20 posts for example. maybe integrate it with ebux/ucash so we can give them points?

[cuphongle]

stilld ont work

[10ofhearts]

Great hack, and really useful.

I have a question.

Is there a way to use this hack so that it copies the threads selected to a designated forum, or rather than putting the information in public view, it is private, depending on usergroup permissions?

To explain, we are about to link up with a new magazine being launched, we provide a free ad, they will give us a monthly page for free, and we wanted to add a bit about the top threads of the month, so this is ideal to identify them, but, we don't actually want the members to see what the threads are to try and promote sales, so getting the information provided into a forum without open viewing access is the best bet.

Does that explain what I mean, and if so, is it possible?

Thanks again, forums would be so boring if it wasn't for the guys and girls that took some time to do things like this

[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

[Annie^.^]

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

[Annie^.^]

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

Sorry I found the problem ....thanks great hack