Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Letter Statistics in Member Profile v1.0 Details »
Letter Statistics in Member Profile v1.0
Mod Version: 1.00, by Sho (Member) Sho is offline
Developer Last Online: Jun 2007 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: 12
Released: 16 Mar 2003 Last Update: Never Downloads: 2
Not Supported  

This hack will add several new statistics to your member's profile pages:

- The number of letters all his/her posts contain.
- The average number of letters he/she posts per day.
- His/her percentage of all letters in all posts in the database.
- The average number of letters a post by him/her contains.


File Modifications: 1 (member.php)
Template Modifications: 1 (getinfo)


This hack was tested with vBulletin 2.2.7 and 2.3.0 Release Candidate 3. I'm confident it will work with every version of vBulletin in the 2.2.x branch. Probably even with older versions.


Two screenshots of the hack in action are included in the ZIP archive:

screenshot1.gif: Plain vBulletin 2.3.0 RC3.
screenshot2.gif: My own forums, a heavily modified vBulletin 2.2.7 translated into German (hack's in English, though).


Special thanks to Logician for helping with the SQL syntax used in this hack.


Have fun with it!

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
Fake Community Statistics Addon - Update Maxloggedin and Member List rogersnm vBulletin 3.5 Add-ons 40 01 Jul 2007 06:07

Comments
  #2  
Old 16 Mar 2003, 08:11
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
Perfect. Just perfect. Still you could add a link to a demo site.
Reply With Quote
  #3  
Old 16 Mar 2003, 08:15
Sho Sho is offline
 
Join Date: Nov 2001
Thanks.

Live demo site: http://www.forenplanet.de/member.php...nfo&userid=450

It's German, though. Buchstaben = letters. (Hack's in English; screenshot of plain English vB 2.3.0 RC3 included.)

Last edited by Sho; 16 Mar 2003 at 08:24.
Reply With Quote
  #4  
Old 16 Mar 2003, 09:34
pattox pattox is offline
 
Join Date: Feb 2003
I installed it, nice hack.
Reply With Quote
  #5  
Old 16 Mar 2003, 09:36
Intex Intex is offline
 
Join Date: Apr 2002
Nice hack m8. I'll install this soon.
Reply With Quote
  #6  
Old 16 Mar 2003, 10:45
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Lovely idea. I guess this will be server intensive as it breaks down every word and then processes it into a table?

- miSt
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #7  
Old 16 Mar 2003, 10:54
Sho Sho is offline
 
Join Date: Nov 2001
No, not significantly. We have about 120.000 posts in our database, and for a user with 2500 posts it slows down the generation of the profile page by circa 0.2 seconds (according to vBMicrostats in our footer). On a not particularly powerful, shared server.

The MySQL function LENGTH() returns the length of the specified fields contents for all records in the table, SUM() adds those values together and returns the result. So it's a SUM(LENGTH(pagetext)) for the table "post" WHERE userid=X. That's a pretty fast way to do it - and it doesn't require multiple changes to newthread/editpost/newreply and new table fields to do it statically.

I'd advice against using the same technique for the postbit, but for the profile pages its good enough.

(Yes, that means spaces between words get counted as well. Well, the user had to push the space button, after all. Fair enough, eh? )

Last edited by Sho; 16 Mar 2003 at 11:01.
Reply With Quote
  #8  
Old 16 Mar 2003, 11:04
One-Team's Avatar
One-Team One-Team is offline
 
Join Date: Dec 2002
Nice hack Install it irate:
Reply With Quote
  #9  
Old 16 Mar 2003, 11:21
Koopa Koopa is offline
 
Join Date: Nov 2001
Nice hack, I might use this
Reply With Quote
  #10  
Old 17 Mar 2003, 04:21
dstruct2k's Avatar
dstruct2k dstruct2k is offline
 
Join Date: Dec 2002
Real name: Bill
Hey, I like!

/me clicks install
Reply With Quote
  #11  
Old 19 Mar 2003, 14:23
zajako's Avatar
zajako zajako is offline
 
Join Date: Jan 2002
Real name: James Covey
nice hack ill post a hack based of your query for forumhome.
Reply With Quote
  #12  
Old 19 Mar 2003, 15:06
Sho Sho is offline
 
Join Date: Nov 2001
Sure, go ahead. Mentioning me & Logician would be cool, though. And a link to this hack?
Reply With Quote
  #13  
Old 19 Mar 2003, 15:24
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
hmm, your profile page loads quite slow...

So it's a SUM(LENGTH(pagetext)) for the table "post" WHERE userid=X.
yes you are right here, that part should be relativ fast
but for getting the global percentage you need also that query:
So it's a SUM(LENGTH(pagetext)) for the whole table "post"
which will become slower and slower how more posts you have.
ok, getprofile isn't called so often, but also there i don't think that's such a good way.
i'd use a sort of caching the absulote letter ammount and just update it rarely
Reply With Quote
  #14  
Old 19 Mar 2003, 15:28
Sho Sho is offline
 
Join Date: Nov 2001
I'd hate having to do that manually by loading up a script, and I don't have access to the crontab task scheduler, so I prefer doing it dynamically.

Yep, my profile pages load quite slow, mostly because this is just a small part of a shared server and really underpowered. The letter statistics do not account for a major part of the generation time, though. Granted, that's because there are some other modifications in there.

Overall, I think it's the best way to do it in a case similar to mine.

Last edited by Sho; 19 Mar 2003 at 15:31.
Reply With Quote
  #15  
Old 19 Mar 2003, 15:34
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
you can do it 'nearly' dynamically without having acces to a crontab scheduler

but i'll leave it up to you

just as a hint, look at the cached birthdays on forumhome
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 16:24.

Layout Options | Width: Wide Color: