#!/bin/bash
mysql phpnuxbill -e "DESCRIBE tbl_routers;"
mysql phpnuxbill -e "SELECT id,name,ip_address,enabled FROM tbl_routers;"
# insert only if missing
mysql phpnuxbill -e "
INSERT INTO tbl_routers (name, ip_address, username, password, description, enabled, status)
SELECT 'Woyla-hAP', '192.168.88.1', 'admin', '', 'hAP lite office gateway - do not hotspot the 192.168.88.0/24 LAN', 1, 'Online'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM tbl_routers WHERE ip_address='192.168.88.1');
SELECT id,name,ip_address,username,enabled FROM tbl_routers;
"