Wow, you are amazing, I?ll try it right now, Thanks a llot ;)

I don't know why but a lot of users are requesting I make the Iraqi weather available, anyone know if this is possible?

My forecast for Iraq is a good chance of bombing tonight, more of the same tommorow. :) Go USA!

Scott,

The weather for Iraq, should be working, just check you have codes
IZXX0001
IZXX0002
IZXX0003
to
IZXX0012

In your `weather_city`table. They are in my forum.

LeMarsu.


PS: I have lived through a war and I would like to inform you that spending the night wondering if a missile is going to hit your house and kill you and you family or bury you all alive is not something you wish to happen to other people, I hope it doesn?t ever happen to you.
End of this conversation please

I m loking for bugs and i have found a new one.
Australia dosenst work either but this time, it looks different.
I think the cities haven´t been created.

The problem is that you need to pick a Country to force the refresh....
so pick New Zealand, the go back to Australia.... and.... et Voila !

It works..

LeMarsu

Great work though i have a small error with the spanish stuff.
when executing the sql queries, i get an error message about the following INSERT INTO weather_city VALUES ('SPXX0049', 'L´Hospitalet de Llobregat', 211); but changing it to INSERT INTO weather_city VALUES ('SPXX0049', 'L Hospitalet de Llobregat', 211); it works.
But after that, i get some strange errors. Did you try it? Did it work ?
By the way lemarsu, are you french or belgian?
Thanks for your time..
:banana:

is there an easy way to remove the country, cities, and such that will not be used? I am from Canada, and my members are ONLY from Canada, therefor the others will never be used... With them all in there, it is taking a huge amound of database space.

Stephane,

I have edited the sql attachment for Spain... Sorry I was at work and I didn't fully test it out I only ran the first 5 towns.... What a bad tester !!!

I am actually Lebanese (hence the little comment for scottct1), but I had a French education....

LeMarsu

Etcher,

To delete everything that is not Canada I suggest you do the following:
As the biggest table is weather_city, just concentrate on that one. You will need to run the delete statement bellow that will get rid of 36721 rows, NOTE THIS WILL GET RID OF EVERY CITY IN THE WORLD APPART FROM CANADA the countries will still be there if you need them in the future.

[b]ps I have not tested the SQL[b]

French education, now I understand where you got your nick from...
I am insisting again about the weather hack but it?s only because I really like it and i cannot make it working fine :(

What do i have to do with spain.sql to make it working?
And what is the following error:
[socketerror] cannot connect to www.msnbc.com.... blblabla 80
Un truc dans le genre...

Thanks for your knowledge.