Mercurial > hg > mgallery
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))