vb.org Archive - Major Additions - DamnComp

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - DamnComp - MemberMap (https://vborg.vbsupport.ru/showthread.php?t=285479)

Poppet

07-13-2012 11:48 PM

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

07-14-2012 03:57 AM

Quote:

Originally Posted by soniceffect (Post 2347786)

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

Quote:

allow_url_fopen

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

thx for help and the mod.

cya

nukinfuts29

07-14-2012 05:07 AM

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	07-14-2012 07:00 AM

Fantastic update! I can see Avatar now! Exellent!

Ricsca

07-14-2012 07:11 AM

Quote:

Originally Posted by soniceffect (Post 2347786)

[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

07-14-2012 08:13 AM

Quote:

Originally Posted by nukinfuts29 (Post 2347873)

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

CoZmicShReddeR

07-14-2012 08:21 AM

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

07-14-2012 08:25 AM

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

07-14-2012 08:33 AM

1 Attachment(s)

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

07-14-2012 09:35 AM

Quote:

Originally Posted by nukinfuts29 (Post 2347873)

Code appears to be missing: TABLE_PREFIX

soniceffect

07-14-2012 10:24 AM

Quote:

Originally Posted by Geisthund99 (Post 2347964)

Code appears to be missing: TABLE_PREFIX

Yeah I got it m8. I knew to put in there, just for some odd reason didnt. Im blaming lack of sleep LOL

soniceffect

07-14-2012 10:36 AM

Beta 2 now 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.

ProFifaLeagues

07-14-2012 10:50 AM

Superb mate a great update and nice and quick to get it all A1 thank you

soniceffect

07-14-2012 10:52 AM

Cheers :)

Next version will include phrase updates. Will add pagetitle to the phrases and collate all the phrases into their own phrasegroup. That will be beta3 and what I am hoping will be the final beta

Robru

07-14-2012 11:32 AM

I get a blank screen when starting the map...

soniceffect

07-14-2012 11:35 AM

Are you using a custom skin? If so does it work on the default skin? Wondering if you have same problem I have had but only ever been able to replicate once

Vick98

07-14-2012 11:41 AM

Works great! Thank you for the great support and this mod.

Poppet

07-14-2012 12:08 PM

Updated to beta 2, still the same database error, what am I supposed to do to fix it?

soniceffect

07-14-2012 12:31 PM

1 Attachment(s)

Quote:

Originally Posted by Poppet (Post 2348005)

Updated to beta 2, still the same database error, what am I supposed to do to fix it?

please could you try uninstalling and reinstalling with this one and let me know if you still have the same issue?

Poppet

07-14-2012 01:41 PM

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

Geisthund99

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

07-14-2012 01:44 PM

Quote:

Originally Posted by Poppet (Post 2348033)

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

07-14-2012 01:53 PM

Quote:

Originally Posted by Geisthund99 (Post 2348034)

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

07-14-2012 02:13 PM

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

CoZmicShReddeR

07-14-2012 02:22 PM

Quote:

Originally Posted by soniceffect (Post 2347950)

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

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

07-14-2012 03:08 PM

Quote:

Originally Posted by Ricsca (Post 2348042)

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

07-14-2012 03:12 PM

This is what I see when I look at it... See the gap on the R/S?
https://vborg.vbsupport.ru/

soniceffect

07-14-2012 03:25 PM

Quote:

Originally Posted by CoZmicShReddeR (Post 2348057)

This is what I see when I look at it... See the gap on the R/S?
https://vborg.vbsupport.ru/

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

soniceffect

07-14-2012 03:45 PM

Quote:

Originally Posted by CoZmicShReddeR (Post 2348057)

This is what I see when I look at it... See the gap on the R/S?
http://img444.imageshack.us/img444/4506/bothways.jpg

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.

CoZmicShReddeR

07-14-2012 04:59 PM

Ah, thanks so much was driving me crazy!

Now I can move on to my other questions...

Does this plugin support something to auto detect ip's was just wondering if there could be an option to show users from where they logged in from? Not sure where this project is headed other then a user location dart board...

soniceffect

07-14-2012 05:10 PM

Quote:

Originally Posted by CoZmicShReddeR (Post 2348087)

User location dartboard!! I wish you'd said that before I released the mod, I would have called it that LOL.

There are no plans for geolocating users no. Once the current version is fully stable for everyone then I will put down all plans for V1.1, however here are a few ideas we have floating around:

Pin other locations
Link to users pin within postbit
Admin selectable custom profile fields in popup

ProFifaLeagues

07-14-2012 05:26 PM

All three of those options would be Class

Pin other locations
Link to users pin within postbit
Admin selectable custom profile fields in popup

Geisthund99

07-14-2012 05:46 PM

Probelms solved I forgot to re-run Beta 2's product-dc_membermap.xml

Cheers

R4rifi

07-14-2012 05:58 PM

Hi, its a great mode, I've installed on 4.1.10, and cannot fin a link, however i can access to it manually by http://www.urdushanas.com/dcMembermap.php, how to add it in the nav. bar?

CoZmicShReddeR

07-14-2012 06:02 PM

I just remember years ago we had this for PHPNuke and it would also show if the user was online as well... I guess that also is under the Geo location thing but it didn't require a geo Apache module as far as I know...

Are there plans for choosing a theme?
I really need to change the user block would like to have the background in black instead of white...

bzcomputers

07-14-2012 06:03 PM

Quote:

Originally Posted by ProFifaLeagues (Post 2348096)

All three of those options would be Class

Pin other locations
Link to users pin within postbit
Admin selectable custom profile fields in popup

Figured since the ideas were flying...

I run a travel website and I think adding the option of having Personal Maps for each member would be a great option. This would allow them to mark off all their past travel destinations. Just a thought.

Robru

07-14-2012 06:32 PM

Quote:

Originally Posted by soniceffect (Post 2347993)

Are you using a custom skin? If so does it work on the default skin? Wondering if you have same problem I have had but only ever been able to replicate once

I use the default style :)

orangefive

07-14-2012 07:10 PM

beta 2 now installed - avatar but much better as using the forum scheme.

I have an idea for a mod that would be awesome for our site but no idea how to go about it - fo you do stuff for cash? It is basically the map stuff but also allowing members to post routes which it will show from GPX gps files.

We would pay for this!!

orangefive

07-14-2012 09:02 PM

Hello marc - in the whos online bit you still get http://xxxxxxxxxxxxxxxxxxxxxxxx/test.php? by clicking on member map.

All times are GMT. The time now is 07:43 AM.

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01957 seconds Memory Usage 1,846KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (17)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: