static function updateUser($userid, $user) { if (get_class($user) != "User") { return "Error, received object other than User"; } $dbUser = apiDB::getUser($userid); if (empty($dbUser->id)) { return "Error, Invalid User ID for Update"; } $updatestring = "set "; $updatestring .= "email = " . (empty($user->email) ? "email" : "'" . $user->email . "'") . ", "; $updatestring .= "password = "******"password" : "'" . $user->password . "'") . ", "; $updatestring .= "firstname = " . (empty($user->firstname) ? "firstname" : "'" . $user->firstname . "'") . ", "; $updatestring .= "lastname = " . (empty($user->lastname) ? "lastname" : "'" . $user->lastname . "'") . ", "; $updatestring .= "postal = " . (empty($user->postal) ? "postal" : "'" . $user->postal . "'") . ", "; $updatestring .= "phone = " . (empty($user->phone) ? "phone" : "'" . $user->phone . "'") . ", "; $updatestring .= "verified = " . (empty($user->verified) ? "verified" : $user->verified) . ", "; $updatestring .= "sub_summary = " . (isset($user->sub_summary) ? $user->sub_summary : "sub_summary") . ", "; $updatestring .= "sub_gwadi = " . (isset($user->sub_gwadi) ? $user->sub_gwadi : "sub_gwadi") . ", "; $updatestring .= "sub_stats = " . (isset($user->sub_stats) ? $user->sub_stats : "sub_stats") . ", "; $updatestring .= "access = " . (empty($user->access) ? "access" : $user->access); $conxn = apiDB::getConnection(); $sql = "UPDATE cw_user " . $updatestring . " WHERE id = " . $userid; $result = pg_query($conxn, $sql); if ($result) { $rows = pg_affected_rows($result); return $rows . " User(s) updated"; } else { return "Error with User update query : " . pg_last_error($conxn); } }
static function updateUser($userid, $user) { if (get_class($user) != "User") { return "Error, received object other than User"; } $dbUser = apiDB::getUser($userid); if (empty($dbUser->id)) { return "Error, Invalid User ID for Update"; } $updatestring = "set "; $updatestring .= "email = " . (empty($user->email) ? "email" : "'" . $user->email . "'"); $updatestring .= ", "; $updatestring .= "password = "******"password" : "'" . $user->password . "'"); $conxn = apiDB::getConnection(); $sql = "UPDATE cw_user " . $updatestring . " WHERE id = " . $userid; $result = pg_query($conxn, $sql); if ($result) { $rows = pg_affected_rows($result); return $rows . " User(s) updated"; } else { return "Error with User update query : " . pg_last_error($conxn); } }
public function getInstanceDetails($id) { $user = apiDB::getUser($id, 2); if (empty($user->id)) { return self::NO_SUCH_ID; } if ($_SERVER['PHP_AUTH_USER'] != $user->email && $this->access <= 1) { return self::ACCESS_DENIED; } $this->id = $user->id; $this->email = $user->email; $this->password = $user->password; $this->locations = $user->locations; // Does this array need cloning? // Preserving $this->access however, to retain admin rights. return self::SETUP_OK; }
public function getInstanceDetails($id) { $location = empty($this->userid) ? apiDB::getLocation($id) : apiDB::getUserLocation($id, $this->userid); if (empty($location->id)) { return self::NO_SUCH_ID; } $user = apiDB::getUser($location->userid); if ($_SERVER['PHP_AUTH_USER'] != $user->email && $this->access <= 1) { return self::ACCESS_DENIED; } $this->latitude = $location->latitude; $this->longitude = $location->longitude; $this->name = $location->name; $this->userid = $location->userid; $this->id = $location->id; $this->rain = $location->rain; $this->mintemp = $location->mintemp; // Preserving $this->access however, to retain admin rights. return self::SETUP_OK; }