Very useful hack
All went well with the install .. added new awards to test the hack and when award was issued received this database error :-
Code:
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT user.username,userfield.field10,userfield.field11,userfield.field12,userfield.field13,userfield.field14
FROM user, userfield
WHERE (user.userid=1) and (userfield.userid=1)
mysql error: Unknown column 'userfield.field10' in 'field list'
mysql error number: 1054
Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235
I ran the sql updates included in the install file and tried several different user ID's !?