stwalkerster /
waca
| @@ 12-33 (lines=22) @@ | ||
| 9 | protected $data; |
|
| 10 | protected $timestamp; |
|
| 11 | ||
| 12 | public static function getByUsername($username, PdoDatabase $database) |
|
| 13 | { |
|
| 14 | $statement = $database->prepare(<<<SQL |
|
| 15 | SELECT * |
|
| 16 | FROM antispoofcache |
|
| 17 | WHERE username = :id AND timestamp > date_sub(now(), interval 3 hour) |
|
| 18 | LIMIT 1 |
|
| 19 | SQL |
|
| 20 | ); |
|
| 21 | $statement->bindValue(":id", $username); |
|
| 22 | ||
| 23 | $statement->execute(); |
|
| 24 | ||
| 25 | $resultObject = $statement->fetchObject(get_called_class()); |
|
| 26 | ||
| 27 | if ($resultObject != false) { |
|
| 28 | $resultObject->isNew = false; |
|
| 29 | $resultObject->setDatabase($database); |
|
| 30 | } |
|
| 31 | ||
| 32 | return $resultObject; |
|
| 33 | } |
|
| 34 | ||
| 35 | public function getUsername() |
|
| 36 | { |
|
| @@ 90-105 (lines=16) @@ | ||
| 87 | return $resultObject; |
|
| 88 | } |
|
| 89 | ||
| 90 | public static function getByName($name, PdoDatabase $database) |
|
| 91 | { |
|
| 92 | $statement = $database->prepare("SELECT * FROM `emailtemplate` WHERE name = :name LIMIT 1;"); |
|
| 93 | $statement->bindValue(":name", $name); |
|
| 94 | ||
| 95 | $statement->execute(); |
|
| 96 | ||
| 97 | $resultObject = $statement->fetchObject(get_called_class()); |
|
| 98 | ||
| 99 | if ($resultObject != false) { |
|
| 100 | $resultObject->isNew = false; |
|
| 101 | $resultObject->setDatabase($database); |
|
| 102 | } |
|
| 103 | ||
| 104 | return $resultObject; |
|
| 105 | } |
|
| 106 | ||
| 107 | public function save() |
|
| 108 | { |
|
| @@ 17-32 (lines=16) @@ | ||
| 14 | * @param PdoDatabase $database |
|
| 15 | * @return RDnsCache |
|
| 16 | */ |
|
| 17 | public static function getByAddress($address, PdoDatabase $database) |
|
| 18 | { |
|
| 19 | $statement = $database->prepare("SELECT * FROM rdnscache WHERE address = :id LIMIT 1;"); |
|
| 20 | $statement->bindValue(":id", $address); |
|
| 21 | ||
| 22 | $statement->execute(); |
|
| 23 | ||
| 24 | $resultObject = $statement->fetchObject(get_called_class()); |
|
| 25 | ||
| 26 | if ($resultObject != false) { |
|
| 27 | $resultObject->isNew = false; |
|
| 28 | $resultObject->setDatabase($database); |
|
| 29 | } |
|
| 30 | ||
| 31 | return $resultObject; |
|
| 32 | } |
|
| 33 | ||
| 34 | public function save() |
|
| 35 | { |
|
| @@ 161-176 (lines=16) @@ | ||
| 158 | return false; |
|
| 159 | } |
|
| 160 | ||
| 161 | public static function getByRequestToken($requestToken, PdoDatabase $database) |
|
| 162 | { |
|
| 163 | $statement = $database->prepare("SELECT * FROM user WHERE oauthrequesttoken = :id LIMIT 1;"); |
|
| 164 | $statement->bindValue(":id", $requestToken); |
|
| 165 | ||
| 166 | $statement->execute(); |
|
| 167 | ||
| 168 | $resultObject = $statement->fetchObject(get_called_class()); |
|
| 169 | ||
| 170 | if ($resultObject != false) { |
|
| 171 | $resultObject->isNew = false; |
|
| 172 | $resultObject->setDatabase($database); |
|
| 173 | } |
|
| 174 | ||
| 175 | return $resultObject; |
|
| 176 | } |
|
| 177 | ||
| 178 | /** |
|
| 179 | * @param string $status |
|
| @@ 183-197 (lines=15) @@ | ||
| 180 | * @param PdoDatabase $database |
|
| 181 | * @return User[] |
|
| 182 | */ |
|
| 183 | public static function getAllWithStatus($status, PdoDatabase $database) |
|
| 184 | { |
|
| 185 | $statement = $database->prepare("SELECT * FROM user WHERE status = :status"); |
|
| 186 | $statement->execute(array(":status" => $status)); |
|
| 187 | ||
| 188 | $resultObject = $statement->fetchAll(PDO::FETCH_CLASS, get_called_class()); |
|
| 189 | ||
| 190 | /** @var User $u */ |
|
| 191 | foreach ($resultObject as $u) { |
|
| 192 | $u->setDatabase($database); |
|
| 193 | $u->isNew = false; |
|
| 194 | } |
|
| 195 | ||
| 196 | return $resultObject; |
|
| 197 | } |
|
| 198 | ||
| 199 | public static function getAllCheckusers(PdoDatabase $database) |
|
| 200 | { |
|
