public static function getGroupChildId($gid) { $db = JFactory::getDBO(); //CFactory::load( 'libraries' , 'activities' ); $sql = "SELECT\n\t\t\t\t\t\t" . $db->quoteName("id") . "\n\t\t\t\tFROM\n\t\t\t\t\t\t" . $db->quoteName("#__community_groups_discuss") . "\n\t\t\t\tWHERE\n\t\t\t\t\t\t" . $db->quoteName("groupid") . " = " . $db->Quote($gid); $db->setQuery($sql); $row = $db->loadobjectList(); if ($db->getErrorNum()) { JError::raiseError(500, $db->stderr()); } $sql = "SELECT\n\t\t\t\t\t\t" . $db->quoteName("id") . "\n\t\t\t\tFROM\n\t\t\t\t\t\t" . $db->quoteName("#__community_groups_bulletins") . "\n\t\t\t\tWHERE\n\t\t\t\t\t\t" . $db->quoteName("groupid") . " = " . $db->Quote($gid); $db->setQuery($sql); $bulletin = $db->loadobjectList(); if ($db->getErrorNum()) { JError::raiseError(500, $db->stderr()); } $sql = "SELECT\n\t\t\t\t\t\t" . $db->quoteName("id") . "\n\t\t\t\tFROM\n\t\t\t\t\t\t" . $db->quoteName("#__community_wall") . "\n\t\t\t\tWHERE\n\t\t\t\t\t\t" . $db->quoteName("contentid") . " = " . $db->Quote($gid); $db->setQuery($sql); $wall = $db->loadobjectList(); if ($db->getErrorNum()) { JError::raiseError(500, $db->stderr()); } $row = array_merge($row, array_merge($bulletin, $wall)); if (!empty($row)) { $ids_array = array(); foreach ($row as $tempid) { array_push($ids_array, $tempid->id); } $ids = implode(',', $ids_array); $ids .= ',' . $gid; //Remove All groupActivity stream CActivityStream::removeGroup($ids); } }