chris2005 wrote:
I've changed the second line:

ALTER TABLE #__fb_subscriptions ADD `category` INT( 11 ) NULL DEFAULT '0'

into:

ALTER TABLE jos_fb_subscriptions ADD `category` INT( 11 ) NULL DEFAULT '0'

and the query works that way. But is this correct?
Sorry thats a typo - I was going to get Joomla to execute these but gave up as my server is down right now and so there became real priorities...

Joomla substitutes jos_ in instead of #__ assuming that's your table prefix.

Will fix this on the html page

ALTER TABLE jos_fb_subscriptions CHANGE `thread` `thread` INT( 11 ) NULL DEFAULT '0' ALTER TABLE

Run the two lines seperately..? But yes with the second line fixed as you propose...

Furthermore I was wondering if it is possible to change the behaviour of the hack right after clicking the subscribe button. At the moment it goes to the fireboard profile page after some seconds. I'm using CB profiles so this is not correct behaviour for this matter. I would like to have the destination page to be the actual forum instead.
Erm... what happens when you subscribe to a post instead of a category? Cause it should do the same?

Yes it actually does the same thing which I don't like. I remember it didn't do that before with previous versions of fb 1.0.4.

Anyway thanx for your help. I'll make a seperate topic for my last issue.

Regards,
Chris

Sorry - I've read through this thread and I'm not sure what to do. We just did a massive conversion of an SMF forum that had 10 years worth of posts in it to Fireboard 1.0.4 - then realized we didn't have the ability to let people subscribe to a forum (category) rather than a thread - which is very popular with our users.

Am I to understand there is a hack or something you guys have developed that will allow us to offer that?

Thanks for bearing with a noob.

See this link:
http://www.wittongilbert.free-online.co.uk/FBHack/HowTo.html

I did the hack for fb1.0.3 and it worked fair.

When I upgraded today to fb 1.0.4 ... in a rush and not thinking ... I lost all of my mods, config settings, etc.

I used your web instructions (sense the files are all different now) and all worked well. Initial testing appears like it works. I placed into production and all is peaceful with the site and users.

It would be nice if it were a "sticky" someplace since many would like to have this feature as a standard package. Until then, it's a hack unsupported except here.

Thanks for doing this and documenting so clearly.

I have hacked my Fireboard so much I am a little scared of doing more, particularly as I have no PHP skill and it will send out emails to hundreds of user

BUT... I was wondering if someone had tried another approach.

There is already a feature to send emails to Moderators. In my case I wonder if someone has worked out a way to hack that part of the code to also send an email to all registered users (excluding moderators) BUT only when a new thread is started.

If I can get this to work then each new thread becomes an 'All Points Broadcast' on my forum (which is what I want). If someone replies then they are automatically interested and given the option to subscribe.

PS:
I my case users would reply by email. And this is the point of the mod. suggested above for me, because my community communicate by email and don't tend to log in. If I can get all posts emailed, I already have a way to get their reply emails posted, I will have closed the loop.

that is an interesting comment on your user community wanting to do everything by email. I call that a "reflector" feature where the forum becomes a repository of all the responses by email.

That is simular to the Yahoo group mail but Yahoo collects it all in one thread for web historical display..... blaa blaa

My user community has migrated from Yahoo except for this "reflector" feature. What you describe should be included as a basic feature. Although not all hosting services support the increased email volumes ... and have tiered costs for distinct email volumes. Not everyone is going to want this type of feature turned on. My community would!

Glad to hear someone else has this need too!

There are discussions of someone using the moderator process to do something via a mailman list.

However here's a suggestion (completely untested and off the cuff...)

Post.php has this edit on line 294:

Code:

$database->setQuery("SELECT DISTINCT * FROM #__fb_subscriptions AS a" . " \n LEFT JOIN #__users as u ON a.userid=u.id" . " \n WHERE a.thread= '$querythread' OR a.category='$catid'"«»);

If you were to insert this code BEFORE that edit you'd be checking if the post was a new topic or a reply to an existing topic.

Code:

$database->setQuery("SELECT * FROM #__fb_messages" . " \n WHERE thread= '$querythread'; $database->query(); $num_posts = $database->getAffectedRows(); //if $num_posts is > 1 then this is not a new post so we should only send email to people who subscribed to the thread. So make catid something it can't be like " " if ($num_posts > 1) { $catid = " "; //not that is a space not a NULL field. NULL will return lots! }