Example #1
0
 public function getPrim($id, $fields)
 {
     $prim = $this->db->fetchRow("SELECT * FROM prims,primshapes WHERE prims.UUID=primshapes.UUID AND prims.UUID='{$id}' LIMIT 1");
     if (!$fields) {
         return $prim;
     }
     $results = array();
     // always returned
     $results['UUID'] = $prim['UUID'];
     foreach (explode(',', $fields) as $field) {
         if (array_key_exists($field, $prim)) {
             $results[$field] = $prim[$field];
         }
     }
     return $results;
 }
Example #2
0
 public function edit($id, $firstName, $lastName, $email, $userLevel)
 {
     $user = $this->db->fetchRow("SELECT UUID FROM auth,useraccounts WHERE UUID=PrincipalID AND UUID='{$id}'");
     if (!$user) {
         return false;
     }
     $this->db->update('useraccounts', array('FirstName' => $firstName, 'LastName' => $lastName, 'Email' => $email, 'UserLevel' => $userLevel), "PrincipalID=\"{$id}\"");
     return true;
 }
 public function getRegion($id, $fields)
 {
     $region = $this->db->fetchRow("SELECT * FROM regions,regionsettings WHERE uuid=regionUUID AND uuid='{$id}' LIMIT 1");
     if (!$region) {
         return null;
     }
     if (!$fields) {
         return $region;
     }
     $results = array('UUID' => $region['uuid']);
     // always returned
     foreach (explode(',', $fields) as $field) {
         if (array_key_exists($field, $region)) {
             $results[$field] = $region[$field];
         }
     }
     return $results;
 }