[Re-release v2.2.0] Combined threads started + percent of total posts, plus more

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.

[afterlab]

Nice job there. Worked and installed easily on my 2.0.3. Hope to see more hacks from ya. Good luck!

[dxb]

well done JJR512

[Kengan]

Nice hack !! love it !

[Lesane]

Thanks for this small but very cool hack, installed the hack in a minute.

[Lesane]

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?

[JJR512]

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.

[Lesane]

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]' ????

[JJR512]

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).

[Brian Cruz]

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.