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.

[Poppet]

We've installed this tonight and this is the database error,

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 'troton_forum.vBdc_membermap' doesn't exist
Error Number : 1146

[Doc2911]

Originally Posted by soniceffect

Will have to look into that. This is the fix I have just put in place for the avatars which seems to be disabled on your php installation. May be worth contacting your host with this message as they may be able to enable it for you. In the meantime I will try and find a workaround.

your are right, this

allow_url_fopen

was the prob in the php installation, fixed and now it works perfect.

thx for help and the mod.

cya

[nukinfuts29]

For many of you with DB issues it may be something very simple that you overlooked, I know i did:

Check the prefix on the dc table. I have a custom vb prefix on my database and the mod was looking in the wrong place.

[ywwz]

Fantastic update! I can see Avatar now! Exellent!

[Ricsca]

Originally Posted by soniceffect

[sql]
CREATE TABLE IF NOT EXISTS `vb_dc_membermap` (
`markerid` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`desc` text,
`lat` float(10,6) NOT NULL,
`lon` float(10,6) NOT NULL,
PRIMARY KEY (`markerid`),
UNIQUE KEY `idx_user` (`userid`))
[/sql]

The map work but if save the position have this error:

http://www.tuttoserpenti.it/dcMembermap.php

[soniceffect]

Originally Posted by nukinfuts29

For many of you with DB issues it may be something very simple that you overlooked, I know i did:

Check the prefix on the dc table. I have a custom vb prefix on my database and the mod was looking in the wrong place.

YOU MY FRIEND ARE A GENIOUS! ....... I cant believe I overlooked something so simple. Fix on its way

[CoZmicShReddeR]

Please test this on a fixed theme/style as I do not see anyone posting here using a fixed theme and I removed all the plugins you said might be causing the misalignment...

http://www.cozworld.com/dcMembermap.php

Thanks!

[soniceffect]

No worries m8. If you do need that plugin you removed and need it sorting for you let me know. Looks good on there though m8 other than the popup colours which is actually sorted in beta2 being released shortly

Seems to look find on your theme from here btw

[soniceffect]

Has been tested on default skin only as cannot build a modification that fits every skin on the planet due to not knowing what those skins entail. However it does work on fixed skins no problem, including yours as you can see in this screenshot.

If you find it is being hidden somewhat though or its overlapping the edge of your skin, this will be due to the size of the map which you would have to have a look at within dcMembermap.css template

[Geisthund99]

Originally Posted by nukinfuts29

For many of you with DB issues it may be something very simple that you overlooked, I know i did:

Check the prefix on the dc table. I have a custom vb prefix on my database and the mod was looking in the wrong place.

Code appears to be missing: TABLE_PREFIX