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

   DESCRIPTION:  Structure Definition Script for
   Tables:
      codefixerlp_tblPayment, codefixerlp_tblNews, codefixerlp_tblLink
      codefixerlp_tblSchema, codefixerlp_tblReview, codefixerlp_tblRating
      codefixerlp_tblConfig, codefixerlp_tblCategoryRoute, codefixerlp_tblCategory
      codefixerlp_tblEmailTemplate, codefixerlp_tblEmail, codefixerlp_tblCustomPage

   DESCRIPTION:  Data Script for
   Tables:
      codefixerlp_tblPayment, codefixerlp_tblNews, codefixerlp_tblLink
      codefixerlp_tblSchema, codefixerlp_tblReview, codefixerlp_tblRating
      codefixerlp_tblConfig, codefixerlp_tblCategoryRoute, codefixerlp_tblCategory
      codefixerlp_tblEmailTemplate, codefixerlp_tblEmail, codefixerlp_tblCustomPage

   DATABASE:	(local).master
   =============================================================*/

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 codefixerlp_tblCategory
Print 'Create Table codefixerlp_tblCategory'
GO
CREATE TABLE [codefixerlp_tblCategory] (
		[fldID]                      int NOT NULL IDENTITY(1, 1),
		[fldIDParent]                int NULL,
		[fldCategoryName]            varchar(50) NULL,
		[fldPageName]                varchar(255) NULL,
		[fldCategoryDescription]     text NULL,
		[fldDateAdded]               smalldatetime NULL,
		[fldActive]                  bit NULL,
		[fldTitle]                   varchar(255) NULL,
		[fldKeywords]                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_codefixerlp_tblCategory to codefixerlp_tblCategory
Print 'Add Primary Key PK_codefixerlp_tblCategory to codefixerlp_tblCategory'
GO
ALTER TABLE [codefixerlp_tblCategory]
	ADD
	CONSTRAINT [PK_codefixerlp_tblCategory]
	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 codefixerlp_tblCategoryRoute
Print 'Create Table codefixerlp_tblCategoryRoute'
GO
CREATE TABLE [codefixerlp_tblCategoryRoute] (
		[fldID]              int NOT NULL IDENTITY(1, 1),
		[fldIDCat]           int NULL,
		[fldIDCatParent]     int NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_codefixerlp_tblCategoryRoute to codefixerlp_tblCategoryRoute
Print 'Add Primary Key PK_codefixerlp_tblCategoryRoute to codefixerlp_tblCategoryRoute'
GO
ALTER TABLE [codefixerlp_tblCategoryRoute]
	ADD
	CONSTRAINT [PK_codefixerlp_tblCategoryRoute]
	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 codefixerlp_tblConfig
Print 'Create Table codefixerlp_tblConfig'
GO
CREATE TABLE [codefixerlp_tblConfig] (
		[fldID]                     int NOT NULL IDENTITY(1, 1),
		[fldConfigName]             varchar(255) NULL,
		[fldConfigValue]            text NULL,
		[fldProtected]              bit NULL,
		[fldDataType]               varchar(50) NULL,
		[fldConfigDescription]      text NULL,
		[fldSystem]                 bit NULL,
		[fldRank]                   int NULL,
		[fldOption1Text]            text NULL,
		[fldOption1Value]           text NULL,
		[fldOption2Text]            text NULL,
		[fldOption2Value]           text NULL,
		[fldOption3Text]            text NULL,
		[fldOption3Value]           text NULL,
		[fldOption4Text]            text NULL,
		[fldOption4Value]           text NULL,
		[fldOption5Text]            text NULL,
		[fldOption5Value]           text NULL,
		[fldOption6Text]            text NULL,
		[fldOption6Value]           text NULL,
		[fldOption7Text]            text NULL,
		[fldOption7Value]           text NULL,
		[fldOption8Text]            text NULL,
		[fldOption8Value]           text NULL,
		[fldOption9Text]            text NULL,
		[fldOption9Value]           text NULL,
		[fldOption10Text]           text NULL,
		[fldOption10Value]          text NULL,
		[fldOtherAllowed]           bit NULL,
		[fldConfigFriendlyName]     varchar(255) NULL,
		[fldTextArea]               bit NULL,
		[fldIDType]                 int 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_codefixerlp_tblConfig to codefixerlp_tblConfig
Print 'Add Primary Key PK_codefixerlp_tblConfig to codefixerlp_tblConfig'
GO
ALTER TABLE [codefixerlp_tblConfig]
	ADD
	CONSTRAINT [PK_codefixerlp_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 codefixerlp_tblCustomPage
Print 'Create Table codefixerlp_tblCustomPage'
GO
CREATE TABLE [codefixerlp_tblCustomPage] (
		[fldID]            int NOT NULL IDENTITY(1, 1),
		[fldMenuTitle]     varchar(50) NULL,
		[fldPageName]      varchar(255) NULL,
		[fldBody]          text NULL,
		[fldActive]        bit NULL,
		[fldPosition]      varchar(50) 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_codefixerlp_tblCustomPage to codefixerlp_tblCustomPage
Print 'Add Primary Key PK_codefixerlp_tblCustomPage to codefixerlp_tblCustomPage'
GO
ALTER TABLE [codefixerlp_tblCustomPage]
	ADD
	CONSTRAINT [PK_codefixerlp_tblCustomPage]
	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 codefixerlp_tblEmail
Print 'Create Table codefixerlp_tblEmail'
GO
CREATE TABLE [codefixerlp_tblEmail] (
		[fldID]                    int NOT NULL IDENTITY(1, 1),
		[fldEmailFrom]             varchar(255) NULL,
		[fldEmailTo]               varchar(255) NULL,
		[fldEmailCC]               text NULL,
		[fldEmailBCC]              text NULL,
		[fldEmailSubject]          varchar(255) NULL,
		[fldEmailBody]             text NULL,
		[fldEmailDateAdded]        smalldatetime NULL,
		[fldEmailFormat]           varchar(50) NULL,
		[fldEmailIP]               varchar(50) NULL,
		[fldEmailSessionID]        varchar(50) NULL,
		[fldEmailTicket]           varchar(50) NULL,
		[fldEmailServerName]       varchar(255) NULL,
		[fldEmailComponent]        varchar(50) NULL,
		[fldEmailAuthUsername]     varchar(255) NULL,
		[fldEmailAuthPassword]     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_codefixerlp_tblEmail to codefixerlp_tblEmail
Print 'Add Primary Key PK_codefixerlp_tblEmail to codefixerlp_tblEmail'
GO
ALTER TABLE [codefixerlp_tblEmail]
	ADD
	CONSTRAINT [PK_codefixerlp_tblEmail]
	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 codefixerlp_tblEmailTemplate
Print 'Create Table codefixerlp_tblEmailTemplate'
GO
CREATE TABLE [codefixerlp_tblEmailTemplate] (
		[fldID]                    int 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_codefixerlp_tblEmailTemplate to codefixerlp_tblEmailTemplate
Print 'Add Primary Key PK_codefixerlp_tblEmailTemplate to codefixerlp_tblEmailTemplate'
GO
ALTER TABLE [codefixerlp_tblEmailTemplate]
	ADD
	CONSTRAINT [PK_codefixerlp_tblEmailTemplate]
	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 codefixerlp_tblLink
Print 'Create Table codefixerlp_tblLink'
GO
CREATE TABLE [codefixerlp_tblLink] (
		[fldID]                  int NOT NULL IDENTITY(1, 1),
		[fldIDParent]            int NULL,
		[fldActive]              bit NULL,
		[fldFeatured]            bit NULL,
		[fldRating]              float NULL,
		[fldNumberOfRatings]     int NULL,
		[fldLinkName]            varchar(255) NULL,
		[fldURL]                 varchar(255) NULL,
		[fldReciprocalURL]       varchar(255) NULL,
		[fldLinkDescription]     text NULL,
		[fldContactName]         varchar(50) NULL,
		[fldContactEmail]        varchar(50) NULL,
		[fldLinkNotes]           text NULL,
		[fldDateAdded]           smalldatetime NULL,
		[fldApproved]            bit NULL,
		[fldPageName]            varchar(255) NULL,
		[fldIDType]              int NULL,
		[fldPaymentItemName]     varchar(50) NULL,
		[fldImageURL]            varchar(255) NULL,
		[fldAddress]             varchar(50) NULL,
		[fldTown]                varchar(50) NULL,
		[fldCounty]              varchar(50) NULL,
		[fldPostCode]            varchar(50) NULL,
		[fldCountry]             varchar(50) NULL,
		[fldPhone]               varchar(50) NULL,
		[fldURLMap]              varchar(255) NULL,
		[fldCustomContent]       text NULL,
		[fldClickThrough]        int NULL,
		[fldImageURLb]           varchar(255) NULL,
		[fldImageURLc]           varchar(255) NULL,
		[fldHits]                int NULL,
		[fldOtherCategory]       varchar(50) 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_codefixerlp_tblLink to codefixerlp_tblLink
Print 'Add Primary Key PK_codefixerlp_tblLink to codefixerlp_tblLink'
GO
ALTER TABLE [codefixerlp_tblLink]
	ADD
	CONSTRAINT [PK_codefixerlp_tblLink]
	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 codefixerlp_tblNews
Print 'Create Table codefixerlp_tblNews'
GO
CREATE TABLE [codefixerlp_tblNews] (
		[fldID]                  int NOT NULL IDENTITY(1, 1),
		[fldTitle]               varchar(255) NULL,
		[fldBody]                text NULL,
		[fldRating]              float NULL,
		[fldNumberOfRatings]     int NULL,
		[fldActive]              bit NULL,
		[fldDateAdded]           smalldatetime 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_codefixerlp_tblNews to codefixerlp_tblNews
Print 'Add Primary Key PK_codefixerlp_tblNews to codefixerlp_tblNews'
GO
ALTER TABLE [codefixerlp_tblNews]
	ADD
	CONSTRAINT [PK_codefixerlp_tblNews]
	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 codefixerlp_tblPayment
Print 'Create Table codefixerlp_tblPayment'
GO
CREATE TABLE [codefixerlp_tblPayment] (
		[fldID]                           int NOT NULL IDENTITY(1, 1),
		[fldItemName]                     varchar(255) NULL,
		[fldItemNumber]                   varchar(50) NULL,
		[fldPaymentAmount]                float NULL,
		[fldPaymentCurrency]              varchar(50) NULL,
		[fldReceiverEmail]                varchar(50) NULL,
		[fldPayerEmail]                   varchar(50) NULL,
		[fldInvoice]                      varchar(255) NULL,
		[fldFirstName]                    varchar(50) NULL,
		[fldLastName]                     varchar(50) NULL,
		[fldAddress]                      varchar(50) NULL,
		[fldCity]                         varchar(50) NULL,
		[fldCounty]                       varchar(50) NULL,
		[fldPostCode]                     varchar(50) NULL,
		[fldCountry]                      varchar(50) NULL,
		[fldPhoneA]                       varchar(50) NULL,
		[fldPhoneB]                       varchar(50) NULL,
		[fldShipping]                     float NULL,
		[fldHandling]                     float NULL,
		[fldTax]                          float NULL,
		[fldPaymentStatus]                varchar(50) NULL,
		[fldTransactionID]                varchar(50) NULL,
		[fldTransactionDateTime]          smalldatetime NULL,
		[fldSecurityKey]                  varchar(50) NULL,
		[fldGatewayStatus]                varchar(50) NULL,
		[fldIDType]                       int NULL,
		[fldIDOwner]                      int NULL,
		[fldIDTypeOwner]                  int NULL,
		[fldSessionID]                    varchar(50) NULL,
		[fldIP]                           varchar(50) NULL,
		[fldNotes]                        text NULL,
		[fldRecurringTimePeriod]          varchar(50) NULL,
		[fldRecurringTimePeriodUnit]      int NULL,
		[fldRecurringDateStart]           smalldatetime NULL,
		[fldPaymentStatusDescription]     varchar(255) NULL,
		[fldRecurringDateEnd]             smalldatetime 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_codefixerlp_tblPayment to codefixerlp_tblPayment
Print 'Add Primary Key PK_codefixerlp_tblPayment to codefixerlp_tblPayment'
GO
ALTER TABLE [codefixerlp_tblPayment]
	ADD
	CONSTRAINT [PK_codefixerlp_tblPayment]
	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 codefixerlp_tblRating
Print 'Create Table codefixerlp_tblRating'
GO
CREATE TABLE [codefixerlp_tblRating] (
		[fldID]            int NOT NULL IDENTITY(1, 1),
		[fldIDLink]        int NULL,
		[fldRating]        float NULL,
		[fldIPAddress]     varchar(50) NULL,
		[fldActive]        bit NULL,
		[fldDateAdded]     smalldatetime NULL,
		[fldIDType]        int NULL
)
ON [PRIMARY]
GO
IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
	IF @@TRANCOUNT>0
		ROLLBACK
	
	SET NOEXEC ON
END
GO
-- Add Primary Key PK_codefixerlp_tblRating to codefixerlp_tblRating
Print 'Add Primary Key PK_codefixerlp_tblRating to codefixerlp_tblRating'
GO
ALTER TABLE [codefixerlp_tblRating]
	ADD
	CONSTRAINT [PK_codefixerlp_tblRating]
	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 codefixerlp_tblReview
Print 'Create Table codefixerlp_tblReview'
GO
CREATE TABLE [codefixerlp_tblReview] (
		[fldID]            int NOT NULL IDENTITY(1, 1),
		[fldIDLink]        int NULL,
		[fldFirstName]     varchar(100) NULL,
		[fldLastName]      varchar(100) NULL,
		[fldBody]          text NULL,
		[fldIPAddress]     varchar(50) NULL,
		[fldActive]        bit NULL,
		[fldDateAdded]     smalldatetime NULL,
		[fldIDType]        int NULL,
		[fldInfo]          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_codefixerlp_tblReview to codefixerlp_tblReview
Print 'Add Primary Key PK_codefixerlp_tblReview to codefixerlp_tblReview'
GO
ALTER TABLE [codefixerlp_tblReview]
	ADD
	CONSTRAINT [PK_codefixerlp_tblReview]
	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 codefixerlp_tblSchema
Print 'Create Table codefixerlp_tblSchema'
GO
CREATE TABLE [codefixerlp_tblSchema] (
		[fldID]                 int NOT NULL IDENTITY(1, 1),
		[fldSchemaName]         varchar(50) NULL,
		[fldSchemaClass]        varchar(50) NULL,
		[fldSchemaView]         varchar(255) NULL,
		[fldResultsPerPage]     int NULL,
		[fldFieldsViewable]     varchar(50) NULL,
		[fldTitle]              varchar(50) NULL,
		[fldMessage]            varchar(50) NULL,
		[fldFormID]             varchar(50) NULL,
		[fldFormText]           varchar(50) NULL,
		[fldWidth]              varchar(50) NULL,
		[fldHeight]             varchar(50) NULL,
		[fldFieldID]            varchar(50) NULL,
		[fldFieldText]          varchar(50) NULL,
		[fldSchemaCategory]     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_codefixerlp_tblSchema to codefixerlp_tblSchema
Print 'Add Primary Key PK_codefixerlp_tblSchema to codefixerlp_tblSchema'
GO
ALTER TABLE [codefixerlp_tblSchema]
	ADD
	CONSTRAINT [PK_codefixerlp_tblSchema]
	PRIMARY KEY
	([fldID])
	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: codefixerlp_tblCategory
PRINT 'Deleting from table: codefixerlp_tblCategory'
DELETE FROM [codefixerlp_tblCategory]
-- Deleting from table: codefixerlp_tblCategoryRoute
PRINT 'Deleting from table: codefixerlp_tblCategoryRoute'
DELETE FROM [codefixerlp_tblCategoryRoute]
-- Deleting from table: codefixerlp_tblConfig
PRINT 'Deleting from table: codefixerlp_tblConfig'
DELETE FROM [codefixerlp_tblConfig]
-- Deleting from table: codefixerlp_tblCustomPage
PRINT 'Deleting from table: codefixerlp_tblCustomPage'
DELETE FROM [codefixerlp_tblCustomPage]
-- Deleting from table: codefixerlp_tblEmail
PRINT 'Deleting from table: codefixerlp_tblEmail'
DELETE FROM [codefixerlp_tblEmail]
-- Deleting from table: codefixerlp_tblEmailTemplate
PRINT 'Deleting from table: codefixerlp_tblEmailTemplate'
DELETE FROM [codefixerlp_tblEmailTemplate]
-- Deleting from table: codefixerlp_tblLink
PRINT 'Deleting from table: codefixerlp_tblLink'
DELETE FROM [codefixerlp_tblLink]
-- Deleting from table: codefixerlp_tblNews
PRINT 'Deleting from table: codefixerlp_tblNews'
DELETE FROM [codefixerlp_tblNews]
-- Deleting from table: codefixerlp_tblPayment
PRINT 'Deleting from table: codefixerlp_tblPayment'
DELETE FROM [codefixerlp_tblPayment]
-- Deleting from table: codefixerlp_tblRating
PRINT 'Deleting from table: codefixerlp_tblRating'
DELETE FROM [codefixerlp_tblRating]
-- Deleting from table: codefixerlp_tblReview
PRINT 'Deleting from table: codefixerlp_tblReview'
DELETE FROM [codefixerlp_tblReview]
-- Deleting from table: codefixerlp_tblSchema
PRINT 'Deleting from table: codefixerlp_tblSchema'
DELETE FROM [codefixerlp_tblSchema]

-- No records are in codefixerlp_tblCategory
PRINT 'No records are in codefixerlp_tblCategory'
-- No records are in codefixerlp_tblCategoryRoute
PRINT 'No records are in codefixerlp_tblCategoryRoute'
-- Insert scripts for table: codefixerlp_tblConfig
PRINT 'Inserting rows into table: codefixerlp_tblConfig'
SET IDENTITY_INSERT [codefixerlp_tblConfig] ON

INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 39, '', 1, 'string', '', '', 'URL_Categories', 1, '', 'Category URL Directory', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 40, '', 1, 'string', '', '', 'FOLDER_Install', 1, '', 'Install Folder', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 41, '', 1, 'string', '', '', 'PATH_Site', 1, '', 'Path to Site Root', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 42, '', 1, 'string', '', '', 'PATH_Categories', 1, '', 'Path to Categories', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Maximum characters allowed to describe a link or category.', '', '', '750', '', '500', 1, '', NULL, '1000', 17, '2000', 43, '250', 0, 'long', '500', '1500', 'DescriptionLength', 1, '750', 'Description Length', 0, '', 0, '1500', '2000', '250', '', '', '1000', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Page Suffix', '', '', '', '', '', 1, '', NULL, '', 254, '', 44, '', 1, 'string', '', '', 'PageSuffix', 1, '', 'Page Suffix', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, to allow you to easily get going with some popular uses for this web application.

Please contact sales@codefixer.com for a custom banner or total reskin of your site. We will happilly quote you at our reduced development rate for modifications on the linkspro product.', 'Header-TourismDirectory.jpg', '', 'Header-HostingDirectory.jpg', '', 'DVD Link Directory', 1, '', NULL, 'Recipe Link Directory', 15, 'Car Sales Directory', 45, 'LinksPro Ultimate', 0, 'string', 'Header-DVDLinks.jpg', 'linksPro_468x60.gif', 'BannerImage', 1, 'Hosting Business Directory', 'Banner Image', 0, '', 0, 'LinksPro Basic', 'Header-CarDirectory.jpg', 'Header-LinksProUltimate.jpg', '', '', 'Header-RecipeLinks.jpg', 'Tourism Directory')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 15, '', 46, '', 0, 'string', '', '', 'BannerAltTag', 1, '', 'Banner Alt Tag', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to authorize new links 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, '', NULL, '', 18, '', 50, 'True', 0, 'boolean', 'False', '', 'AutomaticApproval', 1, '', 'Automatic Approve Links', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 9, '', 51, 'True', 0, 'boolean', 'False', '', 'NotifyAdministrator', 1, '', 'Email Notify Administrator', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 12, '', 52, '', 0, 'string', '', '', 'META_SiteTitle', 1, '', 'Site Title', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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', NULL, 'Yahoo', 4, 'AOL', 53, 'BT Internet', 0, 'string', 'post.demon.co.uk', 'smtp.gmail.com', 'EmailServerName', 1, 'Hotmail', 'Email Server SMTP', 0, 'Comcast USA', 0, 'Gmail', 'smtp.aol.com', 'mail.btinternet.com', 'smtp.comcast.net', 'Netcom USA', 'smtp.mail.yahoo.com', 'AT&T broadband USA')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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 mail component used by many ISP''s (do not confuse with Persists ASPEmail component) 

We recommended CDOSYS, but please do experiment if you have problems.', '', '', 'ASPMAIL', '', 'CDONTS', 1, '', NULL, '', 5, '', 54, 'CDOSYS', 0, 'string', 'CDONTS', '', 'EmailComponent', 1, 'ASPMAIL', 'Email Component', 0, '', 0, '', '', 'CDOSYS', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '14', 17, '', 55, '1', 0, 'long', '2', '21', 'DaysForNewListing', 1, '7', 'Days For New Listing', 0, '', 0, '21', '', '1', '', '', '14', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '20', 16, '', 56, '3', 0, 'long', '5', '50', 'ResultsMaxLatestLinks', 1, '10', 'Latest Links Results Top', 0, '', 0, '50', '', '3', '', '', '20', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Background color of tables/main body of site.

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

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

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

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

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

e.g. #EFEFEF', '', '', '', '', '', 1, '', NULL, '', 11, '', 59, '', 0, 'string', '', '', 'CSS_BackgroundColor', 1, '', 'Color Site Background', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Username used to access the admin/back-end', '', '', '', '', '', 1, '', NULL, '', 1, '', 60, '', 0, 'string', '', '', 'LOGIN_AdminUsername', 1, '', 'Admin Username', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Password used to access the admin/back-end', '', '', '', '', '', 1, '', NULL, '', 2, '', 61, '', 0, 'string', '', '', 'LOGIN_AdminPassword', 1, '', 'Admin Password', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 62, '', 1, 'string', '', '', 'URL_SiteRoot', 1, '', 'Site URL', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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.', '', '', '1270', '', '1014', 1, '', NULL, '1590', 11, '', 63, '775', 0, 'long', '1014', '', 'CSS_TableWidth', 1, '1270', 'Content Width', 0, '', 0, '', '', '775', '', '', '1590', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Full Default Description of the this site, used for SEO / META Tags.', '', '', '', '', '', 1, '', NULL, '', 13, '', 64, '', 0, 'string', '', '', 'META_SiteDescription', 1, '', 'Site Description', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Default Keywords describing this site, used for SEO / META Tags.', '', '', '', '', '', 1, '', NULL, '', 14, '', 65, '', 0, 'string', '', '', 'META_SiteKeywords', 1, '', 'Site Keywords', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many links/items will be displayed per page.', '', '', '25', '', '10', 1, '', NULL, '50', 16, '', 66, '5', 0, 'long', '10', '100', 'ResultsPerPage', 1, '25', 'Results Per Page', 0, '', 0, '100', '', '5', '', '', '50', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 67, '', 1, 'string', '', '', 'URL_Css', 1, '', 'Style Sheet URL', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 68, '', 1, 'string', '', '', 'URL_JavascriptFunctions', 1, '', 'Javascript Function URL', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 254, '', 69, 'MS Access', 1, 'string', 'dbsqlserver', '', 'DATABASE_Type', 1, '', 'Database Type', 0, '', 0, '', '', 'dbaccess', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, 'Access', 254, 'MS SQL Server (2005,2005 Express) ODBC', 70, 'MS SQL Server (7,2000)  OLEDB', 1, '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', 0, '', 0, '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 [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 3, '', 71, '', 0, 'string', '', '', 'AdministratorsEmail', 1, '', 'Email Address', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Format in which to send emails out in, HTML or Text. HTML is recommended.', '', '', '', '', 'Text', 0, '', NULL, '', 6, '', 72, 'HTML', 0, 'string', 'Text', '', 'EmailFormat', 1, '', 'Email Format', 0, '', 0, '', '', 'HTML', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 17, '', 73, 'True', 0, 'boolean', 'False', '', 'ShowDescriptions', 1, '', 'Show Descriptions', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '50', 16, '', 74, '5', 0, 'long', '10', '', 'ResultsMaxTopRated', 1, '25', 'Results Per Page Top Rated', 0, '', 0, '', '', '5', '', '', '50', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow people to submit duplicate sites to the directory or not.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 75, 'True', 1, 'boolean', 'False', '', 'DuplicateSites', 1, '', 'Duplicate Sites', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show images in the standard listing of links.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 76, 'True', 0, 'boolean', 'False', '', 'ShowImages', 1, '', 'Show Images', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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_', '', 'codefixerlp_', 1, '', NULL, 'codefixerlpr_', 254, '', 77, 'codefixer_', 1, 'string', 'codefixerlp_', '', 'TableNamePrefix', 1, 'linkspro_', 'Database Table Name Prefix', 0, '', 0, '', '', 'codefixer_', '', '', 'codefixerlpr_', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '50', 16, '', 78, '5', 0, 'long', '10', '100', 'ResultsPerPageAdmin', 1, '25', 'Results Per Page Admin', 0, '', 0, '100', '', '5', '', '', '50', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 17, '', 79, 'True', 0, 'boolean', 'False', '', 'AllowTopCategoryLinks', 1, '', 'Show Top Links', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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 prevent your site being used for spam purposes.', '', '', '60', '', '30', 1, '', NULL, '120', 7, '', 80, '15', 0, 'long', '30', '', 'EmailIntervalSeconds', 1, '60', 'Email Send Interval', 0, '', 0, '', '', '15', '', '', '120', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 81, '', 0, 'string', '', '', 'CSS_Color', 1, '', 'Color Text', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 82, '', 0, 'string', '', '', 'CSS_ColorLink', 1, '', 'Color Link', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 83, '', 0, 'string', '', '', 'CSS_ColorLinkHover', 1, '', 'Color Link Hover', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('List of fonts to be used for all text e.g. Verdana, Arial, Helvetica, sans-serif', 'Georgia, Times New Roman, Times, serif', 'Geneva, Arial, Helvetica, sans-serif', 'Geneva, Arial, Helvetica, sans-serif', 'Geneva, Arial, Helvetica, sans-serif', 'Georgia, "Times New Roman", Times, serif', 1, '', NULL, 'Arial, Helvetica, sans-serif', 11, 'Courier New, Courier, monospace', 84, 'Verdana, Arial, Helvetica, sans-serif', 0, 'string', 'Georgia, "Times New Roman", Times, serif', 'Times New Roman, Times, serif', 'CSS_FontFamily', 1, 'Geneva, Arial, Helvetica, sans-serif', 'Font Family', 0, 'Verdana, Arial, Helvetica, sans-serif', 0, 'Times New Roman, Times, serif', 'Courier New, Courier, monospace', 'Verdana, Arial, Helvetica, sans-serif', 'Verdana, Arial, Helvetica, sans-serif', '', 'Arial, Helvetica, sans-serif', 'Georgia, Times New Roman, Times, serif')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '12', 11, '14', 85, '9', 0, 'long', '10', '13', 'CSS_FontSize', 1, '11', 'Font Size', 0, '', 0, '13', '14', '9', '', '', '12', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 86, '', 0, 'string', '', '', 'CSS_InputEdgeColor', 1, '', 'Color Text Box Border', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 87, '', 1, 'string', '', '', 'CSS_CellBackgroundColor1', 1, '', 'Color Cell Background', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 88, '', 0, 'string', '', '', 'CSS_CellEdgeColor1', 1, '', 'Color Cell Border', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Background color of admin menu/navigation bar. Full color code listing can be viewed via the following
 http://www.w3schools.com/html/html_colornames.asp', '', '', '', '', '', 1, '', NULL, '', 11, '', 89, '', 0, 'string', '', '', 'CSS_CellBackgroundColor2', 1, '', 'Color Admin Nav Background', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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, '', NULL, '', 11, '', 90, '', 0, 'string', '', '', 'CSS_CellEdgeColor2', 1, '', 'Color Admin Nav Border', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to turn Google AdSense Advertising On or Off - Top of Page

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, '', NULL, '', 19, '', 91, 'True', 0, 'boolean', 'False', '', 'AD_Google', 1, '', 'Google Adverts Top', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [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

Example of what you should enter here:
pub-2473673338532556

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, '', '', '', 19, '', 92, '', 0, 'string', '', '', 'AD_GoogleCode', 1, '', 'Google Adverts Code', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Automatically approve all reviews submitted to the site.', '', '', '', '', 'False', 0, '', NULL, '', 18, '', 94, 'True', 0, 'boolean', 'False', '', 'AutomaticApprovalReviews', 1, '', 'Automatic Approve Reviews', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Automatically approve all ratings submitted to the site.', '', '', '', '', 'False', 0, '', NULL, '', 18, '', 95, 'True', 0, 'boolean', 'False', '', 'AutomaticApprovalRatings', 1, '', 'Automatic Approve Ratings', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want the news page turned on with the link on the navigation bar?', '', '', '', '', 'False', 0, '', NULL, '', 10, '', 96, 'True', 0, 'boolean', 'False', '', 'ActivateNews', 1, '', 'News Page', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show recent news on the home page of the site, not effected by News Page Menu Item.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 97, 'True', 0, 'boolean', 'False', '', 'ShowNews', 1, '', 'News Show Top', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many recent news items to show on the homepage.', '', '', '25', '', '10', 1, '', NULL, '50', 16, '', 98, '5', 0, 'long', '10', '', 'ResultsMaxNews', 1, '25', 'News Results Top', 0, '', 0, '', '', '5', '', '', '50', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('1. Free - Allows links to be submitted to the site free of charge
2. Reciprocal - Submitter sites must have a link back to this site / your directory, for mutual search engine optimisation.
3. Pay - Members pay a free to submit to your directory. You can specify premium and standard rates depending on if the submitter wishes a link at the top of the directory, by altering the Premium Top Category and Fee Premium Settings. You can use recurring or 1 off billing.', '', '', 'Pay', '', 'Reciprocal', 0, '', NULL, '', 10, '', 99, 'Free', 0, 'string', 'Reciprocal', '', 'ModeSite', 1, 'Pay', 'Site Mode', 0, '', 0, '', '', 'Free', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to submit their links to the top of the directory, setting false will force them to submit to a category within the site.

IMPORTANT (Please Read)
Set "Show Top Links" to True also, so you/users can see the links submitted to the top of the directory.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 100, 'True', 0, 'boolean', 'False', '', 'AllowTopCategorySubmit', 1, '', 'Top Category Submission', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you wish to offer a premium rate charge, for people to submit links to the top of your directory.

IMPORTANT (Please Read)
1. Set "Top Category Submission" to True also, so that users are allowed to submit to the top categories, Premium Submission will NOT work without this being turned on.
2. Set "Show Top Links" to True also, so you/users can see the links submitted to the top of the directory.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 101, 'True', 0, 'boolean', 'False', '', 'PremiumTopCategory', 1, '', 'Pay: Config Premium Submission', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Premium one off fee the site will charge submitters.', '', '', '20.00', '', '10.00', 1, '', NULL, '30.00', 22, '50.00', 102, '5.00', 0, 'double', '10.00', '50.00', 'FeePremium', 1, '20.00', 'Pay: Config Fee Premium', 0, '', 0, '40.00', '100.00', '5.00', '', '', '30.00', '100.00')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Standard one off fee the site will charge submitters.', '', '', '20.00', '', '10.00', 1, '', NULL, '30.00', 22, '50.00', 103, '5.00', 0, 'double', '10.00', '50.00', 'FeeStandard', 1, '20.00', 'Pay: Config Fee Standard', 0, '', 0, '40.00', '100.00', '5.00', '', '', '30.00', '100.00')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The currency your site will charge users in.', '', '', 'EUR', '', 'USD', 1, '', NULL, 'AUD', 22, 'YEN', 104, 'GBP', 0, 'string', 'USD', 'CAD', 'FeeCurrency', 1, 'EUR', 'Pay: Config Fee Currency', 0, '', 0, 'CAD', 'YEN', 'GBP', '', '', 'AUD', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Paypal Email address for you to receive site payments in. To sign up for a paypal business account please visit www.paypal.com. The email you specify there should be the same for this setting.', '', '', '', '', '', 1, '', NULL, '', 22, '', 105, '', 0, 'string', '', '', 'PAYPAL_Receiver_Email', 1, '', 'Pay: PayPal Email', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('URL of the PayPal payment gateway. If you experience problems in the future it is possible PayPal may have changed the this URL.', '', '', '', '', 'Test: https://www.sandbox.paypal.com/cgi-bin/webscr', 1, '', NULL, '', 22, '', 106, 'Live: https://www.paypal.com/cgi-bin/webscr', 0, 'string', 'https://www.sandbox.paypal.com/cgi-bin/webscr', '', 'PAYPAL_URL', 1, '', 'Pay: PayPal URL', 0, '', 0, '', '', 'https://www.paypal.com/cgi-bin/webscr', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Would you like to show a custom menu, under the main site menu. This will list any pages created by the custom site manager.', '', '', '', '', 'False', 0, '', NULL, '', 10, '', 107, 'True', 0, 'boolean', 'False', '', 'ShowCustomMenu', 1, '', 'Custom Pages', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Short Name/Description used in the reciprocal link on users sites.', '', '', '', '', '', 1, '', NULL, '', 23, '', 109, '', 0, 'string', '', '', 'ReciprocalWebSiteTitle', 1, '', 'Reciprocal Web Site Title', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The description that will be used on users reciprocal links within their sites.', '', '', '', '', '', 1, '', NULL, '', 23, '', 110, '', 0, 'string', '', '', 'ReciprocalWebSiteDescription', 1, '', 'Reciprocal Web Site Description', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The base fully qualified site url of which you wish users to have on there sites, for reciprocal status to be valid.

The system will look for this link on reciprocal sites.', '', '', '', '', '', 1, '', NULL, '', 23, '', 111, '', 0, 'string', '', '', 'URL_ReciprocalLinkBack', 1, '', 'Reciprocal Link Back URL', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to pay with PayPal.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 112, 'True', 0, 'boolean', 'False', '', 'PAYMENT_PayPal', 1, '', 'Pay: Single PayPal', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to pay with NoChex. This gateway only accepts GBP - if your ''Fee Currency'' setting isn''t in pounds sterling this option won''t be available to your customers, regardless of this setting.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 113, 'True', 0, 'boolean', 'False', '', 'PAYMENT_NoChex', 1, '', 'Pay: Single Nochex', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show the link count next to each category. This will total up all active links below that category and sub-categories.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 114, 'True', 0, 'boolean', 'False', '', 'ShowLinkCount', 1, '', 'Category Show Link Count', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('NoChex Email address for you to receive site payments in. To sign up for a NoChex seller account please visit www.nochex.com. The email you specify there should be the same for this setting.', '', '', '', '', '', 1, '', NULL, '', 22, '', 115, '', 0, 'string', '', '', 'NOCHEX_Receiver_Email', 1, '', 'Pay: Nochex Email', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('URL of the NoChex payment gateway. If you experience problems in the future it is possible NoChex may have changed the this URL.', '', '', '', '', 'https://www.nochex.com/nochex.dll/checkout', 1, '', NULL, '', 22, '', 116, 'https://secure.nochex.com/', 0, 'string', 'https://www.nochex.com/nochex.dll/checkout', '', 'NOCHEX_URL', 1, '', 'Pay: Nochex URL', 0, '', 0, '', '', 'https://secure.nochex.com/', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Turn on Recurring Billing for PayPal, allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 117, 'True', 0, 'boolean', 'False', '', 'PAYPAL_Recurring', 1, '', 'Pay: Recurring PayPal', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The period you wish to charge recurring billing in, Days, Weeks, Months or Years', '', '', 'M', '', 'Week', 0, '', NULL, 'Year', 22, '', 118, 'Day', 0, 'string', 'W', '', 'PAYMENT_Recurring_TimePeriod', 1, 'Month', 'Pay: Config Recurring Cycle', 0, '', 0, '', '', 'D', '', '', 'Y', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many units of whatever time period you selected, between each recurring charge. If you chose Weeks above, and you want to bill your customers every 4 weeks, then this value should be four. If you chose Years, and you want to bill them annually, then this unit should be 1.', '12', '21', '3', '21', '2', 1, '30', NULL, '4', 22, '7', 119, '1', 0, 'long', '2', '5', 'PAYMENT_Recurring_TimePeriodUnit', 1, '3', 'Pay: Config Recurring Cycle Unit', 0, '14', 0, '5', '7', '1', '14', '30', '4', '12')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you use Google Analytics? Enter your analytics code here, and all of the pages on this site will be tracked. 

You can find this code by pressing "Edit Analytics Account" on the main page within Google Analytics.

Example of what you should enter here:
UA-429234

For further information on Google Analytics hit/traffic statistics service please visit http://www.google.com/analytics', '', '', '', '', '', 1, '', '', '', 19, '', 120, '', 0, 'string', '', '', 'ANALYTICS_GoogleCode', 1, '', 'Google Analytics Code', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The type of item your site mainly uses. This will fill in text labels next to forms and other site titles to accurately let the users know what type of information to enter.', '', '', 'Business', '', 'Company', 1, '', NULL, 'Restaurant', 20, '', 121, 'Link', 0, 'string', 'Company', '', 'SiteWord', 1, 'Business', 'Site Type', 0, '', 0, 'Inn', '', 'Link', '', '', 'Restaurant', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The type of item your site mainly uses, but using a plural spelling to allow lists to accurately be labelled.', '', '', 'Businesses', '', 'Companies', 1, '', NULL, 'Restaurants', 20, '', 122, 'Links', 0, 'string', 'Companies', '', 'SiteWordPlural', 1, 'Businesses', 'Site Type Plural', 0, '', 0, 'Inns', '', 'Links', '', '', 'Restaurants', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to obtain peoples addressing details and show them on the site. This also turns on a google map which is created from these details.', '', '', '', '', 'False', 0, '', NULL, '', 10, '', 123, 'True', 0, 'boolean', 'False', '', 'ActivateAddressing', 1, '', 'Business/Address Mode', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to upload their own images / logos on the submit screen.', '', '', '', '', 'False', 0, '', NULL, '', 10, '', 124, 'True', 0, 'boolean', 'False', '', 'ActivateUpload', 1, '', 'Upload Allowed', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('1. Single: Customer pays a one time fee, and it is up to the site owner to organise any other payments if needed
2. Recurring: The customer pays a recurring charge, the frequency of which is specified in the paypal recurring settings. The price of recurring billing is set via the ''Fee Standard'' and ''Fee Premium'' settings.
These are functional when the ''Site Mode'' is set to ''Pay'' only.', '', '', '', '', 'Recurring', 0, '', NULL, '', 22, '', 125, 'Single', 0, 'string', 'Recurring', '', 'PAYMENT_Mode', 1, '', 'Pay: Config Mode', 0, '', 0, '', '', 'Single', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to pay with Cheque by post/external means.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 126, 'True', 0, 'boolean', 'False', '', 'PAYMENT_Cheque', 1, '', 'Pay: Single Cheque', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to pay with Cash by post/external means.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 127, 'True', 0, 'boolean', 'False', '', 'PAYMENT_Cash', 1, '', 'Pay: Single Cash', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to pay with Bank Transfer/Wire.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 128, 'True', 0, 'boolean', 'False', '', 'PAYMENT_BankTransfer', 1, '', 'Pay: Single Bank Transfer', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow users to pay with your own credit card processing facilities, you will take there details and process the transaction manually.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 129, 'True', 0, 'boolean', 'False', '', 'PAYMENT_CreditCard', 1, '', 'Pay: Single Manual Card', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Turn on Recurring Billing for Cheques (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 130, 'True', 0, 'boolean', 'False', '', 'CHEQUE_Recurring', 1, '', 'Pay: Recurring Cheque', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Turn on Recurring Billing for Cash (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 131, 'True', 0, 'boolean', 'False', '', 'CASH_Recurring', 1, '', 'Pay: Recurring Cash', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Turn on Recurring Billing for Bank Transfer/Wire (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 132, 'True', 0, 'boolean', 'False', '', 'BANKTRANSFER_Recurring', 1, '', 'Pay: Recurring Bank Transfer', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Turn on Recurring Billing for Manual Credit/Debit Card processing (received/handled externally by yourself on a recurring basis), allowing you to charge Dayly, Weekly, Monthly and Yearly for site submissions.', '', '', '', '', 'False', 0, '', NULL, '', 22, '', 133, 'True', 0, 'boolean', 'False', '', 'CREDITCARD_Recurring', 1, '', 'Pay: Recurring Manual Card', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Address of where you wish manual/postal payments to be sent to, your correspondence address.', '', '', '', '', '', 1, '', NULL, '', 22, '', 134, '', 0, 'string', '', '', 'PAYMENT_Address', 1, '', 'Pay: Address', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The name of the person or company people should make cheques payble to.', '', '', '', '', '', 1, '', NULL, '', 22, '', 135, '', 0, 'string', '', '', 'CHEQUE_Receiver_Name', 1, '', 'Pay: Cheque Name', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Your bank payment details, recommended that you use either one of the Two main standards
1. ABA Routing Code - USA
2. IBAN (International Bank Account Number) - Europe and rest of world

You can of course use this field to specify any bank account details, if not using one of the above standards

Examples
1. IBAN: GB54BARC20992012345678
2. ABA: 231382241
3. NAME:Bob Acc Num:66299822 SORT:80-20-90 IBAN:GB5? SWIFT:HJD...

Always add in the IBAN, ABA or other words before any account details (as seen above) so that users will know what the details represent.', '', '', '', '', '', 1, '', NULL, '', 22, '', 136, '', 0, 'string', '', '', 'BANKTRANSFER_IBAN', 1, '', 'Pay: Bank Transfer Details', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('The instructions on how users will pay for there site submission if you''re manually processing their credit/debit cards.', '', '', '', '', '', 1, '', NULL, '', 22, '', 137, 'Contact Shortly', 0, 'string', '', '', 'CREDITCARD_Instructions', 1, '', 'Pay: Manual Card Details', 0, '', 0, '', '', 'We will contact you shortly to arrange payment via your credit/debit card.', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Title''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 138, 'True', 1, 'boolean', 'False', '', 'Force_Linkname', 1, '', 'Force Title', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Web Site Address''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 139, 'True', 0, 'boolean', 'False', '', 'Force_URL', 1, '', 'Force Web Address', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Description''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 140, 'True', 0, 'boolean', 'False', '', 'Force_Description', 1, '', 'Force Description', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Address''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 141, 'True', 0, 'boolean', 'False', '', 'Force_Address', 1, '', 'Force Address', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Town/City''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 142, 'True', 0, 'boolean', 'False', '', 'Force_Town', 1, '', 'Force Town/City', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''County/State''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 143, 'True', 0, 'boolean', 'False', '', 'Force_County', 1, '', 'Force County/State', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Post Code/Zip''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 144, 'True', 0, 'boolean', 'False', '', 'Force_PostCode', 1, '', 'Force Post Code/Zip', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Country''', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 145, 'True', 0, 'boolean', 'False', '', 'Force_Country', 1, '', 'Force Country', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Force people submitting to the site to give a ''Phone'' number', '', '', '', '', 'False', 0, '', NULL, '', 21, '', 146, 'True', 0, 'boolean', 'False', '', 'Force_Phone', 1, '', 'Force Phone', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('If your mail server required authentication please put in the username associated with your email address you specified.', '', '', '', '', '', 1, '', '', '', 8, '', 147, '', 0, 'string', '', '', 'EmailAuthUsername', 1, '', 'Email Account Username', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('If your mail server required authentication please put in the password associated with your email address you specified.', '', '', '', '', '', 1, '', '', '', 9, '', 148, '', 0, 'string', '', '', 'EmailAuthPassword', 1, '', 'Email Account Password', 0, '', 0, '', '', '', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many links/items will be displayed per page for premium links, if you have any links/items at the top of the directory.', '', '', '25', '', '10', 1, '', NULL, '50', 16, '', 149, '5', 1, 'long', '10', '100', 'ResultsPerPageTop', 1, '25', 'Results Per Page Top/Premium', 0, '', 0, '100', '', '5', '', '', '50', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Do you want to turn Google AdSense Advertising On or Off - Bottom of Page', '', '', '', '', 'False', 0, '', NULL, '', 19, '', 150, 'True', 0, 'boolean', 'False', '', 'AD_Google2', 1, '', 'Google Adverts Bottom', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show latest links on the top/home page of your site? See also "Latest Links Results Top" to specify how many links to show.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 151, 'True', 0, 'boolean', 'False', '', 'ShowLatestLinksTop', 1, '', 'Show Latest Links Top', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show email address of submitters to the public in the Details page?', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 152, 'True', 0, 'boolean', 'False', '', 'ShowEmail', 1, '', 'Show Submitters Email', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many images are users allowed to upload. If you are wishing to offer custom content pages, you may wish to allow 2 or 3 images to be submitted so you can design small websites/content for your customers. Multiple images can also be displayed automatically in the details section by changing the Show Image Amount setting.', '', '', '3', '', '2', 0, '', NULL, '', 17, '', 153, '1', 0, 'long', '2', '', 'ImageAmount', 1, '3', 'Image Amount', 0, '', 0, '', '', '1', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Allow (or not) reviews to be viewed/submitted.', '', '', '', '', 'False', 0, '', NULL, '', 18, '', 154, 'True', 0, 'boolean', 'False', '', 'ActivateReviews', 1, '', 'Reviews', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Additional information field to associate with a review. This can be used to validate that the user has some understanding of what they''re reviewing and not just putting down unfounded review comments. An example would be to use this field to say "Date visited" to confirm a reviewer has visited a lodging/eatery establishment.', '', '', 'Package Bought', '', 'Meal Had', 1, '', NULL, 'Room Number', 18, '', 155, 'Date Visited', 0, 'string', 'Meal Had', 'Booking Number', 'ReviewInfoLabel', 1, 'Package Bought', 'Review Info', 0, '', 0, 'Booking Number', '', 'Date Visited', '', '', 'Room Number', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show the current click-through count for a link/business.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 156, 'True', 0, 'boolean', 'False', '', 'ShowClickThroughs', 1, '', 'Show Click-Throughs', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show the current hit count for a link/business.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 157, 'True', 0, 'boolean', 'False', '', 'ShowHits', 1, '', 'Show Hits', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('How many images are to automatically displayed when viewing the details page of link/company. If Show Images setting is set to off, no images will be displayed regardless of this setting.', '', '', '3', '', '2', 0, '', NULL, '', 17, '', 158, '1', 0, 'long', '2', '', 'ShowImageAmount', 1, '3', 'Show Image Amount', 0, '', 0, '', '', '1', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Show the location bar/category bar at the top of the pages.', '', '', '', '', 'False', 0, '', NULL, '', 17, '', 159, 'True', 0, 'boolean', 'False', '', 'ShowLocationBar', 1, '', 'Show Location Bar', 0, '', 0, '', '', 'True', '', '', '', '')
INSERT INTO [codefixerlp_tblConfig] ([fldConfigDescription], [fldOption7Value], [fldOption9Text], [fldOption3Value], [fldOption9Value], [fldOption2Text], [fldOtherAllowed], [fldOption10Value], [fldConfigValue], [fldOption4Text], [fldRank], [fldOption6Text], [fldID], [fldOption1Text], [fldSystem], [fldDataType], [fldOption2Value], [fldOption5Value], [fldConfigName], [fldProtected], [fldOption3Text], [fldConfigFriendlyName], [fldIDType], [fldOption8Text], [fldTextArea], [fldOption5Text], [fldOption6Value], [fldOption1Value], [fldOption8Value], [fldOption10Text], [fldOption4Value], [fldOption7Text]) VALUES ('Send an extra email automatically to people submitting a link/company to your site. The email content can be altered via Email Management > Email Templates, the template to alter is named ''Welcome Email''.', NULL, NULL, NULL, NULL, 'False', 0, NULL, NULL, NULL, 17, NULL, 161, 'True', 0, 'boolean', 'False', NULL, 'WelcomeEmail', 1, NULL, 'Auto-send Welcome Email', 0, NULL, 0, NULL, NULL, 'True', NULL, NULL, NULL, NULL)

SET IDENTITY_INSERT [codefixerlp_tblConfig] OFF


-- No records are in codefixerlp_tblCustomPage
PRINT 'No records are in codefixerlp_tblCustomPage'
-- No records are in codefixerlp_tblEmail
PRINT 'No records are in codefixerlp_tblEmail'
-- Insert scripts for table: codefixerlp_tblEmailTemplate
PRINT 'Inserting rows into table: codefixerlp_tblEmailTemplate'
SET IDENTITY_INSERT [codefixerlp_tblEmailTemplate] ON

INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Link Approved', 'Protected', 'Congratulations, your submission has been <b>Approved</b>', 3, '20060703 17:54:00', NULL, 'Approved your Submission:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Link Rejected', 'Protected', 'We''re sorry, your submission has been <b>Rejected</b>', 4, '20060703 17:54:00', NULL, 'Rejected your Submission:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, '', 'Broken Link', 'Protected', '', 5, '20060703 17:54:00', '', 'Broken Link', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Tell Friend', 'Protected', NULL, 6, '20060703 17:54:00', NULL, 'I thought you might be interested in this website', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Link Added And Approved', 'Protected', 'A new submission has been added and approved', 7, '20060703 17:54:00', NULL, 'received a new submission:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Link Added And Needs Approval', 'Protected', 'A new submission has been added and needs approval', 8, '20060703 17:54:00', NULL, 'received a new submission that needs your approval:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Rating Added And Approved', 'Protected', 'A new rating has been added and approved', 9, '20060703 17:54:00', NULL, 'received a new rating for:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Rating Added And Needs Approval', 'Protected', 'A new rating has been added and needs approval', 10, '20060703 17:54:00', NULL, 'received a new rating that needs your approval for:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Review Added And Approved', 'Protected', 'A new review has been added and approved.', 11, '20060703 17:54:00', NULL, 'received a new review for:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Review Added And Needs Approval', 'Protected', 'A new review has been added and needs approval.', 12, '20060703 17:54:00', NULL, 'received a new review that needs your approval for:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Link Added And Approved User', 'Protected', 'Your new submission has been added and approved.', 13, '20060703 17:54:00', NULL, 'received and approved your new submission:', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'New Link Added And Needs Approval User', 'Protected', 'Your new submission has been added and is undergoing approval.', 14, '20060703 17:54:00', NULL, 'received your new submission and is currently undergoing approval:', 0, 1)
INSERT INTO [codefixerlp_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>', 15, '20060703 17:54: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 [codefixerlp_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="/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="/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="/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="/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>', 16, '20060703 17:54: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)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Payment Follow Up', 'Protected', NULL, 17, '20060703 17:54:00', NULL, 'Payment Follow up', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Subscription Cancellation', 'Protected', NULL, 18, '20060703 17:54:00', NULL, 'Subscription Cancellation', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Site Statistics', 'Protected', 'Hello,<br />Please find below the current Click-Throughs your site has received via our site.', 19, '20060703 17:54:00', NULL, 'Site Statistics', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Submission Guide', 'Protected', '<b>Process</b><br />
1. Please make sure that our email address is <div class="systemerrortext"><b>unblocked from any email spam or filter software</b></div> you are using <b>before submitting</b><br />
2. Add to our directory using the Inn/Bed &amp; Breakfast form<br />
3. Read the welcome email from us which has further information and options<br />
<br />
<b>Submission Form</b><br />
Please find below descriptions of the various fields and options within the submission form.<br />
<br />
<b>Title</b><br />
This is the short name/description of your Inn/Bed &amp; Breakfast . The Title will also be used to make a filename for Search Engine Optimization purposes.<br /> 
<br />
<b>Web Address</b><br />
The web site address of your Inn/Bed &amp; Breakfast .<br />
<br />
<b>Description</b><br />
The full text description of your Inn/Bed &amp; Breakfast , seen in the listings and details pages.<br />
<br />
<b>Area or Town</b><br />
In which area or town is your Inn/Bed &amp; Breakfast situated. If you can''t find an exact match, please choose your closest/most relevant town.<br />
<br />
<b>Other Area/Town</b><br />
If your exact area or town isn''t listed, please tell us here, and we will add this to our site if appropriate.<br />
<br />
<b>Contact Name</b><br />
The name of the person this Inn/Bed &amp; Breakfast relates to.<br />
<br />
<b>Contact Email</b><br />
The email of the person this Inn/Bed &amp; Breakfast relates to.<br />
<br />
<b>Logo/Images</b><br />
Each Inn/Bed &amp; Breakfast can have images associated with it. These images maybe used in the listings and the details page of your Inn/Bed &amp; Breakfast .<br />
<br />
There are several methods, explained below:<br />
<br />
<b>1. Logo Upload</b><br />
You can upload an image from your hard drive to the site. Your logo should have approximate dimensions of 160x120 pixels & be below 80k in size. To find your file press the ''browse'' button, confirm, then press send. You will get a confirmation message if successful or an error message if not. Upon successful upload the text box below will automatically fill with the images web address, that is now stored with us.<br />
<br />
<b>2. Web site Thumbnail</b><br />
We will automatically obtain a snapshot of your web site. We use two thumbnail providers to try an ensure an image is returned which can only occur if you have submitted a valid working web site. In some cases a snapshot may not be obtainable due to your site not being spidered by the thumbnail providers, Girafa or Thumbshots.org.<br />
<br />
If you have problems of this nature, please visit <a target="_blank" href="http://www.dmoz.org">DMOZ</a> - The Open Directory Project, and add your site to their listings to ensure thumbnail pickup and maximize your Search Engine Exposure.<br />
<br />
<b>3. Logo Web Address</b><br />
You can specify the full URL/Web address of an image you have stored else ware in the supplied text box. This image should be publicly accessible.<br />
<br />
e.g. http://www.google.com/intl/en_ALL/images/logo.gif<br />
<br />
<b>Multiple images</b><br />
If you upload more than 1 image, we can use these to create advanced company information and styling within your details page, allowing for full promotion of your business. If you choose ''Web site Thumbnail'' for more than one logo/image do not worry, only a singular thumbnail will be gathered so there will be no repetition.<br />
<br />
<b>Addressing Details</b><br />
A number of fields should be filled in to describe your business location. It is important you at least enter a Zip/PostCode and Country so we can generate a Google map of your location.<br />
<br />
Please enter details for: <b>Address, City/Town, State/County, Zip/Post Code, Country &amp; Phone</b>.<br />', 20, '20060703 17:54:00', NULL, 'Submission Guide/Information', 0, 1)
INSERT INTO [codefixerlp_tblEmailTemplate] ([fldActive], [fldHeader], [fldTemplateName], [fldTypeEmailTemplate], [fldContent], [fldID], [fldDateAdded], [fldFooter], [fldSubject], [fldSystem], [fldProtected]) VALUES (1, NULL, 'Welcome Email', 'Protected', 'Thank you for signing up to Scenes of Vermont''s new links program for inns and bed and breakfasts in Vermont.<br />
<br />
This is just the start of several new features will plan to roll out in the next few months. Rest assured as a charter subscriber to Scenes of Vermont Links, you will be the first to hear about our new programs.<br />
<br />
Kind regards<br />
<br />
Timothy Palmer-Benson<br />
Scenes of Vermont Links Program<br />', 21, '20060703 17:54:00', NULL, 'Welcome Information', 0, 1)

SET IDENTITY_INSERT [codefixerlp_tblEmailTemplate] OFF


-- No records are in codefixerlp_tblLink
PRINT 'No records are in codefixerlp_tblLink'
-- No records are in codefixerlp_tblNews
PRINT 'No records are in codefixerlp_tblNews'
-- No records are in codefixerlp_tblPayment
PRINT 'No records are in codefixerlp_tblPayment'
-- No records are in codefixerlp_tblRating
PRINT 'No records are in codefixerlp_tblRating'
-- No records are in codefixerlp_tblReview
PRINT 'No records are in codefixerlp_tblReview'
-- Insert scripts for table: codefixerlp_tblSchema
PRINT 'Inserting rows into table: codefixerlp_tblSchema'
SET IDENTITY_INSERT [codefixerlp_tblSchema] ON

INSERT INTO [codefixerlp_tblSchema] ([fldSchemaName], [fldFieldText], [fldSchemaView], [fldID], [fldSchemaClass], [fldResultsPerPage], [fldHeight], [fldMessage], [fldFieldID], [fldTitle], [fldWidth], [fldFormText], [fldFormID], [fldFieldsViewable], [fldSchemaCategory]) VALUES ('News', 'Title', 'Default', 1, 'cNews', 20, '500', 'News Title', 'ID', 'News', '400', 'text_crating_fldidlink', 'crating_fldidlink', 'Title', 'Search')
INSERT INTO [codefixerlp_tblSchema] ([fldSchemaName], [fldFieldText], [fldSchemaView], [fldID], [fldSchemaClass], [fldResultsPerPage], [fldHeight], [fldMessage], [fldFieldID], [fldTitle], [fldWidth], [fldFormText], [fldFormID], [fldFieldsViewable], [fldSchemaCategory]) VALUES ('Submission', 'LinkName', 'Default', 2, 'cLink', 20, '500', 'Link Title &amp; Link Description', 'ID', 'Links', '400', 'text_crating_fldidlink', 'crating_fldidlink', 'LinkName', 'Search')

SET IDENTITY_INSERT [codefixerlp_tblSchema] OFF



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

SET NOEXEC OFF

