/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
if (get_forum_type() != 'ocf') {
return array();
}
$remapped_orderer = '';
switch ($sort) {
case 'title':
$remapped_orderer = 'g_name';
break;
}
require_lang('ocf');
// Calculate our where clause (search)
$sq = build_search_submitter_clauses('g_group_leader', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
$where_clause .= ' AND ';
$where_clause .= 'g_hidden=0 AND g_is_private_club=1';
// Calculate and perform query
$rows = get_search_rows(NULL, NULL, $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'f_groups r', array('!', 'r.g_name', 'r.g_title'), $where_clause, $content_where, $remapped_orderer, 'r.*');
$out = array();
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
require_lang('calendar');
$remapped_orderer = '';
switch ($sort) {
case 'title':
$remapped_orderer = 'e_title';
break;
case 'add_date':
$remapped_orderer = 'e_add_date';
break;
}
// Calculate our where clause (search)
$where_clause .= ' AND ';
$where_clause .= '(e_is_public=1';
if (!is_guest()) {
$where_clause .= ' OR e_submitter=' . strval(get_member());
}
$where_clause .= ')';
$sq = build_search_submitter_clauses('e_submitter', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!is_null($cutoff)) {
$where_clause .= ' AND ';
$where_clause .= 'e_add_date>' . strval(intval($cutoff));
}
$where_clause .= ' AND ';
$where_clause .= 'e_type<>' . strval(db_get_first_id());
if (!has_specific_permission(get_member(), 'see_unvalidated')) {
$where_clause .= ' AND ';
$where_clause .= 'validated=1';
}
// Calculate and perform query
$rows = get_search_rows('event', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'calendar_events r', array('r.e_title', 'r.e_content'), $where_clause, $content_where, $remapped_orderer, 'r.*', NULL, 'calendar', 'e_type');
$out = array();
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
$remapped_orderer = '';
switch ($sort) {
case 'rating':
$remapped_orderer = '_rating:polls:id';
break;
case 'title':
$remapped_orderer = 'question';
break;
case 'add_date':
$remapped_orderer = 'add_time';
break;
}
require_code('polls');
require_lang('polls');
require_css('polls');
// Calculate our where clause (search)
$sq = build_search_submitter_clauses('submitter', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!is_null($cutoff)) {
$where_clause .= ' AND ';
$where_clause .= 'add_time>' . strval((int) $cutoff);
}
// Calculate and perform query
$rows = get_search_rows(NULL, NULL, $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'poll r', array('r.question', 'r.option1', 'r.option2', 'r.option3', 'r.option4', 'r.option5'), $where_clause, $content_where, $remapped_orderer, 'r.*');
$out = array();
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
$remapped_orderer = '';
switch ($sort) {
case 'title':
$remapped_orderer = 'q_name';
break;
case 'add_date':
$remapped_orderer = 'q_add_date';
break;
}
require_lang('quiz');
// Calculate our where clause (search)
$sq = build_search_submitter_clauses('q_submitter', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!is_null($cutoff)) {
$where_clause .= ' AND ';
$where_clause .= 'q_add_date>' . strval((int) $cutoff);
}
if (!has_specific_permission(get_member(), 'see_unvalidated')) {
$where_clause .= ' AND ';
$where_clause .= 'q_validated=1';
}
// Calculate and perform query
$rows = get_search_rows('quiz', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'quizzes r', array('', 'r.q_start_text'), $where_clause, $content_where, $remapped_orderer, 'r.*');
$out = array();
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
if (get_forum_type() != 'ocf') {
return array();
}
if (get_member() == $GLOBALS['OCF_DRIVER']->get_guest_id()) {
return array();
}
require_code('ocf_forums');
require_code('ocf_posts');
require_css('ocf');
$remapped_orderer = '';
switch ($sort) {
case 'title':
$remapped_orderer = 'p_title';
break;
case 'add_date':
$remapped_orderer = 'p_time';
break;
}
require_lang('ocf');
// Calculate our where clause (search)
$where_clause .= ' AND ';
$where_clause .= 't_forum_id IS NULL AND (t_pt_from=' . strval((int) get_member()) . ' OR t_pt_to=' . strval((int) get_member()) . ')';
$sq = build_search_submitter_clauses('p_poster', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!is_null($cutoff)) {
$where_clause .= ' AND ';
$where_clause .= 'p_time>' . strval($cutoff);
}
if (get_param_integer('option_ocf_posts_starter', 0) == 1) {
$where_clause .= ' AND ';
$where_clause .= 's.t_cache_first_post_id=r.id';
}
if (!has_specific_permission(get_member(), 'see_unvalidated')) {
$where_clause .= ' AND ';
$where_clause .= 'p_validated=1';
}
// Calculate and perform query
$rows = get_search_rows(NULL, NULL, $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'f_posts r LEFT JOIN ' . get_table_prefix() . 'f_topics s ON r.p_topic_id=s.id', array('!', 'r.p_post'), $where_clause, $content_where, $remapped_orderer, 'r.*', array('r.p_title'));
$out = array();
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
$remapped_orderer = '';
switch ($sort) {
case 'rating':
$remapped_orderer = '_rating:downloads:id';
break;
case 'title':
$remapped_orderer = 'name';
break;
case 'add_date':
$remapped_orderer = 'add_date';
break;
case 'file_size':
$remapped_orderer = $sort;
break;
}
require_code('downloads');
require_lang('downloads');
require_css('downloads');
// Calculate our where clause (search)
$sq = build_search_submitter_clauses('submitter', $author_id, $author, 'author');
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!is_null($cutoff)) {
$where_clause .= ' AND ';
$where_clause .= 'add_date>' . strval(intval($cutoff));
}
if (!has_specific_permission(get_member(), 'see_unvalidated')) {
$where_clause .= ' AND ';
$where_clause .= 'validated=1';
}
// Calculate and perform query
$rows = get_search_rows('downloads_download', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'download_downloads r', array('r.name', 'r.description', 'r.comments'), $where_clause, $content_where, $remapped_orderer, 'r.*', array('r.original_filename', 'r.download_data_mash'), 'downloads', 'category_id');
$out = array();
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
$remapped_orderer = '';
switch ($sort) {
case 'title':
$remapped_orderer = 'the_page';
break;
case 'add_date':
$remapped_orderer = 'the_zone';
// Stucked
break;
}
load_up_all_self_page_permissions(get_member());
$sq = build_search_submitter_clauses('p_submitter', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!$GLOBALS['FORUM_DRIVER']->is_super_admin(get_member())) {
$where_clause .= ' AND ';
$where_clause .= 'z.zone_name IS NOT NULL';
}
if (strpos($content, 'panel_') === false) {
$where_clause .= ' AND ';
$where_clause .= '(r.the_page NOT LIKE \'' . db_encode_like('panel\\_%') . '\') AND (r.the_page NOT LIKE \'' . db_encode_like('\\_%') . '\')';
}
if (!is_null($search_under) && $search_under != '!') {
$where_clause .= ' AND ';
$where_clause .= '(' . db_string_equal_to('r.the_zone', $search_under) . ')';
}
if (!has_specific_permission(get_member(), 'see_unvalidated')) {
$where_clause .= ' AND ';
$where_clause .= 'p_validated=1';
}
require_lang('zones');
$g_or = _get_where_clause_groups(get_member(), false);
// Calculate and perform query
if ($g_or == '') {
$rows = get_search_rows('comcode_page', 'the_zone:the_page', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'cached_comcode_pages r LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'comcode_pages q ON (q.the_zone=r.the_zone AND q.the_page=r.the_page)', array('r.cc_page_title', 'r.string_index'), $where_clause, $content_where, $remapped_orderer, 'r.*');
} else {
$rows = get_search_rows('comcode_page', 'the_zone:the_page', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'cached_comcode_pages r LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'comcode_pages q ON (q.the_zone=r.the_zone AND q.the_page=r.the_page) LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'group_zone_access z ON (z.zone_name=r.the_zone AND (' . str_replace('group_id', 'z.group_id', $g_or) . '))', array('r.cc_page_title', 'r.string_index'), $where_clause, $content_where, $remapped_orderer, 'r.*');
}
if (addon_installed('redirects_editor')) {
$redirects = $GLOBALS['SITE_DB']->query_select('redirects', array('*'));
} else {
$redirects = array();
}
$out = array();
$pages_found = array();
foreach ($rows as $i => $row) {
foreach ($redirects as $redirect) {
if ($redirect['r_from_page'] == $row['the_page'] && $redirect['r_from_zone'] == $row['the_zone']) {
continue 2;
}
}
if ($row['the_zone'] == '!') {
continue;
}
if (array_key_exists($row['the_zone'] . ':' . $row['the_page'], $pages_found)) {
continue;
}
$pages_found[$row['the_zone'] . ':' . $row['the_page']] = 1;
$out[$i]['data'] = $row + array('extra' => array($row['the_zone'], $row['the_page'], $limit_to));
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
if (!has_page_access(get_member(), $row['the_page'], $row['the_zone'])) {
$out[$i]['restricted'] = true;
}
}
if ($author == '') {
// Make sure we record that for all cached Comcode pages, we know of them (only those not cached would not have been under the scope of the current search)
$all_pages = $GLOBALS['SITE_DB']->query_select('cached_comcode_pages', array('the_zone', 'the_page'));
foreach ($all_pages as $row) {
$pages_found[$row['the_zone'] . ':' . $row['the_page']] = 1;
}
// Now, look on disk for non-cached comcode pages
$zones = find_all_zones();
$i = count($out);
if (!is_null($search_under) && $search_under != '!') {
$zones = array($search_under);
}
foreach ($zones as $zone) {
if (!has_zone_access(get_member(), $zone)) {
continue;
}
$pages = find_all_pages($zone, 'comcode/' . user_lang(), 'txt') + find_all_pages($zone, 'comcode_custom/' . user_lang(), 'txt') + find_all_pages($zone, 'comcode/' . get_site_default_lang(), 'txt') + find_all_pages($zone, 'comcode_custom/' . get_site_default_lang(), 'txt');
foreach ($pages as $page => $dir) {
if (!is_string($page)) {
$page = strval($page);
}
if (!array_key_exists($zone . ':' . $page, $pages_found)) {
if (!has_page_access(get_member(), $page, $zone)) {
continue;
}
if (strpos($content, 'panel_') === false) {
if (substr($page, 0, 6) == 'panel_') {
continue;
}
}
if (substr($page, 0, 1) == '_') {
continue;
}
foreach ($redirects as $redirect) {
if ($redirect['r_from_page'] == $page && $redirect['r_from_zone'] == $zone) {
continue 2;
}
}
$path = zone_black_magic_filterer(($dir == 'comcode_custom' ? get_custom_file_base() : get_file_base()) . '/' . $zone . '/pages/' . $dir . '/' . $page . '.txt');
if (!is_null($cutoff) && filemtime($path) < $cutoff) {
continue;
}
$contents = file_get_contents($path, FILE_TEXT);
if ($only_titles) {
$contents = preg_replace('#^.*\\[title(="1")?\\](.*)\\[/title\\].*$#Us', '${2}', $contents);
}
if (in_memory_search_match(array('content' => $content, 'conjunctive_operator' => $boolean_operator), $contents)) {
$out[$i]['data'] = array('the_zone' => $zone, 'the_page' => $page) + array('extra' => array($zone, $page, $limit_to));
if ($remapped_orderer == 'the_page') {
$out[$i]['orderer'] = $page;
} elseif ($remapped_orderer == 'the_zone') {
$out[$i]['orderer'] = $zone;
}
$i++;
$GLOBALS['TOTAL_RESULTS']++;
// Let it cache for next time
if (get_option('is_on_comcode_page_cache') == '1') {
request_page($page, false, $zone, $dir, false, true);
}
}
}
}
}
}
return $out;
}
/**
* Standard modular run function for search results.
*
* @param string Search string
* @param boolean Whether to only do a META (tags) search
* @param ID_TEXT Order direction
* @param integer Start position in total results
* @param integer Maximum results to return in total
* @param boolean Whether only to search titles (as opposed to both titles and content)
* @param string Where clause that selects the content according to the main search string (SQL query fragment) (blank: full-text search)
* @param SHORT_TEXT Username/Author to match for
* @param ?MEMBER Member-ID to match for (NULL: unknown)
* @param TIME Cutoff date
* @param string The sort type (gets remapped to a field in this function)
* @set title add_date
* @param integer Limit to this number of results
* @param string What kind of boolean search to do
* @set or and
* @param string Where constraints known by the main search code (SQL query fragment)
* @param string Comma-separated list of categories to search under
* @param boolean Whether it is a boolean search
* @return array List of maps (template, orderer)
*/
function run($content, $only_search_meta, $direction, $max, $start, $only_titles, $content_where, $author, $author_id, $cutoff, $sort, $limit_to, $boolean_operator, $where_clause, $search_under, $boolean_search)
{
unset($limit_to);
if (!module_installed('catalogues')) {
return array();
}
$remapped_orderer = '';
switch ($sort) {
case 'rating':
$remapped_orderer = '_rating:catalogues:id';
break;
case 'title':
$remapped_orderer = 'b_cv_value';
break;
case 'add_date':
$remapped_orderer = 'ce_add_date';
break;
case 'relevance':
break;
default:
$remapped_orderer = preg_replace('#[^\\w]#', '', $sort);
break;
}
require_code('catalogues');
require_lang('catalogues');
// Calculate our where clause (search)
$sq = build_search_submitter_clauses('ce_submitter', $author_id, $author);
if (is_null($sq)) {
return array();
} else {
$where_clause .= $sq;
}
if (!is_null($cutoff)) {
$where_clause .= ' AND ';
$where_clause .= 'r.ce_add_date>' . strval($cutoff);
}
if (!$GLOBALS['FORUM_DRIVER']->is_super_admin(get_member())) {
$where_clause .= ' AND ';
$where_clause .= 'z.category_name IS NOT NULL';
$where_clause .= ' AND ';
$where_clause .= 'p.category_name IS NOT NULL';
}
if (!has_specific_permission(get_member(), 'see_unvalidated')) {
$where_clause .= ' AND ';
$where_clause .= 'ce_validated=1';
}
$g_or = _get_where_clause_groups(get_member());
// Calculate and perform query
$catalogue_name = get_param('catalogue_name', '');
$ranges = array();
if ($catalogue_name != '') {
$extra_select = '';
$rows = $GLOBALS['SITE_DB']->query_select('catalogue_fields', array('id', 'cf_name', 'cf_type', 'cf_default'), array('c_name' => $catalogue_name, 'cf_searchable' => 1), 'ORDER BY cf_order');
$table = 'catalogue_entries r';
$trans_fields = array('!');
$nontrans_fields = array();
$title_field = mixed();
require_code('fields');
foreach ($rows as $i => $row) {
$ob = get_fields_hook($row['cf_type']);
$temp = $ob->inputted_to_sql_for_search($row, $i);
if (is_null($temp)) {
list(, , $row_type) = $ob->get_field_value_row_bits($row);
switch ($row_type) {
case 'long_trans':
$trans_fields[] = 'f' . strval($i) . '.cv_value';
$table .= ' JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'catalogue_efv_long_trans f' . strval($i) . ' ON (f' . strval($i) . '.ce_id=r.id AND f' . strval($i) . '.cf_id=' . strval($row['id']) . ')';
$search_field = 't' . strval(count($trans_fields) - 1) . '.text_original';
//$extra_select.=',t'.strval(count($trans_fields)-1).'.text_original AS f'.strval($i).'_actual_value';
break;
case 'short_trans':
$trans_fields[] = 'f' . strval($i) . '.cv_value';
$table .= ' JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'catalogue_efv_short_trans f' . strval($i) . ' ON (f' . strval($i) . '.ce_id=r.id AND f' . strval($i) . '.cf_id=' . strval($row['id']) . ')';
$search_field = 't' . strval(count($trans_fields) - 1) . '.text_original';
//$extra_select.=',t'.strval(count($trans_fields)-1).'.text_original AS f'.strval($i).'_actual_value';
break;
case 'long':
$nontrans_fields[] = 'f' . strval($i) . '.cv_value';
$table .= ' JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'catalogue_efv_long f' . strval($i) . ' ON (f' . strval($i) . '.ce_id=r.id AND f' . strval($i) . '.cf_id=' . strval($row['id']) . ')';
$search_field = 'f' . strval($i) . '.cv_value';
//$extra_select.=',f'.strval($i).'.cv_value AS f'.strval($i).'_actual_value';
break;
case 'short':
$nontrans_fields[] = 'f' . strval($i) . '.cv_value';
$table .= ' JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'catalogue_efv_short f' . strval($i) . ' ON (f' . strval($i) . '.ce_id=r.id AND f' . strval($i) . '.cf_id=' . strval($row['id']) . ')';
$search_field = 'f' . strval($i) . '.cv_value';
//$extra_select.=',f'.strval($i).'.cv_value AS f'.strval($i).'_actual_value';
break;
case 'float':
//$nontrans_fields[]='f'.strval($i).'.cv_value';
$table .= ' JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'catalogue_efv_float f' . strval($i) . ' ON (f' . strval($i) . '.ce_id=r.id AND f' . strval($i) . '.cf_id=' . strval($row['id']) . ')';
$search_field = 'f' . strval($i) . '.cv_value';
//$extra_select.=',f'.strval($i).'.cv_value AS f'.strval($i).'_actual_value';
break;
case 'integer':
//$nontrans_fields[]='f'.strval($i).'.cv_value';
$table .= ' JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'catalogue_efv_integer f' . strval($i) . ' ON (f' . strval($i) . '.ce_id=r.id AND f' . strval($i) . '.cf_id=' . strval($row['id']) . ')';
$search_field = 'f' . strval($i) . '.cv_value';
//$extra_select.=',f'.strval($i).'.cv_value AS f'.strval($i).'_actual_value';
break;
}
$param = get_param('option_' . strval($row['id']), '');
if ($param != '') {
$where_clause .= ' AND ';
if (substr($param, 0, 1) == '=') {
$where_clause .= db_string_equal_to($search_field, substr($param, 1));
} elseif ($row_type == 'integer' || $row_type == 'float') {
if (is_numeric($param)) {
$where_clause .= $search_field . '=' . $param;
} else {
$where_clause .= db_string_equal_to($search_field, $param);
}
} else {
if (db_has_full_text($GLOBALS['SITE_DB']->connection_read) && method_exists($GLOBALS['SITE_DB']->static_ob, 'db_has_full_text_boolean') && $GLOBALS['SITE_DB']->static_ob->db_has_full_text_boolean() && !is_under_radar($param)) {
$temp = db_full_text_assemble($param, true);
} else {
$temp = db_like_assemble($param);
}
$where_clause .= preg_replace('#\\?#', $search_field, $temp);
}
} else {
$param = get_param('option_' . strval($row['id']) . '_ranged', '');
if ($param != '') {
$ranges[$row['id']] = $param;
}
}
} else {
$table .= $temp[2];
$search_field = $temp[3];
if ($temp[4] != '') {
$where_clause .= ' AND ';
$where_clause .= $temp[4];
} else {
$trans_fields = array_merge($trans_fields, $temp[0]);
$non_trans_fields = array_merge($nontrans_fields, $temp[1]);
}
}
if ($i == 0) {
$title_field = $search_field;
}
}
$where_clause .= ' AND ';
$where_clause .= db_string_equal_to('r.c_name', $catalogue_name);
if (is_null($title_field)) {
return array();
}
// No fields in catalogue -- very odd
if ($g_or == '') {
$rows = get_search_rows('catalogue_entry', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, $table, $trans_fields, $where_clause, $content_where, str_replace('b_cv_value', $title_field, $remapped_orderer), 'r.*,r.id AS id,r.cc_id AS r_cc_id,' . $title_field . ' AS b_cv_value' . $extra_select, $nontrans_fields);
} else {
$rows = get_search_rows('catalogue_entry', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, $table . ' LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'group_category_access z ON (' . db_string_equal_to('z.module_the_name', 'catalogues_category') . ' AND z.category_name=r.cc_id AND ' . str_replace('group_id', 'z.group_id', $g_or) . ') LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'group_category_access p ON (' . db_string_equal_to('p.module_the_name', 'catalogues_catalogue') . ' AND p.category_name=r.c_name AND ' . str_replace('group_id', 'p.group_id', $g_or) . ')', $trans_fields, $where_clause, $content_where, str_replace('b_cv_value', $title_field, $remapped_orderer), 'r.*,r.id AS id,r.cc_id AS r_cc_id,' . $title_field . ' AS b_cv_value' . $extra_select, $nontrans_fields);
}
} else {
if ($GLOBALS['SITE_DB']->query_value('translate', 'COUNT(*)') > 10000) {
$trans_fields = array();
$join = ' JOIN ' . get_table_prefix() . 'catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id)';
$_remapped_orderer = str_replace('b_cv_value', 'c.cv_value', $remapped_orderer);
$extra_select = '';
$non_trans_fields = array('c.cv_value');
} else {
$join = ' LEFT JOIN ' . get_table_prefix() . 'catalogue_efv_short_trans a ON (r.id=a.ce_id AND f.id=a.cf_id) LEFT JOIN ' . get_table_prefix() . 'catalogue_efv_long_trans b ON (r.id=b.ce_id AND f.id=b.cf_id) LEFT JOIN ' . get_table_prefix() . 'catalogue_efv_long d ON (r.id=d.ce_id AND f.id=d.cf_id) LEFT JOIN ' . get_table_prefix() . 'catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id)';
//' LEFT JOIN '.get_table_prefix().'catalogue_efv_float g ON (r.id=g.ce_id AND f.id=g.cf_id) LEFT JOIN '.get_table_prefix().'catalogue_efv_integer h ON (r.id=h.ce_id AND f.id=h.cf_id)';
$trans_fields = array('a.cv_value', 'b.cv_value');
$_remapped_orderer = str_replace('b_cv_value', 'b.cv_value', $remapped_orderer);
$extra_select = ',b.cv_value AS b_cv_value';
$non_trans_fields = array('c.cv_value', 'd.cv_value');
}
$where_clause .= ' AND ';
$where_clause .= 'r.c_name NOT LIKE \'\\_%\'';
// Don't want results drawn from the hidden custom-field catalogues
if ($g_or == '') {
$rows = get_search_rows('catalogue_entry', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'catalogue_fields f LEFT JOIN ' . get_table_prefix() . 'catalogue_entries r ON (r.c_name=f.c_name)' . $join, $trans_fields, $where_clause, $content_where, $_remapped_orderer, 'r.*,r.id AS id,r.cc_id AS r_cc_id' . $extra_select, $non_trans_fields);
} else {
$rows = get_search_rows('catalogue_entry', 'id', $content, $boolean_search, $boolean_operator, $only_search_meta, $direction, $max, $start, $only_titles, 'catalogue_fields f LEFT JOIN ' . get_table_prefix() . 'catalogue_entries r ON (r.c_name=f.c_name)' . $join . ' LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'group_category_access z ON (' . db_string_equal_to('z.module_the_name', 'catalogues_category') . ' AND z.category_name=r.cc_id AND ' . str_replace('group_id', 'z.group_id', $g_or) . ') LEFT JOIN ' . $GLOBALS['SITE_DB']->get_table_prefix() . 'group_category_access p ON (' . db_string_equal_to('p.module_the_name', 'catalogues_catalogue') . ' AND p.category_name=r.c_name AND ' . str_replace('group_id', 'p.group_id', $g_or) . ')', $trans_fields, $where_clause, $content_where, $_remapped_orderer, 'r.*,r.id AS id,r.cc_id AS r_cc_id' . $extra_select, $non_trans_fields);
}
}
$out = array();
if (count($rows) == 0) {
return array();
}
global $SEARCH_CATALOGUE_ENTRIES_CATALOGUES;
$query = 'SELECT c.* FROM ' . get_table_prefix() . 'catalogues c';
if (can_arbitrary_groupby()) {
$query .= ' JOIN ' . get_table_prefix() . 'catalogue_entries e ON e.c_name=c.c_name GROUP BY c.c_name';
}
$_catalogues = $GLOBALS['SITE_DB']->query($query);
foreach ($_catalogues as $catalogue) {
$SEARCH_CATALOGUE_ENTRIES_CATALOGUES[$catalogue['c_name']] = $catalogue;
}
if (count($ranges) != 0) {
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
$catalogue_name = $row['c_name'];
$tpl_set = $catalogue_name;
$display = get_catalogue_entry_map($row, $SEARCH_CATALOGUE_ENTRIES_CATALOGUES[$catalogue_name], 'PAGE', $tpl_set, -1);
foreach ($ranges as $range_id => $range_key) {
$bits = explode('-', $display['_FIELD_' . strval($range_id)]);
if (count($bits) == 2) {
if (intval($bits[0]) >= intval($range_key) || intval($bits[1]) <= intval($range_key)) {
$out[$i]['restricted'] = true;
continue 2;
}
}
}
//$out[$i]['template']=do_template('CATALOGUE_'.$tpl_set.'_ENTRY_EMBED',$display,NULL,false,'CATALOGUE_DEFAULT_ENTRY_EMBED');//put_in_table(hyperlink($url,do_lang('_HERE')),'internal','middle','WIDE',1,do_lang('CATALOGUE_ENTRY').' ('.do_lang('IN',get_translated_text($catalogue['c_title'])).')');
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
} else {
foreach ($rows as $i => $row) {
$out[$i]['data'] = $row;
unset($rows[$i]);
if ($remapped_orderer != '' && array_key_exists($remapped_orderer, $row)) {
$out[$i]['orderer'] = $row[$remapped_orderer];
} elseif (substr($remapped_orderer, 0, 7) == '_rating') {
$out[$i]['orderer'] = $row['compound_rating'];
}
}
}
return $out;
}
