Installation

StartOff Tips

  1. When you upload and download files use an ftp program like FileZilla, ws_ftp or cuteFTP and ALWAYS transfer the files as ASCII.
  2. All filenames are lower case. Insure that this does not change.
  3. When configuring any of the files or when you change the template files we highly recommend using a text or HTML coding editor. If you do use a word-processor then make sure you save the files as ASCII.
  4. This program works with mySQL. We recommend you install also a SQL Manager. We recommend mysqlman created by Gossamer Threads.


Installation SQL QuickRegister

Please read the instructions first before implementing them. To assist in your installation we have added checkboxes at each step which you can use to track that everything has been done.

The links on the left called Files describes the application files and their permissions.

  1. Unzip Files on Local Machine
    Unzip sqlquickregisterv6_0.zip in a directory called quickregister. (The zip files have been created on a Windows NT workstation and so should be unzipped on a windows local computer and then uploaded to the server using ftp.) .

  2. Perl Path
    The perl path defined at the top of each script is #!/usr/bin/perl . If the path to the perl program is different from this then change the top line in all the scripts.

  3. Configuring Referers
    A parameter called @referers found at the top of the script genlib.pl defines what domain names and/or IP addresses are allowed to access the program. It is essential that you set this perl array otherwise one receives an error called Security Violation. If you are using the PayPal module then be sure to include paypal.com as part of this list.

  4. Open Up startup_quickregister.pl in a Text Editor to Configure Hardcoded Parameters
    1. mySQL Parameters Set the following 4 parameters:
      1. $config{'database'}='quickregister'; This is the default but you may have to change it to the name of the database assigned to your account by your web host or administrator.
      2. $config{'server'}='localhost'; This is the server name for the mySQL. Note many installations use just localhost as the default name especially if its your own server. If you are virtually hosted then you need to get this information from your hosting company.
      3. $config{'username'}='yourusername'; Set this to the mySQL username setup for your account or which you setup for this application.
      4. $config{'password'}='password'; Set this to the password associated with the username.
    2. Administrative Passwords
      1. $config{'adminuser'} = 'admin'; This is the username to get into the adminstrative interface.
      2. $config{'adminpassword'} = '123454678'; This is the password to get into the adminstrative interface.
        Its imperative that you change both the adminuser and the 12345678 password. A good password is at least 12 characters and is composed of a random selection of upper and lower case characters, and numbers. To generate a true random password visit our Password Generator site GoodPassword.com .
    3. Path Definitions
      In the current version the Path Definitions are automated by using the CGI environment variables: SCRIPT_FILENAME to find the cgi-bin, DOCUMENT_ROOT to extract the document root and HTTP_HOST to extract the domain name. If this does not work then you may have to hard code the Unix paths in the file called startup_quickregister.pl. Instructions are inside the script if you need to do this.


  5. Configuring the cgi-bin Path in Templates and Data Files.
    CGI scripts are called either from an HREF or a <FORM ACTION .. tag. The default cgi-bin name used is cgi-bin. Some web-hosting companies may use a different directory name for the cgi-bin such as cgi-local or pcgi-bin etc... If this is the case you will need to adjust all the templates to modify the path to the cgi-bin in each HREF and <FORM ACTION .. tag. Also a few configuration parameters will need adjusting which can be done from the Adminstrative Web Panel.



  6. Create Directories, Upload Files to the Server and Set File Permissions
    1. Expresss Upload
      If you are good with your ftp program then you can upload the folder quickregister on your local machine in one go. This will include all subfolders and corresponding files.

    2. Create Folders Create the following under the cgi-bin the following directories:
      1. /cgi-bin/quickregister/scripts
      2. /cgi-bin/quickregister/data
      3. /cgi-bin/quickregister/data/error
      4. /cgi-bin/quickregister/templates
      5. /cgi-bin/quickregister/templates/mypages
      6. /cgi-bin/quickregister/templates/groups


    3. Upload Files To Server
      Upload the files unzipped on your local machine to their respective directories on the server.

    4. File Permissions
      1. Scripts run under user click here
      2. Scripts run under the userid of the web server: click here


  7. Creating SQL Database and Tables
    1. SQL Database
      Create a new SQL database called quickregister OR use the database that has been assigned to your virtual account from your web hosting company.
    2. SQL Tables The SQL tables and their default field definitions are defined here.
      1. Copy and paste the following link into your browser window: http://www.yourdomain.com/cgi-bin/quickregister/scripts/mktable.cgi and replace yourdomain.com with your domain.
      2. Delete mktable.cgi from the server once the tables are created.
    3. Add fields to register table
      register table has 10 additional fields which you can use in your forms. They are called description1 ... description10. If one requires additional fields simply add them after description10. The quickest way to do this is to modify the cgi script mktable.cgi and re-create the tables otherwise use a MySQL Manager like phpAdmin to change the tables directly. For further information click here.


  8. Configuration of the Application Parameters
    Follow these steps carefully.
    1. Rename the file admin_menu_install.htm to admin_menu.htm. This admin_menu_install.htm has the access links to the following 4 configuration files:
      1. config.txt - general configuration file
      2. register.txt - configuration file for the registration
      3. messages.txt - all messages used in the system
      4. paypal.txt - paypal configuration file
    2. Copy and paste the following link into your browser window:
      http://www.yourdomain.com/cgi-bin/quickregister/scripts/admin_command.cgi
      replace yourdomain.com with your domain and bookmark this url.
    3. Enter your username and password.
    4. Proceed to update the parameters. Read carefully the descriptions of each parameter.


  9. Application URL
    http://www.yourdomain.com/cgi-bin/quickregister/scripts/command.cgi?action=3

  10. Adminstrative URL
    http://www.yourdomain.com/cgi-bin/quickregister/scripts/admin_command.cgi

  11. Setting up the Templates.
    Once the application is working you can then proceed to modify the application templates to incorporate the look and feel of your web site. The templates are listed here.
    SQL QuickRegister has a feature that allows the incorporation of a subtemplate of HTML code within a main template. Currently SQL QuickRegister uses the following subtemplates in many of the main templates:
    1. header.htm - used as the header portion.
    2. footer.htm - used as the footer portion
    3. admin_header.htm - used as the header in all the administrative templates
    4. admin_footer.htm - used as the footer in all the administrative templates
    If one adds other subtemplates then one needs to update the parameter othertemplates under Edit Configuration Parameters.

  12. Optional Features To Implement
    2. Download Digital files
    3. Protecting any HTML Page Using a PHP Template
    4. Protecting any HTML Pages Using a Redirect Script
    5. Setup Group Login Pages.
    6. Using the E-mail Address as the Userid
    7. Use Captcha to Stop Spam


  13. Final Steps
    WHEN EVERYTHING IS DONE AND THE PROGRAM IS WORKING IT IS ESSENTIAL THAT THE FOLLOWING DELETIONS ARE CARRIED OUT:
    1. DELETE admin_menu.htm but keep a backup on your desktop computer of admin_menu_install.htm for future need.
    2. RENAME admin_menu_original.htm. to admin_menu.htm. Note that admin_menu_original.htm does not have the links to the configuration parameter files.
    3. DELETE mktable.cgi, testmods.cgi and test.cgi .
Bytes Interactive<cgi@bytesinteractive.com>
 SQL QuickRegister - (c) Bytes Interactive 2002-2006