[Freeswitch-svn] [commit] r12800 - freeswitch/trunk/scripts/contrib/swk/php/amfphp

[FreeSWITCH SVN]

Author: silik0n
Date: Thu Mar 26 18:06:23 2009
New Revision: 12800

Log:
fix some errors on generic DB handler

Modified:
   freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php

Modified: freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php
==============================================================================
--- freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php	(original)
+++ freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php	Thu Mar 26 18:06:23 2009
@@ -274,7 +274,8 @@
 
 	public function getDirDomainbyName($domain_name){
 		$query = sprintf("select * from domains where name = '%s'", $domain_name);
-		$stmt = $this->dbh->query($query);
+		$dbh = $this->getDbh();
+		$stmt = $dbh->query($query);
 		$results = $stmt->fetchAll();
 		return $results[0];
 	}
@@ -336,7 +337,8 @@
 	/* Directory User Methods */
 	public function getDirUsersByDomainUidByUsername($domain_uid, $user_name){
 		$query = sprintf("select * from users where domains_uid = '%s' and username = '%s'", $domain_uid, $user_name);
-		$stmt = $this->dbh->query($query);
+		$dbh = $this->getDbh();
+		$stmt = $dbh->query($query);
 		$results = $stmt->fetchAll();
 		return $results[0];
 	}
@@ -360,6 +362,13 @@
 		return $results;
 	}
 
+	public function addDirDomainUser($domains_uid, $username, $mailbox, $cidr, $enabled) {
+		$dbh = $this->getDbh();
+		$query = sprintf('insert into users (domains_uid, username, mailbox, cidr, enabled) values (%s, "%s", "%s", "%s", %s)', 
+							$domain_uid, $username, $mailbox, $cidr, $enabled);
+		return $dbh->exec($query);
+	}
+
 	public function addDirDomainUserParam($users_uid, $name, $value) {
 		$dbh = $this->getDbh();
 		$query = sprintf('insert into user_params (users_uid, name, value) values (%s, "%s", "%s")', $users_uid, $name, $value);
@@ -415,7 +424,8 @@
 
 	public function getDirGroupsByDomianUidByUserUid($domain_uid, $user_uid){
 		$query = sprintf("select a.uid as groupUid, a.name as groupName, b.uid as usersUid from groups as a, group_members as b where a.uid = b.groups_uid and b.domains_uid = %s and b.users_uid = %s", $domain_uid, $user_uid) ;
-		$stmt = $this->dbh->query($query);
+		$dbh = $this->getDbh();
+		$stmt = $dbh->query($query);
 		$results = $stmt->fetchAll();
 		return $results;
 	}