ULX
« previous next »
Pages: 1 ... 4 5 [6] 7 8 ... 28   Go Down

Author Topic: Utime -- Show how long your players have been connected this session and total  (Read 554789 times)

0 Members and 1 Guest are viewing this topic.

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #75 on: February 17, 2009, 07:45:30 AM »
It's based off unique ids... I'm not sure how those are generated in the first place, so there's no way to map to the new ones (that I know of), sorry.
Logged
Experiencing God's grace one day at a time.

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
Re: Utime -- Show how long your players have been connected this session and total
« Reply #76 on: February 17, 2009, 11:13:57 AM »
I know UTime works with unique IDs.

unique IDs are generated based on a person's SteamID. I dunno how hard it would be to change all the UniqueID's to match the new UniqueID generated by the new SteamID update. Since I had a modified version which used SteamIDs.. it wasnt hard to go in and change the SteamID's to add a 1 instead of the 0.. but having it use uniqueids adds a whole new level of wtf to the situation..


tl;dr....
In short... No.. there is no easy way to get the script to grab the correct data.
In long.. if you can figure out who is who and how UniqueIDs are generated.. it may be posible to run a query on the sqlite server (What UTime uses) and convert the old ids to the new ones and then it'll work with the old data.

If all you had was time data.. as much as it may suck.. just tell your peoplle that the data needed to be reset due to an update that valve put out.. it'll save you a LOT of time and heartache in the longrun.
Logged

Offline Cornflake

  • Newbie
  • *
  • Posts: 26
  • Karma: 0
Re: Utime -- Show how long your players have been connected this session and total
« Reply #77 on: February 19, 2009, 02:30:54 AM »
Just out of curiosity, why was the choice made to store the time information in a database file using UIDs? Why not just use SteamIDs (and even possible generated text files) like APromotion?

I ask this in light of the fact it's much easier to go and change all the SteamIDs (Nearly impossible to do this with UIDs) if Valve decides to change everyone's ID again. But for the time being it seems they've reverted the changes, and things seem to be working okay.
« Last Edit: February 19, 2009, 02:32:49 AM by Cornflake »
Logged

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #78 on: February 19, 2009, 09:09:37 AM »
I used UIDs so UTime would work on LAN servers. Obviously VALVe changing steamids was not part of my consideration. :P
Logged
Experiencing God's grace one day at a time.

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
Re: Utime -- Show how long your players have been connected this session and total
« Reply #79 on: February 19, 2009, 10:57:15 AM »
Seriously.. my steam ID has been the same for how many years now.. then they just decide to change it?

Its MORE likely that garry would do something to break the lua than SteamIDs changeing.. just a unforseen niche in the plan.


Also SQL even SQLite is more effecient way of storing the data.. its faster (server side) easier to read and write too.. and less clutter in teh data folder.
Logged

Offline Dv2236

  • Jr. Member
  • **
  • Posts: 89
  • Karma: 0
    • MyGamingVoid
Re: Utime -- Show how long your players have been connected this session and total
« Reply #80 on: February 19, 2009, 10:54:45 PM »
What I find super funny is after they did this and I know 4 people that changed all steam ID from steam_0 to steam_1
they just ended up changing it back making them 4 guys re-do it all over again haha, my lazy ass just re-added myself only :P
Logged

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
Re: Utime -- Show how long your players have been connected this session and total
« Reply #81 on: February 20, 2009, 04:57:10 PM »
Quote from: Dv2236 on February 19, 2009, 10:54:45 PM
What I find super funny is after they did this and I know 4 people that changed all steam ID from steam_0 to steam_1
they just ended up changing it back making them 4 guys re-do it all over again haha, my lazy ass just re-added myself only :P

Funny thing is.. I had to do that.. but not only in text files.. I changed over 7 THOUSAND steamIDs in my database... and then had to change them back the next day... Wasnt hard.. i have my ways.. but STILL!! come on...
Logged

Offline lolol

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Re: Utime -- Show how long your players have been connected this session and total
« Reply #82 on: April 07, 2009, 05:51:47 AM »
My UTime does not store any information  :-[
If a player rejoins, if there's a map/server restart... the time is reset. How can I fix this issue?
Logged

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #83 on: April 25, 2009, 10:04:00 AM »
Quote from: lolol on April 07, 2009, 05:51:47 AM
My UTime does not store any information  :-[
If a player rejoins, if there's a map/server restart... the time is reset. How can I fix this issue?

Is your database in the folder? Is it read-only?
Logged
Experiencing God's grace one day at a time.

Offline ACProdigy

  • Newbie
  • *
  • Posts: 21
  • Karma: 10
  • Beriddled with nonsense
Re: Utime -- Show how long your players have been connected this session and total
« Reply #84 on: July 02, 2009, 06:29:11 PM »
I've mashed together some code to get UTime working for MySQL databases.

The code is written in terms of quickly opening and closing connections, and is best suited on a machine serving both gmod and MySQL locally. It could easily be altered to work with a persistent connection for larger tasks (such as the UpdateAll function).

I'm willing to clean this up a bit and make it more user friendly if anybody else is interested in it. (Currently it writes MySql connected/Disconnected/QueryStatus to the server console whenever there is activity, sort reusable code into functions, etc)

[edit] Also, I've written a script for migrating an existing sqlite utime table to a mysql table if it exists.
« Last Edit: July 02, 2009, 06:50:35 PM by ACProdigy »
Logged

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #85 on: July 02, 2009, 07:09:42 PM »
Quote from: ACProdigy on July 02, 2009, 06:29:11 PM
I've mashed together some code to get UTime working for MySQL databases.

The code is written in terms of quickly opening and closing connections, and is best suited on a machine serving both gmod and MySQL locally. It could easily be altered to work with a persistent connection for larger tasks (such as the UpdateAll function).

I'm willing to clean this up a bit and make it more user friendly if anybody else is interested in it. (Currently it writes MySql connected/Disconnected/QueryStatus to the server console whenever there is activity, sort reusable code into functions, etc)

[edit] Also, I've written a script for migrating an existing sqlite utime table to a mysql table if it exists.

Good work! :)
Logged
Experiencing God's grace one day at a time.

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Utime -- Show how long your players have been connected this session and total
« Reply #86 on: July 02, 2009, 09:43:31 PM »
Quote from: ACProdigy on July 02, 2009, 06:29:11 PM
I'm willing to clean this up a bit and make it more user friendly if anybody else is interested in it.

Prodigy, though the true ded server + SQL + other major geek point true 'admin' experienced users around the gmod community are a small niche... always feel free to improve upon something like this.
Though I personally just hang out with the cool geeks here (I don't know SQL), I know that several here do, and know even more willing to look and learn.
Logged
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline ACProdigy

  • Newbie
  • *
  • Posts: 21
  • Karma: 10
  • Beriddled with nonsense
Re: Utime -- Show how long your players have been connected this session and total
« Reply #87 on: July 02, 2009, 09:49:18 PM »
Quote from: JamminR on July 02, 2009, 09:43:31 PM
Prodigy, though the true ded server + SQL + other major geek point true 'admin' experienced users around the gmod community are a small niche... always feel free to improve upon something like this.

I enjoy coding, and I'm working on a full gmod web interface (for rating tables / administration), so I figured this would be a good place to start. I'll clean it up and make it more user friendly. I modified UTime a long time ago to dynamically create images (think: steamCard, example: http://fredluti.ath.cx/dcc/playerInfo.php?id=6), but it was dirty code.. Always good to start fresh.

-EDIT-
New version is ready. Cleaned up code somewhat, removed mysql debug console spam. This version reliably creates a utime database if one doesn't exist. If I continue developing UTime for MySQL, should it be branched or shall I just keep posting releases in the main UTime category? Either way is fine.

UTime-SuiScoreboard works natively with the modifications to Utime due to the way the total time is read. (so anybody using sui scoreboard won't have to change anything to use the MySQL version of UTime)
« Last Edit: July 03, 2009, 09:54:59 AM by ACProdigy »
Logged

Offline Jethro

  • Newbie
  • *
  • Posts: 45
  • Karma: 1
Re: Utime -- Show how long your players have been connected this session and total
« Reply #88 on: July 07, 2009, 02:14:11 PM »
Hi,
Im using Utime version 1.3

Keep getting this error when people leave:
Code: [Select]
Player legendoflife21 left the game (Disconnect by user.)
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
autorun/cl_utime.lua:236: Tried to use a NULL entity!
« Last Edit: July 07, 2009, 04:00:03 PM by Jethro »
Logged

Offline kennis942

  • Newbie
  • *
  • Posts: 22
  • Karma: 0
Re: Utime -- Show how long your players have been connected this session and total
« Reply #89 on: July 18, 2009, 05:33:32 PM »
hello we just changed server and i lost my 200 hours of playtime and i realy need them back, the old file is lodt , is there any way of setting them back ?
Logged
Pages: 1 ... 4 5 [6] 7 8 ... 28   Go Up
« previous next »