My Sql Saving (URGENT) Thank you!
#6

I don't want to use new line. Actually, I mean, it should be like this.

PHP код:
forward OnPlayerSave(playerid);
public 
OnPlayerSave(playerid)
{
    new 
query[500];
    
pInfo[playerid][pSkinID] = GetPlayerSkin(playerid);
    if(
IsLoggedIn[playerid] == && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        
mysql_format(MySQLConquerysizeof(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(MySQLConquerysizeof(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(MySQLConquery"""");
        print(
query);
    }

But i know this is wrong format. I want to know how to make double line together like this.

PHP код:
 mysql_format(MySQLConquerysizeof(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(MySQLConquerysizeof(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'"
If i change

PHP код:
new query[500]; 
500 to 1500. So can i add these 2 line mysql_format in one line.?
Reply


Messages In This Thread
My Sql Saving (URGENT) Thank you! - by STONEGOLD - 14.06.2015, 04:36
Re: My Sql Saving (URGENT) Thank you! - by FplayerGR - 14.06.2015, 05:06
Re: My Sql Saving (URGENT) Thank you! - by STONEGOLD - 14.06.2015, 05:14
Re: My Sql Saving (URGENT) Thank you! - by FplayerGR - 14.06.2015, 05:22
Re: My Sql Saving (URGENT) Thank you! - by ]Rafaellos[ - 14.06.2015, 05:26
Re: My Sql Saving (URGENT) Thank you! - by STONEGOLD - 14.06.2015, 05:45
Re: My Sql Saving (URGENT) Thank you! - by FplayerGR - 14.06.2015, 06:05

Forum Jump:


Users browsing this thread: 2 Guest(s)