stock SaveStats(playerid)
{
new query[200],ip[16];
GetPlayerIp(playerid,ip,16);
format(query,sizeof(query),"UPDATE `Players` SET `IP`='%s', `Admin`=%d, `VIP`=%d, `Scores`=%d,`Money`=%d,`Skin`=%d WHERE `Username`='%s'",ip, pInfo[playerid][Admin],pInfo[playerid][VIP],GetPlayerScore(playerid),GetPlayerMoney(playerid),GetPlayerSkin(playerid),Getname(playerid));
mysql_query(query);
print(query);
return 1;
}
UPDATE `Players` SET `IP`='255.255.255.255', `Admin`=287, `VIP`=0, `Scores`=0,`Money`=0,`Skin`=287 WHERE `Username`='tester'
stock SaveStats(playerid)
{
new
query[ 522 ],
ip[ 16 ]
;
GetPlayerIp( playerid, ip , 16 );
skinid = GetPlayerSkin( playerid );
format( query ,sizeof( query ),"UPDATE `Players` SET `IP`='%s', `Admin`=%d, `VIP`=%d, `Scores`=%d,`Money`=%d,`Skin`=%d WHERE `Username`='%s'", ip, pInfo[ playerid ][ Admin ], pInfo[ playerid ][ VIP ] , GetPlayerScore( playerid ) , GetPlayerMoney( playerid ) , skinid , Getname( playerid ));
mysql_query( query );
print( query );
return 1;
}
I would CTRL+F through your script for every instance that you use pInfo[playerid][Admin] (I assume this is the incorrect one) and check whether there is any instance where you are accidentally setting the player skin to this variable. I sometimes end up doing this if I copy and paste similar code and forget to change it in every place.
|
format(query,sizeof(query),"INSERT INTO `Players` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Scores`, `Money`,`Skin`) VALUES ('%s', '%s', '%s', 0, 0, 0, 0,0)",Getname(playerid),esctext,ip);
i think its code work but somewhere a ADMIN too !! Mby another update or smth
pawn Код:
|