CAllGroup::GetByID

static function GetByID($ID, $SHOW_USERS_AMOUNT = "N")
{
	global $DB;

	$err_mess = (static::err_mess())."
Function: GetList
Line: ";
	$ID = intval($ID);

	$strSql = "SELECT G.ID, G.ACTIVE, G.C_SORT, G.ANONYMOUS, G.NAME, G.STRING_ID, G.DESCRIPTION, ".$DB->DateToCharFunction("G.TIMESTAMP_X")." as TIMESTAMP_X ";

	if ($SHOW_USERS_AMOUNT == "Y")
		$strSql .= ", count(distinct U.USER_ID) USERS ";
	else
		$strSql .= ", G.SECURITY_POLICY ";

	$strSql .= "FROM b_group G ";

	if ($SHOW_USERS_AMOUNT == "Y")
		$strSql .= "LEFT JOIN b_user_group U ON (U.GROUP_ID=G.ID AND ((U.DATE_ACTIVE_FROM IS NULL) OR (U.DATE_ACTIVE_FROM <= ".$DB->CurrentTimeFunction().")) AND ((U.DATE_ACTIVE_TO IS NULL) OR (U.DATE_ACTIVE_TO >= ".$DB->CurrentTimeFunction()."))) ";

	$strSql .= "WHERE G.ID = ".$ID." ";

	if ($SHOW_USERS_AMOUNT == "Y")
		$strSql .= "GROUP BY G.ID, G.ACTIVE, G.C_SORT, G.TIMESTAMP_X, G.ANONYMOUS, G.NAME, G.STRING_ID, G.DESCRIPTION";

	$z = $DB->Query($strSql, false, $err_mess.__LINE__);
	return $z;
}