Wikidot Open Source

class TagsLookupQModule extends QuickModule {    
    public function process($data){
        // does not use data

        $search = $_GET['q'];
        $siteId = $_GET['s'];
        if(!is_numeric($siteId)) return;
        if($search == null || strlen($search) ==0) return;

        $search1 = pg_escape_string(preg_quote($search));
        $search2 = pg_escape_string($search);

        Database::init();
        $q1 = "SELECT tag, tag_id FROM page_tag WHERE " .
                "tag ~* '^$search1' AND tag != '$search2' AND site_id = '$siteId'";
        $q1 .= "ORDER BY tag LIMIT 20";
        $q2 = "SELECT tag, user_id FROM page_tag WHERE " .
                "tag = '$search2'  AND site_id ='$siteId'";
        $db = Database::connection();

        $result1 = $db->query($q1);
        $result1 = $result1->fetchAll();
        $result2 = $db->query($q2);
        $result2 = $result2->fetchAll();

        if($result1 == null && $result2 != null) $result = $result2;
        if($result2 == null && $result1 != null) $result = $result1;
        if($result1 != null && $result2 != null){
            $result = array_merge($result2, $result1);
        }

        return array('tags' => $result);
    }

}