New tool - SERVERSTATS

**TheLieka** · #1 11-10-2007, 10:35 AM

Thanks George. I just installed the new build on my dev server (Windows Server 2003 R2 SP2) and it needed mscomct2.ocx. Again, I just downloaded and registered it.

Dax

**GeorgeS** · #2 11-10-2007, 12:34 PM

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 · #3 11-11-2007, 02:19 AM

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** · #4 11-12-2007, 04:36 PM

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** · #5 11-12-2007, 07:01 PM

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** · #6 11-12-2007, 07:11 PM

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

**TheLieka** · #7 11-14-2007, 07:46 AM

Quote:

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 · #8 11-14-2007, 11:26 AM

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.

Aramid · #9 11-12-2007, 10:45 PM

Quote:

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

 <a href="quest.zip"><img border="0" src="graphics/folder_Item.gif" width="39" height="35"></a>

ServerStats 1.1c , Latest
11/13/07  - This tool is for server admin for
monitoring server activity and modifying accounts,toons,
and loot. 
       &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 

       &nbsp ; their account activity. 

Here is the correct line for quest.zip

 <a href="quest.zip"><img border="0" src="graphics/folder_Item.gif" width="39" height="35"></a>
Everquest Perl Quest
Editor 1.1.4 , Latest 11/9/07 (updated quests) 
       &nbsp ; Ever
wanted to create NPC quests easiiy?

**GeorgeS** · #10 11-13-2007, 03:12 AM

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 · #11 11-13-2007, 10:18 PM

Quote:

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!!!