[sixten_8_9@]

Need help input line too long (after substitutions)

PHP Code:

formatex(iQ,1023,"INSERT INTO %s_bans (type, steam, ip, name, reason, length, server_id, admin_id, admin_ip, create_time) VALUES  ('%s', '%s', '%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + %d, %d, '%s', IFNULL((SELECT admin_id FROM %s_admins WHERE steam = '%s' OR steam REGEXP '^^%s$'),'0'), '%s', (SELECT server_id FROM %s_servers WHERE ip = '%s' AND port='%s' LIMIT 0,1), ' ')", prefix, Ip, steam, Name, (banTime*60), (banTime*60), Reason, prefix, AdminAuthid, AdminAuthid, admin_ip, prefix, ServerIp, ServerPort) 


[CrazY.]

new szBuffer[1023], iLen;
iLen = formatex(szBuffer, charsmax(szBuffer), "INSERT INTO %s_bans (type, steam, ip, name, reason, length, server_id, admin_id, admin_ip, create_time)", prefix);
iLen += formatex(szBuffer[iLen], charsmax(szBuffer) - iLen, "VALUES  ('%s', '%s', '%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + %d, %d, '%s',", Ip, steam, Name, (banTime*60), (banTime*60), Reason)
iLen += formatex(szBuffer[iLen], charsmax(szBuffer) - iLen, "IFNULL((SELECT admin_id FROM %s_admins WHERE steam = '%s' OR steam REGEXP '^^%s$'),'0'), '%s', ", prefix, AdminAuthid, AdminAuthid, admin_ip)
iLen += formatex(szBuffer[iLen], charsmax(szBuffer) - iLen, "(SELECT server_id FROM %s_servers WHERE ip = '%s' AND port='%s' LIMIT 0,1), ' ')", prefix, ServerIp, ServerPort)