Data loading - Printable Version

Data loading - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Data loading (/showthread.php?tid=278720)

Data loading - juraska - 23.08.2011

Hi all, have little problem

syntex error

pawn Code:

[19:33:30] CMySQLHandler::Query(Beta_Tester|865425043|89.117.247.68|nera|0|0|0|75|0|132.336|-67.0737|1.57813|0|100|0|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0|28|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Beta_Tester|865425043|89.117.247.68|nera|0|0|0|75|0|132.336|-67.0737|1.57813|0|1' at line 1)

Here is mysql ssanf lines

pawn Code:

sscanf(Query, "e<p<|>s[24]s[40]s[20]s[50]dddddfffdffddddddddddddddddddddddddddddddddddd>", PD[iPlayer]);

enum

pawn Code:

enum _PSTATS
{
    pLayaName[24],
    pPassword[40],
    pIP[20],
    pEmail[50],
    pKills,
    pDeaths,
    pScore,
    pMoney,
    pAdminLevel,
    Float:pLastX,
    Float:pLastY,
    Float:pLastZ,
    pInt,
    Float:pHealth,
    Float:pArmour,
    pFightStyle,
    pSkin,
    pVipLevel,
    pWantedLevel,
    pMuted,
    pLicenzijaA,
    pLicenzijaB,
    pLicenzijaC,
    pLicenzijaD,
    pAge,
    pSex,
    pWeapons[12],
    pAmmor[12]
}

I do like this

new pWeapons[12]

I add 12 'd' to sscanf line row so what i do wrong ?