Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 02-16-2005, 12:44 AM
webrats webrats is offline
 
Join Date: May 2002
Posts: 102
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default convert this vb2 mysql code to work in vb3

#!/usr/bin/perl -w
#
# vBulletin MRTG grapher by discore (tyler@xmission.com)
#

use strict;
use DBI;

################################################## ##############################
## CHANGE this stuff ##
################################################## ##############################

# MySQL info
my $sqluser = "USERNAME";
my $sqlpass = "PASSWORD";
my $sqlhost = "localhost"; # host of your database
my $database = "DATABASE";

# Your board's name
my $name = "Your Board Name";

# Your 'Timeout for Cookie'
#
# Set this to 300 if you want truely accurate graphs. This will report
# considerably less users online than vB does.
# Or, set this to whatever you "Timeout for Cookie" setting from your vB
# Options is to report online users the same way "Who's Online" does.
my $cookie_expire = "300";

# Location of 'uptime' program
my $uptime_bin = "/usr/bin/uptime";

################################################## ##############################
## Logically won't need to touch anything after here ##
################################################## ##############################

# connect to the database
my $dba = "DBI:mysql:database=$database;host=$sqlhost";
my $dbh = DBI->connect("$dba","$sqluser", "$sqlpass",{'RaiseError' => 1})
|| die "Could not connect to database: $!\n";

my $data; # output

# get number of posts in the last 5 minutes
if($ARGV[0] eq "posts") {
my $time = time()-300;
my $query = $dbh->selectrow_hashref("SELECT COUNT(*) AS count FROM post WHERE dateline>=$time");
my $totalnewposts = $query->{'count'};

$data = $totalnewposts;
}

# get number of online users
elsif($ARGV[0] eq "users") {
my $time = time()-$cookie_expire;
my $query = $dbh->selectrow_hashref("SELECT COUNT(*) AS sessions FROM session WHERE lastactivity>$time");
my $totalonline = $query->{'sessions'};

$data = $totalonline;
}

$dbh->disconnect();

# get uptime
my $uptime = `$uptime_bin`;
$uptime =~ /up (.*?),/;
$uptime = $1;
chomp($uptime);

# print out info for MRTG
print <<EOF;
$data
$data
$uptime
$name
EOF
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:56 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03580 seconds
  • Memory Usage 2,184KB
  • Queries Executed 11 (?)
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)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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
  • postbit_imicons
  • 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