phpbb2 - phpbb3 help [0/2 SOLVED]

gaogier · January 9, 2008

Hello.

Im new hear.

I have a 2 problems with some php code, and im wodering if anyone can help. Please help as much as you can.

Forum Stats [unsolved]

One of the Problems im having is, stats for the forums is not showing the stats of the forums it give the following error.

Fatal error: Call to undefined function get_db_stat() in /home/gaogier/public_html/fstats.php on line 20

Here is the code...

<head> 
<link rel="shortcut icon" href="images/icon/favicon.ico" type="image/x-icon" />
<!--<link rel="stylesheet" type="text/css" href="darkblue.css">-->
<link rel="stylesheet" type="text/css" media="screen" title="User Defined Style" href="<?php echo (!$sitestyle)?'darkblue':$sitestyle ?>.css" />
<?php
if (!$sitestyle){
$sitestyle = "darkblue";
}
?>
</head>
<body >
<?php
require_once ('../mysql_connect1.php');//connect to db
define('IN_PHPBB', true);
define('PHPBB_INSTALLED', true);
$phpbb_root_path = 'phpBB3/';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include('phpBB3/common.php');

$total_posts = get_db_stat('postcount');
$total_users = get_db_stat('usercount');
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];

$sql = "SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, u.user_whosonline_color, s.session_logged_in, s.session_time, s.session_page, s.session_ip
FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
WHERE u.user_id = s.session_user_id
	AND s.session_time >= ".( time() - 300 ) . "
ORDER BY u.username ASC, s.session_ip ASC";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);
}

$guest_users = 0;
$registered_users = 0;
$hidden_users = 0;

$reg_counter = 0;
$guest_counter = 0;
$prev_user = 0;
$prev_ip = '';

while ( $row = $db->sql_fetchrow($result) )
{
$view_online = false;

if ( $row['session_logged_in'] ) 
{
	$user_id = $row['user_id'];

	if ( $user_id != $prev_user )
	{
		$username = $row['username'];

		$style_color = '';
		if ( $row['user_whosonline_color'] )
		{
			$username = '<b style="color:' . $id_color[$row[user_whosonline_color]] . '">' . $username . '</b>';
		}
		else if ( $row['user_level'] == ADMIN )
		{
			$username = '<b style="color:#' . $theme['fontcolor3'] . '">' . $username . '</b>';
		}
		else if ( $row['user_level'] == MOD )
		{
			$username = '<b style="color:#' . $theme['fontcolor2'] . '">' . $username . '</b>';
		}
					else if ( $user_group_color[$row['user_id']])
		{
			$username = '<b style="color:' . $user_group_color[ $row['user_id'] ] . '">' . $username . '</b>';
		}

		if ( !$row['user_allow_viewonline'] )
		{
			$view_online = ( $userdata['user_level'] == ADMIN ) ? true : false;
			$hidden_users++;

			$username = '<i>' . $username . '</i>';
		}
		else
		{
			$view_online = true;
			$registered_users++;
		}

		$which_counter = 'reg_counter';
		$which_row = 'reg_user_row';
		$prev_user = $user_id;
	}
}
else
{
	if ( $row['session_ip'] != $prev_ip )
	{
		$username = $lang['Guest'];
		$view_online = true;
		$guest_users++;

		$which_counter = 'guest_counter';
		$which_row = 'guest_user_row';
	}
}

$prev_ip = $row['session_ip'];
}

echo '<font class="small">';
echo 'Registered Users:</font> <font class="small2">'.$total_users;
echo '</font><font class="small">';
echo '<br />Newest User:</font> <a href="phpBB3/profile.php?mode=viewprofile&u='.$newest_uid.'">'.$newest_user.'</a>';
echo '<font class="small">';
echo '<br />Total Posts:</font> <font class="small2">'.$total_posts.'</font>';
echo '<font class="small">';
echo '<br />Users online:</font> <font class="small2">'.$registered_users.'</font>';
echo '<font class="small">';
echo '<br />Guests online:</font> <font class="small2">'.$guest_users.'</font>';

			?>

News [unsolved]

The other problem, is, the website dose not show data from the forums, it is ment to act like the news for the main site. There is no data there what so ever.

<?php
# News Db script - index.php
# Created on 21 January 2005
# Created by Joseph Jeffery

include('header.inc');




//function displayNews($all = 0) {
//global $sitestyle;
require_once ('../mysql_connect1.php');//connect to db
    if ($all == 0) {   
    		$topic_query = "SELECT * FROM `phpbb3_topics` WHERE `forum_id`= '63' ORDER BY `topic_time` DESC LIMIT 7"; // do topic query
    }else{
		$topic_query = "SELECT * FROM `phpbb3_topics` WHERE `forum_id`= '63' ORDER BY `topic_time` DESC"; // do topic query
}
	$topic_result = mysql_query ($topic_query);
		while ($topic_row = mysql_fetch_assoc($topic_result)) {
			$tt = $topic_row['topic_time'];
			$topic = $topic_row['topic_id'];
	  		$poster = $topic_row['topic_poster'];
			$first = $topic_row['topic_first_post_id'];
			$title = $topic_row['topic_title'];
			$topic_replies = $topic_row['topic_replies'];
			$topic_runescape = $topic_row['topic_runescape'];
			$post_query = "SELECT * FROM `phpbb3_posts` WHERE  `topic_id` = '$topic' AND `poster_id` = '$poster' AND `post_id` = '$first'"; // do post subject query
			$post_result = mysql_query($post_query);
			while ($post_row = mysql_fetch_assoc($post_result)){
				$post_id = $post_row['post_id'];
			}
			$use_query = "SELECT `username`, `user_avatar`, `user_email`, `user_rank` FROM `phpbb3_users` WHERE `user_id` = '$poster'"; // do user query
			$use_result = mysql_query($use_query);
			while ($use_row = mysql_fetch_assoc($use_result)){
				 $user = $use_row['username'];
				 $user_avatar = $use_row['user_avatar'];
				 $user_email = $use_row['user_email'];
				 $rank = $use_row['user_rank'];					
			}
			$news_query = "SELECT `post_text` FROM `phpbb3_posts_text` WHERE `post_id`='$post_id'";
			$news_result = mysql_query($news_query);
			while ($news_row = mysql_fetch_assoc($news_result)){
				$news = $news_row['post_text'];
			}
			$rank_result = mysql_query("SELECT `rank_title` FROM `phpbb3_ranks` WHERE `rank_id`='$rank'");
			while($rank_row = mysql_fetch_assoc($rank_result)){
				$ranks = $rank_row['rank_title'];
			}
			$date = date("D M jS, Y g:i a", $tt);
			if ($topic_replies == 0){
			$reply = '<a href="http://www.runehints.com/phpBB3/posting.php?mode=reply&t='.$topic.'">Nobody has commented on this piece of news yet. Be the first!</a>';
			$post_new ="";
			}else{
			$reply =  'comments(<a href="http://www.runehints.com/phpBB3/viewtopic.php?t='.$topic.'">'.$topic_replies.'</a>) |';
			$post_new = '<a href="http://www.runehints.com/phpBB3/posting.php?mode=reply&t='.$topic.'">Post a comment</a>';
			}
			if ($topic_runescape == 1){
				$news1 = 'This news topic is taken straight from <a href="http://runescape.com">Runescape.com</a><br />_____________________________________________<br /><br />'.$news;
			}else{
				$news1 = $news;
			}
			// Replace newlines //
			$news2 = str_replace("\n", "\n<br />\n", $news1);
	?>

	 <table border="0" cellpadding="0" cellspacing="0" width="100%" class="news">
        <tr>
          <td background="images/<?php echo $sitestyle.'_';?>tabletopl.jpg" height="25" width="30"></td>
          <td background="images/<?php echo $sitestyle.'_';?>tabletopm.jpg" height="25"><div align="center"><p class="small2"><a href="http://www.runehints.com/phpBB3/viewtopic.php?t=<?php echo $topic; ?>" class="news"><?php echo $title; ?></a> posted by <a href="http://www.runehints.com/phpBB3/profile.php?mode=viewprofile&u=<?php echo $poster; ?>"><?php echo $user; ?></a> on <?php echo $date;?></p></font></div></td>
          <td background="images/<?php echo $sitestyle.'_';?>tabletopr.jpg" height="25" width="30"></td>
           </tr>
      </table>

             <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td background="images/<?php echo $sitestyle.'_';?>tablemidl.jpg" width="16"></td>
         <td align="center" border="0" cellpadding="0" cellspacing="0"> 
	  
   			<img src="<?php echo $user_avatar; ?>" ><br /><center><font class="small2"><?php echo $ranks; ?></font></center></td>
	    <td width="429"> <p><font class="small2">
      <p><?php echo $news2; ?></p><br>
  <br /><font class="small2"><?php echo $reply. ' '. $post_new;?>
<td background="images/<?php echo $sitestyle.'_';?>tablemidr.jpg" width="16"></td>
          </tr>
          </table>
      
      <table border="0" cellpadding="0" cellspacing="0" width="100%">

       <tr>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_';?>tablebottoml.jpg" height="13" width="16"></td>
                          <td background="images/<?php echo $sitestyle.'_';?>tablebottomm.jpg" height="13"><img src="images/<?php echo $sitestyle.'_';?>tablebottomm.jpg" height="13" width="1"></td>
                          <td width="16"><img src="images/<?php echo $sitestyle.'_';?>tablebottomr.jpg" height="13" width="16"></td>
        </tr>
      </table></div><br />
<?php
    }
    
    /* if we aren't displaying all news, 
     * then give a link to do so */
    if ($all == 0) {
        echo "<center><a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=all\">View all news</a></center>\n";
    }
//mysql_close();
//}

include('footer.inc');
?>

revraz · January 9, 2008

Probably should try the phpbb support forums for help on this.

gaogier · January 9, 2008

The thing is its not their code thats the problem, so they dont want to help, they want to help with their code problems.

Which is why i have come here, as its my code thats the problem.

Sign In

phpbb2 - phpbb3 help [0/2 SOLVED]

Recommended Posts

gaogier

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

gaogier

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information