vb.org Archive - Having problems with calling functions

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Having problems with calling functions (https://vborg.vbsupport.ru/showthread.php?t=79106)

Sean S

03-31-2005 03:37 AM

Having problems with calling functions

Hi everyone,

I was reading a few of the posts here and decided to test some of them and see if I learned anything, but I guess I didn't.

What I'm trying to do is I wanted to show the total number of threads on my homepage, which is not integrated to vbulletin, it is a seperate page.

I have this page saved as php and I have put this at the begining of the page,

<?php
chdir("./my forums directory/");
require('./global.php');
chdir("../");
?>

the problem I have though is that I don't know what to do from there, how do I write a command/script that would call the total number of threads from the vbulletin's database?

thank you for your help.

tnguy3n

03-31-2005 03:50 AM

PHP Code:


		
			
$counts = $DB_site->query("SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread");

while($count = $DB_site->fetch_array($counts))

{

$totalthread = $count['totalthread'];

}

print("Total threads: $totalthread");

Sean S

03-31-2005 04:10 AM

Quote:

Originally Posted by tnguy3n

PHP Code:


		
			
$count = $DB_site->query(SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread");

while($count = $DB_site->fetch_array($counts))

{

$totalthread = $count['totalthread'];

}

print("Total threads: $totalthread");

thank you for your help tnguy3n, really appericiate it. The only thing is that I am getting a "prase error, unexpected T-string", do you know what might cause this error by any chance? also if it helps I use vbulletin 3, thank you.

Revan

03-31-2005 06:35 AM

Quote:

Originally Posted by tnguy3n

PHP Code:


		
			
$count = $DB_site->query(SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread");

while($count = $DB_site->fetch_array($counts))

{

$totalthread = $count['totalthread'];

}

print("Total threads: $totalthread");

Syntax error. The correct code would be

PHP Code:


		
			
$count = $DB_site->query("SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread");

while ($count = $DB_site->fetch_array($counts))

{

$totalthread = $count['totalthread'];

}

print ("Total threads: $totalthread");

tnguy3n

03-31-2005 10:54 AM

lol, my bad. missing a double quote, and first $count var should have s.

Sean S

03-31-2005 02:32 PM

Quote:

Originally Posted by tnguy3n

lol, my bad. missing a double quote, and first $count var should have s.

:D Thanks again for your help Revan and tnguy3n. I now have no errors in the page, the only problem is that the total numbers are not showing up, the only thing that shows up in the page is "Total threads:" but in front of it there is no numbers.

the code that I have so far is,

Code:

<?php

chdir("/home/***/public_html/forums");

require('/home/***/public_html/forums/global.php');

chdir("../");



$count = $DB_site->query("SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread"); 

while ($count = $DB_site->fetch_array($counts)) 

{ 

$totalthread = $count['totalthread']; 

} 

print ("Total threads: $totalthread"); 

?>

tnguy3n

03-31-2005 05:48 PM

try this one. fix $count to $counts

PHP Code:


		
			
<?php

chdir("/home/***/public_html/forums");

require('/home/***/public_html/forums/global.php');

chdir("../");



$counts= $DB_site->query("SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread"); 

while ($count = $DB_site->fetch_array($counts)) 

{ 

$totalthread = $count['totalthread']; 

} 

print ("Total threads: $totalthread"); 

?>

Deaths

03-31-2005 05:55 PM

tnguy3n's query should work.

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01091 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 (5)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages: