undefined symbol "UPDATE" - MYSQL
#2

Hello!

I was so free to write your code like this:
PHP Code:
new query[800];
mysql_format(mysql,query,sizeof query,"UPDATE `utenti` SET `HP`=%f,`Denaro`=%d,`Sesso`=%d,`AP`=%f,`Admin`=%d,`Premium`=%d,`Anni`=%d,",
PlayerInfo[playerid][HP],PlayerInfo[playerid][Denaro],PlayerInfo[playerid][Sesso],PlayerInfo[playerid][AP],PlayerInfo[playerid][Admin],
PlayerInfo[playerid][Premium],PlayerInfo[playerid][Anni]);
mysql_format(mysql,query,sizeof query,"%s`Cittadinanza`=%d,`Skin`=%d,`Tutorial`=%d,`Jail`=%d,`TempoJail`=%d,`Muto`=%d,`Elmetto`=%d,",query
PlayerInfo
[playerid][Cittadinanza],PlayerInfo[playerid][Skin],PlayerInfo[playerid][Tutorial],PlayerInfo[playerid][Jail],
PlayerInfo[playerid][TempoJail],PlayerInfo[playerid][Muto],PlayerInfo[playerid][Elmetto]);
mysql_format(mysql,query,sizeof query,"%s`Banca`=%d,`IDNegozio`=%d,`IDVeicolo`=%d,`IDVeicolo_2`=%d,`IDVeicolo_3`=%d,`IDSpawn`=%d,",query
PlayerInfo
[playerid][Banca],PlayerInfo[playerid][IDNegozio],PlayerInfo[playerid][IDVeicolo],PlayerInfo[IDVeicolo_2],PlayerInfo[playerid][IDVeicolo_3],
PlayerInfo[playerid][Spawn]);
mysql_format(mysql,query,sizeof query,"%s`IDFazione`=%d,`RankFazione`=%d,`SkinDuty`=%d,`Servizio`=%d,`SemeCocaina`=%d,`SemeMarijuana`=%d,",query
PlayerInfo
[playerid][IDFazione],PlayerInfo[playerid][RankFazione],PlayerInfo[playerid][SkinDuty],PlayerInfo[playerid][Servizio],
PlayerInfo[playerid][SemeCocaine],PlayerInfo[playerid][SemeMarijuana]);
mysql_format(mysql,query,sizeof query,"%s`SemeOppio`=%d,`OppioPuro`=%d,`Oppio`=%d,`Eroina`=%d,`CocainePura`=%d,`Cocaina`=%d,`Crack`=%d,",query,
PlayerInfo[playerid][SemeOppio],PlayerInfo[playerid][OppioPuro],PlayerInfo[playerid][Oppio],PlayerInfo[playerid][Eroina],PlayerInfo[playerid][CocainePura],
PlayerInfo[playerid][Cocaine],PlayerInfo[playerid][Crack]);
mysql_format(mysql,query,sizeof query,"%s`MarijuanaPura`=%d,`Marijuana`=%d,`Hashish`=%d,`Ecstasy`=%d,`Steroidi`=%d,`Giornale`=%d,`Titolo_0`=%s,",query,
PlayerInfo[playerid][MarijuanaPura],PlayerInfo[playerid][Marijuana],PlayerInfo[playerid][Hashish],PlayerInfo[playerid][Ecstasy],
PlayerInfo[playerid][Steroidi],PlayerInfo[playerid][Giornale],PlayerInfo[playerid][Titolo_0]);
mysql_format(mysql,query,sizeof query,"%s`Pagina_0`=%s,`Titolo_1`=%s,`Pagina_1`=%s,`Titolo_2`=%s,`Pagina_2`=%s,`Titolo_3`=%s,`Pagina_3`=%s,",query,
PlayerInfo[playerid][Pagina_0],PlayerInfo[playerid][Titolo_1],PlayerInfo[playerid][Pagina_1],PlayerInfo[playerid][Totolo_2],PlayerInfo[playerid][Pagina_2],
PlayerInfo[playerid][Totolo_3],PlayerInfo[playerid][Pagina_3]);
mysql_format(mysql,query,sizeof query,"%s`Titolo_4`=%s,`Pagina_4`=%s,`Titolo_5`=%s,`Pagina_5`=%s,`Posizione_X`=%f,`Posizione_Y`=%f,`Posizione_Z`=%f,",query,
PlayerInfo[playerid][Titolo_4],PlayerInfo[playerid][Pagina_4],PlayerInfo[playerid][Titolo_5],PlayerInfo[playerid][Pagina_5],
PlayerInfo[playerid][Posizione_X],PlayerInfo[playerid][Posizione_Y],PlayerInfo[playerid][Posizione_Z]);
mysql_format(mysql,query,sizeof query,"%s`Interior`=%d,`VirtualWorld`=%d WHERE `ID`=%d",query,PlayerInfo[playerid][Interior],
PlayerInfo[playerid][VirtualWorld],PlayerInfo[playerid][ID]);
mysql_tquery(mysqlquery""""); 
If you write it like your code the compiler put this in a one row while the compile.
I hope you understand this.
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: 1 Guest(s)