\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");
# print $sub_count."
";
$cat_counter = (int)mysql_result($result, $i, "counter" );
if ($sub_count!=0)
$cat_counter = "(".$sub_count.")";
else
{
$cat_counter = "";
/*
if ($cat_counter!=0)
{
$count_string = "(".$cat_counter.")";
}
else
$count_string = "";
*/
}
$cat_url = "./browse.php?id=$cat_id&SESSION_ID=$sessionIDU";
$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 = ereg_replace ( " ", " ", $cat_name );
$TPL_categories_value .= " $cat_name"." $cat_counter"." |
\n";
$i++;
}
$TPL_categories_value .= "\n";
$TPL_categories_value .= "$std_font$MSG_277 ";
}
/* bildvorschau*/
$tplpic .= "";
/* get last created auctions */
$query = "select id,title,date,pict_url from ".$dbfix."_auctions where closed='0' order by date desc";
$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 && $i < 3){
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#EEEEEE";
}
else
{
$bgcolor = "#FFFFFF";
}
$pict_url = mysql_result($result,$i,"pict_url");
$title = mysql_result($result,$i,"title");
$id = mysql_result($result,$i,"id");
$date = mysql_result($result,$i,"date");
$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);
$TPL_last_auctions_value .=" | | ";
$i++;
}
if($num_auction > 3)
{
$TPL_last_auctions_value .= "$sml_font$MSG_233...";
}
/* get ending soon auctions */
$TPL_ending_soon_value = "";
$now = date("YmdHis",time());
$query = "select ends,id,title,pict_url from ".$dbfix."_auctions where closed=\"0\" and
suspended=\"0\" order by ends";
$result = mysql_query($query);
$num_auction = mysql_num_rows($result);
$i = 0;
$bgcolor = "#FFFFFF";
while($i < $num_auction && $i < 3){
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#EEEEEE";
}
else
{
$bgcolor = "#FFFFFF";
}
$pict_url = mysql_result($result,$i,"pict_url");
$title = mysql_result($result,$i,"title");
$id = mysql_result($result,$i,"id");
$ends = mysql_result($result,$i,"ends");
$year = intval(date("Y"));
$month = intval(date("m"));
$day = intval(date("d"));
$hours = intval(date("H"));
$minutes = intval(date("i"));
$seconds = intval(date("s"));
$ends_year = substr($ends,0,4);
$ends_month = substr($ends,4,2);
$ends_day = substr($ends,6,2);
$ends_hours = substr($ends,8,2);
$ends_minutes = substr($ends,10,2);
$ends_seconds = substr($ends,12,2);
$difference = intval(mktime($ends_hours,$ends_minutes,$ends_seconds,$ends_month,$ends_day,$ends_year)) - intval(mktime($hours,$minutes,$seconds,$month,$day,$year));
if ($difference > 0) {
$ends_string = intval($difference / 86400).$MSG_126;
$difference = $difference - (intval($difference / 86400)
* 86400);
$hours_difference = intval($difference / 3600);
if(strlen($hours_difference) == 1){
$hours_difference = "0".$hours_difference;
}
$ends_string .= $hours_difference.":";
$difference = $difference - ($hours_difference * 3600);
$minutes_difference = intval($difference / 60);
if(strlen($minutes_difference) == 1){
$minutes_difference = "0".$minutes_difference;
}
$ends_string .= $minutes_difference.":";
$difference = $difference - ($minutes_difference * 60);
$seconds_difference = $difference;
if(strlen($seconds_difference) == 1){
$seconds_difference = "0".$seconds_difference;
}
$ends_string .= $seconds_difference;
} else {
$ends_string = "$err_font$MSG_911";
}
$TPL_ending_soon_value .=
"
| | ";
$i++;
}
if($num_auction > 3)
{
$TPL_ending_soon_value .= "$sml_font$MSG_233...";
}
/* get higher bids */
$TPL_maximum_bids = "";
$query = "select auction,max(bid) as max_bid from ".$dbfix."_bids group by 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";
while($i < $num_auction && $j < 3){
$max_bid = mysql_result($result,$i,"max_bid");
$auction = mysql_result($result,$i,"auction");
//-- Get auction data
$query = "select title,closed,id,pict_url from ".$dbfix."_auctions where id=\"$auction\"";
$result_bid = mysql_query($query);
$pict_url = mysql_result($result_bid,0,"pict_url");
$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"){
$TPL_maximum_bids .=" | | ";
$j++;
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#EEEEEE";
}
else
{
$bgcolor = "#FFFFFF";
}
}
$i++;
}
if($num_auction > 3)
{
$TPL_maximum_bids .= "$sml_font$MSG_233...";
}
/* get hot auctions */
$TPL_hot_auctions = "";
$query = "select id,minimum_bid,reserve_price,current_bid,pict_url from ".$dbfix."_auctions where closed='0' and minimum_bid<='1.0000' and current_bid<='1.0000' order by minimum_bid";
$result = mysql_query($query);
if ($result)
$num_auction = mysql_num_rows($result);
else
$num_auction = 0;
$i = 0;
$j = 0;
$bgcolor = "#eeeeee";
while($i < $num_auction && $j < 3){
$reserve_price = mysql_result($result,$i,"minimum_bid");
$auction = mysql_result($result,$i,"id");
//-- Get hot_auctions data
$query = "select title,closed,id,pict_url from ".$dbfix."_auctions where id=\"$auction\"";
$hots = mysql_query($query);
$pict_url = mysql_result($hots,0,"pict_url");
$title = mysql_result($hots,0,"title");
$closed = mysql_result($hots,0,"closed");
$auc_id = mysql_result($hots,0,"id");
if($closed == "0"){
$TPL_hot_auctions .="![](\"./uploaded/".$pict_url."\")
".
"".stripslashes($title)." | | ";
$j++;
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#EEEEEE";
}
else
{
$bgcolor = "#FFFFFF";
}
}
$i++;
}
if($num_auction > 3)
{
$TPL_hot_auctions .= "$sml_font$MSG_233...";
}
// Build list of help topics
$query = "select topic from ".$dbfix."_help order by topic;";
$result = mysql_query($query);
if (!$result){
print "$err_font $ERR_001
";
require("footer.php");
exit;
}
if (mysql_num_rows($result)) {
$TPL_helptopics = "" . $MSG_919 . "
";
$num_topics = mysql_num_rows($result);
$i = 0;
while(($i < $num_topics) && ($i < 5)){
$this_topic = mysql_result($result, $i, "topic");
if ($this_topic != "General") {
$TPL_helptopics .= "";
$TPL_helptopics .= $this_topic;
$TPL_helptopics .= "
";
}
$i++;
}
} else {
$TPL_helptopics = "";
}
// Build list of news topics
$query = "select topic from ".$dbfix."_news order by topic;";
$result = mysql_query($query);
if (!$result){
print "$err_font $ERR_001
";
require("footer.php");
exit;
}
if (mysql_num_rows($result)) {
$TPL_newstopics = "" . $MSG_919a . "
";
$num_topics = mysql_num_rows($result);
$i = 0;
while(($i < $num_topics) && ($i < 5)){
$this_topic = mysql_result($result, $i, "topic");
if ($this_topic != "allgemeine Übersicht") {
$TPL_newstopics .= "";
$TPL_newstopics .= $this_topic;
$TPL_newstopics .= "
";
}
$i++;
}
} else {
$TPL_newstopics = "";
}
/* top5 code Anfang */
$result=mysql_query("SELECT auktionsid, zugriff, title, date FROM ".$dbfix."_aufrufzaehler, ".$dbfix."_auctions WHERE ".$dbfix."_aufrufzaehler.auktionsid=".$dbfix."_auctions.id ORDER BY zugriff DESC LIMIT 0,5");
$i=1;
while ($daten=mysql_fetch_array($result)) {
$TPL_toptopics .= "".
"".
$i. ".".$daten[title]."
mit ".$daten[zugriff]." Besuchern
";
$i++;"".
" ";
print "";
}
print "";
/* top5 code ende */
require("templates/index_php3.html");
require('footer.php');
?>