close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Need "better" management of Galleries

Thread began 9/30/2010 12:22 am by Jim376112 | Last modified 10/04/2010 6:00 pm by Jim376112 | 549 views | 4 replies |

Jim376112

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Jim376112

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Jim376112

OK, thanks Jason!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...