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
#8152
bekaheni (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Add additional fields in Featured module 3 Years, 6 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.
#8154
admin (Admin)
Admin
Posts: 4874
graph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 3 Years, 6 Months ago Karma: 61  
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.
#8170
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 3 Years, 6 Months ago Karma: 0  
Ai!

Works perfectly!

Cheers
Nick
 
Logged Logged  
  The administrator has disabled public write access.
#8192
admin (Admin)
Admin
Posts: 4874
graph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 3 Years, 6 Months ago Karma: 61  
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
What are you looking for?
Anti-spam question: How many eyes has a typical person?