Integrate Flashmap with community builder

[zeman]

Hi People,

Mark here, I designed the flash photoblog world map.

If you're having problems with directories I suggest that you put in the full url.

So in the html code change "map.swf" to a full url like "http://www.yourdomain.com/map/map.swf" and I would also do the same for the "mapdatadir" in the config.xml file. "http://www.yourdomain.com/map/mapdata/".

The "config.xml" file should be in the same directory as the page loading the map.

Let me know if you still have troubles and I'll make a custom version of the map that allows you to specify where the "config.xml" file is via the thml code.

[larpo]

Hi,

I'm still having this problem even after changing the url in config.xml to:

mapdatadir="http://www.redr.org/dev/map/mapdata/"

data is loading from community builder, and map_php.swf is loading correctly, but the mapdata is not being loaded into the movie...

you can see what I mean here: http://www.redr.org/dev/content/view/19/19/

Can you think why this might be?

Thanks for your help

David

[thehypnotoad]

You seem to have some URL-rewrite active, maybe that prevents the map from loading with the absolute path - see if you can load just the basic .swf File directly in the browser...


For anyone else: I finally wrote a small Howto, summing up all proposals here and my own experiences:
http://omnibus.uni-freiburg.de/~s8ar..._flashmap.html

[larpo]

I have tried loading the map directly by entering the URL for the map_php.swf into the browser... still no map data... this is most odd.

[larpo]

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?

[larpo]

OK... some headway...

for those still struggling with this. I have got the location data to load into the map by removing the line

date="'.$row[registerDate].'"

from:

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].'" 
    />'; 


Now I have a different problem in that the url to the profile doesn't work, and under the username on the map are two lines saying:

undefined
undefined

Presumably this is location data... anyone know why this might be?

so no one has this running on jos 1.4 and cbrc2?

[larpo]

i do... http://www.redr.org/dev/content/view/19/19/

but there are some minor issues...

linking to the profile appears not to be working. I am using the SEF urls option in joomla, so the link in my mapxml.php looks like this:

PHP Code:

$pre_url=$rootPath.'component/option,com_comprofiler/task,userProfile/user,'; 


One irritation which you may like to remember if testing this is that you need to clear your temp internet files each time you edit and upload, as the files and swf get cached.

Originally Posted by larpo

i do... http://www.redr.org/dev/content/view/19/19/

but there are some minor issues...

linking to the profile appears not to be working. I am using the SEF urls option in joomla, so the link in my mapxml.php looks like this:

PHP Code:

$pre_url=$rootPath.'component/option,com_comprofiler/task,userProfile/user,'; 


One irritation which you may like to remember if testing this is that you need to clear your temp internet files each time you edit and upload, as the files and swf get cached.

PHP Code:

$pre_url=$rootPath.'index.php?option=com_comprofiler&task=userProfile&user='; 


and

PHP Code:

url="'.$pre_url.$row[user_id]."/".'" 


does that work for you??

edit: this should work now.. solves all link issues! : )

[larpo]

hmm... no. Link to profile from the map still doesn't appear to work for me.

look: http://www.redr.org/dev/content/view/19/19/

mapxml.php now looks like this:

PHP Code:

<?php
require("configuration.php");
// Add the details of you exisiting database
$host="$mosConfig_host";
$username="$mosConfig_user";
$password="$mosConfig_password";
$database="$mosConfig_db";
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

// Add the url to your mambo root -for example $rootPath="http://www.mysite.com/mam/" remembering to 
// include the trailing slash..
$rootPath="http://www.redr.org/dev/";

#################################################
## If you have used a different prefix to your ##
## mambo database then the standard mos_ then  ##
## please change the $query statement below    ##
#################################################

$query=" SELECT a. * , b. *
FROM `jos_users` AS a
LEFT JOIN `jos_comprofiler` AS b ON b.id = a.id
WHERE b.avatarapproved =1
AND b.banned =0 
AND b.avatar <> '' 
AND b.cb_latitude <> ''
AND b.cb_longitude <> '' ";
$result=mysql_query($query);

##-----Nothing more needs editing below------##

$pre_url=$rootPath.'index.php?option=com_comprofiler&task=userProfile&user=';  


echo '<?xml version="1.0" encoding="UTF-8"?>';
echo '<datapacket>';
while($row=mysql_fetch_array($result)){

# Use the line below for Community Builder Avatars, for the ones
# from Simpleboard, the second!

$image_url=$rootPath.'images/comprofiler/tn'.$row[avatar];
#$image_url=$rootPath.'components/com_simpleboard/avatars/'.$row[avatar];

    //see what file extention the avatar has and then decide
    //if $path2proxy will call the conversion program
    $dotarray = explode(".",$row[avatar]);
    $fileending = $dotarray[(count($dotarray)-1)];
    if ((strtolower($fileending))=="jpg"){
        $path2proxy="";
            }else{
                $path2proxy=$rootPath.'swfimgproxy.php?url=';
                };


    $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].'" 
    lat="'.$row[cb_latitude].'" 
    lon="'.$row[cb_longitude].'"
    />';
    
    echo $line;
}
echo '</datapacket>';
?>