Well Designed Scripts for the Busy WebMaster

GreatRatings Users Guide

Install Guide GreatWebBook

GreatRatings© Installation Manual



Table of Contents


Introduction. 1

Requirements. 1

Installation. 3

Upgrade. 5

Administrator Control Panel 6

Your First Test Drive. 14

Administrator Displays. 14

Standard User Displays. 18

Customizations. 22

Tips for Using GreatRatings. 23

Third-Party UMS Operations. 24

Installation. 24

aMember 24

phpBB.. 25

Builtin UMS Operations. 27

Tips on using the Builtin UMS. 32






Thank you for trying the GreatRatings® Internet Website Rating utility.  We believe you will find it to be a tremendous addition to your site by continually drawing traffic and generating user interaction with your website.


Installation of GreatRatings® is designed to be a quick 15-minute operation.  The setup screen allows you to customize the installation to your own tastes.  There is actually very little information that the script needs to run as most of the parameters are set to default values so you can get up and running very quickly.


There’s also a quick view section entitled Your First Test Drive, which will walk you through the various features.  We recommend this to all first-time users.




  1. A SQL database system, one of:
    1. MySQL (3.22 or higher)
    2. PostgreSQL  (7.1.x or 7.2.x)
    3. MS SQL Server (7 or 2000)
    4. Microsoft db2
  2. PHP (4.3.1 or higher recommended for security, but above 4.0.3 will suffice).
  3. A UMS (User-Management System) which allows the system to uniquely identify a user is also required, although a builtin UMS is supplied with GreatRatings.  Supported external UMSs are:
    1. Builtin: a fully functional embedded User Management System
    2. aMember Pro® (CGI-Central) []
    3. phpBB® Bulletin Board []

(Additional UMS integrations are available at a modest fee)



If your hosting account does not meet the requirements above, GreatRatings cannot be installed on your account. 


You will also need access on your local machine to an archival utility such as WinZIP or WinRAR to extract the product files, and an FTP Client such as FileZilla or FTP Commander to place the files on your webhosting directories.


There are two embedded UMS available: the default UMS that has a single, administrative user that is intended for initial testing only so webmasters can get a working demo up quickly.  The default UMS (not builtin) is not intended nor sufficient to use as a production system! 


By contrast, the builtin UMS is a fully functional embedded User Management System supplied with the script.  You should either use a plugin that is compatible with your existing site UMS or use the builtin UMS.  If you are intending to use the builtin UMS, please review the Section Builtin UMS Operations at the end of these instructions.



Before continuing, you need the following information in hand:

  1. The database type (MySQL, Postgres, etc) your webhost provides;
  2. A username to that database, with create/drop/insert/delete privileges;
  3. The password to the username account;
  4. The Host where the database server resides.  This value is typically localhost, but check with your webhosting company if unsure.




This section details how to install Ratings if you have never installed a copy on your site before.  See here for upgrade instructions if Ratings is already installed and you are trying to upgrade to a later version.


  1. FTP all files to your host into a UMS-protected directory /ratings. (Note: Your UMS may require the files to be placed below a specific directory in order to be protected from unauthorized access; if so place the files in that directory but within a /ratings subdirectory)
    1. All .php, .sql, .txt and .htm files should be uploaded in ASCII mode, while all graphics should be uploaded in BINARY mode. If you are unfamiliar with what this means please refer to your FTP client documentation. In most cases this is all handled transparently by your FTP Client but if you have problems later you should be sure the files where uploaded correctly as described here.
  2. Sign into your UMS (if you have one), as an Administrator and ensure your UMS reports you as an Administrator.  If you do not have a UMS, refer to the section Built in UMS Operations.
  3. Run the installer by pointing your web browser to


You should see the Ratings Installation Script Display (Figure 1: Script Initial Display) below appear.


The First Step is to select the database type (also referred to as DBMS, Database Management System) your web hosting provides.  If you do not know the database type, contact your hosting company for details.


Step 2 is to provide the details of how to connect into the database; this includes the server where the database is installed, the username and password, and the name of the database to use.


The Final Step is to identify the UMS (User Management System) you intend to use.  You must be signed in with an account that the UMS reports as an Administrator.


When completed press the Submit Button.  The installation script will create and populate the necessary tables and create the configuration file.  The installation status is displayed in the top window, along with any suggested changes.  If any errors are detected, correct the problem and press the Submit Button again.  When the installation parameters are correctly configured, you will see the following status window (Figure 2: Successful Installation Display):



Figure 1: Script Initial Display




Figure 2: Successful Installation Display


This indicates the installation was successful, and you can now select the Setup Options you wish to set.  Select the link under “Please go to this page and complete the setup”, and you will see the Configuration page display.




This section details how to upgrade to a later version of Ratings from an earlier one.  It assumes Ratings is already installed and working at your site.  See here for information on how to install Ratings if you do not have an earlier version installed.


Before starting, backup your data, including the php files, and especially the data from the database.  Reference your web hosting provider documentation for steps on how to backup your database.


  1. Backup your data!
  2. Unzip the archive to your hard drive
  3. FTP the files up to the Ratings directory on your web host.
  4. Point your browser to http://<sitename>/ratings/install/install.php.
  5. Under the database section, if there is a ‘LoadDB’ button select it to update your database.
  6. Select the link under “Please go to this page and complete the setup”, and review the parameters to ensure they are customized to your desires (reference next section).



Administrator Control Panel


The Administrator Control Panel allows you to select various parameters that affect how GreatRatings® works.   The Control Panel can be run anytime you want to update your selections.  When you first enter the Panel, you are presented with the Reviews display (Figure 3: Administrator Control Panel Initial Display), which lists the Site Ratings you have created.



Figure 3: Administrator Control Panel Initial Display


The options are split into six tabs: 


  1. General: customize overall system parameters.  It is recommended you review and set these according to your site needs.
  2. SPAM:  Set parameters defining the security and SPAM fighting aspects of the script, applied when users submit comments.
  3. Reviews:  This is the tab you open to be default, and is displayed in the Figure above.  It enumerates all the defined site rating reports.
  4. Requests: This window allows you to review and handle user submissions of site suggestions for review.
  5. Categories: Lists the categories for site reviews defined in the system.
  6. Logs: Lists special or unusual events that occur.
  7. License: Provides information about your license.


You will also notice a yellow message box indicating that the installation scripts are still present on the site.    In all cases, before you allow public access to GreatRatings, ensure you delete the installation scripts.  Leaving the scripts in place with a production system is a very serious security issue.  (If you decide you need the installation scripts after deletion, simply upload that install/ directory via your FTP Client).


The top menu bar of Logoff, Change Password, etc are present if you have selected the Builtin User Management System (UMS).  If using the builtin UMS, reference the section on the BuiltInUMS for details


Select the General tab and your display will appear similar to Figure 4: Setup Options – General Tab (part 1) below.  This tab defines the overall settings for your site, and describes how the pages look.


The parameters are color coded to prompt you in making updates: green items can be freely changed; yellow items affect the security or workings of the program and you should consider carefully before changing; and red items should not be adjusted without GreatWebScripts support. The name of each item and a description of the effects of that item are listed.  You should review and modify each entry as appropriate.


Some of the items you’ll want to customize are:


General Tab:


  1. Site Title: The name of your site, displayed at the top of each page.
  2. Site Subtitle: Use this as a caption or banner for your site if you want.
  3. Site Notice: This is designed to be a small, transient notice you can display to alert your visitors of any special conditions.
  4. Server Time Offset:  First, ensure the Timezone Setting from your UMS is correct, then set this value so local time display is correct.   This offset affects the display of timestamps recorded in the Activity Log.
  5. Admin Email: indicate the email address where GreatRatings should send email notifications.
  6. Logo Image: Allows you to place your site logo at the top of each page.


The other parameters on the page can be reviewed and changed as desired; ensure you understand the meaning of each item before updating (especially the yellow and red items!)



Select the SPAM tab and your display will appear similar to Figure 6: SPAM Tab (part 1) below.  This tab defines the overall settings for your site, and describes how the pages look.





  1. Anti-SPAM Verification Method: This specifies how to avoid SPAM-bots from trashing your site via the comment form.  It requires a challenge /response such that you can ensure the typist is a human and not a bot.  We have found that the Text feature is sufficient to stop 99% of the bots
  2. Akismet Key: A free service that you sign up for that tests each user comment for SPAM.  It catches most (but not all) SPAM.
  3. SPAM Words: If your site becomes the target of a persistent SPAMMER, you may have to add words here to prevent his specific attack.
  4. Filter Words: Here you can enter a list of words that should be filtered out from entries.  The format for entering is word:replacement, where each occurrence of word found in the entry is replaced by replacement.  If you do not specify replacement, the word is replaced by its first letter plus dashes (so banana would be replaced by b-----).
  5. Filter Word Action: This indicates what to do when a Filter Word is encountered: Replace it with the replacement text specified as above; Delete it with no replacement; or Reject the entire entry and make the user correct it.


License Tab:


The license tab allows you to verify and review your licensing status for the product.



Reference the Online HELP display for more detailed information about the remaining settings.


Figure 4: Setup Options – General Tab (part 1)


Figure 5: Setup Options – General Tab (part 2)

Figure 6: SPAM Tab (part 1)

Figure 7: SPAM Tab (part 2)




Figure 8: License Tab


Your First Test Drive


OK, you installed Ratings, created your own account, and configured it, – now what can it do?  Here’s your introduction to the product.


Administrator Displays


First we’ll review the displays that are available only to the Site Administrator, not to general users.  In the next section we will review the Standard User Displays available to all users.


If you have not signed in as Administrator, do so now, and move to the Administrator Control Panel.   If you are at the user displays, press the ‘Administrator Options’ icon at the upper right of the table.  In either case you should be at the Administrator Control Panel as shown in Figure 9: Administrator Control Panel.



Figure 10: Administrator Control Panel



This is the Administrator Control Panel, Review Tab.  It lists all the reviews you have created.  If you have not added any new reviews, the GreatWebScripts is the only review listed.  The   shown means the display is visible to all users; press it once to make the display hidden from all users (and the icon changes to ).  Press the  icon to edit the review. You could (but don’t – yet) press the  to delete the review. 


The ‘Add’ button is used to add a new review.  Press it now to add a new review, and a display similar to Figure 11: Review Addition will appear.


This is the display where you add a review; complete the Site Name, URL, Category, Site Description (main text of the review), and your Likes and Dislikes.  You also place the website into one of the defined categories.  The icon row is where you indicate various features of the site.  Several of these are subjective; as you review more and more sites you get a feel for a range.


You then rate the site on the various criteria.  The Overall Rating criteria is color-coded to remind you that it drives theand  icons on the main window.  Press the Save button to save off the review – remember if the visible icon above is set, the review is immediately visible to your readers.


The last Admin display to discuss is shown in Figure 12: Review Addition, which your readers use to request you to review their favorite website.  In the example shown, the website is named The Straight Dope, and the review was requested by a Member (due to the red ‘M’) Michael. To view the entire request form, press the View button and the display shown in Figure 14: Website Review Response appears.  Here, you respond to the reader request – either an Accept (after the Review is written), a Reject, or a Delete.  The Delete button deletes the review without notifying the requestor.


Figure 12: Review Addition


Figure 13: Website Review Response




Figure 14: Website Review Response

Standard User Displays


The displays in this section are available to all users.  The previous section dealt with the screens that are available only to the Administrator.


In order to fully appreciate what your users will see, you first need to signoff.  This allows you to view the Ratings from a standard, non-member view.  We’ll point out the differences between members and non-members as we go; as a non-member you’ll actually see the additional fields rather than have us describe them.


Proceed to your website URL with the /ratings at the end.  This will place you at the Review Table (Figure 15: Review Table) window, which is the main display for standard (non-Admin) users.



Figure 15: Review Table (Main User Window)


If you have not made earlier updates, there will be one review in the table, that of  Since there is only one review, many of the navigation buttons do not actually change the display; as you add site review you can see them work.  On the other hand, we think the navigation system works exactly as you would intuitively expect, so wouldn’t be much to say anyway!


GreatRatings has an extensive context-sensitive built-in HELP system accessible via the HELP button, which we encourage you to use frequently.  In this overview, we will walk you through the major functions of the display; for more in-depth details reference the HELP system.


Let’s quickly review the navigation controls.  The Page buttons move to individual groups of displays as more are added.  The Search field allows the user to specify keywords that search the review text, likes, dislikes, and comments.  The Category field allows the user to specify only groups of reviews.  Pressing a letter searches for sites whose names start with that letter.


In the review panel, the name and URL of the site are displayed.  Icons indicate specific functions of the site:  in this case, the site is worthy of a bookmark, and is a Cool site.  The next area displays the first line of the site review (in this case, “A Great Place for Scripts …”).  Below that is the rating for the site as supplied by the site reviewer (you).


The next row displays information related to how often the reviewed site is visited by someone who read the review.  The first section, Visits, refers to the total count of valid times the URL link was followed (This is a reference for the meaning of ‘valid’ in the previous sentence).    It is divided between visits by members and those by non-members.  The next section details the overall Score of the site, and the last is its Popularity.


To read the entire review, select the ‘Read Full Review’ link and you will be moved to display Figure 16: Full Review. 


The Full Review Display is the complete display of the review selected from the Review Table.  The top third of the display is objective information about the site (URL, review date, Site name).  The middle portion is the site overall rating and rating in specific areas of usability.  The last portion is the text written by the reviewer, detailing specifics about the site, what the reviewer liked and disliked.



Figure 16: Full Review


The last panel of the Full Review are the User Comments- this is where the feedback from users who read the review is displayed.  Users can provide their own comments and ratings by pressing the Comment button leading to Figure 17: Add Comment.


The only other field that needs explaining is the Security Code field; a unique code is generated for each entry; the users must supply that code when completing the form to prevent SPAMBots from auto-filling comments.  (Note that you can see the length of the field, or disable it, via the Security tab on the Setup Display). You can also convert this field to an image to prevent SPAMMER from reading it directly and filling it in.


Note that signed in Members will not get the Security Field; since they have been preapproved during the membership activation process.


Figure 17: Add Comment





In the custom directory of Ratings you will find two files named ratings_header_panel-dist.php and ratings_footer_panel-dist.php. Use them as a template to create a header and footer for each page of the game (perhaps to use as an advertisement or special notice).


To create the header or footer panels, copy ratings _header_panel-dist.php to ratings _header_panel.php and/or ratings _footer_panel-dist.php to ratings _footer_panel.php, and then make any updates in the copied files.  You may use standard php or html in the files.


Lastly the ratings.css file contains the CSS commands used to format the display. You will find many updates to Ratings to better harmonize with your site.  First, copy file ratings.css from into the custom directory before making your changes; this prevents a future software update of Ratings from overwriting your changes.  If file ratings.css is found in the custom directory, it is loaded when the script runs (and overrides the values specified in the distribution file).


Tips for Using GreatRatings


  1. Review the Transaction Log periodically to see if entries are being rejected and the reasons why.


  1. If you add words/phrases to your SPAM lists that work well, please notify GreatWebScripts so we can add it to later revisions!


  1. Javascript: For security reasons, many users disable Javascript while browsing the web.  GreatRatings was designed to not require Javascript enabled to function.  As such, only the ‘extras’ require its use.  If a visitor does not have Javascript enabled while viewing the guestbook, the following anomalies will be noted:
    1. The popup ballon help (from the [?]) will not work.





Third-Party UMS Operations


This section details how to work with a third-party UMS and Ratings.  Ratings works by querying the UMS as to the current user’s name and userid.  The UMS should provide a unique userID for eac user; the userID is stored when the user interacts with the game.  Then the game queries the UMS to determine the username for each userID it encounters to make it more presentable to the human player.


Ratings ensures that the UMS unique userID is set before allowing a player to interact; if not set he is prompted to log into the UMS first.




This section describes how to select and install a UMS during the installation process.   The installation follows a standard model:

  1. If the UMS has a method to indicate whether an account is a privileged user, that method is employed to indicate the user is a Ratings admin; otherwise the UMS is extended to provide such a notice.
  2. Using the method identified or created in Step #1, add/modify an account to have Ratings Admin privileges.
  3. Sign in to the Ratings Admin account.
  4. Run the installation script, and select the desired UMS.
  5. Enter/change any parameters needed for the UMS.

For virtually all UMSs, the Ratings Admin is distinct from the Site/UMS Admin, so you can add as many Ratings Admins as desired, without giving them overall site Admin powers.




To install the aMember UMS, follow these steps:

  1. From the aMember Control Panel, create two new fields for aMember:
    1. admin: Checkbox field; is set if user is admin.  This field is NOT available for the standard aMember User to set / review; it should only be set via the aMember Control Panel. Set it if the user is an Ratings administrator in your system.

Field Name: admin

Field Title: Administrator (whatever)

Field Type: Common field

SQL Field Type: Blob

Display Type: Checkboxes

Field Value: administrator|Administrator

Visibility: Display in signup / profile: Don't Display


    1. timezone::  Pulldown field for user to set his local timezone so datetimes are displayed in local zone.

Field Name: timezone

Field Title:  Timezone (whatever)

Note: If you do not create the timezone field, all times will be set to your server's time zone.


  1. From the aMember Control Panel, check the 'admin' box for one of the aMember users you want to be a Ratings Administrator
  2. Sign in to aMember using the account you set in Step #2.
  3. Run the Ratings installation script: at
  4. Under the UMS Parameter Section, select 'aMember' and press the Submit button.
  5. Verify the fields under the UMS Parameters Section:
    1. AMEMBER_DIR: aMember Root, typically /amember/.  The aMember configuration file should reside there
    2. AMEMBER_ADMIN_FIELD: The name of the Admin checkbox you created in Step a.
    3. AMEMBER_TIMEZONE_FIELD: The name of the Timezone field you created in Step a.
  6. When the fields are correct press the Submit button.




1.      If you get an error that you are not signed in as an Administrator,

ensure the aMember account name you are signed in as has the "admin” box that you created checked.  (Note: You can only set this via the aMember Control Panel).  








To install the phpBB UMS, follow these steps:

1.      phpBB contains a setting indicating if the user is an Admin; that same setting is used by Ratings.  If the account is an Admin for phpBB, he is also an Admin for Ratings.

2.      Sign using an Admin account you set in Step #1.

3.      Run the Ratings installation script: at

4.      Under the UMS Parameter Section, select ‘phpBB’ for phpBB v2 installations or ‘phpBB3’ for phpBB v3 installations.  Press the Submit button.

5.      Verify the fields under the UMS Parameters Section (In general, the defaults should be correct):

    1. PHPBB_COOKIENAME: Cookie used to store login information.
    2. PHPBB_SIDGETNAME: Parameter used to pass phpBB SID via URL
    3. PHPBB_TABLEPREFIX: phpBB Tablename prefix
    4. PHPBB_DBNAME: The database that phpBB uses, if different from the one used by Ratings.

6.      When the fields are correct press the Submit button.

7.      Under the UMS Setup Display from the User Menus are several other options unique to phpBB.




  1. User Login Requirement: Determines whether users have to sign in or not to view the ratings:
    1. Optional (default): The user can view the ratings with no sign in and register comments.
    2. Required: The user must sign in even to view the ratings.
    3. Not Available: No users may sign in.

(Note: if you set this flag to Not Available, there is no login box available so not even the Administrator can sign in.  To sign back in as an Adminsitrator, navigate to ratings_index_admin.php

to obtain a signin prompt.


  1. Allow User Registration: Setting this to Disabled precludes users from creating new accounts, in which case an Admin user must create all accounts.  If new user registration is enabled, a Register link is displayed at the Login Prompt

Note: This setting affects only the display of the link; if you want to permanent disable registrations, you must do so via the phpBB Administrator Panel.

Normal State: Enabled.


  1. Allow Reset Password: When Enabled the user can request his password be reset and emailed to him at his registered address.  This displays a “Forgot your Password?” link at the Login Prompt

Note: This setting affects only the display of the link; if you want to permanent disable registrations, you must do so via the phpBB Administrator Panel.

Normal State: Enabled.


  1. Display Forum Link: When Enabled a user will have a ‘Forum’ selection in the top row UMS banner.

Normal State: Enabled

Builtin UMS Operations


The builtin UMS is a complete UMS that you can use if your site does not have an existing User Management System.  It allows for three levels of users, which determine the amount of changes an individual can perform.  User authentication is provided by a password of selectable length.


The builtin UMS is a fully functional and automated UMS. It has the ability to require a valid email address by sending the initial password; to allow a user to retrieve a forgotten password via email address; and to allow users to register a new account.


There are three types of Users:

  1. Root Admin: The superuser in charge of all other users.  He can add, modify, delete, or promote any other account.  Only the Root Admin can promote (or demote) any User account to Admin status. There is only one Root Admin account, created at Installation.
  2. Admin: Admins are in control of the game functions.  They can adjust the parameters of the game, move the photos, edit the user inputs, and all the other functions of “Administrator” in the game writeup above.  You can have as many Admin accounts as you want. (The Root Admin is also an Admin).
  3. User: Users are the standard players.  They can enter captions, vote, and all other non-Administrator functions. (The Root Admin and all Admins are also Users).


When you install GreatRatings, you will be asked for your UMS.  If you select builtin and press Submit, the following fields will be available for you to fill in:



Figure 18: UMS Parameters



The fields you need to supply are Administrator Username, Administrator Password (twice), and Timezone.  The Administrator Username is the Root Admin account.  The Timezone field is used to adjust the Activity Log times to local time. 


Once you complete the fields and Submit, you can access the Setup Options Page.  You will notice that you first need to login to the UMS.


Figure 19: Login Prompt Display


Enter the Root Admin Username and Password as you supplied on the installation script.  You will be logged into the UMS, and placed at the Setup Options Page.


The page is identical to that described previously, with the addition of a band of options for the UMS.



Figure 20: UMS Band


The band of commands at the top allow you to control the User Management System.  The functions are:

  1. Logoff: Sign off the UMS.  You will have to re-enter your username and password to get back into the system.
  2. Change Password: Allows a user to change his password (and the Root Admin to change his login).
  3. My Account: Allow a user to change his account information (email, timezone).
  4. Manage Users [Admin]: Allows the Admins to add, modify, and delete other users.  The Root Admin can promote other users from this display.
  5. Activity [Admin]: Allows the Admins to monitor the activities of the UMS.
  6. UMS Setup [Root Admin]: Allows the Root Admin to setup the parameters of the display.


We’ll more closely examine the major displays of Manage Users and Activity Display.  An example of the Manage Users, reached by selecting the Manage Users from the menu band is below:



Figure 21: Manage Users List


Figure 21: Manage Users List shows the users defined in the System.  The current user is highlighted in yellow.  The Username, UserID (assigned automatically by the UMS), IP of signup, Email are all displayed, along with an Admin defined comment and date of account creation.  There are four operations permitted for each user:

  1. The status of the user is indicated by a redlight/greenlight icon; a  indicate the user is Active and may log into his account; a  indicates the user is Inactive and may not signin. The  indicates the user is Pending, meaning you have required Email Validation at registration and the user has not yet signed in.  As soon as the user does sign in, his status will switch to Active.
  2. The rank of the user is displayed via icon; a  indicates the user is an Admin, while a indicates the User is at the User level.
  3. The red ‘X’  is selected to delete the user;
  4. The green ‘E’  will allow an Admin to edit the user account to modify his account data and/or the account password.
  5. Pressing the New Button allows the Admins to create new users.

There is a restriction that one Admin account cannot modify any other Admin account – only the Root Admin can modify other Admin accounts.


Finally, Figure 22: Setup Display is the UMS Setup Parameters display, accessible only to the Root Admin.



Figure 22: Setup Display


Most of the entries are self-explanatory.  Several to pay special attention to are:


  1. Enable Game: Setting this to Disabled signs-off any players, and does not permit anyone except the Root Admin to sign on.  This is used if you need to perform maintenance on the site and do not want your users to log in. 

Normal State: Enabled.


  1. Allow User Registration: Setting this to Disabled precludes users from creating new accounts, in which case an Admin user must create all accounts.  If new user registration is enabled, a Register link is displayed link at the Login Prompt (Figure 19: Login Prompt Display).

Normal State: Enabled.


  1. User Address Information: Set this to Required to force new users to enter some text for address information (which of course is not verified), or Optional to allow the user to enter address information, or None to not display the address fields.

Normal State: None.


  1. Allow Reset Password: When Enabled the user can request his password be reset and emailed to him at his registered address.  This displays a “Forgot your Password?” link at the Login Prompt (Figure 19: Login Prompt Display).

Normal State: Enabled.


  1. New User Initial State: Setting this to Inactive means that when users create a new account, they cannot sign in until an Admin approves the registration.  If set to Active, users can sign in and play as soon as they register. When set to Require Validation the user’s initial password is randomly generated and emailed to him at the address he registered. 

Normal State: Inactive.


Tips on using the Builtin UMS

  1. If you have not had any spammers or troublemakers visit your site (you’re lucky!) you can set the New User Initial State to Active to allow new users to register quickly.  If you get too many troublemakers, you will have to adjust it back to Inactive.
  2. In general, once a user has been playing the game DO NOT delete his account, even if he is no longer playing.  If you delete the account, the photos he uploaded, his captions and his votes all become ‘orphaned’ such that the system cannot determine the player’s name. Instead of deleting the account, just set it to Inactive.