I've had a bit of a nightmare....For some reason I cannot use my shell acount at the moment..I've contacted my host (who do provide it!) but I'm still awaiting a response...I have used it extensively before this.Although I know Pear is installed I cannot setup the other modules yet..Because I'm impatient and also exited about this working I tried installing Pear into the root (You can do this with ImageMagick and various other mods sometimes)...I used this installer http://www.phpkitchen.com/article.ph...21201062516970...Just out of interest and as you must know more about this than me. Do you think that this is possible or should I just hold on?? - There is a built in installer for all of the extra mods

The problem will be PHP. You have to enter the PEAR path into your php.ini file. If you install it into your root folder i do not know if the php files will find the Geo folder. I never tried it before.

I am sorry but i have only root server and due to this i do not have restrictions like that. Otherwise i would have tested it. But if you want to go for it, then try it. Give it a shot. Then we know for other people if it works or not.

I know from other people that they are using PEAR in their root folder and it works for them. So the only question that remains would be: "Will the Geo folder be recognized ?". Let's see what you will tell us. Good luck.

Cheers,

Hi @LL,

i am very sorry but i just discovered a serious bug in the performance enhancements. Under certain circumstances it does not update the new files accordingly. So please add the following changes to your files:

locator.php:

Find:
Just below add:
Then find:
Just below add:
Now delete the following files on your server: ./data/users.dat and ./data/numbers.dat. The first view of the page should run all queries but the reload of the page should have just 5 or 6 queries.

Sorry for the inconvenience. Now your locator page should be cached until the number of ZIP codes will change. I will implement this into the next update of the ZIP file.

P.S.: This is also not implemented in the UK version of th?s hack. So please add these changes to the UK version of this hack as well.

Cheers,

UK ? Any feedback so far ?

Cheers,

I'm still having a nightmare...My host agreed to install the 4 extra mods.The first 2 installed ok but the XML_SVG wouldn't...I have managed to install Pear into my Public_HTML root sucessfully and have installed the 4 mods but as you stated there is still a problem finding GEO...I did some research and evidently if the following is added to the top of every Pear dependant page it should work.

My question is "Is this correct and what files need this adding to?" The site I got this information from is here http://builder.com.com/5100-6371-5163311.html

This is the error I receive after adding the above to locator.php

Warning: main(Geo/Geo.php): failed to open stream: No such file or directory in /home/clubnu00/public_html/forums/locator.php on line 32

Fatal error: main(): Failed opening required 'Geo/Geo.php' (include_path='home/clubnu00/public_html/pear/PEAR/PATH_SEPERATOR.:/usr/lib/php:/usr/local/lib/php') in /home/clubnu00/public_html/forums/locator.php on line 32

Hello Dave,

there is an easier way to get this running. Let me guess: You can the error message "no stable version/release found" for XML_SVG ? This is correct because they have a problem with the installer. They are working on this issue. As a workaround you have to do the following:

Instead of typing "pear install XML_SVG" you have to download the latest stable version as a tar.gz file from the PEAR website and the install it with "pear install XML_SVG_versionXXXX.tar.gz".

And of course you can not install IMAGE_GIS because this depends on XML_SVG. So if the one of the 3 packages fail you will not be able to install IMAGE_GIS.

Tell this to your provider and he should be able to install all 4 modules and copy the Geo directory into the PEAR directory as well.

Cheers,

has anyone did the U.S map yet

Hi Johnny,

NO. No one approached me yet to give me the US data. I am still waiting for input. As long as i do not have any input, i can not create anything. Sorry.

Cheers,

Pseudomizer - What about this link?: http://forums.devshed.com/showthread.php?t=157248

It's free Zip code database and it's in MySQL. Hope it has the data you need. :D

<a href="http://forums.devshed.com/t60834/s.html&highlight=zip+codes" target="_blank">http://forums.devshed.com/t60834/s.h...ight=zip+codes</a>

Hi 58sniper,

i also found this page during my google search but question:

Did you try to download at least one of these files ? You would not believe it, but NONE of them work. Thanks so far but this link does not help.

I am currently investigating the first link from Oly51. Let's hope i can use this data.

Cheers,

I do have a MySQL database with 40,000+ zips in it if you need it....

Hi 58sniper,

what i need is a SQL file/source file like:

City, x-location, y-location, ZIP codes

Example:

'San Francisco', '37.65863', '122.30839','94005 94014 94044 94066 94080'

If you can provide this for US for all ZIP codes, then yes. Otherwise no.

Cheers,

Hi oly51,

i just checked out this data. This data is correct and includes the correct GEO locations ... BUT ... i am missing one important part in this database: the City names. This DB is useless for me without the city names like

94005 San Francisco x y

What they have is:

CA94005 x y

I do not know how i can get the city names into this db with all these zip codes. But this is the best source so far. With the city names this would be perfect and i could start working on the US version of this hack. But without ... no.

Cheers,

42741 zip codes here. This is the best I could do.
It's in the format:

99950 +55.542007 -131.432682 Ketchikan AK Ketchikan Gateway Standard

Which is zip, lat, lon, city, state, county, class

The only thing that this is missing (that I've determined) is the aliases. Some zips (mine included) are actually used in more than one city. Only the primary city is listed.

Hi 58sniper,

just for my understanding: What do you mean with aliases are missing ? The format i need is, that one city can have multiple ZIP codes or suburbs. In this case i have to choose one name for the city and add all the ZIP codes to this city. This is what i need. Is this what you mean ?

And another question: You can provide 42741 ZIP codes. How many are there in total ? Any idea ? So how many are you missing ?

Cheers,

As far as I know, that includes all of the zip codes in the US. Some will say that there are more than 70,000, but that's not entirely true.

In my case:
48315 is my zip code. But that zip code is used in Utica, and in Shelby Twp (where I live).

If I look up my zip code, it's in the database, but only listed as Utica. Some databases would list it twice, once with each city name. Mine lists them once with the primary city. No duplicates.

Ok. Let me check what i can do here. I will come back to you if i can use this file. Thanks so far.

Cheers,

Here's a MySQL dump of a Zip code dB

Ui. This looks good. I will install this into a db and i have run a couple of queries to make it distinct but this looks like the best source so far. Let me check now.

Now i have 2 sources where i can check. I hope one of them will work.

Thanks so far and now please be patient. In the meantime i need volunteers to install this hack on their servers and obviously this volunteers should be located in US. Who wants to be the BETA tester ?

Please make sure that you get the prerequisites running before i give you the data.

Cheers,

I've got three installations I can install it on...

Hi 58sniper,

then please install it on at least one. Please try to it to have it ready until i have resorted the data you have given me. Perhaps you run into some problems which we can solve until then.

Cheers,

I'll give it a shot!

...Well maybe not.
My host will not install the Geo folder to the pear folder. :disappointed:

Why ? This is no security issue. *strange*

Cheers,

The US maps are not as freely aviable as you think, more than 90% of all mareicans only care about money so it's hard. If you want I can get The microsoft map thingy if you know how to get the data out.

I think I hit Jackpot!
http://www.census.gov/tiger/tms/gazetteer/zips.txt

good ol goverment sites, they just like telling us everything on their...nice find, maybe that should help out...

Let me check this. I am a little bit confused because some map details have e.g. San Francisco with -122 and others have +122 for the coordinate. I am not a GEO expert. I have to check this.

At the moment with the current map information i have, it puts San Francisco into the center of Iowa. *weird*

Cheers,

clicks install

Im anxious for this release in the US. Is there any word on the US release?
Thanks!
~Torben
www.desmonorthwest.com

that looks great! I'll wait eagerly for a US version :D

Hi,

i have massive problems with the US map details. The geographical locations are not set where they should be set. I am trying to figure out why. I am still working on this but please be patient.

Cheers,

hmmm maybe your file is bad ....redownload .......


i downloaded the file and -122 does not exist in the file .

Nice hack, but this one seems to be much more powerful (but for phpBB :()
http://217.160.138.71/development/ph...wforum.php?f=5

I'd really love to see these features (eg. hightlight, zoom, distances, next members, etc.) in your hack :)

Hello @LL,

first of all i want to comment on the last info and then i will give a general update about this hack.

@KirbyDE: I know this hack already and this hack is only for phpBB and i tried to convert it to vb and i failed. It is much more then just an adjustment. It is fully integrated into phpBB. In addition i do not think that it is much more powerful. The official version does not have the features you are mentioning. Only the development link you just posted have these features and it is not finished yet. It still has bugs in it. Regardless of this i want to add this for all people here.

@ALL: I just installed this hack on a board with over 10000 users and my hack failed miserably. The performance was reduced due to my SQL loads and the complete server stopped for about 1 minute every SQL request. This is UNACCEPTABLE. I had to remove the hack immediately.

As it looks like this hack works fine for small communities but not for large boards.

2 options now:

1) discontinue the hack completly
2) start from scratch with a complete new system/concept

The OpenGeoDB is not optimized for so many SQL queries. It is for finding one specific location + nearest locations and nothing else.

Sorry for that but i do either create an overall good working hack or none but nothing between.

Cheers,

Hmm ... bad.
Seems lik I have to port the phpBB mod myself then.
Gonna let you know if it works out (my board has approx. 18.000 members).

Hi @LL,

i just found a modification of the GEO DB class which is much more efficient. I would have to test this version and then come back to you. Give me time and i think i will be able to bring out something. Remember: This is still BETA.

Cheers,

hey guys, I don't know how you are doing this hack, but I have one similiar for my site. go to www.ultimatenurse.com and click on "user map" and see it.

It doesn't use zip codes or anything. A user simply places a "pin" in the place they are located. Would this improve the way this works?

This would be an easy way of implementing a PIN solution which would not check if the location is right. The ZIP code would be a way to check if the ZIP code exists. But this depends on the requirement. So if a user is looking for a solution like yours ... GO FOR IT. Every solution is welcome which enhances the vbulletin.

Cheers,