MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
2 Attachment(s)
MySCAL (MySQL Server Configs & Admin Logging)
Foreword I am looking for any suggestions for this plug-in, I currently class this plug-in as BETA because I am looking for feedback from the community, although I am using for my game servers. See my thoughts/suggestions below. My Thoughts/Suggestions: If you have any suggestions, please reply below, I saw two very good ideas and merged them together into a single 'viable' solution for larger communities with lots of game servers.
This plug-in allows server operators to store their server.cfg file entries in a MySQL database, rather than have server config files scattered across each server and to control them from a single location. After approximately 3 seconds of the map loading, this plug grabs the configs from a database where the server number matches and then executes them. If any map specific config files exist eg mapname.cfg it will now run these in your cfg folder automatically. Also its capable of logging admin commands to a MySQL Database as well. As I use HSFighter's web interface (link below), it made absolute sense to add this as well, as in theory its only a simple search based upon Steam ID, to keep a record of the commands an admin has made. Also as a fail-safe, if the connection fails, server plug-in will run "server_back.cfg". Web Interface Coming Soon! The web interface is being worked up by HSFighter and will be released later this week in this thread: http://forums.alliedmods.net/showthread.php?t=60174 I am hoping that it may end up looking similar to this for CSS: http://www.cstrike-planet.com/cfgmaker?cfg=srcds CVars sm_myscal_version - Duh sm_myscal_enable - Default: 1 - Enables and disables this plugin sm_myscal_server_no - Server Number (see notes below) sm_myscal_log_enable - Default: 1 - Enables/Disables Admin Command Logging Installation 1. A working MySQL Connection, http://wiki.alliedmods.net/SQL_Admin...#Configuration noting that this plug-in will use what ever the default one is. 2. Run the SQL below or attached in the .sql file on your database to create the tables 3. Put this plugin in your <mod dir>/addons/sourcemod/plugins/ folder 4. Change maps. FYI: The cvar is held in ' Command_Name' and the value is held in 'Command_Value', this also means you could also do "exec somefile.cfg" if needed Optional: Server Number: After entering your server configs to the database in columns, you may want to think about server numbers. you will need to add the following to your server.cfg file: PHP Code:
If the database connection fails, the plugin will attempt to run "server_backup.cfg", this of course could have been your original server.cfg which you have renamed. SQL: Below and attached, is the SQL to create the two tables, you will see that its prepared for HSFighter's web console (after one squillion PM's, loooool) Server Config: PHP Code:
PHP Code:
CVars that do not work & special considerations! So far I have only found one CVar that does not work using this method and that is sv_downloadurl, this must be set in the server.cfg file. We have hundreds of admins, within a a few days we had already topped the 1000 command mark that the admin logging function had stored, over a long period of time, this map be a problem for someone with a small database allowance. Version History V1.0 - First release V1.1 - Added the function to run map specific cfg files automatically Thanks to..
|
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
This looks pretty good ;)
Since there's a known problem with sv_downloadurl, could you search the editor and throw an error if that string is found? What about releasing the admin logging in a separate system? |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
Quote:
As for just the admin loggging only, set sm_myscal_enable to 0 Matt |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
Code:
CREATE TABLE `smwa`.`sm_logging` ( |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
Quote:
Matt |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
We'll test this on one of our servers, probably soccer server, and give feedback. I'm all about logging being done remotely just in case servers go down.
otto :grrr: |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
Quote:
|
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
Quote:
Matt |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
Quote:
It will be esay to switch the settings in the webpanel to a separate plugin for adminlogging. The new Multiserver-Support for the Webadmin will allow this ^^ I think it's a fine solution to put the admin logging to a separate plugin |
Re: MySCAL (MySQL Server Configs & Admin Logging) - Need Feedback!
I'm getting the following errors, any ideas?
L 07/04/2008 - 14:39:17: [myscal.smx] [MySCAL] Database Error L 07/04/2008 - 14:39:17: [myscal.smx] [MySCAL] Attempting to run server_backup.cfg L 07/04/2008 - 14:39:17: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4) |
All times are GMT -4. The time now is 02:51. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.