[Request]Searching for a specific log

Hey guys,

I am looking for a log that states when a account has been logged on and from what IP it is logging on from.

If anyone could help me out with that. It would be wonderful.

Also, Is there a table with every item on it. Instead of just the charitem and userstored? So it would show the exact make time and perhaps the where about of that item.

Login status should be in PS_UserData.dbo.UserLoginLog or in PS_GameLog.dbo.ActionLog. You will find info about created items in PS_GameLog.dbo.ActionLog.

Thanks Prof. I see that the Action log has the IP in it, but my loginlog is completely empty, Which would be better since it doesn't have every piece of info in it. Is there a modification i need to make for it to start to fill out?

Also, is there any way to sort the action log by userUID? or anything other then row ID, it gives me an error when i try to sort it any other way.

thanks again. I will start looking through all this crap :)

Haven't been working on that. Instead of checking who's online by UserUID you can check PS_GameData.dbo.Chars. It has two fields - JoinDate and LeaveDate - which tell you when the character last logedin and when did it leave game.

I dont need the last time they logged on i need the complete list of when they logged on and when they logged off with the IP they where logging from :)

then you will need a freeware called "IP stalker." im sure you already have it DL though.

so just put there ip in it and stalk away!!!!

-joke post before people assume that such a software is real.-

Bane Stop trolling on my post and filling it with crap.