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

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.

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?

stilld ont work

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

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

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

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