/** * * @access public * @static * @return Idea */ public static function Create($title, $desc, $user) { $obj = new Idea(); $obj->idea_title = Database::SafeData(Support::SafeTags($title)); $obj->user_id = $user->user_id; $obj->SetDesc($desc); $obj->idea_date = time(); $obj->idea_rate = 0; return $obj; }
public static function SearchByTitle($q, $limit = 100) { $cmd = sprintf("SELECT idea_id FROM zi_ideas WHERE idea_title LIKE \"%%%s%%\" ORDER BY idea_date DESC LIMIT %d", Database::SafeData($q), $limit); return self::GetCollectionData($cmd, "can't get ideas for this search"); }
/** * Checks if $user_email is in database >> user is registered * * @param string $user_email * * @return User|false */ public static function FindUserByEmail($user_email) { $obj = new User(); $cmd = sprintf("SELECT * FROM zi_users WHERE user_email='%s'", Database::SafeData($user_email)); $data = Database::Query($cmd); if (empty($data)) { return false; } $obj = new User(); foreach ($data[0] as $key => $value) { $obj->{$key} = $value; } return $obj; }