// thumbnail - for bkp1.3mik.com - 2000, for media1.3mik.com - 2000
// run for stored_name and thumbnail
*/
$total = 2000;
$pageSize = 50;
$pages = ceil($total / $pageSize);
$count = 0;
while ($count <= $pages) {
$start = $count * $pageSize + 1;
$end = $start + ($pageSize - 1);
$sql = " select * from sc_media where (id <= {end}) and (id >= {start} ) ";
$sql = str_replace(array("{end}", "{start}"), array(0 => $end, 1 => $start), $sql);
$rows = MySQL\Helper::fetchRows($mysqli, $sql);
printf("processing media rows between %d and %d \n", $start, $end);
foreach ($rows as $row) {
//$s3name = $row["stored_name"];
$s3name = $row["thumbnail"];
$name = $row["original_name"];
$rowId = $row["id"];
// get mime from name.
$mime = \com\indigloo\Util::getMimeFromName($name);
if (empty($mime)) {
//report it
printf("Bad mime type for media id %d \n", $rowId);
$mime = "application/octet-stream";
}
add_object_headers($s3, $bucket, $s3name, $rowId, $mime);
sleep(1);
}
$count++;
}
