function filedepot_displaySearchListing in filedepot 6

Same name and namespace in other branches

1. 7 lib-ajaxserver.php \filedepot_displaySearchListing()

1 call to filedepot_displaySearchListing()

filedepot_dispatcher in ./ajaxserver.php

@file ajaxserver.php Implementation of filedepot_ajax() - main ajax handler for the module

File

./lib-ajaxserver.php, line 325

lib-ajaxserver.php Library functions for the ajax_server

Code

function filedepot_displaySearchListing($query) {
  $filedepot = filedepot_filedepot();
  $query = addslashes($query);
  $sql = 'SELECT file.fid as fid,file.cid,file.title,file.fname,file.date,file.version,file.submitter,file.status,';
  $sql .= 'file.description,category.name as foldername,category.pid,category.nid ';
  $sql .= 'FROM {filedepot_files} file ';
  $sql .= 'LEFT JOIN {filedepot_categories} category ON file.cid=category.cid ';
  $sql .= 'WHERE 1=1 ';
  if (!empty($filedepot->allowableViewFoldersSql)) {
    $sql .= 'AND file.cid in (%s) ';
  }
  $sql .= 'AND (file.title LIKE "%%%s%%%" OR file.title LIKE "%%%s%%%" OR file.description LIKE "%%%s%%%" OR file.description LIKE "%%%s%%%") ';
  $sql .= 'ORDER BY file.date DESC ';
  $search_query = db_query($sql, $filedepot->allowableViewFoldersSql, $query, $query, $query, $query);
  $output = '';
  while ($A = db_fetch_array($search_query)) {
    $output .= theme('filedepot_filelisting', $A);
  }
  return $output;
}