BP Blog

CHANGELOG

v10.0 [2010-07-10]
+ Editor changed to ckeditor
+ Layout tab - thanks Phillipe!
+ Entries search by title or content - thanks Phillipe!
+ Additional admin styles - copy Symbol-*.png files into images folder
+ Enhanced admin form validation
* Enhanced the crop sentence routine
* Adding one new line of encoding to rss.asp
* Fixed CSS problem with andrea theme
* Removed version numbers from public pages
# Manually add pagination using the layout tab
v9.0.1 [2009-09-03]
+ Updated fckeditor to version 2.6.4.1
v9.0 [2008-09-16]
* Fixed problem where layout was broken
* CSS colors and layout changes in the admin
+ More admin screen validations
+ New layout engine (no more using the tblLayout option). Layouts are in the Themes folder and are chosen on the Config screen.
+ Layout previews are now stored in a session variable to you can preview all pages in your theme
+ Gallery config screen for thumbnail sizes added
+ Updated fckeditor to version 2.6.3
v8.0.5 [2008-06-15]
+ Manually add a "More..." link anywhere in your post by putting in the tag [more]
v8.0.4 [2008-02-27]
* Fixed typo on Approve Comments admin page
+ Added reload captcha image link on template_permalink.asp
v8.0.3 [2008-02-18]
+ Updated fckeditor to version 2.5.1
v8.0.2 [2007-10-20]
* Fixed login fail redirect on login.asp (it was redirecting to admin_default.asp)
* Deleted some duplicate code in login.asp
v8.0.1 [2007-09-09]
* Updated archives.asp and archives_cat.asp to use the new plugin engine.
v8.0 [2007-08-23]
+ When logged in as an admin you have two views, the admin view and a user view based on your UserID. 
You can see everything or just your content if you're an admin.
+ Added fldAdmin (Default 0, 1 for Admin) in tblUser, Required
+ Added fldGalleryUser in tblGallery, Required, galleries are now tied to UserID
+ Admin interface now uses "Updated Simple CSS Tabs"
Ref: http://labs.silverorange.com/archives/2004/may/updatedsimple
+ Error checking on all admin pages
+ Users can update their profile from their online profile page is logged in
+ Users and Admin can edit posts from the permalink page if logged in
+ Plugin Module
* Updated fckeditor to newest version 2.4.3
* Cleaned up gallery code
* Created function lib for common code in blog.asp rather than on individual pages
* Changed the admin_default.asp page to login.asp
* Blog titles are now all permalinks on the public pages
* Deleting a blog entry now deletes the associated Comments also
- Removed no897 template (didn't work)TODO: Create SQL script to alter existing db tables. Added fields:
+ On tblAuthor - [fldAdmin] [smallint] NULL DEFAULT ((0))
+ On tblGallery - [fldGalleryUser] [int] NOT NULL DEFAULT ((1))DB Upgrade Notes:
Add the two above fields and then run the following queries:
-----
Update tblAuthor
Set fldAdmin = 1
-----
This will set all of your Author's to admins which you can change via the admin screen
-----
Update tblGallery
Set fldGalleryUser = 1
-----
This will set all of your existing galleries to have been created by you.  Change the 1 to your UserID.Notes:
Option Explicit commented out
FCKeditor\editor\filemanager\browser\default\connectors\asp\connector.asp
FCKeditor\editor\filemanager\upload\asp\upload.asp
----------------------------------------
v7.04.01 [2007-07-12]
* Updated MakeHyperlink function on template_permalink.asp
Ref: Thanks Nate http://blog.betaparticle.com/forum/topic.asp?TOPIC_ID=199
* Updated readme.htm file to redirect to wiki
+ Added some default entries in the blog.sql script for tblLayout
Ref: http://blog.betaparticle.com/forum/topic.asp?TOPIC_ID=202
v7.04 [2007-04-27]
+ Added IsValidString and HackerSafe_Filter to check for possible SQL injection and remove database code from erroneous urls
Files changed: default.asp
search.asp
template.asp
template_archives.asp
template_archives_cat.asp
template_author.asp
template_gallery_detail.asp
template_permalink.asp
These are all above the first HTML tag, if you're updating these manually
* Updated fckeditor to newest version 2.4.2
v7.03 [2007-03-15]
* Fixed default.asp layout typo vulnerability
* Optimized SELECT * statements to explicit table names for faster page generation
* Fixed a bug where draft page would show up in sidebar and recent items
v7.02 [2007-02-24]
* Fixed register.asp security vulnerability
* Removed <![CDATA[ from XML generation after cleaning up rss.asp
v7.01 [2006-11-10]
* Updated fckeditor to version 2.3.2
* Fixed a tiny bug in the description meta tag on template_permalink.asp where some HTML tags weren't being filtered out
v7.0 [2006-11-05]
+ Added multiple templating via the database with previews (selectable from the config screen)
+ Added an author page with rich text description
+ Added registration page with "Approved" flag for admin (you must create a new page called "thankyou", example)
+ Added search highlight (hl class in the stylesheet)
+ Send login details via an email link (Must be Plain Text)
+ Added Archive by Month and Archive by Category pages
+ Added "Read More" flag in post (default length is 500 characters)
+ Added Draft flag in post
+ Added Comment Numbers and an alt class for each alternate row (commentalt. css class)
+ Added "Edit" link on each permalink and page post if you're logged in for quick and easy updating if a typing error is found
+ Lightbox code is on by default for the galleryIf you don't want lightbox, then just remove the following lines from Layout2 of the default layout (via the new admin screen):<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
<script src="js/prototype.js" type="text/javascript"></script>
<script src="js/scriptaculous.js?load=effects" type="text/javascript"></script>
<script src="js/lightbox.js" type="text/javascript"></script>
* Updated the RSS Feed to 2.0
* Fixed gallery delete folder error
* Fixed empty category dead link problem
* Fixed a search bug where the category was incorrect
* Cleaned up code
Database changes: tblRSS
blogLayout int required default 1
tblLayout
layoutid autonumber pk
layout1 memo
layout2 memo
layout3 memo
layout4 memo
layout5 memo
layoutTitle Text 100 char
tblBlog
BlogReadMore int required default 0
BlogDraft int required default 0
----------------------------------------
v6.04 [2006-04-29]
+ Implemented ASP Security Image Generator (CAPTCHA) http://www.tipstricks.org/
+ Added link to original post in comment approval page
* Deleted comment code from template_permalink.asp
v6.03 [2006-03-21]
* Secured all fckeditor asp files using an include check for session login
v6.02 [2006-03-18]
* Fixed a hack exploit on pages that accepted a parameter by checking if the length of the param was less than 5
v6.01 [2006-02-02]
* Fixed a bug where the 31st day post was not appearing on the template_archives.asp page for the Month
v6.0 [2006-01-07]
+ Added the ability to set the number of posts to show on default via the configuration screen
* Change commenting database field to type number (int)
* Altered code to work with SQL Server
----------------------------------------
v5.01b [2005-07-30]
+ Added the ability to edit comments
+ HTML/RSS publishing is now done visually from their respective pages and the results are displayed and timed
* Updated meta info and CC licence code
v5.0b [2005-07-07]
+ Changed the default template to a blogger style
+ Each area that requires changing for templates has been converted to a Library item (DW object) for easier customization
+ The Editor has been updated to KTML Pro v3.5.6
* No more need for inputting the correct blog url for publishing - it's detected automatically (note: you'll still have to have it correct in the config for your RSS feed file which pulls from this)
* Fixed numerous errors
----------------------------------------
v4.06 [2005-05-04]
+ Disabled the ability to delete the admin user account
+ Entries can now be ordered by Category (everyone) and by Author (if you're logged in as admin)
* Fixed comments display in Ascending order rather than in Descending order (newest comments at the bottom)
* Fixed admin page errors
v4.05 [2005-05-02]
+ Entries can now by ordered by Date and Heading, Ascending or Descending
+ Pending Comments count
+ Text guess on the Blog Configuration page to help with paths (very important - the blog software won't work if this field is wrong)
* Changed the login page so that the admin navigation doesn't show
* Simplified the download so that only one download is required for root or subdirectory installations
* Fixed typos
* Fixed several errors with the Gallery admin pages regarding deleting images
v4.04 [2005-04-26]
+ Meta tag "description" field now on each page and pulls from your configuration screen description
+ RSS generator now adds "pubDate" for each post and "lastBuildDate" for your site in RFC822 format
+ Added bp blog download for root installations (e.g., http://blogname.com/)
* Fixed several typos
v4.03 [2005-04-20]
+ Added ability to delete comments from each blog entry on that entry's update page.
v4.02 [2005-04-19]
* Fixed the gallery upload feature - no longer requires a server component.
* Changed the gallery files to 1 upload (rather than 3).
v4.01 [2005-04-13]
* Fixed the gallery files to work regardless of directory structure
* Fixed numerous issues with the ASP only templates.
v4.0 [2005-03-21]
+ Multiple authors supported (username "admin" has access to all posts)
+ Commenting can be turned on or off for each entry
+ Simple Gallery (requires Persits ASP Upload and .NET for thumbnail resizing)
+ Added Templates Directory with option for ASP (for those who can't get the publish to HTML option to work) and Movable Type
* DB Changes:
- Added tblAuthor table and linked it to the BlogAuthor field in tblBlog
- Changed commentDate in tblComment to Long Date format
- Added BlogCommentInclude field to tblBlog
----------------------------------------
v3.1 [2005-03-09]
+ Update HTML Editor to KTML 3.5.6 http://www.interaktonline.com/Products/KTML/Overview/
v3.02 [2005-03-09]
+ Added Comments and Category Counts
* Fixed zip download with correct mdb file
v3.01 [2005-02-07]
+ Added Search function that strips the HTML from the results and truncates the line to 300 characters
* Fixed numberous formatting problems concerning anchors and the rss.asp generator to conform to the new layout.

Documentation

Synopsis
License
Donation
Download
Features
Important Note
Installation
Installation Procedure
Requirements
Server
Browser
Database
Changelog
Sites Using BP Blog
Additional Help
Screenshots

Synopsis

BP Blog is a blog software coded in ASP.

License

Creative Commons License http://creativecommons.org/licenses/by-nc-sa/2.5/

Donation

Cost (Suggested): $20.00 US Dollars
Benefits:
* Assist in further development of BP Blog
* Personal Email Support

Download

http://blog.betaparticle.com/uploads/blog_9.0.zip

Features

* ASP 3.0
* HTML Editor with image/file upload
* Only one line of code to change (the connection string to your Access database)!
* Simple Gallery (requires ASP.NET for thumbnail creation)
* Plugin Module

Important Note

The default username and password is:

Username: admin
Password: password

Be sure and change these when you login for the first time!

Installation

I decided against using an email client to notify your users if they have been approved after registering due to server variance. On the user's page you can send the users their login information and tell them they're approved for posting. The sidebar hides the admin functions.

Their is only one admin with the username "admin" since this blog was originally designed to be for one site with many users, not a multi-blog application. This may be in the future...

Installation Procedure

1. Upload all files to the directory of your choice on your web server. If using the provided Access database, 2.1 Open "blog.asp" in the Connections folder and change the path to you database (in the "Data Source=" area) If SQL Server, 2.2 Open blog.sql in the Connections folder and run on your SQL Server to create your database and default entries 3. Open up blog.asp in the Connections folder and change the variables: Dim theBasePath theBasePath = "/FCKeditor/" 'FCKeditor base path Dim theConfigUserFilesPath theConfigUserFilesPath = "/UserFiles/"

The connection string will probably be the most difficult step in the process, especially concerning SQL Server.

4. Open up the admin page http://yourserver.com/main.asp or the login page http://yourserver.com/admin_login.asp. The default username is "admin" and the password is "password"

5. The first thing to do after logging in is to click "Users" on the sidebar and change the admin password. Then click "Blog Configuration" and fill in the appropriate information. There is some help if you put your mouse over each field title.

6. There is a layout.htm document to give you the basics of the templating system that's stored in the database by viewing the source of the document and looking at the HTML comments. There are 5 layout parts that divide the page - what I call the "wrapper" b/c it's the layout that wraps around the dynamic text elements and generally stays the same on each page.

7. If you need to customize the dynamic elements such as the post area then you'll have to manually edit (the area that's not covered by the templates) in notepad or Dreamweaver:
* default.asp
* search.asp
* template.asp
* template_archives.asp
* template_archives_cat.asp
* template_author.asp
* template_gallery.asp
* template_gallery_detail.asp
* template_permalink.asp

Requirements

Server

* IIS 4.0+
* Read/write access on the server (FSO)
* MSXML
* Simple Gallery requires ASP.NET 1.1 or greater for thumbnail creation

Browser

IE 5.0+ or Firefox 1.0+

Database

Access or SQL Server or MySQL (BETA)

FAQ

More info: Google

Generic HTTP 500 - Internal server errors
A Frequent problem when trying to run ASP applications on your own web space or web server is how do you debug the application if it is not running correctly and only showing a generic error message.

All to often in Internet Explorer if the application crashes all you see is a page saying - 'The page cannot be displayed.' then further down the screen you have the generic error 'HTTP 500 - Internal server error'.

Well you'll be glad to know there is something you can do to help debug the application and find out what exactly is coursing the application not to run correctly.

To do this you need to turn of Internet Explorers, Friendly HTTP Error Messages function, by following the steps below: -

First you need to select 'Tools' from the menu at the top of Internet Explorer.
Then from the drop down menu choose 'Internet Options'.
Once the 'Internet Options' Dialog box opens you want to choose the 'Advanced' tab.
You will then see a list of Advanced functions of Internet Explorer that can be turned on or off by checking the tick boxes.
Look down the list for 'Show friendly HTTP error messages' and uncheck the tick box for it followed by the 'Apply' button at the bottom of the dialog box.
Now when you return to the main Internet Explorer screen with 'The page cannot be displayed. - HTTP 500 - Internal server error' you should be able to get what the error is after hitting the refresh button.

Ref: http://www.webwizguide.info/asp/faq/friendly_HTTP_error_messages.asp

fckeditor not showing
In Connections/ blog.asp
Dim theBasePath theBasePath = "/FCKeditor/" Dim theConfigUserFilesPath theConfigUserFilesPath = "/UserFiles/"

You can comment out the dim statements if you have additional problems like: 'Dim theBasePath theBasePath = "/FCKeditor/" 'Dim theConfigUserFilesPath theConfigUserFilesPath = "/UserFiles/"

If the path to your blog is http://domain.com/blog/ then change the above to: 'Dim theBasePath theBasePath = "/blog/FCKeditor/" 'Dim theConfigUserFilesPath theConfigUserFilesPath = "/blog/UserFiles/"

You may also try it without the leading slash: 'Dim theBasePath theBasePath = "FCKeditor/" 'Dim theConfigUserFilesPath theConfigUserFilesPath = "UserFiles/"

Thumbnails won't display on gallery pages

You must have asp.net enabled for thumbnails to display. If this is not possible, then delete the code:
thumbnailimage.aspx?filename=

from template_gallery.asp and template_gallery_detail.asp and the pages should display without thumbnailing.

Name redefined error
If the pages that use fckeditor get the error:
Microsoft VBScript compilation error '800a0411' Name redefined /blog/Connections/blog.asp, line 8 Dim MM_blog_STRING ----^

Then comment out the Dim statements in your blog.asp file (they're not really needed) like so:
'Dim MM_blog_STRING MM_blog_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\blog.mdb;Persist Security Info=False" 'Dim theBasePath theBasePath = "/blog/FCKeditor/" 'FCKeditor base path 'Dim theConfigUserFilesPath

Disallowed Path Characters/Disallowed Parent Path
Problem:
Server.MapPath() error 'ASP 0175 : 80004005'

Disallowed Path Characters The '..' characters are not allowed in the Path parameter for the MapPath method.

OR
The Include file '../Connections/blog.asp' cannot contain '..' to indicate the parent directory.

Solution:

"Enable parent paths" setting must be enabled on your IIS server. You might need to talk to your server admin concerning this. They'll know what you're talking about.

More info: http://www.google.com/search?num=100&hl=en&lr=&safe=active&q=Disallowed+Path+Characters+IIS

By default, the Parent Paths option is enabled in IIS 5.0, but it is disabled by default in IIS 6.0.

1. Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. Double-click your computer name in the left pane, and then double-click Web Sites.
3. Locate the Web site and directory that houses the ASP application.
4. Right-click the application site or directory, and then click Properties.
5. Select Home Directory, and then click Configuration.
6. Click Options, and then click to select the Enable Parent Paths check box.
7. Click OK two times.

Ref: http://support.microsoft.com/kb/332117

Permission denied error

Your blog directory must have read/write permissions:

SQL Server
ADODB Field error 800a0bcd
After installing on SQL Server. tblLayout must have some default entries in it. I just use "asdf" for each field. Fixed with version 7.04.01.

MySQL Instructions

First export your database using this app: MdbToMySQL
http://www.zebradb.de/mdbtomysql.htm

Then use this .sql script to import.

3 areas in your generated script have to be altered to work with MySQL: tblBlog, tblComment, tblGallery and tblPage. Set them all to this definition:

In tblBlog:

BlogDate timestamp NOT NULL default CURRENT_TIMESTAMP 


In tblComment: commentDate timestamp NOT NULL default CURRENT_TIMESTAMP 


In tblGallery: fldGalleryCreated timestamp NOT NULL default CURRENT_TIMESTAMP 


and the insert statement:

INSERT INTO tblGalleryConfig (fldGalleryConfigID, fldGalleryTitleThumb, fldGalleryThumb) VALUES (1, 425, 150); 


In tblPage: PageDate timestamp NOT NULL default CURRENT_TIMESTAMP 


You'll have to search around the .sql file but it's not that difficult.

Replace your connection string with:
db_server = "10.6.166.52" 
db_name = "dbname" 
db_username = "dbname" 
db_userpassword = "dbpass" 
MM_blog_STRING = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";OPTION=16387;PWD=" & db_userpassword

Note the "OPTION=16387" which is required. Also, you may have to manually rename "fldGalleryTitleThum" to "fldGalleryTitleThumb" either in the .sql file that's generated or via the PHP MySQL Admin screen (that's what worked for me).

More info on OPTION=16387: http://www.google.com/search?num=50&hl=en&q=OPTION=16387+asp

approve_comments Error
Replace (on line 106):

Code:
rsComments.Fields.Item("commentID").Value
rsComments.Fields.Item("tblComment.BlogID").Value

With:
Code:
rsComments.Fields(0).Value
rsComments.Fields(1).Value


Sample default mysql file:
Code:
# MdbToMySQL MySQL-Dump
# version 1.01
# http://www.zebradb.de
# --------------------------------------------------------

#
# Table structure for table tblAuthor
#

DROP TABLE IF EXISTS tblAuthor;
CREATE TABLE tblAuthor (
   fldAuthorID INT NOT NULL AUTO_INCREMENT,
   fldAuthorUsername VARCHAR(100),
   fldAuthorRealName VARCHAR(100),
   fldAuthorEmail VARCHAR(100),
   fldAuthorWebsite VARCHAR(100),
   fldAuthorBlurb TEXT,
   fldAuthorPassword VARCHAR(50),
   Approved SMALLINT,
   fldAdmin INT DEFAULT 0 NOT NULL,
   INDEX (fldAuthorID),
   PRIMARY KEY (fldAuthorID)
);

#
# Table data for table tblAuthor
#

INSERT INTO tblAuthor (fldAuthorID, fldAuthorUsername, fldAuthorRealName, fldAuthorEmail, fldAuthorWebsite, fldAuthorBlurb, fldAuthorPassword, Approved, fldAdmin) VALUES (1, 'admin', 'asdf', 'asdf@asdf.com', 'http://domain.com', 'Test', 'password', 1, 1);

#
# Table structure for table tblBlog
#

DROP TABLE IF EXISTS tblBlog;
CREATE TABLE tblBlog (
   BlogID INT NOT NULL AUTO_INCREMENT,
   BlogHeadline VARCHAR(255) NOT NULL,
   BlogHTML TEXT NOT NULL,
   BlogDate DATETIME DEFAULT '0' NOT NULL,
   BlogCat INT,
   BlogAuthor INT,
   BlogCommentInclude SMALLINT,
   BlogReadMore SMALLINT,
   BlogDraft SMALLINT,
   INDEX (BlogID),
   PRIMARY KEY (BlogID)
);

#
# Table data for table tblBlog
#

INSERT INTO tblBlog (BlogID, BlogHeadline, BlogHTML, BlogDate, BlogCat, BlogAuthor, BlogCommentInclude, BlogReadMore, BlogDraft) VALUES (12, 'Introduction', '<BLOCKQUOTE dir=ltr style=\"MARGIN-RIGHT: 0px\"><P><EM>\"All happy families are alike; every unhappy family is unhappy in its own way.\" - Leo Tolstoy</EM></P></BLOCKQUOTE>', '2004-01-09 09:01:19', 1, 1, 1, 0, 0);

#
# Table structure for table tblBlogRSS
#

DROP TABLE IF EXISTS tblBlogRSS;
CREATE TABLE tblBlogRSS (
   rssID INT NOT NULL AUTO_INCREMENT,
   blogTitle VARCHAR(255) NOT NULL,
   blogSubTitle VARCHAR(255),
   blogDesc TEXT NOT NULL,
   blogURL VARCHAR(255) NOT NULL,
   blogImage VARCHAR(255) NOT NULL,
   blogAuthor VARCHAR(255) NOT NULL,
   blogEmail VARCHAR(255) NOT NULL,
   blogPosts INT,
   blogLayout INT DEFAULT 1 NOT NULL,
   PRIMARY KEY (rssID),
   INDEX (rssID)
);

#
# Table data for table tblBlogRSS
#

INSERT INTO tblBlogRSS (rssID, blogTitle, blogSubTitle, blogDesc, blogURL, blogImage, blogAuthor, blogEmail, blogPosts, blogLayout) VALUES (1, 'Blog Title', 'Sub Title', 'Blog Description', 'http://betaparticle.dyndns.org/', 'http://domain.com/blog/blog_button.jpg', 'asdf', 'asdf@asdf.com', 20, 4);

#
# Table structure for table tblCat
#

DROP TABLE IF EXISTS tblCat;
CREATE TABLE tblCat (
   CatID INT NOT NULL AUTO_INCREMENT,
   CatName VARCHAR(200),
   CatDesc VARCHAR(100),
   INDEX (CatID),
   PRIMARY KEY (CatID)
);

#
# Table data for table tblCat
#

INSERT INTO tblCat (CatID, CatName, CatDesc) VALUES (1, 'Blog', 'description');

#
# Table structure for table tblComment
#

DROP TABLE IF EXISTS tblComment;
CREATE TABLE tblComment (
   commentID INT NOT NULL AUTO_INCREMENT,
   blogID INT DEFAULT 0 NOT NULL,
   commentDate DATETIME DEFAULT '0' NOT NULL,
   commentName VARCHAR(255) NOT NULL,
   commentEmail VARCHAR(255),
   commentURL VARCHAR(255),
   commentHTML TEXT NOT NULL,
   commentInclude INT DEFAULT 0 NOT NULL,
   INDEX (blogID),
   INDEX (commentID),
   PRIMARY KEY (commentID)
);

#
# Table data for table tblComment
#

#
# Table structure for table tblGallery
#

DROP TABLE IF EXISTS tblGallery;
CREATE TABLE tblGallery (
   fldGalleryID INT NOT NULL AUTO_INCREMENT,
   fldGalleryTitle VARCHAR(100),
   fldGalleryDesc TEXT,
   fldGalleryPic VARCHAR(100),
   fldGalleryCreated DATETIME,
   fldGalleryUser INT DEFAULT 0 NOT NULL,
   INDEX (fldGalleryID),
   PRIMARY KEY (fldGalleryID)
);

#
# Table data for table tblGallery
#

#
# Table structure for table tblGalleryConfig
#

DROP TABLE IF EXISTS tblGalleryConfig;
CREATE TABLE tblGalleryConfig (
   fldGalleryConfigID INT NOT NULL AUTO_INCREMENT,
   fldGalleryTitleThumb SMALLINT,
   fldGalleryThumb SMALLINT,
   INDEX (fldGalleryConfigID),
   PRIMARY KEY (fldGalleryConfigID)
);

#
# Table data for table tblGalleryConfig
#

INSERT INTO tblGalleryConfig (fldGalleryConfigID, fldGalleryTitleThumb, fldGalleryThumb) VALUES (1, 200, 100);

#
# Table structure for table tblLayout
#

DROP TABLE IF EXISTS tblLayout;
CREATE TABLE tblLayout (
   layoutid INT NOT NULL AUTO_INCREMENT,
   layout1 TEXT,
   layout2 TEXT,
   layout3 TEXT,
   layout4 TEXT,
   layout5 TEXT,
   layoutTitle VARCHAR(100) NOT NULL,
   INDEX (layoutid),
   PRIMARY KEY (layoutid)
);

#
# Table data for table tblLayout
#

INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (3, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/Black Minima/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /><link rel=\"stylesheet\" href=\"css/lightbox.css\" type=\"text/css\" media=\"screen\" /><script src=\"js/prototype.js\" type=\"text/javascript\"></script><script src=\"js/scriptaculous.js?load=effects\" type=\"text/javascript\"></script>\t<script src=\"js/lightbox.js\" type=\"text/javascript\"></script></head><BODY><DIV id=container><DIV id=header>', '</DIV><DIV id=content><DIV id=main><!-- AdSense Code --><style type=\"text/css\"><!--.adsensefloat {\tmargin: 4px;\tpadding: 2px;\tfloat: right;\tmargin-top:10px;}--></style><div class=\"adsensefloat\"><script type=\"text/javascript\"><!--google_ad_client = \"pub-0172387945911790\";google_ad_width = 120;google_ad_height = 240;google_ad_format = \"120x240_as\";google_ad_channel =\"7792557859\";google_color_border = \"000000\";google_color_bg = \"000000\";google_color_link = \"AADD99\";google_color_text = \"CCCCCC\";google_color_url = \"AADD99\";//--></script><script type=\"text/javascript\"  src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\"></script></div><!-- AdSense Code -->', '</DIV><DIV id=sidebar><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About/Download BP Blog</a></li></ul><p style=\"text-align:center;\" ><strong>Get BP Blog Updates by Email</strong></p><form style=\"text-align:center;\" action=\"http://www.feedburner.com/fb/a/emailverify\" method=\"post\" target=\"_blank\"><p>Enter your email address:</p><p><input name=\"email\" type=\"text\" style=\"width:140px\" size=\"20\"/></p><input type=\"hidden\" value=\"http://feeds.feedburner.com/~e?ffid=574457\" name=\"url\"/><input type=\"hidden\" value=\"BP Blog\" name=\"title\"/><input type=\"submit\" value=\"Subscribe\" /><p>Delivered by <a href=\"http://www.feedburner.com/\" target=\"_blank\">FeedBurner</a></p></form>', '</DIV> </DIV><DIV id=footer><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></DIV>\t</DIV>\t </BODY></HTML>', 'Black Minima');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (4, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/White Minima/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><BODY><DIV id=container><DIV id=header>', '</DIV><DIV id=content><DIV id=main>', '</DIV><DIV id=sidebar><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"template_gallery.asp\">Gallery</a></li></ul>', '</DIV> </DIV><DIV id=footer><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></DIV>\t</DIV>\t </BODY></HTML>', 'White Minima');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (5, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/Rounders/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><body><!-- Begin #content - Centers all content and provides edges for floated columns --><div id=\"content\"><!-- Blog Header --><div id=\"header\"><div> ', '</div></div><!-- Begin #main - Contains main-column blog content --><div id=\"main\"><div id=\"main2\"><div id=\"main3\">', '</div></div></div><!-- End #main --><!-- Begin #sidebar --><div id=\"sidebar\">  <!-- Begin #profile-container -->  <div id=\"profile-container\">    <h2 class=\"sidebar-title\">Profile</h2>      <dl class=\"profile-datablock\">      <dt class=\"profile-img\"><img src=\"http://betaparticle.com/blog/Films_Covers/50.jpg\" alt=\"\" /></dt>      <dd class=\"profile-data\"><strong>Name:</strong>Matt</dd>      <dd class=\"profile-data\"><strong>Location:</strong> Atlanta, GA</dd>    </dl>      <p class=\"profile-textblock\">I am the administrator and programmer of BP Blog.    </p>      <p class=\"profile-link\">      <a href=\"template_author.asp?id=1\">View my complete profile</a>    </p>  </div>  <!-- End #profile -->  <div class=\"box\"><div class=\"box2\"><div class=\"box3\"><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"http://www.betaparticle.com/wiki/BP-Blog.ashx\" target=\"_blank\">Readme/Download</a></li></ul><p style=\"text-align:center;\" ><strong>Get BP Blog Updates by Email</strong></p><form style=\"text-align:center;\" action=\"http://www.feedburner.com/fb/a/emailverify\" method=\"post\" target=\"_blank\"><p>Enter your email address:</p><p><input name=\"email\" type=\"text\" style=\"width:140px\" size=\"20\"/></p><input type=\"hidden\" value=\"http://feeds.feedburner.com/~e?ffid=574457\" name=\"url\"/><input type=\"hidden\" value=\"BP Blog\" name=\"title\"/><input type=\"submit\" value=\"Subscribe\" /><p>Delivered by <a href=\"http://www.feedburner.com/\" target=\"_blank\">FeedBurner</a></p></form>', '<div align=\"center\">  <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"4\" cellspacing=\"0\">    <tbody>      <tr>        <td valign=\"middle\" align=\"center\" width=\"50%\"><h3><strong>Donate and support the development of BP Blog</strong></h3>            <p>and receive </p>          <p><strong>Personal Email Support</strong></p>          <form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\">            <input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\" />            <input type=\"image\" alt=\"Make payments with PayPal - it\'s fast, free and secure!\" src=\"https://www.paypal.com/en_US/i/btn/x-click-but21.gif\" border=\"0\" name=\"submit2\" />            <input type=\"hidden\" name=\"encrypted\" value=\"-----BEGIN PKCS7-----MIIHHgYJKoZIhvcNAQcEoIIHDzCCBwsCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYAm8sglAko2MddqkparOFQ7oNDbMw/MjhDQSaHoBTmy2pamjmXjE1fQRk6NJnpLwC8QlVTu1XuGoWxJcWv3dfPQFag/4C4jbFq2z0stpTG/yPIgn9yWQLvlHa43lHtAJ3rfSbv7r/OOqc/8aRcRV1zhdHf5p/52b/TVrufvRPzr6zELMAkGBSsOAwIaBQAwgZsGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIWFZc0A1zrU2AePmn6vwT/welbsvcLDhayG8YE2JoJdy+7NBsBlpEYgONjo6H9IX3FbXbpQZd38kRaBs/u6/dNeDDbDUkw1Pi5lYWEcAYkuAxzCxWHVU8O6AwDse/j2Sb3GvVufvREgsu2UPlhLrbUuzl72inuDENFSDr299HHgyw3qCCA4cwggODMIIC7KADAgECAgEAMA0GCSqGSIb3DQEBBQUAMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTAeFw0wNDAyMTMxMDEzMTVaFw0zNTAyMTMxMDEzMTVaMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAwUdO3fxEzEtcnI7ZKZL412XvZPugoni7i7D7prCe0AtaHTc97CYgm7NsAtJyxNLixmhLV8pyIEaiHXWAh8fPKW+R017+EmXrr9EaquPmsVvTywAAE1PMNOKqo2kl4Gxiz9zZqIajOm1fZGWcGS0f5JQ2kBqNbvbg2/Za+GJ/qwUCAwEAAaOB7jCB6zAdBgNVHQ4EFgQUlp98u8ZvF71ZP1LXChvsENZklGswgbsGA1UdIwSBszCBsIAUlp98u8ZvF71ZP1LXChvsENZklGuhgZSkgZEwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tggEAMAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQEFBQADgYEAgV86VpqAWuXvX6Oro4qJ1tYVIT5DgWpE692Ag422H7yRIr/9j/iKG4Thia/Oflx4TdL+IFJBAyPK9v6zZNZtBgPBynXb048hsP16l2vi0k5Q2JKiPDsEfBhGI+HnxLXEaUWAcVfCsQFvd2A1sxRr67ip5y2wwBelUecP3AjJ+YcxggGaMIIBlgIBATCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwCQYFKw4DAhoFAKBdMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA0MDYyMjE1MjYwMFowIwYJKoZIhvcNAQkEMRYEFBSwjOhBPZHWd9BKxnTuevKd61hyMA0GCSqGSIb3DQEBAQUABIGAC7EJJzTaBiswTocK7Q75RigH+EyeUGmgRPblUBUDRIIWWypMexlLFDJTvVOj2hfO0MVRrB24EiyVODFfjchJeAW+3F9arAo5AkXZr3RV+BjOyPeT0RT8PQYwyv/KIZWIycKa3kG5bTLjZXe/6l/HlwiJ1s0ljN3s1tczHmSTiYU=-----END PKCS7-----                \" />          </form></td>      </tr>    </tbody>  </table></div><h2 class=\"sidebar-title\">Meta</h2><ul>\t<li><a href=\"rss.xml\" title=\"Syndicate this site (RSS XML 2.0)\"><img src=\"images/feed-icon-32x32.png\" border=\"0\" alt=\"Syndicate this site (RSS XML 2.0)\" /></a></li>\t<li>Powered by <a href=\"http://blog.betaparticle.com/\">bp blog 7.0</a></li>\t<li>This weblog is licensed under a <a href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" target=\"_blank\">Creative Commons License</a></li></ul><p><script type=\"text/javascript\"><!--google_ad_client = \"pub-0172387945911790\";google_ad_width = 120;google_ad_height = 600;google_ad_format = \"120x600_as\";google_ad_type = \"text\";google_ad_channel =\"7792557859\";google_color_border = \"ffffff\";google_color_bg = \"ffffff\";google_color_link = \"AADD99\";google_color_text = \"CCCCCC\";google_color_url = \"AADD99\";//--></script><script type=\"text/javascript\"  src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\"></script></p>    </div></div></div>  <!-- End .box --></div><!-- End #sidebar --><!-- Begin #footer --><div id=\"footer\"><div><div><hr /><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></div></div></div><!-- End #footer --></div><!-- End #content --></body></html>', 'Rounders');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (6, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/Dots/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><body><!-- Begin #content - Centers all content and provides edges for floated columns --><div id=\"content\"><!-- Blog Header --><div id=\"header\"><div>', '</div></div><!-- Begin #main - Contains main-column blog content --><div id=\"main\"><div id=\"main2\"><div id=\"main3\">', '</div></div></div><!-- End #main --><!-- Begin #sidebar --><div id=\"sidebar\">  <!-- Begin #profile-container -->  <div id=\"profile-container\">    <h2 class=\"sidebar-title\">Profile</h2>      <dl class=\"profile-datablock\">      <dt class=\"profile-img\"><img src=\"http://betaparticle.com/blog/Films_Covers/50.jpg\" alt=\"\" /></dt>      <dd class=\"profile-data\"><strong>Name:</strong>Matt</dd>      <dd class=\"profile-data\"><strong>Location:</strong> Atlanta, GA</dd>    </dl>      <p class=\"profile-textblock\">I am the administrator and programmer of BP Blog.    </p>      <p class=\"profile-link\">      <a href=\"template_author.asp?id=1\">View my complete profile</a>    </p>  </div>  <!-- End #profile -->  <div class=\"box\"><div class=\"box2\"><div class=\"box3\"><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"template_gallery.asp\">Gallery</a></li></ul>', '    </div></div></div>  <!-- End .box --></div><!-- End #sidebar --><!-- Begin #footer --><div id=\"footer\"><div><div><hr /><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></div></div></div><!-- End #footer --></div><!-- End #content --></body></html>', 'Dots');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (7, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/Blue Minima/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><BODY><DIV id=container><DIV id=header>', '</DIV><DIV id=content><DIV id=main>', '</DIV><DIV id=sidebar><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"template_gallery.asp\">Gallery</a></li></ul>', '</DIV> </DIV><DIV id=footer><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></DIV>\t</DIV>\t </BODY></HTML>', 'Blue Minima');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (8, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/Snapshot/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><body><!-- Begin #content - Centers all content and provides edges for floated columns --><div id=\"content\"><div id=\"header\"><div>', '</div></div><!-- Begin #main - Contains main-column blog content --><div id=\"main\">', '</div><!-- End #main --><!-- Begin #sidebar --><div id=\"sidebar\">  <!-- Begin #profile-container -->  <div id=\"profile-container\">    <h2 class=\"sidebar-title\">Profile</h2>      <dl class=\"profile-datablock\">      <dt class=\"profile-img\"><img src=\"http://betaparticle.com/blog/Films_Covers/50.jpg\" alt=\"\" /></dt>      <dd class=\"profile-data\"><strong>Name:</strong>Matt</dd>      <dd class=\"profile-data\"><strong>Location:</strong> Atlanta, GA</dd>    </dl>      <p class=\"profile-textblock\">I am the administrator and programmer of BP Blog.    </p>      <p class=\"profile-link\">      <a href=\"template_author.asp?id=1\">View my complete profile</a>    </p>  </div>  <!-- End #profile -->  <div class=\"box\"><div class=\"box2\"><div class=\"box3\"><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"template_gallery.asp\">Gallery</a></li></ul>', '</div><!-- End #sidebar --><!-- Begin #footer --><div id=\"footer\"><hr /><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></div><!-- End #footer --></div><!-- End #content --></body></html>', 'Snapshot');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (9, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"Themes/ms_moto/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><body><!-- Begin wrapper --><div id=\"wrapper\">  <div id=\"blog-header\">', '</div><!-- Begin content --><div id=\"content\">  <!-- Begin main column -->\t<div id=\"main\">', '  <!-- End main column -->\t\t</div>\t\t\t<div id=\"sidebar\">  <!-- Begin #profile-container -->  <div id=\"profile-container\">    <h2 class=\"sidebar-title\">Profile</h2>      <dl class=\"profile-datablock\">      <dt class=\"profile-img\"><img src=\"http://betaparticle.com/blog/Films_Covers/50.jpg\" alt=\"\" /></dt>      <dd class=\"profile-data\"><strong>Name:</strong>Matt</dd>      <dd class=\"profile-data\"><strong>Location:</strong> Atlanta, GA</dd>    </dl>      <p class=\"profile-textblock\">I am the administrator and programmer of BP Blog.    </p>      <p class=\"profile-link\">      <a href=\"template_author.asp?id=1\">View my complete profile</a>    </p>  </div>  <!-- End #profile -->  <div class=\"box\"><div class=\"box2\"><div class=\"box3\"><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"template_gallery.asp\">Gallery</a></li></ul>', '  <!-- End sidebar -->  </div><!-- End content --></div><div id=\"footer\"><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></div><!-- End wrapper --></div></body></html>', 'Ms. Moto (Pinky Lee variation)');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (10, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\"><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" /><meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />', '<link href=\"styles/style.css\" rel=\"stylesheet\" type=\"text/css\" /><script type=\"text/javascript\" src=\"js/prototype.js\"></script><script type=\"text/javascript\" src=\"js/scriptaculous.js?load=effects\"></script><script type=\"text/javascript\" src=\"js/lightbox.js\"></script><link rel=\"stylesheet\" href=\"css/lightbox.css\" type=\"text/css\" media=\"screen\" /><link href=\"Themes/Minima 2/styles-site.css\" rel=\"stylesheet\" type=\"text/css\" /></head><BODY><DIV id=container><DIV id=header>', '</DIV><DIV id=content><DIV id=main>', '</DIV><DIV id=sidebar><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"http://www.betaparticle.com/wiki/BP-Blog.ashx\" target=\"_blank\">Readme/Download</a></li></ul><p style=\"text-align:center;\" ><strong>Get BP Blog Updates by Email</strong></p><form style=\"text-align:center;\" action=\"http://www.feedburner.com/fb/a/emailverify\" method=\"post\" target=\"_blank\"><p>Enter your email address:</p><p><input name=\"email\" type=\"text\" style=\"width:140px\" size=\"20\"/></p><input type=\"hidden\" value=\"http://feeds.feedburner.com/~e?ffid=574457\" name=\"url\"/><input type=\"hidden\" value=\"BP Blog\" name=\"title\"/><input type=\"submit\" value=\"Subscribe\" /><p>Delivered by <a href=\"http://www.feedburner.com/\" target=\"_blank\">FeedBurner</a></p></form><div align=\"center\">  <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"4\" cellspacing=\"0\">    <tbody>      <tr>        <td valign=\"middle\" align=\"center\" width=\"50%\"><h3><strong>Donate and support the development of BP Blog</strong></h3>            <p>and receive </p>          <p><strong>Personal Email Support</strong></p>          <form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\">            <input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\" />            <input type=\"image\" alt=\"Make payments with PayPal - it\'s fast, free and secure!\" src=\"https://www.paypal.com/en_US/i/btn/x-click-but21.gif\" border=\"0\" name=\"submit2\" />            <input type=\"hidden\" name=\"encrypted\" value=\"-----BEGIN PKCS7-----MIIHHgYJKoZIhvcNAQcEoIIHDzCCBwsCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYAm8sglAko2MddqkparOFQ7oNDbMw/MjhDQSaHoBTmy2pamjmXjE1fQRk6NJnpLwC8QlVTu1XuGoWxJcWv3dfPQFag/4C4jbFq2z0stpTG/yPIgn9yWQLvlHa43lHtAJ3rfSbv7r/OOqc/8aRcRV1zhdHf5p/52b/TVrufvRPzr6zELMAkGBSsOAwIaBQAwgZsGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIWFZc0A1zrU2AePmn6vwT/welbsvcLDhayG8YE2JoJdy+7NBsBlpEYgONjo6H9IX3FbXbpQZd38kRaBs/u6/dNeDDbDUkw1Pi5lYWEcAYkuAxzCxWHVU8O6AwDse/j2Sb3GvVufvREgsu2UPlhLrbUuzl72inuDENFSDr299HHgyw3qCCA4cwggODMIIC7KADAgECAgEAMA0GCSqGSIb3DQEBBQUAMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTAeFw0wNDAyMTMxMDEzMTVaFw0zNTAyMTMxMDEzMTVaMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAwUdO3fxEzEtcnI7ZKZL412XvZPugoni7i7D7prCe0AtaHTc97CYgm7NsAtJyxNLixmhLV8pyIEaiHXWAh8fPKW+R017+EmXrr9EaquPmsVvTywAAE1PMNOKqo2kl4Gxiz9zZqIajOm1fZGWcGS0f5JQ2kBqNbvbg2/Za+GJ/qwUCAwEAAaOB7jCB6zAdBgNVHQ4EFgQUlp98u8ZvF71ZP1LXChvsENZklGswgbsGA1UdIwSBszCBsIAUlp98u8ZvF71ZP1LXChvsENZklGuhgZSkgZEwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tggEAMAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQEFBQADgYEAgV86VpqAWuXvX6Oro4qJ1tYVIT5DgWpE692Ag422H7yRIr/9j/iKG4Thia/Oflx4TdL+IFJBAyPK9v6zZNZtBgPBynXb048hsP16l2vi0k5Q2JKiPDsEfBhGI+HnxLXEaUWAcVfCsQFvd2A1sxRr67ip5y2wwBelUecP3AjJ+YcxggGaMIIBlgIBATCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwCQYFKw4DAhoFAKBdMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA0MDYyMjE1MjYwMFowIwYJKoZIhvcNAQkEMRYEFBSwjOhBPZHWd9BKxnTuevKd61hyMA0GCSqGSIb3DQEBAQUABIGAC7EJJzTaBiswTocK7Q75RigH+EyeUGmgRPblUBUDRIIWWypMexlLFDJTvVOj2hfO0MVRrB24EiyVODFfjchJeAW+3F9arAo5AkXZr3RV+BjOyPeT0RT8PQYwyv/KIZWIycKa3kG5bTLjZXe/6l/HlwiJ1s0ljN3s1tczHmSTiYU=-----END PKCS7-----                \" />          </form></td>      </tr>    </tbody>  </table></div><h2 class=\"sidebar-title\">Meta</h2><ul>\t<li><a href=\"rss.xml\" title=\"Syndicate this site (RSS XML 2.0)\"><img src=\"images/feed-icon-32x32.png\" border=\"0\" alt=\"Syndicate this site (RSS XML 2.0)\" /></a></li>\t<li>Powered by <a href=\"http://blog.betaparticle.com/\">bp blog 7.0</a></li>\t<li>This weblog is licensed under a <a href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" target=\"_blank\">Creative Commons License</a></li></ul><p><script type=\"text/javascript\"><!--google_ad_client = \"pub-0172387945911790\";google_ad_width = 120;google_ad_height = 600;google_ad_format = \"120x600_as\";google_ad_type = \"text\";google_ad_channel =\"7792557859\";google_color_border = \"ffffff\";google_color_bg = \"ffffff\";google_color_link = \"AADD99\";google_color_text = \"CCCCCC\";google_color_url = \"AADD99\";//--></script><script type=\"text/javascript\"  src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\"></script></p> ', '</DIV> </DIV><DIV id=footer><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></DIV>\t</DIV>\t </BODY></HTML>', 'Minima 2');
INSERT INTO tblLayout (layoutid, layout1, layout2, layout3, layout4, layout5, layoutTitle) VALUES (11, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"><html xmlns=\"http://www.w3.org/1999/xhtml\"><head profile=\"http://gmpg.org/xfn/11\">\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" /> <meta name=\"generator\" content=\"BP Blog 7.0\" /><link rel=\"copyright\" href=\"http://creativecommons.org/licenses/by-nc-sa/2.5/\" />  ', '<link href=\"Themes/Kubrick/style.css\" rel=\"stylesheet\" type=\"text/css\" /></head><body><div id=\"page\"><div id=\"header\">\t<div id=\"headerimg\">', '</div></div><hr />\t<div id=\"content\" class=\"narrowcolumn\"> ', '</div>\t<div id=\"sidebar\"><h2 class=sidebar-title>Menu</h2><ul><li><a href=\"default.asp\">Home</a></li><li><a href=\"template.asp?pagename=about\">About BP Blog</a></li><li><a href=\"template_gallery.asp\">Gallery</a></li></ul>  ', '</div><hr /><div id=\"footer\"><P>Powered by <a href=\"http://blog.betaparticle.com\" title=\"Powered by BP Blog 7.0\">BP Blog 7.0</a>\t\t | <a href=\"rss.xml\">Feed (RSS)</a></P></div></div><!-- Gorgeous design by Michael Heilemann - http://binarybonsai.com/kubrick/ -->\t\t</body></html>', 'Kubrick');

#
# Table structure for table tblPage
#

DROP TABLE IF EXISTS tblPage;
CREATE TABLE tblPage (
   PageName VARCHAR(50),
   PageTitle VARCHAR(255) NOT NULL,
   PageHTML TEXT NOT NULL,
   PageDate DATETIME DEFAULT '0' NOT NULL
);

#
# Table data for table tblPage
#

INSERT INTO tblPage (PageName, PageTitle, PageHTML, PageDate) VALUES ('about', 'About BP Blog', '<P>bp blog is a blog software coded in ASP.</P><P>It should work on any server with IIS 4.0+.&nbsp; Use IE 5.0+ or Firefox as your browser for updating pages.</P><P>Download:<BR>6.0<BR><A href=\"http://blog.betaparticle.com/uploads/blog_6.0.zip\">http://blog.betaparticle.com/uploads/blog_6.0.zip</A><BR>5.0b (previous version)<BR><A href=\"http://blog.betaparticle.com/uploads/blog_5.0b.zip\">http://blog.betaparticle.com/uploads/blog_5.0b.zip</A><BR>&nbsp;<BR>Features:<BR>- ASP 3.0<BR>- HTML Editor with image/file upload<BR>- Only one line of code to change (the connection string to your Access database)!<BR>- Simple Gallery</P><P>Requirements:<BR>- IIS 4.0+<BR>- Read/write access on the server (FSO)<BR>- MSXML</P><P><A href=\"readme.txt\">Changelog</A></P><!-------><TABLE borderColor=#840300 cellSpacing=0 cellPadding=0 width=150 bgColor=#d70500 border=1><FORM action=http://www.hotscripts.com/rate/31715.html method=post><TBODY><TR><TD><TABLE cellSpacing=0 cellPadding=2 width=\"100%\" border=0><TBODY><TR align=middle bgColor=#aa0400><TD colSpan=2><B><FONT color=#ffffff>Rate Our Program <INPUT type=hidden name=external> </FONT></B></TD></TR><TR><TD align=right><INPUT type=radio name=rate></TD><TD><FONT color=#ffffff>Excellent!</FONT></TD></TR><TR><TD align=right><INPUT type=radio name=rate></TD><TD><FONT color=#ffffff>Very Good</FONT></TD></TR><TR><TD align=right><INPUT type=radio name=rate></TD><TD><FONT color=#ffffff>Good</FONT></TD></TR><TR><TD align=right><INPUT type=radio name=rate></TD><TD><FONT color=#ffffff>Fair</FONT></TD></TR><TR><TD align=right><INPUT type=radio name=rate></TD><TD><FONT color=#ffffff>Poor</FONT></TD></TR><TR align=middle><TD colSpan=2><INPUT type=submit value=\"Submit Query\" name=submit2></TD></TR></TBODY></TABLE></TD></TR></TBODY></FORM></TABLE><BR><!------- End of HTML Code -------><TABLE cellSpacing=0 cellPadding=1 width=\"100%\" align=center bgColor=#000000 border=0><TBODY><TR><TD align=middle><TABLE cellSpacing=0 cellPadding=3 bgColor=#eeeedd border=0><TBODY><TR><TD align=middle><FONT style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial\"><B>Rated:</B> <A href=\"http://www.aspin.com/func/review?id=5981710\"><IMG src=\"http://ratings.aspin.com/getstars?id=5981710\" border=0></A> <FONT style=\"FONT-SIZE: 8pt\"><BR>by <A href=\"http://www.aspin.com/\">Aspin.com</A> users<BR></FONT></FONT></TD></TR><TR><FORM action=http://www.Aspin.com/func/review/write?id=5981710 method=post><TD align=middle><FONT style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial\">What do you think?</FONT><BR><SELECT name=VoteStars><OPTION selected>5 Stars</OPTION><OPTION>4 Stars</OPTION><OPTION>3 Stars</OPTION><OPTION>2 Stars</OPTION><OPTION>1 Star</OPTION></SELECT><INPUT type=submit value=\"Submit Query\"> </TD></FORM></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>', '2004-01-09 09:01:19');
INSERT INTO tblPage (PageName, PageTitle, PageHTML, PageDate) VALUES ('thanks', 'Thank you for your comments!', '<p>Your comments are subject to approval.</p>', '2005-02-15 13:27:39');
INSERT INTO tblPage (PageName, PageTitle, PageHTML, PageDate) VALUES ('thankyou', 'Thank you for registering', '<p>You will be contacted via email when you are approved.&nbsp; Be sure and upated your profile when you log back in after approval.</p>', '2006-11-04 11:09:29');

The End!