MySQL Query insert - Printable Version

MySQL Query insert - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Query insert (/showthread.php?tid=596829)

MySQL Query insert - E7mad - 23.12.2015

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;

}

Re: MySQL Query insert - JeaSon - 23.12.2015

show us mysql logs

Re: MySQL Query insert - E7mad - 23.12.2015

Quote:

Originally Posted by JeaSon

show us mysql logs

Where can I find them?

Re: MySQL Query insert - Beckett - 23.12.2015

Your server directory.