public static function GetAlliancesOtherThanMineWithFleets($myAllianceId)
{
if (!is_int($myAllianceId)) {
throw new Exception("myAllianceId was not an int.");
}
$conn = DataManager::GetInstance()->GetConnection();
$stmt = $conn->prepare('SELECT id, name FROM alliance WHERE id in (SELECT allianceId FROM fleet WHERE added > ?) AND id != ?');
$stmt->bind_param('si', DataManager::GetInstance()->FormatTimestampForSql(LastDowntimeMidpoint()), $myAllianceId);
$stmt->execute();
$stmt->bind_result($id, $name);
$alliances = array();
while ($stmt->fetch()) {
$a = new Alliance();
Alliance::fill($a, $id, $name);
$alliances[] = $a;
}
$stmt->close();
return $alliances;
}
