Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
Reload this Page Letter Statistics in Member Profile v1.0
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
Letter Statistics in Member Profile v1.0 Details »»
Letter Statistics in Member Profile v1.0
Version: 1.00, by Sho Sho is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page
Version: 2.3.x Rating:
Released: 03-15-2003 Last Update: Never Installs: 12
 
No support by the author.

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!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 03-16-2003, 06:11 AM
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Location: Mocsow
Posts: 1,288
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Perfect. Just perfect. Still you could add a link to a demo site.
Reply With Quote
  #3  
Old 03-16-2003, 06:15 AM
Sho Sho is offline
 
Join Date: Nov 2001
Location: Berlin, Germany
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.)
Reply With Quote
  #4  
Old 03-16-2003, 07:34 AM
pattox pattox is offline
 
Join Date: Jan 2003
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I installed it, nice hack.
Reply With Quote
  #5  
Old 03-16-2003, 07:36 AM
Intex Intex is offline
 
Join Date: Apr 2002
Posts: 576
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice hack m8. I'll install this soon.
Reply With Quote
  #6  
Old 03-16-2003, 08:45 AM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Lovely idea. I guess this will be server intensive as it breaks down every word and then processes it into a table?

- miSt
Reply With Quote
  #7  
Old 03-16-2003, 08:54 AM
Sho Sho is offline
 
Join Date: Nov 2001
Location: Berlin, Germany
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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? )
Reply With Quote
  #8  
Old 03-16-2003, 09:04 AM
One-Team's Avatar
One-Team One-Team is offline
 
Join Date: Dec 2002
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice hack Install it irate:
Reply With Quote
  #9  
Old 03-16-2003, 09:21 AM
Koopa Koopa is offline
 
Join Date: Nov 2001
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice hack, I might use this
Reply With Quote
  #10  
Old 03-17-2003, 02:21 AM
dstruct2k's Avatar
dstruct2k dstruct2k is offline
 
Join Date: Dec 2002
Location: Winnipeg
Posts: 318
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Hey, I like!

[high]* dstruct2k clicks install[/high]
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

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
Forum Jump


All times are GMT. The time now is 11:36 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05622 seconds
  • Memory Usage 2,287KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete