Changed list node to provide more data. Added change_pw functionality/node. Changed...

[hermes] / lib / user_functions.php

diff --git a/lib/user_functions.php b/lib/user_functions.php
index 79445510bd58cb9e96410ffffad1146c42289b12..adad1be740cbc3c0b7472ee137c1d8768debb325 100644 (file)
--- a/lib/user_functions.php
+++ b/lib/user_functions.php
@@ -79,7 +79,26 @@ function delete_kamailio_subscriber( $username, $domain )
                sql_clean($username),
                sql_clean($domain)
        );
-       if ( ! sql_dbexec( $config['kamailio_db'], $query ) ) return false;
+       if ( sql_dbexec_rows( $config['kamailio_db'], $query) != 1 ) return false;
+       return true;
+}
+
+
+function update_kamailio_pw ( $username, $domain, $password )
+{
+       global $config;
+
+       if ( ! ($username && $domain && $password))
+               return false;
+
+       $query = sprintf("UPDATE %s SET password = '%s' WHERE username = '%s' AND domain = '%s'",
+               $config['kamailio_subscriber_table'],
+               sql_clean($password),
+               sql_clean($username),
+               sql_clean($domain)
+       
+       );
+       if ( sql_dbexec_rows( $config['kamailio_db'], $query) != 1 ) return false;
        return true;
 }
 
@@ -134,14 +153,32 @@ function delete_provision_user( $username, $domain )
                sql_clean($username),
                sql_clean($domain)
        );
-       if ( ! sql_dbexec( $config['provision_db'], $query ) ) return false;
+       if ( sql_dbexec_rows( $config['provision_db'], $query) != 1 ) return false;
+       return true;
+}
+
+function update_provision_pw ( $username, $domain, $password )
+{
+       global $config;
+
+       if ( ! ($username && $domain && $password))
+               return false;
+
+       $query = sprintf("UPDATE %s SET password = '%s' WHERE username = '%s' AND domain = '%s'",
+               $config['provision_users_table'],
+               sql_clean($password),
+               sql_clean($username),
+               sql_clean($domain)
+       
+       );
+       if ( sql_dbexec_rows( $config['provision_db'], $query) != 1 ) return false;
        return true;
 }
 
 function list_users ( $search = null )
 {
        global $config;
-       $query = sprintf("SELECT CONCAT(username, '@', domain) FROM %s ORDER BY username,domain", $config['provision_users_table'] );
+       $query = sprintf("SELECT CONCAT(username, '@', domain), displayname FROM %s ORDER BY username,domain", $config['provision_users_table'] );
 
        if ( array_key_exists ( 'search', $_GET ) )
        {
@@ -154,7 +191,7 @@ function list_users ( $search = null )
        $list = array();
        while ( $row = mysql_fetch_row( $result ) )
        {
-               array_push( $list, $row[0] );
+               array_push( $list, array( "user" => $row[0], "displayname" => $row[1] ) );
        }
        return $list;
        print json_encode( array( 'response' => 'ok', 'list' => $list ));