psychicblast wrote:
grumblemarc wrote:
.4 was mainly a bugfix release and not a feature release. Possibly you would prefer many features and many more bugs?
This "Subscribe to Forum instead of Thread" feature was the one reason I installed FireBoard, and for some reason I was lead to believe that was a "standard feature".
-Psy

Who led you to that conclusion? Anyone at BOJ? Some forum member? I just re-read this entire thread and NOT ONCE did it say it would be included in the .4 release. The release notes ALSO made no mention of it. In fact I'm hard pressed to see WHERE you go the idea from.

Instead of pointing out all the flaws I like to ask where were you when the call went out for bug-testing and bug-reporting? I think if you stepped up to help the community out in that endeavor instead of FireBoard/BOJ bashing you would have known what was going on with the .4 upgrade and not made any assumptions. Anyone bother attempting to contact the provider of the original hack to see of it could be modified to work with .4?

And the last time I checked "moderator" was not a profession that I was aware of and I'm still entitled to voice my opinions. After all this is a public forum. I'm not a customer service rep and I don't read from a script.

i'm trying to hack fb to auto-subscribe new users to all categories in fb..

i managed to make it work in may localhost that uses mysql 5.0.17 but the live site uses 4.0.27-standard..

can anyone help me convert this code to work with mysql 4.0.27-standard?..

[code:1]SELECT user_id FROM #__comprofiler WHERE user_id NOT IN (SELECT userid FROM #__fb_autosubscribe)[/code:1]

OK this is untested but based on this
[code:1]
select po.id
from po left join pn
on po.id=pn.id
where pn.id is null
[/code:1]

from this site (http://ocaoimh.ie/2004/09/16/mysql-finding-the-records-in-one-table-that-are-not-in-another-table/ )

I'd try:

[code:1]
SELECT user_id
FROM #__comprofiler
LEFT JOIN #__fb_autosubscribe.userid = #__comprofiler.user_id
WHERE #__fb_autosubscribe.userid IS NULL[/code:1]

@polc1410
thanks for the quick reply..

i'll try to experiment with the code that you gave me..

if all goes well, i'll share the hack that i made to the community..

it's working now..

this is the code i used..

[code:1]SELECT user_id
FROM jos_comprofiler
LEFT JOIN jos_fb_autosubscribe ON jos_fb_autosubscribe.userid = jos_comprofiler.user_id
WHERE jos_fb_autosubscribe.userid IS NULL[/code:1]

thanks for the tip polc1410..

i'll share the hack soon..

the code needs some clean up..

also if anyone is interested in fb_auto-subscribe to category, i need someone to help me with the codes..;)

i'm not that great with php codes and xml..

Hi freakshowtm

Sounds like just what I'm needing

Can you please explain to a "newbie", how I go about trying this mod.

Thanks

What's the issue with the category codes?

i've made a module that is to be published in a secluded page of a site..

like the welcome page where a new user is redirected to when he first logs in..

i'm still cleaning up the codes..

i'll release it by the end of the week..

i also hacked the fireboard plugin for cb to incorporate the category subscriptions..

i have a problem when installing the module..

it doesn't create the table #__fb_autosubscribe..

here's the fb_autosubscribe module..

i need someone to test this and also look at the codes to make it work better..

especially in the xml file..

the query there that creates the #__fb_autosubscribe table doesn't work..

top work, but:

the CREATE query works if it looks like that:
[code:1]
CREATE TABLE IF NOT EXISTS `#__fb_autosubscribe` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`subscribe` int(11) NOT NULL,
PRIMARY KEY (`id`)
);
[/code:1]

you forgot the ALTER TABLE statement for the jos_fb_subscriptions table. the 'categories' column ....