[LilBob]

Hey guys !

I've made a saving mysql system in order to save player stats.

All is working (saving cash, bank, number, etc...) juste some aren't saved !

Here is the code for example:

pawn Код:

format(query,sizeof(query),"UPDATE players_stats SET Roop=%d,Baillon=%d,Jerrican=%d,Confiserie=%d,Adrenaline=%d,Cigarettes=%d,Feuilles=%d,Tabac=%d,Connected=%d,Talkie=%d,CarKeyOffer=%d,OfferTime=%d,Wanted=%d,Ip='%s',CombatStyle=%d,Journal=%d,Parrain=%d,Email='%s',De=%d WHERE ID=%d",
            PlayerInfo[playerid][pRoop],
            PlayerInfo[playerid][pBaillon],
            PlayerInfo[playerid][pJerrican],
            PlayerInfo[playerid][pConfiserie],
            PlayerInfo[playerid][pAdrenaline],
            PlayerInfo[playerid][pCigarettes],
            PlayerInfo[playerid][pFeuilles],
            PlayerInfo[playerid][pTabac],
            PlayerInfo[playerid][pConnected],
            PlayerInfo[playerid][pTalkie],
            PlayerInfo[playerid][pCarKeyOffer],
            PlayerInfo[playerid][pCarKeyOfferTime],
            PlayerInfo[playerid][pWantedLevel],
            PlayerInfo[playerid][pIP],
            PlayerInfo[playerid][pCombatStyle],
            PlayerInfo[playerid][pJournal],
            PlayerInfo[playerid][pParrain],
            PlayerInfo[playerid][pEmail],
            PlayerInfo[playerid][pDe],
            PlayerInfo[playerid][pCap],
            PlayerInfo[playerid][pCoiffure],
            PlayerInfo[playerid][pSQLID]);

For example, all is saving just not talkie, combatstyle, feuilles tabac, cigarette, baillon roop).

Now, here is a screen of the database (maybe son int mistake ?)

hub.png


Thanks a lot

[LilBob]

Bump...

[BullseyeHawk]

Do you have any errors during it? (Like, while its doing the mysql query)

Try to toggle debug of mysql ( mysql_debug(1); ) in OnGameModeInit

[LilBob]

No there are no errors :/ also syntax is correct..

[LilBob]

bump..

[LilBob]

bump, help please !