undefined symbol "UPDATE" - MYSQL
#10

PHP Code:

function SalvaDati(playerid)
{
    
/*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(mysql, query, "", "");*/
    
return 1;


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)