vB Weather Mk. 2

This is a post of a much-revised hack originally posted (by myself) here. I am posting this as a new hack because MSNBC, who the raw weather data is provided through, has changed their source provider (from AccuWeather to The Weather Channel), which required a retooling of the data parsing code, as well as completely new databases. I have also made obsolete the weather_functions.php file, moving the functions to admin/functions.php, simplifying the ability to show current weather data on any page (if desired). Finally, in what I'm sure will be welcome news to many people who have installed the original, I've completely rewritten the instructions, making them, as far as I can tell, much simpler.

If you are unfamiliar with the original: This hack provides current weather conditions and a five-day forecast to your members. Each member can select from over 34,000 cities, by narrowing down from region (like continents), country, and subdivision (like states). Each member can also select to see temperatures in Fahrenheit or Celsius, as well as metric or standard measurements for the other data.

A demo is available on my test board: http://www.jjr512.com/testboard/. I have set up an account for anyone to use to test it out (username: test; pw: test). If you are not logged in, you will see default weather on the home page (default is set to New York City), and cannot change settings (I forget if you can view a detailed forecast, though; you may be able to). If you do log in, you can change the settings for the test account, to see how it works.

***
If you have installed any previous version, you should completely uninstall it. Read the instructions and work backwards from there: Delete all templates added, remove changes to any existing templates (I forget if there were any or not), delete all new tables from the database, delete all new files added by the old hack. All have been changed to some extent, some more than others, and it would be easier to work from a clean slate. Especially since some of the template names have changes, so if you don't delete the old ones, they'll just be sitting there doing nothing at all. It is also vitally important to delete (or "drop") the tables--I believe there were six--you added for the original version. The new ones have different data and, for some, a different structure, so do not just empty them. Remove them totally.

Good luck!

Change Log
v1.1a: Current Version: Corrects a small error where an incorrect variable was used in the code to show the local time of the last update. If you already have v1.1, you only need to do the fix described in Post #82 below.
v1.1: Changes display of last update time to be the correct time in the user's own local time zone; previously, it was always Eastern Time (GMT-5) (Upgrade instructions are in Post #79 below). Also breaks the weather_city.sql into six smaller pieces (useful only to new installations; existing installations need not worry about this).
v1.0a: Adds instructions on how to add location to current weather on forums home page (changes to code added to index.php and forumhome_weather template).
v1.0: Original Release

[o0stephane0o]

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

[scottct1]

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!

[lemarsu]

Today at 02:30 PM scottct1 said this in Post #332
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

[o0stephane0o]

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.

[lemarsu]

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

[o0stephane0o]

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:

[Etcher]

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.

[lemarsu]

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

[lemarsu]

Today at 01:34 AM Etcher said this in Post #337
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.

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]

DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'CAXX%'

[o0stephane0o]

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.

[Etcher]

Awsome, thank you...
That is a HUGE DB, that must have taken weeks to make, and less than 2 seconds to delete.... and that worked, and took 900,000+ out of the DB

Fantastic job though, great hack...

Yesterday at 08:55 PM lemarsu said this in Post #339
[B]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

DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'CAXX%'

[PennylessZ28]

04-04-03 at 09:55 PM lemarsu said this in Post #339
[B]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

DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'CAXX%'

What about everything but America, who cares about Canada!

[drumsy]

How would I add the type "Heavy Rain" to the board? It's coming up as Unknown Type on the board but I see it as Heavy Rain on MSNBC.

BTW, Installed, love it! Great fix by the other gentleman!

[lemarsu]

Today at 04:58 PM HR3rdGen said this in Post #342
What about everything but America, who cares about Canada!

like So :

DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'US%'

[drumsy]

Ok, now all of a sudden the "H O N D A - A C U R A . N E T Weather is provided by The Weather Channel and MSNBC " table is blacked out. It was fine before. I've changed nothing! What could have done this?