]>
git.defcon.no Git - hermes/blob - api/lib/domain_functions.php
974a97c0c7a8bffbbb9f8fac73f9ccc8ce016656
3 # Copyright (c) 2012, Gjøvik University College
6 # Redistribution and use in source and binary forms, with or without
7 # modification, are permitted provided that the following conditions are met:
8 # * Redistributions of source code must retain the above copyright
9 # notice, this list of conditions and the following disclaimer.
10 # * Redistributions in binary form must reproduce the above copyright
11 # notice, this list of conditions and the following disclaimer in the
12 # documentation and/or other materials provided with the distribution.
13 # * Neither the name of the Gjøvik University College nor the
14 # names of its contributors may be used to endorse or promote products
15 # derived from this software without specific prior written permission.
17 # THIS SOFTWARE IS PROVIDED BY Gjøvik University College ''AS IS'' AND ANY
18 # EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
19 # WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
20 # DISCLAIMED. IN NO EVENT SHALL Gjøvik University College BE LIABLE FOR ANY
21 # DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
22 # (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
23 # LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
24 # ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
25 # (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
26 # SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
28 require_once('config.php');
29 require_once('lib/common_functions.php');
30 require_once('lib/db_functions.php');
32 function get_domains()
35 $query = sprintf("SELECT domain FROM %s",
36 $config['kamailio_domain_table']);
38 $result = sql_dbquery( $config['kamailio_db'], $query);
39 if ( ! $result ) return -1;
42 while ( $row = mysql_fetch_row($result) ) { array_push($domains, $row[0]); }
46 function set_servers ( $domain, $registrar, $r_port, $proxy, $p_port, $prov_url )
52 $prev_servers = get_servers( $domain );
55 $query = sprintf("UPDATE %s SET
56 registrar = '%s', r_port = %d,
57 proxy = '%s', p_port = %d,
60 $config['hermes_servers_table'],
61 sql_clean($registrar),
71 $query = sprintf("INSERT INTO %s
72 (domain, registrar, r_port, proxy, p_port, prov_url)
73 VALUES ('%s', '%s', %d, '%s', %d, '%s')",
74 $config['hermes_servers_table'],
76 sql_clean($registrar),
84 return sql_dbexec( $config['hermes_db'], $query );