vb.org Archive - Members who have visited today (with last 24 hours option).

Page 2 of 61

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)

- - Members who have visited today (with last 24 hours option). (https://vborg.vbsupport.ru/showthread.php?t=71533)

Paul M

11-10-2004 02:23 PM

Quote:

Originally Posted by RaZor Edge

But on my forum home... it show that all my members have come online today (1898 on 1898)

What's wrong???

I have no idea, what times does it show for each member when you hover over them ?

RaZor Edge

11-10-2004 02:25 PM

Quote:

Originally Posted by Paul M

I have no idea, what times does it show for each member when you hover over them ?

It show only the time

Ex: 11h31 (a different time for everyone)

Paul M

11-10-2004 02:26 PM

Quote:

Originally Posted by sabret00the

is this available for the WOL instead of the forumhome?

Not from me. You could do it, but it would mean moving the code to a different place, and then copying the relevant part of the template change - virtually a whole new version really.

Paul M

11-10-2004 02:29 PM

Quote:

Originally Posted by RaZor Edge

It show only the time

Ex: 11h31 (a different time for everyone)

I take it you are sure they haven't all visited ?

If so, pick a few you are sure haven't, then look at the time when you hover over them, and then check their profiles to see what the Last Active date & time is.

I'll check back later.

RaZor Edge

11-10-2004 02:32 PM

Quote:

Originally Posted by Paul M

yes... it's impossible that all my members (100% of 1899) have come today at 11:31!! :nervous:

I will look at this.

RaZor Edge

11-10-2004 02:37 PM

Ok, the time is right... but not the date!!!

Ex:

user 1: 16:32 (Home index time)
Last activity: 11/06/2003 16h32 (in profil)

user 2: 22:00 (Home index time)
Last activity: 26/03/2003 22h00 (in profil)

I've try to re-install a clean version of functions_misc.php but the problem is still there.

I've try to change the date format to the american style, don't work neither...

(I use the latest version of vbulletin)

BarHopper

11-10-2004 04:20 PM

Isnt this, like exactly the same to Garys?

taffy056

11-10-2004 07:08 PM

Nice hack installed with no problems at all

Paul M

11-10-2004 07:34 PM

Quote:

Originally Posted by floris

Code:

Database error in vBulletin 3.0.3:

 

Invalid SQL: SELECT userid, lastactivity, options, username,opentag,closetag

FROM vb3_user

LEFT JOIN vb3_usergroup ON(user.usergroupid = usergroup.usergroupid)

WHERE lastactivity > 1100037600 

mysql error: Unknown table 'user' in on clause

 

mysql error number: 1109

Oopsy?

Floris,

I believe that replacing the four lines of the SQL query with this should work.

PHP Code:


		
			
$todaysusers = $DB_site->query("SELECT userid, lastactivity, options, username,opentag,closetag

FROM " . TABLE_PREFIX . "user as user

LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)

WHERE lastactivity > " .$cutoff. " ");

Please let me know and I will update the instructions.

Paul M

11-10-2004 07:58 PM

Quote:

Originally Posted by RaZor Edge

Ok, the time is right... but not the date!!!

Can you try replacing the day/month/year lines of the code with these;

PHP Code:


		
			
$nowday = vbdate('d', $now. false, false);  

$nowmonth = vbdate('m', $now. false, false);  

$nowyear = vbdate('Y', $now. false, false);

If that fails then temporarily add the following line above the SQL query ;

echo "Cutoff = ".$cutoff;

this will cause the forumhome to display a line at the top saying something like

Cutoff = 1100044800

post the result back here we can see what cutoff date it has calculated.

All times are GMT. The time now is 03:21 PM.

Page 2 of 61

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04068 seconds Memory Usage 1,748KB 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 (1)bbcode_code_printable (2)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: