SQL Control Panel w/ *nix/BSD Management Support

[bentheexo]

A few years ago I started a project that I thought would rival the Sereon Server control panel. I had come to realize that not many if any people would actually use this panel for administration purposes. A friend of mine asked if I still had the panel files available, but I did not. I have started work on this project again, this time to finish and release, and I need input for features that people would want to have. Here is a list of features that I already have working and just need to be fine tuned and implemented:

Ability to choose Trunk or Stable

Ability to choose eAthena or rAthena (others can be added as well)

Revision Checkout and Upgrade

Compilation and Recompilation

Backup and Restore functionality

File Editor

Ajax based Terminal Window with easy click buttons to view the running servers.

Double Authentication for the aforementioned functions.

SQL Log Viewer and Manager (Providing sorting, and clean up capabilities)

Easy to manage administrators privileges (based on the Ceres style of permissions)

Ability to up/downgrade Admin level within the Panel

List of Possible deployments:

Image Template for all Major Virtualizations

As it's own Operating System

--The panel will install all necessary programs except for PHP, Apache, and Ioncube

--The programs will be downloaded from the corresponding Operating System Repository, or by installation from

--source tarballs.

Now that I am done listing what I have already thought to include and have already included, I need your input to know what else a Server Owner would want to include. I could not ask myself what to include, because personally I prefer to do all administration from a CLI.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

Updates on Developement

The Control Panel for the game has been placed in Open Source Development on GitHub.com. The Administration panel will be kept Closed Source and will be a separate part of the Control Panel that does not have to be included.

https://github.com/bentheexo/CSMP

Download the Control Panel and report bugs back to me either here or on github. Active Development is going on so there will be revision updates at least 4 times a week.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

Frequently Asked Questions: You asked me in PMs, so here are the answers

Q - Why is there no Upgrade Script or Folder anymore?

A - This panel is still in development at a point where the key code could change at any moment. Tables are not being updated, but new ones are being added. The installer and the manual files are being updated as well. That being said, I full recommend clean installs each time, since I do not recommend this be used for production use until development changes full time to the administration panel.

Q - Why is it not working?/Why does the page not show anything?/I edited the config and moved it so it should work but it doesn't.

A - Delete the files associated with the panel, and download a fresh copy from the GitHub link in the above section.

Q - How do I install this?

A - In 4 easy steps.

*Step 1.) Obtain Source

*Step 2.) Place Source into directory that is accessible from internet (example http://fake.web.site/csmp)

*Step 3.) Run Installation script by either navigating to install directory and the install.php or by redirection of the primary index page

*Step 4.) Follow the Instructions on the Installer

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

To prevent people from screaming "theft" of certain unmodified scripts here are my thanks to specific people and their contributions.

JayPee Mateo - Vote 4 Points (it still requires being logged into the control panel so his authentication is added security)

hellflaem - Donation Script (even though Zac gave me full unlicensed use of his scripts as I did for him, see above comment as well)

Beowulf, BrianLua, etc - Ceres Core (for which this project would have take longer)

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

To whatever his name is that tried to criticize me - Yes I care about creators getting their Credit and I have even gone out of my way to not only submit a bug fix for Ceres, but I made a conscious choice about branching my panel off at a stagnant time in their development when the only updates were for code corrections.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

Under effects of stupidity on 05/02/2012 I have injured my right hand (mainly my pinky and ring finger). Dragon Natural speaking and a mouse can only do so much, so development is paused. IF anyone wants to assist me with the development by lending me space on their server for testing the panel (Windows or Linux, it doesn't matter right now as I am just going to be testing the Control Panel) I will be eternally grateful.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

My hand is still not even close to being back to normal. My doctor is talking about surgery to loosen and tight ligaments. In the mean time I have been using Dragon Natural speaking to try dictation of continuing works, but I haven't gotten very far. I did start a new trunk branch to more fully integrate features. There will be more work to come on that branch and then the real fun starts.

https://github.com/bentheexo/CSMP-trunk

Edited February 23, 2012 by bentheexo

[gustav]

a windows version lulz

[bentheexo]

If I did decide to do it as a Windows, It would be a requirement that it be licensed and bought, not be able to run with very minimal installation, and would not be released for 6 months or more after the initial release.

[beebski]

Integration with Forums by being able to change table names and formats

--Still debating on creating a "forum" within the Panel.

-That would be nice for the control panel, for newbie like me (shameful to say ) it might help a lot. Plus the people who doesn't know how to setup/start a forum.

goodluck to your project.

[akihito]

All the codes you claim you "write" is from Ceres and please do not remove their credits.

[bentheexo]

Check again. All codes you claim to be Ceres have been meticulously combed through and changed to the point that their credits are no longer valid. The license is still GPL as per the original codes license.

[KoriAK]

I dont give a XXXX what its base on, if it does the job then im happy. Plus stop pressing people to do what you want, they will make it how they fell it should be.

BTW Ceres is much better than any other XXXXing control panel out there. I have ran so many XXXXing servers and ceres by far, was and is the best XXXXing control panel out there so if he want to use XXXXing ceres then XXXXing let him.

BTW the code my be rewriting to take the ceres code out of there who give a XXXX, if it still has the fell o XXXXing well deal with it, you just dont like it someone can rewrite a control to make it there own Big XXXXing Deal let him have his XXXXing glory, cause i bet you cant even XXXXing code, script, write a website, develop items, so STFU and leave him the XXXX alone.

Edited February 5, 2012 by Kawaii

[Ehcloprom]

Sweet this will come in handy good job ben

[ngek202]

I would love to try this one, been having headache with flux. thanks Mr. Ben.

[ScriptingPhailure]

Plus 1 to Kawaii, I mean sure it's based off of it but it's an improved version. Java lead to C and C lead to C+ and C+ lead to C++. Biology was founded by Chemistry and Chemstry by Physics and Phyiscs by math. If they were in actuallity to same they wouldn't teach seperate classes.

[bentheexo]

Thank you everyone for your support. As an added bonus for you I have finished an in-game Character Mailer. There is a new config line for people who want to update just the files, or if you were testing it and want a fresh install you the config line is included in the installer.

****Key Updates have been committed to fix bugs with $end and end() that would cause the panel to finish before anything got started. If you have any troubles out of the system LET ME KNOW. I have been working all day on integrating the new features with double login security. The panel uses Cookie Authorization for 1 hour, but the donation panel and vote for points require an additional login using your game credentials to verify user identity and to prevent "accidental" fraud.

****Donations Panel and Vote 4 Points have been added into the Code. Very soon I will be moving to the Administration Panel full time.

Edited February 5, 2012 by bentheexo

[KoriAK]

Subjecting can you add configuration for V4P and Donations to make it easyer for people to set it up, if you can i would like to see a forum in the Control Panel.

[ngek202]

I'm trying the Transfer Money function and it doesn't seem to work. it says "The operation is impossible"

well I already changed it to 1.

$CONFIG['money_transfer'] = '1'; // money transfer enable = 1, disable = 0
$CONFIG['money_cost'] = '1'; // money transfer cost (100 = 1%), disable cost = 0

I tried the Mailer too Send a Message from another Character but he didn't receive anything.

I tried to test the @mail ingame to see if it's working and yes It's working but not thru the CP.

[bentheexo]

Thanks for the bug report. I will look into this asap. You should post this https://github.com/b...exo/CSMP/issues so that I can track these incidents better.

Check the mail table to see if you can find your message there. If you can't then it should be an easy fix.

Edited February 6, 2012 by bentheexo

[ngek202]

yep I checked the mail table on ragnarok db and the mail was there.

submit Issues on github

[ngek202]

wow Transfer Money is fixed..

Question is Vote 4 Points working?

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ''@'localhost' (using password: NO) in C:xampphtdocscsmpvoteforpointsvotingpage.php on line 5
ErrorAccess denied for user ''@'localhost' (using password: NO)

I tried testing it.

Suggestion: maybe adding a Reset Position

[bentheexo]

I pushed an update for the Vote for Points. It should fix most of your problems for now with it. The next updates are going to all configuration based. I will be re-writing all the configuration codes for the Donation and Vote for Points to be set at the time of installation. Another possibility is to break the installation up into parts and create multiple configuration files. While I think that is bad idea, it makes everything more modular. Another way around issues of forcing the panel to install to a specific folder path (which is what the latest updates required i.e. http://exam.ple/csmp).

Feature updates will be halted until I can type and it not take 5 minutes for a sentance or string. I injured my hand being somewhat ignorant of my chosen field. Long story short I hit the Heavy Bag too low and with enough vigor to knock the guy on the other side back against the wall. I didn't break anything, but it likely I tore a ligament or got a tendon twisted. Both of which will work themselves out but only through time. New updates for bugs/issues will be fixed, but no new development.

[manabeast]

this one have anti hack & inject system @@?

Edited February 8, 2012 by manabeast

[bentheexo]

It has a bruteforce detection system that bans IP addresses.

[bentheexo]

I have finished a new version of Vote for Points. It is not included in the https://github.com/bentheexo/CSMP but it is included in https://github.com/bentheexo/CSMP-trunk

As always you should always do a clean install, or if you are using git make sure that you pull all changes and re-install the Vote 4 Points SQL. I will add an SQL Upgrade script to run as well.

[ngek202]

will try this

[manabeast]

when register need for password must have atlease 2 abc and 2 digi 123. how to cancel make it atlease 1 abc and 1 digi?

like a123456

[Whitecash]

its gonna soon paid control panel?

[bentheexo]

No it will not be a paid panel. I have been very busy with work (Apple Certified Technician for CityMac) so I haven't been updating any recently. I plan on doing another major set of revision this weekend as well as the next. I have decided to just leave it open source GPLv2.