Problem with Invision Power Board Stats block (ibf-stats)

Nuke Cadet Joined: Dec 13, 2003 Posts: 3

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site22/fst/var/www/html/phpnuke/blocks/block-Ibf-Stats.php on line 22
You have an error in your SQL syntax near '-_forums.ibf_posts order by pid desc' at line 1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site22/fst/var/www/html/phpnuke/blocks/block-Ibf-Stats.php on line 30
You have an error in your SQL syntax near '-_forums.ibf_topics WHERE tid=''' at line 1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site22/fst/var/www/html/phpnuke/blocks/block-Ibf-Stats.php on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site22/fst/var/www/html/phpnuke/blocks/block-Ibf-Stats.php on line 45

Anyone? Please?

Corporal Joined: May 31, 2003 Posts: 50

The block is not connecting to your database correctly. ie, 1 or more of the following lines are not right:

Code:

$db_name = "";    // The name of the database where your forums are installed

// Variables
$ibf_stats = "ibf_stats";    // Name of the table where your stats are
$ibf_posts = "ibf_posts";    // The name of your posts table
$ibf_topics = "ibf_topics";    // The name of your topics table
$forum_id = "1";       // The forum ID of the forum you wish to export
$url = "forums/index.php";    // The full URL to your forums
$ibf_sessions = "ibf_sessions"; // Change if not correct
$ibf_groups = "ibf_groups"; // Change if not correct
$linkforums = "http://www.yoursiteurl/forums"; //Your Forum URL

Anyway, the code for this block is old and has some lines that were never used - here is a tidied up version:

Code:

<?
if (eregi("block-Ibf-Stats.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}

// Edit these variables to suit your site
$db_name = ""; // Name of your IPB database (if PHP-Nuke & IPB are sharing the same database you can leave it blank).
$ibfprefix = "ibf"; // Prefix of your IPB tables (default = ibf)
$linkforums = "http://www.yoursite/forums"; //Your Forum URL
// End

global $sitename, $db;

$dbpath = "$db_name.$ibfprefix";

$stats_sql = $db->sql_query("select * from ".$dbpath."_stats");
$stats=$db->sql_fetchrow($stats_sql);
$date = date ("jS M Y" ,$stats["MOST_DATE"]);
$posts = $stats["TOTAL_TOPICS"] + $stats["TOTAL_REPLIES"];
$threads = $stats["TOTAL_TOPICS"];

$content = "<a href=\"$linkforums\"><center>$sitename Forums</a></center> Posts: $posts Threads: $threads Members: $stats[MEM_COUNT]";

$last_member_id = $db->sql_query("SELECT * FROM ".$dbpath."_members WHERE name ='$stats[LAST_MEM_NAME]'");
$m=$db->sql_fetchrow($last_member_id);

$content .= " Welcome to our newest member, <a href=\"$linkforums/index.php?act=Profile&MID=$m[id]\">$stats[LAST_MEM_NAME]</a> Most users ever online was $stats[MOST_COUNT] on $date.";

$lastpost_sql = $db->sql_query("select * from ".$dbpath."_posts order by pid desc");
$p=$db->sql_fetchrow($lastpost_sql);
$last_topic = $db->sql_query("SELECT * FROM ".$dbpath."_topics WHERE tid='$p[topic_id]'");
$t=$db->sql_fetchrow($last_topic);

$content .= " Last Post In: <a href=\"$linkforums/index.php?act=ST&f=$p[forum_id]&t=$p[topic_id]\">$t[title]</a> By: <a href=\"$linkforums/index.php?act=Profile&MID=$p[author_id]\">$p[author_name]</a>";

$time = time() - 900;
$data = $db->sql_query("SELECT s.member_id, s.member_name, s.login_type, g.suffix, g.prefix FROM ".$dbpath."_sessions s, ".$dbpath."_groups g WHERE running_time > '$time' AND g.g_id=s.member_group ORDER BY running_time DESC");
$active['GUESTS'] = 0;
$cached = array();
while ($result = $db->sql_fetchrow($data) )
{
if ($result['member_id'] == 0)
{
$active['GUESTS']++;
}
else
{
if (empty( $cached[ $result['member_id'] ] ) )
{
$cached[ $result['member_id'] ] = 1;
if ($result['login_type'] == 1)
{
$active['ANON']++;
}
else
{
$active['MEMBERS']++;
$active['NAMES'] .= "»  <a href='$linkforums/index.php?act=Profile&MID={$result['member_id']}'>{$result['prefix']}{$result['member_name']}{$result['suffix']}</a> ";
}
}

}
}

$active['TOTAL'] = $active['MEMBERS'] + $active['GUESTS'] + $active['ANON'];

$content .= " <a href='$linkforums/index.php?act=Online&CODE=listall'>Users online</a> $active[TOTAL] Members ";
$content .= " $active[GUESTS] Guests ";
$content .= $active['NAMES'];

?>

Nuke Cadet Joined: Dec 13, 2003 Posts: 3

Hey, man, thanks for the reply. There seems to be no problem with the code now, i have no errors. But, there are no stats showing up. Might there have to be a NEW post before it starts tracking it?