Author Topic: UtimeMOO - Utime for MySQL (Linux Compatible)  (Read 40365 times)

0 Members and 1 Guest are viewing this topic.

Offline MRDRMUFN

  • Newbie
  • *
  • Posts: 9
  • Karma: 6
    • Ingenious Gaming
UtimeMOO - Utime for MySQL (Linux Compatible)
« on: August 13, 2012, 08:36:34 PM »
I have taken the UtimeM plugin and have modified it work with the 'gm_mysqloo' module. This allows Linux servers to store Utime data on a MySQL database.
Works for both windows and Linux servers.

Requires:
ULib, gm_mysqloo

Released under Creative Commons

[EDIT] uploaded revision 1 "Fixes random disconnects"
« Last Edit: October 11, 2012, 10:23:20 AM by MRDRMUFN »

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #1 on: August 13, 2012, 08:51:33 PM »
Thanks!
I love seeing an old release become new and better through the talents of our community.
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline MRDRMUFN

  • Newbie
  • *
  • Posts: 9
  • Karma: 6
    • Ingenious Gaming
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #2 on: August 13, 2012, 08:59:32 PM »
No problem  ;D. there might be some debug code still in there you can just remove those print msg's if they get annoying

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #3 on: August 14, 2012, 06:17:24 PM »
Nice!
Experiencing God's grace one day at a time.

Offline MKServers

  • Newbie
  • *
  • Posts: 10
  • Karma: 3
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #4 on: August 15, 2012, 09:42:14 PM »
Very nice, very nice. Will be used on [MK] so thank you.

Offline MRDRMUFN

  • Newbie
  • *
  • Posts: 9
  • Karma: 6
    • Ingenious Gaming
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #5 on: August 15, 2012, 10:58:37 PM »
Thanks this is my first personal coding project that i've actually finished  :D
I did it because i needed it for my own server.
« Last Edit: August 15, 2012, 11:03:21 PM by MRDRMUFN »

Offline emilhem

  • Newbie
  • *
  • Posts: 21
  • Karma: 3
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #6 on: August 19, 2012, 08:52:53 AM »
Awesome! Karma for you!

Now if you could do the same for UBan that would be even more awesome!

Offline MoSs

  • Newbie
  • *
  • Posts: 3
  • Karma: 1
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #7 on: August 20, 2012, 04:34:43 AM »
heads up! default port for mysql is 3306, in the lua file the port is 3308

just wanted to point it out in case someone gets confused why it doesn't connect to the db :)

Offline Q4-Bi.

  • Newbie
  • *
  • Posts: 3
  • Karma: 2
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #8 on: October 10, 2012, 11:52:10 AM »
Looks nice =) Finally i found what i've been looking for.

Almost, could it be possible to track people from different servers like , Current server time and total server time?

Offline MRDRMUFN

  • Newbie
  • *
  • Posts: 9
  • Karma: 6
    • Ingenious Gaming
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #9 on: October 11, 2012, 10:29:25 AM »
it works exactly as Utime did. I've only modified the library it relies on. Also you should use the Rev-1 version i uploaded. It fixes a serious bug i had with the first version. Critical bug if you use Auto-promote. Sorry just got around to uploading it.

Offline saintwubbles

  • Newbie
  • *
  • Posts: 15
  • Karma: 3
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #10 on: October 24, 2012, 04:44:58 PM »
Thank you for your work on this, it was one of the things I was worried about for gmod13.

As Emilhem said, a port of uban would be really useful.

Edit: Did it myself http://forums.ulyssesmod.net/index.php/topic,921.msg26717.html#msg26717
« Last Edit: October 25, 2012, 09:29:33 PM by saintwubbles »

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #11 on: December 31, 2012, 03:34:11 AM »
Thank you for this. I used to have a version of utime that did this exactly, and you could also change a player's time while IG. Unfortunately due to the Garry's Mod 13 upgrade, it kinda killed the derma panals, which made Utime just record time in a database as this one does.

I hope one day you might do the same with this really amazing version of utime so ply:IsSuperAdmin can change players time IG, or maybe even integrate it with xgui.

Nice work though  ;D
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.

Offline maddogsuperior

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #12 on: April 29, 2013, 07:48:56 AM »
Currently in the process of trying to get this to work...

Offline Sidewaykill

  • Newbie
  • *
  • Posts: 8
  • Karma: 2
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #13 on: May 11, 2013, 06:14:31 AM »
If you do, post it here :D

Offline TweaK

  • Jr. Member
  • **
  • Posts: 80
  • Karma: 14
    • Garry's Mod Engineers
Re: UtimeMOO - Utime for MySQL (Linux Compatible)
« Reply #14 on: June 28, 2013, 09:44:42 PM »
Here is my rewrite of this addon. It (hopefully) fixes a rare case where the time would get saved after a player joined but before the db responded, causing their time to reset to zero. It also properly handles a database connection loss.

The only difference, functionally, from MRDRMUFN's version is that it does not store the team, you will have to modify the queries if you want it to save that info.

https://dl.dropboxusercontent.com/u/7934790/gmod/utimem.zip