SQL SAVing - Printable Version

SQL SAVing - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL SAVing (/showthread.php?tid=579271)

SQL SAVing - STONEGOLD - 25.06.2015

what's wrong with it?

PHP код:



forward OnPlayerSave(playerid);

public OnPlayerSave(playerid)

{

    new query[500];

    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))

    {

        strcat(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,");

        strcat(query, "`Crimes`=%d, `WantedLevel`=%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][pMedical],

        pInfo[playerid][pID], PlayerName(playerid));

        mysql_tquery(MySQLCon, query, "", "");

        print(query);


        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `IsBanned`=%d WHERE `ID`=%d AND user='%e'", pInfo[playerid][pIsBanned], PlayerName(playerid));

        mysql_tquery(MySQLCon, query, "", "");

        IsLoggedIn[playerid] = 0;

        if(pInfo[playerid][pAdmin] >= 1)

        {

            mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `AdminName`=%s WHERE `ID`=%d AND `user`='%e'", pInfo[playerid][pAName]);

            return true;

        }

    }

    return 1;

}

Re: SQL SAVing - STONEGOLD - 25.06.2015

Okay aight after doing this.

PHP код:



5593) : error 001: expected token: "-string end-", but found "-identifier-"
(5593) : error 017: undefined symbol "players"
 (5593): warning 215: expression has no effect
5593) : error 001: expected token: ";", but found ")"
(5593) : fatal error 107: too many error messages on one line

PHP код:



forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        strcat(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',");
        strcat(query, "Crimes ='%d', WantedLevel ='%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][pMedical],
        pInfo[playerid][pID], PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        print(query);

        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `IsBanned`=%d WHERE `ID`=%d AND user='%e'", pInfo[playerid][pIsBanned], PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        IsLoggedIn[playerid] = 0;
        if(pInfo[playerid][pAdmin] >= 1)
        {
            mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `AdminName`=%s WHERE `ID`=%d AND `user`='%e'", pInfo[playerid][pAName]);
            return true;
        }
    }
    return 1;
}

Re: SQL SAVing - Stanford - 25.06.2015

What about this?:

pawn Код:

if(pInfo[playerid][pAdmin] >= 1) 
        { 
            mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `AdminName`=%s WHERE `ID`=%d AND `user`='%e'", pInfo[playerid][pAName]); 
            return true; 
        }

you basically do not send this just format the string!

Re: SQL SAVing - STONEGOLD - 25.06.2015

Nah. The problem is on line 5593

Which is

PHP код:



strcat(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',");

Re: SQL SAVing - STONEGOLD - 25.06.2015

need it urgent pls some1 help

Re: SQL SAVing - STONEGOLD - 26.06.2015

Im still stuck on this. Anyone help me? I would be your thankful.

Re: SQL SAVing - J0sh... - 26.06.2015

Why do you have players in " marks? `players`

Re: SQL SAVing - STONEGOLD - 26.06.2015

Well, I changed into this

PHP код:



///mysql start
forward OnPlayerSave(playerid);
public OnPlayerSave(playerid)
{
    new query[500];
    new tmp[64];
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format( query, sizeof( query ), "UPDATE `players` SET " );
        
        format( tmp, sizeof( tmp ), "`Admin`=%d, ", pInfo[playerid][pAdmin]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Vip`=%d, ", pInfo[playerid][pVip]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Money`=%d, ", GetPlayerCash(playerid));
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Deaths`=%d, ", pInfo[playerid][pDeaths]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Kills`=%d, ", pInfo[playerid][pKills]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`HitsCompleted`=%d, ", pInfo[playerid][pHitsCompleted]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`SkinID`=%d, ", pInfo[playerid][pDeaths]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Robbed`=%d, ", pInfo[playerid][pRobbed]);
        strcat( query, tmp );

        format( tmp, sizeof( tmp ), "`RobbedMoney`=%d, ", pInfo[playerid][pRobbedMoney]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`GotRobbed`=%d, ", pInfo[playerid][pGotRobbed]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`GotRobbedMoney`=%d, ", pInfo[playerid][pGotRobbedMoney]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`StoreRobbed`=%d, ", pInfo[playerid][pStoreRobbed]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`StoreRobbedMoney`=%d, ", pInfo[playerid][pStoreRobbedMoney]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`FoodPurchased`=%d, ", pInfo[playerid][pFoodPurchased]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`FoodPurchasedMoney`=%d, ", pInfo[playerid][pFoodPurchasedMoney]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`WeaponsPurchased`=%d, ", pInfo[playerid][pWeaponsPurchased]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`WeaponsPurchasedMoney`=%d, ", pInfo[playerid][pWeaponsPurchasedMoney]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Healed`=%d, ", pInfo[playerid][pHealed]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Arrest`=%d, ", pInfo[playerid][pArrest]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Busted`=%d, ", pInfo[playerid][pBusted]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Crimes`=%d, ", pInfo[playerid][pCrimes]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`WantedLevel`=%d, ", pInfo[playerid][pWantedLevel]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Drugs`=%d, ", pInfo[playerid][pDrugs]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Medical`=%d, ", pInfo[playerid][pMedical]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "`Drugs`=%d, ", pInfo[playerid][pDrugs]);
        strcat( query, tmp );
        
        format( tmp, sizeof( tmp ), "WHERE `ID`= %d AND `user`= '%e'", pInfo[playerid][pID], PlayerName(playerid));
        strcat( query, tmp );
        mysql_tquery(MySQLCon, query, "", "");
        print(query);

        mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `IsBanned`=%d WHERE `ID`=%d AND user='%e'", pInfo[playerid][pIsBanned], PlayerName(playerid));
        mysql_tquery(MySQLCon, query, "", "");
        IsLoggedIn[playerid] = 0;
        if(pInfo[playerid][pAdmin] >= 1)
        {
            mysql_format(MySQLCon, query, sizeof(query), "UPDATE `players` SET `AdminName`=%s WHERE `ID`=%d AND `user`='%e'", pInfo[playerid][pAName]);
            return true;
        }
    }
    return 1;
}

But this doesn't update my database.

Re: SQL SAVing - STONEGOLD - 26.06.2015

Someone help me? I have been asking for help from yesterday? Rly Nobody wants to help me?

Re: SQL SAVing - Prokill911 - 26.06.2015

Quote:

Originally Posted by STONEGOLD

Nah. The problem is on line 5593

Which is

PHP код:



strcat(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',");

simply put...
You're referencing completely wrong....

INCORRECT CODE

PHP код:



strcat(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',");

CORRECT CODE

PHP код:



strcat(query, "UPDATE `players` SET `Admin` = %d, `Vip` = %d, `Money` = %d

PLEASE NOTE
IF You're REFERENCING A STRING.....

PHP код:



"UPDATE `players` SET `username` = '%s'

SQL Syntax doesn't require nor accept quotations around an integer.. ONLY A string / variable with characters.

So...

%d would be %d when referenced via SQL
%s would be '%s' when referenced via SQL