[dovyansas]

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 zaidejai SET Pinigai='%d', Taskai='%d',AdminLVL='%d',Vip='%s',LastIP='%s',LastTimeOn='%d-%d-%d %d:%d',X='%f',Y='%f',Z='%f',A='%f' WHERE Vardas = '%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],
	vardas(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`,`Kada` FROM `Uzrakintos` WHERE Vardas = '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 `Slaptazodis` FROM `zaidejai` WHERE `Vardas`='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 Vardas = 'Kiki_Niko') - Successfully executed.

Someone know Wtf!? it is?

[Yashas]

Could you please convert the language to English, I don't get few things.

The best way to debug is:
Do these steps if you have phpMyAdmin MySQL:
1)Open you phpMyAdmin Page
2)Go to your database and select the table and wait for it to open.
3)There is a link "inline" ,Click that
4)Copy your query code and paste it there and press GO.

It will 100% tell your problem in your UPDATE. 100% Sure.

Possible Reasons:
1)Syntax Error - Your VPI seems to be NULL - You have to define NULL value in your database to allow NULL Values(Or simply asign 0 instead of NULL and in your script #define NULL 0)
2)The Username(WHERE Username ='...') doesn't exist
3)One of the column of given in the query doesn't exist(One error is enough ,it will stop the whole query)

[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

[Yashas]

Do you have TeamViewer or Skype??I will help you out.