Need "better" management of Galleries

Hello,

I have PowerGallery installed and working but I'm noticing a couple of problems with the Admin facility:

1) The Galleries that I define are appearing in the Admin page in the order in which I added them as opposed to being alphabetical. I expect that I will have dozens or perhaps a hundred Galleries and that's going to make locating a Gallery very difficult. Plus, even if we can get them in some useful order, it would be helpful when dealing with a large number of Galleries if the list could be grouped or filtered. Is there some feature I'm missing to help deal with these issues?

2) Can multiple images be deleted at once? I uploaded about 50 images into a Gallery and then realized that it might go faster if I used a Photoshop macro to rotate a bunch of them all at once. I then had to delete many of the photos in the Gallery one at a time (and confirm each deletion one at a time). (I had already discovered that a 2nd addition of the images created duplicates as opposed to replacing the files.) How can I delete multiple images in a Gallery.

Thanks.

1) You can change the order the galeries are displayed in by editing the order by statement on the choosegallery.php page;

find the recodset code:

$result_gallery = mysql_query('
				SELECT *
				FROM pg1_gallery
				ORDER BY id ASC');

and change it to:

$result_gallery = mysql_query('
				SELECT *
				FROM pg1_gallery
				ORDER BY title ASC');

2) There is no multiple delete option in power gallery, I will add a feature request for this to be considered in the future.

Hi Jason.

I figured I was going to have to alter a SELECT; thanks for pointing me to the location.

Also, glad to hear you are going to add the "multiple deletes" as a feature request. In the meantime, I've looked at the table structure and see that in pg1_gallery_images there are columns for id, gallery_id and title that could be used to identify a specific image or even all of the images in a gallery. By examining the tables I get the impression that it should be OK to "manually" issue SQL DELETEs to directly remove image rows from this table. While I don't see any linkages to other tables (other than to pg1_gallery to id to which gallery an image belongs) I'd like to ask you to confirm that manually DELETing image rows from pg1_gallery_images would have no adverse effect on the system.

Also, you didn't address my question about having a large (say a hundred) number of Galleries and how the Gallery list might be grouped or filtered to make such a long list manageable. Am I correct in assuming that there are no facilities to help with this and my only option is to alter the code (probably in choosegallery.php) to add my own features to do this?

Thanks.

No, manually deleting the images should not have adverse effect on the system.


There is no facility availabel for grouping the galleries, you would need to add this manually.

OK, thanks Jason!