The Arcive of Official vBulletin Modifications Site.

DamnComp - MemberMap · **Released**: 07-11-2012

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.

Geisthund99 · #**102** 07-14-2012, 01:43 PM

Code:

//Check to see if user already has a marker
$dc_markercheck = $vbulletin->db->query_read_slave("
SELECT userid FROM dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']
);

Missing TABLE_PREFIX

Also the code below has disappeared from dcMembermap.php Beta 2

Code:

//Get avatar for current user
$dc_currentuser = $vbulletin->db->query_first("
SELECT U.username as username,
       U.userid as userid,
       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 " . TABLE_PREFIX . "user AS U
LEFT JOIN " . TABLE_PREFIX . "avatar AS AV ON (AV.avatarid = U.avatarid)
LEFT JOIN " . TABLE_PREFIX . "customavatar AS CAV ON (CAV.userid = U.userid) WHERE U.userid = ".$vbulletin->userinfo['userid']);

     if ($vbulletin->options['usefileavatar'])
      {

      $dc_avimagecurrent = $vbulletin->options['avatarurl'] . "/avatar{$dc_currentuser[userid]}_{$dc_currentuser['avatarrevision']}.gif";
      }
      else
      {
      $dc_avimagecurrent = $vbulletin->options['bburl'] . "/image.php?u=$dc_currentuser[userid]&amp;dateline=$dc_currentuser[avdateline]";
      } 
require_once(DIR . '/includes/functions_user.php'); 
$dc_htmlusercurrent = fetch_musername($dc_currentuser);


if ($db->num_rows($dc_markercheck))
{$dc_hasmarker = true;}else{$dc_hasmarker = false;}

$viewablegroups = unserialize($vbulletin->options['DC_membermap_visible']);
$editgroups = unserialize($vbulletin->options['DC_membermap_canedit']);
$dc_canedit = is_member_of($vbulletin->userinfo,$viewablegroups);

Also where I had 2 pins appearing on the map there is now only 1 now visable.

Can I request you include the release version in dcMembermap.php ie beta 1 to avoid any confusion.
Regards
Gareth

soniceffect · #**103** 07-14-2012, 01:44 PM

Quote:

Originally Posted by Poppet

That's fixed it m8, well done Marc...

And Jos (BlueWolf_) who is the co-developer

Fantastic. Will get a fwe release package based on that

soniceffect · #**104** 07-14-2012, 01:53 PM

Quote:

Originally Posted by Geisthund99

Code:

//Check to see if user already has a marker
$dc_markercheck = $vbulletin->db->query_read_slave("
SELECT userid FROM dc_membermap WHERE userid = ".$vbulletin->userinfo['userid']
);

Missing TABLE_PREFIX

This is fixed in the file above, I just need to rebuild the package on the main thread.

Quote:

Also the code below has disappeared from dcMembermap.php Beta 2

Code:

//Get avatar for current user
$dc_currentuser = $vbulletin->db->query_first("
SELECT U.username as username,
       U.userid as userid,
       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 " . TABLE_PREFIX . "user AS U
LEFT JOIN " . TABLE_PREFIX . "avatar AS AV ON (AV.avatarid = U.avatarid)
LEFT JOIN " . TABLE_PREFIX . "customavatar AS CAV ON (CAV.userid = U.userid) WHERE U.userid = ".$vbulletin->userinfo['userid']);

     if ($vbulletin->options['usefileavatar'])
      {

      $dc_avimagecurrent = $vbulletin->options['avatarurl'] . "/avatar{$dc_currentuser[userid]}_{$dc_currentuser['avatarrevision']}.gif";
      }
      else
      {
      $dc_avimagecurrent = $vbulletin->options['bburl'] . "/image.php?u=$dc_currentuser[userid]&amp;dateline=$dc_currentuser[avdateline]";
      } 
require_once(DIR . '/includes/functions_user.php'); 
$dc_htmlusercurrent = fetch_musername($dc_currentuser);


if ($db->num_rows($dc_markercheck))
{$dc_hasmarker = true;}else{$dc_hasmarker = false;}

$viewablegroups = unserialize($vbulletin->options['DC_membermap_visible']);
$editgroups = unserialize($vbulletin->options['DC_membermap_canedit']);
$dc_canedit = is_member_of($vbulletin->userinfo,$viewablegroups);

Also where I had 2 pins appearing on the map there is now only 1 now visable.

Can I request you include the release version in dcMembermap.php ie beta 1 to avoid any confusion.
Regards
Gareth

I beg to differ. Including old broken code causes confusion. The older beta files had issues that have been fixed in beta 2. As it happens the dc_Membermap.php has not been changed. The code you have posted above, half of it is from that file and half of it is from the plugin.

The issue with 2 pins, can I ask do you have the same problem on your default skin? I have a problem I am tryin to solve with custom skins which is why I ask

Ricsca · #**105** 07-14-2012, 02:13 PM

If istalla the table are dc_membermap but my vbulletin are the prefix vb_

CoZmicShReddeR · #**106** 07-14-2012, 02:22 PM

Quote:

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

I think maybe either your not showing the outsides of the theme or your desktop is set so small your not seeing what I see unless it's my admin access causing it but I do not have any issues with any other mods or plugins shifting the themes to the left side...

Could you test it maybe making the default theme you use to a fixed theme?

soniceffect · #**107** 07-14-2012, 03:06 PM

Have tested with that m8, and the only issue there would ever be is if the theme is too small to fit the map, in which case the map width would need changing in the css file for your skin.

BTW, its a smaller screen that the issue would be seen on, not a larger one. As said before if you are willing to give me details to see what you are seeing I am more than willing to take a look for you.

soniceffect · #**108** 07-14-2012, 03:08 PM

Quote:

Originally Posted by Ricsca

If istalla the table are dc_membermap but my vbulletin are the prefix vb_

Please uninstall and use the installer in this file

https://vborg.vbsupport.ru/showpost....4&postcount=99

CoZmicShReddeR · #**109** 07-14-2012, 03:12 PM

This is what I see when I look at it... See the gap on the R/S?

soniceffect · #**110** 07-14-2012, 03:25 PM

Quote:

Originally Posted by CoZmicShReddeR

This is what I see when I look at it... See the gap on the R/S?

AHHH NOW I see ...... bare with me will see what we can see

soniceffect · #**111** 07-14-2012, 03:45 PM

Quote:

Originally Posted by CoZmicShReddeR

This is what I see when I look at it... See the gap on the R/S?

OK go to the template dcMembermap

find

Code:

  <body style="margin:0px; border:0px; padding:0px;">

Replace with

Code:

<body>

This was added while testing and never removed. Will not be there in the next version.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09601 seconds Memory Usage 2,371KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (6)bbcode_code (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (4)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (6)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

4 благодарности(ей) от:
Beckenbauer, K4GAP, NoMatt3r, tekram

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!