\n";
while($i < $num_cat && $i < 23) {
$cat_id = mysql_result($result,$i,"cat_id");
$cat_name = mysql_result($result,$i,"cat_name");
$sub_count = intval(mysql_result($result, $i, "sub_counter"));
$cat_colour = mysql_result($result, $i, "cat_colour");
$cat_image = mysql_result($result, $i, "cat_image");
$cat_counter = (int)mysql_result($result, $i, "counter" );
if ($sub_count!=0) $cat_counter = "(".$sub_count.")";
else {
$cat_counter = "";
}
$cat_url = "./browse.php?id=$cat_id";
$TPL_categories_value .= "\n";
if ( $cat_image != "") {
$TPL_categories_value .= "![](\"$cat_image\") ";
}
$TPL_categories_value .= " | \n";
if ( $cat_colour != "") {
$TPL_categories_value .= "";
} else {
$TPL_categories_value .= " | ";
}
$TPL_categories_value .= $std_font."$cat_name".$std_font." $cat_counter"." |
\n";
$i++;
}
$TPL_categories_value .= "\n";
$TPL_categories_value .= $std_font."$MSG_277";
}
#// ####################################################################################################################
#// FEATURED ITEMS
#// Retrieve additional fees cost
$query = "SELECT * FROM PHPAUCTIONREVERSE_additionalfees";
$result = @mysql_query($query);
if(!$result) {
MySQLError($query);
exit;
} else {
$ADDITIONALFEES = @mysql_fetch_array($result);
}
$query = "SELECT auction.id,
auction.title,
auction.starts,
auction.ends,
auction.minimum_bid,
featured.auction,
featured.bold,
featured.highlighted
FROM
PHPAUCTIONREVERSE_auctions auction,
PHPAUCTIONREVERSE_featured featured
WHERE
auction.private='n' AND
auction.closed='0' AND
auction.suspended=0 AND
featured.featured='y' AND
auction.id=featured.auction AND
starts<='".$NOW."'
GROUP BY auction.id
ORDER BY RAND()
LIMIT ".$SETTINGS['featureditemsnumber'];
$result = mysql_query($query);
if(!$result) {
MySQLError($query);
exit;
} elseif(mysql_num_rows($result) > 0) {
while($row = mysql_fetch_array($result)) {
if($row['current_bid'] == 0) {
$row['current_bid'] = $row['minimum_bid'];
}
if($row['pict_url'] == "") {
$row['pict_url'] = "images/nopicture.gif";
} elseif($row['photo_uploaded'] != '0') {
$row['pict_url'] = "getthumb.php?w=".$SETTINGS['thimbnailswidth']."&fromfile=$uploaded_path".$row['pict_url'];
}
$_FEATURED_ID[] = $row;
}
}
#// ####################################################################################################################
/* get last created auctions */
$query = "select id,title,starts from PHPAUCTIONREVERSE_auctions
WHERE
closed='0' AND
suspended=0 AND
private='n' AND
starts<=".$NOW."
ORDER BY starts DESC
LIMIT ".$SETTINGS['lastitemsnumber'];
$result = mysql_query($query);
if ( $result ) $num_auction = mysql_num_rows($result);
else $num_auction = 0;
$i = 0;
$bgcolor = "#FFFFFF";
$TPL_last_auctions_value = "";
while($i < $num_auction) {
if($bgcolor == "#FFFFFF") {
$bgcolor = $FONTCOLOR[$SETTINGS['headercolor']];
} else {
$bgcolor = "#FFFFFF";
}
$title = mysql_result($result,$i,"title");
$id = mysql_result($result,$i,"id");
$date = mysql_result($result,$i,"starts");
$year = substr($date,0,4);
$month = substr($date,4,2);
$day = substr($date,6,2);
$hours = substr($date,8,2);
$minutes = substr($date,10,2);
$seconds = substr($date,12,2);
#// Check bold and highlighted options
$ISBOLD = FALSE;
$ISHIGHLIGHTED = FALSE;
$query = "SELECT bold,highlighted
FROM PHPAUCTIONREVERSE_featured
WHERE auction='$id'";
$_r_ = mysql_query($query);
if(!$_r_) {
MySQLError($query);
exit;
} elseif(mysql_num_rows($_r_) > 0) {
if(mysql_result($_r_,0,"bold") == 'y') $ISBOLD = TRUE;
if(mysql_result($_r_,0,"highlighted") == 'y') $ISHIGHLIGHTED = TRUE;
}
$TPL_last_auctions_value .="
| $std_font".ArrangeDateNoCorrection($day,$month,$year,$hours,$minutes)." |
$std_font";
if($ISHIGHLIGHTED) {
$TPL_last_auctions_value .= "";
}
if($ISBOLD) {
$TPL_last_auctions_value .= "";
}
$TPL_last_auctions_value .= stripslashes($title);
if($ISBOLD) {
$TPL_last_auctions_value .= "";
}
if($ISHIGHLIGHTED) {
$TPL_last_auctions_value .= "";
}
$TPL_last_auctions_value .= " |
";
$i++;
}
/* get ending soon auctions */
$TPL_ending_soon_value = "";
$query = "select ends,id,title from PHPAUCTIONREVERSE_auctions
WHERE closed='0' AND
suspended='0' AND
private='n' AND
starts<=".$NOW."
order by ends LIMIT ".$SETTINGS['endingsoonnumber'];
$result = mysql_query($query);
$num_auction = mysql_num_rows($result);
$i = 0;
$bgcolor = "#FFFFFF";
while($i < $num_auction) {
if($bgcolor == "#FFFFFF") {
$bgcolor = $FONTCOLOR[$SETTINGS['headercolor']];
} else {
$bgcolor = "#FFFFFF";
}
$title = mysql_result($result,$i,"title");
$id = mysql_result($result,$i,"id");
$ends = mysql_result($result,$i,"ends");
$nowt = $TIME;
$difference = mktime( substr ($ends, 8, 2),
substr ($ends, 10, 2),
substr ($ends, 12, 2),
substr ($ends, 4, 2),
substr ($ends, 6, 2),
substr ($ends, 0, 4))-$nowt;
if ($difference > 0) {
$days_difference = floor($difference / 86400);
$difference = $difference % 86400;
$hours_difference = floor($difference / 3600);
$difference = $difference % 3600;
$minutes_difference = floor($difference / 60);
$seconds_difference = $difference % 60;
$ends_string = sprintf("%d%s %02dh:%02dm:%02ds",$days_difference,$MSG_126, $hours_difference,$minutes_difference,$seconds_difference);
} else {
$ends_string = "$err_font$MSG_911";
}
#// Check bold and highlighted options
$ISBOLD = FALSE;
$ISHIGHLIGHTED = FALSE;
$query = "SELECT bold,highlighted
FROM PHPAUCTIONREVERSE_featured
WHERE auction='$id'";
$_r_ = mysql_query($query);
if(!$_r_) {
MySQLError($query);
exit;
} elseif(mysql_num_rows($_r_) > 0) {
if(mysql_result($_r_,0,"bold") == 'y') $ISBOLD = TRUE;
if(mysql_result($_r_,0,"highlighted") == 'y') $ISHIGHLIGHTED = TRUE;
}
$TPL_ending_soon_value .= "
| $std_font $ends_string |
$std_font";
if($ISHIGHLIGHTED) {
$TPL_ending_soon_value .= "";
}
if($ISBOLD) {
$TPL_ending_soon_value .= "";
}
$TPL_ending_soon_value .= stripslashes($title);
if($ISBOLD) {
$TPL_ending_soon_value .= "";
}
if($ISHIGHLIGHTED) {
$TPL_ending_soon_value .= "";
}
$TPL_ending_soon_value .= "
|
";
$i++;
}
/**
* NOTE: get higher bids
*/
$TPL_maximum_bids = "";
$query = "select auction,max(bid) AS max_bid
FROM PHPAUCTIONREVERSE_bids GROUP BY bid,auction order by max_bid desc";
$result = mysql_query($query);
if ($result) $num_auction = mysql_num_rows($result);
else $num_auction = 0;
$i = 0;
$j = 0;
$bgcolor = "#FFFFFF";
$AU = array();
while($i < $num_auction && $j < $SETTINGS['higherbidsnumber']) {
$max_bid = mysql_result($result,$i,"max_bid");
$auction = mysql_result($result,$i,"auction");
//-- Get auction data
$query = "SELECT title,closed,id from PHPAUCTIONREVERSE_auctions
WHERE id=\"$auction\"
AND private='n'
AND '".$NOW."'>=starts";
//print $query;
$result_bid = mysql_query($query);
if(mysql_num_rows($result_bid) > 0) {
$title = mysql_result($result_bid,0,"title");
$closed = mysql_result($result_bid,0,"closed");
$auc_id = mysql_result($result_bid,0,"id");
}
if($closed == "0" && !in_array($auction,$AU)) {
#// Check bold and highlighted options
$ISBOLD = FALSE;
$ISHIGHLIGHTED = FALSE;
$query = "SELECT bold,highlighted
FROM PHPAUCTIONREVERSE_featured
WHERE auction='$auc_id'";
$_r_ = mysql_query($query);
if(!$_r_) {
MySQLError($query);
exit;
} elseif(mysql_num_rows($_r_) > 0) {
if(mysql_result($_r_,0,"bold") == 'y') $ISBOLD = TRUE;
if(mysql_result($_r_,0,"highlighted") == 'y') $ISHIGHLIGHTED = TRUE;
}
$TPL_maximum_bids .=
"
|
$std_font"
.print_money ($max_bid)."
|
$std_font";
if($ISHIGHLIGHTED) {
$TPL_maximum_bids .= "";
}
if($ISBOLD) {
$TPL_maximum_bids .= "";
}
$TPL_maximum_bids .= stripslashes($title);
if($ISBOLD) {
$TPL_maximum_bids .= "";
}
if($ISHIGHLIGHTED) {
$TPL_maximum_bids .= "";
}
$TPL_maximum_bids .= " |
";
if($bgcolor == "#FFFFFF") {
$bgcolor = $FONTCOLOR[$SETTINGS['headercolor']];
} else {
$bgcolor = "#FFFFFF";
}
$AU[] = $auction;
$j++;
}
$i++;
}
// Build list of help topics
$query = "SELECT * FROM PHPAUCTIONREVERSE_faqscategories";
$r_h = @mysql_query($query);
if(!$r_h) {
MySQLError($query);
exit;
}
if(mysql_num_rows($r_h) > 0) {
while($faqscat = mysql_fetch_array($r_h)) {
$faqscat['category']=stripslashes($faqscat['category']);
$TPL_helptopics .= " ";
$TPL_helptopics .= "
".$faqscat['category']."
";
}
} else {
$TPL_helptopics = " ";
}
//-- Build news list
if($SETTINGS['newsbox'] == 1) {
$query = "SELECT title,id,new_date from PHPAUCTIONREVERSE_news where suspended=0 order by new_date DESC limit ".$SETTINGS['newstoshow'];
$res = mysql_query($query);
if(!$res) {
MySQLError($query);
exit;
}
$TPL_news_list = "";
while($new = mysql_fetch_array($res)) {
$new['title'] = stripslashes($new['title']);
$new_date= $new['new_date'];
$F_date = FormatDate($new_date);
$TPL_news_list .= " ";
$TPL_news_list .= " $sml_font".$new['title']."
$F_date
";
}
} else {
$TPL_news_list = " ";
}
require("./templates/template_index_php.html");
require('./footer.php');
?>