<?php 
  $pieces = explode("/", getcwd());
  $name = end($pieces);
?>
<?php
  $db = mysql_connect('localhost', 'joe', 'fixture');
  $db_selected = mysql_select_db('udn', $db);
  if (!$db or !$db_selected) {
    die('Could not connect: ' . mysql_error());
  }

  $result = mysql_query(sprintf(
    "select * from gallery where name = '%s'",
    mysql_real_escape_string($name)
  ));
  $page = mysql_fetch_assoc($result);

  $result = mysql_query(sprintf("select * from images where gallery_id = %d order by sequence", $page["id"]));
  while ($row = mysql_fetch_assoc($result)) {
    $images[] = $row;
  }

  function title($page) { 
    if ($page["extended_title"]) {
      return $page["title"];
    } else {
      return "The Urinals of " . $page["title"];
    }
  }
?>
<html><head><title><?php print strip_tags(title($page)) ?></title>
<meta property="fb:app_id" content="275918535768793" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-2502101-1");
pageTracker._trackPageview();
} catch(err) {}</script>
</head>
<body bgcolor="black" link="#cc00cc" text="#ffffff" vLink="#bb00bb">
<center>
<h1><?php print title($page) ?></h1>
<h3><?php print $page["subtitle"] ?></h3>
<table border=0>
<tr><td>
<div id="fb-root"></div>
<script>(function(d){
  var js, id = 'facebook-jssdk'; if (d.getElementById(id)) {return;}
  js = d.createElement('script'); js.id = id; js.async = true;
  js.src = "//connect.facebook.net/en_US/all.js#appId=275918535768793&xfbml=1";
  d.getElementsByTagName('head')[0].appendChild(js);
}(document));</script>
<div class="fb-like" data-send="true" data-width="360" data-show-faces="false" data-colorscheme="dark" data-font="arial"></div>
</td><td>
<a href="http://twitter.com/share" class="twitter-share-button" data-count="horizontal" data-via="urinal_dot_net">Tweet</a><script type="text/javascript" src="http://platform.twitter.com/widgets.js"></script>
</td><td>
<!-- Place this tag where you want the +1 button to render -->
<div class="g-plusone" data-annotation="inline" data-width="200" data-href="www.urinal.net"></div>

<!-- Place this render call where appropriate -->
<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
  })();
</script>

</td></tr></table>
<table><tr valign="top"><td>
  <table width="640">
<?php
  function draw_image($image) {
    printf("<tr align=\"center\"><td><img src=\"%s\" width=\"%d\" height=\"%d\"></td></tr>\n", 
      $image["src"], $image["width"], $image["height"]);
    printf("<tr align=\"center\"><td><br>%s</td></tr>\n", $image["comment"]);
  }
  $total_image_height = 0;
  foreach ($images as $image) {
    draw_image($image);
    $total_image_height += $image["height"];
  }
?>
  <tr align="center" height="10"><td>&nbsp;</td></tr>
  <tr align="center"><td><small><?php print $page["contributor"] ?></small></td></tr>
<tr align="center"><td>
<div id="fb-root"></div>
<script>(function(d){
  var js, id = 'facebook-jssdk'; if (d.getElementById(id)) {return;}
  js = d.createElement('script'); js.id = id; js.async = true;
  js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";
  d.getElementsByTagName('head')[0].appendChild(js);
}(document));</script>
<div class="fb-comments" data-href="urinal.net<?php print $_SERVER['REQUEST_URI'] ?>" data-num-posts="2" data-width="800" data-colorscheme="dark"></div>
</td></tr>
<tr align="center"><td><p><a href="/"><img src="/back.gif" width="39" height="52" border="0"></a></p> </td></tr>
  </table>
</td><td width="20">&nbsp;</td><td>
<!-- BEGIN GOOGLE AD -->
<script type="text/javascript">
<!--
google_ad_client = "pub-6615147015841932";
<?php
  if ($total_image_height > 320) {
    print <<<EOF
google_ad_width = 160;
google_ad_height = 600;
google_ad_format = "160x600_as";
EOF;
  } else {
    print <<<EOF
google_ad_width = 120;
google_ad_height = 240;
google_ad_format = "120x240_as";
EOF;
  }
?>
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "222222";
google_color_bg = "000000";
google_color_link = "cc00cc";
google_color_url = "ffffff";
google_color_text = "ffffff";
//--></script>
<script type="text/javascript"
src=" http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<!-- END GOOGLE AD -->

</td></tr></table>

</center>
<p><font size=1><a href="/copyright.html">Copyright <?php print $page["copyright"] ?> - URINAL.NET</a></font></p>
</body></html>
<?
  mysql_close($db);
?>

