vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Best&Worst Thread of the day-Week-Month (https://vborg.vbsupport.ru/showthread.php?t=107711)

Developer 02-20-2006 02:03 PM

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

LadyBeth 02-20-2006 02:20 PM

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 02-20-2006 09:01 PM

Quote:

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 02-20-2006 11:26 PM

Quote:

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

Hornstar 02-21-2006 12:21 AM

Quote:

Originally Posted by Developer
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 02-22-2006 03:37 PM

stilld ont work

10ofhearts 02-23-2006 03:40 AM

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 02-23-2006 04:17 AM

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^.^ 02-27-2006 01:39 AM

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

Annie^.^ 02-27-2006 01:44 AM

Quote:

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

RFViet 03-07-2006 02:42 PM

I want to change phrase of day, week, month => How can I do that ?? Thanks.

Annie^.^ 03-07-2006 03:18 PM

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

Gizmo5h1t3 03-07-2006 04:08 PM

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 03-26-2006 04:06 PM

You really need to put spaces after words and colons... :|

MarsNIIT 03-26-2006 07:46 PM

Quote:

Originally Posted by 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


Error same me, it not support vbb install with prefix table. Please fix it. Thank you verry much.

Developer 03-31-2006 07:57 PM

Quote:

Originally Posted by Annie^.^
So what is to the solution the above thread??? I am getting the same error and I use table prefix

https://vborg.vbsupport.ru/attachmen...4&d=1139667840
u have to put at leaset 0 in ex. forums & threads

Developer 03-31-2006 07:58 PM

Quote:

Originally Posted by Annie^.^
Is there a way to see more than one most replied threads?

currently:no

Developer 03-31-2006 07:58 PM

Quote:

Originally Posted by MarsNIIT
Error same me, it not support vbb install with prefix table. Please fix it. Thank you verry much.

https://vborg.vbsupport.ru/attachmen...4&d=1139667840
u have to put at leaset 0 in ex. forums & threads

MarsNIIT 04-02-2006 09:15 PM

yes, thank you, it work :D

Amaranth 04-09-2006 05:57 PM

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 04-18-2006 07:51 AM

One of the best I have ever seen <claps>

MorrisMcD 04-18-2006 02:18 PM

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 04-21-2006 10:22 AM

preety cool thanks. everyone sure loves statistics!

Invalid ID 04-21-2006 05:55 PM

It's working fine on the default template, but not working on the other skins that I uploaded later.

What to do?

ShadowOne 04-24-2006 03:58 PM

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 05-16-2006 04:18 PM

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

Lottis 05-16-2006 04:27 PM

I think the Developer is away;
Exams peroid: no-support NOR custom work to 8-6-06
See his signatur. ;)

vbreal 06-09-2006 02:45 AM

Quote:

Originally Posted by 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/adm...ex.php?do=head
IP Address : 68.38.252.172
Username : ??řķ ρřǿЈιΆ†
Classname : vB_Database

Quote:

Originally Posted by Developer
https://vborg.vbsupport.ru/attachmen...4&d=1139667840
u have to put at leaset 0 in ex. forums & threads

this may help

Pcparts 08-06-2006 12:39 PM

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 08-06-2006 05:09 PM

Sweet!:D

newbe_haselina 08-27-2006 05:48 AM

I love this hack :) ... thx!

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

DiMiT 09-05-2006 08:47 PM

looks nice gonna give it a go
thanks yo :)


oh and HI EVERYBODY! I am new :)

chikkoo 09-19-2006 02:24 AM

Does it works with 3.6.0?

newbe_haselina 09-24-2006 01:22 PM

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 10-13-2006 01:36 AM

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 05-01-2007 06:34 PM

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 11-19-2007 07:47 AM

Quote:

Originally Posted by RedGTiVR6 (Post 1239113)
and will it work on 3.6?

The same question here :confused:

anarx 02-20-2008 09:47 AM

Hi ! is there a hack for 3.7 too?

tanyeri24 02-23-2008 07:52 PM

doesnt work in 3.7.x

medicalforums 09-08-2009 05:56 AM

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


All times are GMT. The time now is 09:26 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01357 seconds
  • Memory Usage 1,829KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete