[XoMoX]

Hi can i request for help for my temp ban im using event scheduler but it wont unban automaticaly but if you guys can suggest or give some temp ban scripts it would be good or can you help me with this

PHP Code:

CMD:ban(playerid, params[])
{
    if(Player[playerid][Admin] >= 2)
    {
        new
            query[256],
            ip[16],
            reason[50],
            string[64]
        ;
        new banner[MAX_PLAYER_NAME], PlayerName[MAX_PLAYER_NAME], target;
        GetPlayerName(playerid, banner, sizeof(banner));
        GetPlayerName(target, PlayerName, sizeof(PlayerName));
        GetPlayerIp(target, ip, sizeof(ip));
        if(sscanf(params, "rs[50]", target, reason)) return SendClientMessage(playerid,0xAA3333AA,"USAGE:/ban(Name)(reason)");
        mysql_format(MySQL:mysql, query, sizeof(query), "INSERT INTO `bans`(`player`, `ip`, `admin`,`reason`) VALUES('%s', '%e', '%e', '%s')", target, ip, banner, reason);
        mysql_tquery(MySQL:mysql, query, "", "");
        mysql_format(MySQL:mysql, query, 256, "DROP EVENT IF EXISTS `%e`", target);
        mysql_tquery(MySQL:mysql, query, "", "");
        mysql_format(MySQL:mysql, query, sizeof(query), "CREATE EVENT `%e` ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 Minute DO DELETE FROM `bans` WHERE `bans`.`player` = '%e'", target, target);
        mysql_tquery(MySQL:mysql, query, "", "");
        format(string, sizeof(string), "ADMIN BAN:%s has been banned reason: %s", target, reason);
        SendClientMessageToAll(0xFF22EE00, string);
    }
    return 1;
} 


thanks