IP Logs & Anti Cheat

hello ragezone members today i will teach how to make
anti cheat with ip or get ip of character


first go to create the table

Spoiler:

USE [SRO_VT_SHARD_LOG]
GO


/****** Object: Table [dbo].[_IPLogs] Script Date: 09/04/2014 08:30:03 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[_IPLogs](
[No.] [int] IDENTITY(1,1) NOT NULL,
[CharID] [int] NULL,
[Charname] [varchar](max) NULL,
[IP] [varchar](max) NULL,
[Date] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[No.] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO

second add this lines in proc of dbo._AddLogChar

Spoiler:

Code:

---

/* coded by kingdollar */
IF  @eventID = 4 Or @eventID = 6)
BEGIN
BEGIN TRANSACTION
BEGIN TRY
IF  @eventID = 4)
BEGIN
DECLARE @JiD int = (Select UserJID from SRO_VT_SHARD.dbo._User Where CharID = @CharID)
DECLARE @DyniP varchar(max); exec @DyniP = SRO_VT_ACCOUNT.dbo.split_ip @data2;
INSERT INTO SRO_VT_SHARD_LOG.dbo._IPLogs (CharID,Charname,IP,[Date]) VALUES  @CharID, (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID), @DyniP,GETDATE())
update SRO_VT_ACCOUNT.dbo.TB_User set reg_ip = @DyniP where JID = @JiD
END


ELSE IF  @eventID = 6)
BEGIN
delete from SRO_VT_SHARD_LOG.dbo._IPLogs where CharID = @CharID
END


COMMIT TRANSACTION
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() AS ErrorState,
ERROR_PROCEDURE() AS ErrorProcedure,
ERROR_LINE() AS ErrorLine,
ERROR_MESSAGE() AS ErrorMessage


ROLLBACK TRANSACTION
END CATCH
IF (@@ERROR <> 0)
BEGIN
RETURN
ROLLBACK TRANSACTION
END
END

---

from first and second now you can get the iplog of characters
okay let's go to part 2 from thread > it's about how to make anti cheat with ip log on your system it's too easy
look go to your proc which you need to make it like pvp proc or job system and do next step
add this lines to your proc

Spoiler:

declare @IP1 varchar(64) = (select IP from _IPLogs Where Charname = @Yourdeclare1)
declare @IP2 varchar(64) = (select IP from _IPLogs Where Charname = @Yourdeclare2)


IF (@IP1 != @IP2)
BEGIN
--YOUR CODE
END

Okay we have done now
regards King Dollar

what if the server have proxy :)

yep .. useless for proxies users :)

Yes, i was thinking to release it before you, but like NourAyman said useless for proxy users, because any character register will appear with proxy IP

Quote:

---

Originally Posted by NourAyman

yep .. useless for proxies users :)

---

proxies users

amazing

+1 :d

want something for proxy