undefined symbol "UPDATE" - MYSQL
#1

Hi all. This is my code:

My MYSQL version is the last.

PHP Code:

new query[600];
    
mysql_format(mysqlquerysizeof(query),"UPDATE `utenti` SET\
    `HP`=%f,\
    `Denaro`=%d,\
    `Sesso`=%d,\
    `AP`=%f,\
    `Admin`=%d,\
    `Premium`=%d,\
    `Anni`=%d,\
    `Cittadinanza`=%d,\
    `Skin`=%d,\
    `Tutorial`=%d,\
    `Jail`=%d,\
    `TempoJail`=%d,\
    `Muto`=%d,\
    `Elmetto`=%d,\
    `Banca`=%d,\
    `IDNegozio`=%d,\
    `IDVeicolo`=%d,\
    `IDVeicolo_2`=%d,\
    `IDVeicolo_3`=%d,\
    `IDSpawn`=%d,\
    `IDFazione`=%d,\
    `RankFazione`=%d,\
    `SkinDuty`=%d,\
    `Servizio`=%d,\
    `SemeCocaina`=%d,\
    `SemeMarijuana`=%d,\
    `SemeOppio`=%d,\
    `OppioPuro`=%d,\
    `Oppio`=%d,\
    `Eroina`=%d,\
    `CocainaPura`=%d,\
    `Cocaina`=%d,\
    `Crack`=%d,\
    `MarijuanaPura`=%d,\
    `Marijuana`=%d,\
    `Hashish`=%d,\
    `Ecstasy`=%d,\
    `Steroidi`=%d,\
    `Giornale`=%d,\
    `Titolo_0`=%s,\
    `Pagina_0`=%s,\
    `Titolo_1`=%s,\
    `Pagina_1`=%s,\
    `Titolo_2`=%s,\
    `Pagina_2`=%s,\
    `Titolo_3`=%s,\
    `Pagina_3`=%s,\
    `Titolo_4`=%s,\
    `Pagina_4`=%s,\
    `Titolo_5`=%s,\
    `Pagina_5`=%s,\
    `Posizione_X`=%f,\
    `Posizione_Y`=%f,\
    `Posizione_Z`=%f,\
    `Interior`=%d,\
    `VirtualWorld`=%d\
    WHERE\
    `ID`=%d"
,
    
PlayerInfo[playerid][HP],
    
PlayerInfo[playerid][Denaro],
    
PlayerInfo[playerid][Sesso],
    
PlayerInfo[playerid][AP],
    
PlayerInfo[playerid][Admin],
    
PlayerInfo[playerid][Premium],
    
PlayerInfo[playerid][Anni],
    
PlayerInfo[playerid][Cittadinanza],
    
PlayerInfo[playerid][Skin],
    
PlayerInfo[playerid][Jail],
    
PlayerInfo[playerid][TempoJail],
    
PlayerInfo[playerid][Muto],
    
PlayerInfo[playerid][Elmetto],
    
PlayerInfo[playerid][Banca],
    
PlayerInfo[playerid][IDNegozio],
    
PlayerInfo[playerid][IDVeicolo],
    
PlayerInfo[playerid][IDVeicolo2],
    
PlayerInfo[playerid][IDVeicolo3],
    
PlayerInfo[playerid][IDSpawn],
    
PlayerInfo[playerid][IDFazione],
    
PlayerInfo[playerid][RankFazione],
    
PlayerInfo[playerid][SkinDuty],
    
PlayerInfo[playerid][Servizio],
    
PlayerInfo[playerid][SemeCocaina],
    
PlayerInfo[playerid][SemeMarijuana],
    
PlayerInfo[playerid][SemeOppio],
    
PlayerInfo[playerid][OppioPuro],
    
PlayerInfo[playerid][Oppio],
    
PlayerInfo[playerid][Eroina],
    
PlayerInfo[playerid][CocainaPura],
    
PlayerInfo[playerid][Cocaina],
    
PlayerInfo[playerid][MarijuanaPura],
    
PlayerInfo[playerid][Marijuana],
    
PlayerInfo[playerid][Hashish],
    
PlayerInfo[playerid][Ecstasy],
    
PlayerInfo[playerid][Steroidi],
    
PlayerInfo[playerid][Giornale],
    
PlayerInfo[playerid][Titolo0],
    
PlayerInfo[playerid][Pagina0],
    
PlayerInfo[playerid][Titolo1],
    
PlayerInfo[playerid][Pagina1],
    
PlayerInfo[playerid][Titolo2],
    
PlayerInfo[playerid][Pagina2],
    
PlayerInfo[playerid][Titolo3],
    
PlayerInfo[playerid][Pagina3],
    
PlayerInfo[playerid][Titolo4],
    
PlayerInfo[playerid][Pagina4],
    
PlayerInfo[playerid][Titolo5],
    
PlayerInfo[playerid][Pagina5],
    
PlayerInfo[playerid][PosX],
    
PlayerInfo[playerid][PosY],
    
PlayerInfo[playerid][PosZ],
    
PlayerInfo[playerid][Interior],
    
PlayerInfo[playerid][VirtualWorld],
    
PlayerInfo[playerid][ID]);
    
mysql_tquery(mysqlquery""""); 
It give to me:
Code:
error 075: input line too long (after substitutions)
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "UPDATE"
error 029: invalid expression, assumed zero
: fatal error 107: too many error messages on one line
How can I do?
Reply


Messages In This Thread
undefined symbol "UPDATE" - MYSQL - by DarkLouis - 10.05.2015, 07:32
AW: undefined symbol "UPDATE" - MYSQL - by Mencent - 10.05.2015, 07:48
Re: undefined symbol "UPDATE" - MYSQL - by DarkLouis - 10.05.2015, 08:12
Re: undefined symbol "UPDATE" - MYSQL - by J4Rr3x - 10.05.2015, 08:45
AW: undefined symbol "UPDATE" - MYSQL - by Mencent - 10.05.2015, 09:08
Re: AW: undefined symbol "UPDATE" - MYSQL - by justice96 - 10.05.2015, 09:26
Re: undefined symbol "UPDATE" - MYSQL - by DarkLouis - 10.05.2015, 09:37
AW: undefined symbol "UPDATE" - MYSQL - by Mencent - 10.05.2015, 09:37
Re: undefined symbol "UPDATE" - MYSQL - by justice96 - 10.05.2015, 09:39
Re: undefined symbol "UPDATE" - MYSQL - by DarkLouis - 10.05.2015, 09:42

Forum Jump:


Users browsing this thread: 2 Guest(s)