| Conditions | 1 |
| Paths | 1 |
| Total Lines | 10 |
| Code Lines | 8 |
| Lines | 0 |
| Ratio | 0 % |
| Tests | 0 |
| CRAP Score | 2 |
| Changes | 0 | ||
| 1 | <?php |
||
| 18 | public static function dbFleetsOnHoldOnPlanetsByIds($planetIds, $time = SN_TIME_NOW) { |
||
| 19 | return SN::$db->doquery( |
||
|
|
|||
| 20 | "SELECT `{{fleets}}`.* |
||
| 21 | FROM `{{fleets}}` |
||
| 22 | LEFT JOIN `{{users}}` ON id = fleet_owner |
||
| 23 | WHERE |
||
| 24 | fleet_end_planet_id IN (" . implode(',', $planetIds) . ") |
||
| 25 | AND fleet_mess = 0 |
||
| 26 | AND fleet_start_time <= " . $time . " |
||
| 27 | AND fleet_end_stay >= " . $time . " |
||
| 28 | FOR UPDATE" |
||
| 32 | } |