get_var("SELECT path FROM $wpdb->nggallery WHERE gid = '$act_gid' ");
if ($gallerypath){
$thumb_folder = ngg_get_thumbnail_folder($gallerypath, FALSE);
$thumb_prefix = ngg_get_thumbnail_prefix($gallerypath, FALSE);
// delete pictures
$imagelist = $wpdb->get_col("SELECT filename FROM $wpdb->nggpictures WHERE galleryid = '$act_gid' ");
if ($ngg_options[deleteImg]) {
if (is_array($imagelist)) {
foreach ($imagelist as $filename) {
unlink(WINABSPATH.$gallerypath.'/'.$thumb_folder.'/'.$thumb_prefix.$filename);
unlink(WINABSPATH.$gallerypath.'/'.$filename);
}
}
// delete folder
@rmdir(WINABSPATH.$gallerypath.'/'.$thumb_folder);
@rmdir(WINABSPATH.$gallerypath);
}
}
$delete_pic = $wpdb->query("DELETE FROM $wpdb->nggpictures WHERE galleryid = $act_gid");
$delete_galllery = $wpdb->query("DELETE FROM $wpdb->nggallery WHERE gid = $act_gid");
if($delete_galllery)
$messagetext = ''.__('Gallery','nggallery').' \''.$act_gid.'\' '.__('deleted successfully','nggallery').'';
$mode = 'main'; // show mainpage
}
if ($mode == 'delpic') {
// Delete a picture
$gallerypath = $wpdb->get_var("SELECT path FROM $wpdb->nggallery WHERE gid = '$act_gid' ");
if ($gallerypath){
$thumb_folder = ngg_get_thumbnail_folder($gallerypath, FALSE);
$thumb_prefix = ngg_get_thumbnail_prefix($gallerypath, FALSE);
$filename = $wpdb->get_var("SELECT filename FROM $wpdb->nggpictures WHERE pid = '$act_pid' ");
if ($ngg_options[deleteImg]) {
unlink(WINABSPATH.$gallerypath.'/'.$thumb_folder.'/'.$thumb_prefix.$filename);
unlink(WINABSPATH.$gallerypath.'/'.$filename);
}
}
$delete_pic = $wpdb->query("DELETE FROM $wpdb->nggpictures WHERE pid = $act_pid");
if($delete_pic)
$messagetext = ''.__('Picture','nggallery').' \''.$act_pid.'\' '.__('deleted successfully','nggallery').'';
$mode = 'edit'; // show pictures
}
if (isset($_POST['bulkaction'])) {
// do bulk update
$gallerypath = $wpdb->get_var("SELECT path FROM $wpdb->nggallery WHERE gid = '$act_gid' ");
$imageslist = array();
if ( is_array($_POST['doaction']) ) {
foreach ( $_POST['doaction'] as $imageID ) {
$imageslist[] = $wpdb->get_var("SELECT filename FROM $wpdb->nggpictures WHERE pid = '$imageID' ");
}
}
switch ($_POST['bulkaction']) {
case 0;
// No action
break;
case 1:
// Set watermark
ngg_generateWatermark(WINABSPATH.$gallerypath,$imageslist);
$messagetext = ''.__('Watermark successfully added','nggallery').'';
break;
case 2:
// Create new thumbnails
ngg_generatethumbnail(WINABSPATH.$gallerypath,$imageslist);
$messagetext = ''.__('Thumbnails successfully created. Please refresh your browser cache.','nggallery').'';
break;
case 3:
// Resample images
ngg_resizeImages(WINABSPATH.$gallerypath,$imageslist);
$messagetext = ''.__('Images successfully resized','nggallery').'';
break;
case 4:
// Delete images
if ( is_array($_POST['doaction']) ) {
if ($gallerypath){
$thumb_folder = ngg_get_thumbnail_folder($gallerypath, FALSE);
$thumb_prefix = ngg_get_thumbnail_prefix($gallerypath, FALSE);
foreach ( $_POST['doaction'] as $imageID ) {
$filename = $wpdb->get_var("SELECT filename FROM $wpdb->nggpictures WHERE pid = '$imageID' ");
if ($ngg_options[deleteImg]) {
unlink(WINABSPATH.$gallerypath.'/'.$thumb_folder.'/'.$thumb_prefix.$filename);
unlink(WINABSPATH.$gallerypath.'/'.$filename);
}
$delete_pic = $wpdb->query("DELETE FROM $wpdb->nggpictures WHERE pid = $imageID");
}
}
if($delete_pic)
$messagetext = ''.__('Pictures deleted successfully ','nggallery').'';
}
break;
}
}
if ($_POST['updatepictures']) {
// Update pictures
$gallery_title=$_POST[title];
$gallery_path=$_POST[path];
$gallery_desc=$_POST[gallerydesc];
$gallery_pageid=$_POST[pageid];
$gallery_preview=$_POST[previewpic];
$result = $wpdb->query("UPDATE $wpdb->nggallery SET title= '$gallery_title', path= '$gallery_path', description = '$gallery_desc', pageid = '$gallery_pageid', previewpic = '$gallery_preview' WHERE gid = '$act_gid'");
$result = ngg_update_pictures($_POST[description], $_POST[alttext], $_POST[exclude], $act_gid );
$messagetext = ''.__('Update successfully','nggallery').'';
}
if ($_POST['scanfolder']) {
// Rescan folder
//TODO: Wenn keine bilder vorhanden sind , fehler beim scannen
$gallerypath = $wpdb->get_var("SELECT path FROM $wpdb->nggallery WHERE gid = '$act_gid' ");
$old_imageslist = $wpdb->get_col("SELECT filename FROM $wpdb->nggpictures WHERE galleryid = '$act_gid' ");
// read list of images in folder
$new_imageslist = ngg_scandir(WINABSPATH.$gallerypath);
// check difference
$imageslist = array_diff($new_imageslist, $old_imageslist);
//create thumbnails
ngg_generatethumbnail(WINABSPATH.$gallerypath,$imageslist);
// add images to database
$count_pic = 0;
if (is_array($imageslist)) {
foreach($imageslist as $picture) {
$result = $wpdb->query("INSERT INTO $wpdb->nggpictures (galleryid, filename, alttext) VALUES ('$act_gid', '$picture', '$picture') ");
if ($result) $count_pic++;
}
$messagetext = ''.$count_pic.__(' picture(s) successfully added','nggallery').'';
}
}
// message windows
if(!empty($messagetext)) { echo '
'.$messagetext.'
'; }
if (($mode == '') or ($mode == "main"))
nggallery_manage_gallery_main();
if ($mode == 'edit')
nggallery_pciturelist();
}//nggallery_admin_manage_gallery
function nggallery_manage_gallery_main() {
// *** show main gallery list
global $wpdb;
?>
get_results("SELECT * FROM $wpdb->nggallery ");
if($gallerylist) {
foreach($gallerylist as $gallery) {
$class = ( $class == 'class="alternate"' ) ? '' : 'class="alternate"';
$gid = $gallery->gid;
$counter = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->nggpictures WHERE galleryid = '$gid'");
?>