Przyspieszanie forum phpBB

Otwórz: index.php

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; 

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

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

} 

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.