PDA

View Full Version : EQEmuJSM - A cross platform server management utility


cubber
09-12-2010, 09:23 PM
Here is a little something I have been working on for the past week. I am trying to really get a good handle on java and decided to build a cross platform server management utility.

It is far from complete and still has a few features that I need to complete, as well as some aesthetic fixes. However I am releasing an Alpha testing version to the community to get some feedback, as well as feature requests.

Please note that this utility relies heavily on the telnet server built into EQEmu, and provides a GUI interface to ALL of the telnet commands available. I have separated the commands into drop down menus, some commands are pure SQL driven as well, and I am still working on a few them. An alert will tell you if the command is in the works.


What Works Now:

- All Telnet Commands
- A couple of SQL select commands (list guilds, list petitions)


Coming Soon:

- Account management SQL queries
- Guild management SQL queries
- Graphical fixes
- Move the console window into the output frame in the program. ( this one eludes me so far! )
- Help Docs


Prereqs:

- Must have telnet connection open with an account setup.

- Must have a MySQL connection with the same username and password as the telnet connection. Give this account the ability to change things in the db as well. The program will eventually be able to add/delete things like guilds, accounts, petitions and such.

- Must have a Java JRE or JDK installed to run the EQEmuJSM.jar file (progam is developed on sun jdk ver 1.6.0.20 under Gentoo Linux)

- Before any command will work you need to connect to the server in the interface.


Known Bugs:

- Text box resizing is terrible
- Need to move the separate console window into the main application
- You need to connect to a server! Alert pops up at the wrong time sometimes.


You can get the latest version here:

http://code.google.com/p/cubbers-eqemu-utils/downloads/list

the file is called EQEmuJSM.jar

Download it and run it with the following command:

java -jar EQEmuJSM.jar


I will be putting the source code up on the google code page under subversion once the project is further along. If any devs want to view it before then feel free to PM me and I will provide you with a tarball.


I look forward to some feedback!

cubber
10-02-2010, 12:57 PM
Wow! 82 views and no feedback...

Anyway, I just posted an update on my googlecode page as well as added the source code for the project to my svn repo there. The new version is Alpha 0.0.2 and it fixes the unnecessary "You have to connect first" popup. I reworked the code so that is only displayed when appropriate rather than after every button push when the server is not connected.

Get the new version here:

http://code.google.com/p/cubbers-eqemu-utils/downloads/list

to run it use the same command

java -jar EQEmuJSM_Rev_Alpha_0.0.2.jar


If you wish to pull down my source code you can do so by following the directions here:

http://code.google.com/p/cubbers-eqemu-utils/source/checkout

If you want just the EQEmuJSM folder use this command

svn checkout http://cubbers-eqemu-utils.googlecode.com/svn/trunk/EQEmuJSM EQEMuJSM_Read_Only

Note: I am using Eclipse to develop this, and the project's source is setup as such.

Enjoy!

cubber
10-02-2010, 01:09 PM
Since a picture is worth a thousand words

http://img545.imageshack.us/f/screenshotsm.png/

http://img545.imageshack.us/img545/2535/screenshotsm.png (http://img545.imageshack.us/i/screenshotsm.png/)

Note: I am still working on getting the "Java Console Window" to display in the Output: area of the program rather than in a separate window. If anyone reviews my source and has a fix for this I am open to suggestions.

Akkadius
10-02-2010, 02:34 PM
Since a picture is worth a thousand words

http://img545.imageshack.us/f/screenshotsm.png/

http://img545.imageshack.us/img545/2535/screenshotsm.png (http://img545.imageshack.us/i/screenshotsm.png/)

Note: I am still working on getting the "Java Console Window" to display in the Output: area of the program rather than in a separate window. If anyone reviews my source and has a fix for this I am open to suggestions.

I am afraid you will have to sell this to people Cubber, not that your work isn't bad at all. There's many tools out there as it is. You will just have to keep posting pics etc and showing what is going on.

Looks great BTW, look forward to seeing its progress.

cubber
10-02-2010, 03:00 PM
Thanks Akkadius,

I am mostly developing this to improve my Java skills.

cubber
10-22-2011, 04:45 PM
I know its been about a year but I finally got some time to update this. I have added all of the MySQL functionality to the program. The latest version can be downloaded here:

http://code.google.com/p/cubbers-eqemu-utils/downloads/list

You can also get the latest source code by doing:

svn checkout http://cubbers-eqemu-utils.googlecode.com/svn/trunk/ cubbers-eqemu-utils-read-only

Just a reminder the project was built in eclipse and the source is setup as such.

##############
#NEW FEATURES
##############

All SQL Commands are now functioning.

Account Menu:

Add Account (uses tblLoginServerAccounts)
Delete Account (uses tblLoginServerAccounts)
Change Password (uses tblLoginServerAccounts)
List Accounts (uses account table)


Character Menu:

Move Character (Character you are moving must be offline)
List Characters
Character Inventory (Lists specified character's inventory)
List Bots (Lists all bots on the server with Owner name)


Guilds Menu:

Create Guild
Delete Guild
List Guilds


Enjoy!