beginTrans();
$pdo = $trans->getPDO();
$stmt = $pdo->prepare('SELECT article_id, title, htmltitle, subtitle, adtext, ad_width, image_url, image_alt, meta_keywords, meta_description FROM article WHERE path_text = ?');
$stmt->bindValue(1, $path);
$stmt->execute();
if ($myrow = $stmt->fetch(PDO::FETCH_NUM)) {
$aid = $myrow[0];
$title = $myrow[1];
$htmltitle = $myrow[2];
$subtitle = $myrow[3];
$adtext = $myrow[4];
$adwidth = $myrow[5];
$imageurl = $myrow[6];
$imagealt = $myrow[7];
$metakeywords = $myrow[8];
$metadescription = $myrow[9];
}
else
is404();
?>
= $title ?>
prepare('SELECT content, tag, paragraph_id FROM paragraph WHERE article_id = ? ORDER BY paragraph_id ASC');
$stmt->bindValue(1, $aid);
$stmt->execute();
while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) {
if ($count++ == 9 && $adtext)
$body .= '
'. $adtext .'
'. "\r\n";
$body .= '<'. $myrow[1] .'>'. $myrow[0] .''. $myrow[1] .'>' ."\r\n";
}
$links = '';
$latest = '';
$stmt = $pdo->prepare('SELECT path_text, title, article_id, SUBSTRING(blurb, 1, 84), sm_image_url, image_alt FROM article WHERE status = \'A\' AND article_id != ? ORDER BY article_id DESC LIMIT 5');
$stmt->bindValue(1, $aid);
$stmt->execute();
while ($myrow = $stmt->fetch(PDO::FETCH_NUM)) {
if (!$latest)
$latest = '
'. $myrow[1] .''. "\r\n";
if ($myrow[4])
$links .= '
';
$blurb = $myrow[3];
$links .= ''. $myrow[1] .''. substr($blurb, 0, strrpos($blurb, ' ')) ."...\r\n";
}
?>
'. "\r\n";
?>
= $subtitle ?>
= $body ?>
Latest Article at 10Spot.net: = $latest ?>
prepare('INSERT INTO referer (url, searchval, article_id, hit_date) VALUES (?, ?, ?, CURRENT_TIMESTAMP)');
$stmt->bindValue(1, $referer);
$stmt->bindValue(2, $searchval);
$stmt->bindValue(3, $aid);
$stmt->execute();
}
$useragent = strtolower($_SERVER['HTTP_USER_AGENT']);
if (strpos($useragent, 'googlebot') || strpos($useragent, 'slurp') || strpos($useragent, 'msnbot')) {
$stmt = $pdo->prepare('INSERT INTO referer (url, article_id, hit_date) VALUES (?, ?, CURRENT_TIMESTAMP)');
$stmt->bindValue(1, $useragent);
$stmt->bindValue(1, $aid);
$stmt->execute();
}
$trans->commit(true);
}
catch (Exception $e) {
if ($trans)
$trans->rollback();
}
}
else
is404();
?>