Changed command order in client_add function so that the insertID is execut...

tbrehm

2012-01-23 a8afe37a39a9d8ac1c1432ba5dd77fc866f8941b

Changed command order in client_add function so that the insertID is executed right after the sql insert query.

 interface/lib/classes/remoting.inc.php

@@ -2156,20 +2156,29 @@
        
        //* Get the SQL query
        $sql = $app->remoting_lib->getSQL($params,'INSERT',0);
        $app->db->query($sql);
        
        //* Check if no system user with that username exists
        $username = $app->db->quote($params["username"]);
        $tmp = $app->db->queryOneRecord("SELECT count(userid) as number FROm sys_user WHERE username = '$username'");
        $tmp = $app->db->queryOneRecord("SELECT count(userid) as number FROM sys_user WHERE username = '$username'");
        if($tmp['number'] > 0) $app->remoting_lib->errorMessage .= "Duplicate username<br />";
        
        //* Stop on error while preparing the sql query
        if($app->remoting_lib->errorMessage != '') {
            $this->server->fault('data_processing_error', $app->remoting_lib->errorMessage);
            return false;
        }
        
        //* Execute the SQL query
        $app->db->query($sql);
        $insert_id = $app->db->insertID();
        
		
        //* Stop on error while executing the sql query
        if($app->remoting_lib->errorMessage != '') {
            $this->server->fault('data_processing_error', $app->remoting_lib->errorMessage);
            return false;
        }
		
        $this->id = $insert_id;
        $this->dataRecord = $params;