MYSQL help
#1

Base: (compiling-no erros)
pawn Код:
stock MySQL_SAVE(playerid)
{
    new query[128];
    new Float:x, Float:y, Float:z;
    GetPlayerPos(playerid, x, y, z);
    mysql_format(g_Write, query, sizeof(query), "UPDATE accounts SET PosX = %f, PosY = %f, PosZ = %f WHERE UserID = %d", x, y, z, pInfo[playerid][UserID]);
    mysql_pquery(g_Write, query);
    return 1;
}
Right above code compiling without errors,
But when I put my replaces the line here under \/

pawn Код:
mysql_format(g_Write, query, sizeof(query), "UPDATE accounts SET Username = %s, Senha = %s, IP = %s, scorelevel = %d, maconha = %d, sementes = %d, BPsize = %d, wanted = %d, moneybag = %d, COPskills = %d, CRIMINALskills = %d, PARAMEDICskills = %d, admin = %d, money = %d, bank = %d, kills = %d, deaths = %d, DP = %d, VIP = %d, fmembro = %d, fcargo = %d, preso = %d, presotime = %d, startVIPdia = %d, startVIPmes = %d, startVIPano = %d, carid = %d, carpos0 = %f, carpos1 = %f, carpos2 = %f, carpos3 = %f, spawnpoint = %d, housekey = %d, idiom = %d, tutorial = %d, banned = %d, leftBANdia = %d, leftBANmes = %d, leftBANano = %d WHERE UserID = %d", PlayerName(playerid), Senha[playerid], IP[playerid], scorelevel[playerid], maconha[playerid], sementes[playerid], BPsize[playerid], wanted[playerid], moneybag[playerid], COPskills[playerid], CRIMINALskills[playerid], PARAMEDICskills[playerid], admin[playerid], money[playerid], bank[playerid], kills[playerid], deaths[playerid], DP[playerid], VIP[playerid], fmembro[playerid], fcargo[playerid], preso[playerid], presotime[playerid], startVIPdia[playerid], startVIPmes[playerid], startVIPano[playerid], carid[playerid], carpos[playerid][0], carpos[playerid][1], carpos[playerid][2], carpos[playerid][3], spawnpoint[playerid], housekey[playerid], idiom[playerid], tutorial[playerid], banned[playerid], leftBANdia[playerid], leftBANmes[playerid], leftBANano[playerid] , pInfo[playerid][UserID]);
pawn Код:
error 075: input line too long (after substitutions)
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "UPDATE"
error 017: undefined symbol "accounts"
 fatal error 107: too many error messages on one line
It seems that the text was too big someone can share it to me in Syntactic sure if that?
And tell me 'cause it happens?
Reply


Messages In This Thread
MYSQL help - by maikons - 05.01.2015, 04:36
Re: MYSQL help - by JeaSon - 05.01.2015, 05:27
Re: MYSQL help - by maikons - 05.01.2015, 18:22
Re: MYSQL help - by maikons - 05.01.2015, 18:28
Re: MYSQL help - by maikons - 05.01.2015, 21:26

Forum Jump:


Users browsing this thread: 1 Guest(s)