[Release]EoAdminPanel2

Page 1 of 3 1 23
09/10/2010 18:32 King_Arthur#1
EoAdminPanel2 Current version: v1.0.1

This tool is made for PMs, GMs and others with some form of database access to do common game/user management tasks without mysql knowledge.

Features:
  • Adapts to different account table locations (separate account db, my, and my2)
  • Remember Me saves server IP, username, and account table location.
  • Botjail/Unjail characters. Now with a timer!
  • Ban and unban users by either character name or account name. Now with a timer!
  • Award EPs, PPs, and VIP. Awarding VIP will show current VIP level before changing.
  • View a Botjail list and a Ban list.
  • EoAdminServices will automaticlly start checking bans/botjails when executed (use "Remember me")

[Only registered and activated users can see links. Click Here To Register...]

Please post any bugs to this thread or to the issue tracker and remember that this is a BETA product made by me and further development/bug-fixing by me will be done passively. Also note that I am not an active EO Pserver Developer and thus will not have lots of ideas. Recommendations are welcome and greatly needed for further development.

Requires .NETFramework 2.0

By clicking this spoiler and downloading this program you recognize that this is a beta version and that some menus and buttons that are coded may not be available.

Changelog
Code:
v1.0.1 - EoAdminServices now starts checking bans/botjails upon execution when "Remember me" is checked.

v1.0 - Added EoAdminServices for timer functionality on bans/botjails.

v0.4 - Initial C# Release
Source Code available [Only registered and activated users can see links. Click Here To Register...] with detailed changlog.
Solution made in VS2010 using the C# Language.

Inspired by: [Only registered and activated users can see links. Click Here To Register...]
VB (Depreciated) Version: [Only registered and activated users can see links. Click Here To Register...]
09/10/2010 18:39 austinian#2
You made EoAdminPanel before. What is new in EoAdminPanel2?
09/10/2010 18:40 King_Arthur#3
Quote:
Originally Posted by austinian View Post
You made EoAdminPanel before. What is new in EoAdminPanel2?
Thank you for asking! EoAdminPanel2 may contain a lot of the features from the old panel, but it is vastly different.

Two of the major changes in EoAdminPanel2 are licensing and programming language:
  • EoAdminPanel2 is licensed under [Only registered and activated users can see links. Click Here To Register...]. As such, it is compliant for use with the mysql .net connector dll used in this program.
  • The old EoAdminPanel1 was written in Visual Basic and very poorly I might add. EoPanel2 is coded in C# using Visual Studio 2010. While the interface may be very familiar, all VB code has been completely rewritten in C#. The new code is written with expandability in mind.
    It also should take a less of a toll on the mysql server. Previously EoPanel1 made a new connection for each SQL statement. EoPanel2, on the other hand, will reuse the same connection at login to do run all SQL statements until the user either logs out or exits. This should make for much better-looking mysql logs if you use them.
Some other changes are:
  • The AwardVIP is no longer a separate window of the Award menu, but a separate menu all by itself. This will leave more space for the account name lookup I plan to add to it.
  • A new "about" page on startup with a disclaimer as required by GPLv2. Simply check the "Do now show this again" checkbox so this doesn't reappear on every login.
09/10/2010 19:08 Eurion#4
King_Arthur,

I checked out this new release to see what new things you may have added to this version. Over all I say it will be helpful to the people on these forums. Some suggestions I have though would be the following.
  • Change the Vip award to go by character name (GM's or PM's without db access shouldn't have access to account names.)
  • Perhaps add a refresh to the botjail/list this way the end-user won't have to reload the list everytime.

But overall, I say great job done on this one :)
09/10/2010 19:09 Faith.#5
nice you wont add sources ?
09/10/2010 19:12 Eurion#6
Quote:
Originally Posted by [Devil] View Post
nice you wont add sources ?
The source is there, its just set up in a SVN so he can easily update things as he edits them, which is a great idea actually.
09/10/2010 23:42 King_Arthur#7
Quote:
Originally Posted by Eurion View Post
Change the Vip award to go by character name (GM's or PM's without db access shouldn't have access to account names.
This is one thing that I have wanted to add in the past, but the way it was coded in VB made it a little difficult. v0.4 was a straight port from EoPanel1, so absolutely expect this feature in the next release.

Quote:
Originally Posted by Eurion View Post
Perhaps add a refresh to the botjail/list this way the end-user won't have to reload the list everytime.
This was a feature of EoPanel1, but was removed as the way the program is coded now it was not as simple to code. Once I figure some way, elegant or not, I assure you it will be back.

Quote:
Originally Posted by Eurion View Post
Quote:
Originally Posted by [Devil] View Post
nice you wont add sources ?
The source is there, its just set up in a SVN so he can easily update things as he edits them, which is a great idea actually.
The source link is here: [Only registered and activated users can see links. Click Here To Register...] and is also in the first post above the reference links. Only major releases will be compiled and uploaded to this thread on Epvp. The source will be updated more frequently as I work on it. If your interesting in bug-fixing, forking, or just want to see how this program works, the SVN works great.
09/11/2010 01:18 ~WARNING~#8
i don't see any sources available on there, only the mysql DLL file, but still a good release
09/11/2010 01:22 Eurion#9
You can view the files by going to

[Only registered and activated users can see links. Click Here To Register...]
09/11/2010 01:23 DeadHackerz#10
King perhaps u could make some more features like ip banned or something more extreme ehhehe coz you doing well on programming ;) anyways i would like to said nice release!!
09/11/2010 03:31 King_Arthur#11
Quote:
Originally Posted by UnbeatenRs2 View Post
i don't see any sources available on there, only the mysql DLL file, but still a good release
Go to the sources tab. From there you can either click browse or follow the instructions to connect with an SVN client.

Quote:
Originally Posted by DeadHackerz View Post
King perhaps u could make some more features like ip banned or something more extreme ehhehe coz you doing well on programming ;) anyways i would like to said nice release!!
Thanks for the suggestion! However, I do not want to spend my time reinventing the wheel. A feature like ip banning is better left up to the server's firewall.

In the meantime, I do (as seen in the source) plan on eventually making an add-on program that would run on the server like forcer hinted to in the Acme admin tool. It would implement a timer to automatically release users from botjail. This would be a feature down the line and diffidently wont be included in v0.5.
09/11/2010 21:37 ~WARNING~#12
alright thanks, ill give it a go and see if i can improve or add anything else :D
09/17/2010 06:45 King_Arthur#13
BETA Executables:

This beta is from branches v0_5 and contains the following changes:
Improvements to the Login system wait time.
AwardVIP now has character option
Started initial login after frmManage is loaded.
Login method no longer tried to update login info after cancel click

Downloads in spoiler:

If there are no issues, this will be released as version 0.5. As always, post any bugs here or on the issue tracker.
09/17/2010 07:06 Faith.#14
When Clicking on Detail 1 it gives error.
why dont you make icon for it here is a good editor i can do it for you, but let me download the Program :P
i made HW Icon with this but.. lost the setup.

[Only registered and activated users can see links. Click Here To Register...]

here i the icon file
09/17/2010 10:34 King_Arthur#15
Quote:
Originally Posted by [Devil] View Post
When Clicking on Detail 1 it gives error.
Where is the Detail 1 you are clicking on? Could you post a screenshot?

As for the other stuff, so far I have kept the GUI pretty simple. I have just done the bare-bone stuff without much regard for making things pretty. Perhaps after my classes are done I will work toward a color scheme and icon, but for now the stock stuff works for me.
Page 1 of 3 1 23