Select Page
Poker Forum
Over 1,292,000 Posts!
REGISTER
Subscribe to FTR web feed
Poker Forum › FTR Community ›

phpBB question

Results 1 to 15 of 15

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-30-2005 02:38 PM #1
    Xianti's Avatar
    Xianti
    Xianti is offline Retired forum manager
    Join Date
    Dec 2003
    Posts
    9,246
    Location
    facebook.com/mediacookery

    Default 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?
    Reply With Quote Reply With Quote  
  2. 10-31-2005 12:55 AM #2
    ™'s Avatar
    ™
    ™ is offline
    Join Date
    Jan 2005
    Posts
    389
    Location
    MA
    can you just look at the member list and then sort it by post count?
    Reply With Quote Reply With Quote  
  3. 10-31-2005 12:59 AM #3
    ™'s Avatar
    ™
    ™ is offline
    Join Date
    Jan 2005
    Posts
    389
    Location
    MA
    oh wait do you mean like, most posts in the comune, most posts in poker ect, ect?
    Reply With Quote Reply With Quote  
  4. 10-31-2005 01:03 AM #4
    Xianti's Avatar
    Xianti
    Xianti is offline Retired forum manager
    Join Date
    Dec 2003
    Posts
    9,246
    Location
    facebook.com/mediacookery
    Quote Originally Posted by ™
    oh wait do you mean like, most posts in the comune, most posts in poker ect, ect?
    Correct.
    Reply With Quote Reply With Quote  
  5. 10-31-2005 01:06 AM #5
    ™'s Avatar
    ™
    ™ is offline
    Join Date
    Jan 2005
    Posts
    389
    Location
    MA
    ahh, i dont know that you can
    Reply With Quote Reply With Quote  
  6. 10-31-2005 01:07 AM #6
    Xianti's Avatar
    Xianti
    Xianti is offline Retired forum manager
    Join Date
    Dec 2003
    Posts
    9,246
    Location
    facebook.com/mediacookery
    Not even with some special search query code?
    Reply With Quote Reply With Quote  
  7. 10-31-2005 01:09 AM #7
    Eric's Avatar
    Eric
    Eric is offline
    Join Date
    Dec 2003
    Posts
    3,458
    Location
    California, USA
    You could do it as a sql query.
    Reply With Quote Reply With Quote  
  8. 10-31-2005 01:10 AM #8
    Xianti's Avatar
    Xianti
    Xianti is offline Retired forum manager
    Join Date
    Dec 2003
    Posts
    9,246
    Location
    facebook.com/mediacookery
    Could you show me how to do that sometime?
    Reply With Quote Reply With Quote  
  9. 10-31-2005 01:29 AM #9
    Eric's Avatar
    Eric
    Eric is offline
    Join Date
    Dec 2003
    Posts
    3,458
    Location
    California, USA
    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.
    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
    Reply With Quote Reply With Quote  
  10. 10-31-2005 01:30 AM #10
    vqc
    vqc is offline
    Join Date
    Jan 2005
    Posts
    6,560
    OOo OOO OOOO
    how mnay have i posted in the SNG forum!!!
    Reply With Quote Reply With Quote  
  11. 10-31-2005 01:32 AM #11
    Xianti's Avatar
    Xianti
    Xianti is offline Retired forum manager
    Join Date
    Dec 2003
    Posts
    9,246
    Location
    facebook.com/mediacookery
    Thanks, Eric.

    Roffle... 'rilla has more than double of the runner-up in Commune.
    Reply With Quote Reply With Quote  
  12. 10-31-2005 01:35 AM #12
    Demiparadigm's Avatar
    Demiparadigm
    Demiparadigm is offline
    Join Date
    Feb 2005
    Posts
    1,963
    Location
    Party 6 max
    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.
    Reply With Quote Reply With Quote  
  13. 10-31-2005 01:38 AM #13
    vqc
    vqc is offline
    Join Date
    Jan 2005
    Posts
    6,560
    awesome!
    Reply With Quote Reply With Quote  
  14. 10-31-2005 08:08 AM #14
    a500lbgorilla's Avatar
    a500lbgorilla
    a500lbgorilla is offline SPLENDID GUY
    Join Date
    Sep 2004
    Posts
    28,082
    Location
    himself fucker.
    Quote Originally Posted by Xianti
    Thanks, Eric.

    Roffle... 'rilla has more than double of the runner-up in Commune.
    This is mah house.

    -'rilla
    <a href=http://i.imgur.com/kWiMIMW.png target=_blank>http://i.imgur.com/kWiMIMW.png</a>
    Reply With Quote Reply With Quote  
  15. 10-31-2005 11:51 AM #15
    bigred's Avatar
    bigred
    bigred is offline
    Join Date
    Sep 2004
    Posts
    15,437
    Location
    Nest of Douchebags
    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
    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules