Thread: Major Additions - DamnComp - MemberMap
View Single Post
  #79  
Old 07-13-2012, 10:16 PM
soniceffect's Avatar
soniceffect soniceffect is offline
 
Join Date: Feb 2005
Location: UK
Posts: 453
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Nirjonadda View Post
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 View Post
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 View Post
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 View Post
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]
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01191 seconds
  • Memory Usage 1,777KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete