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(playerid, params[])
{
    new 
pID, reason[30], string[128];
    if(
pInfo[playerid][Admin] < 3) return NotAdminMSG(playerid);
    if(
sscanf(params, "us[30]", pID, reason)) return SCM(playerid, COLOR_WHITE, ""WORD_USAGE"/ban [PLAYER_ID] [REASON]");
    if(!
IsPlayerConnected(pID)) return SCM(playerid, COLOR_WHITE, ""WORD_ERROR"This player is not connected.");
    if(
pInfo[playerid][Admin] < pInfo[pID][Admin]) return SCM(playerid, COLOR_WHITE, ""WORD_ERROR"You cannot apply this command on a higher admin.");
    
format(string, sizeof(string), ""WORD_ADMIN"%s has banned %s. "COL_REASON"[REASON: %s]", PlayerName(playerid), PlayerName(pID), reason);
    
SCMToAll(COLOR_WHITE, string);
    new 
year, month, day, query[128];
    
getdate(year, month, day);
    
mysql_format(mysql, query, sizeof(query), "INSERT INTO `banlist` (`BannedBy`, `Reason`, `PlayerName`, `BannedIP`, `banYear`, `banMonth`, `banDay`) VALUES ('%s', '%s', '%s', '%s', '%d', '%02d', '%02d')", PlayerName(playerid), reason, PlayerName(pID), PlayerIP(pID), year, month, day);
    
mysql_tquery(mysql, query, "", "");
    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: 1 Guest(s)