} elseif ($add >= 0 && empty($_POST['submit']) || $edit > 0) {
$Template->assign_vars(array('C_ADD_MEDIA' => true, 'U_TARGET' => url('media_action.php'), 'L_TITLE' => $MEDIA_LANG['media_name'], 'L_CATEGORY' => $MEDIA_LANG['media_category'], 'L_WIDTH' => $MEDIA_LANG['media_width'], 'L_HEIGHT' => $MEDIA_LANG['media_height'], 'L_U_MEDIA' => $MEDIA_LANG['media_url'], 'L_CONTENTS' => $MEDIA_LANG['media_description'], 'KERNEL_EDITOR' => display_editor(), 'L_APPROVED' => $MEDIA_LANG['media_approved'], 'L_CONTRIBUTION_LEGEND' => $LANG['contribution'], 'L_NOTICE_CONTRIBUTION' => $MEDIA_LANG['notice_contribution'], 'L_CONTRIBUTION_COUNTERPART' => $MEDIA_LANG['contribution_counterpart'], 'L_CONTRIBUTION_COUNTERPART_EXPLAIN' => $MEDIA_LANG['contribution_counterpart_explain'], 'L_REQUIRE_NAME' => $MEDIA_LANG['require_name'], 'L_REQUIRE_URL' => $MEDIA_LANG['require_url'], 'L_RESET' => $LANG['reset'], 'L_PREVIEW' => $LANG['preview'], 'L_SUBMIT' => $edit > 0 ? $LANG['update'] : $LANG['submit']));
$js_id_music = array();
foreach ($MEDIA_CATS as $key => $value) {
if ($value['mime_type'] == MEDIA_TYPE_MUSIC) {
$js_id_music[] = $key;
}
}
if ($edit > 0 && ($media = $Sql->query_array(PREFIX . 'media', '*', "WHERE id = '" . $edit . "'", __LINE__, __FILE__)) && !empty($media) && $User->check_level(MODO_LEVEL)) {
bread_crumb($media['idcat']);
if (in_array($media['mime_type'], $mime_type['audio'])) {
$auth = MEDIA_TYPE_MUSIC;
} else {
$auth = MEDIA_TYPE_VIDEO;
}
$Template->assign_vars(array('L_PAGE_TITLE' => $MEDIA_LANG['edit_media'], 'C_CONTRIBUTION' => 0, 'IDEDIT' => $media['id'], 'NAME' => $media['name'], 'CATEGORIES_TREE' => $media_categories->build_select_form($media['idcat'], 'idcat" onchange="hide_width_height ();', 'idcat', 0, MEDIA_AUTH_WRITE, $MEDIA_CATS[0]['auth'], IGNORE_AND_CONTINUE_BROWSING_IF_A_CATEGORY_DOES_NOT_MATCH), 'WIDTH' => $media['width'], 'HEIGHT' => $media['height'], 'U_MEDIA' => $media['url'], 'DESCRIPTION' => unparse($media['contents']), 'APPROVED' => ($media['infos'] & MEDIA_STATUS_APROBED) !== 0 ? ' checked="checked"' : '', 'C_APROB' => ($media['infos'] & MEDIA_STATUS_APROBED) === 0, 'JS_ID_MUSIC' => '"' . implode('", "', $js_id_music) . '"', 'C_MUSIC' => $auth == MEDIA_TYPE_MUSIC ? true : false));
} elseif (($write = $User->check_auth($MEDIA_CATS[$add]['auth'], MEDIA_AUTH_WRITE)) || $User->check_auth($MEDIA_CATS[$add]['auth'], MEDIA_AUTH_CONTRIBUTION)) {
bread_crumb($add);
$Template->assign_vars(array('L_PAGE_TITLE' => $write ? $MEDIA_LANG['add_media'] : $MEDIA_LANG['contribute_media'], 'C_CONTRIBUTION' => !$write, 'CONTRIBUTION_COUNTERPART_EDITOR' => display_editor('counterpart'), 'IDEDIT' => 0, 'NAME' => '', 'CATEGORIES_TREE' => $media_categories->build_select_form($add, 'idcat" onchange="hide_width_height ();', 'idcat', 0, $write ? MEDIA_AUTH_WRITE : MEDIA_AUTH_CONTRIBUTION, $MEDIA_CATS[0]['auth'], IGNORE_AND_CONTINUE_BROWSING_IF_A_CATEGORY_DOES_NOT_MATCH), 'WIDTH' => '', 'HEIGHT' => '', 'U_MEDIA' => 'http://', 'DESCRIPTION' => '', 'APPROVED' => 'checked="checked"', 'C_APROB' => false, 'JS_ID_MUSIC' => '"' . implode('", "', $js_id_music) . '"', 'C_MUSIC' => $MEDIA_CATS[$add]['mime_type'] == MEDIA_TYPE_MUSIC ? true : false));
} else {
$Errorh->handler('e_auth', E_USER_REDIRECT);
exit;
}
if (!empty($media)) {
$Bread_crumb->add($media['name'], url('media.php?id=' . $media['id'], 'media-' . $media['id'] . '-' . $media['idcat'] . '+' . url_encode_rewrite($media['name']) . '.php'));
$Bread_crumb->add($MEDIA_LANG['edit_media'], url('media_action.php?edit=' . $media['id']));
define('TITLE', $MEDIA_LANG['edit_media']);
} else {
$Bread_crumb->add($MEDIA_LANG['add_media'], url('media_action.php'));
define('TITLE', $MEDIA_LANG['add_media']);
}
if ($state == "visible") {
$db_where = MEDIA_STATUS_APROBED;
} elseif ($state == 'unvisible') {
$db_where = MEDIA_STATUS_UNVISIBLE;
} elseif ($state == 'unaprobed') {
$db_where = MEDIA_STATUS_UNAPROBED;
} else {
$db_where = null;
}
if ($sub_cats) {
$media_categories->build_children_id_list($cat, $array_cats, RECURSIVE_EXPLORATION, ADD_THIS_CATEGORY_IN_LIST, MEDIA_AUTH_READ);
}
} else {
$cat = 0;
$db_where = $sub_cats = null;
$media_categories->build_children_id_list(0, $array_cats, RECURSIVE_EXPLORATION, ADD_THIS_CATEGORY_IN_LIST, MEDIA_AUTH_READ);
}
import('util/pagination');
$Pagination = new Pagination();
$nbr_media = 0;
$result = $Sql->query_while("SELECT * FROM " . PREFIX . "media WHERE " . (!empty($array_cats) ? 'idcat IN (' . "'" . implode("', '", $array_cats) . "'" . ')' : 'idcat=' . (!empty($cat) ? $cat : 0)) . (is_null($db_where) ? '' : ' AND infos=' . $db_where) . " ORDER BY infos ASC, timestamp DESC" . $Sql->limit($Pagination->get_first_msg(NUM_MODO_MEDIA, 'p'), NUM_MODO_MEDIA), __LINE__, __FILE__);
while ($row = $Sql->fetch_assoc($result)) {
$nbr_media++;
$js_array[] = $row['id'];
$Template->assign_block_vars('files', array('ID' => $row['id'], 'NAME' => $row['name'], 'U_FILE' => url('media.php?id=' . $row['id'], 'media-' . $row['id'] . '-' . $row['idcat'] . '+' . url_encode_rewrite($row['name']) . '.php'), 'U_EDIT' => url('media_action.php?edit=' . $row['id']), 'CAT' => !empty($MEDIA_CATS[$row['idcat']]) ? $MEDIA_CATS[$row['idcat']]['name'] : $LANG['unknow'], 'U_CAT' => url('media.php?cat=' . $row['idcat']), 'COLOR' => $row['infos'] == MEDIA_STATUS_UNVISIBLE ? '#FFEE99' : ($row['infos'] == MEDIA_STATUS_APROBED ? '#CCFFCC' : '#FFCCCC'), 'SHOW' => $row['infos'] == MEDIA_STATUS_APROBED ? ' checked="checked"' : '', 'HIDE' => $row['infos'] == MEDIA_STATUS_UNVISIBLE ? ' checked="checked"' : '', 'UNAPROBED' => $row['infos'] == MEDIA_STATUS_UNAPROBED ? ' checked="checked"' : ''));
}
$Sql->query_close($result);
$Template->assign_vars(array('C_DISPLAY' => 1, 'L_FILTER' => $MEDIA_LANG['filter'], 'L_DISPLAY_FILE' => $MEDIA_LANG['display_file'], 'L_ALL' => $MEDIA_LANG['all_file'], 'SELECTED_ALL' => is_null($db_where) ? ' selected="selected"' : '', 'L_FVISIBLE' => $MEDIA_LANG['visible'], 'SELECTED_VISIBLE' => $db_where === MEDIA_STATUS_APROBED ? ' selected="selected"' : '', 'L_FUNVISIBLE' => $MEDIA_LANG['unvisible'], 'SELECTED_UNVISIBLE' => $db_where === MEDIA_STATUS_UNVISIBLE ? ' selected="selected"' : '', 'L_FUNAPROBED' => $MEDIA_LANG['unaprobed'], 'SELECTED_UNAPROBED' => $db_where === MEDIA_STATUS_UNAPROBED ? ' selected="selected"' : '', 'L_CATEGORIES' => $MEDIA_LANG['from_cats'], 'CATEGORIES_TREE' => $media_categories->build_select_form($cat, 'idcat', 'idcat', 0, MEDIA_AUTH_READ, $MEDIA_CATS[$cat]['auth']), 'L_INCLUDE_SUB_CATS' => $MEDIA_LANG['include_sub_cats'], 'SUB_CATS' => is_null($sub_cats) ? ' checked="checked"' : ($sub_cats ? ' checked="checked"' : ''), 'L_MODO_PANEL' => $LANG['modo_panel'], 'L_NAME' => $LANG['name'], 'L_CATEGORY' => $LANG['category'], 'L_VISIBLE' => $MEDIA_LANG['show_media_short'], 'L_UNVISIBLE' => $MEDIA_LANG['hide_media_short'], 'L_UNAPROBED' => $MEDIA_LANG['unaprobed_media_short'], 'L_DELETE' => $LANG['delete'], 'C_NO_MODERATION' => $nbr_media > 0 ? 0 : 1, 'L_NO_MODERATION' => $MEDIA_LANG['no_media_moderate'], 'L_CONFIRM_DELETE' => str_replace('\'', '\\\'', $MEDIA_LANG['confirm_delete_media']), 'L_CONFIRM_DELETE_ALL' => str_replace('\'', '\\\'', $MEDIA_LANG['confirm_delete_media_all']), 'L_LEGEND' => $MEDIA_LANG['legend'], 'L_FILE_UNAPROBED' => $MEDIA_LANG['file_unaprobed'], 'L_FILE_UNVISIBLE' => $MEDIA_LANG['file_unvisible'], 'L_FILE_VISIBLE' => $MEDIA_LANG['file_visible'], 'PAGINATION' => $Pagination->display('moderation_media.php?p=%d', $nbr_media, 'p', NUM_MODO_MEDIA, 3), 'L_SUBMIT' => $LANG['submit'], 'L_RESET' => $LANG['reset'], 'C_ADMIN' => $User->check_level(ADMIN_LEVEL), 'L_RECOUNT_MEDIA' => $MEDIA_LANG['recount_per_cat'], 'JS_ARRAY' => '"' . implode('", "', $js_array) . '"'));
}
$Template->pparse('media_moderation');
require_once '../kernel/footer.php';
$error = retrieve(GET, 'error', '');
if ($id_up > 0) {
$media_categories->move($id_up, MOVE_CATEGORY_UP);
redirect(url('admin_media_cats.php'));
} elseif ($id_down > 0) {
$media_categories->move($id_down, MOVE_CATEGORY_DOWN);
redirect(url('admin_media_cats.php'));
} elseif ($id_show > 0) {
$media_categories->change_visibility($id_show, CAT_VISIBLE, LOAD_CACHE);
redirect(url('admin_media_cats.php'));
} elseif ($id_hide > 0) {
$media_categories->change_visibility($id_hide, CAT_UNVISIBLE, LOAD_CACHE);
redirect(url('admin_media_cats.php'));
} elseif ($cat_to_del > 0) {
$Template->assign_vars(array('L_REMOVING_CATEGORY' => $MEDIA_LANG['removing_category'], 'L_EXPLAIN_REMOVING' => $MEDIA_LANG['removing_category_explain'], 'L_DELETE_CATEGORY_AND_CONTENT' => $MEDIA_LANG['remove_category_and_its_content'], 'L_MOVE_CONTENT' => $MEDIA_LANG['move_category_content'], 'L_SUBMIT' => $LANG['delete']));
$Template->assign_block_vars('removing_interface', array('CATEGORY_TREE' => $media_categories->build_select_form(0, 'id_parent', 'id_parent', $cat_to_del), 'IDCAT' => $cat_to_del));
} elseif (!empty($_POST['submit'])) {
$error_string = 'e_success';
if (!empty($cat_to_del_post)) {
$delete_content = !empty($_POST['action']) && $_POST['action'] == 'move' ? false : true;
$id_parent = retrieve(POST, 'id_parent', 0);
if ($delete_content) {
$media_categories->Delete_category_recursively($cat_to_del_post);
} else {
$media_categories->Delete_category_and_move_content($cat_to_del_post, $id_parent);
}
} else {
$id_cat = retrieve(POST, 'idcat', 0);
$id_parent = retrieve(POST, 'id_parent', 0);
$name = retrieve(POST, 'name', '');
$image = retrieve(POST, 'image', '');
