Quote:
Originally Posted by Stanford
Alright, under OnPlayerDisconnect:
pawn Код:
new query[128];
PlayerSkin[playerid] = GetPlayerSkin(playerid);
mysql_format(sqlLine, query, sizeof(query), "UPDATE `players` SET `skinid`= '%d' WHERE `userID` = '%d'", PlayerSkin[playerid], UserID[playerid]);
mysql_tquery(sqlLine, query, "", "");
You can depend also on the playername instead of the userID in your database.
You can also use normal formatting (format) instead of mysql_format as you are not going to escape strings while saving the skin id.
I hope I helped any feedback is appreciated! |
Issue is that im using buds to make my query's so when using pInfo[playerid][Skin] = something it directs it to the query itself as this is the query made already BUD::VerifyColumn("Skin", BUD::TYPE_NUMBER);
