OS Property support center

SOLVED!!! request info: "not set"

  • Enzo Artale
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 6 months ago - 10 years 6 months ago #59373 by Enzo Artale
SOLVED!!! request info: "not set" was created by Enzo Artale
Hi Dam
One of the properties I published as owner in frontend has got two requests for more info by users. The issue is that I still see this field in my frontend owner panel as "not set" (first image), while as admin I can see in backend the number of requests correctly displayed in properties managing view (second image). How to set it up in order to make it work also for owners in frontend? Thanks
Last edit: 10 years 6 months ago by Dang Thuc Dam.

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #59407 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic request info: "not set"
Hi Enzo,
To solve the issue, please follow these steps
1. Open file: components > com_osproperty > classes > agent.php
2. find
$query = "Select a.id, a.ref, a.pro_name, d.id as typeid,d.type_name as type_name,g.name as agent_name,a.published,a.approved, a.isFeatured,a.curr,a.price,a.price_call,a.rent_time,a.show_address,a.hits,c.city,s.state_name as state_name,a.address, ex.expired_time,ex.expired_feature_time from #__osrs_properties as a"
." INNER JOIN #__osrs_agents as g on g.id = a.agent_id"
." LEFT JOIN #__osrs_types as d on d.id = a.pro_type"
." INNER JOIN #__osrs_countries as e on e.id = a.country"
." LEFT JOIN #__osrs_states as s on s.id = a.state"
." LEFT JOIN #__osrs_cities as c on c.id = a.city"
." LEFT JOIN #__osrs_expired as ex on ex.pid = a.id"
." WHERE a.agent_id = '$agent->id'";

and replace by

$query = "Select a.id, a.ref, a.pro_name, d.id as typeid,d.type_name as type_name,g.name as agent_name,a.published,a.approved, a.isFeatured,a.curr,a.price,a.price_call,a.rent_time,a.show_address,a.hits,c.city,s.state_name as state_name,a.address, ex.expired_time,ex.expired_feature_time,a.total_request_info from #__osrs_properties as a"
." INNER JOIN #__osrs_agents as g on g.id = a.agent_id"
." LEFT JOIN #__osrs_types as d on d.id = a.pro_type"
." INNER JOIN #__osrs_countries as e on e.id = a.country"
." LEFT JOIN #__osrs_states as s on s.id = a.state"
." LEFT JOIN #__osrs_cities as c on c.id = a.city"
." LEFT JOIN #__osrs_expired as ex on ex.pid = a.id"
." WHERE a.agent_id = '$agent->id'";

Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Enzo Artale
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
10 years 6 months ago #59445 by Enzo Artale
Replied by Enzo Artale on topic request info: "not set"
SOLVED! Thank you Dam

Please Log in or Create an account to join the conversation.

Moderators: Dang Thuc DamNguyen Phu Quan