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