[dominick32]

This hack is excellent. Although I cant seem to get it configured, and I cant get the actual referrals.php page to show up. This is the error I get in the AdminCP Statistics configuration:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE referrals SET resultnumber='20', limit1='', limit2='', limit3='', limit4='1', limit5='0', limit6='1'
mysql error: Unknown column 'resultnumber' in 'field list'

mysql error number: 1054

Date: Monday 16th of October 2006 08:42:24 AM
Script: http://www.svtsnake.com/forum/admincp/referralstats.php
Referer: http://www.svtsnake.com/forum/admincp/referralstats.php

And I get this error in the referral.php:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid, user.totalreferrals FROM user AS users INNER JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE users.referrerid > 0
                   
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT 0, 
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 '' at line 6

mysql error number: 1064

Date: Monday 16th of October 2006 08:43:55 AM
Script: http://www.svtsnake.com/forum/referrals.php

Any help would be greatly appreciated as I really want this to get added to my forum. My website is www.svtsnake.com/forum/

Thanks in advance.