06.05.2013, 21:14
You probably don't get any errors because you haven't enabled MySQL logging.
Add the following line right above your mysql_connect function:
As regards the query issue, you have errors in the query. Change it like this and try:
If there aren't any other errors I haven't noticed, it should work fine.
You also don't need the string size of 9999 for this. 256 will be just fine.
Add the following line right above your mysql_connect function:
pawn Code:
mysql_log(LOG_ERROR | LOG_WARNING);
pawn Code:
UPDATE `Accounts` SET `adminLevel` = %d, `Money` = %d, `Level` = %d, `LastOn` = %d, `Health` = %f, `Armour` = %f, `Skin` = %d, `Gender` = '%s', `LastIP` = '%s', `Age` = %d WHERE `Username` = '%s'
You also don't need the string size of 9999 for this. 256 will be just fine.