vBExternal v1.6

Well, this doesn't modify any php, nor use a plugin, so i wasn't sure exactly where to stick it

Anyhow, this is a port of the vBExternal for vb 3.0.7, so look at this thread for more information: https://vborg.vbsupport.ru/showthrea...threadid=81943

Enjoy

- Zero Tolerance

[nokturno]

cool!!

[subnet_rx]

I would still like to see a calendar function added to this

[Daniel]

Warning: main(./includes/db_mysql.php): failed to open stream: No such file or directory in /home/nikzad0/public_html/forum/vBExternal.php on line 67

Fatal error: main(): Failed opening required './includes/db_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nikzad0/public_html/forum/vBExternal.php on line 67

Any idea what I did wrong?

[Simms]

Originally Posted by jugo

Change this line (towards the end of the file):

	$Data = str_replace('images/',"{$vbulletin->options[bburl]}/images/",$Data);

to

// 	$Data = str_replace('images/',"{$vbulletin->options[bburl]}/images/",$Data);

Delayed response, but wanted to let you know this worked perfectly. Thanks!

[Xtrm2Matt]

Originally Posted by jugo

@Xtrm2matt does it still give you an error if so, please post your vBExternal here so I can hae a look.

People...if you want to pull threads from another site's vBulletin install use EXTERNAL.PHP

I seem to have gotten it fixed now

Thanks for all the help,

Matt

[apdcanari]

Hello,

How to post the total number members and posts on a page of its site?

For example : The forum had 55.000 posts and 2.000 members

My code with Vbulletin 3.0.7

Count member

PHP Code:

<?php
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM vb3_post');
$totalposts=number_format($countposts['posts']);
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM vb3_user');
$numbermembers=number_format($numbersmembers['users']);
echo "$numbermembers";
?>

Count Posts

PHP Code:

<?php
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM vb3_post');
$totalposts=number_format($countposts['posts']);
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM vb3_user');
$numbermembers=number_format($numbersmembers['users']);
echo "$totalposts";
?>

Thank you very much,

Good evening

C?dric

PS : I'm french and i don't speak English very well... :ermm:

[Xtrm2Matt]

Originally Posted by apdcanari

Hello,

How to post the total number members and posts on a page of its site?

For example : The forum had 55.000 posts and 2.000 members

My code with Vbulletin 3.0.7

Count member

PHP Code:

.. 


Count Posts

PHP Code:

.. 


Thank you very much,

Good evening

C?dric

PS : I'm french and i don't speak English very well... :ermm:

I fixed your script for you -> http://www.opticalgaming.com/forums/test2.php

Code changes:

PHP Code:

<?php 
$countposts=$vbulletin->db->query_first('SELECT COUNT(*) AS posts FROM prefix_post'); 
$totalposts=number_format($countposts['posts']); 
$numbersmembers=$vbulletin->db->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM prefix_user'); 
$numbermembers=number_format($numbersmembers['users']); 
echo "Total Posts: $totalposts";
echo "<br>";
echo "Total Members: $numbermembers";
?>

I made a small change - didn't see the need for 2 scripts where 1 could be used.

Hope this helps

Matt

[apdcanari]

Thanks a lot !!!

It's ok

Cédric :nervous:

[gopherhockey]

Nice!

[Xtrm2Matt]

Lovely edit there, gopher!! :P Was about to reply!!

Back on topic..

Will there be any further extensions to this? I love it and would like to see a bit more Possible following on from the news.. how about a Poll-pulling function?

Hard to explain, but: I have a "dedicated poll forum" on my forum where polls are (and can only be) created. Would it be possible to pull the latest poll made by -->AN ADMIN<-- (would work by specifying the Admin usergroup or a group that could display polls on the front page?) and have it put it on the front page?

Hope it's clear

Matt