OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Add additional fields in Featured module (0 viewing) 
RealEstateManager component support
Go to bottom Favoured: 0
TOPIC: Add additional fields in Featured module
bekaheni (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Add additional fields in Featured module 9 Years, 4 Months ago
Karma: 0  
Hi there,

Can you tell me if it is possible to add additional fields into the Featured module?

eg I would like to add also the City field.

I have managed to add the location twice just to make sure I can do it! and it works fine.

ie I add this line echo "<div id='fest_location'>{$row->hlocation}</div>"; and thats works fine.

But I have tried 'hcity' or any other field for that matter and it wont display !

Any ideas?

Cheers
Nick
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 7803
graph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 9 Years, 4 Months ago
Karma: 95  
Hello Nick,

At module top you see:

Code:

$query = "SELECT h.htitle, h.id, h.image_link, h.hits, c.id AS catid, h.price, h.published, h.priceunit, h.hlocation, h.featured_clicks, h.featured_shows
        n FROM #__rem_houses AS h
        n LEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
        n LEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
        n WHERE (".$s.") and ( h.featured_clicks > 0 or h.featured_shows > 0 ) ";



You need add "hcity" - to select operator first some like:

Code:

$query = "SELECT h.htitle, h.id, h.image_link, h.hits, c.id AS catid, h.price, h.published, h.priceunit, h.hlocation, h.featured_clicks, h.featured_shows, h.hcity 
        n FROM #__rem_houses AS h
        n LEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
        n LEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
        n WHERE (".$s.") and ( h.featured_clicks > 0 or h.featured_shows > 0 ) ";



Thanks,
OrdaSoft team
Logged Logged
Last Edit: 2013/05/29 07:31 By admin.
The administrator has disabled public write access.
bekaheni (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 9 Years, 4 Months ago
Karma: 0  
Ai!

Works perfectly!

Cheers
Nick
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 7803
graph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 9 Years, 4 Months ago
Karma: 95  
Hi Nick,

You may vote for us on joomla.org and write excellent review

If you will have some error or questions, please write

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Go to top