Forum Home Enhancements - Best&Worst Thread of the day-Week-Month

Best&Worst Thread of the day-Week-Month

vBulletin 3.5.3
www.vBHackers.com

<b>Description::.

This hack shows in forum home Best&Worst Thread of the day-Week-Month

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

</b>
Installation::.

1-Import The Product.
2-Edit Template FORUMHOME

Find:

You must first be a registered member to view any code.

Add After it

You must first be a registered member to view any code.

History::.

1.0 On 11. Feb 2006 Initial Version.

Hack Languages::.

English Only For Now

Details::.

6 plugin, 26 phrases, 12 options, 6 queries(reading only not change or add)

aT lAsT::.

IF YOu lIkE iT cLIcK INSTALL
vbulletin.org
vbhackers.com

</b>

[kofoid]

Is there a way I can get this to work in a CMPS module?

[xtremox]

thanks you!

[HeLL]

Good job dude!

easy to install and dont find any bug

thanks ;)

[stivo]

Seems to be a nice hack thnx

[webgroup]

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 vbnewthread, forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1153617431 AND 1153790231
AND thread.forumid NOT IN (4)
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 ')
ORDER BY thread.replycount DESC LIMIT 1' at line 15 Error Number : 1064
Date : Sunday, July 23rd 2006 @ 09:17:11 PM


When opening forum home after installation.
If I disable the hack, the problem goes away.

Please help

[Senna]

After looking at the screenshots the author attached I would suggest recontrolling your settings and make sure you completed the last 2 fields, if not required with 0 instead of leaving the second one blank.

[dart vader]

thanks but is not working on 3.6

[icody]

i take same error om 3.6.4

Originally Posted by webgroup

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 vbnewthread, forum
WHERE forum.forumid = thread.forumid
AND dateline BETWEEN 1153617431 AND 1153790231
AND thread.forumid NOT IN (4)
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 ')
ORDER BY thread.replycount DESC LIMIT 1' at line 15 Error Number : 1064
Date : Sunday, July 23rd 2006 @ 09:17:11 PM


When opening forum home after installation.
If I disable the hack, the problem goes away.

Please help

[Mf.Rub]

thanks ;) very good