public function GetMembers($max = null)
{
global $MySQL;
$query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "Users, " . System::$Configuration["Database.TablePrefix"] . "PageMembers WHERE " . System::$Configuration["Database.TablePrefix"] . "PageMembers.pagemember_PageID = " . $this->ID . " AND " . System::$Configuration["Database.TablePrefix"] . "PageMembers.pagemember_UserID = " . System::$Configuration["Database.TablePrefix"] . "Users.user_ID";
$result = $MySQL->query($query);
$count = $result->num_rows;
$retval = array();
for ($i = 0; $i < $count; $i++) {
$values = $result->fetch_assoc();
$retval[] = User::GetByAssoc($values);
}
return $retval;
}
public static function GetRandom()
{
global $MySQL;
$query = "SELECT * FROM " . System::GetConfigurationValue("Database.TablePrefix") . "Users ORDER BY RAND() LIMIT 1";
$result = $MySQL->query($query);
$values = $result->fetch_assoc();
return User::GetByAssoc($values);
}
/**
* Retrieves a single User with the given credentials.
* @param string $username The user name of the User to search for.
* @param string $password The password of the User to search for.
* @return NULL|\PhoenixSNS\Objects\User The User with the given credentials, or null if no User with the given credentials was found or the credentials were invalid
*/
public static function GetByCredentials($username, $password)
{
global $pdo;
$query = $pdo->prepare("SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "Users WHERE user_LoginID = :LoginID");
$query->bindParam(":LoginID", $username);
$result = $query->execute();
if ($result === false) {
return null;
}
$values = $query->fetch(PDO::FETCH_ASSOC);
$passwordSalt = $values["user_PasswordSalt"];
$passwordHashCmp = $values["user_PasswordHash"];
$passwordHash = hash("sha512", $password . $passwordSalt);
if ($passwordHash == $passwordHashCmp) {
return User::GetByAssoc($values);
}
return null;
}
$includes = explode(",", $include);
foreach ($availableTables as $key => $value) {
$availableTables[$key] = false;
}
foreach ($includes as $include) {
$availableTables[$include] = true;
}
}
if ($availableTables["Users"]) {
$lookupTables[] = new LookupTable("Users", "user_DisplayName", function ($table, $totalCount, $previousCount) {
$result = $table->Result;
$items = array();
$c = 0;
for ($i = 0; $i < $result->num_rows; $i++) {
$values = $result->fetch_assoc();
$item = User::GetByAssoc($values);
if (!$item->IsVisible()) {
$c++;
continue;
}
$items[] = $item;
}
$totalCount -= $c;
$count = count($items);
for ($i = 0; $i < $count; $i++) {
$item = $items[$i];
echo "{ \"Category\": \"Members\", \"Item\": ";
echo $item->ToJSON();
echo " }";
if ($i + $previousCount < $totalCount - 1) {
echo ", ";
