[mtha]

Originally Posted by TTG

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 :-

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 !?

Please download and replace the award.php in your admincp folder with the award.php file attached in the first post.

It was 4am at that time, I forgot to take out those fields