10 Free mods

[inspireme]

Hi guys, all content on http://www.indexu.co.uk is free now, with the following
condition. Link back to http://www.places2b.co.uk required somewhere on the site if you use any of the mods. Link must be spiderable and pass pagerank.

Members on the site do not have this condition.
Members on the site will have full access to the soon to be released themes, however a limitation of one use on the template will be applied to non paying members.

One last thing, no support is given to non paying members AT ALL so bring it to these forums and maybe youll get lucky and i will help out :0)

SOme future mods will not be free. (ones im currently working on) and articles on geolocation will not be free.

[dePaulus]

Thanks inspireme...

Excellent site, love the logo.. I'll be browsing around as soon as the boss has parked his arse somewhere else.

de P

[echo@]

Hi inspireme

I was wondering when your geo location mods where going up

Ill keep my eyes peeled, also i purchaced a pdf from easypeasy on uk postcode geo location, but it goes way over my head, its yours if you want.

(ide rather it not go to waste)

I also read about free uk map / images avalible at ordnance survey website.

anyway heres the link that marries up with the pdf

http://www.easypeasy.com/guides/article.php?article=64

It might help or on the other hand it might not.

[inspireme]

soon I keep thinking i have time to do this and something fills it. im sorry, I promise its coming soon!

I have some extremely awesome stuff i want to add into into the articles, including a script that will automatically geocode your whole database from a postcode or address.... search by clicking on a map, distance from location and some super cool ajax maps. Its all new code and i have it now working on my site. You can try it out,

http://www.bigfreeguide.com/camping/...park/2049.html

click "add starting location" you will then get the distance from you to the listing, it also demonstrates map and ajax postcode searching. I have the code working well now, so all thats left is to write the article.

These articles will be thorough, and will never be free. Mainly because it took a hell of a lot of headache for me to work this out (if you have read the article from easypeasey you know this stuff is actually very complicated) I will be providing some free databases to do all the calculations from as well.

So im going to put a deadline on this, first articles will be done by the 20th, and all of them finished by the end of the month. Just so i know, what are you planning on doing with this? googlemaps? basically the articles will cover whats on mys ite (the link above) and some of the bits i added to http://www.places2b.co.uk/ I wont cover making your own maps just concentrate on the google ones.

[echo@]

I was hoping to integrate this mod more for searching, (straight of the landing page) and giving a distance in miles in the rows.html just displaying the text, im not really interested in the map for the directory im working on at the moment.

heres an idea of how i would like the search to work with this mod

[inspireme]

okay. you will need the postcode database from
http://www.npemap.org.uk/

I have made some scripts last week to fail gracefully when it cant find a postcode, basically if the postcode doesnt exist (which it wont, seeing as it only has 35,000 in that free database) it slowly degrades the user input until it finds a hit. Its not amazingly accurate but it will usually get it within 5miles. Would that be accurate enough? Its good for general searches.

[inspireme]

Geocoding article 1 online. the article covers getting all your listings quickly geocoded, tutorial 2 will use this and make a block to show "distance" from other listings.

[griller111]

hmmm I get this when i try and run it

Address failed to geocoded. Received status 601 Invalid query: 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 'LIMIT 1' at line 1

[inspireme]

what field are you using?, make sure the custom field name is typed correctly...

Also, i didnt mention it in the tutorial (will change it later) but you need to create your own KEY using google maps, its locked into your domain name so unless your using the exact key given for the exact site your using this will fail. Its also at the top of the file, a section that says :

define("KEY", "ABQIAAAAomF59xyo6Ec1MqZiNaN-HRSFeoNC1GdvuthYgCW3mLdEBQECvxT23shsqRRW1SKsda6oK9 SPd7wqpQ");

make sure its correct, if your still having problems post here and i will check through to see why its happening.

[inspireme]

i have tutorial 2 written, if someone doesn't mind testing it - i have it working on my site every time i do this, but it doesn't always necessarily mean it works for other circumstances, or i miss mentioning something major (like the problem above) I will post it end of the week but if you dont mind having a try with it before hand (and your a member) email egginton(at)gmail(dot)com

[echo@]

Hi inspireme , ive given this a go, I have created the script and added my google maps api keyy, database name/username/password acordingly.

I called the script geocode.php and uploaded to my webserver, then ran the file.

i get the following error

Invalid query: 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 'LIMIT 1' at line 1

also i take it were going to do geocoding remotley (with google) instead of locally geocoding, i.e populating custom fields lat lon??

Do we need to download the file

okay. you will need the postcode database from
http://www.npemap.org.uk/

???

thanks

[echo@]

Hi inspireme , ive given this a go, I have created the script and added my google maps api keyy, database name/username/password acordingly.

I called the script geocode.php and uploaded to my webserver, then ran the file.

i get the following error

Invalid query: 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 'LIMIT 1' at line 1

also i take it were going to do geocoding remotley (with google) instead of locally geocoding, i.e populating custom fields lat lon??

Do we need to download the file

okay. you will need the postcode database from
http://www.npemap.org.uk/

???

thanks

[inspireme]

Opps, when im trying this im using my temp table, i thought i had corrected everything to work with the usual table but i made a typo. it should work now, i updated code on my site. If your still having problems please email me ftp details and i will see why its happening. You will need the postcode database later for doing postcode lookups, although i suppose i could use the geocoding from google for that also... hmmm... I will see which one works best (accuracy wise) and come to a decision.

Hi inspireme , ive given this a go, I have created the script and added my google maps api keyy, database name/username/password acordingly.

I called the script geocode.php and uploaded to my webserver, then ran the file.

i get the following error



also i take it were going to do geocoding remotley (with google) instead of locally geocoding, i.e populating custom fields lat lon??

Do we need to download the file

???

thanks

[echo@]

looks like it was a typo, the script now runs , but im now reciving a

Address failed to geocoded. Received status 601

sorry to be the bearer of bad news

After reading the article about this MOD on your site i find it does not explain the purpose of this script clearly enough(i just follow its instuctions)

My understanding is this script populates the custom field lon / lat from google , once this is done indexu can reference these fields locally??
(I would rather geocode locally)

Im sure you appreciatie the feedback all critisum is good critisium


thanks

[inspireme]

"address failed to geocode" is just a feedback for one of the addresses/postcodes you sent not being found (either an incorrect or missing postcode for one of the listings) Please check your listings most of them will now contain the lat/lon information.

I realise i havent explained the purpose much, the tutorials will move on from each other so i will explain futher. You are correct, the information is stored locally, this is because we use a radius search which checks every single one of your listings to see if it falls within a give mile radius, it would be impossible to lookup 1,000 or so lat/lon positions from google with every search so we need them stored in the database.

Can you check some of your listings from the edit screen in admin to check that the lat and lon fields are now populated?