+
+ $aliases = array();
+
+ // Terminate early on missing param.
+ if (!( $alias_username && $alias_domain)) return $aliases;
+
+ $query = sprintf("SELECT CONCAT(username, '@', domain ) AS destination, CONCAT( alias_username, '@', alias_domain) AS alias FROM %s"
+ . " WHERE alias_username = '%s' AND alias_domain = '%s'",
+ $config['kamailio_alias_table'],
+ sql_clean($alias_username),
+ sql_clean($alias_domain)
+ );
+
+ $result = sql_dbquery( $config['kamailio_db'], $query);
+ // If result is empty, there was either an SQL error, or simply no results.
+ // At this point, no error checking is performed, instead the empty array is returned.
+ if ( ! $result ) return $aliases;
+
+ while ( $row = mysql_fetch_assoc( $result ) )
+ {
+ array_push( $aliases, array( 'destination' => $row['destination'], 'alias' => $row['alias'] ) );
+ }
+ return $aliases;