$high_bids = $j > 0 ? true : false;
// Build list of help topics
$query = "SELECT id, category FROM " . $DBPrefix . "faqscat_translated WHERE lang = '" . $language . "' ORDER BY category ASC";
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
$i = 0;
while ($faqscat = mysql_fetch_array($res)) {
$template->assign_block_vars('helpbox', array('ID' => $faqscat['id'], 'TITLE' => $faqscat['category']));
$i++;
}
$helpbox = $i > 0 ? true : false;
// -- Build news list
if ($system->SETTINGS['newsbox'] == 1) {
$query = "SELECT n.title As t, n.new_date, t.* FROM " . $DBPrefix . "news n\r\n\t\t\tLEFT JOIN " . $DBPrefix . "news_translated t ON (t.id = n.id)\r\n\t\t\tWHERE t.lang = '" . $language . "' AND n.suspended = 0\r\n\t\t\tORDER BY new_date DESC, id DESC LIMIT " . $system->SETTINGS['newstoshow'];
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
while ($new = mysql_fetch_array($res)) {
if (!empty($new['title'])) {
$title = stripslashes($new['title']);
} else {
$title = stripslashes($new['t']);
}
$template->assign_block_vars('newsbox', array('ID' => $new['id'], 'DATE' => FormatDate($new['new_date']), 'TITLE' => $title));
}
}
$template->assign_vars(array('FLAGS' => ShowFlags(), 'LOGIN_ERROR' => isset($_SESSION['loginerror']) ? $_SESSION['loginerror'] : '', 'B_AUC_LAST' => $auc_last, 'B_HIGH_BIDS' => $high_bids, 'B_AUC_ENDSOON' => $end_soon, 'B_HELPBOX' => $helpbox, 'B_MULT_LANGS' => count($LANGUAGES) > 1, 'B_LOGIN_BOX' => $system->SETTINGS['loginbox'] == 1, 'B_LOGIN_ERROR' => isset($_SESSION['loginerror']), 'B_NEWS_BOX' => $system->SETTINGS['newsbox'] == 1));
require 'header.php';
$template->set_filenames(array('body' => 'home.html'));
$template->display('body');
require 'footer.php';
unset($_SESSION['loginerror']);
$ends_string = $MSG['911'];
}
$high_bid = $row['num_bids'] == 0 ? $row['minimum_bid'] : $row['current_bid'];
$template->assign_block_vars('hotitems', array('ENDS' => $ends_string, 'ID' => $row['id'], 'BID' => $system->print_money($high_bid), 'IMAGE' => !empty($row['pict_url']) ? 'getthumb.php?w=' . $system->SETTINGS['thumb_show'] . '&fromfile=' . $uploaded_path . $row['id'] . '/' . $row['pict_url'] : 'images/email_alerts/default_item_img.jpg', 'TITLE' => $row['title']));
}
$hot_items = $i > 0 ? true : false;
// Build list of help topics
$query = "SELECT id, category FROM " . $DBPrefix . "faqscat_translated WHERE lang = '" . $language . "' ORDER BY category ASC";
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
$i = 0;
while ($faqscat = mysql_fetch_assoc($res)) {
$template->assign_block_vars('helpbox', array('ID' => $faqscat['id'], 'TITLE' => $faqscat['category']));
$i++;
}
$helpbox = $i > 0 ? true : false;
// Build news list
if ($system->SETTINGS['newsbox'] == 1) {
$query = "SELECT n.title As t, n.new_date, t.* FROM " . $DBPrefix . "news n\n\t\t\tLEFT JOIN " . $DBPrefix . "news_translated t ON (t.id = n.id)\n\t\t\tWHERE t.lang = '" . $language . "' AND n.suspended = 0\n\t\t\tORDER BY new_date DESC, id DESC LIMIT " . $system->SETTINGS['newstoshow'];
$res = mysql_query($query);
$system->check_mysql($res, $query, __LINE__, __FILE__);
while ($new = mysql_fetch_assoc($res)) {
$template->assign_block_vars('newsbox', array('ID' => $new['id'], 'DATE' => FormatDate($new['new_date']), 'TITLE' => !empty($new['title']) ? $new['title'] : $new['t']));
}
}
$template->assign_vars(array('FLAGS' => ShowFlags(), 'B_AUC_LAST' => $auc_last, 'B_HOT_ITEMS' => $hot_items, 'B_AUC_ENDSOON' => $end_soon, 'B_HELPBOX' => $helpbox && $system->SETTINGS['helpbox'] == 1, 'B_MULT_LANGS' => count($LANGUAGES) > 1, 'B_LOGIN_BOX' => $system->SETTINGS['loginbox'] == 1, 'B_NEWS_BOX' => $system->SETTINGS['newsbox'] == 1));
include 'header.php';
$template->set_filenames(array('body' => 'home.tpl'));
$template->display('body');
include 'footer.php';
unset($_SESSION['loginerror']);
