[zeroibis]

If there a way that sourcebans could be modified to allow for it to still process the ban when there is more than one account with the same steam id. Can it be made to just record it from the first account that has the steam id.

[zeroibis]

I have tried the code below and with ANY as well and so far IN nor ANY work.

FormatEx(Query, sizeof(Query), "INSERT INTO %s_bans (ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES \
                        ('%s', '%s', '%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + %d, %d, '%s', IFNULL((SELECT aid FROM %s_admins WHERE authid IN ( '%s', REGEXP '^STEAM_[0-9]:%s$' )),'0'), '%s', \
                        %d, ' ')", 
                        DatabasePrefix, Ip, Authid, banName, (time*60), (time*60), banReason, DatabasePrefix, AdminAuthid, AdminAuthid[8], AdminIp, serverID);

[zeroibis]

Solved!

Solution was:

FormatEx(Query, sizeof(Query), "INSERT INTO %s_bans (type, ip, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES \
                        (1, '%s', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + %d, %d, '%s', (SELECT aid FROM %s_admins WHERE authid IN ( '%s' OR authid REGEXP '^STEAM_[0-9]:%s$' ) LIMIT 1 ), '%s', \
                        %d, ' ')", 
                        DatabasePrefix, ip, (minutes*60), (minutes*60), banReason, DatabasePrefix, adminAuth, adminAuth[8], adminIp, serverID);

[Peace-Maker]

Why would you ever want 2 admins with the same steamid in your database?!

[SystematicMania]

My guess is different privileges on each server.