diff options
author | Erich Eckner <git@eckner.net> | 2022-07-28 11:19:17 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2022-07-28 11:19:17 +0200 |
commit | 76c7c036938be3cb6f90396de51958a90e8bf8b0 (patch) | |
tree | 69cbb8a7c303a6bc9fd6fd40d049f2c234324ab4 /html/maintenance.php | |
parent | b68c32227484822f4d213683ef5602328bc17449 (diff) | |
download | colocation-76c7c036938be3cb6f90396de51958a90e8bf8b0.tar.xz |
insert lo-keys by ids
Diffstat (limited to 'html/maintenance.php')
-rw-r--r-- | html/maintenance.php | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/html/maintenance.php b/html/maintenance.php index 338695e..c7f608f 100644 --- a/html/maintenance.php +++ b/html/maintenance.php @@ -66,9 +66,12 @@ if (array_key_exists('lights_out_machines', $_GET)) { 'SELECT machines.name AS machine FROM machines' . ' WHERE machines.name LIKE ' . "'" . '%-lo' . "'" ); + $power_id = $db -> get_state_id('power'); + $ping_id = $db -> get_state_id('ping'); while ($row = $result -> fetchArray()) { - $db -> add_key_for(substr($row['machine'],0,-3), 'power', 'lights-out'); - $db -> add_key_for(substr($row['machine'],0,-3), 'ping', 'lights-out'); + $machine_id = $db -> get_machine_id(substr($row['machine'],0,-3)); + $db -> add_key_for($machine_id, $power_id, 'lights-out'); + $db -> add_key_for($machine_id, $ping_id, 'lights-out'); } echo 'done.' . "\n"; die(); |