vb.org Archive - Total Time Online Hack v1.0

Page 7 of 8

« First

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

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Total Time Online Hack v1.0 (https://vborg.vbsupport.ru/showthread.php?t=42864)

Bison

10-24-2002 12:13 AM

For some unknow reason, my time counter isn't working ... would changing the permissions to who's time to show stop this hack from working?

All I did was prevented the admin and zero posters from showing up in the time leaders list, getinfo and the threads?
:(

snack

10-24-2002 05:45 PM

Yea i need help i keep getting that divsion zero error on the leader page? which file do i need to edit to fix it?

girlzclan

10-28-2002 01:00 AM

my is stuck at zero in the threads and 0 on the timeonline page. I had it working on a previous forum but now it's broke :/

lmao helps if i fully install the hack
<-- retard

Bison

10-28-2002 11:07 AM

I figured out why the times stopped working ... I included a condition into the sesions.php file and it stopped recording time for everyone instead of the admin. I removed the condition and now everyone's time is being recorded again!

Merjawy

10-29-2002 07:46 AM

nice hack I installed it with the zero problem but thanx I fixed it too and working on 226 now

but what about guests? I love to have something works with whos online

I have a guest that seems to be stuck on my forum of 3 days now.. same IP never left.. jumpts from post to another, attempts to post, quote, edit post, mod. tools, add member to buddy, add member to ignore etc etc.. and hes been at it for 3 days non stop

even shut down the server and back up and hes was back the minute it returned

I am not sure whats going on.. my forum is kinda interesting.. but not that much to have someone on it 3 days and he is still there now.. I had watched him for many hours and had others watch him.. never seen him leave

can't be a bot as he was attempting to do things
his IP traced to Japan but that could verywell be proxy

I just wanted to make a record of his time online :)
and yes it worries me and wonder what the heck is he up to

first thought he could be a bored kid.. but 3 days and still going? hmmmmmm

Mystic XL

11-12-2002 08:09 AM

Sorry but I can't read through all those pages heh, but I keep getting this error on the view leader page

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

Warning: Division by zero in /home/sjmadho/public_html/board/timeonline.php on line 42

you can view it at http://www.sjmadhouse.net/board/time...fo=view_leader

Erwin

11-12-2002 08:16 AM

Quote:

Originally posted by Merjawy
I have a guest that seems to be stuck on my forum of 3 days now.. same IP never left.. jumpts from post to another, attempts to post, quote, edit post, mod. tools, add member to buddy, add member to ignore etc etc.. and hes been at it for 3 days non stop

That's a search engine spidering bot, probably from Google. Google is actively spidering at the moment.

Erwin

11-12-2002 08:18 AM

Quote:

Originally posted by Mystic XL
Sorry but I can't read through all those pages heh...

Use the "Search This Thread" box on the bottom right hand corner.

g-force2k2

11-19-2002 04:09 PM

Mystic XL change is included in the zip... for fixing the division by zero error...

regards...

g-force2k2

matthepepe

11-21-2002 04:30 AM

im trying to find out what code i ahve to add where to get the online time to show in the postbit.

matthepepe

11-21-2002 04:36 AM

Nevermind forget that ... i got it now .. i forgot to look at the original post bit.

Molok

12-17-2002 11:44 AM

I think its only a little problem what i have here.

when I Click on a Username in the Total Time Online Statistik i becomes a message thats the user is not registrated an so it have no Profil ?

How I can fix this problem ?

N9ne	12-17-2002 09:12 PM

How could I make it so if you're in usergroupid=X and you are invisible, the time is not added on?

MetroSports82

01-05-2003 01:28 PM

Sorry, bit late here eh? never got a chance to install this. works great for 2.2.9. anyway just wanted to say, awesome hack g-force2k2!! :)

S1R1US

02-05-2003 04:32 AM

I get database error when try to install it. After I followed instructions exactly before i started on templates i went to the forum and forums didn't work. Had database error.

i'm trying it on v2.2.9 btw

Does it not work on 2.2.9 or something? If thats not the reason then look forward to your response on why get database error.

007	02-09-2003 11:55 PM

i got it in 2.2.9 with little problems. only problem i got is on the postbit under report this post and ip logged, it just has a link "Time Online:" and nothing else. anyone know what could be causing this?

----------

k i found the problem. if anyone is having trouble getting this to work in the postbit, refer to Post #18

:)

S1R1US

02-10-2003 12:06 AM

how do i do this?

Queries to Run (1)
// +++++++++++++++++++++
ALTER TABLE user ADD timeonline int(10) NOT NULL DEFAULT '0'

Also when someone says run the file to install from the admincp how do i do that? Thanks.

007	02-10-2003 11:40 AM

i did it in phpMyAdmin. which I just discovered yesterday lol. there are other ways but i couldn't tell you. just ask your hosting provider where phpMyAdmin is in your website directory or if tehy can install it and tehn go into it and run the querie:

ALTER TABLE user ADD timeonline int(10) NOT NULL DEFAULT '0'

i'm bad at explaining it. sorry.

S1R1US

02-12-2003 06:45 AM

i have no clue what phpMyAdmin is and u didn't really help because all u said was go into it and run the queries. but i don't know how to run the query's. It must be done in AdminCP since thats what it said in the instuctions so where do i go in AdminCP and how do i do it? THanks.

007	02-12-2003 11:56 AM

Ok, here's a better response. Straight from Logician's "How To Install a vbulletin Hack: Guide to Newbies."

Quote:

10- Sometimes a hack may require you run a SQL command. Before running SQL queries in your MYSQL database make sure you backed up your database. To run SQL queries you have 3 options:

Your server may have an utility like "PHPmyAdmin" to run SQL queries. You can use these utilities.
You can use this vbulletin hack which helps you run SQL queries via Your VB Admin Control Panel
You can use this small independent script which have the same feature.

If you contact your host, they may be able to set up phpMyAdmin on your server. If so, then please view the attached image to see where you will enter the query. Simply enter it and click go. :)

ranger2kxlt

02-12-2003 01:19 PM

Love the idea of the hack but i dont want it to display the amount of time online anywhere except when i rollover a users name in the whos online box on the main forum page or on the whosonline page. How would i go about doing this? Thanks.

Silenced Soul

02-23-2003 05:47 AM

S1R1US, make a file called:
totalquery.php and put the following code in it:

PHP Code:


		
			
<?php

error_reporting(7);

require("./global.php");



cpheader("<title>Run a Query</title>");



$totalquery = "ALTER TABLE user ADD timeonline int(10) NOT NULL DEFAULT '0'";

$DB_site->query($totalquery);



echo "Query successful.<br>";

echo "<font face='Courier New' size='1'>$totalquery</font><br><br>";

echo "Do not forget to delete this file...";



cpfooter();

?>

Upload it to your admincp, run the file, and then delete it. This will run the query directly through the admin cp, therefore bypassing any need for phpMyadmin or any other query running program, although, I highly recommend getting phpMyadmin or one of the several Query DB hacks floating around.

LangTuDaTinh

03-13-2003 06:17 AM

Quote:

Originally posted by N9ne
How could I make it so if you're in usergroupid=X and you are invisible, the time is not added on?

have not do this yet but i added an option in usercp edit option where user can choose whether to display their total time online or not

the default is on but if they select no, total time online will be disappear in all (include in their profile(or getinfo), time learder, and their posts) and only usergroupid ==6 can view all user's timeonline even if they disable it in their usercp.

even if they disable timeonline in their usercp, their time still adding.

pattox

03-16-2003 12:20 PM

What if I dont want to show the days? How would I need to modify the code? I just want it to continue counting the hours. and if possible to stop counting seconds when it reaches 24 hours.

Airs	04-13-2003 05:27 PM

Hi i was installing the hack and all and got this error

Error
SQL-query : [Edit]

ALTER TABLE user ADD timeonline int
(10) NOT NULL DEFAULT \'0\'

MySQL said:

You have an error in your SQL syntax near '\'0\'' at line 2

in phpmyadmin can anyone please help? and great hack!.

Craigr

04-13-2003 06:12 PM

Quote:

08-30-02 at 01:12 AM Souly said this in Post #69
I have do the follow to calculate a correct "Time Online Per Day".

First you need the Timestamp (LINUX) before you start to install my changes! ! !

in timeonline.php find:

PHP Code:

        $daysregs = floor((time() - $lead[2]) / 86400);

change it to: [installtimestamp=yourtimestampyou must change it manually]

PHP Code:

          $daysregs = floor((time() - installtimestamp) / 86400);

I have Start the Tool now, an now is Linuxtime=1030666140 - also my Code is

PHP Code:

          $daysregs = floor((time() - 1030666140) / 86400);

And don?t look on my bad english - first learn german :lick:

Thanks, this works well on my forum. The 'time online per day' was starting from when my forum first opened so the values were very low, but this sorted it out.

Thanks
Craig

kdog316

04-22-2003 02:14 AM

when i try to go to my profile i get this erorr

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM storeextra WHERE action='midi' AND userid='1'
mysql error: Table 'kdog316_vb.storeextra' doesn't exist

mysql error number: 1146

Date: Monday 21st of April 2003 07:12:03 PM
Script: http://www.allaroundsite.com/forums/...tinfo&userid=1
Referer: http://www.allaroundsite.com/forums/

Intex

04-27-2003 06:05 PM

Great hack g-force2k2. Worked great running 2.2.6 with the zero.php instructions to fix the divide by zero problem.

/me clicks install.

Intex

04-27-2003 06:09 PM

Not sure but it doesn't look like this hack caused that particular problem. I remember there was a hack that allowed you to play a midi file in your profile. It looks like, from the SQL statement, that this table is missing.

Perhaps you were installing this hack at the same time or didn't include the query from that hack and have never been to the profile since its installation?

Quote:

04-22-03 at 04:14 AM kdog316 said this in Post #267
when i try to go to my profile i get this erorr

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM storeextra WHERE action='midi' AND userid='1'
mysql error: Table 'kdog316_vb.storeextra' doesn't exist

mysql error number: 1146

Date: Monday 21st of April 2003 07:12:03 PM
Script: http://www.allaroundsite.com/forums/...tinfo&userid=1
Referer: http://www.allaroundsite.com/forums/

trafix

04-27-2003 11:07 PM

I realy dont want to install this hack for 2 reasons....

1) I dont want my members to suddenly leave the site if they realise they have been there for some time.
2) My wife will fill me cos she will know exactly how much time is spend working on the site :)

Might install at a later date

Alien

04-28-2003 08:11 AM

Has the original install file ever been modified to the version that TECK had spoken about that would involve absolutely ZERO queries at all?

It was mentioned here:
https://vborg.vbsupport.ru/showthrea...011#post302011

I'm interested in installing this with zero queries, if it is definatly possible to do so. Who wouldn't?

Thanks. :)

-Jason

PurpleCow

05-11-2003 02:40 PM

Has anyone tested this to be working perfectly fine in ver2.3.0 ??

In the previous page someone said, it was working fine in 2.9.0 with some changes....how abt in ver2.3.0 ??

Thanks much

Alien

05-20-2003 03:32 AM

Anyone know the status of the "0 queries version" mentioned by Teck in this thread? :) Where is everyone lately lol...

007	05-20-2003 04:26 AM

I got it that way (I think) with no problems. Although I only use it in the getinfo template due to some errors earlier on and me being too lazy to go back now and update my files.

I think it is all working by now though. Just read the post by TECK and I think it tells you what to do..

maxxxxxx

05-22-2003 01:21 PM

Maybe i am a little bit stupid, but i dont know how i do not div with zero.
I mean this row:

PHP Code:


		
			
$daysreg = iif($daysreg == 0,'1','$daysreg'); // checking to see if not registered for more then a day to prevent division by zero

in the timeonline.php.

It comes the warnig if i use the http://www.phonecity.de/forum/timeonline.php where you can see it.

Can somebody tell me how i can fix this

cu
Thomas

maxxxxxx

05-23-2003 06:33 AM

I have a zero file in my zip file but the code in this file is:

ÐÏà¡±á

cu
Thomas

maxxxxxx

05-23-2003 10:04 AM

Ok gefunden... sorry :(

gruss
Thomas

maxxxxxx

05-24-2003 11:58 AM

But i have still a problem with the by day table

look

http://www.phonecity.de/forum/timeonline.php

Best regards
Thomas

Alien

05-25-2003 09:06 PM

This really needs updating. :) TECK's only includes hours, not minutes and seconds, and his is only within the postbit and also has no leaderboard. I would like to see this updated completely to use 0 queries but maintain all the functionality of the original hack.

I am not sure how to merge both these things into one hack, and I've tried myself without success. :(

mlevenson

05-25-2003 10:39 PM

Maybe some will step up to the plate and revive this hack. I think it's a good one and I want to install it badly

All times are GMT. The time now is 06:28 PM.

Page 7 of 8

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01771 seconds Memory Usage 1,841KB 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 (5)bbcode_php_printable (6)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: