27.02.2012, 16:20
It doesnt save my pos in database, but why? and how i can fix it?
pawn Код:
enum pInfo
{
pIP,
pMoney,
pScore,
Float:pPos[4]
}
public OnPlayerDisconnect(playerid, reason)
{
//================================================================//
// MySQL part //
//================================================================//
if(Logged[playerid] == 1)
{
SetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]);
new score = GetPlayerScore(playerid);
new money = GetPlayerMoney(playerid);
new query[300], pname[24];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "UPDATE playerdata SET money=%d, score=%d, posx=%f, posy=%f, posz=%f, posa=%f WHERE user='%s'",
money,
score,
PlayerInfo[playerid][pPos][0],
PlayerInfo[playerid][pPos][1],
PlayerInfo[playerid][pPos][2],
PlayerInfo[playerid][pPos][3],
pname);
mysql_query(query);
}
return 1;
}