solved!
version:
fireboard 1.0.4
file:
administrator/components/com_fireboard/admin.fireboard.php
line:
382
| Code: |
$database->setQuery("SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup"
. "nFROM #__fb_categories AS a"
. "nLEFT JOIN #__users AS u ON u.id = a.checked_out"
. "nLEFT JOIN #__core_acl_aro_groups AS g ON g.".((FBTools::isJoomla15())?"":"group_")."id = a.pub_access"
. "nLEFT JOIN #__core_acl_aro_groups AS h ON h.".((FBTools::isJoomla15())?"":"group_")."id = a.admin_access"
. "n GROUP BY a.id"
. "n ORDER BY a.ordering, a.name");
|
change to
| Code: |
if( defined('_JEXEC') ){
//joomla 1.5
$group_id_col_name = 'id';
}else{
//joomla 1.0.x
$group_id_col_name = 'group_id';
}
$database->setQuery("SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup"
. "nFROM #__fb_categories AS a"
. "nLEFT JOIN #__users AS u ON u.id = a.checked_out"
. "nLEFT JOIN #__core_acl_aro_groups AS g ON g.$group_id_col_name = a.pub_access"
. "nLEFT JOIN #__core_acl_aro_groups AS h ON h.$group_id_col_name = a.admin_access"
. "n GROUP BY a.id"
. "n ORDER BY a.ordering, a.name");
|
works on both joomla 1.0.15 and 1.5 !
problem is in this code:
| Code: |
((FBTools::isJoomla15())?"":"group_")
|
which is suppose to return '' for joomla 1.5.x and 'group_' for joomla 1.0.x (because they reamed that column), but somehow does not. the above code does the same, but works.
open source rulez!
@fireboard team:
please include this code in your next release.
Favoured: 0
