The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 05-23-2000

Hi!

I don't know how to do this with vb - i just want to pull data from the vb-database into other html-pages (SSI?):

First i want to show the newest membername
Additionally I want to show the stats like x threads, x posts and x members

Could anyone post this here?

Thanks for help!

#2 05-23-2000, 04:29 AM

you could do that with PERL is you're wanting to pull it in as an SSI call.

You have to set some base information as variables up in the SSI call, like your DB info (host, dbname, username, pass) and set your connection query and then write a little script to tell it what you want to pull and how you want it to display.

Not tough stuff

#3 05-23-2000, 04:31 AM

Hmm ... could you post an example?

#4 05-23-2000, 04:49 AM

Realize that all of these won't apply here?

These are excerpts I wrote for an SSI call pulling featured and hot items from a mySQL Auction Site I'm about to finish:

The DB stuff:
_____________________________________

#!/usr/bin/perl

use CGI qw(:standard);
use Mysql;

#------------------[ Program Configuration
$deger = new CGI;
$currency = "\$"; # Currency Symbol (If you use USD, then include \ char.
$delimeter = "?"; # Don't change this value
$mysql_host = "your host";
$mysql_dbname = "your db name";
$mysql_username = "your username";
$mysql_password = "your password";
$dbh = Mysql->connect("$mysql_host","$mysql_dbname","$mysql_use rname","$mysql_password") || error('connect');

______________________________________________

Note that the DB Call uses mySQl. DBI is not set up on this particular server. It's also set as a variable to save a lot of typing later in the script

______________________________________________

This is the sub used to call hot items. It will show you how to set up the database calls:
______________________________________________

sub hotitem
{
my ($sdh);
if ($cat ne "all")
{
$sdh = $dbh->query("SELECT * FROM tblItems WHERE itCategory LIKE '%$cat%'");
}
elsif ($cat eq "all")
{
$sdh = $dbh->query("SELECT * FROM tblItems");
}
(my $total_found) = $sdh->numrows;

if ($total_found ne "0")
{
my $sayac2 = 1;
for my $sayac(1..$total_found)
{
(my @content) = $sdh->fetchrow();
my $sdh2 = $dbh->query("SELECT * FROM tblBids WHERE biItem='@content[0]'");
(my $bid_total) = $sdh2->numrows;
if ($bid_total >= $bid)
{
@keeper[$sayac2-1] = join("$delimeter",@content);
$sayac2++;
}
}
}

$total_found = @keeper;
if ($total_found < $num)
{
$num = $total_found;
}

for my $sayac(1..$num)
{
my $flag = 0;
my $random = int(rand($total_found));
foreach my $keeper2(@keeper2)
{
if ($keeper2 eq $random)
{
$flag = 1;
last;
}
}
if ($flag eq "0") { push (@keeper2,$random); }
}

open (HTML,"$template_file");
my @html = <HTML>;
close(HTML);
my $global_line = join('',@html);
$global_line =~ s/_list_type_/Hot Items/g;
$global_line =~ s/<list>([\w\W]*)<\/list>/&list_html($1)/ie;
&header;
print $global_line;
exit;
}
__________________________________________________ _

see how the $dbh variable is used to set up the query?

Granted, this is for a specialized proggie, but the basics are all in there

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03533 seconds Memory Usage 2,218KB Queries Executed 17 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (3)postbit (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!