Best&Worst Thread of the day-Week-Month

[Developer]

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 (https://vborg.vbsupport.ru/member.php?u=36046) Had translate the hack to french. here (https://vborg.vbsupport.ru/showpost.php?p=903147&postcount=37)
Hellraider (http://www.vbhacks-germany.com/forum/member.php?u=10) Had translate the hack to german. here (http://www.vbhacks-germany.com/forum/showthread.php?t=3151)
Details::.
6 plugin, 26 phrases, 12 options, 6 queries(reading only not change or add)
Donation::.
Feel Free To https://www.paypal.com/en_US/i/btn/x-click-butcc-donate.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=filmahosting%40gmail%2ecom&item_name=DEVELOPER&item_number=1&no_shipping=0&no_note=1&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)
aT lAsT::.
IF YOu lIkE iT cLIcK INSTALL
vbulletin.orghttps://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=107711)
Support Given For Who Clicked Install {ONLY}

[RFViet]

I'll try it, thanks !!

[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.

[Gizmo5h1t3]

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

[Developer]

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]

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:


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

[Mr Chad]

anyone know how to fix this?

[o0Hubba0o]

Like the idea, I'll keep an eye on this one, appears to be some bugs maybe?

[PHPGeek2k3]

hello,

this really isnt a bug just you havent set a setting in the vBulletin Options.

You need to set

Exclude Forums to 0
and
Exclude Threads to 0

than this will work

Thanks
- James

[apdcanari]

hello,

this really isnt a bug just you havent set a setting in the vBulletin Options.

You need to set

Exclude Forums to 0
and
Exclude Threads to 0

than this will work

Thanks
- James

no...bug for me

[orphan]

for me too

[orphan]

Sql Query is not including table prefix!
If you correct it it works fine

[Mr Chad]

Sql Query is not including table prefix!
If you correct it it works fine

you sure?

[PHPGeek2k3]

your right and for some reason i didnt see that.

Thanks
- James

[Snake]

Thanks man!

[PHPGeek2k3]

in order to fix this you need to change the every instance of


FROM " . TABLE_PREFIX . "thread, forum


To the following


FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "forum AS forum

[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]

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 :(

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

[Developer]

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

[Mr Chad]

you didn't but 0 in exclude threads and exclude forums
https://vborg.vbsupport.ru/attachment.php?attachmentid=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]

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

[Developer]

ok question how can i get it on the top of my forumhome?
after $navbar add the code

[CupraSi]

after $navbar add the code

Is that in Forum Home?

[Developer]

yes ....

[CupraSi]

Brilliant have managed to move it to the top now

Thanks

[Gwynar]

Does this make use of vb cron?

If not, might I suggest you include it? On highly trafficked boards it might be beneficial to use the vb cron.

[lazytown]

as i said this hack requestedHuh? So no answers to my questions? So it's requested.. What was the request?
-vissa

[Developer]

Does this make use of vb cron?

If not, might I suggest you include it? On highly trafficked boards it might be beneficial to use the vb cron.
ok may i make it later

[Allan]

Click Install ;)

French Language :)

[nufc fan]

im still new to all this so what di i have to do when instructions say import the product can someone tell me what to do please.

[Developer]

im still new to all this so what di i have to do when instructions say import the product can someone tell me what to do please.
goto to you're admin cp ==> Plugin System ==> Manage Products ==> [Add/Import Product] ==> upload the product then from Admin cp also
==> vBulletin Options ==> vBulletin Options ==> BestWorst Thread of the (day,week,month) and change settings

[nufc fan]

thanks mate

[Developer]

allan (https://vborg.vbsupport.ru/member.php?u=36046) Had translate the hack to french. here (https://vborg.vbsupport.ru/showpost.php?p=903147&postcount=37)
Hellraider (http://www.vbhacks-germany.com/forum/member.php?u=10) Had translate the hack to german. here (http://www.vbhacks-germany.com/forum/showthread.php?t=3151)

[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]

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]

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 :D
anyway
what it is the trophy you suggest? an image? or add 20 posts to his post cont or something like that?

[Hornstar]

there is no person of the month :D
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^.^]

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

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

[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]

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]

So what is to the solution the above thread??? I am getting the same error and I use table prefix
https://vborg.vbsupport.ru/attachment.php?attachmentid=42564&d=1139667840
u have to put at leaset 0 in ex. forums & threads

[Developer]

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

[Developer]

Error same me, it not support vbb install with prefix table. Please fix it. Thank you verry much.
https://vborg.vbsupport.ru/attachment.php?attachmentid=42564&d=1139667840
u have to put at leaset 0 in ex. forums & threads

[MarsNIIT]

yes, thank you, it work :D

[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.

[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/admincp/index.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]

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/admincp/index.php?do=head
IP Address : 68.38.252.172
Username : ??řķ ρřǿЈ领
Classname : vB_Database

https://vborg.vbsupport.ru/attachment.php?attachmentid=42564&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!:D

[newbe_haselina]

I love this hack :) ... thx!

Sorry if the following question had been already asked, but does this hack work with 3.6?

[DiMiT]

looks nice gonna give it a go
thanks yo :)


oh and HI EVERYBODY! I am new :)

[chikkoo]

Does it works with 3.6.0?

[newbe_haselina]

As I can see, it won't work with 3.6.1 :confused:

Please tell me, that I'm wrong, I love this hack and my user love it too ... any idea?

[manutdvn]

I tried to set the best, worst thread in serverals boxes, but it doesnot work. It shows threads in all boxes in forum. How can I fix this?

Thanks in advance.

[RedGTiVR6]

seems that the question about how the threads are determined aren't answered...

is it based solely on post count?

and will it work on 3.6?

Looks promising to say the least!

[Artes_Marciales]

and will it work on 3.6?

The same question here :confused:

[anarx]

Hi ! is there a hack for 3.7 too?

[tanyeri24]

doesnt work in 3.7.x

[medicalforums]

I installed it in 3.8.3 and it works absolutely fine
there one more </if> that you have to add the forumhome code before it works

Thanks for such a wonder MOD