BIG PROBLEM , PLEASE HELp

09/20/2013 12:44 Gamer ##1

Hey everyone , i get 1 problem in my server . Someone hit 30k and i don't know how , and last problem is how i can ban 1 class of ip , example : 166.155

I need fast reply please

09/20/2013 15:38 Autrux#2

#moved

09/20/2013 15:50 TeddyBear94#3

update ps_userdata.dbo.users_master
set status = -5
where userip = 'xxx.xxx.xxx'

09/20/2013 17:40 nubness#4

Quote:

Originally Posted by TeddyBear94

update ps_userdata.dbo.users_master
set status = -5
where userip = 'xxx.xxx.xxx'

More like:

Code:

USE PS_UserData
UPDATE Users_Master
SET Status = -5
WHERE UserIp LIKE '166.155.%'

And it's still not the best solution, as it's a manual thing. Never been a ban hammer admin, so I can't tell you anything better than that. Google it up on restricting an IP range in Windows.

09/20/2013 23:34 TeddyBear94#5

Quote:

Originally Posted by TeddyBear94

update ps_userdata.dbo.users_master
set status = -5
where userip = 'xxx.xxx.xxx'

this works propper aswell chris ur one is just a bit more splitted. if u dont believe me u can try it urself
Edit : (ofc u have to replace the xxx with the ip nothing to dicuss about that)

09/21/2013 08:14 nubness#6

Quote:

Originally Posted by TeddyBear94

this works propper aswell chris ur one is just a bit more splitted. if u dont believe me u can try it urself
Edit : (ofc u have to replace the xxx with the ip nothing to dicuss about that)

As much as it looks like it, I'm not trying to be an asshole. My code clearly says LIKE, not =, but LIKE, which means your way includes only the rows having the one IP you specify, while my result set will contain all the rows having IPs starting with '166.155.'.

09/21/2013 08:23 GM.Triest#7

Actually, Teddy, your script is looking for the IP you set on the code, while Chris' code is looking for an IP similar to the one on his code.
For example, your code will look for IP '1.1.1' Exactly how it is written, whereas Chris' code looks for an IP similar to '1.1.1' which will, and might find IPs = '1.1.1.2, 1.1.1.3, 1.1.1.4, 1.1.1.5"

09/21/2013 11:11 TeddyBear94#8

my bad i was miss reading that he was looking for an ip range ban

09/21/2013 20:09 Gamer ##9

Ty guys for solutions

09/21/2013 23:44 Autrux#10

#closed

Quote:

Originally Posted by Gamer #

Ty guys for solutions

There is a "[Only registered and activated users can see links. Click Here To Register...]" button for this. ;)