Hello,
you need edit file:
modules/mod_realestate_manager_new/tmpl/default.php
there are you need edit select for take price from database
code
Code: |
if($langmodule != "" && $langmodule != "*"){
$selectstring = "SELECT h.id, h.houseid, h.htitle, h.description, h.broker, h.image_link, hc.idcat
nFROM #__rem_houses AS h
nLEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
nLEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
nWHERE ($s) AND h.published=1 AND h.language = '".$langmodule."'
nORDER BY ".$sql_orderby_query." DESC LIMIT 0,$count;";
}
else {
$selectstring = "SELECT h.id, h.houseid, h.htitle, h.description, h.broker, h.image_link, hc.idcat
nFROM #__rem_houses AS h
nLEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
nLEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
nWHERE ($s) AND h.published=1
nORDER BY ".$sql_orderby_query." DESC LIMIT 0,$count;";
}
|
to code
Code: |
if($langmodule != "" && $langmodule != "*"){
$selectstring = "SELECT h.id, h.houseid, h.htitle, h.description, h.broker, h.image_link, hc.idcat, h.price
nFROM #__rem_houses AS h
nLEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
nLEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
nWHERE ($s) AND h.published=1 AND h.language = '".$langmodule."'
nORDER BY ".$sql_orderby_query." DESC LIMIT 0,$count;";
}
else {
$selectstring = "SELECT h.id, h.houseid, h.htitle, h.description, h.broker, h.image_link, hc.idcat, h.price
nFROM #__rem_houses AS h
nLEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
nLEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
nWHERE ($s) AND h.published=1
nORDER BY ".$sql_orderby_query." DESC LIMIT 0,$count;";
}
|
and in self layout add some like below:
Code: |
<div id="brokerest">
<p> <?php echo $row->price; ?>
</p>
</div>
|
Please backup your files first
Thanks,
OrdaSoft team