vb.org Archive - Total Time Spent On Forums

Page 2 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Total Time Spent On Forums (https://vborg.vbsupport.ru/showthread.php?t=97830)

Bones_3DFC

10-13-2005 07:43 PM

To undo the query can we simply run a new query with "drop?"
Example:

Code:

ALTER TABLE `VB_user` DROP `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity` ;

curriertech

10-13-2005 08:19 PM

How hard would it be to let users decide if they want this to show, instead of it being forum-wide? I have a rather tempermental group on my hands, and while some really like this feature, others are crying about it already. :)

tnguy3n

10-13-2005 09:30 PM

Quote:

Originally Posted by exceem

Here is what i got, got around 60 in all

had no errors today, going to reinstall tomorrow and moniter what happens

from the error warning, it must be some other hacks causing that because this hack has nothing to do with showthread or viewing forum query. It only updates the 'timeonboard' field in user table.

tnguy3n

10-13-2005 09:31 PM

Quote:

Originally Posted by Bones_3DFC

To undo the query can we simply run a new query with "drop?"
Example:

Code:

ALTER TABLE `VB_user` DROP `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity` ;

yup, and reverse your modified file. :)

tnguy3n

10-13-2005 09:33 PM

Quote:

Originally Posted by curriertech

Just simply add an additional field which give users an options whether to show that or not. Then in plugin, put a condition to check whether to show it. :)

tanyeri24

10-13-2005 11:46 PM

Quote:

Originally Posted by exceem

is there any way to display a "top 10 list of the time spent online" ?

is there?

exceem

10-14-2005 05:57 AM

Quote:

Originally Posted by tnguy3n

from the error warning, it must be some other hacks causing that because this hack has nothing to do with showthread or viewing forum query. It only updates the 'timeonboard' field in user table.

The only other hacKs i have installed is vbadvanced, and a "whos visited today"

Ill reinstall today and see what happens, had it just been over1 day I would have put it down to a server glitch, but over 3 days it woudl be something else :ermm:

eXtremeTim

10-14-2005 06:37 AM

Quote:

Originally Posted by tnguy3n

PHP Code:


		
			
$average = (TIMENOW - $post[joindate])/86400;

Umm that wont work quite right lol. That would give me the number of days they have been registered. ;)

Now I think I see what your saying lol. Your giving me a way to get to the solution. ;)

I didnt need any help there lol I was just more or less trying to suggest it as a feature becuase the 3.0.x version had it as a feature. ;)

tnguy3n

10-14-2005 01:41 PM

Quote:

Originally Posted by eXtremeTim

lol... my bad.
try:

PHP Code:


		
			
$average = $post[timeonboard]/((TIMENOW - $post[joindate])/86400);

GamerJunk.net

10-25-2005 10:59 AM

Sorry if this has been asked before, but does this also include time spent in the admincp?

Rickie3

11-03-2005 08:41 AM

i have this installed great hack,i have it showing in post bit,is there any way you can get it to show in member list as well?

Rickie3

11-06-2005 09:23 AM

"bump" anyone please

funinthesun

11-06-2005 01:08 PM

I've installed the timeonboardinprofile but nothing shows up? Do I have to install the totaltimeonboard as well? :confused:

007	11-07-2005 02:03 AM

Um, why is this listed as an Extension when it requires a file edit of class_core.php? A little disapointing to find out after downloading. :( Is there any way this will be possible without file edits in the future?

fiber_cut

11-07-2005 04:15 AM

I installed this and done as it says I cant get it to display the timespent..

any ideas?

funinthesun

11-07-2005 08:53 AM

I've installed the timeonboardinprofile but nothing shows up? Do I have to install the totaltimeonboard as well? :confused:

Smitty

11-07-2005 09:34 AM

Quote:

Originally Posted by funinthesun

I've installed the timeonboardinprofile but nothing shows up? Do I have to install the totaltimeonboard as well? :confused:

Appears it's not supported...

funinthesun

11-07-2005 03:47 PM

So does anyone have any ideas as to why nothing is showing up then?

tnguy3n

11-15-2005 01:22 AM

Quote:

Originally Posted by Rickie3

i have this installed great hack,i have it showing in post bit,is there any way you can get it to show in member list as well?

you don't have to install both, but if you install totaltime in profile, you have to insert the query which add a new column timeonboard or you might even get database error.
here's the query:

Code:

ALTER TABLE `user` ADD `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity`;

tnguy3n

11-15-2005 01:26 AM

Quote:

Originally Posted by Rickie3

i have this installed great hack,i have it showing in post bit,is there any way you can get it to show in member list as well?

Rickie,

you can copy the function to convert times in seconds (timeonbaord) to its proper display, then create a new plugin in memberlist (probably), and change:
$post['timeonboard'] = ....
to
$userinfo['timeonboard'] = ...

in your memberlist template,
add $userinfo[timeomboard] to where you want it to show.

And sorry folks, I barely got any bare time, so support for this hack is very limited.

puertoblack2003

11-19-2005 12:24 AM

great Hack *******INSTALLED**** no problems

board.trash

11-25-2005 02:21 PM

another nice hack from my friend tnguy3n :)

Thx ( clicks install )

MissKalunji

11-26-2005 12:50 AM

nuthing showing for me......

tnguy3n

11-26-2005 01:44 AM

@ board.trash: thanks, mate.

@ MissKalunji: try to add modify both postbit and postbit_legacy templates.

MissKalunji

11-26-2005 02:06 AM

Quote:

Originally Posted by tnguy3n

@ board.trash: thanks, mate.

@ MissKalunji: try to add modify both postbit and postbit_legacy templates.

im trying on the member info page....

tnguy3n

11-26-2005 02:10 AM

Quote:

Originally Posted by MissKalunji

im trying on the member info page....

It was meant to be an add-on for the Total Time Spent On Forums; however, if you want to install it as a stand-alone, you have to run the following query:

PHP Code:


		
			
ALTER TABLE `user` ADD `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity`;

MissKalunji

11-26-2005 02:53 AM

Quote:

Originally Posted by tnguy3n

It was meant to be an add-on for the Total Time Spent On Forums; however, if you want to install it as a stand-alone, you have to run the following query:

PHP Code:


		
			
ALTER TABLE `user` ADD `timeonboard` INT( 10 ) NOT NULL AFTER `lastactivity`;

not working thanks anyway

ImportPassion

11-29-2005 02:54 AM

couldn't this be put in a plugin and called on init_startup?

PHP Code:


		
			
if(TIMENOW - $this->userinfo['lastactivity'] > $this->registry->options['cookietimeout'])

{

$newtime = '0';

}

else

{

$newtime = TIMENOW - $this->userinfo['lastactivity'];

}



$this->registry->db->shutdown_query("                        UPDATE " . TABLE_PREFIX . "user

        SET timeonboard = timeonboard + $newtime

        WHERE userid = " . $this->userinfo['userid']."");

or am i way off base?

Chris M

12-01-2005 06:41 AM

Moved to correct forum :)

Chris

nintendo

12-03-2005 09:05 PM

If you get..

Quote:

You have to choose at least one Column to display

in phpMyAdmin, go to 'user' then use the 'Run SQL query/queries on database' form there, at the bottom

kahmeal

12-07-2005 04:00 PM

Trying to install this hack but even with all the lines uncommented in total_time_on_board.xml I am only getting a large number like Total Time Spend On Board: 2053

The user table has been modified to include a timeonboard column, it seems like the plugin isn't doing the calculations/formatting at all... Any ideas?

hotwheels

12-28-2005 06:44 PM

Thanks man, great hack.......... Hotwheels clicks *install*

Ragnarok

12-31-2005 06:50 AM

Quote:

Originally Posted by kahmeal

Planning to install, any chance of a fix for this? I get the same problem.

Rickie3

01-07-2006 10:30 AM

ive had this hack installed for a while now,but for some unknown reason it has stalled,meaning my time online hasnt changed for the past week,has remained the same for over a week and not updating,any advise appreciated

lifesourcerec

01-07-2006 05:29 PM

Quote:

Originally Posted by TygerTyger

I've installed it in memberinfo_complete and it seems to be running fine, but it's simply displaying the time spent as numbers, without hours/seconds or whatever. It simply says time spent: 644

Any idea what the problem might be?

I'm having this same issue.

IrPr	01-11-2006 11:25 PM

Quote:

Originally Posted by lifesourcerec

I'm having this same issue.

make sure that u upload plugins

peterska2

01-11-2006 11:35 PM

Quote:

Originally Posted by Rickie3

Let me see......

[high]* peterska2 gazes into crystal ball[/high]

You upgraded to 3.5.3
Your times stopped
You didn't re-apply the one code modification.

Don't worry, I do it every time.

lifesourcerec

01-12-2006 01:56 AM

Quote:

Originally Posted by Moosa

make sure that u upload plugins

They are uploaded to includes/xml/ and still same results. Everything seems to be in seconds.

Rickie3

01-12-2006 04:33 AM

Quote:

Originally Posted by peterska2

Let me see......

[high]* peterska2 gazes into crystal ball[/high]

You upgraded to 3.5.3
Your times stopped
You didn't re-apply the one code modification.

Don't worry, I do it every time.

no i didnt upgrade,i installed another hack that required to edit the class_core.PHP,i FTP the file incorrectly lol,all is good now

IrPr	01-12-2006 08:16 AM

Quote:

Originally Posted by lifesourcerec

They are uploaded to includes/xml/ and still same results. Everything seems to be in seconds.

same problem here untill re-uploading plugins

make sure u uploaded total time on board.zip plugin

All times are GMT. The time now is 10:55 PM.

Page 2 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02201 seconds Memory Usage 1,840KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (5)bbcode_php_printable (21)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: