$filterMedia = '';
foreach ($_POST['entry'] as $id) {
if (!ae_Validate::id($id)) {
continue;
}
$stmt .= $idField . ' = :entry' . $id . ' OR ';
$params[':entry' . $id] = $id;
$filterMedia .= $prefix . '_id = ' . $id . ' OR ';
}
$stmt = mb_substr($stmt, 0, -4);
$stmt .= ' )';
if ($_POST['area'] == 'media') {
$filterMedia = '(' . mb_substr($filterMedia, 0, -4) . ') AND ';
$filterMedia .= $prefix . '_status = "' . $preDelete . '"';
$filter = array('LIMIT' => FALSE, 'WHERE' => $filterMedia);
$mediaList = new ae_MediaList($filter);
while ($m = $mediaList->next()) {
$m->deleteFile();
}
}
} else {
$stmt = '
UPDATE `' . $table . '`
SET ' . $prefix . '_status = :status
WHERE
';
$params = array(':status' => $status);
foreach ($_POST['entry'] as $id) {
if (!ae_Validate::id($id)) {
continue;
}
<?php
$area = 'media';
$itemsPerPage = 20;
$pageOffset = isset($_GET['offset']) && is_numeric($_GET['offset']) ? $_GET['offset'] : 0;
$status = isset($_GET['status']) ? $_GET['status'] : FALSE;
$urlBasis = '?area=media&offset=' . $pageOffset;
$filter = array();
$filter['LIMIT'] = sprintf('%d, %d', $pageOffset * $itemsPerPage, $itemsPerPage);
if (ae_MediaModel::isValidStatus($status)) {
$filter['WHERE'] = 'm_status = "' . $status . '"';
}
$list = new ae_MediaList($filter);
// pagination
$numPages = ceil($list->getTotalNumItems() / $itemsPerPage);
$queryStr = preg_replace('/[?&]offset=?[0-9]*/i', '', $_SERVER['QUERY_STRING']);
$linkBase = 'admin.php?' . htmlspecialchars($queryStr) . '&offset=';
?>
<h1>Media</h1>
<form class="media-file-upload" action="scripts/upload.php" method="post" enctype="multipart/form-data">
<input type="file" name="upload[]" />
<button type="submit" class="btn btn-publish">upload</button>
</form>
<form method="post" action="scripts/manage-bulk.php">
<input type="hidden" name="area" value="media" />
<?php
