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]

Updated to the beta and Avatars Work A1 now thank you!
Upgrade was pain-free and easy too which is always nice

[Doc2911]

good work, but i get this message.

Warnung: getimagesize() [function.getimagesize]: http:// wrapper is disabled in the server configuration by allow_url_fopen=0 in [path]/includes/class_bootstrap.php(430) : eval()'d code (Zeile 98)

Warnung: getimagesize(http://www.c-l-f.org/image.php?u=1&dateline=) [function.getimagesize]: failed to open stream: no suitable wrapper could be found in [path]/includes/class_bootstrap.php(430) : eval()'d code (Zeile 98)

[Geisthund99]

I ran the sql
now getting

Invalid SQL:
SELECT userid FROM dc_membermap WHERE userid = 1;

This appears to be related to table prefix I add to the sql statement.
SELECT userid FROM dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']

This works:
SELECT userid FROM vb_dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']

The map appears fine.

It might be nice to have the map import users location from their profiiles. Just a thought cheers
Gareth

[Gemma]

Installed the latest version. Works perfectly. Thank you

[BlueWolf_]

Originally Posted by Geisthund99

I ran the sql
now getting


This appears to be related to table prefix I add to the sql statement.
SELECT userid FROM dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']

This works:
SELECT userid FROM vb_dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']

The map appears fine.

It might be nice to have the map import users location from their profiiles. Just a thought cheers
Gareth

Though it sounds great, there are two reason why it would be better to not do that:
#1. It'll have to use Google's geo search function to mass convert all this data. They put restrictions on how many times per day (and how fast) you can do that. You'll quickly get yourself blocked if you do 8k* queries right after each other to get all the data.
* Depending on the size of the member base of course.

#2. Like soniceffect stated above, some cities are interpreted wrongly as they exist in multiple countries. There's a fairly big chance members will be put in the US while they actually live in the UK for example. Lots of people neglect to define their location properly.

[Ricsca]

Originally Posted by soniceffect

Seems you are getting the same installation problem. Please could you try the installer in the new package and let me know if it works? Think I may have found the issue

Dont work in my site

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

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

[orangefive]

avatars now working nice one!!

[soniceffect]

Originally Posted by Nirjonadda

vBulletin 4.1.10

Sorry I cannot guarentee it will work on that version. Im assuming that the settings are slightly different on that setup. I may release a version for that at some point, however not on my priority list at the moment. To be honest I would recommend you upgrade to 4.2.0 anyways. Any reason why you havent updated?

Originally Posted by Doc2911

good work, but i get this message.

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.

Originally Posted by Geisthund99

I ran the sql
now getting


This appears to be related to table prefix I add to the sql statement.
SELECT userid FROM dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']

This works:
SELECT userid FROM vb_dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']

The map appears fine.

It might be nice to have the map import users location from their profiiles. Just a thought cheers
Gareth

Try this statement instead in your case
[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]

Originally Posted by Ricsca

Dont work in my site

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

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

Please could you try running the following in phpmyadmin as I am assuming the table is not there. However Im now 100% about this as I cannot see the sql error. If you can provide me with the actual error I can help more.

[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]

[soniceffect]

affffffffffffffffffff

[orangefive]

You deserve a medal pal. Best supported beta ive ever used.