Author Topic: Weather34 template(non meteobridge versions)  (Read 117994 times)

0 Members and 1 Guest are viewing this topic.

Offline mattwx

  • Member
  • *
  • Posts: 17
Re: HOMEWEATHERSTATION Dashboard template
« Reply #100 on: October 03, 2016, 11:30:42 PM »
My charts are blank after the latest update (downloaded around 23:00 EST)

 [ You are not allowed to view attachments ]

I'm sure I missed something in settings.php but I couldn't see anything obvious. I tried setting the location to usa, northamerica, and uk but all resulted in the same blank chart. With the version I installed yesterday, the charts worked fine (but with wrong units) with northamerica set to true but were blank with usa set to true.

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #101 on: October 03, 2016, 11:35:08 PM »
My charts are blank after the latest update (downloaded around 23:00 EST)

 [ You are not allowed to view attachments ]

I'm sure I missed something in settings.php but I couldn't see anything obvious. I tried setting the location to usa, northamerica, and uk but all resulted in the same blank chart. With the version I installed yesterday, the charts worked fine (but with wrong units) with northamerica set to true but were blank with usa set to true.

hi sorry its hard for me to diagnose without a url , looking at the screenshot its on a local . just send me your settings.php via pm

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #102 on: October 04, 2016, 12:13:45 AM »
matt i have sent you a pm i tested everything with no problems found on local server environment screenshot below


Offline giantocr

  • Member
  • *
  • Posts: 22
Re: HOMEWEATHERSTATION Dashboard template
« Reply #103 on: October 04, 2016, 04:17:03 AM »
Hi Brian,


I'm getting no data into the new chartswu.

Piet

http://www.weerstation-sauwerd.nl

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #104 on: October 04, 2016, 05:20:06 AM »
Hi Brian,


I'm getting no data into the new chartswu.

Piet

http://www.weerstation-sauwerd.nl

looks ok to me clear your browser cache ???

see screenshot attached


Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #105 on: October 05, 2016, 03:41:20 AM »
Hi good morning

firstly massive big thank you to the following for yesterdays bug fest with the charts , it was a new system that needed some input and feedback and finally last night seemed to
iron out the issues raised .worst one was the single missing colon (;),something so small yet critical as some installations on some servers refused to work without it .

William,Piet,Paul W,Paul G,Hans,Atsio,Gert,Antoine,Luca,Chris W,Chris D,Damien,Ella.. if i missed anyone im sorry .

this morning i have re packaged everything no longer going to issue a small upgrade packaged it proved more problematic than the original upgrade path of doing a full installation however it should not take any more than 10 minutes if you have been a regular user .

i have added a new conversion file called conversion.php which resides in the chartswu folder this basically drives the conversions when switching units with in the template via the menu . i have also included rain rate in the daily rain chart .

it is critical to study the settings.php i found yesterday most were setting two lines as true this completely confuses the conversion script

for example
$northamerica       = false;   // set to true if in NORTH AMERICA OUTSIDE UNITED STATES OF AMERICA                            
$uk                 = true;  // set to true if in UNITED KINGDOM (MPH)                                                
$usa                = false;  // set to true if in UNITED STATES OF AMERICA                                           
$scandinavia        = false;  // set to true if in scandinaiva (m/s)                                                 
$restoftheworld     = true;   // set to true if in none of above      

only one line should be set to true

$northamerica       = false;   // set to true if in NORTH AMERICA OUTSIDE UNITED STATES OF AMERICA                            
$uk                 =false;  // set to true if in UNITED KINGDOM (MPH)                                                
$usa                = false;  // set to true if in UNITED STATES OF AMERICA                                           
$scandinavia        = false;  // set to true if in scandinaiva (m/s)                                                 
$restoftheworld     = true;   // set to true if in none of above

i have absolutely no plans to do anymore for at least a month, i have a personal DIY bathroom to start and finish.

you can get the release ALL4ONE(canvas) at http://weather34.com/homeweatherstation/

again many many thanks for all the feedback...

brian         

Offline ConligWX

  • Forecaster
  • *****
  • Posts: 836
  • #conligwx
    • conligwx.org
Re: HOMEWEATHERSTATION Dashboard template
« Reply #106 on: October 05, 2016, 01:10:54 PM »
Hi Brian.

I am still unable to create the graphs from the data, i am guessing it is some permission issues with my NAS which is my Webserver.

so I was thinking of using MySql Database instead, however I noticed the settings mentions the following.

Quote
//only if using for database add your login details
//$db_host = "localhost"; // always local host

so I cannot use my Weather Stations Cumulus DB unless is on the Webserver that this Template is located on? is this correct? can I not use my WX Host IP address instead?

Regards Simon
Davis Vantage Pro2 Plus (6162UK) • Daytime FARS • WeatherLink Live • AirLink • PurpleAir PA-II-SD • CumulusMX •


Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #107 on: October 05, 2016, 02:55:26 PM »
Hi Brian.

I am still unable to create the graphs from the data, i am guessing it is some permission issues with my NAS which is my Webserver.

so I was thinking of using MySql Database instead, however I noticed the settings mentions the following.

Quote
//only if using for database add your login details
//$db_host = "localhost"; // always local host

so I cannot use my Weather Stations Cumulus DB unless is on the Webserver that this Template is located on? is this correct? can I not use my WX Host IP address instead?
you can use what ever database you want as long as the configuration file can see it , FYI this is all developed on a local server (2 machines now one is a dedicated server one is xampp on a mac mini both running php 5.6 optional 7 so i cant understand why you have the permission issue , i have no special configuration .

do me a favour drop me an email i have a stand alone version of the new charts that doesnt use a cron job it simply pulls the info direct from WU  .

it has its own settings file which is very simple see below .it also works with the unit switching from the template but ideally its purpose is going to be a stand alone package to use with any template or if your building your own design as it is self sufficient and does not rely on any other configuration files

<?php
   
   ####################################################################################################
   #   WUDATACHARTS by BRIAN UNDERDOWN 2016                                                           #
   #   CREATED FOR HOMEWEATHERSTATION TEMPLATE at http://weather34.com/homeweatherstation/index.html  #
   #                                                                                                   #
   #    built on CanvasJs                                                                                #
   #     canvasJs.js is protected by CREATIVE COMMONS LICENCE BY-NC 3.0                                #
   #    free for non commercial use and credit must be left in tact .                                   #
   #                                                                                                   #
   #    Weather Data is based on your PWS upload quality collected at Weather Underground               #
   #                                                                                                   #
   #    Second General Release: October 2016                                                            #
   #    STANDALONE Release: October 4th 2016                                                        #
   #                                                                                                   #
   #   http://www.weather34.com                                                                       #
   ####################################################################################################
   
####################################################################################################
# Basic setup information
##############################################################################################      
   
$id                = 'ISTANBUL161'; // your weather underground station id (case sensitive in CAPITALS)
$unit              = 'metric';  // set to metric for rest of world outside of USA  set to english for USA (lowercase)
$TZ                = 'Europe/Istanbul'; // important set your time zone America/New_York for example go here to find your http://php.net/manual/en/timezones.php
$stationlocation   = 'Sinanoba Istanbul'; // add your station name or location
##############################################################################################
# Units set to your preference
##############################################################################################    
$windunit           = 'm/s'; // km/h - m/s - mph - kts
 $tempunit           = '°C '; // °C or °F
  $rainunit           = 'mm'; // set template output for rain units displayed: 'in' or 'mm'
    $rainrate           = 'mm'; // set template output for rain rate measurement mm ,in
     $pressureunit       = "hPa"; // set template output pressure units displayed: 'inHg' or 'hPa' or 'mb'
##############################################################################################

##############################################################################################
# Convert wind speed(mph for UK and scandinavia  M/S) andyearly & monthly rainfall(cm to mm) daily requires no conversion
##############################################################################################    
if ($unit == 'metric' & $windunit == 'mph'  ) {   
$windconv = "0.621371";$rainfallconv='10';$rainfallconvmm='10';

}

if ($unit == 'metric' & $windunit == 'm/s'  ) {   
$windconv = "0.277778";$rainfallconv='10';$rainfallconvmm='10';
}

if ($unit == 'metric' & $windunit == 'km/h'  ) {   
$windconv = "1";$rainfallconv='10';$rainfallconvmm='10';
}

if ($unit == 'english' & $windunit == 'mph'  ) {   
$windconv = "1";$rainfallconv='1';$rainfallconvmm='1';
}

//end

?>

so send me an email

Offline PaulMy

  • Forecaster
  • *****
  • Posts: 5509
    • KomokaWeather
Re: HOMEWEATHERSTATION Dashboard template
« Reply #108 on: October 05, 2016, 11:23:07 PM »
I have updated and all looks good.  Well except for my ongoing "stale file" interruption :oops:
The graphs look great!

Paul

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
HOMEWEATHERSTATION TEMPLATE APP
« Reply #109 on: October 07, 2016, 01:18:51 AM »
HOMEWEATHERSTATION TEMPLATE APP

pending Apple store approval you will be able to download a free simple app for MAC OSX or IOS and use your weather station with the template as an app

it can be used on desktop or menu bar see screenshot . very simple but effective.. works on MAC OSX from  MAVERICK, to EL CAPITAN,and new SIERRA(screenshot) and if approved will release also a IOS app


Offline ConligWX

  • Forecaster
  • *****
  • Posts: 836
  • #conligwx
    • conligwx.org
Re: HOMEWEATHERSTATION Dashboard template
« Reply #110 on: October 11, 2016, 02:25:53 PM »
I'd like to try using the mysql database.

in Settings.php I have changed/uncommented the

$db_host
$db_user
$db_pass
$db_name

but what else to I change in settings?

$dataSource   points to wunderground.  should this also be changed to what? mysql? ip of mysql server?


Regards Simon
Davis Vantage Pro2 Plus (6162UK) • Daytime FARS • WeatherLink Live • AirLink • PurpleAir PA-II-SD • CumulusMX •


Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
NEW ALTERNATIVE HOMEWEATHERSTATION Dashboard template
« Reply #111 on: October 13, 2016, 07:22:28 AM »
Note this is only if you wish to take advantage of newer features if you are happy with existing setup then it is not important to change to this version.

New enhancements for WS1001 users and a universal new indexnew.php
to use combined windspeed and direction, new moon-phase appearance and current sky conditions on
main page. use menu to switch





If you wish to use alternative layout as main appearance just rename indexnew.php to
index.php and save original index.php as something else for later use or reverting back.
you will have to change the menu to reflect new filename.

this package requires full upgrade there is no shortcut please install without any traces of previous
versions , if you take the shortcut route it will not work properly .
simply remove existing template from your server and fully replace all files.

it is not always necessary to upgrade each time if you are happy with your current setup.

1.NEW alternative main page use menu to switch layout choice
2.NEW folder CREATEDATABASE for WS1001 users to use database data for realtime HIGHS/LOWS/AVERAGES
3.NEW current conditions with 3 hour forecast displayed
4.NEW moonphase display for main page
5.NEW notification center for earthquake data regional and significant
6.make sure your database login details are correct in settings.php nothing will work properly until it is correct.
7.run createdatabase.php first
8.run import.php when successfully created database
9.WS1001 USERS updateweatherstation.php will do all the rest of the work updating database every 16 seconds
10.NEW run extra WS1001 only cron job at midnight your server time to trunctuate(clear down and create a new for new day) database at end of day. important


critical new database settings for WS1001 users in settings.php please check thoroughly …

please read the setup.rtf enclosed in the zip file download.

version ALL4ONE(canvas alternative)

brian underdown october 13th 2016

realtime live demo at http://weather34.com

available via http://weather34.com/homeweatherstation/

Offline slayer91

  • Member
  • *
  • Posts: 6
Re: HOMEWEATHERSTATION Dashboard template
« Reply #112 on: October 13, 2016, 03:42:55 PM »
Hi,
I using your great template at http://www.quinweather.com and all appears to be working ok except my charts.
The monthly charts are not up dating pass the 3rd Oct and the today's chart is blank.
 Using Weather display and weather underground.
Any idea whats wrong?

Regards

Liam

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #113 on: October 14, 2016, 12:51:20 AM »
Hi,
I using your great template at http://www.quinweather.com and all appears to be working ok except my charts.
The monthly charts are not up dating pass the 3rd Oct and the today's chart is blank.
 Using Weather display and weather underground.
Any idea whats wrong?

Regards

Liam

good morning

after I run your two cron files you should now see the charts populated for year/month/day ok

however i think you need to check or add the correct api key as the forecast and current sky are not showing data .

settings.php

$api= 'xxx'; // important Weather Underground api key developer key '1234567890'
$api2= 'xxx'; // optional Weather Underground api key developer key '1234567890'

weather.json shows (used for current sky)


{
  "response": {
  "version":"0.1",
  "termsofService":"http://www.wunderground.com/weather/api/d/terms.html",
  "features": {
  }
      ,
   "error": {
      "type": "keynotfound"
      ,"description": "this key does not exist"
   }
   }
}

forecast10day.json shows (used for forecast data)


{
  "response": {
  "version":"0.1",
  "termsofService":"http://www.wunderground.com/weather/api/d/terms.html",
  "features": {
  }
      ,
   "error": {
      "type": "keynotfound"
      ,"description": "this key does not exist"
   }
   }
}


have a good day..
brian

Offline slayer91

  • Member
  • *
  • Posts: 6
Re: HOMEWEATHERSTATION Dashboard template
« Reply #114 on: October 14, 2016, 06:22:49 AM »
Brian,
Thanks for the quick and helpful reply.
I had mistaken my WU station key as the api key. I have now got a api key from WU and updated the settings file and awaiting results

Sorry if I miss it in the docs but how do I run the cron files to update the graphs

Thanks for all your help

Reg
Liam K

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #115 on: October 14, 2016, 06:29:39 AM »
Brian,
Thanks for the quick and helpful reply.
I had mistaken my WU station key as the api key. I have now got a api key from WU and updated the settings file and awaiting results

Sorry if I miss it in the docs but how do I run the cron files to update the graphs

Thanks for all your help

Reg
Liam K

you need to run two cronfiles i tested them through the browser and your server config is perfect for cron jobs . check your site now .

your/cronfiles/stationcron.php  15 minute intervals
your/cronfiles/forecastcron.php 60 minute intervals

do you have a cpanel provided by your host ?

if you need help please pm your login in details or create temporary login . only takes a minute .

brian







Offline slayer91

  • Member
  • *
  • Posts: 6
Re: HOMEWEATHERSTATION Dashboard template
« Reply #116 on: October 14, 2016, 10:23:13 AM »
Brian,

As this is part of an ongoing learning process, I look up and have now set up 2 cron jobs. At this stage the appear to be working. The daily and yearly charts are updated and I can see api calls on WU on my WU analytics page but all monthly charts are only updated to the 3rd of Oct? Any advice?

Regs and Thanks

Liam

Offline droiddk

  • Forecaster
  • *****
  • Posts: 334
Re: HOMEWEATHERSTATION Dashboard template
« Reply #117 on: October 14, 2016, 03:17:54 PM »
Hello All

Sorry but I don't think I get this - who is developing the Dashboard template? Some time ago I saw a message that Brian was going to leave the template and pass over to a hand-full of people?

Are the numerous version "out there" or just one version that Brian is taking about above?

Regards

Offline cojones

  • Member
  • *
  • Posts: 2
Re: HOMEWEATHERSTATION Dashboard template
« Reply #118 on: October 14, 2016, 05:27:56 PM »
Hello. New here and first post...

I have an Aercus WeatherRanger WIFI PWS that feeds Wunderground.  Is it possible to configure the data source for this template as the wunderground api for current observations as well as forecast?

I'm asking because I haven't found a way to intercept the data from the PWS as it's sent over wifi and not through a logger.

I've tried configuring the settings to how I think it should be but I just get the forecast data.

Thank you for any advice.

Coj

Offline brushwood69

  • Member
  • *
  • Posts: 16
Re: HOMEWEATHERSTATION Dashboard template
« Reply #119 on: October 15, 2016, 07:45:30 AM »
Hi All & Brian,

I had my setup all working and as you do you play around! However I cant find the initial setup instructions for the ws1001 server.ini and the json bit on the server. ie where the folders need to go and what they are called.

I'm using an old template at weatherincornwall.com but i'm not getting any data to it any more so need the info to check my setting against the correct settings.

Thanks in advance

BW69



Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #120 on: October 15, 2016, 08:10:00 AM »
if you dont mind ill answer last 3 in one .

1. droiddk: 3 months ago the situation here in istanbul was getting awful , numerous suicide bombings on one occassion stood at the point at the airport some 3 hours earlier , another occasion wife was 5 minutes away with a group of visitors from a another suicide bomb in the city.

then we had the attempted coup , F16s flying over us all night , bomb explosions in the distance amongst all that was total confusion as it unfolded it didnt makes sense and was not supported in any way by the turkish people but the aftermath was a lot of uncertainty because of the unknown. for a few weeks our future here was uncertain but has the weeks passed the initial shock had weakened and life started to return to normal , we started to feel safe again and able to go about our daily life as normal up to that point there was a lot of uncertainty about in the air , you could literally feel the tense atmosphere everywhere.
so touch wood we have passed that point of uncertainty but remain vigilant and cautious . having the normality has allowed me to carry on and push the template into a better user experience and apply different ideas from others like the new switching of units and theme etc(from Eric). so what you see above is current and no foreseeable major release until late november as currently preoccupied with something else. hope that clarifies things and i totally understand the frustration its the same for us but the events that happened were beyond my control and they really turn your life and thinking upside down and thankfully today life is normal but its never far away from our minds as only yesterday rocket launchers were fired into a popular tourist region.

2.brushwood69  drop me an email nothing changed and the current download as all the necessary files to use with the ws1001 but now you will need a database setup to take advantage of some extra features for the WS1001.

3.cojones  it was originally that way the template way back in august 2015 was using the weather underground api to display the data .drop me an email somewhere in my back up drive i have the original scripts i used, but i cant offer anything else to work with current template design just to preoccupied but happy to send you along what i have if that is of any help.


brian
« Last Edit: October 15, 2016, 08:18:34 AM by weatherist34 »

Offline mattwx

  • Member
  • *
  • Posts: 17
Re: HOMEWEATHERSTATION Dashboard template
« Reply #121 on: October 15, 2016, 11:20:48 AM »
Brian,

Is the new alternative template only for WS1001 users? I use WD/clientraw and am getting this error:

Code: [Select]
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\inetpub\wwwroot\pws\livedata.php:8 Stack trace: #0 C:\inetpub\wwwroot\pws\index.php(1): include() #1 {main} thrown in C:\inetpub\wwwroot\pws\livedata.php on line 8
I commented out the mysql user/pass/etc settings from settings.php but also tried supplying valid credentials to mysql.  Am I missing a file that defines the mysql_connect() function?

Thanks,

Matt

ps glad to hear things at home are calming down a bit!

Offline Jáchym

  • Meteotemplate Developer
  • Forecaster
  • *****
  • Posts: 8605
    • Meteotemplate
Re: HOMEWEATHERSTATION Dashboard template
« Reply #122 on: October 15, 2016, 11:57:39 AM »
Hi Matt,

hope Brian doesnt mind if I answer.

The mysql_connect is a function that should be built-in PHP, so you should not need to "include it". However this is slightly outdated, the function that is used these days is MySQLi instead. Either way, based on what you said, it looks like you do not want to use MySQL at all.

The function you specified is one trying to connect to database. Even if you replaced it with one that works on your server (assuming it is MySQLi), it would not work unless you provide the details for connecting to the database.

You must find the line which tries to connect to the db and comment that out too if you do not want to use MySQL at all.

If you do and mysql_connect does not work, I recommend using MySQLi, it stands for "improved MySQL" and it is today´s standard. MySQL is outdated.

However, I am not sure if that is what Brian used because if you use MySQLi to connect to the db, then you would also have to change all the other mySQL commands that use MySQL to MySQLi syntax.

Offline mattwx

  • Member
  • *
  • Posts: 17
Re: HOMEWEATHERSTATION Dashboard template
« Reply #123 on: October 16, 2016, 12:28:44 AM »
Hi Matt,

hope Brian doesnt mind if I answer.

The mysql_connect is a function that should be built-in PHP, so you should not need to "include it". However this is slightly outdated, the function that is used these days is MySQLi instead. Either way, based on what you said, it looks like you do not want to use MySQL at all.

The function you specified is one trying to connect to database. Even if you replaced it with one that works on your server (assuming it is MySQLi), it would not work unless you provide the details for connecting to the database.

You must find the line which tries to connect to the db and comment that out too if you do not want to use MySQL at all.

If you do and mysql_connect does not work, I recommend using MySQLi, it stands for "improved MySQL" and it is today´s standard. MySQL is outdated.

However, I am not sure if that is what Brian used because if you use MySQLi to connect to the db, then you would also have to change all the other mySQL commands that use MySQL to MySQLi syntax.

I'd started a post edit hours ago to say I did some digging and saw that mysql_connect is no longer part of php but got sidetracked. Thanks for the advice, I went in and commented out the sql related lines at the top of livedata.php and things seem to be working well.

Matt

Offline weather34

  • Forecaster
  • *****
  • Posts: 1068
    • https://weather34.com/homeweatherstation
Re: HOMEWEATHERSTATION Dashboard template
« Reply #124 on: October 16, 2016, 06:42:23 AM »
Hi Matt,

hope Brian doesnt mind if I answer.

The mysql_connect is a function that should be built-in PHP, so you should not need to "include it". However this is slightly outdated, the function that is used these days is MySQLi instead. Either way, based on what you said, it looks like you do not want to use MySQL at all.

The function you specified is one trying to connect to database. Even if you replaced it with one that works on your server (assuming it is MySQLi), it would not work unless you provide the details for connecting to the database.

You must find the line which tries to connect to the db and comment that out too if you do not want to use MySQL at all.

If you do and mysql_connect does not work, I recommend using MySQLi, it stands for "improved MySQL" and it is today´s standard. MySQL is outdated.

However, I am not sure if that is what Brian used because if you use MySQLi to connect to the db, then you would also have to change all the other mySQL commands that use MySQL to MySQLi syntax.

I'd started a post edit hours ago to say I did some digging and saw that mysql_connect is no longer part of php but got sidetracked. Thanks for the advice, I went in and commented out the sql related lines at the top of livedata.php and things seem to be working well.

Matt

SORRY MY MISTAKE LAST NIGHT have separated the versions correctly . the ws1001 database is for ws1001 stand alone users only,
 if you are using the weather display software to send data then the standard version is all you need not the ws1001 .so my sincere apologies for the confusion.

as for mysqli currently i have not enabled the extension on my recently home built server hence the mysql code and i still need to install php 7 on it .
running also mysqli on a mac min  with PHP 7 so the option is there locally to work with . however the version i use on weather34.com site uses mysqli

 // THIS DATABASE OPTION AT PRESENT IS ONLY FOR WS1001 USERS //
   
    $conn = mysqli_connect($db_host,$db_user,$db_pass,$db_name);
   // Max temperature ws1001 only
   $result  = mysqli_query($conn,"SELECT MAX(outsideTemp) FROM weatherstation");
   $maxtemp = mysqli_fetch_array($result);   
      // Min TEMPERATURE ws1001
   $result1 = mysqli_query($conn,"SELECT MIN(outsideTemp) FROM weatherstation");
   $mintemp = mysqli_fetch_array($result1);   
   // Max Windspeed ws1001
   $result2 = mysqli_query($conn,"SELECT MAX(windSpeed) FROM weatherstation");
   $maxwind = mysqli_fetch_array($result2);   
   // Average Windspeed ws1001
   $result3 = mysqli_query($conn,"SELECT AVG(windSpeed) FROM weatherstation");
    $avgwind = mysqli_fetch_array($result3);
   // Average Windsgust ws1001
   $result4 = mysqli_query($conn,"SELECT AVG(windGustmph) FROM weatherstation");
    $avggust = mysqli_fetch_array($result4);         
   // Max Windgust   ws1001
   $result5 = mysqli_query($conn,"SELECT MAX(windgustmph) FROM weatherstation");
    $maxgust = mysqli_fetch_array($result5);
   // Max Barometer ws1001
   $result6 = mysqli_query($conn,"SELECT MAX(barometer) FROM weatherstation");
    $maxpressure = mysqli_fetch_array($result6);   
   // Max Radiation ws1001
   $result7 = mysqli_query($conn,"SELECT MAX(radiation) FROM weatherstation");
    $maxsolar = mysqli_fetch_array($result7);   
   // Average Direction ws1001
   $result8 = mysqli_query($conn,"SELECT AVG(direction) FROM weatherstation");
    $avgdir = mysqli_fetch_array($result8);   

hopefully when all is good and stable in terms of database usage across all software/hardware the dbase option for all software types will be released and include above . time is not on my side the moment but it will come .

drag and option hmmm having second thoughts as I kind of vision some user experience problems . i personally love it but i can see people getting frustrated on non touch screen
devices , it works well on a desktop but it so easy to move the mouse across a module a pick it up and move unexpectedly so I am looking at a script from https://jqueryui.com/draggable/ to position the pick up point in the bottom right hand corner of module and hold down mouse only to fire the drag and drop when on desktop.

thanks for response.

brian