MYSQL Saving
#1

PHP код:
///mysql start
forward OnPlayerSave(playerid);
public 
OnPlayerSave(playerid)
{
    new 
query[500];
    if(
IsLoggedIn[playerid] == && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        
mysql_format(MySQLConquerysizeof(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, `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'",
        
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],
        
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(MySQLConquery"""");
        print(
query);
    }
    return 
1;

PHP код:
5475) : error 075input line too long (after substitutions
Well, I'm sorry. This is my second/thrid threads about it. I'm still stuck at this and not getting and don't know what to do. I have tried many times but still stuck. So, I would be your thankful if you guyz help me and get me out of this problem. Thanks!
Reply


Messages In This Thread
MYSQL Saving - by STONEGOLD - 29.06.2015, 23:39
Re: MYSQL Saving - by nezo2001 - 29.06.2015, 23:48
Re: MYSQL Saving - by kloning1 - 30.06.2015, 05:38
Re: MYSQL Saving - by Cheesus - 30.06.2015, 08:33
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 09:25
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 10:15
Re: MYSQL Saving - by Suicidal.Banana - 30.06.2015, 10:32
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 10:37
Re: MYSQL Saving - by Suicidal.Banana - 30.06.2015, 11:08
Re: MYSQL Saving - by STONEGOLD - 30.06.2015, 11:11

Forum Jump:


Users browsing this thread: 4 Guest(s)