Page 51 of 51

Re: [BETA] Phoogle (Google) Map

Posted: Wed Oct 01, 2008 11:40 am
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?

Re: [BETA] Phoogle (Google) Map

Posted: Sun Oct 26, 2008 9:49 pm
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?

Re: [BETA] Phoogle (Google) Map

Posted: Mon Oct 27, 2008 12:20 am
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.

Re: [BETA] Phoogle (Google) Map

Posted: Mon Oct 27, 2008 3:01 am
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

Re: [BETA] Phoogle (Google) Map

Posted: Mon Oct 27, 2008 1:57 pm
by baudday
bump

Re: [BETA] Phoogle (Google) Map

Posted: Mon Oct 27, 2008 2:20 pm
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

Re: [BETA] Phoogle (Google) Map

Posted: Mon Oct 27, 2008 2:50 pm
by baudday
I figured it all out...

Re: [BETA] Phoogle (Google) Map

Posted: Sat Dec 27, 2008 8:26 pm
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!

Re: [BETA] Phoogle (Google) Map

Posted: Wed Jan 21, 2009 7:51 am
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