ULX

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

0 Members and 3 Guests are viewing this topic.

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
I'm not sure what lodt means.
However, to get the old ones back, you'd need to take the old sv.db file from your original server gmod path and place it in your new gmod root.
"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
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 ?

Unfortunately, unless you have sv.db from the old server backed up, there is no way to recover the time table. Unless you have a good working knowledge of SQL, the likelihood of manually re-adding them is relatively slim.

Offline kennis942

  • Newbie
  • *
  • Posts: 22
  • Karma: 0
isnt it possible that i for example delete the current database file and only i join the server , it would be the only record so i can change it ?

Offline ACProdigy

  • Newbie
  • *
  • Posts: 21
  • Karma: 10
  • Beriddled with nonsense
This is possible to do, however you should know that if you delete your sv.db, some of your other settings may also be lost.

If you're very intent on this ( and understand the risks ), then you can do the following:
1. Delete your sv.db
2. Restart your server and join it. This will ensure your record exists.
3. Stop the server (This is important. SV.DB is sometimes readonly to other programs while a server is running)
4. Using a program called SQLite Database Browser, edit your time record in the UTime table -- the totaltime column is measured in seconds. You will have to do some math here if you wish to make it accurate.
5. Save and close the database.
6. Restart server and join. Your time should show up.

Offline kennis942

  • Newbie
  • *
  • Posts: 22
  • Karma: 0
sounds greAt i have the browser but it will not let me edit.. it says theres no table selected, anyway what are the risks ?

Offline jay209015

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 934
  • Karma: 62
    • Dev-Solutions
Quote
...what are the risks ?
     -Ruining the database
An error only becomes a mistake when you refuse to correct it. --JFK

"And thus the downfall of the great ULX dynasty was wrought not by another dynasty, but the slow and steady deterioration of the leaders themselves, followed by the deprecation of the great knowledge they possessed." -Gmod, Chapter 28, verse 34 -- Stickly

Offline ACProdigy

  • Newbie
  • *
  • Posts: 21
  • Karma: 10
  • Beriddled with nonsense
The main risk being that when you delete your sv.db, other addon information may go away. Things like prop protect, titles, user ratings, etc are stored in sv.db. If you delete it, all these values will reset to zero.

To edit a record:
1. Open sv.db using SQLite Database Browser
2. Go to the Browse tab.
3. Select UTime from the drop list (next to the magnifying glass)
4. Find your record (It won't have a name or steamid, only a uniqueid)
5. Double click the totaltime field. A box will pop up. Change the value therein to the number of seconds you want UTime to reflect. Then press the Apply / Close button.
6. Save the Database
7. Close SQLite Database Browser.

Offline comradeboris

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
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!

I get exactly the same thing when people leave my server.

Anything that can be done?

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Comradeboris, if you read a few posts after the message you quote... Megiddo states he believes he fixed that in revision 2.
Megiddo is often known to be of few words, so I'll explain a little more.
If you use the SVN of UTime, it should be working.
The SVN of UTime is available from http://ulyssesmod.net/UTime/trunk/
If you don't know how to use SVN, there's a quick tutorial in our SVN forum area.
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline comradeboris

  • Newbie
  • *
  • Posts: 14
  • Karma: 0
Comradeboris, if you read a few posts after the message you quote... Megiddo states he believes he fixed that in revision 2.
Megiddo is often known to be of few words, so I'll explain a little more.
If you use the SVN of UTime, it should be working.
The SVN of UTime is available from http://ulyssesmod.net/UTime/trunk/
If you don't know how to use SVN, there's a quick tutorial in our SVN forum area.

Thanks mate, i'll install Utime with SVN now, tbh I didnt even realize there was an SVN, a mate gave me the addon when i got my server.

- Tom

Offline Rob1991

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
  • www.cgamer.co.uk
    • Community Gamer
Couldnt find another thread to reply in, bit of an old topic, but I need to know if I can set this UTime plugin to default ON for new players on the server, at the moment they have to go to utilities to enable it!

Please help, thanks

Rob
« Last Edit: April 23, 2010, 06:16:32 PM by Rob1991 »



Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6213
  • Karma: 394
  • Project Lead
Couldnt find another thread to reply in, bit of an old topic, but I need to know if I can set this UTime plugin to default ON for new players on the server, at the moment they have to go to utilities to enable it!

Please help, thanks

Rob

I think it broke because of garry's changes to the initialization system, I'll see if I can't get a quick fix out this weekend.
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]
Couldnt find another thread to reply in, bit of an old topic<clip>

Actually, we'd prefer this over asking a brand new topic post in help and support.
The only time we don't like a bump is if it's totally off topic (brings no new information to the thread by answer or question), or if the question is answered in the thread already.
Thanks for asking a valid question...I'm not sure any of us knew it had broken.
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline Rob1991

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
  • www.cgamer.co.uk
    • Community Gamer
I think it broke because of garry's changes to the initialization system, I'll see if I can't get a quick fix out this weekend.

Awesome stuff, I love the efficiency of these forums, looking forward to hopefully seeing a fix. Its suprising how a Gmod update can cause the utime box to default off..

Actually, we'd prefer this over asking a brand new topic post in help and support.
The only time we don't like a bump is if it's totally off topic (brings no new information to the thread by answer or question), or if the question is answered in the thread already.
Thanks for asking a valid question...I'm not sure any of us knew it had broken.

Thanks for confirming ;D


Just to add, since iv changed to ASSMod the times keep getting reset when i restart the server :( Im not sure if this would have caused it or not
« Last Edit: April 24, 2010, 09:40:35 AM by Rob1991 »



Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6213
  • Karma: 394
  • Project Lead
Version 1.40 released!

Quote from: changelog
v1.40 - *(05/14/10)*
   * [FIX] A disconnect bug.
   * [FIX] Some bugs introduced by garry's updates.
Experiencing God's grace one day at a time.