/**
  *
  * @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;
 }