/* ============================================================
   SCRIPT HEADER (DATABASE STRUCTURE)

   DESCRIPTION:  Structure Definition Script for
   Tables:
      vtbusiness_tblLink, vtbusiness_tblRating, vtbusiness_tblReview
      vtbusiness_tblCategory, vtbusiness_tblCategoryRoute, vtbusiness_tblEmail
   =============================================================*/

SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_WARNINGS ON
SET NOCOUNT ON
SET XACT_ABORT ON
GO

-- BEGINNING TRANSACTION STRUCTURE
PRINT 'Beginning transaction STRUCTURE'
BEGIN TRANSACTION _STRUCTURE_
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblCategory
Print 'Create Table vtbusiness_tblCategory'
GO
CREATE TABLE [vtbusiness_tblCategory] (
		[fldID]                      bigint NOT NULL IDENTITY(1, 1),
		[fldIDParent]                bigint NULL,
		[fldCategoryName]            varchar(50) NULL,
		[fldPageName]                varchar(255) NULL,
		[fldCategoryDescription]     varchar(1000) NULL,
		[fldDateAdded]               smalldatetime NULL,
		[fldActive]                  bit NULL,
		[fldTitle]                   varchar(255) NULL,
		[fldKeywords]                varchar(255) NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_lpu_tblCategory to vtbusiness_tblCategory
Print 'Add Primary Key PK_lpu_tblCategory to vtbusiness_tblCategory'
GO
ALTER TABLE [vtbusiness_tblCategory]
	ADD
	CONSTRAINT [PK_lpu_tblCategory]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblCategory
Print 'Create Index MainIndexes on vtbusiness_tblCategory'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblCategory] ([fldIDParent], [fldCategoryName], [fldPageName], [fldDateAdded], [fldActive], [fldTitle], [fldKeywords])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblCategoryRoute
Print 'Create Table vtbusiness_tblCategoryRoute'
GO
CREATE TABLE [vtbusiness_tblCategoryRoute] (
		[fldID]              bigint NOT NULL IDENTITY(1, 1),
		[fldIDCat]           bigint NULL,
		[fldIDCatParent]     bigint NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_tblRoute to vtbusiness_tblCategoryRoute
Print 'Add Primary Key PK_tblRoute to vtbusiness_tblCategoryRoute'
GO
ALTER TABLE [vtbusiness_tblCategoryRoute]
	ADD
	CONSTRAINT [PK_tblRoute]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblCategoryRoute
Print 'Create Index MainIndexes on vtbusiness_tblCategoryRoute'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblCategoryRoute] ([fldIDCat], [fldIDCatParent])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblEmail
Print 'Create Table vtbusiness_tblEmail'
GO
CREATE TABLE [vtbusiness_tblEmail] (
		[fldID]                  bigint NOT NULL IDENTITY(1, 1),
		[fldEmailFrom]           varchar(255) NULL,
		[fldEmailTo]             varchar(255) NULL,
		[fldEmailCC]             varchar(2000) NULL,
		[fldEmailBCC]            varchar(2000) NULL,
		[fldEmailSubject]        varchar(255) NULL,
		[fldEmailBody]           varchar(8000) NULL,
		[fldEmailDateAdded]      smalldatetime NULL,
		[fldEmailFormat]         varchar(50) NULL,
		[fldEmailIP]             varchar(50) NULL,
		[fldEmailSessionID]      varchar(50) NULL,
		[fldEmailTicket]         varchar(50) NULL,
		[fldEmailServerName]     varchar(50) NULL,
		[fldEmailComponent]      varchar(50) NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_codefixerlpr_tblEmail to vtbusiness_tblEmail
Print 'Add Primary Key PK_codefixerlpr_tblEmail to vtbusiness_tblEmail'
GO
ALTER TABLE [vtbusiness_tblEmail]
	ADD
	CONSTRAINT [PK_codefixerlpr_tblEmail]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblEmail
Print 'Create Index MainIndexes on vtbusiness_tblEmail'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblEmail] ([fldEmailDateAdded], [fldEmailFormat], [fldEmailIP], [fldEmailSessionID])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblLink
Print 'Create Table vtbusiness_tblLink'
GO
CREATE TABLE [vtbusiness_tblLink] (
		[fldID]                  bigint NOT NULL IDENTITY(1, 1),
		[fldIDParent]            bigint NULL,
		[fldActive]              bit NULL,
		[fldFeatured]            bit NULL,
		[fldRating]              bigint NULL,
		[fldNumberOfRatings]     bigint NULL,
		[fldLinkName]            varchar(255) NULL,
		[fldAddress]             varchar(50) NULL,
		[fldCity]                varchar(50) NULL,
		[fldState]               varchar(2) NULL,
		[fldZip]                 varchar(10) NULL,
		[fldPhone]               varchar(50) NULL,
		[fldURL]                 varchar(255) NULL,
		[fldReciprocalURL]       varchar(255) NULL,
		[fldLinkDescription]     varchar(1000) NULL,
		[fldContactName]         varchar(50) NULL,
		[fldContactEmail]        varchar(50) NULL,
		[fldLinkNotes]           varchar(1000) NULL,
		[fldDateAdded]           smalldatetime NULL,
		[fldApproved]            bit NULL,
		[fldPageName]            varchar(255) NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_lpu_tbllinks to vtbusiness_tblLink
Print 'Add Primary Key PK_lpu_tbllinks to vtbusiness_tblLink'
GO
ALTER TABLE [vtbusiness_tblLink]
	ADD
	CONSTRAINT [PK_lpu_tbllinks]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblLink
Print 'Create Index MainIndexes on vtbusiness_tblLink'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblLink] ([fldIDParent], [fldActive], [fldFeatured], [fldURL], [fldContactName], [fldContactEmail], [fldDateAdded], [fldApproved])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblRating
Print 'Create Table vtbusiness_tblRating'
GO
CREATE TABLE [vtbusiness_tblRating] (
		[fldID]            bigint NOT NULL IDENTITY(1, 1),
		[fldIDLink]        bigint NULL,
		[fldRating]        bigint NULL,
		[fldIPAddress]     varchar(20) NULL,
		[fldActive]        bit NULL,
		[fldDateAdded]     smalldatetime NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_tblRating to vtbusiness_tblRating
Print 'Add Primary Key PK_tblRating to vtbusiness_tblRating'
GO
ALTER TABLE [vtbusiness_tblRating]
	ADD
	CONSTRAINT [PK_tblRating]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblRating
Print 'Create Index MainIndexes on vtbusiness_tblRating'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblRating] ([fldIDLink], [fldRating], [fldIPAddress], [fldActive], [fldDateAdded])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblReview
Print 'Create Table vtbusiness_tblReview'
GO
CREATE TABLE [vtbusiness_tblReview] (
		[fldID]            bigint NOT NULL IDENTITY(1, 1),
		[fldIDLink]        bigint NULL,
		[fldFirstName]     varchar(100) NULL,
		[fldLastName]      varchar(100) NULL,
		[fldBody]          varchar(8000) NULL,
		[fldIPAddress]     varchar(20) NULL,
		[fldActive]        bit NULL,
		[fldDateAdded]     smalldatetime NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_tblReview to vtbusiness_tblReview
Print 'Add Primary Key PK_tblReview to vtbusiness_tblReview'
GO
ALTER TABLE [vtbusiness_tblReview]
	ADD
	CONSTRAINT [PK_tblReview]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblReview
Print 'Create Index MainIndexes on vtbusiness_tblReview'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblReview] ([fldIDLink], [fldIPAddress], [fldActive], [fldDateAdded])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

-- COMMITTING TRANSACTION STRUCTURE
PRINT 'Committing transaction STRUCTURE'
IF @@TRANCOUNT>0
	COMMIT TRANSACTION _STRUCTURE_
GO

SET NOEXEC OFF



/* ============================================================
   SCRIPT HEADER (DATABASE STRUCTURE AND DATA)

   DESCRIPTION:  Structure Definition Script for
   Tables:
      vtbusiness_tblEmailTemplate, vtbusiness_tblConfig

   DESCRIPTION:  Data Script for
   Tables:
      vtbusiness_tblEmailTemplate, vtbusiness_tblConfig
   =============================================================*/

SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_WARNINGS ON
SET NOCOUNT ON
SET XACT_ABORT ON
GO

-- BEGINNING TRANSACTION STRUCTURE
PRINT 'Beginning transaction STRUCTURE'
BEGIN TRANSACTION _STRUCTURE_
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblConfig
Print 'Create Table vtbusiness_tblConfig'
GO
CREATE TABLE [vtbusiness_tblConfig] (
		[fldID]                     bigint NOT NULL IDENTITY(1, 1),
		[fldConfigName]             varchar(255) NULL,
		[fldConfigValue]            varchar(2000) NULL,
		[fldProtected]              bit NOT NULL,
		[fldDataType]               varchar(50) NULL,
		[fldConfigDescription]      varchar(2000) NULL,
		[fldSystem]                 bit NOT NULL,
		[fldRank]                   bigint NULL,
		[fldOption1Text]            varchar(2000) NULL,
		[fldOption1Value]           varchar(2000) NULL,
		[fldOption2Text]            varchar(2000) NULL,
		[fldOption2Value]           varchar(2000) NULL,
		[fldOption3Text]            varchar(2000) NULL,
		[fldOption3Value]           varchar(2000) NULL,
		[fldOption4Text]            varchar(2000) NULL,
		[fldOption4Value]           varchar(2000) NULL,
		[fldOption5Text]            varchar(2000) NULL,
		[fldOption5Value]           varchar(2000) NULL,
		[fldOption6Text]            varchar(2000) NULL,
		[fldOption6Value]           varchar(2000) NULL,
		[fldOption7Text]            varchar(2000) NULL,
		[fldOption7Value]           varchar(2000) NULL,
		[fldOption8Text]            varchar(2000) NULL,
		[fldOption8Value]           varchar(2000) NULL,
		[fldOption9Text]            varchar(2000) NULL,
		[fldOption9Value]           varchar(2000) NULL,
		[fldOption10Text]           varchar(2000) NULL,
		[fldOption10Value]          varchar(2000) NULL,
		[fldOtherAllowed]           bit NOT NULL,
		[fldConfigFriendlyName]     varchar(255) NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_vtbusiness_tblConfig to vtbusiness_tblConfig
Print 'Add Primary Key PK_vtbusiness_tblConfig to vtbusiness_tblConfig'
GO
ALTER TABLE [vtbusiness_tblConfig]
	ADD
	CONSTRAINT [PK_vtbusiness_tblConfig]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Table vtbusiness_tblEmailTemplate
Print 'Create Table vtbusiness_tblEmailTemplate'
GO
CREATE TABLE [vtbusiness_tblEmailTemplate] (
		[fldID]                    bigint NOT NULL IDENTITY(1, 1),
		[fldTemplateName]          varchar(255) NULL,
		[fldHeader]                text NULL,
		[fldContent]               text NULL,
		[fldFooter]                text NULL,
		[fldDateAdded]             smalldatetime NULL,
		[fldTypeEmailTemplate]     varchar(50) NULL,
		[fldActive]                bit NULL,
		[fldSystem]                bit NULL,
		[fldProtected]             bit NULL,
		[fldSubject]               varchar(255) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_codefixer_tblEmailTemplate to vtbusiness_tblEmailTemplate
Print 'Add Primary Key PK_codefixer_tblEmailTemplate to vtbusiness_tblEmailTemplate'
GO
ALTER TABLE [vtbusiness_tblEmailTemplate]
	ADD
	CONSTRAINT [PK_codefixer_tblEmailTemplate]
	PRIMARY KEY
	([fldID])
	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Create Index MainIndexes on vtbusiness_tblEmailTemplate
Print 'Create Index MainIndexes on vtbusiness_tblEmailTemplate'
GO
CREATE INDEX [MainIndexes] ON [vtbusiness_tblEmailTemplate] ([fldTemplateName], [fldDateAdded], [fldTypeEmailTemplate], [fldActive], [fldSystem])

	ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO

-- COMMITTING TRANSACTION STRUCTURE
PRINT 'Committing transaction STRUCTURE'
IF @@TRANCOUNT>0
	COMMIT TRANSACTION _STRUCTURE_
GO

SET NOEXEC OFF
-- BEGINNING TRANSACTION DATA
PRINT 'Beginning transaction DATA'
BEGIN TRANSACTION _DATA_
GO


SET NOCOUNT ON
GO


-- Deleting from table: vtbusiness_tblConfig
PRINT 'Deleting from table: vtbusiness_tblConfig'
DELETE FROM [vtbusiness_tblConfig]
-- Deleting from table: vtbusiness_tblEmailTemplate
PRINT 'Deleting from table: vtbusiness_tblEmailTemplate'
DELETE FROM [vtbusiness_tblEmailTemplate]

-- Insert scripts for table: vtbusiness_tblConfig
PRINT 'Inserting rows into table: vtbusiness_tblConfig'
SET IDENTITY_INSERT [vtbusiness_tblConfig] ON

INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Fully qualified url to the categories directory of the links pro application.
This is often the root url of your site + linkspro subdirectory + ''/categories''

Or more simply it is the value you have just placed in URL_SiteRoot + ''/categories''

e.g. http://www.mysite.com/linkspro/categories

Do NOT add a / to the end', '', '', '', '', '', 1, '', '', '', 254, '', 39, '', 1, 'string', '', '', 'URL_Categories', 1, '', 'Category URL Directory', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('This is the directory of your site in which links pro application is installed. Usually a subdirectory of the root of the site.

e.g. linkspro

Do NOT add a /  to the beginning or end', '', '', '', '', '', 1, '', '', '', 254, '', 40, '', 1, 'string', '', '', 'FOLDER_Install', 1, '', 'Install Folder', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The full hard drive path to the linkspro directory on your web server.

e.g. c:\inetpub\wwwroot\mysite\linkspro

Do NOT add a \ to the end', '', '', '', '', '', 1, '', '', '', 254, '', 41, '', 1, 'string', '', '', 'PATH_Site', 1, '', 'Path to Site Root', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Full hard drive path to the links pro categories directory.
This is often the root path of your site + linkspro subdirectory + ''\categories''. 

Or more simply it is the value you have just placed in PATH_SiteRoot + ''\categories''

e.g. c:\inetpub\wwwroot\linkspro\categories

Do NOT add a \ to the end', '', '', '', '', '', 1, '', '', '', 254, '', 42, '', 1, 'string', '', '', 'PATH_Categories', 1, '', 'Path to Categories', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Maximum characters allowed to describe a link or category.', '', '', '750', '', '500', 1, '', '', '1000', 7, '2000', 43, '250', 0, 'long', '500', '1500', 'DescriptionLength', 1, '750', 'Description Length', '', '1500', '2000', '250', '', '', '1000', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Page Suffix', '', '', '', '', '', 1, '', '', '', 254, '', 44, '', 1, 'string', '', '', 'PageSuffix', 1, '', 'Page Suffix', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Filename of the main site banner image, found at the top of all pages. 

If you wish to use a custom image/header, place this file in the ''images'' subdirectory of your linkspro site and reference the filename here (without directory/path information).

Example banners are included via the drop down. You can copy over these filenames in the images directory to be able to quickly access multiple banner images.
e.g. custom1.gif, custom2.gif', 'custom6.gif', 'custom8.gif', 'custom2.gif', 'custom8.gif', 'custom1.gif', 1, 'custom9.gif', '', 'custom3.gif', 5, 'custom5.gif', 45, 'linksPro_468x60.gif', 0, 'string', 'custom1.gif', 'custom4.gif', 'BannerImage', 1, 'custom2.gif', 'Banner Image', 'custom7.gif', 'custom4.gif', 'custom5.gif', 'linksPro_468x60.gif', 'custom7.gif', 'custom9.gif', 'custom3.gif', 'custom6.gif')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Text description/title of the main site image. This will be visible if there is a problem loading the image, and also when your mouse hovers over it.', '', '', '', '', '', 1, '', '', '', 5, '', 46, '', 0, 'string', '', '', 'BannerAltTag', 1, '', 'Banner Alt Tag', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to authorize new links, ratings and reviews on your site prior to them being available to the public?

If you do set to False, to keep the system fully automated with no need for yourself to be bothered, set to True.', '', '', '', '', 'False', 0, '', '', '', 8, '', 50, 'True', 0, 'boolean', 'False', '', 'AutomaticApproval', 1, '', 'Automatic Approve Links', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to be notified of new links, ratings and reviews, or happy to let the system govern itself?

Set to False if you don''t want notifications by email.', '', '', '', '', 'False', 0, '', '', '', 8, '', 51, 'True', 0, 'boolean', 'False', '', 'NotifyAdministrator', 1, '', 'Notify Administrator', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Title of this site, that appears in the browsers top bar and also SEO / META Keywords.', '', '', '', '', '', 1, '', '', '', 4, '', 52, '', 0, 'string', '', '', 'META_SiteTitle', 1, '', 'Title Meta Tag', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The SMTP server name of your mail server allowing sending of mails from the system. This is usually from your ISP, a selection of common isp settings are available above, you can also enter in a custom one if different.', 'mail.attbi.com', 'Gateway.net USA', 'mail.hotmail.com', 'smtp.Gateway.net', 'Demon', 1, 'smtp.ix.netcom.com', '', 'Yahoo', 2, 'AOL', 53, 'BT Internet', 0, 'string', 'post.demon.co.uk', 'smtp.gmail.com', 'EmailServerName', 1, 'Hotmail', 'Email Server SMTP', 'Comcast USA', 'Gmail', 'smtp.aol.com', 'mail.btinternet.com', 'smtp.comcast.net', 'Netcom USA', 'smtp.mail.yahoo.com', 'AT&T broadband USA')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Three different email components exist to enable the sending of mail. These are based on your host/servers particular settings

CDOSYS - Modern Standard, Windows 2003+
CDONTS - Windows 2000 and below
ASPMAIL - 3rd party pro mail component used by many ISP''s

We recommended CDOSYS, but please do experiment if you have problems.', '', '', 'ASPMAIL', '', 'CDONTS', 1, '', '', '', 2, '', 54, 'CDOSYS', 0, 'string', 'CDONTS', '', 'EmailComponent', 1, 'ASPMAIL', 'Email Component', '', '', '', 'CDOSYS', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Activates the "NEW" graphic next to categories and links, if a link is added within the amount of days specified above.

If value is set to 14 for instance, then the new flag will be next to a particular link for upto 14 days from when first added.', '', '', '7', '', '2', 1, '', '', '14', 6, '', 55, '1', 0, 'long', '2', '21', 'DaysForNewListing', 1, '7', 'Days For New Listing', '', '21', '', '1', '', '', '14', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Total amount of latest links you wish to show, usually kept small as latest links are shown on the homepage.', '', '', '10', '', '5', 1, '', '', '20', 6, '', 56, '3', 0, 'long', '5', '50', 'ResultsMaxLatestLinks', 1, '10', 'Latest Links Per Page', '', '50', '', '3', '', '', '20', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Background colour of tables/main body of site.

You can use named colours like blue or red or a hex value, please do put the leading # in if using the latter

e.g. #EFEFEF', '', '', '', '', '', 1, '', '', '', 3, '', 57, '', 0, 'string', '', '', 'CSS_TableBackgroundColor', 1, '', 'Content Background Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Colour of the outlines around tables and site sections.

You can use named colours like blue or red or a hex value, please do put the leading # in if using the latter

e.g. #333333', '', '', '', '', '', 1, '', '', '', 3, '', 58, '', 0, 'string', '', '', 'CSS_TableEdgeColor', 1, '', 'Content Border Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Background colour of site, that highlights the central body/content.

You can use named colours like blue or red or a hex value, please do put the leading # in if using the latter

e.g. #EFEFEF', '', '', '', '', '', 1, '', '', '', 3, '', 59, '', 0, 'string', '', '', 'CSS_BackgroundColor', 1, '', 'Site Background Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Username used to access the admin/back-end', '', '', '', '', '', 1, '', '', '', 1, '', 60, '', 0, 'string', '', '', 'LOGIN_AdminUsername', 1, '', 'Admin Username', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Password used to access the admin/back-end', '', '', '', '', '', 1, '', '', '', 1, '', 61, '', 0, 'string', '', '', 'LOGIN_AdminPassword', 1, '', 'Admin Password', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Fully qualified url to the root of the links pro application.
This is often the root url of your site + linkspro subdirectory

e.g. http://www.mysite.com/linkspro

Do NOT add a / to the end', '', '', '', '', '', 1, '', '', '', 254, '', 62, '', 1, 'string', '', '', 'URL_SiteRoot', 1, '', 'Site URL', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Width of main body of site in pixels. Numeric values only please do not put px suffix.', '', '', '1100', '', '900', 1, '', '', '', 3, '', 63, '770', 0, 'long', '900', '', 'CSS_TableWidth', 1, '1100', 'Content Width', '', '', '', '770', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Full Default Description of the this site used for SEO / META Tags.', '', '', '', '', '', 1, '', '', '', 4, '', 64, '', 0, 'string', '', '', 'META_SiteDescription', 1, '', 'Description Meta Tag', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Default Keywords describing this site, used for SEO / META Tags.', '', '', '', '', '', 1, '', '', '', 4, '', 65, '', 0, 'string', '', '', 'META_SiteKeywords', 1, '', 'Keywords Meta Tag', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many links/items will be displayed per page.', '', '', '25', '', '10', 1, '', '', '50', 6, '', 66, '5', 0, 'long', '10', '100', 'ResultsPerPage', 1, '25', 'Results Per Page', '', '100', '', '5', '', '', '50', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Fully qualified url to the CSS filename of the links pro application.
This is should be the root url of your site + linkspro subdirectory + ''/includes/css.asp''

Or more simply it is the value you have just placed in URL_SiteRoot +  ''/includes/css.asp''

e.g. http://www.mysite.com/linkspro/includes/css.asp', '', '', '', '', '', 1, '', '', '', 254, '', 67, '', 1, 'string', '', '', 'URL_Css', 1, '', 'Style Sheet URL', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Fully qualified url to the JavaScript Functions filename of the links pro application.
This is should be the root url of your site + linkspro subdirectory + ''/includes/functions.js''

Or more simply it is the value you have just placed in URL_SiteRoot +  ''/includes/functions.js''

e.g. http://www.mysite.com/linkspro/includes/functions.js', '', '', '', '', '', 1, '', '', '', 254, '', 68, '', 1, 'string', '', '', 'URL_JavascriptFunctions', 1, '', 'Javascript Function URL', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Select between MS Access and MS SQL Server - depending on which database server you wish to use to run the application.', '', '', '', '', 'MS SQL Server (7,2000,2005)', 0, '', '', '', 254, '', 69, 'MS Access', 0, 'string', 'dbsqlserver', '', 'DATABASE_Type', 1, '', 'Database Type', '', '', '', 'dbaccess', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('MS Access and MS SQL Connect Strings.
Choose based on which database type you are using.  

The example settings above need to be altered to suit your particular settings, please change the following:

MS SQL Server
DatabaseName - With the name of your database
UID - Username of a permitted user of the database
Password - Password of the user
Server=(local) - If using an off site server, Server=IP Address

MS Access
AbsolutePathToSiteRoot - With hard drive path to the root of the links pro directory e.g. c:\inetpub\wwwroot\linkspro\db.database

OLEDB Connect Strings are favoured/fastest, but in some circumstances you might wish to use the none OLEDB type, experiment to find which is best for you.', '', '', 'PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AbsolutePathToSiteRoot\links.mdb', '', 'MS SQL Server (7,2000) ODBC', 1, '', '', 'Access', 254, 'MS SQL Server (2005,2005 Express) ODBC', 70, 'MS SQL Server (7,2000)  OLEDB', 0, 'string', 'Driver=SQL Server;Server=(local);Database=DatabaseName;UID=Username;PWD=Password', 'Provider=SQLNCLI;Data Source=localhost\sqlexpress;Initial Catalog=DatabaseName;UID=Username;PWD=Password;', 'DATABASE_DefaultConnection', 1, 'Access OLEDB', 'Database Connect String', '', 'MS SQL Server (2005,2005 Express) OLEDB', 'Driver={SQL Native Client};Server=ServerName;Database=DatabaseName;UID=Username;PWD=Password;', 'Provider=SQLOLEDB;Driver={SQL Server};Server=(local);Database=DatabaseName;Uid=Username;Pwd=Password;', '', '', 'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\AbsolutePathToSiteRoot\links.mdb', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Email address to which to receieve notifications and all correspondence from the site, this address will also be used in the FROM column, when sending emails to users of the system.', '', '', '', '', '', 1, '', '', '', 2, '', 71, '', 0, 'string', '', '', 'AdministratorsEmail', 1, '', 'Email Address', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Format in which to send emails out in, HTML or Text. HTML is recommended.', '', '', '', '', 'Text', 0, '', '', '', 2, '', 72, 'HTML', 0, 'string', 'Text', '', 'EmailFormat', 1, '', 'Email Format', '', '', '', 'HTML', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('In the category listings, do you want to show full descriptions under the main category title? 

Note, that turning this on will swap the standard subdirectories of categories that you usually see. 

Experiment to find what is best for you.', '', '', '', '', 'False', 0, '', '', '', 7, '', 73, 'True', 0, 'boolean', 'False', '', 'ShowDescriptions', 1, '', 'Show Descriptions', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Top Rated section, how many links will be shown there and classified as top rated.', '', '', '25', '', '10', 1, '', '', '50', 6, '', 74, '5', 0, 'long', '10', '', 'ResultsMaxTopRated', 1, '25', 'Top Rated Per Page', '', '', '', '5', '', '', '50', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow people to submit duplicate sites to the directory or not.', '', '', '', '', 'False', 0, '', '', '', 8, '', 75, 'True', 0, 'boolean', 'False', '', 'DuplicateSites', 1, '', 'Duplicate Sites', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show images in the standard listing of links.', '', '', '', '', 'False', 0, '', '', '', 8, '', 76, 'True', 0, 'boolean', 'False', '', 'ShowImages', 1, '', 'Show Images', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('If installing in MS SQL Master database especially, you may wish to have a table prefix applied to the standard names to easily differentiate against others. If not leave blank. You will need to change your db tables to represent any changes made here, or the site will not work.', '', '', 'linkspro_', '', 'vtbusiness_', 1, '', '', 'codefixerlpr_', 254, '', 77, 'codefixer_', 0, 'string', 'vtbusiness_', '', 'TableNamePrefix', 1, 'linkspro_', 'Table Name Prefix', '', '', '', 'codefixer_', '', '', 'codefixerlpr_', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The amount of links and other items to show per page in admin, this is different value to the resultsperpage for the front of the application.', '', '', '25', '', '10', 1, '', '', '50', 6, '', 78, '5', 0, 'long', '10', '100', 'ResultsPerPageAdmin', 1, '25', 'Results Per Page Admin', '', '100', '', '5', '', '', '50', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to show links at the top of the directory, links without a category of high priority/visible importance?', '', '', '', '', 'False', 0, '', '', '', 8, '', 79, 'True', 0, 'boolean', 'False', '', 'AllowTopCategoryLinks', 1, '', 'Show Top Links', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The interval in seconds a user with the same ip address or session id has to wait before sending another email using the on-site contact forms. This is to stop your site being used as a spam relay.', '', '', '60', '', '30', 1, '', '', '120', 2, '', 80, '15', 0, 'long', '30', '', 'EmailIntervalSeconds', 1, '60', 'Email Send Interval', '', '', '', '15', '', '', '120', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Text Color. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 81, '', 0, 'string', '', '', 'CSS_Color', 1, '', 'Text Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Link Color. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 82, '', 0, 'string', '', '', 'CSS_ColorLink', 1, '', 'Link Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Link Hover Color. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 83, '', 0, 'string', '', '', 'CSS_ColorLinkHover', 1, '', 'Link Hover Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('List of fonts to be used for all text e.g. Verdana, Arial, Helvetica, sans-serif', '', '', 'Geneva, Arial, Helvetica, sans-serif', '', 'Georgia, "Times New Roman", Times, serif', 1, '', '', '', 3, '', 84, 'Verdana, Arial, Helvetica, sans-serif', 0, 'string', 'Georgia, "Times New Roman", Times, serif', '', 'CSS_FontFamily', 1, 'Geneva, Arial, Helvetica, sans-serif', 'Font Family', '', '', '', 'Verdana, Arial, Helvetica, sans-serif', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Font size in pixels, numerics only e.g. 10 or 12 or 14 (please don''t add px suffix)', '', '', '11', '', '10', 1, '', '', '12', 3, '14', 85, '9', 0, 'long', '10', '13', 'CSS_FontSize', 1, '11', 'Font Size', '', '13', '14', '9', '', '', '12', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Color of the borders around form elements like text boxes or drop downs. Full color code listing can be viewed via the following

http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 86, '', 0, 'string', '', '', 'CSS_InputEdgeColor', 1, '', 'Text Box Border Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Background color of cell/header/site sections (not implemented). Full color code listing can be viewed via the following

http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 87, '', 1, 'string', '', '', 'CSS_CellBackgroundColor1', 1, '', 'Cell Background Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Color of the outline around main cell/header/site sections. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 88, '', 0, 'string', '', '', 'CSS_CellEdgeColor1', 1, '', 'Cell Border Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Background colour of admin menu/navigation bar. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 89, '', 0, 'string', '', '', 'CSS_CellBackgroundColor2', 1, '', 'Admin Nav Background Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Color of the outline around admin menu/navigation bar. Full color code listing can be viewed via the following

http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', '', '', 3, '', 90, '', 0, 'string', '', '', 'CSS_CellEdgeColor2', 1, '', 'Admin Nav Border Color', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to turn Google AdSense Advertising On or Off?

Google AdSense is an easy way for website publishers to display relevant adverts on their website''s and earn money. The adverts are related to the existing content on your site or matched to the interests of the visitors your website attracts. You are payed per click, everytime a user simply clicks on an advert on your site, you earn money to varying degrees.

To apply for a google adsense account please visit the following URL
https://www.google.com/adsense/', '', '', '', '', 'False', 0, '', '', '', 9, '', 91, 'True', 0, 'boolean', 'False', '', 'AD_Google', 1, '', 'Google Ads', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Google AdSense Code

Can be found at the following URL (once logged in), next to the label ''AdSense for Content''
https://www.google.com/adsense/account-settings

Google AdSense is an easy way for website publishers to display relevant adverts on their website''s and earn money. The adverts are related to the existing content on your site or matched to the interests of the visitors your website attracts. You are payed per click, everytime a user simply clicks on an advert on your site, you earn money to varying degrees.

To apply for a google adsense account, and so obtain your Google AdSense Code please visit the following URL
https://www.google.com/adsense/', '', '', '', '', '', 1, '', '', '', 9, '', 92, '', 0, 'string', '', '', 'AD_GoogleCode', 1, '', 'Google Ad Code', '', '', '', '', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Automatically approve all reviews submitted to the site.', '', '', '', '', 'False', 0, '', '', '', 8, '', 94, 'True', 0, 'boolean', 'False', '', 'AutomaticApprovalReviews', 1, '', 'Automatic Approve Reviews', '', '', '', 'True', '', '', '', '')
INSERT INTO [vtbusiness_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldOption8Text], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Automatically approve all ratings submitted to the site.', '', '', '', '', 'False', 0, '', '', '', 8, '', 95, 'True', 0, 'boolean', 'False', '', 'AutomaticApprovalRatings', 1, '', 'Automatic Approve Ratings', '', '', '', 'True', '', '', '', '')

SET IDENTITY_INSERT [vtbusiness_tblConfig] OFF


-- Insert scripts for table: vtbusiness_tblEmailTemplate
PRINT 'Inserting rows into table: vtbusiness_tblEmailTemplate'
SET IDENTITY_INSERT [vtbusiness_tblEmailTemplate] ON

INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'Link Approved', 'Protected', 'Congratulations, your link has been <b>Approved</b>', 2, '20060418 21:30:00', '', 'Approved your Link:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'Link Rejected', 'Protected', 'We''re sorry, your link has been <b>Rejected</b>', 3, '20060418 21:32:00', '', 'Rejected your Link:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'Broken Link', 'Protected', '', 4, '20060420 00:15:00', '', 'Broken Link', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'Tell Friend', 'Protected', '', 5, '20060420 00:16:00', '', 'I thought you might be interested in this website', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Link Added And Approved', 'Protected', 'A new link has been added and approved', 6, '20060420 00:50:00', '', 'received a new link:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Link Added And Needs Approval', 'Protected', 'A new link has been added and needs approval', 7, '20060420 01:00:00', '', 'received a new link that needs your approval:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Rating Added And Approved', 'Protected', 'A new rating has been added and approved', 8, '20060420 02:10:00', '', 'received a new rating for:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Rating Added And Needs Approval', 'Protected', 'A new rating has been added and needs approval', 9, '20060420 02:11:00', '', 'received a new rating that needs your approval for:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Review Added And Approved', 'Protected', 'A new review has been added and approved.', 10, '20060420 02:54:00', '', 'received a new review for:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Review Added And Needs Approval', 'Protected', 'A new review has been added and needs approval.', 11, '20060420 02:56:00', '', 'received a new review that needs your approval for:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Link Added And Approved User', 'Protected', 'Your new link has been added and approved.', 12, '20060421 00:02:00', '', 'received and approved your new link:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'New Link Added And Needs Approval User', 'Protected', 'Your new link has been added and is undergoing approval.', 13, '20060421 00:04:00', '', 'received your new link and is currently undergoing approval:', 0, 1)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '<style>
body,table,tr,td
{
font-family:arial;
font-size:12px;
color:#333333;
}

a,a:link,a:visited
{
font-family:arial;
font-size:12px;
color:blue;
}

a:hover
{
color:green;
}

</style>
<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<img src="http://www.codefixer.com/images/CodefixerLogo.gif" border="0" />
</td>
</tr>
</table>', 'Example Template 1', 'General', '<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td style="padding:5px;">
Welcome and thank you for signing up to the codefixer web site. we hope you enjoy your stay, and find our site useful.
</td></tr>
<tr><td>
<p>Codefixer offers <strong>ASP 
                        tutorials, articles and resources</strong> aimed at the 
                        beginner to intermediate ASP developer though there are 
                        many ASP tutorials, articles and resources for the more 
                        advanced. Delve deep and enjoy.<br /><br />Codefixer now has a <a href="http://www.codefixer.com/forum/default.asp">DISCUSSION 
                      FORUM</a> for all your ASP questions and comments. Be the 
                      first to post!<br /> <br /> <a href="http://www.codefixer.com/app_mpV4_PayPal/default.asp">MEMBERSPRO 
                      PAYPAL</a> now supports 3 levels of membership and recurring 
                      payments as well as one-off ''lifetime'' subscriptions.</p>

                     
              <p>We have a new series of <a href="http://www.codefixer.com/asp_net/index.asp">ASP.NET 
                tutorials</a> and articles on the way.</p></td>

<td></tr>
</table>', 14, '20060526 20:00:00', '<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<div style="text-align:center;">
<a href="http://www.xlinesoft.com/asprunnerpro/codefixer468x60.aspx" alt="ASP Runner Professional"><img src="http://www.codefixer.com/images/banners/xlinesoft468x68.gif"  border="0" /></a>
</div>
<br /><br />
<div style="text-align:center;"><a href="http://www.codefixer.com/tutorials/about_company.asp">About</a> 
  | <a href="mailto:contact@codefixer.com?subject=contact">Contact</a> | <a href="http://www.codefixer.com/advertise/advertise.asp">Advertise</a> 
  | <a href="http://www.codefixer.com/tutorials/feedback.asp">Feedback</a> | <a href="http://www.codefixer.com/tutorials/service.asp">Hire Us</a> | <a href="http://www.codefixer.com/link/linktous.asp">Link</a> </div>

<p style="text-align:center;">Site developed by Michael Wall.<br />
  Copyright &copy; 2000-2006. All rights reserved.</p>
</td></tr>
</table>', 'Welcome To Codefixer', 0, 0)
INSERT INTO [vtbusiness_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '<style>
body,table,tr,td
{
font-family:arial;
font-size:12px;
color:#333333;
}

a,a:link,a:visited
{
font-family:arial;
font-size:12px;
color:blue;
}

a:hover
{
color:green;
}

</style>
<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<img src="http://www.codefixer.com/images/CodefixerLogo.gif" border="0" />
</td>
</tr>
</table>', 'Example Template 2 (reusing Example 1 Header & Footer)', 'General', '<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td style="padding:5px;">
 <table width="100%" style="border:1px solid #CCCCCC;" cellpadding="2" cellspacing="0">
        <tr> 
          <td align="left" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td valign="top"><h1>MembersPro PayPal</h1>
                    MembersPro PayPal now lets you charge members recurring subscriptions 
                    or a one-off ''lifetime'' joining fee. <br />

                    With 3 levels of membership available you can set different 
                    subscription fees and provide different content for each. 
                    <br />
                    <br />
                    Easy to install professional 100% secure membership management 
                    system.<br />
                    Customers can signup and automatically be approved once their 
                    payment has been verified by PayPal. PayPal takes care of 
                    all the back end payments with their <a href="http://www.codefixer.com/app_mpV4_Paypal/paypal_ipn.asp">IPN 
                    interface</a> while you can concentrate on running a successful 
                    site and attracting more members. <br />
                    <br />
                    MembersPro PayPal can be quickly and easily integrated into
                    your existing site. Simply upload the files onto your server
                   and have it  running on your website in minutes.<br />                    
                   <br />

                    To use MembersPro PayPal you will need a <a href="https://www.paypal.com/cgi-bin/webscr?cmd=_registration-run" target="_blank">business
                    or premier PayPal account</a>  with Instant Payment
                    Notification  (IPN) enabled in your PayPal control panel. <br />
                    <br />
                    Our <a href="http://www.codefixer.com/app_mpV4_Paypal/subscription_payment_chart.asp">subscription 
                    payment chart</a> shows you how much potential revenue your 
                    site could generate.<br />
                    <br />
                    Here''s <a href="http://www.codefixer.com/app_mpV4_Paypal/10_reasons.asp">10 reasons</a> why you should buy our software.
                </p></td>

                <td width="23%" valign="top"> <div align="center"><a href="https://www.paypal.com/xclick/business=michael%40codefixer.com&item_name=MembersPro+PayPal&item_number=12&amount=199.00&no_note=1&currency_code=USD&return=http%3A//www.codefixer.com/applications/thankyou.asp&cancel_return=http%3A//www.codefixer.com/applications/cancel.asp">
				<strong>PURCHASE TODAY!</strong></a><br />
                    <br />
                    <img src="http://www.codefixer.com/images/productshotboxes/membersPro_paypal.gif" alt="MembersPro PayPal - ASP Membership software" width="125" height="125" border="0"> 
                    <br />
                    <br />
                  </div>
                  <div align="center"><a href="http://www.codefixer.com/members/login.asp" target="_blank"><img src="http://www.codefixer.com/images/mpPayPalpromotion.gif" width="222" height="121"  border="0" ></a> 
                    <table width="80%"  border="0" cellspacing="0" cellpadding="2">

                      <tr>
                        <td>All front end files 
can be easily integrated
into existing site templates.</td>
                      </tr>
                    </table>
                  </div></td>
              </tr>
            </table>
            <div align="center"><a href="http://www.codefixer.com/members/join/view_membershiptypes.asp" target="_blank"><br />

              <img src="http://www.codefixer.com/images/userdemo.gif" width="100" height="25" border="0"></a> 
              <a href="http://www.codefixer.com/members/login.asp" target="_blank"><img src="http://www.codefixer.com/images/admindemo.gif" width="100" height="25" border="0"></a> 
              <a href="http://www.codefixer.com/app_mpv4_paypal/support.asp"><img src="http://www.codefixer.com/images/nsupport.gif" width="90" height="25" border="0"></a> 
              <a href="http://www.codefixer.com/app_mpv4_paypal/faqs.asp"><img src="http://www.codefixer.com/images/nFAQS.gif" height="25" border="0"></a><br />
              <br />
            </div>
            <table width="100%" style="border:solid 1px #cccccc;" cellspacing="1" cellpadding="3">
              <tr > 
                <td width="9%" >Version</td>
                <td width="59%">Product Description</td>

                <td colspan="2"> <div align="center"><strong>Price $199 </strong></div></td>
              </tr>
              <tr style="border:solid 1px #cccccc;"> 
                <td width="9%" rowspan="2" valign="top" nowrap ><strong>4.1 </strong></td>
                <td rowspan="2" valign="top" ><strong>Single Site License<br />
                  </strong> Full source code included<br />

                  2 Hours technical support including free installation if needed<br />
                  Free Updates (2 years)<br />
                  Free Add-ons (2 years) </td>
                <td width="14%" rowspan="2" valign="top" ><form method="post" action="https://www.2checkout.com/cgi-bin/sbuyers/purchase.2c">
                    <div align="center"> 
                      <input type="hidden" name="sid" value="131678">
                      <input type="hidden" name="product_id" value="5">
                      <input type="hidden" name="quantity" value="1">

                      <input name="submit" value="Click to pay thru 2CheckOut" type="image" src="http://www.codefixer.com/images/2co.jpg" width="70" height="39">
                    </div>
                  </form></td>
                <td width="18%" valign="top"> <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
                    <div align="center"> 
                      <input type="hidden" name="cmd" value="_xclick">
                      <input type="hidden" name="business" value="michael@codefixer.com">
                      <input type="hidden" name="return" value="http://www.codefixer.com/applications/thankyou.asp">
                      <input type="hidden" name="cancel_return" value="http://www.codefixer.com/applications/cancel.asp">

                      <input type="hidden" name="notify_url" value="http://www.codefixer.com/applications/ipn.asp">
                      <input type="hidden" name="item_name" value="MembersPro PayPal">
                      <input type="hidden" name="item_number" value="12">
                      <input type="hidden" name="amount" value="199">
                      <input type="hidden" name="no_note" value="1">
                      <input type="hidden" name="currency_code" value="USD">
					  
                      <input name="submit" type="image" src="http://www.codefixer.com/images/paypalbutton.jpg" alt="Make payments with PayPal - it''s fast, free and secure!" border="0" width="70" height="39">
                    </div>
                  </form></td>

              </tr>
              <tr> 
                <td></td>
              </tr>
              <tr style="border:solid 1px #cccccc;"> 
                <td rowspan="2" valign="top"><strong>4.1</strong></td>
                <td rowspan="2" valign="top" ><strong>Unlimited Sites License</strong> 
                  <br />
                  Full source code included<br />

                  3 Hours technical support including free installation if needed<br />
                  Free Updates (2 years)<br />
                  Free Add-ons (2 years) </td>
                <td colspan="2" valign="top"><div align="center"><strong>Price 
                    $499 </strong></div></td>
              </tr>
              <tr style="border:solid 1px #cccccc;"> 
                <td valign="top"><form method="post" action="https://www.2checkout.com/cgi-bin/sbuyers/purchase.2c">

                    <div align="center"> 
                      <input type="hidden" name="sid" value="131678">
                      <input type="hidden" name="product_id" value="6">
                      <input type="hidden" name="quantity" value="1">
                      <input name="submit" value="Click to pay thru 2CheckOut" type="image" src="http://www.codefixer.com/images/2co.jpg" width="70" height="39">
                    </div>
                  </form></td>
                <td valign="top"> <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
                    <div align="center"> 
                      <input type="hidden" name="cmd" value="_xclick">

                      <input type="hidden" name="business" value="michael@codefixer.com">
                      <input type="hidden" name="return" value="http://www.codefixer.com/applications/thankyou.asp">
                      <input type="hidden" name="cancel_return" value="http://www.codefixer.com/applications/cancel.asp">
                      <input type="hidden" name="notify_url" value="http://www.codefixer.com/applications/ipn.asp">
                      <input type="hidden" name="item_name" value="MembersPro PayPal">
                      <input type="hidden" name="item_number" value="12">
                      <input type="hidden" name="amount" value="499">
                      <input type="hidden" name="no_note" value="1">
                      <input type="hidden" name="currency_code" value="USD">

					  
                      <input name="submit" type="image" src="http://www.codefixer.com/images/paypalbutton.jpg" alt="Make payments with PayPal - it''s fast, free and secure!" border="0" width="70" height="39">
                    </div>
                  </form></td>
              </tr>
            </table>
            <br /> <table style="border:solid 1px #cccccc;" width="100%">
              <tr> 
                <td align="left" valign="top"> <strong>Product Features</strong><br /><br />

                  &#8226; Easy to set up and admin, with no Dll''s or components 
                  to install.<br />
                   &#8226; Pure ASP code, 
                  and easily integrated into an existing site.<br />
                  &#8226; Supports multiple membership levels. <br />
                  &#8226; Joining form look is completely customizable. <br /> &#8226; Select the fields and 
                  details for joining form that you need. <br /> &#8226; Javascript 
                  enabled validation on joinup form.<br /> &#8226; Password protect 
                  all your pages with one line of code.<br /> &#8226; Change username 
                  and password.<br /> &#8226; Forgotten password reminder.<br /> &#8226; 
                  Configure site details and settings.<br /> &#8226; Secure administration 
                  area. <br /> &#8226; Web based administration area with easy navigation.<br />

                  &#8226; Administer MembersPro from any internet connected computer 
                  in the world.<br /> <font color="#000000">&#8226; 
                  Search facility for current members with sorting features.</font><font color="#FF0000"><br />
                  <font color="#000000">&#8226; Delete members details or view 
                  details.</font><br />
                  <font color="#000000">&#8226; Automatic approval of members.</font> 
                  <br />
                  <font color="#000000">&#8226;</font> <font color="#000000">Send 
                  mass email to all members.</font><br />

                  <font color="#000000">&#8226;</font> <font color="#000000">Easily 
                  change text of emails sent out.</font><br />
                  </font> &#8226; Uses an Access 2000 relational database.<br />
                  <font color="#FF0000"><font color="#000000">&#8226;</font></font> 
                  Secure against SQL injection.<br />
                  <font color="#FF0000"><font color="#000000">&#8226;</font></font> 
                  Password and username are not sent out in the same email for 
                  security.<br />

                   &#8226; Members 
                  can edit and update their own details.<br />
                  &#8226; Page tracking.<br />
                  &#8226; Login tracking.                  <br /> &#8226; and much 
                  much more...<br /> <font color="#FF0000"><br />
                  <br />

                  <font color="#000000">MembersPro Paypal is an excellent application. 
                  Robust and powerful, It''ll save you time, it''s taken us over 
                  3 years plus worth of work! </font></font> </td>
              </tr>
            </table>
            <br /> <table width="100%" style="border:solid 1px #cccccc;">
              <tr> 
                <td><strong>What is PayPal?</strong><br />
                  <br />

                  </strong>You can find out more about PayPal on the <a href="http://www.paypal.com" target="_blank">PayPal
                  website</a>.<br />
                   <br /><strong>What Could I use this  for?</strong><br />
                  <br />
                  </strong>Obviously a membership site, a subscription site,
                  a supporters site, a fan club or an organization. <br />
                  Sell your intellectual property, newsletters, articles, images, 
                  software, music or downloads.<br />
                  <br />

				  <strong>How it works? </strong><br />
                  <br />
                  </strong>A customer selects a membership option that they would 
                  like to subscribe to and then fills out the sign up form. The 
                  customer then clicks on the payment button and then goes through 
                  with their PayPal payment. The IPN process and post back as 
                  outlined above occur and provided the payment is verified and 
                  successful then the new member will be redirected back to the 
                  site&#8217;s login page and is instantly sent out an autogenerated 
                  password via email.<br />
                  The new member can then login to their account as an active 
                  member. Depending on the membership option that the new member 
                  has paid for they will be taken to the members home page for 
                  that subscription option.<br />
                Find out more about <a href="http://www.codefixer.com/app_mpV4_Paypal/paypal_ipn.asp">PayPal IPN.</a></td>
              </tr>

            </table>
            <br /> <table width="100%" style="border:solid 1px #cccccc;">
              <tr> 
                <td><strong>Server Requirements</strong><br /> 
                  <br />
                  Written in ASP, VBScript. No components to be installed. <br />
                  All the ASP pages must be run through an ASP enabled web server 
                  - Microsoft IIS 4 or above.<br />
                  If you are unsure whether your webserver supports ASP then send 
                  your webhosting company an email asking them.<br />

                  MembersPro Paypal will not work on other platforms. <br />
                  Email components - CDONTS, CDOSYS, JMail, ASPMail (Can be modified 
                  to support other components upon request) <br>
                  <p><strong>Database Requirements</strong><br />
                    <br />
                    This script uses a Microsoft Access 2000 database.<br />
                    The Access database is provided.<br />

                    This script will work for IE and Netscape 4 browsers and above.<br />
                  </p></td>
              </tr>
            </table>
                     </td>
        </tr>
      </table>
</td></tr>
</table>', 15, '20060531 18:01:00', '<table cellpadding="2" cellspacing="2" width="90%" style="border: 1px solid #CCCCCC;">
<tr><td>
<div style="text-align:center;">
<a href="http://www.xlinesoft.com/asprunnerpro/codefixer468x60.aspx" alt="ASP Runner Professional"><img src="http://www.codefixer.com/images/banners/xlinesoft468x68.gif"  border="0" /></a>
</div>
<br /><br />
<div style="text-align:center;"><a href="http://www.codefixer.com/tutorials/about_company.asp">About</a> 
  | <a href="mailto:contact@codefixer.com?subject=contact">Contact</a> | <a href="http://www.codefixer.com/advertise/advertise.asp">Advertise</a> 
  | <a href="http://www.codefixer.com/tutorials/feedback.asp">Feedback</a> | <a href="http://www.codefixer.com/tutorials/service.asp">Hire Us</a> | <a href="http://www.codefixer.com/link/linktous.asp">Link</a> </div>

<p style="text-align:center;">Site developed by Michael Wall.<br />
  Copyright &copy; 2000-2006. All rights reserved.</p>
</td></tr>
</table>', 'MembersPro Web Application Special Offer', 0, 0)

SET IDENTITY_INSERT [vtbusiness_tblEmailTemplate] OFF


-- COMMITTING TRANSACTION DATA
PRINT 'Committing transaction DATA'
IF @@TRANCOUNT>0
	COMMIT TRANSACTION _DATA_
GO

SET NOEXEC OFF
