Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Threads Started by User in Postbit & Profile Details »
Threads Started by User in Postbit & Profile
Mod Version: 1.0.1, by Mudvayne (Member) Mudvayne is offline
Developer Last Online: Jul 2008 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.7 Rating: (7 votes - 4.57 average) Installs: 86
Released: 10 Jul 2007 Last Update: 10 Jul 2007 Downloads: 807
Not Supported DB Changes Uses Plugins Template Edits  

First of all this is a fixed version of Threads Started by User in Postbit and Profile for 3.5.4 by Boofo. I would like to thanks to Boofo for giving me the permission of releasing this.
Originally Posted by Boofo
Go for it, if it is totally tested and working
As this product is the original work of Boofo. So I’m going to use his description as well. All I did is fixed one error related to DB query & remove the MySQL version check as vBulletin 3.6.x already requires MySQL 4.3.3.

Description:
This product counts the threads started by a user and displays it in the postbit and the profile. It will also display the threads per day in the profile. The thread count is automatically updated hourly via cron job. New threads are added to the count in real time. No extra queries are run in the postbit or profile when getting the thread count, only when the cron job runs. This product has been tested on a live board with over 15,000 users and 40,000 threads and ran unnoticeably in the background in 0.3 seconds during the cron job update. This product only counts valid threads (not moderated or soft-deleted threads).

Live Demo:
Golpo Community Forum

Install Instruction:
  • Import the product-thread_count_7272
  • Edit the "postbit" & "MEMBERINFO" Template.
Update Instruction:
  • Import the product-thread_count_7272. Don't forget to allow overwrite!
Screenshots & template edit instructions are included in zip file.

Download Now

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

Screenshots

Click image for larger version

Name:	postbit.jpg
Views:	1458
Size:	18.3 KB
ID:	66776   Click image for larger version

Name:	profile.jpg
Views:	1796
Size:	21.0 KB
ID:	66777  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Miscellaneous Hacks Threads Started by User in Postbit and Profile Boofo Modification Graveyard 67 04 Jul 2008 15:50
Miscellaneous Hacks Threads Started by User in Postbit and Profile Boofo Modification Graveyard 104 07 May 2008 13:40
vB3 Threads Started in Postbit v1.3 Boofo vBulletin 3.0 Full Releases 39 29 Oct 2005 13:06

  #16  
Old 19 Jul 2007, 10:17
sybakaos sybakaos is offline
 
Join Date: Mar 2006
This hack upon uninstall removes the user.threads field from the user table, bug?
Reply With Quote
  #17  
Old 21 Jul 2007, 03:58
Mudvayne's Avatar
Mudvayne Mudvayne is offline
 
Join Date: Dec 2005
Real name: Mudvayne
Originally Posted by sybakaos View Post
This hack upon uninstall removes the user.threads field from the user table, bug?
Nop.
Reply With Quote
  #18  
Old 22 Jul 2007, 01:59
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by sybakaos View Post
This hack upon uninstall removes the user.threads field from the user table, bug?
That is not a bug as this hack is what adds that field.
Reply With Quote
  #19  
Old 22 Jul 2007, 02:03
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by GearTripper View Post
why not inject the remaining template edits? also, why not hotlink the count totals to the actual threads/posts? i updated the previous version product to do all that and here's my postbit as an example...
I would be interested in seeing your edits with the prior version as I am still running 3.5.4.
Reply With Quote
  #20  
Old 22 Jul 2007, 09:55
sybakaos sybakaos is offline
 
Join Date: Mar 2006
Originally Posted by Boofo View Post
That is not a bug as this hack is what adds that field.
Oh, I understand it now. I used a threads counter in vb3.0.x before my vb367 upgrade which added that same field.
Reply With Quote
  #21  
Old 22 Jul 2007, 13:40
Chester87 Chester87 is offline
 
Join Date: Apr 2006
Wondering if this hack could be modified so it will only count the threads in a particularly forum.

So it wil count like this

Posts: 2540
Threads in imageforum: 12
Threads in tekstforum: 45

How can i change this a little bit so i can make it do this??
Reply With Quote
  #22  
Old 23 Aug 2007, 19:11
Techno05 Techno05 is offline
 
Join Date: Nov 2005
Yeah I would like to know that also
Reply With Quote
  #23  
Old 06 Sep 2007, 05:39
momo2 momo2 is offline
 
Join Date: Feb 2007
Installed, how can I get have it line up in one single line, so I can save space ??

Thread 2000 Posts 3000
instead of
Thread 2000
Posts 2000
Reply With Quote
  #24  
Old 06 Sep 2007, 06:24
momo2 momo2 is offline
 
Join Date: Feb 2007
never mind i added ur alternative, and it's all fixed, this is the best mod i have seen i have a very busy forum and, i can simply click on anyone and see all their posts or threads..

Thanks..
Reply With Quote
  #25  
Old 10 Oct 2007, 15:09
Mystery Man Mystery Man is offline
 
Join Date: Sep 2002
Originally Posted by Andyucs View Post
i get this when the cron runs


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
I'm receiving the exact same error and I've tried re uploading the xml and also made sure it was overwriteable but to no avail. I'm running 3.6.8 anybody else having this issue or better yet a way to fix it?
Reply With Quote
  #26  
Old 10 Oct 2007, 15:44
Mudvayne's Avatar
Mudvayne Mudvayne is offline
 
Join Date: Dec 2005
Real name: Mudvayne
Try uninstall then reinstall the hack.
Reply With Quote
  #27  
Old 10 Oct 2007, 16:36
Mystery Man Mystery Man is offline
 
Join Date: Sep 2002
Originally Posted by Mudvayne View Post
Try uninstall then reinstall the hack.
Already did twice, but nothing seems to work, im quite sure ive done everything correctly. any chance this is not compatible with 3.6.8?
Reply With Quote
  #28  
Old 14 Oct 2007, 05:24
Mudvayne's Avatar
Mudvayne Mudvayne is offline
 
Join Date: Dec 2005
Real name: Mudvayne
I'm not using 3.6.8 yet. I will test & confirm you ASAP.
Reply With Quote
  #29  
Old 14 Oct 2007, 12:39
DiverTree's Avatar
DiverTree DiverTree is offline
 
Join Date: Jun 2006
Real name: Diver
Originally Posted by Mudvayne View Post
I'm not using 3.6.8 yet. I will test & confirm you ASAP.
seems to work fine for me. ive got it installed on a 3.6.8, as per instructions.
Reply With Quote
  #30  
Old 16 Oct 2007, 21:08
AWJunkies AWJunkies is offline
 
Join Date: Jan 2005
Real name: Adam
It shows 0 threads for me not sure what is up. DO I need to wait for it to do its cron job?

forced the corn and this is what happens:

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE allwheeljunkies_user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM allwheeljunkies_thread AS thread
LEFT JOIN allwheeljunkies_forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(threadid)
FROM allwheeljunkies_thread AS threa
Error Number : 1064
Date : Tuesday, October 16th 2007 @ 05:12:46 PM
Script : http://allwheeljunkies.com/admincp/c...ncron&cronid=7
Referrer : http://allwheeljunkies.com/admincp/c....php?do=modify
IP Address : 66.75.231.222
Username : AWJunkies
Classname : vb_database

Last edited by AWJunkies; 16 Oct 2007 at 21:13.
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 19:14.

Layout Options | Width: Wide Color: