PumpinIron
Well-known member
Looking forward to seeing what this next addon is!
Never mind! Found it in "Crispin_UserMap_profile.css"Map Height
I did a quick search and did not find anything on this: It looks like the width is set to 1005, but the Height is fixed at 540? Is there any way to adjust the height?
Thanks!
% so it's responsive?I should make that a acp option. Next version
Hi,So I see I'm behind a bit on versions. How do I get new versions?
I know its a time, you are busy - but what I realy miss is a search in the Membermap to find ( and display them on the map ) other members near to my location.
So that I only input a radius in km, press on search and the map displays me only all members within this range.
Do you think, you can do this - I see a other map (Woltlab Forum), that has this feature and I found it realy cool.
Done, thanks.Hi,
Can you CP me the PayPal email address you used? Somehow I don't have you on the list.
Next question. What do you think about moving your extra fields from xf_user_profile into it's own table? InnoDB doesn't support SPATIAL indexes so it would be handy to use your POINT location data for other purposes if it was in a MyISAM with an index instead. It's too slow otherwise for spatial queries.
This basic spatial query for a distance from a specific point is a good example on only about 4k rows that have location dataOut of curiosity - what spatial queries are you running?
SELECT
user_id,
X(cum_map_location) AS "latitude",
Y(cum_map_location) AS "longitude",
(
GLength(
LineStringFromWKB(
LineString(
cum_map_location,
GeomFromText('POINT(39.900757 -76.606021)')
)
)
)
)
AS distance
FROM xf_user_profile
WHERE cum_map_location IS NOT NULL
ORDER BY distance ASC
LIMIT 0,30;
drop function if exists lineDistanceC;
delimiter //
CREATE FUNCTION lineDistanceC (la1 DOUBLE, lo1 DOUBLE, la2 DOUBLE, lo2 DOUBLE) RETURNS DOUBLE
BEGIN
SET @r = 6371;
SET @lat1 = RADIANS(la1);
SET @lon1 = RADIANS(lo1);
SET @lat2 = RADIANS(la2);
SET @lon2 = RADIANS(lo2);
SET @x = (@lon2-@lon1) * COS((@lat1+@lat2)/2);
SET @y = (@lat2 - @lat1);
RETURN (SQRT((@x*@x) + (@y*@y)) * @r);
END
//
delimiter ;
SELECT
user_id,
location,
lineDistanceC(X(cum_map_location),Y(cum_map_location),39.900757,-76.606021) AS distance
FROM xf_user_profile
WHERE cum_map_location IS NOT NULL
HAVING distance <=75
ORDER BY distance ASC
We use essential cookies to make this site work, and optional cookies to enhance your experience.