//Do something here if the result is absent. no item to sell
} else {
//Result is present
$itemPresent = true;
$row = mysqli_fetch_assoc($result);
$i_id = $row["i_id"];
$i_name = $row["i_name"];
$i_imgpath = $row["i_imgpath"];
$i_desc = $row["i_desc"];
$i_baseprice = $row["i_baseprice"];
$i_actualprice = $row["i_actualprice"];
$i_increment = $row["i_increment"];
$i_starttime = $row["i_starttime"];
$i_endtime = $row["i_endtime"];
//check whether the item is loaded correctly
if (readJsonItem('i_id') != $i_id) {
if ($next_itemPresent) {
emptyJsonItem();
exportToJsonItemAfter();
}
}
}
//End of else result is present
mysqli_close($link);
?>
<html class="full" lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
if ((!isset($_SESSION['tek_emailid']) || empty($_SESSION['tek_emailid'])) && (!isset($_SESSION['tek_fname']) || empty($_SESSION['tek_fname']))) {
echo '<script>window.top.location.href = "http://teknack.in"</script>';
//echo '<script>window.top.location.href = "login.php"</script>'; //use to test the application
}
$curtime = date("Y-m-d H:i:s");
$itemPresent = false;
include 'json_func.php';
include 'database.php';
if (readJsonItem('i_id') == null) {
//Do something here if the result is absent. no item to sell
} else {
$itemPresent = true;
$i_id = readJsonItem('i_id');
$i_increment = readJsonItem('i_increment');
$i_endtime = readJsonItem('i_endtime');
$i_baseprice = readJsonItem('i_baseprice');
$i_bidvalue = readJsonLiveBid(0, 'bidValue');
if ($i_bidvalue == null) {
$i_bidvalue = 0;
}
$i_biduser_id = readJsonLiveBid(0, 'bidUserId');
$i_biduser_name = readJsonLiveBid(0, 'bidUserName');
if (is_null($i_biduser_id)) {
$curBidValue1 = $i_baseprice;
$curBidValue2 = $i_baseprice + $i_increment;
$curBidValue3 = $i_baseprice + $i_increment * 2;
$curBidValue4 = $i_baseprice + $i_increment * 3;
} else {
$curBidValue1 = $i_bidvalue + $i_increment;
$curBidValue2 = $i_bidvalue + $i_increment * 2;
$curBidValue3 = $i_bidvalue + $i_increment * 3;
<?php
session_start();
$myUserid = $_SESSION['tek_emailid'];
$myUsername = $_SESSION['tek_fname'];
//error_reporting(0);
include 'json_func.php';
include 'database.php';
if (isset($_POST['bidValue'])) {
$div_id = "bidfnc";
$bidvalue = $_POST['bidValue'];
$i_id = readJsonItem('i_id');
$sql_query = "UPDATE `items` SET `i_bidvalue` = '{$bidvalue}' , `i_biduser_id` = '{$myUserid}' , `i_biduser_name` = '{$myUsername}',`i_is_won` = '0' WHERE `i_id` = '{$i_id}' AND `i_bidvalue` < '{$bidvalue}'";
$sql_res = mysqli_query($link, $sql_query);
if (mysqli_affected_rows($link) == 1) {
exportToJsonLiveBid($bidvalue, $myUserid, $myUsername, $i_id);
}
}
?>
<div class="panel-body" id="bidfnc">
<img src="images/wait.gif" height="150px" width="150px"></img>
</div>
function updatewinner()
{
include 'database.php';
$curtime = date("Y-m-d H:i:s");
if (readJsonItem('i_endtime') == null) {
return 3;
} elseif (readJsonItem('i_endtime') <= $curtime) {
$query = "SELECT `i_id`,`i_baseprice`, `i_actualprice`, `i_increment`,`i_bidvalue`, `i_biduser_id` FROM `items` WHERE (`i_is_won` = '0') AND (`i_endtime` < '{$curtime}') ORDER BY i_endtime DESC LIMIT 1";
$res = mysqli_query($link, $query);
if (mysqli_num_rows($res) > 0) {
$row = mysqli_fetch_assoc($res);
$up_i_bidvalue = $row["i_bidvalue"];
$up_i_id = $row["i_id"];
$up_i_biduser_id = $row["i_biduser_id"];
$up_i_actualprice = $row["i_actualprice"];
$query_cur_usr = "******";
$res_cur_usr = mysqli_query($link, $query_cur_usr);
$cur_usr_row = mysqli_fetch_assoc($res_cur_usr);
$up_u_cashspent = $cur_usr_row["u_cashspent"] + $up_i_bidvalue;
$up_u_newcashbalance = $cur_usr_row["u_cashbalance"] - $up_i_bidvalue;
$up_u_itemswon = $cur_usr_row["u_itemswon"] + 1;
$up_u_megapoints = $cur_usr_row["meg_points"];
if ($up_u_megapoints == 900) {
$up_u_megapoints = 1000;
} elseif ($up_u_megapoints + 150 < 1000) {
$up_u_megapoints = $cur_usr_row["meg_points"] + 150;
} else {
$up_u_megapoints = $up_u_megapoints + 0;
}
$cur_itempoints = 0;
if ($up_i_bidvalue <= $up_i_actualprice / 2) {
$cur_itempoints = 6;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 3 / 5) {
$cur_itempoints = 7;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 7 / 10) {
$cur_itempoints = 8;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 4 / 5) {
$cur_itempoints = 9;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 11 / 10) {
$cur_itempoints = 10;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 6 / 5) {
$cur_itempoints = 9;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 13 / 10) {
$cur_itempoints = 8;
} elseif ($up_i_bidvalue <= $up_i_actualprice * 7 / 5) {
$cur_itempoints = 7;
} else {
$cur_itempoints = 6;
}
$up_u_itempoints = $cur_itempoints + $cur_usr_row["u_itempoints"];
$up_query_usr = "******";
$up_query_itm = "UPDATE `items` SET `i_is_won`='1' WHERE `i_id` = {$up_i_id}";
$up_res_usr = mysqli_query($link, $up_query_usr);
$up_res_itm = mysqli_query($link, $up_query_itm);
//update mega-event points
include 'common-code.php';
sendScore("auction-it", $up_u_megapoints, $user_id);
return 0;
} else {
return 2;
}
} else {
return 1;
}
}
