phpBB question

Printable View

10-30-2005, 02:38 PM
Xianti

phpBB question

Anyone know if there's a way to do a search query in phpBB to see who has the most posts within a particular forum?
10-31-2005, 12:55 AM
™

can you just look at the member list and then sort it by post count?
10-31-2005, 12:59 AM
™

oh wait do you mean like, most posts in the comune, most posts in poker ect, ect?
10-31-2005, 01:03 AM
Xianti

Quote:

Originally Posted by ™

oh wait do you mean like, most posts in the comune, most posts in poker ect, ect?

Correct.
10-31-2005, 01:06 AM
™

ahh, i dont know that you can
10-31-2005, 01:07 AM
Xianti

Not even with some special search query code?
10-31-2005, 01:09 AM
Eric

You could do it as a sql query.
10-31-2005, 01:10 AM
Xianti

Could you show me how to do that sometime?
10-31-2005, 01:29 AM
Eric

This query shows the top 10 posters in this ftr community forum.
You can check other forums by changing the pp.forum_id=14 line.
You run the queries in the same window where you've run sql statements for mods.

Quote:

SELECT pu.username, count( * )
FROM phpbb_posts pp, phpbb_users pu
WHERE pp.forum_id =14
AND pp.poster_id = pu.user_id
GROUP BY pu.username
ORDER BY 2 DESC
LIMIT 10
a500lbgorilla 2037
dwarfman 873
Xianti 646
vqc 424
BoondockSaint 415
FyrFytr998 411
TylerK 384
Muxy 376
gabe 332
Miffed22001 321
10-31-2005, 01:30 AM
vqc

OOo OOO OOOO
how mnay have i posted in the SNG forum!!!
10-31-2005, 01:32 AM
Xianti

Thanks, Eric.

Roffle... 'rilla has more than double of the runner-up in Commune.
10-31-2005, 01:35 AM
Demiparadigm

Quote:

Originally Posted by vqc

OOo OOO OOOO
how mnay have i posted in the SNG forum!!!

749.

Congrats.
10-31-2005, 01:38 AM
vqc

awesome!
10-31-2005, 08:08 AM
a500lbgorilla

Quote:

Originally Posted by Xianti

Thanks, Eric.

Roffle... 'rilla has more than double of the runner-up in Commune.

This is mah house.

-'rilla
10-31-2005, 11:51 AM
bigred

Rilla is such a nerd. I don't think rada or I will let you come out to vegas and play beer pong with us now.