#!/usr/bin/env python3
import re, subprocess
t = open("/var/www/wifi-otantik/config.php").read()

def g(k):
    m = re.search(r"\$" + k + r"\s*=\s*['\"]([^'\"]+)", t)
    return m.group(1) if m else ""

host = g("db_host") or "localhost"
user = g("db_user")
pw = g("db_pass")
name = g("db_name")
sql = "UPDATE tbl_otantik_peers SET status='completed', last_seen=NOW() WHERE router_id=13"
r = subprocess.run(["mysql","-h",host,"-u",user,f"-p{pw}",name,"-e",sql], capture_output=True, text=True)
print("ok" if r.returncode==0 else r.stderr.replace(pw,"***"))
r2 = subprocess.run(["mysql","-h",host,"-u",user,f"-p{pw}",name,"-N","-e","SELECT id,name,slug,ip_address FROM tbl_routers WHERE id=13; SELECT name_plan,type,price FROM tbl_plans WHERE routers='Otantik_Hub_Nkoabang'"], capture_output=True, text=True)
print(r2.stdout)