I am running Fireboard 1.04 with Community Builder. I recently changed the configuration of Fireboard (security):
- Email Moderators: No
- Email Administrators: Yes

With this configuration new posts were sent to every user which opted to receive moderator emails (field sendEmail=1 in table jos_users) and not only the administrators!

I quickly turned off the Email Administrator option and analyzed the code.

The following code change is needed to fix this issue:
Filename: post.php (components/com_fireboard/template/default)
Lines: 350 ff

Old code:

Code:

if($fbConfig['mailadmin']==1) { if(strlen($sql2)) { $sql2 .= "\n OR "; } $sql2 .= " u.sendEmail=1"; }

New code:

Code:

if($fbConfig['mailadmin']==1) { if(strlen($sql2)) { $sql2 .= "\n OR "; } $sql2 .= " u.gid >= 24 AND u.sendEmail=1"; }

This solved my issue

Stephan

Thanks for this!!!

ALL my users are also getting moderator emails.

Could you please tell me what this 'u.gid >= 24 AND' is doing?

-Tom

Every user in Joomla belongs to a specifc group; this is specified in the table jos_users. The available groups are defined in the table jos_core_acl_aro_groups:

A default Joomla 1.5 installation always contains the groups (extract from the table):

Code:

| id | parent_id | name | lft | rgt | value | | 24 | 23 | Administrator | 15 | 18 | Administrator | | 25 | 24 | Super Administrator | 16 | 17 | Super Administrator |

So the u.gid >=24 is referring to all users which belong to the group with an ID of 24 or higher, which in standard cases would be the Administrators and the Super Administrators.

Stephan