Snap PhotoFrame 

<?php
echo "support.kissmetrics.com\n";
echo "http://snapphotoframe.blogspost.com/\n";
echo "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n";
echo "<!DOCTYPE html>\n";
echo "<html b:version=\'2\' class=\'v2\' expr:dir=\'data:blog.languageDirection\' xmlns=\'http://www.w3.org/1999/xhtml\' xmlns:b=\'http://www.google.com/2005/gml/b\' xmlns:data=\'http://www.google.com/2005/gml/data\' xmlns:expr=\'http://www.google.com/2005/gml/expr\'>\n";
echo "USE MyDB\n";
echo "GO\n";
echo "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE=&#39;BASE TABLE&#39;\n";
echo "ORDER BY TABLE_NAME\n";
echo "USE MyDB\n";
echo "GO\n";
echo "SELECT * FROM sys.Tables ORDER BY name\n";
echo "<UBO4 xmlns:xsd=\'http://www.w3.org/2001/XMLSchema\' xmlns:xsi=\'http://www.w3.org/2001/XMLSchema-instance\'>\n";
echo "<InvoiceID>0</InvoiceID>\n";
echo "<S1>Kanrad Home Health Inc\n";
echo "1580 Broad Avenue\n";
echo "Belle Vernon, NY 15012</S1>\n";
echo "<S2>100</S2>\n";
echo "<S3>26020</S3>\n";
echo "<S4>XXX</S4>\n";
echo "<S5>1234567890</S5>\n";
echo "</UBO4>\n";
echo "UPDATE XMLData SET XMLCOlumnData.modify(&#39;\n";
echo "replace value of\n";
echo "(/UBO4[1]/S2 [1]/text()[1])\n";
echo "with\n";
echo "( sql:column(&quot;StudentID &quot;) )\n";
echo "&#39;)\n";
echo "<head>\n";
echo "<b:if cond=\'data:blog.isMobile\'>\n";
echo "<meta content=\'width=device-width,initial-scale=1.0,minimum-scale=1.0,maximum-scale=1.0\' name=\'viewport\'/>\n";
echo "<b:else/>\n";
echo "<meta content=\'width=1100\' name=\'viewport\'/>\n";
echo "</b:if>\n";
echo "<b:include data=\'blog\' name=\'all-head-content\'/>\n";
echo "<title>\n";
echo "<data:blog.pageTitle/>\n";
echo "</title>\n";
echo "<b:skin><![CDATA[\n";
echo "/*\n";
echo "-----------------------------------------------\n";
echo "Blogger Template Style\n";
echo "Name: Simple\n";
echo "Designer: Josh Peterson\n";
echo "URL: www.noaesthetic.com\n";
echo "----------------------------------------------- */\n";
echo "/* Variable definitions\n";
echo "====================\n";
echo "<Variable name=\"keycolor\" description=\"Main Color\" type=\"color\" default=\"#66bbdd\" value=\"#cfe7d1\"/>\n";
echo "<Group description=\"Page Text\" selector=\"body\">\n";
echo "<Variable name=\"body.font\" description=\"Font\" type=\"font\"\n";
echo "default=\"normal normal 12px Arial, Tahoma, Helvetica, FreeSans, sans-serif\" value=\"normal normal 12px Arial, Tahoma, Helvetica, FreeSans, sans-serif\"/>\n";
echo "<Variable name=\"body.text.color\" description=\"Text Color\" type=\"color\" default=\"#222222\" value=\"#222222\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Backgrounds\" selector=\".body-fauxcolumns-outer\">\n";
echo "<Variable name=\"body.background.color\" description=\"Outer Background\" type=\"color\" default=\"#66bbdd\" value=\"#cfe7d1\"/>\n";
echo "<Variable name=\"content.background.color\" description=\"Main Background\" type=\"color\" default=\"#ffffff\" value=\"#ffffff\"/>\n";
echo "<Variable name=\"header.background.color\" description=\"Header Background\" type=\"color\" default=\"transparent\" value=\"transparent\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Links\" selector=\".main-outer\">\n";
echo "<Variable name=\"link.color\" description=\"Link Color\" type=\"color\" default=\"#2288bb\" value=\"#249fa3\"/>\n";
echo "<Variable name=\"link.visited.color\" description=\"Visited Color\" type=\"color\" default=\"#888888\" value=\"#7c93a1\"/>\n";
echo "<Variable name=\"link.hover.color\" description=\"Hover Color\" type=\"color\" default=\"#33aaff\" value=\"#5dc2c0\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Blog Title\" selector=\".header h1\">\n";
echo "<Variable name=\"header.font\" description=\"Font\" type=\"font\"\n";
echo "default=\"normal normal 60px Arial, Tahoma, Helvetica, FreeSans, sans-serif\" value=\"normal normal 70px Arial, Tahoma, Helvetica, FreeSans, sans-serif\"/>\n";
echo "<Variable name=\"header.text.color\" description=\"Title Color\" type=\"color\" default=\"#3399bb\" value=\"#249fa3\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Blog Description\" selector=\".header .description\">\n";
echo "<Variable name=\"description.text.color\" description=\"Description Color\" type=\"color\"\n";
echo "default=\"#777777\" value=\"#444444\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Tabs Text\" selector=\".tabs-inner .widget li a\">\n";
echo "<Variable name=\"tabs.font\" description=\"Font\" type=\"font\"\n";
echo "default=\"normal normal 14px Arial, Tahoma, Helvetica, FreeSans, sans-serif\" value=\"normal normal 20px Arial, Tahoma, Helvetica, FreeSans, sans-serif\"/>\n";
echo "<Variable name=\"tabs.text.color\" description=\"Text Color\" type=\"color\" default=\"#999999\" value=\"#00818b\"/>\n";
echo "<Variable name=\"tabs.selected.text.color\" description=\"Selected Color\" type=\"color\" default=\"#000000\" value=\"#444444\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Tabs Background\" selector=\".tabs-outer .PageList\">\n";
echo "<Variable name=\"tabs.background.color\" description=\"Background Color\" type=\"color\" default=\"#f5f5f5\" value=\"transparent\"/>\n";
echo "<Variable name=\"tabs.selected.background.color\" description=\"Selected Color\" type=\"color\" default=\"#eeeeee\" value=\"transparent\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Post Title\" selector=\"h3.post-title, .comments h4\">\n";
echo "<Variable name=\"post.title.font\" description=\"Font\" type=\"font\"\n";
echo "default=\"normal normal 22px Arial, Tahoma, Helvetica, FreeSans, sans-serif\" value=\"normal normal 22px Arial, Tahoma, Helvetica, FreeSans, sans-serif\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Date Header\" selector=\".date-header\">\n";
echo "<Variable name=\"date.header.color\" description=\"Text Color\" type=\"color\"\n";
echo "default=\"$(body.text.color)\" value=\"$(body.text.color)\"/>\n";
echo "<Variable name=\"date.header.background.color\" description=\"Background Color\" type=\"color\"\n";
echo "default=\"transparent\" value=\"transparent\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Post Footer\" selector=\".post-footer\">\n";
echo "<Variable name=\"post.footer.text.color\" description=\"Text Color\" type=\"color\" default=\"#666666\" value=\"#666666\"/>\n";
echo "<Variable name=\"post.footer.background.color\" description=\"Background Color\" type=\"color\"\n";
echo "default=\"#f9f9f9\" value=\"#f9f9f9\"/>\n";
echo "<Variable name=\"post.footer.border.color\" description=\"Shadow Color\" type=\"color\" default=\"#eeeeee\" value=\"#eeeeee\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Gadgets\" selector=\"h2\">\n";
echo "<Variable name=\"widget.title.font\" description=\"Title Font\" type=\"font\"\n";
echo "default=\"normal bold 11px Arial, Tahoma, Helvetica, FreeSans, sans-serif\" value=\"normal bold 11px Arial, Tahoma, Helvetica, FreeSans, sans-serif\"/>\n";
echo "<Variable name=\"widget.title.text.color\" description=\"Title Color\" type=\"color\" default=\"#000000\" value=\"#000000\"/>\n";
echo "<Variable name=\"widget.alternate.text.color\" description=\"Alternate Color\" type=\"color\" default=\"#999999\" value=\"#999999\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Images\" selector=\".main-inner\">\n";
echo "<Variable name=\"image.background.color\" description=\"Background Color\" type=\"color\" default=\"#ffffff\" value=\"#ffffff\"/>\n";
echo "<Variable name=\"image.border.color\" description=\"Border Color\" type=\"color\" default=\"#eeeeee\" value=\"#eeeeee\"/>\n";
echo "<Variable name=\"image.text.color\" description=\"Caption Text Color\" type=\"color\" default=\"$(body.text.color)\" value=\"$(body.text.color)\"/>\n";
echo "</Group>\n";
echo "<Group description=\"Accents\" selector=\".content-inner\">\n";
echo "<Variable name=\"body.rule.color\" description=\"Separator Line Color\" type=\"color\" default=\"#eeeeee\" value=\"#dddddd\"/>\n";
echo "<Variable name=\"tabs.border.color\" description=\"Tabs Border Color\" type=\"color\" default=\"$(body.rule.color)\" value=\"$(body.rule.color)\"/>\n";
echo "</Group>\n";
echo "<Variable name=\"body.background\" description=\"Body Background\" type=\"background\"\n";
echo "color=\"$(body.background.color)\" default=\"$(color) none repeat scroll top left\" value=\"#cfe7d1 url(//themes.googleusercontent.com/image?id=1x_TqXo6-7t6y2ZiuOyQ2Bk6Zod9CTtyKYtRui0IeQJe6hVlJcQiXYG2xQGkxKvl6iZMJ) repeat fixed top center /* Credit: gaffera (http://www.istockphoto.com/googleimages.php?id=4072573&amp;platform=blogger) */\"/>\n";
echo "<Variable name=\"body.background.override\" description=\"Body Background Override\" type=\"string\" default=\"\" value=\"background-attachment: scroll;\"/>\n";
echo "<Variable name=\"body.background.gradient.cap\" description=\"Body Gradient Cap\" type=\"url\"\n";
echo "default=\"url(//www.blogblog.com/1kt/simple/gradients_light.png)\" value=\"url(//www.blogblog.com/1kt/simple/gradients_light.png)\"/>\n";
echo "<Variable name=\"body.background.gradient.tile\" description=\"Body Gradient Tile\" type=\"url\"\n";
echo "default=\"url(//www.blogblog.com/1kt/simple/body_gradient_tile_light.png)\" value=\"url(//www.blogblog.com/1kt/simple/body_gradient_tile_light.png)\"/>\n";
echo "<Variable name=\"content.background.color.selector\" description=\"Content Background Color Selector\" type=\"string\" default=\".content-inner\" value=\".main-outer, .footer-outer\"/>\n";
echo "<Variable name=\"content.padding\" description=\"Content Padding\" type=\"length\" default=\"10px\" value=\"0\"/>\n";
echo "<Variable name=\"content.padding.horizontal\" description=\"Content Horizontal Padding\" type=\"length\" default=\"$(content.padding)\" value=\"$(content.padding)\"/>\n";
echo "<Variable name=\"content.shadow.spread\" description=\"Content Shadow Spread\" type=\"length\" default=\"40px\" value=\"0\"/>\n";
echo "<Variable name=\"content.shadow.spread.webkit\" description=\"Content Shadow Spread (WebKit)\" type=\"length\" default=\"5px\" value=\"0\"/>\n";
echo "<Variable name=\"content.shadow.spread.ie\" description=\"Content Shadow Spread (IE)\" type=\"length\" default=\"10px\" value=\"0\"/>\n";
echo "<Variable name=\"main.border.width\" description=\"Main Border Width\" type=\"length\" default=\"0\" value=\"1px\"/>\n";
echo "<Variable name=\"header.background.gradient\" description=\"Header Gradient\" type=\"url\" default=\"none\" value=\"none\"/>\n";
echo "<Variable name=\"header.shadow.offset.left\" description=\"Header Shadow Offset Left\" type=\"length\" default=\"-1px\" value=\"0\"/>\n";
echo "<Variable name=\"header.shadow.offset.top\" description=\"Header Shadow Offset Top\" type=\"length\" default=\"-1px\" value=\"0\"/>\n";
echo "<Variable name=\"header.shadow.spread\" description=\"Header Shadow Spread\" type=\"length\" default=\"1px\" value=\"0\"/>\n";
echo "<Variable name=\"header.padding\" description=\"Header Padding\" type=\"length\" default=\"30px\" value=\"30px\"/>\n";
echo "<Variable name=\"header.border.size\" description=\"Header Border Size\" type=\"length\" default=\"1px\" value=\"0\"/>\n";
echo "<Variable name=\"header.bottom.border.size\" description=\"Header Bottom Border Size\" type=\"length\" default=\"$(header.border.size)\" value=\"$(header.border.size)\"/>\n";
echo "<Variable name=\"header.border.horizontalsize\" description=\"Header Horizontal Border Size\" type=\"length\" default=\"0\" value=\"0\"/>\n";
echo "<Variable name=\"description.text.size\" description=\"Description Text Size\" type=\"string\" default=\"140%\" value=\"200%\"/>\n";
echo "<Variable name=\"tabs.margin.top\" description=\"Tabs Margin Top\" type=\"length\" default=\"0\" value=\"0\"/>\n";
echo "<Variable name=\"tabs.margin.side\" description=\"Tabs Side Margin\" type=\"length\" default=\"30px\" value=\"0\"/>\n";
echo "<Variable name=\"tabs.background.gradient\" description=\"Tabs Background Gradient\" type=\"url\"\n";
echo "default=\"url(//www.blogblog.com/1kt/simple/gradients_light.png)\" value=\"none\"/>\n";
echo "<Variable name=\"tabs.border.width\" description=\"Tabs Border Width\" type=\"length\" default=\"1px\" value=\"0\"/>\n";
echo "<Variable name=\"tabs.bevel.border.width\" description=\"Tabs Bevel Border Width\" type=\"length\" default=\"1px\" value=\"0\"/>\n";
echo "<Variable name=\"date.header.padding\" description=\"Date Header Padding\" type=\"string\" default=\"inherit\" value=\"inherit\"/>\n";
echo "<Variable name=\"date.header.letterspacing\" description=\"Date Header Letter Spacing\" type=\"string\" default=\"inherit\" value=\"inherit\"/>\n";
echo "<Variable name=\"date.header.margin\" description=\"Date Header Margin\" type=\"string\" default=\"inherit\" value=\"inherit\"/>\n";
echo "<Variable name=\"post.margin.bottom\" description=\"Post Bottom Margin\" type=\"length\" default=\"25px\" value=\"25px\"/>\n";
echo "<Variable name=\"image.border.small.size\" description=\"Image Border Small Size\" type=\"length\" default=\"2px\" value=\"2px\"/>\n";
echo "<Variable name=\"image.border.large.size\" description=\"Image Border Large Size\" type=\"length\" default=\"5px\" value=\"5px\"/>\n";
echo "<Variable name=\"page.width.selector\" description=\"Page Width Selector\" type=\"string\" default=\".region-inner\" value=\".content-outer\"/>\n";
echo "<Variable name=\"page.width\" description=\"Page Width\" type=\"string\" default=\"auto\" value=\"100%\"/>\n";
echo "<Variable name=\"main.section.margin\" description=\"Main Section Margin\" type=\"length\" default=\"15px\" value=\"15px\"/>\n";
echo "<Variable name=\"main.padding\" description=\"Main Padding\" type=\"length\" default=\"15px\" value=\"15px\"/>\n";
echo "<Variable name=\"main.padding.top\" description=\"Main Padding Top\" type=\"length\" default=\"30px\" value=\"30px\"/>\n";
echo "<Variable name=\"main.padding.bottom\" description=\"Main Padding Bottom\" type=\"length\" default=\"30px\" value=\"30px\"/>\n";
echo "<Variable name=\"paging.background\"\n";
echo "color=\"$(content.background.color)\"\n";
echo "description=\"Background of blog paging area\" type=\"background\"\n";
echo "default=\"transparent none no-repeat scroll top center\" value=\"transparent none no-repeat scroll top center\"/>\n";
echo "<Variable name=\"footer.bevel\" description=\"Bevel border length of footer\" type=\"length\" default=\"0\" value=\"0\"/>\n";
echo "<Variable name=\"mobile.background.overlay\" description=\"Mobile Background Overlay\" type=\"string\"\n";
echo "default=\"transparent none repeat scroll top left\" value=\"transparent none repeat scroll top left\"/>\n";
echo "<Variable name=\"mobile.background.size\" description=\"Mobile Background Size\" type=\"string\" default=\"auto\" value=\"auto\"/>\n";
echo "<Variable name=\"mobile.button.color\" description=\"Mobile Button Color\" type=\"color\" default=\"#ffffff\" value=\"#ffffff\"/>\n";
echo "<Variable name=\"startSide\" description=\"Side where text starts in blog language\" type=\"automatic\" default=\"left\" value=\"left\"/>\n";
echo "<Variable name=\"endSide\" description=\"Side where text ends in blog language\" type=\"automatic\" default=\"right\" value=\"right\"/>\n";
echo "*/\n";
echo "/* Content\n";
echo "----------------------------------------------- */\n";
echo "body {\n";
echo "font: $(body.font);\n";
echo "color: $(body.text.color);\n";
echo "background: $(body.background);\n";
echo "padding: 0 $(content.shadow.spread) $(content.shadow.spread) $(content.shadow.spread);\n";
echo "$(body.background.override)\n";
echo "}\n";
echo "html body $(page.width.selector) {\n";
echo "min-width: 0;\n";
echo "max-width: 100%;\n";
echo "width: $(page.width);\n";
echo "}\n";
echo "a:link {\n";
echo "text-decoration:none;\n";
echo "color: $(link.color);\n";
echo "}\n";
echo "a:visited {\n";
echo "text-decoration:none;\n";
echo "color: $(link.visited.color);\n";
echo "}\n";
echo "a:hover {\n";
echo "text-decoration:underline;\n";
echo "color: $(link.hover.color);\n";
echo "}\n";
echo ".body-fauxcolumn-outer .fauxcolumn-inner {\n";
echo "background: transparent $(body.background.gradient.tile) repeat scroll top left;\n";
echo "_background-image: none;\n";
echo "}\n";
echo ".body-fauxcolumn-outer .cap-top {\n";
echo "position: absolute;\n";
echo "z-index: 1;\n";
echo "height: 400px;\n";
echo "width: 100%;\n";
echo "background: $(body.background);\n";
echo "$(body.background.override)\n";
echo "}\n";
echo ".body-fauxcolumn-outer .cap-top .cap-left {\n";
echo "width: 100%;\n";
echo "background: transparent $(body.background.gradient.cap) repeat-x scroll top left;\n";
echo "_background-image: none;\n";
echo "}\n";
echo ".content-outer {\n";
echo "-moz-box-shadow: 0 0 $(content.shadow.spread) rgba(0, 0, 0, .15);\n";
echo "-webkit-box-shadow: 0 0 $(content.shadow.spread.webkit) rgba(0, 0, 0, .15);\n";
echo "-goog-ms-box-shadow: 0 0 $(content.shadow.spread.ie) #333333;\n";
echo "box-shadow: 0 0 $(content.shadow.spread) rgba(0, 0, 0, .15);\n";
echo "margin-bottom: 1px;\n";
echo "}\n";
echo ".content-inner {\n";
echo "padding: $(content.padding) $(content.padding.horizontal);\n";
echo "}\n";
echo "$(content.background.color.selector) {\n";
echo "background-color: $(content.background.color);\n";
echo "}\n";
echo "/* Header\n";
echo "----------------------------------------------- */\n";
echo ".header-outer {\n";
echo "background: $(header.background.color) $(header.background.gradient) repeat-x scroll 0 -400px;\n";
echo "_background-image: none;\n";
echo "}\n";
echo ".Header h1 {\n";
echo "font: $(header.font);\n";
echo "color: $(header.text.color);\n";
echo "text-shadow: $(header.shadow.offset.left) $(header.shadow.offset.top) $(header.shadow.spread) rgba(0, 0, 0, .2);\n";
echo "}\n";
echo ".Header h1 a {\n";
echo "color: $(header.text.color);\n";
echo "}\n";
echo ".Header .description {\n";
echo "font-size: $(description.text.size);\n";
echo "color: $(description.text.color);\n";
echo "}\n";
echo ".header-inner .Header .titlewrapper {\n";
echo "padding: 22px $(header.padding);\n";
echo "}\n";
echo ".header-inner .Header .descriptionwrapper {\n";
echo "padding: 0 $(header.padding);\n";
echo "}\n";
echo "/* Tabs\n";
echo "----------------------------------------------- */\n";
echo ".tabs-inner .section:first-child {\n";
echo "border-top: $(header.bottom.border.size) solid $(tabs.border.color);\n";
echo "}\n";
echo ".tabs-inner .section:first-child ul {\n";
echo "margin-top: -$(header.border.size);\n";
echo "border-top: $(header.border.size) solid $(tabs.border.color);\n";
echo "border-left: $(header.border.horizontalsize) solid $(tabs.border.color);\n";
echo "border-right: $(header.border.horizontalsize) solid $(tabs.border.color);\n";
echo "}\n";
echo ".tabs-inner .widget ul {\n";
echo "background: $(tabs.background.color) $(tabs.background.gradient) repeat-x scroll 0 -800px;\n";
echo "_background-image: none;\n";
echo "border-bottom: $(tabs.border.width) solid $(tabs.border.color);\n";
echo "margin-top: $(tabs.margin.top);\n";
echo "margin-left: -$(tabs.margin.side);\n";
echo "margin-right: -$(tabs.margin.side);\n";
echo "}\n";
echo ".tabs-inner .widget li a {\n";
echo "display: inline-block;\n";
echo "padding: .6em 1em;\n";
echo "font: $(tabs.font);\n";
echo "color: $(tabs.text.color);\n";
echo "border-$startSide: $(tabs.border.width) solid $(content.background.color);\n";
echo "border-$endSide: $(tabs.bevel.border.width) solid $(tabs.border.color);\n";
echo "}\n";
echo ".tabs-inner .widget li:first-child a {\n";
echo "border-$startSide: none;\n";
echo "}\n";
echo ".tabs-inner .widget li.selected a, .tabs-inner .widget li a:hover {\n";
echo "color: $(tabs.selected.text.color);\n";
echo "background-color: $(tabs.selected.background.color);\n";
echo "text-decoration: none;\n";
echo "}\n";
echo "/* Columns\n";
echo "----------------------------------------------- */\n";
echo ".main-outer {\n";
echo "border-top: $(main.border.width) solid $(body.rule.color);\n";
echo "}\n";
echo ".fauxcolumn-left-outer .fauxcolumn-inner {\n";
echo "border-right: 1px solid $(body.rule.color);\n";
echo "}\n";
echo ".fauxcolumn-right-outer .fauxcolumn-inner {\n";
echo "border-left: 1px solid $(body.rule.color);\n";
echo "}\n";
echo "/* Headings\n";
echo "----------------------------------------------- */\n";
echo "h2 {\n";
echo "margin: 0 0 1em 0;\n";
echo "font: $(widget.title.font);\n";
echo "color: $(widget.title.text.color);\n";
echo "}\n";
echo "/* Widgets\n";
echo "----------------------------------------------- */\n";
echo ".widget .zippy {\n";
echo "color: $(widget.alternate.text.color);\n";
echo "text-shadow: 2px 2px 1px rgba(0, 0, 0, .1);\n";
echo "}\n";
echo ".widget .popular-posts ul {\n";
echo "list-style: none;\n";
echo "}\n";
echo "/* Posts\n";
echo "----------------------------------------------- */\n";
echo ".date-header span {\n";
echo "background-color: $(date.header.background.color);\n";
echo "color: $(date.header.color);\n";
echo "padding: $(date.header.padding);\n";
echo "letter-spacing: $(date.header.letterspacing);\n";
echo "margin: $(date.header.margin);\n";
echo "}\n";
echo ".main-inner {\n";
echo "padding-top: $(main.padding.top);\n";
echo "padding-bottom: $(main.padding.bottom);\n";
echo "}\n";
echo ".main-inner .column-center-inner {\n";
echo "padding: 0 $(main.padding);\n";
echo "}\n";
echo ".main-inner .column-center-inner .section {\n";
echo "margin: 0 $(main.section.margin);\n";
echo "}\n";
echo ".post {\n";
echo "margin: 0 0 $(post.margin.bottom) 0;\n";
echo "}\n";
echo "h3.post-title, .comments h4 {\n";
echo "font: $(post.title.font);\n";
echo "margin: .75em 0 0;\n";
echo "}\n";
echo ".post-body {\n";
echo "font-size: 110%;\n";
echo "line-height: 1.4;\n";
echo "position: relative;\n";
echo "}\n";
echo ".post-body img, .post-body .tr-caption-container, .Profile img, .Image img,\n";
echo ".BlogList .item-thumbnail img {\n";
echo "padding: $(image.border.small.size);\n";
echo "background: $(image.background.color);\n";
echo "border: 1px solid $(image.border.color);\n";
echo "-moz-box-shadow: 1px 1px 5px rgba(0, 0, 0, .1);\n";
echo "-webkit-box-shadow: 1px 1px 5px rgba(0, 0, 0, .1);\n";
echo "box-shadow: 1px 1px 5px rgba(0, 0, 0, .1);\n";
echo "}\n";
echo ".post-body img, .post-body .tr-caption-container {\n";
echo "padding: $(image.border.large.size);\n";
echo "}\n";
echo ".post-body .tr-caption-container {\n";
echo "color: $(image.text.color);\n";
echo "}\n";
echo ".post-body .tr-caption-container img {\n";
echo "padding: 0;\n";
echo "background: transparent;\n";
echo "border: none;\n";
echo "-moz-box-shadow: 0 0 0 rgba(0, 0, 0, .1);\n";
echo "-webkit-box-shadow: 0 0 0 rgba(0, 0, 0, .1);\n";
echo "box-shadow: 0 0 0 rgba(0, 0, 0, .1);\n";
echo "}\n";
echo ".post-header {\n";
echo "margin: 0 0 1.5em;\n";
echo "line-height: 1.6;\n";
echo "font-size: 90%;\n";
echo "}\n";
echo ".post-footer {\n";
echo "margin: 20px -2px 0;\n";
echo "padding: 5px 10px;\n";
echo "color: $(post.footer.text.color);\n";
echo "background-color: $(post.footer.background.color);\n";
echo "border-bottom: 1px solid $(post.footer.border.color);\n";
echo "line-height: 1.6;\n";
echo "font-size: 90%;\n";
echo "}\n";
echo "#comments .comment-author {\n";
echo "padding-top: 1.5em;\n";
echo "border-top: 1px solid $(body.rule.color);\n";
echo "background-position: 0 1.5em;\n";
echo "}\n";
echo "#comments .comment-author:first-child {\n";
echo "padding-top: 0;\n";
echo "border-top: none;\n";
echo "}\n";
echo ".avatar-image-container {\n";
echo "margin: .2em 0 0;\n";
echo "}\n";
echo "#comments .avatar-image-container img {\n";
echo "border: 1px solid $(image.border.color);\n";
echo "}\n";
echo "/* Comments\n";
echo "----------------------------------------------- */\n";
echo ".comments .comments-content .icon.blog-author {\n";
echo "background-repeat: no-repeat;\n";
echo "background-image: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IArs4c6QAAAAZiS0dEAP8A/wD/oL2nkwAAAAlwSFlzAAALEgAACxIB0t1+/AAAAAd0SU1FB9sLFwMeCjjhcOMAAAD+SURBVDjLtZSvTgNBEIe/WRRnm3U8RC1neQdsm1zSBIU9VVF1FkUguQQsD9ITmD7ECZIJSE4OZo9stoVjC/zc7ky+zH9hXwVwDpTAWWLrgS3QAe8AZgaAJI5zYAmc8r0G4AHYHQKVwII8PZrZFsBFkeRCABYiMh9BRUhnSkPTNCtVXYXURi1FpBDgArj8QU1eVXUzfnjv7yP7kwu1mYrkWlU33vs1QNu2qU8pwN0UpKoqokjWwCztrMuBhEhmh8bD5UDqur75asbcX0BGUB9/HAMB+r32hznJgXy2v0sGLBcyAJ1EK3LFcbo1s91JeLwAbwGYu7TP/3ZGfnXYPgAVNngtqatUNgAAAABJRU5ErkJggg==);\n";
echo "}\n";
echo ".comments .comments-content .loadmore a {\n";
echo "border-top: 1px solid $(widget.alternate.text.color);\n";
echo "border-bottom: 1px solid $(widget.alternate.text.color);\n";
echo "}\n";
echo ".comments .comment-thread.inline-thread {\n";
echo "background-color: $(post.footer.background.color);\n";
echo "}\n";
echo ".comments .continue {\n";
echo "border-top: 2px solid $(widget.alternate.text.color);\n";
echo "}\n";
echo "/* Accents\n";
echo "---------------------------------------------- */\n";
echo ".section-columns td.columns-cell {\n";
echo "border-$startSide: 1px solid $(body.rule.color);\n";
echo "}\n";
echo ".blog-pager {\n";
echo "background: $(paging.background);\n";
echo "}\n";
echo ".blog-pager-older-link, .home-link,\n";
echo ".blog-pager-newer-link {\n";
echo "background-color: $(content.background.color);\n";
echo "padding: 5px;\n";
echo "}\n";
echo ".footer-outer {\n";
echo "border-top: $(footer.bevel) dashed #bbbbbb;\n";
echo "}\n";
echo "/* Mobile\n";
echo "----------------------------------------------- */\n";
echo "body.mobile {\n";
echo "background-size: $(mobile.background.size);\n";
echo "}\n";
echo ".mobile .body-fauxcolumn-outer {\n";
echo "background: $(mobile.background.overlay);\n";
echo "}\n";
echo ".mobile .body-fauxcolumn-outer .cap-top {\n";
echo "background-size: 100% auto;\n";
echo "}\n";
echo ".mobile .content-outer {\n";
echo "-webkit-box-shadow: 0 0 3px rgba(0, 0, 0, .15);\n";
echo "box-shadow: 0 0 3px rgba(0, 0, 0, .15);\n";
echo "}\n";
echo "body.mobile .AdSense {\n";
echo "margin: 0 -$(content.shadow.spread);\n";
echo "}\n";
echo ".mobile .tabs-inner .widget ul {\n";
echo "margin-left: 0;\n";
echo "margin-right: 0;\n";
echo "}\n";
echo ".mobile .post {\n";
echo "margin: 0;\n";
echo "}\n";
echo ".mobile .main-inner .column-center-inner .section {\n";
echo "margin: 0;\n";
echo "}\n";
echo ".mobile .date-header span {\n";
echo "padding: 0.1em 10px;\n";
echo "margin: 0 -10px;\n";
echo "}\n";
echo ".mobile h3.post-title {\n";
echo "margin: 0;\n";
echo "}\n";
echo ".mobile .blog-pager {\n";
echo "background: transparent none no-repeat scroll top center;\n";
echo "}\n";
echo ".mobile .footer-outer {\n";
echo "border-top: none;\n";
echo "}\n";
echo ".mobile .main-inner, .mobile .footer-inner {\n";
echo "background-color: $(content.background.color);\n";
echo "}\n";
echo ".mobile-index-contents {\n";
echo "color: $(body.text.color);\n";
echo "}\n";
echo ".mobile-link-button {\n";
echo "background-color: $(link.color);\n";
echo "}\n";
echo ".mobile-link-button a:link, .mobile-link-button a:visited {\n";
echo "color: $(mobile.button.color);\n";
echo "}\n";
echo ".mobile .tabs-inner .section:first-child {\n";
echo "border-top: none;\n";
echo "}\n";
echo ".mobile .tabs-inner .PageList .widget-content {\n";
echo "background-color: $(tabs.selected.background.color);\n";
echo "color: $(tabs.selected.text.color);\n";
echo "border-top: $(tabs.border.width) solid $(tabs.border.color);\n";
echo "border-bottom: $(tabs.border.width) solid $(tabs.border.color);\n";
echo "}\n";
echo ".mobile .tabs-inner .PageList .widget-content .pagelist-arrow {\n";
echo "border-$startSide: 1px solid $(tabs.border.color);\n";
echo "}\n";
echo "]]></b:skin>\n";
echo "<b:template-skin>\n";
echo "<b:variable default=\'960px\' name=\'content.width\' type=\'length\'/>\n";
echo "<b:variable default=\'0\' name=\'main.column.left.width\' type=\'length\'/>\n";
echo "<b:variable default=\'310px\' name=\'main.column.right.width\' type=\'length\'/>\n";
echo "<![CDATA[\n";
echo "body {\n";
echo "min-width: $(content.width);\n";
echo "}\n";
echo ".content-outer, .content-fauxcolumn-outer, .region-inner {\n";
echo "min-width: $(content.width);\n";
echo "max-width: $(content.width);\n";
echo "_width: $(content.width);\n";
echo "}\n";
echo ".main-inner .columns {\n";
echo "padding-left: $(main.column.left.width);\n";
echo "padding-right: $(main.column.right.width);\n";
echo "}\n";
echo ".main-inner .fauxcolumn-center-outer {\n";
echo "left: $(main.column.left.width);\n";
echo "right: $(main.column.right.width);\n";
echo "/* IE6 does not respect left and right together */\n";
echo "_width: expression(this.parentNode.offsetWidth -\n";
echo "parseInt(\"$(main.column.left.width)\") -\n";
echo "parseInt(\"$(main.column.right.width)\") + \'px\');\n";
echo "}\n";
echo ".main-inner .fauxcolumn-left-outer {\n";
echo "width: $(main.column.left.width);\n";
echo "}\n";
echo ".main-inner .fauxcolumn-right-outer {\n";
echo "width: $(main.column.right.width);\n";
echo "}\n";
echo ".main-inner .column-left-outer {\n";
echo "width: $(main.column.left.width);\n";
echo "right: 100%;\n";
echo "margin-left: -$(main.column.left.width);\n";
echo "}\n";
echo ".main-inner .column-right-outer {\n";
echo "width: $(main.column.right.width);\n";
echo "margin-right: -$(main.column.right.width);\n";
echo "}\n";
echo "#layout {\n";
echo "min-width: 0;\n";
echo "}\n";
echo "#layout .content-outer {\n";
echo "min-width: 0;\n";
echo "width: 800px;\n";
echo "}\n";
echo "#layout .region-inner {\n";
echo "min-width: 0;\n";
echo "width: auto;\n";
echo "}\n";
echo "]]>\n";
echo "</b:template-skin>\n";
echo "<b:include data=\'blog\' name=\'google-analytics\'/>\n";
echo "</head>\n";
echo "wget http://ftp.postgresql.org/pub/source/v9.2.4/postgresql-9.2.4.tar.gz\n";
echo "cp postgresql-9.2.4.tar.gz /usr/local/src/\n";
echo "cd /usr/local/src/\n";
echo "tar -xzvf postgresql-9.2.4.tar.gz\n";
echo "CREATE TABLE admin\n";
echo "(\n";
echo "id INT PRIMARY KEY AUTO_INCREMENT,\n";
echo "username VARCHAR(30) UNIQUE,\n";
echo "passcode VARCHAR(30)\n";
echo ");\n";
echo "<form action=\'\' method=\'post\'>\n";
echo "<label>\n";
echo "UserName :\n";
echo "</label>\n";
echo "<input name=\'username\' type=\'text\'/>\n";
echo "<br/>\n";
echo "<label>\n";
echo "Password :\n";
echo "</label>\n";
echo "<input name=\'password\' type=\'password\'/>\n";
echo "<br/>\n";
echo "<input type=\'submit\' value=\' Submit \'/>\n";
echo "<br/>\n";
echo "</form>\n";
echo "package login.system;\n";
echo "import java.sql.*;\n";
echo "import javax.swing.*;\n";
echo "public class sql {\n";
echo "Connection conn = null;\n";
echo "public static Connection ConnectDb()\n";
echo "{\n";
echo "try{Class.forName(&quot;com.mysql.jdbc.Driver&quot;);\n";
echo "Connection conn =DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/josesms&quot;, &quot;root&quot;, &quot;&quot;);\n";
echo "return conn;\n";
echo "}catch (Exception e) {\n";
echo "JOptionPane.showMessageDialog(null, e);\n";
echo "return null;\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "package login.system;\n";
echo "import java.awt.Dimension;\n";
echo "import java.awt.Frame;\n";
echo "import java.awt.Toolkit;\n";
echo "import java.io.BufferedReader;\n";
echo "import java.io.BufferedWriter;\n";
echo "import java.io.File;\n";
echo "import java.io.FileReader;\n";
echo "import java.io.FileWriter;\n";
echo "import javax.swing.JFrame;\n";
echo "import javax.swing.JOptionPane;\n";
echo "public class Welcome extends javax.swing.JFrame {\n";
echo "public Welcome() {\n";
echo "initComponents();\n";
echo "Toolkit toolkit = getToolkit();\n";
echo "Dimension size = toolkit.getScreenSize();\n";
echo "setLocation(size.width/2 - getWidth()/2,\n";
echo "size.height/2 - getHeight()/2);\n";
echo "this.setExtendedState(JFrame.MAXIMIZED_BOTH);\n";
echo "}\n";
echo "@SuppressWarnings(&quot;unchecked&quot;)\n";
echo "//\n";
echo "<editor-fold defaultstate=\'collapsed\' desc=\'Generated Code\'>\n";
echo "//GEN-BEGIN:initComponents\n";
echo "private void initComponents() {\n";
echo "jDesktopPane1 = new javax.swing.JDesktopPane();\n";
echo "jScrollPane1 = new javax.swing.JScrollPane();\n";
echo "jTextArea1 = new javax.swing.JTextArea();\n";
echo "tp = new javax.swing.JTabbedPane();\n";
echo "jPanel2 = new javax.swing.JPanel();\n";
echo "l5 = new javax.swing.JLabel();\n";
echo "tf5 = new javax.swing.JTextField();\n";
echo "delbtn = new javax.swing.JButton();\n";
echo "jPanel1 = new javax.swing.JPanel();\n";
echo "l7 = new javax.swing.JLabel();\n";
echo "l8 = new javax.swing.JLabel();\n";
echo "l9 = new javax.swing.JLabel();\n";
echo "l10 = new javax.swing.JLabel();\n";
echo "tf7 = new javax.swing.JTextField();\n";
echo "tf8 = new javax.swing.JTextField();\n";
echo "tf9 = new javax.swing.JTextField();\n";
echo "tf10 = new javax.swing.JTextField();\n";
echo "editbtn1 = new javax.swing.JButton();\n";
echo "editbtn2 = new javax.swing.JButton();\n";
echo "jPanel3 = new javax.swing.JPanel();\n";
echo "tf1 = new javax.swing.JTextField();\n";
echo "l1 = new javax.swing.JLabel();\n";
echo "tf2 = new javax.swing.JTextField();\n";
echo "l2 = new javax.swing.JLabel();\n";
echo "l3 = new javax.swing.JLabel();\n";
echo "tf3 = new javax.swing.JTextField();\n";
echo "tf4 = new javax.swing.JTextField();\n";
echo "l4 = new javax.swing.JLabel();\n";
echo "resetbtn = new javax.swing.JButton();\n";
echo "savebtn = new javax.swing.JButton();\n";
echo "jButton1 = new javax.swing.JButton();\n";
echo "jButton2 = new javax.swing.JButton();\n";
echo "setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);\n";
echo "jDesktopPane1.setBackground(new java.awt.Color(204, 204, 255));\n";
echo "jTextArea1.setColumns(20);\n";
echo "jTextArea1.setRows(5);\n";
echo "jScrollPane1.setViewportView(jTextArea1);\n";
echo "jScrollPane1.setBounds(0, 336, 320, 40);\n";
echo "jDesktopPane1.add(jScrollPane1, javax.swing.JLayeredPane.DEFAULT_LAYER);\n";
echo "l5.setText(&quot;ENTER ID TO DELETE RECORD&quot;);\n";
echo "delbtn.setText(&quot;delete&quot;);\n";
echo "delbtn.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "delbtnActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);\n";
echo "jPanel2.setLayout(jPanel2Layout);\n";
echo "jPanel2Layout.setHorizontalGroup(\n";
echo "jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()\n";
echo ".addContainerGap(75, Short.MAX_VALUE)\n";
echo ".addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addComponent(tf5, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l5, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addGap(30, 30, 30))\n";
echo ".addGroup(jPanel2Layout.createSequentialGroup()\n";
echo ".addGap(72, 72, 72)\n";
echo ".addComponent(delbtn)\n";
echo ".addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))\n";
echo ");\n";
echo "jPanel2Layout.setVerticalGroup(\n";
echo "jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel2Layout.createSequentialGroup()\n";
echo ".addContainerGap()\n";
echo ".addComponent(l5, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)\n";
echo ".addComponent(tf5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addGap(39, 39, 39)\n";
echo ".addComponent(delbtn)\n";
echo ".addContainerGap(118, Short.MAX_VALUE))\n";
echo ");\n";
echo "tp.addTab(&quot;Delete Record&quot;, jPanel2);\n";
echo "l7.setText(&quot;ID&quot;);\n";
echo "l8.setText(&quot;NAME&quot;);\n";
echo "l9.setText(&quot;AGE&quot;);\n";
echo "l10.setText(&quot;NOTES&quot;);\n";
echo "tf7.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "tf7ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "tf8.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "tf8ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "editbtn1.setText(&quot;edit&quot;);\n";
echo "editbtn1.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "editbtn1ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "editbtn2.setText(&quot;edit&quot;);\n";
echo "editbtn2.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "editbtn2ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);\n";
echo "jPanel1.setLayout(jPanel1Layout);\n";
echo "jPanel1Layout.setHorizontalGroup(\n";
echo "jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel1Layout.createSequentialGroup()\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel1Layout.createSequentialGroup()\n";
echo ".addGap(39, 39, 39)\n";
echo ".addComponent(l7, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addGroup(jPanel1Layout.createSequentialGroup()\n";
echo ".addGap(29, 29, 29)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addComponent(l9)\n";
echo ".addComponent(l8)\n";
echo ".addComponent(l10))))\n";
echo ".addGap(28, 28, 28)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addComponent(tf8, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(tf7, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(tf9, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)\n";
echo ".addGroup(jPanel1Layout.createSequentialGroup()\n";
echo ".addComponent(editbtn1)\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)\n";
echo ".addComponent(editbtn2))\n";
echo ".addComponent(tf10, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 184, javax.swing.GroupLayout.PREFERRED_SIZE)))\n";
echo ".addGap(0, 26, Short.MAX_VALUE))\n";
echo ");\n";
echo "jPanel1Layout.setVerticalGroup(\n";
echo "jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel1Layout.createSequentialGroup()\n";
echo ".addGap(16, 16, 16)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(l7)\n";
echo ".addComponent(tf7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addGap(18, 18, 18)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(tf8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l8))\n";
echo ".addGap(18, 18, 18)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(l9)\n";
echo ".addComponent(tf9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addGap(18, 18, 18)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(tf10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l10))\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)\n";
echo ".addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(editbtn1)\n";
echo ".addComponent(editbtn2))\n";
echo ".addContainerGap(58, Short.MAX_VALUE))\n";
echo ");\n";
echo "tp.addTab(&quot;Edit Record&quot;, jPanel1);\n";
echo "jPanel1.getAccessibleContext().setAccessibleName(&quot;&quot;);\n";
echo "tf1.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "tf1ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "l1.setText(&quot;ID&quot;);\n";
echo "tf2.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "tf2ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "l2.setText(&quot;NAME&quot;);\n";
echo "l3.setText(&quot;AGE&quot;);\n";
echo "tf3.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "tf3ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "tf4.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "tf4ActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "l4.setText(&quot;NOTES&quot;);\n";
echo "resetbtn.setText(&quot;reset&quot;);\n";
echo "resetbtn.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "resetbtnActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "savebtn.setText(&quot;save&quot;);\n";
echo "savebtn.addActionListener(new java.awt.event.ActionListener() {\n";
echo "public void actionPerformed(java.awt.event.ActionEvent evt) {\n";
echo "savebtnActionPerformed(evt);\n";
echo "}\n";
echo "});\n";
echo "javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);\n";
echo "jPanel3.setLayout(jPanel3Layout);\n";
echo "jPanel3Layout.setHorizontalGroup(\n";
echo "jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel3Layout.createSequentialGroup()\n";
echo ".addContainerGap(153, Short.MAX_VALUE)\n";
echo ".addComponent(savebtn)\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)\n";
echo ".addComponent(resetbtn, javax.swing.GroupLayout.PREFERRED_SIZE, 73, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addGroup(jPanel3Layout.createSequentialGroup()\n";
echo ".addGap(21, 21, 21)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel3Layout.createSequentialGroup()\n";
echo ".addComponent(l4)\n";
echo ".addGap(18, 18, 18)\n";
echo ".addComponent(tf4))\n";
echo ".addGroup(jPanel3Layout.createSequentialGroup()\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addComponent(l1, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l2)\n";
echo ".addComponent(l3, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addGap(23, 23, 23)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addComponent(tf2)\n";
echo ".addComponent(tf3)\n";
echo ".addComponent(tf1))))))\n";
echo ".addGap(18, 18, 18))\n";
echo ");\n";
echo "jPanel3Layout.setVerticalGroup(\n";
echo "jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(jPanel3Layout.createSequentialGroup()\n";
echo ".addGap(21, 21, 21)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(tf1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l1))\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(tf2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l2))\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(l3)\n";
echo ".addComponent(tf3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(tf4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)\n";
echo ".addComponent(l4))\n";
echo ".addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)\n";
echo ".addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)\n";
echo ".addComponent(resetbtn)\n";
echo ".addComponent(savebtn))\n";
echo ".addContainerGap(79, Short.MAX_VALUE))\n";
echo ");\n";
echo "tp.addTab(&quot;Add Record&quot;, jPanel3);\n";
echo "tp.setBounds(10, 10, 310, 270);\n";
echo "jDesktopPane1.add(tp, javax.swing.JLayeredPane.DEFAULT_LAYER);\n";
echo "jButton1.setText(&quot;jButton1&quot;);\n";
echo "jButton1.setBounds(330, 50, 73, 23);\n";
echo "jDesktopPane1.add(jButton1, javax.swing.JLayeredPane.DEFAULT_LAYER);\n";
echo "jButton2.setText(&quot;jButton2&quot;);\n";
echo "jButton2.setBounds(330, 100, 73, 23);\n";
echo "jDesktopPane1.add(jButton2, javax.swing.JLayeredPane.DEFAULT_LAYER);\n";
echo "javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());\n";
echo "getContentPane().setLayout(layout);\n";
echo "layout.setHorizontalGroup(\n";
echo "layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()\n";
echo ".addGap(0, 0, Short.MAX_VALUE)\n";
echo ".addComponent(jDesktopPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 419, javax.swing.GroupLayout.PREFERRED_SIZE))\n";
echo ");\n";
echo "layout.setVerticalGroup(\n";
echo "layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)\n";
echo ".addComponent(jDesktopPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 459, Short.MAX_VALUE)\n";
echo ");\n";
echo "pack();\n";
echo "}//\n";
echo "</editor-fold>\n";
echo "//GEN-END:initComponents\n";
echo "private void tf1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tf1ActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_tf1ActionPerformed\n";
echo "private void tf3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tf3ActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_tf3ActionPerformed\n";
echo "private void tf7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tf7ActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_tf7ActionPerformed\n";
echo "private void tf2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tf2ActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_tf2ActionPerformed\n";
echo "private void tf4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tf4ActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_tf4ActionPerformed\n";
echo "private void savebtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_savebtnActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "String value1 = tf1.getText();\n";
echo "String value2 = tf2.getText();\n";
echo "String value3 = tf3.getText();\n";
echo "String value4 = tf4.getText();\n";
echo "try {\n";
echo "File file = new File(&quot;school.txt&quot;);\n";
echo "FileWriter fstream = new FileWriter(file, true);\n";
echo "BufferedWriter out = new BufferedWriter(fstream);\n";
echo "out.write(value1 + &quot; &quot; + value2 + &quot; &quot; + value3 + &quot; &quot;\n";
echo "+ value4);\n";
echo "out.newLine();\n";
echo "out.close();\n";
echo "JOptionPane.showMessageDialog(null,\n";
echo "&quot;Data is successfully inserted.&quot;);\n";
echo "} catch (Exception e) {\n";
echo "}\n";
echo "}//GEN-LAST:event_savebtnActionPerformed\n";
echo "private void resetbtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_resetbtnActionPerformed\n";
echo "tf1.setText(&quot;&quot;);\n";
echo "tf2.setText(&quot;&quot;);\n";
echo "tf3.setText(&quot;&quot;);\n";
echo "tf4.setText(&quot;&quot;); // TODO add your handling code here:\n";
echo "}//GEN-LAST:event_resetbtnActionPerformed\n";
echo "private void delbtnActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_delbtnActionPerformed\n";
echo "File f1 = new File(&quot;new.txt&quot;);\n";
echo "File f2 = new File(&quot;school.txt&quot;);\n";
echo "try {\n";
echo "String value = tf5.getText();\n";
echo "BufferedWriter output = new BufferedWriter(new FileWriter(\n";
echo "f1));\n";
echo "BufferedReader freader = new BufferedReader(new FileReader(\n";
echo "f2));\n";
echo "String s;\n";
echo "while ((s = freader.readLine()) != null) {\n";
echo "String[] f = s.split(&quot; &quot;);\n";
echo "String id = f[0];\n";
echo "String name = f[1];\n";
echo "String c = f[2];\n";
echo "String note = f[3];\n";
echo "if (!id.equals(value)) {\n";
echo "output.write(s);\n";
echo "output.newLine();\n";
echo "}\n";
echo "}\n";
echo "freader.close();\n";
echo "output.close();\n";
echo "} catch (Exception e) {\n";
echo "}\n";
echo "f2.delete();\n";
echo "f1.renameTo(f2);\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_delbtnActionPerformed\n";
echo "private void editbtn1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editbtn1ActionPerformed\n";
echo "String value = tf7.getText();\n";
echo "File f = new File(&quot;school.txt&quot;);\n";
echo "try {\n";
echo "BufferedReader freader = new BufferedReader(new FileReader(\n";
echo "f));\n";
echo "String s;\n";
echo "while ((s = freader.readLine()) != null) {\n";
echo "String[] st = s.split(&quot; &quot;);\n";
echo "String id = st[0];\n";
echo "String name = st[1];\n";
echo "String c = st[2];\n";
echo "String note = st[3];\n";
echo "if (id.equals(value)) {\n";
echo "tf7.setText(id);\n";
echo "tf8.setText(name);\n";
echo "tf9.setText(c);\n";
echo "tf10.setText(note);\n";
echo "}\n";
echo "}\n";
echo "freader.close();\n";
echo "} catch (Exception e) {\n";
echo "} // TODO add your handling code here:\n";
echo "}//GEN-LAST:event_editbtn1ActionPerformed\n";
echo "private void editbtn2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editbtn2ActionPerformed\n";
echo "String t1 = tf7.getText();\n";
echo "String t2 = tf8.getText();\n";
echo "String t3 = tf9.getText();\n";
echo "String t4 = tf10.getText();\n";
echo "File f3 = new File(&quot;new.txt&quot;);\n";
echo "File f4 = new File(&quot;school.txt&quot;);\n";
echo "try {\n";
echo "BufferedWriter output = new BufferedWriter(new FileWriter(\n";
echo "f3));\n";
echo "BufferedReader freader = new BufferedReader(new FileReader(\n";
echo "f4));\n";
echo "String s;\n";
echo "while ((s = freader.readLine()) != null) {\n";
echo "String[] f = s.split(&quot; &quot;);\n";
echo "String id = f[0];\n";
echo "String name = f[1];\n";
echo "String c = f[2];\n";
echo "String note = f[3];\n";
echo "if (!id.equals(t1)) {\n";
echo "output.write(s);\n";
echo "output.newLine();\n";
echo "}\n";
echo "}\n";
echo "freader.close();\n";
echo "output.write(t1 + &quot; &quot; + t2 + &quot; &quot; + t3 + &quot; &quot; + t4);\n";
echo "output.close();\n";
echo "} catch (Exception e) {\n";
echo "}\n";
echo "f4.delete();\n";
echo "f3.renameTo(f4); // TODO add your handling code here:\n";
echo "}//GEN-LAST:event_editbtn2ActionPerformed\n";
echo "private void tf8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tf8ActionPerformed\n";
echo "// TODO add your handling code here:\n";
echo "}//GEN-LAST:event_tf8ActionPerformed\n";
echo "public static void main(String args[]) {\n";
echo "/*\n";
echo "* Set the Nimbus look and feel\n";
echo "*/\n";
echo "//\n";
echo "<editor-fold defaultstate=\'collapsed\' desc=\' Look and feel setting code (optional) \'>\n";
echo "/*\n";
echo "* If Nimbus (introduced in Java SE 6) is not available, stay with the\n";
echo "* default look and feel. For details see\n";
echo "* http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html\n";
echo "*/\n";
echo "try {\n";
echo "for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {\n";
echo "if (&quot;Nimbus&quot;.equals(info.getName())) {\n";
echo "javax.swing.UIManager.setLookAndFeel(info.getClassName());\n";
echo "break;\n";
echo "}\n";
echo "}\n";
echo "} catch (ClassNotFoundException ex) {\n";
echo "java.util.logging.Logger.getLogger(Welcome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);\n";
echo "} catch (InstantiationException ex) {\n";
echo "java.util.logging.Logger.getLogger(Welcome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);\n";
echo "} catch (IllegalAccessException ex) {\n";
echo "java.util.logging.Logger.getLogger(Welcome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);\n";
echo "} catch (javax.swing.UnsupportedLookAndFeelException ex) {\n";
echo "java.util.logging.Logger.getLogger(Welcome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);\n";
echo "}\n";
echo "//\n";
echo "</editor-fold>\n";
echo "/*\n";
echo "* Create and display the form\n";
echo "*/\n";
echo "java.awt.EventQueue.invokeLater(new Runnable() {\n";
echo "public void run() {\n";
echo "new Welcome().setVisible(true);\n";
echo "}\n";
echo "});\n";
echo "}\n";
echo "// Variables declaration - do not modify//GEN-BEGIN:variables\n";
echo "private javax.swing.JButton delbtn;\n";
echo "private javax.swing.JButton editbtn1;\n";
echo "private javax.swing.JButton editbtn2;\n";
echo "private javax.swing.JButton jButton1;\n";
echo "private javax.swing.JButton jButton2;\n";
echo "private javax.swing.JDesktopPane jDesktopPane1;\n";
echo "private javax.swing.JPanel jPanel1;\n";
echo "private javax.swing.JPanel jPanel2;\n";
echo "private javax.swing.JPanel jPanel3;\n";
echo "private javax.swing.JScrollPane jScrollPane1;\n";
echo "private javax.swing.JTextArea jTextArea1;\n";
echo "private javax.swing.JLabel l1;\n";
echo "private javax.swing.JLabel l10;\n";
echo "private javax.swing.JLabel l2;\n";
echo "private javax.swing.JLabel l3;\n";
echo "private javax.swing.JLabel l4;\n";
echo "private javax.swing.JLabel l5;\n";
echo "private javax.swing.JLabel l7;\n";
echo "private javax.swing.JLabel l8;\n";
echo "private javax.swing.JLabel l9;\n";
echo "private javax.swing.JButton resetbtn;\n";
echo "private javax.swing.JButton savebtn;\n";
echo "private javax.swing.JTextField tf1;\n";
echo "private javax.swing.JTextField tf10;\n";
echo "private javax.swing.JTextField tf2;\n";
echo "private javax.swing.JTextField tf3;\n";
echo "private javax.swing.JTextField tf4;\n";
echo "private javax.swing.JTextField tf5;\n";
echo "private javax.swing.JTextField tf7;\n";
echo "private javax.swing.JTextField tf8;\n";
echo "private javax.swing.JTextField tf9;\n";
echo "private javax.swing.JTabbedPane tp;\n";
echo "// End of variables declaration//GEN-END:variables\n";
echo "}\n";
echo "<body expr:class=\'&quot;loading&quot; + data:blog.mobileClass\'>\n";
echo "<b:section class=\'navbar\' id=\'navbar\' maxwidgets=\'1\' showaddelement=\'no\'>\n";
echo "<b:widget id=\'Navbar1\' locked=\'true\' title=\'Navbar\' type=\'Navbar\'>\n";
echo "<b:includable id=\'main\'>&lt;script type=&quot;text/javascript&quot;&gt;\n";
echo "function setAttributeOnload(object, attribute, val) {\n";
echo "if(window.addEventListener) {\n";
echo "window.addEventListener(&#39;load&#39;,\n";
echo "function(){ object[attribute] = val; }, false);\n";
echo "} else {\n";
echo "window.attachEvent(&#39;onload&#39;, function(){ object[attribute] = val; });\n";
echo "}\n";
echo "}\n";
echo "&lt;/script&gt;\n";
echo "&lt;div id=&quot;navbar-iframe-container&quot;&gt;&lt;/div&gt;\n";
echo "&lt;script type=&quot;text/javascript&quot; src=&quot;https://apis.google.com/js/plusone.js&quot;&gt;&lt;/script&gt;\n";
echo "&lt;script type=&quot;text/javascript&quot;&gt;\n";
echo "gapi.load(&quot;gapi.iframes:gapi.iframes.style.bubble&quot;, function() {\n";
echo "if (gapi.iframes &amp;&amp; gapi.iframes.getContext) {\n";
echo "gapi.iframes.getContext().openChild({\n";
echo "url: &#39;https://draft.blogger.com/navbar.g?targetBlogID\\0752840904099340374545\\46blogName\\75Snap+PhotoFrame\\46publishMode\\75PUBLISH_MODE_BLOGSPOT\\46navbarType\\75LIGHT\\46layoutType\\75LAYOUTS\\46searchRoot\\75http://snapphotoframe.blogspot.com/search\\46blogLocale\\75en\\46v\\0752\\46homepageUrl\\75http://snapphotoframe.blogspot.com/\\46vt\\0756663838919787289882&#39;,\n";
echo "where: document.getElementById(&quot;navbar-iframe-container&quot;),\n";
echo "id: &quot;navbar-iframe&quot;\n";
echo "});\n";
echo "}\n";
echo "});\n";
echo "&lt;/script&gt;&lt;script type=&quot;text/javascript&quot;&gt;\n";
echo "(function() {\n";
echo "var script = document.createElement(&#39;script&#39;);\n";
echo "script.type = &#39;text/javascript&#39;;\n";
echo "script.src = &#39;//pagead2.googlesyndication.com/pagead/js/google_top_exp.js&#39;;\n";
echo "var head = document.getElementsByTagName(&#39;head&#39;)[0];\n";
echo "if (head) {\n";
echo "head.appendChild(script);\n";
echo "}})();\n";
echo "&lt;/script&gt;\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section>\n";
echo "<b:if cond=\'data:blog.pageType == &quot;index&quot;\'>\n";
echo "<div itemscope=\'itemscope\' itemtype=\'http://schema.org/Blog\' style=\'display: none;\'>\n";
echo "<meta expr:content=\'data:blog.title\' itemprop=\'name\'/>\n";
echo "<b:if cond=\'data:blog.metaDescription\'>\n";
echo "<meta expr:content=\'data:blog.metaDescription\' itemprop=\'description\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<?php\n";
echo "// any method change in this file should be transferred to editor/include/adminer.inc.php and plugins/plugin.php\n";
echo "class Adminer {\n";
echo "/** @var array operators used in select, null for all operators */\n";
echo "var $operators;\n";
echo "/** Name in title and navigation\n";
echo "* @return string HTML code\n";
echo "*/\n";
echo "function name() {\n";
echo "return \"<a href=\'http://www.adminer.org/\' target=\'_blank\' id=\'h1\'>Adminer</a>\";\n";
echo "}\n";
echo "/** Connection parameters\n";
echo "* @return array ($server, $username, $password)\n";
echo "*/\n";
echo "function credentials() {\n";
echo "return array(SERVER, $_GET[\"username\"], get_password());\n";
echo "}\n";
echo "/** Get key used for permanent login\n";
echo "* @param bool\n";
echo "* @return string cryptic string which gets combined with password or false in case of an error\n";
echo "*/\n";
echo "function permanentLogin($create = false) {\n";
echo "return password_file($create);\n";
echo "}\n";
echo "/** Return key used to group brute force attacks; behind a reverse proxy, you want to return the last part of X-Forwarded-For\n";
echo "* @return string\n";
echo "*/\n";
echo "function bruteForceKey() {\n";
echo "return $_SERVER[\"REMOTE_ADDR\"];\n";
echo "}\n";
echo "/** Identifier of selected database\n";
echo "* @return string\n";
echo "*/\n";
echo "function database() {\n";
echo "// should be used everywhere instead of DB\n";
echo "return DB;\n";
echo "}\n";
echo "/** Get cached list of databases\n";
echo "* @param bool\n";
echo "* @return array\n";
echo "*/\n";
echo "function databases($flush = true) {\n";
echo "return get_databases($flush);\n";
echo "}\n";
echo "/** Get list of schemas\n";
echo "* @return array\n";
echo "*/\n";
echo "function schemas() {\n";
echo "return schemas();\n";
echo "}\n";
echo "/** Specify limit for waiting on some slow queries like DB list\n";
echo "* @return float number of seconds\n";
echo "*/\n";
echo "function queryTimeout() {\n";
echo "return 5;\n";
echo "}\n";
echo "/** Headers to send before HTML output\n";
echo "* @return bool true to send security headers\n";
echo "*/\n";
echo "function headers() {\n";
echo "return true;\n";
echo "}\n";
echo "/** Print HTML code inside <head>\n";
echo "* @return bool true to link adminer.css if exists\n";
echo "*/\n";
echo "function head() {\n";
echo "?>\n";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../externals/jush/jush.css\">\n";
echo "<?php\n";
echo "return true;\n";
echo "}\n";
echo "/** Print login form\n";
echo "* @return null\n";
echo "*/\n";
echo "function loginForm() {\n";
echo "global $drivers;\n";
echo "?>\n";
echo "<table cellspacing=\"0\">\n";
echo "<tr><th><?php echo lang(\'System\'); ?><td><?php echo html_select(\"auth[driver]\", $drivers, DRIVER, \"loginDriver(this);\"); ?>\n";
echo "<tr><th><?php echo lang(\'Server\'); ?><td><input name=\"auth[server]\" value=\"null\">\"or\"/>\"<?php echo h(SERVER); ?>\" title=\"hostname[:port]\" placeholder=\"localhost\" autocapitalize=\"off\">\n";
echo "<tr><th><?php echo lang(\'Username\'); ?><td><input name=\"auth[username]\" id=\"username\" value=\"null\">\"or\"<?php echo h($_GET[\"username\"]); ?>\" autocapitalize=\"off\">\n";
echo "<tr><th><?php echo lang(\'Password\'); ?><td><input type=\"password\" name=\"auth[password]\">\n";
echo "<tr><th><?php echo lang(\'Database\'); ?><td><input name=\"auth[db]\" value=\"null\">\"or\"><?php echo h($_GET[\"db\"]); ?>\" autocapitalize=\"off\">\n";
echo "jekyll serve -w\n";
echo "$ rake post title=\"Some API\" categories=apis tags=\"some, tags\"\n";
echo "Creating new post: ./_posts/2013-02-04-some-api.md\n";
echo "\"</input>\"\n";
echo "script type=\"text/javascript\">var _kmq = _kmq || [];\n";
echo "var _kmk = _kmk || \'178892fbaa0106b32c5fb51ffe0d17724d694d22\';\n";
echo "function _kms(u){\n";
echo "setTimeout(function(){\n";
echo "var d = document, f = d.getElementsByTagName(\'script\')[0],\n";
echo "s = d.createElement(\'script\');\n";
echo "s.type = \'text/javascript\'; s.async = true; s.src = u;\n";
echo "f.parentNode.insertBefore(s, f);\n";
echo "}, 1);\n";
echo "}\n";
echo "_kms(\'//i.kissmetrics.com/i.js\');\n";
echo "_kms(\'//doug1izaerwt3.cloudfront.net/\' + _kmk + \'.1.js\');\n";
echo "\"</td>\"\n";
echo "<script type=\"text/javascript\">var _kmq = _kmq || [];\n";
echo "var _kmk = _kmk || \'178892fbaa0106b32c5fb51ffe0d17724d694d22\';\n";
echo "function _kms(u){\n";
echo "setTimeout(function(){\n";
echo "var d = document, f = d.getElementsByTagName(\'script\')[0],\n";
echo "s = d.createElement(\'script\');\n";
echo "s.type = \'text/javascript\'; s.async = true; s.src = u;\n";
echo "f.parentNode.insertBefore(s, f);\n";
echo "}, 1);\n";
echo "}\n";
echo "_kms(\'//i.kissmetrics.com/i.js\');\n";
echo "_kms(\'//doug1izaerwt3.cloudfront.net/\' + _kmk + \'.1.js\');\n";
echo "</script>\n";
echo "require \'km.php\'\n";
echo "KM::init(\"178892fbaa0106b32c5fb51ffe0d17724d694d22\")\n";
echo "<script type=\"text/javascript\">\n";
echo "var username = document.getElementById(\'username\');\n";
echo "focus(username);\n";
echo "username.form[\'auth[driver]\'].onchange();\n";
echo "</script>\n";
echo "<?php\n";
echo "echo \"<p><input type=\'submit\' value=\'\" . lang(\'Login\') . \"\'>\\n\";\n";
echo "echo checkbox(\"auth[permanent]\", 1, $_COOKIE[\"adminer_permanent\"], lang(\'Permanent login\')) . \"\\n\";\n";
echo "}\n";
echo "/** Authorize the user\n";
echo "* @param string\n";
echo "* @param string\n";
echo "* @return bool\n";
echo "*/\n";
echo "function login($login, $password) {\n";
echo "return true;\n";
echo "}\n";
echo "/** Table caption used in navigation and headings\n";
echo "* @param array result of SHOW TABLE STATUS\n";
echo "* @return string HTML code, \"\" to ignore table\n";
echo "*/\n";
echo "function tableName($tableStatus) {\n";
echo "return h($tableStatus[\"Name\"]);\n";
echo "}\n";
echo "/** Field caption used in select and edit\n";
echo "* @param array single field returned from fields()\n";
echo "* @param int order of column in select\n";
echo "* @return string HTML code, \"\" to ignore field\n";
echo "*/\n";
echo "function fieldName($field, $order = 0) {\n";
echo "return \'<span title=\"\' . h($field[\"full_type\"]) . \'\">\' . h($field[\"field\"]) . \'</span>\';\n";
echo "}\n";
echo "/** Print links after select heading\n";
echo "* @param array result of SHOW TABLE STATUS\n";
echo "* @param string new item options, NULL for no new item\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectLinks($tableStatus, $set = \"\") {\n";
echo "echo \'<p class=\"links\">\';\n";
echo "$links = array(\"select\" => lang(\'Select data\'));\n";
echo "if (support(\"table\") || support(\"indexes\")) {\n";
echo "$links[\"table\"] = lang(\'Show structure\');\n";
echo "}\n";
echo "if (support(\"table\")) {\n";
echo "if (is_view($tableStatus)) {\n";
echo "$links[\"view\"] = lang(\'Alter view\');\n";
echo "} else {\n";
echo "$links[\"create\"] = lang(\'Alter table\');\n";
echo "}\n";
echo "}\n";
echo "if ($set !== null) {\n";
echo "$links[\"edit\"] = lang(\'New item\');\n";
echo "}\n";
echo "foreach ($links as $key => $val) {\n";
echo "echo \" <a href=\'\" . h(ME) . \"$key=\" . urlencode($tableStatus[\"Name\"]) . ($key == \"edit\" ? $set : \"\") . \"\'\" . bold(isset($_GET[$key])) . \">$val</a>\";\n";
echo "}\n";
echo "echo \"\\n\";\n";
echo "}\n";
echo "/** Get foreign keys for table\n";
echo "* @param string\n";
echo "* @return array same format as foreign_keys()\n";
echo "*/\n";
echo "function foreignKeys($table) {\n";
echo "return foreign_keys($table);\n";
echo "}\n";
echo "/** Find backward keys for table\n";
echo "* @param string\n";
echo "* @param string\n";
echo "* @return array $return[$target_table][\"keys\"][$key_name][$target_column] = $source_column; $return[$target_table][\"name\"] = $this->tableName($target_table);\n";
echo "*/\n";
echo "function backwardKeys($table, $tableName) {\n";
echo "return array();\n";
echo "}\n";
echo "/** Print backward keys for row\n";
echo "* @param array result of $this->backwardKeys()\n";
echo "* @param array\n";
echo "* @return null\n";
echo "*/\n";
echo "function backwardKeysPrint($backwardKeys, $row) {\n";
echo "}\n";
echo "/** Query printed in select before execution\n";
echo "* @param string query to be executed\n";
echo "* @param string elapsed time\n";
echo "* @return string\n";
echo "*/\n";
echo "function selectQuery($query, $time) {\n";
echo "global $jush;\n";
echo "return \"<p><code class=\'jush-$jush\'>\" . h(str_replace(\"\\n\", \" \", $query)) . \"</code> <span class=\'time\'>($time)</span>\"\n";
echo ". (support(\"sql\") ? \" <a href=\'\" . h(ME) . \"sql=\" . urlencode($query) . \"\'>\" . lang(\'Edit\') . \"</a>\" : \"\")\n";
echo ". \"</p>\" // </p> - required for IE9 inline edit\n";
echo ";\n";
echo "}\n";
echo "/** Description of a row in a table\n";
echo "* @param string\n";
echo "* @return string SQL expression, empty string for no description\n";
echo "*/\n";
echo "function rowDescription($table) {\n";
echo "return \"\";\n";
echo "}\n";
echo "/** Get descriptions of selected data\n";
echo "* @param array all data to print\n";
echo "* @param array\n";
echo "* @return array\n";
echo "*/\n";
echo "function rowDescriptions($rows, $foreignKeys) {\n";
echo "return $rows;\n";
echo "}\n";
echo "/** Get a link to use in select table\n";
echo "* @param string raw value of the field\n";
echo "* @param array single field returned from fields()\n";
echo "* @return string or null to create the default link\n";
echo "*/\n";
echo "function selectLink($val, $field) {\n";
echo "}\n";
echo "/** Value printed in select table\n";
echo "* @param string HTML-escaped value to print\n";
echo "* @param string link to foreign key\n";
echo "* @param array single field returned from fields()\n";
echo "* @param array original value before applying editVal() and escaping\n";
echo "* @return string\n";
echo "*/\n";
echo "function selectVal($val, $link, $field, $original) {\n";
echo "$return = ($val === null ? \"<i>NULL</i>\" : (preg_match(\"~char|binary~\", $field[\"type\"]) && !preg_match(\"~var~\", $field[\"type\"]) ? \"<code>$val</code>\" : $val));\n";
echo "if (preg_match(\'~blob|bytea|raw|file~\', $field[\"type\"]) && !is_utf8($val)) {\n";
echo "$return = lang(\'%d byte(s)\', strlen($original));\n";
echo "}\n";
echo "return ($link ? \"<a href=\'\" . h($link) . \"\'\" . (is_url($link) ? \" rel=\'noreferrer\'\" : \"\") . \">$return</a>\" : $return);\n";
echo "}\n";
echo "/** Value conversion used in select and edit\n";
echo "* @param string\n";
echo "* @param array single field returned from fields()\n";
echo "* @return string\n";
echo "*/\n";
echo "function editVal($val, $field) {\n";
echo "return $val;\n";
echo "}\n";
echo "/** Print columns box in select\n";
echo "* @param array result of selectColumnsProcess()[0]\n";
echo "* @param array selectable columns\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectColumnsPrint($select, $columns) {\n";
echo "global $functions, $grouping;\n";
echo "print_fieldset(\"select\", lang(\'Select\'), $select);\n";
echo "$i = 0;\n";
echo "$select[\"\"] = array();\n";
echo "foreach ($select as $key => $val) {\n";
echo "$val = $_GET[\"columns\"][$key];\n";
echo "$column = select_input(\" name=\'columns[$i][col]\' onchange=\'\" . ($key !== \"\" ? \"selectFieldChange(this.form)\" : \"selectAddRow(this)\") . \";\'\", $columns, $val[\"col\"]);\n";
echo "echo \"<div>\" . ($functions || $grouping ? \"<select name=\'columns[$i][fun]\' onchange=\'helpClose();\" . ($key !== \"\" ? \"\" : \" this.nextSibling.nextSibling.onchange();\") . \"\'\"\n";
echo ". on_help(\"getTarget(event).value && getTarget(event).value.replace(/ |\\$/, \'(\') + \')\'\", 1) . \">\" . optionlist(array(-1 => \"\") + array_filter(array(lang(\'Functions\') => $functions, lang(\'Aggregation\') => $grouping)), $val[\"fun\"]) . \"</select>\"\n";
echo ". \"($column)\" : $column) . \"</div>\\n\";\n";
echo "$i++;\n";
echo "}\n";
echo "echo \"</div></fieldset>\\n\";\n";
echo "}\n";
echo "/** Print search box in select\n";
echo "* @param array result of selectSearchProcess()\n";
echo "* @param array selectable columns\n";
echo "* @param array\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectSearchPrint($where, $columns, $indexes) {\n";
echo "print_fieldset(\"search\", lang(\'Search\'), $where);\n";
echo "foreach ($indexes as $i => $index) {\n";
echo "if ($index[\"type\"] == \"FULLTEXT\") {\n";
echo "echo \"(<i>\" . implode(\"</i>, <i>\", array_map(\'h\', $index[\"columns\"])) . \"</i>) AGAINST\";\n";
echo "echo \" <input type=\'search\' name=\'fulltext[$i]\' value=\'\" . h($_GET[\"fulltext\"][$i]) . \"\' onchange=\'selectFieldChange(this.form);\'>\";\n";
echo "echo checkbox(\"boolean[$i]\", 1, isset($_GET[\"boolean\"][$i]), \"BOOL\");\n";
echo "echo \"<br>\\n\";\n";
echo "}\n";
echo "}\n";
echo "$_GET[\"where\"] = (array) $_GET[\"where\"];\n";
echo "reset($_GET[\"where\"]);\n";
echo "$change_next = \"this.nextSibling.onchange();\";\n";
echo "for ($i = 0; $i <= count($_GET[\"where\"]); $i++) {\n";
echo "list(, $val) = each($_GET[\"where\"]);\n";
echo "if (!$val || (\"$val[col]$val[val]\" != \"\" && in_array($val[\"op\"], $this->operators))) {\n";
echo "echo \"<div>\" . select_input(\" name=\'where[$i][col]\' onchange=\'$change_next\'\", $columns, $val[\"col\"], \"(\" . lang(\'anywhere\') . \")\");\n";
echo "echo html_select(\"where[$i][op]\", $this->operators, $val[\"op\"], $change_next);\n";
echo "echo \"<input type=\'search\' name=\'where[$i][val]\' value=\'\" . h($val[\"val\"]) . \"\' onchange=\'\" . ($val ? \"selectFieldChange(this.form)\" : \"selectAddRow(this)\") . \";\' onkeydown=\'selectSearchKeydown(this, event);\' onsearch=\'selectSearchSearch(this);\'></div>\\n\";\n";
echo "}\n";
echo "}\n";
echo "echo \"</div></fieldset>\\n\";\n";
echo "}\n";
echo "/** Print order box in select\n";
echo "* @param array result of selectOrderProcess()\n";
echo "* @param array selectable columns\n";
echo "* @param array\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectOrderPrint($order, $columns, $indexes) {\n";
echo "print_fieldset(\"sort\", lang(\'Sort\'), $order);\n";
echo "$i = 0;\n";
echo "foreach ((array) $_GET[\"order\"] as $key => $val) {\n";
echo "if ($val != \"\") {\n";
echo "echo \"<div>\" . select_input(\" name=\'order[$i]\' onchange=\'selectFieldChange(this.form);\'\", $columns, $val);\n";
echo "echo checkbox(\"desc[$i]\", 1, isset($_GET[\"desc\"][$key]), lang(\'descending\')) . \"</div>\\n\";\n";
echo "$i++;\n";
echo "}\n";
echo "}\n";
echo "echo \"<div>\" . select_input(\" name=\'order[$i]\' onchange=\'selectAddRow(this);\'\", $columns);\n";
echo "echo checkbox(\"desc[$i]\", 1, false, lang(\'descending\')) . \"</div>\\n\";\n";
echo "echo \"</div></fieldset>\\n\";\n";
echo "}\n";
echo "/** Print limit box in select\n";
echo "* @param string result of selectLimitProcess()\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectLimitPrint($limit) {\n";
echo "echo \"<fieldset><legend>\" . lang(\'Limit\') . \"</legend><div>\"; // <div> for easy styling\n";
echo "echo \"<input type=\'number\' name=\'limit\' class=\'size\' value=\'\" . h($limit) . \"\' onchange=\'selectFieldChange(this.form);\'>\";\n";
echo "echo \"</div></fieldset>\\n\";\n";
echo "}\n";
echo "/** Print text length box in select\n";
echo "* @param string result of selectLengthProcess()\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectLengthPrint($text_length) {\n";
echo "if ($text_length !== null) {\n";
echo "echo \"<fieldset><legend>\" . lang(\'Text length\') . \"</legend><div>\";\n";
echo "echo \"<input type=\'number\' name=\'text_length\' class=\'size\' value=\'\" . h($text_length) . \"\'>\";\n";
echo "echo \"</div></fieldset>\\n\";\n";
echo "}\n";
echo "}\n";
echo "/** Print action box in select\n";
echo "* @param array\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectActionPrint($indexes) {\n";
echo "echo \"<fieldset><legend>\" . lang(\'Action\') . \"</legend><div>\";\n";
echo "echo \"<input type=\'submit\' value=\'\" . lang(\'Select\') . \"\'>\";\n";
echo "echo \" <span id=\'noindex\' title=\'\" . lang(\'Full table scan\') . \"\'></span>\";\n";
echo "echo \"<script type=\'text/javascript\'>\\n\";\n";
echo "echo \"var indexColumns = \";\n";
echo "$columns = array();\n";
echo "foreach ($indexes as $index) {\n";
echo "if ($index[\"type\"] != \"FULLTEXT\") {\n";
echo "$columns[reset($index[\"columns\"])] = 1;\n";
echo "}\n";
echo "}\n";
echo "$columns[\"\"] = 1;\n";
echo "foreach ($columns as $key => $val) {\n";
echo "json_row($key);\n";
echo "}\n";
echo "echo \";\\n\";\n";
echo "echo \"selectFieldChange(document.getElementById(\'form\'));\\n\";\n";
echo "echo \"</script>\\n\";\n";
echo "echo \"</div></fieldset>\\n\";\n";
echo "}\n";
echo "/** Print command box in select\n";
echo "* @return bool whether to print default commands\n";
echo "*/\n";
echo "function selectCommandPrint() {\n";
echo "return !information_schema(DB);\n";
echo "}\n";
echo "/** Print import box in select\n";
echo "* @return bool whether to print default import\n";
echo "*/\n";
echo "function selectImportPrint() {\n";
echo "return !information_schema(DB);\n";
echo "}\n";
echo "/** Print extra text in the end of a select form\n";
echo "* @param array fields holding e-mails\n";
echo "* @param array selectable columns\n";
echo "* @return null\n";
echo "*/\n";
echo "function selectEmailPrint($emailFields, $columns) {\n";
echo "}\n";
echo "/** Process columns box in select\n";
echo "* @param array selectable columns\n";
echo "* @param array\n";
echo "* @return array (array(select_expressions), array(group_expressions))\n";
echo "*/\n";
echo "function selectColumnsProcess($columns, $indexes) {\n";
echo "global $functions, $grouping;\n";
echo "$select = array(); // select expressions, empty for *\n";
echo "$group = array(); // expressions without aggregation - will be used for GROUP BY if an aggregation function is used\n";
echo "foreach ((array) $_GET[\"columns\"] as $key => $val) {\n";
echo "if ($val[\"fun\"] == \"count\" || ($val[\"col\"] != \"\" && (!$val[\"fun\"] || in_array($val[\"fun\"], $functions) || in_array($val[\"fun\"], $grouping)))) {\n";
echo "$select[$key] = apply_sql_function($val[\"fun\"], ($val[\"col\"] != \"\" ? idf_escape($val[\"col\"]) : \"*\"));\n";
echo "if (!in_array($val[\"fun\"], $grouping)) {\n";
echo "$group[] = $select[$key];\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "return array($select, $group);\n";
echo "}\n";
echo "/** Process search box in select\n";
echo "* @param array\n";
echo "* @param array\n";
echo "* @return array expressions to join by AND\n";
echo "*/\n";
echo "function selectSearchProcess($fields, $indexes) {\n";
echo "global $jush;\n";
echo "$return = array();\n";
echo "foreach ($indexes as $i => $index) {\n";
echo "if ($index[\"type\"] == \"FULLTEXT\" && $_GET[\"fulltext\"][$i] != \"\") {\n";
echo "$return[] = \"MATCH (\" . implode(\", \", array_map(\'idf_escape\', $index[\"columns\"])) . \") AGAINST (\" . q($_GET[\"fulltext\"][$i]) . (isset($_GET[\"boolean\"][$i]) ? \" IN BOOLEAN MODE\" : \"\") . \")\";\n";
echo "}\n";
echo "}\n";
echo "foreach ((array) $_GET[\"where\"] as $val) {\n";
echo "if (\"$val[col]$val[val]\" != \"\" && in_array($val[\"op\"], $this->operators)) {\n";
echo "$cond = \" $val[op]\";\n";
echo "if (preg_match(\'~IN$~\', $val[\"op\"])) {\n";
echo "$in = process_length($val[\"val\"]);\n";
echo "$cond .= \" \" . ($in != \"\" ? $in : \"(NULL)\");\n";
echo "} elseif ($val[\"op\"] == \"SQL\") {\n";
echo "$cond = \" $val[val]\"; // SQL injection\n";
echo "} elseif ($val[\"op\"] == \"LIKE %%\") {\n";
echo "$cond = \" LIKE \" . $this->processInput($fields[$val[\"col\"]], \"%$val[val]%\");\n";
echo "} elseif (!preg_match(\'~NULL$~\', $val[\"op\"])) {\n";
echo "$cond .= \" \" . $this->processInput($fields[$val[\"col\"]], $val[\"val\"]);\n";
echo "}\n";
echo "if ($val[\"col\"] != \"\") {\n";
echo "$return[] = idf_escape($val[\"col\"]) . $cond;\n";
echo "} else {\n";
echo "// find anywhere\n";
echo "$cols = array();\n";
echo "foreach ($fields as $name => $field) {\n";
echo "$is_text = preg_match(\'~char|text|enum|set~\', $field[\"type\"]);\n";
echo "if ((is_numeric($val[\"val\"]) || !preg_match(\'~(^|[^o])int|float|double|decimal|bit~\', $field[\"type\"]))\n";
echo "&& (!preg_match(\"~[\\x80-\\xFF]~\", $val[\"val\"]) || $is_text)\n";
echo ") {\n";
echo "$name = idf_escape($name);\n";
echo "$cols[] = ($jush == \"sql\" && $is_text && !preg_match(\'~^utf8~\', $field[\"collation\"]) ? \"CONVERT($name USING utf8)\" : $name);\n";
echo "}\n";
echo "}\n";
echo "$return[] = ($cols ? \"(\" . implode(\"$cond OR \", $cols) . \"$cond)\" : \"0\");\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "return $return;\n";
echo "}\n";
echo "/** Process order box in select\n";
echo "* @param array\n";
echo "* @param array\n";
echo "* @return array expressions to join by comma\n";
echo "*/\n";
echo "function selectOrderProcess($fields, $indexes) {\n";
echo "$return = array();\n";
echo "foreach ((array) $_GET[\"order\"] as $key => $val) {\n";
echo "if ($val != \"\") {\n";
echo "$return[] = (preg_match(\'~^((COUNT\\\\(DISTINCT |[A-Z0-9_]+\\\\()(`(?:[^`]|``)+`|\"(?:[^\"]|\"\")+\")\\\\)|COUNT\\\\(\\\\*\\\\))$~\', $val) ? $val : idf_escape($val)) //! MS SQL uses []\n";
echo ". (isset($_GET[\"desc\"][$key]) ? \" DESC\" : \"\")\n";
echo ";\n";
echo "}\n";
echo "}\n";
echo "return $return;\n";
echo "}\n";
echo "/** Process limit box in select\n";
echo "* @return string expression to use in LIMIT, will be escaped\n";
echo "*/\n";
echo "function selectLimitProcess() {\n";
echo "return (isset($_GET[\"limit\"]) ? $_GET[\"limit\"] : \"50\");\n";
echo "}\n";
echo "/** Process length box in select\n";
echo "* @return string number of characters to shorten texts, will be escaped\n";
echo "*/\n";
echo "function selectLengthProcess() {\n";
echo "return (isset($_GET[\"text_length\"]) ? $_GET[\"text_length\"] : \"100\");\n";
echo "}\n";
echo "/** Process extras in select form\n";
echo "* @param array AND conditions\n";
echo "* @param array\n";
echo "* @return bool true if processed, false to process other parts of form\n";
echo "*/\n";
echo "function selectEmailProcess($where, $foreignKeys) {\n";
echo "return false;\n";
echo "}\n";
echo "/** Build SQL query used in select\n";
echo "* @param array result of selectColumnsProcess()[0]\n";
echo "* @param array result of selectSearchProcess()\n";
echo "* @param array result of selectColumnsProcess()[1]\n";
echo "* @param array result of selectOrderProcess()\n";
echo "* @param int result of selectLimitProcess()\n";
echo "* @param int index of page starting at zero\n";
echo "* @return string empty string to use default query\n";
echo "*/\n";
echo "function selectQueryBuild($select, $where, $group, $order, $limit, $page) {\n";
echo "return \"\";\n";
echo "}\n";
echo "/** Query printed after execution in the message\n";
echo "* @param string executed query\n";
echo "* @param string elapsed time\n";
echo "* @return string\n";
echo "*/\n";
echo "function messageQuery($query, $time) {\n";
echo "global $jush;\n";
echo "restart_session();\n";
echo "$history = &get_session(\"queries\");\n";
echo "$id = \"sql-\" . count($history[$_GET[\"db\"]]);\n";
echo "if (strlen($query) > 1e6) {\n";
echo "$query = preg_replace(\'~[\\x80-\\xFF]+$~\', \'\', substr($query, 0, 1e6)) . \"\\n...\"; // [\\x80-\\xFF] - valid UTF-8, \\n - can end by one-line comment\n";
echo "}\n";
echo "$history[$_GET[\"db\"]][] = array($query, time(), $time); // not DB - $_GET[\"db\"] is changed in database.inc.php //! respect $_GET[\"ns\"]\n";
echo "return \" <span class=\'time\'>\" . @date(\"H:i:s\") . \"</span> <a href=\'#$id\' onclick=\\\"return !toggle(\'$id\');\\\">\" . lang(\'SQL command\') . \"</a>\" // @ - time zone may be not set\n";
echo ". \"<div id=\'$id\' class=\'hidden\'><pre><code class=\'jush-$jush\'>\" . shorten_utf8($query, 1000) . \'</code></pre>\'\n";
echo ". ($time ? \" <span class=\'time\'>($time)</span>\" : \'\')\n";
echo ". (support(\"sql\") ? \'<p><a href=\"\' . h(str_replace(\"db=\" . urlencode(DB), \"db=\" . urlencode($_GET[\"db\"]), ME) . \'sql=&history=\' . (count($history[$_GET[\"db\"]]) - 1)) . \'\">\' . lang(\'Edit\') . \'</a>\' : \'\')\n";
echo ". \'</div>\'\n";
echo ";\n";
echo "}\n";
echo "/** Functions displayed in edit form\n";
echo "* @param array single field from fields()\n";
echo "* @return array\n";
echo "*/\n";
echo "function editFunctions($field) {\n";
echo "global $edit_functions;\n";
echo "$return = ($field[\"null\"] ? \"NULL/\" : \"\");\n";
echo "foreach ($edit_functions as $key => $functions) {\n";
echo "if (!$key || (!isset($_GET[\"call\"]) && (isset($_GET[\"select\"]) || where($_GET)))) { // relative functions\n";
echo "foreach ($functions as $pattern => $val) {\n";
echo "if (!$pattern || preg_match(\"~$pattern~\", $field[\"type\"])) {\n";
echo "$return .= \"/$val\";\n";
echo "}\n";
echo "}\n";
echo "if ($key && !preg_match(\'~set|blob|bytea|raw|file~\', $field[\"type\"])) {\n";
echo "$return .= \"/SQL\";\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "if ($field[\"auto_increment\"] && !isset($_GET[\"select\"]) && !where($_GET)) {\n";
echo "$return = lang(\'Auto Increment\');\n";
echo "}\n";
echo "return explode(\"/\", $return);\n";
echo "}\n";
echo "/** Get options to display edit field\n";
echo "* @param string table name\n";
echo "* @param array single field from fields()\n";
echo "* @param string attributes to use inside the tag\n";
echo "* @param string\n";
echo "* @return string custom input field or empty string for default\n";
echo "*/\n";
echo "function editInput($table, $field, $attrs, $value) {\n";
echo "if ($field[\"type\"] == \"enum\") {\n";
echo "return (isset($_GET[\"select\"]) ? \"<label><input type=\'radio\'$attrs value=\'-1\' checked><i>\" . lang(\'original\') . \"</i></label> \" : \"\")\n";
echo ". ($field[\"null\"] ? \"<label><input type=\'radio\'$attrs value=\'\'\" . ($value !== null || isset($_GET[\"select\"]) ? \"\" : \" checked\") . \"><i>NULL</i></label> \" : \"\")\n";
echo ". enum_input(\"radio\", $attrs, $field, $value, 0) // 0 - empty\n";
echo ";\n";
echo "}\n";
echo "return \"\";\n";
echo "}\n";
echo "/** Process sent input\n";
echo "* @param array single field from fields()\n";
echo "* @param string\n";
echo "* @param string\n";
echo "* @return string expression to use in a query\n";
echo "*/\n";
echo "function processInput($field, $value, $function = \"\") {\n";
echo "if ($function == \"SQL\") {\n";
echo "return $value; // SQL injection\n";
echo "}\n";
echo "$name = $field[\"field\"];\n";
echo "$return = q($value);\n";
echo "if (preg_match(\'~^(now|getdate|uuid)$~\', $function)) {\n";
echo "$return = \"$function()\";\n";
echo "} elseif (preg_match(\'~^current_(date|timestamp)$~\', $function)) {\n";
echo "$return = $function;\n";
echo "} elseif (preg_match(\'~^([+-]|\\\\|\\\\|)$~\', $function)) {\n";
echo "$return = idf_escape($name) . \" $function $return\";\n";
echo "} elseif (preg_match(\'~^[+-] interval$~\', $function)) {\n";
echo "$return = idf_escape($name) . \" $function \" . (preg_match(\"~^(\\\\d+|\'[0-9.: -]\') [A-Z_]+$~i\", $value) ? $value : $return);\n";
echo "} elseif (preg_match(\'~^(addtime|subtime|concat)$~\', $function)) {\n";
echo "$return = \"$function(\" . idf_escape($name) . \", $return)\";\n";
echo "} elseif (preg_match(\'~^(md5|sha1|password|encrypt)$~\', $function)) {\n";
echo "$return = \"$function($return)\";\n";
echo "}\n";
echo "return unconvert_field($field, $return);\n";
echo "}\n";
echo "/** Returns export output options\n";
echo "* @return array\n";
echo "*/\n";
echo "function dumpOutput() {\n";
echo "$return = array(\'text\' => lang(\'open\'), \'file\' => lang(\'save\'));\n";
echo "if (function_exists(\'gzencode\')) {\n";
echo "$return[\'gz\'] = \'gzip\';\n";
echo "}\n";
echo "return $return;\n";
echo "}\n";
echo "/** Returns export format options\n";
echo "* @return array empty to disable export\n";
echo "*/\n";
echo "function dumpFormat() {\n";
echo "return array(\'sql\' => \'SQL\', \'csv\' => \'CSV,\', \'csv;\' => \'CSV;\', \'tsv\' => \'TSV\');\n";
echo "}\n";
echo "/** Export database structure\n";
echo "* @param string\n";
echo "* @return null prints data\n";
echo "*/\n";
echo "function dumpDatabase($db) {\n";
echo "}\n";
echo "/** Export table structure\n";
echo "* @param string\n";
echo "* @param string\n";
echo "* @param int 0 table, 1 view, 2 temporary view table\n";
echo "* @return null prints data\n";
echo "*/\n";
echo "function dumpTable($table, $style, $is_view = 0) {\n";
echo "if ($_POST[\"format\"] != \"sql\") {\n";
echo "echo \"\\xef\\xbb\\xbf\"; // UTF-8 byte order mark\n";
echo "if ($style) {\n";
echo "dump_csv(array_keys(fields($table)));\n";
echo "}\n";
echo "} elseif ($style) {\n";
echo "if ($is_view == 2) {\n";
echo "$fields = array();\n";
echo "foreach (fields($table) as $name => $field) {\n";
echo "$fields[] = idf_escape($name) . \" $field[full_type]\";\n";
echo "}\n";
echo "$create = \"CREATE TABLE \" . table($table) . \" (\" . implode(\", \", $fields) . \")\";\n";
echo "} else {\n";
echo "$create = create_sql($table, $_POST[\"auto_increment\"]);\n";
echo "}\n";
echo "if ($create) {\n";
echo "if ($style == \"DROP+CREATE\" || $is_view == 1) {\n";
echo "echo \"DROP \" . ($is_view == 2 ? \"VIEW\" : \"TABLE\") . \" IF EXISTS \" . table($table) . \";\\n\";\n";
echo "}\n";
echo "if ($is_view == 1) {\n";
echo "$create = remove_definer($create);\n";
echo "}\n";
echo "echo \"$create;\\n\\n\";\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "/** Export table data\n";
echo "* @param string\n";
echo "* @param string\n";
echo "* @param string\n";
echo "* @return null prints data\n";
echo "*/\n";
echo "function dumpData($table, $style, $query) {\n";
echo "global $connection, $jush;\n";
echo "$max_packet = ($jush == \"sqlite\" ? 0 : 1048576); // default, minimum is 1024\n";
echo "if ($style) {\n";
echo "if ($_POST[\"format\"] == \"sql\") {\n";
echo "if ($style == \"TRUNCATE+INSERT\") {\n";
echo "echo truncate_sql($table) . \";\\n\";\n";
echo "}\n";
echo "$fields = fields($table);\n";
echo "}\n";
echo "$result = $connection->query($query, 1); // 1 - MYSQLI_USE_RESULT //! enum and set as numbers\n";
echo "if ($result) {\n";
echo "$insert = \"\";\n";
echo "$buffer = \"\";\n";
echo "$keys = array();\n";
echo "$suffix = \"\";\n";
echo "$fetch_function = ($table != \'\' ? \'fetch_assoc\' : \'fetch_row\');\n";
echo "while ($row = $result->$fetch_function()) {\n";
echo "if (!$keys) {\n";
echo "$values = array();\n";
echo "foreach ($row as $val) {\n";
echo "$field = $result->fetch_field();\n";
echo "$keys[] = $field->name;\n";
echo "$key = idf_escape($field->name);\n";
echo "$values[] = \"$key = VALUES($key)\";\n";
echo "}\n";
echo "$suffix = ($style == \"INSERT+UPDATE\" ? \"\\nON DUPLICATE KEY UPDATE \" . implode(\", \", $values) : \"\") . \";\\n\";\n";
echo "}\n";
echo "if ($_POST[\"format\"] != \"sql\") {\n";
echo "if ($style == \"table\") {\n";
echo "dump_csv($keys);\n";
echo "$style = \"INSERT\";\n";
echo "}\n";
echo "dump_csv($row);\n";
echo "} else {\n";
echo "if (!$insert) {\n";
echo "$insert = \"INSERT INTO \" . table($table) . \" (\" . implode(\", \", array_map(\'idf_escape\', $keys)) . \") VALUES\";\n";
echo "}\n";
echo "foreach ($row as $key => $val) {\n";
echo "$field = $fields[$key];\n";
echo "$row[$key] = ($val !== null\n";
echo "? unconvert_field($field, preg_match(\'~(^|[^o])int|float|double|decimal~\', $field[\"type\"]) && $val != \'\' ? $val : q($val))\n";
echo ": \"NULL\"\n";
echo ");\n";
echo "}\n";
echo "$s = ($max_packet ? \"\\n\" : \" \") . \"(\" . implode(\",\\t\", $row) . \")\";\n";
echo "if (!$buffer) {\n";
echo "$buffer = $insert . $s;\n";
echo "} elseif (strlen($buffer) + 4 + strlen($s) + strlen($suffix) < $max_packet) { // 4 - length specification\n";
echo "$buffer .= \",$s\";\n";
echo "} else {\n";
echo "echo $buffer . $suffix;\n";
echo "$buffer = $insert . $s;\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "if ($buffer) {\n";
echo "echo $buffer . $suffix;\n";
echo "}\n";
echo "} elseif ($_POST[\"format\"] == \"sql\") {\n";
echo "echo \"-- \" . str_replace(\"\\n\", \" \", $connection->error) . \"\\n\";\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "/** Set export filename\n";
echo "* @param string\n";
echo "* @return string filename without extension\n";
echo "*/\n";
echo "function dumpFilename($identifier) {\n";
echo "return friendly_url($identifier != \"\" ? $identifier : (SERVER != \"\" ? SERVER : \"localhost\"));\n";
echo "}\n";
echo "/** Send headers for export\n";
echo "* @param string\n";
echo "* @param bool\n";
echo "* @return string extension\n";
echo "*/\n";
echo "function dumpHeaders($identifier, $multi_table = false) {\n";
echo "$output = $_POST[\"output\"];\n";
echo "$ext = (preg_match(\'~sql~\', $_POST[\"format\"]) ? \"sql\" : ($multi_table ? \"tar\" : \"csv\")); // multiple CSV packed to TAR\n";
echo "header(\"Content-Type: \" .\n";
echo "($output == \"gz\" ? \"application/x-gzip\" :\n";
echo "($ext == \"tar\" ? \"application/x-tar\" :\n";
echo "($ext == \"sql\" || $output != \"file\" ? \"text/plain\" : \"text/csv\") . \"; charset=utf-8\"\n";
echo ")));\n";
echo "if ($output == \"gz\") {\n";
echo "ob_start(\'ob_gzencode\', 1e6);\n";
echo "}\n";
echo "return $ext;\n";
echo "}\n";
echo "/** Print homepage\n";
echo "* @return bool whether to print default homepage\n";
echo "*/\n";
echo "function homepage() {\n";
echo "echo \'<p class=\"links\">\' . ($_GET[\"ns\"] == \"\" && support(\"database\") ? \'<a href=\"\' . h(ME) . \'database=\">\' . lang(\'Alter database\') . \"</a>\\n\" : \"\");\n";
echo "echo (support(\"scheme\") ? \"<a href=\'\" . h(ME) . \"scheme=\'>\" . ($_GET[\"ns\"] != \"\" ? lang(\'Alter schema\') : lang(\'Create schema\')) . \"</a>\\n\" : \"\");\n";
echo "echo ($_GET[\"ns\"] !== \"\" ? \'<a href=\"\' . h(ME) . \'schema=\">\' . lang(\'Database schema\') . \"</a>\\n\" : \"\");\n";
echo "echo (support(\"privileges\") ? \"<a href=\'\" . h(ME) . \"privileges=\'>\" . lang(\'Privileges\') . \"</a>\\n\" : \"\");\n";
echo "return true;\n";
echo "}\n";
echo "/** Prints navigation after Adminer title\n";
echo "* @param string can be \"auth\" if there is no database connection, \"db\" if there is no database selected, \"ns\" with invalid schema\n";
echo "* @return null\n";
echo "*/\n";
echo "function navigation($missing) {\n";
echo "global $VERSION, $jush, $drivers, $connection;\n";
echo "?>\n";
echo "<h1>\n";
echo "<?php echo $this->name(); ?> <span class=\"version\"><?php echo $VERSION; ?></span>\n";
echo "<a href=\"http://www.adminer.org/#download\" target=\"_blank\" id=\"version\"><?php echo (version_compare($VERSION, $_COOKIE[\"adminer_version\"]) < 0 ? h($_COOKIE[\"adminer_version\"]) : \"\"); ?></a>\n";
echo "</h1>\n";
echo "<?php\n";
echo "if ($missing == \"auth\") {\n";
echo "$first = true;\n";
echo "foreach ((array) $_SESSION[\"pwds\"] as $vendor => $servers) {\n";
echo "foreach ($servers as $server => $usernames) {\n";
echo "foreach ($usernames as $username => $password) {\n";
echo "if ($password !== null) {\n";
echo "if ($first) {\n";
echo "echo \"<p id=\'logins\' onmouseover=\'menuOver(this, event);\' onmouseout=\'menuOut(this);\'>\\n\";\n";
echo "$first = false;\n";
echo "}\n";
echo "$dbs = $_SESSION[\"db\"][$vendor][$server][$username];\n";
echo "foreach (($dbs ? array_keys($dbs) : array(\"\")) as $db) {\n";
echo "echo \"<a href=\'\" . h(auth_url($vendor, $server, $username, $db)) . \"\'>($drivers[$vendor]) \" . h($username . ($server != \"\" ? \"@$server\" : \"\") . ($db != \"\" ? \" - $db\" : \"\")) . \"</a><br>\\n\";\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "} else {\n";
echo "if ($_GET[\"ns\"] !== \"\" && !$missing && DB != \"\") {\n";
echo "$connection->select_db(DB);\n";
echo "$tables = table_status(\'\', true);\n";
echo "}\n";
echo "if (support(\"sql\")) {\n";
echo "?>\n";
echo "<script type=\"text/javascript\" src=\"../externals/jush/modules/jush.js\"></script>\n";
echo "<script type=\"text/javascript\" src=\"../externals/jush/modules/jush-textarea.js\"></script>\n";
echo "<script type=\"text/javascript\" src=\"../externals/jush/modules/jush-txt.js\"></script>\n";
echo "<script type=\"text/javascript\" src=\"../externals/jush/modules/jush-null\"><?php echo $jush; ?>.js\"></script>\n";
echo "<script type=\"text/javascript\">\n";
echo "<?php\n";
echo "if ($tables) {\n";
echo "$links = array();\n";
echo "foreach ($tables as $table => $type) {\n";
echo "$links[] = preg_quote($table, \'/\');\n";
echo "}\n";
echo "echo \"var jushLinks = { $jush: [ \'\" . js_escape(ME) . (support(\"table\") ? \"table=\" : \"select=\") . \"\\$&\', /\\\\b(\" . implode(\"|\", $links) . \")\\\\b/g ] };\\n\";\n";
echo "foreach (array(\"bac\", \"bra\", \"sqlite_quo\", \"mssql_bra\") as $val) {\n";
echo "echo \"jushLinks.$val = jushLinks.$jush;\\n\";\n";
echo "}\n";
echo "}\n";
echo "?>\n";
echo "bodyLoad(\'<?php echo (is_object($connection) ? substr($connection->server_info, 0, 3) : \"\"); ?>\');\n";
echo "</script>\n";
echo "<?php\n";
echo "}\n";
echo "$this->databasesPrint($missing);\n";
echo "if (DB == \"\" || !$missing) {\n";
echo "echo \"<p class=\'links\'>\" . (support(\"sql\") ? \"<a href=\'\" . h(ME) . \"sql=\'\" . bold(isset($_GET[\"sql\"]) && !isset($_GET[\"import\"])) . \">\" . lang(\'SQL command\') . \"</a>\\n<a href=\'\" . h(ME) . \"import=\'\" . bold(isset($_GET[\"import\"])) . \">\" . lang(\'Import\') . \"</a>\\n\" : \"\") . \"\";\n";
echo "if (support(\"dump\")) {\n";
echo "echo \"<a href=\'\" . h(ME) . \"dump=\" . urlencode(isset($_GET[\"table\"]) ? $_GET[\"table\"] : $_GET[\"select\"]) . \"\' id=\'dump\'\" . bold(isset($_GET[\"dump\"])) . \">\" . lang(\'Dump\') . \"</a>\\n\";\n";
echo "}\n";
echo "}\n";
echo "if ($_GET[\"ns\"] !== \"\" && !$missing && DB != \"\") {\n";
echo "echo \'<a href=\"\' . h(ME) . \'create=\"\' . bold($_GET[\"create\"] === \"\") . \">\" . lang(\'Create table\') . \"</a>\\n\";\n";
echo "if (!$tables) {\n";
echo "echo \"<p class=\'message\'>\" . lang(\'No tables.\') . \"\\n\";\n";
echo "} else {\n";
echo "$this->tablesPrint($tables);\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "/** Prints databases list in menu\n";
echo "* @param string\n";
echo "* @return null\n";
echo "*/\n";
echo "function databasesPrint($missing) {\n";
echo "global $adminer, $connection;\n";
echo "$databases = $this->databases();\n";
echo "?>\n";
echo "<form action=\"\">\n";
echo "<p id=\"dbs\">\n";
echo "<?php\n";
echo "hidden_fields_get();\n";
echo "$db_events = \" onmousedown=\'dbMouseDown(event, this);\' onchange=\'dbChange(this);\'\";\n";
echo "echo \"<span title=\'\" . lang(\'database\') . \"\'>DB</span>: \" . ($databases\n";
echo "? \"<select name=\'db\'$db_events>\" . optionlist(array(\"\" => \"\") + $databases, DB) . \"</select>\"\n";
echo ": \'<input name=\"db\" value=\"\' . h(DB) . \'\" autocapitalize=\"off\">\'\n";
echo ");\n";
echo "echo \"<input type=\'submit\' value=\'\" . lang(\'Use\') . \"\'\" . ($databases ? \" class=\'hidden\'\" : \"\") . \">\\n\";\n";
echo "if ($missing != \"db\" && DB != \"\" && $connection->select_db(DB)) {\n";
echo "if (support(\"scheme\")) {\n";
echo "echo \"<br>\" . lang(\'Schema\') . \": <select name=\'ns\'$db_events>\" . optionlist(array(\"\" => \"\") + $adminer->schemas(), $_GET[\"ns\"]) . \"</select>\";\n";
echo "if ($_GET[\"ns\"] != \"\") {\n";
echo "set_schema($_GET[\"ns\"]);\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "echo (isset($_GET[\"sql\"]) ? \'<input type=\"hidden\" name=\"sql\" value=\"\">\'\n";
echo ": (isset($_GET[\"schema\"]) ? \'<input type=\"hidden\" name=\"schema\" value=\"\">\'\n";
echo ": (isset($_GET[\"dump\"]) ? \'<input type=\"hidden\" name=\"dump\" value=\"\">\'\n";
echo ": (isset($_GET[\"privileges\"]) ? \'<input type=\"hidden\" name=\"privileges\" value=\"\">\'\n";
echo ": \"\"))));\n";
echo "echo \"</p></form>\\n\";\n";
echo "}\n";
echo "/** Prints table list in menu\n";
echo "* @param array result of table_status(\'\', true)\n";
echo "* @return null\n";
echo "*/\n";
echo "function tablesPrint($tables) {\n";
echo "echo \"<p id=\'tables\' onmouseover=\'menuOver(this, event);\' onmouseout=\'menuOut(this);\'>\\n\";\n";
echo "foreach ($tables as $table => $status) {\n";
echo "echo \'<a href=\"\' . h(ME) . \'select=\' . urlencode($table) . \'\"\' . bold($_GET[\"select\"] == $table || $_GET[\"edit\"] == $table) . \">\" . lang(\'select\') . \"</a> \";\n";
echo "$name = $this->tableName($status);\n";
echo "echo (support(\"table\") || support(\"indexes\")\n";
echo "? \'<a href=\"\' . h(ME) . \'table=\' . urlencode($table) . \'\"\' . bold(in_array($table, array($_GET[\"table\"], $_GET[\"create\"], $_GET[\"indexes\"], $_GET[\"foreign\"], $_GET[\"trigger\"])), (is_view($status) ? \"view\" : \"\")) . \" title=\'\" . lang(\'Show structure\') . \"\'>$name</a>\"\n";
echo ": \"<span>$name</span>\"\n";
echo ") . \"<br>\\n\";\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "$adminer = (function_exists(\'adminer_object\') ? adminer_object() : new Adminer);\n";
echo "if ($adminer->operators === null) {\n";
echo "$adminer->operators = $operators;\n";
echo "}\n";
echo "<div class=\'body-fauxcolumns\'>\n";
echo "<div class=\'fauxcolumn-outer body-fauxcolumn-outer\'>\n";
echo "<div class=\'cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right\'/>\n";
echo "<div class=\'fauxcolumn-inner\'>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'content\'>\n";
echo "<div class=\'content-fauxcolumns\'>\n";
echo "<div class=\'fauxcolumn-outer content-fauxcolumn-outer\'>\n";
echo "<div class=\'cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right\'/>\n";
echo "<div class=\'fauxcolumn-inner\'>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'content-outer\'>\n";
echo "<div class=\'content-cap-top cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left content-fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right content-fauxborder-right\'/>\n";
echo "<div class=\'content-inner\'>\n";
echo "<header>\n";
echo "<div class=\'header-outer\'>\n";
echo "<div class=\'header-cap-top cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left header-fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right header-fauxborder-right\'/>\n";
echo "<div class=\'region-inner header-inner\'>\n";
echo "<b:section class=\'header\' id=\'header\' maxwidgets=\'1\' showaddelement=\'no\'>\n";
echo "<b:widget id=\'Header1\' locked=\'true\' title=\'Snap PhotoFrame (Header)\' type=\'Header\'>\n";
echo "<b:includable id=\'main\'>\n";
echo "<b:if cond=\'data:useImage\'>\n";
echo "<b:if cond=\'data:imagePlacement == &quot;BEHIND&quot;\'>\n";
echo "<!--\n";
echo "Show image as background to text. You can\'t really calculate the width\n";
echo "reliably in JS because margins are not taken into account by any of\n";
echo "clientWidth, offsetWidth or scrollWidth, so we don\'t force a minimum\n";
echo "width if the user is using shrink to fit.\n";
echo "This results in a margin-width\'s worth of pixels being cropped. If the\n";
echo "user is not using shrink to fit then we expand the header.\n";
echo "-->\n";
echo "<b:if cond=\'data:mobile\'>\n";
echo "<div id=\'header-inner\'>\n";
echo "<div class=\'titlewrapper\' style=\'background: transparent\'>\n";
echo "<h1 class=\'title\' style=\'background: transparent; border-width: 0px\'>\n";
echo "<b:include name=\'title\'/>\n";
echo "</h1>\n";
echo "</div>\n";
echo "<b:include name=\'description\'/>\n";
echo "</div>\n";
echo "<b:else/>\n";
echo "<div expr:style=\'&quot;background-image: url(\\&quot;&quot; + data:sourceUrl + &quot;\\&quot;); &quot; + &quot;background-position: &quot; + data:backgroundPositionStyleStr + &quot;; &quot; + data:widthStyleStr + &quot;min-height: &quot; + data:height + &quot;_height: &quot; + data:height + &quot;background-repeat: no-repeat; &quot;\' id=\'header-inner\'>\n";
echo "<div class=\'titlewrapper\' style=\'background: transparent\'>\n";
echo "<h1 class=\'title\' style=\'background: transparent; border-width: 0px\'>\n";
echo "<b:include name=\'title\'/>\n";
echo "</h1>\n";
echo "</div>\n";
echo "<b:include name=\'description\'/>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<!--Show the image only-->\n";
echo "<div id=\'header-inner\'>\n";
echo "<a expr:href=\'data:blog.homepageUrl\' style=\'display: block\'>\n";
echo "<img expr:alt=\'data:title\' expr:height=\'data:height\' expr:id=\'data:widget.instanceId + &quot;_headerimg&quot;\' expr:src=\'data:sourceUrl\' expr:width=\'data:width\' style=\'display: block\'/>\n";
echo "</a>\n";
echo "<!--Show the description-->\n";
echo "<b:if cond=\'data:imagePlacement == &quot;BEFORE_DESCRIPTION&quot;\'>\n";
echo "<b:include name=\'description\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<!--No header image -->\n";
echo "<div id=\'header-inner\'>\n";
echo "<div class=\'titlewrapper\'>\n";
echo "<h1 class=\'title\'>\n";
echo "<b:include name=\'title\'/>\n";
echo "</h1>\n";
echo "</div>\n";
echo "<b:include name=\'description\'/>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'description\'>\n";
echo "<div class=\'descriptionwrapper\'>\n";
echo "<p class=\'description\'>\n";
echo "<span>\n";
echo "<data:description/>\n";
echo "</span>\n";
echo "</p>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'title\'>\n";
echo "<b:if cond=\'data:blog.url == data:blog.homepageUrl\'>\n";
echo "<data:title/>\n";
echo "<b:else/>\n";
echo "<a expr:href=\'data:blog.homepageUrl\'>\n";
echo "<data:title/>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'header-cap-bottom cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</header>\n";
echo "<div class=\'tabs-outer\'>\n";
echo "<div class=\'tabs-cap-top cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left tabs-fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right tabs-fauxborder-right\'/>\n";
echo "<div class=\'region-inner tabs-inner\'>\n";
echo "<b:section class=\'tabs\' id=\'crosscol\' maxwidgets=\'1\' showaddelement=\'yes\'>\n";
echo "<b:widget id=\'Gadget1\' locked=\'false\' title=\'Sign In Snap PhotoFrame\' type=\'Gadget\'>\n";
echo "<b:includable id=\'main\'>\n";
echo "<!-- only display title if it\'s non-empty -->\n";
echo "<b:if cond=\'data:renderingUrl != &quot;&quot;\'>\n";
echo "<b:if cond=\'data:title != &quot;&quot;\'>\n";
echo "<h2 class=\'title\'>\n";
echo "<data:title/>\n";
echo "</h2>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:gadgetSnippet != &quot;&quot;\'>\n";
echo "<data:gadgetSnippet/>\n";
echo "<b:else/>\n";
echo "<div class=\'widget-content\'>\n";
echo "<b:if cond=\'data:nonSocialFragment != &quot;&quot;\'>\n";
echo "<data:nonSocialFragment/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<data:errorMessage/>\n";
echo "</b:if>\n";
echo "<b:include name=\'quickedit\'/>\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section>\n";
echo "<b:section class=\'tabs\' id=\'crosscol-overflow\' showaddelement=\'no\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'tabs-cap-bottom cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'main-outer\'>\n";
echo "<div class=\'main-cap-top cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left main-fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right main-fauxborder-right\'/>\n";
echo "<div class=\'region-inner main-inner\'>\n";
echo "<div class=\'columns fauxcolumns\'>\n";
echo "<div class=\'fauxcolumn-outer fauxcolumn-center-outer\'>\n";
echo "<div class=\'cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right\'/>\n";
echo "<div class=\'fauxcolumn-inner\'>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'fauxcolumn-outer fauxcolumn-left-outer\'>\n";
echo "<div class=\'cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right\'/>\n";
echo "<div class=\'fauxcolumn-inner\'>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'fauxcolumn-outer fauxcolumn-right-outer\'>\n";
echo "<div class=\'cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right\'/>\n";
echo "<div class=\'fauxcolumn-inner\'>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<!-- corrects IE6 width calculation -->\n";
echo "<div class=\'columns-inner\'>\n";
echo "<div class=\'column-center-outer\'>\n";
echo "<div class=\'column-center-inner\'>\n";
echo "<b:section class=\'main\' id=\'main\' showaddelement=\'no\'>\n";
echo "<b:widget id=\'Blog1\' locked=\'true\' title=\'Blog Posts\' type=\'Blog\'>\n";
echo "<b:includable id=\'main\' var=\'top\'>\n";
echo "<b:if cond=\'data:mobile == &quot;false&quot;\'>\n";
echo "<!-- posts -->\n";
echo "<div class=\'blog-posts hfeed\'>\n";
echo "<b:include data=\'top\' name=\'status-message\'/>\n";
echo "<data:defaultAdStart/>\n";
echo "<b:loop values=\'data:posts\' var=\'post\'>\n";
echo "<b:if cond=\'data:post.isDateStart\'>\n";
echo "<b:if cond=\'data:post.isFirstPost == &quot;false&quot;\'>\n";
echo "&lt;/div&gt;&lt;/div&gt;\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:post.isDateStart\'>\n";
echo "&lt;div class=&quot;date-outer&quot;&gt;\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:post.dateHeader\'>\n";
echo "<h2 class=\'date-header\'>\n";
echo "<span>\n";
echo "<data:post.dateHeader/>\n";
echo "</span>\n";
echo "</h2>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:post.isDateStart\'>\n";
echo "&lt;div class=&quot;date-posts&quot;&gt;\n";
echo "</b:if>\n";
echo "<div class=\'post-outer\'>\n";
echo "<b:include data=\'post\' name=\'post\'/>\n";
echo "<b:if cond=\'data:blog.pageType == &quot;static_page&quot;\'>\n";
echo "<b:include data=\'post\' name=\'comment_picker\'/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:blog.pageType == &quot;item&quot;\'>\n";
echo "<b:include data=\'post\' name=\'comment_picker\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "<b:if cond=\'data:post.includeAd\'>\n";
echo "<b:if cond=\'data:post.isFirstPost\'>\n";
echo "<data:defaultAdEnd/>\n";
echo "<b:else/>\n";
echo "<data:adEnd/>\n";
echo "</b:if>\n";
echo "<div class=\'inline-ad\'>\n";
echo "<data:adCode/>\n";
echo "</div>\n";
echo "<data:adStart/>\n";
echo "</b:if>\n";
echo "</b:loop>\n";
echo "<b:if cond=\'data:numPosts != 0\'>\n";
echo "&lt;/div&gt;&lt;/div&gt;\n";
echo "</b:if>\n";
echo "<data:adEnd/>\n";
echo "</div>\n";
echo "<!-- navigation -->\n";
echo "<b:include name=\'nextprev\'/>\n";
echo "<!-- feed links -->\n";
echo "<b:include name=\'feedLinks\'/>\n";
echo "<b:else/>\n";
echo "<b:include name=\'mobile-main\'/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showDummy\'>\n";
echo "<data:top.dummyBootstrap/>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'backlinkDeleteIcon\' var=\'backlink\'>\n";
echo "<span expr:class=\'&quot;item-control &quot; + data:backlink.adminClass\'>\n";
echo "<a expr:href=\'data:backlink.deleteUrl\' expr:title=\'data:top.deleteBacklinkMsg\'>\n";
echo "<img src=\'//www.blogger.com/img/icon_delete13.gif\'/>\n";
echo "</a>\n";
echo "</span>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'backlinks\' var=\'post\'>\n";
echo "<a name=\'links\'/>\n";
echo "<h4>\n";
echo "<data:post.backlinksLabel/>\n";
echo "</h4>\n";
echo "<b:if cond=\'data:post.numBacklinks != 0\'>\n";
echo "<dl class=\'comments-block\' id=\'comments-block\'>\n";
echo "<b:loop values=\'data:post.backlinks\' var=\'backlink\'>\n";
echo "<div class=\'collapsed-backlink backlink-control\'>\n";
echo "<dt class=\'comment-title\'>\n";
echo "<span class=\'backlink-toggle-zippy\'>\n";
echo "&#160;\n";
echo "</span>\n";
echo "<a expr:href=\'data:backlink.url\' rel=\'nofollow\'>\n";
echo "<data:backlink.title/>\n";
echo "</a>\n";
echo "<b:include data=\'backlink\' name=\'backlinkDeleteIcon\'/>\n";
echo "</dt>\n";
echo "<dd class=\'comment-body collapseable\'>\n";
echo "<data:backlink.snippet/>\n";
echo "</dd>\n";
echo "<dd class=\'comment-footer collapseable\'>\n";
echo "<span class=\'comment-author\'>\n";
echo "<data:post.authorLabel/>\n";
echo "<data:backlink.author/>\n";
echo "</span>\n";
echo "<span class=\'comment-timestamp\'>\n";
echo "<data:post.timestampLabel/>\n";
echo "<data:backlink.timestamp/>\n";
echo "</span>\n";
echo "</dd>\n";
echo "</div>\n";
echo "</b:loop>\n";
echo "</dl>\n";
echo "</b:if>\n";
echo "<p class=\'comment-footer\'>\n";
echo "<a class=\'comment-link\' expr:href=\'data:post.createLinkUrl\' expr:id=\'data:widget.instanceId + &quot;_backlinks-create-link&quot;\' target=\'_blank\'>\n";
echo "<data:post.createLinkLabel/>\n";
echo "</a>\n";
echo "</p>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'comment-form\' var=\'post\'>\n";
echo "<div class=\'comment-form\'>\n";
echo "<a name=\'comment-form\'/>\n";
echo "<b:if cond=\'data:mobile\'>\n";
echo "<h4 id=\'comment-post-message\'>\n";
echo "<a expr:id=\'data:widget.instanceId + &quot;_comment-editor-toggle-link&quot;\' href=\'javascript:void(0)\'>\n";
echo "<data:postCommentMsg/>\n";
echo "</a>\n";
echo "</h4>\n";
echo "<p>\n";
echo "<data:blogCommentMessage/>\n";
echo "</p>\n";
echo "<data:blogTeamBlogMessage/>\n";
echo "<a expr:href=\'data:post.commentFormIframeSrc\' id=\'comment-editor-src\'/>\n";
echo "<iframe allowtransparency=\'true\' class=\'blogger-iframe-colorize blogger-comment-from-post\' frameborder=\'0\' height=\'410\' id=\'comment-editor\' name=\'comment-editor\' src=\'\' style=\'display: none\' width=\'100%\'/>\n";
echo "<b:else/>\n";
echo "<h4 id=\'comment-post-message\'>\n";
echo "<data:postCommentMsg/>\n";
echo "</h4>\n";
echo "<p>\n";
echo "<data:blogCommentMessage/>\n";
echo "</p>\n";
echo "<data:blogTeamBlogMessage/>\n";
echo "<a expr:href=\'data:post.commentFormIframeSrc\' id=\'comment-editor-src\'/>\n";
echo "<iframe allowtransparency=\'true\' class=\'blogger-iframe-colorize blogger-comment-from-post\' frameborder=\'0\' height=\'410\' id=\'comment-editor\' name=\'comment-editor\' src=\'\' width=\'100%\'/>\n";
echo "</b:if>\n";
echo "<data:post.friendConnectJs/>\n";
echo "<data:post.cmtfpIframe/>\n";
echo "<script type=\'text/javascript\'>\n";
echo "BLOG_CMT_createIframe(&#39;<data:post.appRpcRelayPath/>&#39;);\n";
echo "</script>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'commentDeleteIcon\' var=\'comment\'>\n";
echo "<span expr:class=\'&quot;item-control &quot; + data:comment.adminClass\'>\n";
echo "<b:if cond=\'data:showCmtPopup\'>\n";
echo "<div class=\'goog-toggle-button\'>\n";
echo "<div class=\'goog-inline-block comment-action-icon\'/>\n";
echo "</div>\n";
echo "<b:else/>\n";
echo "<a class=\'comment-delete\' expr:href=\'data:comment.deleteUrl\' expr:title=\'data:top.deleteCommentMsg\'>\n";
echo "<img src=\'//www.blogger.com/img/icon_delete13.gif\'/>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'comment_count_picker\' var=\'post\'>\n";
echo "<b:if cond=\'data:post.commentSource == 1\'>\n";
echo "<span class=\'cmt_count_iframe_holder\' expr:data-count=\'data:post.numComments\' expr:data-onclick=\'data:post.addCommentOnclick\' expr:data-post-url=\'data:post.url\' expr:data-url=\'data:post.canonicalUrl\'>\n";
echo "</span>\n";
echo "<b:else/>\n";
echo "<a class=\'comment-link\' expr:href=\'data:post.addCommentUrl\' expr:onclick=\'data:post.addCommentOnclick\'>\n";
echo "<data:post.commentLabelFull/>\n";
echo ":\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'comment_picker\' var=\'post\'>\n";
echo "<b:if cond=\'data:post.commentSource == 1\'>\n";
echo "<b:include data=\'post\' name=\'iframe_comments\'/>\n";
echo "<b:else/>\n";
echo "<b:if cond=\'data:post.showThreadedComments\'>\n";
echo "<b:include data=\'post\' name=\'threaded_comments\'/>\n";
echo "<b:else/>\n";
echo "<b:include data=\'post\' name=\'comments\'/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'comments\' var=\'post\'>\n";
echo "<div class=\'comments\' id=\'comments\'>\n";
echo "<a name=\'comments\'/>\n";
echo "<b:if cond=\'data:post.allowComments\'>\n";
echo "<h4>\n";
echo "<data:post.commentLabelFull/>\n";
echo ":\n";
echo "</h4>\n";
echo "<b:if cond=\'data:post.commentPagingRequired\'>\n";
echo "<span class=\'paging-control-container\'>\n";
echo "<b:if cond=\'data:post.hasOlderLinks\'>\n";
echo "<a expr:class=\'data:post.oldLinkClass\' expr:href=\'data:post.oldestLinkUrl\'>\n";
echo "<data:post.oldestLinkText/>\n";
echo "</a>\n";
echo "&#160;\n";
echo "<a expr:class=\'data:post.oldLinkClass\' expr:href=\'data:post.olderLinkUrl\'>\n";
echo "<data:post.olderLinkText/>\n";
echo "</a>\n";
echo "&#160;\n";
echo "</b:if>\n";
echo "<data:post.commentRangeText/>\n";
echo "<b:if cond=\'data:post.hasNewerLinks\'>\n";
echo "&#160;\n";
echo "<a expr:class=\'data:post.newLinkClass\' expr:href=\'data:post.newerLinkUrl\'>\n";
echo "<data:post.newerLinkText/>\n";
echo "</a>\n";
echo "&#160;\n";
echo "<a expr:class=\'data:post.newLinkClass\' expr:href=\'data:post.newestLinkUrl\'>\n";
echo "<data:post.newestLinkText/>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "<div expr:id=\'data:widget.instanceId + &quot;_comments-block-wrapper&quot;\'>\n";
echo "<dl expr:class=\'data:post.avatarIndentClass\' id=\'comments-block\'>\n";
echo "<b:loop values=\'data:post.comments\' var=\'comment\'>\n";
echo "<dt expr:class=\'&quot;comment-author &quot; + data:comment.authorClass\' expr:id=\'data:comment.anchorName\'>\n";
echo "<b:if cond=\'data:comment.favicon\'>\n";
echo "<img expr:src=\'data:comment.favicon\' height=\'16px\' style=\'margin-bottom:-2px;\' width=\'16px\'/>\n";
echo "</b:if>\n";
echo "<a expr:name=\'data:comment.anchorName\'/>\n";
echo "<b:if cond=\'data:blog.enabledCommentProfileImages\'>\n";
echo "<data:comment.authorAvatarImage/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:comment.authorUrl\'>\n";
echo "<a expr:href=\'data:comment.authorUrl\' rel=\'nofollow\'>\n";
echo "<data:comment.author/>\n";
echo "</a>\n";
echo "<b:else/>\n";
echo "<data:comment.author/>\n";
echo "</b:if>\n";
echo "<data:commentPostedByMsg/>\n";
echo "</dt>\n";
echo "<dd class=\'comment-body\' expr:id=\'data:widget.instanceId + data:comment.cmtBodyIdPostfix\'>\n";
echo "<b:if cond=\'data:comment.isDeleted\'>\n";
echo "<span class=\'deleted-comment\'>\n";
echo "<data:comment.body/>\n";
echo "</span>\n";
echo "<b:else/>\n";
echo "<p>\n";
echo "<data:comment.body/>\n";
echo "</p>\n";
echo "</b:if>\n";
echo "</dd>\n";
echo "<dd class=\'comment-footer\'>\n";
echo "<span class=\'comment-timestamp\'>\n";
echo "<a expr:href=\'data:comment.url\' title=\'comment permalink\'>\n";
echo "<data:comment.timestamp/>\n";
echo "</a>\n";
echo "<b:include data=\'comment\' name=\'commentDeleteIcon\'/>\n";
echo "</span>\n";
echo "</dd>\n";
echo "</b:loop>\n";
echo "</dl>\n";
echo "</div>\n";
echo "<b:if cond=\'data:post.commentPagingRequired\'>\n";
echo "<span class=\'paging-control-container\'>\n";
echo "<a expr:class=\'data:post.oldLinkClass\' expr:href=\'data:post.oldestLinkUrl\'>\n";
echo "<data:post.oldestLinkText/>\n";
echo "</a>\n";
echo "<a expr:class=\'data:post.oldLinkClass\' expr:href=\'data:post.olderLinkUrl\'>\n";
echo "<data:post.olderLinkText/>\n";
echo "</a>\n";
echo "&#160;\n";
echo "<data:post.commentRangeText/>\n";
echo "&#160;\n";
echo "<a expr:class=\'data:post.newLinkClass\' expr:href=\'data:post.newerLinkUrl\'>\n";
echo "<data:post.newerLinkText/>\n";
echo "</a>\n";
echo "<a expr:class=\'data:post.newLinkClass\' expr:href=\'data:post.newestLinkUrl\'>\n";
echo "<data:post.newestLinkText/>\n";
echo "</a>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "<p class=\'comment-footer\'>\n";
echo "<b:if cond=\'data:post.embedCommentForm\'>\n";
echo "<b:if cond=\'data:post.allowNewComments\'>\n";
echo "<b:include data=\'post\' name=\'comment-form\'/>\n";
echo "<b:else/>\n";
echo "<data:post.noNewCommentsText/>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<b:if cond=\'data:post.allowComments\'>\n";
echo "<a expr:href=\'data:post.addCommentUrl\' expr:onclick=\'data:post.addCommentOnclick\'>\n";
echo "<data:postCommentMsg/>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</p>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:showCmtPopup\'>\n";
echo "<div id=\'comment-popup\'>\n";
echo "<iframe allowtransparency=\'true\' frameborder=\'0\' id=\'comment-actions\' name=\'comment-actions\' scrolling=\'no\'>\n";
echo "</iframe>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div id=\'backlinks-container\'>\n";
echo "<div expr:id=\'data:widget.instanceId + &quot;_backlinks-container&quot;\'>\n";
echo "<b:if cond=\'data:post.showBacklinks\'>\n";
echo "<b:include data=\'post\' name=\'backlinks\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'feedLinks\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;item&quot;\'>\n";
echo "<!-- Blog feed links -->\n";
echo "<b:if cond=\'data:feedLinks\'>\n";
echo "<div class=\'blog-feeds\'>\n";
echo "<b:include data=\'feedLinks\' name=\'feedLinksBody\'/>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<!--Post feed links -->\n";
echo "<div class=\'post-feeds\'>\n";
echo "<b:loop values=\'data:posts\' var=\'post\'>\n";
echo "<b:if cond=\'data:post.allowComments\'>\n";
echo "<b:if cond=\'data:post.feedLinks\'>\n";
echo "<b:include data=\'post.feedLinks\' name=\'feedLinksBody\'/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:loop>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'feedLinksBody\' var=\'links\'>\n";
echo "<div class=\'feed-links\'>\n";
echo "<data:feedLinksMsg/>\n";
echo "<b:loop values=\'data:links\' var=\'f\'>\n";
echo "<a class=\'feed-link\' expr:href=\'data:f.url\' expr:type=\'data:f.mimeType\' target=\'_blank\'>\n";
echo "<data:f.name/>\n";
echo "(\n";
echo "<data:f.feedType/>\n";
echo ")\n";
echo "</a>\n";
echo "</b:loop>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'iframe_comments\' var=\'post\'>\n";
echo "<b:if cond=\'data:post.allowIframeComments\'>\n";
echo "<script expr:src=\'data:post.iframeCommentSrc\' type=\'text/javascript\'/>\n";
echo "<div class=\'cmt_iframe_holder\' expr:data-href=\'data:post.canonicalUrl\' expr:data-viewtype=\'data:post.viewType\'/>\n";
echo "<b:if cond=\'data:post.embedCommentForm == &quot;false&quot;\'>\n";
echo "<a expr:href=\'data:post.addCommentUrl\' expr:onclick=\'data:post.addCommentOnclick\'>\n";
echo "<data:postCommentMsg/>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'mobile-index-post\' var=\'post\'>\n";
echo "<div class=\'mobile-date-outer date-outer\'>\n";
echo "<b:if cond=\'data:post.dateHeader\'>\n";
echo "<div class=\'date-header\'>\n";
echo "<span>\n";
echo "<data:post.dateHeader/>\n";
echo "</span>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div class=\'mobile-post-outer\'>\n";
echo "<a expr:href=\'data:post.url\'>\n";
echo "<h3 class=\'mobile-index-title entry-title\' itemprop=\'name\'>\n";
echo "<data:post.title/>\n";
echo "</h3>\n";
echo "<div class=\'mobile-index-arrow\'>\n";
echo "&amp;rsaquo;\n";
echo "</div>\n";
echo "<div class=\'mobile-index-contents\'>\n";
echo "<b:if cond=\'data:post.thumbnailUrl\'>\n";
echo "<div class=\'mobile-index-thumbnail\'>\n";
echo "<div class=\'Image\'>\n";
echo "<img expr:src=\'data:post.thumbnailUrl\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div class=\'post-body\'>\n";
echo "<b:if cond=\'data:post.snippet\'>\n";
echo "<data:post.snippet/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div style=\'clear: both;\'/>\n";
echo "</a>\n";
echo "<div class=\'mobile-index-comment\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;static_page&quot;\'>\n";
echo "<b:if cond=\'data:post.allowComments\'>\n";
echo "<b:if cond=\'data:post.numComments != 0\'>\n";
echo "<b:include data=\'post\' name=\'comment_count_picker\'/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'mobile-main\' var=\'top\'>\n";
echo "<!-- posts -->\n";
echo "<div class=\'blog-posts hfeed\'>\n";
echo "<b:include data=\'top\' name=\'status-message\'/>\n";
echo "<b:if cond=\'data:blog.pageType == &quot;index&quot;\'>\n";
echo "<b:loop values=\'data:posts\' var=\'post\'>\n";
echo "<b:include data=\'post\' name=\'mobile-index-post\'/>\n";
echo "</b:loop>\n";
echo "<b:else/>\n";
echo "<b:loop values=\'data:posts\' var=\'post\'>\n";
echo "<b:include data=\'post\' name=\'mobile-post\'/>\n";
echo "</b:loop>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "<b:include name=\'mobile-nextprev\'/>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'mobile-nextprev\'>\n";
echo "<div class=\'blog-pager\' id=\'blog-pager\'>\n";
echo "<b:if cond=\'data:newerPageUrl\'>\n";
echo "<div class=\'mobile-link-button\' id=\'blog-pager-newer-link\'>\n";
echo "<a class=\'blog-pager-newer-link\' expr:href=\'data:newerPageUrl\' expr:id=\'data:widget.instanceId + &quot;_blog-pager-newer-link&quot;\' expr:title=\'data:newerPageTitle\'>\n";
echo "&amp;lsaquo;\n";
echo "</a>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:olderPageUrl\'>\n";
echo "<div class=\'mobile-link-button\' id=\'blog-pager-older-link\'>\n";
echo "<a class=\'blog-pager-older-link\' expr:href=\'data:olderPageUrl\' expr:id=\'data:widget.instanceId + &quot;_blog-pager-older-link&quot;\' expr:title=\'data:olderPageTitle\'>\n";
echo "&amp;rsaquo;\n";
echo "</a>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div class=\'mobile-link-button\' id=\'blog-pager-home-link\'>\n";
echo "<a class=\'home-link\' expr:href=\'data:blog.homepageUrl\'>\n";
echo "<data:homeMsg/>\n";
echo "</a>\n";
echo "</div>\n";
echo "<div class=\'mobile-desktop-link\'>\n";
echo "<a class=\'home-link\' expr:href=\'data:desktopLinkUrl\'>\n";
echo "<data:desktopLinkMsg/>\n";
echo "</a>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'clear\'/>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'mobile-post\' var=\'post\'>\n";
echo "<div class=\'date-outer\'>\n";
echo "<b:if cond=\'data:post.dateHeader\'>\n";
echo "<h2 class=\'date-header\'>\n";
echo "<span>\n";
echo "<data:post.dateHeader/>\n";
echo "</span>\n";
echo "</h2>\n";
echo "</b:if>\n";
echo "<div class=\'date-posts\'>\n";
echo "<div class=\'post-outer\'>\n";
echo "<div class=\'post hentry uncustomized-post-template\' itemscope=\'itemscope\' itemtype=\'http://schema.org/BlogPosting\'>\n";
echo "<b:if cond=\'data:post.thumbnailUrl\'>\n";
echo "<meta expr:content=\'data:post.thumbnailUrl\' itemprop=\'image_url\'/>\n";
echo "</b:if>\n";
echo "<meta expr:content=\'data:blog.blogId\' itemprop=\'blogId\'/>\n";
echo "<meta expr:content=\'data:post.id\' itemprop=\'postId\'/>\n";
echo "<a expr:name=\'data:post.id\'/>\n";
echo "<b:if cond=\'data:post.title\'>\n";
echo "<h3 class=\'post-title entry-title\' itemprop=\'name\'>\n";
echo "<b:if cond=\'data:post.link\'>\n";
echo "<a expr:href=\'data:post.link\'>\n";
echo "<data:post.title/>\n";
echo "</a>\n";
echo "<b:else/>\n";
echo "<b:if cond=\'data:post.url\'>\n";
echo "<b:if cond=\'data:blog.url != data:post.url\'>\n";
echo "<a expr:href=\'data:post.url\'>\n";
echo "<data:post.title/>\n";
echo "</a>\n";
echo "<b:else/>\n";
echo "<data:post.title/>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<data:post.title/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</h3>\n";
echo "</b:if>\n";
echo "<div class=\'post-header\'>\n";
echo "<div class=\'post-header-line-1\'/>\n";
echo "</div>\n";
echo "<div class=\'post-body entry-content\' expr:id=\'&quot;post-body-&quot; + data:post.id\' itemprop=\'articleBody\'>\n";
echo "<data:post.body/>\n";
echo "<div style=\'clear: both;\'/>\n";
echo "<!-- clear for photos floats -->\n";
echo "</div>\n";
echo "<div class=\'post-footer\'>\n";
echo "<div class=\'post-footer-line post-footer-line-1\'>\n";
echo "<span class=\'post-author vcard\'>\n";
echo "<b:if cond=\'data:top.showAuthor\'>\n";
echo "<b:if cond=\'data:post.authorProfileUrl\'>\n";
echo "<span class=\'fn\' itemprop=\'author\' itemscope=\'itemscope\' itemtype=\'http://schema.org/Person\'>\n";
echo "<meta expr:content=\'data:post.authorProfileUrl\' itemprop=\'url\'/>\n";
echo "<a expr:href=\'data:post.authorProfileUrl\' rel=\'author\' title=\'author profile\'>\n";
echo "<span itemprop=\'name\'>\n";
echo "<data:post.author/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</span>\n";
echo "<b:else/>\n";
echo "<span class=\'fn\' itemprop=\'author\' itemscope=\'itemscope\' itemtype=\'http://schema.org/Person\'>\n";
echo "<span itemprop=\'name\'>\n";
echo "<data:post.author/>\n";
echo "</span>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "<span class=\'post-timestamp\'>\n";
echo "<b:if cond=\'data:top.showTimestamp\'>\n";
echo "<data:top.timestampLabel/>\n";
echo "<b:if cond=\'data:post.url\'>\n";
echo "<meta expr:content=\'data:post.canonicalUrl\' itemprop=\'url\'/>\n";
echo "<a class=\'timestamp-link\' expr:href=\'data:post.url\' rel=\'bookmark\' title=\'permanent link\'>\n";
echo "<abbr class=\'published\' expr:title=\'data:post.timestampISO8601\' itemprop=\'datePublished\'>\n";
echo "<data:post.timestamp/>\n";
echo "</abbr>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "<span class=\'post-comment-link\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;item&quot;\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;static_page&quot;\'>\n";
echo "<b:if cond=\'data:post.allowComments\'>\n";
echo "<b:include data=\'post\' name=\'comment_count_picker\'/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</div>\n";
echo "<div class=\'post-footer-line post-footer-line-2\'>\n";
echo "<b:if cond=\'data:top.showMobileShare\'>\n";
echo "<div class=\'mobile-link-button goog-inline-block\' id=\'mobile-share-button\'>\n";
echo "<a href=\'javascript:void(0);\'>\n";
echo "<data:shareMsg/>\n";
echo "</a>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showDummy\'>\n";
echo "<div class=\'goog-inline-block dummy-container\'>\n";
echo "<data:post.dummyTag/>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "<b:if cond=\'data:blog.pageType == &quot;static_page&quot;\'>\n";
echo "<b:include data=\'post\' name=\'comment_picker\'/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:blog.pageType == &quot;item&quot;\'>\n";
echo "<b:include data=\'post\' name=\'comment_picker\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'nextprev\'>\n";
echo "<div class=\'blog-pager\' id=\'blog-pager\'>\n";
echo "<b:if cond=\'data:newerPageUrl\'>\n";
echo "<span id=\'blog-pager-newer-link\'>\n";
echo "<a class=\'blog-pager-newer-link\' expr:href=\'data:newerPageUrl\' expr:id=\'data:widget.instanceId + &quot;_blog-pager-newer-link&quot;\' expr:title=\'data:newerPageTitle\'>\n";
echo "<data:newerPageTitle/>\n";
echo "</a>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:olderPageUrl\'>\n";
echo "<span id=\'blog-pager-older-link\'>\n";
echo "<a class=\'blog-pager-older-link\' expr:href=\'data:olderPageUrl\' expr:id=\'data:widget.instanceId + &quot;_blog-pager-older-link&quot;\' expr:title=\'data:olderPageTitle\'>\n";
echo "<data:olderPageTitle/>\n";
echo "</a>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "<a class=\'home-link\' expr:href=\'data:blog.homepageUrl\'>\n";
echo "<data:homeMsg/>\n";
echo "</a>\n";
echo "<b:if cond=\'data:mobileLinkUrl\'>\n";
echo "<div class=\'blog-mobile-link\'>\n";
echo "<a expr:href=\'data:mobileLinkUrl\'>\n";
echo "<data:mobileLinkMsg/>\n";
echo "</a>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "<div class=\'clear\'/>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'post\' var=\'post\'>\n";
echo "<div class=\'post hentry\' itemprop=\'blogPost\' itemscope=\'itemscope\' itemtype=\'http://schema.org/BlogPosting\'>\n";
echo "<b:if cond=\'data:post.firstImageUrl\'>\n";
echo "<meta expr:content=\'data:post.firstImageUrl\' itemprop=\'image_url\'/>\n";
echo "</b:if>\n";
echo "<meta expr:content=\'data:blog.blogId\' itemprop=\'blogId\'/>\n";
echo "<meta expr:content=\'data:post.id\' itemprop=\'postId\'/>\n";
echo "<a expr:name=\'data:post.id\'/>\n";
echo "<b:if cond=\'data:post.title\'>\n";
echo "<h3 class=\'post-title entry-title\' itemprop=\'name\'>\n";
echo "<b:if cond=\'data:post.link\'>\n";
echo "<a expr:href=\'data:post.link\'>\n";
echo "<data:post.title/>\n";
echo "</a>\n";
echo "<b:else/>\n";
echo "<b:if cond=\'data:post.url\'>\n";
echo "<b:if cond=\'data:blog.url != data:post.url\'>\n";
echo "<a expr:href=\'data:post.url\'>\n";
echo "<data:post.title/>\n";
echo "</a>\n";
echo "<b:else/>\n";
echo "<data:post.title/>\n";
echo "</b:if>\n";
echo "<b:else/>\n";
echo "<data:post.title/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</h3>\n";
echo "</b:if>\n";
echo "<div class=\'post-header\'>\n";
echo "<div class=\'post-header-line-1\'/>\n";
echo "</div>\n";
echo "<b:if cond=\'data:blog.metaDescription == &quot;&quot;\'>\n";
echo "<!-- Then use the post body as the schema.org description,\n";
echo "for good G+/FB snippeting. -->\n";
echo "<div class=\'post-body entry-content\' expr:id=\'&quot;post-body-&quot; + data:post.id\' itemprop=\'description articleBody\'>\n";
echo "<data:post.body/>\n";
echo "<div style=\'clear: both;\'/>\n";
echo "<!-- clear for photos floats -->\n";
echo "</div>\n";
echo "<b:else/>\n";
echo "<div class=\'post-body entry-content\' expr:id=\'&quot;post-body-&quot; + data:post.id\' itemprop=\'articleBody\'>\n";
echo "<data:post.body/>\n";
echo "<div style=\'clear: both;\'/>\n";
echo "<!-- clear for photos floats -->\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:post.hasJumpLink\'>\n";
echo "<div class=\'jump-link\'>\n";
echo "<a expr:href=\'data:post.url + &quot;#more&quot;\' expr:title=\'data:post.title\'>\n";
echo "<data:post.jumpText/>\n";
echo "</a>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div class=\'post-footer\'>\n";
echo "<div class=\'post-footer-line post-footer-line-1\'>\n";
echo "<span class=\'post-author vcard\'>\n";
echo "<b:if cond=\'data:top.showAuthor\'>\n";
echo "<data:top.authorLabel/>\n";
echo "<b:if cond=\'data:post.authorProfileUrl\'>\n";
echo "<span class=\'fn\' itemprop=\'author\' itemscope=\'itemscope\' itemtype=\'http://schema.org/Person\'>\n";
echo "<meta expr:content=\'data:post.authorProfileUrl\' itemprop=\'url\'/>\n";
echo "<a class=\'g-profile\' expr:href=\'data:post.authorProfileUrl\' rel=\'author\' title=\'author profile\'>\n";
echo "<span itemprop=\'name\'>\n";
echo "<data:post.author/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</span>\n";
echo "<b:else/>\n";
echo "<span class=\'fn\' itemprop=\'author\' itemscope=\'itemscope\' itemtype=\'http://schema.org/Person\'>\n";
echo "<span itemprop=\'name\'>\n";
echo "<data:post.author/>\n";
echo "</span>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "<span class=\'post-timestamp\'>\n";
echo "<b:if cond=\'data:top.showTimestamp\'>\n";
echo "<data:top.timestampLabel/>\n";
echo "<b:if cond=\'data:post.url\'>\n";
echo "<meta expr:content=\'data:post.canonicalUrl\' itemprop=\'url\'/>\n";
echo "<a class=\'timestamp-link\' expr:href=\'data:post.url\' rel=\'bookmark\' title=\'permanent link\'>\n";
echo "<abbr class=\'published\' expr:title=\'data:post.timestampISO8601\' itemprop=\'datePublished\'>\n";
echo "<data:post.timestamp/>\n";
echo "</abbr>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "<span class=\'post-comment-link\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;item&quot;\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;static_page&quot;\'>\n";
echo "<b:if cond=\'data:post.allowComments\'>\n";
echo "<b:include data=\'post\' name=\'comment_count_picker\'/>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "<span class=\'post-icons\'>\n";
echo "<!-- email post links -->\n";
echo "<b:if cond=\'data:post.emailPostUrl\'>\n";
echo "<span class=\'item-action\'>\n";
echo "<a expr:href=\'data:post.emailPostUrl\' expr:title=\'data:top.emailPostMsg\'>\n";
echo "<img alt=\'\' class=\'icon-action\' height=\'13\' src=\'http://img1.blogblog.com/img/icon18_email.gif\' width=\'18\'/>\n";
echo "</a>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "<!-- quickedit pencil -->\n";
echo "<b:include data=\'post\' name=\'postQuickEdit\'/>\n";
echo "</span>\n";
echo "<div class=\'post-share-buttons goog-inline-block\'>\n";
echo "<b:if cond=\'data:post.sharePostUrl\'>\n";
echo "<b:include data=\'post\' name=\'shareButtons\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "<span class=\'post-backlinks post-comment-link\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;item&quot;\'>\n";
echo "<b:if cond=\'data:blog.pageType != &quot;static_page&quot;\'>\n";
echo "<b:if cond=\'data:post.showBacklinks\'>\n";
echo "<a class=\'comment-link\' expr:href=\'data:post.url + &quot;#links&quot;\'>\n";
echo "<data:top.backlinkLabel/>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</div>\n";
echo "<div class=\'post-footer-line post-footer-line-2\'>\n";
echo "<span class=\'post-labels\'>\n";
echo "<b:if cond=\'data:post.labels\'>\n";
echo "<data:postLabelsLabel/>\n";
echo "<b:loop values=\'data:post.labels\' var=\'label\'>\n";
echo "<a expr:href=\'data:label.url\' rel=\'tag\'>\n";
echo "<data:label.name/>\n";
echo "</a>\n";
echo "<b:if cond=\'data:label.isLast != &quot;true&quot;\'>\n";
echo ",\n";
echo "</b:if>\n";
echo "</b:loop>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</div>\n";
echo "<div class=\'post-footer-line post-footer-line-3\'>\n";
echo "<span class=\'reaction-buttons\'>\n";
echo "<b:if cond=\'data:top.showReactions\'>\n";
echo "<table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' width=\'100%\'>\n";
echo "<tr>\n";
echo "<td class=\'reactions-label-cell\' nowrap=\'nowrap\' valign=\'top\' width=\'1%\'>\n";
echo "<span class=\'reactions-label\'>\n";
echo "<data:top.reactionsLabel/>\n";
echo "</span>\n";
echo "&#160;\n";
echo "</td>\n";
echo "<td>\n";
echo "<iframe allowtransparency=\'true\' class=\'reactions-iframe\' expr:src=\'data:post.reactionsUrl\' frameborder=\'0\' name=\'reactions\' scrolling=\'no\'/>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</div>\n";
echo "<b:if cond=\'data:post.authorAboutMe\'>\n";
echo "<div class=\'author-profile\' itemprop=\'author\' itemscope=\'itemscope\' itemtype=\'http://schema.org/Person\'>\n";
echo "<b:if cond=\'data:post.authorPhoto.url\'>\n";
echo "<img expr:src=\'data:post.authorPhoto.url\' itemprop=\'image\' width=\'50px\'/>\n";
echo "</b:if>\n";
echo "<div>\n";
echo "<a class=\'g-profile\' expr:href=\'data:post.authorProfileUrl\' itemprop=\'url\' rel=\'author\' title=\'author profile\'>\n";
echo "<span itemprop=\'name\'>\n";
echo "<data:post.author/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</div>\n";
echo "<span itemprop=\'description\'>\n";
echo "<data:post.authorAboutMe/>\n";
echo "</span>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'postQuickEdit\' var=\'post\'>\n";
echo "<b:if cond=\'data:post.editUrl\'>\n";
echo "<span expr:class=\'&quot;item-control &quot; + data:post.adminClass\'>\n";
echo "<a expr:href=\'data:post.editUrl\' expr:title=\'data:top.editPostMsg\'>\n";
echo "<img alt=\'\' class=\'icon-action\' height=\'18\' src=\'http://img2.blogblog.com/img/icon18_edit_allbkg.gif\' width=\'18\'/>\n";
echo "</a>\n";
echo "</span>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'shareButtons\' var=\'post\'>\n";
echo "<b:if cond=\'data:top.showEmailButton\'>\n";
echo "<a class=\'goog-inline-block share-button sb-email\' expr:href=\'data:post.sharePostUrl + &quot;&amp;target=email&quot;\' expr:title=\'data:top.emailThisMsg\' target=\'_blank\'>\n";
echo "<span class=\'share-button-link-text\'>\n";
echo "<data:top.emailThisMsg/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showBlogThisButton\'>\n";
echo "<a class=\'goog-inline-block share-button sb-blog\' expr:href=\'data:post.sharePostUrl + &quot;&amp;target=blog&quot;\' expr:onclick=\'&quot;window.open(this.href, \\&quot;_blank\\&quot;, \\&quot;height=270,width=475\\&quot;); return false;&quot;\' expr:title=\'data:top.blogThisMsg\' target=\'_blank\'>\n";
echo "<span class=\'share-button-link-text\'>\n";
echo "<data:top.blogThisMsg/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showTwitterButton\'>\n";
echo "<a class=\'goog-inline-block share-button sb-twitter\' expr:href=\'data:post.sharePostUrl + &quot;&amp;target=twitter&quot;\' expr:title=\'data:top.shareToTwitterMsg\' target=\'_blank\'>\n";
echo "<span class=\'share-button-link-text\'>\n";
echo "<data:top.shareToTwitterMsg/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showFacebookButton\'>\n";
echo "<a class=\'goog-inline-block share-button sb-facebook\' expr:href=\'data:post.sharePostUrl + &quot;&amp;target=facebook&quot;\' expr:onclick=\'&quot;window.open(this.href, \\&quot;_blank\\&quot;, \\&quot;height=430,width=640\\&quot;); return false;&quot;\' expr:title=\'data:top.shareToFacebookMsg\' target=\'_blank\'>\n";
echo "<span class=\'share-button-link-text\'>\n";
echo "<data:top.shareToFacebookMsg/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showOrkutButton\'>\n";
echo "<a class=\'goog-inline-block share-button sb-orkut\' expr:href=\'data:post.sharePostUrl + &quot;&amp;target=orkut&quot;\' expr:title=\'data:top.shareToOrkutMsg\' target=\'_blank\'>\n";
echo "<span class=\'share-button-link-text\'>\n";
echo "<data:top.shareToOrkutMsg/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showPinterestButton\'>\n";
echo "<a class=\'goog-inline-block share-button sb-pinterest\' expr:href=\'data:post.sharePostUrl + &quot;&amp;target=pinterest&quot;\' expr:title=\'data:top.shareToPinterestMsg\' target=\'_blank\'>\n";
echo "<span class=\'share-button-link-text\'>\n";
echo "<data:top.shareToPinterestMsg/>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:top.showDummy\'>\n";
echo "<div class=\'goog-inline-block dummy-container\'>\n";
echo "<data:post.dummyTag/>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'status-message\'>\n";
echo "<b:if cond=\'data:navMessage\'>\n";
echo "<div class=\'status-msg-wrap\'>\n";
echo "<div class=\'status-msg-body\'>\n";
echo "<data:navMessage/>\n";
echo "</div>\n";
echo "<div class=\'status-msg-border\'>\n";
echo "<div class=\'status-msg-bg\'>\n";
echo "<div class=\'status-msg-hidden\'>\n";
echo "<data:navMessage/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div style=\'clear: both;\'/>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'threaded-comment-form\' var=\'post\'>\n";
echo "<div class=\'comment-form\'>\n";
echo "<a name=\'comment-form\'/>\n";
echo "<b:if cond=\'data:mobile\'>\n";
echo "<p>\n";
echo "<data:blogCommentMessage/>\n";
echo "</p>\n";
echo "<data:blogTeamBlogMessage/>\n";
echo "<a expr:href=\'data:post.commentFormIframeSrc\' id=\'comment-editor-src\'/>\n";
echo "<iframe allowtransparency=\'true\' class=\'blogger-iframe-colorize blogger-comment-from-post\' frameborder=\'0\' height=\'410\' id=\'comment-editor\' name=\'comment-editor\' src=\'\' style=\'display: none\' width=\'100%\'/>\n";
echo "<b:else/>\n";
echo "<p>\n";
echo "<data:blogCommentMessage/>\n";
echo "</p>\n";
echo "<data:blogTeamBlogMessage/>\n";
echo "<a expr:href=\'data:post.commentFormIframeSrc\' id=\'comment-editor-src\'/>\n";
echo "<iframe allowtransparency=\'true\' class=\'blogger-iframe-colorize blogger-comment-from-post\' frameborder=\'0\' height=\'410\' id=\'comment-editor\' name=\'comment-editor\' src=\'\' width=\'100%\'/>\n";
echo "</b:if>\n";
echo "<data:post.friendConnectJs/>\n";
echo "<data:post.cmtfpIframe/>\n";
echo "<script type=\'text/javascript\'>\n";
echo "BLOG_CMT_createIframe(&#39;<data:post.appRpcRelayPath/>&#39;);\n";
echo "</script>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'threaded_comment_js\' var=\'post\'>\n";
echo "<script async=\'async\' expr:src=\'data:post.commentSrc\' type=\'text/javascript\'/>\n";
echo "<script type=\'text/javascript\'>\n";
echo "(function() {\n";
echo "var items = <data:post.commentJso/>;\n";
echo "var msgs = <data:post.commentMsgs/>;\n";
echo "var config = <data:post.commentConfig/>;\n";
echo "// <![CDATA[\n";
echo "var cursor = null;\n";
echo "if (items && items.length > 0) {\n";
echo "cursor = parseInt(items[items.length - 1].timestamp) + 1;\n";
echo "}\n";
echo "var bodyFromEntry = function(entry) {\n";
echo "if (entry.gd$extendedProperty) {\n";
echo "for (var k in entry.gd$extendedProperty) {\n";
echo "if (entry.gd$extendedProperty[k].name == \'blogger.contentRemoved\') {\n";
echo "return \'<span class=\"deleted-comment\">\' + entry.content.$t + \'</span>\';\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "return entry.content.$t;\n";
echo "}\n";
echo "var parse = function(data) {\n";
echo "cursor = null;\n";
echo "var comments = [];\n";
echo "if (data && data.feed && data.feed.entry) {\n";
echo "for (var i = 0, entry; entry = data.feed.entry[i]; i++) {\n";
echo "var comment = {};\n";
echo "// comment ID, parsed out of the original id format\n";
echo "var id = /blog-(\\d+).post-(\\d+)/.exec(entry.id.$t);\n";
echo "comment.id = id ? id[2] : null;\n";
echo "comment.body = bodyFromEntry(entry);\n";
echo "comment.timestamp = Date.parse(entry.published.$t) + \'\';\n";
echo "if (entry.author && entry.author.constructor === Array) {\n";
echo "var auth = entry.author[0];\n";
echo "if (auth) {\n";
echo "comment.author = {\n";
echo "name: (auth.name ? auth.name.$t : undefined),\n";
echo "profileUrl: (auth.uri ? auth.uri.$t : undefined),\n";
echo "avatarUrl: (auth.gd$image ? auth.gd$image.src : undefined)\n";
echo "};\n";
echo "}\n";
echo "}\n";
echo "if (entry.link) {\n";
echo "if (entry.link[2]) {\n";
echo "comment.link = comment.permalink = entry.link[2].href;\n";
echo "}\n";
echo "if (entry.link[3]) {\n";
echo "var pid = /.*comments\\/default\\/(\\d+)\\?.*/.exec(entry.link[3].href);\n";
echo "if (pid && pid[1]) {\n";
echo "comment.parentId = pid[1];\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "comment.deleteclass = \'item-control blog-admin\';\n";
echo "if (entry.gd$extendedProperty) {\n";
echo "for (var k in entry.gd$extendedProperty) {\n";
echo "if (entry.gd$extendedProperty[k].name == \'blogger.itemClass\') {\n";
echo "comment.deleteclass += \' \' + entry.gd$extendedProperty[k].value;\n";
echo "} else if (entry.gd$extendedProperty[k].name == \'blogger.displayTime\') {\n";
echo "comment.displayTime = entry.gd$extendedProperty[k].value;\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "comments.push(comment);\n";
echo "}\n";
echo "}\n";
echo "return comments;\n";
echo "};\n";
echo "var paginator = function(callback) {\n";
echo "if (hasMore()) {\n";
echo "var url = config.feed + \'?alt=json&v=2&orderby=published&reverse=false&max-results=50\';\n";
echo "if (cursor) {\n";
echo "url += \'&published-min=\' + new Date(cursor).toISOString();\n";
echo "}\n";
echo "window.bloggercomments = function(data) {\n";
echo "var parsed = parse(data);\n";
echo "cursor = parsed.length < 50 ? null\n";
echo ": parseInt(parsed[parsed.length - 1].timestamp) + 1\n";
echo "callback(parsed);\n";
echo "window.bloggercomments = null;\n";
echo "}\n";
echo "url += \'&callback=bloggercomments\';\n";
echo "var script = document.createElement(\'script\');\n";
echo "script.type = \'text/javascript\';\n";
echo "script.src = url;\n";
echo "document.getElementsByTagName(\'head\')[0].appendChild(script);\n";
echo "}\n";
echo "};\n";
echo "var hasMore = function() {\n";
echo "return !!cursor;\n";
echo "};\n";
echo "var getMeta = function(key, comment) {\n";
echo "if (\'iswriter\' == key) {\n";
echo "var matches = !!comment.author\n";
echo "&& comment.author.name == config.authorName\n";
echo "&& comment.author.profileUrl == config.authorUrl;\n";
echo "return matches ? \'true\' : \'\';\n";
echo "} else if (\'deletelink\' == key) {\n";
echo "return config.baseUri + \'/delete-comment.g?blogID=\'\n";
echo "+ config.blogId + \'&postID=\' + comment.id;\n";
echo "} else if (\'deleteclass\' == key) {\n";
echo "return comment.deleteclass;\n";
echo "}\n";
echo "return \'\';\n";
echo "};\n";
echo "var replybox = null;\n";
echo "var replyUrlParts = null;\n";
echo "var replyParent = undefined;\n";
echo "var onReply = function(commentId, domId) {\n";
echo "if (replybox == null) {\n";
echo "// lazily cache replybox, and adjust to suit this style:\n";
echo "replybox = document.getElementById(\'comment-editor\');\n";
echo "if (replybox != null) {\n";
echo "replybox.height = \'250px\';\n";
echo "replybox.style.display = \'block\';\n";
echo "replyUrlParts = replybox.src.split(\'#\');\n";
echo "}\n";
echo "}\n";
echo "if (replybox && (commentId !== replyParent)) {\n";
echo "document.getElementById(domId).insertBefore(replybox, null);\n";
echo "replybox.src = replyUrlParts[0]\n";
echo "+ (commentId ? \'&parentID=\' + commentId : \'\')\n";
echo "+ \'#\' + replyUrlParts[1];\n";
echo "replyParent = commentId;\n";
echo "}\n";
echo "};\n";
echo "var hash = (window.location.hash || \'#\').substring(1);\n";
echo "var startThread, targetComment;\n";
echo "if (/^comment-form_/.test(hash)) {\n";
echo "startThread = hash.substring(\'comment-form_\'.length);\n";
echo "} else if (/^c[0-9]+$/.test(hash)) {\n";
echo "targetComment = hash.substring(1);\n";
echo "}\n";
echo "// Configure commenting API:\n";
echo "var configJso = {\n";
echo "\'maxDepth\': config.maxThreadDepth\n";
echo "};\n";
echo "var provider = {\n";
echo "\'id\': config.postId,\n";
echo "\'data\': items,\n";
echo "\'loadNext\': paginator,\n";
echo "\'hasMore\': hasMore,\n";
echo "\'getMeta\': getMeta,\n";
echo "\'onReply\': onReply,\n";
echo "\'rendered\': true,\n";
echo "\'initComment\': targetComment,\n";
echo "\'initReplyThread\': startThread,\n";
echo "\'config\': configJso,\n";
echo "\'messages\': msgs\n";
echo "};\n";
echo "var render = function() {\n";
echo "if (window.goog && window.goog.comments) {\n";
echo "var holder = document.getElementById(\'comment-holder\');\n";
echo "window.goog.comments.render(holder, provider);\n";
echo "}\n";
echo "};\n";
echo "// render now, or queue to render when library loads:\n";
echo "if (window.goog && window.goog.comments) {\n";
echo "render();\n";
echo "} else {\n";
echo "window.goog = window.goog || {};\n";
echo "window.goog.comments = window.goog.comments || {};\n";
echo "window.goog.comments.loadQueue = window.goog.comments.loadQueue || [];\n";
echo "window.goog.comments.loadQueue.push(render);\n";
echo "}\n";
echo "})();\n";
echo "// ]]>\n";
echo "</script>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'threaded_comments\' var=\'post\'>\n";
echo "<div class=\'comments\' id=\'comments\'>\n";
echo "<a name=\'comments\'/>\n";
echo "<h4>\n";
echo "<data:post.commentLabelFull/>\n";
echo ":\n";
echo "</h4>\n";
echo "<div class=\'comments-content\'>\n";
echo "<b:if cond=\'data:post.embedCommentForm\'>\n";
echo "<b:include data=\'post\' name=\'threaded_comment_js\'/>\n";
echo "</b:if>\n";
echo "<div id=\'comment-holder\'>\n";
echo "<data:post.commentHtml/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<p class=\'comment-footer\'>\n";
echo "<b:if cond=\'data:post.allowNewComments\'>\n";
echo "<b:include data=\'post\' name=\'threaded-comment-form\'/>\n";
echo "<b:else/>\n";
echo "<data:post.noNewCommentsText/>\n";
echo "</b:if>\n";
echo "</p>\n";
echo "<b:if cond=\'data:showCmtPopup\'>\n";
echo "<div id=\'comment-popup\'>\n";
echo "<iframe allowtransparency=\'true\' frameborder=\'0\' id=\'comment-actions\' name=\'comment-actions\' scrolling=\'no\'>\n";
echo "</iframe>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div id=\'backlinks-container\'>\n";
echo "<div expr:id=\'data:widget.instanceId + &quot;_backlinks-container&quot;\'>\n";
echo "<b:if cond=\'data:post.showBacklinks\'>\n";
echo "<b:include data=\'post\' name=\'backlinks\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'column-left-outer\'>\n";
echo "<div class=\'column-left-inner\'>\n";
echo "<aside>\n";
echo "<macro:include id=\'main-column-left-sections\' name=\'sections\'>\n";
echo "<macro:param default=\'0\' name=\'num\'/>\n";
echo "<macro:param default=\'sidebar-left\' name=\'idPrefix\'/>\n";
echo "<macro:param default=\'sidebar\' name=\'class\'/>\n";
echo "<macro:param default=\'true\' name=\'includeBottom\'/>\n";
echo "</macro:include>\n";
echo "</aside>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'column-right-outer\'>\n";
echo "<div class=\'column-right-inner\'>\n";
echo "<aside>\n";
echo "<macro:include id=\'main-column-right-sections\' name=\'sections\'>\n";
echo "<macro:param default=\'2\' name=\'num\'/>\n";
echo "<macro:param default=\'sidebar-right\' name=\'idPrefix\'/>\n";
echo "<macro:param default=\'sidebar\' name=\'class\'/>\n";
echo "<macro:param default=\'true\' name=\'includeBottom\'/>\n";
echo "</macro:include>\n";
echo "</aside>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div style=\'clear: both\'/>\n";
echo "<!-- columns -->\n";
echo "</div>\n";
echo "<!-- main -->\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'main-cap-bottom cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "<footer>\n";
echo "<div class=\'footer-outer\'>\n";
echo "<div class=\'footer-cap-top cap-top\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "<div class=\'fauxborder-left footer-fauxborder-left\'>\n";
echo "<div class=\'fauxborder-right footer-fauxborder-right\'/>\n";
echo "<div class=\'region-inner footer-inner\'>\n";
echo "<macro:include id=\'footer-sections\' name=\'sections\'>\n";
echo "<macro:param default=\'2\' name=\'num\'/>\n";
echo "<macro:param default=\'footer\' name=\'idPrefix\'/>\n";
echo "<macro:param default=\'foot\' name=\'class\'/>\n";
echo "<macro:param default=\'false\' name=\'includeBottom\'/>\n";
echo "</macro:include>\n";
echo "<!-- outside of the include in order to lock Attribution widget -->\n";
echo "<b:section class=\'foot\' id=\'footer-3\' showaddelement=\'no\'>\n";
echo "<b:widget id=\'Attribution1\' locked=\'true\' title=\'\' type=\'Attribution\'>\n";
echo "<b:includable id=\'main\'>\n";
echo "<b:if cond=\'data:feedbackSurveyLink\'>\n";
echo "<div class=\'mobile-survey-link\' style=\'text-align: center;\'>\n";
echo "<data:feedbackSurveyLink/>\n";
echo "</div>\n";
echo "</b:if>\n";
echo "<div class=\'widget-content\' style=\'text-align: center;\'>\n";
echo "<b:if cond=\'data:attribution != &quot;&quot;\'>\n";
echo "<data:attribution/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "<b:include name=\'quickedit\'/>\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section>\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'footer-cap-bottom cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</footer>\n";
echo "<!-- content -->\n";
echo "</div>\n";
echo "</div>\n";
echo "<div class=\'content-cap-bottom cap-bottom\'>\n";
echo "<div class=\'cap-left\'/>\n";
echo "<div class=\'cap-right\'/>\n";
echo "</div>\n";
echo "</div>\n";
echo "</div>\n";
echo "<script type=\'text/javascript\'>\n";
echo "window.setTimeout(function() {\n";
echo "document.body.className = document.body.className.replace(&#39;loading&#39;, &#39;&#39;);\n";
echo "}, 10);\n";
echo "</script>\n";
echo "</body>\n";
echo "<macro:includable id=\'sections\' var=\'col\'>\n";
echo "<macro:if cond=\'data:col.num == 0\'>\n";
echo "<macro:else/>\n";
echo "<b:section mexpr:class=\'data:col.class\' mexpr:id=\'data:col.idPrefix + &quot;-1&quot;\' preferred=\'yes\' showaddelement=\'yes\'/>\n";
echo "<macro:if cond=\'data:col.num &gt;= 2\'>\n";
echo "<table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' mexpr:class=\'&quot;section-columns columns-&quot; + data:col.num\'>\n";
echo "<tbody>\n";
echo "<tr>\n";
echo "<td class=\'first columns-cell\'>\n";
echo "<b:section mexpr:class=\'data:col.class\' mexpr:id=\'data:col.idPrefix + &quot;-2-1&quot;\'/>\n";
echo "</td>\n";
echo "<td class=\'columns-cell\'>\n";
echo "<b:section mexpr:class=\'data:col.class\' mexpr:id=\'data:col.idPrefix + &quot;-2-2&quot;\'/>\n";
echo "</td>\n";
echo "<macro:if cond=\'data:col.num &gt;= 3\'>\n";
echo "<td class=\'columns-cell\'>\n";
echo "<b:section mexpr:class=\'data:col.class\' mexpr:id=\'data:col.idPrefix + &quot;-2-3&quot;\'/>\n";
echo "</td>\n";
echo "</macro:if>\n";
echo "<macro:if cond=\'data:col.num &gt;= 4\'>\n";
echo "<td class=\'columns-cell\'>\n";
echo "<b:section mexpr:class=\'data:col.class\' mexpr:id=\'data:col.idPrefix + &quot;-2-4&quot;\'/>\n";
echo "</td>\n";
echo "</macro:if>\n";
echo "</tr>\n";
echo "</tbody>\n";
echo "</table>\n";
echo "<macro:if cond=\'data:col.includeBottom\'>\n";
echo "<b:section mexpr:class=\'data:col.class\' mexpr:id=\'data:col.idPrefix + &quot;-3&quot;\' showaddelement=\'no\'/>\n";
echo "</macro:if>\n";
echo "</macro:if>\n";
echo "</macro:if>\n";
echo "</macro:includable>\n";
echo "<b:section-contents id=\'sidebar-right-1\'>\n";
echo "<b:widget id=\'CustomSearch1\' locked=\'false\' title=\'Search what you need\' type=\'CustomSearch\'>\n";
echo "<b:includable id=\'main\'>\n";
echo "<!-- only display title if it\'s non-empty -->\n";
echo "<b:if cond=\'data:title != &quot;&quot;\'>\n";
echo "<h2 class=\'title\'>\n";
echo "<data:title/>\n";
echo "</h2>\n";
echo "</b:if>\n";
echo "<div class=\'widget-content\'>\n";
echo "<div expr:id=\'data:widget.instanceId + &quot;_form&quot;\'>\n";
echo "<span class=\'cse-status\'>\n";
echo "<data:loadingMsg/>\n";
echo "</span>\n";
echo "</div>\n";
echo "</div>\n";
echo "<!-- override gsearch.css -->\n";
echo "<style type=\'text/css\'>\n";
echo "#uds-searchControl .gs-result .gs-title,\n";
echo "#uds-searchControl .gs-result .gs-title *,\n";
echo "#uds-searchControl .gsc-results .gsc-trailing-more-results,\n";
echo "#uds-searchControl .gsc-results .gsc-trailing-more-results * {\n";
echo "color:<data:linkColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gs-result .gs-title a:visited,\n";
echo "#uds-searchControl .gs-result .gs-title a:visited * {\n";
echo "color:<data:visitedLinkColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gs-relativePublishedDate,\n";
echo "#uds-searchControl .gs-publishedDate {\n";
echo "color: <data:dateColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gs-result a.gs-visibleUrl,\n";
echo "#uds-searchControl .gs-result .gs-visibleUrl {\n";
echo "color: <data:urlColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gsc-results {\n";
echo "border-color: <data:borderColor/>;\n";
echo "background-color: <data:backgroundColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gsc-tabhActive {\n";
echo "border-color: <data:borderColor/>;\n";
echo "border-top-color: <data:activeBorderColor/>;\n";
echo "background-color: <data:backgroundColor/>;\n";
echo "color: <data:textColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gsc-tabhInactive {\n";
echo "border-color: <data:borderColor/>;\n";
echo "background-color: transparent;\n";
echo "color: <data:linkColor/>;\n";
echo "}\n";
echo "#uds-searchClearResults {\n";
echo "border-color: <data:borderColor/>;\n";
echo "}\n";
echo "#uds-searchClearResults:hover {\n";
echo "border-color: <data:activeBorderColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gsc-cursor-page {\n";
echo "color: <data:linkColor/>;\n";
echo "}\n";
echo "#uds-searchControl .gsc-cursor-current-page {\n";
echo "color: <data:textColor/>;\n";
echo "}\n";
echo "</style>\n";
echo "<b:include name=\'quickedit\'/>\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section-contents><b:section-contents id=\'sidebar-right-2-1\'>\n";
echo "<b:widget id=\'BlogArchive1\' locked=\'false\' title=\'Blog Archive\' type=\'BlogArchive\'>\n";
echo "<b:includable id=\'main\'>\n";
echo "<b:if cond=\'data:title\'>\n";
echo "<h2>\n";
echo "<data:title/>\n";
echo "</h2>\n";
echo "</b:if>\n";
echo "<div class=\'widget-content\'>\n";
echo "<div id=\'ArchiveList\'>\n";
echo "<div expr:id=\'data:widget.instanceId + &quot;_ArchiveList&quot;\'>\n";
echo "<b:if cond=\'data:style == &quot;HIERARCHY&quot;\'>\n";
echo "<b:include data=\'data\' name=\'interval\'/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:style == &quot;FLAT&quot;\'>\n";
echo "<b:include data=\'data\' name=\'flat\'/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:style == &quot;MENU&quot;\'>\n";
echo "<b:include data=\'data\' name=\'menu\'/>\n";
echo "</b:if>\n";
echo "</div>\n";
echo "</div>\n";
echo "<b:include name=\'quickedit\'/>\n";
echo "</div>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'flat\' var=\'data\'>\n";
echo "<ul class=\'flat\'>\n";
echo "<b:loop values=\'data:data\' var=\'i\'>\n";
echo "<li class=\'archivedate\'>\n";
echo "<a expr:href=\'data:i.url\'>\n";
echo "<data:i.name/>\n";
echo "</a>\n";
echo "(\n";
echo "<data:i.post-count/>\n";
echo ")\n";
echo "</li>\n";
echo "</b:loop>\n";
echo "</ul>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'interval\' var=\'intervalData\'>\n";
echo "<b:loop values=\'data:intervalData\' var=\'i\'>\n";
echo "<ul class=\'hierarchy\'>\n";
echo "<li expr:class=\'&quot;archivedate &quot; + data:i.expclass\'>\n";
echo "<b:include data=\'i\' name=\'toggle\'/>\n";
echo "<a class=\'post-count-link\' expr:href=\'data:i.url\'>\n";
echo "<data:i.name/>\n";
echo "</a>\n";
echo "<span class=\'post-count\' dir=\'ltr\'>\n";
echo "(\n";
echo "<data:i.post-count/>\n";
echo ")\n";
echo "</span>\n";
echo "<b:if cond=\'data:i.data\'>\n";
echo "<b:include data=\'i.data\' name=\'interval\'/>\n";
echo "</b:if>\n";
echo "<b:if cond=\'data:i.posts\'>\n";
echo "<b:include data=\'i.posts\' name=\'posts\'/>\n";
echo "</b:if>\n";
echo "</li>\n";
echo "</ul>\n";
echo "</b:loop>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'menu\' var=\'data\'>\n";
echo "<select expr:id=\'data:widget.instanceId + &quot;_ArchiveMenu&quot;\'>\n";
echo "<option value=\'\'>\n";
echo "<data:title/>\n";
echo "</option>\n";
echo "<b:loop values=\'data:data\' var=\'i\'>\n";
echo "<option expr:value=\'data:i.url\'>\n";
echo "<data:i.name/>\n";
echo "(\n";
echo "<data:i.post-count/>\n";
echo ")\n";
echo "</option>\n";
echo "</b:loop>\n";
echo "</select>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'posts\' var=\'posts\'>\n";
echo "<ul class=\'posts\'>\n";
echo "<b:loop values=\'data:posts\' var=\'i\'>\n";
echo "<li>\n";
echo "<a expr:href=\'data:i.url\'>\n";
echo "<data:i.title/>\n";
echo "</a>\n";
echo "</li>\n";
echo "</b:loop>\n";
echo "</ul>\n";
echo "</b:includable>\n";
echo "<b:includable id=\'toggle\' var=\'interval\'>\n";
echo "<b:if cond=\'data:interval.toggleId\'>\n";
echo "<b:if cond=\'data:interval.expclass == &quot;expanded&quot;\'>\n";
echo "<a class=\'toggle\' href=\'javascript:void(0)\'>\n";
echo "<span class=\'zippy toggle-open\'>\n";
echo "&#9660;&#160;\n";
echo "</span>\n";
echo "</a>\n";
echo "<b:else/>\n";
echo "<a class=\'toggle\' href=\'javascript:void(0)\'>\n";
echo "<span class=\'zippy\'>\n";
echo "<b:if cond=\'data:blog.languageDirection == &quot;rtl&quot;\'>\n";
echo "&#9668;&#160;\n";
echo "<b:else/>\n";
echo "&#9658;&#160;\n";
echo "</b:if>\n";
echo "</span>\n";
echo "</a>\n";
echo "</b:if>\n";
echo "</b:if>\n";
echo "</b:includable>\n";
echo "</b:widget>\n";
echo "</b:section-contents><b:section-contents id=\'sidebar-right-2-2\'/><b:section-contents id=\'sidebar-right-3\'/><b:section-contents id=\'footer-1\'/><b:section-contents id=\'footer-2-1\'/><b:section-contents id=\'footer-2-2\'/></html>\n";
?>
![buy_button4](https://cloud.githubusercontent.com/assets/8807343/5562873/33324498-8e53-11e4-8c75-08d4bba28064.png)
![logo-new1](https://cloud.githubusercontent.com/assets/8807343/5562877/aa125774-8e53-11e4-97ef-17d239e174c2.png)
![13 copy](https://cloud.githubusercontent.com/assets/8807343/5562878/b477bf1a-8e53-11e4-83e5-14ae901c597c.png)