These scriipts will display the Highs & Lows for a given Day, Month, or
Year from data in the DB. They can be run interactively or as a cgi-bin
script once properly set up.

Set up the following sections in the .my.cnf file for the "user" specified
in "user=<user>" & "password=<password>" below and also replace "<user>" 
in the scripts on the $user = "<user>"; line. And also set the "vpID = 0"
value to the Console ID to retreive dat for if you have data from multiple
Vantage Pro Consoles stored in the DB.

[vproweather]
user=<user>
password=<password>
host=localhost
database=Weather

-or-

[getDBDailyHiLo]
user=<user>
password=<password>
host=localhost
database=Weather

[getDBMonthlyHiLo]
user=<user>
password=<password>
host=localhost
database=Weather

[getDBYearlyHiLo]
user=<user>
password=<password>
host=localhost
database=Weather

The "user" specified needs a minimum of SELECT on the tables in the 
Weather DB so replace "<user>" in the GRANT statements below with
that "user" if necessary:

GRANT SELECT ON Weather.Barometer TO <user>@localhost;
GRANT SELECT ON Weather.DHL TO <user>@localhost;
GRANT SELECT ON Weather.DT TO <user>@localhost;
GRANT SELECT ON Weather.Forecasts TO <user>@localhost;
GRANT SELECT ON Weather.Hourly TO <user>@localhost;
GRANT SELECT ON Weather.Humidity TO <user>@localhost;
GRANT SELECT ON Weather.IndexDT TO <user>@localhost;
GRANT SELECT ON Weather.MHL TO <user>@localhost;
GRANT SELECT ON Weather.MinPtrData TO <user>@localhost;
GRANT SELECT ON Weather.Rain TO <user>@localhost;
GRANT SELECT ON Weather.Solar TO <user>@localhost;
GRANT SELECT ON Weather.Storms TO <user>@localhost;
GRANT SELECT ON Weather.Temperature TO <user>@localhost;
GRANT SELECT ON Weather.VersionWeatherDB TO <user>@localhost;
GRANT SELECT ON Weather.Wind TO <user>@localhost;
GRANT SELECT ON Weather.YHL TO <user>@localhost;
GRANT SELECT ON Weather.YMD TO <user>@localhost;

Then to run these scripts;

./getDBDailyHiLo 20120301
./getDBMonthlyHiLo 201203
./getDBYearlyHiLo 2012
./getDBRainStorms

Or if running as a cgi-bin:

http://yourwebsite/cgi-bin/getDBDailyHiLo?20120301
http://yourwebsite/cgi-bin/getDBMonthlyHiLo?201203
http://yourwebsite/cgi-bin/getDBYearlyHiLo?2012


