0, 'album_title' => '', 'album_keywords' => '', 'album_description' => '', 'album_access' => '', 'album_language' => LANGUAGE, 'album_image' => '', 'album_thumb1' => '', 'album_thumb2' => '', 'album_order' => dbcount("(album_id)", DB_PHOTO_ALBUMS, multilang_table("PG") ? in_group('album_language', LANGUAGE) : "") + 1 ]; if (isset($_POST['save_album'])) { $data = [ 'album_id' => form_sanitizer($_POST['album_id'], 0, 'album_id'), 'album_title' => form_sanitizer($_POST['album_title'], '', 'album_title'), 'album_keywords' => form_sanitizer($_POST['album_keywords'], '', 'album_keywords'), 'album_description' => form_sanitizer($_POST['album_description'], '', 'album_description'), 'album_access' => form_sanitizer($_POST['album_access'], '', 'album_access'), 'album_language' => form_sanitizer($_POST['album_language'], '', 'album_language'), 'album_order' => form_sanitizer($_POST['album_order'], '', 'album_order'), 'album_image' => '', 'album_thumb1' => '', 'album_thumb2' => '', 'album_user' => fusion_get_userdata('user_id'), 'album_datestamp' => time(), ]; if (empty($data['album_order'])) { $data['album_order'] = dbresult(dbquery("SELECT MAX(album_order) FROM ".DB_PHOTO_ALBUMS." ".(multilang_table("PG") ? "where ".in_group('album_language', LANGUAGE) : "").""), 0) + 1; } // do delete image if (\defender::safe()) { if (!empty($_FILES['album_image']) && is_uploaded_file($_FILES['album_image']['tmp_name'])) { $upload = form_sanitizer($_FILES['album_image'], '', 'album_image'); if (empty($upload['error'])) { $data['album_image'] = $upload['image_name']; $data['album_thumb1'] = $upload['thumb1_name']; $data['album_thumb2'] = $upload['thumb2_name']; } } else { if (isset($_POST['del_image'])) { // album_id $result = dbquery("select album_image, album_thumb1, album_thumb2 FROM ".DB_PHOTO_ALBUMS." WHERE album_id=:albumid", [':albumid' => $data['album_id']]); if (dbrows($result) > 0) { $pData = dbarray($result); if ($pData['album_image'] && file_exists(IMAGES_G.$pData['album_image'])) { unlink(IMAGES_G.$pData['album_image']); } if ($pData['album_thumb1'] && file_exists(IMAGES_G.$pData['album_thumb1'])) { unlink(IMAGES_G_T.$pData['album_thumb1']); } if ($pData['album_thumb2'] && file_exists(IMAGES_G.$pData['album_thumb2'])) { unlink(IMAGES_G_T.$pData['album_thumb2']); } $data['album_image'] = ''; $data['album_thumb1'] = ''; $data['album_thumb2'] = ''; } } else { $data['album_image'] = form_sanitizer(isset($_POST['album_image']) ? $_POST['album_image'] : '', '', 'album_image'); $data['album_thumb2'] = form_sanitizer(isset($_POST['album_thumb2']) ? $_POST['album_thumb2'] : '', '', 'album_thumb2'); $data['album_thumb1'] = form_sanitizer(isset($_POST['album_thumb1']) ? $_POST['album_thumb1'] : '', '', 'album_thumb1'); } } } if (\defender::safe()) { if (dbcount("(album_id)", DB_PHOTO_ALBUMS, "album_id=:albumid", [':albumid' => intval($data['album_id'])])) { // update album $result = dbquery_order(DB_PHOTO_ALBUMS, $data['album_order'], 'album_order', $data['album_id'], 'album_id', FALSE, FALSE, TRUE, 'album_language', 'update'); dbquery_insert(DB_PHOTO_ALBUMS, $data, 'update'); addNotice('success', $locale['album_0013']); redirect(FUSION_REQUEST); } else { // create album $result = dbquery_order(DB_PHOTO_ALBUMS, $data['album_order'], 'album_order', 0, "album_id", FALSE, FALSE, TRUE, 'album_language', 'save'); dbquery_insert(DB_PHOTO_ALBUMS, $data, 'save'); addNotice('success', $locale['album_0014']); redirect(FUSION_REQUEST); } } } // callback if ($album_edit) { $result = dbquery("SELECT * FROM ".DB_PHOTO_ALBUMS." WHERE album_id=:catid", [':catid' => intval($_GET['cat_id'])]); if (dbrows($result) > 0) { $data = dbarray($result); } } // edit features - add more in roadmap. // add features to purge all album photos and it's administration // add features to move all album photos to another album. echo openform('albumform', 'post', FUSION_REQUEST, ['enctype' => TRUE, 'class' => 'm-t-20']); echo "