- fixed sql error

Changed files:
    lms-misc_mods.patch -> 1.2

diff --git a/lms-misc_mods.patch b/lms-misc_mods.patch
index 88f8af20e77dedfc5f5c89267c36e79a44111dc0..0b6fb0098f51bdc34d05d4c98ff399d35334822e 100644 (file)
--- a/lms-misc_mods.patch
+++ b/lms-misc_mods.patch
@@ -5,7 +5,7 @@
                # BUILD NODELIST
                
 -              $dbq = $dbase->prepare("SELECT ipaddr, mac, access, nodes.id as id, ownerid, nodes.name as name, warning, nodes.info AS info, pin FROM nodes, users WHERE users.id=nodes.ownerid");
-+              $dbq = $dbase->prepare("SELECT ipaddr, mac, access, nodes.id as id, ownerid, nodes.name as name, warning, nodes.info AS info, pin FROM nodes");
++              $dbq = $dbase->prepare("SELECT ipaddr, mac, access, nodes.id as id, ownerid, nodes.name as name, warning, nodes.info AS info, pin FROM nodes LEFT JOIN users ON users.id=nodes.ownerid");
                $dbq->execute();
  
                my %maclist;