|
|
 |
|
|
 |
|
|
�� ��¥���� ��� */
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
?>
2) {
$next_range_end = substr($range_end,2);
} else {
$next_range_end = 0;
}
}
$today = date("Ymd");
?>
= curdate() AND withdraw='n' and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
} else if($sub_catenum == '2') {
$sub_table = "f_recipe";
$query3 = "select anum from $sub_table where withdraw='n' and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
} else if($sub_catenum == '3') {
$sub_table = "f_grocery";
$query3 = "select anum from $sub_table where end >= curdate() AND withdraw='n' and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
} else {
if(!$c) {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '21000000' and ('21000000' + $next_range_end)) ";
} else {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
}
}
} else {
if(!$c) {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '21000000' and ('21000000' + $next_range_end)) ";
} else {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
}
}
$result3 = mysqli_query($query3,$connect);
$total_count = @mysqli_num_rows($result3);
if(!fmod($i,2)) {
echo("
");
}
echo("
 |
");
if(isset($page) && $page_from == 'index') {
echo("
$catename
");
} else {
if($cook) {
$s_ck = 'y';
$catenum = $catenum;
} else {
if($catenum == '4000000') {
$s_ck = 'y';
$catenum = '21000000';
} else {
$s_ck = '';
$catenum = $catenum;
}
}
echo("
$catename
");
}
if($total_count>$listnum){
echo "($total_count)";
}
echo("
|
");
if(!fmod($i,2)) {
if($j == ($total -1)) {
echo("
|
");
} else {
echo("
|
");
}
} else if(fmod($i,2)) {
echo("
");
}
}
// 1st column of Category ends
?>
|
insertState()
insertCity($state)
insertTown($city);
");
}
//
// Searching by locations ends
//
$location_condt = "";
if(isset($town) && $town) {
$location_condt .= "town_no=".$town;
} else {
if(isset($city) && $city) {
$location_condt .= "city_no=".$city;
} else {
if(isset($state) && $state) {
$location_condt .= "state_no=".$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("../find/keyword_search.php");
$where_in_qry .= " AND $query0";
}
} else {
if(isset($keyword) && $keyword) {
include("../find/keyword_search.php");
$where_in_qry = "$query0";
}
}
?>
= curdate() AND withdrawn IS NULL";
} else {
$select="SELECT * FROM $table WHERE end >= curdate() AND withdraw='n'";
}
if(isset($sort2) && $sort2=="all"){
$sort_2 .= "";
$selected2_all=" selected";
} else if(isset($sort2) && $sort2=="p") {
$sort_2 .= " ( e_type LIKE '%p%' )";
$selected2_style=" selected";
} else if(isset($sort2) && $sort2=="r") {
$sort_2 .= " ( registered='Y')";
$selected2_registered=" selected";
} else if(isset($sort2) && $sort2=="dp") {
$sort_2 .= " ( qualification='dp')";
$selected2_diploma=" selected";
} else if(isset($sort2) && $sort2=="dg") {
$sort_2 .= " ( qualification='dg')";
$selected2_degree=" selected";
} else if(isset($sort2) && $sort2=="photo") {
$sort_2 .= " ( photo != '')";
$selected2_photo=" selected";
} else if(isset($sort2) && $sort2=="online") {
$sort_2 .= " ( online_shopping = 'y')";
$selected2_online=" selected";
} else if(isset($sort2) && $sort2=="parking") {
$sort_2 .= " ( parking = 'y')";
$selected2_parking=" selected";
} else if(isset($sort2) && $sort2=="byo") {
$sort_2 .= " ( byo = 'y' OR res_type = '1')";
$selected2_byo=" selected";
} else if(isset($sort2) && $sort2=="breakfast") {
$sort_2 .= " ( res_type = '2')";
$selected2_breakfast=" selected";
} else if(isset($sort2) && $sort2=="child") {
$sort_2 .= " ( res_type = '3')";
$selected2_child=" selected";
} else if(isset($sort2) && $sort2=="hostel") {
$sort_2 .= " ( res_type = '4')";
$selected2_hostel=" selected";
} else if(isset($sort2) && $sort2=="live") {
$sort_2 .= " ( res_type = '5')";
$selected2_live=" selected";
} else if(isset($sort2) && $sort2=="outdoor") {
$sort_2 .= " ( res_type = '6')";
$selected2_outdoor=" selected";
} else if(isset($sort2) && $sort2=="private") {
$sort_2 .= " ( res_type = '7')";
$selected2_private=" selected";
} else if(isset($sort2) && $sort2=="bar") {
$sort_2 .= " ( res_type = '8')";
$selected2_bar=" selected";
} else if(isset($sort2) && $sort2=="100") {
$sort_2 .= " ( res_type = '9')";
$selected2_100=" selected";
} else if(isset($sort2) && $sort2=="wed") {
$sort_2 .= " ( res_type = '10')";
$selected2_wed=" selected";
} else if(isset($sort2) && $sort2=="weekend") {
$sort_2 .= " ( res_type = '11')";
$selected2_weekend=" selected";
}
if(isset($sort2) && $sort2=="all"){
$sort_2 .= "";
$selected2_all=" selected";
} else if(isset($sort2) && $sort2=="ft") {
$sort_2 .= " ( e_type='f')";
$selected2_etype_f=" selected";
} else if(isset($sort2) && $sort2=="pt") {
$sort_2 .= " ( e_type='p')";
$selected2_etype_p=" selected";
} else if(isset($sort2) && $sort2=="vol") {
$sort_2 .= " ( e_type='v')";
$selected2_etype_v=" selected";
} else if(isset($sort2) && $sort2=="fc") {
$sort_2 .= " ( c_type='f')";
$selected2_ctype_f=" selected";
} else if(isset($sort2) && $sort2=="tc") {
$sort_2 .= " ( c_type='t')";
$selected2_ctype_t=" selected";
} else if(isset($sort2) && $sort2=="con") {
$sort_2 .= " ( c_type='c')";
$selected2_ctype_c=" selected";
}
///category cate_limit
if(isset($c1) && $c1){
$cate_limit = "( catenum BETWEEN $c1 AND $c1+999999 )";
} elseif(isset($c2) && $c2){
$cate_limit = "( catenum BETWEEN $c2 AND $c2+9999 )";
} elseif(isset($c3) && $c3){
$cate_limit = "( catenum BETWEEN $c3 AND $c3+99 )";
} elseif(isset($c4) && $c4){
$cate_limit = "( catenum = $c4 )";
} else {
$cate_limit = "( catenum BETWEEN 1000000 AND 1999999 )";
}
if(isset($sort1) && $sort1=="all") {
$sort_1="";
$selected1_all=" selected";
} else if(isset($sort1) && $sort1=="title") {
if($cook) {
$sort_1=" ORDER BY title ASC";
} else {
$sort_1=" ORDER BY prod_name ASC";
}
$selected1_title=" selected";
} else if(isset($sort1) && $sort1=="new") {
$sort_1=" ORDER BY start DESC";
$selected1_new=" selected";
} else if(isset($sort1) && $sort1=="size") {
$sort_1=" ORDER BY students DESC";
$selected1_size=" selected";
} else if(isset($sort1) && $sort1=="tuition") {
$sort_1=" ORDER BY tuition ASC";
$selected1_tuition=" selected";
} else {
if($cook) {
$sort_1 = " ORDER BY premier ASC,reg_date DESC";
} else {
$sort_1 = " ORDER BY premier ASC,start 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;
}
if(($cate_limit && !$keyword) || ($cate_limit && $insearch==1 && $keyword)) {
$cond .= " AND ".$cate_limit;
}
if(($PHP_SELF == '/index.php') && ($sub_cate != '2')) {
$cond .= " AND (frontp=1)";
}
$query_tatal=$select.$cond.$sort_1; //category limit
//echo $query_tatal;
// Forming a query ends
///category transform
if(isset($c1) && $c1){ $catenum_l=$c1; }
elseif(isset($c2) && $c2){ $catenum_l=$c2; }
elseif(isset($c3) && $c3){ $catenum_l=$c3; }
elseif(isset($c4) && $c4){ $catenum_l=$c4; }
if(isset($town) && $town){$town_l = "&town=".$town; }
if(isset($city) && $city){$city_l = "&city=".$city; }
if(isset($state) && $state){$state_l = "&state=".$state; }
if(isset($keyword) && $keyword){$keyword_l = "&keyword=".$keyword; }
if(isset($insearch) && $insearch){$insearch_l = "&insearch=".$insearch; }
if(isset($c1) && $c1){ $catetrans1 = "c1" ; $cate_num=$c1; }
elseif(isset($c2) && $c2){$catetrans1 = "c2" ; $cate_num=$c2; }
elseif(isset($c3) && $c3){$catetrans1 = "c3" ; $cate_num=$c3; }
elseif(isset($c4) && $c4){$catetrans1 = "c4" ; $cate_num=$c4; }
else {
$catetrans1 = "c1" ; $cate_num=$c1;
}
if(isset($catetrans1) && $catetrans1) {
$pass_cate = $catetrans1."=".$cate_num;
} else {
$pass_cate = $catetrans1."=".$cate_num;
}
// Sets a url for the shopinfo
$trade_url = $PHP_SELF."?state=$state&city=$city&town=$town&keyword=$keyword&insearch=$insearch";
?>
|
|
|
