Example #1
0
 foreach ($orig_sort_order as $album) {
     $op = parse_orig_sort_order($album);
     if (count($op) == 2) {
         $query = "UPDATE {$CONFIG['TABLE_ALBUMS']} SET pos='{$op['pos']}' WHERE aid='{$op['aid']}' {$restrict} LIMIT 1";
         cpg_db_query($query);
     } else {
         cpg_die(sprintf(CRITICAL_ERROR, $lang_delete_php['err_invalid_data'], $_POST['sort_order']), __FILE__, __LINE__);
     }
 }
 $to_delete = parse_list($_POST['delete_album']);
 foreach ($to_delete as $album_id) {
     delete_album((int) $album_id);
 }
 if (isset($_POST['to'])) {
     foreach ($_POST['to'] as $option_value) {
         $op = parse_select_option(stripslashes($option_value));
         switch ($op['action']) {
             case '0':
                 break;
             case '1':
                 if (GALLERY_ADMIN_MODE) {
                     $category = (int) $_POST['cat'];
                 } else {
                     $category = FIRST_USER_CAT + USER_ID;
                 }
                 echo "<tr><td colspan=\"6\" class=\"tableb\">" . sprintf($lang_delete_php['create_alb'], $op['album_nm']) . "</td></tr>\n";
                 $query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos, description) VALUES ('{$category}', '" . addslashes($op['album_nm']) . "', 'NO',  '{$op['album_sort']}', '')";
                 cpg_db_query($query);
                 break;
             case '2':
                 echo "<tr><td colspan=\"6\" class=\"tableb\">" . sprintf($lang_delete_php['update_alb'], $op['album_no'], $op['album_nm'], $op['album_sort']) . "</td></tr>\n";
Example #2
0
 $orig_sort_order = parse_list($_POST['sort_order']);
 foreach ($orig_sort_order as $album) {
     $op = parse_orig_sort_order($album);
     if (count($op) == 2) {
         $db->sql_query("UPDATE {$CONFIG['TABLE_ALBUMS']} SET pos='{$op['pos']}' WHERE aid='{$op['aid']}' {$restrict}", false, __FILE__, __LINE__);
     } else {
         cpg_die(sprintf(CRITICAL_ERROR, ERR_INVALID_DATA, $_POST['sort_order']), __FILE__, __LINE__);
     }
 }
 $to_delete = parse_list($_POST['delete_album']);
 foreach ($to_delete as $album_id) {
     delete_album($album_id);
 }
 if (isset($_POST['to'])) {
     foreach ($_POST['to'] as $option_value) {
         $op = parse_select_option($option_value);
         switch ($op['action']) {
             case '0':
                 break;
             case '1':
                 if (GALLERY_ADMIN_MODE) {
                     $category = intval($_POST['cat']);
                 } else {
                     $category = FIRST_USER_CAT + USER_ID;
                 }
                 echo "<tr><td colspan=\"6\" class=\"tableb\">" . sprintf('CREATE_ALB', $op['album_nm']) . "</td></tr>\n";
                 $album_nm = Fix_Quotes($op['album_nm']);
                 $db->sql_query("INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos) VALUES ('{$category}', '" . $album_nm . "', 'NO',  '{$op['album_sort']}')", false, __FILE__, __LINE__);
                 break;
             case '2':
                 $album_nm = Fix_Quotes($op['album_nm']);