"aktív","inaktív","eladott","visszamondott","lejárt","törölt"); $g_ajanlat_tip_array = array(1=>"Eladó","Kiadó"); $g_ugyfel_tip_array = array(1=>"ismeretlen","tulajdonos","megbízott","bérlő","egyéb"); $g_szerzodes_megbiz_tip_array = array(1=>"általános","kizárólagos","félkizárólagos"); $g_allapot_tip_array = array(1=>"ismeretlen","új építésű","jó állapotú","felújítot","átlagos","felújítandó"); //$g_epitesi_mod_tip_array = array(1=>"ismeretlen","fa","tégla","panel","könnyűszerk.","salakblokk","vályog","vegyes","egyéb"); $g_epitesi_mod_tip_array = array(2=>"fa","tégla","panel","könnyűszerk.","salakblokk","term.falazat",9=>"egyéb"); $g_futes_tip_array = array(1=>"ismeretlen","nincs","gázkazán","gázkonvektor","vegyes","elektromos","házközponti","geotermikus","távhő","egyéb"); $g_emelet_tip_array = array(1=>"pince/alagsor","földszint","1. emelet","2. emelet","3. emelet","4. emelet","5. emelet","6. emelet","7. emelet","8. emelet","9. emelet","10. emelet","tetőtér"); $g_emelet_tip_array2 = array(0=>"pince",1=>"alagsor","földszint","1. emelet","2. emelet","3. emelet","4. emelet","5. emelet","6. emelet","7. emelet","8. emelet","9. emelet","10. emelet","tetőtér"); $g_ep_szint_tip_array = array(1=>"1","2","3","4","5","6","7","8","9","10","11"); $g_egyeb_felszereltseg_lista_array = array(10001=>"Bútorozott","Hűtő","Mosógép","Klima","TV","Gardrób","Amerikai konyha","Kamra","Étkező"); $g_igen_nem_array = array(1=>"igen",0=>"nem"); $g_igen_nem_mindegy_array = array(2=>"--Mindegy--",1=>"igen",0=>"nem"); $g_van_nincs_array = array(1=>"van",0=>"nincs"); $g_telek_meret_tip_array = array(1=>"m2","öl","ha"); $g_rozitette_tip_array = array(1=>"saját","örökölt"); $g_kozvetitesi_dij_tip_array = array('A','K','E'); $g_terkep_publikus_tip_array = array(1=>"igen, pontatlan","igen, pontos","nem"); $g_berendezessel_tip_array = array(1=>"igen","nem"); $g_fodem_tip_array = array(1=>"fa","monolit beton","vasbeton gerenda-beton","vasbeton gerenda-kerámia","kerámia gerenda-kerámia"); $g_teto_tip_array = array(1=>"cserép","zsindely","pala","fém","nád","lapos","hullámpala","egyéb"); $g_melegviz_tip_array = array(1=>"fűtés rendszerről","gázbojler","villanybojler","egyéb","nincs"); $g_parkolas_tip_array = array(1=>"benne van az árban: garázs","benne van az árban: parkoló","külön vásárolható: garázs","külön vásárolható: parkoló","közterületen","fedett beálló","garázs","garázs, dupla","garázs, pincében"); $g_helyiseg_tip_array = array(1=>"szoba","félszoba","gardrób","nappali","előszoba","közlekedő","háztart. helyiség","szauna","fürdőszoba","WC","étkező","kamra","konyha","lépcsőház","melléképület","télikert","amerikai konyha","erkély","terasz","pince","borospince","szerszámos","műhely","tároló","kazánház","fitness terem","garázs","egyéb"); $g_burkolat_tip_array = array(1=>"hidegburkolat","parketta","laminált parketta","szalagparketta","hajópadló","padlószőnyeg","linóleum","beton","nincs burkolat"); $g_fal_anyag_tip_array = array(1=>"tégla","vályog","vertfal","könnyűszerkezetes","sóskútikő","fa","rönk","salakbeton blokk","ytong","panel","csúsztatott zsalus","vegyes","egyéb"); $g_bn_tip_array = array(1=>"nettó","bruttó"); $g_kozmu_tip_array = array(1=>"nincs","van","telken belül","utcában","közelben"); $g_szerz_tip_array = array(1=>"saját","partnerirodai megbízás"); $g_egyutmuk_tip_array = array(1=>"nem","igen"); $g_butorozva_tip_array = array(1=>"igen","nem","részben"); $g_ugyel_statusz_tip_array = array(0=>"nem aktív","aktív","törölt","mind"); $g_ar_tipus = array("mill_huf"=>"millió Ft","ezer_eur"=>"ezer €"); $ar_array = array("1","2","3","4","5","6","7","8","9","10","12","14","16","17","18","19","20","25","30","40","50","60","70","80","90","100","130","160","190"); $g_sec_actions = array("felhasznalo","beallitasok_modositasa","naplo_megtekintese","telepulesek_modositasa","kategoriak_modositasa","lapok_modositasa","ugyfel_modositasa","uzenetek","ingatlan_letrehozas","ingatlan_torles","ingatlan_modositas","ingatlan_cimkiadas","ingatlan_cime","ingatlan_tulajdonos","ingatlan_megtekintese","ingatlan_referens_modositasa","statisztika"); $g_kereso_array = array("szintmin","szintmax","kinalat","minar","maxar","szobak","ingatlan_tipus","ingatlan_epitesimod","telepules"); $g_talalatok_szam_array = array(10=>"10",20=>"20",40=>"40",100=>"100",200=>"200",500=>"500"); $g_talalatok_szam_pub_array = array(10=>"10",30=>"30",50=>"50"); $g_eladas_ar_array = array("0","1","2","3","6","9","12","15","18","21","24","27","30","60","90","120","150","200","250","300","500"); $g_berles_ar_array = array("10","15","20","30","35","40","45","50","60","70","80","90","100","150","200","250","300","500"); $g_kapcsolat_tip = array(1=>"internet","újság"); $g_rendezes2_array = array(1=>"Ár - csökkenő","Ár - növekvő","Helységnév - csökkenő","Helységnév - növekvő","Méret - csökkenő","Méret - növekvő","Szobák - csökkenő","Szobák - növekvő","Azonosító - csökkenő","Azonosító - növekvő"); $g_rendezes2_sql_array = array(1=>"ing.ar DESC","ing.ar ASC","telep.nev DESC","telep.nev ASC","ing.lakoter_meret DESC","ing.lakoter_meret ASC","szobak DESC","szobak ASC","irodai_kod DESC","irodai_kod ASC"); $g_mentett_tip_array = array(1=>"mentett keresés","hírdetésfigyelő"); $g_ingatlan_naplo_tip_array = array(1=>"létrehozás","törlés","aktiválás","módosítás","címkiadás","egyéb"); $szemelyes_menu_array = array("Adatok","Kedvencek","Mentett keresések","Hírdetésfigyelő","Ajánlott ingatlanok","Megtekintett ingatlanok"); $g_admin_main_menu_array = array(array("property_list","Ingatlanok"),array("property_edit&new=1","Új ingatlan"),array("customer_list","Ügyfelek"),array("wishlist_list","Címkiadás"),array("log_list","Napló") ); $g_admin_sub_menu_array = array(array("stat_list","Statisztika"),array("page_list","Oldalak"),array("categ_list","Kategóriák"),array("town_list","Települések"),array("user_list","Felhasználók")); //remote $g_gmap_key = "ABQIAAAAt_yJWg67jbuLGEhgXB5ewRSSmCjm1XSoptd11ODui0P2UM7ioxRrGyQiG9SDtvVe5IEYNC5myfFpig"; //$g_gmap_key = "ABQIAAAAt_yJWg67jbuLGEhgXB5ewRQkx0a9yD_pZL3bN4Mf3hNI4K5YJxTVczgkt3NSZeS2TO7G_NPCvK-6kg"; $g_imagedir = "$g_db_path/kepek"; $pic_dir_temp = $g_imagedir."/temp"; $big_path = $g_imagedir."/nagy"; $def_path = $g_imagedir."/alap"; $little_path = $g_imagedir."/kis"; $def_path2 = $g_imagedir."/alap"; $big_path2 = $g_imagedir."/nagy"; $little_path2 = $g_imagedir."/kis"; $mini_size = 130; $def_size = 640; $def_hight = 258; $big_size = 1280; $g_css = " "; Function dbconnect() { if (is_dev()) { $login='root'; $pass=''; $dbname='maxingatlan'; $host="localhost"; } else { $login='maxoffice'; $pass ='zee0uuPh'; $dbname='maxoffice_maxingatlan'; $host="localhost"; } $db=mysql_connect($host,$login,$pass); if (!$db) { die("nincs adatbázis kapcsolat"); } mysql_select_db($dbname,$db); //mysql_query("SET NAMES latin2"); return $db; } function is_dev() { if ($_SERVER["DOCUMENT_ROOT"] == "H:/xampp/htdocs" || $_SERVER['DOCUMENT_ROOT'] == "C:/sambar44/docs" || $_SERVER["ENVTYPE"] == "dev") { return true; } return false; } function get_menu_label_by_name($menu_array) { foreach($menu_array as $menu_temp) { if (strstr($_GET['params'],$menu_temp[0])) { return $menu_temp[1]; } } return false; } function get_all_menu() { global $g_admin_sub_menu_array,$g_admin_main_menu_array; return array_merge($g_admin_main_menu_array,$g_admin_sub_menu_array); } function was_search() { global $_REQUEST,$g_kereso_array; foreach($g_kereso_array as $kereso) { if ($_REQUEST[$kereso]) { return true; } } return false; } function put_request_to_session_var($var) { global $_REQUEST,$_SESSION; if ($_REQUEST[$var]) { $_SESSION[$var] = $_REQUEST[$var]; } } function put_session_to_request_vars() { global $_REQUEST,$_SESSION; foreach($_SESSION as $key => $value) { $_REQUEST[$key] = $value; } } function display_message($type,$message) { //warning info done error echo "

$message

\n"; } function display_still_message($type,$message) { //warning info done error echo "

$message

\n"; } function display_title($title) { echo "

$title

\n"; } function format_vars($varray) { $result=''; while (list ($key, $val) = each ($varray)) { if (is_array($val)) { $result.="$key :"; while (list ($key2, $val2) = each ($val)) { $result.=" $val2"; } $result.="\n"; } else { if ($key!='submit') $result.="$key : $val\n"; } } return $result; } function get_order_dir_by_id($id) { global $g_rendezes_irany_array; foreach($g_rendezes_irany_array as $key => $value) { if ($id == $key) { return $value[1]; break; } } return 0; } function get_order_type_by_id($id) { global $g_rendezes2_sql_array; foreach($g_rendezes2_sql_array as $key => $value) { if ($id == $key) { return $value; break; } } return 0; } function get_order_type_by_name($name) { global $g_rendezes2_array, $g_rendezes2_sql_array; foreach($g_rendezes2_array as $key => $value) { if ($value == $name) { return $g_rendezes2_sql_array[$key]; break; } } return 0; } Function get_query_params() { $qstr = ""; $queries = $_GET; foreach($queries as $key => $value) { $qstr .= "&".$key."=".$value; } //echo $str; return $qstr; } Function _filter_query_params() { //a parameterben kapott mezoket hagyja ki $qstr = ""; $queries = array_merge($_GET,$_POST); $params = func_get_args(); foreach($queries as $key => $value) { if (is_array($value)) { foreach($value as $k => $v) { if (!in_array(trim($key),$params)) { $qstr .= "&".$key."[".$k."]=".$v; } } } else { if (!in_array(trim($key),$params)) { $qstr .= "&".$key."=".$value; } } } //echo $str; return $qstr; } Function filter_query_params() { //a parameterben kapott mezoket rakja bele $qstr = ""; $queries = $_GET; $params = func_get_args(); foreach($queries as $key => $value) { //echo "$key
"; if (in_array(trim($key),$params)) { $qstr .= "&".$key."=".$value; } } //echo $str; return $qstr; } Function _filter_query_params_input() { //a parameterben kapott mezoket hagyja ki $qstr = ""; $queries = $_REQUEST; $params = func_get_args(); foreach($queries as $key => $value) { if (is_array($value)) { foreach($value as $k => $v) { if (!in_array(trim($key),$params)) { //$qstr .= "&".$key."[".$k."]=".$v; echo "\n"; } } } else { //echo "$key
"; if (!in_array(trim($key),$params)) { echo "\n"; //$qstr .= "&".$key."=".$value; } } } } Function filter_query_params_input() { //a parameterben kapott mezoket rakja bele $qstr = ""; $queries = $_REQUEST; $params = func_get_args(); foreach($queries as $key => $value) { //echo "$key
"; if (in_array(trim($key),$params)) { echo "\n"; //$qstr .= "&".$key."=".$value; } } } function put_session_to_hidden_by_filter() { global $_SESSION; $qstr = ""; $queries = $_SESSION; $params = func_get_args(); foreach($queries as $key => $value) { if (is_array($value)) { foreach($value as $k => $v) { if (!in_array(trim($key),$params)) { //$qstr .= "&".$key."[".$k."]=".$v; echo "\n"; } } } else { //echo "$key
"; if (!in_array(trim($key),$params)) { echo "\n"; //$qstr .= "&".$key."=".$value; } } } } function is_morethan_mill($price) { if ($price > 1000000) { return true; } return false; } function price_in_mill($price) { //return round(($price / 1000000),3); return fixedround(($price / 1000000),3); } Function priceconv($price) { $result=trim(strrev(chunk_split(strrev($price),3,' '))); return $result; } Function priceconv2($price) { $result=strrev(chunk_split(strrev($price),3,'.')); $result[0]=""; return $result; } Function priceunconv($price) { return str_replace(" ", "", $price); } Function get_c_time() { return time() + (8 * 3600); } Function get_sql_time($time) { return strftime("%Y-%m-%d %H:%M:%S",$time); } function get_lpics($id,$pics) { return "\"kattintson\n"; } Function get_date($date) { return strftime("%Y-%m-%d",$date); } function validate_email($email) { return eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email); } function is_in_page_list($lap,$page_list) { if (in_array($lap,$page_list)) { return 1; } return 0; } Function get_file_list_ex($mydir,$extension_filter) { $res = array(); $handle=@opendir($mydir); $i = 0; if ($handle) { while (false!==($file = readdir($handle))) { if ($file != "." && $file != ".." && (get_extension($file) == $extension_filter) ) { $res[$i] = $file; $i++; } } } @closedir($handle); return $res; } Function get_file_list($mydir,$up1=false) { $res = array(); $handle=@opendir($mydir); $i = 0; if ($handle) { while (false!==($file = readdir($handle))) { if ($up1) { if ($file != "..") { $res[$i] = $file; $i++; } } else { if ($file != "." && $file != "..") { $res[$i] = $file; $i++; } } } } @closedir($handle); return $res; } function redir_delayed($url="index.php",$time=5) { echo "\n"; display_message("info","Átirányítás következik, ha $time másodpercen belül nem jelenik meg az oldal Kattints ide"); } Function is_dyn($page) { global $g_dyn_pages; if (in_array($page,$g_dyn_pages)) { return 1; } return 0; } function ekezetmentesit($szoveg){ $trans = array("Ó"=>"O","Á"=>"A","É"=>"E","Í"=>"I","Ö"=>"O","Ő"=>"O","Ű"=>"U", "Ü"=>"U","Ú"=>"U","ó"=>"o","á"=>"a","é"=>"e","í"=>"i","ö"=>"o","ő"=>"o", "ű"=>"u","ú"=>"u","ü"=>"u","á"=>"a","é"=>"e","í"=>"i", "ö"=>"o","ó"=>"o","ú"=>"u","ü"=>"u","Á"=>"A", "É"=>"E","Í"=>"I","Ö"=>"O","Ó"=>"O","Ú"=>"U", "Ü"=>"U"); return strtr($szoveg, $trans); } Function normalize_text($text) { $text = strip_tags($text); $text = strtolower($text); $text = str_replace(" ","_",$text); $text = str_replace(array("Á","á"),"a",$text); $text = str_replace(array("É","é"),"e",$text); $text = str_replace(array("Í","í"),"i",$text); $text = str_replace(array("Ő","Ö","Ó","ő","ö","ó","ő"),"o",$text); $text = str_replace(array("Ű","Ü","Ú","ű","ü","ú","ű"),"u",$text); $myregexp = "[^A-Za-z0-9\-\ \_]"; return ereg_replace($myregexp,"_",$text); return $text; } function html_table_start($headers,$padding=2,$spacing=2,$width=0) { if ($width > 0) echo "\n"; else echo "
\n"; while (list($key,$val) = each($headers)) { echo "\n"; } echo "\n"; } function html_table_start_ex($headers,$padding=2,$spacing=2,$width=0,$class="",$id="") { if ($width > 0) echo "
$val
\n"; else echo "
\n"; while (list($key,$val) = each($headers)) { echo "\n"; } echo "\n"; } function html_table_end() { echo("
$val
\n
\n\n"); } Function id_generate() { srand((double)microtime()*1000000); $result=time(); for ($i=0;$i<4;$i++) $result=$result.chr(rand(65,90)); return "$result"; } Function longid_generate() { srand((double)microtime()*1000000); $result=time(); for ($i=0;$i<6;$i++) $result=$result.chr(rand(65,90)); return "$result"; } Function max_text($text,$size) { $size = $size - 4; if (strlen($text) > $size) { return substr($text,0,$size)." ..."; } return $text; } function substrws( $text, $len=180 ) { if( (strlen($text) > $len) ) { $whitespaceposition = strpos($text," ",$len)-1; if( $whitespaceposition > 0 ) $text = substr($text, 0, ($whitespaceposition+1)); // close unclosed html tags if( preg_match_all("|<([a-zA-Z]+)>|",$text,$aBuffer) ) { if( !empty($aBuffer[1]) ) { preg_match_all("||",$text,$aBuffer2); if( count($aBuffer[1]) != count($aBuffer2[1]) ) { foreach( $aBuffer[1] as $index => $tag ) { if( empty($aBuffer2[1][$index]) || $aBuffer2[1][$index] != $tag) $text .= ''; } } } } } return $text; } Function max_text_word($text,$size) { if (strlen($text) >= $size) { $chunks = explode(" ", $text); if (strlen($chunks[0]) <= $size-3) { return $chunks[0]."..."; } else { $text=substr($text,0,$size-5); $text.="..."; return $text; } } return $text; } Function get_file_props($filename) { $res = array(); $names = explode(".",$filename); $res[0] = $names[0]; $res[1] = $names[count($names)-1]; return $res; } Function get_file_frompath($filename) { $names = explode("/",$filename); return $names[count($names)-1]; } Function load_file($myfile) { if (file_exists($myfile)) { return implode('', file($myfile)); } else { return false; } } function get_page_content($myfile) { return load_file($myfile); } Function redir_js($url) { echo "\n"; } Function redir_js_delayed($url,$time=5) { $time_ms = $time * 1000; echo " "; display_message("info","Átirányítás következik, ha $time másodpercen belül nem jelenik meg az oldal Kattints ide"); } Function close_js_delayed($time=5) { $time_ms = $time * 1000; echo " "; display_message("info","Az oldal automatikusan bezárodik, ha $time másodpercen belül nem záródik be az oldal Kattints ide"); } Function get_currency($db) { return get_id_by_name("beallitasok","ertek","nev","euro",$db); } Function get_office_userid($db) { return get_id_by_name("beallitasok","ertek","nev","iroda_ugyfel_azonosito",$db); } Function get_id_by_name($table,$name,$idname,$idvalue,$db) { $sql_id =" SELECT $name FROM $table "; $sql_id .= " WHERE $idname = '$idvalue' "; $sql_id .= " LIMIT 0,1 "; $result=MySQL_query($sql_id,$db); //echo "

get_id_by_name: $sql_id

"; return @mysql_result($result,0,0); } Function get_ids_by_name($table,$names,$idname,$idvalue,$db) { $res = array(); $valuecount = count($names); $names_string = implode(",",$names); $sql_id =" SELECT $names_string FROM $table "; $sql_id .= " WHERE $idname = '$idvalue' "; $sql_id .= " LIMIT 0,1 "; $result=MySQL_query($sql_id,$db); //echo "

get_ids_by_name: $sql_id

"; for($i=0;$i<=$valuecount-1;$i++) { $res[$i] = @mysql_result($result,0,$i); } return $res; } Function get_ids_by_name_assoc($table,$names,$idname,$idvalue,$db) { $res = array(); $valuecount = count($names); $names_string = implode(",",$names); $sql_id =" SELECT $names_string FROM $table "; $sql_id .= " WHERE $idname = '$idvalue' "; $sql_id .= " LIMIT 0,1 "; $result=MySQL_query($sql_id,$db); //echo "

get_ids_by_name: $sql_id

"; $res = mysql_fetch_assoc($result); return $res; } Function delete_cookie_s_id() { setcookie ("MAX_ID", "" , time() - 3600); } Function get_cookie_s_id() { return $_COOKIE["MAX_ID"]; } Function set_cooike_s_id($sec_id) { setcookie ("MAX_ID", $sec_id , get_c_time()); } function checkuser($do="") { $s_id = get_cookie_s_id(); if ($s_id) { $q_datas = check_s_id($s_id); $q_uid = $q_datas[0]; $q_sid = $q_datas[1]; $q_nev = $q_datas[2]; @setcookie($q_sid); if ($do && $do != "") { if (!check_permission($q_uid,$do)) { logthis("Tiltott funkció | funkció: $do",$q_nev); logtodb($q_nev,$q_uid,"Tiltott funkció","funkció: $do",2); write_permission_denied(); } } } else { redir_js("login.php"); die(); } return $q_datas; } function check_permission($uid,$do) { $db = dbconnect(); $sql_id =" SELECT akcio FROM jog WHERE uid='$uid' AND akcio='$do' "; $result=MySQL_query($sql_id,$db); //echo "

check_permission: $sql_id

"; return @mysql_result($result,0,0); } function write_permission_denied() { global $g_css; display_message("error","HIBA
Nincs jogod az adott funkció eléréséhez"); redir_delayed("index.php",5); die(); } function get_permissions($uid) { $db = dbconnect(); $sql_id =" SELECT akcio FROM jog WHERE uid='$uid' "; //echo "

$sql_id

"; $result=MySQL_query($sql_id,$db); if ($result) { $res = array(); $i=0; while ($data_list=mysql_fetch_row($result)) { $res[$i] = $data_list[0]; $i++; } return $res; } return false; } function check_s_id($sid) { $db=dbconnect(); return get_ids_by_name("felhasznalo",array("uid","sid","nev"),"sid",$sid,$db); } Function set_db_s_id($reg_id,$new_id) { $db=dbconnect(); $sql_id="UPDATE felhasznalo SET sid='$new_id' WHERE uid='$reg_id'"; $result_id=MySQL_query($sql_id,$db); } Function logthis($logmessage,$usernev) { $ip = getip(); ignore_user_abort(true); $daystring = get_logfilename(); $logfile="logs/".$daystring.".txt"; $fp = fopen($logfile, 'a'); if ($fp) { @fwrite($fp,get_logtime()." | $usernev | ip: $ip | $logmessage\n\r"); /* if (flock($fp, LOCK_EX)) { @flock($fp, LOCK_UN); if (fwrite($fp,get_logtime()." | $usernev | ip: $ip | $logmessage\n\r") === FALSE) { echo "HIBA: nem lehet a naplófile-ba írni"; } fclose($fp); } else { echo "HIBA: nem lehet a naplófile-t lockolni"; } */ } else { echo "HIBA: nem lehet naplózni
naplófile: $logfile"; } ignore_user_abort(false); } Function get_logfilename() { return date("Y_m_d"); } Function get_logtime() { return date("Y.m.d H:i:s"); } Function get_useragent() { $res = ""; $useragent = @$_SERVER['HTTP_USER_AGENT']; if (strstr($useragent,"MSIE")) { $res = "msie"; } return $res; } function validip($ip) { if (!empty($ip) && ip2long($ip)!=-1) { $reserved_ips = array ( array('0.0.0.0','2.255.255.255'), array('10.0.0.0','10.255.255.255'), array('127.0.0.0','127.255.255.255'), array('169.254.0.0','169.254.255.255'), array('172.16.0.0','172.31.255.255'), array('192.0.2.0','192.0.2.255'), array('192.168.0.0','192.168.255.255'), array('255.255.255.0','255.255.255.255') ); foreach ($reserved_ips as $r) { $min = ip2long($r[0]); $max = ip2long($r[1]); if ((ip2long($ip) >= $min) && (ip2long($ip) <= $max)) return false; } return true; } else { return false; } } function getip() { //global $HTTP_SERVER_VARS; if (validip($_SERVER["HTTP_CLIENT_IP"])) return $_SERVER["HTTP_CLIENT_IP"]; elseif ($_SERVER["HTTP_X_FORWARDED_FOR"]!="") { $forwarded=str_replace(",","",$_SERVER["HTTP_X_FORWARDED_FOR"]); $forwarded_array=split(" ",$forwarded); foreach($forwarded_array as $value) if (validip($value)) return $value; } return $_SERVER["REMOTE_ADDR"]; } function remove_blank_array($myarray) { $res = array(); if ($myarray) { foreach($myarray as $key => $value) { if ( strlen($value) > 0) { $res[$key] = $value; } } return $res; } } function render_input_selects_multi($myarray,$varname,$defval_array,$multiple=false,$size=1,$def_name="n.a.") { if ($multiple) { echo "\n"; if (!$defval_array) { echo "\n"; } } if ($myarray) { foreach($myarray as $key => $value) { if ($defval_array) { if (in_array($key,$defval_array)) { echo "\n"; } else { echo "\n"; } } else { echo "\n"; } } } echo "\n"; } function render_input_selects($myarray,$varname,$defval,$multiple=false,$size=1,$def_name="n.a.") { if ($multiple) { echo "\n"; if (!$defval) { echo "\n"; } else { echo "\n"; } } if ($myarray) { foreach($myarray as $key => $value) { if ($key == $defval) { echo "\n"; } else { echo "\n"; } } } echo "\n"; } function render_input_selects_class_id($myarray,$varname,$defval,$class,$id) { echo "\n"; } function render_input_selects_wo_id($myarray,$varname,$defval,$multiple=false,$size=1,$def_name="n.a.") { if ($multiple) { echo "\n"; if (!$defval) { echo "\n"; } else { echo "\n"; } } if ($myarray) { foreach($myarray as $key => $value) { if ($key == $defval) { echo "\n"; } else { echo "\n"; } } } echo "\n"; } function render_input_selects_wo_key($myarray,$varname,$defval,$multiple=false,$size=1,$def_name="--Mindegy--") { if ($multiple) { echo "\n"; if (!$defval) { echo "\n"; } else { echo "\n"; } } if ($myarray) { foreach($myarray as $key => $value) { if ($value == $defval) { echo "\n"; } else { echo "\n"; } } } echo "\n"; } function render_input_selects_wo_def($myarray,$varname,$defval) { echo "\n"; } function render_input_selects_wo_def_onsubmit($myarray,$varname,$defval,$title="") { echo "\n"; } function render_input_radios($myarray,$varname,$defval) { foreach($myarray as $key => $value) { if ($key == $defval) { echo " $value   "; } else { echo " $value   "; } } } function render_input_radios_def($myarray,$varname,$defval) { foreach($myarray as $key => $value) { if ($key == $defval) { echo " $value   "; } else { echo " $value   "; } } if (!$defval) { echo " n.a.   "; } else { echo " n.a.   "; } } function render_input_checkboxes($myarray,$varname,$checked_array) { if ($myarray) { foreach($myarray as $key => $value) { if ($checked_array) { if (in_array($key,$checked_array)) { echo " $value
\n"; } else { echo " $value
\n"; } } else { echo " $value
\n"; } } } } function render_input_checkboxes_onsubmit($myarray,$varname,$checked_array) { if ($myarray) { foreach($myarray as $key => $value) { if ($checked_array) { if (in_array($key,$checked_array)) { echo " $value
\n"; } else { echo " $value
\n"; } } else { echo " $value
\n"; } } } } function render_input_checkboxes_one($varname,$myvalue) { $display_name = $varname."_temp"; if ($myvalue == 1) { echo "\n"; echo "\n"; } else { echo "\n"; echo "\n"; } } function delete_picture_file($pic) { global $big_path,$little_path,$def_path,$mid_path; @unlink("$big_path/$pic.jpg"); @unlink("$little_path/$pic.jpg"); @unlink("$def_path/$pic.jpg"); @unlink("$mid_path/$pic.jpg"); } function make_js_array($myarray) { $temp = array(); foreach($myarray as $key => $value) { $temp[$key] = "\"$key\":\"$value\""; } return implode(",",$temp); } function make_js_array_simple($myarray) { $temp = array(); //$myarray = array_reverse($myarray); foreach($myarray as $key=> $value) { $temp[$key] = "\"$value\""; } return implode(",",$temp); } function get_all_tags($db,$field,$table,$separator=",") { $sql_tags = " SELECT DISTINCT $field FROM $table WHERE 1 "; $result_tags = MySQL_query($sql_tags,$db); $tag_array = array(); if ($result_tags) { $i = 0; while ($data_tags=mysql_fetch_row($result_tags)) { $temp = explode($separator,$data_tags[0]); foreach($temp as $value) { if ($value) { $tag_array[$i] = trim($value); $i++; } } } } return array_unique($tag_array); } function get_all_values($db,$field,$table) { $sql_tags = " SELECT DISTINCT $field FROM $table WHERE 1 "; $result_tags = MySQL_query($sql_tags,$db); $tag_array = array(); if ($result_tags) { $i = 0; while ($data_tags=mysql_fetch_row($result_tags)) { if ($data_tags[0]) { $tag_array[$i] = $data_tags[0]; $i++; } } } return array_unique($tag_array); } function implode_assoc($myarray,$mychar=":") { $res = array(); if ($myarray) { $i = 0; foreach($myarray as $key => $value) { if ($value) { $res[$i] = $key.$mychar.$value; $i++; } } } return implode(" ",$res); } function filter_kozmu($myarray) { $res = array(); if ($myarray) { $i = 0; foreach($myarray as $key => $value) { if ($value != 1) { $res[$i] = $key; $i++; } } } return $res; } function render_single_data_array($title,$myarray,$defval) { global $g_table_row; if (!$defval) { $defval = 0; } if ($g_table_row > 0) { echo ""; echo "$title\n$myarray[$defval]\n\n"; $g_table_row++; } else { echo "\n$title\n$myarray[$defval]\n\n"; } } function render_single_data_array_more($title,$myarray,$checked_array) { global $g_table_row; if ($g_table_row > 0) { echo ""; $g_table_row++; } echo "$title"; foreach($myarray as $key => $value) { if (in_array($key,$checked_array)) { echo "$value
\n"; } } echo "\n"; } function render_single_data_array_more_show($title,$myarray,$checked_array) { global $g_table_row; if ($g_table_row > 0) { echo ""; $g_table_row++; } echo "$title"; foreach($myarray as $key => $value) { if (in_array($key,$checked_array)) { echo "$value - van
\n"; } else { echo "$value - nincs
\n"; } } echo "\n"; } function render_single_data($title,$value,$row='') { global $g_table_row; if ($g_table_row > 0) { echo ""; echo "$title\n$value\n\n"; $g_table_row++; } else { echo "\n$title\n$value\n\n"; } } function render_array_data_table_row($myarray,$row='') { global $g_table_row; if ($g_table_row > 0) { echo ""; foreach($myarray as $mycol) { echo "$mycol"; } $g_table_row++; } else { foreach($myarray as $mycol) { echo "$mycol"; } } echo "\n"; } function parse_url_params() { global $base_url; if ($_REQUEST['params']) { $url = $_REQUEST['params']; } else { $url = substr($_SERVER['REQUEST_URI'], 1); $len = strlen($base_url); $start = strpos($url,$base_url); $url = substr($url,$len); } $urlParts = explode('/', $url); $eredmeny = array(); $count=count($urlParts); $quotes = explode('?',$_SERVER['REQUEST_URI']); $quote_temp = $quotes[count($quotes)-1]; for($i=0;$i<$count;$i++) { if ($i % 2 == 0) { $nev = $urlParts[$i]; $ertek = $urlParts[$i+1]; if ($ertek) { $eredmeny[$nev] = $ertek; } } } $eredmeny['xyz'] = $quote_temp; return $eredmeny; } function transform_items_array_to_checkboxed_lines($items_array,$varname,$selected_array) { $new_array = array(); $i = 0; foreach($items_array as $key => $value) { $new_array[$i] = "\n"; echo "\n"; $j=0; foreach($myarray as $value) { if ($j >= $num) { echo "\n"; $j=0; } $j++; echo "$value"; } echo "\n"; echo "\n"; } function get_property_data_mini_by_id($ingatlan_id,$db) { global $g_megbiz_tip_array; $res = array(); $sql_list = " SELECT tel.nev,megbiz_tip,alkat.nev,ar,lakoter_meret,kat.nev,ing.kep,ing.irodai_kod "; $sql_list .= " FROM ingatlan ing, megye megy, telepules tel, ing_kateg kat WHERE megy.id = tel.megye_id AND tel.id = ing.cim_telepules_id AND kat.id = ing.ing_kat_id AND ing.irodai_kod='$ingatlan_id' "; $result_list=MySQL_query($sql_list,$db); //echo "

get_property_data_mini: $sql_list

"; if ($result_list) { $res['tel_nev'] = mysql_result($result_list,0,0); $res['id'] = mysql_result($result_list,0,7); $res['megbiz_tip'] = $g_megbiz_tip_array[mysql_result($result_list,0,1)]; $res['alkat_nev'] = mysql_result($result_list,0,2); $res['ar'] = mysql_result($result_list,0,3); $res['lakoter_meret'] = mysql_result($result_list,0,4); $res['kat_nev'] = mysql_result($result_list,0,5); $res['kep'] = mysql_result($result_list,0,6); if (is_morethan_mill($res['ar'])) { $res['ar_mod'] = price_in_mill($res['ar'])." millió Ft"; } else { $res['ar_mod'] = priceconv($res['ar'])." Ft"; } } return $res; } function get_property_data_mini($ingatlan_id,$db) { global $g_ajanlat_tip_array; $res = array(); $sql_list = " SELECT tel.nev,ajanlat_tip,kat.nev,ar,lakoter_meret,kat.nev,ing.kep,ing.irodai_kod "; $sql_list .= " FROM ingatlan ing, megye megy, telepules tel, ing_kateg kat WHERE megy.id = tel.megye_id AND tel.id = ing.cim_telepules_id AND kat.id = ing.ing_kat_id AND ing.irodai_kod='$ingatlan_id' "; $result_list=MySQL_query($sql_list,$db); //echo "

get_property_data_mini: $sql_list

"; if ($result_list) { $res['tel_nev'] = mysql_result($result_list,0,0); $res['id'] = mysql_result($result_list,0,7); $res['megbiz_tip'] = $g_ajanlat_tip_array[mysql_result($result_list,0,1)]; $res['alkat_nev'] = mysql_result($result_list,0,2); $res['ar'] = mysql_result($result_list,0,3); $res['lakoter_meret'] = mysql_result($result_list,0,4); $res['kat_nev'] = mysql_result($result_list,0,5); $res['kep'] = mysql_result($result_list,0,6); if (is_morethan_mill($res['ar'])) { $res['ar_mod'] = price_in_mill($res['ar'])." millió Ft"; } else { $res['ar_mod'] = priceconv($res['ar'])." Ft"; } } return $res; } function render_property_data_mini($favitem_details) { $res = "
"; $res .= ""; $res .= "
$favitem_details[megbiz_tip] $favitem_details[kat_nev], $favitem_details[ar_mod]
$favitem_details[lakoter_meret] m2
$favitem_details[tel_nev]
"; $res .= ""; $res .= "
\n"; return $res; } function render_property_data_compact_w_del($favitem_details) { $res = "
"; $res .= "
"; $res .= "
#$favitem_details[id]
$favitem_details[megbiz_tip] $favitem_details[kat_nev], $favitem_details[tel_nev]
Ár: $favitem_details[ar_mod]
"; $res .= "Lakótér: $favitem_details[lakoter_meret] m2

"; $res .= "

törlés a kedvencekből

"; $res .= "
"; $res .= "

\n"; return $res; } function render_property_data_compact($favitem_details) { $res = "
"; $res .= "
"; $res .= "
#$favitem_details[id]
$favitem_details[megbiz_tip] $favitem_details[kat_nev], $favitem_details[tel_nev]
Ár: $favitem_details[ar_mod]
"; $res .= "Lakótér: $favitem_details[lakoter_meret] m2

"; $res .= "

"; $res .= "

\n"; return $res; } function render_property_data_compact_custom_link($favitem_details,$link) { $res = "
"; $res .= "
"; $res .= "
#$favitem_details[id]
$favitem_details[megbiz_tip] $favitem_details[kat_nev], $favitem_details[tel_nev]
Ár: $favitem_details[ar_mod]
"; $res .= "Lakótér: $favitem_details[lakoter_meret] m2

"; $res .= "

$link

"; $res .= "
"; $res .= "

\n"; return $res; } function pagination($script,$total_pages,$limit,$page) { $adjacents = 3; $list_params = _filter_query_params("page","PHPSESSID","params"); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 //echo "

total: $total_pages | $start $limit

"; /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($total_pages > $limit) { $pagination .= "

"; //previous button if ($page > 1) $pagination.= "< előző"; else $pagination.= "< előző"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //close to end; only hide early pages else { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } } //echo "

counter: $counter

"; //next button if ($page < $counter - 1) { $pagination.= "következő >"; } else { $pagination.= "következő >"; } $pagination.= "

\n"; } return $pagination; } function pagination_clean_url($script,$total_pages,$limit,$page) { $adjacents = 3; $list_params = _filter_query_params("page"); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 //echo "

total: $total_pages | $start $limit

"; /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($total_pages > $limit) { $pagination .= "

"; //previous button if ($page > 1) $pagination.= "< előző"; else $pagination.= "< előző"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //in middle; hide some front and some back else if($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //close to end; only hide early pages else { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } } //echo "

counter: $counter

"; //next button if ($page < $counter - 1) { $pagination.= "következő >"; } else { $pagination.= "következő >"; } $pagination.= "

\n"; } return $pagination; } function get_subarray_assoc_value_by_key($myarray,$mykey) { foreach($myarray as $temp) { if ($temp[0] == $mykey) { return $temp[1]; } } return false; } function in_subarray_assoc_key($myarray,$var) { foreach($myarray as $temp) { if ($temp[0] == $var) { return true; } } return false; } function in_array_assoc_key($myarray,$mykey) { //echo "

in_array_assoc_key called: $mykey

"; foreach($myarray as $key => $value) { if ($key == $mykey) { return true; } } return false; } function in_array_assoc_value($myarray,$myval) { foreach($myarray as $key => $value) { if ($value == $myval) { return true; } } return false; } function get_array_values_by_keys($myarray,$checked_array) { $res = array(); $i = 0; foreach($myarray as $key => $value) { if (in_array($key,$checked_array)) { $res[$i] = $value; $i++; } } return $res; } function add_string_to_array_lines($myarray,$before="",$after="") { foreach($myarray as $key => $value) { if (strlen($before)) { $myarray[$key] = $before.$value; } if (strlen($after)) { $myarray[$key] = $value.$after; } } return $myarray; } function delete_from_array_by_value($myvalue,$myarray) { $res = array(); $i = 0; foreach($myarray as $value) { if ($value != $myvalue) { $res[$i] = $value; $i++; } } return $res; } function generate_password($length=6) { $conso=array("b","c","d","f","g","h","j","k","l", "m","n","p","r","s","t","v","w","x","y","z"); $vocal=array("a","e","i","o","u"); $password=""; srand ((double)microtime()*1000000); $max = $length/2; for($i=1; $i<=$max; $i++) { $password.=$conso[rand(0,19)]; $password.=$vocal[rand(0,4)]; } return $password; } function log_sql($sql) { ignore_user_abort(true); $logfile="sql_log.txt"; $most = get_sql_time(time()); $spec = array("\n","\r","\t"); $sql = $most." - ".str_replace($spec, "", $sql); $fp = fopen($logfile, 'a'); if ($fp) { @fwrite($fp,"$sql\n\r"); } ignore_user_abort(false); } function save_file($myfile,$mycont) { $mycont = stripslashes($mycont); $fp = fopen($myfile, "w+"); @flock($fp, LOCK_EX); fwrite($fp,$mycont); @flock($fp, LOCK_UN); fclose($fp); } Function array_into_table($myarray,$cols=3,$css_id="tabla",$cellpadding=10,$cellspacing=10) { $colcount=0; $res = ""; $res .= "\n"; foreach($myarray as $key => $value) { if ($colcount==0) { //ujsor elkezdjuk az oszlopot $res .= "\n"; } else if ($colcount==$cols) { //megvan a harom oszlop lehet nullazni az uj sorhoz $res .= "\n"; $colcount=0; } //inkrementaljuk a szamlalot $colcount++; $res .= "\n"; } $res .= "
\n"; $res .= "$value"; $res .= "
"; return $res; } function random_float ($min,$max) { return ($min+lcg_value()*(abs($max-$min))); } function translate_assoc($assoc_array,$value_array) { $res = array(); $i = 0; foreach($value_array as $value) { if ($assoc_array[$value]) { $res[$i] = $assoc_array[$value]; $i++; } } return $res; } function uzenet_kuldes_db($felado_id,$cimzett_id,$targy,$uzenet,$db) { $most = get_sql_time(time()); $sql_ins=" INSERT INTO uzenet VALUES ('','$felado_id','$cimzett_id','$most',NULL,'$targy','$uzenet') "; $result_ins=MySQL_query($sql_ins,$db); return mysql_insert_id($db); } function ingatlan_naploba($ingatlan_id,$tipus_tip,$adat,$felhasznalo="rendszer") { $db = dbconnect(); $most = get_sql_time(time()); if ($felhasznalo) { $adat_str = "$felhasznalo : $adat"; } $sql_ins=" INSERT INTO ing_naplo VALUES ('','$ingatlan_id','$tipus_tip','$most','$adat_str') "; $result_ins=MySQL_query($sql_ins,$db); } function get_extension($fname) { $parts = explode('.', $fname); return $parts[count($parts) - 1]; } function query_favorites($userid,$db) { $fav_array = array(); $sql_list_fav = " SELECT irodai_kod FROM ugyfel_kedvencek WHERE ugyfel_id='$userid' "; $result_list_fav=MySQL_query($sql_list_fav,$db); if ($result_list_fav) { while ($data_list_fav=mysql_fetch_row($result_list_fav)) { $fav_array[$data_list_fav[0]] = $data_list_fav[0]; } } return $fav_array; } function translate_saved_query($query_array,$db) { global $g_egyeb_felszereltseg_lista_array, $g_ajanlat_tip_array, $g_epitesi_mod_tip_array; //"megye_id","egyeb_felszereltseg","ingatlan_tipus","ingatlan_altipus","telepules_id","merettol","meretig","artol","arig","mill_tol","mill_ig","kodszam","q","page","start","limit","rendezes_tip","rendezes" $res = ""; if ($query_array["kinalat"]) { $res .= "".$g_ajanlat_tip_array[$query_array["kinalat"]]." ingatlanok."; } if ($query_array["ingatlan_tipus"]) { if (count($query_array["ingatlan_tipus"])) { $query_array["ingatlan_tipus"] = array_unique($query_array["ingatlan_tipus"]); $ingtipusok_array = array(); $i=0; foreach($query_array["ingatlan_tipus"] as $tip_id) { $ingtipusok_array[$i] = get_id_by_name("ing_kateg","nev","id",$tip_id,$db); $i++; } if (count($ingtipusok_array)) { $ingtipus_str .= implode(",",$ingtipusok_array); if (count($telepulesek_array) == 1) { $res .= "Az ingatlan típusa: $ingtipus_str"; } else { $res .= "Az ingatlan típusa: $ingtipus_str"; } } } } if ($query_array["ingatlan_epitesimod"]) { if (count($query_array["ingatlan_epitesimod"])) { $query_array["ingatlan_epitesimod"] = array_unique($query_array["ingatlan_epitesimod"]); $epitesimod_array = array(); foreach($query_array["ingatlan_epitesimod"] as $epitesimod_id) { $epitesimod_array[] = $g_epitesi_mod_tip_array[$epitesimod_id]; } if (count($epitesimod_array)) { $epitesimod_str .= implode(",",$epitesimod_array); $res .= ", építési módja: $epitesimod_str"; } } } if ($query_array["telepules"]) { if (count($query_array["telepules"])) { $query_array["telepules"] = array_unique($query_array["telepules"]); $telepulesek_array = array(); $i=0; foreach($query_array["telepules"] as $telep_id) { $telepulesek_array[$i] = get_id_by_name("telepules","nev","id",$telep_id,$db); $i++; } if (count($telepulesek_array)) { $telepulesek_str .= implode(",",$telepulesek_array); if (count($telepulesek_array) == 1) { $res .= ", ami következő helyen van: $telepulesek_str"; } else { $res .= ", ami következő helyeken van: $telepulesek_str"; } } } } if ($query_array["merettol"]) { $res .= ", és mérete nagyobb mint: $query_array[merettol] m2"; } if ($query_array["meretig"]) { $res .= ", és mérete kissebb mint: $query_array[merettol] m2"; } if ($query_array["szobak"]) { $res .= ", és a szobák száma legalább: $query_array[szobak]"; } if ($query_array["minar"]) { if (is_morethan_mill(priceunconv($query_array['minar']))) { $res .= ", és az ára nagyobb mint: ".price_in_mill(priceunconv($query_array['minar']))." millió Ft"; } else { $res .= ", és az ára nagyobb mint: ".$query_array['minar']." Ft"; } } if ($query_array["maxar"]) { if (is_morethan_mill(priceunconv($query_array['maxar']))) { $res .= ", és az ára kissebb mint: ".price_in_mill(priceunconv($query_array['maxar']))." millió Ft"; } else { $res .= ", és az ára kissebb mint: ".$query_array["maxar"]." Ft"; } } if ($query_array["egyeb_felszereltseg"]) { $q_egyeb_felszereltseg_array = get_array_values_by_keys($g_egyeb_felszereltseg_lista_array,$query_array["egyeb_felszereltseg"]); $q_egyeb_felszereltseg_str = implode(",",$q_egyeb_felszereltseg_array); $res .= ", és a felszereltsége: $q_egyeb_felszereltseg_str"; } return $res; } function put_var_template($myvar,$myvalue,$mybody) { return str_replace($myvar,$myvalue,$mybody); } function debug_print_r($myarray) { echo "
\n";
	print_r($myarray);
	echo "
\n"; } function check_my_properties($userid,$db) { $res = array(); $sql_list = " SELECT irodai_kod FROM ingatlan WHERE ugyfel_id='$userid' "; $result_list = MySQL_query($sql_list,$db); while ($data_list=mysql_fetch_row($result_list)) { $res[] = $data_list[0]; } return $res; } function render_message_history($message) { $res = array(); $lines_array = explode("\n",$message); foreach($lines_array as $key=> $value) { $res[$key] = "> $value"; } return implode("",$res); } function make_clickable($ret) { $ret = preg_replace("#(^|[\n ])([\w]+?://[\w]+[^ \"\n\r\t< ]*)#", "\\1\\2", $ret); $ret = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r< ]*)#", "\\1\\2", $ret); return $ret; } function regexp_get_number($mystr) { $mystr = str_replace(array(".",",","-"," "),"",$mystr); preg_match("/[0-9]{1,9}/",$mystr,$number); return (int)$number[0]; } function encode_email($user,$domain,$ext) { $myvars = array(); $myvars['first'] = "ma"; $myvars['second'] = "il"; $myvars['third'] = "to:"; $myvars['address'] = $user; $myvars['domain'] = $domain; $myvars['ext'] = $ext; srand((double)microtime()*1000000); $myvars2 = array(); foreach($myvars as $key => $value) { $varname = $result.chr(rand(65,90)).chr(rand(65,90)).rand(1,999); $myvars2[$varname] = $value; $myvars[$key] = $varname; $i++; } srand((double)microtime()*1000000); kshuffle($myvars2); echo "\n"; } function kshuffle(&$array) { if(!is_array($array) || empty($array)) { return false; } $tmp = array(); foreach($array as $key => $value) { $tmp[] = array('k' => $key, 'v' => $value); } shuffle($tmp); $array = array(); foreach($tmp as $entry) { $array[$entry['k']] = $entry['v']; } return true; } function insert_stat($ingatlan_id,$db) { $most = get_sql_time(time()); $sql_ins = " INSERT INTO stat_ingatlan VALUES ('$most','$ingatlan_id') "; $result_ins=MySQL_query($sql_ins,$db); } function is_array_in_assoc($my_array,$my_assoc) { foreach($my_assoc as $key => $value) { if (in_array($key,$my_array)) { return true; } } return false; } function logtodb($usernev,$uid,$logaction,$logmessage,$loglevel) { $ido = get_sql_time(time()); $ip = getip(); $db=dbconnect(); $sql_ins=" INSERT INTO naplo VALUES ('','$ido','$usernev','$uid','$ip','$loglevel','$logaction','$logmessage') "; //echo "

$sql_ins

"; $result_ins=MySQL_query($sql_ins,$db); } Function get_row_by_name($table,$idname,$idvalue,$db) { $res = array(); $sql_id =" SELECT * FROM $table "; $sql_id .= " WHERE $idname = '$idvalue' "; $sql_id .= " LIMIT 0,1 "; $result=MySQL_query($sql_id,$db); //echo "

get_row_by_name: $sql_id

"; $res = mysql_fetch_assoc($result); return $res; } function compare_assoc_array($new_array,$old_array) { $res = ""; foreach($new_array as $key => $value) { if ($value != $old_array[$key]) { $res .= "$key: ".max_text($old_array[$key],50)." -> ".max_text($value,50)."\n"; } } return $res; } function get_souce($text) { $temp = explode(":",$text); return trim($temp[0]); } function source_filter($this_source,$text) { $temp = explode(":",$text); if (trim($temp[0]) == $this_source) { return trim($temp[1]); } } function get_table_fields($table,$db) { $res = array(); $sql = " SELECT * FROM $table LIMIT 0,1 "; $result=MySQL_query($sql,$db); $i = 0; while ($i < mysql_num_fields($result)) { $data = mysql_fetch_field($result,$i); $res[$i] = $data->name; $i++; } return $res; } function get_user_pref($userid,$name,$db) { $sql_check = " SELECT ertek FROM felhasznalo_bellitasok WHERE uid='$userid' AND beallitas='$name' LIMIT 0,1 "; $result_check = MySQL_query($sql_check,$db); $res = mysql_fetch_assoc($result_check); return $res['ertek']; } function set_user_pref($userid,$name,$value,$db) { $check = get_user_pref($userid,$name,$db); if ($check) { $sql_upd = " UPDATE felhasznalo_bellitasok SET ertek='$value' WHERE uid='$userid' AND beallitas='$name' "; $result_upd=MySQL_query($sql_upd,$db); } else { $sql_ins = " INSERT INTO felhasznalo_bellitasok (uid,beallitas,ertek) VALUES ('$userid','$name','$value') "; $result_ins=MySQL_query($sql_ins,$db); } } function my_mail($mailto,$from,$fromname,$subject,$html_body,$plain_body) { if (is_dev()) { echo "

$html_body

"; echo "
$plain_body
"; } else { require_once("class.phpmailer.php"); $mail = new PHPMailer(); $mail->AddAddress($mailto); $mail->Subject = $subject; $mail->From = $from; $mail->FromName = $fromname; //$mail->Host = "localhost"; $mail->Mailer = "sendmail"; $mail->Encoding = "quoted-printable"; $mail->CharSet = "iso-8859-1"; $mail->Body = $html_body; $mail->AltBody = $plain_body; $mail->Send(); unset($mail); } } function getTextBetweenTags($string) { $pattern = "/]*class=\"ingatlanlista\")[^>]*>([\w\W]*?)<\/tr>/i"; preg_match_all($pattern, $string, $matches); //debug_print_r($matches[0]); return $matches[0]; } function fixedround($val) { $value = sprintf('%.2F',$val); $temp = explode(".",$value); if ( strlen($temp[1]) > 1 ) { if ($temp[1] == 0) { $value = $temp[0]; } else { $lastchar = substr($temp[1], -1, 1); if ($lastchar == 0) { $value = substr($value,0,-1); } } } return $value; } function parse_smart_search($mystr) { global $_REQUEST; $matches = array(); if (!$db) $db = dbconnect(); $regexp_price_million = "/[0-9]{1,9}[\s]*(mill|mi|m|millió|millio)[\s]*(ft|huf|eur|gbp|forint)/i"; $regexp_price_thousand = "/[0-9]{1,9}[\s]*(e|ezer)[\s]*(ft|huf|eur|gbp|forint)/i"; $regexp_price = "/(([0-9]{1,3}[\D]){1,9}|[0-9]{1,15})[\s]*(ft|huf|eur|gbp|forint)/i"; $regexp_size = "/[0-9]{1,5}[\s]*(nm|m2|méter|meter)/i"; preg_match_all($regexp_price,$mystr,$matches_price); preg_match_all($regexp_price_million,$mystr,$matches_price_million); preg_match_all($regexp_size,$mystr,$matches_size); //millio if (strlen($matches_price_million[0][0])) { $price_million = regexp_get_number($matches_price_million[0][0]); if (strlen($matches_price_million[0][1])) { $price_million2 = regexp_get_number($matches_price_million[0][1]); } if ($price_million && $price_million2) { if ($price_million < $price_million2) { $_REQUEST['artol'] = $price_million; $_REQUEST['arig'] = $price_million2; } else { $_REQUEST['artol'] = $price_million2; $_REQUEST['arig'] = $price_million; } $matches[count($matches)+1] = $matches_price_million[0][0]; $matches[count($matches)+1] = $matches_price_million[0][1]; } else { //egy ar van $looseness = 1; if ($price_million > 20) { $looseness = $price_million / 10; } $_REQUEST['artol'] = $price_million - $looseness; $_REQUEST['arig'] = $price_million + $looseness; $matches[count($matches)+1] = $matches_price_million[0][0]; } $_REQUEST['milltol'] = 1; $_REQUEST['millig'] = 1; } //sima osszeg if (strlen($matches_price[0][0])) { $price = regexp_get_number($matches_price[0][0]); if (strlen($matches_price[0][1])) { $price2 = regexp_get_number($matches_price[0][1]); } if ($price && $price2) { if ($price < $price2) { $_REQUEST['artol'] = $price; $_REQUEST['arig'] = $price2; } else { $_REQUEST['artol'] = $price2; $_REQUEST['arig'] = $price; } $matches[count($matches)+1] = $matches_price[0][0]; $matches[count($matches)+1] = $matches_price[0][1]; } else { //egy ar van $looseness = 1000000; if ($price > 20) { $looseness = $price / 10; } $_REQUEST['artol'] = $price - $looseness; $_REQUEST['arig'] = $price + $looseness; $matches[count($matches)+1] = $matches_price[0][0]; } $_REQUEST['ar_tipus'] = 3; } //meret if (strlen($matches_size[0][0])) { $size1 = regexp_get_number($matches_size[0][0]); if (strlen($matches_size[0][1])) { $size2 = regexp_get_number($matches_size[0][1]); } if ($size1 && $size2) { if ($size1 > $size2) { $_REQUEST['merettol'] = $size2; $_REQUEST['meretig'] = $size1; } else { $_REQUEST['merettol'] = $size1; $_REQUEST['meretig'] = $size2; } $matches[count($matches)+1] = $matches_size[0][0]; $matches[count($matches)+1] = $matches_size[0][1]; } else { $_REQUEST['merettol'] = $size1; $matches[count($matches)+1] = $matches_size[0][0]; } } //kivesszuk az eddigi illeszkedo sztringeket $mystr = str_replace($matches,"",$mystr); //kivesszuk a szemet karaktereket $mystr = str_replace(array(".",",","-","tól","ig")," ",$mystr); if ( strlen($mystr) > 1 ) { $myarray = explode(" ",$mystr); if (count($myarray)) { $db = dbconnect(); foreach($myarray as $value) { $value = trim($value); if ( strlen($value) > 1 ) { //telepulesre teszteljuk $telepules_temp = get_id_by_name("telepules","id","nev",$value,$db); if ($telepules_temp) { $telepules_id = $telepules_temp; $telepules_nev = $value; $_REQUEST['telepules_id'][count($_REQUEST['telepules_id'])+1] = $telepules_temp; $mystr = trim(str_replace($value,"",$mystr)); } else if (!$ingatlan_tipus_id) { $ingatlan_tipus_temp = get_id_by_name("ing_kateg","id","nev",$value,$db); if ($ingatlan_tipus_temp) { $ingatlan_tipus_id = $ingatlan_tipus_temp; $ingatlan_tipus_nev = $value; } } } } } } if ($ingatlan_tipus_nev && $ingatlan_tipus_id) { $_REQUEST['ingatlan_tipus'] = $ingatlan_tipus_id; $matches[count($matches)+1] = $ingatlan_tipus_nev; } $mystr = trim(str_replace($matches,"",$mystr)); if ( strlen($mystr) > 1 ) { $_REQUEST['q'] = $mystr; } } ?>