I've updated it again:

Fixed code that was killing zones that were not really hung
Log will now report that it is tracking a hung zone and the pid of the zone. Check against task manager to make sure it's at 49%+ cpu usage. if it drops back down to 0, log should report 'zone appears to have returned to normal.' and no longer track the hung zone.

When minimized it will sit in the system tray, until you click on the system tray icon.

Added an icon to make it look prettier.

Links: source and win32 binaries

good job on this so far have not had any probs getting new code now.. but i would say it has been a god send so far. still not liking it broadcasting 2 times but its just a minor annoyance nothing big.

ill try the new code after the next reset on my server. thanks for all the work you have put into this..

also i don't know what happened but it seams earlier today the program itself crashed after broadcasting 30 mins till rest i did not see it happen but the program was closed no error window or anything.. best i could figure it crashed and closed the error window right before it closed :P is that even possible?

would it be doable for it to reopen itself if it crashes? im guessing no becuase the program is closed on crash but was a thought.. anyways ill give the new code a try

you posted the link wronge its pointing to (:82) http port 82 i was able to get them changeing the page that poped ups address but may want to change that :P

it should be port 82 - and i'm pretty sure my links have always been port 82. If it works both ways, that's ok - i have apache and iis running on the same machine for different reasons.

I made some minor tweaks to the code and also added tabs to be able to view, add, edit and delete Rule_Sets, Rule_Values, and Variables

Links: source and win32 binaries

make sure you edit the options to log into your mysql database.
If you want to compile the source, you'll need MySQL Connector.Net 5.1.6

Damn 5 minute rule!

Important Note: The program will not load the variables tab if there is invalid data in the variables table. If it pops up with a message saying it didn't load - follow the directions.

You'll need to manually edit the variables table and change all values in the ts column from '0000-00-00 00:00:00' to a valid timestamp (ie 2008-06-18 08:50:00)

Ok another update

* It should only broadcast once.
* It should actually hide itself when you minimize it. clicking on the icon in the tray will unhide it.
* version number displayed in the titlebar
* i re-did the way rule_sets, rule_values and variables are edited

let me know if there are any problems!

Links: source and win32 binaries

make sure you edit the options to log into your mysql database.
If you want to compile the source, you'll need MySQL Connector.Net 5.1.6

im not seeing anything in the server rules tab and only seeing 2 variables in the server variables tab..

just thought you would like to know.. any more info you need let me know.

Hmmm.... try re-downloading it and running the new version (1.0.0.3)
also check that you have info in your rule_sets, rule_values and variables tables.

nope got new version still same thing.. does it matter that i use peq db? ill look at the code later today see if i dont see whats up. but im sure you will find the problem.. and yes the tables have info in them

btw dont think i told you yet this is a really nice program you have done a great job thus far.

Thanks!

I'm using the peq db too - but if i'm not mistaken peq and angelox's are the same format (ie table structure is the same), just differ on content.

that's strange. i've been running it on mine and it runs and loads fine.
I've been running it on the same machine that my eq server is running on and sql server is on.

are you using 'root' in the settings to log into the mysql server?

Added an option to load the old log at startup

added some code to give feedback when there's connection/db errors that should help you trace the problem.

Also, changing settings when the program is running will take effect immediately.

Links: source and win32 binaries

make sure you edit the options to log into your mysql database.
If you want to compile the source, you'll need MySQL Connector.Net 5.1.6

yep using it on the same server as my server/db
it is connecting becuase it sees 2 peases of info from the vers table but nothing else.

i do not use root as the user for security but i am useing a valid account that has read write access..

ill give the new ver a try when the server resets next.

nope still only reading 2 server variables and no server rules.

and i skimmed the code and did not see nothing wrong with the database stuff. it did not give any connection errors in the log.

ill give it a better look when i get some time.

Just for shins & grins - try using root and see what happens. there may be some permission problems - i developed this using root access when i created the connection string

Ok, added code to make any db errors extremely verbose, and write those errors to the log (along with popup msg's)

Fixed a problem where the displayed log was getting cleared on load, rather than displayed if the 'Load old log' option was checked.

Links: source and win32 binaries

make sure you edit the options to log into your mysql database.
If you want to compile the source, you'll need MySQL Connector.Net 5.1.6

Spider661, any luck? Try this version (1.0.0.6), and pm me the log (make sure you edit out your passwords =) ) Maybe I can make heads or tails of it.

Update:

* Added a 'broadcast now' button to allow custom msg's to be broadcast at any time.
* Last broadcast message will be saved for when the program is restarted.
* All msgs's broadcast are written to the log
* Any and all error messages should be written to the log.

Links: source and win32 binaries

make sure you edit the options to log into your mysql database.
If you want to compile the source, you'll need MySQL Connector.Net 5.1.6

still no go on them tables i tryed root and the root password but says user cant connect i think its because i have it set to local host only and its connecting useing my local ip and not localhost. not sure but anyways its seems to not be able to access the account even if i am loaded on the same computer. with my normal user name it connects and reads 2 server variables only.. and only thing in the log file is this

i changed root so that it can be accessed from other then localhost and it connected fine but still same thing useing root user

log

Hmm, I'd bet there are some permissions set on mysql that's causing problems, but if it loads 1 or 2 items from the db, then it should be working....
Do you have a vb.net 2005 compiler?

yes i have vs2005

You might want to try debugging the code in the
LoadRuleSets,
LoadVariables,
LoadRuleValues
subs - see if you come up with any errors or information there.
You might need to comment out the "<System.Diagnostics.DebuggerStepThrough()> _" in MySQLTransDB.vb so the debugger doesn't skip over them.

i've been running the latest ver on 3 different machines, local, remote (same network) and remote (outside the lan) and have had no problems yet.

let me know if you need help - sorry this has been giving you trouble =/

btw - are you using Vista or XP?

im using xp pro and dont worry about it man.. if the tables do not list right thats fine i was ok with the restarted before you added the database stuff. i don't really need to know what info is set there its all listed on my site. its a great program im not worried about some database strings not working that i don't really need anyways.

but if i get some time ill debug it like you say encase others do have the same prob.

Cool - I just hate when something I build doesn't work right =)

let me know if you have any more probs with broadcasting or rebooting!

Cheers!

Updated links, heard they were broken

Source:
http://70.183.172.217/EQTools/EQEmuTools.rar
Binaries:
http://70.183.172.217/EQTools/Release.rar

hey is there a way to port this to Linux?

i love the program but im having problems on windows so with the server upgrade im moving to Linux and would like to use a program like this still..

is there anything we can do?

i'm not sure how compiling the code directly in linux would work - as it's based off the .net 2.0 framework. i suppose it could be a command line driven program - but i have no idea where to begin.

the source is freely available if someone wants to tinker with it.

I'd like to share with the community an app I've been working on for a while.

It's still in the Beta phase and I'm sure has a few bugs here and there. Feedback is appreciated and welcome! I've been running it on my server for about a week and haven't had any problems.

I tried to capture all possible errors and have it write to error.log. PM me the contents of that file and I'll see what's what.

What it does:
Monitor:
* Monitor your server (running processes & uptime)
* Start & stop your server with the push of a button (entire server or parts)
* Auto close crash windows, auto kill hung applications (not only server components)
* Automatically load all launchers found and launch the one(s) selected
* Auto restart server on an interval
Maintenance:
* Update source (and source db) from SVN
* Update PEQ Database from SVN
* Update PEQ Quests from SVN
* Update Maps from SVN
* Update local database when update found (SVN & PEQ)
* Compile new binaries when update found
* Upgrade server binaries and *.conf
* Backup database

Coming:
AXClassic support
Other SVN compatibility (upon request)

S/W Requirements:
TortoiseSVN to update from the SVN
Visual Studio (2005 or 2008) to compile
MySQL to connect to the database

Installation:
Unrar to any folder. Must be on local emu server machine to monitor / stop/start processes.


Download

Updated ServerTender... (download)

* can now run SQL and/or Batch file before db update and after.
* backup batch file included to backup all bot info, all character info, rules, variables, etc. modify to suit your needs or add your own customizations.
* backup sql file included to re-source last backup after update
* added option to update player & bot tables on full PEQ update
* properly updates db_version and core_version in the database
* monitor log files generated by running world, zone(s), chat & mail server
* hide / show the server windows
* starts world.exe with processor affinity on core '0' to help with multi-core issues.
* view the built in eqemu admin website
* miscellaneous tweaks and timer fixes

no need to overwrite your settings.conf file (makes it easier to not have to re-set all options.)

Updated ServerTender...v1.0.0.1 Beta (download)

* Edit rules and variables on the fly. (server restart for changes to take effect)
* Edit your config on the fly. (server restart for changes to take effect)
* Dump your entire database to a single file.

Updated ServerTender...v1.0.0.1 Beta (download)

* Broadcast now enabled
* added option to source player tables on full PEQ update

anyone know if there is an updated version of this? I get an unhandled exception when starting eqlaunch. this seems like a really good program, and would like to try it on my server. any help would be appreciated.

can you pm me any more info? debug logs, detailed error info, peq rev, os, etc? i'll look into it as soon as i can.

this is the error I get when I hit start world. world comes up, but eqlaunch doesn't. also it gives me errors on the first page when you try to broadcast anything.
EDIT:: oh and just double clicking on the executable gives me an "error initializing" box, but no debug info for that.

binary rev:972

peq DB rev:31

windows server 2008 enterprise

AMD opteron 8350 Barcelona 2.0 quad core x 4
16 gb ram

I'd like to look at the source, if it is still available.

@Sylaei: I'll post the link for the source tomorrow. (its for the old rev), i'll post a link for the new rev too.

@nightsta69: i'll look into it asap and let you know.

@Nightsta69 - it looks like you have some variable un-defined in your options.

delete the file 'settings.conf' and run the app again, re-define the settings.
there should be files 'database.log' and 'error.log' in the folder - they will help me out more if you can send them to me.

As promised

Sources:

Old version

New Version

Re The broadcast error:

1) your eqemu_config.xml must have this line enabled:

2) the port in the ServerTender config needs to be 9000 (or whatever you use in step 1)

3) your username and password need to be the same as what you use to view the http management page (defined in your account table).

error.log
database.log
settings.conf
here are the files requested. this is after I redid the settings, making sure to fill in everything that was requested to be filled in. hope it helps, really want this working.

sorry for second post, it wouldn't let me edit. here is another dump of the error.log. I tried what you said for the broadcasting, and it still gets an error when tryin to broadcast. plus I noticed it was having a problem looking for peq.core_version table. I don't have a core_version table, but I do have a db_version table. maybe peq changed it? Idk, but my 2 cents on that.

error.log