php/searchfiles.php

   1 <?php
   2
   3 require('inc.header.php');
   4 require('inc.html.php');
   5
   6
   7 function ShowDataSearchForm()
   8 {
   9   XHTML_Form_GET_Begin($GLOBALS['self']);
  10   {
  11     XHTML_Text("File search");
  12     XHTML_Table_Begin();
  13     {
  14       XHTML_Table_Row_Begin();
  15       {
  16         XHTML_Table_Cell_Begin();
  17         XHTML_Text("Filename");
  18         XHTML_Table_Cell_End();
  19
  20         XHTML_Table_Cell_Begin();
  21         XHTML_Form_Input_Text("search_filename");
  22         XHTML_Text("Exact");
  23         XHTML_Form_Input_Checkbox("search_exact");
  24         XHTML_Text("case sensitive");
  25         XHTML_Form_Input_Checkbox("case");
  26         XHTML_Table_Cell_End();
  27       }
  28       XHTML_Table_Row_End();
  29
  30       XHTML_Table_Row_Begin();
  31       {
  32         XHTML_Table_Cell_Begin();
  33         XHTML_Text("Min size");
  34         XHTML_Table_Cell_End();
  35
  36         XHTML_Table_Cell_Begin();
  37         {
  38           XHTML_Form_Input_Text("search_minsize");
  39           XHTML_Form_Select_Begin("min_size_unit");
  40           XHTML_Form_Option("Bytes", "b");
  41           XHTML_Form_Option("KBytes", "k", true);
  42           XHTML_Form_Option("MBytes", "m");
  43           XHTML_Form_Option("GBytes", "g");
  44           XHTML_Form_Select_End();
  45         }
  46         XHTML_Table_Cell_End();
  47       }
  48       XHTML_Table_Row_End();
  49
  50       XHTML_Table_Row_Begin();
  51       {
  52         XHTML_Table_Cell_Begin();
  53         XHTML_Text("Max size");
  54         XHTML_Table_Cell_End();
  55
  56         XHTML_Table_Cell_Begin();
  57         {
  58           XHTML_Form_Input_Text("search_maxsize");
  59           XHTML_Form_Select_Begin("max_size_unit");
  60           XHTML_Form_Option("Bytes", "b");
  61           XHTML_Form_Option("KBytes", "k", true);
  62           XHTML_Form_Option("MBytes", "m");
  63           XHTML_Form_Option("GBytes", "g");
  64           XHTML_Form_Select_End();
  65         }
  66         XHTML_Table_Cell_End();
  67       }
  68       XHTML_Table_Row_End();
  69
  70       XHTML_Table_Row_Begin();
  71       {
  72         XHTML_Table_Cell_Begin();
  73         XHTML_Text("Path");
  74         XHTML_Table_Cell_End();
  75
  76         XHTML_Table_Cell_Begin();
  77         XHTML_Form_Input_Text("search_path");
  78         XHTML_Text("Exact");
  79         XHTML_Form_Input_Checkbox("search_pathexact");
  80         XHTML_Text("case sensitive");
  81         XHTML_Form_Input_Checkbox("pathcase");
  82         XHTML_Table_Cell_End();
  83       }
  84       XHTML_Table_Row_End();
  85
  86       if ($GLOBALS['config']['use_categories'])
  87       {
  88         XHTML_Table_Row_Begin();
  89         {
  90           XHTML_Table_Cell_Begin();
  91           XHTML_Text("Category");
  92           XHTML_Table_Cell_End();
  93
  94           XHTML_Table_Cell_Begin();
  95           XHTML_Form_Input_Select_Begin("search_category");
  96           {
  97             XHTML_Form_Option("Any category", "any");
  98             XHTML_Form_Option("--", "--");
  99
 100             mb_fetch_select_categories(4);
 101           }
 102           XHTML_Form_Input_Select_End();
 103           XHTML_Table_Cell_End();
 104         }
 105       }
 106     }
 107     XHTML_Table_End();
 108
 109     XHTML_Form_Input_Submit("Search");
 110   }
 111   XHTML_Form_End();
 112 }
 113
 114 // SQL Query builder
 115 $where = array();
 116 if (isset($_GET['search_filename']) && strlen($_GET['search_filename']) > 0)
 117 {
 118         if (isset($_GET['case']))
 119   {
 120     $binary = "BINARY ";
 121   }
 122   else
 123   {
 124     $binary = "";
 125   }
 126
 127         if (isset($_GET['search_exact']))
 128   {
 129                 $where[] = $binary."f.name = '".addslashes($_GET['search_filename'])."'";
 130         }
 131   else
 132   {
 133                 $where[] = "f.name REGEXP ".$binary."'".addslashes($_GET['search_filename'])."'";
 134         }
 135 }
 136
 137 if (isset($_GET['search_minsize']) && is_numeric($_GET['search_minsize']))
 138 {
 139   $size = $_GET['search_minsize'];
 140   switch ($_GET['min_size_unit'])
 141   {
 142   case "g":
 143     $size *= 1024;
 144   case "m":
 145     $size *= 1024;
 146   case "k":
 147     $size *= 1024;
 148   }
 149         $where[] = "f.size >= ".$size;
 150 }
 151
 152 if (isset($_GET['search_maxsize']) && is_numeric($_GET['search_maxsize']))
 153 {
 154   $size = $_GET['search_maxsize'];
 155   switch ($_GET['max_size_unit'])
 156   {
 157   case "g":
 158     $size *= 1024;
 159   case "m":
 160     $size *= 1024;
 161   case "k":
 162     $size *= 1024;
 163   }
 164         $where[] = "f.size <= ".$size;
 165 }
 166
 167 if (isset($_GET['search_path']) && strlen($_GET['search_path']) > 0)
 168 {
 169         if (isset($_GET['pathcase']))
 170   {
 171     $binary = "BINARY ";
 172   }
 173   else
 174   {
 175     $binary = "";
 176   }
 177
 178         if (isset($_GET['search_pathexact']))
 179   {
 180                 $where[] = $binary."f.path = '".addslashes($_GET['search_path'])."'";
 181         }
 182   else
 183   {
 184                 $where[] = "f.path REGEXP ".$binary."'".addslashes($_GET['search_path'])."'";
 185         }
 186 }
 187
 188 if (count($where) > 0)
 189 {
 190         // Database query {{{
 191                 $tables = $config['tbl_files']." AS f, ".$config['tbl_media']." AS m";
 192                 $where[] = 'f.mediaid = m.mediaid';
 193                 $cols = 'f.name, f.path, f.size, f.time, m.mediaid, m.name as medianame';
 194                 if ($config['use_categories'])
 195     {
 196                         $tables .= ", ".$config['tbl_categories']." AS c";
 197                         $cols .= ", c.catid, c.name as catname";
 198                         $where[] = 'm.catid = c.catid';
 199                         $headers[] = 'Category';
 200                 }
 201                 $query = "SELECT $cols FROM $tables WHERE ".implode(' AND ',$where);
 202
 203     //echo "<p>".$query."</p>";
 204
 205                 if (!$res = mysql_query($query))
 206     {
 207                         echo "<b>Error:</b> ".mysql_error()." <i>(".basename(__FILE__).", line ".__LINE__.")</i>\n\n";
 208                 }
 209     else
 210     {
 211                         if (!$count = mysql_num_rows($res)) {
 212                                 echo "Found no files matching your query.\n\n";
 213                         } else {
 214                                 $pl = $count > 1 ? 's' : '';
 215                                 echo "Found $count file$pl matching your query.\n<br><br>\n";
 216
 217                                 // Output
 218                                 if ($config['use_categories']) {
 219                                         mb_table_start('Filename','Path','Size','Timestamp','Medium','Media ID','Category');
 220                                 } else {
 221                                         mb_table_start('Filename','Path','Size','Timestamp','Medium','Media ID');
 222                                 }
 223
 224                                 while ($row = mysql_fetch_array($res)) {
 225                                         if (substr($row['name'],-1) == '/') {
 226                                                 mb_table_col('<nobr>'.mb_icon('__folder').'<a href="index.php?media='.$row['mediaid'].'&dir='.urlencode($row['path']).urlencode($row['name']).'">'.$row['name'].'</a></nobr>');
 227                                                 $showsize = false;
 228                                         } else {
 229                                                 mb_table_col('<nobr>'.mb_icon('__unknown').$row['name'].'</nobr>');
 230                                                 $showsize = true;
 231                                         }
 232                                         mb_table_col('<nobr><a href="index.php?media='.$row['mediaid'].'&dir='.urlencode($row['path']).'">'.$row['path'].'</a></nobr>');
 233                                         mb_table_col($showsize?mb_sizetext($row['size']):'');
 234                                         mb_table_col(mb_datetext($row['time']));
 235                                         mb_table_col('<a href="index.php?media='.$row['mediaid'].'">'.$row['medianame'].'</a>');
 236                                         mb_table_col($row['mediaid']);
 237                                         if ($config['use_categories']) {
 238                                                 mb_table_col('<a href="index.php?cat='.$row['catid'].'">'.$row['catname'].'</a>');
 239                                         }
 240                                 }
 241
 242                                 mb_table_end();
 243                         }
 244                 }
 245         // }}}
 246         echo "<p><a href=\"$self\">New search</a>\n";
 247 }
 248 else
 249 {
 250         ShowDataSearchForm();
 251 }
 252
 253 require('inc.footer.php');
 254
 255 ?>