Mysql R39-2 Don't save - Printable Version

Mysql R39-2 Don't save - 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: Mysql R39-2 Don't save (/showthread.php?tid=561150)

Mysql R39-2 Don't save - BreakStore - 01.02.2015

Hello,

I have a problem, my stats mysql don't save on the database on the deconnection :

Script :

OnplayerDisconnect :

PHP код:



new query[128], Float:pos[3]; 

GetPlayerPos(playerid,pos[0],pos[1],pos[2]); 

mysql_format(mysql,query,sizeof(query),"UPDATE `comptejoueurs` SET `Admin`=%d, `Vip`=%d, `Argent`=%d, `PositionX`=%f, `PositionY`=%f, `PositionZ`=%f WHERE `ID`=%d",\ 

InfoJoueur[playerid][Admin],InfoJoueur[playerid][Vip],InfoJoueur[playerid][Argent],pos[0],pos[1],pos[2], InfoJoueur[playerid][ID]); 

mysql_tquery(mysql,query,"",""); 

printf("%s",query);

Thanks

Re: Mysql R39-2 Don't save - amirab - 01.02.2015

i tested that , try this instead maybe it works :

PHP код:



new query[128], Float:pos[3]; 
GetPlayerPos(playerid,pos[0],pos[1],pos[2]); 
mysql_format(mysql,query,sizeof(query),"UPDATE `comptejoueurs` SET `Admin`=%d, `Vip`=%d, `Argent`=%d, `PositionX`=%f, `PositionY`=%f, `PositionZ`=%f WHERE `ID`=%d",\ 
InfoJoueur[playerid][Admin],InfoJoueur[playerid][Vip],InfoJoueur[playerid][Argent],pos[0],pos[1],pos[2], InfoJoueur[playerid][ID]); 
mysql_tquery(mysql,query); 
printf("%s",query);

Re: Mysql R39-2 Don't save - zPain - 01.02.2015

I think the array size isn't enough.

pawn Код:

new query[0xFF], Float:pos[3];  
GetPlayerPos(playerid,pos[0],pos[1],pos[2]);  

mysql_format(mysql, query, sizeof(query),"UPDATE `comptejoueurs` SET `Admin`=%d, `Vip`=%d, `Argent`=%d, `PositionX`=%f, `PositionY`=%f, `PositionZ`=%f WHERE `ID`=%d",  
    InfoJoueur[playerid][Admin],
    InfoJoueur[playerid][Vip],
    InfoJoueur[playerid][Argent],
    pos[0],pos[1],pos[2], 
    InfoJoueur[playerid][ID]
);

mysql_tquery(mysql,query,"","");  
printf("%s",query);