$post"; #$_SESSION['searchHistory']=array();$_SESSION['searchHistoryTime']=array(); ##START: clear symbol if($enableCARI==1 AND @$_GET['cari']) { $_GET['cari']=strip_tags($_GET['cari']); $_GET['cari']=preg_replace("/[^A-Za-z0-9\-\_ ]/","", $_GET['cari']); #$_GET['cari']=str_replace("\\"," ",$_GET['cari']); #$_GET['cari']=preg_replace("/[~`!@#$%^&*\(\)\-\+\"\':;\?\/=<>\.]/", "", $_GET['cari']); ##START: identified bot, buat2 cari tapi bypasskan je //spreq 2 apr 2021. //Y? sebab ada keyword yang didapati di hantar oleh bot. bypass utk jimat processor $BOTKEYWORDS['talkza']=1; if(in_array(strtolower($_GET['cari']),$BOTKEYWORDS)) {$bypassThisSearch=1;} ##END: identified bot, buat2 cari tapi bypasskan je } if(@$_GET['url']) { # $_GET['url']=preg_replace("/[~`!@#$%^&*\(\)\-\+\"\':;\?\/=<>\.]/", "", $_GET['url']); } ##END: clear symbol ##START: PART 1 - FWD to $url if($enableCARI==1 AND @$_GET['url']) { $cr_url1=$cr_url2=$cr_url3=""; #SPREQ: SEPATUTNYA GUNA 'CARIAN' ni betul tapi data takde lagi # $sql="select cr_url1,cr_url2,cr_url3 from carian where cr_tarikh_carian_epoch=".$_SESSION['lastSearch'][0]." AND cr_katakunci='".$_SESSION['lastSearch'][1]."'"; $sql="select cr_url1,cr_url2,cr_url3 from carian_".strtolower(@$TEMP_SETTING['LIVEDB']['server_loc'])." where cr_tarikh_carian_epoch=".$_SESSION['lastSearch'][0]." AND cr_katakunci='".$_SESSION['lastSearch'][1]."'"; $result=mysqli_query($con,$sql); if(@result and mysqli_num_rows($result)>0) { list($cr_url1,$cr_url2,$cr_url3)=mysqli_fetch_array($result); if(!@$cr_url1) $cr_url1=$_GET['url']; else if(!@$cr_url2) $cr_url2=$_GET['url']; else if(!@$cr_url3) $cr_url3=$_GET['url']; else $cr_url3=$_GET['url']; } /* FWD ke URL dan simpan */ $sql="update carian_".strtolower(@$TEMP_SETTING['LIVEDB']['server_loc'])." set cr_url1='$cr_url1',cr_url2='$cr_url2',cr_url3='$cr_url3',cr_country='".@$_GET['COUNTRY']."' where cr_tarikh_carian_epoch=".@$_SESSION['lastSearch'][0]." AND cr_katakunci='".$_SESSION['lastSearch'][1]."'"; $result=mysqli_query($con,$sql); if(!$result) {print"PROBLEM 372xxx
"; $handler=fopen("../webupm_data/problem.txt","a"); fwrite($handler,date('U')."|$_SERVER[REMOTE_ADDR]|$sql|".mysqli_error($con)."\r\n"); fclose($handler); } $url=urldecode($_GET['url']); print ""; } ##START: PART1 - FWD tu $url ##START: PART 2- settle word else if($enableCARI==1 AND (@!$_GET['cari'] or strlen(@$_GET['cari'])<3) AND !@$_GET['url'] AND (strtolower(@$_GET['cari'])!='vc' AND strtolower(@$_GET['cari'])!='nc')) { if(@$LANG=="en") print""; else print""; } else if($enableCARI==1 AND (@$_GET['cari'] AND strlen(@$_GET['cari'])>2 AND !@$_GET['url']) OR (strtolower(@$_GET['cari'])=='vc' OR strtolower(@$_GET['cari'])=='nc')) { $_GET['cari']=trim($_GET['cari']); ##START: split if multiple words if(preg_match("/ /",@$_GET['cari'])) $words=explode(" ",$_GET['cari']); else $words=array($_GET['cari']); ##OUTPUT: $words is array of search words, ##END: split if multiple words ##START: filter $words $searchWords=''; $filteredWords=array('binti', 'bte', 'bin'); foreach($words as $key=>$word) { $word=trim($word); ##START: ckean user input if(strlen($word)<3 AND strtolower(@$_GET['cari'])!='vc' AND strtolower(@$_GET['cari'])!='nc') //jika too short {unset($words[$key]); } else if(preg_match("/'/",$word)) //jika ada ' (hack attempt) {unset($words[$key]); } else { ##START: remove by $filteredWords foreach($filteredWords as $X=>$filter) { if(strcasecmp($word,$filter)==0) {unset($words[$key]);} } ##END: remove by $filteredWords } ##END: ckean user input } $jumWords=count($words); foreach($words as $key=>$word) { @$counter++; if($LANG=="en" AND @$words[$key]) @$searchWords.="'".strtoupper($word)."', "; else if(@$words[$key]) @$searchWords.="'".strtoupper($word)."', "; if(($jumWords-$counter)==1 AND $LANG=="en") $searchWords = substr($searchWords,0,-2) . " AND "; else if(($jumWords-$counter)==1) $searchWords = substr($searchWords,0,-2) . " DAN "; } $searchWords = substr($searchWords,0,-2); ##OUTPUT: $searchWords is array of search words, filtered to only valid words ##END: filter $words ##START: for header if($LANG=="en") { $TITLE="SEARCH: ".@$searchWords; $KEYWORD="search, ".strtolower(@$searchWords); $DESC="Search result for '".strtolower(@$searchWords)."'"; } else { $TITLE="CARI: ".@$searchWords; $KEYWORD="cari, ".strtolower(@$searchWords); $DESC="Hasil carian bagi '".strtolower(@$searchWords)."'"; } ##END: for header if(count($words)==0) { if($LANG=="en") print""; else print""; } } ##END: PART 2 - settle word ##START: PART 3 - get number if($enableCARI==1 AND count(@$words)>0 AND @$DATA=="") { ##START: main Search # $dicari=@$_GET['cari']; ##START: save search hist into session if(!@$_SESSION['searchHistory']) { $_SESSION['searchHistory']=array(); $_SESSION['searchHistoryTime']=array(); } foreach($words as $X=>$searchedWord) @$dicari.="$searchedWord "; $dicari=substr($dicari,0,-1); if ($dicari AND !in_array($dicari, $_SESSION['searchHistory'])) { $U=date("U"); array_push($_SESSION['searchHistory'],$dicari); array_push($_SESSION['searchHistoryTime'],$U); $_SESSION['lastSearch']=array($U,$dicari); $U=date('U'); $sql="insert into carian_".strtolower(@$TEMP_SETTING['LIVEDB']['server_loc'])."(cr_katakunci,cr_ip,cr_rkwb_kod_web,cr_tarikh_carian_epoch,cr_country) values ('$dicari','$_SERVER[REMOTE_ADDR]','$PTJ1',$U,'$_SESSION[COUNTRY]')"; $result=mysqli_query($con,$sql); if(!$result) { print"L181
"; //errorLog_mysql($error,$mysql,$php,$line); errorLog_mysql(mysqli_error($con),$sql,"pg_cari.php",181); } } ##END: save search hist into session ##START: show option if($LANG=='en'){$whole="Whole";} else {$whole="Seluruh";} if(@$_GET['o']=='a'){$searchOpt_Domain='type=unselected'; $searchOpt_All='type=selected';} else {$searchOpt_Domain='type=selected'; $searchOpt_All='type=unselected';} print""; ##END: show option if(@$bypassThisSearch!=1) { ##START: cari dari artikel ---------------------------- $searchRules=rulesCarian($words,array("artikel.ar_ringkasan_bm", "artikel.ar_ringkasan_bi", "kandungan.kdg_tajuk_bm","kandungan.kdg_teks_bm", "kandungan.kdg_tajuk_bi","kandungan.kdg_teks_bi")); $limitToPTJ="AND (ar_papar_semua_ptj=1 AND kdg_rkwb_kod_web='$PTJ1')"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from artikel, kandungan,ruj_kod_web where ($searchRules) and artikel.ar_kdg_kod_kandungan=kandungan.kdg_kod_kandungan AND ar_status=1 $limitToPTJ AND ruj_kod_web.rkwb_status=1 AND ruj_kod_web.rkwb_rkw_kod_kategori_web='W1' AND ruj_kod_web.rkwb_kod_web=artikel.ar_rkwb_kod_web "; $result=mysqli_query($con,$sql); list($resultArtikel)=mysqli_fetch_array($result); if($resultArtikel==0 and $LANG=='en')$resultArtikel="NO"; else if($resultArtikel==0)$resultArtikel="TIADA"; ##END: cari dari artikel ================================ ##START: cari dari berita ----------------------- $searchRules=rulesCarian($words,array("kdg_tajuk_bm","kdg_teks_bm","kdg_tajuk_bi","kdg_teks_bi")); $limitToPTJ="AND kdg_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from kandungan,ruj_kod_web where ($searchRules) AND kdg_status=1 AND kdg_rkk_kod_jenis='B' $limitToPTJ AND ruj_kod_web.rkwb_status=1 AND ruj_kod_web.rkwb_rkw_kod_kategori_web='W1' AND ruj_kod_web.rkwb_kod_web=kandungan.kdg_rkwb_kod_web"; $result=mysqli_query($con,$sql); list($resultBerita)=mysqli_fetch_array($result); if($resultBerita==0 and $LANG=='en')$resultBerita="NO"; else if($resultBerita==0)$resultBerita="TIADA"; ##END: cari dari berita ========================== ##START: cari dari content ##START: cari dari L1 ----------------------------- $searchRules=rulesCarian($words,array("ml1_tajuk_bm","ml1_tajuk_bi","ml1_teks_bm","ml1_teks_bi")); $limitToPTJ="AND ml1_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from menu_l1,ruj_kod_web where ml1_status='1' $limitToPTJ AND ($searchRules) AND ruj_kod_web.rkwb_status=1 AND ruj_kod_web.rkwb_rkw_kod_kategori_web='W1' AND ruj_kod_web.rkwb_kod_web=menu_l1.ml1_rkwb_kod_web"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) list($countL1)=mysqli_fetch_array($result); ##END: cari dari L1 ======================= ##START: cari dari L2 ------------------------- $searchRules=rulesCarian($words,array("ml2_tajuk_bm","ml2_tajuk_bi","ml2_teks_bm","ml2_teks_bi")); $limitToPTJ="AND ml1_rkwb_kod_web='$PTJ1' AND ml2_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from menu_l1,menu_l2,ruj_kod_web where menu_l2.ml2_status='1' $limitToPTJ AND ml1_kod=ml2_ml1_kod AND ($searchRules) AND ruj_kod_web.rkwb_status=1 AND ruj_kod_web.rkwb_rkw_kod_kategori_web='W1' AND ruj_kod_web.rkwb_kod_web=menu_l2.ml2_rkwb_kod_web"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) list($countL2)=mysqli_fetch_array($result); ##END: cari dari L2 ================================ ##START: cari dari L3 --------------------------- $searchRules=rulesCarian($words,array("kdg_tajuk_bm","kdg_tajuk_bi","kdg_teks_bm","kdg_teks_bi")); $limitToPTJ="ml1_rkwb_kod_web='$PTJ1' AND ml2_rkwb_kod_web='$PTJ1' AND ml3_rkwb_kod_web='$PTJ1' AND "; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from menu_l1, menu_l2, menu_l3, kandungan, ruj_kod_web where $limitToPTJ menu_l1.ml1_kod=menu_l2.ml2_ml1_kod AND menu_l2.ml2_kod=menu_l3.ml3_ml2_kod AND menu_l3.ml3_kdg_kod_kandungan=kandungan.kdg_kod_kandungan AND menu_l3.ml3_status='1' AND ($searchRules) AND ruj_kod_web.rkwb_status=1 AND ruj_kod_web.rkwb_rkw_kod_kategori_web='W1' AND ruj_kod_web.rkwb_kod_web=menu_l3.ml3_rkwb_kod_web"; #print $sql; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) list($countL3)=mysqli_fetch_array($result); ##END: cari dari L3 ================================= #print "A$countL1 + B$countL2 + C$countL3"; if((@$countL1+@$countL2+@$countL3)==0 and $LANG=='en')$resultContent="NO"; else if((@$countL1+@$countL2+@$countL3)==0)$resultContent="TIADA"; ##END: cari dari content ##START: cari dari dokumen -------------------------- $searchRules=rulesCarian($words,array("fw_uploads.nama","dokumen.dk_nama_dokumen_bm","dokumen.dk_nama_dokumen_bi")); $limitToPTJ="AND dokumen.dk_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from dokumen,fw_uploads where ($searchRules) AND dokumen.dk_status=1 $limitToPTJ AND dokumen.dk_nama_fail=fw_uploads.id"; $result=mysqli_query($con,$sql); list($resultDokumen)=mysqli_fetch_array($result); if($resultDokumen==0 and $LANG=='en')$resultDokumen="NO"; else if($resultDokumen==0)$resultDokumen="TIADA"; ##END: cari dari dokumen =========================== ##START: cari dari aktiviti ----------------------- $searchRules=rulesCarian($words,array("akt_tajuk_bm","akt_tajuk_bi", "akt_lokasi_bm", "akt_lokasi_bi", "akt_ringkasan_bm", "akt_ringkasan_bi")); $limitToPTJ=" AND akt_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select count(*) from aktiviti where ($searchRules) $limitToPTJ"; $result=mysqli_query($con,$sql); list($resultAktvt)=mysqli_fetch_array($result); if($resultAktvt==0 and $LANG=='en')$resultAktvt="NO"; else if($resultAktvt==0)$resultAktvt="TIADA"; ##END: cari dari aktiviti ===================== ##START: cari dari direktori ---------------------------- $KODJAB=""; $searchRules=rulesCarian($words,array("ruj_profile_staf.rps_nama_staf")); if(@$_GET['o']=='a' OR $PTJ1=="UPM") $sql="select DISTINCT ruj_nokpkey.rnk_no_staf from ruj_staf,ruj_profile_staf,ruj_nokpkey , ruj_sapaan, ruj_jawatan where ruj_staf.rs_no_kp=ruj_profile_staf.rps_no_kp AND ruj_staf.rs_kod_jawatan=ruj_jawatan.rj_kod_jawatan AND ruj_staf.rs_no_kp=ruj_nokpkey.rnk_nokp AND ruj_sapaan.rsp_id=ruj_staf.rs_sapaan AND ruj_profile_staf.rps_no_kp=ruj_nokpkey.rnk_nokp AND ruj_nokpkey.rnk_no_staf=ruj_staf.rs_no_staf AND ruj_nokpkey.rnk_status_aktif='A' AND ($searchRules)"; else { $dirFound=array(); ##START: get all kod jabatan $sql="select rptj_kod_org,rptj_nama_ptj from ruj_ptj where rptj_kod_induk='$PTJ1'"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { while(list($kod,$jab)=mysqli_fetch_array($result)) { $JAB[$kod]=$jab; $KODJAB.="OR ruj_staf.rs_kod_org='$kod' "; } $KODJAB=substr($KODJAB,0,-1); } ##END: get all kod jabatan $sql="select DISTINCT ruj_nokpkey.rnk_no_staf FROM ruj_staf,ruj_profile_staf,ruj_nokpkey,ruj_jawatan, ruj_sapaan WHERE ruj_staf.rs_no_kp=ruj_profile_staf.rps_no_kp AND ruj_staf.rs_kod_jawatan=ruj_jawatan.rj_kod_jawatan AND ruj_staf.rs_no_kp=ruj_nokpkey.rnk_nokp AND ruj_profile_staf.rps_no_kp=ruj_nokpkey.rnk_nokp AND ruj_sapaan.rsp_id=ruj_staf.rs_sapaan AND ruj_nokpkey.rnk_no_staf = ruj_staf.rs_no_staf AND ($searchRules) AND (ruj_staf.rs_kod_org='$PTJ1' $KODJAB) AND ruj_nokpkey.rnk_status_aktif='A' ORDER by ruj_profile_staf.rps_nama_staf"; } $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { while(list($noStaf)=mysqli_fetch_array($result)) { $dirFound[$noStaf]=1; } } ##START: cari dari jawatan pentadbiran $searchRules=rulesCarian($words,array("ruj_kod_jawatan_pentadbiran.rjw_keterangan")); if($PTJ1=="UPM" OR @$_GET['o']=='a') $sql="SELECT ruj_nokpkey.rnk_no_staf FROM ruj_kod_jawatan_pentadbiran, ruj_jawatan_pentadbiran, ruj_nokpkey, ruj_profile_staf, ruj_staf, ruj_sapaan WHERE ruj_jawatan_pentadbiran.k_tdbr=ruj_kod_jawatan_pentadbiran.rjw_kod_jawatan AND ruj_jawatan_pentadbiran.no_staf=ruj_nokpkey.rnk_no_staf AND ruj_nokpkey.rnk_no_staf=ruj_nokpkey.rnk_no_staf AND ruj_nokpkey.rnk_nokp=ruj_profile_staf.rps_no_kp AND ruj_profile_staf.rps_no_kp= ruj_staf.rs_no_kp AND ruj_staf.rs_sapaan=ruj_sapaan.rsp_id AND (ruj_jawatan_pentadbiran.tkh_tamat>now() OR ruj_jawatan_pentadbiran.tkh_tamat is null) AND ruj_nokpkey.rnk_status_aktif='A' AND ($searchRules)"; else $sql="SELECT ruj_nokpkey.rnk_no_staf FROM ruj_kod_jawatan_pentadbiran, ruj_jawatan_pentadbiran, ruj_nokpkey, ruj_profile_staf, ruj_staf, ruj_sapaan WHERE ruj_jawatan_pentadbiran.k_tdbr=ruj_kod_jawatan_pentadbiran.rjw_kod_jawatan AND ruj_jawatan_pentadbiran.no_staf=ruj_nokpkey.rnk_no_staf AND ruj_nokpkey.rnk_no_staf=ruj_nokpkey.rnk_no_staf AND ruj_nokpkey.rnk_nokp=ruj_profile_staf.rps_no_kp AND ruj_profile_staf.rps_no_kp= ruj_staf.rs_no_kp AND ruj_staf.rs_sapaan=ruj_sapaan.rsp_id AND (ruj_jawatan_pentadbiran.tkh_tamat>now() OR ruj_jawatan_pentadbiran.tkh_tamat is null) AND ruj_nokpkey.rnk_status_aktif='A' AND (ruj_jawatan_pentadbiran.k_ptj='$PTJ1' $KODJAB) AND ($searchRules)"; $result=mysqli_query($con,$sql); #ruj_profile_staf.rps_nama_staf if(mysqli_num_rows($result)>0) { while(list($noStaf)=mysqli_fetch_array($result)) { $dirFound[$noStaf]=1; } } ##END: cari dari jawatan pentadbiran ##START: cari dari jawatan biasa $searchRules=rulesCarian($words,array("ruj_jawatan.rj_keterangan")); if($PTJ1=="UPM" OR @$_GET['o']=='a') $sql="select DISTINCT ruj_staf.rs_no_staf, ruj_sapaan.rsp_keterangan, ruj_profile_staf.rps_nama_staf, ruj_nokpkey.rnk_upm_id, ruj_jawatan.rj_keterangan, ruj_profile_staf.rps_no_telefon, ruj_profile_staf.rps_no_telefon_2,ruj_staf.rs_kod_org FROM ruj_jawatan, ruj_staf, ruj_profile_staf, ruj_sapaan, ruj_nokpkey WHERE ruj_staf.rs_kod_jawatan=ruj_jawatan.rj_kod_jawatan AND ruj_staf.rs_sapaan=ruj_sapaan.rsp_id AND ruj_staf.rs_no_kp=ruj_profile_staf.rps_no_kp AND ruj_profile_staf.rps_no_kp=ruj_nokpkey.rnk_nokp AND ruj_nokpkey.rnk_no_staf = ruj_staf.rs_no_staf AND ruj_nokpkey.rnk_status_aktif='A' AND ($searchRules) ORDER BY ruj_profile_staf.rps_nama_staf"; else $sql="select ruj_nokpkey.rnk_no_staf FROM ruj_jawatan, ruj_staf, ruj_profile_staf, ruj_sapaan, ruj_nokpkey WHERE ruj_staf.rs_kod_jawatan=ruj_jawatan.rj_kod_jawatan AND ruj_staf.rs_sapaan=ruj_sapaan.rsp_id AND ruj_staf.rs_no_kp=ruj_profile_staf.rps_no_kp AND ruj_profile_staf.rps_no_kp=ruj_nokpkey.rnk_nokp AND ruj_nokpkey.rnk_no_staf = ruj_staf.rs_no_staf AND ruj_nokpkey.rnk_status_aktif='A' AND (ruj_staf.rs_kod_org='$PTJ1' $KODJAB) AND ($searchRules) "; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { while(list($noStaf)=mysqli_fetch_array($result)) { $dirFound[$noStaf]=1; } } ##END: cari dari jawatan biasa $totalDir=count(@$dirFound); if($totalDir==0 and $LANG=='en')$resultDir="NO"; else if($totalDir==0)$resultDir="TIADA"; ##END: cari dari direktori ============================= ##START: cari dari upmexpert ============================= $searchRules=rulesCarian($words,array("upmexpert.nama","upmexpert.bidang", "upmexpert.bidangEN")); $sql="select count(*) FROM upmexpert WHERE $searchRules and status=1"; $result=mysqli_query($con,$sql); list($resultExpert)=mysqli_fetch_array($result); if($resultExpert==0 and $LANG=='en')$resultExpert="NO"; else if($resultExpert==0)$resultExpert="TIADA"; ##END: cari dari upmexpert ============================= ##START: cari dari lokasi -------------------------- $searchRules=rulesCarian($words,array("lokasi.lk_lokasi_bm","lokasi.lk_lokasi_bi", "ruj_kategori_lokasi.rkl_kategori_bm", "ruj_kategori_lokasi.rkl_kategori_bi")); if($PTJ1=="UPM" OR @$_GET['o']=='a') $sql="SELECT count(*) FROM lokasi,ruj_kategori_lokasi WHERE lokasi.lk_rkl_kod_kategori_lokasi=ruj_kategori_lokasi.rkl_kod_kategori_lokasi AND ($searchRules) AND lokasi.lk_status=1"; else $sql="SELECT count(*) FROM lokasi,ruj_kategori_lokasi WHERE lokasi.lk_rkl_kod_kategori_lokasi=ruj_kategori_lokasi.rkl_kod_kategori_lokasi AND ($searchRules) AND lokasi.lk_rkwb_kod_web='$PTJ1' AND lokasi.lk_status=1"; $result=mysqli_query($con,$sql); list($resultLokasi)=mysqli_fetch_array($result); if($resultLokasi==0 and $LANG=='en')$resultLokasi="NO"; else if($resultLokasi==0)$resultLokasi="TIADA"; ##END: cari dari lokasi ============================= ##START: cari dari album ------------------------- $searchRules=rulesCarian($words,array("album.alb_nama_album_bm", "album_foto.af_catatan_bm", "album.alb_nama_album_bi", "album_foto.af_catatan_bi")); $limitToPTJ="AND album.alb_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select DISTINCT album_foto.af_catatan_bm from ruj_kategori_album,album,album_foto,ruj_kod_web where album.alb_kod_album=album_foto.af_alb_kod_album AND album.alb_rjka_kod_kategori_album=ruj_kategori_album.rjka_kod_kategori_album AND ($searchRules) $limitToPTJ AND album.alb_status=1 AND album_foto.af_status=1 AND ruj_kategori_album.rjka_status=1 AND ruj_kod_web.rkwb_kod_web=album.alb_rkwb_kod_web group by album.alb_kod_album"; $result=mysqli_query($con,$sql); if($result) $resultAlbum=mysqli_num_rows($result); else { if($resultAlbum==0 and $LANG=='en')$resultAlbum="NO"; else if($resultAlbum==0)$resultAlbum="TIADA"; } ##END: cari dari album ======================= ##SQL search dari buku disini $resultIR=0; ##START: related website #$resultALLWEB=countRelatedPTJ($words); $resultLINK=checkSuggestedLINK($words); ##END: related website ##START: google $resultGoogle=countGoogle($PTJ,$dicari); ##END: google ##START: untuk left button $_SESSION['searchResult']=array(); array_push($_SESSION['searchResult'],array("Berita","News",$resultBerita)); array_push($_SESSION['searchResult'],array("Artikel","Article",$resultArtikel)); array_push($_SESSION['searchResult'],array("Kandungan","Content",(@$countL1+@$countL2+@$countL3))); array_push($_SESSION['searchResult'],array("Dokumen","Document",$resultDokumen)); array_push($_SESSION['searchResult'],array("Aktiviti","Activity",$resultAktvt)); array_push($_SESSION['searchResult'],array("Direktori","Directory",$totalDir)); # array_push($_SESSION['searchResult'],array("UPMexpert","UPMExpert",$resultExpert)); array_push($_SESSION['searchResult'],array("Lokasi","Location",$resultLokasi)); if(@$resultAlbum)array_push($_SESSION['searchResult'],array("Galeri","Gallery",$resultAlbum)); #array_push($_SESSION['searchResult'],array("IR","IR",$resultIR)); array_push($_SESSION['searchResult'],array("Berkaitan","Related",count($resultLINK))); if($resultGoogle > 0) array_push($_SESSION['searchResult'],array("Google","Google",$resultGoogle)); ##END: untuk left button $TOTAL=($resultBerita + $resultArtikel + @$countL1+@$countL2+@$countL3 + $resultDokumen + $resultAktvt + $totalDir + $resultLokasi + $resultAlbum + count($resultLINK)); } else if(@$bypassThisSearch==1) { if($LANG=='en')$resultAll="NO"; else $resultAll="TIADA"; ##START: untuk left button $_SESSION['searchResult']=array(); array_push($_SESSION['searchResult'],array("Berita","News",$resultAll)); array_push($_SESSION['searchResult'],array("Artikel","Article",$resultAll)); array_push($_SESSION['searchResult'],array("Kandungan","Content",$resultAll)); array_push($_SESSION['searchResult'],array("Dokumen","Document",$resultAll)); array_push($_SESSION['searchResult'],array("Aktiviti","Activity",$resultAll)); array_push($_SESSION['searchResult'],array("Direktori","Directory",$resultAll)); # array_push($_SESSION['searchResult'],array("UPMExpert","UPMExpert",$resultAll)); array_push($_SESSION['searchResult'],array("Lokasi","Location",$resultAll)); array_push($_SESSION['searchResult'],array("Galeri","Gallery",$resultAll)); array_push($_SESSION['searchResult'],array("Berkaitan","Related",$resultAll)); array_push($_SESSION['searchResult'],array("Google","Google",$resultAll)); ##END: untuk left button $TOTAL=0; } ##START: display search result $labelBerita['bm']='BERITA'; $labelBerita['en']='NEWS'; $labelArtikel['bm']='ARTIKEL'; $labelArtikel['en']='ARTICLE'; $labelKandungan['bm']='KANDUNGAN WEB'; $labelKandungan['en']='WEB CONTENT'; $labelDokumen['bm']='DOKUMEN'; $labelDokumen['en']='DOCUMENT'; $labelAktiviti['bm']='AKTIVITI'; $labelAktiviti['en']='ACTIVITY'; $labelDir['bm']='DIREKTORI'; $labelDir['en']='DIRECTORY'; $labelExpert['bm']='UPMExpert'; $labelExpert['en']='UPMExpert'; $labelLokasi['bm']='LOKASI'; $labelLokasi['en']='LOCATION'; $labelAlbum['bm']='ALBUM'; $labelAlbum['en']='ALBUM'; $labelIR['bm']='INFORMATION REPOSITORY'; $labelIR['en']='INFORMATION REPOSITORY'; $labelALLWEB['bm']='CADANGAN PAUTAN'; $labelALLWEB['en']='SUGGESTED LINK'; $labelGoogle['bm']='GOOGLE'; $labelGoogle['en']='GOOGLE'; $padanan['bm']='padanan ditemui'; $padanan['en']['NO']='match found'; function padananWords($LANG,$resultArtikel) { if($resultArtikel==1 AND $LANG=="en"){return 'match found';} else if($resultArtikel>1 AND $LANG=="en"){return 'matches found';} else if($LANG=="en"){return 'match found';} else if($LANG=="bm"){return 'padanan ditemui';} } print"$pre$post"; ##END: display search result ##END: main Search ##START: site if($DEVICE=="d") { $counter=0; print"$pre$post"; } ##END: site $sql="update carian_".strtolower(@$TEMP_SETTING['LIVEDB']['server_loc'])." set cr_bil_jumpa='$TOTAL',cr_bil_google='$resultGoogle' where cr_tarikh_carian_epoch=".$_SESSION['lastSearch'][0]." AND cr_katakunci='".$_SESSION['lastSearch'][1]."'"; $result=mysqli_query($con,$sql); #$affected=mysqli_affected_rows($con); #if($affected==0) print $sql; } ##END: PART 2 - get number ##START: PART 3 - show detail search else if($enableCARI==1 AND count(@$words)>0 AND $DATA!="") { #print"BBBBB $DATA

"; if(count($_SESSION['searchHistory'])>0) { foreach($words as $X=>$searchedWord) @$dicari.="$searchedWord "; $dicari=substr($dicari,0,-1); } $grp=$DATA; if(@$_GET['o']){$optSearch_get='&o=a';} else {$optSearch_get='';} ##START: site if($DEVICE=="d") { #print_r($_SESSION['searchResult']); print"$pre

$post"; } ##END: site if($grp=='berita' OR $grp=='news') { ##START: main Search print"$pre$post"; ##END: main Search } else if($grp=='artikel' OR $grp=='article') { ##START: main Search print"$pre$post"; ##END: main Search } else if($grp=='kandungan' OR $grp=='content') { ##START: main Search print"$pre$post"; ##END: main Search } else if($grp=='dokumen' OR $grp=='document') { ##START: main Search print"$pre$post"; ##END: main Search } else if($grp=='aktiviti' OR $grp=='activity') { ##START: main Search print"$pre$post"; ##END: main Search } else if($grp=='direktori' OR $grp=='directory') { ##START: main Search print"$pre$post"; print"$pre

$post"; if($LANG=="en") { print"$pre\t$post"; } else { print"$pre\t$post"; } ##START: cari dari UPMEXPERT $searchRules=rulesCarian($words,array("nama","bidang", "bidangEN")); $sql="SELECT sapaan,nama,bidang,bidangEN from upmexpert where $searchRules order by nama,bidang"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { $counter=0; $displayNamaPTJ=""; while(list($sapaan,$nama,$bidang,$bidangEN)=mysqli_fetch_array($result)) { $counter++; $Bidang=""; $BIDANG=$BIDANGEN=$ALLbidang=array(); $bidang=str_replace("\"","",$bidang); $bidangEN=str_replace("\"","",$bidangEN); $linkNama=str_replace(" ","",$nama); foreach($words as $Y=>$word) { if(preg_match("/$word/i",$nama)) $Bidang=$bidang.$bidangEN; } if(!$Bidang) //tak match kat nama { if(preg_match("/, /",$bidang)) $BIDANG=explode(", ",$bidang); else if(preg_match("/; /",$bidang)) $BIDANG=explode("; ",$bidang); else $BIDANG[0]=$bidang; if(preg_match("/,/",$bidangEN)) $BIDANGEN=explode(",",$bidangEN); else if(preg_match("/;/",$bidangEN)) $BIDANGEN=explode(";",$bidangEN); else $BIDANGEN[0]=$bidangEN; foreach($BIDANG as $X=>$bidang) { $bidang=trim($bidang); $bidang=ucwords(strtolower($bidang)); foreach($words as $Y=>$word) { $word=ucwords(strtolower(trim($word))); if(preg_match("/$word/i",$bidang) and !in_array($bidang,$ALLbidang)) $ALLbidang[$bidang]=1; } } foreach($BIDANGEN as $X=>$bidang) { $bidang=trim($bidang); $bidang=ucwords(strtolower($bidang)); foreach($words as $Y=>$word) { if(preg_match("/$word/i",$bidang) and !in_array($bidang,$ALLbidang)) $ALLbidang[$bidang]=1; } } foreach($ALLbidang as $bidang=>$X) {$Bidang.=$bidang.", ";} $Bidang=substr($Bidang,0,-2); } print"$pre\t
$post"; } } ##END: cari dari UPMEXPERT print"$pre

$post"; if($LANG=="en") { $tableNamaPTJ="hubungi_kami.hk_nama_ptj_bi"; $order="order by $tableNamaPTJ,lokasi.lk_lokasi_bi"; print"$pre\t$post"; } else { $tableNamaPTJ="hubungi_kami.hk_nama_ptj_bm"; $order="order by $tableNamaPTJ,lokasi.lk_lokasi_bm"; print"$pre\t$post"; } ##START: cari dari LOKASI $searchRules=rulesCarian($words,array("lokasi.lk_lokasi_bm","lokasi.lk_lokasi_bi", "ruj_kategori_lokasi.rkl_kategori_bm", "ruj_kategori_lokasi.rkl_kategori_bi")); $limitToPTJ="AND lokasi.lk_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a' OR $PTJ=='upm')$limitToPTJ=""; $sql="SELECT ruj_kod_web.rkwb_dns, $tableNamaPTJ as namaptj, lokasi.lk_lokasi_bm,lokasi.lk_lokasi_bi,lokasi.lk_latitud,lokasi.lk_longitud, ruj_kategori_lokasi.rkl_kategori_bm,ruj_kategori_lokasi.rkl_kategori_bi FROM lokasi,ruj_kategori_lokasi,ruj_kod_web,hubungi_kami WHERE ruj_kod_web.rkwb_kod_web=lokasi.lk_rkwb_kod_web AND ruj_kod_web.rkwb_kod_web=ruj_kategori_lokasi.rkl_rkwb_kod_web AND lokasi.lk_rkl_kod_kategori_lokasi=ruj_kategori_lokasi.rkl_kod_kategori_lokasi AND ($searchRules) $limitToPTJ AND lokasi.lk_status=1 AND lokasi.lk_rkwb_kod_web=hubungi_kami.hk_rkwb_kod_web $order"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { $counter=0; $displayNamaPTJ=""; while($data=mysqli_fetch_array($result)) { $counter++; if($LANG=='en'){$tajuk=$data['lk_lokasi_bi'];$kat=$data['rkl_kategori_bi'];} else {$tajuk=$data['lk_lokasi_bm'];$kat=$data['rkl_kategori_bm'];} #if($PTJ=="upm" OR @$_GET['o']=='a'){$namaPTJ=", $data[rkwb_nama_web]";} #else{$namaPTJ="";} if($data['namaptj'] != $displayNamaPTJ) print "".strtoupper($data['namaptj'])."
"; if($DEVICE=="m") $waze="    "; else $waze="    "; print"$pre\t
$post"; #$waze 360 $displayNamaPTJ=$data['namaptj'] ; } } ##END: cari dari berita print"$pre

$post"; if($LANG=="en") { $title="ruj_kategori_album.rjka_keterangan_bi, album.alb_nama_album_bi, album_foto.af_catatan_bi"; $order="order by ruj_kod_web.rkwb_nama_web,ruj_kategori_album.rjka_keterangan_bi,album.alb_nama_album_bi,album_foto.af_catatan_bi"; print"$pre\t$post"; } else { $title="ruj_kategori_album.rjka_keterangan_bm, album.alb_nama_album_bm, album_foto.af_catatan_bm"; $order="order by ruj_kod_web.rkwb_nama_web,ruj_kategori_album.rjka_keterangan_bm,album.alb_nama_album_bm,album_foto.af_catatan_bm"; print"$pre\t$post"; } ##START: cari dari kandungan $searchRules=rulesCarian($words,array("album.alb_nama_album_bm", "album_foto.af_catatan_bm", "album.alb_nama_album_bi", "album_foto.af_catatan_bi")); $limitToPTJ="AND album.alb_rkwb_kod_web='$PTJ1'"; if(@$_GET['o']=='a')$limitToPTJ=""; $sql="select DISTINCT ruj_kod_web.rkwb_dns, ruj_kod_web.rkwb_nama_web, album.alb_kod_album, ruj_kategori_album.rjka_keterangan_bm, album.alb_nama_album_bm, album_foto.af_catatan_bm from ruj_kategori_album,album,album_foto,ruj_kod_web where album.alb_kod_album=album_foto.af_alb_kod_album AND album.alb_rjka_kod_kategori_album=ruj_kategori_album.rjka_kod_kategori_album AND ($searchRules) $limitToPTJ AND album.alb_status=1 AND album_foto.af_status=1 AND ruj_kategori_album.rjka_status=1 AND ruj_kod_web.rkwb_kod_web=album.alb_rkwb_kod_web group by album.alb_kod_album $order"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { $counter=0;$displayNamaPTJ=""; while(list($dnsPTJ,$namaPTJ, $kodAlbum, $category,$album,$caption)=mysqli_fetch_array($result)) { $counter++; if($namaPTJ != $displayNamaPTJ) print"$namaPTJ
"; $addDomain=$SETTING['CONFIG']['rootfolder']; if(@$_GET['o']=='a' AND $dnsPTJ!="upm")$addDomain="http://www.$dnsPTJ.upm.edu.my/"; else if(@$_GET['o']=='a' AND $dnsPTJ=="upm")$addDomain="http://www.upm.edu.my/"; print"$pre\t$post"; $displayNamaPTJ=$namaPTJ; } } ##END: cari dari berita print"$pre

$post"; if($LANG=="en") { print"$pre\t$post"; } else { print"$pre\t$post"; } ##START: cari dari dbase $resultLINK=checkSuggestedLINK($words); if(count($resultLINK)>0) { $counter=0; foreach($resultLINK as $url=>$X) { $counter++; if(preg_match("/^http/",$url)) { $tajukPautan=$url; } else { ##START: cari dari dbase $sql="SELECT rkwb_dns,hk_nama_PTJ_bm,hk_nama_PTJ_bi FROM ruj_kod_web a, hubungi_kami b WHERE a.rkwb_kod_web=b.hk_rkwb_kod_web AND a.rkwb_dns='$url'"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { while(list($kod,$ptjBM,$ptjBI)=mysqli_fetch_array($result)) { if($LANG=="en") $tajukPautan=$ptjBI; else $tajukPautan=$ptjBM; } } ##END: cari dari dbase $url="http://www.$url.upm.edu.my"; } @$link.="$counter.$tajukPautan
"; } print"$pre\t$post"; } /* $sql="select rkwb_nama_web,rkwb_dns from ruj_kod_web where rkwb_status=1 AND ("; foreach($FOUND as $PTJ=>$X) { $sql.="rkwb_dns='$PTJ' OR "; } $sql=substr($sql,0,-4); $sql.=")"; $result=mysqli_query($con,$sql); if(mysqli_num_rows($result)>0) { $counter=0; while(list($ptj,$kod)=mysqli_fetch_array($result)) { $namaPTJ[$kod]=$ptj; } } ##END: cari dari dbase $counter=0; foreach($FOUND as $PTJ=>$X) { $counter++; print"$pre\t$post"; } */ ##END: cari dari ptj ##END: main Search } else if($grp=='google') { ##START: main Search print"$pre$post"; ##END: main Search } print"$pre

"; for ($aa=1;$aa<=$totalPages;$aa++) { if($aa==$currentPage) print" "; else print" "; } print"

W, ~noCache [*LIVETIMESTAMP*]