vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   How to connect to a vB database & sessions (https://vborg.vbsupport.ru/showthread.php?t=57897)

NTLDR 10-16-2003 06:13 PM
All the code to get that information can be found in index.php :)

TECK 10-17-2003 12:54 AM
Assuming you are using in your 'htdocs' a /forum folder:
PHP Code:
<?php

require_once('./forum/global.php');

$memberscount = $DB_site->query_first("
    SELECT COUNT(*) AS total,MAX(userid) AS max FROM user
");
$memberstotal = number_format($memberscount['total']);
$threadscount = $DB_site->query_first("
    SELECT COUNT(*) AS total FROM thread
");
$threadstotal = number_format($threadscount['total']);
$postscount = $DB_site->query_first("
    SELECT COUNT(*) AS total FROM post
");
$poststotal = number_format($postscount['total']);
if ($displayloggedin)
{
    $datecut = $ourtimenow - $cookietimeout;
    $loggedins = $DB_site->query_first("
        SELECT COUNT(*) AS sessions
        FROM session
        WHERE userid=0
        AND lastactivity>$datecut
    ");
    $numberguest = $loggedins['sessions'];
    $numberregistered = 0;
    $loggedins = $DB_site->query("
        SELECT DISTINCT session.userid,username,invisible,usergroupid
        FROM session
        LEFT JOIN user ON (user.userid=session.userid)
        WHERE session.userid>0
        AND session.lastactivity>$datecut
        ORDER BY invisible ASC, username ASC
    ");
    if ($loggedin = $DB_site->fetch_array($loggedins))
    {
        $numberregistered++;
        while ($loggedin = $DB_site->fetch_array($loggedins))
        {
            $numberregistered++;
        }
    }
    $DB_site->free_result($loggedins);
    $onlinetotal = $numberregistered + $numberguest;
}
$totalposts = number_format($countposts['posts']);

print_r('Members: ' . $memberstotal . '<br />');
print_r('Threads: ' . $threadstotal . '<br />');
print_r('Posts: ' . $poststotal . '<br />');
print_r('Online Users: ' . $onlinetotal);

?>

kill_emma 10-17-2003 01:52 AM
Warning: main(./includes/init.php): failed to open stream: No such file or directory in C:\network\Apache2\htdocs\forum\global.php on line 18

Fatal error: main(): Failed opening required './includes/init.php' (include_path='.;c:\php4\pear') in C:\network\Apache2\htdocs\forum\global.php on line 18

btw: yes, i'm using htdocs/forum :P

EDIT:

i redid the top part to this
PHP Code:
 
chdir('c:\network\Apache2\htdocs\forum'); 
require_once('./global.php'); 
and now i'm getting:

Quote:
vBulletin Message

Unable to add cookies, header already sent.

File: C:\network\Apache2\htdocs\index.php
Line: 26
line 26 is where the table my page begins on is.

TECK 10-17-2003 05:10 PM
PHP Code:
chdir('./forum');
require_once('./global.php'); 

kill_emma 10-17-2003 06:19 PM
still getting the same message

bradsears 10-17-2003 06:28 PM
Make sure you do the includes before your actual html .... you can't have any html tags before the include.

The key for you is "header already sent".

Some things need to be done by the server before the page starts being sent. This includes redirects but it would not surprise me if cookies were included as well.

Start with an empty script and test things step by step.

kill_emma 10-17-2003 09:35 PM
w00t, now it works.

2 things then i'm done!

1: everything will work except for the users online... why?
2: how would i display a user's info from the getinfo template (ie $userinfo[avatarurl])?


All times are GMT. The time now is 03:32 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

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.01097 seconds
  • Memory Usage 1,745KB
  • 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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