The maths looks like it should be right ..
The SQLX snippet for that select is basically:
PHP Code:
query_handle = SQL_PrepareQuery(connection_handle,"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) ;
(The linebreaks are to add a tiny bit of readability ... but should be fine left in)