[FplayerGR]

this?

Код:

forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[1000];
    pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `Vip`=%d, `Money`=%d, `BankMoney`=%d, `Score`=%d, `Deaths`=%d, `Kills`=%d, `SkinID`=%d, `WantedLevel`=%d, `Bounty`=%d, `BountyHour`=%d, `BountyMinute`=%d, `BountyPlacedOn`=%d, `BountyPlacedBy`=%d, \
        `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d \
		 WHERE `ID`=%d AND `user`='%e'", \
        pInfo[playerid][pAdmin], \
        pInfo[playerid][pVip], \
        GetPlayerMoney(playerid), \
        pInfo[playerid][pBankMoney], \
        GetPlayerScore(playerid), \
        pInfo[playerid][pDeaths], \
        pInfo[playerid][pKills], \
        GetPlayerSkin(playerid), \
        pInfo[playerid][pWantedLevel], \
        pInfo[playerid][pBounty], \
        pInfo[playerid][pBountyHour], \
        pInfo[playerid][pBountyMinute], \
        pInfo[playerid][pBountyPlacedOn], \
        pInfo[playerid][pBountyPlacedBy], \
        pInfo[playerid][pRobbed], \
        pInfo[playerid][pRobbedMoney], \
        pInfo[playerid][pGotRobbed], \
        pInfo[playerid][pGotRobbedMoney], \
        pInfo[playerid][pStoreRobbed], \
        pInfo[playerid][pStoreRobbedMoney], \
        pInfo[playerid][pFoodPurchased], \
        pInfo[playerid][pFoodPurchasedMoney], \
        pInfo[playerid][pWeaponsPurchased], \
        pInfo[playerid][pWeaponsPurchasedMoney], \
        pInfo[playerid][pID], \
        PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);
    }
}

'So can i add these 2 line mysql_format in one line.?'

no the only result that will churn is enforceable only

Код:

mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `Robbed`=%d, `RobbedMoney`=%d, `GotRobbed`=%d, `GotRobbedMoney`=%d, `StoreRobbed`=%d, `StoreRobbedMoney`=%d, `FoodPurchased`=%d, `FoodPurchasedMoney`=%d, `WeaponsPurchased`=%d, `WeaponsPurchasedMoney`=%d WHERE `ID`=%d AND `user`='%e'",

To run two formats must send one after the other.

end if you have string counter set new query[to your count]; For best performance.