SA-MP Forums Archive
MySQL saving errors - 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 saving errors (/showthread.php?tid=618872)



MySQL saving errors - NeXoR - 10.10.2016

Hey guys, this is my SaveChar function, anyone help ?
Код:
D:\MySQL\gamemodes\MVR.pwn(602) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602 -- 603) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602 -- 603) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602 -- 603) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602 -- 603) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602 -- 603) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(602 -- 603) : warning 215: expression has no effect
D:\MySQL\gamemodes\MVR.pwn(603) : error 001: expected token: ";", but found ")"
D:\MySQL\gamemodes\MVR.pwn(603) : error 029: invalid expression, assumed zero
PHP код:
stock SaveChar(playerid)
{
    new 
query[1028];
    
mysql_format(mysqlquerysizeof(query), "UPDATE `Users` SET" \
    
"`AdminLevel`='%d'," \
      
"`Score`='%d'," \
      
"`Kills`='%d'," \
      
"`Deaths`='%d', " \
    
"`Assists`='%d', ");
    
"`VIP`='%d', " \
    
"`VIPExpire`='%e', " \
    
"`Money`='%d', " \
      
"`AutoLogin`='%d' WHERE `UserID`='%d'"PlayerInfo[playerid][Admin], PlayerInfo[playerid][Score], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths],
     
PlayerInfo[playerid][Assists],  PlayerInfo[playerid][VIP],  PlayerInfo[playerid][VIPExpire],  PlayerInfo[playerid][Money],  PlayerInfo[playerid][ALogin], PlayerInfo[playerid][UserID]);
    
mysql_tquery(mysqlquery);




Re: MySQL saving errors - Konstantinos - 10.10.2016

"`Assists`='%d', ");

What is this? It should have been a backslash.


Re: MySQL saving errors - NeXoR - 10.10.2016

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
"`Assists`='%d', ");

What is this? It should have been a backslash.
Thanks, no idea where it did come from.