файл phalanx.php
существующий код
Код: Выделить всё
$fq = doquery("SELECT * FROM {{table}} WHERE
( fleet_start_galaxy='" . $g . "' AND fleet_start_system='" . $s . "' AND fleet_start_planet='" . $i . "' AND fleet_start_type = 1)
OR
( fleet_end_galaxy='" . $g . "' AND fleet_end_system='" . $s . "' AND fleet_end_planet='" . $i . "' AND fleet_start_type = 1)
ORDER BY `fleet_start_time`", 'fleets');
Код: Выделить всё
$fq = doquery("SELECT * FROM {{table}} WHERE
( fleet_start_galaxy='" . $g . "' AND fleet_start_system='" . $s . "' AND fleet_start_planet='" . $i . "' AND fleet_start_type = 1 and fleet_mission !=0 )
OR
( fleet_end_galaxy='" . $g . "' AND fleet_end_system='" . $s . "' AND fleet_end_planet='" . $i . "' AND fleet_start_type = 1 and fleet_mission !=0 )
ORDER BY `fleet_start_time`", 'fleets');