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