« previous next »
Pages: 1 ... 8 9 [10] 11 12 ... 28   Go Down

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

0 Members and 1 Guest are viewing this topic.

Offline Botman

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Re: Utime -- Show how long your players have been connected this session and total
« Reply #135 on: February 08, 2011, 01:58:07 PM »
The most recent gmod update seems to have caused the play time of all players in my server to be reset to 0. Is there anything to do..?

edit: this has actually become really, really severe in my server. I'm running a quite active sandbox server and I'd have no chance of manually resetting every player's play time -- there are just way too many and there must be another solution for me. I'm also using the promotion script which relies on UTime; and it doesn't even respond to UTime anymore despite displaying no lua errors. (I'm able to set UTime manually thanks to Aaron113's code above.) I have a feeling there's something mysterious to it judging by the way UTime is behaving. I'm also afraid that the script is now overwriting the old player time saves so that no matter if the problem is resolved, my every players' time will be reset to 0 and forced to start over again. This in turn would cause longstanding consequences for the established player environment in the server.
« Last Edit: February 08, 2011, 02:26:36 PM by Botman »
Logged

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6213
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #136 on: February 08, 2011, 09:18:55 PM »
Perhaps there's something wrong with the database? You could try deleting the "sv.db" file in the garrysmod root and set everyone's time manually again to see if that fixes your problem.
Logged
Experiencing God's grace one day at a time.

Offline Botman

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Re: Utime -- Show how long your players have been connected this session and total
« Reply #137 on: February 09, 2011, 10:04:17 AM »
Just tried that, Megiddo. Yes, it does stabilise the database and fixes all other problems scriptwise. This still feels very hopeless though as I've absolutely not got enough time to reset everyone's time manually, the task would be too immense (this is a 16-slots, and active). What can I do? Please, please tell me there are any options...
Logged

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6213
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #138 on: February 09, 2011, 10:31:20 AM »
Quote from: Botman on February 09, 2011, 10:04:17 AM
Just tried that, Megiddo. Yes, it does stabilise the database and fixes all other problems scriptwise. This still feels very hopeless though as I've absolutely not got enough time to reset everyone's time manually, the task would be too immense (this is a 16-slots, and active). What can I do? Please, please tell me there are any options...

If I were in your shoes, I'd probably look into using an sqlite tool to export the UTime table, then import it into the new database. My experience with SQL is limited, so your mileage may vary. I'm not sure what caused your issues in the first place, so this might just bring the problems to the new database...
Logged
Experiencing God's grace one day at a time.

Offline saintwubbles

  • Newbie
  • *
  • Posts: 15
  • Karma: 3
Re: Utime -- Show how long your players have been connected this session and total
« Reply #139 on: February 10, 2011, 08:52:11 AM »
Having trouble with UtimeM as well since this update.

Timer Error: [@addons\ulx\lua\ulx\lib.lua:70] bad arguement #2 to 'format' (number expected, got nil)
« Last Edit: February 10, 2011, 08:57:22 AM by saintwubbles »
Logged

Offline Stickly Man!

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 1270
  • Karma: 164
  • What even IS software anymore?
    • XGUI
Re: Utime -- Show how long your players have been connected this session and total
« Reply #140 on: February 10, 2011, 11:55:00 AM »
That was the same error I got when I was fixing the error in this thread here: http://forums.ulyssesmod.net/index.php/topic,5173.0.html

Make sure your ULX SVN is up-to-date then post in that thread if you have further issues.
Logged
Join our Team Ulysses community discord! https://discord.gg/gR4Uye6

Offline krooks

  • Sr. Member
  • ****
  • Posts: 382
  • Karma: 32
  • I don't like video games.
    • Diamond Krooks
Re: Utime -- Show how long your players have been connected this session and total
« Reply #141 on: January 20, 2012, 07:14:14 PM »
-snip-
« Last Edit: January 23, 2012, 12:49:01 PM by krooks »
Logged
My TTT server. Join the fun!

Offline krooks

  • Sr. Member
  • ****
  • Posts: 382
  • Karma: 32
  • I don't like video games.
    • Diamond Krooks
Re: Utime -- Show how long your players have been connected this session and total
« Reply #142 on: January 23, 2012, 12:48:24 PM »
Sorry for so many edits,
I first posted and said I had a database error related to utime, causing the server to go into restart loops.
I then snipped the post, because I was able to look at the database and found that it was used by many other services within gmod, and couldn't be sure utime was at fault.

I have since looked at it and after changing something that I thought to be an error, my server is now working again, it was in fact related to utime.

On the utime table I have 1000 entries.
There is another table called "sqlite_sequence" and it lists utime among other things like sui_ratings, then there is a "seq" column, this column seems to contain the number of entries for each table it lists. utime's entry was 1644.

Changing this to match the actual table 1000, seemed to fix things.

I still don't know if utime is to blame or if something else is. Or if this is a permanent fix. I thought I'd report it none the less.
Logged
My TTT server. Join the fun!

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6213
  • Karma: 394
  • Project Lead
Re: Utime -- Show how long your players have been connected this session and total
« Reply #143 on: January 25, 2012, 04:06:30 PM »
Looking at the documentation for that table, I'm inclined to believe that either a rogue addon modified the table or Garry can't even implement simple C libraries correctly...
Logged
Experiencing God's grace one day at a time.

Offline krooks

  • Sr. Member
  • ****
  • Posts: 382
  • Karma: 32
  • I don't like video games.
    • Diamond Krooks
Re: Utime -- Show how long your players have been connected this session and total
« Reply #144 on: January 27, 2012, 02:15:36 PM »
Hmm, ok, thanks for the reply. Sorry if I've brought this thread off topic  :P
It's back to it's restart loops again, and those tables all match up this time, so I'm stumped as to what the issue is now. Wont post back here about it though if I have questions  ;D
Logged
My TTT server. Join the fun!

Offline ThatBum

  • Newbie
  • *
  • Posts: 14
  • Karma: 2
Re: Utime -- Show how long your players have been connected this session and total
« Reply #145 on: March 25, 2012, 06:25:30 PM »
Can we has UtimeM version of setutime? I tried converting it myself using UtimeM's MySQL syntax but I'm failing at it.
Logged

Offline Aaron113

  • Hero Member
  • *****
  • Posts: 803
  • Karma: 102
Re: Utime -- Show how long your players have been connected this session and total
« Reply #146 on: March 25, 2012, 06:33:38 PM »
Logged

Offline ThatBum

  • Newbie
  • *
  • Posts: 14
  • Karma: 2
Re: Utime -- Show how long your players have been connected this session and total
« Reply #147 on: March 25, 2012, 11:20:52 PM »
Yessir. It was from when I imported the data from the SQLite3 DB from standard UTime, and it got wiped from a Source engine update a long time ago. So, I need to manually add time to people, even though it's on MySQL now.
Logged

Offline thegtz

  • Newbie
  • *
  • Posts: 25
  • Karma: 0
Re: Utime -- Show how long your players have been connected this session and total
« Reply #148 on: April 09, 2012, 04:29:50 PM »
How would I make this addon run off of Utime?

http://www.garrysmod.org/downloads/?a=view&id=103559

Trying to make it use data from Utime instead of a PlayerTimes file.

Example when a player plays a certain amount of time(ex. 6hrs according to Utime) then he will get promoted to the next rank according to settings in TimeSpent.
Logged

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 #149 on: April 09, 2012, 08:01:33 PM »
You mean this? AutoPromote - http://forums.ulyssesmod.net/index.php/topic,3826.msg13322.html#msg13322 (OLD code)
And this code from Aaron in Jan 2011 would probably have much more chance of working due to original's age.
http://forums.ulyssesmod.net/index.php/topic,3826.msg22128.html#msg22128
(Though, even the 2011 code may not work)
Logged
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming
Pages: 1 ... 8 9 [10] 11 12 ... 28   Go Up
« previous next »