Another problem[MySQL R34]
#2

The name is empty because you don't get it with GetPlayerName
pawn Код:
stock UpdateBans(playerid, params[])
{
    new target[MAX_PLAYER_NAME], str[128], query[200];
    GetPlayerName(playerid,target,sizeof(target));
    if(Player[playerid][Banned] == 1)
    {
        mysql_format(SQL,query, sizeof(query),"UPDATE `players` SET `banned` = '0' WHERE `username` = '%s' LIMIT 1", target);
        mysql_tquery(SQL, query, "", "");
        print(query);
        SendClientMessage(playerid, -1, "SERVER:Done!");
    }
    else
    {
        format(str, 128,"[MySQL]:This player is not registered.");
        SendClientMessage(playerid, -1, str);
    }
    return 1;
}
Reply


Messages In This Thread
Another problem[MySQL R34] - by Keyhead - 02.11.2013, 23:59
Re: Another problem[MySQL R34] - by dusk - 03.11.2013, 00:04
Re: Another problem[MySQL R34] - by Keyhead - 03.11.2013, 00:09
Re: Another problem[MySQL R34] - by Jefff - 03.11.2013, 00:30
Re: Another problem[MySQL R34] - by Keyhead - 03.11.2013, 00:49

Forum Jump:


Users browsing this thread: 1 Guest(s)