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:

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

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