MySQL Query insert
#1

Hello, Can someone tell me what's wrong in this function?
I don't get any errors on compile, and command works well in server (usage and...)
But no bans are added to banlist..

PHP код:
CMD:ban(playeridparams[])
{
    new 
pIDreason[30], string[128];
    if(
pInfo[playerid][Admin] < 3) return NotAdminMSG(playerid);
    if(
sscanf(params"us[30]"pIDreason)) return SCM(playeridCOLOR_WHITE""WORD_USAGE"/ban [PLAYER_ID] [REASON]");
    if(!
IsPlayerConnected(pID)) return SCM(playeridCOLOR_WHITE""WORD_ERROR"This player is not connected.");
    if(
pInfo[playerid][Admin] < pInfo[pID][Admin]) return SCM(playeridCOLOR_WHITE""WORD_ERROR"You cannot apply this command on a higher admin.");
    
format(stringsizeof(string), ""WORD_ADMIN"%s has banned %s. "COL_REASON"[REASON: %s]"PlayerName(playerid), PlayerName(pID), reason);
    
SCMToAll(COLOR_WHITEstring);
    new 
yearmonthdayquery[128];
    
getdate(yearmonthday);
    
mysql_format(mysqlquerysizeof(query), "INSERT INTO `banlist` (`BannedBy`, `Reason`, `PlayerName`, `BannedIP`, `banYear`, `banMonth`, `banDay`) VALUES ('%s', '%s', '%s', '%s', '%d', '%02d', '%02d')"PlayerName(playerid), reasonPlayerName(pID), PlayerIP(pID), yearmonthday);
    
mysql_tquery(mysqlquery"""");
    return 
true;

Reply


Messages In This Thread
MySQL Query insert - by E7mad - 23.12.2015, 05:59
Re: MySQL Query insert - by JeaSon - 23.12.2015, 08:07
Re: MySQL Query insert - by E7mad - 23.12.2015, 09:14
Re: MySQL Query insert - by DaniceMcHarley - 23.12.2015, 10:31

Forum Jump:


Users browsing this thread: 2 Guest(s)