I need to make a var which is a SUM between 2 integers current time and ban lenght - showld give me ban expire time right ? how do i do that ...
and how to port this line into amxx language ?
INSERT INTO `%s_bans` (`ip`, `authid`, `name`, `created`, `ends`, `length`, `reason`, `aid`, `adminIp`, `sid`) VALUES ('%s', '%s', \"%s\", UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + %d, '%d', '%s', (SELECT `aid` FROM `%s_admins` WHERE `authid` = '%s'), '%s', (SELECT `sid` FROM `%s_servers` WHERE `ip` = '%s' AND `port` = '%s' LIMIT 0,1))", DatabasePrefix, Ip, Authid, Name, (time*60), (time*60), Reason, DatabasePrefix, AdminAuthid, AdminIp, DatabasePrefix, ServerIp, ServerPort);
|