private function addUserToPhpbb($forum_group_id = 0, $user_id = 0)
{
// Initial checks
if (!$forum_group_id > 0 || !$user_id > 0) {
return false;
}
// Setup the phpBB-class
$phpbb_class = JPATH_ADMINISTRATOR . '/components/com_ssrrn_msc/phpbb/phpbb.php';
if (!file_exists($phpbb_class)) {
return false;
}
require_once $phpbb_class;
$phpbb = new phpbb();
// Fetch the right php_bbuser_id from JFusion
$query = 'SELECT `userid` FROM `#__jfusion_users_plugin` WHERE `id`="' . (int) $user_id . '" AND `jname`="phpbb3"';
$db = JFactory::getDBO();
$db->setQuery($query);
$forum_user_id = $db->loadResult();
// Connect to phpBB
$check = $phpbb->connect_phpbb();
if ($check == '0') {
return false;
}
// If we are connected and we have proper IDs
if ($forum_user_id > 0 && $forum_group_id > 0) {
try {
$query = 'SELECT * FROM `#__user_group` WHERE `group_id`="' . $forum_group_id . '" AND `user_id`="' . $forum_user_id . '"';
$phpbb->setQuery($query);
$result = $phpbb->loadObjectList();
} catch (Exception $e) {
}
if (empty($result)) {
try {
$query = 'INSERT INTO `#__user_group` SET `group_id`="' . $forum_group_id . '", `user_id`="' . $forum_user_id . '",
`user_pending`="0"';
$phpbb->setQuery($query);
$phpbb->query();
} catch (Exception $e) {
}
}
}
}
