<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="/new.css">
<?php
include "ddfuncs/ad2.php";
require('../setClassPath.php');
require_once('db/TransManager.php');
require_once('util/InputHelper.php');

$input = InputHelper::getInstance();
$trans = TransManager::getInstance();

$cookieval      = $input->fullySanitize($_COOKIE['mystic']);
$jokepath       = $input->fullySanitize($_GET['joke_path']);

$trans->beginTrans();
$pdo = $trans->getPDO();

if (strlen($jokepath) != 0) {
    $stmt = $pdo->prepare('SELECT title, body FROM joke WHERE joke_path = ?');
    $stmt->bindParam(1, $jokepath);
    $stmt->execute();
    if ($myrow = $stmt->fetch(PDO::FETCH_NUM)) {
        $title  = $myrow[0];
        $body   = $myrow[1];
?>
<title>Dating Joke - <?= $title ?></title>
<script type="text/javascript">
var _gaq=_gaq||[];_gaq.push(['_setAccount','UA-628020-4']);_gaq.push(['_trackPageview']);(function(){var ga=document.createElement('script');ga.type='text/javascript';ga.async=true;ga.src=('https:'==document.location.protocol?'https://ssl':'http://www')+'.google-analytics.com/ga.js';var s=document.getElementsByTagName('script')[0];s.parentNode.insertBefore(ga,s);})();
</script>
</head>
<body>

<div class="box full" style="background-color: #ffddcc;">
<h1><?= $title ?></h1>
<a href="/">Dating Diversions</a> | 
<a href="/advice.html">Dating Advice</a> | 
<a href="/stories.mv">Dating Stories</a> | 
<a href="/dating_jokes.html">More Jokes</a> | 
<a href="/singles-US/main.html">Geographical Dating Tips</a> | 
<a href="/gift_ideas.html">Great Gift Ideas</a>
</div>

<div class="boxt fullnp">
  <div class="boxtr rside flr ctr">
    <?= getAd($cookieval, '120x600', 'f', $pdo) ?>
  </div>
  <div class="main pad">
    <?= $body ?>
    <hr>
    <div class="ctr">
      <?= getAd($cookieval, '468x60', 'f', $pdo) ?>
    </div>
  </div>
</div>
View our <a href="/privacy.html">Privacy Policy</a>

</body></html>
<?php
    }
}
else {
?>
<title>Dating Jokes at Dating Diversions</title>
<script type="text/javascript">
var _gaq=_gaq||[];_gaq.push(['_setAccount','UA-628020-4']);_gaq.push(['_trackPageview']);(function(){var ga=document.createElement('script');ga.type='text/javascript';ga.async=true;ga.src=('https:'==document.location.protocol?'https://ssl':'http://www')+'.google-analytics.com/ga.js';var s=document.getElementsByTagName('script')[0];s.parentNode.insertBefore(ga,s);})();
</script>
</head>
<body>

<div class="box full" style="background-color: #ffddcc;">
<h1>Dating and Relationship Jokes</h1>
<a href="/">Dating Diversions</a> | 
<a href="/advice.html">Dating Advice</a> | 
<a href="/stories.mv">Dating Stories</a> | 
<a href="/singles-US/main.html">Geographical Dating Tips</a> | 
<a href="/gift_ideas.html">Great Gift Ideas</a>
</div>

<div class="boxt fullnp">
  <div class="boxtr rside flr ctr">
    <?= getAd($cookieval, '120x240', 'f', $pdo) ?>
  </div>
  <div class="main pad">
<?php
    $stmt = $pdo->prepare('SELECT joke_path, title, description FROM joke');
    $stmt->execute();
    while ($myrow = $stmt->fetch(PDO::FETCH_NUM))
        printf("<a href=\"/%s/joke.html\">%s</a> - %s<br>\r\n", $myrow[0], $myrow[1], $myrow[2]);
?>
    <hr>
    <div class="ctr">
      <?= getAd($cookieval, '468x60', 'f', $pdo) ?>
    </div>
  </div>
</div>
View our <a href="/privacy.html">Privacy Policy</a>

</body></html>
<?php
}
$trans->commit();
$trans->disconnect();
?>
