Ulysses Stuff > Releases

UTime - tmysql4 edition!

(1/2) > >>

wafflecopta:
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=1442438

Installation and Configuration
Just 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 Changes
I removed the ID column, and am using SteamID64's to identify players. So there are now just the 3 columns (steamid, totaltime, lastvisit).

Download
https://github.com/Wafflecopta/utime-tmysql4
Yes 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:

* Install git
--- Code: ---sudo apt-get install git
--- End code ---

* cd into your Garry's Mod addons directory (I can't tell you how to do that...)
* Then simply run:
--- Code: ---git clone https://github.com/Wafflecopta/utime-tmysql4.git
--- End code ---
And thats it, its installed.

To update just cd into the addon itself and run:

--- Code: ---git pull
--- End code ---

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 Note
This 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.

Bite That Apple:
Don't take my message wrong. I'm happy to see people still make stuff for this game, but.... why all of you guys hopping on the utime bandwagon. utimem has been around since the dawn of the dinosaurs. It seems like everyone has their pick for utime now, and it's such a useless addon now a days. It serves a more comedic and finishing touch to a server.

I myself do not develop for gmod anymore. So I have not inspected your code at all, but I'm just saying what I believe.

{Insert JamminR response here}

Beast:

--- Quote from: Bite That Apple on March 10, 2016, 03:04:12 AM ---Don't take my message wrong. I'm happy to see people still make stuff for this game, but.... why all of you guys hopping on the utime bandwagon. utimem has been around since the dawn of the dinosaurs. It seems like everyone has their pick for utime now, and it's such a useless addon now a days. It serves a more comedic and finishing touch to a server.

I myself do not develop for gmod anymore. So I have not inspected your code at all, but I'm just saying what I believe.

{Insert JamminR response here}

--- End quote ---

I brought the bandwagon back with the up to date version that allowed for the uploading and pushing of current data.  Once I'd finished that, I realized that mysqloo isn't exactly good, so I released UTime Ultimate which uses Falco's MySQLite module.  The issue with this is that it somehow interferes with DarkRP and apparently there are other gamemodes that have issues.

While this is nice that a person made a tmysql4 edition, I do plan on updating and writing my own version of querying from multiple sources with a few minor improvements over my last one.

I mean, its not fun if you never improve upon your code, right?
 
I see what this person is doing by adding tmysql and making it remove the id system, however, I do believe that my version is superior due to the extra details and table information, as well as uploading and modification of current data.

Nice job though.

Randos:
Great! Thanks! Ive been waiting for this edition because ive got problems with the older one!
Ure my god! This works great!

TheHeroBilly:
Is it possible to have three separate times on this, such as Session, Total, (How long they've spent onthis server) and Global (time spent on all the servers)? I've seen it done and I'm trying to find which version does this.

Navigation

[0] Message Index

[#] Next page