undefined symbol "UPDATE" - MYSQL

undefined symbol "UPDATE" - MYSQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: undefined symbol "UPDATE" - MYSQL (/showthread.php?tid=573766)

undefined symbol "UPDATE" - MYSQL - DarkLouis - 10.05.2015

Hi all. This is my code:

My MYSQL version is the last.

PHP Code:





new query[600];

    mysql_format(mysql, query, sizeof(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(mysql, query, "", "");

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?

AW: undefined symbol "UPDATE" - MYSQL - Mencent - 10.05.2015

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(mysql, query, "", "");

If you write it like your code the compiler put this in a one row while the compile.
I hope you understand this.

Re: undefined symbol "UPDATE" - MYSQL - DarkLouis - 10.05.2015

Thank you but it don't work.

Code:

error 001: expected token: ",", but found "-identifier-"
 warning 215: expression has no effect
 warning 215: expression has no effect
 warning 215: expression has no effect
 warning 215: expression has no effect
 warning 215: expression has no effect
 warning 215: expression has no effect
 warning 215: expression has no effect
 error 001: expected token: ";", but found ")"
 error 029: invalid expression, assumed zero
 fatal error 107: too many error messages on one line

Re: undefined symbol "UPDATE" - MYSQL - J4Rr3x - 10.05.2015

Try this:

pawn Code:

new query[600]; 
mysql_format(mysql, query, sizeof(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(mysql, query);

AW: undefined symbol "UPDATE" - MYSQL - Mencent - 10.05.2015

No! It's the same as the code before.
The compiler put the rows in one row while the compile.

@DarkLouis:
Can you send us the row where the errors are?

Re: AW: undefined symbol "UPDATE" - MYSQL - justice96 - 10.05.2015

Quote:

Originally Posted by Mencent

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(mysql, query, "", "");

If you write it like your code the compiler put this in a one row while the compile.
I hope you understand this.

^correct, try this then

Code:

mysql_tquery('this is for the connection to database, query, "example", "d",playerid);

function example
{
   // reset player data here
   return 1;
}

public OnPlayerDisconnect
{
   example(playerid);
   return 1;
}

Re: undefined symbol "UPDATE" - MYSQL - DarkLouis - 10.05.2015

I created a function that save the player's data. (SalvaDati(playerid) and in it there's that code..

AW: undefined symbol "UPDATE" - MYSQL - Mencent - 10.05.2015

Ok. Can you send us your whole save-function and the rows of the errors in that function?

Re: undefined symbol "UPDATE" - MYSQL - justice96 - 10.05.2015

Quote:

Originally Posted by DarkLouis

I created a function that save the player's data. (SalvaDati(playerid) and in it there's that code..

give me a codes for function 'salvadati(playerid)'

Re: undefined symbol "UPDATE" - MYSQL - DarkLouis - 10.05.2015

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;

}