[FULL] Bookmarks 1.0.2

Andrey · Зарегистрирован: 2010-08-28

##############################################################
## MOD Title: Bookmarks
## MOD Author: DanielT < daniel@danielt.com > (Daniel Taylor) http://www.danielt.com
## MOD Description: this mod will allow users to bookmark topics
## MOD Version: 1.0.2
##
## Installation Level: (Intermediate)
## Installation Time: 20 Minutes
## Files To Edit: admin/admin_users.php,
## includes/constants.php,
## includes/functions_post.php,
## includes/page_header.php,
## includes/prune.php,
## language/lang_english/lang_main.php,
## modcp.php,
## templates/subSilver/overall_header.tpl,
## templates/subSilver/viewtopic_body.tpl,
## viewtopic.php
## Included Files: bookmarks.php, book_body.tpl
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes:
## This MOD is a replacment for my old 'Favorites' MOD.
## Big thanks to smitjel for his 'reposition watch topic link' MOD
## which i was able to re-use here.
##
##############################################################
## MOD History:
##
## 2005-10-27 - Version 1.0.0
## - This first release of 'Bookmarks' MOD
## 2005-10-27 - Version 1.0.1
## - This release fixes a small SQL problem and does the
## langauge bit correctly.
## 2005-10-30 - Version 1.0.2
## - Added 'No Bookmarks' text into bookmarks.php
## - Changed U_BOOK to U_BOOKMARK in viewtopic.php (and .tpl)
## since U_BOOK was already used in the header and sometimes
## caused problems (when the user was a guest)
## - fixed redirect problem in bookmarks.php, missed a '.'
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

Делаем запрос:

Код:

CREATE TABLE `phpbb_bookmarks` (
`book_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`topic_id` int(11) NOT NULL default '0',
PRIMARY KEY (`book_id`)
)

Копируем файлы на сервер:
copy bookmarks.php to bookmarks.php
copy book_body.tpl to templates/subSilver/book_body.tpl
Открыть:
admin/admin_users.php
Найти:

Код:

$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "
WHERE user_id = $user_id";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete user from topic watch table', '', __LINE__, __FILE__, $sql);
}

Добавить после:

Код:

// Bookmarks MOD, 1.0.1
$sql = "DELETE FROM " . BOOKMARKS_TABLE . "
WHERE user_id = $user_id";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete user from bookmarks table', '', __LINE__, __FILE__, $sql);
}

Открыть:
includes/constants.php
Найти:

Код:

define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

После добавить:

Код:

// Bookmarks MOD, 1.0.1
define('BOOKMARKS_TABLE', $table_prefix.'bookmarks');

Открыть:
includes/functions_post.php
Найти:

Код:

$topic_update_sql .= ', topic_last_post_id = ' . $row['last_post_id'];
}

Добавить после:

Код:

// Bookmarks MOD, 1.0.1
$sql = "DELETE FROM " . BOOKMARKS_TABLE . "
WHERE topic_id = $topic_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in deleting bookmark', '', __LINE__, __FILE__, $sql);
}

Открыть:
includes/page_header.php
Найти:

Код:

'L_WHOSONLINE_MOD' => sprintf($lang['Mod_online_color'], '', ''),

Добавить после:

Код:

'L_BOOK' => $lang['bookmarks'],

Найти:

Код:

'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

Добавить после:

Код:

'U_BOOK' => append_sid('bookmarks.'.$phpEx),

Открыть:
includes/prune.php
Найти:

Код:

message_die(GENERAL_ERROR, 'Could not delete watched topics during prune', '', __LINE__, __FILE__, $sql);
}

Добавить после:

Код:

// Bookmarks MOD, 1.0.1
$sql = "DELETE FROM " . BOOKMARKS_TABLE . "
WHERE topic_id IN ($sql_topics)";
if ( !$db->sql_query($sql, BEGIN_TRANSACTION) )
{
message_die(GENERAL_ERROR, 'Could not delete bookmarked topics during prune', '', __LINE__, __FILE__, $sql);
}

Открыть:
language/lang_russian/lang_main.php
Найти:

Код:

$lang['Admin_reauthenticate']

Добавить после:

Код:

//Bookmark Mod, 1.0.1

$lang['remove_book_data'] = 'Не удалось удалить данные из таблицы закладки';
$lang['insert_book_data'] = 'Не могу вставить данные в таблице закладки';
$lang['no_book_topic'] = 'Нет выбранных тем!';
$lang['bookmarks'] = 'Закладки';
$lang['add_book'] = 'Добавить в закладки';
$lang['remove_book'] = 'Удалить закладку';
$lang['bookmark_added'] = "Тема успешно добавлена в закладки";
$lang['bookmark_removed'] = "Тема успешно удалена из закладок";
$lang['Click_return_bookmarks'] = "Нажмите %sздесь%s что бы вернуться в закладки";
$lang['exist_book'] = "Эта тема уже есть в закладках!";
//Bookmark MOD, 1.0.2
$lang['no_bookmarks'] = "У вас нет закладок!";

Открыть:
modcp.php
Найти:

Код:

$sql = "DELETE
FROM " . TOPICS_WATCH_TABLE . "

Код:

Перед добавить:

Код:

// Bookmarks MOd, 1.0.1
$sql = "DELETE
FROM " . BOOKMARKS_TABLE . "
WHERE topic_id IN ($topic_id_sql)";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete bookmarked list', '', __LINE__, __FILE__, $sql);
}

Открыть:
templates/subSilver/overall_header.tpl
Найти:

Код:

<a href="{U_GROUP_CP}">{L_USERGROUPS}</a>

После добавить:

Код:

Открыть:
templates/subSilver/viewtopic_body.tpl
Найти:

Код:

<a href="{U_VIEW_FORUM}" class="nav">{FORUM_NAME}</a></td>

После добавить:

Код:

<td align="left" nowrap="nowrap">[{U_BOOKMARK}]</td>

Открыть:
viewtopic.php
Найти:

Код:

'U_POST_REPLY_TOPIC' => $reply_topic_url)
);

После добавить:

Код:

// Bookmarks MOD, 1.0.1
// Check to see if the topic has already been bookmarked

if ($userdata['session_logged_in']) {

$sql = "SELECT *
FROM " . BOOKMARKS_TABLE . "
WHERE user_id = '" . $userdata['user_id'] . "' AND topic_id = '" . intval($topic_id) ."'";

$result = $db->sql_query($sql);

$num_row = $db->sql_numrows($result);

if (intval($num_row) == 0) {
$template->assign_vars(array(
'U_BOOKMARK' => "<a class=\"nav\" href=\"". append_sid("bookmarks.$phpEx?t=" . $topic_id . "&mode=add" . "\">" . $lang['add_book'] . "</a>"))
);
}
else {
$template->assign_vars(array(
'U_BOOKMARK' => "<a class=\"nav\" href=\"". append_sid("bookmarks.$phpEx?t=" . $topic_id . "&mode=remove" . "\">" . $lang['remove_book'] . "</a>"))
);
}

}