add sql
Code:
CREATE TABLE IF NOT EXISTS `bookmarks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`torrentid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
also
Code:
ALTER TABLE torrents ADD addbookmark char(3) NOT NULL DEFAULT no
torrent-details.php
add where want to show
Code:
// Bookmarks mod
echo "<FIELDSET class=download><LEGEND></a><B>Bookmark this torrent</B></LEGEND>";
echo "<CENTER><table border=0 width=98%><TR><TD>";
$bookt = mysql_query("SELECT torrentid FROM bookmarks WHERE torrentid =" .$row[id]);
$bookt1 = mysql_fetch_array($bookt);
if ($bookt1[0] == $row[id])
{
print ("<div align=left><b>You already have this torrent in Your Bookmark Click. [<a href='takedelbookmark.php?bookmarkid=". $row[id] ."'><font color=red>HERE</font></a>] to remove it</b>");
}
else {
print ("<div align=left><b>Click <a href=bookmarks.php?torrent=$row[id]><b><font color=red>HERE</font><b></a><b> to save to bookmarks which can be viewed <a href='bookmark.php'><font color=red>HERE</font></b></a>.\n");}
echo "</table></FIELDSET><BR>";
// End Bookmarks mod
add attached to root
add link to bookmark.php in account.php