BIG PROBLEM , PLEASE HELp

[Gamer #]

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

[Autrux]

#moved

[TeddyBear94]

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

[nubness]

Originally Posted by TeddyBear94

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

More like:

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.

[TeddyBear94]

Originally Posted by TeddyBear94

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

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 *** with the ip nothing to dicuss about that)

[nubness]

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 *** with the ip nothing to dicuss about that)

As much as it looks like it, I'm not trying to be an *******. 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.'.

[GM.Triest]

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"

[TeddyBear94]

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

[Gamer #]

Ty guys for solutions

[Autrux]

#closed

Originally Posted by Gamer #

Ty guys for solutions

There is a " " button for this.