Modify Next Gen Gallery WordPress

Duncan O'Neill answers:

Hi Derek,

Or, you could take a sledgehammer approach and alter a file within the next-gen gallery plugin.

In my version of the plugin ( which is probably outdated ) there is a line within the plugin's admin/functions.php which you can alter. This is part of the function add_Images(), and is on line 523 in my version of next-gen. Find this line;

$result = $wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->nggpictures (galleryid, filename, alttext, exclude) VALUES (%s, %s, %s, 0)", $galleryID, $picture, $alttext) );

and alter it to

$result = $wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->nggpictures (galleryid, filename, alttext, exclude) VALUES (%s, %s, %s, 1)", $galleryID, $picture, $alttext) );


You're just changing that zero value to 1 for the value of the exclude field in the db.

Of course, you'd have to go back and manually update the images you wanted to include.

hth,

Sébastien | French WordpressDesigner answers:

which version of nextgengallery do you use ?


if you use the last version of NGG, open the file nextgen-gallery/lib/ngg-db.php
at the line 613 you have this code :
if ( false === $wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->nggpictures (image_slug, galleryid, filename, description, alttext, meta_data, post_id, imagedate, exclude, sortorder)
VALUES (%s, %d, %s, %s, %s, %s, %d, %s, %d, %d)", $slug, $id, $filename, $description, $alttext, $meta_data, $post_id, $imagedate, $exclude, $sortorder ) ) ) {
return false;
}

replace it by
if ( false === $wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->nggpictures (image_slug, galleryid, filename, description, alttext, meta_data, post_id, imagedate, exclude, sortorder)
VALUES (%s, %d, %s, %s, %s, %s, %d, %s, 1, %d)", $slug, $id, $filename, $description, $alttext, $meta_data, $post_id, $imagedate, $exclude, $sortorder ) ) ) {
return false;
}

this is the same principle of the answer of Duncan O'Neill
but for the last version of NGG


EDIT : Arnav Joy's response is better :-)

Arnav Joy answers:

try this in your functions.php

I have tested it , it works well

add_action('ngg_after_new_images_added','my_function',10,2);

function my_function($galleryID,$image_ids){
global $wpdb;
foreach($image_ids as $imgID)
$wpdb->query("UPDATE $wpdb->nggpictures SET exclude = '1' WHERE pid = '$imgID' ");

}

derekshirk comments:

This is exactly what I was looking for. Works perfectly so far.
I have one more question that I am going to post and I bet you all would be able to help me out with.

Thank you so much for all of you help.
This is the first question I have asked on this website. I am going to use Arnav's answer but since Duncan and Sebastien also posted good answers is it appropriate for me to award them a small portion of the prize money?