New Posts in Subscribed Forums

New Posts in Subscribed Forums
Originaly Released: 11-09-2001
Last Updated: 11-09-2001
Author: mister
Demo: Sorry, no demo...
Installation Instructions are as follows:

1) Backup your database and all forum files, just in case
2) Add this new template

name: error_not_subscribed

stuff:
You are not subscribed to any forums. This search is only for those who are subscribed to forums. You can subscribe to forums by clicking on the 'Subscribe to this forum' link at the top of each individual forum.

3) Edit search.php as noted below

NOTE: All Additions happen in this if-block: if ($action=="getnew") {
If you put them in the other if's (i.e. newdaily, etc) it won't work properly.


FIND:

PHP Code:

if ($action=="getnew") {
  // generate query
  // do it!
  if ($bbuserinfo[userid]!=0 or $bbuserinfo[lastvisit]!=0) {
    $forumsql=getallforumsql(); 


AFTER IT, PUT THIS:

PHP Code:

//New Subscribed Posts Hack
if ($getsubscribed) {
  $subscr_where=getsubscribedforumsql();
  if (!$subscr_where) {
    eval("standarderror(\"".gettemplate("error_not_subscribed")."\");");
    exit;
  }
}
//End New Subscribed Posts Hack 


IN THAT SAME "getnew" IF-BLOCK FIND:

PHP Code:

$wheresql="1=1".$forumsql.$datesql;
$wheresql.=" AND thread.open<>10"; 


AFTER IT, PUT THIS:

PHP Code:

//New Subscribed Posts Hack
if ($getsubscribed) {
  $wheresql.=" AND thread.forumid IN ".$subscr_where;
}
//End New Subscribed Posts Hack 


PUT THIS SOMEWHERE IN THE FILE:

PHP Code:

// ###################### Start get subscribed forum sql #############
function getsubscribedforumsql() {
   global $bbuserinfo,$DB_site;
   $forums=$DB_site->query("SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=$bbuserinfo[userid] ORDER BY title");
      
   if ($DB_site->num_rows($forums)) {
      $ret = '(';
      while ($forum=$DB_site->fetch_array($forums)) {
         $ret .= $forum[forumid] . ',';
      }
      $ret = substr($ret,0,strlen($ret)-1);
      $ret .= ')';
   } else {
      $ret = '';
   }
   return $ret;  
} 


4) Edit your forumhome_newposts template

Add this

PHP Code:

 | <a href="search.php?s=$session[sessionhash]&action=getnew&getsubscribed=1">View New Subscribed Posts</a> 


5) Enjoy!

[LuBi]

So what's this do? Search thread your subsribed to..? How do I select which forum to search..? no demo or ss... sounds great but I need more info I'll be sure to install..

[Admin]

LuBi, it just shows you all threads you are subscribed to that have new posts in them.
Like the "View New Posts" search, only this only returns subscribed threads.

mister, I think you forgot a function you wrote, getsubscribedforumsql().

[LuBi]

LuBi, it just shows you all threads you are subscribed to that have new posts in them.

All the time when you search or is it selectable?

[Admin]

[QUOTE]Originally posted by LuBi
All the time when you search or is it selectable?

[red_baron2000]

anyone mind finishing this ?
please

[mister]

Sorry about forgetting to add that one function.
My bad. Thanks for reminding me, red_barron2000.

Should work now once you add that function to search.php

[Boofo]

I'm getting this error after adding the function.

Parse error: parse error, unexpected ',' in /home/bear/public_html/forum/search.php on line 578

It has to do with this line.

$ret = $ret,0,$ret)-1);

[red_baron2000]

Today at 07:18 PM Boofo said this in Post #8
I'm getting this error after adding the function.

Parse error: parse error, unexpected ',' in /home/bear/public_html/forum/search.php on line 578

It has to do with this line.

$ret = $ret,0,$ret)-1);

same here