Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (!file_exists("includes/adminbestand.php")) {
- echo "<script>document.location.href='install.php'</script>";
- } else {
- require_once('./includes/config.inc.php');
- #// Run cron according to SETTINGS
- if ($SETTINGS['cron'] == 2) {
- include_once "cron.php";
- }
- require_once("./header.php");
- function get_next_bid($auction_id)
- {
- if (intval($auction_id) > 0) {
- $result = mysql_query("SELECT * FROM VEILINGMEESTER_auctions WHERE id=" . intval($auction_id));
- $result_bids = mysql_query("select max(bid) AS maxbid, bidder FROM VEILINGMEESTER_bids WHERE auction=" . intval($auction_id) . " GROUP BY auction, bidder ORDER BY maxbid DESC");
- $customincrement = mysql_result($result, 0, "increment");
- $max_bid = mysql_result($result_bids, 0, "maxbid");
- $minimum_bid = mysql_result($result, 0, "minimum_bid");
- if ($max_bid == 0) {
- $MAX_BID = $minimum_bid;
- $max_bid = $minimum_bid;
- } else {
- $MAX_BID = $max_bid;
- }
- $query = "SELECT increment FROM VEILINGMEESTER_increments WHERE " . "((low <= $MAX_BID AND high >= $MAX_BID) OR " . "(low < $MAX_BID AND high < $MAX_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 ($customincrement > 0) {
- $increment = $customincrement;
- }
- if ($max_bid == 0 || $atype == 2) {
- $next_bid = $minimum_bid;
- } else {
- $next_bid = $max_bid + $increment;
- }
- return $next_bid;
- } else {
- return 0;
- }
- }
- function get_winner_name($auction_id)
- {
- $sql = "SELECT
- b.bid, b.bidder, COUNT(bid) AS bid_count,u.nick
- FROM
- VEILINGMEESTER_bids b
- INNER JOIN VEILINGMEESTER_users u ON b.bidder=u.id
- WHERE
- b.auction=" . $auction_id . "
- GROUP BY
- b.bid
- ORDER BY
- b.bid DESC ";
- $result = mysql_query($sql);
- if ($row1 = mysql_fetch_array($result)) {
- return $row1['nick'];
- } else {
- return "";
- }
- }
- $TIME = mktime(date("H") + $SETTINGS['timecorrection'], date("i"), date("s"), date("m"), date("d"), date("Y"));
- $NOW = date("YmdHis", $TIME);
- if ($SETTINGS['catsorting'] == 'alpha') {
- $catsorting = " ORDER BY t.cat_name ASC";
- } else {
- $catsorting = " ORDER BY sub_counter DESC";
- }
- $TPL_categories_value = "";
- $query = "select
- distinct *
- from
- VEILINGMEESTER_categories c,
- VEILINGMEESTER_cats_translated t
- WHERE
- c.parent_id=0
- AND t.cat_id=c.cat_id
- AND t.lang='" . $USERLANG . "'
- $catsorting";
- $result = mysql_query($query);
- if (!$result) {
- echo mysql_error();
- exit();
- } else {
- $num_cat = mysql_num_rows($result);
- $i = 0;
- $TPL_categories_value = "<ul>n";
- while ($i < $num_cat && $i < $SETTINGS['catstoshow']) {
- $catlink = "";
- $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";
- if ($cat_image != "") {
- $catlink = '<A HREF="$cat_url"><IMG SRC="$cat_image" BORDER="0"></a>';
- }
- $cat_name = @mysql_result(mysql_query("SELECT cat_name FROM VEILINGMEESTER_cats_translated WHERE cat_id=$cat_id AND lang='" . $USERLANG . "'"), 0, "cat_name");
- $catlink = '<A HREF="$cat_url">$cat_name</A>" . " $cat_counter';
- if ($cat_colour != "") {
- $catlink = setsspan($catlink, "background-color:$cat_colour");
- }
- $TPL_categories_value .= "<li>" . $catlink . "</li>n";
- $i++;
- }
- $TPL_categories_value .= "</ul>n";
- $TPL_categories_value .= '<A HREF="browse.php?id=0">$MSG_277</A>';
- }
- $query = "SELECT id,title,starts, ends, pict_url, auction_type, item_value, minimum_bid, bid_value,w_seat, Seat_Left, Seat_Number, Seat_Price, closed, started, increment FROM VEILINGMEESTER_auctions WHERE closed='0' AND suspended=0 AND auction_type = 1 AND is_main_auction = 0 AND ";
- if ($SETTINGS['adultonly'] == 'y' && !isset($_SESSION["VEILINGMEESTER_LOGGED_IN"])) {
- $query .= "adultonly='n' AND ";
- }
- if ($category_id != "") {
- if (subCategoriesList($category_id) != "") {
- $query .= "(category = " . $category_id . " OR category IN (" . subCategoriesList($category_id) . ")) AND ";
- } else {
- $query .= "category = " . $category_id . " AND ";
- }
- }
- $query .= "starts <= " . $NOW . " ORDER BY ends ASC LIMIT " . $SETTINGS['lastitemsnumber'];
- $result = mysql_query($query);
- if ($result)
- $num_auction = mysql_num_rows($result);
- else
- $num_auction = 0;
- $i = 0;
- $TPL_auctions_classic = array();
- while ($i < $num_auction) {
- $closed = mysql_result($result, $i, "closed");
- $started = mysql_result($result, $i, "started");
- $Seat_Price = mysql_result($result, $i, "Seat_Price");
- $Seat_Number = mysql_result($result, $i, "Seat_Number");
- $Seat_Left = mysql_result($result, $i, "Seat_Left");
- $w_seat = mysql_result($result, $i, "w_seat");
- $title = mysql_result($result, $i, "title");
- $id = mysql_result($result, $i, "id");
- $date = mysql_result($result, $i, "ends");
- $pict_url = mysql_result($result, $i, "pict_url");
- if ($pict_url == "") {
- $pict_url = 'no_image.png';
- }
- $a_increment = mysql_result($result, $i, "increment");
- if ($a_increment > 0) {
- $a_onclick = "do_ajax_bid(" . $id . "," . ($_SESSION['VEILINGMEESTER_LOGGED_IN'] != "" ? $_SESSION['VEILINGMEESTER_LOGGED_IN'] : 0) . ")";
- } else {
- $a_onclick = 'javascript:window.location.href="./item.php?id=".$id."" ';
- }
- $auction_type = mysql_result($result, $i, "auction_type");
- $item_value = mysql_result($result, $i, "item_value");
- $bid_value = mysql_result($result, $i, "bid_value");
- $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);
- $minimum_a_bid = mysql_result($result, $i, "minimum_bid");
- $sql2 = "SELECT * FROM VEILINGMEESTER_auctions_signed WHERE auction_id=" . $id . " and user_id=" . $_SESSION["VEILINGMEESTER_LOGGED_IN"];
- $result2 = mysql_query($sql2);
- $is_signed = mysql_num_rows($result2);
- if ($Seat_Left > 0 && $w_seat == "2" && $closed == "0") {
- $sql1 = "SELECT COUNT(*) as seats_sold FROM VEILINGMEESTER_auctions_signed WHERE auction_id=" . $id;
- $result1 = mysql_query($sql1);
- $seats_sold = mysql_result($result1, 0, "seats_sold");
- $Seat_Left = $Seat_Number - $seats_sold;
- $update = "update VEILINGMEESTER_auctions set Seat_Left ='" . $Seat_Left . "' where id= '" . $id . "'";
- mysql_query($update);
- }
- $sql = "SELECT MAX(bid) AS max_bid FROM VEILINGMEESTER_bids WHERE auction=" . $id;
- $result_bid = mysql_query($sql);
- $ISBOLD = FALSE;
- $ISHIGHLIGHTED = FALSE;
- $TPL_auctions_classic[$i] = array();
- $TPL_auctions_classic[$i]["date_created"] = $month . "/" . $day . "/" . $year . " " . $hours . ":" . $minutes . ":" . $seconds;
- $TPL_auctions_classic[$i]["remained_seconds"] = strtotime($TPL_auctions_classic[$i]["date_created"]) - time();
- $TPL_auctions_classic[$i]["name"] = stripslashes($title);
- $TPL_auctions_classic[$i]["link_href"] = "./item.php?id=" . $id . "";
- $TPL_auctions_classic[$i]["pict_url"] = $pict_url;
- $TPL_auctions_classic[$i]["item_value"] = stripslashes($item_value);
- $TPL_auctions_classic[$i]["bid_value"] = stripslashes($bid_value);
- $TPL_auctions_classic[$i]["winner"] = get_winner_name($id);
- $TPL_auctions_classic[$i]["w_seat"] = stripslashes($w_seat);
- $TPL_auctions_classic[$i]["Seat_Number"] = stripslashes($Seat_Number);
- $TPL_auctions_classic[$i]["Seat_Left"] = stripslashes($Seat_Left);
- $TPL_auctions_classic[$i]["Seat_Price"] = stripslashes($Seat_Price);
- $TPL_auctions_classic[$i]["started"] = stripslashes($started);
- $TPL_auctions_classic[$i]["is_signed"] = stripslashes($is_signed);
- $TPL_auctions_classic[$i]["next_bid"] = get_next_bid($id);
- $TPL_auctions_classic[$i]["winner"] = get_winner_name($id);
- $TPL_auctions_classic[$i]["current_bid"] = mysql_result($result_bid, 0, "max_bid");
- if ($TPL_auctions_classic[$i]["current_bid"] == "") {
- $TPL_auctions_classic[$i]["current_bid"] = $minimum_a_bid;
- }
- $TPL_auctions_classic[$i]["a_onclick"] = $a_onclick;
- $TPL_auctions_classic[$i]["auction_id"] = $id;
- $i++;
- }
- $query = "SELECT id,title,starts, ends, pict_url, auction_type, item_value, minimum_bid, bid_value,w_seat, Seat_Left, Seat_Number, Seat_Price, closed, started, increment FROM VEILINGMEESTER_auctions WHERE closed='0' AND suspended=0 AND auction_type = 1 AND is_main_auction = 0 AND ";
- if ($SETTINGS['adultonly'] == 'y' && !isset($_SESSION["VEILINGMEESTER_LOGGED_IN"])) {
- $query .= "adultonly='n' AND ";
- }
- if ($category_id != "") {
- if (subCategoriesList($category_id) != "") {
- $query .= "(category = " . $category_id . " OR category IN (" . subCategoriesList($category_id) . ")) AND ";
- } else {
- $query .= "category = " . $category_id . " AND ";
- }
- }
- $query .= "starts <= " . $NOW . " ORDER BY ends ASC LIMIT " . ($SETTINGS['lastitemsnumber']) . ",30";
- $result = mysql_query($query);
- if ($result)
- $num_auction1 = mysql_num_rows($result);
- else
- $num_auction1 = 0;
- $i = 0;
- $TPL_more_auctions = array();
- while ($i < $num_auction1) {
- $closed = mysql_result($result, $i, "closed");
- $started = mysql_result($result, $i, "started");
- $Seat_Price = mysql_result($result, $i, "Seat_Price");
- $Seat_Number = mysql_result($result, $i, "Seat_Number");
- $Seat_Left = mysql_result($result, $i, "Seat_Left");
- $w_seat = mysql_result($result, $i, "w_seat");
- $title = mysql_result($result, $i, "title");
- $id = mysql_result($result, $i, "id");
- $date = mysql_result($result, $i, "ends");
- $pict_url = mysql_result($result, $i, "pict_url");
- if ($pict_url == "") {
- $pict_url = 'no_image.png';
- }
- $a_increment = mysql_result($result, $i, "increment");
- if ($a_increment > 0) {
- $a_onclick = "do_ajax_bid(" . $id . "," . ($_SESSION['VEILINGMEESTER_LOGGED_IN'] != "" ? $_SESSION['VEILINGMEESTER_LOGGED_IN'] : 0) . ")";
- } else {
- $a_onclick = 'javascript:window.location.href="./item.php?id=".$id."" ';
- }
- $auction_type = mysql_result($result, $i, "auction_type");
- $item_value = mysql_result($result, $i, "item_value");
- $bid_value = mysql_result($result, $i, "bid_value");
- $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);
- $minimum_a_bid = mysql_result($result, $i, "minimum_bid");
- $sql2 = "SELECT * FROM VEILINGMEESTER_auctions_signed WHERE auction_id=" . $id . " and user_id=" . $_SESSION["VEILINGMEESTER_LOGGED_IN"];
- $result2 = mysql_query($sql2);
- $is_signed = mysql_num_rows($result2);
- if ($Seat_Left > 0 && $w_seat == "2" && $closed == "0") {
- $sql1 = "SELECT COUNT(*) as seats_sold FROM VEILINGMEESTER_auctions_signed WHERE auction_id=" . $id;
- $result1 = mysql_query($sql1);
- $seats_sold = mysql_result($result1, 0, "seats_sold");
- $Seat_Left = $Seat_Number - $seats_sold;
- $update = "update VEILINGMEESTER_auctions set Seat_Left ='" . $Seat_Left . "' where id= '" . $id . "'";
- mysql_query($update);
- }
- $sql = "SELECT MAX(bid) AS max_bid FROM VEILINGMEESTER_bids WHERE auction=" . $id;
- $result_bid = mysql_query($sql);
- #
- $ISBOLD = FALSE;
- $ISHIGHLIGHTED = FALSE;
- $TPL_more_auctions[$i] = array();
- $TPL_more_auctions[$i]["date_created"] = $month . "/" . $day . "/" . $year . " " . $hours . ":" . $minutes . ":" . $seconds;
- $TPL_more_auctions[$i]["remained_seconds"] = strtotime($TPL_more_auctions[$i]["date_created"]) - time();
- $TPL_more_auctions[$i]["w_seat"] = stripslashes($w_seat);
- $TPL_more_auctions[$i]["Seat_Number"] = stripslashes($Seat_Number);
- $TPL_more_auctions[$i]["Seat_Left"] = stripslashes($Seat_Left);
- $TPL_more_auctions[$i]["Seat_Price"] = stripslashes($Seat_Price);
- $TPL_more_auctions[$i]["started"] = stripslashes($started);
- $TPL_more_auctions[$i]["is_signed"] = stripslashes($is_signed);
- $TPL_more_auctions[$i]["name"] = stripslashes($title);
- $TPL_more_auctions[$i]["link_href"] = "./item.php?id=" . $id . "";
- $TPL_more_auctions[$i]["pict_url"] = $pict_url;
- $TPL_more_auctions[$i]["item_value"] = stripslashes($item_value);
- $TPL_more_auctions[$i]["bid_value"] = stripslashes($bid_value);
- $TPL_more_auctions[$i]["next_bid"] = get_next_bid($id);
- $TPL_more_auctions[$i]["winner"] = get_winner_name($id);
- $TPL_more_auctions[$i]["current_bid"] = mysql_result($result_bid, 0, "max_bid");
- $TPL_more_auctions[$i]["a_onclick"] = $a_onclick;
- $TPL_more_auctions[$i]["auction_id"] = $id;
- if ($TPL_more_auctions[$i]["current_bid"] == "") {
- $TPL_more_auctions[$i]["current_bid"] = $minimum_a_bid;
- }
- $i++;
- }
- $open_auction_num = $num_auction + $num_auction1;
- $TPL_maximum_bids = "";
- $query = "select
- auction,max(bid) AS max_bid
- FROM
- VEILINGMEESTER_bids b,
- VEILINGMEESTER_auctions a
- WHERE
- a.suspended=0
- AND a.closed=0
- AND a.id=b.auction
- GROUP BY
- b.bid,b.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");
- $query = "SELECT title,closed,id from VEILINGMEESTER_auctions WHERE id='$auction' AND";
- $query .= "'" . $NOW . "'>=starts";
- $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)) {
- $ISBOLD = FALSE;
- $ISHIGHLIGHTED = FALSE;
- $TPL_maximum_bids .= '<p style="background-color:$bgcolor;display:block"><A HREF=javascript:window_open("converter.php?AMOUNT=$max_bid","incre",650,200,30,30)>" . print_money($max_bid) . " <A HREF="./item.php?id=$auc_id">';
- if ($ISHIGHLIGHTED) {
- $TPL_maximum_bids .= "<SPAN CLASS=hg>";
- }
- if ($ISBOLD) {
- $TPL_maximum_bids .= "<B>";
- }
- $TPL_maximum_bids .= stripslashes($title);
- if ($ISBOLD) {
- $TPL_maximum_bids .= "</B>";
- }
- if ($ISHIGHLIGHTED) {
- $TPL_maximum_bids .= "</SPAN>";
- }
- $TPL_maximum_bids .= "</A></p>";
- if ($bgcolor == "#FFFFFF") {
- $bgcolor = $FONTCOLOR[$SETTINGS['headercolor']];
- } else {
- $bgcolor = "#FFFFFF";
- }
- $AU[] = $auction;
- $j++;
- }
- $i++;
- }
- if (($SETTINGS['newsbox'] == 1) && !isset($_SESSION["VEILINGMEESTER_LOGGED_IN"])) {
- $query = "SELECT title,id,new_date from VEILINGMEESTER_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 ($news = mysql_fetch_array($res)) {
- $TPL_news_list .= "<div class='newsfont'>";
- $TR = @mysql_fetch_array(@mysql_query("SELECT title,content FROM VEILINGMEESTER_news WHERE id=" . intval($news['id'])));
- $news['title'] = $TR['title'];
- $news['content'] = $TR['content'];
- $news_date = $news['new_date'];
- $F_date = FormatDate($news_date);
- $TPL_news_list .= "<div class='linkmore'>
- <div class='linkmore'><a href='nieuws_bekijken.php?id=" . $news['id'] . "' class='linkmore'>" . $news['title'] . "</a></div>
- </div>";
- $TPL_news_list .= $F_date . " - " . substr($news['content'], 0, 30) . "... <a href='nieuws_bekijken.php?id=" . $news['id'] . "' class='linkmore'>" . $INF_105 . "</a>";
- $TPL_news_list .= "</div>";
- $TPL_news_list .= "<div class='image'><img src='" . $SETTINGS['siteurl'] . "themas/webhouse_template/img/line.png' /></div>";
- }
- } else {
- $TPL_news_list = " ";
- }
- $TPL_news_list .= " <a href='bekijk_alle_nieuws.php'>" . $MSG_31_0046 . "</a>";
- $query = "SELECT
- DISTINCT a.title, a.id, a.pict_url, w.bid, w.winner, a.ends AS closingdate, w.bid, u.nick
- FROM
- VEILINGMEESTER_auctions a
- LEFT OUTER JOIN VEILINGMEESTER_winners w ON a.id = w.auction
- LEFT OUTER JOIN VEILINGMEESTER_users u ON w.winner = u.id
- WHERE
- auction_type = '1' AND closed = '1'
- ORDER BY
- ends DESC
- limit 0, 7";
- $res = mysql_query($query);
- if (!$res) {
- }
- $TPL_closed_auctions_list = "";
- while ($row = mysql_fetch_array($res)) {
- $title = ((strlen($row['title']) > 12) ? substr($row['title'], 0, 12) . "..." : $row['title']);
- $closed_date = $row['closingdate'];
- $pict_url = $row['pict_url'];
- if ($pict_url == "") {
- $pict_url = 'no_image.png';
- }
- $winner = ($row['winner'] != "") ? " Winner: " . $row['nick'] : "";
- $bid = ($row['bid'] != "") ? " Won bid: " . $row['bid'] : "";
- $F_date = FormatDate($closed_date);
- $TPL_closed_auctions_list .= "<div class='newsfont'>";
- $TPL_closed_auctions_list .= "<table><tr>";
- $TPL_closed_auctions_list .= "<td><a href='item.php?id='.$row[314'id']'.'>'.$title.'</a></td>";
- $TPL_closed_auctions_list .= "<td>" . $F_date . "</td>";
- $TPL_closed_auctions_list .= "</tr>";
- $TPL_closed_auctions_list .= "<tr>";
- if ($row['pict_url'] != "") {
- $TPL_closed_auctions_list .= "<td><a href='item.php?id='.$row['id'].'.' title='.$row['title'].'><img alt='.'.$row['title'].'.' src='" . $SETTINGS['siteurl'] . "upload/thumb/winners/'.$row['pict_url'].' /></a></td>";
- } else {
- $TPL_closed_auctions_list .= "<td><a href='item.php?id='.'.$row['id'].'.' title='.'.$row['title'].'.' ><img alt='" . $row['title'] . "' border='0' width='60px' src='" . $SETTINGS['siteurl'] . "images/no-image.jpg'/></a></td>';
- }
- $TPL_closed_auctions_list .= '<td>';
- $TPL_closed_auctions_list .= '.$MSG_40_020'.' <font style='color:#FF9900'><br /><b> " . print_money($row['bid'], 2, '.', ' ') . "</b></font><br>";
- $TPL_closed_auctions_list .= $MSG_40_021 . " <font style='color:#777777'><br /><b>" . $row['nick'] . "</b></font><br>";
- $TPL_closed_auctions_list .= "<td>";
- $TPL_closed_auctions_list .= "</tr></table>";
- $TPL_closed_auctions_list .= "</div>";
- }
- }
- $TPL_closed_auctions_list .= "<div class='image'><img src='" . $SETTINGS['siteurl'] . "themas/webhouse_template/img/line.png' /></div>";
- $TPL_closed_auctions_list .= "<br><a href='lijst_gesloten_veilingen.php'>" . $MSG_31_0046 . "</a>";
- require_once(phpa_include("index.html"));
- require_once('./footer.php');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement