vb.org Archive
Page 2 of 13 1 2 3412 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)

orangefive 07-13-2012 12:45 PM
Quote:
Originally Posted by soniceffect (Post 2347550)
No access on there m8 even for registered member



No problem, will take a look at these once Im back from work tonight for ya.
Hi - looks liek someones given you access to the same issue - if you need access let me know and ill sort your account out.

Geisthund99 07-13-2012 12:45 PM
Quote:
Originally Posted by Krusty1231 (Post 2347417)
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 'jerry_forum._vbdc_membermap' doesn't exist
Error Number : 1146
Request Date : Thursday, July 12th 2012 @ 05:59:39 PM
Error Date : Thursday, July 12th 2012 @ 05:59:40 PM
Script : http://www.XXXXXX/forum/dcMembermap.php
Referrer : http://www.XXXXXX/forum/forum.php
IP Address : XX.XX.XX.XXX
Username : Jerry
Classname : vB_Database
MySQL Version : 5.5.23-55
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

Ricsca 07-13-2012 01:06 PM
Dont work in http://www.tartaportal.it/dcMembermap.php

orangefive 07-13-2012 01:46 PM
Also in whos online, clicking in Members map if someones on it takes you to xxxxxxxxxxxx./test and 404's

soniceffect 07-13-2012 02:59 PM
Quote:
Originally Posted by Geisthund99 (Post 2347565)
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?


Quote:
Originally Posted by Ricsca (Post 2347568)
Please click install for support

Quote:
Originally Posted by orangefive (Post 2347575)
Also in whos online, clicking in Members map if someones on it takes you to xxxxxxxxxxxx./test and 404's
Will be updating to beta 2 tonight so will add this to my list of fixes. Various other issues have also been looked at.

orangefive 07-13-2012 03:33 PM
Cool - good work!! will keep an eye out :)

ywwz 07-13-2012 03:45 PM
fantastic!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !

This one I don't need to install the what so called php extension geoip sth... COOL!!

vb_nils 07-13-2012 03:47 PM
Very very nice :-)

Thank you for this mod !

Nirjonadda 07-13-2012 03:52 PM
Does it work on 4.1.10 ?

ywwz 07-13-2012 03:57 PM
But there is no Avatar ah?? Little problem, but with Avatar it would be perfect!

soniceffect 07-13-2012 04:23 PM
Quote:
Originally Posted by Nirjonadda (Post 2347618)
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.

Quote:
Originally Posted by ywwz (Post 2347624)
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 07-13-2012 04:39 PM
1 Attachment(s)
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

Code:
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_ 07-13-2012 04:43 PM
Quote:
Originally Posted by CoZmicShReddeR (Post 2347432)
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 07-13-2012 05:28 PM
Quote:
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 07-13-2012 05:31 PM
Just a thought but both of us with a problem are using MySQL Version : 5

Geisthund99 07-13-2012 05:34 PM
Just noticed there are 3 of us having a problem

soniceffect 07-13-2012 06:39 PM
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 07-13-2012 06:59 PM
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 07-13-2012 07:02 PM
Quote:
Originally Posted by soniceffect (Post 2347709)
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 07-13-2012 07:06 PM
Quote:
Originally Posted by soniceffect (Post 2347597)
Please click install for support
Ok...

soniceffect 07-13-2012 07:07 PM
Quote:
Originally Posted by ProFifaLeagues (Post 2347711)
Hello just a Quick note the link in your Sig is missing the : out fella
That was my test of the week, and you passed with flyin colours :D LOL .. Cheers for that, hadnt noticed :)

soniceffect 07-13-2012 07:08 PM
Quote:
Originally Posted by Ricsca (Post 2347713)
Ok...
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

CoZmicShReddeR 07-13-2012 07:13 PM
Any way you can fix it so it doesn't slide the theme over to the left? I had disabled the share plugin but it was still moving the entire usermap page over to the left?

soniceffect 07-13-2012 07:17 PM
Quote:
Originally Posted by CoZmicShReddeR (Post 2347716)
Any way you can fix it so it doesn't slide the theme over to the left? I had disabled the share plugin but it was still moving the entire usermap page over to the left?
Unfortunatly this is a problem with your skin and not the modification. I will certainly take a look though no problem.

EDIT: Its specifically the button which says "pin it" (your pintrest link) which is causing the problem. The div within that iframe is pushing the membermap over. If you can find that div and add height: 20px to it then it will fix the issue.

If your having issues with this, feel free to pm me some admin details and I will see if I can sort for you if you like.

Mr_Running 07-13-2012 07:20 PM
Quote:
Originally Posted by soniceffect (Post 2347709)
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
Cool, I see avatars on version beta 1.1 :)

Note:
Code:
doc_margin
Document Margin changed (less space on margin) on the Member Map page only.
Earlier version it stayed the same.

Nirjonadda 07-13-2012 07:24 PM
Quote:
Originally Posted by Nirjonadda (Post 2347641)
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

Code:
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
Have an fixed this issue ?

soniceffect 07-13-2012 07:33 PM
Hopefully so, however yet to have someone confirm. I cant replcate the issue here. If not the script for adding the table manually I posted above.

@Mr_Running. Not sure what has changed if anything to be honest on that side of things, but will take a look

Nirjonadda 07-13-2012 07:38 PM
1 Attachment(s)
But bug on Options Damn Comp - Membermap Setting page ? Check this ScreenShot Please !

Attachment 139779

soniceffect 07-13-2012 07:58 PM
Quote:
Originally Posted by Nirjonadda (Post 2347732)
But bug on Options Damn Comp - Membermap Setting page ? Check this ScreenShot Please !

Attachment 139779
That is an odd one. What version of vbulletin are you running?

I would maybe suggest reinstalling if this is 4.2.0 as this is not something that should break imo

Nirjonadda 07-13-2012 08:03 PM
vBulletin 4.1.10

ProFifaLeagues 07-13-2012 08:18 PM
Updated to the beta and Avatars Work A1 now thank you!
Upgrade was pain-free and easy too which is always nice

Doc2911 07-13-2012 08:23 PM
good work, but i get this message.

Quote:
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 07-13-2012 08:30 PM
I ran the sql
now getting
Quote:
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 07-13-2012 08:58 PM
Installed the latest version. Works perfectly. Thank you :)

BlueWolf_ 07-13-2012 09:01 PM
Quote:
Originally Posted by Geisthund99 (Post 2347753)
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 07-13-2012 09:06 PM
Quote:
Originally Posted by soniceffect (Post 2347715)
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 07-13-2012 09:58 PM
avatars now working nice one!!

soniceffect 07-13-2012 10:16 PM
Quote:
Originally Posted by Nirjonadda (Post 2347744)
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?

Quote:
Originally Posted by Doc2911 (Post 2347750)
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.

Quote:
Originally Posted by Geisthund99 (Post 2347753)
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]

Quote:
Originally Posted by Ricsca (Post 2347761)
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 07-13-2012 10:18 PM
affffffffffffffffffff

orangefive 07-13-2012 10:31 PM
You deserve a medal pal. Best supported beta ive ever used.


All times are GMT. The time now is 11:39 AM.
Page 2 of 13 1 2 3412 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01628 seconds
  • Memory Usage 1,856KB
  • 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
  • (3)bbcode_code_printable
  • (25)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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