|
Xianti
|
10-30-2005, 06:38 PM
Post subject: phpBB question
|
#1 (permalink)
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: facebook.com/xianti
Posts: 5,289
|
|
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?
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
™
|
|
Straight
Join Date: Jan 2005
Location: MA
Posts: 144
|
|
can you just look at the member list and then sort it by post count?
|
|
|
|
™
|
|
Straight
Join Date: Jan 2005
Location: MA
Posts: 144
|
|
oh wait do you mean like, most posts in the comune, most posts in poker ect, ect?
|
|
|
|
Xianti
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: facebook.com/xianti
Posts: 5,289
|
|
Quote:
|
Originally Posted by ™
oh wait do you mean like, most posts in the comune, most posts in poker ect, ect?
|
Correct.
|
|
|
|
™
|
|
Straight
Join Date: Jan 2005
Location: MA
Posts: 144
|
|
ahh, i dont know that you can
|
|
|
|
Xianti
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: facebook.com/xianti
Posts: 5,289
|
|
Not even with some special search query code?
|
|
|
|
Eric
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: on my laptop
Posts: 1,782
|
|
You could do it as a sql query.
|
|
|
|
Xianti
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: facebook.com/xianti
Posts: 5,289
|
|
Could you show me how to do that sometime?
|
|
|
|
Eric
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: on my laptop
Posts: 1,782
|
|
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
|
|
|
|
|
vqc
|
|
Straight Flush
Join Date: Jan 2005
Posts: 5,427
|
|
OOo OOO OOOO
how mnay have i posted in the SNG forum!!!
|
|
|
|
Xianti
|
|
Administrator
Administrator
Join Date: Dec 2003
Location: facebook.com/xianti
Posts: 5,289
|
|
Thanks, Eric.
Roffle... 'rilla has more than double of the runner-up in Commune.
|
|
|
|
Demiparadigm
|
|
4-of-a-Kind
Join Date: Feb 2005
Location: Party 6 max
Posts: 1,602
|
|
Quote:
|
Originally Posted by vqc
OOo OOO OOOO
how mnay have i posted in the SNG forum!!!
|
749.
Congrats.
|
|
To win in poker you only need to be one step ahead of your opponents. Two steps may be detrimental.
|
|
vqc
|
|
Straight Flush
Join Date: Jan 2005
Posts: 5,427
|
|
awesome!
|
|
|
|
a500lbgorilla
|
|
JESUS TAKE THE KEYBOARD
Join Date: Sep 2004
Location: This room is a good place to be
Posts: 8,379
|
|
Quote:
|
Originally Posted by Xianti
Thanks, Eric.
Roffle... 'rilla has more than double of the runner-up in Commune.
|
This is mah house.
-'rilla
|
Smithers, use the amnesia ray.
You mean the revolver, sir?
Precisely.
|
|
bigred
|
|
PROFESSIONAL TROLL
Join Date: Sep 2004
Location: Nest of Douchebags
Posts: 2,184
|
|
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.
|
|
LOL OPERATIONS
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
