New tool - SERVERSTATS

**GeorgeS** · #1 10-09-2007, 02:58 AM

This new tool is being coded and will allow a server admin to check things like -

/1/ User accounts and details
/2/ Items dropped per zone
/3/ Items owned by users
/4/ NPC's in each zone
/5/ Coins owned by users
/6/ Change User's server privelages
/7/ Summary of who used what #emu commands

...

Since this is an extensible tool, it will allow one to add more queries.

Since this is early in the dev stage for the program, I am asking for more queries that you want added.

This will be a straight forward reporting tool, with limited write back to db functionality.

GeorgeS

**GeorgeS** · #2 10-09-2007, 01:31 PM

Update -

I also am adding a polling tool to show a line graph of selected accounts/characters with plots of level and pp over time. So if there's a character who went from 1-60 in a day, you will know.

The tool will poll LOGS and parse their contents so you will have a snapshot of who used what GM commands.

You will also be able to change GM status, class,race, delete accounts and so on.

...change what zones are bootable, see how many players are on and where they are playing...

GeorgeS

Amra · #3 10-09-2007, 02:46 PM

Sounds awesome, George. Can't wait =)

Theeper · #4 10-10-2007, 05:32 AM

George, are you coding this into the worldUI, or it's going to be a standalone thing ?

rojadruid · #5 10-10-2007, 03:40 PM

Quote:

Originally Posted by Theeper

George, are you coding this into the worldUI, or it's going to be a standalone thing ?

it would be really nice if it was coded into the worldui. but we can only hope.

there have been a couple of good utils latley the people seem determined to code outside of the worldui.

**GeorgeS** · #6 10-12-2007, 01:28 PM

I have decided not to integrate it to the emu directly, but I did consider it. I was going to add a special #command. This tool will attempt to minimize sql server resources, but certain sql commands should be run sparingly - for example running the script that returns all items dropped in a zone.

Ok, so I looked at the cpp profile struct and managed to decode everything there. I'm doing the coding right now on the accounts admin part and should have a read only version ready in a few days.

So far it's going well and looking good.

GeorgeS

gernblan · #7 10-12-2007, 06:07 PM

Allowing it to view and edit player coin would be a GODSEND.

Thank you, so much for doing this tool, I just know that it's going to be awesome!

**GeorgeS** · #8 10-12-2007, 07:46 PM

Ok, the read/only part of the tool is done, including viewing/sorting all player owned coin and banked coins too - these and many other parts of the binary struct data are going to be read/write too.

GeorgeS

**AndMetal** · #9 10-16-2007, 08:39 PM

Out of curiosity, what are you using to create this?

I ask because I have created a script to convert the entire profile into a multi-dimensional array in PHP (about 14KB worth of code). It was a pain in the butt for me, so I would hate to see others go through the same thing.

On a side note, I have been thinking about how to edit the profile field, but the checksum is confusing me, mainly because it doesn't match what crc32() in PHP calculates it to. But then again, I've kinda put that one on the back burner.

John Adams · #10 10-17-2007, 10:51 AM

GeorgeS, I think roja was talking about the perl/html Emu Management scripts that come with the emulator world. Those pages haven't seen a pixel change in the year I've been here - though I have customized quite a few for my own purposes (and soon as I get time to clean up my slop, I hope to share them back to the core devs).

Is it possible to do this kind of editor/viewer in the perl/html?

**TheLieka** · #11 10-17-2007, 03:14 PM

George... I love you. I can't wait for this.

Dax

**GeorgeS** · #12 10-18-2007, 02:30 AM

The tool will not be a comprehensive profile editor, just a few selected byte values like last name, coins etc..

Actually I'm using VB, and to convert the entire profile blob came from an idea where I pulled the blob from the database and saved it to a binary file. The file is NOT loaded into memory, but accessed by a byte pointer. Then edited values are saved and the binary file dumped back to the DB.
Actually it's easy.

The tool does much more editing, but account management is a small portion of it's purpose. You can copy toons from one account to another, and even delete and modify toon data stored in the character_ table.

Right now you can
- find out what items drop in a zone by NPC (done)
- Identify if an item drops or is sold or player made (done)
- view NPC in a zone by level/min max/avg levels,spawngroup (done)
- account profile and character editing (as discussed before) (1/2 done)
- modify loot drops by selected npc's (not done)
- tag/poll/monitor accounts for suspicious behaviour (not done)
- view/parse #commands by users (log file parser) - (not done)
- more as time permits..

GeorgeS

gernblan · #13 10-22-2007, 03:48 AM

Quote:

Originally Posted by GeorgeS

Ok, the read/only part of the tool is done, including viewing/sorting all player owned coin and banked coins too - these and many other parts of the binary struct data are going to be read/write too.

GeorgeS

WOOT!!!!!!!!

/bows

gernblan · #14 10-22-2007, 03:48 AM

Quote:

Originally Posted by AndMetal

Out of curiosity, what are you using to create this?

I ask because I have created a script to convert the entire profile into a multi-dimensional array in PHP (about 14KB worth of code). It was a pain in the butt for me, so I would hate to see others go through the same thing.

On a side note, I have been thinking about how to edit the profile field, but the checksum is confusing me, mainly because it doesn't match what crc32() in PHP calculates it to. But then again, I've kinda put that one on the back burner.

PLEASE, can you post this?

It would be invaluable.

**TheLieka** · #15 10-22-2007, 02:59 PM

*chomps at bit*

Dax