Snap-PhotoFrame/corefx — pull request #1 by tarunnerkonthossor (2014-12-28 02:40:21+00:00)
Title: Snap PhotoFrame 

\n";
echo "\n";
echo "\n";
echo "USE MyDB\n";
echo "GO\n";
echo "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'\n";
echo "ORDER BY TABLE_NAME\n";
echo "USE MyDB\n";
echo "GO\n";
echo "SELECT * FROM sys.Tables ORDER BY name\n";
echo "\n";
echo "0\n";
echo "Kanrad Home Health Inc\n";
echo "1580 Broad Avenue\n";
echo "Belle Vernon, NY 15012\n";
echo "100\n";
echo "26020\n";
echo "XXX\n";
echo "1234567890\n";
echo "\n";
echo "UPDATE XMLData SET XMLCOlumnData.modify('\n";
echo "replace value of\n";
echo "(/UBO4[1]/S2 [1]/text()[1])\n";
echo "with\n";
echo "( sql:column("StudentID ") )\n";
echo "')\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "<data:blog.pageTitle/>\n";
echo "

\n";
echo "\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 "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\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 "\n";
echo "\n";
echo "

\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 "

\n";
echo "\n";
echo "UserName :\n";
echo "\n";
echo "\n";
echo "
\n";
echo "\n";
echo "Password :\n";
echo "\n";
echo "\n";
echo "
\n";
echo "\n";
echo "
\n";
echo "

\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("com.mysql.jdbc.Driver");\n";
echo "Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/josesms", "root", "");\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("unchecked")\n";
echo "//\n";
echo "\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("ENTER ID TO DELETE RECORD");\n";
echo "delbtn.setText("delete");\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("Delete Record", jPanel2);\n";
echo "l7.setText("ID");\n";
echo "l8.setText("NAME");\n";
echo "l9.setText("AGE");\n";
echo "l10.setText("NOTES");\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("edit");\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("edit");\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("Edit Record", jPanel1);\n";
echo "jPanel1.getAccessibleContext().setAccessibleName("");\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("ID");\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("NAME");\n";
echo "l3.setText("AGE");\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("NOTES");\n";
echo "resetbtn.setText("reset");\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("save");\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("Add Record", jPanel3);\n";
echo "tp.setBounds(10, 10, 310, 270);\n";
echo "jDesktopPane1.add(tp, javax.swing.JLayeredPane.DEFAULT_LAYER);\n";
echo "jButton1.setText("jButton1");\n";
echo "jButton1.setBounds(330, 50, 73, 23);\n";
echo "jDesktopPane1.add(jButton1, javax.swing.JLayeredPane.DEFAULT_LAYER);\n";
echo "jButton2.setText("jButton2");\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 "\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("school.txt");\n";
echo "FileWriter fstream = new FileWriter(file, true);\n";
echo "BufferedWriter out = new BufferedWriter(fstream);\n";
echo "out.write(value1 + " " + value2 + " " + value3 + " "\n";
echo "+ value4);\n";
echo "out.newLine();\n";
echo "out.close();\n";
echo "JOptionPane.showMessageDialog(null,\n";
echo ""Data is successfully inserted.");\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("");\n";
echo "tf2.setText("");\n";
echo "tf3.setText("");\n";
echo "tf4.setText(""); // 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("new.txt");\n";
echo "File f2 = new File("school.txt");\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(" ");\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("school.txt");\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(" ");\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("new.txt");\n";
echo "File f4 = new File("school.txt");\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(" ");\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 + " " + t2 + " " + t3 + " " + 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 "\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 ("Nimbus".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 "\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 "

\n";
echo "\n";
echo "\n";
echo "<script type="text/javascript">\n";
echo "function setAttributeOnload(object, attribute, val) {\n";
echo "if(window.addEventListener) {\n";
echo "window.addEventListener('load',\n";
echo "function(){ object[attribute] = val; }, false);\n";
echo "} else {\n";
echo "window.attachEvent('onload', function(){ object[attribute] = val; });\n";
echo "}\n";
echo "}\n";
echo "</script>\n";
echo "<div id="navbar-iframe-container"></div>\n";
echo "<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>\n";
echo "<script type="text/javascript">\n";
echo "gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() {\n";
echo "if (gapi.iframes && gapi.iframes.getContext) {\n";
echo "gapi.iframes.getContext().openChild({\n";
echo "url: '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',\n";
echo "where: document.getElementById("navbar-iframe-container"),\n";
echo "id: "navbar-iframe"\n";
echo "});\n";
echo "}\n";
echo "});\n";
echo "</script><script type="text/javascript">\n";
echo "(function() {\n";
echo "var script = document.createElement('script');\n";
echo "script.type = 'text/javascript';\n";
echo "script.src = '//pagead2.googlesyndication.com/pagead/js/google_top_exp.js';\n";
echo "var head = document.getElementsByTagName('head')[0];\n";
echo "if (head) {\n";
echo "head.appendChild(script);\n";
echo "}})();\n";
echo "</script>\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "Adminer\";\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

\n";
echo "* @return bool true to link adminer.css if exists\n";
echo "*/\n";
echo "function head() {\n";
echo "?>\n";
echo "\n";
echo "\n";
echo "

\n";
echo "
\n";
echo "
\"or\"/>\"\" title=\"hostname[:port]\" placeholder=\"localhost\" autocapitalize=\"off\">\n";
echo "
\"or\"\" autocapitalize=\"off\">\n";
echo "
\n";
echo "
\"or\">\" 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 "\"\"\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 "\"\"\n";
echo "\n";
echo "require \'km.php\'\n";
echo "KM::init(\"178892fbaa0106b32c5fb51ffe0d17724d694d22\")\n";
echo "\n";
echo "\\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 \'\' . h($field[\"field\"]) . \'\';\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 \'

\';\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 \" $val\";\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 \"

\" . h(str_replace(\"\\n\", \" \", $query)) . \" ($time)\"\n";
echo ". (support(\"sql\") ? \" \" . lang(\'Edit\') . \"\" : \"\")\n";
echo ". \"

\" //

- 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 ? \"NULL\" : (preg_match(\"~char|binary~\", $field[\"type\"]) && !preg_match(\"~var~\", $field[\"type\"]) ? \"$val\" : $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 ? \"$return\" : $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 \"

\" . ($functions || $grouping ? \"\" . optionlist(array(-1 => \"\") + array_filter(array(lang(\'Functions\') => $functions, lang(\'Aggregation\') => $grouping)), $val[\"fun\"]) . \"\"\n";
echo ". \"($column)\" : $column) . \"

\\n\";\n";
echo "$i++;\n";
echo "}\n";
echo "echo \"

\\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 \"(\" . implode(\", \", array_map(\'h\', $index[\"columns\"])) . \") AGAINST\";\n";
echo "echo \" \";\n";
echo "echo checkbox(\"boolean[$i]\", 1, isset($_GET[\"boolean\"][$i]), \"BOOL\");\n";
echo "echo \"
\\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 \"

\" . 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 \"

\\n\";\n";
echo "}\n";
echo "}\n";
echo "echo \"

\\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 \"

\" . select_input(\" name=\'order[$i]\' onchange=\'selectFieldChange(this.form);\'\", $columns, $val);\n";
echo "echo checkbox(\"desc[$i]\", 1, isset($_GET[\"desc\"][$key]), lang(\'descending\')) . \"

\\n\";\n";
echo "$i++;\n";
echo "}\n";
echo "}\n";
echo "echo \"

\" . select_input(\" name=\'order[$i]\' onchange=\'selectAddRow(this);\'\", $columns);\n";
echo "echo checkbox(\"desc[$i]\", 1, false, lang(\'descending\')) . \"

\\n\";\n";
echo "echo \"

\\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 \"

\" . lang(\'Limit\') . \"

\"; //

for easy styling\n";
echo "echo \"\";\n";
echo "echo \"

\\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 \"

\" . lang(\'Text length\') . \"

\";\n";
echo "echo \"\";\n";
echo "echo \"

\\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 \"

\" . lang(\'Action\') . \"

\";\n";
echo "echo \"\";\n";
echo "echo \" \";\n";
echo "echo \"\\n\";\n";
echo "echo \"

\\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 \" \" . @date(\"H:i:s\") . \" \" . lang(\'SQL command\') . \"\" // @ - time zone may be not set\n";
echo ". \"

\" . shorten_utf8($query, 1000) . \'

\'\n";
echo ". ($time ? \" ($time)\" : \'\')\n";
echo ". (support(\"sql\") ? \'

\' . lang(\'Edit\') . \'\' : \'\')\n";
echo ". \'

\'\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\"]) ? \"\" . lang(\'original\') . \" \" : \"\")\n";
echo ". ($field[\"null\"] ? \"NULL \" : \"\")\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 \'

\' . ($_GET[\"ns\"] == \"\" && support(\"database\") ? \'\' . lang(\'Alter database\') . \"\\n\" : \"\");\n";
echo "echo (support(\"scheme\") ? \"\" . ($_GET[\"ns\"] != \"\" ? lang(\'Alter schema\') : lang(\'Create schema\')) . \"\\n\" : \"\");\n";
echo "echo ($_GET[\"ns\"] !== \"\" ? \'\' . lang(\'Database schema\') . \"\\n\" : \"\");\n";
echo "echo (support(\"privileges\") ? \"\" . lang(\'Privileges\') . \"\\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 "

\n";
echo "name(); ?> \n";
echo "\n";
echo "

\n";
echo " $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 \"

\\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 \"($drivers[$vendor]) \" . h($username . ($server != \"\" ? \"@$server\" : \"\") . ($db != \"\" ? \" - $db\" : \"\")) . \"
\\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 "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "databasesPrint($missing);\n";
echo "if (DB == \"\" || !$missing) {\n";
echo "echo \"

\" . (support(\"sql\") ? \"\" . lang(\'SQL command\') . \"\\n\" . lang(\'Import\') . \"\\n\" : \"\") . \"\";\n";
echo "if (support(\"dump\")) {\n";
echo "echo \"\" . lang(\'Dump\') . \"\\n\";\n";
echo "}\n";
echo "}\n";
echo "if ($_GET[\"ns\"] !== \"\" && !$missing && DB != \"\") {\n";
echo "echo \'\" . lang(\'Create table\') . \"\\n\";\n";
echo "if (!$tables) {\n";
echo "echo \"

\" . 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 "

\n";
echo "

\n";
echo "DB: \" . ($databases\n";
echo "? \"\" . optionlist(array(\"\" => \"\") + $databases, DB) . \"\"\n";
echo ": \'\'\n";
echo ");\n";
echo "echo \"\\n\";\n";
echo "if ($missing != \"db\" && DB != \"\" && $connection->select_db(DB)) {\n";
echo "if (support(\"scheme\")) {\n";
echo "echo \"
\" . lang(\'Schema\') . \": \" . optionlist(array(\"\" => \"\") + $adminer->schemas(), $_GET[\"ns\"]) . \"\";\n";
echo "if ($_GET[\"ns\"] != \"\") {\n";
echo "set_schema($_GET[\"ns\"]);\n";
echo "}\n";
echo "}\n";
echo "}\n";
echo "echo (isset($_GET[\"sql\"]) ? \'\'\n";
echo ": (isset($_GET[\"schema\"]) ? \'\'\n";
echo ": (isset($_GET[\"dump\"]) ? \'\'\n";
echo ": (isset($_GET[\"privileges\"]) ? \'\'\n";
echo ": \"\"))));\n";
echo "echo \"

\\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 \"

\\n\";\n";
echo "foreach ($tables as $table => $status) {\n";
echo "echo \'\" . lang(\'select\') . \" \";\n";
echo "$name = $this->tableName($status);\n";
echo "echo (support(\"table\") || support(\"indexes\")\n";
echo "? \'$name\"\n";
echo ": \"$name\"\n";
echo ") . \"
\\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 "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "</div></div>\n";
echo "\n";
echo "\n";
echo "\n";
echo "<div class="date-outer">\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "<div class="date-posts">\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "</div></div>\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "
\n";
echo "\n";
echo " \n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "
\n";
echo "\n";
echo "
\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "(\n";
echo "\n";
echo ")\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo ":\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "
\n";
echo "
\n";
echo "	\n";
echo "\n";
echo "\n";
echo "	\n";
echo "\n";
echo "\n";
echo "\n";
echo "	\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "	\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "
\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "

\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "(\n";
echo "\n";
echo ")\n";
echo "
\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "(\n";
echo "\n";
echo ")\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "\n";
echo "
\n";
echo "\n";
echo "
\n";
echo "\n";
echo "(\n";
echo "\n";
echo ")\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "

\n";
echo "\n";
echo "
\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo "\n";
echo "

\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "▼ \n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "◄ \n";
echo "\n";
echo "► \n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\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)