Ok this is for all gms/server admins who want to find out ghost mode hackers. I know this isnt probably the best way to find out a ghost mode hacker but atleast it will help. So yea ghost mode hackers can be really annoying at times and u cant really see them and if you have a populated server then its even harder since there are a lot of characters. So if u see a hacker killing mobs in ghost mode and u cant see their name/click on their name so what can u do?check logs? theres 100s of logs every sec so thats hard to do. So what program can help you with this?
Answer is Query Analyzer.
How so?
Theres couple of ways.
First way lets do a query to check all players in that map. Pretend you saw the ghostmode hacker in DeathLands. Map Index = 63. So lets check all players that are in deathlands.
So in query analyzer type
This Code will show all members that are in map 63, so try following them if there are like 10 characters. But in a populated server there will be 100s of members and you cant chase them all to see if they are online or not.
Second way, check where the ghostmode hacker is killing the mobs. For examploe if the mob is at coordiantes like 68:255
In Query analyzer type in
Execute the query and it will show all members that are in map 63 and are in between those coordinates(every 1 who is in x coordinates higher than 63, and y coordinates lower than 259).
In this way there will be less members. Now chase each one of them and trust me one of them is the hacker and you'll find him as long as hes online. But remember dont do anything stupid while your near him, it will just force him to logout.
Other ways to check if some1 is online or offline is from their usernumber and in user_profile check if they have loginflag = 1100.
Well dont flame if u dont like this way. Simply check it and leave. I just came up with this idea since some in my server were using ghost mode hacks. and how do u know if they are using ghostmode hacks? attacking mobs while invisible. How did u even know a player was there? use /GM distribute to see every1 in a particular map.
I know there are probably a lot of other (better ways) but this works completely fine for me.
Thanks
Naruto820
Answer is Query Analyzer.
How so?
Theres couple of ways.
First way lets do a query to check all players in that map. Pretend you saw the ghostmode hacker in DeathLands. Map Index = 63. So lets check all players that are in deathlands.
So in query analyzer type
Code:
SELECT * FROM character.dbo.user_character WHERE wMapIndex = '63'
Second way, check where the ghostmode hacker is killing the mobs. For examploe if the mob is at coordiantes like 68:255
In Query analyzer type in
Code:
SELECT * FROM character.dbo.user_character WHERE wMapIndex = '63' and wposx > '63' and wposy < '259'
In this way there will be less members. Now chase each one of them and trust me one of them is the hacker and you'll find him as long as hes online. But remember dont do anything stupid while your near him, it will just force him to logout.
Other ways to check if some1 is online or offline is from their usernumber and in user_profile check if they have loginflag = 1100.
Well dont flame if u dont like this way. Simply check it and leave. I just came up with this idea since some in my server were using ghost mode hacks. and how do u know if they are using ghostmode hacks? attacking mobs while invisible. How did u even know a player was there? use /GM distribute to see every1 in a particular map.
I know there are probably a lot of other (better ways) but this works completely fine for me.
Thanks
Naruto820