Major Additions - DamnComp - MemberMap

ABOUT
After moving over from xenforo the one thing I was missing on my forum was a membermap. This is a map where your users can pin their location so that others can see where people are. This modification does just this.


FEATURES
Admin Settings:

Enable Membermap - Globally switches membermap and associated tabs off
Allowed Usergroups - Which usergroups can see the membermap
Can Edit - Which usergroups can add/edit markers on the map



User Functions

Add/Edit marker by drag drop on map
Add/Edit marker by searching for location by text
Online users show different colour
Popup bubble on markers with avatar and profile link
Live user search

INSTALL

Upload all files in the upload folder to your forum directory leaving their structure intact, then import the product file. If you are using a custom skin, please ensure you also add the dcmembermap image folder to your own misc directory within images

PLEASE NOTE THIS MODIFICATION IS IN BETA STAGE. SUPPORT WILL BE GIVEN ONLY TO THOSE WHO SPECIFY INSTALLED.

Changelog:
13 July 2012 - Updated failed installer
14 July 2012 - Beta 1.1 Release. Fixes missing avatars and removed unused column from database which may be causing installation issues.
14 July 2012 - Beta 2 Released. Infomation box has now been replaced so that css can be edited if required. Prefix added to install code to fix issues with install. Various other minor fixes.
15 July 2012 - Beta 3 Released - Installer prexif code amended. Who's online now fixed to show members online within map area. Avatars set from admin set avatars now working. Various other minor fixes.
17 July 2012 - 1.0.0 final Released - Final phrases added so the product is now fully phrased.
18 July 2012 - 1.0.1 Released - Phrase added for breadcrumb text, support for umlauts and other utf8 characters.
20 July 2012 - 1.0.2 Released - All phrases now utf encoded for foreign language support, avatar creation changed to reduce query and remove problems, missing table prefix added, new settings added for default longitude/latitude/zoom level.
29 July 2012 - 1.0.3 Released - Security update
29 July 2012 - 1.0.4 Released - Fixed what I previously broke due to being half asleep. That will teach me!
30 July 2012 - 1.0.4b Released - Quick fix for markers not updating correctly.

[ProFifaLeagues]

Will Install when i get home Nice work mate thank you

[Krusty1231]

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT U.username as username,
U.userid as userid,
MM.lat as lat,
MM.lon as lon,
IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,
U.avatarrevision,
AV.avatarpath,
NOT ISNULL(CAV.userid) AS hascustomavatar,
CAV.dateline AS avatardateline,
CAV.width AS avwidth,
CAV.height AS avheight,
U.lastactivity

FROM _vbdc_membermap AS MM
LEFT JOIN _vbuser AS U ON U.userid = MM.userid
LEFT JOIN _vbavatar AS AV ON (AV.avatarid = U.avatarid)
LEFT JOIN _vbcustomavatar AS CAV ON (CAV.userid = U.userid);

MySQL Error : Table 'jerry_forum._vbdc_membermap' doesn't exist
Error Number : 1146
Request Date : Thursday, July 12th 2012 @ 05:59:39 PM
Error Date : Thursday, July 12th 2012 @ 05:59:40 PM
Script : http://www.XXXXXX/forum/dcMembermap.php
Referrer : http://www.XXXXXX/forum/forum.php
IP Address : XX.XX.XX.XXX
Username : Jerry
Classname : vB_Database
MySQL Version : 5.5.23-55

[soniceffect]

Did you get any errors when you installed?

EDIT: Issue with installer, sorting now an will reupload

[Krusty1231]

None. It installed fine....

[soniceffect]

This one will work. Updating main package in a min

EDIT: Main package now updated also. If you have already installed, please uninstall the product and reinstall with the latest one. The old one wasnt creating tables correctly. Sorry guys

Please ensure you click on INSTALL if you add

[orangefive]

Hi - installed but cant see a marker to drag.

[soniceffect]

You need to add a marker first by clicking an area on the map. Please click installed

[soniceffect]

Originally Posted by orangefive

Hi - installed but cant see a marker to drag.

Ah sorry now I understand .. Are you running this on a custom skin? If so you will need to add the image files into your own image directory.

misc/dcmembermap is the folder. You will need to ensure that the folder dcmembermap is within the skin folder of the skin you are using as well.

[CoZmicShReddeR]

I think some are used to the one that grabs your IP... Is it possible to set it to choose a user info box color to match web design and html mockup color scheme.. For instance my theme is dark and the user names are white...

Need a fix it shifts the theme/style over to the left
http://www.cozworld.com/dcMembermap.php

Anyways thanks for making something simple to hook up!