\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 = "";
/*
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 .= "";
//$cat_name = ereg_replace ( " ", " ", $cat_name );
if(substr_count($cat_name, "FSK 18")>0 AND $_COOKIE["LOGGED_IN_p18"] != "frei")
{
$TPL_categories_value .= " $cat_name"." $cat_counter"." |
\n";
}
else
{
$TPL_categories_value .= " $cat_name"." $cat_counter"."\n";
}
// ###############################################################################################
// BM: Ab hier Unterkategorien der 1. Ebene, wenn gewünscht (siehe config.inc.php)
if ($SHOW_SUBCAT=="1")
{
$query_sub = "select * from categories WHERE parent_id=$cat_id order by cat_name asc";
$result_sub = mysql_query($query_sub);
if(!$result_sub)
{
$TPL_categories_value .= $ERR_001;
}
else
{
$num_cat_sub = mysql_num_rows($result_sub);
$j = 0;
$TPL_categories_value .= "\n";
while($j < $num_cat_sub && $j < 23)
{
$cat_id_sub = mysql_result($result_sub,$j,"cat_id");
$cat_name_sub = mysql_result($result_sub,$j,"cat_name");
$sub_count_sub = intval(mysql_result($result_sub, $j, "sub_counter"));
$cat_colour_sub = mysql_result($result_sub, $j, "cat_colour");
$cat_image_sub = mysql_result($result_sub, $j, "cat_image");
$cat_counter_sub = (int)mysql_result($result_sub, $j, "counter" );
if ($sub_count_sub!=0)
$cat_counter_sub = "(".$sub_count_sub.")";
else
{
$cat_counter_sub = "";
}
$cat_url_sub = "./browse.php?id=$cat_id_sub&SESSION_ID=$sessionIDU";
$TPL_categories_value .= "\n";
if ( $cat_image_sub != "")
{
$TPL_categories_value .= "![](\"$cat_image_sub\") ";
}
$TPL_categories_value .= " | \n";
if ( $cat_colour_sub != "")
{
$TPL_categories_value .= "";
}
else
{
$TPL_categories_value .= " | ";
}
$TPL_categories_value .= "";
//$cat_name = ereg_replace ( " ", " ", $cat_name );
if(substr_count($cat_name, "FSK 18")>0 AND $_COOKIE["LOGGED_IN_p18"] != "frei")
{
$TPL_categories_value .= " $cat_name"." $cat_counter"." |
\n";
}
else
{
$TPL_categories_value .= " $cat_name_sub"." $cat_counter_sub"."\n";
}
$j++;
}
}
// Ende Unterkategorien
// ###############################################################################################
}
$i++;
}
$TPL_categories_value .= "
\n";
if ($num_cat >= 23)
$TPL_categories_value .= "
$MSG_277...";
}
// Auktions- und Benutzerzähler anzeigen
$query = "select * from counters";
$result_counters = mysql_query($query);
if ($result_counters)
{
$num_users = $sml_font."Registrierte Benutzer:
".mysql_result($result_counters,0,"users")."
";
$num_auctions = $sml_font."Laufende Auktionen:
".mysql_result($result_counters,0,"auctions")."
";
}
// Wieviele User sind Online?
$IP=$REMOTE_ADDR;
$HOST=gethostbyaddr($IP);
$time=explode(" ",microtime());
$deletuser = mysql_query("delete from userlog where DATE< $time[1] - 300");
$userlog = mysql_fetch_row(MYSQL_QUERY("SELECT * FROM userlog where IP like '$IP'"));
$User_ID = md5(str_replace(".","",$REMOTE_ADDR)+ mt_rand (10000,999999));
if($userlog== false)
{
$ok= mysql_query("insert INTO userlog (ID,IP,NAME,DATE) VALUES ('$User_ID','$IP','$HOST','$time[1]')")or die( "Unable to query db!");
}
//$deletuser = mysql_query("delete from userlog where DATE< $time[1] - 300");
$resultlogtab = mysql_query(" SELECT Count(*) as total FROM userlog");
$memberlogtab = mysql_fetch_array($resultlogtab);
$num_online = $sml_font."User online:
".$memberlogtab[total]."";
/* Alex's inserted code here*/
$TPL_top_auktion="";
$query = "select * from auctions where topkat='1'and closed=0;";
$result = mysql_query($query);
if ( $result )
$num_auction = mysql_num_rows($result);
else
$num_auction = 0;
if ($num_auction!=0){
if($num_auction<=$alex_max_top_auktion){
$cv=0;
while($cv<$alex_max_top_auktion){
$arr[$cv]=$cv;
$cv++;
}
}
else{
$cv=0;
$xcv=rand(0,$num_auction-$alex_max_top_auktion);
for($kontor=0;$kontor<$alex_max_top_auktion;$kontor++){
$arr[$kontor]=$kontor+$xcv;
}
}
$cv=0;
while($cv<$alex_max_top_auktion && $cv<$num_auction){
$bgcolor="#D891A9";
$title = "";
$id = "";
$date = "";
$picture = 0;
$title = mysql_result($result,$arr[$cv],"title");
$id = mysql_result($result,$arr[$cv],"id");
/////////////////// Ermittelt der Gebotsanzahl
$queryGebote = "select * from bids where auction='$id'";
$resultGebote = mysql_query($queryGebote);
$anz_gebote = mysql_num_rows($resultGebote);
while($rowSB = mysql_fetch_row($resultGebote))
{
$akt_gebot = $rowSB[2];
}
if($akt_gebot=="")
{
$akt_gebot = mysql_result($result,$arr[$cv],"minimum_bid");
}
//////////////////////////////////////////////
$date = mysql_result($result,$arr[$cv],"ends");
$FSK="";
$katid = mysql_result($result,$arr[$cv],"category");
$queryFSK = "Select * from `categories` where `cat_id` = '$katid'";
$resultFSK = mysql_query($queryFSK);
while($rowFSK = mysql_fetch_row($resultFSK))
{
$kattitel = $rowFSK[2];
$pid = $rowFSK[1];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
while($pid != 0)
{
$queryFSK2 = "Select * from `categories` where `cat_id` = '$pid'";
$resultFSK2 = mysql_query($queryFSK2);
while($rowFSK2 = mysql_fetch_row($resultFSK2))
{
$pid = $rowFSK2[1];
$kattitel = $rowFSK2[2];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
}
}
if($FSK != "18" OR $_COOKIE["LOGGED_IN_p18"] == "frei")
{
$pict_url = mysql_result($result,$arr[$cv],"pict_url");
}
else
{
$pict_url = "fsk18.gif";
}
}
$picture = intval(mysql_result($result,$arr[$cv],"photo_uploaded"));
$cv++;
$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);
if($title!=""){
$datumAusgabe = ArrangeDate($day,$month,$year,$hours,$minutes);
$TPL_top_auktion .=
"".
"";
if ($picture != 0)
{
if($FSK == "18" AND $_COOKIE["LOGGED_IN_p18"] != "frei")
{
$TPL_top_auktion.="![](\"/uploaded/".$pict_url."\") ";
}
else
{
$TPL_top_auktion.=" ";
}
}
if($FSK == "18" AND $_COOKIE["LOGGED_IN_p18"] != "frei")
{
$TPL_top_auktion.= " | $sml_font".stripslashes($title).""." | ";
}
else
{
$TPL_top_auktion.= "$sml_font".stripslashes($title).""." | ";
}
$TPL_top_auktion .= "".
" $sml_font".$akt_gebot." EUR".
" | ";
$TPL_top_auktion .= "".
" $sml_font".$anz_gebote."".
" | ";
$TPL_top_auktion .= "".
" $sml_font".$datumAusgabe."".
" |
";
$akt_gebot = "";
}
}
}
/* 1 euro */
$TPL_1euro_auktion="";
$query = "select * from auctions where minimum_bid=1 AND closed=0;";
$result = mysql_query($query);
if ( $result )
$num_auction = mysql_num_rows($result);
else
$num_auction = 0;
if ($num_auction!=0){
if($num_auction<=$alex_max_1euro_auktion){
$cv=0;
while($cv<$alex_max_1euro_auktion){
$arr[$cv]=$cv;
$cv++;
}
}
else{
$cv=0;
$xcv=rand(0,$num_auction-$alex_max_1euro_auktion);
for($kontor=0;$kontor<$alex_max_1euro_auktion;$kontor++){
$arr[$kontor]=$kontor+$xcv;
}
}
$cv=0;
while($cv<$alex_max_1euro_auktion && $cv<$num_auction){
$bgcolor="#F2F7FE";
$title = "";
$id = "";
$date = "";
$picture = 0;
$title = mysql_result($result,$arr[$cv],"title");
$id = mysql_result($result,$arr[$cv],"id");
$date = mysql_result($result,$arr[$cv],"starts");
$katid = mysql_result($result,$arr[$cv],"category");
$queryFSK = "Select * from `categories` where `cat_id` = '$katid'";
$resultFSK = mysql_query($queryFSK);
while($rowFSK = mysql_fetch_row($resultFSK))
{
$kattitel = $rowFSK[2];
$pid = $rowFSK[1];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
while($pid != 0)
{
$queryFSK2 = "Select * from `categories` where `cat_id` = '$pid'";
$resultFSK2 = mysql_query($queryFSK2);
while($rowFSK2 = mysql_fetch_row($resultFSK2))
{
$pid = $rowFSK2[1];
$kattitel = $rowFSK2[2];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
}
}
if($FSK != "18" OR $_COOKIE["LOGGED_IN_p18"] == "frei")
{
$pict_url = mysql_result($result,$arr[$cv],"pict_url");
}
else
{
$pict_url = "fsk18.gif";
}
$FSK = "";
}
$picture = intval(mysql_result($result,$arr[$cv],"photo_uploaded"));
$cv++;
$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);
if($title!=""){
$TPL_1euro_auktion .=
"".
"| ".
"$sml_font".
ArrangeDate($day,$month,$year,$hours,$minutes).
" | ".
"";
if ($picture != 0)
$TPL_1euro_auktion.="![](\"./uploaded/".$pict_url."\") ";
$TPL_1euro_auktion.="$sml_font".stripslashes($title)."".
" | ".
"
";
}
}
}
/* get last created auctions */
$query = "select * from auctions where closed='0' order by starts 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 < 6){
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#F2F7FE";
}
else
{
$bgcolor = "#FFFFFF";
}
$title = mysql_result($result,$i,"title");
$id = mysql_result($result,$i,"id");
$date = mysql_result($result,$i,"starts");
$katid = mysql_result($result,$i,"category");
$queryFSK = "Select * from `categories` where `cat_id` = '$katid'";
$resultFSK = mysql_query($queryFSK);
while($rowFSK = mysql_fetch_row($resultFSK))
{
$kattitel = $rowFSK[2];
$pid = $rowFSK[1];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
while($pid != 0)
{
$queryFSK2 = "Select * from `categories` where `cat_id` = '$pid'";
$resultFSK2 = mysql_query($queryFSK2);
while($rowFSK2 = mysql_fetch_row($resultFSK2))
{
$pid = $rowFSK2[1];
$kattitel = $rowFSK2[2];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
}
}
if($FSK != "18" OR $_COOKIE["LOGGED_IN_p18"] == "frei")
{
$pict_url = mysql_result($result,$i,"pict_url");
}
else
{
$pict_url = "fsk18.gif";
}
$FSK = "";
}
$picture = intval(mysql_result($result,$i,"photo_uploaded"));
$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 .=
"".
"| ".
"$sml_font".
ArrangeDate($day,$month,$year,$hours,$minutes).
" | ".
"";
if ($picture != 0)
$TPL_last_auctions_value .= " ";
$TPL_last_auctions_value.=
"$sml_font".
"".stripslashes($title)."";
$TPL_last_auctions_value .=
" | ".
"
";
$i++;
}
if($num_auction > 6)
{
$TPL_last_auctions_value .= "".
" | ".
"$sml_font$MSG_233...".
" | ".
"
";
}
/* get ending soon auctions */
$TPL_ending_soon_value = "";
$now = date("YmdHis",time());
$query = "select * from 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 < 6){
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#D891A9";
}
else
{
$bgcolor = "#FFFFFF";
}
$title = mysql_result($result,$i,"title");
$id = mysql_result($result,$i,"id");
$startpreis = mysql_result($result,$i,"id");
/////////////////// Ermittelt der Gebotsanzahl
$queryGebote = "select * from bids where auction='$id'";
$resultGebote = mysql_query($queryGebote);
$anz_gebote = mysql_num_rows($resultGebote);
while($rowSB = mysql_fetch_row($resultGebote))
{
$akt_gebot = $rowSB[2];
}
if($akt_gebot=="")
{
$akt_gebot = intval(mysql_result($result,$i,"minimum_bid"));
}
//////////////////////////////////////////////
$FSK = "";
$ends = mysql_result($result,$i,"ends");
$katid = mysql_result($result,$i,"category");
$queryFSK = "Select * from `categories` where `cat_id` = '$katid'";
$resultFSK = mysql_query($queryFSK);
while($rowFSK = mysql_fetch_row($resultFSK))
{
$kattitel = $rowFSK[2];
$pid = $rowFSK[1];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
while($pid != 0)
{
$queryFSK2 = "Select * from `categories` where `cat_id` = '$pid'";
$resultFSK2 = mysql_query($queryFSK2);
while($rowFSK2 = mysql_fetch_row($resultFSK2))
{
$pid = $rowFSK2[1];
$kattitel = $rowFSK2[2];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
}
}
if($FSK != "18" OR $_COOKIE["LOGGED_IN_p18"] == "frei")
{
$pict_url = mysql_result($result,$i,"pict_url");
}
else
{
$pict_url = "fsk18.gif";
}
}
$picture = intval(mysql_result($result,$i,"photo_uploaded"));
$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 .=
"".
"| ";
$katid = mysql_result($result,$arr[$cv],"category");
$queryFSK = "Select * from `categories` where `cat_id` = '$katid'";
$resultFSK = mysql_query($queryFSK);
while($rowFSK = mysql_fetch_row($resultFSK))
{
$kattitel = $rowFSK[2];
$pid = $rowFSK[1];
if(substr_count($kattitel, "FSK 18")>0)
{
$FSK = "18";
}
}
if ($picture != 0)
{
if($FSK == "18" AND $_COOKIE["LOGGED_IN_p18"] != "frei")
{
$TPL_ending_soon_value .= "";
}
else
{
$TPL_ending_soon_value .= "";
}
}
if($FSK == "18" AND $_COOKIE["LOGGED_IN_p18"] != "frei")
{
$TPL_ending_soon_value .= " | $sml_font".stripslashes($title).""." | ";
}
else
{
$TPL_ending_soon_value .= " $sml_font".stripslashes($title).""." | ";
}
$FSK = "";
$i++;
$TPL_ending_soon_value .= "".
" $sml_font".$akt_gebot." EUR".
" | ";
$TPL_ending_soon_value .= "".
" $sml_font".$anz_gebote."".
" | ";
$TPL_ending_soon_value .= "".
" $sml_font".$ends_string."".
" |
";
$akt_gebot = "";
}
if($num_auction > 6)
{
$TPL_ending_soon_value .= "".
"| ".
"$sml_font$MSG_233...".
" | ".
"
";
}
/* get higher bids */
$TPL_maximum_bids = "";
$query = "select auction,max(bid) as max_bid from 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 < 6)
{
$max_bid = mysql_result($result,$i,"max_bid");
$auction = mysql_result($result,$i,"auction");
//-- Get auction data
$query = "select title,closed,id,photo_uploaded from auctions where id=\"$auction\"";
$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");
$picture = mysql_result($result_bid,0,"photo_uploaded");
}
if($closed == "0"){
$TPL_maximum_bids .=
"".
"| ".
"$sml_font".
print_money($max_bid).
" | ".
"";
if ($picture != 0)
$TPL_maximum_bids .= "![](\"images/minipic.gif\") ";
$TPL_maximum_bids .=
"$sml_font".
"".stripslashes($title)."".
" | ".
"
";
$j++;
if($bgcolor == "#FFFFFF")
{
$bgcolor = "#F2F7FE";
}
else
{
$bgcolor = "#FFFFFF";
}
}
$i++;
}
if($num_auction > 6)
{
$TPL_maximum_bids .= "".
" | ".
"$sml_font$MSG_233...".
" | ".
"
";
}
// Build list of help topics
$query = "select topic from 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 news list
if($NEWS_BOX)
{
$query = "SELECT title,id from news where suspended=0 order by new_date limit $NEWS_TO_SHOW";
$res = mysql_query($query);
if(!$res)
{
$TPL_news_list = $ERR_001;
exit;
}
while($new = mysql_fetch_array($res))
{
$TPL_news_list .= "$new[title]
";
}
}
//-- Startseitentext
$query = "SELECT * from welcome";
$res = mysql_query($query);
if(!$res)
{
$TPL_news_list = $ERR_001;
exit;
}
$TPL_headline = stripslashes(mysql_result($res,0,"headline"));
$TPL_message = stripslashes(mysql_result($res,0,"message"));
$TPL_image = $SITE_URL."images/".stripslashes(mysql_result($res,0,"image"));
// -- Ende Startseitentext
require("./templates/template_index_php.html");
require('./footer.php');
?>