|
|||
 |
|||
|
|||
�� ��¥���� ��� */ function remain_cls($end_time) { $timestamp=mktime(substr($end_time,8,2),substr($end_time,10,2),0,substr($end_time,4,2),substr($end_time,6,2),substr($end_time,2,2)); $now_time=time(); $remain_time = (int)$timestamp - (int)$now_time; $t_res = getdate($timestamp); if((int)$remain_time<=0){ $remain = "Closes"; }elseif($remain_time<3600){ $remain = $t_res[minutes]."m"; }elseif(($remain_time<86400)&&($remain_time>=3600)){ $h= (int)($remain_time/3600); $m= (int)($remain_time%3600); $remain = $h."h"." ".(int)($m/60)."m"; //echo $remain_time; // if($t_res[minutes]==0){ // $remain = $t_res[hours]."h"; // }elseif($t_res[minutes]!=0){ // $remain = $t_res[hours]."h"." ".$t_res[minutes]."m"; // } }elseif((int)$remain_time>86400){ $remain = $t_res[mday]." ".substr($t_res[month],0,3)."
".substr($t_res[weekday],0,3); } return $remain; } function remain_cls0($end_time) { $timestamp=mktime(substr($end_time,8,2),substr($end_time,10,2),0,substr($end_time,4,2),substr($end_time,6,2),substr($end_time,2,2)); $remain01 = date("g:i a , d M y", $timestamp); return $remain01; } function remain_cls1($end_time) { //for index3.php 204 $timestamp=mktime(substr($end_time,8,2),substr($end_time,10,2),0,substr($end_time,4,2),substr($end_time,6,2),substr($end_time,2,2)); $now_time=time(); $remain_time = (int)$timestamp - (int)$now_time; $d= (int)($remain_time/86400); $h= (int)($remain_time/3600); $m= (int)($remain_time%3600); $hh= (int)($remain_time%86400)/3600; $hh = (int)$hh; if((int)$remain_time<=0){ $remain = "closes"; }elseif($remain_time<3600){ $remain = $remain_time/60 ; $remain = (int)$remain." min" ; }elseif(($remain_time<86400)&&($remain_time>=3600)){ if($t_res[minutes]==0){ $remain = " ".$h." Hours"." ".(int)($m/60)." m "; //replace sec } }elseif((int)$remain_time>86400){ $remain = $d." days"." ".$hh." h"." ".(int)($m/60)." m"; } return $remain; } function remain_cls2($end_time) { //for index3.php 535 $timestamp=mktime(substr($end_time,8,2),substr($end_time,10,2),0,substr($end_time,4,2),substr($end_time,6,2),substr($end_time,2,2)); $now_time=time(); $remain_time = (int)$timestamp - (int)$now_time; $d= (int)($remain_time/86400); $h= (int)($remain_time/3600); $m= (int)($remain_time%3600); $hh= (int)($remain_time%86400)/3600; $hh = (int)$hh; if((int)$remain_time<=0){ $remain = "closes"; }elseif($remain_time<3600){ $remain = $remain_time/60 ; $remain = (int)$remain." min" ; }elseif(($remain_time<86400)&&($remain_time>=3600)){ if($t_res[minutes]==0){ $remain = " ".$h." Hours"." ".(int)($m/60)." m "; //replace sec } }elseif((int)$remain_time>86400){ $remain = $d." days,"." ".$hh." hr,"." ".(int)($m/60)." mins"; } return $remain; } function remain_cls3($end_time) { $timestamp=mktime(substr($end_time,8,2),substr($end_time,10,2),0,substr($end_time,4,2),substr($end_time,6,2),substr($end_time,2,2)); $remain01 = date("G:i j/n/y", $timestamp); return $remain01; } function remain_cls4($anum,$connect) { $query_e="select * from auct_master_join where (anum='$anum' and join_gb='1') order by jnum desc"; // echo $query_e; $result_e=mysqli_query($query_e,$connect); $row_end=mysqli_fetch_array($result_e); mysql_free_result($result_e); $timestamp=mktime(substr($row_end[join_created],8,2),substr($row_end[join_created],10,2),0,substr($row_end[join_created],4,2),substr($row_end[join_created],6,2),substr($row_end[join_created],2,2)); $remain04 = date("G:i j/n/y", $timestamp); return $remain04; } ///////////////////////////////////////////////////////////// function my_connect1($host,$id,$pass,$db) { $connect=mysqli_connect($host,$id,$pass); mysqli_select_db($connect, $db); return $connect; } /// local info ?>
insertState() insertCity($state) insertTown($city); "); } // // Searching by locations ends // $location_condt = ""; if(isset($town) && $town) { $location_condt .= "event_town=".$town; } else { if(isset($city) && $city) { $location_condt .= "event_city=".$city; } else { if(isset($state) && $state) { $location_condt .= "event_state=".$state; } else { if(isset($f_left_country) && $f_left_country) { $location_condt .= "country_no=".$left_country; } } } } $where_in_qry = ""; if($location_condt) { $where_in_qry .= $location_condt; if(isset($keyword) && $keyword) { include("../buying/keyword_search.php"); $where_in_qry .= " AND $query0"; } } else { if(isset($keyword) && $keyword) { include("../buying/keyword_search.php"); $where_in_qry = "$query0"; } } ?> = curdate()"; if(isset($sort2) && $sort2) { $sort_2 = "cate_num=$sort2"; } else { $sort_2 = ""; } if(isset($sort1) && $sort1=="all") { $sort_1=""; $selected1_all=" selected"; } else if(isset($sort1) && $sort1=="hot") { $sort_1=" ORDER BY cnt DESC"; $selected1_hot=" selected"; } else if(isset($sort1) && $sort1=="soon") { $sort_1=" ORDER BY event_day ASC"; $selected1_soon=" selected"; } else { $sort_1 = " ORDER BY create_day DESC"; } $cond = ""; if(isset($sort_2) && $sort_2) { $cond .= " AND ".$sort_2; } if(isset($where_in_qry) && $where_in_qry) { $cond .= " AND ".$where_in_qry; } $query_tatal=$select.$cond.$sort_1; // Forming a query ends ///category transform if(isset($town) && $town){$town_l = "&town=".$town; } if(isset($city) && $city){$city_l = "&city=".$city; } if(isset($state) && $state){$state_l = "&state=".$state; } ?>