Przyspieszanie forum phpBB

Otwórz: index.php [p]znajdź i usuń:

if ( $userdata['session_logged_in'] ) 

   { 

      $sql = "SELECT t.forum_id, t.topic_id, p.post_time 
         FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p 
         WHERE p.post_id = t.topic_last_post_id 
            AND p.post_time > " . $userdata['user_lastvisit'] . " 
            AND t.topic_moved_id = 0"; 

      if ( !($result = $db->sql_query($sql)) ) 

      { 

         message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql); 

      } 


      $new_topic_data = array(); 

      while( $topic_data = $db->sql_fetchrow($result) ) 

      { 
         
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time']; 

      } 

   }

znajdź pierwsze wystąpienie :

$forum_data[] = $row;

i wklej po tym:

$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id 
        FROM (( " . FORUMS_TABLE . " f 
        LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) 
        LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id ) 
        ORDER BY f.cat_id, f.forum_order"; 






   if ( !($result = $db->sql_query($sql)) ) 

   { 

      message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql); 

   } 



   $forum_data = array(); 

   while( $row = $db->sql_fetchrow($result) ) 

   { 

      $forum_data[] = $row; 

        if ($row['post_time'] > $userdata['user_lastvisit']) 
$new_topic_data[$row['forum_id']][$row['topic_id']] = $row['post_time']; 

   }

Otwórz: page_header.php

znajdź:

//

// Get basic (usernames + totals) online

// situation

//




$logged_visible_online = 0;

$logged_hidden_online = 0;

$guests_online = 0;

$online_userlist = '';


if (defined('SHOW_ONLINE'))

{


   $user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';

i zamień na:

//

// Get basic (usernames + totals) online

// situation

//




$logged_visible_online = 0;

$logged_hidden_online = 0;

$guests_online = 0;

$online_userlist = '';



if (defined('SHOW_ONLINE') && $userdata['session_logged_in'])

{


   $user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';

Otwórz: viewtopic.php

znajdź:

$sql = "UPDATE " . TOPICS_TABLE . " SET topic_views = topic_views + 1 WHERE topic_id = $topic_id"; 

        if ( !$db->sql_query($sql) ) 

        { 

            message_die(GENERAL_ERROR, "Could not update topic views.", '', __LINE__, __FILE__, $sql); 

        }

i zamień na:

if (mt_rand(1,3) == 1) { 
        $sql = "UPDATE " . TOPICS_TABLE . " SET topic_views = topic_views + 3 WHERE topic_id = $topic_id"; 

        if ( !$db->sql_query($sql) )
 
        { 

            message_die(GENERAL_ERROR, "Could not update topic views.", '', __LINE__, __FILE__, $sql); 

        } 

    }

Zapisz wszystkie pliki i wgraj ponownie na serwer.

śro, 16 styczeń 2008

Spis wszystkich artykułów

Przyspieszanie forum phpBB

Kategorie artykułów

Nawigacja

Literatura

Ostatnie artykuły

Ostatnie recenzje

Partnerzy

Polecam