Ulysses Stuff > Ulysses Release Archives

UTimeM - UTime for MySQL

(1/10) > >>

ACProdigy:
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. I have modified it to make use of a different database system, and release it under the Creative Commons License, BY/NC/SA.

Megiddo:
Good work! Especially useful with nick and steamid combo.

JamminR:
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.

ACProdigy:

--- Quote from: JamminR on January 03, 2010, 10:26:06 PM ---The one that stores nicknames... won't create duplicates if different names are used, correct?

--- End quote ---
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.

JamminR:
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>

Navigation

[0] Message Index

[#] Next page