[kloning1]

[U] maybe will be help you

PHP код:

///mysql start
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query,sizeof(query), "UPDATE `players` SET `Admin`=%d, `Vip`=%d, `Money`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `HitsCompleted`=%d, `SkinID`=%d, `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d,`StoreRobbed`=%d, `StoreRobbedMoney`=%d,",
        pInfo[playerid][pAdmin],pInfo[playerid][pVip],GetPlayerMoney(playerid),GetPlayerScore(playerid),pInfo[playerid][pDeaths],pInfo[playerid][pKills],pInfo[playerid][pHitsCompleted],GetPlayerSkin(playerid),pInfo[playerid][pRobbed],pInfo[playerid][pRobbedMoney],pInfo[playerid][pGotRobbed],pInfo[playerid][pGotRobbedMoney],pInfo[playerid][pStoreRobbed],pInfo[playerid][pStoreRobbedMoney]);
        
        format(query,sizeof(query), "%s `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d,`Healed`=%d, `Arrest`=%d, `Busted`=%d, `Crimes`=%d, `WantedLevel`=%d, `Drugs`=%d, `Medical`=%d WHERE `ID`=%d AND `user`='%e'",
        query,pInfo[playerid][pFoodPurchased],pInfo[playerid][pFoodPurchasedMoney],pInfo[playerid][pWeaponsPurchased],pInfo[playerid][pWeaponsPurchasedMoney],pInfo[playerid][pHealed],pInfo[playerid][pArrest],pInfo[playerid][pBusted],pInfo[playerid][pCrimes],pInfo[playerid][pWantedLevel],pInfo[playerid][pDrugs],pInfo[playerid][pMedical],pInfo[playerid][pID],PlayerName(playerid));
        mysql_tquery(MySQLCon, query);
        print(query);
    }
    return 1;
} 


[php]