Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
[Re-release v2.2.0] Combined threads started + percent of total posts, plus more Details »
[Re-release v2.2.0] Combined threads started + percent of total posts, plus more
Mod Version: 1.00, by JJR512 (Member) JJR512 is offline
Developer Last Online: Jun 2006 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 21
Released: 05 Nov 2001 Last Update: Never Downloads: 2
Not Supported  

I have taken the Total Threads Started hack by tubedogg and the User's Percentage of Total Posts hack by apfeifer and combined the instructions into one unified set. I have also combined into it some new code by myself that shows the user's percentage of total threads.

Please note that credit for this should go mostly to tubedogg and apfeifer, as they wrote the base hacks for this re-release. I only combined their instructions and modified code from both hacks to add new functionality to them.

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
User's Percent of Total Posts apfeifer vBulletin 2.x Full Releases 50 28 May 2003 05:48
Percent of thread views on threads created by user Gamingforce vBulletin 2.x Full Releases 11 20 Dec 2002 03:48

Comments
  #2  
Old 05 Nov 2001, 08:24
afterlab's Avatar
afterlab afterlab is offline
 
Join Date: Oct 2001
Real name: Eric
Nice job there. Worked and installed easily on my 2.0.3. Hope to see more hacks from ya. Good luck!
__________________
Owner, Designer, Programmer and Founder of Gamertag Nation
Have an Xbox Live gamertag? Sync your gamertag with our community! Check us out for an interactive community packed with reviews, guides, achievements and tons more.
Reply With Quote
  #3  
Old 05 Nov 2001, 12:24
dxb's Avatar
dxb dxb is offline
 
Join Date: Oct 2001
well done JJR512
Reply With Quote
  #4  
Old 11 Nov 2001, 12:35
Kengan's Avatar
Kengan Kengan is offline
 
Join Date: Nov 2001
Nice hack !! love it !
Reply With Quote
  #5  
Old 14 Nov 2001, 17:19
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Real name: Maurice
Thumbs up

Thanks for this small but very cool hack, installed the hack in a minute.
Reply With Quote
  #6  
Old 16 Nov 2001, 08:42
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Real name: Maurice
One Problem:

Since i installed this hack i receive errors when i try 2 view a user with an ' in his username, like "Tha' Anarchist", i receive this error:

Database error in vBulletin: Invalid SQL: SELECT COUNT(title) AS starts FROM thread WHERE postusername='Tha' Anarchist' AND open!='10'
mysql error: You have an error in your SQL syntax near 'Anarchist' AND open!='10'' at line 1
mysql error number: 1064
Date: Thursday 15th of November 2001 01:45:21 PM
Script: /board/member.php?s=&action=getinfo&userid=117

So when poeple have a ' in their username then i cant view their profile

I changed his username to "Tha Anarchist" and it works now fine but what can i do against this error?
Reply With Quote
  #7  
Old 16 Nov 2001, 09:04
JJR512's Avatar
JJR512 JJR512 is offline
 
Join Date: Oct 2001
Real name: Justin J. Rebbert
I've experienced the same problem, although I didn't know it was related to this hack. Can you confirm that you never had this problem before this hack?

If this hack is the problem, I have no idea how to fix it. As I said in the hack instructions, this is mainly a combination of two separate hacks from two separate members, with a little derivatory add-on by myself.
__________________
-Justin J. "JJR512" Rebbert
www.JJR512.com: Chat about anything!
Reply With Quote
  #8  
Old 16 Nov 2001, 11:51
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Real name: Maurice
Yes, after installing this hack i received alot of emails with the above error.

Can this be the problem:
In your instructions text file you say:

### Open member.php

### After That Add

// Find out how many threads this user has started
$startcount = $DB_site->query_first("SELECT COUNT(title) AS starts FROM thread WHERE postusername='$userinfo[username]' AND open!='10'");
$starts = $startcount[starts];
// end find threads started

Now i c you are using: postusername='$userinfo[username]'
what if i put there:
postusername='$bbuserinfo[userid]' ????
Reply With Quote
  #9  
Old 16 Nov 2001, 15:51
JJR512's Avatar
JJR512 JJR512 is offline
 
Join Date: Oct 2001
Real name: Justin J. Rebbert
If you use postusername='$bbuserinfo[userid]', it won't work, because that would be asking it to find a name (postusername) where it equals a number (userid). Obviously, a name will never equal a number. But maybe if you could figure out how to change the left side of the equation to a number, like maybe postuserid, it would work. I don't know if there is such a thing as postuserid or not, so you'd have to try it and see (remember, I didn't write the original hack).
__________________
-Justin J. "JJR512" Rebbert
www.JJR512.com: Chat about anything!
Reply With Quote
  #10  
Old 18 Nov 2001, 06:46
Brian Cruz's Avatar
Brian Cruz Brian Cruz is offline
 
Join Date: Nov 2001
There's a typo towards the end of the template code additon. It says {firstatltcolor} instead of {firstaltcolor} (extra "t" in "alt"). It caused that row to turn up bright green for me until I figured out the problem.
__________________
Brian Cruz
http://www.toonzone.net/
Reply With Quote
  #11  
Old 18 Nov 2001, 14:07
JJR512's Avatar
JJR512 JJR512 is offline
 
Join Date: Oct 2001
Real name: Justin J. Rebbert
Thank you, I've updated the instruction file.
__________________
-Justin J. "JJR512" Rebbert
www.JJR512.com: Chat about anything!
Reply With Quote
  #12  
Old 18 Nov 2001, 14:49
over over is offline
 
Join Date: Nov 2001
nice hack very easy to install what else could we ask for
Reply With Quote
  #13  
Old 18 Nov 2001, 21:43
Brian Cruz's Avatar
Brian Cruz Brian Cruz is offline
 
Join Date: Nov 2001
I had a problem when I installed this hack. Whenever I tried to look at the profile of a member with an apostrophe in thier name, I would get an e-mail similar to this:

vBulletin (forum) Database error!

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT COUNT(title) AS starts FROM thread WHERE postusername='Batman's bride' AND open!='10'
mysql error: You have an error in your SQL syntax near 's bride' AND open!='10'' at line 1

mysql error number: 1064

Date: Sunday 18th of November 2001 11:43:33 AM
Script: http://forums.toonzone.net/member.ph...nfo&userid=669
Referer:
In this case I tried to view the profile of a member named Batman's bride. I had to take the hack out for now. Can this be fixed?
__________________
Brian Cruz
http://www.toonzone.net/
Reply With Quote
  #14  
Old 19 Nov 2001, 04:43
SgtSling SgtSling is offline
 
Join Date: Nov 2001
i am having the same problem with users with ' in ther name
Reply With Quote
  #15  
Old 19 Nov 2001, 07:38
JJR512's Avatar
JJR512 JJR512 is offline
 
Join Date: Oct 2001
Real name: Justin J. Rebbert
As I said earlier, you'd have to ask the person that wrote that part of the hack. I believe that part of the code is from the hack by Tubedogg that counts how many threads a person has started. I would suggest finding that thread and asking in there.
__________________
-Justin J. "JJR512" Rebbert
www.JJR512.com: Chat about anything!
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 00:23.

Layout Options | Width: Wide Color: