$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page (id, title, slug, breadcrumb, parent_id, layout_id, behavior_id, status_id, created_on, published_on, updated_on, created_by_id, updated_by_id, position, is_protected) VALUES (5, 'My first article', 'my_first_article', 'My first article', 4, 0, '', 100, '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1, 0, 0)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page (id, title, slug, breadcrumb, parent_id, layout_id, behavior_id, status_id, created_on, published_on, updated_on, created_by_id, updated_by_id, position, is_protected) VALUES (6, 'My second article', 'my_second_article', 'My second article', 4, 0, '', 100, '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1, 0, 0)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page (id, title, slug, breadcrumb, parent_id, layout_id, behavior_id, status_id, created_on, published_on, updated_on, created_by_id, updated_by_id, position, is_protected) VALUES (7, '%B %Y archive', 'monthly_archive', '%B %Y archive', 4, 0, 'archive_month_index', 101, '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1, 0, 1)");
// Dumping data for table: page_part ----------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (1, 'body', '', '<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<?php \$last_article = \$page_article->children(array(''limit'' => 1, ''order'' => ''page.created_on DESC'')); ?>\r\n\r\n<div class=\"first entry\">\r\n <h3><?php echo \$last_article->link(); ?></h3>\r\n <?php echo \$last_article->content(); ?>\r\n <?php if (\$last_article->hasContent(''extended'')) echo \$last_article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$last_article->author(); ?> on <?php echo \$last_article->date(); ?></p>\r\n</div>\r\n\r\n<?php foreach (\$page_article->children(array(''limit'' => 4, ''offset'' => 1, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <?php if (\$article->hasContent(''extended'')) echo \$article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?></p>\r\n</div>\r\n<?php endforeach; ?>\r\n', '<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<?php \$last_article = \$page_article->children(array(''limit'' => 1, ''order'' => ''page.created_on DESC'')); ?>\r\n\r\n<div class=\"first entry\">\r\n <h3><?php echo \$last_article->link(); ?></h3>\r\n <?php echo \$last_article->content(); ?>\r\n <?php if (\$last_article->hasContent(''extended'')) echo \$last_article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$last_article->author(); ?> on <?php echo \$last_article->date(); ?></p>\r\n</div>\r\n\r\n<?php foreach (\$page_article->children(array(''limit'' => 4, ''offset'' => 1, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <?php if (\$article->hasContent(''extended'')) echo \$article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?></p>\r\n</div>\r\n<?php endforeach; ?>\r\n', 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (2, 'body', '', '<?php echo ''<?''; ?>xml version=\"1.0\" encoding=\"UTF-8\"<?php echo ''?>''; ?> \r\n<rss version=\"2.0\">\r\n<channel>\r\n\t<title>Frog CMS</title>\r\n\t<link>http://www.madebyfrog.com/</link>\r\n\t<language>en-us</language>\r\n\t<copyright>Copyright <?php echo date(''Y''); ?>, philwork.com</copyright>\r\n\t<pubDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S +0000''); ?></pubDate>\r\n\t<lastBuildDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S +0000''); ?></lastBuildDate>\r\n\t<category>CMS</category>\r\n\t<generator>Frog CMS</generator>\r\n\t<description>The main news feed from Frog CMS.</description>\r\n\t<docs>http://www.rssboard.org/rss-specification</docs>\r\n\t<atom:link href=\"<?php echo BASE_URL ?>rss\" rel=\"self\" type=\"application/rss+xml\" />\r\n\r\n<?php \$articles = \$this->find(''articles''); ?>\r\n<?php foreach (\$articles->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?> \r\n\t<item>\r\n\t\t<title><?php echo \$article->title(); ?></title>\r\n\t\t<description><?php if (\$article->hasContent(''summary'')) { echo \$article->content(''summary''); } else { echo strip_tags(\$article->content()); } ?></description>\r\n\t\t<pubDate><?php echo \$article->date(''%a, %d %b %Y %H:%M:%S +0000''); ?></pubDate>\r\n\t\t<link><?php echo \$article->url(); ?></link>\r\n\t\t<guid><?php echo \$article->url(); ?></guid>\r\n\t</item>\r\n<?php endforeach; ?> \r\n</channel>\r\n</rss>\r\n\r\n', '<?php echo ''<?''; ?>xml version=\"1.0\" encoding=\"UTF-8\"<?php echo ''?>''; ?> \r\n<rss version=\"2.0\">\r\n<channel>\r\n\t<title>Frog CMS</title>\r\n\t<link>http://www.madebyfrog.com/</link>\r\n\t<language>en-us</language>\r\n\t<copyright>Copyright <?php echo date(''Y''); ?>, philwork.com</copyright>\r\n\t<pubDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S +0000''); ?></pubDate>\r\n\t<lastBuildDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S +0000''); ?></lastBuildDate>\r\n\t<category>CMS</category>\r\n\t<generator>Frog CMS</generator>\r\n\t<description>The main news feed from Frog CMS.</description>\r\n\t<docs>http://www.rssboard.org/rss-specification</docs>\r\n\t<atom:link href=\"<?php echo BASE_URL ?>rss\" rel=\"self\" type=\"application/rss+xml\" />\r\n\r\n<?php \$articles = \$this->find(''articles''); ?>\r\n<?php foreach (\$articles->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?> \r\n\t<item>\r\n\t\t<title><?php echo \$article->title(); ?></title>\r\n\t\t<description><?php if (\$article->hasContent(''summary'')) { echo \$article->content(''summary''); } else { echo strip_tags(\$article->content()); } ?></description>\r\n\t\t<pubDate><?php echo \$article->date(''%a, %d %b %Y %H:%M:%S +0000''); ?></pubDate>\r\n\t\t<link><?php echo \$article->url(); ?></link>\r\n\t\t<guid><?php echo \$article->url(); ?></guid>\r\n\t</item>\r\n<?php endforeach; ?> \r\n</channel>\r\n</rss>\r\n\r\n', 2)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (3, 'body', 'textile', 'This is my site. I''m living in ... I''m doing some nice thing, like that and that ...', '\t<p>This is my site. I’m living in … I’m doing some nice thing, like that and that …</p>', 3)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (4, 'body', '', '<?php \$last_articles = \$this->children(array(''limit''=>5, ''order''=>''page.created_on DESC'')); ?>\r\n<?php foreach (\$last_articles as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(\$article->title); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?> \r\n <br />tags: <?php echo join('', '', \$article->tags()); ?>\r\n </p>\r\n</div>\r\n<?php endforeach; ?>\r\n\r\n', '<?php \$last_articles = \$this->children(array(''limit''=>5, ''order''=>''page.created_on DESC'')); ?>\r\n<?php foreach (\$last_articles as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(\$article->title); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?> \r\n <br />tags: <?php echo join('', '', \$article->tags()); ?>\r\n </p>\r\n</div>\r\n<?php endforeach; ?>\r\n\r\n', 4)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (5, 'body', 'markdown', 'My **first** tet of my first article that use Markdown', '<p>My <strong>first</strong> tet of my first article that use Markdown</p>\n', 5)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (7, 'body', 'markdown', 'This is you second article', '<p>This is you second article</p>\n', 6)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (8, 'body', '', '<?php \$archives = \$this->archive->get(); ?>\r\n<?php foreach (\$archives as \$archive): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$archive->link(); ?></h3>\r\n <p class=\"info\">Posted by <?php echo \$archive->author(); ?> on <?php echo \$archive->date(); ?> \r\n </p>\r\n</div>\r\n<?php endforeach; ?>', '<?php \$archives = \$this->archive->get(); ?>\r\n<?php foreach (\$archives as \$archive): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$archive->link(); ?></h3>\r\n <p class=\"info\">Posted by <?php echo \$archive->author(); ?> on <?php echo \$archive->date(); ?> \r\n </p>\r\n</div>\r\n<?php endforeach; ?>', 7)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (9, 'sidebar', '', '<h3>About Me</h3>\r\n\r\n<p>I''m just a demonstration of how easy it is to use Frog CMS to power a blog. <a href=\"<?php echo BASE_URL; ?>about_us\">more ...</a></p>\r\n\r\n<h3>Favorite Sites</h3>\r\n<ul>\r\n <li><a href=\"http://www.madebyfrog.com\">Frog CMS</a></li>\r\n <li><a href=\"http://www.philworks.com\">Philworks</a></li>\r\n</ul>\r\n\r\n<?php if(url_match(''/'')): ?>\r\n<h3>Recent Entries</h3>\r\n<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<ul>\r\n<?php foreach (\$page_article->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n <li><?php echo \$article->link(); ?></li> \r\n<?php endforeach; ?>\r\n</ul>\r\n<?php endif; ?>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>articles\">Archives</a>\r\n\r\n<h3>Syndicate</h3>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>rss\">Articles RSS Feed</a>', '<h3>About Me</h3>\r\n\r\n<p>I''m just a demonstration of how easy it is to use Frog CMS to power a blog. <a href=\"<?php echo BASE_URL; ?>about_us\">more ...</a></p>\r\n\r\n<h3>Favorite Sites</h3>\r\n<ul>\r\n <li><a href=\"http://www.madebyfrog.com\">Frog CMS</a></li>\r\n <li><a href=\"http://www.philworks.com\">Philworks</a></li>\r\n</ul>\r\n\r\n<?php if(url_match(''/'')): ?>\r\n<h3>Recent Entries</h3>\r\n<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<ul>\r\n<?php foreach (\$page_article->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n <li><?php echo \$article->link(); ?></li> \r\n<?php endforeach; ?>\r\n</ul>\r\n<?php endif; ?>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>articles\">Archives</a>\r\n\r\n<h3>Syndicate</h3>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>rss\">Articles RSS Feed</a>', 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (10, 'sidebar', '', '<?php \$article = \$this->find(''articles''); ?>\r\n<?php \$archives = \$article->archive->archivesByMonth(); ?>\r\n\r\n<h3>Archives By Month</h3>\r\n<ul>\r\n<?php foreach (\$archives as \$date): ?>\r\n <li><a href=\"<?php echo BASE_URL . \$this->url .''/''. \$date . URL_SUFFIX; ?>\"><?php echo strftime(''%B %Y'', strtotime(strtr(\$date, ''/'', ''-''))); ?></a></li>\r\n<?php endforeach; ?>\r\n</ul>', '<?php \$article = \$this->find(''articles''); ?>\r\n<?php \$archives = \$article->archive->archivesByMonth(); ?>\r\n\r\n<h3>Archives By Month</h3>\r\n<ul>\r\n<?php foreach (\$archives as \$date): ?>\r\n <li><a href=\"<?php echo BASE_URL . \$this->url .''/''. \$date . URL_SUFFIX; ?>\"><?php echo strftime(''%B %Y'', strtotime(strtr(\$date, ''/'', ''-''))); ?></a></li>\r\n<?php endforeach; ?>\r\n</ul>', 4)");
// Dumping data for table: permission ---------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "permission (id, name) VALUES (1, 'administrator')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "permission (id, name) VALUES (2, 'developer')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "permission (id, name) VALUES (3, 'editor')");
// Dumping data for table: setting ------------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('admin_title', 'Frog CMS')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('language', 'en')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('theme', 'default')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('default_status_id', '1')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('default_filter_id', '')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('plugins', 'a:5:{s:7:\"textile\";i:1;s:8:\"markdown\";i:1;s:7:\"archive\";i:1;s:14:\"page_not_found\";i:1;s:12:\"file_manager\";i:1;}')");
// Dumping data for table: snippet ------------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "snippet (id, name, filter_id, content, content_html, created_on, updated_on, created_by_id, updated_by_id) VALUES (1, 'header', '', '<div id=\"header\">\r\n <h1><a href=\"<?php echo URL_PUBLIC; ?>\">Frog</a> <span>content management simplified</span></h1>\r\n <div id=\"nav\">\r\n <ul>\r\n <li><a<?php echo url_match(''/'') ? '' class=\"current\"'': ''''; ?> href=\"<?php echo URL_PUBLIC; ?>\">home</a></li>\r\n<?php foreach(\$this->find(''/'')->children() as \$menu): ?>\r\n <li><?php echo \$menu->link(\$menu->title, (in_array(\$menu->slug, explode(''/'', \$this->url)) ? '' class=\"current\"'': null)); ?></li>\r\n<?php endforeach; ?> \r\n </ul>\r\n </div> <!-- end #navigation -->\r\n</div> <!-- end #header -->', '<div id=\"header\">\r\n <h1><a href=\"<?php echo URL_PUBLIC; ?>\">Frog</a> <span>content management simplified</span></h1>\r\n <div id=\"nav\">\r\n <ul>\r\n <li><a<?php echo url_match(''/'') ? '' class=\"current\"'': ''''; ?> href=\"<?php echo URL_PUBLIC; ?>\">home</a></li>\r\n<?php foreach(\$this->find(''/'')->children() as \$menu): ?>\r\n <li><?php echo \$menu->link(\$menu->title, (in_array(\$menu->slug, explode(''/'', \$this->url)) ? '' class=\"current\"'': null)); ?></li>\r\n<?php endforeach; ?> \r\n </ul>\r\n </div> <!-- end #navigation -->\r\n</div> <!-- end #header -->', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "snippet (id, name, filter_id, content, content_html, created_on, updated_on, created_by_id, updated_by_id) VALUES (2, 'footer', '', '<div id=\"footer\"><div id=\"footer-inner\">\r\n <p>© Copyright <?php echo date(''Y''); ?> <a href=\"http://www.madebyfrog.com/\" title=\"Frog\">Philworks.com</a><br />\r\n Powered by <a href=\"http://www.madebyfrog.com/\" title=\"Frog CMS\">Frog CMS</a>.\r\n </p>\r\n</div></div><!-- end #footer -->', '<div id=\"footer\"><div id=\"footer-inner\">\r\n <p>© Copyright <?php echo date(''Y''); ?> <a href=\"http://www.madebyfrog.com/\" alt=\"Frog\">Philworks.com</a><br />\r\n Powered by <a href=\"http://www.madebyfrog.com/\" alt=\"Frog\">Frog CMS</a>.\r\n </p>\r\n</div></div><!-- end #footer -->', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1)");
// Dumping data for table: user ---------------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "user (id, name, email, username, password, created_on, updated_on, created_by_id, updated_by_id) VALUES (1, 'Administrator', '*****@*****.**', 'admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1)");
// Dumping data for table: user_permission ----------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "user_permission (user_id, permission_id) VALUES (1, 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page (id, title, slug, breadcrumb, parent_id, layout_id, behavior_id, status_id, created_on, published_on, updated_on, created_by_id, updated_by_id, position, is_protected, needs_login) VALUES (7, '%B %Y archive', 'monthly_archive', '%B %Y archive', 4, 0, 'archive_month_index', 101, '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1, 0, 1, 2)");
// Dumping data for table: page_part ----------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (1, 'body', '', '<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<?php \$last_article = \$page_article->children(array(''limit'' => 1, ''order'' => ''page.created_on DESC'')); ?>\r\n\r\n<div class=\"first entry\">\r\n <h3><?php echo \$last_article->link(); ?></h3>\r\n <?php echo \$last_article->content(); ?>\r\n <?php if (\$last_article->hasContent(''extended'')) echo \$last_article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$last_article->author(); ?> on <?php echo \$last_article->date(); ?></p>\r\n</div>\r\n\r\n<?php foreach (\$page_article->children(array(''limit'' => 4, ''offset'' => 1, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <?php if (\$article->hasContent(''extended'')) echo \$article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?></p>\r\n</div>\r\n<?php endforeach; ?>\r\n', '<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<?php \$last_article = \$page_article->children(array(''limit'' => 1, ''order'' => ''page.created_on DESC'')); ?>\r\n\r\n<div class=\"first entry\">\r\n <h3><?php echo \$last_article->link(); ?></h3>\r\n <?php echo \$last_article->content(); ?>\r\n <?php if (\$last_article->hasContent(''extended'')) echo \$last_article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$last_article->author(); ?> on <?php echo \$last_article->date(); ?></p>\r\n</div>\r\n\r\n<?php foreach (\$page_article->children(array(''limit'' => 4, ''offset'' => 1, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <?php if (\$article->hasContent(''extended'')) echo \$article->link(''Continue Reading…''); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?></p>\r\n</div>\r\n<?php endforeach; ?>\r\n', 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (2, 'body', '', '<?php echo ''<?''; ?>xml version=\"1.0\" encoding=\"UTF-8\"<?php echo ''?>''; ?> \r\n<rss version=\"2.0\" xmlns:atom=\"http://www.w3.org/2005/Atom\">\r\n<channel>\r\n\t<title>Frog CMS</title>\r\n\t<link><?php echo BASE_URL ?></link>\r\n\t<atom:link href=\"<?php echo BASE_URL ?>/rss.xml\" rel=\"self\" type=\"application/rss\\+xml\" />\r\n\t<language>en-us</language>\r\n\t<copyright>Copyright <?php echo date(''Y''); ?>, madebyfrog.com</copyright>\r\n\t<pubDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S %z''); ?></pubDate>\r\n\t<lastBuildDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S %z''); ?></lastBuildDate>\r\n\t<category>any</category>\r\n\t<generator>Frog CMS</generator>\r\n\t<description>The main news feed from Frog CMS.</description>\r\n\t<docs>http://www.rssboard.org/rss-specification</docs>\r\n\t<?php \$articles = \$this->find(''articles''); ?>\r\n\t<?php foreach (\$articles->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n\t<item>\r\n\t\t<title><?php echo \$article->title(); ?></title>\r\n\t\t<description><?php if (\$article->hasContent(''summary'')) { echo \$article->content(''summary''); } else { echo strip_tags(\$article->content()); } ?></description>\r\n\t\t<pubDate><?php echo \$article->date(''%a, %d %b %Y %H:%M:%S %z''); ?></pubDate>\r\n\t\t<link><?php echo \$article->url(); ?></link>\r\n\t\t<guid><?php echo \$article->url(); ?></guid>\r\n\t</item>\r\n\t<?php endforeach; ?>\r\n</channel>\r\n</rss>', '<?php echo ''<?''; ?>xml version=\"1.0\" encoding=\"UTF-8\"<?php echo ''?>''; ?> \r\n<rss version=\"2.0\" xmlns:atom=\"http://www.w3.org/2005/Atom\">\r\n<channel>\r\n\t<title>Frog CMS</title>\r\n\t<link><?php echo BASE_URL ?></link>\r\n\t<atom:link href=\"<?php echo BASE_URL ?>/rss.xml\" rel=\"self\" type=\"application/rss\\+xml\" />\r\n\t<language>en-us</language>\r\n\t<copyright>Copyright <?php echo date(''Y''); ?>, madebyfrog.com</copyright>\r\n\t<pubDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S %z''); ?></pubDate>\r\n\t<lastBuildDate><?php echo strftime(''%a, %d %b %Y %H:%M:%S %z''); ?></lastBuildDate>\r\n\t<category>any</category>\r\n\t<generator>Frog CMS</generator>\r\n\t<description>The main news feed from Frog CMS.</description>\r\n\t<docs>http://www.rssboard.org/rss-specification</docs>\r\n\t<?php \$articles = \$this->find(''articles''); ?>\r\n\t<?php foreach (\$articles->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n\t<item>\r\n\t\t<title><?php echo \$article->title(); ?></title>\r\n\t\t<description><?php if (\$article->hasContent(''summary'')) { echo \$article->content(''summary''); } else { echo strip_tags(\$article->content()); } ?></description>\r\n\t\t<pubDate><?php echo \$article->date(''%a, %d %b %Y %H:%M:%S %z''); ?></pubDate>\r\n\t\t<link><?php echo \$article->url(); ?></link>\r\n\t\t<guid><?php echo \$article->url(); ?></guid>\r\n\t</item>\r\n\t<?php endforeach; ?>\r\n</channel>\r\n</rss>', 2)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (3, 'body', 'textile', 'This is my site. I live in this city ... I do some nice things, like this and that ...', '<p>This is my site. I live in this city … I do some nice things, like this and that …</p>', 3)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (4, 'body', '', '<?php \$last_articles = \$this->children(array(''limit''=>5, ''order''=>''page.created_on DESC'')); ?>\r\n<?php foreach (\$last_articles as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(\$article->title); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?> \r\n <br />tags: <?php echo join('', '', \$article->tags()); ?>\r\n </p>\r\n</div>\r\n<?php endforeach; ?>\r\n\r\n', '<?php \$last_articles = \$this->children(array(''limit''=>5, ''order''=>''page.created_on DESC'')); ?>\r\n<?php foreach (\$last_articles as \$article): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$article->link(\$article->title); ?></h3>\r\n <?php echo \$article->content(); ?>\r\n <p class=\"info\">Posted by <?php echo \$article->author(); ?> on <?php echo \$article->date(); ?> \r\n <br />tags: <?php echo join('', '', \$article->tags()); ?>\r\n </p>\r\n</div>\r\n<?php endforeach; ?>\r\n\r\n', 4)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (5, 'body', 'markdown', 'My **first** test of my first article that uses *Markdown*.', '<p>My <strong>first</strong> test of my first article that uses <em>Markdown</em>.</p>\n', 5)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (7, 'body', 'markdown', 'This is my second article.', '<p>This is my second article.</p>\n', 6)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (8, 'body', '', '<?php \$archives = \$this->archive->get(); ?>\r\n<?php foreach (\$archives as \$archive): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$archive->link(); ?></h3>\r\n <p class=\"info\">Posted by <?php echo \$archive->author(); ?> on <?php echo \$archive->date(); ?> \r\n </p>\r\n</div>\r\n<?php endforeach; ?>', '<?php \$archives = \$this->archive->get(); ?>\r\n<?php foreach (\$archives as \$archive): ?>\r\n<div class=\"entry\">\r\n <h3><?php echo \$archive->link(); ?></h3>\r\n <p class=\"info\">Posted by <?php echo \$archive->author(); ?> on <?php echo \$archive->date(); ?> \r\n </p>\r\n</div>\r\n<?php endforeach; ?>', 7)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (9, 'sidebar', '', '<h3>About Me</h3>\r\n\r\n<p>I''m just a demonstration of how easy it is to use Frog CMS to power a blog. <a href=\"<?php echo BASE_URL; ?>about_us\">more ...</a></p>\r\n\r\n<h3>Favorite Sites</h3>\r\n<ul>\r\n <li><a href=\"http://www.madebyfrog.com\">Frog CMS</a></li>\r\n</ul>\r\n\r\n<?php if(url_match(''/'')): ?>\r\n<h3>Recent Entries</h3>\r\n<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<ul>\r\n<?php foreach (\$page_article->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n <li><?php echo \$article->link(); ?></li> \r\n<?php endforeach; ?>\r\n</ul>\r\n<?php endif; ?>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>articles\">Archives</a>\r\n\r\n<h3>Syndicate</h3>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>rss.xml\">Articles RSS Feed</a>', '<h3>About Me</h3>\r\n\r\n<p>I''m just a demonstration of how easy it is to use Frog CMS to power a blog. <a href=\"<?php echo BASE_URL; ?>about_us\">more ...</a></p>\r\n\r\n<h3>Favorite Sites</h3>\r\n<ul>\r\n <li><a href=\"http://www.madebyfrog.com\">Frog CMS</a></li>\r\n</ul>\r\n\r\n<?php if(url_match(''/'')): ?>\r\n<h3>Recent Entries</h3>\r\n<?php \$page_article = \$this->find(''/articles/''); ?>\r\n<ul>\r\n<?php foreach (\$page_article->children(array(''limit'' => 10, ''order'' => ''page.created_on DESC'')) as \$article): ?>\r\n <li><?php echo \$article->link(); ?></li> \r\n<?php endforeach; ?>\r\n</ul>\r\n<?php endif; ?>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>articles\">Archives</a>\r\n\r\n<h3>Syndicate</h3>\r\n\r\n<a href=\"<?php echo BASE_URL; ?>rss.xml\">Articles RSS Feed</a>', 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "page_part (id, name, filter_id, content, content_html, page_id) VALUES (10, 'sidebar', '', '<?php \$article = \$this->find(''articles''); ?>\r\n<?php \$archives = \$article->archive->archivesByMonth(); ?>\r\n\r\n<h3>Archives By Month</h3>\r\n<ul>\r\n<?php foreach (\$archives as \$date): ?>\r\n <li><a href=\"<?php echo BASE_URL . \$this->url .''/''. \$date . URL_SUFFIX; ?>\"><?php echo strftime(''%B %Y'', strtotime(strtr(\$date, ''/'', ''-''))); ?></a></li>\r\n<?php endforeach; ?>\r\n</ul>', '<?php \$article = \$this->find(''articles''); ?>\r\n<?php \$archives = \$article->archive->archivesByMonth(); ?>\r\n\r\n<h3>Archives By Month</h3>\r\n<ul>\r\n<?php foreach (\$archives as \$date): ?>\r\n <li><a href=\"<?php echo BASE_URL . \$this->url .''/''. \$date . URL_SUFFIX; ?>\"><?php echo strftime(''%B %Y'', strtotime(strtr(\$date, ''/'', ''-''))); ?></a></li>\r\n<?php endforeach; ?>\r\n</ul>', 4)");
// Dumping data for table: permission ---------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "permission (id, name) VALUES (1, 'administrator')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "permission (id, name) VALUES (2, 'developer')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "permission (id, name) VALUES (3, 'editor')");
// Dumping data for table: setting ------------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('admin_title', 'Frog CMS')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('language', 'en')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('theme', 'default')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('default_status_id', '1')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('default_filter_id', '')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('default_tab', '')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('allow_html_title', 'off')");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "setting (name, value) VALUES ('plugins', 'a:5:{s:7:\"textile\";i:1;s:8:\"markdown\";i:1;s:7:\"archive\";i:1;s:14:\"page_not_found\";i:1;s:12:\"file_manager\";i:1;}')");
// Dumping data for table: snippet ------------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "snippet (id, name, filter_id, content, content_html, created_on, updated_on, created_by_id, updated_by_id) VALUES (1, 'header', '', '<div id=\"header\">\r\n <h1><a href=\"<?php echo URL_PUBLIC; ?>\">Frog</a> <span>content management simplified</span></h1>\r\n <div id=\"nav\">\r\n <ul>\r\n <li><a<?php echo url_match(''/'') ? '' class=\"current\"'': ''''; ?> href=\"<?php echo URL_PUBLIC; ?>\">Home</a></li>\r\n<?php foreach(\$this->find(''/'')->children() as \$menu): ?>\r\n <li><?php echo \$menu->link(\$menu->title, (in_array(\$menu->slug, explode(''/'', \$this->url)) ? '' class=\"current\"'': null)); ?></li>\r\n<?php endforeach; ?> \r\n </ul>\r\n </div> <!-- end #navigation -->\r\n</div> <!-- end #header -->', '<div id=\"header\">\r\n <h1><a href=\"<?php echo URL_PUBLIC; ?>\">Frog</a> <span>content management simplified</span></h1>\r\n <div id=\"nav\">\r\n <ul>\r\n <li><a<?php echo url_match(''/'') ? '' class=\"current\"'': ''''; ?> href=\"<?php echo URL_PUBLIC; ?>\">Home</a></li>\r\n<?php foreach(\$this->find(''/'')->children() as \$menu): ?>\r\n <li><?php echo \$menu->link(\$menu->title, (in_array(\$menu->slug, explode(''/'', \$this->url)) ? '' class=\"current\"'': null)); ?></li>\r\n<?php endforeach; ?> \r\n </ul>\r\n </div> <!-- end #navigation -->\r\n</div> <!-- end #header -->', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1)");
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "snippet (id, name, filter_id, content, content_html, created_on, updated_on, created_by_id, updated_by_id) VALUES (2, 'footer', '', '<div id=\"footer\"><div id=\"footer-inner\">\r\n <p>© Copyright <?php echo date(''Y''); ?> <a href=\"http://www.madebyfrog.com/\" title=\"Frog\">Madebyfrog.com</a><br />\r\n Powered by <a href=\"http://www.madebyfrog.com/\" title=\"Frog CMS\">Frog CMS</a>.\r\n </p>\r\n</div></div><!-- end #footer -->', '<div id=\"footer\"><div id=\"footer-inner\">\r\n <p>© Copyright <?php echo date(''Y''); ?> <a href=\"http://www.madebyfrog.com/\" alt=\"Frog\">Madebyfrog.com</a><br />\r\n Powered by <a href=\"http://www.madebyfrog.com/\" alt=\"Frog\">Frog CMS</a>.\r\n </p>\r\n</div></div><!-- end #footer -->', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1)");
// Dumping data for table: user ---------------------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "user (id, name, email, username, password, created_on, updated_on, created_by_id, updated_by_id) VALUES (1, 'Administrator', '*****@*****.**', '" . $admin_name . "', '" . $admin_passwd . "', '" . frog_datetime_incrementor() . "', '" . frog_datetime_incrementor() . "', 1, 1)");
// Dumping data for table: user_permission ----------------------------------
$PDO->exec("INSERT INTO " . TABLE_PREFIX . "user_permission (user_id, permission_id) VALUES (1, 1)");
