[help me] Data not save SQL - 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: [help me] Data not save SQL (/showthread.php?tid=567160)

---

[help me] Data not save SQL - nooion345 - 11.03.2015

Data not save SQL.

When I set data in the game but the database is not updated.

---

AW: [help me] Data not save SQL - Kaliber - 11.03.2015

Then Post the query you use?

---

Re: [help me] Data not save SQL - nooion345 - 11.03.2015

PlayerInfo[playerid][pPoly],
PlayerInfo[playerid][pDen],
PlayerInfo[playerid][pTan],
PlayerInfo[playerid][pGammatan],
PlayerInfo[playerid][pTree],


format(string, sizeof(string), "UPDATE players SET `Fishes1`='%s',`Fishes2`='%s',`Fishes3`='%s',`Fish es4`='%s',`Fishes5`='%s',`Fish1`=%d,`Fish2`=%d,`Fi sh3`=%d,`Fish4`=%d,`Fish5`=%d,`Note1s`=%d,`Note2s` =%d,`Note3s`=%d,`Note4s`=%d,`Note5s`=%d,`Note1`='% s',`Note2`='%s',`Note3`='%s',`Note4`='%s',`Note5`= '%s',`JobDelay`=%d,`MaskUse`=%d,`Accent`='%s',`Vot ed2`=%d,`AdmName`='%s',`HeadValue`=%d,`HiddenNum`= %d,`Skate`=%d ,`Metal`=%d ,`Poly`=%d ,`Gammatan`=%d ,`Tree`=%d WHERE `Name`='%s'",

5 Last Data not update

---

Re: [help me] Data not save SQL - nooion345 - 11.03.2015

help

---

AW: [help me] Data not save SQL - Kaliber - 11.03.2015

Can you show us how you declared the string value?

Maybe the array size is too small

---

Re: [help me] Data not save SQL - nooion345 - 11.03.2015

new string[1024];

---

Re: [help me] Data not save SQL - nooion345 - 11.03.2015

Database bug no save cost.

The only new variable.
Create a new field will not save.

---