/var/www/html/reviews/index.php
require(BASE_DIR .'/includes/doctype.php');
?>
<html>
<head>
<!-- index.php template -->
<title>HDTV Magazine Reviews</title>
<? if ($feed_url != '') echo '<link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="'. $feed_url .'" />';?>
<meta name="generator" content="http://www.movabletype.org/" />
<meta name="keywords" content="hdtv,hdtv news,hdtv reviews,hdtv information,hdtv articles,hdtv blog,hdtv guide,hdtv listings,hdtv faq,hdtv forum,hdtv forums,hdtv events,hdtv history,hdtv review,hdtv reviews,hdtv reference,hdtv book,hdtv books,hdtv products,hdtv help,hdtv satellite,hdtv cable,hdtv broadcast" />
<meta name="description" content="In-depth technical and consumer reviews on the latest high definition televisions (HDTV), programming and attached peripherals. Get our opinions on video quality, functions, cost and whether the extra features are worth the extra money." />
<? require(BASE_DIR .'/includes/page_header.php');?>
</head>
<body><div id="<?=$container?>">
<? include(BASE_DIR .'/includes/body_header-4.php');?>
<h1>HDTV Magazine Reviews</h1>
<table class="bare" cellpadding="0" cellspacing="0"><tr>
<td id="left">
<? if ($user->data['subscriptions'] & $sub_type) {} else {
if ($user->data['is_registered']) {?>
<div class="important"><span class="corners-top"><span></span></span>
<img src="/images/i_inbox.gif" align="left" style="padding-right:10px" />
<span class="label"><?=$sub_label?>:</span>
<?=$sub_desc_logged_in?>
<span class="corners-bottom"><span></span></span></div>
<?} else {?>
<div class="important"><span class="corners-top"><span></span></span>
<img src="/images/i_inbox.gif" align="left" style="padding-right:10px" />
<span class="label"><?=$sub_label?>:</span>
<?=$sub_desc_anon?>
<span class="corners-bottom"><span></span></span></div>
<? }
}
$sql = "
SELECT DISTINCT entry_blog_id, e.entry_id, entry_excerpt, entry_created_on, entry_title, author_name, topic_replies, aux.topic_id, az.MediumImageURL img
FROM mt_entry e, mt_author a, aux_mt_entry aux
LEFT JOIN ". TOPICS_TABLE ." t ON (aux.topic_id = t.topic_id)
LEFT JOIN az_main az ON (aux.ASIN = az.ASIN)
WHERE entry_author_id = author_id
/var/www/html/reviews/index.php
require(BASE_DIR .'/includes/doctype.php');
?>
<html>
<head>
<!-- index.php template -->
<title>HDTV Magazine Reviews</title>
<? if ($feed_url != '') echo '<link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="'. $feed_url .'" />';?>
<meta name="generator" content="http://www.movabletype.org/" />
<meta name="keywords" content="hdtv,hdtv news,hdtv reviews,hdtv information,hdtv articles,hdtv blog,hdtv guide,hdtv listings,hdtv faq,hdtv forum,hdtv forums,hdtv events,hdtv history,hdtv review,hdtv reviews,hdtv reference,hdtv book,hdtv books,hdtv products,hdtv help,hdtv satellite,hdtv cable,hdtv broadcast" />
<meta name="description" content="In-depth technical and consumer reviews on the latest high definition televisions (HDTV), programming and attached peripherals. Get our opinions on video quality, functions, cost and whether the extra features are worth the extra money." />
<? require(BASE_DIR .'/includes/page_header.php');?>
</head>
<body><div id="<?=$container?>">
<? include(BASE_DIR .'/includes/body_header-4.php');?>
<h1>HDTV Magazine Reviews</h1>
<table class="bare" cellpadding="0" cellspacing="0"><tr>
<td id="left">
<? if ($user->data['subscriptions'] & $sub_type) {} else {
if ($user->data['is_registered']) {?>
<div class="important"><span class="corners-top"><span></span></span>
<img src="/images/i_inbox.gif" align="left" style="padding-right:10px" />
<span class="label"><?=$sub_label?>:</span>
<?=$sub_desc_logged_in?>
<span class="corners-bottom"><span></span></span></div>
<?} else {?>
<div class="important"><span class="corners-top"><span></span></span>
<img src="/images/i_inbox.gif" align="left" style="padding-right:10px" />
<span class="label"><?=$sub_label?>:</span>
<?=$sub_desc_anon?>
<span class="corners-bottom"><span></span></span></div>
<? }
}
$sql = "
SELECT DISTINCT entry_blog_id, e.entry_id, entry_excerpt, entry_created_on, entry_title, author_name, topic_replies, aux.topic_id, az.MediumImageURL img
FROM mt_entry e, mt_author a, aux_mt_entry aux
LEFT JOIN ". TOPICS_TABLE ." t ON (aux.topic_id = t.topic_id)
LEFT JOIN az_main az ON (aux.ASIN = az.ASIN)
WHERE entry_author_id = author_id