at /home/gpsesta9/public_html/libs/db.php line 4Array
(
[code] =>
[message] =>
[query] => mysql_connect()
[context] => /home/gpsesta9/public_html/libs/db.php line 4
)
at /home/gpsesta9/public_html/libs/db.php line 24Array
(
[code] =>
[message] =>
[query] => select dollar, euro from c_curs where t_day = CURDATE()
[context] => /home/gpsesta9/public_html/libs/db.php line 24
)
at /home/gpsesta9/public_html/libs/db.php line 16Array
(
[code] =>
[message] =>
[query] => INSERT INTO c_curs (`dollar`, `euro`, `t_day`) VALUES('', '', '')
[context] => /home/gpsesta9/public_html/libs/db.php line 16
)
at /home/gpsesta9/public_html/libs/db.php line 24Array
(
[code] =>
[message] =>
[query] => select
c_houses.lot_num as id,
c_houses.lot_num as lot_num,
(select l_houses_types.title from l_houses_types where l_houses_types.id=c_houses.h_type) as h_type,
(select l_highways.title from l_highways where l_highways.id=c_houses.highway) as highway,
c_houses.otmkad as otmkad,
(select l_districts.title from l_districts where l_districts.id=c_houses.district) as district,
(select l_villages.title from l_villages where l_villages.id=c_houses.village) as village,
(select c_compounds.title from c_compounds where c_compounds.id=c_houses.compound) as compound,
c_houses.compound as compound_id,
case c_houses.currency
when 1 then round(c_houses.s_price/66.7044)
when 2 then round(c_houses.s_price)
when 3 then round((c_houses.s_price*75.2492)/66.7044)
end as sprice_usd,
case c_houses.currency
when 1 then round(c_houses.s_price)
when 2 then round(c_houses.s_price*66.7044)
when 3 then round(c_houses.s_price*75.2492)
end as sprice_rur,
case c_houses.currency
when 1 then round(c_houses.r_price/66.7044)
when 2 then round(c_houses.r_price)
when 3 then round((c_houses.r_price*75.2492)/66.7044)
end as rprice_usd,
case c_houses.currency
when 1 then round(c_houses.r_price)
when 2 then round(c_houses.r_price*66.7044)
when 3 then round(c_houses.r_price*75.2492)
end as rprice_rur,
c_houses.u_area,
(select l_landscape_types.title from l_landscape_types where l_landscape_types.id = c_houses.u_landscape) as u_landscape,
c_houses.u_options,
c_houses.h_area,
c_houses.h_storeys,
c_houses.h_levels,
(select l_foundation_types.title from l_foundation_types where l_foundation_types.id = c_houses.h_foundation) as h_foundation,
(select l_wall_types.title from l_wall_types where l_wall_types.id = c_houses.h_walls) as h_walls,
(select l_floor_types.title from l_floor_types where l_floor_types.id = c_houses.h_floors) as h_floors,
(select l_roof_types.title from l_roof_types where l_roof_types.id = c_houses.h_roof) as h_roof,
(select l_facing_types.title from l_facing_types where l_facing_types.id = c_houses.h_facing) as h_facing,
(select l_finishing_types.title from l_finishing_types where l_finishing_types.id = c_houses.h_finishing) as h_finishing,
(select l_furniture_types.title from l_furniture_types where l_furniture_types.id = c_houses.h_furniture) as h_furniture,
c_houses.h_options,
c_houses.h_plannig,
(select l_gas_types.title from l_gas_types where l_gas_types.id = c_houses.c_gas) as c_gas,
c_houses.c_elpower,
(select l_water_types.title from l_water_types where l_water_types.id = c_houses.c_water) as c_water,
(select l_sewage_types.title from l_sewage_types where l_sewage_types.id = c_houses.c_sewage) as c_sewage,
c_houses.c_options
from c_houses where c_houses.deleted=0 and c_houses.lot_num=''
[context] => /home/gpsesta9/public_html/libs/db.php line 24
)