Re: help me pls :(

null@example.com (Smartys) — Sun, 22 Apr 2007 14:22:12 +0000

No problem

Re: help me pls :(

null@example.com (FruitCake) — Sun, 22 Apr 2007 14:20:40 +0000

oh sorry

very very thank you

Re: help me pls :(

null@example.com (Smartys) — Sun, 22 Apr 2007 14:09:43 +0000

No, you made a mistake

FIND

$result = $db->query('SELECT SUM(num_topics), SUM(num_posts) FROM '.$db->prefix.'forums') or error('Unable to fetch topic/post count', __FILE__, __LINE__, $db->error());
$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'blogs') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
$stats['total_blogs'] = $db->result($result);

REPLACE WITH

$result = $db->query('SELECT SUM(num_topics), SUM(num_posts) FROM '.$db->prefix.'forums') or error('Unable to fetch topic/post count', __FILE__, __LINE__, $db->error());
list($stats['total_topics'], $stats['total_posts']) = $db->fetch_row($result);
$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'blogs') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
$stats['total_blogs'] = $db->result($result);

Re: help me pls :(

null@example.com (FruitCake) — Sun, 22 Apr 2007 14:04:31 +0000

i see readme in PBB User Blogs 1.2

readme say

#
#---------[ 4. OPEN ]-------------------------------------------------------
#

index.php

#
#---------[ 5. FIND (line: 158) ]-------------------------------------------------------
#

$result = $db->query('SELECT SUM(num_topics), SUM(num_posts) FROM '.$db->prefix.'forums') or error('Unable to fetch topic/post count', __FILE__, __LINE__, $db->error());
list($stats['total_topics'], $stats['total_posts']) = $db->fetch_row($result);

#
#---------[ 6. AFTER ADD ]-------------------------------------------------
#

$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'blogs') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
$stats['total_blogs'] = $db->result($result);


#
#---------[ 7. FIND (line: 173) ]-------------------------------------------------
#

                '.$stats['total_posts'] ?>

#
#---------[ 8. AFTER ADD ]-------------------------------------------------
#

                '.$stats['total_blogs'] ?>

my index.php

add

 PUN_MOD)
        message($lang_common['No permission']);
    
    // Is get_host an IP address or a post ID?
    if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $_GET['get_host']))
        $ip = $_GET['get_host'];
    else {
        $get_host = intval($_GET['get_host']);
        if ($get_host < 1)
            message($lang_common['Bad request']);
        
        $result = $db->query('SELECT poster_ip FROM '.$db->prefix.'chatbox_msg WHERE id='.$get_host) or error('Unable to fetch post IP address', __FILE__, __LINE__, $db->error());
        if (!$db->num_rows($result))
            message($lang_common['Bad request']);
    
        $ip = $db->result($result);
    }
    
    message('The IP address is: '.$ip.'
The host name is: '.@gethostbyaddr($ip).'

Show more users for this IP');
}

if ($pun_user['g_read_chatbox'] != '1')
    message($lang_chatbox['No Read Permission']);

?>



   
    
        
     © PBB ChatBox 
    
  
    
        
query('SELECT u.id, u.group_id, u.num_posts_chatbox, m.id AS m_id, m.poster_id, m.poster, m.poster_ip, m.poster_email, m.message, m.posted, g.g_id, g.g_title_chatbox FROM '.$db->prefix.'chatbox_msg AS m INNER JOIN '.$db->prefix.'users AS u ON u.id=m.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id ORDER BY m.posted DESC LIMIT '.$pun_config['cb_max_msg']) or error('Unable to fetch messages', __FILE__, __LINE__, $db->error());

$new_msg_time = false;
while ($cur_msg = $db->fetch_assoc($result)) {
    
    // Get newest timestamp
    if ($new_msg_time == false) {
        $last_msg_time = $cur_msg['posted'];
        $new_msg_time = true;
    }
    $cur_msg_txt = $pun_config['cb_space'].$cur_msg['g_title_chatbox'].$pun_config['cb_disposition'].$cur_msg_txt;
    
    if ($cur_msg['g_id'] != PUN_GUEST)
        $cur_msg_txt = str_replace('', ''.pun_htmlspecialchars($cur_msg['poster']).'', $cur_msg_txt);
    else
        $cur_msg_txt = str_replace('', pun_htmlspecialchars($cur_msg['poster']), $cur_msg_txt);
    
    $cur_msg_txt = str_replace('', format_time($cur_msg['posted']), $cur_msg_txt);
    
    if ($cur_msg['g_id'] != PUN_GUEST)
        $cur_msg_txt = str_replace('', $cur_msg['num_posts_chatbox'], $cur_msg_txt);
    else {
        if (!isset($count_id[$cur_msg['poster']])) {
            $like_command = ($db_type == 'pgsql') ? 'ILIKE' : 'LIKE';
        
            $count = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'chatbox_msg WHERE poster '.$like_command.' \''.$db->escape(str_replace('*', '%', $cur_msg['poster'])).'\'') or error('Unable to fetch user chatbox post count', __FILE__, __LINE__, $db->error());
            $num_post = $db->result($count);
            $count_id[$cur_msg['poster']] = $num_post;
        }
        else
            $num_post = $count_id[$cur_msg['poster']];
        
        $cur_msg_txt = str_replace('', $num_post, $cur_msg_txt);
    }
    
    $cur_msg_txt = str_replace('', $lang_chatbox['Posts'], $cur_msg_txt);
    
    if ($pun_user['g_id'] < PUN_GUEST) {
        $cur_msg_admin = ' [ '.$cur_msg['poster_ip'].'';
        if ($cur_msg['poster_email'])
            $cur_msg_admin .= ' | '.$lang_common['E-mail'].' ]';
        else
            $cur_msg_admin .= ' ] ';
    }
    else
        $cur_msg_admin = '';
    
    $cur_msg_txt = str_replace('', $cur_msg_admin, $cur_msg_txt);
    $cur_msg_txt = str_replace('', parse_message($cur_msg['message'], 0), $cur_msg_txt);
}

if (!$cur_msg_txt)
    echo $lang_chatbox['No Message'];
else
    echo "\t\t\t".$cur_msg_txt."\n";
?>
        
    
  
    
    

      
         
         
'.$lang_common['E-mail'].':' : $lang_common['E-mail'];
        $email_form_name = ($pun_config['p_force_guest_email'] == '1') ? 'req_email' : 'email';
        
        if($email_form_name = 'req_email')
            echo "\t".''."\n";
        else
            echo "\t".''."\n";
?>
          :  
            

           
           
           

         :  
         
    
    

    
  



query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE fp.read_forum IS NULL OR fp.read_forum=1 ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

$cur_category = 0;
$cat_count = 0;
while ($cur_forum = $db->fetch_assoc($result))
{
    $moderators = '';

    if ($cur_forum['cid'] != $cur_category)    // A new category since last iteration?
    {
        if ($cur_category != 0)
            echo "\t\t\t".''."\n\t\t\t".''."\n\t\t".'

'."\n\t".''."\n".''."\n\n";

        ++$cat_count;

?>

    
    
        
             $pun_user['last_visit'])
    {
        $item_status = 'inew';
        $icon_text = $lang_common['New icon'];
        $icon_type = 'icon inew';
    }

    // Is this a redirect forum?
    if ($cur_forum['redirect_url'] != '')
    {
        $forum_field = ''.pun_htmlspecialchars($cur_forum['forum_name']).'';
        $num_topics = $num_posts = ' ';
        $item_status = 'iredirect';
        $icon_text = $lang_common['Redirect icon'];
        $icon_type = 'icon';
    }
    else
    {
        $forum_field = ''.pun_htmlspecialchars($cur_forum['forum_name']).'';

        $num_topics = $cur_forum['num_topics'];
        $num_posts = $cur_forum['num_posts'];
    }

    if ($cur_forum['forum_desc'] != '')
        $forum_field .= "\n\t\t\t\t\t\t\t\t".$cur_forum['forum_desc'];


    // If there is a last_post/last_poster.
    if ($cur_forum['last_post'] != '')
        $last_post = ''.format_time($cur_forum['last_post']).''.$lang_common['by'].' '.pun_htmlspecialchars($cur_forum['last_poster']).'';

    else
        $last_post = ' ';

    if ($cur_forum['moderators'] != '')
    {
        $mods_array = unserialize($cur_forum['moderators']);
        $moderators = array();

        while (list($mod_username, $mod_id) = @each($mods_array))
            $moderators[] = ''.pun_htmlspecialchars($mod_username).'';

        $moderators = "\t\t\t\t\t\t\t\t".'('.$lang_common['Moderated by'].' '.implode(', ', $moderators).')'."\n";
    }

?>
                 >
                     0)
    echo "\t\t\t".''."\n\t\t\t".'
            
                
                    
                    
                    
                    
                
            
            
 
                        
                            
                            
                                
                            
                        
                    
                    
                    
                    
                
'."\n\t\t".'
'."\n\t".'
'."\n".''."\n\n";
else
    echo ''.$lang_index['Empty board'].'';


// Collect some statistics from the database
$result = $db->query('SELECT COUNT(id)-1 FROM '.$db->prefix.'users') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
$stats['total_users'] = $db->result($result);

$result = $db->query('SELECT id, username FROM '.$db->prefix.'users ORDER BY registered DESC LIMIT 1') or error('Unable to fetch newest registered user', __FILE__, __LINE__, $db->error());
$stats['last_user'] = $db->fetch_assoc($result);

$result = $db->query('SELECT SUM(num_topics), SUM(num_posts) FROM '.$db->prefix.'forums') or error('Unable to fetch topic/post count', __FILE__, __LINE__, $db->error());
$result = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'blogs') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
$stats['total_blogs'] = $db->result($result);
list($stats['total_topics'], $stats['total_posts']) = $db->fetch_row($result);

?>




    Top 20 most active users
    
        
            
query('SELECT id, username, num_posts FROM '.$db->prefix.'users ORDER BY num_posts DESC LIMIT 20') or error('Unable to fetch user data', __FILE__, __LINE__, $db->error());
while ($data = $db->fetch_assoc($result))
{
echo "\t\t\t\t\t\t".''.pun_htmlspecialchars($data['username']).'('.$data['num_posts'].') '."\n";
}
 
?>
        
    


    
    
        
            
                
                '. $stats['total_users'] ?>
                '.$stats['total_topics'] ?>
                '.$stats['total_posts'] ?>
                '.$stats['total_blogs'] ?>
                query("SELECT COUNT(*) FROM ".$db->prefix."posts WHERE posted > ".(time()-7*24*3600)) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error());
                $posts_week = $db->result($result);
                $result = $db->query("SELECT COUNT(*) FROM ".$db->prefix."posts WHERE posted > ".(time()-24*3600)) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error());
                $posts_day = $db->result($result);
                $posts_h = $posts_day/24;
                ?>
                
                '.$posts_week;
                       else
                              echo  $lang_index['number day'].': '.$posts_day;
                else
                       echo $lang_index['average h'].': '.number_format($posts_h,1);
                ?>
                

                 
            

            
                
                : 
query('SELECT user_id, ident, color FROM '.$db->prefix.'online WHERE idle=0 ORDER BY ident', true) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error());

    while ($pun_user_online = $db->fetch_assoc($result))
    {
        if ($pun_user_online['user_id'] > 1)
            $users[] = "\n\t\t\t\t".''.pun_htmlspecialchars($pun_user_online['ident']).'';
        else
            ++$num_guests;
    }

    $num_users = count($users);
    // users on line today 
    $date = getdate(time());
    $todaystamp = mktime(0,0,0, $date['mon'], $date['mday'], $date['year']);

$result = $db->query("SELECT username, id, last_visit from ".$db->prefix."users WHERE last_visit >= '".$todaystamp."' ORDER by last_visit DESC") or error("Unable to find the list of the users online today", __FILE__, __LINE__, $db->error());

    $users_today = array();
    while ($pun_user_online_today = $db->fetch_assoc($result))
        $users_today[] .=  "\n\t\t\t\t".'
'.$pun_user_online_today['username'].'';
        
    $num_users_today = count($users_today);
    echo "\t\t\t\t".'
'. $lang_index['Users online'].': '.$num_users.'
'."\n\t\t\t\t".''.$lang_index['Users today'].': '.$num_users_today.'
'."\n\t\t\t\t".''.$lang_index['Guests online'].': '.$num_guests.'
'."\n\t\t\t".''."\n";


include('botdetect.php');
    $botStatus = isBotOnline();

    if ($num_users > 0 || $botStatus != '') {
       echo "\t\t\t".''."\n\t\t\t\t".''.$lang_index['Online'].': '."\t\t\t\t".implode(', ', $users);
    if($botStatus != '' & $num_users == 0)
        echo substr($botStatus, 1);
    else
        echo $botStatus;    

    echo ''."\n\t\t\t".''."\n";
    }
        echo "\t\t\t".''."\n";

            //--- birthday begin ---/
    $today = getdate();
    $result = $db->query('SELECT username, id, YEAR(FROM_UNIXTIME(birthday)) AS year, hide_age from '.$db->prefix.'users WHERE DAYOFMONTH(FROM_UNIXTIME(birthday))=\''.$today['mday'].'\' AND MONTH(FROM_UNIXTIME(birthday))=\''.$today['mon'].'\' ORDER by username ASC') or error('Cannot retreive birthdays', __FILE__, __LINE__, $db->error());

    $birthdays_today = array();
    while ($row = $db->fetch_assoc($result))
        $birthdays_today[] .=  "\n\t\t\t\t".''.$row['username'].''.
        ((!$row['hide_age'])?'('.($today['year']-$row['year']).')':'');

    if (count($birthdays_today) > 0) {
        echo "\t\t\t".''."\n\t\t\t\t".'' . $lang_index['Birthday Today'] . ': ';
        echo implode(', ', $birthdays_today) . '' . "\n\t\t\t" . '' . "\n";
    }
    //--- birthday end ---/

    // list users on line today
    echo "\t\t\t".''."\n\t\t\t\t".''.$lang_index['Online today'].': ';
                
    if ($num_users_today > 0) 
        echo implode(', ', $users_today).''."\n\t\t\t".''."\n";
    else
        echo ''."\n\t\t\t".''."\n";

}
else
    echo "\t\t".''."\n\t\t\t".''."\n";


?>
        

    



I see it correctly
pls help me

PunBB Forums — help me pls :(

Re: help me pls :(

Re: help me pls :(

Re: help me pls :(

Re: help me pls :(

© PBB ChatBox

'.pun_htmlspecialchars($cur_forum['forum_name']).'

'.pun_htmlspecialchars($cur_forum['forum_name']).'

Top 20 most active users

Re: help me pls :(

Re: help me pls :(

Re: help me pls :(

help me pls :(