if (is_dev())
{
$base_url = "/maxingatlan2";
//error_reporting(E_ERROR | E_PARSE);
}
else
{
$base_url = "/";
//error_reporting(0);
}
$g_help_path = "help";
$g_db_path="db";
$g_pages_path = "$g_db_path/lapok";
if (is_dev())
{
$g_base_url = "http://localhost/maxingatlan2/";
//$g_base_url = "http://192.168.3.2/maxingatlan2/";
}
else
{
$g_base_url = "http://www.ujvarosingatlan.hu/";
}
$doc_path = "$g_db_path/dok";
$g_iroda_email = "ertekesites@max-office.hu";
$g_dyn_pages = array("kezdolap","ingatlanok","ingatlan","regisztracio","regisztracio_lepes3","szemelyes","jelszoemlekezteto","szemelyes_adatok","hitelajanlat","hirdetes");
$g_pic_extensions = array("jpg","jpeg","gif","png");
$g_ingatlan_statusz_array = array(1=>"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 " \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 "$val \n";
}
echo " \n";
}
function html_table_start_ex($headers,$padding=2,$spacing=2,$width=0,$class="",$id="")
{
if ($width > 0)
echo "\n";
else
echo "\n";
while (list($key,$val) = each($headers))
{
echo "$val \n";
}
echo " \n";
}
function html_table_end()
{
echo("
\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("|([a-zA-Z]+)>|",$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 .= ''.$tag.'>';
}
}
}
}
}
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";
}
else
{
echo "\n";
if (!$defval_array)
{
echo "$def_name \n";
}
}
if ($myarray)
{
foreach($myarray as $key => $value)
{
if ($defval_array)
{
if (in_array($key,$defval_array))
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
else
{
echo "$value \n";
}
}
}
echo " \n";
}
function render_input_selects($myarray,$varname,$defval,$multiple=false,$size=1,$def_name="n.a.")
{
if ($multiple)
{
echo "\n";
}
else
{
echo "\n";
if (!$defval)
{
echo "$def_name \n";
}
else
{
echo "$def_name \n";
}
}
if ($myarray)
{
foreach($myarray as $key => $value)
{
if ($key == $defval)
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
}
echo " \n";
}
function render_input_selects_class_id($myarray,$varname,$defval,$class,$id)
{
echo "\n";
if ($myarray)
{
if (!$defval)
{
echo " \n";
}
else
{
echo " \n";
}
foreach($myarray as $key => $value)
{
if ($key == $defval)
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
}
echo " \n";
}
function render_input_selects_wo_id($myarray,$varname,$defval,$multiple=false,$size=1,$def_name="n.a.")
{
if ($multiple)
{
echo "\n";
}
else
{
echo "\n";
if (!$defval)
{
echo "$def_name \n";
}
else
{
echo "$def_name \n";
}
}
if ($myarray)
{
foreach($myarray as $key => $value)
{
if ($key == $defval)
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
}
echo " \n";
}
function render_input_selects_wo_key($myarray,$varname,$defval,$multiple=false,$size=1,$def_name="--Mindegy--")
{
if ($multiple)
{
echo "\n";
}
else
{
echo "\n";
if (!$defval)
{
echo "$def_name \n";
}
else
{
echo "$def_name \n";
}
}
if ($myarray)
{
foreach($myarray as $key => $value)
{
if ($value == $defval)
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
}
echo " \n";
}
function render_input_selects_wo_def($myarray,$varname,$defval)
{
echo "\n";
if ($myarray)
{
foreach($myarray as $key => $value)
{
if ($key == $defval)
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
}
echo " \n";
}
function render_input_selects_wo_def_onsubmit($myarray,$varname,$defval,$title="")
{
echo "\n";
if ($myarray)
{
foreach($myarray as $key => $value)
{
if ($key == $defval)
{
echo "$value \n";
}
else
{
echo "$value \n";
}
}
}
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] m
2 ";
$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] m
2 ";
$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] m
2 ";
$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 .= "
\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 .= "
\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 .= "$value";
$res .= " \n";
}
$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;
}
}
?>