Mysql Trying 3 cases
#1

pawn Код:
mysql_format(g_SQL, string, sizeof(string), "SELECT * FROM `bans` WHERE `bannick`='%e' OR `banip`='%e' AND banned=true LIMIT 1", PlayerInfo[playerid][pUserName],PlayerInfo[playerid][pIP]);
    mysql_pquery(g_SQL, string, "CheckPlayerBan", "d", playerid);
How could i do to check for the ip or that banned nick but where the banned should be true it's a boolen on database.
As even if i will remove my bans it won't remove this record.
Reply


Messages In This Thread
Mysql Trying 3 cases - by AroseKhanNiazi - 01.07.2015, 12:55
Re: Mysql Trying 3 cases - by Suicidal.Banana - 01.07.2015, 13:08
Re: Mysql Trying 3 cases - by AroseKhanNiazi - 01.07.2015, 15:14
Re: Mysql Trying 3 cases - by Prokill911 - 01.07.2015, 15:41
Re: Mysql Trying 3 cases - by Suicidal.Banana - 01.07.2015, 16:32
Re: Mysql Trying 3 cases - by AroseKhanNiazi - 01.07.2015, 18:29
Re: Mysql Trying 3 cases - by Suicidal.Banana - 01.07.2015, 19:04
Re: Mysql Trying 3 cases - by AroseKhanNiazi - 01.07.2015, 19:41
Re: Mysql Trying 3 cases - by Suicidal.Banana - 01.07.2015, 21:41
Re: Mysql Trying 3 cases - by AroseKhanNiazi - 02.07.2015, 12:19

Forum Jump:


Users browsing this thread: 5 Guest(s)