Link Directory SQL installation documentation

• Version
• Features
• System requirements
• Installation and configuration from the script
• Add categories and links
• Create the web pages
• Template programming
• 5 star rating
• Dynamic page creation but deliver static
• Terms of Use
• Copyright information
• Warranty disclaimer

Open all the files with a .pl file extension in your favorite text editor and look for the line.

#!/usr/local/bin/perl

Make a directory in your cgi-bin directory something like link-sql. Upload everything from the cgi-bin directory (from the zip file) in the same context to your cgi-bin/link-sql directory. Upload everything in ASCII mode (be sure of that other why the script is not working)

Make a directory in your main directory something like docs. Upload everything from the docs directory (from the zip file) in the same context to your docs directory.

You can add categories and links in the administrator control panel, open the admin.pl (http://www.yourdomain.com/cgi-bin/link-sql/admin/admin.pl) script in a browser. On the left side you see a menu where you can add the categories [Add Category] and links [Add Link], before you can add links, you need to create the categories before.

After you have create the categories and links you can build the pages in the administrator control panel by pushing the [Build All] link. All pages and directories are created automatically by the script.

The templates located in the 'admin/templates' directory can be edit to change the look from the site. Advanced template programing can be use to display different result, depending the value/condition.

<%if CATEGORY%>
<h2>Categories</h2>
<%CATEGORY%>
<%endif%>

In this case the variable 'CATEGORY' is displayed only when the variable 'CATEGORY' is set.

<%if Popular eq Yes%>
<sup class="popular">pop</sup>
<%endif%>

In this case the word 'pop' is displayed only when the variable 'Popular' is equal to 'Yes'.

<%if DAYS_OLD eq 1%>
new today
<%elsif DAYS_OLD < 8%>
new this week
<%elsif DAYS_OLD < 15%>
new older than 1 week
<%endif%>

When the variable 'DAYS_OLD' is equal to '6' the words 'new this week' is displayed.

<%if DAYS_OLD eq 1%>
new today

<%andif Popular eq Yes%>
and popular
<%endandif%>

<%elsif DAYS_OLD < 8%>
new this week

<%andif Popular eq Yes%>
and popular
<%endandif%>

<%elsif DAYS_OLD > 7%>
new older than 1 week

<%andif Popular eq Yes%>
and popular
<%endandif%>

<%endif%>

When the variable 'DAYS_OLD' is equal to '6' the words 'new this week' is displayed, if also the variable 'Popular' is equal to 'Yes' the words 'and popular' is also displayed.

This script have a 5 or 10 star rating display options, with this option you can display the rating in a graphic matter.

<img src="http://www.yourdomain.com/images/<%5STAR_RATING%>.gif" border="0" alt="">

<img src="http://www.yourdomain.com/images/<%10STAR_RATING%>.gif" border="0" alt="">

You need (for the use of the 5 star rating option) also to replace the rating form in the 'rate.html' template with the form below.

<form action="<%RATE_SCRIPT%>" method="post">
<input type="hidden" name="do" value="rate_link">
<input type="hidden" name="id" value="<%ID%>">
<input type="radio" name="rate" value="10"> Excellent!<br>
<input type="radio" name="rate" value="8"> Very Good<br>
<input type="radio" name="rate" value="6"> Good<br>
<input type="radio" name="rate" value="4"> Fair<br>
<input type="radio" name="rate" value="2"> Poor<br>
<input type="submit" value="Cast Vote!">
</form>

RewriteEngine On
RewriteRule ^detailed/(.*)\. /cgi-bin/link-sql/browse.pl?do=detail&ID=$1 [L]
RewriteRule ^rate/(.*)\. /cgi-bin/link-sql/browse.pl?do=rate&ID=$1 [L]

RewriteRule ^$ /cgi-bin/link-sql/browse.pl [L]
RewriteRule ^index\. /cgi-bin/link-sql/browse.pl [L]
RewriteRule ^search\. /cgi-bin/link-sql/browse.pl?do=search [L]
RewriteRule ^popular\. /cgi-bin/link-sql/browse.pl?do=pop [L]
RewriteRule ^rating\. /cgi-bin/link-sql/browse.pl?do=top [L]
RewriteRule ^new/index\. /cgi-bin/link-sql/browse.pl?do=new [L]
RewriteRule ^new/(.*)\. /cgi-bin/link-sql/browse.pl?do=new&date=$1 [L]
RewriteRule ^subscribe\. /cgi-bin/link-sql/browse.pl?do=subscribe [L]
RewriteRule ^add\. /cgi-bin/link-sql/browse.pl?do=add [L]
RewriteRule ^Top/(.*)/page(.*)\. /cgi-bin/link-sql/browse.pl?cat=$1&page=$2 [L]
RewriteRule ^Top/(.*)/ /cgi-bin/link-sql/browse.pl?cat=$1 [L]

# --------------------------------------------
# Configuration for the dynamic page creation.
# This is only used by the browse.pl script.
# --------------------------------------------

# Build the pages by the browse.pl '1' script
# or create the pages by the build.pl '0' script
  $config{'useBrowse'} = '1';

# Build the pages Dynamic '1' or static '0' for the use of browse.pl
  $config{'buildDynamic'} = '0';

# When you build the pages static for the use of browse.pl and MOD_REWITE. What
# is the name of the directory that comes in front of the category directory.
# $config{'useBrowse'} need to be '1' and $config{'buildDynamic'} need to be '0';
  $config{'preDirectory'} = 'Top';

  $config{'useBrowse'} = '1';
  $config{'buildDynamic'} = '0';
  $config{'preDirectory'} = 'Top';

Selling the code for this program, or a program derived from Link SQL, without prior written consent is expressly forbidden. Similarly, redistributing this program, or a program derived from Link SQL, over the Internet, CD-Rom or any other medium is expressly forbidden without prior written consent. By using this program you agree to conditions above.

THIS PROGRAM IS DISTRIBUTED IN THE HOPE THAT IT WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. WITHOUT EVEN THE IMPLIED WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.