[dovyansas]

[QUOTE=dovyansas;2497028]Hi all, I have problem with MySQL save. In debug it looks ok, but didn't save anything

Script:

Код:

stock SaveData(playerid)
{
	new Query[700];
	new met, men, die, hou, mina;
	getdate(met, men, die);
	gettime(hou, mina);
	GetPlayerPos(playerid, Spoz[playerid][0], Spoz[playerid][1], Spoz[playerid][2]);
	GetPlayerFacingAngle(playerid, Spoz[playerid][3]);
	format(Query,sizeof(Query), "UPDATE players SET Money='%d', XP='%d',AdminLVL='%d',Vip='%s',LastIP='%s',LastTimeOn='%d-%d-%d %d:%d',X='%f',Y='%f',Z='%f',A='%f' WHERE Name = '%s'",
	GetPlayerMoney(playerid),
	GetPlayerScore(playerid),
	zi[playerid][AdminLVL],
	zi[playerid][Vip],
	ipas(playerid),
	met,
	men,
	die,
	hou,
	mina,
	Spoz[playerid][0],
	Spoz[playerid][1],
	Spoz[playerid][2],
	Spoz[playerid][3],
	name(playerid));
	mysql_query(Query);
}

public OnPlayerDisconnect(playerid, reason)
{
	SaveData(playerid);
	return 1;
}

Debug:

Код:

[14:03:44]  

[14:03:44] ---------------------------

[14:03:44] MySQL Debugging activated (04/24/13)

[14:03:44] ---------------------------

[14:03:44]  

[14:03:44] >> mysql_connect( )

[14:03:44] CMySQLHandler::Connect() - Connection was successful.

[14:03:44] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[14:04:05] >> mysql_query( Connection handle: 1 )

[14:04:05] CMySQLHandler::Query(SELECT `LOCKED`,`LastIp`,`When` FROM `locked` WHERE name = 'Kiki_Niko') - Successfully executed.

[14:04:05] >> mysql_store_result( Connection handle: 1 )

[14:04:05] CMySQLHandler::StoreResult() - Result was stored.

[14:04:05] >> mysql_fetch_row_format( Connection handle: 1 )

[14:04:05] >> mysql_free_result( Connection handle: 1 )

[14:04:05] CMySQLHandler::FreeResult() - Result was successfully free'd.

[14:04:08] >> mysql_query( Connection handle: 1 )

[14:04:08] CMySQLHandler::Query(SELECT `pass` FROM `players` WHERE `name`='Kiki_Niko') - Successfully executed.

[14:04:08] >> mysql_store_result( Connection handle: 1 )

[14:04:08] CMySQLHandler::StoreResult() - Result was stored.

[14:04:08] >> mysql_reconnect( Connection handle: 1 )

[14:04:08] CMySQLHandler::Disconnect() - Connection was closed.

[14:04:08] CMySQLHandler::Connect() - Connection was successful.

[14:04:08] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[14:04:08] >> mysql_num_rows( Connection handle: 1 )

[14:04:08] CMySQLHandler::NumRows() - Returned 0 row(s)

[14:04:08] >> mysql_free_result( Connection handle: 1 )

[14:04:08] CMySQLHandler::FreeResult() - Result was successfully free'd.

[14:07:07] >> mysql_query( Connection handle: 1 )

[14:07:07] CMySQLHandler::Query(UPDATE zaidejai SET Pinigai='2000', Taskai='0',AdminLVL='0',Vip='',LastIP='255.255.255.255',LastTimeOn='2013-4-24 14:7',X='1363.140380',Y='-1637.862670',Z='13.382812',A='43.916042' WHERE name= 'Kiki_Niko') - Successfully executed.

i translate it.

srry, i dont know what you mean