|
|
 |
| |
Special Event > Special Event Class Category |
|
 |
| |
|
Special Event Class Category |
|
�� ��¥���� ��� */
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' AND withdrawn IS NULL and (scatenum='$scatenum') and (sc4='$catenum')";
} else {
$catenum=$row_c[scatenum];
$catename=stripslashes($row_c[scatename]);
$query3 = "SELECT e_auct_master.anum,e_company.valid FROM e_auct_master LEFT OUTER JOIN e_company USING(school_no) WHERE valid >= '$today' AND withdrawn IS NULL and (scatenum between '$catenum' and ('$catenum' + $next_range_end))";
}
$result3 = mysqli_query($query3,$connect);
$total_count = mysqli_num_rows($result3);
if(fmod($i,3) == 0) {
echo("
");
}
echo("
 |
|
");
if(fmod($i,3) == 0) {
if($j == ($total -1)) {
echo("
|
");
} else {
echo("
|
");
}
} else if(fmod($i,3) == 2) {
echo("
");
} else if(fmod($i,3) == 1) {
if($j == ($total -1)) {
echo("
|
");
} else {
echo("
|
");
}
}
}
?>
|
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("../buying/keyword_search.php");
$where_in_qry .= " AND $query0";
}
} else {
if(isset($keyword) && $keyword) {
include("../buying/keyword_search.php");
$where_in_qry = "$query0";
}
}
?>
= '$today' AND withdrawn IS NULL";
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";
}
///category cate_limit
if(isset($c1) && $c1){
$cate_limit = "( scatenum BETWEEN $c1 AND $c1+999999 )";
} elseif(isset($c2) && $c2){
$cate_limit = "( scatenum BETWEEN $c2 AND $c2+9999 )";
} elseif(isset($c3) && $c3){
$cate_limit = "(sc4 = $c3 )";
} else {
$cate_limit = "(scatenum!='' OR sc4!='')";
}
if(isset($sort1) && $sort1=="all") {
$sort_1="";
$selected1_all=" selected";
} else if(isset($sort1) && $sort1=="title") {
$sort_1=" ORDER BY title ASC";
$selected1_title=" selected";
} else if(isset($sort1) && $sort1=="tuition") {
$sort_1=" ORDER BY tuition ASC";
$selected1_tuition=" selected";
} else if(isset($sort1) && $sort1=="size") {
$sort_1=" ORDER BY students ASC";
$selected1_size=" selected";
} else {
$sort_1 = " ORDER BY premier ASC,reg_date 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((isset($first_cate) && !$keyword) || (isset($first_cate) && $insearch ==1 && $keyword)) {
$cond .= " AND ((frontp=1) AND (opt_valid >= '$today'))";
}
if($_REQUEST[co_no]) {
$cond .= " AND seq_num=$_REQUEST[co_no]";
}
$query_tatal=$select.$cond.$sort_1; //category limit
// 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; }
?>
|
|
|
