diff mgallery.php @ 343:d6422e856ecd

Remove the backend/SQL stuff for now.
author Matti Hamalainen <ccr@tnsp.org>
date Sun, 27 Aug 2023 04:16:05 +0300
parents 0d1bd22fcb39
children 9fbec6399cdd
line wrap: on
line diff
--- a/mgallery.php	Sun Aug 27 01:45:44 2023 +0300
+++ b/mgallery.php	Sun Aug 27 04:16:05 2023 +0300
@@ -544,132 +544,6 @@
   fclose($fp);
 }
 
-// Check for chosen backend mode
-if (($galBackend = mgGetSetting("backend")) === null)
-  die("MGallery backend mode not set.\n");
-
-switch ($galBackend = strtolower($galBackend))
-{
-  case "sql":
-    // If SQL backend, and gallery is virtual, attempt a select
-    if (isset($galData["virtual"]))
-    {
-      // Connect to database
-      if (mgConnectSQLDB() === FALSE)
-        die("Could not open database connection.\n");
-
-      $asql = ["SELECT * FROM images ".
-        "LEFT JOIN paths ON images.path_id=paths.id ".
-        "WHERE"];
-
-      $ccmds = preg_split("/\s*([,|])\s*/",
-        strtolower($galData["virtual"]), -1,
-        PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);
-
-      foreach ($ccmds as $ccmd)
-      switch ($ccmd)
-      {
-        case "keyword":
-          if (!isset($galData["v_keyword"]))
-            die("Invalid definition.\n");
-
-          $asql[] = mgPrepareSQL(
-            "images.id IN (SELECT image_id FROM images_meta ".
-            "LEFT JOIN metadata ON images_meta.meta_id=metadata.id ".
-            "WHERE metadata.field='keywords' AND data=%s)",
-            $galData["v_keyword"]);
-          break;
-
-        case "month_range":
-          if (!isset($galData["v_month_begin"]) ||
-              !isset($galData["v_month_end"]))
-            die("Invalid definition.\n");
-
-          $asql[] = mgPrepareSQL(
-            "date_part('month', datetime) BETWEEN %d AND %d",
-            $galData["v_month_begin"],
-            $galData["v_month_end"]);
-          break;
-
-        case "date_range":
-          if (!isset($galData["v_date_begin"]) ||
-              !isset($galData["v_date_end"]))
-            die("Invalid definition.\n");
-
-          $asql[] = mgPrepareSQL(
-            "datetime BETWEEN %s AND %s",
-            $galData["v_date_begin"],
-            $galData["v_date_end"]);
-          break;
-
-        case "year":
-          if (!isset($galData["v_year"]))
-            die("Invalid definition.\n");
-
-          // Laatuklunssi
-          $v_year = strtolower($galData["v_year"]);
-          if (substr($v_year, 0, 7) == "parent:")
-          {
-            if (isset($galData["parent"]))
-            {
-              $v_field = substr($v_year, 7);
-              if (isset($galData["parent"]["caption"]))
-                $galData["v_year"] = $galData["parent"][$v_field];
-              else
-                die("Foobar\n");
-            }
-            else
-              die("Fazboo\n");
-          }
-
-          $asql[] = mgPrepareSQL(
-            "date_part('year', datetime)=%d",
-            $galData["v_year"]);
-          break;
-
-        case "|":
-          $asql[] = "OR";
-          break;
-
-        case ",":
-          $asql[] = "AND";
-          break;
-
-        default:
-          die("Invalid virtual gallery definition.\n");
-      }
-
-      $asql[] = "ORDER BY datetime DESC";
-      $sql = implode(" ", $asql);
-
-      // Query images for this gallery
-      $galData["header"] .= "<p>".$sql."</p>";
-
-      if (($res = mgExecSQL($sql)) === FALSE)
-        die("Could not execute virtual gallery.\n");
-
-      // Push the entries into our data structures
-      foreach ($res as $entry)
-      if (!in_array($entry["filename"], $galImagesIndex))
-      {
-        $entry["datetime"] = mgSQLToDateTime($db, $entry["datetime"]);
-        $entry["type"] = 0;
-
-        $galEntries[$entry["filename"]] = $entry;
-        $galImagesIndex[] = $entry["filename"];
-      }
-    }
-    //print_r($galEntries);
-    break;
-
-  case "php":
-    break;
-
-  default:
-    die("Invalid MGallery backend mode '".$galBackend."'.\n");
-}
-
-
 // If no data available, show an error page
 if (!isset($galData) || !isset($galEntries) ||
     !isset($galAlbumsIndex) || !isset($galImagesIndex))