Mysql Saving Data
#3

You probably don't get any errors because you haven't enabled MySQL logging.

Add the following line right above your mysql_connect function:
pawn Code:
mysql_log(LOG_ERROR | LOG_WARNING);
As regards the query issue, you have errors in the query. Change it like this and try:

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'
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.
Reply


Messages In This Thread
Mysql Saving Data - by Stefand - 06.05.2013, 19:21
Re: Mysql Saving Data - by Vince - 06.05.2013, 20:59
Re: Mysql Saving Data - by Pooh7 - 06.05.2013, 21:14
Re: Mysql Saving Data - by Stefand - 07.05.2013, 07:01
Re: Mysql Saving Data - by Stefand - 07.05.2013, 07:13
Re: Mysql Saving Data - by Stefand - 07.05.2013, 07:26
Re: Mysql Saving Data - by PaulDinam - 07.05.2013, 10:22
Re: Mysql Saving Data - by Stefand - 07.05.2013, 10:42

Forum Jump:


Users browsing this thread: 1 Guest(s)