$flr_605 ";
include "footer.php";
exit;
}
require("header.php");
// now check if requested auction exists and is/isn't closed
$AuctionIsClosed = false;
$query = "SELECT * FROM auctions WHERE id='$id'";
$result = mysql_query ($query);
if ( $result )
{
// look if such auction exists
if ( mysql_num_rows($result)>0 )
{
$closed = intval(mysql_result($result,0,"closed"));
// look if auction has a "closed" flag
if ( $closed==1 )
{
$AuctionIsClosed = true;
}
else
{
// look if auction isn't closed
$c = mysql_result($result,0,"ends");
$c = mktime (
substr($c,8,2),// hour
substr($c,10,2),// min
substr($c,12,2),// sec
substr($c,4,2),// month
substr($c,6,2),// day
substr($c,0,4)// year
);
if ( $c<=time() )
{
// auction is closed - set flag
$AuctionIsClosed = true;
}
}
}
else
{
print " $flr_606 ";
include "footer.php";
exit;
}
}
else
{
print " $flr_001 ";
include "footer.php";
exit;
}
$sessionVars["CURRENT_ITEM"] = $id;
putSessionVars();
$query = "select bid from bids where auction=\"$id\"";
$result = mysql_query($query);
if ( mysql_num_rows($result ) > 0)
{
$TPL_BIDS_value = "$text_105 | ";
}
/* get auction data */
$query = "select * from auctions where id='$id'";
$result = mysql_query($query);
if ( !$result )
{
print $flr_001;
exit;
}
$user = stripslashes(mysql_result ( $result, 0, "user" ));
$title = stripslashes(mysql_result ( $result, 0, "title" ));
$date = mysql_result ( $result, 0, "starts" );
$description = stripslashes(mysql_result ( $result, 0, "description" ));
$pict_url = mysql_result ( $result, 0, "pict_url" );
$pict_url2 = mysql_result ( $result, 0, "pict_url2" );
$pict_url3 = mysql_result ( $result, 0, "pict_url3" );
$category = mysql_result ( $result, 0, "category" );
$minimum_bid = mysql_result ( $result, 0, "minimum_bid" );
$reserve_price = mysql_result ( $result, 0, "reserve_price" );
$auction_type = mysql_result ( $result, 0, "auction_type" );
$location = mysql_result ( $result, 0, "location" );
$location_zip = mysql_result ( $result, 0, "location_zip" );
$shipping = mysql_result ( $result, 0, "shipping" );
$payment = mysql_result ( $result, 0, "payment" );
$international = mysql_result ( $result, 0, "international" );
$ends = mysql_result ( $result, 0, "ends" );
$current_bid = mysql_result ( $result, 0, "current_bid" );
$phu = intval(mysql_result( $result,0,"photo_uploaded"));
$atype = intval(mysql_result($result,0,"auction_type"));
$iquantity = mysql_result ($result,0,"quantity");
$izustand = mysql_result ($result,0,"zustand");
$iartnr = mysql_result ($result,0,"artnr");
$izustand = mysql_result ($result,0,"zustand");
$buy_now = mysql_result ($result,0,"buynow");
$TPL_auction_type = $auction_types[$atype];
/* if ($atype==2)
{ */
$TPL_auction_quantity = $iquantity;
/* } */
//-- Get RESERVE PRICE information
if ($reserve_price > 0)
{
$TPL_reserve_price = "$text_030 ";
//-- Has someone reached the reserve price?
if($current_bid <= $reserve_price)
{
$TPL_reserve_price .= " ($text_514)";
}
else
{
$TPL_reserve_price .= " ($text_515) ";
}
}
else
{
$TPL_reserve_price = "$text_029";
}
$TPL_id_value = $id;
$TPL_artnr_value = $iartnr;
$TPL_zustand_value = $izustand;
$TPL_title_value = $title;
$TPL_description_value = $description;
$TPL_buy_now = $buy_now;
$TPL_current_bid = $current_bid;
//print $phu;
// see if it's an uploaded picture
if ( $phu!=0 )
$pict_url = $uploaded_path.$pict_url;
if ($pict_url2 <> "")
$pict_url2 = $uploaded_path.$pict_url2;
if ($pict_url3 <> "")
$pict_url3 = $uploaded_path.$pict_url3;
/* get user's nick */
$query = "SELECT id,nick FROM users WHERE id='$user'";
$result_usr = mysql_query ( $query );
if ( !$result_usr )
{
print $text_001;
exit;
}
$user_nick = mysql_result ( $result_usr, 0, "nick");
$user_id = mysql_result ( $result_usr, 0, "id");
$TPL_user_nick_value = $user_nick;
/* get bids for current item */
$query = "SELECT MAX(bid) AS maxbid FROM bids WHERE auction='$id' GROUP BY auction";
$result_bids = mysql_query ( $query) ;
if ( !$result_bids )
{
print $text_001;
exit;
}
if ( mysql_num_rows($result_bids ) > 0)
{
$high_bid = mysql_result ( $result_bids, 0, "maxbid" );
$query = "select bidder from bids where bid=$high_bid and auction='$id'";
$result_bidder = mysql_query ( $query );
$high_bidder_id = mysql_result ( $result_bidder, 0, "bidder" );
}
if ( !mysql_num_rows($result_bids) )
{
$num_bids = 0;
$high_bid = 0;
}
else
{
/* Get number of bids */
$query = "select bid from bids where auction='$id'";
$result_numbids = mysql_query ( $query );
if ( !$result_numbids )
{
print $flr_001;
exit;
}
$num_bids = mysql_num_rows ( $result_numbids );
/* Get bidder nickname */
$query = "select id,nick from users where id='$high_bidder_id'";
$result_bidder = mysql_query($query);
if ( !$result_bidder )
{
print $flr_001;
exit;
}
$high_bidder_id = mysql_result ( $result_bidder, 0, "id" );
$high_bidder_nick = mysql_result ( $result_bidder, 0, "nick" );
}
/* Get bid increment for current bis and calculate minimum bid */
$query = "SELECT increment FROM increments WHERE".
"((low<=$high_bid AND high>=$high_bid) OR".
"(low<$high_bid AND high<$high_bid)) ORDER BY increment DESC";
$result_incr = mysql_query ( $query );
if(mysql_num_rows($result_incr) != 0) {
$increment = mysql_result ( $result_incr, 0, "increment" );
}
if ($high_bid == 0)
{
$query = "SELECT increment FROM increments WHERE".
"((low<=$minimum_bid AND high>=$minimum_bid) OR".
"(low<$minimum_bid AND high<$minimum_bid)) ORDER BY increment DESC";
$result_incr = mysql_query ( $query );
$increment = mysql_result ( $result_incr, 0, "increment" );
$next_bid = $minimum_bid;
}
else
{
$next_bid = $high_bid + $increment;
}
if ( $pict_url )
{
$TPL_pict_url_value = "![](\"./images/picture.gif\")
"
."$text_108"
."![](\"images/transparent.gif\")
";
}
/* Get current number of feedbacks */
$query = "SELECT rated_user_id FROM feedbacks WHERE rated_user_id='$user_id'";
$result = mysql_query ( $query );
$num_feedbacks = mysql_num_rows ( $result );
/* Get current total rate value for user */
$query = "SELECT rate_sum FROM users WHERE nick='$user_nick'";
$result = mysql_query ( $query );
if($result && mysql_num_rows($result) > 0)
$total_rate = mysql_result ( $result, 0, "rate_sum" );
$TPL_vendetor_value = " ".$TPL_user_nick_value."";
if ( $num_feedbacks > 0 )
{
$rate_ratio = round( $total_rate / $num_feedbacks );
}
else
{
$rate_ratio = 0;
}
$TPL_rate_radio = " ($num_feedbacks) ![](\"./images/estrella_".$rate_ratio.".gif\")
";
/* High bidder */
if ( $high_bidder_id ){
$TPL_hight_bidder_id = "$high_bidder_nick";
/* Get current number of feedbacks */
$query = "select rated_user_id from feedbacks where rated_user_id=\"$high_bidder_id\"";
$result = mysql_query ( $query );
$num_feedbacks = mysql_num_rows($result);
/* Get current total rate value for user */
$query = "select rate_sum,nick,id from users where nick=\"$high_bidder_nick\"";
$result = mysql_query($query);
$total_rate = mysql_result($result,0,"rate_sum");
$nickname = mysql_result($result,0,"nick");
$userid = mysql_result($result,0,"id");
if ( $num_feedbacks > 0 )
{
$rate_ratio = round($total_rate / $num_feedbacks);
}
else
{
$rate_ratio = 0;
}
$TPL_hight_bidder_id = "$high_bidder_nick ($num_feedbacks) ";
}
$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));
$difference = intval( mktime( $ends_hours,$ends_minutes,$ends_seconds,$ends_month,$ends_day,$ends_year)) - time();
if ($difference > 0) {
$TPL_days_difference_value = intval($difference / 86400).$text_126;
$difference = $difference - ($TPL_days_difference_value * 86400);
$hours_difference = intval($difference / 3600);
if(strlen($hours_difference) == 1)
{
$hours_difference = "0".$hours_difference;
}
$TPL_hours_difference_value = $hours_difference.":";
$difference = $difference - ($hours_difference * 3600);
$minutes_difference = intval($difference / 60);
if (strlen($minutes_difference) == 1)
{
$minutes_difference = "0".$minutes_difference;
}
$TPL_minutes_difference_value = $minutes_difference.":";
$difference = $difference - ($minutes_difference * 60);
$seconds_difference = $difference;
if (strlen($seconds_difference) == 1)
{
$seconds_difference = "0".$seconds_difference;
}
$TPL_seconds_difference_value = $seconds_difference;
} else {
if (($buy_now == $current_bid) && ($current_bid <> 0))
$TPL_days_difference_value = "$flr_font durch Sofort-Kauf beendet ";
else
$TPL_days_difference_value = "$flr_font $text_911 ";
$TPL_hours_difference_value = "";
$TPL_minutes_difference_value = "";
$TPL_seconds_difference_value = "";
}
$TPL_num_bids_value = $num_bids;
$TPL_currency_value1 = print_money($minimum_bid);
$TPL_currency_value2 = print_money($high_bid);
$TPL_currency_value3 = print_money($increment);
$TPL_currency_value4 = print_money($next_bid);
/* Bidding table */
$TPL_next_bid_value = $next_bid;
$TPL_user_id_value = $user_id;
$TPL_title_value = $title;
$TPL_category_value = $category;
$TPL_id_value = $id;
$TPL_artnr_value = $iartnr;
$TPL_zustand_value = $izustand;
/* Description & Image table */
$TPL_description_value = nl2br($description);
if ( $pict_url )
{
$TPL_pict_url = $sml_font."Originalgröße hier
![](\"$pict_url\")
";
}
else
{
$TPL_pict_url = "$text_114";
}
if ( $pict_url2 )
{
$TPL_pict_url2 = $sml_font."Originalgröße hier
![](\"$pict_url2\")
";
}
if ( $pict_url3 )
{
$TPL_pict_url3 = $sml_font."Originalgröße hier
![](\"$pict_url3\")
";
}
/* Get location description */
/*
include ("./includes/countries.inc.php");
while ( list($key, $val) = each ($countries) )
{
if ( $val = $location )
{
$location_name = $countries[$val];
}
}
$TPL_location_name_value = $location_name;
*/
$TPL_location_name_value = $location;
$TPL_location_zip_value = $location_zip;
if ( $shipping == '1' )
{
$TPL_shipping_value = $text_038;
}
else
{
$TPL_shipping_value = $text_032;
}
if ( $international )
{
$TPL_international_value = ", $text_033";
}
else
{
$TPL_international_value = ", $text_043";
}
/* Get Payment methods */
$payment_methods = explode("\n",$payment);
$i = 0;
$c = count($payment_methods);
$began = false;
while ($i<$c)
{
if (strlen($payment_methods[$i])!=0 )
{
if ($began)
$TPL_payment_value .= ", ";
else
$began = true;
$TPL_payment_value .= trim($payment_methods[$i]);
}
$i++;
}
$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);
$date_string = ArrangeDate($day,$month,$year,$hours,$minutes);
$TPL_date_string1 = $date_string;
$year = substr($ends,0,4);
$month = substr($ends,4,2);
$day = substr($ends,6,2);
$hours = substr($ends,8,2);
$minutes = substr($ends,10,2);
$date_string = ArrangeDate($day,$month,$year,$hours,$minutes);
$TPL_date_string2 = $date_string;
$c_name[] = array(); $c_id[] = array();
$TPL_cat_value = "";
$query = "SELECT cat_id,parent_id,cat_name FROM categories WHERE cat_id='$category'";
$result = mysql_query($query);
if ( !$result )
{
print $flr_001;
exit;
}
$result = mysql_fetch_array ( $result );
$parent_id = $result[parent_id];
$cat_id = $categories;
$j = $category;
$i = 0;
do {
$query = "SELECT cat_id,parent_id,cat_name FROM categories WHERE cat_id='$j'";
$result = mysql_query($query);
if ( !$result )
{
print $flr_001;
exit;
}
$result = mysql_fetch_array ( $result );
if ( $result )
{
$parent_id = $result[parent_id];
$c_name[$i] = $result[cat_name];
$c_id[$i] = $result[cat_id];
$i++;
$j = $parent_id;
} else {
// error message
print "$flr_font $flr_620 ";
include "footer.php";
exit;
}
} while ( $parent_id != 0 );
for ($j=$i-1; $j>=0; $j--)
{
if ( $j == 0)
{
$TPL_cat_value .= "".$c_name[$j]."";
}
else
{
$TPL_cat_value .= "".$c_name[$j]." / ";
}
}
include ("./templates/template_item_php.html");
require("footer.php");
?>