• Portable: no operating system dependent code;
• Quick and easy installation;
• Translatable into any language(100% Language independence);
• Fully customizable HTML;
• Easy navigation/interface;
• Resources Listing by Posted Date, Download count, Hits and Votes;
• Hits counting;
• Member review;
• Most Popular Listing;
• Top Rated Listing;
• Advanced Search capabilities;
• Sorting results by fields;
• Forgot password reminder;
• Email notification;
• Smart and Flexible Registration for Resource Authors;
• Email address confirmation;
• Edit and Delete Ads;
• Extendibility of the code;
• Full-featured administration;
• Advanced Security;
• Secure Password Generation;
• Email Validation;
• Bad word Filter;
• Countries List Editing;
• Cities List Editing;

   Installation:

4) Create a MySQL database (If you have an installed MySQL database and enough experinece in SQL you may pass this step).

The database needs a database-name, a username, and a password.
The database-name can be any name beginning with a letter, the username
should be your unix login name. The password must be different from all
other passwords in your system for security reasons.

If you have root access to the MySQL server then you can create the
database following these instructions:

   4.1. On UNIX prompt write:

      mysqladmin -uroot -p create YourDataBaseName
      (enter MySQL root password)
       

   4.2. On UNIX prompt write:

      mysql -uroot -p
      (enter MySQL root password)
       

   4.3. On MySQL prompt write:

      grant select, insert, update, create, alter, delete, drop
      on DATABASENAME.*
      to USERNAME@localhost
      identified by 'PASSWORD' ;
      quit
       

If you don't have root access then you have to ask the webmaster to
create a database for you. Just specify the database-name, username,
and password. Remember that the database password must be different from
your normal password.

5) Create database tables
There are two ways:
  - From the command line for your operating system, type

       % mysql YourDataBaseName < phpHotResources.sql
       

This will send the statements into the mysql client and create the tables for you. To verify that this was done correctly, go into the mysql client and see.

       %mysql YourDataBaseName
       

You should see

       Welcome to the MySQL monitor. Commands end with ; or \g.
        Your MySQL connection id is 2 to server version: 3.22.32
        Type 'help' for help.
        mysql>

now type
mysql> show tables;

and you should see the next tables listed

       +----------------------------+
        | Tables_in_YourDataBaseName |
        +----------------------------+
        | HR_authors                 |
        | HR_categories              |
        | HR_city                    |
        | HR_country                 |
        | HR_kinds                   |
        | HR_languages               |
        | HR_resources               |
        | HR_review                  |
        +----------------------------+

HR_authors // Authors
HR_categories // Subcategories
HR_city // Cities list
HR_country // Countries list
HR_kinds // Resources Type
HR_languages // Web Programming Languages
HR_resources // Web Resources
HR_review // Resource review

   - use phpMyAdmin or similar DataBase Web Administration tools to run the SQL requests from phpHotResources.sql file

6) Make changes to the conf/conf.inc file. This file is well documented, so you should be able to pick out what you need to change fairly easily.

       ########### MySQL DataBase Setting ####################
        $dbname = "yourDBName"; //DataBase Name
        $hostname = "mysql.yourdomain.comm:64366"; //Host Name:PORT
        $username = "yourDBUserName"; //DataBase Access UserName
        $password = "yourDBPassword"; //DataBase Access Password
        
        ########### WebDocs real path #################
        $epath="/usr/local/apache/htdocs/phpHotResources"; //real path
        $eurl="http://localhost/phpHotResources"; //Your Site URL
        $sp="/"; //Windows System '\\'
        $admin="admin@demo.com"; //Admin email

        ############## Color configuration for the default HTML table layout 
        $design["tab_color"]="#d4d5c2"; //HTML Table background color tag setting 
        $design["tr_color"]="#E4E5D2"; //HTML Table <tr> tag background color setting 
        $design["td_color"]="white"; //HTML Table <td> tag background color setting 

        include("../languages/lang_eng.inc"); choose Interface Language

You may create your own language interface simply translating the message variables in the lang_eng.inc.

7) To customize page layout you may edit next two files in 'templates' folder:

• templates/header.inc
• templates/footer.inc

You can customize all HTML tags in these functions.
Warning ! Don't change <form > elements names and parameters.

8) Once all this has been done, you should protect the conf/conf.inc file (that contains
your login/password for db access). Look at your server documentation to find out
how to do this.
For the Apache server, you'll need to create an ".htaccess" file (without quotes) in
the conf subdir that contains:

      <files conf.inc>
          Order Deny,Allow
          Deny From All
      </files>

   Requirements:

• PHP 3.x or greater
• A web server supported by PHP (Apache is most widely used)
• A database with adequate support compiled into PHP. The currently supported database backends are:
  MySQL,
  PostgreSQL,
  InterBase,
  Mini SQL,
  Microsoft SQL Server,
  Oracle 7/8/8i,
  ODBC (Open Database Connectivity),
  SyBase,
  Informix,
  FrontBase