Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
Subscribe to forum instead of thread (1 viewing) (1) Guest
Go to bottom Favoured: 13
TOPIC: Subscribe to forum instead of thread
#38684
Re:Subscribe to forum instead of thread 9 Months ago  
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.
grumblemarc (User)
Platinum Boarder
Posts: 3557
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
#39069
Re:Subscribe to forum instead of thread 9 Months ago  
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]
freakshowtm (User)
FB Quality & Testing Team
I am a LOSER
Senior Boarder
Posts: 139
graphgraph
User Offline Click here to see the profile of this user
Gender: Male nluvandhate Location: Philippines Birthdate: 1983-11-07
Logged Logged
 
Last Edit: 2008/01/14 15:10 By freakshowtm.
 
..having a Brain doesn\'t mean you know how to use one..
 
The administrator has disabled public write access.  
#39072
Re:Subscribe to forum instead of thread 9 Months ago  
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 (User)
Junior Boarder
Posts: 65
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#39075
Re:Subscribe to forum instead of thread 9 Months ago  
@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..
freakshowtm (User)
FB Quality & Testing Team
I am a LOSER
Senior Boarder
Posts: 139
graphgraph
User Offline Click here to see the profile of this user
Gender: Male nluvandhate Location: Philippines Birthdate: 1983-11-07
Logged Logged
 
..having a Brain doesn\'t mean you know how to use one..
 
The administrator has disabled public write access.  
#39077
Re:Subscribe to forum instead of thread 9 Months ago  
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..
freakshowtm (User)
FB Quality & Testing Team
I am a LOSER
Senior Boarder
Posts: 139
graphgraph
User Offline Click here to see the profile of this user
Gender: Male nluvandhate Location: Philippines Birthdate: 1983-11-07
Logged Logged
 
Last Edit: 2008/01/14 16:58 By freakshowtm.
 
..having a Brain doesn\'t mean you know how to use one..
 
The administrator has disabled public write access.  
#39078
Re:Subscribe to forum instead of thread 9 Months ago  
Hi freakshowtm

Sounds like just what I'm needing

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

Thanks
DoughBoy (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#39079
Re:Subscribe to forum instead of thread 9 Months ago  
What's the issue with the category codes?
polc1410 (User)
Junior Boarder
Posts: 65
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#39178
Re:Subscribe to forum instead of thread 9 Months ago  
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..
freakshowtm (User)
FB Quality & Testing Team
I am a LOSER
Senior Boarder
Posts: 139
graphgraph
User Offline Click here to see the profile of this user
Gender: Male nluvandhate Location: Philippines Birthdate: 1983-11-07
Logged Logged
 
..having a Brain doesn\'t mean you know how to use one..
 
The administrator has disabled public write access.  
#39182
Re:Subscribe to forum instead of thread 9 Months ago  
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..
File Attachment:
File Name: mod_fb_autosubscribe.zip
File Size: 2509
freakshowtm (User)
FB Quality & Testing Team
I am a LOSER
Senior Boarder
Posts: 139
graphgraph
User Offline Click here to see the profile of this user
Gender: Male nluvandhate Location: Philippines Birthdate: 1983-11-07
Logged Logged
 
..having a Brain doesn\'t mean you know how to use one..
 
The administrator has disabled public write access.  
#39185
Re:Subscribe to forum instead of thread 9 Months ago  
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 ....
cyke (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2008/01/15 13:31 By cyke.
 
The administrator has disabled public write access.  
Go to top