Mysql saving problem
#5

I fixed,problem was in WHERE ID = `%d`
Quote:

stock SavePlayer(playerid)
{
new query[200],Float: pos[4]; //Creates the variables
GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
GetPlayerFacingAngle(playerid, pos[3]);
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `Money` = %d, `Admin` = %d, `GM` = %d, `AdminKod` = %d, `GMKod` = %d, `VIP` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f WHERE `ID` = %d",
PlayerInfo[playerid][NovacDzep], PlayerInfo[playerid][Admin], PlayerInfo[playerid][GM], PlayerInfo[playerid][AdminKod], PlayerInfo[playerid][GMKod], PlayerInfo[playerid][Vip],pos[0], pos[1], pos[2], pos[3], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
return 1;
}

Reply


Messages In This Thread
Mysql saving problem - by Vaki - 20.11.2016, 19:18
Re: Mysql saving problem - by Dayrion - 20.11.2016, 21:20
Re: Mysql saving problem - by Pearson - 21.11.2016, 00:55
Re: Mysql saving problem - by Vaki - 21.11.2016, 12:43
Re: Mysql saving problem - by Vaki - 21.11.2016, 15:07

Forum Jump:


Users browsing this thread: 1 Guest(s)