Letters statistics On your forum home

This hack is based off of the one for member profiles, which is located here.

This hack displays the total number of keystrokes in all posts on your forums. And acording to Sho it should not effect page loads much.

There is one file edit and 1 template edit.

and can be done in less than a minute.

Enjoy!

[Xenon]

as i can see, this will go through all posts on your board and sum up the letters.
on a small board you're right, it wouldn't hurt, but if you have a lot of posts, this would be extremly harmfull..

enable debug mode in config.php then run index.php with &showqueries=1&explain=1 and you'll see how much time this query needs.

i won't use that hack on a great board, from what i can see, but if you use a sort of cache (like the todays birthday just a bit more complicated) it could be an intresting hack

in conclusion: it's no offend, but i think the negative aspect should be shown, too

[zajako]

the post count on forum home and thread count on forum home go through every post and thread as well.

This one does the small task of counting the letters in the text, it should not be too much on server load.

Now as for cached version i could create a version that runs this query once and stores it in the db and then adds to this count every time a post is made similar to how post counts for members work then make a line in th eadmin panel to update the counters for this. However currently i don't have the time fo rthat, Im currently trying to finsih up my RCS (Rpg Creation System).

So maybe in the future i might update it to that.

[Xenon]

nope there is a difference.

the post count on forumhome has just to look how much rows there are, that's very fast, the lettercounter has to visit each row and sums up the postlength.

it's like the combination of the 3 pm queries into one.
i've seen on several tests, when you have a lot of pm's the three queries are much faster than the one, because the one query version has to go through each row for the if clauses.

[zajako]

well then if your a bigger board you can try this till it becomes a problem, and if your a small board you should have no problem. My board has thsese stats since december:

Members: 294, Threads: 1,080, Posts: 19,315 Letters:5,181,800

And i have no problem with lodaing times on 56k.
Yes my board is relatively small so i can't tell you how it would be for large boards.
However the choice is yours and if it produces non desirable results feel free to remove it.

I may in the future produce a version that uses the database and updates it on every post so that the number is a quick query. Though don't wait up for this cause it may take some time to make since i am very busy on my project.

[Xenon]

i felt a bit bored an worked a bit on your hack.

this version here works with a daily cache, and should fit everyones needs, even on larger boards

[Sho]

Yeah, Xenon's version might be the better one for forum home. My completely dynamical one was designed for the member's profile pages, where load times are (imo) not much of an issue.

[joeboo]

you can easily do this without hacking, using templates, like the phpinlcude template. But nevertheless, its okay

[filburt1]

I released this at vBT a long time ago. If not this exact one, then one that counted the number of "words" posted at your forum.

[zajako]

i posted one that count the amout of times your name is said as well.

Anywho, thanks xenon for optimizeing it.