[Version 1.1] Google User Map

Misc MOD Downloads for phpBB3 -- Any MOD that does not fit into any other category
Forum rules
Image Please feel free to download any MOD's here, support for each MOD is located it's own thread.

To post your own MOD, please first read the MOD Guidelines

Re: [Version 1.1] Google User Map

Postby Brandon7 » 25 Mar 2008, 11:19

I ran this SQL Query:

CREATE TABLE phpbb_geocode (
user_from varchar(100) collate utf8_bin NOT NULL default,
user_lat double NOT NULL default 0,
user_long double NOT NULL default 0,
code_expire int(11) unsigned NOT NULL default 0,
UNIQUE KEY user_from (user_from)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


MySQL said:

#1064 - 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 '
user_lat double NOT NULL default 0,
user_long double NOT NULL default 0,

Does anybody know how to fix this?


I tried to contact the Mod's Author, with no response.



Thanks,
Brandon
Brandon7    
Ensign
Ensign
 
Posts: 71
Joined: 21 Dec 2007, 11:32
Location: United States
Favorite Team: Seattle Seahawks
Gender: Male
phpBB Knowledge: 5


Re: [Version 1.1] Google User Map

Postby stitch626 » 30 Mar 2008, 20:23

Hi Brandon,
I don't know if you found a solution to this but I was messing with this mod, just testing it out and I ran into the same problem.

There seems to be a double quote missing on the 2nd line of code. Here is how it should be. Only took me a 1/2 hour this time to figure it out. I am getting better. The last time I tried debugging a SQL it took me 4 hours (not all in one sitting though) :grin:
Code: Select all
CREATE TABLE `phpbb_geocode` (
  `user_from` varchar(100) collate utf8_bin NOT NULL default '',
  `user_lat` double NOT NULL default '0',
  `user_long` double NOT NULL default '0',
  `code_expire` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
User avatar
stitch626    
STG Moderator Leader
STG Moderator Leader
 
Posts: 3185
Joined: 08 Feb 2007, 20:47
Location: Michigan
Favorite Team: Detroit Red Wings
Gender: Male
phpBB Knowledge: 7

Re: [Version 1.1] Google User Map

Postby cichlid » 07 Apr 2008, 05:05

is it possible instead of having locations that a user can enter a gps mark instead and mark this spot on the map

cheers
cichlid
Ensign
Ensign
 
Posts: 94
Joined: 25 Jul 2007, 01:54
Gender: Male

Re: [Version 1.1] Google User Map

Postby yaboymartell » 21 Aug 2008, 11:57

is there a new demo site link?
yaboymartell
Crewman
Crewman
 
Posts: 1
Joined: 21 Aug 2008, 11:48
Gender: Male
phpBB Knowledge: 4

Re: [Version 1.1] Google User Map

Postby doylefish » 29 Aug 2008, 07:32

Hey guys,

Does anyone have the install code for this?

The original links are no longer being hosted, and I cant see them anywhere.

Cheers

J
doylefish    
Crewman
Crewman
 
Posts: 1
Joined: 28 Jun 2008, 09:08
Gender: Male
phpBB Knowledge: 5

Re: [Version 1.1] Google User Map

Postby NMI » 31 Aug 2008, 20:32

Download link in original post is broken.
Image
Image
Image
Image
The price of freedom is eternal vigilance. - Thomas Jefferson
User avatar
NMI    
Supporter
Supporter
 
Posts: 110
Joined: 19 Oct 2007, 14:15
Location: Illinois
Favorite Team: Chicago Bears
Gender: Male
phpBB Knowledge: 5

Re: [Version 1.1] Google User Map

Postby scouthostinguk » 09 Feb 2009, 10:32

download link is not working again :banghead:
scouthostinguk    
Supporter
Supporter
 
Posts: 23
Joined: 01 Nov 2008, 15:13
Location: Hertfordshire
Favorite Team: Don't Have One
Gender: Male
phpBB Knowledge: 5

Re: [Version 1.1] Google User Map

Postby Boomi21 » 28 Apr 2010, 00:04

Thanks for share good info keep it up...........
Boomi21
Crewman
Crewman
 
Posts: 1
Joined: 27 Apr 2010, 23:59
Gender: Male

Previous

Return to Miscellaneous MODs, Hacks and Downloads

Who is online

Users browsing this forum: Tbot [Bot] and 6 guests