Results 1 to 5 of 5
Thread: Post Count Is Stuck...
|
Enjoy an ad free experience by logging in. Not a member yet? Register.
|
|
-
09-03-2005 #1
- Join Date
- Aug 2005
- Posts
- 542
Post Count Is Stuck...
By the way, those posts were not in the coffee lounge.
-
09-03-2005 #2
Post in the Coffee Lounge no longer count.
http://www.linuxforums.org/forum/topic-51810.htmlDell Precision T7400 Workstation
Dual 3.33Ghz Xeon "Harpertown" Core
16GB PC5300 DDR2 ECC CL5
BFG GeForce GTX 285 OC 2GB
X-Fi Platinum
HP w2408 24" Monitor
Dual Boot:openSUSE 11.2/Win 7 Ultimate
-
09-03-2005 #3
- Join Date
- Jul 2005
- Posts
- 138
and if you post consecutive replies in a thread.....they count as one reply
regards,
ordoni
-
09-03-2005 #4
- Join Date
- Aug 2005
- Location
- Peterborough, UK
- Posts
- 379
This thread should probably live here: http://www.linuxforums.org/forum/forum-1.html
\"I am, after all,\" said Pooh, \"a bear of very little brain.\"
MY PC: Athlon XP64 3000+ on a Asus K8V-X mobo w/1GB of non-descript RAM. AGP - GeForce 2 MX400. PCI - Creative Live! 5.1 soundcard. 140 GB and 120 GB SATA WD drives.
-
09-03-2005 #5
- Join Date
- Apr 2003
- Location
- London, UK
- Posts
- 3,284
Your post count seems to be about right, actually, 2 posts to high.
Code:mysql> select f.forum_name, count(*) FROM posts p INNER JOIN users u ON (u.user_id = p.poster_id) INNER JOIN forums f ON (f.forum_id = p.forum_id) WHERE u.username = 'chopin1810' GROUP BY p.forum_id; +--------------------------------+----------+ | forum_name | count(*) | +--------------------------------+----------+ | The Coffee Lounge | 19 | | Linux Newbie | 3 | | Misc | 42 | | Spam, Lamerz & Removed Content | 3 | | Redhat / Fedora Linux Help | 5 | | SuSE Linux Help | 10 | | Debian Linux Help | 2 | | Mandriva Linux Help | 1 | | Everything BSD | 8 | +--------------------------------+----------+ 9 rows in set (7.64 sec)