[Gh0s7]

Код:

[19:30:29] [DEBUG] ProcessQueryThread(OnQueryFinish) - Executing query UPDATE `accounts` SET `Password`= 40CDB3721817C064758C3A8F4C4F5D1C304716C10A8A78243ACBDDD178FF820BC7461DCC7A59C06021AAA68FF693B9EF9D7996AD552E85C607E63A35FAE27E99, `Level`= 0, `VIP`= 0,`Kills`= 0, `Warns`= 0, `Jails`= 0, `Bans`= 0, `Kicks`= 0, `Mutes`= 0, `Reacs`= 0,`Deaths= 0`, `Hours`= 0, `Mins`= 5 , `Secs`= 29, `Registered`= 1,`Date`= 1/6/2013 WHERE `Name` = 'Gh0s7.'...
[19:30:29] [ERROR] ProcessQueryThread(OnQueryFinish) - 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 ' `Hours`= 0, `Mins`= 5 , `Secs`= 29, `Registered`= 1,`Date`= 1/6/2013 WHERE `Nam' at line 1 (error ID: 1064)
[19:30:29] [DEBUG] ProcessQueryThread(OnQueryFinish) - Error will be triggered to OnQueryError().
[19:30:29] [DEBUG] OnQueryError() - Callback has been called.

Код:

	format(query, sizeof(query), "UPDATE `accounts` SET `Password`= %s, `Level`= %d, `VIP`= %d,`Kills`= %d, `Warns`= %d, `Jails`= %d",buf,AccInfo[playerid][Level],AccInfo[playerid][pVip],AccInfo[playerid][Kills],AccInfo[playerid][Warns],AccInfo[playerid][Jails]);
	format(query, sizeof(query), "%s, `Bans`= %d, `Kicks`= %d, `Mutes`= %d, `Reacs`= %d,`Deaths= %d`",query,AccInfo[playerid][Bans],AccInfo[playerid][Kicks],AccInfo[playerid][Mutes],AccInfo[playerid][Reacs],AccInfo[playerid][Deaths]);
	format(query, sizeof(query), "%s, `Hours`= %d, `Mins`= %d , `Secs`= %d, `Registered`= 1,`Date`= %s WHERE `Name` = '%s'",query,h,m,s,Date,MysqlGetName(playerid));
 	mysql_query(query, THREAD_SAVE_PLAYER, playerid, CGRData);

[Vince]

Код:

WHERE `Nam' at line 1

You can see that it cuts off right there. Deduction: your string is not big enough.

[Gh0s7]

I`ve tried to increase it but the error still remains.

new query[8192];

[Knappen]

Split it up into several queries...

pawn Код:

format(query, sizeof(query), "Something", somevar, somevar2);
mysql_query(query);
format(query, sizeof(query), "Something2", somevar3, somestring);
mysql_query(query);

Also remember to close off strings with ' ' like this :

pawn Код:

format(query, sizeof(query), "UPDATE `players` SET `Name`='%s', `Level`=%d, `PosX`=%f", somestrng, somevar, somefloat);

[Kirollos]

you didn't put ' ' between %s of da password.

[Knappen]

kirollos, did you read my post before you posted that?

[Gh0s7]

Still not working , I do not know what to do

Код:

	format(query2, sizeof(query2), "UPDATE `accounts` SET `Level`= %d , `VIP`= %d ,`Kills`= %d , `Warns`= %d , `Jails`= %d WHERE `Name` = '%s'",AccInfo[playerid][Level],AccInfo[playerid][pVip],AccInfo[playerid][Kills],AccInfo[playerid][Warns],AccInfo[playerid][Jails],MysqlGetName(playerid)); 
	mysql_query(query2, THREAD_SAVE_PLAYER, playerid, CGRData); // works

	
	format(query3, sizeof(query3), "UPDATE `accounts` SET `Bans`= %d , `Kicks`= %d , `Mutes`= %d , `Reacs`= %d ,`Deaths= %d` WHERE `Name` = '%s'",AccInfo[playerid][Bans],AccInfo[playerid][Kicks],AccInfo[playerid][Mutes],AccInfo[playerid][Reacs],AccInfo[playerid][Deaths],MysqlGetName(playerid)); // not working
	mysql_query(query3, THREAD_SAVE_PLAYER, playerid, CGRData); // not working
	
	format(query4, sizeof(query4), "UPDATE `accounts` SET `Hours`= %d , `Mins`= %d , `Secs`= %d , `Registered`= 1 , `Date`= '%s' WHERE `Name` = '%s'",h,m,s,Date,MysqlGetName(playerid));
 	mysql_query(query4, THREAD_SAVE_PLAYER, playerid, CGRData); // not working

Код:

[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Executing query UPDATE `accounts` SET `Level`= 0 , `VIP`= 0 ,`Kills`= 0 , `Warns`= 0 , `Jails`= 0 WHERE `Name` = 'Gh0s7.'...
[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Query was successful.
[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[17:06:31] [DEBUG] OnQueryFinish(siii) - Callback is being called...
[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Executing query UPDATE `accounts` SET `Bans`= 0 , `Kicks`= 0 , `Mutes`= 0 , `Reacs`= 0 ,`Deaths= 0` WHERE `Name` = 'Gh0s7.'...
[17:06:31] [ERROR] ProcessQueryThread(OnQueryFinish) - 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 'WHERE `Name` = 'Gh0s7.'' at line 1 (error ID: 1064)
[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Error will be triggered to OnQueryError().
[17:06:31] [DEBUG] OnQueryError() - Callback has been called.
[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Executing query UPDATE `Hours`= 0 , `Mins`= 8 , `Secs`= 53 , `Registered`= 1 , `Date`= '15/6/2013' WHERE `Name` = 'Gh0s7.'...
[17:06:31] [ERROR] ProcessQueryThread(OnQueryFinish) - 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 '0 , `Mins`= 8 , `Secs`= 53 , `Registered`= 1 , `Date`= '15/6/2013' WHERE `Name` ' at line 1 (error ID: 1064)
[17:06:31] [DEBUG] ProcessQueryThread(OnQueryFinish) - Error will be triggered to OnQueryError().
[17:06:31] [DEBUG] OnQueryError() - Callback has been called.