Banned I.P.'s?
 

how do you find an i.p. on a player when not ingame? I looked thru the hackers table in the db and find people using the MQwarp alot, now i have the rules set to locate and find peeps using this cheat, but i'm unable to locate any of their i.p.'s in the db, im not using a mini login, but the eqemu login.

So is there any way of tracking the i.p's or is there a sql that I could run to add the players i.p's to the database for easy finding?

Doc

Have a peak at this thread, it may help to answer your questions. look for Lillu's Post there.Not sure if this was not clear enough of an answer the frist time or maybe looking for a better answer?

sorry for the double post on this subject:) been a long week and forgot i posted this earlier, and was looking for a better way, but this will work. I confronted a player the other day about this subject, and he told me he was targeting a npc from across the zone and then would warp to it and kill it. so this tells me he was using the cheat, but like travis stated in my other post, should take it with a grain of salt if thats all their doing, but still getting too many zone crashes and if they are not doing it by using cheats, then unsure why the zones keep crashing.

not sure if this is the problem or not:
Doc

If he admitted to warping, then that is definitely cheating as far as most servers are concerned lol. When I said "take it with a grain of salt" I meant when you are reading the entries in the hackers table as they don't always mean that someone is hacking. If the player admitted openly to warping, then you don't need the hackers table to prove anything :P Maybe somehow the new anti-hack stuff is crashing your zones when players actually do try to warp. If I was you, I would ban the hacker and see if it stops.

As for the IP, that is still something I would like to see added to the accounts table at some point. I still need to test the code submission to add it and see if that works properly.

well Ive add this to the tables:
ALTER TABLE `account` ADD `lastip` VARCHAR(15) NULL ;

and now i need to find which cpp file to add a statment like
the logon-code to look up the update accounts-line and add IP to that line so the table see's it. Do you have any clue which one i need to add this too, I want to test this for you and see if it will work.

Doc

Added IP Logging to latest SVN.

thats great, but now when i build the project i keep getting this error and i've never had this error before

1>e:\eqemu\eqemuserver\zone\embperl.h(20) : fatal error C1083: Cannot open include file: 'EXTERN.h': No such file or directory
1>embparser.cpp
1>e:\eqemu\eqemuserver\zone\embperl.h(20) : fatal error C1083: Cannot open include file: 'EXTERN.h': No such file or directory
1>effects.cpp
1>doors.cpp
1>command.cpp
1>e:\eqemu\eqemuserver\zone\embperl.h(20) : fatal error C1083: Cannot open include file: 'EXTERN.h': No such file or directory
1>client_process.cpp
1>client_packet.cpp
1>Build log was saved at "file://e:\eqemu\EQEmuServer\zone\ReleaseBots\BuildLog.htm "
1>Zone - 25 error(s), 2 warning(s)

ok I found the compiling issue, forgot i redid peril and had to redo the include file info, working great now

Duh lol