Top xx Posters List

This modification is no longer available or supported.

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.

[Brinnie]

woot!

I'll take 2!

[Kusadasi-Guy]

PHP Code:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
            FROM " . TABLE_PREFIX . "post AS post
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
            WHERE dateline > $startp AND user.usergroupid IN ($groupsp) 
            GROUP BY userid ORDER BY postcount DESC LIMIT 10 


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

[plateau]

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.

[iceytdot]

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

[Paul M]

Originally Posted by iceytdot

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

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

[iceytdot]

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

[iceytdot]

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

[iceytdot]

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:

There seems to have been a problem with the Unsigned Hype database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

went to my technical support email & had this:



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;

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:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select count(*) as newposts from post where dateline >= 1127528755 and visible = 1;

MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054

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

[Paul M]

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.

[Trevor Hannant]

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........