Changeset 299

Timestamp:

02/16/10 15:14:19 (2 years ago)

Author:

Nafania

Message:

--

Files:

• index.php (modified) (3 diffs)
• js/signup.js (modified) (2 diffs)
• languages/lang_english/lang_forum.php (modified) (1 diff)
• languages/lang_english/lang_main.php (modified) (3 diffs)
• languages/lang_russian/lang_forum.php (modified) (1 diff)
• languages/lang_russian/lang_main.php (modified) (4 diffs)
• phpBB2/includes/functions.php (modified) (14 diffs)
• phpBB2/includes/functions_post.php (modified) (9 diffs)
• phpBB2/index.php (modified) (2 diffs)
• phpBB2/modcp.php (modified) (4 diffs)
• phpBB2/posting.php (modified) (7 diffs)
• phpBB2/search.php (modified) (4 diffs)
• phpBB2/viewforum.php (modified) (9 diffs)
• phpBB2/viewtopic.php (modified) (8 diffs)
• sql.sql (modified) (6 diffs)
• templates/bithdtv/bbcode.html (modified) (1 diff)
• templates/bithdtv/top10.html (deleted)
• templates/bithdtv/top_peers_body.html (added)
• templates/bithdtv/top_ten_body.html (added)
• templates/bithdtv/top_torrents_body.html (added)
• templates/bithdtv/top_users_body.html (added)
• templates/main/bbcode.html (modified) (2 diffs)
• templates/main/top10.html (deleted)
• templates/main/top_peers_body.html (added)
• templates/main/top_ten_body.html (added)
• templates/main/top_torrents_body.html (added)
• templates/main/top_users_body.html (added)
• templates/reflection/bbcode.html (modified) (1 diff)
• templates/reflection/top10.html (deleted)
• templates/reflection/top_peers_body.html (added)
• templates/reflection/top_ten_body.html (added)
• templates/reflection/top_torrents_body.html (added)
• templates/reflection/top_users_body.html (added)
• templates/reflection/tor_modifier.html (added)
• topten.php (modified) (2 diffs)
• updates/034.299.php (added)

index.php

@@ -11 +11 @@
-$sql = 'SELECT uid, name FROM ' . USERS_TABLE . ' WHERE status = 1 AND uid <> ' . ANONYMOUS . ' ORDER BY uid DESC';
-$result = $db->sql_query_limit($sql, 1, 0, 20 * 60);
-$row = $db->sql_fetchrow($result)
+ $row = $db->sql_fetchrow($result) 
-
-        // www.phpBB-SEO.com SEO TOOLKIT START
@@ -25 +25 @@
-        // start birthday users
-        $now = date('m-d', time() + $userdata['tzoffset']);
-
+
+
+
+
+
+
-        $result = $db->sql_query($sql, 120 * 60);
-
-        $birthday_users = '';
-
+
+
-                do {
+                        ++$i;
-                        // www.phpBB-SEO.com SEO TOOLKIT START
-birthday_arr['name'], $birthday_arr
+row['name'], $row
-                        // www.phpBB-SEO.com SEO TOOLKIT END
-
-
-
-
+
+
+
+
+
+
+
+
-
-                }
-
+
+
+
+
+
-        }
-        $db->sql_freeresult($result);
@@ -46 +62 @@
-
-        $template->assign_vars(array(
- )
-
+
+)
-
-        /* start poll */

js/signup.js

@@ -6 +6 @@
-                        passagain: {required: true,minlength: 6,maxlength: 40,equalTo: '#wantpassword'},
-                        email: {required: true,email: true,remote : S_EMAIL_CHECK},
-,digits:true
-,digits:true
-,digits:true
+
+
+
-                        country: {required: true},
-                        upload: {required: true},
@@ -19 +19 @@
-                        wantusername: {remote : L_JS_USERNAME_CHECK_INVALID},
-                        email: {remote : L_JS_EMAIL_CHECK_INVALID}
-,
+
-        });
-

languages/lang_english/lang_forum.php

@@ -260 +260 @@
-        'post_a_reply' =>  'Post a reply',
-        'post_topic_as' =>  'Post topic as',
+        'topic_first_post_sticky' =>  'First post is sticky',
-        'edit_post' =>  'Edit post',
-        'options' =>  'Options',

languages/lang_english/lang_main.php

@@ -1049 +1049 @@
-                'April' => 'April',
-                'May' => 'May',
+                'May_short' => 'May',
-                'June' => 'June',
-                'July' => 'July',
@@ -1067 +1068 @@
-                'Oct' => 'Oct',
-                'Nov' => 'Nov',
-
+
+
+
+
+
+
+
+
+
+
+
-        ),
-
@@ -1227 +1238 @@
-        'similiar_torrents' => 'Similiar torrents',
-
+        'top_ten_popular_torrents' => 'Топ популярных торрентов',
+        'top_ten_users' => 'Топ пользователей',
+        'top_ten_peers' => 'Топ пиров',
+        'top_ten_by_completed' => 'По скачиваниям',
+        'top_ten_by_peers' => 'По количеству пиров',
+        'top_ten_by_comments' => 'По комментариям',
+        'top_ten_by_uploaded' => 'По загруженной информации',
+        'top_ten_by_downloaded' => 'По скачанной информации',
+        'top_ten_by_ratio' => 'По ратио',
+        'top_ten_by_total_seed_time' => 'По времени сидирования',
+        'top_ten_by_reputation' => 'По репутации',
+        'top_ten_by_upspeed' => 'По скорости загрузки',
+        'top_ten_by_downspeed' => 'По скорости скачивания',
+        'show_by' => 'Выводить по',
+        'for' => 'за',
+        'and_sort' => 'и сортировать',
+        'sort_asc' => 'По возрастанию',
+        'sort_desc' => 'По убыванию',
+        'show' => 'Показать',
+        'all_time' => 'Все время',
+        'show_all_cats' => 'Показывать все категории',
+        'show_only_my_cats' => 'Показывать только мои категории',
+
-        'translated_by' => 'Translation to english made by %s',
-));

languages/lang_russian/lang_forum.php

@@ -265 +265 @@
-        'post_a_reply' =>  'Ответить',
-        'post_topic_as' =>  'Статус создаваемой темы',
+        'topic_first_post_sticky' =>  'Прилепить первый пост',
-        'edit_post' =>  'Редактировать сообщение',
-        'options' =>  'Настройки',

languages/lang_russian/lang_main.php

@@ -428 +428 @@
-        'required' => 'обязательно',
-        'some_other' => 'Прочее',
-Детали торрента
+Скачать торрент
-        'succefully_uploaded' => 'Успешно загружено!',
-        'succefully_uploaded_descr' => 'Теперь вы можете сидировать. <b>Внимание</b> торрента не будет видно пока вы это не сделаете!',
@@ -1056 +1056 @@
-                'April' => 'Апрель',
-                'May' => 'Май',
+                'May_short' => 'Май',
-                'June' => 'Июнь',
-                'July' => 'Июль',
@@ -1074 +1075 @@
-                'Oct' => 'Окт',
-                'Nov' => 'Ноя',
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-        ),
-
@@ -1235 +1260 @@
-        'similiar_torrents' => 'Похожие торренты',
-
+        'top_ten_popular_torrents' => 'Топ популярных торрентов',
+        'top_ten_users' => 'Топ пользователей',
+        'top_ten_peers' => 'Топ пиров',
+        'top_ten_by_completed' => 'По скачиваниям',
+        'top_ten_by_peers' => 'По количеству пиров',
+        'top_ten_by_comments' => 'По комментариям',
+        'top_ten_by_uploaded' => 'По загруженной информации',
+        'top_ten_by_downloaded' => 'По скачанной информации',
+        'top_ten_by_ratio' => 'По ратио',
+        'top_ten_by_total_seed_time' => 'По времени сидирования',
+        'top_ten_by_reputation' => 'По репутации',
+        'top_ten_by_upspeed' => 'По скорости загрузки',
+        'top_ten_by_downspeed' => 'По скорости скачивания',
+        'show_by' => 'Выводить по',
+        'for' => 'за',
+        'and_sort' => 'и сортировать',
+        'sort_asc' => 'По возрастанию',
+        'sort_desc' => 'По убыванию',
+        'show' => 'Показать',
+        'all_time' => 'Все время',
+        'show_all_cats' => 'Показывать все категории',
+        'show_only_my_cats' => 'Показывать только мои категории',
+
+        'show_profile' => 'Показать профиль',
+        'search_torrents' => 'Поиск торрентов',
+
-        'translated_by' => 'На русский язык перевел %s',
-));

phpBB2/includes/functions.php

@@ -434 +434 @@
-                                $db->sql_query('DELETE FROM ' . TOPICS_TRACK_TABLE . " WHERE user_id = {$userdata['uid']}");
-                                $db->sql_query('DELETE FROM ' . FORUMS_TRACK_TABLE . " WHERE user_id = {$userdata['uid']}");
-ser_
+
-                        }
-                        else if ($config['load_anon_lastread'] || $userdata['session_logged_in'])
@@ -451 +451 @@
-                                unset($tracking_topics);
-
-
-
-
-
-
+
+
+
+
-                        }
-                }
@@ -595 +594 @@
-                        $topic_id36 = base_convert($topic_id, 10, 36);
-
-//
-//
+
+
-                                $tracking['tf'][$forum_id][$topic_id36] = true;
-//
+
-
-                        $post_time = ($post_time) ? $post_time : time();
@@ -636 +635 @@
-                                {
-                                        $userdata['user_lastmark'] = intval(base_convert(max($time_keys) + $config['onlinesince'], 36, 10));
-//$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_lastmark = ' . $userdata['user_lastmark'] . " WHERE user_
+$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_lastmark = ' . $userdata['user_lastmark'] . " WHERE u
-                                }
-                                else
@@ -741 +740 @@
-
-                $user_lastmark = (isset($mark_time[$forum_id])) ? $mark_time[$forum_id] : $userdata['user_lastmark'];
-                //$userdata['user_lastmark'] = $user_lastmark = (isset($mark_time[$forum_id])) ? $mark_time[$forum_id] : $userdata['user_lastmark'];
-
-                foreach ($topic_ids as $topic_id)
@@ -808 +806 @@
-
-                        $user_lastmark = (isset($mark_time[$forum_id])) ? $mark_time[$forum_id] : $userdata['user_lastmark'];
-                        //$userdata['user_lastmark'] = $user_lastmark = (isset($mark_time[$forum_id])) ? $mark_time[$forum_id] : $userdata['user_lastmark'];
-
-                        foreach ($topic_ids as $topic_id)
@@ -833 +830 @@
-                }
-
-//
-//
+
+
-                        $user_lastmark = (isset($tracking_topics['l'])) ? base_convert($tracking_topics['l'], 36, 10) + $config['onlinesince'] : 0;
-//
-//
-//
-//
-//
+
+
+
+
+
-
-                foreach ($topic_ids as $topic_id)
@@ -913 +910 @@
-        }
-
-->data['is_registered
+data['session_logged_in
-        {
-                // Get list of the unread topics
-->
+
-
-                $sql_array = array(
@@ -954 +951 @@
-                $db->sql_freeresult($result);
-        }
-->data['is_registered
+data['session_logged_in
-        {
-                global $tracking_topics;
@@ -964 +961 @@
-                }
-
-->data['is_registered
-
-board_startdat
+data['session_logged_in
+
+onlinesinc
-                }
-                else
-                {
-->
+
-                }
-
@@ -988 +985 @@
-                        if (isset($tracking_topics['t'][$topic_id36]))
-                        {
-board_startdat
+onlinesinc
-
-                                if ($row['topic_last_post_time'] > $last_read)
@@ -997 +994 @@
-                        else if (isset($tracking_topics['f'][$forum_id]))
-                        {
-board_startdat
+onlinesinc
-
-                                if ($row['topic_last_post_time'] > $mark_time)
@@ -1041 +1038 @@
-                        $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();
-
-//
-//
+
+
-                                $userdata['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['onlinesince']) : 0;
-//
+
-
-                        $mark_time_forum = (isset($tracking_topics['f'][$forum_id])) ? (int) (base_convert($tracking_topics['f'][$forum_id], 36, 10) + $config['onlinesince']) : $userdata['user_lastmark'];
@@ -1085 +1082 @@
-                else
-                {
-
-
-
-
-
-
+
+
+
+
+
-                        $result = $db->sql_query($sql);
-

phpBB2/includes/functions_post.php

@@ -80 +80 @@
-function submit_merged_post($post_id, $forum_id, $subject, $message, &$return_message, &$return_meta)
-{
-
+, $userdata
-
-        include($root_path . 'languages/lang_' . $config['default_lang'] . '/lang_merge.' . $phpEx);
@@ -151 +151 @@
-        $result = $db->sql_query($sql);
-
-
+
+
+
+
-        $result = $db->sql_query($sql);
-
@@ -157 +160 @@
-        remove_search_post($post_id);
-        add_search_words('single', $post_id, $message, $subject);
+
+
+        markread('post', $forum_id, $last_post_data['topic_id'], $current_time);
+
+        // Mark this topic as read
+        // We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)
+        markread('topic', $forum_id, $last_post_data['topic_id'], $current_time);
+        //
+
+        if ($config['load_db_lastread'] && $userdata['session_logged_in'])
+        {
+                $sql = 'SELECT mark_time
+                        FROM ' . FORUMS_TRACK_TABLE . '
+                        WHERE user_id = ' . $userdata['user_id'] . '
+                        AND forum_id = ' . $data['forum_id'];
+                $result = $db->sql_query($sql);
+                $f_mark_time = (int) $db->sql_fetchfield('mark_time');
+                $db->sql_freeresult($result);
+        }
+        else if ($config['load_anon_lastread'] || $userdata['session_logged_in'])
+        {
+                $f_mark_time = false;
+        }
+
+        if (($config['load_db_lastread'] && $userdata['session_logged_in']) || $config['load_anon_lastread'] || $userdata['session_logged_in'])
+        {
+                // Update forum info
+                $sql = 'SELECT forum_last_post_time
+                        FROM ' . FORUMS_TABLE . '
+                        WHERE forum_id = ' . $forum_id;
+                $result = $db->sql_query($sql);
+                $forum_last_post_time = (int) $db->sql_fetchfield('forum_last_post_time');
+                $db->sql_freeresult($result);
+
+                update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time, false);
+        }
-
-        // Meta & return message
@@ -273 +312 @@
-// Post a new topic/reply/poll or edit existing post/poll
-//
-
+, &$topic_first_post_sticky
-{
-        global $config, $lang, $db, $root_path, $phpEx;
@@ -313 +352 @@
-                $topic_vote = (!empty($poll_title) && count($poll_options) >= 2) ? 1 : 0;
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-                $db->sql_query($sql);
-
@@ -394 +447 @@
-        }
-
+        $post_data['post_time'] = $current_time;
+
+        if ($mode == 'post' || $mode == 'reply' || $mode == 'quote')
+        {
+                // Mark this topic as posted to
+                markread('post', $forum_id, $topic_id, $current_time);
+        }
+
+        // Mark this topic as read
+        // We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)
+        markread('topic', $forum_id, $topic_id, time());
+        //
+
+        if ($config['load_db_lastread'] && $userdata['session_logged_in'])
+        {
+                $sql = 'SELECT mark_time
+                        FROM ' . FORUMS_TRACK_TABLE . '
+                        WHERE user_id = ' . $userdata['user_id'] . '
+                        AND forum_id = ' . $data['forum_id'];
+                $result = $db->sql_query($sql);
+                $f_mark_time = (int) $db->sql_fetchfield('mark_time');
+                $db->sql_freeresult($result);
+        }
+        else if ($config['load_anon_lastread'] || $userdata['session_logged_in'])
+        {
+                $f_mark_time = false;
+        }
+
+        if (($config['load_db_lastread'] && $userdata['session_logged_in']) || $config['load_anon_lastread'] || $userdata['session_logged_in'])
+        {
+                // Update forum info
+                $sql = 'SELECT forum_last_post_time
+                                FROM ' . FORUMS_TABLE . '
+                                WHERE forum_id = ' . $forum_id;
+                $result = $db->sql_query($sql);
+                $forum_last_post_time = (int) $db->sql_fetchfield('post_time');
+                $db->sql_freeresult($result);
+
+                update_forum_tracking_info($forum_id,$forum_last_post_time, $f_mark_time, false);
+        }
+
-        //$meta = '<meta http-equiv="refresh" content="3;url=' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $post_id) . '#' . $post_id . '">';
-        $meta = '<meta http-equiv="refresh" content="3;url=' . append_sid($root_path . "phpbb2.php?page=viewtopic&" . POST_POST_URL . "=" . $post_id) . '#' . $post_id . '">';
@@ -426 +520 @@
-                                $topic_update_sql .= 'topic_replies = topic_replies - 1';
-
-
-
-
-
+
+
+
+
+
-
-                                if ($row = $db->sql_fetchrow($result))
-                                {
-                                        $topic_update_sql .= ', topic_last_post_id = ' . $row['last_post_id'];
+                                        $topic_update_sql .= ', topic_last_post_time = ' . $row['post_time'];
-                                }
-                        }
@@ -439 +535 @@
-                        if ($post_data['last_topic'])
-                        {
-
-
-
-
+
+
+
+
+
-
-                                if ($row = $db->sql_fetchrow($result))
-                                {
-
+. ', forum_last_post_time = ' . $row['post_time'] 
-                                }
-                        }
@@ -469 +566 @@
-        else if ($mode != 'poll_delete')
-        {
-"
-"
+, forum_last_post_time = " . $post_data['post_time']
+, topic_last_post_time = " . $post_data['post_time']
-        }
-        else

phpBB2/index.php

@@ -85 +85 @@
-        $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();
-
-//     if (!$user->data['is_registered
-//
-->
-//
+       if (!$userdata['session_logged_in
+
+
+
-}
-
@@ -191 +191 @@
-        while( $row = $db->sql_fetchrow($result) )
-        {
-->data['is_registered
+data['session_logged_in
-                {
-                        $forum_tracking_info[$forum_id] = (!empty($row['mark_time'])) ? $row['mark_time'] : $userdata['user_lastmark'];
-                }
-->data['is_registered
-
-//
-//
+data['session_logged_in
+
+
+
-                                $userdata['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['onlinesince']) : 0;
-//
+
-                        $forum_tracking_info[$row['forum_id']] = (isset($tracking_topics['f'][$row['forum_id']])) ? (int) (base_convert($tracking_topics['f'][$row['forum_id']], 36, 10) + $config['onlinesince']) : $userdata['user_lastmark'];
-                }

phpBB2/modcp.php

@@ -278 +278 @@
-                        $sql = "SELECT poster_id, COUNT(post_id) AS posts
-                                FROM " . POSTS_TABLE . "
-
+ AND poster_id <> " . ANONYMOUS . "
-                                GROUP BY poster_id";
-                        $result = $db->sql_query($sql);
@@ -489 +489 @@
-                                        if ( isset($_POST['move_leave_shadow']) )
-                                        {
+                                                $sql = 'INSERT INTO ' . TOPICS_TABLE . ' ' . $db->sql_build_array('INSERT', array(
+                                                        'forum_id' => $old_forum_id,
+                                                        'topic_title' => str_replace("\'", "''", $row[$i]['topic_title']),
+                                                        'topic_poster' => str_replace("\'", "''", $row[$i]['topic_poster']),
+                                                        'topic_time' => $row[$i]['topic_time'],
+                                                        'topic_status' => TOPIC_MOVED,
+                                                        'topic_type' => POST_NORMAL,
+                                                        'topic_vote' => $row[$i]['topic_vote'],
+                                                        'topic_views' => $row[$i]['topic_views'],
+                                                        'topic_replies' => $row[$i]['topic_replies'],
+                                                        'topic_first_post_id' => $row[$i]['topic_first_post_id'],
+                                                        'topic_last_post_id' => $row[$i]['topic_last_post_id'],
+                                                        'topic_last_post_time' => $row[$i]['topic_last_post_time'],
+                                                        'topic_moved_id' => $topic_id,
+                                                                        ));
-                                                // Insert topic in the old forum that indicates that the forum has moved.
-                                                $sql = "INSERT INTO " . TOPICS_TABLE . " (forum_id, topic_title, topic_poster, topic_time, topic_status, topic_type, topic_vote, topic_views, topic_replies, topic_first_post_id, topic_last_post_id, topic_moved_id)
-                                                        VALUES ($old_forum_id, '" . addslashes(str_replace("\'", "''", $row[$i]['topic_title'])) . "', '" . str_replace("\'", "''", $row[$i]['topic_poster']) . "', " . $row[$i]['topic_time'] . ", " . TOPIC_MOVED . ", " . POST_NORMAL . ", " . $row[$i]['topic_vote'] . ", " . $row[$i]['topic_views'] . ", " . $row[$i]['topic_replies'] . ", " . $row[$i]['topic_first_post_id'] . ", " . $row[$i]['topic_last_post_id'] . ", $topic_id)";
-                                                $db->sql_query($sql);
-                                        }
@@ -1381 +1394 @@
-                // End Simple Subforums MOD
-
-, p.post_time
-, " . POSTS_TABLE . " p
+
+
-                        WHERE t.forum_id = $forum_id
-                                AND t.topic_poster = u.uid
-
-
+
-                        LIMIT $start, " . $config['topics_per_page'];
-                $result = $db->sql_query($sql);
@@ -1451 +1463 @@
-                        $topic_replies = $row['topic_replies'];
-
-
+topic_last_
-
-                        $template->assign_block_vars('topicrow', array(

phpBB2/posting.php

@@ -59 +59 @@
-$topic_type = request_var('topictype', POST_NORMAL);
-$topic_type = ( in_array($topic_type, array(POST_NORMAL, POST_STICKY, POST_ANNOUNCE)) ) ? $topic_type : POST_NORMAL;
+$topic_first_post_sticky = request_var('topic_first_post_sticky', 0);
-
-//
@@ -213 +214 @@
-                $where_sql = "AND pt.post_id = p.post_id AND u.uid = p.poster_id";
-
-
+t.topic_first_post_sticky, 
-                        FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $from_sql . "
-                        WHERE p.post_id = $post_id
@@ -265 +266 @@
-                $post_data['topic_type'] = $post_info['topic_type'];
-                $post_data['poster_id'] = $post_info['poster_id'];
+                $post_data['topic_first_post_sticky'] = $post_info['topic_first_post_sticky'];
-
-                if ( $post_data['first_post'] && $post_data['has_poll'] )
@@ -602 +604 @@
-                                        $topic_type = ( $topic_type != $post_data['topic_type'] && !$is_auth['auth_sticky'] && !$is_auth['auth_announce'] ) ? $post_data['topic_type'] : $topic_type;
-
-
+, $topic_first_post_sticky
-                                }
-                        }
@@ -609 +611 @@
-                                $error_msg = '';
-                                submit_merged_post($last_post_id, $forum_id, $subject, $message, $return_message, $return_meta);
-                        }
-
-                        if ( $error_msg == '' ) {
-                                $current_time = time();
-
-                                if ($mode == 'post' || $mode == 'reply' || $mode == 'quote')
-                                {
-                                // Mark this topic as posted to
-                                        markread('post', $forum_id, $topic_id, $current_time);
-                                }
-
-                                // Mark this topic as read
-                                // We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)
-                                markread('topic', $forum_id, $topic_id, $current_time);
-                                //
-
-                                if ($config['load_db_lastread'] && $user->data['is_registered'])
-                                {
-                                        $sql = 'SELECT mark_time
-                                                FROM ' . FORUMS_TRACK_TABLE . '
-                                                WHERE user_id = ' . $user->data['user_id'] . '
-                                                AND forum_id = ' . $data['forum_id'];
-                                        $result = $db->sql_query($sql);
-                                        $f_mark_time = (int) $db->sql_fetchfield('mark_time');
-                                        $db->sql_freeresult($result);
-                                }
-                                else if ($config['load_anon_lastread'] || $user->data['is_registered'])
-                                {
-                                        $f_mark_time = false;
-                                }
-
-                                if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])
-                                {
-                                        // Update forum info
-                                        $sql = 'SELECT p.post_time
-                                                FROM ' . FORUMS_TABLE . ' f LEFT JOIN ' . POSTS_TABLE . ' p ON ( f.forum_last_post_id = p.post_id )
-                                                WHERE f.forum_id = ' . $forum_id;
-                                        $result = $db->sql_query($sql);
-                                        $forum_last_post_time = (int) $db->sql_fetchfield('post_time');
-                                        $db->sql_freeresult($result);
-
-                                        update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time, false);
-                                }
-                        }
-                break;
@@ -997 +956 @@
-                }
-                $topic_type_toggle .= ' /> ' . $lang['post_sticky'] . '  ';
+
-        }
-
@@ -1012 +972 @@
-        {
-                $topic_type_toggle = $lang['post_topic_as'] . ': <input type="radio" name="topictype" value="' . POST_NORMAL .'"' . ( ( $post_data['topic_type'] == POST_NORMAL || $topic_type == POST_NORMAL ) ? ' checked="checked"' : '' ) . ' /> ' . $lang['post_normal'] . '&nbsp;&nbsp;' . $topic_type_toggle;
+        }
+
+        if( $is_auth['auth_sticky'] ) {
+
+                $topic_type_toggle .= '<br /><input type="checkbox" name="topic_first_post_sticky" value="1"' . ( $post_data['topic_first_post_sticky'] ? ' checked="checked"' : '' ) . ' /> ' . $lang['topic_first_post_sticky'];
-        }
-}

phpBB2/search.php

@@ -729 +729 @@
-                $per_page = ( $show_results == 'posts' ) ? $config['posts_per_page'] : $config['topics_per_page'];
-
-->data['is_registered
+data['session_logged_in
-                        {
-->data['user_
+data['u
-                                {
-->data['user_
+data['u
-                                                AND t.topic_id = tp.topic_id)';
-                                        $sql_select .= ', tp.topic_posted';
@@ -740 +740 @@
-                                if ($config['load_db_lastread'])
-                                {
-->data['user_
+data['u
-                                                        AND t.topic_id = tt.topic_id)
-->data['user_
+data['u
-                                                        AND ft.forum_id = f.forum_id)';
-                                        $sql_select .= ', tt.mark_time, ft.mark_time as f_mark_time';
@@ -748 +748 @@
-                        }
-
-->data['is_registered
+data['session_logged_in
-                        {*/
-                                $tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';
@@ -790 +790 @@
-                        foreach ($forums as $forum_id => $forum)
-                        {
-->data['is_registered
+data['session_logged_in
-                                {
-                                        $topic_tracking_info[$forum_id] = get_topic_tracking($forum_id, $forum['topic_list'], $forum['rowset'], array($forum_id => $forum['mark_time']), ($forum_id) ? false : $forum['topic_list']);
-                                }
-->data['is_registered
+data['session_logged_in
-                                {*/
-                                        $topic_tracking_info[$forum_id] = get_complete_topic_tracking($forum_id, $forum['topic_list'], ($forum_id) ? false : $forum['topic_list']);
-
-//if (!$user->data['is_registered
-//
-->
-//
+if (!$userdata['session_logged_in
+
+
+
-                                //}
-                        }

phpBB2/viewforum.php

@@ -208 +208 @@
-
-        $sql = "SELECT COUNT(t.topic_id) AS forum_topics
-, " . POSTS_TABLE . " p
+
-                WHERE t.forum_id = $forum_id
-
-
+
-
-        $result = $db->sql_query($sql);
@@ -256 +255 @@
-
-$topic_rowset = array();
+$topic_list = array();
-$total_announcements = 0;
-while( $row = $db->sql_fetchrow($result) )
-{
-        $topic_rowset[] = $row;
+        $topic_list[] = $row['topic_id'];
-        $total_announcements++;
-}
@@ -283 +284 @@
-
-$total_topics = 0;
-$topic_list = array();
-while( $row = $db->sql_fetchrow($result) )
-{
@@ -425 +425 @@
-
-$topic_tracking_info = $tracking_topics = array();
-$forum_row['forum_last_post_time'] = 0;
-
-if( $total_topics )
@@ -432 +431 @@
-        $mark_time_forum = 0;
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-        for($i = 0; $i < $total_topics; $i++)
@@ -578 +589 @@
-                $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
-                $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
-
-                $forum_row['forum_last_post_time'] = max($forum_row['forum_last_post_time'], $topic_rowset[$i]['post_time']);
-
-                $template->assign_block_vars('topicrow', array(
@@ -712 +721 @@
-        // posts made since user last visited
-        //
-
-
-
-
-
-
+
+
+
+
+
-                                AND t.topic_moved_id = 0";
-                $result = $db->sql_query($sql);
@@ -724 +732 @@
-                while( $topic_data = $db->sql_fetchrow($result) )
-                {
-
+topic_last_
-                }
-                $db->sql_freeresult($result);
-
+
+
-        //
-        // Obtain list of moderators of each forum
@@ -777 +786 @@
-                if ( $is_auth_ary[$subforum_id]['auth_view'] )
-                {
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-

phpBB2/viewtopic.php

@@ -96 +96 @@
-                $topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id);
-
-0
+$userdata['session_time']
-
-                        $sql = "SELECT p.post_id
@@ -153 +153 @@
-// page the post is on and the correct display of viewtopic)
-//
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-$result = $db->sql_query($sql);
-
@@ -377 +389 @@
-
-        // Get topic tracking info
-->data['is_registered
+data['session_logged_in
-        {
-                $tmp_topic_data = array($topic_id => $topic_data);
@@ -383 +395 @@
-                unset($tmp_topic_data);
-        }
-->data['is_registered
+data['session_logged_in
-        {
-                $topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_id);
@@ -414 +426 @@
-        $limit = $config['posts_per_page'];
-}
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-$postrow = array();
@@ -436 +468 @@
-        while ($row = $db->sql_fetchrow($result));
-        $db->sql_freeresult($result);
+
+        if ( sizeof($sql_array) ) {
+                $sql = $db->sql_build_query('SELECT', $sql_array);
+                $result = $db->sql_query($sql);
+                $first_post_data = array($db->sql_fetchrow($result));
+                $postrow = array_merge($first_post_data, $postrow);
+        }
-
-        if ( sizeof($posts_ary) ) {
@@ -450 +489 @@
-        }
-
-count
+sizeof
-}
-else
@@ -1394 +1433 @@
-if (isset($topic_tracking_info[$topic_id]) && $forum_topic_data['topic_last_post_time'] > $topic_tracking_info[$topic_id] && $max_post_time > $topic_tracking_info[$topic_id])
-{
-
-        markread('topic', $forum_id, $topic_id, $max_post_time);
-

sql.sql

@@ -417 +417 @@
-('tags_max_allow', '10', 0),
-('tags_max_length', '50', 0),
-
+
+
+
+
-
--- --------------------------------------------------------
@@ -680 +683 @@
-  `auth_attachments` tinyint(2) default '0',
-  `forum_parent` int(11) default '0',
+  `forum_last_post_time` int(11) default '0',
-  PRIMARY KEY  (`forum_id`),
-  KEY `forums_order` (`forum_order`),
@@ -880 +884 @@
-  `topic_type` tinyint(3) default '0',
-  `topic_first_post_id` mediumint(8) unsigned default '0',
+  `topic_first_post_sticky` tinyint(1) default '0',
-  `topic_last_post_id` mediumint(8) unsigned default '0',
-  `topic_moved_id` mediumint(8) unsigned default '0',
+  `topic_last_post_time` int(11) default '0',
-  PRIMARY KEY  (`topic_id`),
-  KEY `forum_id` (`forum_id`),
@@ -1170 +1176 @@
-  `completed` int(11) default '0',
-  `active` tinyint(4) default '0',
-
-
+
-  KEY `peer_id` (`peer_id`(20))
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -1616 +1621 @@
-  `torrentid` int(10) default '0',
-  `userid` int(10) default '0',
-  `port` smallint(5) unsigned default '0',
-  `uploaded` bigint(20) unsigned default '0',
-  `downloaded` bigint(20) unsigned default '0',
-  `last_action` int(11) default '0',
-  `completedat` int(11) default '0',
-torrent
+fid_u
-  KEY `userid` (`userid`),
-_2
+
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
@@ -1901 +1905 @@
-  `user_unread_pms` int(10) default '0',
-  `user_rank_id` int(10) default '0',
+  `user_lastmark` int(11) default '0',
-  PRIMARY KEY  (`uid`),
-  UNIQUE KEY `torrent_pass` (`torrent_pass`),

templates/bithdtv/bbcode.html

@@ -20 +20 @@
-
-<!-- BEGIN spoiler_close -->
-
+
+
+
-<!-- END spoiler_close -->
-

templates/main/bbcode.html

@@ -12 +12 @@
-
-<!-- BEGIN spoiler_header_open -->
-
+
+
+
+
+
+
+
-<!-- END spoiler_header_open -->
-
-<!-- BEGIN spoiler_open -->
-
+
+
+
+
+
+
-<!-- END spoiler_open -->
-
-<!-- BEGIN spoiler_close -->
-
+
+
+
-<!-- END spoiler_close -->
-
@@ -66 +79 @@
-</table>
-<!-- END mod_close -->
-
-<!-- BEGIN flash -->
-        <object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" codebase="http://active.macromedia.com/flash2/cabs/swflash.cab#version=5,0,0,0" width="{WIDTH}" height="{HEIGHT}">
-                <param name="movie" value="{URL}" />
-                <param name="play" value="true" />
-                <param name="loop" value="true" />
-                <param name="quality" value="high" />
-                <param name="allowScriptAccess" value="never" />
-                <embed src="{URL}" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" width="{WIDTH}" height="{HEIGHT}" play="true" loop="true" quality="high" allowscriptaccess="never"></embed>
-        </object>
-<!-- END flash -->

templates/reflection/bbcode.html

@@ -20 +20 @@
-
-<!-- BEGIN spoiler_close -->
-
+
+
+
-<!-- END spoiler_close -->
-

topten.php

@@ -2 +2 @@
-$root_path = './';
-require ($root_path . 'include/config.php');
+require ($root_path . 'include/functions_torrenttable.php');
-
-$userdata = session_pagestart($user_ip);
@@ -7 +8 @@
-loggedinorreturn();
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-                        // www.phpBB-SEO.com SEO TOOLKIT BEGIN
-
-
-
+
+
+
+
+
+
+
+
+
+
-                        // www.phpBB-SEO.com SEO TOOLKIT END
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-        }
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-stdhead($lang['top10']);
-$template->set_filenames(array(
-10.html')
-
+_ten_body.html'
+)
-stdfoot();
-?>