prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $qstr = "SELECT extension, ep_pass, vm_pin, cid_num, cid_name, features, "; $qstr .= "cust_id FROM cust_ext AS c LEFT JOIN svc_package AS s "; $qstr .= "ON c.pkg_id=s.id WHERE c.id=$cust_ext_id"; $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $qstr = "SELECT p.sip_address as p_sip_addr FROM cust_pbx AS c LEFT JOIN pbx_server AS p "; $qstr .= "ON p.id=c.pri_pbx_id WHERE c.cust_id=$cust_id"; $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $qstr = "SELECT p.sip_address as s_sip_addr FROM cust_pbx AS c LEFT JOIN pbx_server AS p "; $qstr .= "ON p.id=c.sec_pbx_id WHERE c.cust_id=$cust_id"; $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else { $s_sip_addr = 'etw-pbx-sip2.websprix.com'; } $ext = $cust_id."S$extension"; $xml = << $mac EOF; $xml .= "\t1\n"; $xml .= "\t$extension\n"; $xml .= "\t$p_sip_addr\n"; $xml .= "\t$s_sip_addr\n"; $xml .= "\t$ext\n"; $xml .= "\t$ext\n"; $xml .= "\t$ep_pass\n"; $xml .= "\t$cid_name\n"; $xml .= " \n"; $xml .= ""; return $xml; } function cisco_provision($mac){ global $dbhr; $nmac = strtolower($mac); $qstr = "SELECT cust_ext_id, device_id, model_id, brand, "; $qstr .= "model, firmware FROM ext_device AS e "; $qstr .= "LEFT JOIN device AS d ON e.device_id=d.id "; $qstr .= "LEFT JOIN dev_model AS m ON m.id=d.model_id "; $qstr .= "WHERE mac='$nmac'"; $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $qstr = "SELECT extension, ep_pass, vm_pin, cid_num, cid_name, features, "; $qstr .= "cust_id FROM cust_ext AS c LEFT JOIN svc_package AS s "; $qstr .= "ON c.pkg_id=s.id WHERE c.id=$cust_ext_id"; $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $ext = $cust_id."S$extension"; $xml = << admin ^nDr0id1x D/M/YA Central Standard/Daylight Time us.ntp.org Unicast true etw-pbx-sip1.websprix.com 5060 etw-pbx-sip2.websprix.com 5060 EOF; $xml .= "\t9\n"; $xml .= "\tDISPLAYED ON SCREEN\n"; $xml .= "\tetw-pbx-sip1.websprix.com\n"; $xml .= "\t5060\n"; $xml .= "\t$cid_name\n"; $xml .= "\t$cid_name\n"; $xml .= "\t3\n"; $xml .= "\t$ext\n"; $xml .= "\t$ep_pass\n"; $xml .= "\t1\n"; $xml .= "\t$ext\n"; $xml .= " \n"; $xml .= " \n"; $xml .= " \n"; $xml .= "\tSIP\n"; $xml .= "\tSIP75.9-2-1S\n"; $xml .= " \n"; return $xml; } function avaya_provision($mac){ global $dbhr; $nmac = strtolower($mac); $qstr = "SELECT cust_ext_id, device_id, model_id, brand, "; $qstr .= "model, firmware FROM ext_device AS e "; $qstr .= "LEFT JOIN device AS d ON e.device_id=d.id "; $qstr .= "LEFT JOIN dev_model AS m ON m.id=d.model_id "; $qstr .= "WHERE mac='$nmac'"; file_put_contents('/var/www/pbx/log/xapi.log', "qstr : $qstr", FILE_APPEND); $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $qstr = "SELECT extension, ep_pass, vm_pin, cid_num, cid_name, features, "; $qstr .= "cust_id FROM cust_ext AS c LEFT JOIN svc_package AS s "; $qstr .= "ON c.pkg_id=s.id WHERE c.id=$cust_ext_id"; $stmt = $dbhr->prepare($qstr); $stmt->execute(); if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { extract($row); } else return false; $ext = $cust_id."S$extension"; $xml = << UTC true 1 false 1 0 0 1 1 0 0 1 udp false false EOF; $xml .= "\t$cid_name\n"; $xml .= "\t$ext\n"; $xml .= "\tetw-pbx-sip1.websprix.com\n"; $xml .= "\t\n"; $xml .= "\ttrue\n"; $xml .= "\t\n"; $xml .= "\tDigest\n"; $xml .= "\t$ext\n"; $xml .= "\t$ep_pass\n"; $xml .= "\t\n"; $xml .= "\t300\n"; $xml .= "\t\n"; $xml .= "\t\n"; $xml .= "\t\n"; return $xml; } ?>