Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't unban with sm_unban as console. #37

Open
WildCard65 opened this issue Mar 1, 2014 · 2 comments
Open

Can't unban with sm_unban as console. #37

WildCard65 opened this issue Mar 1, 2014 · 2 comments

Comments

@WildCard65
Copy link

Title explains all.

@ppalex7
Copy link
Contributor

ppalex7 commented Mar 2, 2014

What errors or messages (debug info from sourcebans) in server (not game) console you see at this moment?

@WildCard65
Copy link
Author

I'll test ban myself then try to unban myself with console.
Edit: Here it is:
sm_unban STEAM_0:1:61441373
L 03/02/2014 - 10:24:37: [sb_bans.smx] "Console<0>" removed ban (filter "STEAM_0:1:61441373")
L 03/02/2014 - 10:24:37: [sb_bans.smx] Failed to unban the ban from the database: Cannot add or update a child row: a foreign key constraint fails (Flexcraft_SourceBans.sb_bans, CONSTRAINT ban_unban_admin FOREIGN KEY (unban_admin_id) REFERENCES sb_admins (id) ON DELETE SET NULL)
[SourceBans] Failed to unban STEAM_0:1:61441373.

Edit 2: The version I'm using is updated from github(latest)
Edit 3: I had someone else with root access and it worked for em:
[SM] Added info_observer_point: 549
L 03/02/2014 - 10:26:36: [sb_bans.smx] "Flex (LUModder)<4><STEAM_0:0:58178275><>" removed ban (filter "STEAM_0:1:61441373")
L 03/02/2014 - 10:27:33: "Flex (LUModder)<4><STEAM_0:0:58178275>" disconnected (reason "Disconnect by user.")
Dropped Flex (LUModder) from server (Disconnect by user.)
L 03/02/2014 - 10:28:24: "WildCard65 the Joker Card<5><STEAM_0:1:61441373><>" connected, address "99.250.46.87:27006"
Client "WildCard65 the Joker Card" connected (99.250.46.87:27006).
L 03/02/2014 - 10:28:24: "WildCard65 the Joker Card<5><STEAM_0:1:61441373><>" STEAM USERID validated
[SourceBans] Sending admin query: SELECT ad.id, ad.name, ad.auth, ad.identity, ad.server_password, COUNT(ag.group_id) FROM {{admins}} AS ad LEFT JOIN {{admins_server_groups}} AS ag ON ag.admin_id = ad.id LEFT JOIN {{servers_server_groups}} AS gs ON gs.group_id = ag.group_id WHERE ((ad.auth = 'steam' AND ad.identity REGEXP '^STEAM_[0-9]:1:61441373$') OR (ad.auth = 'ip' AND '99.250.46.87' REGEXP REPLACE(REPLACE(ad.identity, '.', '.') , '.0', '..{1,3}')) OR (ad.auth = 'name' AND ad.identity = 'WildCard65 the Joker Card')) AND gs.server_id = 1 AND ad.login_time IS NOT NULL GROUP BY ad.id
L 03/02/2014 - 10:28:33: "WildCard65 the Joker Card<5><STEAM_0:1:61441373><>" entered the game
[SourceBans] Found SQL admin (1,steam,STEAM_0:1:61441373,,WildCard65):434:1
[SourceBans] Binding client (2, 7) resulted in: (1, 434, 1)
[SourceBans] Binding admin group (2, 7, 434, Server-Host, 92)
L 03/02/2014 - 10:28:33: [sourcecomms.smx] VerifyPlayer for AccountID: 122882747. QUERY: SELECT IF(c.length, c.create_time + c.length * 60 - UNIX_TIMESTAMP(), 0) as remaining , c.length, c.create_time, c.type, c.reason, IFNULL(c.server_id,0) , IFNULL(a.id, 0), IFNULL(a.name, 'CONSOLE'), MAX(IFNULL(IF(c.server_id, sgs.immunity, sgw.immunity), 0)) AS immunity FROM {{comms}} AS c LEFT JOIN {{admins}} AS a ON a.id = c.admin_id LEFT JOIN {{admins_server_groups}} AS asg ON asg.admin_id = c.admin_id LEFT JOIN {{server_groups}} AS sgw ON sgw.id = asg.group_id LEFT JOIN {{servers_server_groups}} AS ssg ON ssg.server_id = c.server_id LEFT JOIN {{server_groups}} AS sgs ON sgs.id = asg.group_id AND sgs.id = ssg.group_id WHERE c.steam_account_id = 122882747 AND c.unban_time IS NULL AND (c.length = '0' OR c.create_time + c.length * 60 > UNIX_TIMESTAMP()) GROUP BY c.id
Query_VerifyBlock(userid: 5, client: 2)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants