function clan_list_members($clan_id, $personage_id = 0, $online_only = false, $add = "") {
  global $theme, $container;

  if (!$clan_id && !$personage_id) return false;

  $list = array();

  $sql = "SELECT CM.*, P.LOGIN AS PERSONAGE, P.ONLINE AS ONLINE
    FROM ".clan_table_members()." CM
      LEFT JOIN ".personage_table()." P ON P.ID=CM.PERSONAGE_ID
    WHERE 1";
  if ($clan_id > 0) $sql .= " AND CM.CLAN_ID=".$clan_id;
  if ($personage_id > 0) $sql .= " AND CM.PERSONAGE_ID=".$personage_id;
  if ($online_only) $sql .= " AND P.ONLINE=1";

  if (!($result = $container->execSQL($sql.$add))) {
    throw($theme->getSQLError(clan_table_members(), $container->error(), $sql.$add, __FILE__, __LINE__));
    return false;
  }

  while ($row = mysql_fetch_array($result)) $list[] = $row;
  mysql_free_result($result);

  return $list;
}

WHERE 1";