aaargh.... now have th reverse of the problem.
I've got the map loading but now it's not communicating with community builder where it was before.
Can anyone help me with this: I am assuming that if the location data is not being pulled from the database then it is likely to be a problem with mapxml.php rather than any other file.
Am I right in assuming that swfimgproxy.php and swfimgproxy.inc.php are purely for processing the avatars and would not be causing the problem?
the paths to the in config.xml are clearly correct because the map data is loading.
my thoughts are that there is a problem with the sql query from the new files posted on hypnotoad's site:
PHP Code:
$query=" SELECT a. * , b. * , c.avatar, c.userid
FROM `jos_users` AS a
LEFT JOIN `jos_comprofiler` AS b ON b.id = a.id
LEFT JOIN `jos_sb_users` AS c ON c.userid=a.id
WHERE c.avatar <> ''
AND b.banned =0
AND b.cb_latitude <> ''
AND b.cb_longitude <> '' ";
$result=mysql_query($query);
Can anyone suggest what might be wrong with this picture?
PHP Code:
$line = '<row
id="'.$row[id].'"
title="'.ucwords(strtolower($row[username])).'"
file="'.$path2proxy.$image_url.'"
url="'.$pre_url.$row[user_id]."/".'"
loc="'.$row[cb_city].', '.$row[cb_country].'"
date="'.$row[registerDate].'"
lat="'.$row[cb_latitude].'"
lon="'.$row[cb_longitude].'"
/>';
I don't have simpleboard installed. Would this:
PHP Code:
LEFT JOIN `jos_sb_users` AS c ON c.userid=a.id
be causing the problem?