08.02.2014, 16:18
So, it worked like a charm in the way you did it. But since I added some data, it is not saving it in "OnPlayerDisconnect". I even stretched the query to 3000 (which is clearly above what it actually is) and it is still not working. Please help me:
Code:
public OnPlayerDisconnect(playerid, reason) { new query[3000], Float:pos[3]; GetPlayerPos(playerid, pos[0], pos[1], pos[2]); mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f, `Int`=%d, `VW`=%d, `Skin`=%d, `Edad`=%d, `Origen`=%s WHERE `ID`=%d",\ pInfo[playerid][Admin], pInfo[playerid][VIP], pInfo[playerid][Money], pos[0],pos[1],pos[2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid),GetPlayerSkin(playerid),pInfo[playerid][Edad], pInfo[playerid][Origen],pInfo[playerid][ID]); mysql_tquery(mysql, query, "", ""); return 1; }