VB External - Working in VB4 1.4

[wraggster]

yeah thats one of the things to fix

got the htaccess sorted, now we have content pages and news archives for example

http://wii-news.dcemu.co.uk/newsarchive/01-2011.html

http://wii-news.dcemu.co.uk/what-wil...r--350671.html

cant wait to get the rest fixed and let others use what we hacked together

also the main site is at www.dcemu.co.uk

forums are at www.dcemu.co.uk/vbulletin

We can use VB EXternal to have subdomains with news pulled from as many forums as we want


Ok Now the login script is fixed too , now to try and get those pesky stats working

--------------- Added [DATE]1307739498[/DATE] at [TIME]1307739498[/TIME] ---------------

Hmm the stats script is beyond me at the moment. i personally reckon its not calling the database correctly for VB 4

Can anyone take a look at this code and advise some things to try:

the call to the config.php works so it has to be something else, heres the code:

PHP Code:

 <?php
// Connecting to your database

require('./includes/config.php');

//connect
$connection = mysql_connect("$servername","$dbusername","$dbpassword") or die ("Cannot connect to server.");

$db = mysql_select_db("$dbname", $connection) or die ("Could not select database.");

$numbermainsites = mysql_num_rows ( mysql_query("SELECT DISTINCT ip FROM useronline"));

$datecut = time() - 3000;

$guests = mysql_query("SELECT COUNT(*) FROM session WHERE userid=0 AND session.lastactivity > $datecut");
$row = mysql_fetch_row($guests);
$numberguest=$row[0];

$users = mysql_query("SELECT COUNT( DISTINCT userid ) FROM session WHERE userid>0 AND lastactivity > $datecut");
$row = mysql_fetch_row($users);
$numberusers=$row[0];

$threads = mysql_query("SELECT COUNT(*) FROM thread");
$row = mysql_fetch_row($threads);
$totalthreads=$row[0];

$posts = mysql_query("SELECT COUNT(*) FROM post");
$row = mysql_fetch_row($posts);
$totalposts=$row[0];

$total_online = $numberguest + $numberusers + $numbermainsites;

$query = mysql_query("select * from datastore");
$data = array();
while ($row = mysql_fetch_row($query)) {
    $data[$row[0]] = $row[1];
}

$maxonline = unserialize($data['maxloggedin']);
$userstats = unserialize($data['userstats']);
$guestsandsites = $numberguest + $numbermainsites;

//disconnect
mysql_close($connection);

?> 

Visitors Online: <strong><?=$total_online;?></strong><br>
Members: <strong><?=$numberusers;?></strong> <br>
Guests: <strong><?=$guestsandsites?></strong><br>
Most users online: <b><?=$maxonline['maxonline'];?></b><br>
on <?=date("M jS, Y G:i:s", $maxonline['maxonlinedate']);?>.<br>
Newest member, <b><?=$userstats['newusername'];?></b><br><br>
Threads: <strong><?=$totalthreads;?></strong><br>
Posts: <strong><?=$totalposts;?></strong><br>
Members: <strong><?=$userstats['numbermembers'];?></strong>