/var/www/html/includes/lib_common.php
"\n".
"You are receiving this email because you are a registered member of HDTV Magazine and you have chosen to receive these types of updates per your profile:\n".
FULL_URL_PROFILE ."\n".
"\n".
"For best viewing of future emails, please add ". $admindata[email_reply_address] ." to your Safe Senders List or Address Book.\n".
"\n".
"This email was sent by: ". $admindata[company_name] ."\n".
$admindata[street_address] ."\n".
$admindata[city] .", ". $admindata[state_province] .", ". $admindata[zip_postal_code] ." ". $admindata[country] ."\n".
"\n".
$unsub_text .
"\n";
return $m;
}
function getTabHeader($tabs) {
$tab_header = '<div id="tabs"><ul>';
foreach ($tabs as $label => $url) {
if (basename($_SERVER[SCRIPT_NAME]) == strleft(basename($url) .'?', '?')) {
$tab_header .= "<li><a class='tab-selected' href='#' title='$label'><span>$label</span></a></li>";
} else {
$tab_header .= "<li><a href='$url' title='$label'><span>$label</span></a></li>";
}
}
$tab_header .= '</ul></div>';
return $tab_header;
}
function js_alert($text) {
echo '<html lang="en"><body><script language="javascript" type="text/javascript">'.
' alert(\''. $text .'\');'.
'</script></body></html>';
}
function js_back($text = '') {
echo '<html lang="en"><body><script language="javascript" type="text/javascript">';
if ($text != '') echo 'alert(\''. $text .'\');';
/var/www/html/equipment/hdtvs-best-rated.php
require('hdtvs-overall_header.php');
require(BASE_DIR .'/includes/doctype.php');
?>
<html>
<head>
<title>HDTV Magazine - Best Rated HDTVs</title>
<? require(BASE_DIR .'/includes/page_header.php');?>
</head>
<body><div id="body_container">
<?
include(BASE_DIR .'/includes/body_header-4.php');
?>
<h1>Best Rated HDTVs</h1>
<? include('hdtvs-page_header.php');?>
<div style="display:table;">
<?=getTabHeader($tabs);?>
<div class="tab-content">
The Best HDTVs based on consumer rating. These include HDTVs available within the past <?=$update_days?> days and with at least 2 reviews (number of reviews listed in parenthesis).<br />
<br />
<?
$types = array(
'LCD' => 'subtype = '. MODEL_TYPE_LCD,
'Plasma' => 'subtype = '. MODEL_TYPE_PLASMA,
'DLP' => 'subtype = '. MODEL_TYPE_DLP,
'LCoS' => 'subtype = '. MODEL_TYPE_LCOS,
'CRT' => 'subtype = '. MODEL_TYPE_CRT,
);
echo '<table class="bare">';
foreach ($types as $key => $clause) {
$sql = "
SELECT a.ASIN, Manufacturer, Model, Title, TotalNew, TotalUsed, ListPrice, LowestNewPrice, LowestUsedPrice, AverageRating, TotalReviews, SmallImageURL as image_url
FROM az_main m, az_attributes a, az_aux aux
WHERE m.ASIN = a.ASIN
AND m.ASIN = aux.ASIN
AND $clause
AND ListPrice > 0