[RELEASE] How to IP Ban

[lilprohacker]

removed

[AriezOMG]

I don't know if it's worked yet, ive yet to find out, but from when I run a the Try_GameLogin_Taiwan.sql file it gives me this error thing.

Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.sp_LoginSuccessCheck'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.

Also after running it, everyone got an invalid pw and username error. It fixes when I run that query from my help thread though lol.

[lilprohacker]

well all you really need to do is add this section to your login stored proc. and also make the bannedIP table.

--Check for IP ban, if so set the status of the user to banned.
IF(SELECT COUNT([Row]) FROM [PS_UserData].[dbo].[BannedIPs] where [banIP] = @UserIP) > 0
BEGIN
	SET @Status = -5
	UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
END

[NocturnalSniper]

Thanx lilpro i had already done that to fix the error maybe a updated download with the corrected files in it?

[il.mane]

hmmm i feel ****** lol i dont get where to fix the error Apocalypsist had, i also have the same issue aswell, and most importantly my UserIP column in dbo.Users_Master give me NULL all the way thru :S do i miss anything?

EDIT: all fixed

[[GS]Shadow]

Originally Posted by Apocalypsist

Also after running it, everyone got an invalid pw and username error. It fixes when I run that query from my help thread though lol.

What query did you run? I run the 2 query's from lil and i'm getting the same error. Everyone's getting invalid password or id

[Shaiya Xtreme]

Thx works fine i hope we become more SQL files to make a nice Webtemplate.



The only i search is now a working online Shop

Originally Posted by lilprohacker

Hey guys, alot have been asking how to ip ban, so I'm releasing my modified stored procedure. Just open and run both SQL files. Then there should be a new table under user_data called BannedIPs. In there just put the IP you want banned. Thats it.

[AriezOMG]

Thought I should give this a bump do to me reusing it and it's usefulness to the private server community.

[Progrip909]

The IP Banning is fine for the one without common sense and not knowing how to change there IP. I'm curious... Would it be possible to hardware ban? This would be the way to go really assuming it would be possible.

[NocturnalSniper]

possible but a lot of work.

you could make the installer create a unique hardware id for the machine it is installed on and have the server record that when the users connects.

but like i said. lot of work modify ps_login.exe to collect the new data and store it in the database then modify your usp_Try_GameLogin_Taiwan procedure to check for banned hardware id's.

Drawback to that is they can just completely remove all traces of the program so a new hardware ID is created on reinstall. Or just use a different computer to connect and play.

Only way to guarantee blockage is to require a Unique CD key "sent to the user when they sign up for a game account" to be read upon connection to the server.

Could be done but too much trouble.

[lilprohacker]

yes but the way I have the IP ban setup is so when a person logs in under a banned IP it will ban the username that is trying to login. So even if that person tries to login with a different IP or username they will still be blocked.

[Progrip909]

I know on a lot of FPS they Hardware/Mac Ban people this is why I asked. It's way out of my league until I can do some more research and studying xD Thanks for the information though Sniper.

yes but the way I have the IP ban setup is so when a person logs in under a banned IP it will ban the username that is trying to login. So even if that person tries to login with a different IP or username they will still be blocked.

This didn't happen on my server, I IP banned someone they just changed there IP and they were in. Alls they would need to do is change there IP create a new account and all good. There would be no way for them to be detected. There new IP wouldn't be in the bannedIP therefore wouldn't search for the username. Now if they were stupid and tried to create a new account under the same IP or if they tried to switch there IP and used the same account then yes it would apply.

[·Tyler·]

I'm not sure if I'm the only one with this problem, but after tweaking my login procedure to check IP's with the BannedIPs table, it got a little messed up. Every user gets the "Account does not exist" login error, but after you try to login a few times, it magically works. I am not too good with coding, so I kinda rely on the kind people of ElitePvpers to share what they find, but I have not found anyone that has had this problem, or the solution for it. If someone can PM me or even post here for future people to reference from, it would be great. If needed I can upload my procedures so you can look at them.

Thanks
Tyler

[taurian83]

I know a few people had this issue initially. I am not sure if or how they resolved it.

I, however, had had no issue at all. The only advice I can offer, which many seem to do when it seems something just magically starts working, is to be sure that your server is NOT running when you run most queries.

Most will end in error, or they will just screw something up as you are trying to change something that is currently in use.

I know it is not much help, especially if these changes ARE being made while the server is down. But I have noticed that it is a frequent issue that many encounter when they are experiencing issues.

Another issue with this is that many servers, when they first start are manually making accounts. This of course means that numerous accounts have the same IP attached to it. Including the IP of the staff member who created the accounts.

This means if you ban one person, but notice a large number of people are also banned (a major flag here would be a GM being banned), cross reference IP's and be sure that there wasnt any unintentional side effects due to multiple persons having the same IP.

Just some ideas, if neither help, I can give you a copy of my procedure, as it has been tweaked a bit from what Lilpro has released. However, for me, it worked like a charm just as it was before I changed it.

-Syn

[·Tyler·]

Thanks for your response, I will try "reediting" the procedure during maintanence this week, it's probably the reason like you said. I do most of these small fixes while the server is still running, and have seen how SQL can be fixed by simply rerunning the query and changing absolutely nothing. :x I don't like SQL so much. As for the mass ban issue, I have not had this so far, although I have only been using this method for about 2 weeks now, I'll be sure to look into it, and if you could please post your login procedure, I'd appreciate it. I can use it as a cross reference.

Thanks in advance, and also for your quick response, I love this private server community, they give and give, asking for nothing in return.

Thanks again,
Tyler

-Edit-
I fixed the problem by simply turning off the server and instead of using the entire query from post 1, I just added what lilpro posted in his second post to my Login procedure, so far it works. I will post if this didn't solve the problem, as always thanks.