Added domain/list, domain/get_server, domain/set_servers, updated sample SQL data...

[hermes] / api / lib / domain_functions.php

diff --git a/api/lib/domain_functions.php b/api/lib/domain_functions.php
new file mode 100644 (file)
index 0000000..d28c0be
--- /dev/null
+++ b/api/lib/domain_functions.php
@@ -0,0 +1,61 @@
+<?php
+require_once('config.php');
+require_once('lib/common_functions.php');
+require_once('lib/db_functions.php');
+
+function get_domains()
+{
+       global $config;
+       $query = sprintf("SELECT domain FROM %s",
+               $config['kamailio_domain_table']);
+
+       $result = sql_dbquery( $config['kamailio_db'], $query);
+       if ( ! $result ) return -1;
+
+       $domains = array();
+       while ( $row = mysql_fetch_row($result) ) { array_push($domains, $row[0]); }
+       return $domains;
+}
+
+function set_servers ( $domain, $registrar, $r_port, $proxy, $p_port, $prov_url )
+{
+       global $config;
+
+       $query = "";
+
+       $prev_servers = get_servers( $domain );
+       if ( $prev_servers )
+       {
+               $query = sprintf("UPDATE %s SET 
+                               registrar = '%s', r_port = %d,
+                               proxy = '%s', p_port = %d,
+                               prov_url = '%s'
+                               WHERE domain = '%s'",
+                       $config['provision_servers_table'],
+                       sql_clean($registrar),
+                       $r_port,
+                       sql_clean($proxy),
+                       $p_port,
+                       sql_clean($prov_url),
+                       sql_clean($domain)
+               );
+       }
+       else
+       {
+               $query = sprintf("INSERT INTO %s 
+                               (domain, registrar, r_port, proxy, p_port, prov_url)
+                               VALUES ('%s', '%s', %d, '%s', %d, '%s')",
+                       $config['provision_servers_table'],
+                       sql_clean($domain),
+                       sql_clean($registrar),
+                       $r_port,
+                       sql_clean($proxy),
+                       $p_port,
+                       sql_clean($prov_url)
+               );
+
+       }
+       return sql_dbexec( $config['provision_db'], $query );
+       return false;
+}
+?>