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

tbrehm

2012-01-23 a8afe37a39a9d8ac1c1432ba5dd77fc866f8941b

 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;