static function search($text, $limit = 0) { $text = Dal::quote($text); $limit_sql = $limit ? " LIMIT {$limit}" : ""; $sth = Dal::query("SELECT content_id, comment_id FROM {comments} WHERE is_active = 1 AND (name LIKE '%{$text}%' OR subject LIKE '%{$text}%' OR homepage LIKE '%{$text}%' OR comment LIKE '%{$text}%') {$limit_sql}"); return Dal::all_assoc($sth); }
static function get_recent_content_for_user($uid, $content_type, $limit) { $tables = array(IMAGE => "images", AUDIO => "audios", VIDEO => "videos"); $other_table = $tables[$content_type]; $sth = Dal::query("SELECT * FROM contents C\n LEFT JOIN {$other_table} I ON C.content_id=I.content_id\n WHERE C.type=? AND C.author_id=? AND C.is_active=1\n ORDER BY C.created DESC\n LIMIT {$limit}", array($content_type, $uid)); return Dal::all_assoc($sth); }
public function find_associated_domains() { $sth = Dal::query("SELECT sd.domain domain, dic2.domain_id domain_id, COUNT(dic2.domain_id) match_count\n FROM spam_domains sd, domains_in_comments dic1, domains_in_comments dic2\n WHERE dic1.domain_id=? AND dic1.comment_id=dic2.comment_id AND sd.id=dic2.domain_id\n GROUP BY dic2.domain_id ORDER BY match_count DESC", array($this->id)); return Dal::all_assoc($sth); }