|
You last visited: Today at 05:57
Advertisement
BIG PROBLEM , PLEASE HELp
Discussion on BIG PROBLEM , PLEASE HELp within the Shaiya Private Server forum part of the Shaiya category.
09/20/2013, 12:44
|
#1
|
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 23
|
BIG PROBLEM , PLEASE HELp
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
|
#2
|
elite*gold: 1
Join Date: Dec 2010
Posts: 33,275
Received Thanks: 5,709
|
Shaiya -> Shaiya Private Server
#moved
|
|
|
09/20/2013, 15:50
|
#3
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
update ps_userdata.dbo.users_master
set status = -5
where userip = '***.***.***'
|
|
|
09/20/2013, 17:40
|
#4
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
|
Quote:
Originally Posted by TeddyBear94
update ps_userdata.dbo.users_master
set status = -5
where userip = '***.***.***'
|
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
|
#5
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
Quote:
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)
|
|
|
09/21/2013, 08:14
|
#6
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,451
|
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 *** 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.'.
|
|
|
09/21/2013, 08:23
|
#7
|
elite*gold: 0
Join Date: Feb 2009
Posts: 192
Received Thanks: 151
|
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
|
#8
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
my bad i was miss reading that he was looking for an ip range ban
|
|
|
09/21/2013, 20:09
|
#9
|
elite*gold: 0
Join Date: Dec 2012
Posts: 128
Received Thanks: 23
|
Ty guys for solutions
|
|
|
09/21/2013, 23:44
|
#10
|
elite*gold: 1
Join Date: Dec 2010
Posts: 33,275
Received Thanks: 5,709
|
#closed
Quote:
Originally Posted by Gamer #
Ty guys for solutions
|
There is a "
" button for this.
|
|
|
All times are GMT +2. The time now is 05:57.
|
|