amx_last

talk about cs related topics here!

Post Reply
Overkill
Posts: 90
Joined: Thu Jul 24, 2014 8:52 pm

amx_last

Post by Overkill » Fri Jan 09, 2015 10:26 pm

It's broken. I've been banned twice by it, and I've heard other stories.

My idea is an event called on login/logout that writes to table LoginHistory which contains:
int LoginID, varchar PlayerName, varchar SteamID, varchar IPAddress, datetime LoginTime, datetime LogoutTime

Then, an in-game menu would prompt admins for how far back to search (5, 10, 15 minutes) and query the DB:

Code: Select all

DECLARE @SearchTime as INT = _MenuSelectedTime_
select
	LoginHistory.LoginID
	,LoginHistory.PlayerName
from LoginHistory
where LoginHistory.LogoutTime <= DateAdd(minute,@SearchTime,NOW())
Picking the name would then query to bring up a list of aliases:

Code: Select all

DECLARE @UserLoginID as INT = _PreviouslySelectedLoginID_
select --ALIASES
	LoginHistory.PlayerName
from LoginHistory
where LoginHistory.SteamID in
	(select LoginHistory.SteamID from LoginHistory where LoginHistory.LoginID = @UserLoginID)
or other players from that IP:

Code: Select all

DECLARE @UserLoginID as INT = _PreviouslySelectedLoginID_
select --LANNERS
	LoginHistory.PlayerName
	,LoginHisotry.SteamID
from LoginHistory
where LoginHistory.IPAddress in
	(select LoginHistory.IPAddress from LoginHistory where LoginHistory.LoginID = @UserLoginID)
That's my two cents anyway =)

User avatar
sammy
Site Admin
Posts: 6393
Joined: Sat Oct 18, 2008 12:16 am

Re: amx_last

Post by sammy » Fri Jan 09, 2015 11:33 pm

register system is now enabled in WAR3FT
say /reg to protect your steamid
Image

Post Reply

Return to “Counter-Strike! General cs topics!”

Who is online

Users browsing this forum: No registered users and 216 guests