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