Haggis Top Posters

[ktp101]

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]

Reserved lol

[gingery]

How can I change it to only show the top posters during the last 24 hours?

[ktp101]

am working on that as wee speak

[gingery]

Thank you! That is just what I'm looking for.

[Phooey]

Neat concept, I might have to install this one once I'm home from work.

[Zachery]

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]

Awesome! Thanks for this. :D

[CrossBones]

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]

You could've atleast used a variable more unique than "$test".

[Eric]

Nice, although you should be using vBulletin's database class ;)

[Zachery]

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]

This should be flagged for poor programming.

[harmor19]

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]

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]

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]

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? : https://vborg.vbsupport.ru/showthread.php?t=105546

[harmor19]

So is this one coded equally as bad? : https://vborg.vbsupport.ru/showthread.php?t=105546
They're the exact same thing. So to answer oyur question, yes, it is equally bad if not worse.

[CrossBones]

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]

I informed Princeton and told him that the hack on this thread and the hack on another thread (https://vborg.vbsupport.ru/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]

THANK YOU

THANK YOU

Great Hack

[colochris]

ok maybe not

[colochris]

where can i find one like this?

[Gaia]

Thanks, installed ^_^

[rezapci]

thanks so much

awesome work...

[iran.gs]

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]

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]

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]

Thanks :O)

[webgeek247]

installed

cheers :)

[Jesakos]

worked thnx :D

[Slyfox1]

I had mine re-coded :) Cost me $$$ but the end result is much better :)

http://www.theuglybuggers.com/forum

[slinky]

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.