UTimeM - UTime for MySQL

[saintwubbles]

Just a suggestion, could you add IP and first visit logging. I have done this myself but I think it might be useful for other people.

[Buggzie]

Could you possibly help me make a persistent?

thanks to meg and jay they helped make it persistent for me.

[someone920]

There's an error with this now since Garry's Update. Here's the Lua error: I'm pretty sure it still records time, but this error never stops.

Code: [Select]

Timer Error: autorun\cl_utime.lua:43: attempt to index upvalue 'gpanel' (a nil value)

[saintwubbles]

You can remove cl_utime.lua temporarily to stop the errors till a fix is available, the serverside stuff isn't affected.

[RynO-SauruS]

I've fixed this error, but on the regular version of UTime. Is the cl_utime.lua file in this the same as the one in the original? If so I can attach the fixed file.

[Megiddo]

I've fixed this error, but on the regular version of UTime. Is the cl_utime.lua file in this the same as the one in the original? If so I can attach the fixed file.

I think so

[RynO-SauruS]

OK I've attached a slightly modified file that fixes the error that someone920 mentioned,
and also I've found a place where I fixed another error I was getting a long time ago.

And to Megiddo, the part I changed to fix the error that someone920 mentioned is this:

(Starting at line 31 and ending at line 38)

Code: [Select]

function initialize( ent )
if ent == LocalPlayer() then -- Player has been initialized
gpanel = vgui.Create( "UTimeMain" )
gpanel:SetSize( gpanel.Wide, gpanel.Small )
hook.Remove( "OnEntityCreated", "UtimeInitialize" )
end
end
hook.Add( "OnEntityCreated", "UtimeInitialize", initialize )

I changed it to this:

(Starting at line 31 and ending at line 36)

Code: [Select]

function initialize()
gpanel = vgui.Create( "UTimeMain" )
gpanel:SetSize( gpanel.Wide, gpanel.Small )
hook.Remove( "InitPostEntity", "UtimeInitialize" )
end
hook.Add( "InitPostEntity", "UtimeInitialize", initialize )

Let me know if this is flawed in some way.

[saintwubbles]

Thanks RynO-SauruS, that works for me.

Edit: My small modifications to the mySQL queries in sv_utime.lua adding firstvisit and IP logging.

line 60

Code: [Select]

result = xquery( "CREATE TABLE utime (id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,player INTEGER UNSIGNED NOT NULL,ip VARCHAR(30) NOT NULL,totaltime INTEGER UNSIGNED NOT NULL,lastvisit INTEGER UNSIGNED NOT NULL,firstvisit INTEGER UNSIGNED NOT NULL,steamid VARCHAR(45) NOT NULL,playername VARCHAR(100) NOT NULL,team VARCHAR(45),PRIMARY KEY (id))" );
line 86

Code: [Select]

xquery( "UPDATE utime SET ip = '" .. ply:IPAddress() .. "', lastvisit = " .. os.time() .. " WHERE player = " .. uid .. ";" )
line 101

Code: [Select]

local result, succ, err = mysql.query(db, "INSERT into utime ( ip, player, totaltime, lastvisit, steamid, playername, team, firstvisit ) VALUES ( '" .. ply:IPAddress() .. "', " .. uid .. ", 0, " .. os.time() .. ", '" .. sid .. "', '" .. mysql.escape(db, nam) .. "', '" .. mysql.escape(db, tem) .. "', " .. os.time() .. ");")
I hope this would be useful for someone.

[Robin]

For everyone who got problems with it, means when it lags while the server is sending a query,

Replace all

   -- Disconnect from server.
   local succ, error = mysql.disconnect(db)
   if(not succ) then
      print("[UTime] Error disconnecting from server!")
   end

with
       -- Disconnect from server.
       mysql.disconnect(db)

Becouse some servers don't send confirmations for a closed mysql connection back.
Thats why the Server freezes until that functions times out.

[ACProdigy]

Wow, its been a long time since I've been here. It looks like things have changed since the last release, things broke, and the community was able and willing to patch the code as time went on. (Good job and thanks).

I'll be updating this plugin with some updates for compatibility, bugfixes, slightly refactored code, and user-defined options!

[JamminR]

Welcome back, and, great to hear!

[strategos]

Can anyone confirm if this still works?

Also, will gm_mysql work alongside the MysqlOO module by andyvincent?

[blackfire88]

Could this be made into a mysqloo version?
I don't think its possible to run mysql and mysqloo together, and alot of addons use mysqloo, so it would be a good idea to create a mysqloo version for the compatibility

[MRDRMUFN]

Im with blackfire88 on this. ULX needs a mysqloo version of utime. I've tried to patch it to work myself, but a serious issue happened that im not experienced enough in scripting to solve. I managed to get it to propagate the database and fill it in the same format as the mysql utime. but i cant for the life of me manage to get it to load times on player join.
Here is a link to my edited version -> http://dl.dropbox.com/u/34509350/UTimeM.zip 

The reason i need this to work so bad is that my server runs on linux, and GmMysql isnt linux compatible.
My goal is to eventually Merge ranks and player times from my gmod and minecraft servers. Combined with
IRC for Multiserver chat system where members can play on the separate systems and still communicate and
earn game credit/time.

[MKServers]

Im with blackfire88 on this. ULX needs a mysqloo version of utime. I've tried to patch it to work myself, but a serious issue happened that im not experienced enough in scripting to solve. I managed to get it to propagate the database and fill it in the same format as the mysql utime. but i cant for the life of me manage to get it to load times on player join.
Here is a link to my edited version -> http://dl.dropbox.com/u/34509350/UTimeM.zip 

The reason i need this to work so bad is that my server runs on linux, and GmMysql isnt linux compatible.
My goal is to eventually Merge ranks and player times from my gmod and minecraft servers. Combined with
IRC for Multiserver chat system where members can play on the separate systems and still communicate and
earn game credit/time.

I require some help of my own(Here is a MySQLOO Utime).http://forums.ulyssesmod.net/index.php/topic,5737.0.html
So the following WILL require a little knowledge of how Utime saves. It is all numbers. I need a way for my PHP Loading screen to read these number, and break them up into Month, Day, and Year. I am not asking for much, I having been searching for a while and can't figure this out, so any help would be appreciated.
I do know alot about coding, I run my own server, [MK] Servers as my name would show, and i have coded my own things with MySQL and PHP but cant find a way for PHP to read the Utime numbers. Please help me.
Thank you all in advance.