| View previous topic :: View next topic |
| Author |
Message |
f.kater
Guru
Joined: 23 May 2002
Posts: 342
Location: Berlin
|
 Posted: Mon Oct 07, 2002 7:04 pm Post subject: suggestion: not only count replies of users... |
 |
|
Hi,
it just came to my mind:
There are people (like me I have to admit...) who are posting into newsgroups because the need help. Other people offer help. I don't know if anyone is interested in that difference  but if so you could count the replies AND also count replies to threats which weren't started from this user... |
|
| Back to top |
|
 |
progster
Apprentice
Joined: 16 Jul 2002
Posts: 271
|
| Posted: Mon Oct 07, 2002 8:13 pm Post subject: |
|
|
Ehh that would mean rewriting a big part of the board (which was written by a whole team of php programmers), so I don't think they'll be doing that...
Then again, maybe they have some free time on their hands
~Progser |
|
| Back to top |
|
|
rac
Bodhisattva
Joined: 30 May 2002
Posts: 6553
Location: Japanifornia
|
| Posted: Mon Oct 07, 2002 8:52 pm Post subject: |
|
|
Progster may be right when it comes to actually finding a place to store the information and a way to display it, but figuring it out is not so hard, I don't think. I'm not sure whether topic_id is unique across all forums or not, but assuming it is, | Code: | | select poster_id,count(post_id) from phpbb_posts, phpbb_topics where phpbb_topics.topic_id = phpbb_posts.topic_id and post_id = topic_first_post_id group by poster_id; |
...should give you a list of posters and how many threads they have started.
But all these numerical measurements are rather cold. Let's just try to follow "give what you can; take what you need".
_________________
For every higher wall, there is a taller ladder |
|
| Back to top |
|
|
|
Gentoo Forums Feedback
