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.

[soniceffect]

Originally Posted by Nirjonadda

Does it work on 4.1.10 ?

I would suspect the only thing that will certainly not work is the navigation link, so if you are confident in adding a link yourself you would need to add one to dcMembermap.php. Other than that I cant see any reason why it wouldnt work, although its not tested on 4.1.

Originally Posted by ywwz

But there is no Avatar ah?? Little problem, but with Avatar it would be perfect!

Aware of this one. Will be fixed in beta 2 which will be released later tonight.

[Nirjonadda]

Installer But not working get Database error in dcMembermap.php and bug on Damn Comp - Membermap Options Setting page , You can fix this for working on 4.1.10 ?

Attachment 139773

Database error in vBulletin 4.1.10:

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 '******_forums.vbdc_membermap' doesn't exist
Error Number  : 1146
Request Date  : Friday, July 13th 2012 @ 10:49:58 PM
Error Date    : Friday, July 13th 2012 @ 10:49:58 PM
Script        : http://www.*********.net/dcMembermap.php

[BlueWolf_]

Originally Posted by 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!

I looked around and the shift issue is caused by the social bar you have above it. To be more precise, the 'Pin it' button. For some reason that one sticks out and causes the layout below it to shift. You'll be able to fix it if you manually set 'height: 20px' on the div that contains the iframe

[Geisthund99]

Originally Posted by Geisthund99

I just downloaded zip file and got the same error.
Also same error when I downloaded updated file!!
No vbulletin.vb_dc_membermap created.
Cheers
Gareth


Others are installing this fine now (although appreciate their are some small issues in the map) so not sure on this one. Are you getting any errors at the point of install?

The install appears fine but for some reason no tables are being created.
Can you post the sql to create the tables?
Regards

[Geisthund99]

Just a thought but both of us with a problem are using MySQL Version : 5

[Geisthund99]

Just noticed there are 3 of us having a problem

[soniceffect]

If you are gettin the sql error try adding this table

[sql]
CREATE TABLE IF NOT EXISTS `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]

If anyone tries this and they get an error, please could they let me know what the error is so I can fix. Cheers. Tested on 5.1 as thats the only version I have available at the moment

[soniceffect]

Just released a beta 1.1 whilst we are working on beta 2 which fixes the avatar issues and possibly the installer if the problem is what I think it may be

[ProFifaLeagues]

Originally Posted by soniceffect

Just released a beta 1.1 whilst we are working on beta 2 which fixes the avatar issues and possibly the installer if the problem is what I think it may be

Hello just a Quick note the link in your Sig is missing the : out fella

[Ricsca]

Originally Posted by soniceffect

Please click install for support

Ok...