Managing Galleries


Once you get galleries into the database you need a way to manage them. TGP Rotator includes an easy to use gallery management solution which allows you to edit gallery information, perform a search and replace, quickly delete galleries, and scan them to see if they are still working. This document will cover the gallery management interface.

Managing Your Galleries

To manage the galleries in your database, locate and click on the Display Galleries link in the Galleries section of the control panel menu. TGP Rotator will load a page where you can view, search, and manage all of your galleries. At the top of the page there will be a box that you can use to control which galleries will be displayed.

A description of each of the marked items follows.
  1. Display galleries depending on their current status. You can check any or all of these boxes at once.
      Pending - Galleries that are waiting to be selected for display
      Used - Galleries that are currently displayed on one of your pages
      Holding - Galleries in the holding queue waiting to be rotated back into the Pending queue
  2. Display galleries that have a thumbnail preview or not. You can check either or both of these boxes at once.
      Has thumbnail preview - galleries with a thumbnail preview will be shown if this is checked
      No thumbnail preview - galleries that do not have a thumbnail preview will be shown if this is checked
  3. Display pictures or movies galleries. You can check either or both of these boxes at once.
      Pictures - galleries with thumbnails that link to full sized images
      Movies - galleries with thumbnails that link to movies
  4. These are your search options.
      Search In - this determines what database field is searched
      Search Term - this determines what is searched for. Leave this blank to display all galleries. Enter [EMPTY] to search for an empty field.
        Contains - This will search for the search term anywhere in the field you are searching
        Matches - This will search for an exact match on the term you enter
      Sort By - this determines how the galleries are sorted when they are displayed
      Per Page - this determines how many galleries are displayed per page
  5. Click this link to access the quick tasks interface which allows you to execute search and replace type functions
  6. These are your category options. You can select one or more categories from the list to restrict which category's galleries are shown. Click the [All] link to quickly select all categories.
Once you have selected the options to determine what galleries you want do display, press the Display Galleries button. TGP Rotator will search the database using your criteria, and display a list of the galleries it finds. Each gallery will be displayed in it's own section, as you see below.

A description of each of the marked items follows.
  1. This is the ID number that has been assigned to the gallery along with a checkbox you can use to select multiple galleries for deletion
  2. This is where you can view and manage the gallery's preview thumbnail. If the gallery does not have a preview thumbnail it will say [No Thumb]. You can click on the [No Thumb] link to create or upload one. To delete the thumbnail click on the [Delete] link. To create or upload a new thumbnail, click on the [Edit] link. You can also click directly on the thumbnail to access the image filters which allow you to sharpen, adjust contrast, adjust brightness, etc.
  3. Use these form fields to make changes to the gallery information stored in the database
      URL - The gallery URL
      Description - The gallery description
      Keywords - A list of words that describe the gallery
      Thumbs - The number of thumbnails on the gallery page
      Sponsor - The sponsor who owns the gallery
      Clicks - The number of clicks the gallery has received
      Scheduled - The date that the gallery will become eligible for display on your TGP pages, in YYYY-MM-DD format
      Thumb - Uncheck this box if you do not want the gallery scanner to automatically create a thumbnail for this gallery
      Scan - Uncheck this box if you do not want this gallery to be scanned by the gallery scanner
      Category - The category of the gallery
      Weight - The weight assigned to the gallery
      Format - The type of content the gallery contains (either Pictures or Movies)
  4. If the gallery is currently being displayed, this shows the date that it was selected for display in YYYY-MM-DD format
  5. This shows the gallery's current status
  6. You can click on these links to access additional functions
      [Details] - Click this link to display additional information about the gallery
      [Scan] - Click this link to have the software perform a quick scan of the gallery and display the results
      [Visit] - Click this link to visit the gallery in your browser
      [Delete] - Click this link to delete the gallery from the database

If you want to change some of the information for a gallery, you can edit that information directly in the Display Galleries interface. After you have made changes to one or more galleries, you will need to press the Process Changes button. There is one located at both the top and bottom of the page. If you do not press the Process Changes button, the updates you have made will not be stored in the database.

Scheduling Galleries

The scheduling feature of TGP Rotator allows you to specify when a gallery becomes eligible for display on one of your TGP pages. Scheduling galleries is done through the Display Galleries interface by editing the Scheduled field for the gallery that you want to schedule. By default, all galleries imported into the database are scheduled for random selection, however you can include the scheduled date in your import file if you wish.

For galleries that do not have a specific date scheduled, the word Random will appear in the Scheduled field. You can change that to any date that you wish, as long as the date is in YYYY-MM-DD format. For example, if you wanted a gallery to become eligible for display on January 1st, 2006 you would enter 2006-01-01 in the Scheduled field.

Scheduling a gallery for a specific date does not necessarily mean that the gallery will start appearing on your pages that date, it only acts as a holding value. Any scheduled gallery will remain in the pool of available new galleries until at least their scheduled date. Once their scheduled date arrives, they might be selected for display or they might remain in the pool of available new galleries for several days, weeks, or longer. This gives you the ability to import a large batch of new galleries, but at the same time tell the software not to start using them until a specific date.

Applying Image Filters

If you find a preview thumbnail that you want to make a quick adjustment to (sharpen, brightness, etc) you can click directly on that thumbnail to bring up the filter interface. Each of the options in the filter interface is described below.

Important Note When you are done applying filters and are satisfied with the final result, be sure that you press the Save Changes button. This will tell the software that the image you are currently viewing is the one you want to permanently save for this gallery. If you do not make any changes or do not want to save the changes you have made, press the Cancel button. When working with the filtering options, make sure that the new version of the image loads completely before you begin executing the next command. It may take a few seconds for each filter to be applied, so please be aware of that when working with the filter interface.

The Green Colored Links

Clicking on any of the green colored links will apply that value to every gallery on the current page. For example, if you want all of the galleries to be in the same category, find a gallery with the category you want and then click on the green Category link. This will set the Category for all other galleries on this page to the category of the gallery whos green link you clicked. You will need to press the Process Changes button after you do this to update the database with the changes.


To delete a gallery all you need to do is click on the delete link (F) for that gallery. A pop-up window will appear confirming the deletion. Once the gallery has been deleted you should rebuild your pages to ensure that it is no longer being displayed.

Deleting Multiple Galleries

To delete several galleries at once, put a check in the checkbox next to the ID number of all the galleries that you want to delete. Scroll to the bottom of the page and you fill find a button labeled "Delete Selected". Press this button to delete all of the galleries that you have selected.

Quick Tasks

When you click this link a small window will pop up with three boxes inside it. You can perform a search and replace, a search and set, or a search and delete on all of the galleries in your database. There are some special search and replace terms you can use in this interface: To do a search and replace, enter the text you would like to search for and select which field should be searched. You will then need to enter what the replacement should be. For example, if you wanted to change to in every gallery URL, you would enter in the Find field, select Gallery URL for the in field and in the Replace With field.

To do a search and set, enter the text you would like to search for and select which field should be searched. You will then need to enter the field that should be updated and what it should be set to. For example, if you wanted to locate all galleries with platinumbucks in the URL and set the Sponsor value to PlatinumBucks, you would enter platinumbucks in the Find field, select Gallery URL for the in field, select Sponsor for the Set field, and enter PlatinumBucks in the to field. Note that this does not do replacements, but instead sets the field to the value you enter.

To do a search and delete, all you need to enter is what you want to search for and in what field. Any galleries found with that information will be deleted. For example, a quick way to delete all of the galleries in your database is to enter http:// in the Find field and select to search in the Gallery URL. This will delete any galleries in the database that have http:// in their URL, which should be all of them.