New tool - SERVERSTATS

[GeorgeS]

Ok regarding that 3001 error message some are getting -
I've installed mysql 5.x and the latest peq db. Still I get no error. So it's not to do with that.

What is possible is either the 'character_' or accounts table - if someone would send me their tables in sql format, it will eliminate some possibilities.

Those who's accounts load ok, let me know as well.

GeorgeS

[Aramid]

George,

Just a note, as of the past few days, on your web page for all the great utilities, your link to the ServerStats 1.1b Util is pointing to the Quest Util link.

[GeorgeS]

lol, I am constantly being told this, and the server always loaded serverstats.zip for me. Even the page source was correct, but that was from withinn the local network. Soo, I rebooted the server and now you have to tell me if it's working ok.
Most bizaar.

George

[GeorgeS]

Good news. I loaded all 6000+ accounts from the abyss server db, and got the error! It was caused by missing profile blobs. For whatever reason, this can happen, and the program will now check for this and also suspicious level 0's (which you have the option to delete). Any character with a ??? in any field is presumed bad.

I'm adding the new version online now



When loading any data into the grid, you can sort any field. Just FYI. To monitor a toon's activity, you must first load accounts then select the toon's to add to the watch list
GeorgeS

[GeorgeS]

I forgot to mention -
When loading any data into the grid, you can sort any field. Just FYI. To monitor a toon's activity, you must first load accounts then select the toon's to add to the watch list
When copying a toon, select the toon (this places it into a buffer) then select a new owner (character owner) then click on paste toon. If you select the same owner, you get a duplicated toon with a same/appended name. Thus you can copy toon from one account to another (aka migration)... (the toon, his inventory, coin,aa's (everything in profile) and factions are moved too!)

GeorgeS

[Aramid]

Originally Posted by GeorgeS

lol, I am constantly being told this, and the server always loaded serverstats.zip for me. Even the page source was correct, but that was from withinn the local network. Soo, I rebooted the server and now you have to tell me if it's working ok.
Most bizaar.

George

George,

Still doing it, even after reloading the page. Here is what I get when viewing your page source of your download page from outside...

This should be serverstats.zip but it shows quest.zip

</font></font>&nbsp;<a href="quest.zip"><img border="0" src="graphics/folder_Item.gif" width="39" height="35"></a>
<b>
<font color="#FF0000" face="Tahoma">ServerStats 1.1c</font></b><font color="#FFFFFF" face="Tahoma"> , Latest
11/13/07&nbsp; - This tool is for server admin for
monitoring server activity and modifying accounts,toons,
and loot.<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ; It also serves as a general
tool for checking what NPC drops what and where, and
modifying loot for NPC's. You can fix stuck toons in
zones, monitor<br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ; their account activity. <br>

Here is the correct line for quest.zip
</font>
&nbsp;<a href="quest.zip"><img border="0" src="graphics/folder_Item.gif" width="39" height="35"></a>
<font color="#FFFFFF" face="Tahoma">Everquest Perl Quest
Editor 1.1.4 , Latest 11/9/07 (updated quests)<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ; Ever
wanted to create NPC quests easiiy?<br>
</font>

[GeorgeS]

Thanks Aramid,

That helped me fix the problem. I reset the link from the webpage. Somehow the old link did not save, but should work now. Sorry for the confusion.


GeorgeS

[Aramid]

Originally Posted by GeorgeS

Thanks Aramid,

That helped me fix the problem. I reset the link from the webpage. Somehow the old link did not save, but should work now. Sorry for the confusion.


GeorgeS

Yep, working fine now George.

Once again, Thanks for all your great EQEmu tools!!!

[TheLieka]

Originally Posted by GeorgeS

Good news. I loaded all 6000+ accounts from the abyss server db, and got the error! It was caused by missing profile blobs. For whatever reason, this can happen, and the program will now check for this and also suspicious level 0's (which you have the option to delete). Any character with a ??? in any field is presumed bad.

I'm adding the new version online now



When loading any data into the grid, you can sort any field. Just FYI. To monitor a toon's activity, you must first load accounts then select the toon's to add to the watch list
GeorgeS

Wooot! Downloading it now! I'm giddy!

Dax

[John Adams]

GeorgeS, not sure if you know this, but I think those suspicious level 0's are toons that have never fully logged after creation. That's how they appear in my character_ table anyway. I think they are missing their race too, if memory serves.

[GeorgeS]

Well sorta figured it out last night - but anyway the option is still there to get rid of those unplayed characters. Also, no Blob data may exist which means no race either

GeorgeS

[TheLieka]

I've been using this tool a lot lately, and I am very impressed. This is yet another great contribution. Thanks again George!

Dax

[GeorgeS]

I'ts great people like the tool. Since there's no help file, does this program need one, or is it pretty straight fwd to figure it all out?

...the monitoring tool is pretty fun to look at as characters are updating their levels and coin!

GeorgeS

[TheLieka]

I think it's pretty straight forward, no need for a help file. I know it sounds goofy, but I have gotten a lot of use out of the "reference" sections as well.

Dax

[TheLieka]

I love this tool George, I use it all the time. How hard would it be to make it possible to view / modify / search the contents of player corpses?

That would be really nice.

Dax