Add "S" icon next to Subscribed Threads w/link to view all subscriptions

This is my first "released" hack so I can give something back for all the cool hacks I found here.

This one is fairly simple. What it does is put a small icon next to the title in any thread that the user has subscribed to.
The small icon is a clickable link which will take the user to a page where they can view all of their subscriptions.

This requires modifying forumdisplay.php and one template file "forumdisplaybit".
Also you must upload the image icon file to your images directory.

First let's modify the forumdisplay.php file:

Find:

PHP Code:

    eval("\$forumdisplaybits .= \"".gettemplate('forumdisplaybit')."\";"); 


And above it put:

PHP Code:

//Subscribed thread with S icon hack begin
$show_subscribed=''; // empty variable out for each pass in while loop
$s_iconhack_userid=$bbuserinfo['userid'];
$check_user_subscribed=$DB_site->query_first("SELECT subscribethreadid FROM subscribethread WHERE threadid=$thread[threadid] AND userid='$s_iconhack_userid' LIMIT 1");
$subscribed_id=$check_user_subscribed[subscribethreadid];
if ($subscribed_id>0)
{ 
$show_subscribed=" <a href=\"member2.php?s=$session[sessionhash]&action=viewsubscription&daysprune=1000\"><img src=\"images/subscribed-icon.gif\" align=\"middle\" width=15 height=15 border=0 alt=\"You are subscribed to this thread. Click to view all subscriptions\"></A> ";
} 
//Subscribed Icon Hack End 


Now go into the admin cp and change the template forumdisplaybit as follows:

Find:

PHP Code:

    <td bgcolor="#13486D" align="left" width="70%"><normalfont>$thread[gotonew] $paperclip$thread[movedprefix]$thread[typeprefix]<a href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]">$thread[title]</a></normalfont> <smallfont>$thread[pagenav]</smallfont></td> 


Change this to:

PHP Code:

    <td bgcolor="#13486D" align="left" width="70%"><normalfont>$thread[gotonew] $paperclip$thread[movedprefix]$thread[typeprefix]<a href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]">$thread[title]</a></normalfont>$show_subscribed <smallfont>$thread[pagenav]</smallfont></td> 


Then upload the icon below to your image directory and that's it!

I'll try to upload a demo page in a minute or so.

[AndyTSJ]

Same here... worked with "if 0==0", each post had an "S" .... just wished I knew a bit of php cuz this is probably a real easy thing to fix. Love the idea though, definitely not gonna give up on this one....

[mvigod]

OK...I found the problem...in the if statement I missed the dollar sign ($) when changing over the variable names to make them easier to read

it should be:

PHP Code:

if ($subscribed_id>0) 


Note the dollar sign before "subscribed_id" now...before it didn't have it on the original post so it never satisfied the condition.

I'll fix the original post so it's updated too.

LMK if it works now...must have been a long day when I missed that one

[AndyTSJ]

Works Thanks man ! Cool hack.

[mvigod]

AndyTSJ - Looks like you have a border around the icon there....in the image tag make sure you have "border=0" so it shows up as a round circle unless you wanted it that way with the border for some reason. The original code above does in fact already have the "border=0" reference within the image tag.

[AndyTSJ]

Yea, just the way I did my graphic as opposed to being a border around the image.

[Tim Wheatley]

I modified it to show text instead of an icon, but it works like a dream -- thanks!

[mvigod]

I had text originally for this hack too actually but liked the icon look for my site...images convey meaning to the brain faster than reading which is why I changed over to the icon.

If any user wants to substitute text for the icon just replace the <img> tag code with the text they want to see instead.

So if you prefer to use text instead of small "S" icon just replace the piece below from the original code with whatever text you want (i.e. subscribed):

PHP Code:

<img src=\"images/subscribed-icon.gif\" align=\"middle\" width=15 height=15 border=0 alt=\"You are subscribed to this thread. Click to view all subscriptions\"> 


[Warez]

Hmmm. even with the $ in front, nothing shows up .

[mvigod]

make sure you are looking at a forum which has a thread that you are definitely subscribed to or you won't see the "S". Also be sure you uploaded the small S image to your images folder. Let me know if this works.

[GK_ng]

as this Hack added a bunch of Queries, I did a redesign of this genious hack:

find:

SELECT $dotuserid $votequery ".iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
	thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
	lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach
	FROM thread
	".iif($foruminfo[allowicons],'LEFT JOIN icon ON (icon.iconid = thread.iconid)','')."
	$dotjoin
	WHERE $threadids
	ORDER BY sticky DESC, $sortfield $sqlsortorder
	");

replace it with

SELECT $dotuserid $votequery ".iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
	thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
	lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach,subscribethread.subscribethreadid AS subscribed
	FROM thread
	LEFT JOIN subscribethread 
	  ON (subscribethread.threadid=thread.threadid AND subscribethread.userid='".$bbuserinfo['userid']."')
	".iif($foruminfo[allowicons],'LEFT JOIN icon ON (icon.iconid = thread.iconid)','')."
	$dotjoin
	WHERE $threadids
	ORDER BY sticky DESC, $sortfield $sqlsortorder
	");

and then find:

PHP Code:

    eval("\$forumdisplaybits .= \"".gettemplate('forumdisplaybit')."\";"); 


and place ABOVE ist:

PHP Code:

//Subscribed thread with S icon hack begin
if ($thread[subscribed]) { 
  $thread[title]="<i>".$thread[title]."</i>";
}
//Subscribed Icon Hack End 


Instead of

$thread[title]="<i>".$thread[title]."</i>";

you can place whatever you want to do, like

$show_subscribed=" <a href=\"member2.php?s=$session[sessionhash]&action=viewsubscription&daysprune=1000\"><img src=\"images/subscribed-icon.gif\" align=\"middle\" width=15 height=15 border=0 alt=\"You are subscribed to this thread. Click to view all subscriptions\"></A> ";

etc pp..


Full Credits to mvigod for the idea and the first release of this hack ...