Issue with mysql query that gets cut out
#1

Hello.
My query gets cut out.

code:
PHP код:
forward SetLeader(ffID,target,playerid);
public 
SetLeader(ffID,target,playerid)
{
    new 
string[400];
    
myStrcpy(Player[target][FactionRank],"New Leader");
    new 
query[400];
    
Player[target][Leader] = 1;
    
format(query,sizeof(query),"UPDATE accounts SET FactionRank='New Leader',IsLeader='1' WHERE Username='%s'",Player[target][Faction],Player[target][FactionName],Name(target));
    
mysql_tquery(connection,query,"");
    for(new 
0GetPlayerPoolSize(); <= ji++)
    {
        if(
Player[i][Faction] == ffID)
        {
            
format(string,sizeof(string),"{40FF00}[{BEF781}%s{40FF00}] Administrator {BEF781}%s{40FF00} has set {BEF781}%s{40FF00} as a faction leader.",Player[i][FactionName],RPName(playerid),RPName(target));
            
SendMessage(i,0xFF00FF,string);
        }
    }
    return 
1;

What my mysql log emits:
Код:
[11:38:29] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts SET FactionRank='New Leader',IsLeader='1' WHERE ", callback: "(null)", format: "(null)"
Reply


Messages In This Thread
Issue with mysql query that gets cut out - by justjamie - 08.11.2016, 15:47
Re: Issue with mysql query that gets cut out - by oMa37 - 08.11.2016, 15:49
Re: Issue with mysql query that gets cut out - by justjamie - 08.11.2016, 15:55
Re: Issue with mysql query that gets cut out - by Mencent - 08.11.2016, 16:16
Re: Issue with mysql query that gets cut out - by justjamie - 08.11.2016, 16:54

Forum Jump:


Users browsing this thread: 1 Guest(s)