User Guide
Codefixer LinksPro Version 5
Installation

1. Installation & Admin
· 1.1 Installing the Application - Quick Setup
· 1.2 Installing the Application - More Detailed
· 1.3 Admin Login
· 1.4 Admin Areas

2. Database Requirements & Instructions
· 2.1 Database Requirements
· 2.2 SQL Server Requirements & Installation
· 2.3 Email Component Requirements

3. Important Directories & Files
· 3.1 Root/Install Directory
· 3.2 Admin Directory
· 3.3 Categories Directory
· 3.4 Images Directory
· 3.5 Includes Directory
· 3.6 App Directory
· 3.7 ReadMe Directory

4. Support
· 4.1 Technical Support
· 4.2 Customization
· 4.3 Feedback & Suggestions

5. Checklist
· 5.1 Web Server
· 5.2 Browser Problems

6. Troubleshooting
· 6.1 Errors
· 6.2 Other questions/problems


Administration

7. Links Pro Directory Main Functions
· 7.1 Summary Screen
· 7.2 Directory - categories & links listing
· 7.3 Category Add/Edit
· 7.4 Link Add/Edit
· 7.5 Ratings Listing
· 7.6 Ratings Add/Edit
· 7.7 Reviews Listing
· 7.8 Reviews Add/Edit
· 7.9 Links Waiting Approval

8. Email Templates & Sending Bulk Email
· 8.1 Email Template Selection - example 1
· 8.2 Email Template Selection - example 2
· 8.3 Email Preview & Select Recipients
· 8.4 Emails Sent
· 8.5 Email Templates Listing
· 8.6 Email Template Add/Edit - example 1
· 8.7 Email Template Add/Edit - example 2

9. Configuration Settings
· 9.1 Config Options Listing
· 9.2 Config Edit
· 9.3 Config Advanced Options


Terms & Conditions of use

10. End-User License Agreement
· 10.1 Software Product License
· 10.2 Grant Of License
· 10.3 License Fees
· 10.4 Limited Warranty
· 10.5 Breach Of Limited Warranty
· 10.6 Limitation Of Liability
· 10.7 Termination
· 10.8 Copyright
· 10.9 Additional Right And Limitations

Installation
1. Installation & Admin
1. Upload all the files to your web site, maintaining directory structure.
2. If using MS Access skip to Step 3, if using SQL Server, run the included 'sqlscript.sql' file in Enterprise Manager/SQL Server.
3. Navigate to 'install.asp' in your browser found in root of your LinksPro web site.
4. Follow on screen instructions, fill in the critical database settings, press Install Now.
5. Done.

1. Unzip the 'LinksPro.zip' file & copy/upload the entire directory structure to your web server in the subdirectory 'LinksPro'.
2. If wanting to use SQL Server (if not skip to step 3), run 'sqlscript.sql' found in the root of the LinksPro site, this will create the database structure in its entirety (see 2.2 SQL Server Requirements & Installation, for detailed explanation).
3. Run http://www.yourwebserver.com/linkspro/install.asp - this will start the 'install' process.
4. Fill in your Database Connection details, read on-screen information for further help.
5. Click 'Install Now'.
6. If you have entered your details correctly you will have a confirmation message, advising you to go into the admin panel, to alter any further details such as, links to show per page, or site colors/titles.
7. Your installation is complete.

Once installed, you can login to the Admin area on your site e.g. http://www.yoursite.com/linkspro/admin/index.asp.

The default username / password are as below & but can be changed in 'install' or via the admin panel.

Username: username
Password: password

You can change your sites visual and functional settings from here by clicking the 'Settings' menu option. To get a description of each setting, click or hover your mouse over the setting name/value.

Outline of the functions within the admin panel areas.

Waiting Approval
View all new links waiting your approval to be seen on the public site.

Directory
View/Add/Edit categories and links found on your site. This is the main area to manage your site.

Ratings
This section lists all ratings given by the public or via the admin of the sites links. You also can add/edit ratings.

Reviews
As above, but lists reviews. You can also add/edit your own here.

Send Email
Send a bulk email to all of your links submitters, or add in custom emails on the fly.

Email Templates
Manage your text/html email templates, used in bulk email communications. You can store as many as you want for future use in different categories.

Public Site
Go to the front of your LinksPro site.

Settings
Configuration settings, change colors, site width, email settings, automatic link approval, notifications how many links to show per page & more.

2. Database Requirements & Instructions
This application can use the following databases.

1. MS Access 2000+
2. SQL Server 7
3. SQL Server 2000
4. SQL Server 2005
5. SQL Server 2005 Express

MS Access database - Does NOT require a copy / license of Microsoft Access.
SQL Server 7, 2000 & 2005 - DOES require a copy / license to use.
2005 Express - Does NOT require a license, this is a free version of SQL Server from Microsoft.

SQL Server 2005 Express Download.
http://msdn.microsoft.com/vstudio/express/sql/download/

You need to run sqlscript.sql to create your database, please use the below as guide.

What does the 'sqlscript.sql' do?
1. Installs all tables to Master database.
2. Installs the tables with a prefix of 'vtrestaurant_' so easily identifiable.

If you want to install into a different database or you have specified a different table name prefix then see Step 1, else skip to Step 2.

Step 1 - Edit (skip if you haven't/don't wish to change standard database prefix settings)
a. Edit the "sqlscript.sql" in notepad, search & replace all occurrences of 'vtrestaurant_' to a new table name prefix.
b. Visit the file includes\cInstall.asp, and navigate to around line 39 to alter the following

s_SDDefaultValuesCommon.Add "TableNamePrefix", "vtrestaurant_"
to
s_SDDefaultValuesCommon.Add "TableNamePrefix", "MyNewTablePrefix"

This will alter the default table prefix by default for any reinstalls of this application.

Step 2 - SQL Server Enterprise Manager (SQL Server 7, 2000 connectivity tool)
a. Open SQL Server Management Express & connect to your database.
b. Go to the Tools menu in & select SQL Query Analyzer.
c. In SQL Query Analyzer, select the File menu & Open, select the 'sqlscript.sql' file & open it.
d. Press the Green Arrow, or press F5 to Execute Query.

or

Step 2 - SQL Server Management Express (2005 & 2005 Express connectivity tool)
a. Open SQL Server Management Express.
b. Go to File > Open > Open - select "sqlscript.sql" to load.
c. A dialogue will ask you to connect, select which database details & connect.
b. Click on Tables to view the current tables in your database.
d. Press F5 to execute or Right click on new window & select Execute.

The database tables should be created in your database & ready for use.

You need a SQL Server username & password to access the database through LinksPro that should be entered in the connect string when completing 'install'.

One of the following email components needs to be installed on your web server in order to use the email features of this software product.

An SMTP server is also required. We recommend you use CDOSYS from the below.

1. CDOSYS (microsoft.com) - Enabled by default on Windows 2000, Windows XP Professional, & Windows Server 2003 operating systems.
2. CDONTS (microsoft.com) - Included with Windows NT 4.0 SP3+ & Windows 2000 operating systems.
3. ASPMail (Serverobjects.com).

ASPMail is a third-party mail component in use by many ISP's; it does not come with the Windows Operating Systems as standard. CDOSYS & CDONTS are standard.

The software can be modified to support other components upon request (see 4.2 Customization).

3. Important Directories & Files
Site sub-directories
1. Admin.
2. Categories.
3. Images.
4. Includes.
5. App.
6. ReadMe.

Contains .asp files that allow the user to browse categories & links & search for links. The user can also review, rate, report & send a link to a friend. This folder contains the access database 'db.database', the SQL script 'sqlscript.sql' & the install.asp to setup the site initially.

Contains all back-end control functions to administer & run the site.

The location of every category in the directory, when you create a category a small physical file is created, so that the category has search engine optimized reference.

Contains all images including the sites main banner.

Config Text File
includes\config.asp - Several critical database & URL settings populated by the 'install' page. Edit manually in case of emergencies.

Configuration descriptions, options and further guidance is stored within the database viewable via your admin panel.

Classes
includes\cCast, cCategory, cConfig etc. - The classes/master control code behind the front-end pages. All pages on the site use a class to control data & functions.

Style Sheet
includes\css.asp - All styles are located here & can be edited at will.

JavaScript Functions
includes\functions.js - JavaScript functions used within some of the pages.

Contains the main site mini-web applications like category listing or links listing, which the files in the root incorporate to make a full functioning page.

Site Documentation & End User Agreement.

4. Support
For technical support please visit our support forum.

http://www.codefixer.com/forum/default.asp
or
Contact: support@codefixer.com.

Our office hours are Monday-Friday 9am-5.30pm (GMT).
If you have any problems using this software of encounter any bugs please report them to support@codefixer.com.

For customization please contact sales@codefixer.com.

In order to improve our product & services we would appreciate any feedback or suggestions that you wish to give.

Please post your comments on our support forum.

http://www.codefixer.com/forum/default.asp
or
Contact: support@codefixer.com.

5. Checklist
Having problems? then run through this check list, 9 out of 10 times you won't need to, but if you're having problems please make sure your web server/host has the below installed & setup properly.

LinksPro is written in ASP, VBScript. No Active X DLL components need to be installed. The following standard IIS services are required however.

IIS
Requires an ASP enabled web server - Microsoft IIS 4 or above.
If unsure your Web Host supports this, read their FAQ or email their technical support.

Operating Systems that support IIS
http://www.codefixer.com/tutorials/iis_pws_operating_systems.asp.

Test your Web Hosting runs ASP
http://www.codefixer.com/tutorials/test_server_supports_asp.asp.

MDAC
Microsoft Data Access Components (MDAC).

MDAC version 2.5 or later recommended, free download
http://www.microsoft.com/data.

XML Parser
The Microsoft XML Parser (MSXML) which includes the XMLHTTP Request object.

Test your Web Hosting runs XMLHTTP
http://www.codefixer.com/codesnippets/installed_xmlhttprequest_object.asp.

FSO
The File System Object, used to read and modify text files.

Test your Web Hosting has the FileSystemObject
http://www.codefixer.com/codesnippets/filesystemobject_installed.asp.

Please make sure you have session cookies enabled on your browser otherwise this script will not work.
This application has been tested on IE, Firefox, Opera & Netscape browsers.
It is XHTML V1.0 Transitional compliant, for maximum multiple cross platform compatibility.

6. Troubleshooting
Q. I get this error...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver]
Operation must use an updateable query.

A. The Internet Guest account (IUSR_MACHINE) MUST have Modify permissions on the following
1. db.database (Access DB).
2. categories (sub-directory & all files).
3. includes\includes.asp.
4. includes\config.asp.
5. admin\includes.asp.

For ease you can grant the entire LinksPro directory modify permissions. This is usually only an issue on local servers, hosting companies will often have these permissions setup on all your files.
Please refer to http://support.microsoft.com/kb/q175168/ or contact your hosting company to set the correct permissions.

Q. I get this error...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/linkspro/includes/cDataSource.asp, line 31

A. Your database connect string is incorrect, this could be to do with the server name you specified (local or IP), or less likely it could be security restrictions.

Q. I get this error...

CDO.Message.1 error '80040213'
The transport failed to connect to the server.
/linkspro/includes/cEmail.asp, line 407

A. Your Email Server (SMTP) is incorrect in Settings, please check & possibly contact your ISP to find out the correct setting.

Q. How do I get this site up on to my web hosting/server?
A. If uploading to a remote/web hosts server you will need an ftp client. Download one of the following, & read its included instructions.

1. WS_ftp - http://www.ipswitch.com.
2. Filezilla - http://filezilla.sourceforge.net.

Q. Does it run on Access 97 or SQL Server 6.5 & below?
A. Not Sure, why don't you try it & let us know on the forum? (see 4.1 Technical Support) We value your input & involvement.

Q. Why is the MS Access database named db.database?
A. The Access database is provided in the root of the site with the filename db.database, it is renamed as a security measure to stop direct downloading, if you want to edit it in access rename it to db.mdb. But remember to put it back to db.database when you're finished.

Q. I don't understand all this Database Connection String stuff, what am I supposed to be doing?
A. It can be fiddly & annoying to connect to databases in some circumstances.

Please visit the following which will guide you through it
http://support.microsoft.com/?kbid=193332

For further example database connect strings please visit
http://www.connectstrings.com

Q. How do I change the directory name? For instance if I wish to call the directory "demo_links" and install it in this directory?
A. You can do this in several ways

1. Change it initially once unzipped from the linkspro archive/zip file, then upload it, the automated install.asp pick up will do the rest.
2. If you change it once its installed via ftp or your directory structure, then you can do it automatically, simply run install.asp again from within the newly renamed directory and it will populate with all the correct settings.

Q. I don't understand the email system. What do the header, content and footer mean?
A. Header, footer and content are just ways to divide up the template, it does all join together ultimately, but it's a way to better manage them. As often a graphical template is done by having the header and footer wrapping around some kind of content in the middle.

Also, it allows you to copy and paste headers from one template to another quickly without having to sift through the entire html page, headers are often reused many times, but with different contents.

Administration
7. Links Pro Directory Main Functions
Main index page you are first greeted by when you login successfully. Here you will see summaries of site statistics and activities.

Waiting Approval
How many restaurants are unapproved and waiting for your review.

New Restaurants
The number of new/recent restaurants added to the system.

Favorite Restaurants
The number of featured/favorite restaurants as indicated by the green tick.

Total Restaurants
Total number of restaurants in the entire directory.

Total Locations
Total number of locations in the entire directory.

Lists the categories and links within these categories, this is the main admin area for governing site content.

Location bar/category
The top bar, under the menu, identified by 'Categroy: Top' is your current location within the directory. As you click on further categories this will change to show which category you are within. Clicking category names on this bar, will take you said categories, an easy way to navigate your way back up the directory, and remind you what your looking at.

Categories
By clicking select on a category or anywhere along a category line you will take you to that category, and see its contents, which may contain further categories and links, you navigate your way through the directory by clicking on categories.

Clicking edit will take you to that categories details page, where you may alter category name, description and other details.

Clicking Add New, will take you to a screen where you can add a new category and its details.

Links
Clicking edit or anywhere along the link line will take you to that links details page, where you may alter Restaurant, description and other details.

Allows you to add/edit categories within the directory.

Parent Category
The category that this category your editing/adding is within. If you want to change the location of this category within the directory, you may select a new one from the drop down, and it and all its contents will be moved.

Category Name
The name of the category.

Page Name
The page name of the category as stored on the hard drive. This must be unique and you will be told if it is a duplicate. File names are used to increase search engine optimization, the more pages with relevant words in the filename applying to the content of that file the better your site is ranked, very important.

Category Description
The long description of the category, that will appear when you hover over it, and underneath the category name if category descriptions are turned on.

Active
Activate or deactivate, if set to False, this will not be seen in the front of the directory, set to True it will be.

Date Added
The date and time this was added/created.

Search Engine Optimization (SEO) Overrides
Automatically pages will populate the following

1. Page Title and Meta Keywords (both identical) - Category Name, Category Filename and Site Name
Example: Computers computers-and-software.asp LinksPro

2. Meta Description - populates the category description box
Example: This category lists information about Computers and Software and everything IT Related

If you wish other Title/Keywords to be specifically used for this category please enter below. Leave empty for automatic pickup.

Title
Page title as seen in the title bar of the browser.

Keywords
The keywords identifying the content of this category, separate with a space or a comma for better results.

Allows you to add/edit links within the directory, will automatically detect which category you're within and assume you want to add the link there, unless you decide otherwise.

Active
Activate or deactivate, if set to False, this will not be seen in the front of the directory, set to True it will be.

Featured
Featured/favorite link as indicated by the green tick.

Approved
You have to approve links for them to show at the front of the directory, this can be set to automatic or manual in the 'settings' section.

Category
The category this link is within.

Restaurant
The name of this link.

URL
The web site address this link directs too, people will be able to click on this link and visit it.

Restaurant Description
The long description of web site/link, as seen in link listing and link details.

Contact Name
The name of the person who submitted this link.

Contact Email
The email of the person who submitted this link.

Admin Link Notes
Private notes about this link, not available to the public, for your own admin reference.

Date Added
The date and time this was added/created.

Lists the ratings currently given to links within the site.

Clicking edit or anywhere along the rating line will take you to that ratings details page, where you may alter rating value and active status.

Clicking Add New, will take you to a screen where you can add a new rating and its details.

Allows you to add/edit rating of links within this directory.

Active
Activate or deactivate, if set to False, this will not be seen in the front of the directory, set to True it will be.

Link To Rate
Name of the link this rating applies to.

Rating
Rating value, from 1 (low) to 5 (high).

IP Address
IP Address of the person who rated this link.

Date Added
The date and time this was added/created.

Lists the review currently given to links within the site.

Clicking edit or anywhere along the review line will take you to that reviews details page, where you may alter reviewer name, review, active status and other details.

Clicking Add New, will take you to a screen where you can add a new review and its details.

Allows you to add/edit reviews of links within this directory.

Active
Activate or deactivate, if set to False, this will not be seen in the front of the directory, set to True it will be.

First Name
First name of the reviewer of this link.

Last Name
Last name of the reviewer of this link.

Review
Descriptive review of this link.

Link To Review
Name of the link this review applies to.

IP Address
IP Address of the person who reviewed this link.

Date Added
The date and time this was added/created.

Lists the links currently waiting your approval before they become active in the front of the site.

Clicking edit or anywhere along the link line will take you to that links details page, where you may alter Restaurant, description and other details.

Clicking Add New, will take you to a screen where you can add a new link and its details.

8. Email Templates & Sending Bulk Email
Allows you to select an email template from the template store/templates you have created. You can also go to the email templates list and edit/add new templates.

Selecting a template from the drop down for preview, then selecting 'Send - Like This' will take you to a further preview screen where you can select recipients and subject.

Send - Like This
Takes you to a preview screen where you can select the recipient list, subject and from email address, the latter and penultimate latter will auto populate, but you have the option to change prior to sending.

Send - Make Changes Prior
Takes the current template selected and allows you to make changes prior to sending. These changes won't be saved, this gives you an easy option to make none important minor changes to your templates prior to bulk mailing.

Manage Templates
Lists the email templates currently within the site, allowing you to edit existing or add new templates.

As Email Template Selection - example 1, showing a different template selected from the drop down. This demonstrates how easy it is to reuse existing templates, with the header, content, footer sections, you can cut and paste existing headers and footers, but change the content slightly to create entirely different bulk mails.

Shows the preview of your bulk email/template, prior to sending, and also allows you to select which people you wish to send it too.

Email Subject
Subject of the email you want to send, this will auto populate from the template, but editable freely at send time.

Email From
From address that will displayed in your bulk email. This is populated automatically from the site 'settings' values but is editable at send time.

Email To
The recipient list for this bulk email, you can separate emails with a semi colon i.e. ;

Add All Users
Adds all email addresses of people who have submitted links to the site that are stored in the database.

Clear
Clears the 'Email To' text area box.

Preview
Preview of how your bulk email will look.

Send Bulk Email
Send the bulk email to all of its recipients.

Confirms that the bulk email has been sent and the recipient list that have received it.

Lists the templates currently available within the site, templates with a 'protected' category grouping are system templates used for linkspro communication, you can edit these freely but please check results prior to mainstream use as the system may add further text/content.

Clicking anywhere along the email template line will take you to that templates details page, where you may alter template name, subject and other details.

Clicking Add New, will take you to a screen where you can add a new email template and its details.

The email template allows you to create and store reusable emails for later use. It is divided into 3 sections: header, content and footer for easier management. These 3 sections will join together in the end email/template and form a standard html/web page document, these sections are divided for better management.

Template Name
Name of the email template.

Subject
Subject of the email template that will be sent out as default.

Header
Placing of style sheet, page setup and header graphics. This is often the most reused portion of a template as it sets up the entire page with as mentioned, a style sheet (css), header graphics as well as javascript functions, meta tags and a host of page requirements. Creating a header for your site is very efficient as it can be reused many times.

Content
This is where you communicate specific messages and content to your patrons and usually changes on a case per case basis. Examples are usually based on category e.g. general, sales, information, apology and special offers. In 'protected' templates, the system will add content to templates by default, but you can specify further content by editing these.

Footer
Signifies the closing thoughts of an email such as a Tag Line, copyright notice or set of site links.

Template Group
Category/grouping of this email template, place this template in the grouping that suites its purpose best.

Date Added
The date and time this was added/created.

Protected
Setting protected to True, will stop you being able to delete this template or change its grouping, and only allow you edit its name, subject and content.

As Email Template Add/Edit - example 1, showing a different template selected. This demonstrates how easy it is to reuse existing templates, with the header, content, footer sections, you can cut and paste existing headers and footers, but change the content slightly to create entirely different bulk mails.

9. Configuration Settings
Lists the current settings which govern the sites operation. Hover your mouse over each setting for a partial description.
Clicking edit or anywhere along the setting line will take you to that settings details page, where you may alter the settings value, and view a full description of the settings usage.

Setting Variable
Variable used to identify this setting, used in the code that governs the site, not important unless you are expanding or changing the linkspro application.

Setting Name
Name of the setting.

Example Settings
List of examples for this setting in a drop down box, selecting a setting here will change the 'setting value' below, this can be edited further.

Setting Value
Value of this setting, the element which is most important.

Description/Usage
Description and possible examples of how to use this setting.

Allows you to re-install the site, recreate directory structure and view advanced technical documentation, view on screen documentation for further help.

Terms & Conditions of use
10. End-User License Agreement
IMPORTANT-READ CAREFULLY: This End-User License Agreement ("EULA") is a legal agreement between you (either an individual or a single entity) the end user ("Licensee") and Codefixer the ("Licensor") for the Codefixer.com software product accompanying this EULA, which includes computer software and may include associated media, printed materials, and "online" or electronic documentation. By installing, copying, or otherwise using the software product, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, do not install, copy, or use the software product.

Copyright laws and international copyright treaties as well as other intellectual property laws and treaties protect the software product. The software product is licensed, not sold.

Codefixer hereby grants to the licensee a worldwide, limited, non-exclusive, non-transferable license (without the ability to sub-license) to use this product on a SINGLE web site or if a multi-site license has been purchased to use on multiple sites. The licensee may make copies of the software for backup purposes only.

This license shall have no effect unless and until the licensee submits all applicable and appropriate license fees to Codefixer.

Codefixer warrants that for 1 year following delivery of the software to the licensee, the software unless modified in any way by the licensee will perform substantially according to the functions described in any associated product documentation provided by Codefixer. Codefixer does not warrant that the software will meet the licensee's specific requirements. Codefixer is not responsible for any problem which would otherwise be a breach of warranty, caused by changes in the operating characteristics of computer hardware of computer operating systems, or interaction of the software with software not supplied or approved by Codefixer, or accident, abuse or misapplication.

In case of a breach of limited warranty the licensee's sole remedy under the foregoing warranty during the warranty period is that Codefixer shall, at it's sole and exclusive option, either use reasonable efforts to correct any reported deviation from the relevant product documentation, replace the software with a functionally equivalent program, or refund all license fees paid, in which case this license shall immediately terminate. Any repaired or replaced software will be rewarranted for an additional ninety day period, unless subsequently modified by the licensee.

Under no circumstances shall Codefixer be liable to the licensee for any damages, including compensatory, special, incidental, exemplary, punitive or consequential, connected with or resulting from this license agreement or the licensee's use of this software.

This license is effective until terminated. This license may be terminated by the non-defaulting party if either party materially fails to perform or comply with this license or any provision of it. In the event that Codefixer terminates the license, the licensee must destroy all copies of the software product and all of its component parts.

All title and copyrights in and to the software product (including but not limited to any images, photographs, animations, video, audio, music and text incorporated into the software product), the accompanying printed materials, and any copies of the software product are owned by Codefixer or it's suppliers. The software product is protected by copyright laws and international treaty provisions. Therefore, you must treat the software product like any other copyrighted material.

Limitations on Reverse Engineering and Disassembly.
You may not reverse engineer, or disassemble the software product, except and only to the extent that applicable law notwithstanding this limitation expressly permits such activity.

Rental.
You may not sell, rent, or lease the software product.

Software Transfer.
You may permanently transfer all of your rights under this EULA, provided you retain no copies, you transfer all of the software product (including all component parts, the media and printed materials, any upgrades, this EULA, and the recipient agrees to the terms of this EULA.