Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Letters statistics On your forum home Details »
Letters statistics On your forum home
Mod Version: 1.00, by zajako (Member) zajako is offline
Developer Last Online: Aug 2013 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.3.x Rating: (0 vote - 0 average) Installs: 5
Released: 19 Mar 2003 Last Update: Never Downloads: 2
Not Supported  

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!

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Statistics Modifications vbTrends - An Enhanced Statistics Box on Forum Home hambil Modification Graveyard 229 29 Jun 2007 02:33
Forum Home Enhancements vbTrends 1.1.2 - An Enhanced Statistics Box on Forum Home hambil Modification Graveyard 130 18 May 2007 23:38
Thread Statistics On Forum Home chad vBulletin 2.x Full Releases 7 03 Jan 2004 16:52

Comments
  #2  
Old 19 Mar 2003, 14:01
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
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
Reply With Quote
  #3  
Old 19 Mar 2003, 14:20
zajako's Avatar
zajako zajako is offline
 
Join Date: Jan 2002
Real name: James Covey
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.
Reply With Quote
  #4  
Old 19 Mar 2003, 14:28
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
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.
Reply With Quote
  #5  
Old 19 Mar 2003, 14:48
zajako's Avatar
zajako zajako is offline
 
Join Date: Jan 2002
Real name: James Covey
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.
Reply With Quote
  #6  
Old 19 Mar 2003, 15:42
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
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
Attached Files
File Type: txt letters-forumhome.txt (5.1 KB, 35 views)
Reply With Quote
  #7  
Old 19 Mar 2003, 15:47
Sho Sho is offline
 
Join Date: Nov 2001
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.
Reply With Quote
  #8  
Old 19 Mar 2003, 22:39
joeboo's Avatar
joeboo joeboo is offline
 
Join Date: Jun 2002
you can easily do this without hacking, using templates, like the phpinlcude template. But nevertheless, its okay
Reply With Quote
  #9  
Old 19 Mar 2003, 22:41
filburt1 filburt1 is offline
 
Join Date: Feb 2002
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.
Reply With Quote
  #10  
Old 20 Mar 2003, 15:54
zajako's Avatar
zajako zajako is offline
 
Join Date: Jan 2002
Real name: James Covey
i posted one that count the amout of times your name is said as well.

Anywho, thanks xenon for optimizeing it.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:06.

Layout Options | Width: Wide Color: