public static function FromSQLRow($row)
{
$user = new User();
// Generic user info
$user->ID = $row["id"];
$user->Name = User::SQLUnEscape($row["Name"]);
$user->LastLogin = $row["LastLogin"];
$user->IsActive = $row["IsActive"];
$user->IsGuest = $row["IsGuest"];
$user->IsRegistered = true;
// EVE info
$user->Title = User::SQLUnEscape($row["Title"]);
$user->CharID = $row["CharID"];
if (empty($row["Alts"])) {
$user->Alts = array();
} else {
$user->Alts = explode(",", User::SQLUnEscape($row["Alts"]));
}
$user->EVERoles = $row["EVERoles"];
$user->PortalRoles = $row["PortalRoles"];
$user->IsAlly = $row["IsAlly"];
$user->CorporationName = User::SQLUnEscape($row["CorporationName"]);
$user->CorporationTicker = User::SQLUnEscape($row["CorporationTicker"]);
$user->CorporationID = $row["CorporationID"];
// Misc
$user->TimeZone = $row["TimeZone"];
$user->Email = User::SQLUnEscape($row["EMail"]);
$user->IM = User::SQLUnEscape($row["IM"]);
$user->BirthDate = $row["BirthDate"];
$user->Location = User::SQLUnEscape($row["Location"]);
// Portal preferences
$user->DateFormat = $row["DateFormat"];
$user->PortalSettings = $row["PortalSettings"];
$user->Signature = User::SQLUnEscape($row["Signature"]);
// OOP
$user->OOPUntil = $row["OOPUntil"];
$user->OOPNote = User::SQLUnEscape($row["OOPNote"]);
$user->IsOOP = $user->OOPUntil == "0000-00-00" ? false : true;
return $user;
}
