The Arcive of Official vBulletin Modifications Site.

vB Weather Mk. 2 · **Released**: 08-02-2002

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

Gohan · #**197** 09-13-2002, 11:07 PM

Quote:

Originally posted by NTLDR

Gohan, I strongly recomend that you either reduce the number of news posts & active threads and/or remove some of the addons to that page 71 for the sites home page is very, very, very high.

Hmm.. but my server get every day around 10 users visitor.
i think better remove a weather and calendar hack from vbindex.

Gohan · #**198** 09-13-2002, 11:44 PM

Quote:

quote:

Quote:

Originally posted by PsYc
Database error in vBulletin 2.2.7:

Invalid SQL: SELECT accid,city_title FROM weather_city WHERE subdivid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

$cities = $DB_site->query("SELECT accid,city_title FROM weather_city WHERE subdivid=$current_subdiv[subdivid] ORDER BY city_title");

i think this query seems to complicate it..

i have created all tables and made the changes, i run it 4 times deleted it and made a fresh install... everytime i got this error, can anyone help?

--------------------------------------------------------
edit: ok fixed my errors, works great

* PsYc clicks install

same as my problem.. what did you fix?

Hello, nobody know fixed??

Gohan · #**199** 09-16-2002, 08:00 PM

Quote:

Originally posted by Gohan
Hello, nobody know fixed??

ok then.. i'll remove this hack!!!

:tired: :dead:

PHiXTiT · #**200** 09-17-2002, 05:33 PM

Quote:

Originally posted by PHiXTiT
Great hack! (5)

Only 2 problems.

1) The time is 40 minutes in the future.

2) There are no subdivisions in Canada such as Alberta, Ontario, etc, but all the cities are listed. All others are working for me.

BTW: Just wondering if you are planning on adding the option for users to select different .gif files when modifying settings?

Running on 2.2.7

Anyone?

tako · #**201** 09-24-2002, 08:15 PM

Have they blocked the data again?? It is not working on my site today.....

PHiXTiT · #**202** 09-24-2002, 09:13 PM

Working here

Still wondering about the provinces in Canada for subdivisions as the are not showing up.

Help would be appreciated.

ThanX

sklwer · #**203** 10-10-2002, 01:02 AM

Hi there,
I am new to this PHP stuff and i am trying how to impliment the above hack.. I figured everything but I am unable to
"Create new tables in your database using the file create_tables.txt. You can copy the entire contents of the file and
paste into the query window in phpMyAdmin, or you could run each query individually through telnet. Please ask in at
vbulletin.org if you need help in this regard."

Help! Help! Help

lemarsu · #**204** 10-10-2002, 09:45 AM

copy and paste the query window in phpMyAdmin should be enough.

sklwer · #**205** 10-10-2002, 09:10 PM

I dont have a phpmyadmin

lemarsu · #**206** 10-11-2002, 08:48 AM

How do you access your database ? :surprised:

I am new to this, I only had phpmyadmin, or Linux to use to access the mysql databases.

(not to sound to dumb I am working on a data warehouse project at work with Oracle and DB2 and Unix.... So I know what I am going) just this is the first time I user vbulletin

sklwer · #**207** 10-13-2002, 03:55 AM

Finaly figured it out Got it installed sucessfully.
Two Minor problems
I modified the default city and when unregistared user is online the Default city is NY when registered user is online its the New Weather city any help????
How can i link the weather to a non php home site ( thats shtml)??
Thanks

K_2 · #**208** 10-14-2002, 07:11 AM

Anyone try this hack on 2.2.8 yet?? Would love to add it to my forums

Thanks In advance!

lemarsu · #**209** 10-14-2002, 07:40 AM

I have it up and running with 2.2.8 with no problem.

K_2 · #**210** 10-14-2002, 08:55 PM

Thank You!

wolfe · #**211** 10-18-2002, 12:28 AM

WOW awesome m8 niceone must have took you ages to do all that sql code

but 1 question how can i add it to the Who's Online in online.php i get this

Code:

Unknown Location: /forums/weather.php?&action=modifysettings&s=

also there is a error on it when i click on this link

Code:

<a href="weather.php?s=$session[sessionhash]&forceupdate=yes">Force Update</a>

i get a blank screen

any ideas

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.15786 seconds Memory Usage 2,362KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!