コード例 #1
0
ファイル: search.php プロジェクト: kairion/customisation-db
                    continue;
                }
                // Add OR if not empty
                $or_sql .= $or_sql ? ' OR ' : '';
                $or_sql .= '(v.phpbb_version_branch = ' . (int) $version[0] . (int) $version[2] . ' AND v.phpbb_version_revision = \'' . phpbb::$db->sql_escape(substr($version, 4)) . '\')';
            }
            $sql .= ' (' . $or_sql . ') ';
        }
        $sql .= 'GROUP BY ' . $prefix . '.contrib_id';
        $result = phpbb::$db->sql_query($sql);
        while ($row = phpbb::$db->sql_fetchrow($result)) {
            $contribs[] = $row['contrib_id'];
        }
        phpbb::$db->sql_freeresult($result);
        // Search in the set
        titania_search::in_set($query, 'id', $contribs);
    }
    $query->where($query->eq('type', TITANIA_CONTRIB));
} else {
    // Search type
    if ($search_type) {
        $query->where($query->eq('type', $search_type));
    }
}
// Do the search
$results = titania_search::custom_search($query, $sort);
// Grab the users
users_overlord::load_users($results['user_ids']);
/*switch ($display)
{
	case 'topics' :