mysql query.
#1

Hey, i made a simple saving thingy but i get these errors:

Код:
(9499) : error 075: input line too long (after substitutions)
(9500) : error 037: invalid string (possibly non-terminated string)
(9500) : error 017: undefined symbol "UPDATE"
(9500) : error 017: undefined symbol "users"
(9500) : fatal error 107: too many error messages on one line
maybe i need to do the query different than how i did it ;p

pawn Код:
9499        new query[500];
9500        format(query, sizeof(query), "UPDATE users SET IP='%d' stored='%d' jail='%d' armour='%d' warn='%d' duty='%d' biz='%d' house='%d' number='%d' local='%d' int='%d' licensec='%d' licenseb='%d' licensea='%d' pos_z='%d' pos_y='%d' pos_x='%d' shealth='%d' ammo7='%d' ammo6='%d' ammo5='%d' ammo4='%d' ammo3='%d' ammo2='%d' ammo1='%d' gun7='%d' gun6='%d' gun5='%d' gun4='%d' gun3='%d' gun2='%d' gun1='%d' mwkills='%d' deathmatch='%d' streetrace='%d' hotwire='%d' cashbox='%d' kills='%d' admin='%d' password='%s' level='%d' account='%d' money='%d' exp='%d' drugs='%d' skin='%d' team='%d' rank='%d' upgrades='%d' WHERE name='%d'",PlayerInfo[playerid][pIP], PlayerInfo[playerid][pStored], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pSArmour], PlayerInfo[playerid][pWarnL], PlayerInfo[playerid][pDuty], PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pLicenseC], PlayerInfo[playerid][pLicenseB], PlayerInfo[playerid][pLicenseA], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pAmmo7], PlayerInfo[playerid][pAmmo6], PlayerInfo[playerid][pAmmo5], PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pGun7] ,PlayerInfo[playerid][pGun6] ,PlayerInfo[playerid][pGun5] ,PlayerInfo[playerid][pGun4] ,PlayerInfo[playerid][pGun3] ,PlayerInfo[playerid][pGun2] ,PlayerInfo[playerid][pGun1] ,PlayerInfo[playerid][pPEN], PlayerInfo[playerid][pWA], PlayerInfo[playerid][pSR], PlayerInfo[playerid][pHW], PlayerInfo[playerid][pCB],PlayerInfo[playerid][pKills], PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pPassword],PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pCash], PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pExp], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pRank],PlayerInfo[playerid][gPupgrade] , usernamelol);
9501        samp_mysql_query(query);
Reply
#2

Line 9500 is too long. Also change the query to 512 from 500.
Reply
#3

Quote:
Originally Posted by MenaceX^
Line 9500 is too long. Also change the query to 512 from 500.
how must i do it than, i heard a friend of me used 2024 cells for 1 query. so its possibole but how? :X
Reply
#4

Quote:
Originally Posted by Pandabeer1337
Quote:
Originally Posted by MenaceX^
Line 9500 is too long. Also change the query to 512 from 500.
how must i do it than, i heard a friend of me used 2024 cells for 1 query. so its possibole but how? :X
2048* and you can even 4096
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)