Ulysses

Ulysses Stuff => Releases => Ulysses Release Archives => Topic started by: ACProdigy on January 03, 2010, 09:00:32 PM

Title: UTimeM - UTime for MySQL
Post by: ACProdigy on January 03, 2010, 09:00:32 PM
Exactly what it sounds like: UTime rebuilt for MySQL integration. You must have your own MySQL server for this, obviously. UTimeM will create a table in the provided database if it does not already exist.

Requires:
ULib
gm_mysql module

Revision History
-[Version 4 Core 1.3 - 01/07/10]
     [FIXED] Nicknames with special characters not getting updated/created.

-[Version 3 Core 1.3 - 01/03/10]
     [ADDED] Several extra variables, useful for community inter-linking. New stored variables include Nick, Team, and SteamID.

-[Version 2 Core 1.3 - 07/04/09]
     [INITIAL RELEASE] Stays true to the original UTime, stores only ID, UID, Total Time, and Last Visit. As MySQL.

Attribution
The core of this code is licensed by Team Ulysses under the Creative Commons License, BY/NC/SA (http://creativecommons.org/licenses/by-nc-sa/3.0/). I have modified it to make use of a different database system, and release it under the Creative Commons License, BY/NC/SA (http://creativecommons.org/licenses/by-nc-sa/3.0/).
Title: Re: UTimeM - UTime for MySQL
Post by: Megiddo on January 03, 2010, 10:10:56 PM
Good work! Especially useful with nick and steamid combo.
Title: Re: UTimeM - UTime for MySQL
Post by: JamminR on January 03, 2010, 10:26:06 PM
The one that stores nicknames... won't create duplicates if different names are used, correct?
I wouldn't want a database to store 5 different records for the same uniqueid or steamid just because someone decided to change thier steam alias.
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on January 04, 2010, 08:56:58 AM
The one that stores nicknames... won't create duplicates if different names are used, correct?
No, the table maintains its primary key based on the UID, and updates the nick with the total time.

Also, below is a real-time example of what can be done with PHP parsing that new shiny MySQL table. Bear in mind its the concept, my presentation isn't that pretty (I'm not a designer, after all). The image is being pulled from my webserver, which is hosting the DB that my development gameserver talks to. PHP extracts the information for the given user, populates the text fields, and then spits out an image.

(http://cgc.ath.cx/dcc/playerInfo.php?id=2)
Title: Re: UTimeM - UTime for MySQL
Post by: JamminR on January 04, 2010, 10:49:04 AM
Nice. Good work.
Though I do not know MySQL or any related DB query related construct, I know many others will find this useful.
Thanks for the contribution, and I look forward to future releases.

<somewhat off topic>
If you ever wish to tackle making a ULib module for integrating UCL and MySQL, there was discussion and working code (from forum integration) here over almost two years ago. http://forums.ulyssesmod.net/index.php/topic,3241.0.html

At the time we had a dedicated Gmod server. Megiddo wrote code to allow ULib to give access in game depending on their access here using a custom profile field that contained thier Steam ID (STEAM_#:#...)

Like your example image... great!
Ha. I too am visual/graphical artisticly challenged. Probably why I married an graphic artist.
</off topic>
Title: Re: UTimeM - UTime for MySQL
Post by: Ploo on January 07, 2010, 05:38:18 AM
Looks like something I might use instead of the original UTime. I'm gonna see if I can learn some lua by modifying it to have another table called 'servers' which holds all the servers by id, ip and name. Then each SteamID will have one entry for each server they visit. Total time will be the amount of time they spent on all servers but I will also be able to see how much they spent on individual servers.

Consider this a suggestion too. Don't think I'll succeed.
Title: Re: UTimeM - UTime for MySQL
Post by: NaRyan on January 07, 2010, 09:44:32 AM
Nice version of Utime :D
I always had problems with the original Utime (after a few months the on-join crashes got realy bad, but deleting the sv.db file sorted it)

I do have one small problem though.
This version seems to have problems with some clan tags, and some unicode based names.
i.e my steam name is =ASY=Na'Ryan.

If I leave it set to that then it does not create/update the entry in the MySQL database.
When I change my name to NaRyan, it creates the info in the database just fine.
However if I change back to my clan tag name, it reads the info fine (total time), however it will not update the database.

Is there any way to have this version of Utime to ignore a players name, and just use their steamID?
Since player names can change 1001 times, but their steamID is always the same.

Thanks. :)

Edit.
Meh just realised it's because of the ' in my name.
Removing that fixes the problem.
No great loss removing that... Silly me should have realised that by looking at other player names in MySQL database...
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on January 07, 2010, 10:03:41 AM
Looks like something I might use instead of the original UTime. I'm gonna see if I can learn some lua by modifying it to have another table called 'servers' which holds all the servers by id, ip and name. Then each SteamID will have one entry for each server they visit. Total time will be the amount of time they spent on all servers but I will also be able to see how much they spent on individual servers.

Consider this a suggestion too. Don't think I'll succeed.
There may be a better way to go about this. If you change the name of the table per server (i.e. "utime_s1", "utime_s2"), and keep it all in the same database "joes_utime" or some such, you could just use some more complicated MySQL queries to join them together when needed. Making a server table, in this case, seems a little out of the way. I'll look at implementing this (or just forking the development), if you're interested.

This version seems to have problems with some clan tags, and some unicode based names.


Edit.
Meh just realised it's because of the ' in my name.
Ah, I see. I'm glad you were able to resolve it, but it does show a mistake I made in the code. Thanks for pointing this out! I'll re-release it asap with a fix.
Edit: The above is fixed as of Version 4.
Title: Re: UTimeM - UTime for MySQL
Post by: Ploo on January 07, 2010, 12:36:54 PM
There may be a better way to go about this. If you change the name of the table per server (i.e. "utime_s1", "utime_s2"), and keep it all in the same database "joes_utime" or some such, you could just use some more complicated MySQL queries to join them together when needed. Making a server table, in this case, seems a little out of the way. I'll look at implementing this (or just forking the development), if you're interested.

I still belive my method would be simpler. UTime checks if it has its own entry in the servers table (by simple checking if there's an entry with it's IP), if not, it enters an entry with its ip, hostname and an id (incase the server IP changes and you wanna keep the utime, this would obviously require the user to change the ip in the entry manually).

The utime table would contain entires with an additional column of server_id.

When counting the total UTime, simple query the utime table for a certain UID. Add up the results.

I think having utime_s1, utime_s2 wouldn't be a good option for several reasons. a) You would have to edit the luas for each server to tell it if its s1, s2 or whatever. b) You would have edit each lua to tell how many servers there are (and tables). c) If my concept executed correctly, it would require no involvment from the installer at all. Obviously this would all be in the same database.

I hope you understand. :P
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on January 07, 2010, 01:05:18 PM
I think having utime_s1, utime_s2 wouldn't be a good option for several reasons. a) You would have to edit the luas for each server to tell it if its s1, s2 or whatever. b) You would have edit each lua to tell how many servers there are (and tables). c) If my concept executed correctly, it would require no involvment from the installer at all. Obviously this would all be in the same database.

I hope you understand. :P
I believe I understand now. I misunderstood your original comment. This would still require each separate server instance to have a unique identifier hard-coded into the lua configuration. Something like:
Code: [Select]
----- Database connection details -----

local dbhost = "0.0.0.0" -- Your MySQL IP / Hostname
local dbuser = "USER" -- MySQL Username
local dbpass = "PASSWORD" -- MySQL Password
local dbport = "3306" -- MySQL Server Port
local dbname = "DATABASE" -- Database name
local unique = "1" -- Unique gameserver identifier.

--=== DO NOT EDIT BELOW THIS POINT ====

Then the rest could be handled by whatever parses the rows, in order to add them up. That wouldn't be difficult at all really. I suggest a unique ID is manually specified in the header variables like so, as it would make it much easier to automatically update the IP/Servername later on.
Title: Re: UTimeM - UTime for MySQL
Post by: NaRyan on January 09, 2010, 08:55:44 AM
I have been getting this error every so often.

Quote
Lua Error: ERROR: Hook 'UTimeInitialSpawn' Failed: autorun/sv_utime.lua:101: attempt to call global 'mysql_escape' (a nil value)
Lua Error: Removing Hook 'UTimeInitialSpawn'

It does it when a player connects.
It can be the 1st player to join, or the 10th.
The only common thing i have seen with the players it breaks on, is they have unicode names.

I am using V1.4 of UTimeM, and the release versions of ULib and ULX.
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on January 09, 2010, 10:44:42 AM
I have been getting this error every so often.

It does it when a player connects.
It can be the 1st player to join, or the 10th.
The only common thing i have seen with the players it breaks on, is they have unicode names.

I am using V1.4 of UTimeM, and the release versions of ULib and ULX.
Is it *only* with players using unicode names?
Title: Re: UTimeM - UTime for MySQL
Post by: NaRyan on January 09, 2010, 12:45:20 PM
Is it *only* with players using unicode names?

Not entirely sure.
The next time all the players have left server or it crashes, I'll add the "-condebug" launch option to scrds, so I get a better record of what player names it breaks on.

Edit.
Nope it just gave the error when the 1st person joined the server, and they did not have a unicode name.
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on January 09, 2010, 12:58:15 PM
Interesting. Could you post some example names that it crashes on? I think I know what the problem is, but its nice to have an example or four. :D
Title: Re: UTimeM - UTime for MySQL
Post by: NaRyan on January 09, 2010, 01:10:49 PM
Names that it has broke on have been

Code: [Select]
ThorN
^0COM. ^1SOAP ^4MACTAVISH
^2[S]carface^1[D^7K]
Defou_LCK

*had to put names in code tags, else it altered the message to have strikethrough font.

That's the 4 names I have seen it break on today.

Thorn was the last player to join (and have it break), he was also the 1st player to join the server, after it had the usual on-join crash.
He was on the server when it crashed, however I don't know if he had joined before or after that sessions UtimeM breakage.

This is what was in the console.log for him:

Quote
<blah blah blah server stuff>
[UTime] Table exists!
<blah blah blah more server stuff>
Client "ThorN" connected (xx.xx.xxx.xxx:27005).
[UTime] New Player Added: ThorN
ERROR: Hook 'UTimeInitialSpawn' Failed: autorun/sv_utime.lua:101: attempt to call global 'mysql_escape' (a nil value)
Removing Hook 'UTimeInitialSpawn'

Also just noticed it keeps re-setting my total time.
The SQL database had it at 7298 for my total time.
Yet when I joined it displayed my last time on server (01/09/10 04:44:28), however it showed my total time as 1 minute 12 seconds.
And the SQL database now shows my total time as 111.
Using the player name of =ASY=Na'Ryan.
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on January 09, 2010, 01:43:57 PM
Oh, I'm an idiot. My function name was incorrect. mysql_escape is supposed to be mysql.escape.

I've re-uploaded UTimeM V4. It should solve that problem.
Title: Re: UTimeM - UTime for MySQL
Post by: Darksoul on January 26, 2010, 10:48:37 PM
For some reason utime isn't enabled when I join my server (from time to time, usually it works) and I have to type utime_enable 1 in console.

Any idea how to fix this?. It's not a huge deal since it still counts time, but its annoying.
Title: Re: UTimeM - UTime for MySQL
Post by: Robin on February 07, 2010, 05:09:41 AM
Untill ACProdigy takes a look at it, i would suggest you to add: utime_enable 1 (if its a server to server.cfg and if its a client then to config.cfg)
- Robin
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on February 15, 2010, 10:41:01 PM
Any idea how to fix this?. It's not a huge deal since it still counts time, but its annoying.
If its still counting time then it is likely a client issue (Not a given, of course). Are you getting any specific errors?
Title: Re: UTimeM - UTime for MySQL
Post by: benbrooks on February 17, 2010, 09:24:58 AM
I use this on my server and some peoples time keeps getting reset for no reason, it seems to be after about 27 hours.

Just took a quick look at the database and like 6 people have exactly the same time. (the people who's time got reset)

(http://imgkk.com/i/wrJjME.jpg)
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on February 17, 2010, 01:28:29 PM
I use this on my server and some peoples time keeps getting reset for no reason, it seems to be after about 27 hours.

Are you using the latest version of UTimeM? There was a bug previously where certain names would cause database anomalies. Also, do you keep console logs? Would you mind sharing them? The more information I have, the easier I can rectify this issue.
Title: Re: UTimeM - UTime for MySQL
Post by: benbrooks on February 18, 2010, 08:11:33 AM
Yes I have v4

Also found these in my logs

Quote
L 02/17/2010 - 13:07:22: Lua Error: Timer Error: autorun/sv_utime.lua:129: attempt to concatenate a boolean value
Quote
L 02/17/2010 - 16:10:30: Lua Error: ERROR: Hook 'UTimeInitialSpawn' Failed: autorun/sv_utime.lua:101: attempt to concatenate a boolean value
L 02/17/2010 - 16:10:30: Lua Error: Removing Hook 'UTimeInitialSpawn'

That was all of the things related to UTime in the logs for yesterday. (Some repeats of the first error)
Title: Re: UTimeM - UTime for MySQL
Post by: Ploo on February 24, 2010, 01:41:21 PM
I use this on my server and some peoples time keeps getting reset for no reason, it seems to be after about 27 hours.

Just took a quick look at the database and like 6 people have exactly the same time. (the people who's time got reset)

(http://imgkk.com/i/wrJjME.jpg)

Take a screenshot of the structure of the table. Maybe somehow the time field has become a tinyint or something of the sorts? Would explain why a larger int wont fit.
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on March 07, 2010, 12:03:06 PM
Apologies for the delay ( I recently migrated my email and subsequently it was all marked as read, I must have missed over the forum notification ). I'm looking into the issue now, benbrooks. As Ploo said, could you please provide the full table structure? In the case of an Overflow condition, MySQL should be returning an error, and UTime should therefore be mentioning it.

Regarding the Boolean Concatenation error, it seems to be related to the MySQL Query itself. This tells me that MySQL probably IS handing off an error to LUA ( due to the Overflow condition ), but my code isn't handling it correctly. Something that needs to be fixed, certainly, but seems to be a symptom rather than the problem.

Like I said, please post your table structure here, and I'll be able to provide a better answer. Thanks!
Title: Re: UTimeM - UTime for MySQL
Post by: Chippiewill on May 04, 2010, 09:23:24 AM
I seem to be having problems with this, is it compatible with ulib and ulx SVN?
The only error that I receive is that it is unable to reach the database, I hae checked and the box which my game server is on has the IP open.
Title: Re: UTimeM - UTime for MySQL
Post by: someone920 on June 09, 2010, 08:29:46 PM
I just started using this, and it connects fine, but it now only displays the total session time for both times... I don't know if i should remove the sv.db.
Title: Re: UTimeM - UTime for MySQL
Post by: Buggzie on June 21, 2010, 02:46:18 PM
I dislike how you make it reconnect all the time. Never added a persistent feature. This lags my server everytime it connects.
Title: Re: UTimeM - UTime for MySQL
Post by: Megiddo on June 21, 2010, 03:42:11 PM
I dislike how you make it reconnect all the time. Never added a persistent feature. This lags my server everytime it connects.

You could get a faster MySQL server... or at least one closer to your server. For example, these forums don't use a persistent connection. It reconnects every time you load the page, but there's no noticeable delay there.
Title: Re: UTimeM - UTime for MySQL
Post by: Buggzie on June 21, 2010, 04:13:55 PM
You could get a faster MySQL server... or at least one closer to your server. For example, these forums don't use a persistent connection. It reconnects every time you load the page, but there's no noticeable delay there.

Could you jump on steam, I need some help making this persistent...

Its not noticeable on webservers because its a webserver game servers update secondly and if it times out then yeah... it will screw up.

Even the localhost server lags
Title: Re: UTimeM - UTime for MySQL
Post by: someone920 on June 22, 2010, 06:08:12 PM
Could you jump on steam, I need some help making this persistent...

Its not noticeable on webservers because its a webserver game servers update secondly and if it times out then yeah... it will screw up.

Even the localhost server lags

Could you possibly help me make a persistent?
Title: Re: UTimeM - UTime for MySQL
Post by: saintwubbles on June 24, 2010, 05:56:45 AM
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.
Title: Re: UTimeM - UTime for MySQL
Post by: Buggzie on June 25, 2010, 04:50:22 AM
Could you possibly help me make a persistent?

thanks to meg and jay they helped make it persistent for me.
Title: Re: UTimeM - UTime for MySQL
Post by: someone920 on June 29, 2010, 08:21:05 PM
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)
Title: Re: UTimeM - UTime for MySQL
Post by: saintwubbles on June 30, 2010, 07:08:07 AM
You can remove cl_utime.lua temporarily to stop the errors till a fix is available, the serverside stuff isn't affected.
Title: Re: UTimeM - UTime for MySQL
Post by: RynO-SauruS on June 30, 2010, 10:50:08 AM
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.
Title: Re: UTimeM - UTime for MySQL
Post by: Megiddo on June 30, 2010, 11:47:18 AM
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
Title: Re: UTimeM - UTime for MySQL
Post by: RynO-SauruS on June 30, 2010, 12:20:38 PM
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.
Title: Re: UTimeM - UTime for MySQL
Post by: saintwubbles on July 01, 2010, 06:16:16 PM
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.
Title: Re: UTimeM - UTime for MySQL
Post by: Robin on July 21, 2010, 04:49:49 AM
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.
Title: Re: UTimeM - UTime for MySQL
Post by: ACProdigy on July 01, 2011, 09:24:05 AM
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!
Title: Re: UTimeM - UTime for MySQL
Post by: JamminR on July 01, 2011, 07:43:45 PM
Welcome back, and, great to hear!
:)
Title: Re: UTimeM - UTime for MySQL
Post by: strategos on September 19, 2011, 10:54:38 AM
Can anyone confirm if this still works?

Also, will gm_mysql work alongside the MysqlOO module by andyvincent?
Title: Re: UTimeM - UTime for MySQL
Post by: blackfire88 on January 25, 2012, 04:06:12 PM
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
Title: Re: UTimeM - UTime for MySQL
Post by: MRDRMUFN on January 26, 2012, 07:41:17 PM
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 (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.
Title: Re: UTimeM - UTime for MySQL
Post by: MKServers on August 14, 2012, 06:28:27 PM
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 (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 (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.
Title: Re: UTimeM - UTime for MySQL
Post by: JamminR on August 14, 2012, 09:35:04 PM
Been a while since I've looked at any of the UTime code... is it not common Epoch time?
Title: Re: UTimeM - UTime for MySQL
Post by: MKServers on August 15, 2012, 03:11:37 PM
Been a while since I've looked at any of the UTime code... is it not common Epoch time?

Yes, thank you so much! This will be very helpful, thank you!
If anyone needs to use PHP to convert Epoch time, here is a link:
http://forums.devshed.com/php-development-5/php-epoch-time-conversion-498260.html (http://forums.devshed.com/php-development-5/php-epoch-time-conversion-498260.html)
Title: Re: UTimeM - UTime for MySQL
Post by: JamminR on August 15, 2012, 07:03:30 PM
Welcome. Glad you found tip useful, and thanks for the reference for anyone else that might need it.
Title: Re: UTimeM - UTime for MySQL
Post by: MRDRMUFN on August 16, 2012, 09:13:44 PM
I require some help of my own(Here is a MySQLOO Utime).http://forums.ulyssesmod.net/index.php/topic,5737.0.html (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.

I like how you suggested I should check out a topic I made :P