Top 10 Thread Stats v1.0

Top 10 Thread Stats V1.0

Right here you got took me alot of time to figure it out but i have finnaly done it .

I have made this little hack called Top 10 Stats.

Features.

Top 10 Posters.

Displays the Top 10 new members.
Displays there posts.
Displays the Top 10 Posters.
Displays a option to find more/all posts by the user.
Displays there posts.

Top 10 Newest Members.

Displays the Top 10 new members.
Displays there posts.

Top 10 Threads

Displays how many replies the thread has
Displays top 10 newest replies.
Displays the Thread Starters Name.
Displays the Thread Replies Name.
Displays how many views it has.

Displays Most Popular Thread
And how many replies it has

Displays Most Rated Thread.
And how many votes it has.

Thats all for now i will be adding extra stuff in version 2.0

[Mathiau]

^^^^

not to mention winrar has far better compression and speed

WInzip is old and out of date now.

[Mathiau]

OKay Question:


How easy would it to be to add other "top" list?

Lets say i want a "Top News reporter" and such? (possibly in a new table right below the 3 top stats already there.

i was trying to do it myself but just did not seem to come out right.......


P.S - Great job to BOTH guys who did this - the originator and the improved

[GMeadows]

Is it possible to stop certain forums frmo being displayed in the "top 10 recent posts" box...i.e. posts to a hidden/moderator area.

Gary

[wolfe]

tes like in the original one

in index.php find

$pop = $DB_site->query('SELECT title,threadid,postusername,lastpost,lastposter,views FROM thread ORDER BY lastpost DESC LIMIT 10');

and replace it with

$pop = $DB_site->query("SELECT replycount,title,threadid,lastpost,postusername,lastposter,views FROM 
thread WHERE forumid<>'XX' AND forumid<>'XX' ORDER BY lastpost DESC LIMIT 10");

replace the XX with the forum id if the forum id is 1 number delete both X's and put the forum id number

and if you have more forums you want to add than whats there

add this

 AND forumid<>'XX'

after

AND forumid<>'XX'

hope it helps

[wolfe]

Originally posted by Mathiau
OKay Question:


How easy would it to be to add other "top" list?

Lets say i want a "Top News reporter" and such? (possibly in a new table right below the 3 top stats already there.

i was trying to do it myself but just did not seem to come out right.......


P.S - Great job to BOTH guys who did this - the originator and the improved

will look into it d00d

[zahrani]

I wanted to make reated threads 5 instead of 1, so I changed
$rated = $DB_site->query('SELECT title,threadid,votenum FROM thread ORDER BY votenum DESC LIMIT 1');

to be:

$rated = $DB_site->query('SELECT title,threadid,votenum FROM thread ORDER BY votenum DESC LIMIT 5);

but all threads came in one line, not in 5 lines.

for example, I need it to be like this:

thread === user name === number of voting === thread rating



thanks

[Kinox]

add <br>

$thread .= "$rated[title]<br>"; :P

[Sebastian]

i like this hack, but i want people to see only threads/forums they have access to... for instance, i have moderators that have access to some forums and not others, while i also have admins that have access to all threads and some lower moderators with access to other forums.. so it would be cool for a user to only see threads/forums under their access level.

[lifesourcerec]

How do I remove the "Displays how many replies the thread has". I removed $popreplycount from the template, but that only disabled the link. The [0] still shows up.

[X-Fan]

Has anyone zipped this up yet? Or even easier, posted the install.txt as an attachment?

I've got WinRAR, but get an error when trying to extract the install file.