##############################################################
## MOD Title: Bookmarks
## MOD Author: DanielT < daniel@danielt.com > (Daniel Taylor) http://www.danielt.com
##		Modified for Torrent Pier R775 by Demetri
## MOD Description: this mod will allow users to bookmark topics
##
## MOD Version: 1.0.2 / 0.1.0b for TorrentPier R775 modern
##
## Installation Level: (Easy)
##
## Installation Time: 5 Minutes
##
## Files To Edit: admin/admin_users.php,
##      viewtopic.php,
##      includes/init_bb.php,
##      includes/page_header.php,
##	templates/default/page_header.tpl,
##	templates/default/viewtopic.tpl,
##	language/lang_russian/lang_main.php
##
## Included Files: bookmarks.php, book_body.tpl
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##
##############################################################
##
## 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 0.1.0b
##      - Initial BETA release
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `bb_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',
`forum_id` int(11) NOT NULL default '0', 
PRIMARY KEY (`book_id`)) 
#
#-----[ COPY ]------------------------------------------
#

copy root/bookmarks.php to bookmarks.php
copy root/templates/default/book_body.tpl to templates/default/book_body.tpl

#
#-----[ OPEN ]------------------------------------------
#

admin/admin_users.php

#
#-----[ FIND ]------------------------------------------
# 
				user_delete($user_id, !empty($_POST['delete_user_posts']));
#
#-----[ AFTER, ADD ]------------------------------------------
# 
				// Bookmarks
				$sql = "DELETE FROM " . BB_BOOKMARKS . "
					WHERE user_id = $user_id";
				if ( !DB()->sql_query($sql) )
				{
					message_die(GENERAL_ERROR, 'Could not delete user from bookmarks table', '', __LINE__, __FILE__, $sql);
				}
				// Bookmarks [END]
				
#
#-----[ OPEN ]------------------------------------------
#

includes/init_bb.php

#
#-----[ FIND ]------------------------------------------
# 
define('BB_VOTE_USERS',           'bb_vote_voters');
#
#-----[ AFTER, ADD ]------------------------------------------
# 
// Bookmarks
define('BB_BOOKMARKS',            'bb_bookmarks');
// Bookmarks [END]

#
#-----[ OPEN ]------------------------------------------
#

includes/page_header.php

#
#-----[ FIND ]------------------------------------------
# 
	'U_TRACKER'          => "tracker.php",
#
#-----[ AFTER, ADD ]------------------------------------------
# 
	// Bookmarks
	'L_BOOK' => $lang['BOOKMARKS'],
	'U_BOOK' => append_sid('bookmarks.php'),
	// Bookmarks [END]
			
#
#-----[ OPEN ]------------------------------------------
#

viewtopic.php

#
#-----[ FIND ]------------------------------------------
#
//
// Send vars to template
//
#
#-----[ AFTER, ADD ]------------------------------------------
# 
// Bookmarks
if ($userdata['session_logged_in']) {
	
	$sql = "SELECT *
		FROM " . BB_BOOKMARKS . "
		WHERE user_id = '" . $userdata['user_id'] . "' AND topic_id = '" . intval($topic_id) ."'";

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

	$num_row = DB()->num_rows($result);
	
	if (intval($num_row) == 0) {
		$template->assign_vars(array(
			'U_BOOKMARK' => "<a href=\"". append_sid("bookmarks.php?t=" . $topic_id . "&amp;f=" . $forum_id . "&amp;mode=add" . "\">" . $lang['ADD_BOOK'] . "</a>")) 
		);
	}
	else {
		$template->assign_vars(array(
			'U_BOOKMARK' => "<a href=\"". append_sid("bookmarks.php?t=" . $topic_id . "&amp;f=" . $forum_id . "&amp;mode=remove" . "\">" . $lang['remove_book'] . "</a>")) 
		);
	}

}
// Bookmarks [END]

#
#-----[ OPEN ]------------------------------------------
#

templates/default/page_header.tpl

#
#-----[ FIND ]------------------------------------------
#
			<a href="{U_PRIVATEMSGS}"><b>{L_PRIVATE_MESSAGES}</b></a>&#0183;
#
#-----[ BEFORE, ADD ]------------------------------------------
#
			<!-- Bookmarks -->
			<a href="{U_BOOK}"><b>{L_BOOK}</b></a>&#0183;
			<!-- Bookmarks [END] -->

#
#-----[ OPEN ]------------------------------------------
#

templates/default/viewtopic.tpl

#
#-----[ FIND ]------------------------------------------
#
<tr>
	<td valign="bottom">
		<a href="{U_POST_REPLY_TOPIC}"><img src="{REPLY_IMG}" alt="{T_POST_REPLY}" /></a>
	</td>
	<td class="nav w100" style="padding-left: 8px;">
		<a href="{U_INDEX}">{T_INDEX}</a>
		<!-- IF HAS_PARENT_FORUM --> <em>&raquo;</em>&nbsp;<a href="{PARENT_FORUM_HREF}">{PARENT_FORUM_NAME}</a><!-- ENDIF -->
		<em>&raquo;</em>&nbsp;<a href="{U_VIEW_FORUM}">{FORUM_NAME}</a>
	</td>
#
#-----[ AFTER, ADD ]------------------------------------------
#
	<!-- Bookmarks -->
	<td class="nav w100 nowrap tRight">
		{U_BOOKMARK}
	</td>
	<!-- Bookmarks [END] -->

#
#-----[ OPEN ]------------------------------------------
#

language/lang_russian/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ AFTER, ADD ]------------------------------------------
# 
//
// Bookmarks
//
$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'] = "     !";
$lang['NO_BOOKMARKS'] = "   !";
//
// Bookmarks [END]
//
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM


[quote="PandoraBox_2007"]

 \forum\includes\functions_admin.php 

$sql="
SELECTtopic_id,forum_id,topic_title,topic_status
FROM".BB_TOPICS."
WHEREtopic_idIN($topic_csv)
$where_sql
";

 

//Bookmarkdelete
$sql2="DELETEFROM".BB_BOOKMARKS."WHEREtopic_idIN($topic_csv)";
//BookmarkdeleteEnd.

 

foreach(DB()->fetch_rowset($sql)as$row)
{
$topic_csv[]=$row['topic_id'];
$log_topics[]=$row;
$sync_forums[$row['forum_id']]=true;
}

 

//Bookmarkdelete
if(!DB()->sql_query($sql2))
{
message_die(GENERAL_ERROR,'Couldnotdeletebookmark','',__LINE__,__FILE__,$sql);
}
unset($sql2);
//BookmarkdeleteEnd.

 bookmarks.php

 

if( !$userdata['session_logged_in'] ) { 
   header("Location: " . append_sid($phpbb_script_path . "login.php"  . "?redirect=bookmarks.php" )); 
   exit; 
}
 
  

if( !$userdata['session_logged_in'] ) {
   header("Location: " . append_sid($phpbb_root_path . "login.php" . "?redirect=bookmarks.php"));
   exit;
} 
