Using the Database

July 10th, 2009 | Categories: Advanced Tutorial, Chameleon TGP/MGP Submitter

Summary overview of all sites in the database with search by several criteria simultaneously. Sites can be added/edited/deleted using the context menu. You can also add/edit/delete your own groups in the database and move sites among them.

TGP/MGP Database

TGP/MGP Database

The database of all sites can be accessed by selecting Show in the Database Menu (Database > Show).

The table which is displayed (using the default Group -all-) contains all sites in the database and the most important details on each. The following site types are available:
TGP – Site accepts only picture galleries;
MGP – Site accepts only movie galleries or mixed galleries;
TGP+ – Site accepts both picture and movie galleries; or mixed galleries.

  Site is enabled to generate;
  Site only accepts partners;
Only manual submit is allowed for this site;
Site does not accept galleries located on free hosts;
Submit to this site by sending an e-mail;
Site is locked for Database Update;
Site wasn’t auto deleted during Database Update;
Site requires 2257 info;
Site requires big image URL;
Site requires sample thumbnail;
Site requires a reciprocal link if any of the following characters are present:
T (Text) Site requires text-based reciprocal link;
B (Button) Site requires graphical reciprocal link;
H (HTML) Site requires HTML-formatted reciprocal link.

 

Add/Edit/Delete/Clone Site:

To review or change the settings for any site, double-click on its row or right-click your mouse to open a context menu and select Edit Site. The Site Details dialog is opened, displaying information about the site.
Using the same context menu, you can add new sites (Add Site) or remove them completely from the database (Delete Site).

If you wish to add a new site to the database with settings similar to another site already present in the database highlight its row and click on Clone Site in the context menu. Subsequently modify Site Details for the new site (Main URL, etc.).

Search:

You can use the Quick button to find a particular site in the selected group quickly. Enter a part of its name or main/rules/submit URL in the appropriate box.
The Quick button can also be used to search for sites according to your own keywords used in Notes.

Click on the Advanced button to open the following dialog if you wish to select sites according to several criteria at once:

Advanced Search

Advanced Search

First, select a group from the Search in Group list, which contains the sites to be searched.

Next, only select those attributes which the site MUST accept. If you leave any of the items unchecked (or 0), it will be ignored in the search.
Note that if needed, you can select several categories/types at once (by holding CTRL or SHIFT keys) in Accepted Categories/Movie Types.

Press Search as soon as you finish the selection.
The sites which meet the search criteria are automatically loaded into the table in the database.
If you wish to add more sites searched by different criteria or from a different group, follow the same procedure but check the Add Results box before clicking on Search.

Note: The sites found are only placed in the db table temporarily! If you want to work with them as a group we recommend to copy them into a separate (existing) group.
Highlight all sites and choose Copy to > group name from the context menu.

Using Groups:

The -all- Group contains all sites in the database and is used to generate sites in Step 3 by default.
If you only wish to submit galleries to the sites you selected, create your own group(s) containing only these sites. Before generating the sites for submit in Step 3 select its name from the list.

Create your own group(s) by clicking on the New Group button. Enter the name in the dialog (max 30 characters). Click on OK to add this group to the group list.
Delete an unused group by highlighting its name in the list and clicking on Delete Group.

Highlight those site(s) you wish to copy to the new group (use CTRL or SHIFT key to select more sites at once). Right-click to open the context menu and choose Copy to > new group name. The selected sites will be copied to this group.

In this way you can create as many groups as you need. You can edit/delete them and copy/move/remove the sites they contain.
The only exception is Group -all- which contains all sites in the database. This group cannot be deleted and sites cannot be moved to other groups (i.e. only copying is permitted). Deleting a site in the -all- group removes it from all other groups.


Tips & Tricks:

  • The sites in the database do not need to be edited manually, we will do it for you! Just run Database Update (Database > Update) and the sites will be updated automatically.
  • If you use automatic Database Update we DO NOT recommend to delete sites from the -all- Group; otherwise you risk that they will be added during the next update. If you want to make sure that these sites are not generated in Step 3, we recommend to deactivate them (Disable to Generate) in Site Details.
  • If you wish to enable/disable generating of multiple sites at once, or lock/unlock them for automatic updates en bloc, highlight their rows and select the appropriate command in the context menu under Selected Sites (Selected Sites > Lock Against Update/Unlock/Enable to Generate/Disable).
  • The rows highlighted in pink mean that the sites only accept partners but required authorization data is missing (your login, password, etc.).
    If you have a partner account, enter the required information (see notes) in its Site Details.
    If no, the site(s) will be skipped when generating sites in Step 3 unless you enter your account information.
  • To make sure that the site you are about to add is not in the database yet, use the Quick Search button to search the database for its URL.
  • For fast searching you can use the Ctrl+F key shortcut. When searching for an expression, make sure you are positioned in the column where the expression is to be found. If you want to search for the site name, click anywhere in the Site Name column, press Ctrl+F to open the search dialog and enter the search expression.
  • If you wish to sort any of the table columns alphabetically or by type, click on its title or icon in the table header.
  • The only editable item in the table are Notes. You can enter/edit/delete your own notes on the sites by clicking or double-clicking in any row in the Notes column. This can help you when sorting sites by these notes or for quicker site searches using the Quick Search button.
  • If you want to search for sites which accept ONLY some niches (e.g. pure Gay sites, pure Anime sites, etc.) then check Accepting only these categories and select ALL possible categories corresponding to this niche which the site might accept. The search will only find those sites which accept the selected categories (at least 1) and no others. The Site Accepts Only option has a similar function.
  • If you want to search for sites which only accept partners, check Required in Partner’s Authorization. If you only want to search for sites where you have an active partner account, check Approved Partner.
  • If you want to select those sites which are in some other group (except for the -all- Group), select the desired group from the context menu (in Select sites also found in). You can then work with the selection, e.g. delete it from the group, move it etc.
  • You can change the name of the group you created at any time by overwriting it in the Group menu.
  • If you wish to add your own site to your group, select the group from the list, right-click anywhere in the table to open the context menu and select Add Site. Continue by entering the necessary data in Site Details.
    Note that the site will be automatically added to the -all- Group which contains ALL sites in the database.
  • If you wish to remove site(s) ONLY from your own group, select the group in the list, highlight the site(s), right-click to open the context menu and select Remove Site.
  • You can edit sites from any group. Site info will be updated in all groups which contain the site.

No comments yet.
You must be logged in to post a comment.
TOP