Top xx Posters List
 

The 3.5 version of my Top (10) Posters hack.

This has now been re-vamped for the release of version 3.xx - the hack no longer uses a seperate topposters.php file.

This hack displays a page with the Top Forum Posters for a given set of periods. Two periods are fixed ('This Month' & 'Overall') but can be turned off in the options. The other three periods are user definable (in days) - the default values are 1 day (24 hours), 7 days & 28 days. These three columns cannot be turned off.

The number of posters to be shown can also be set, the default is the top 10 posters. You can also select which usergroups are included in the count, so members in banned groups etc are not shown.

To upgrade (if you want to) uninstall version 2.xx and re-install this version. Note the url to display the page has changed.


History:

v3.01 - First public version 3
v3.02 - Fixed display error reported in post 59
v3.03 - Fixed display error reported in post 84
v3.11 - Series of additions, upgrades and settings added.
v3.12 - Updated install code to check for existing index.
v3.13 - Fixed uncached templates added in v3.11
v3.14 : Changes to display layout.
v3.15 : Minor changes, no update necessary.
v3.16 : Fixed bug in monthly totals caculation.

Cool, that is nice :)

Gonna install

Hmm, so who rated this one star, and why :(

Installed :)

Satan

This is for vB Version: 3.5.0 Beta 4. :)

Click on the "my hacks" link in my sig and seek out the 3.0.7 version.

hell yes.

/me downloads and clicks install

v2.10 uploaded - added ability to filter the usergroups that are included (so you can exclude banned users etc).

Thanks. This is really great.

I just want to display this statistics table at the bottom of my forum home. How can I do that?

woot!

I'll take 2! :D

i wasted 2 days for this query. Thank You so much!

Paul M,

I just installed ur Flashchat hacks, and when I read this thread, I think I have to install this top poster hack again. I mean, what a nice idea, what a work :)

I think this hack could be an extension (extended thinking) to the TopXStats hack:
https://vborg.vbsupport.ru/showthread.php?t=93065

I ve kept my eyes on all these Ranking hacks for a very long time, several coders have released diff. types of ranking hacks for 3.5. however, I think if there is a hack that comprehensively works like a BillBoard or a Ranking Board for the vBulletin. That would be nice for an online society.

Top Posters, Most Viewed Topics, Most Replied Topics and so on, they can be displayed in one table and shown on the forumhome, and also can be detailed in a special page as what u do for the top poster...

could u be the one to think about this?

cheers mate.

hopefully this thread still gives support.. cuz i just got this error trying to install it!

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select count(*) as newposts from post where dateline >= 03:42 AM, 09-24-2005 and visible = 1;

anyway to fix this? or if not how do i unistall so i can get my forums back! i've re-traced you steps in the instructions & altered the SQL table with what you had ... but umm yea thats what im left with!

anyone

Erm, that sql code is nowhere in this hack, are you sure you posted in the right topic .......

i think so because i only got this error, immediately after i added the links in my navbar

but now i might have a bigger problem, i just dropped the whole dateline table in pHp my admin.. do you know how i can get that back lol

i want this code... just im pretty dumb wit certain things lol....... i can't believe i dropped that table .. i'm in for a long night

Paul M heres everything.... but i'm certain it had to be this code as it was the last before the site got the DB error

ok i had just installed my 3.5 again today! & i was installing a few minor hacks nuthing big but than i got to this hack:



https://vborg.vbsupport.ru/showthrea...t=92177&page=2



i followed the steps, did the SQL execution
so i wanted to see what it looked like on my site soon as i refreshed i had

this error:





went to my technical support email & had this:



Database error in vBulletin 3.5.0 Release Candidate 3:



so i thought i was all mister SMarTGuy went into pHp My admin, had no clue what i was doing & dropped the Dateline Table completely..



no the email is saying this:



so yeaaa i really screwed up & had no back up, as i didn't think i'd do something as dumb as this!!!! is there anyway to get my forums back

or am i going to have to start all over again... please tell me theres something i can do.... ANYTHING lol im Beggin

Sorry but that sql [for newposts] is simply not this hack - I would guess it's a hack to show a member the number of new posts since they last visited. It might help if you posted the whole message - since it should show has the script that called it.

As for dateline - that's a column in a table, not a table. You could probably recreate it with

ALTER TABLE post ADD dateline INT UNSIGNED NOT NULL DEFAULT '0'

But that won't recover the data it - all you posts would have a date of Jan1st 1970, and I doubt threads would show correctly. Don't you have a BACKUP ?

Oh, I have to go to bed now so I won't see any reply for a few hours.

Has anyone been able to write code to show the top average posters (ie. posters with highest 'posts per day')?

Realise this may be a 'messy' one to try but before I do, want to check if anyone else has been able to........

Any chance of this being re-made as a plug-in so I can drop it onto my home page in the whats going on area?

Love the mod, just don't like that it is on a page all by itself.

I wouldn't recommend having it on the homepage of a large board - the queries can be quite intensive if you have a large number of posts per month.

I don't intend to make it as a plugin, but you could do what you want pretty easily I think - just copy lines 18 to 80 of the code from the file to a plugin using the forumhome_start hook - and copy the table template code (i.e. the stuff between the <table> and </table> tags ) from the top_posters template into the forumhome template, above or below the "What' going on" table, depending on your preference. You might want to make it the Top 5 as well - for space reasons.

Interesting. I don't have a massive board, but hope to in the future, so I will follow your advise and keep it as a seperate page.

Paul, any thoughts on this or how to have this seperately somewhere?

Not at the moment, but I'll keep it in mind.

this ia a great addon.. :)

is it compatible with vb 3.5 gold..

thanx~

It'll work with any 3.5 version.

installed worked fine for me on gold

sweet. very nice i like!

installed it -- cool :)

can anyone tell me how i could make this link appear in the Quick Links instead though?

Go to your navbar template and scroll down until you see

<!-- user cp tools menu -->

Everything under this are links in your Quick Links menu.

Decide where you want the option to go and then drop this code in

[high]* Brandon Sheley installs ty for that last post, i put my link in the quick links too :)[/high]

thanks!

Nice. Paul M is The Man!

Thanks
very nice hack. but did there any way to make it display on the forumhome ? without extra page?

i mean like Top 'X' Stats
https://vborg.vbsupport.ru/showthrea...ht=Top+Posters

Thanks again

See post #22 (prevous page).

Thanks for help

Understand now

I have a large board, so i can't put it in forumhome

Thanks again

worked perfect, I threw it in the quicklinks - thanks :D

Very nice! I like that you wen't that extra step and didn't just make it an "all time top poster" thing.

I am curious, it shouldn't be all that difficult to *EXCLUDE* a certain forum ID, right?

I don't think I would want my Off Topic forum being counted in this tally. Would rather shine some light on my on-topic posters for a change. ;)

Cheers!

Easy enough if you modify the code.