+ Reply to Thread (include dating software, release, and patch number!)
Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 28

Thread: Install UK postcodes

  1. #11

    Join Date
    Nov 2005
    Posts
    1

    Default German Zip Codes

    Quote Originally Posted by tester00
    Well, I found this website has most of the countries' postal code with long/Lat. But, they charge big BUCKS

    http://www.grcdi.nl/gfkmacon.htm

    I wish I can get some european countries' zipcodes...I got many members from EU.

    I also have Germany's zipcode with long/lat, but DB isn't compatible with Aedating...and column names are in german. So, we need someone's help to translate it.
    Hi I will help trans late it if you still need help

  2. #12

    Join Date
    Oct 2005
    Posts
    226

    Default

    Quote Originally Posted by ijk
    yes i had the jibble codes but did not have them in a install file ie insert etc but was surprised when aedating offered the jibble codes as a install file. great stuff.
    Are you able to share this install file?
    Regards
    Greg

    ----------------------------------------
    www . adult only dating . com

    Any help supplied is tested and working on version aeDating 4.02 CLEAN 4

    ----------------------------------------
    ** For Sale **
    www. the date exchange . com (Whitelabel)
    www. the adult exchange . com (Whitelabel)
    See http://www.modmysite.com/showthread.php?t=1841 for more details

  3. #13

    Join Date
    Oct 2005
    Posts
    226

    Default

    Don't mean to drag this one back up, but i think it's important to a lot of sites.

    After a lot of trawling i managed to find the Postcode.zip file and have attached it here.

    I'm just about to start the task of getting it into mysql and i'll export the script when I have it.

    Cheers
    Greg

    Edit: Found the German codes on my travels as well. Already in a SQL script, but needs modifing
    Attached Files
    Last edited by Greggers; 01-05-2006 at 06:47 AM.
    Regards
    Greg

    ----------------------------------------
    www . adult only dating . com

    Any help supplied is tested and working on version aeDating 4.02 CLEAN 4

    ----------------------------------------
    ** For Sale **
    www. the date exchange . com (Whitelabel)
    www. the adult exchange . com (Whitelabel)
    See http://www.modmysite.com/showthread.php?t=1841 for more details

  4. #14

    Join Date
    Oct 2005
    Posts
    226

    Default

    I now have the official uk postcode sql file from aeweb. it's a 20mb zip file that extracts to 2 125mb sql files containing 1.9 million postcodes.

    Couple of changes:

    1) You need to make to the DB is to increase the field size of ZIPCodes.Zipcode from 5 to 10.

    2) comment out the following lines from search_results.php
    Code:
    if ( ((int)$zip) == 0 ) 
    $z_arr = db_arr("SELECT `Latitude`, `Longitude` FROM `ZIPCodes` WHERE `City` = '$zip'"); 
    else
    If anyone wants it, let me know.
    Last edited by Greggers; 01-29-2006 at 04:17 PM.
    Regards
    Greg

    ----------------------------------------
    www . adult only dating . com

    Any help supplied is tested and working on version aeDating 4.02 CLEAN 4

    ----------------------------------------
    ** For Sale **
    www. the date exchange . com (Whitelabel)
    www. the adult exchange . com (Whitelabel)
    See http://www.modmysite.com/showthread.php?t=1841 for more details

  5. #15
    ijk
    ijk is offline

    Join Date
    Apr 2005
    Posts
    340

    Smile great

    I do.
    thanks
    AE Version 4.0 IQ

  6. #16

    Join Date
    Oct 2005
    Posts
    226

    Default

    PM'd you.

    Regards
    Greg

    ----------------------------------------
    www . adult only dating . com

    Any help supplied is tested and working on version aeDating 4.02 CLEAN 4

    ----------------------------------------
    ** For Sale **
    www. the date exchange . com (Whitelabel)
    www. the adult exchange . com (Whitelabel)
    See http://www.modmysite.com/showthread.php?t=1841 for more details

  7. #17
    goldstate
    Guest

    Default

    I would love a copy as well.

    Regards,

  8. #18
    strategist
    Guest

    Default

    I would like a copy as well.
    Thanks,
    Alex

  9. #19
    lips_sewn_shut
    Guest

    Talking

    Would it be possible to have a copy also please...
    -Thankx

  10. #20

    Join Date
    Oct 2005
    Posts
    226
    Regards
    Greg

    ----------------------------------------
    www . adult only dating . com

    Any help supplied is tested and working on version aeDating 4.02 CLEAN 4

    ----------------------------------------
    ** For Sale **
    www. the date exchange . com (Whitelabel)
    www. the adult exchange . com (Whitelabel)
    See http://www.modmysite.com/showthread.php?t=1841 for more details

+ Reply to Thread (include dating software, release, and patch number!)
Page 2 of 3 FirstFirst 1 2 3 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. RMS 3.0 Install
    By q9a2 in forum Ray Community Widget Suite
    Replies: 3
    Last Post: 09-18-2007, 10:33 PM
  2. Postcodes
    By hector in forum General Issues, Comments, Questions
    Replies: 8
    Last Post: 01-17-2007, 07:24 PM
  3. How to install sox??
    By lyongo in forum General Issues, Comments, Questions
    Replies: 1
    Last Post: 10-11-2006, 09:46 PM
  4. Fixed UK postcodes
    By Smithp0 in forum General Troubleshooting
    Replies: 2
    Last Post: 10-10-2006, 04:50 PM
  5. postcodes csv format for every country here
    By stevie in forum General Issues, Comments, Questions
    Replies: 9
    Last Post: 02-01-2006, 02:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts