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) { } } } }