vB Weather: Give your members current weather and forecasts!

After seeing a weather feature at the vbPortal website, and finding out that I couldn't get it for free, I determined to create it for myself, and give it away to everyone for FREE.

So here it is. It's based in part upon the original MyWeather add-on module for PHP-Nuke, which as I understand was also the basis for the add-on module for vbPortal. Anyway, I basically used the part of the PHP-Nuke module that gets the raw data and parses it into a usable format, although I reworked it some and corrected a few bugs. I wrote on my own the rest of the code which handles and displays the data, along with letting the user select his/her location (to localize the weather), number formats (like ?F or C, winds in mph or kmph, etc.), and various other little bits.

I've done as much testing on it as I can on my own, and have had it running on my own production forums for about a day now. Several people have commented that they really love the feature, that it's almost getting to the point where they don't have to go anywhere else on the Internet. I haven't heard of any complaints or problems yet, though, so I'm reasonably certain it's fit for a full release.

You can demo the hack on my message board: JJR512.com. The first part you should look at is the box that appears in the column of boxes on the left side of the home page. This box displays basic current weather info. There are two links in that box, one to see the forecast, and the other to change settings. I forget if you need to be logged in to see the forecast--it may just show you a forecast for the default location, which is Central Park, New York City, NY, USA--but you definitely need to be logged in to change settings. For the purpose of seeing this hack in action, you can login as Test User using the password testuser. Feel free to change the settings and save them, do whatever.

Installing this hack is in some ways easy, in other ways not so easy. There will only be one file modification. However, there are no specific instructions as to which file to edit or how to edit it. If you want the small weather box to show up on your forums home page, you need to edit the associated file (index.php). If you want it to show up somewhere else, then you need to edit whatever file generates the page where you want it. There is a text file in the ZIP that contains all the code, and only the code, that you need to insert into whatever file. If you prefer, you can turn that text file into a .php file (by adding <?php at the beginning and ?> at the end and renaming it to .php) and simply including it in whatever file you need it in.

You will also most likely need to edit the template that makes the weather box. It's formatted to basically make a box as it appears on my site, which is in the middle of some other boxes in a column. If you want to reformat it to appear as a long thing across the top of the page, like the various stuff at the top of the forums home page here at vbulletin.org, that's up to you. You edit the templates to match your own site.

BTW, I would appreciate it if someone better at PHP coding than myself would take a look over this and tell me if I've done everything right or not. I believe the code works and does what I want it to do, but it seems like it might be a little more complex than it needs to or should be. I guess I'm just wondering if there may have been a more efficient way to do some of the things I did. If you have any tips or advice for me, or even want to rewrite the code to show me, I'd really appreciate it.

OK, so without further ado, here's the hack in the attachment. Whatever problems you have, please post them here, and I'll try to help as best I can, but make no guarantees that I can help at all. Please remember that I write my hacks for my own site first and foremost, so they do what I need them to do, not what I think somebody else might want. I choose to release them here in case anybody else can benefit from them, but you may need some part of it to work slightly differently. If I know how to do it I will try to tell you how to do it, but I won't update the hack with every little feature variation that people ask for. In general, I only update my hacks to fix bugs and to add new features that I want or need for my site.

// Change Log]
03b: Includes necessary database change instructions.
03a: Forgot to update 03 ZIP with new templates; fixed.
03: Changed code for new icon system, added code for forecasted weather type (new part of raw data)
02: Adjusted code for new format of weather forecast raw data
01b: Fixed two missing lines from weather_include.txt
01a: Added missing template; updated instructions regarding missing template; fixed $templatesused variable in weather.php; added text file explaining how to add more cities; updated instructions regarding where to get the icons used for this hack
01: Original release

[Kars10]

When youre done, will you release the querys here??
And how can i import the new settings in my Database? Delete the older tables and import the new??
Please JJR, tell me how to add the new codes in the DB...

@ ScottCT1, i think he deserves more than one beer!!

[JJR512]

Don't worry, I'm not doing this just for me!

The old weather_ tables (city, subdiv, country, region) will have to be deleted. There are some structural and data-type changes involved. When the time comes, full instructions will be provided.

[JJR512]

MSNBC seems to be having some trouble with the weather right now. I'm trying to see the cities in some African countries but it's not displaying them. It's doing this for several regions, but not always the same.

[DrkFusion]

*Deleted

[DrkFusion]

I am having probs isntalling this on 2.2.6

Unknown column 'forecasticon1' in 'field list'

[JJR512]

Well, I'm done compiling the database...I think...and it has 37,341 cities!

[Boofo]

When you release this, can you include instructions on deleting the old tables and adding the new without phpmyadmin? I do not have access to that right now, and may not for a while, because of the server my board is on.

[Kars10]

@ Boofo, why you didn?t install phpmyadmin??
Its very very easy, and you can do such a lot things more ...

[Boofo]

I had this installed on the server, but the guy that I've got my site with just did a major rebuild of the server and hasn't has it put on yet. We are supposed to have this, but I don't know how soon. The reason I asked for that was because there are a lot of people out there that either don't have phpmyadmin, or wouldn't know what to do with it if they had it.

Originally posted by Minifreunde
@ Boofo, why you didn?t install phpmyadmin??
Its very very easy, and you can do such a lot things more ...

[scottct1]

Very cool JJR! Hopefully you tell us how to update the databases to include the new cities and remove the dead wood ones.

I thank you for all the work you put into this!

I expect that this will be the last time for a long time you will have to change all this info, I don't think MSNBC will be changing weather providers again anytime soon.

I wonder if the weather channel will provide any visability readings soon? (Still says 0 and MSNBC say's N/A)

Anyways great job!