public static function lookup_member($id = null, $email = null)
{
$id = (int) $id;
$email = trim($email);
$sql = "SELECT `AutoID` , `useremail`, `userFirstname`, `userLastname` FROM `user_signup`";
if ($id || $email || $author) {
$sql .= " WHERE";
} else {
return null;
}
if ($id) {
$sql .= " `AutoID` = '{$id}'";
if ($email || $author) {
$sql .= " &&";
}
}
if ($email) {
$sql .= " `useremail` = '{$email}'";
}
if ($res = DatabaseFactory::passinggreen_master_db()->query($sql)) {
if ($res->num_rows == 1) {
$member = $res->fetch_object();
return new Member($member->AutoID);
} else {
return null;
}
}
return null;
}
public static function findCryptKeyByUserID($id)
{
$id = (int) $id;
$sql = "SELECT `UserID` FROM `keys`";
if ($id) {
$sql .= " WHERE";
} else {
return null;
}
if ($id) {
$sql .= " `UserID` = '{$id}'";
}
if ($res = DatabaseFactory::passinggreen_master_db()->query($sql)) {
if ($res->num_rows == 1) {
$crypt_key = $res->fetch_object();
return new self($crypt_key->UserID);
} else {
return null;
}
}
return null;
}
protected function master_db()
{
return DatabaseFactory::passinggreen_master_db();
}
