1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
undefined symbol "UPDATE" - MYSQL
DarkLouis
Big Clucker
***
Posts: 152
Threads: 24
Joined: Jan 2014
Reputation: 0
#1

10.05.2015, 07:32
( Last edited by DarkLouis; 10/05/2015 at 07:33 AM. Reason: Error in title. )
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?
Find
Reply
Mencent
High-roller
*****
Posts: 1,311
Threads: 11
Joined: Mar 2015
Reputation: 0
#2

10.05.2015, 07:48
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.
Find
Reply
DarkLouis
Big Clucker
***
Posts: 152
Threads: 24
Joined: Jan 2014
Reputation: 0
#3

10.05.2015, 08:12
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
Find
Reply
J4Rr3x
Big Clucker
***
Posts: 167
Threads: 12
Joined: Jan 2014
Reputation: 0
#4

10.05.2015, 08:45
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);
Find
Reply
Mencent
High-roller
*****
Posts: 1,311
Threads: 11
Joined: Mar 2015
Reputation: 0
#5

10.05.2015, 09:08
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?
Find
Reply
justice96
Unregistered
 
#6

10.05.2015, 09:26
Quote:
Originally Posted by Mencent
View Post
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;
}
Reply
DarkLouis
Big Clucker
***
Posts: 152
Threads: 24
Joined: Jan 2014
Reputation: 0
#7

10.05.2015, 09:37
I created a function that save the player's data. (SalvaDati(playerid) and in it there's that code..
Find
Reply
Mencent
High-roller
*****
Posts: 1,311
Threads: 11
Joined: Mar 2015
Reputation: 0
#8

10.05.2015, 09:37
Ok. Can you send us your whole save-function and the rows of the errors in that function?
Find
Reply
justice96
Unregistered
 
#9

10.05.2015, 09:39
Quote:
Originally Posted by DarkLouis
View Post
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)'
Reply
DarkLouis
Big Clucker
***
Posts: 152
Threads: 24
Joined: Jan 2014
Reputation: 0
#10

10.05.2015, 09:42
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;

} 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help