[BETA] Phoogle (Google) Map

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Ronja
Registered User
Posts: 21
Joined: Sat Jul 05, 2008 9:09 pm

Re: [BETA] Phoogle (Google) Map

Post by Ronja »

I have a problem.

I have installed the mod, and it seems to work fine, but when I type ind the google api code, is says that the code is registred to another webside?
I think that it is becouse I have an "ø" in my url. But I have also tried to get a key for xn--mypage-zjb.dk, and it dosent even work :?

What can I do?
baudday
Registered User
Posts: 6
Joined: Sun Oct 26, 2008 9:46 pm

Re: [BETA] Phoogle (Google) Map

Post by baudday »

I'm having a problem with the SQL code included in the INSTALL.xml file. I get this massive error.

Code: Select all

Failed to execute SQL : SQL ALTER TABLE `phpbb_users` ADD `user_phoogle_map_center` varchar(255) NOT NULL default '(42, 3)'; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment` mediumtext NOT NULL; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment_bbcode_uid` varchar(8) NOT NULL default ''; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment_bbcode_bitfield` varchar(255) NOT NULL default ''; ALTER TABLE `phpbb_users` ADD `user_phoogle_icon` tinyint(3) unsigned NOT NULL default '3'; ALTER TABLE `phpbb_users` ADD `user_phoogle_allow` tinyint(1) unsigned NOT NULL default '1'; ALTER TABLE `phpbb_users` ADD `user_phoogle_show_me` tinyint(1) unsigned NOT NULL default '0'; CREATE TABLE `phpbb_phoogle_config` ( `map_id` int(11) NOT NULL auto_increment, `map_width` varchar(4) NOT NULL default '515', `width_measure` varchar(10) NOT NULL default 'px', `map_height` varchar(4) NOT NULL default '370', `height_measure` varchar(10) NOT NULL default 'px', `profile_map_width` varchar(4) NOT NULL default '400', `profile_width_measure` varchar(10) NOT NULL default 'px', `profile_map_height` varchar(4) NOT NULL default '300', `profile_height_measure` varchar(10) NOT NULL default 'px', `api_key` varchar(255) NOT NULL default '', `api_lang` char(2) NOT NULL default 'en', `show_control` varchar(5) NOT NULL default '1', `show_type` varchar(5) NOT NULL default '1', `terrain_map` varchar(5) NOT NULL default 'true', `traffic_over` varchar(5) NOT NULL default 'false', `control_type` varchar(5) NOT NULL default 'large', `show_scale` varchar(5) NOT NULL default '1', `show_overview` varchar(5) NOT NULL default '1', `show_gbar` varchar(5) NOT NULL default 'true', `init_zoom` tinyint(2) NOT NULL default '1', `user_zoom` tinyint(2) NOT NULL default '8', `zoom_limit` tinyint(2) NOT NULL default '17', `dbl_clk_zm` varchar(5) NOT NULL default 'true', `cont_zm` varchar(5) NOT NULL default 'true', `scr_whl_zm` varchar(5) NOT NULL default 'true', `map_center` varchar(255) NOT NULL default '(42, 3)', `auto_fit` tinyint(1) NOT NULL default '0', `use_special_markers` tinyint(1) NOT NULL default '1', `use_events` tinyint(1) NOT NULL default '1', `allow_coppa` tinyint(1) NOT NULL default '0', `marker_folder` varchar(100) NOT NULL default 'images/phoogle/markers/', `event_marker_folder` varchar(100) NOT NULL default 'images/phoogle/events/', `map_type` varchar(30) NOT NULL default 'G_NORMAL_MAP', `default_show` int(11) NOT NULL default '20', `dist_units` varchar(5) NOT NULL default 'miles', PRIMARY KEY (`map_id`) ); INSERT INTO `phpbb_phoogle_config` VALUES (1, 515, 'px', 370, 'px', 400, 'px', 300, 'px', 'ABQIAAAAySbm_RunOu_FTG_Dk8GrVhQxBlLipLklY7yW3TfPO8n_Opm0ahQW-KcosQ6nmxr4xpehzyixfwMW8w', 'en', 1, 1, 1, 0, 'large', 0, 0, 1, 1, 8, 17, 1, 1, 1, '(42, 3)', 0, 1, 1, 0, 'images/phoogle/markers/', 'images/phoogle/events/', 'G_NORMAL_MAP', 25, 'miles'); CREATE TABLE `phpbb_phoogle_events` ( `event_id` int(11) NOT NULL auto_increment, `event_map_center` varchar(255) NOT NULL default '', `event_marker` tinyint(3) NOT NULL default '0', `event_title` varchar(255) NOT NULL default '', `event_desc` varchar(255) NOT NULL default '', `event_desc_bbcode_uid` varchar(8) NOT NULL default '', `event_desc_bbcode_bitfield` varchar(255) NOT NULL default '', `event_start` varchar(30) NOT NULL default '', `event_end` varchar(30) NOT NULL default '', PRIMARY KEY (`event_id`) ) ; CREATE TABLE `phpbb_phoogle_events_markers` ( `marker_id` int(11) NOT NULL auto_increment, `marker_image` varchar(255) NOT NULL default '', `marker_width` varchar(5) NOT NULL default '15', `marker_height` varchar(5) NOT NULL default '15', `marker_x` varchar(5) NOT NULL default '7', `marker_y` varchar(5) NOT NULL default '15', `shadow_image` varchar(255) NOT NULL default '', `shadow_width` varchar(5) NOT NULL default '26', `shadow_height` varchar(5) NOT NULL default '15', PRIMARY KEY (`marker_id`) ) ; INSERT INTO `phpbb_phoogle_events_markers` VALUES (1, 'for_sale.png', '24', '21', '12', '21', 'for_sale_s.png', '44', '21'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (2, 'sport.png', '29', '30', '15', '30', 'sport_s.png', '42', '30'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (3, 'house1.png', '18', '21', '9', '21', 'house1_s.png', '34', '21'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (4, 'for_sale2.png', '24', '24', '12', '24', 'for_sale2_s.png', '42', '24'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (5, 'car_red.png', '18', '17', '9', '17', 'car_red_s.png', '31', '17'); INSERT INTO `phpbb_phoogle_events_markers` VALUES (6, 'knife_fork.png', '32', '32', '16', '32', 'knife_fork_s.png', '50', '30'); CREATE TABLE `phpbb_phoogle_markers` ( `marker_id` int(11) NOT NULL auto_increment, `marker_image` varchar(255) NOT NULL default '', `marker_width` varchar(5) NOT NULL default '15', `marker_height` varchar(5) NOT NULL default '15', `marker_x` varchar(5) NOT NULL default '7', `marker_y` varchar(5) NOT NULL default '15', `shadow_image` varchar(255) NOT NULL default '', `shadow_width` varchar(5) NOT NULL default '26', `shadow_height` varchar(5) NOT NULL default '15', PRIMARY KEY (`marker_id`) ) ; INSERT INTO `phpbb_phoogle_markers` VALUES (1, 'admin.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (2, 'moderator.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (3, 'wink.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (4, 'eek.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (5, 'evil.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (6, 'twisted.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (7, 'surprised.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (8, 'geek.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (9, 'ubergeek.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (10, 'razz.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (11, 'smiley.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_phoogle_markers` VALUES (12, 'cool.png', '15', '23', '7', '23', 'phoogle_shadow.png', '35', '23'); INSERT INTO `phpbb_styles_imageset_data` VALUES ('', 'icon_contact_phoogle', 'icon_contact_phoogle.gif', '', '20', '20', '1'); failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; ALTER TABLE `phpbb_users` ADD `user_phoogle_comment` mediumtext NOT NULL; ALTE' at line 1
I would really appreciate some help. Also, when I go to log into my ACP it's just a blank page. If creating the tables in my DB doesn't fix it, does anyone know what may be causing this?
baudday
Registered User
Posts: 6
Joined: Sun Oct 26, 2008 9:46 pm

Re: [BETA] Phoogle (Google) Map

Post by baudday »

I was able to figure out the SQL, but i'm still getting a blank page where my ACP is supposed to be.
baudday
Registered User
Posts: 6
Joined: Sun Oct 26, 2008 9:46 pm

Re: [BETA] Phoogle (Google) Map

Post by baudday »

Well I was also able to figure out the ACP problem. I have it now to where people can set their locations in their profile and everything. One problem I am having though is when I navigate to mydomain.com/phoogle.php I get the error "No Mode Specified" I see someone else asked this question too, but there's no answer for it. Anyone know what's wrong? I'm using phpBB 3.0.2
baudday
Registered User
Posts: 6
Joined: Sun Oct 26, 2008 9:46 pm

Re: [BETA] Phoogle (Google) Map

Post by baudday »

bump
baudday
Registered User
Posts: 6
Joined: Sun Oct 26, 2008 9:46 pm

Re: [BETA] Phoogle (Google) Map

Post by baudday »

Code: Select all

INSERT INTO `phpbb_styles_imageset_data` VALUES ('', 'icon_contact_phoogle', 'icon_contact_phoogle.gif', '', '20', '20', '1');
That's the last line install.xml tells me to execute. When I try to execute that, I get this error.

Code: Select all

Incorrect integer value: " for column 'image_id' at row 1
baudday
Registered User
Posts: 6
Joined: Sun Oct 26, 2008 9:46 pm

Re: [BETA] Phoogle (Google) Map

Post by baudday »

I figured it all out...
User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: [BETA] Phoogle (Google) Map

Post by muggins »

This was complex enough that I installed a test board to apply it, but after fooling around with file permissions and all, it works.

:D And I think it is the greatest thing since sliced bread! Bassface, you Rock!
Muggins
Holger
Registered User
Posts: 1883
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [BETA] Phoogle (Google) Map

Post by Holger »

I have a problem with this mod.
I installed Phoogle for phpBB2 1.0.5.
First it all worked very nice.
Now nearly 70 members are added to the map.
But not all are shown. Sometimes they even do not see themselves.
In IE I also get two errors:
Image
Image

Any idea about what can cause this?

/Holger
Post Reply

Return to “[2.0.x] MODs in Development”