public function AddComment($user_id, $message) { $time = time(); $message = DB::Escape($message); $query = DB::RunFastQuery("INSERT INTO cms_news_comments (user_id, news_id, value, timestanp) VALUES ('{$user_id}', '{$this->article_id}', '{$message}', '{$time}')"); return $query->InsertId; }
public static function GenerateUserById($id) { $id = DB::Escape($id); $query = DB::RunFastQuery("SELECT * FROM users WHERE id = '{$id}'"); if ($query->NumRows() == 0) { return false; } $user = new HabboUser($query->UniqueRow()["id"], $query->UniqueRow()); self::$cachedUsers[strtolower($user->username)] = $user; return $user; }
public static function GetCookie($name, $domain, $remote_addr) { $name = DB::Escape($name); $query = DB::RunFastQuery("SELECT * FROM cms_cookies WHERE name = '{$name}' AND http_host = '{$domain}' AND remote_addr = '{$remote_addr}'"); if ($query->NumRows() == 0) { return false; } $cook = new CookieElement($query->UniqueRow()); if (!self::ValidateCookie($cook)) { return false; } return $cook; }