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

JamminR · « **Reply #90 on:** July 18, 2009, 09:25:58 PM »

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.

ACProdigy · « **Reply #91 on:** July 19, 2009, 01:04:49 AM »

Quote from: kennis942 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 ?

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.

kennis942 · « **Reply #92 on:** July 20, 2009, 05:10:27 AM »

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 ?

ACProdigy · « **Reply #93 on:** July 20, 2009, 08:13:06 AM »

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.

kennis942 · « **Reply #94 on:** July 20, 2009, 08:47:15 AM »

sounds greAt i have the browser but it will not let me edit.. it says theres no table selected, anyway what are the risks ?

jay209015 · « **Reply #95 on:** July 20, 2009, 08:59:23 AM »

Quote

...what are the risks ?

-Ruining the database

ACProdigy · « **Reply #96 on:** July 20, 2009, 08:59:59 AM »

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.

comradeboris · « **Reply #97 on:** September 04, 2009, 07:45:15 PM »

Quote from: Jethro 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!

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

Anything that can be done?

JamminR · « **Reply #98 on:** September 04, 2009, 08:27:18 PM »

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.

comradeboris · « **Reply #99 on:** September 05, 2009, 07:26:34 PM »

Quote from: JamminR on September 04, 2009, 08:27:18 PM

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

Rob1991 · « **Reply #100 on:** April 23, 2010, 06:10:26 PM »

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

Megiddo · « **Reply #101 on:** April 23, 2010, 07:38:38 PM »

Quote from: Rob1991 on April 23, 2010, 06:10:26 PM

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.

JamminR · « **Reply #102 on:** April 23, 2010, 08:19:49 PM »

Quote from: Rob1991 on April 23, 2010, 06:10:26 PM

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.

Rob1991 · « **Reply #103 on:** April 24, 2010, 02:14:00 AM »

Quote from: Megiddo on April 23, 2010, 07:38:38 PM

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

Quote from: JamminR on April 23, 2010, 08:19:49 PM

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

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

Megiddo · « **Reply #104 on:** May 14, 2010, 01:30:33 PM »

Version 1.40 released!

Quote from: changelog

v1.40 - *(05/14/10)*
* [FIX] A disconnect bug.
* [FIX] Some bugs introduced by garry's updates.

Ulysses

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

JamminR

Re: Utime -- Show how long your players have been connected this session and total

ACProdigy

Re: Utime -- Show how long your players have been connected this session and total

kennis942

Re: Utime -- Show how long your players have been connected this session and total

ACProdigy

Re: Utime -- Show how long your players have been connected this session and total

kennis942

Re: Utime -- Show how long your players have been connected this session and total

jay209015

Re: Utime -- Show how long your players have been connected this session and total

ACProdigy

Re: Utime -- Show how long your players have been connected this session and total

comradeboris

Re: Utime -- Show how long your players have been connected this session and total

JamminR

Re: Utime -- Show how long your players have been connected this session and total

comradeboris

Re: Utime -- Show how long your players have been connected this session and total

Rob1991

Re: Utime -- Show how long your players have been connected this session and total

Megiddo

Re: Utime -- Show how long your players have been connected this session and total

JamminR

Re: Utime -- Show how long your players have been connected this session and total

Rob1991

Re: Utime -- Show how long your players have been connected this session and total

Megiddo

Re: Utime -- Show how long your players have been connected this session and total