New tool - SERVERSTATS

[rojadruid]

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]

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]

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]

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]

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]

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]

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

Dax

[gernblan]

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]

*chomps at bit*

Dax

[AndMetal]

Originally Posted by gernblan

PLEASE, can you post this?

It would be invaluable.

I just created an entry in the Wiki: ConvertProfile

I commented out all of the unknown fields, but did add in the "code" to read them into the array.

I would also like to note that you will need to add in a value for the $db variable, which allows the connection to the database (I use another included file that stores the db login info for all of the pages I use).

[gernblan]

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