\n"; while($i < $num_cat && $i < 32) { $cat_id = mysql_result($result,$i,"cat_id"); $cat_name = stripslashes(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 ="./liste_auktion.php?cat=$cat_id"; $TPL_categories_value .= "\n"; if ( $cat_image != "") { $TPL_categories_value .= ""; } $TPL_categories_value .= "\n"; if ( $cat_colour != "") { $TPL_categories_value .= ""; } else { $TPL_categories_value .= ""; } $TPL_categories_value .= " $cat_name\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 < 32) { $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 = "./liste_auktion.php?cat=$cat_id_sub"; $TPL_categories_value .= "\n\n"; if ( $cat_colour_sub != "") { $TPL_categories_value .= "\n"; $j++; } } // Ende Unterkategorien // ############################################################################################### } $i++; } $TPL_categories_value .= "
"; $TPL_categories_value .= ""; } else { $TPL_categories_value .= ""; } $TPL_categories_value .= ""; //$cat_name = ereg_replace ( " ", " ", $cat_name ); $TPL_categories_value .= "  $cat_name_sub"." $cat_counter_sub"."
\n"; if ($num_cat >= 32) $TPL_categories_value .= "
$MSG_277..."; } // Auktions- und Benutzerzähler anzeigen $query = "select * from counters"; $result_counters = mysql_query($query); if ($result_counters) /* { $num_users = mysql_result($result_counters,0,"users"); $num_auctions = mysql_result($result_counters,0,"auctions"); } */ // Topkat-Auktionen holen $query = "SELECT * FROM auctions WHERE closed='0' AND topkat='1' ORDER BY starts DESC"; $result = mysql_query($query); if ( $result ) $num_auction = mysql_num_rows($result); else $num_auction = 0; $i = 0; $bgcolor = "#F2F2F9"; $TPL_last_auctions_value = ""; while($i < $num_auction && $i < 15) { if($bgcolor == "#FFFFFF") { $bgcolor = "#F2F2F9"; } else { $bgcolor = "#F2F2F9"; } $title = mysql_result($result,$i,"title"); $id = mysql_result($result,$i,"id"); $date = mysql_result($result,$i,"ends"); $price = print_Money(mysql_result($result,$i,"price")); $picture = intval(mysql_result($result,$i,"photo_uploaded")); $year = substr($date,0,4); $month = substr($date,5,2); $day = substr($date,8,2); $hours = substr($date,11,2); $minutes = substr($date,14,2); $seconds = substr($date,17,2); if(strlen($title)>25){ $title = substr($title, 0, 15)."..."; } $TPL_last_auctions_value.= "". "". ""; if ($picture != 0) $TPL_last_auctions_value.="     "; $TPL_last_auctions_value.="".strip_tags(stripslashes($title)).""; $TPL_last_auctions_value .= ""; $i++; } // 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")."

"; }*/ // Startseiten-Auktionen ****************************************************************** mt_srand((double)microtime()*1000000); $zufall = mt_rand(0,9); if ($zufall == 0) $order = "id"; elseif ($zufall == 1) $order = "title"; elseif ($zufall == 2) $order = "ends"; elseif ($zufall == 3) $order = "current_bid"; elseif ($zufall == 4) $order = "starts"; else $order = "user"; //$query = "SELECT * FROM auctions WHERE closed='0' AND startseite='1' ORDER BY ".$order." desc"; $query = "SELECT * FROM auctions WHERE closed='0' AND startseite='1' ORDER BY rand() desc"; $result = mysql_query($query); if ($result) { $num_auction = mysql_num_rows($result); $i = 0; while ($i<$num_auction) { $galerie_ort[$i] = mysql_result($result,$i,"location"); $galerie_id[$i] = mysql_result($result, $i, "id"); $galerie_pic[$i] = mysql_result($result, $i, "pict_url"); $galerie_title[$i] = strip_tags(stripslashes(mysql_result($result, $i, "title"))); $galerie_price[$i] = mysql_result($result, $i, "current_bid"); $galerie_phu[$i] = mysql_result($result, $i, "photo_uploaded"); if ($galerie_price[$i]==0) $galerie_price[$i] = mysql_result($result, $i, "minimum_bid"); if ($galerie_pic[$i]=="") $galerie_pic[$i] = "no_pic.gif"; if (!$galerie_phu[$i]) $galerie_pic[$i] = "no_preview.gif"; $galerie_pic[$i] = $thumb_path.$galerie_pic[$i]; $i++; } $tpl = ""; // 1. Zeile -------------------------------------------- if ($num_auction>=1) { $scale1 = get_imageprops($galerie_pic[0],100); $tpl_bild1 = ""; $tpl_bild1.= "
\n"; if (strlen($galerie_title[0])>40) $galerie_title[0] = substr($galerie_title[0],0,40)."..."; $tpl_txt1.= "".$galerie_title[0]."
\n"; $tpl_txt12.= print_money($galerie_price[0])."
\n"; $tpl_txt13.= $galerie_ort[0]. " "; $tpl_txt1.= "
\n"; } else { $tpl_bild1 = ""; $tpl_txt1 = ""; } if ($num_auction>=2) { $scale2 = get_imageprops($galerie_pic[1],150); $tpl_bild2 = ""; $tpl_bild2.= "
\n"; if (strlen($galerie_title[1])>40) $galerie_title[1] = substr($galerie_title[1],0,40)."..."; $tpl_txt2.= "".$galerie_title[1]."
\n"; $tpl_txt22.= print_money($galerie_price[1])."
\n"; $tpl_txt23.= $galerie_ort[1]. " "; $tpl_txt2.= "
\n"; } else { $tpl_bild2 = ""; $tpl_txt2 = ""; } if ($num_auction>=3) { $scale3 = get_imageprops($galerie_pic[2],150); $tpl_bild3 = ""; $tpl_bild3.= "
\n"; if (strlen($galerie_title[2])>40) $galerie_title[2] = substr($galerie_title[2],0,40)."..."; $tpl_txt3.= "".$galerie_title[2]."
\n"; $tpl_txt32.= print_money($galerie_price[2])."
\n"; $tpl_txt33.= $galerie_ort[2]. " "; $tpl_txt3.= "
\n"; } else { $tpl_bild3 = ""; $tpl_txt3 = ""; } // 2. Zeile -------------------------------------------- if ($num_auction>=4) { $scale4 = get_imageprops($galerie_pic[3],150); $tpl_bild4 = ""; $tpl_bild4.= "
\n"; if (strlen($galerie_title[3])>40) $galerie_title[3] = substr($galerie_title[3],0,40)."..."; $tpl_txt4.= "".$galerie_title[3]."
\n"; $tpl_txt42.= print_money($galerie_price[3])."
\n"; $tpl_txt43.= $galerie_ort[3]. " "; $tpl_txt4.= "
\n"; } else { $tpl_bild4 = ""; $tpl_txt4 = ""; } if ($num_auction>=5) { $scale5 = get_imageprops($galerie_pic[4],150); $tpl_bild5 = ""; $tpl_bild5.= "
\n"; if (strlen($galerie_title[4])>40) $galerie_title[4] = substr($galerie_title[4],0,40)."..."; $tpl_txt5.= "".$galerie_title[4]."
\n"; $tpl_txt52.= print_money($galerie_price[4])."
\n"; $tpl_txt53.= $galerie_ort[4]. " "; $tpl_txt5.= "
\n"; } else { $tpl_bild5 = ""; $tpl_txt5 = ""; } if ($num_auction>=6) { $scale6 = get_imageprops($galerie_pic[5],150); $tpl_bild6 = ""; $tpl_bild6.= "
\n"; if (strlen($galerie_title[5])>40) $galerie_title[5] = substr($galerie_title[5],0,40)."..."; $tpl_txt6.= "".$galerie_title[5]."
\n"; $tpl_txt62.= print_money($galerie_price[5])."
\n"; $tpl_txt63.= $galerie_ort[5]. " "; $tpl_txt6.= "
\n"; } else { $tpl_bild6 = ""; $tpl_txt6 = ""; } // 3. Zeile -------------------------------------------- if ($num_auction>=7) { $scale7 = get_imageprops($galerie_pic[6],150); $tpl_bild7 = ""; $tpl_bild7.= "
\n"; if (strlen($galerie_title[6])>40) $galerie_title[6] = substr($galerie_title[6],0,40)."..."; $tpl_txt7.= "".$galerie_title[6]."
\n"; $tpl_txt72.= print_money($galerie_price[6])."
\n"; $tpl_txt73.= $galerie_ort[6]. " "; $tpl_txtd7.= "
\n"; } else { $tpl_bild7 = ""; $tpl_txt7 = ""; } if ($num_auction>=8) { $scale8 = get_imageprops($galerie_pic[7],150); $tpl_bild8 = ""; $tpl_bild8.= "
\n"; if (strlen($galerie_title[7])>40) $galerie_title[7] = substr($galerie_title[7],0,40)."..."; $tpl_txt8.= "".$galerie_title[7]."
\n"; $tpl_txt82.= print_money($galerie_price[7])."
\n"; $tpl_txt83.= $galerie_ort[7]. " "; $tpl_txt8.= "
\n"; } else { $tpl_bild8 = ""; $tpl_txt8 = ""; } if ($num_auction>=9) { $scale9 = get_imageprops($galerie_pic[8],150); $tpl_bild9 = ""; $tpl_bild9.= "
\n"; if (strlen($galerie_title[8])>40) $galerie_title[8] = substr($galerie_title[8],0,40)."..."; $tpl_txt9.= "".$galerie_title[8]."
\n"; $tpl_txt92.= print_money($galerie_price[8])."
\n"; $tpl_tx93.= $galerie_ort[8]. " "; $tpl_txt9.= "
\n"; } else { $tpl_bild9 = ""; $tpl_txt9 = ""; } } $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 = ""; } // News anzeigem 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; } $TPL_news_list = ""; while($row = mysql_fetch_array($res)) { $TPL_news_list .= "• 
$row[title]
\n"; } } // Startseitentext $query = "SELECT * FROM welcome"; $res = mysql_query($query); if(!$res) { $TPL_headline = $ERR_001; exit; } $TPL_headline = stripslashes(mysql_result($res,0,"headline")); $TPL_message = stripslashes(mysql_result($res,0,"message")); $TPL_image = $SITE_URL."bilder/".stripslashes(mysql_result($res,0,"image")); //////////////////////////////////////neusten suchanzeigen //////////////////////////////////////////// $asdes = "DESC"; $order ="starts"; $query = "SELECT * FROM searches WHERE closed='0' ORDER BY $order $asdes"; $result = mysql_query($query); if ( $result ) $num_su = mysql_num_rows($result); else $num_su = 0; $i = 0; $TPL_last_su_value = ""; $bgcolor2 = "#FFFFFF"; while($i < $num_su&& $i < 7) { if($bgcolor2 == "#FFFFFF") { $bgcolor2 = "#FAF896"; } else { $bgcolor2 = "#FFFFFF"; } $text = mysql_result($result,$i,"text"); $seanr = mysql_result($result,$i,"id"); $date = mysql_result($result,$i,"ends"); $starts = mysql_result($result,$i,"starts"); $text = substr($text,0,25).".."; $year = substr($starts,0,4); $month = substr($starts,5,2); $day = substr($starts,8,2); $hours = substr($starts,11,2); $minutes = substr($starts,14,2); $seconds = substr($starts,17,2); $TPL_last_su_value .= "
"; $TPL_last_su_value.=""; $TPL_last_su_value .= ""; $TPL_last_su_value .= "
\"\"".strip_tags(stripslashes($text))."
"; $i++; } include "./templates/tpl_index.html"; include "./footer.php"; ?>