Hey there guys, first release on these forums, well, first time ever on these forums. Have been doing gmod lua for quite some time now, and lately I have been hunting around for a UTime MySQL addon that just worked with no fuss, and short of
http://forums.ulyssesmod.net/index.php/topic,9320.0.html (I posted in that thread as to my objections with it) there has nothing that has tickled my fancy, so I just made my own.
THIS IS MEANT TO REPLACE ANY EXISTING UTIME INSTALLATION!!!(strangely enough) THIS REQUIRES TMYSQL4 TO BE INSTALLED!!!Here it is for you lazy people:
https://facepunch.com/showthread.php?t=1442438Installation and ConfigurationJust drag and drop (or git clone) into addons folder and add your database info in lua/utime_mysql.lua and thats it. It just works.
Database ChangesI removed the ID column, and am using SteamID64's to identify players. So there are now just the 3 columns (steamid, totaltime, lastvisit).
Downloadhttps://github.com/Wafflecopta/utime-tmysql4Yes its on github, and although I don't really see myself updating it that much, I would recommend cloning it instead of just downloading the zip. If you don't know how to git clone something, here is a quick guide for any Ubuntu/Debian users:
sudo apt-get install git
- cd into your Garry's Mod addons directory (I can't tell you how to do that...)
- Then simply run:
git clone https://github.com/Wafflecopta/utime-tmysql4.git
And thats it, its installed.
To update just cd into the addon itself and run:
git pull
If you don't have terminal access to your server, just press the Download Zip button button, and extract the contents into a folder within the addons folder.
Please NoteThis is a quick and dirty implementation, and as such I have removed things from the original UTime database schema that I deemed unnecessary (such as the id column, I have no idea why that exists), and as such there is
NO way (unless you get crafty with databases) to port existing UTime data into this new system.
No, I will not port this to MySQLOO (its garbage, lets be honest).
And yes, you can split this between multiple servers.
Thankyou for reading, hope you guys find it useful.