vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Users Browsing this Thread problem (https://vborg.vbsupport.ru/showthread.php?t=36835)

TECK 04-01-2002 12:36 PM
Users Browsing this Thread problem
 
this is the code i made in showthread.php, right before the [high]dooutput()[/high]:
PHP Code:
// Get users browsing this thread
if ($showforumusers) {
  $threaddatecut = $ourtimenow - $cookietimeout;
  $threadbrowsers = '';
  $threadcoma = '';
  $threadusers = $DB_site->query("SELECT username, invisible, userid
                                  FROM user
                                  WHERE inforum = $thread[threadid]
                                  AND lastactivity > $threaddatecut
                                  AND lastvisit <> lastactivity");
  while ($threaduser = $DB_site->fetch_array($threadusers)) {
    if ((!$threaduser['invisible'] or $bbuserinfo['usergroupid'] == 6) and $bbuserinfo['userid'] != $threaduser['userid']) {
      $loggeduserid = $threaduser['userid'];
      $loggedusername = $threaduser['username'];
      if ($threaduser['invisible'] == 1) {
        $invisibleuser = '*';
      } else {
        $invisibleuser = '';
      }
      eval("\$threadbrowsers .= \"".$threadcoma.gettemplate('showthread_loggedinuser')."\";");
      $threadcoma = ', ';
    }
  }

  if ((!$bbuserinfo['invisible'] or $bbuserinfo['usergroupid'] == 6) and $bbuserinfo['userid'] <> 0) {
    $loggeduserid = $bbuserinfo['userid'];
    $loggedusername = $bbuserinfo['username'];
    if ($bbuserinfo['invisible'] == 1) {
      $invisibleuser = '*';
    } else {
      $invisibleuser = '';
    }
    eval("\$threadbrowsers .= \"".$threadcoma.gettemplate('showthread_loggedinuser')."\";");
  }
  if ($threadbrowsers) {
    eval("\$loggedusers .= \"".gettemplate('showthread_loggedinusers')."\";");
  }
} 
for some reason, it will grab only one user at the time. is all in the query my bug. can you help me to understand where resides the problem?

TECK 04-01-2002 12:39 PM
i also tried this:
i replaced:
PHP Code:
WHERE inforum = $thread[threadid] 
with
PHP Code:
WHERE inforum = $thread[forumid] 
but now it shows all the users frowsing the forum, not the thread. any help will be apreciated.

UPDATE: Unfortunatelly, i dont have a live website to test my hacks. i only have a localhost setup where i run all my tests, with no users but me that can connect and browse. that's why i always had problems releasing proper hacks.
i will signup with a host in about one month or two and go live with a website. in this way there should be no more problems. for now, i would like to solve this issue mentioned above. thank you

UPDATE 2: ather looking at firefly's code, i realised how close i was to make it work this hack. :(
as you say firefly, life aint fair. ;) my failure to make this hack made me learn one new thing. thanks alot. :D


All times are GMT. The time now is 06:19 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01024 seconds
  • Memory Usage 1,731KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete