$option_value) { if (in_array($option_name, array('h', 'help'))) { echo '' . PHP_EOL; exit(1); } if ($option_name == 'start') { $start = (int)$option_value; echo "Starting with alternative ref #" . $start . PHP_EOL; } if ($option_name == 'end') { $end = (int)$option_value; echo "Ending with alternative ref #" . $end . PHP_EOL; } if ($option_name == 'previewbased') { $previewbased = true; echo "Setting previewbased to true" . PHP_EOL; } } } if (PHP_SAPI == 'cli') { $condition = "a.ref >= ?"; $params = ["i",$start]; if ($end > 0) { $condition .= " AND a.ref <= ?"; $params[] = "i"; $params[] = $end; } $resources = ps_query("SELECT a.ref, a.resource, a.file_extension FROM resource_alt_files a JOIN resource r ON a.resource = r.ref WHERE " . $condition . " AND length(a.file_extension) > 0", $params); foreach ($resources as $resource) { $success = create_previews($resource["resource"], false, ($previewbased ? "jpg" : $resource["file_extension"]), false, $previewbased, $resource["ref"]); $message = $success ? "Preview created successfully" : "Preview creation failed"; echo "Alternative ref #" . $resource["ref"] . ", resource #" . $resource["resource"] . " - " . $message . PHP_EOL; ob_flush(); flush(); } } else { $resourceinfo = ps_query("SELECT a.ref, a.resource, a.file_extension FROM resource_alt_files a JOIN resource r ON a.resource = r.ref WHERE a.ref = ? AND length(a.file_extension) > 0", ["i", $ref]); if (count($resourceinfo) > 0) { create_previews($resourceinfo[0]["resource"], false, ($previewbased ? "jpg" : $resourceinfo[0]["file_extension"]), false, $previewbased, $ref); ?> "> "/> Done.