die; } # del on DB (comments & votings) $query = "DELETE FROM {pre}_voted WHERE voted_mod='usersgallery' AND "; $query .= "voted_fid=" . $gallery_id; cs_sql_query(__FILE__, $query); $query = "DELETE FROM {pre}_comments WHERE comments_mod='usersgallery' AND "; $query .= "comments_fid=" . $gallery_id; cs_sql_query(__FILE__, $query); cs_sql_delete(__FILE__, 'usersgallery', $gallery_id); } } if ($delete_mode == 1 or $delete_mode == 3) { # remove the folder thumbnail if (!empty($folder['folders_picture'])) { cs_unlink('folders', $folder['folders_picture'], 'pictures'); } } if ($delete_mode == 1) { # remove the folder and subfolders $select = 'folders_id, sub_id, folders_name, folders_order, folders_position'; $folder = cs_sql_select(__FILE__, 'folders', $select, "folders_mod='usersgallery'", 'folders_id ASC', 0, 0); $folder = make_folders_array($folder); make_folders_remove($folder, $folders_id); } if ($delete_mode == 3 or empty($delete_mode) and empty($count_pictures)) { # delete only folder cs_sql_delete(__FILE__, 'folders', $folders_id); } cs_redirect($cs_lang['del_true'], 'usersgallery', 'center', 'page=cat'); }
function make_folders_select($name, $select, $users_id = 0, $mod = 0, $create = 1, $folders_id = 0) { $sql_select = 'folders_id, sub_id, folders_name, folders_order, folders_position, folders_url, folders_text, folders_access'; $sql_where = "folders_mod = '" . $mod . "' AND users_id = '" . (int) $users_id . "'"; $array = cs_sql_select(__FILE__, 'folders', $sql_select, $sql_where, 'folders_id ASC', 0, 0); $array = make_folders_array($array); $data['select']['name'] = $name; $data['folders']['options'] = make_folders_options($array, 0, $select, $folders_id); $data['if']['create'] = !empty($create) ? TRUE : FALSE; return cs_subtemplate(__FILE__, $data, 'gallery', 'folders_select'); }