SA-MP Forums Archive
getting a lot error on mysql_format - 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: getting a lot error on mysql_format (/showthread.php?tid=648381)


getting a lot error on mysql_format - Jokers98s - 21.01.2018

Trying to promote an clan member to ownership
PHP код:
            new Query[150];
            new player_name[MAX_PLAYER_NAME];
            GetPlayerName(playerid,player_name,sizeof(player_name));
            new value = 1;
            mysql_format(gSQL,Query, sizeof(Query), "UPDATE `Clan_Mamebers` SET `Clan_Co_Owner` = %d WHERE `playername` = '%s'",value,player_name(cid));
            mysql_tquery(gSQL, Query ); 
error's
PHP код:
F:\Server\My server\Copy- of server 3\Call of Duty\gamemodes\TDM.pwn(17163) : error 012: invalid function call, not a valid address
F:\Server\My server\Copy- of server 3\Call of Duty\gamemodes\TDM.pwn(17163) : warning 215: expression has no effect
F:\Server\My server\Copy- of server 3\Call of Duty\gamemodes\TDM.pwn(17163) : error 001: expected token: ";", but found ")"
F:\Server\My server\Copy- of server 3\Call of Duty\gamemodes\TDM.pwn(17163) : error 029: invalid expression, assumed zero
F:\Server\My server\Copy- of server 3\Call of Duty\gamemodes\TDM.pwn(17163) : fatal error 107: too many error messages on one line 


Re: getting a lot error on mysql_format - RIDE2DAY - 21.01.2018

PHP код:
new Query[150]; 
            new player_name[MAX_PLAYER_NAME]; 
            GetPlayerName(playerid,player_name,sizeof(player_name)); 

            mysql_format(gSQL,Query, sizeof(Query), "UPDATE `Clan_Mamebers` SET `Clan_Co_Owner` = 1 WHERE `playername` = '%e'", player_name); 
            mysql_tquery(gSQL, Query ); 


Re: getting a lot error on mysql_format - Jokers98s - 21.01.2018

Thanks ++rep