Jump to content

phpbb2 - phpbb3 help [0/2 SOLVED]

gaogier

By gaogier
in Third Party Scripts

 Share

Recommended Posts

gaogier Member

gaogier

Posted
Posted

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');
?>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.