X-Git-Url: https://git.defcon.no/?a=blobdiff_plain;f=api%2Flib%2Fdomain_functions.php;fp=api%2Flib%2Fdomain_functions.php;h=d28c0be45b69bbff3f491f4f0f17ffe9c9211902;hb=ff9f68b23637a5393ad2d349f4c052e8be084f85;hp=0000000000000000000000000000000000000000;hpb=0b40f80e4a3fbacf817b622bbcea4d2009610bae;p=hermes

diff --git a/api/lib/domain_functions.php b/api/lib/domain_functions.php
new file mode 100644
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;
+}
+?>