14.06.2015, 05:45
I don't want to use new line. Actually, I mean, it should be like this.
But i know this is wrong format. I want to know how to make double line together like this.
If i change
500 to 1500. So can i add these 2 line mysql_format in one line.?
PHP код:
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
new query[500];
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 WHERE `ID`=%d AND `user`='%e'",
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'",
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);
}
}
PHP код:
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 WHERE `ID`=%d AND `user`='%e'",
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'",
PHP код:
new query[500];