 Hi Everyone
Can anyone help me with changing my world map to only show members who are featured. I want to use world map to only show featured members as I am taking on businesses who are featured and only want to display local businesses on my map.
Thanks in Advance
Gareth |
Hi All I managed to work out how to do this. For anyone else looking to display only featured members on the world map, you'll need to edit /modules/boonex/map_profiles/classes/BxMapDb.php and change line 102: return $this->getAll("SELECT `m`.`id`, `p`.`Avatar`, `p`.`NickName`, `m`.`lat`, `m`.`lng` FROM `" . $this->_sPrefix . "profiles` AS `m` INNER JOIN `Profiles` AS `p` ON (`p`.`ID` = `m`.`id`) WHERE `m`.`failed` = 0 AND `p`.`Status` = 'Active' AND `m`.`allow_view_location_to` = '" . BX_DOL_PG_ALL . "' $sWhere LIMIT 250"); to return $this->getAll("SELECT `m`.`id`, `p`.`Avatar`, `p`.`NickName`, `m`.`lat`, `m`.`lng` FROM `" . $this->_sPrefix . "profiles` AS `m` INNER JOIN `Profiles` AS `p` ON (`p`.`ID` = `m`.`id`) WHERE `m`.`failed` = 0 AND `p`.`Status` = 'Active' AND `p`.`Featured` = '1' AND `m`.`allow_view_location_to` = '" . BX_DOL_PG_ALL . "' $sWhere LIMIT 250"); Hope this helps. |
