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;
}
