adding provision URL as part of server-data in SQL

[hermes] / api / lib / common_functions.php

diff --git a/api/lib/common_functions.php b/api/lib/common_functions.php
index 52d99e8cd57cf0be6b9b5bb1884e8c4eb7d7d8d0..df76b57b8a6a67db62dcc0c702acbcef1971b164 100644 (file)
--- a/api/lib/common_functions.php
+++ b/api/lib/common_functions.php
@@ -22,7 +22,7 @@ function is_kamailio_domain ( $domain )
 function get_servers( $domain )
 {
        global $config;
-       $query = sprintf("SELECT registrar, r_port, proxy, p_port FROM %s WHERE domain = '%s'",
+       $query = sprintf("SELECT registrar, r_port, proxy, p_port, prov_url FROM %s WHERE domain = '%s'",
                $config['provision_servers_table'],
                sql_clean( $domain ));
        $servers = sql_dbquery_single( $config['provision_db'], $query );