It's been quite a while since the last release of a Utime MySQL addon/update, so I decided to bring mine to the table.
What's New?:- Removed the two pointless table additions (steamid and playername)
- Added color coding for the console messages
- Updated UI to be the same as the normal version
Biggest addition is the ability to upload current data from the server's sv.db file to the MySQL database and have it begin to use the MySQL data. This works by running a simple console command, and ensures that it is nearly impossible for anything wrong to happen.
Running the command
"uploadutime" will begin the process of uploading your data to the MySQL database.
NOTES:- Doing this will EMPTY your server completely, as well as put a password on it. This is to prevent any data altercation during upload, ensuring a safer upload. A password is then placed on the server, and should not be changed to allow joins during the uploading process. There is also an option to have the server place [MAINTENANCE] before the servers hostname, which will let players know what is going on.
- Once this process is complete, there should be an automated restart triggered by the server, however if it doesn't work for some reason just restart manually when the message about the server restarting appears.
- A safety has been applied to prevent the data from being uploaded multiple times. If you feel that this data is not fully on there, please restart the server, run the command "utime_cleardb" followed by "utime_continue" then finally "uploadutime". It is advised that if your host crashed, you download the files and do it off a personal server.
Commands:-
uploadutime: This command will begin to upload all of the utime data from sv.db to the MySQL database. Usually, this is the only one you need.
-
utime_cleardb: This command will empty the table of all of its data. Use this in the case that your server crashes midway during the data upload process.
-
utime_continue: This command will remove the limit that prevents multiple runs of the uploadutime command. Use this following the use of utime_cleardb.
Support:This addon comes as is, it's up to you to use it right. In the case that you did not follow instructions properly, and happen to somehow mess up your database, I will NOT fix it for you. You broke it, you deal with it.
Installation:Please install the gm_mysqloo and libmysql dll files accordingly.
https://facepunch.com/showthread.php?t=1220537 - gmsv_mysqloo. Read the page to get the libmysql dll as well as proper installation for both.
Once that is done, drag and drop the utime_mysql folder into your addons directory, and remove the previous utime folder. Once this is done, run the uploadutime command to begin the process. Run this command only once!
Requirements:ULib, gm_mysqloo, libmysql
Download:If you cannot see the download, please sign in or make an account.
IMPORTANT NOTICE: IF YOU DOWNLOADED THE SCRIPT BEFORE 10/10/15 PLEASE IMMEDIATELY APPLY THIS FIX! THERE IS A HUGE FLAW THAT CAN RESULT IN LOSS OF ALL DATA!
DOWNLOAD THE BOTTOM VERSION OF IT!
