Hi,

I must be missing something simple, but I can't find the files (post.php, etc) in my installation to edit. The way i understand it, it should be in root -> components -> com_fireboard. There doesn't seem to be anything in there except fireboard.php that even hints at making fireboard function.

Where do I look? Sorry if I'm being daft...

Nevermind, I found them in the template folder (default). Sorry...

I took a stab at modifying the newest Community Builder plugin that works (avaiable from this thread: http://www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,48565/catid,13/limit,6/limitstart,0/) so that it would work with the subscribe to category hack in this thread.

Now this plugin will show subscribed posts and subscribed categories, and will give users a way to unsubscribe to both.

Begin by loading the package above from Joomlapolis. Follow the instructions to make sure the updated simpleboard plugin works out of the box. Then write this version of cb.simpleboardtab.php over Nant's.

Notes:

1. You'll have to define an additional language string: _UE_USER_CAT_SUBSCRIPTIONS (I defined it as "Your Category Subscriptions" to match).


2. I broke the "unsubscribe all" form, if it worked properly in the first place. (I assume it did, because the favorites one still works). I didn't find it necessary so I commented it out instead of fussing with it.


3. If a user has either a post or category subscription, the query for each will always have something in it, so your lose the "no subscriptions" text. You can tweak the SQL to make that work better, I'm sure.


4. My template didn't like the way this plugin used the css class "sectiontableheader", so I changed it from divs back to a table header. Even though it's a table, it seemed cleaner (and worked better for me)


5. IE says it the page loads with errors, but it still seems to work fine

If anyone can improve on this, I wouldn't mind
Let us know how it works for you.

File didn't attach, sorry...

polc1410 wrote:
OK, things get too messy trying to post lines of html on Joomla Board so I've written a HowTo and put it here:
http://www.wittongilbert.free-online.co.uk/FBHack/HowTo.html

Comments / changes / bugs / problems / praise back on this thread please. If I update it, I'll post here too...
My only suggestion is to change your new field name to category_id.

You might like to add the following hacks as well to get the User Profile working properly:

In template/default/plugin/myprofile/myprofile.php, about line 386

Code:

//get all subscriptions for this user // <JXHACK> //$database->setQuery("select thread from #__fb_subscriptions where userid=$my->id ORDER BY thread DESC LIMIT $limitstart, $limit"); // Replace with more efficient query so the subs template doesn't have to do as much work $query = 'SELECT s.*, m.time, m.hits, m.name,' . ' CASE WHEN (s.thread = 0) THEN c.name ELSE m.subject END AS subject,' . ' CASE WHEN (s.thread = 0) THEN c.id ELSE m.catid END AS catid' . ' FROM #__fb_subscriptions AS s' . ' LEFT JOIN #__fb_messages AS m ON m.id = s.thread' . ' LEFT JOIN #__fb_categories AS c ON c.id = s.category' . ' WHERE s.userid='.(int) $my->id . ' ORDER BY s.thread, s.category DESC'; $database->setQuery( $query, $limitstart, $limit ); // </JXHACK> $subslist = $database->loadObjectList();

This also makes the rendering in the subs template far more efficient. Note above I'm using the correct way to set the limit start and limit in setQuery, and also I am casting any input variables in the query just to be on the safe side (with respect to possible injection attacks).

Then, in template/default/plugin/myprofile/myprofile_subs.php, about line 65

Code:

// <JXHACK> foreach ($subslist as $sub) { //get all message details for each subscription // We got all this information in the main query //$database->setQuery("select * from #__fb_messages where id=$subs->thread "); //$subdet = $database->loadObjectList(); //foreach ($subdet as $sub) { $k = 1 - $k; echo '<tr class="' . $boardclass . '' . $tabclass[$k] . '" >'; if ($sub->thread == 0) { $link = JB_LIVEURLREL . '&amp;func=showcat&amp;catid=' . $sub->catid; } else { $link = JB_LIVEURLREL . '&amp;func=view&amp;catid=' . $sub->catid . '&amp;id=' . $sub->id; } echo '<td class="td-1" width="54%" align="left">' . $enum . ': <a href="' . sefRelToAbs( $link ) . '">' . $sub->subject; // </JXHACK>

Removing that query in the loop should give that page a significant performance boost.

Anyone know if the authors are putting at least the original hack into the distro?

I've not had any communication for a while.

I suspect 1.1 will have the feature but maybe a different methodology.

Assuming tis possible I'd then write a short conversion script to move existing subs over...

Thanks for the contribution BTW, will look at it properly l8r and see if I can tweak the how to page.