Letter counter in getinfo for all posts by a user!
Hi there,
I really want a letter counter for my forums . A user writes a post and the number of letters it contains is added to his counter. Of course, 'editpost' has to be considered, too. The counter should show up in getinfo. Now, all in all, I understand what has to be done, but my SQL is too bad to figure out how to count the letters in the existing posts and where to insert them. I tried it with some simple loops, printing out per userid, but ... well, I'm not up to it.
Since I'm posting this in "Hack Requests", I'm obviously shooting for a complete solution :cheeky:. But if someone takes the time to post some PHP/SQL code on how to count the letters in the existing posts and gives advice on which database structure would be best (I'm guessing the best would be a new field in the user table containing the calculated number, constantly updated by newreply/newthread/editpost; counting anew every time would result in an extreme load), I might be able to try it on my own again.
03-15-2003, 05:57 AM
Letter counter in getinfo for all posts by a user!
. A user writes a post and the number of letters it contains is added to his counter. Of course, 'editpost' has to be considered, too. The counter should show up in getinfo. Now, all in all, I understand what has to be done, but my SQL is too bad to figure out how to count the letters in the existing posts and where to insert them. I tried it with some simple loops, printing out per userid, but ... well, I'm not up to it.
Threaded Mode