active_auctions.php

<?php

/*******************************************************************************

 *   copyright				: (C) 2014 - 2018 Pro-Auction-Script

 *   site					: https://www.pro-auction-script.com

 *   Script License			: https://www.pro-auction-script.com/contents.php?show=free_license

 *******************************************************************************/

include 'common.php';



if (isset($_GET['user_id']) && !empty($_GET['user_id']))

{

	$user_id = intval($_GET['user_id']);

}

elseif ($user->logged_in)

{

	$user_id = $user->user_data['id'];

}

else

{

	$_SESSION['REDIRECT_AFTER_LOGIN'] = 'active_auctions.php';

	header('location: user_login.php');

	exit;

}



// check trying to access valid user id

$user->checkUserValid($user_id);



$NOW = $system->CTIME;



// get number of active auctions for this user

$query = "SELECT id FROM " . $DBPrefix . "auctions

		WHERE user = :user_id

		AND closed = 0

		AND starts <= :time";

$params = array(

	array(':user_id', $user_id, 'int'),

	array(':time', $NOW, 'int')

);

$db->query($query, $params);

$num_auctions = $db->numrows('id');



// Handle pagination

if (!isset($_GET['PAGE']) || $_GET['PAGE'] == '' || $_GET['PAGE'] < 1)

{

	$OFFSET = 0;

	$PAGE = 1;

}

else

{

	$PAGE = intval($_GET['PAGE']);

	$OFFSET = ($PAGE - 1) * $system->SETTINGS['perpage'];

}

$PAGES = ceil($num_auctions / $system->SETTINGS['perpage']);

if (!isset($PAGES) || $PAGES < 1) $PAGES = 1;



$query = "SELECT * FROM " . $DBPrefix . "auctions

		WHERE user = :user_id

		AND closed = 0

		AND starts <= :time

		ORDER BY ends ASC LIMIT :offset, :perpage";

$params = array(

	array(':user_id', $user_id, 'int'),

	array(':time', $NOW, 'int'),

	array(':offset', $OFFSET, 'int'),

	array(':perpage', $system->SETTINGS['perpage'], 'int')

);

$db->query($query, $params);



$k = 0;

while ($row = $db->fetch())

{

	if (strlen($row['pict_url']) > 0)

	{

		$row['pict_url'] = $system->SETTINGS['siteurl'] . 'getthumb.php?w=' . $system->SETTINGS['thumb_show'] . '&fromfile=' . $security->encrypt($row['id'] . '/' . $row['pict_url'], true);

	}

	else

	{

		$row['pict_url'] = get_lang_img('nopicture.gif');

	}



	// number of bids for this auction

	$query = "SELECT bid FROM " . $DBPrefix . "bids WHERE auction = :id";

	$params = array(

		array(':id', $row['id'], 'int')

	);

	$db->query($query, $params);

	$num_bids = $db->numrows('bid');



	$difference = $row['ends'] - $system->CTIME;



	$template->assign_block_vars('auctions', array(

		'ID' => $row['id'],

		'PIC_URL' => $row['pict_url'],

		'TITLE' => $row['title'],

		'SEO_TITLE' => generate_seo_link($row['title']),

		'BNIMG' => get_lang_img(($row['bn_only'] == 'n') ? 'buy_it_now.gif' : 'bn_only.png'),

		'BNVALUE' => $row['buy_now'],

		'BNFORMAT' => $system->print_money($row['buy_now']),

		'BIDVALUE' => $system->print_money($row['current_bid']),

		'BIDFORMAT' => $system->print_money($row['current_bid']),

		'NUM_BIDS' => $num_bids,

		'TIMELEFT' => $system->FormatTimeLeft($difference),

		'B_FREEITEM' => $row['sell_type'] == 'free',

		'B_BUY_NOW' => ($row['buy_now'] > 0 && ($row['bn_only'] == 'y' || $row['bn_only'] == 'n' && ($row['num_bids'] == 0 || ($row['reserve_price'] > 0 && $row['current_bid'] < $row['reserve_price'])))),

		'B_BNONLY' => ($row['bn_only'] == 'y')

	));

	$k++;

}



// get this user's nick

$query = "SELECT nick FROM " . $DBPrefix . "users WHERE id = :user_id";

$params = array(

	array(':user_id', $user_id, 'int')

);

$db->query($query, $params);

$TPL_user_nick = $db->result('nick');

$page_title = $MSG['219'] . ': ' . $TPL_user_nick;



$LOW = $PAGE - 5;

if ($LOW <= 0) $LOW = 1;

$COUNTER = $LOW;

$pagenation = '';

while ($COUNTER <= $PAGES && $COUNTER < ($PAGE + 6))

{

	if ($PAGE == $COUNTER)

	{

		$pagenation .= '<li class="disabled"><a href="#">' . $COUNTER . '</a></li>';

	}

	else

	{

		$pagenation .= '<li><a href="active_auctions.php?PAGE=' . $COUNTER . '&user_id=' . $user_id . '">' . $COUNTER . '</a><li>';

	}

	$COUNTER++;

}



$template->assign_vars(array(

		'B_MULPAG' => ($PAGES > 1),

		'B_NOTLAST' => ($PAGE < $PAGES),

		'B_NOTFIRST' => ($PAGE > 1),

		

		'USER_RSSFEED' => sprintf($MSG['932'], $TPL_user_nick),

		'USER_ID' => $user_id,

		'USERNAME' => $TPL_user_nick,

		'THUMBWIDTH' => $system->SETTINGS['thumb_show'],

		'NEXT' => intval($PAGE + 1),

		'PREV' => intval($PAGE - 1),

		'PAGE' => $PAGE,

		'B_FB_LINK' => 'IndexFBLogin',

		'PAGES' => $PAGES,

		'PAGENA' => $pagenation

		));



include 'header.php';

$template->set_filenames(array(

		'body' => 'active_auctions.tpl'

		));

$template->display('body');

include 'footer.php';