if ($_SERVER["REQUEST_METHOD"] == "POST") {
$valid_result = User::ValidateShortName($_POST["member_shortname"]);
if ($valid_result != null) {
$failure = true;
$failure_message = $valid_result;
} else {
if ($_POST["member_realname"] == null && $_POST["member_shortname"] == null && $_POST["member_longname"] == null && $_POST["member_birthdate"] == null && $_POST["member_email"] == null) {
$failure = true;
$failure_message = "Please change one of the options";
} else {
$CurrentUser->RealName = $_POST["member_realname"];
$CurrentUser->ShortName = $_POST["member_shortname"];
$CurrentUser->LongName = $_POST["member_longname"];
$CurrentUser->BirthDate = $_POST["member_birthdate"];
$CurrentUser->EmailAddress = $_POST["member_email"];
$CurrentUser->ProfileVisibility = UserProfileVisibility::FromIndex($_POST["member_profile_visibility"]);
$result = $CurrentUser->Update();
global $MySQL;
if (!$result) {
$failure = true;
if ($MySQL->errno != 0) {
$failure_message = $MySQL->errno . ": " . $MySQL->error;
} else {
$failure_message = mmo_error_get();
}
} else {
$lang = Language::GetByID($_POST["member_language_id"]);
$lang->SetDefaultForUser($CurrentUser);
// force refresh the user information
$CurrentUser = User::GetCurrent();
if ($MySQL->errno != 0) {
<?php
use DataFX\DataFX;
use DataFX\Table;
use DataFX\Column;
use DataFX\ColumnValue;
use DataFX\Record;
use DataFX\RecordColumn;
use PhoenixSNS\Objects\UserPresenceStatus;
use PhoenixSNS\Objects\UserProfileVisibility;
$tables[] = new Table("Users", "user_", array(new Column("ID", "INT", null, null, false, true, true), new Column("TenantID", "INT", null, null, false), new Column("LoginID", "VARCHAR", 50, null, false), new Column("URLName", "VARCHAR", 50, null, false), new Column("DisplayName", "VARCHAR", 100, null, false), new Column("EmailAddress", "VARCHAR", 200, null, true), new Column("EmailConfirmationCode", "VARCHAR", 16, ColumnValue::Undefined, true), new Column("BirthDate", "DATETIME", null, null, true), new Column("RealName", "VARCHAR", 200, null, true), new Column("PasswordHash", "VARCHAR", 256, null, false), new Column("PasswordSalt", "VARCHAR", 32, null, false), new Column("ThemeID", "INT", null, 0, false), new Column("LanguageID", "INT", null, 1, false), new Column("ProfileVisibility", "INT", null, UserProfileVisibility::ToIndex(UserProfileVisibility::Sitewide), false), new Column("ConsecutiveLoginCount", "INT", null, 0, false), new Column("ConsecutiveLoginFailures", "INT", null, 0, false), new Column("LastLoginTimestamp", "DATETIME", null, null, false), new Column("PresenceStatus", "INT", null, UserPresenceStatus::GetDatabaseID(UserPresenceStatus::Offline), false), new Column("PresenceMessage", "VARCHAR", 256, null, false), new Column("RegistrationTimestamp", "DATETIME", null, null, false), new Column("RegistrationIPAddress", "VARCHAR", 40, null, false), new Column("StartPageID", "INT", null, null, false)));
public function Update()
{
$valid_shortname = User::ValidateShortName($this->ShortName);
if ($valid_shortname != null) {
mmo_error_set($valid_shortname);
return false;
}
global $MySQL;
$query = "UPDATE " . System::GetConfigurationValue("Database.TablePrefix") . "Users SET ";
$query .= "user_RealName = '" . $MySQL->real_escape_string($this->RealName) . "', ";
$query .= "user_URLName = '" . $MySQL->real_escape_string($this->ShortName) . "', ";
$query .= "user_DisplayName = '" . $MySQL->real_escape_string($this->LongName) . "', ";
$query .= "user_BirthDate = '" . $MySQL->real_escape_string($this->BirthDate) . "', ";
$query .= "user_EmailAddress = '" . $MySQL->real_escape_string($this->EmailAddress) . "', ";
$query .= "user_ProfileVisibility = " . UserProfileVisibility::ToIndex($this->ProfileVisibility);
$query .= " WHERE user_ID = " . $this->ID;
$MySQL->query($query);
return $result->errno == 0;
}
