PDA

View Full Version : Forum Home Enhancements - Haggis Top Posters


ktp101
30 Aug 2006, 18:41
This will display the top XX poster in the Whats going on box (see screenshot)

XML File and Instructions are included

Requires an Addtion to one template

Thanks for using my plugin and any comments are welcome

ktp101
30 Aug 2006, 18:42
Reserved lol

gingery
30 Aug 2006, 19:10
How can I change it to only show the top posters during the last 24 hours?

ktp101
30 Aug 2006, 19:37
am working on that as wee speak

gingery
30 Aug 2006, 19:45
Thank you! That is just what I'm looking for.

Phooey
30 Aug 2006, 19:47
Neat concept, I might have to install this one once I'm home from work.

Zachery
30 Aug 2006, 20:46
Thats a crappy query to run everytime someone accesses the forumhome. I'd suggest adding an index for that if possible, or cacheing the data by way of a croin and the datastore.

Snake
31 Aug 2006, 00:17
Awesome! Thanks for this. :D

CrossBones
31 Aug 2006, 01:18
Thats a crappy query to run everytime someone accesses the forumhome. I'd suggest adding an index for that if possible, or cacheing the data by way of a croin and the datastore.But it works really well. *shrug*

harmor19
31 Aug 2006, 03:34
You could've atleast used a variable more unique than "$test".

Eric
31 Aug 2006, 03:40
Nice, although you should be using vBulletin's database class ;)

Zachery
31 Aug 2006, 23:46
But it works really well. *shrug*
It works really well untill you have several hundered thousands users online and you need to scan the user table every time someone access the forumhome.

harmor19
01 Sep 2006, 00:42
This should be flagged for poor programming.

harmor19
01 Sep 2006, 00:56
I'm trying to help ktp with his code but after writing additional code to it I thought "what the hell am I going to do with this?".
I thought I could limit it so it would only check once a week but don't know how to go about caching the data until the query ran again.

if(date("d") % 7 == 1)
{
$gettopusers = $db->query_read("SELECT userid,username,posts FROM " . TABLE_PREFIX ."user ORDER BY posts DESC LIMIT 10");
while($topuser = $db->fetch_array($gettopusers))
{
$disptopuser .= "<a href='member.php?u=$topuser[userid]'>".$topuser['username']."</a> ($topuser[posts]), ";
}
}

Zachery
01 Sep 2006, 04:28
Use a vB cron and have it run once an hour, day, whatever, and have it update another row possibly in the datastore so it can be pulled on demand.

CrossBones
01 Sep 2006, 16:02
It works really well untill you have several hundered thousands users online and you need to scan the user table every time someone access the forumhome.I wish I had that problem. :cross-eyed:

CrossBones
01 Sep 2006, 16:07
It works really well untill you have several hundered thousands users online and you need to scan the user table every time someone access the forumhome.So is this one coded equally as bad? : http://www.vbulletin.org/forum/showthread.php?t=105546

harmor19
01 Sep 2006, 19:51
So is this one coded equally as bad? : http://www.vbulletin.org/forum/showthread.php?t=105546
They're the exact same thing. So to answer oyur question, yes, it is equally bad if not worse.

CrossBones
02 Sep 2006, 00:16
They're the exact same thing. So to answer oyur question, yes, it is equally bad if not worse.D'oh. http://wildpitchforums.com/images/smilies/banghead.gif

harmor19
02 Sep 2006, 18:39
I informed Princeton and told him that the hack on this thread and the hack on another thread (http://www.vbulletin.org/forum/showthread.php?t=105546) are coded exactly the same way. The only difference between these two is that this one fetches 5 rows and the other gets 10.

As people already stated, This hack is horribly coded which means the other one is equally if not worse. I say it's worse because it has to get 10 rows as opposed to 5.
You may also experience conflict if you installed the two hacks or had another other plugin in "forum_start" hook where you use $test as your output variable.
What I mean by that is that you use $test on the "forumhome" template.

I tried to privately deal with this to lessen the chances of hurting someone's creditably but I guess I'm not important enough for someone to read my private message.

colochris
07 Sep 2006, 06:23
THANK YOU

THANK YOU

Great Hack

colochris
07 Sep 2006, 06:28
ok maybe not

colochris
07 Sep 2006, 06:29
where can i find one like this?

Gaia
15 Sep 2006, 14:53
Thanks, installed ^_^

rezapci
18 Sep 2006, 17:26
thanks so much

awesome work...

iran.gs
27 Sep 2006, 23:43
lnstalled but i must agree with others it can be a problem on the long run well
mine shows double unless i am seeing double lol once all shown again secend line shows them again wierd i played with setting same thing.... uninstalled ,

ktp101
11 Oct 2006, 13:07
The hack was made mainly for use on MY forum

I aint an expert in PHP coding so if the code sucks simple answer is dont use it

i aint all that up on Vb coding either so again dont like it dont use it

ktp101
11 Oct 2006, 13:11
I tried to privately deal with this to lessen the chances of hurting someone's creditably but I guess I'm not important enough for someone to read my private message.

do u mean someone else coz i never received no pm

Emanet-Kaos
17 Oct 2006, 22:39
Thanks :O)

webgeek247
27 Oct 2006, 12:36
installed

cheers :)

Jesakos
24 Feb 2007, 23:38
worked thnx :D

Slyfox1
25 Feb 2007, 07:11
I had mine re-coded :) Cost me $$$ but the end result is much better :)

http://www.theuglybuggers.com/forum

slinky
16 Mar 2008, 20:20
Sly - yours is just placed on the bottom. What is different about it other than placement? This one actually works. If there is a cached version of this simple mod, would love to find it.