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] .'' ."\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 .= '
!['. $myrow[5] .']('. $myrow[4] .')
';
$blurb = $myrow[3];
$links .= ''. $myrow[1] .''. substr($blurb, 0, strrpos($blurb, ' ')) ."...\r\n";
}
?>
'. "\r\n";
?>
Latest Article at 10Spot.net:
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();
?>