Page 7 of 15

Re: Top 10 Records Page

Posted: Fri 07 Feb 2014 6:45 pm
by mcrossley
A minor tweak to 'my' ver 0.12 - I have dropped the 'driest years' to make some space (it duplicates wettest years until I have been running longer than 10 years!) and added Most (& Least) Rain Days in a Month.

http://weather.wilmslowastro.com/top10s.php

Re: Top 10 Records Page

Posted: Fri 07 Feb 2014 11:22 pm
by JennyLeez
and done..

Many thanks for alterations, good stats added.

Gee 127mm over 30 rain days for your January. So thats 1 dry day. Pleased I dont live up there.

I call my top10 page my auditor. It keeps me on my toes keeping my dayfile correct....lol

Again thanks,
Jenny

Re: Top 10 Records Page

Posted: Sat 08 Feb 2014 10:26 am
by Bridger
Mark, thanks for the updated script - very useful additions to the table.

Re: Top 10 Records Page

Posted: Sat 08 Feb 2014 10:54 am
by mcrossley
Out of interest... as ever I make these scripts available for people to use as a basis for their own customised versions, so has anybody added their own stats that may be of interest to others?

Re: Top 10 Records Page

Posted: Sat 26 Jul 2014 3:00 pm
by Bridger
At 1:30 on 19th July my FO WH1090 transmitter stopped working at the same time as a lightning strike on the nearby church.
About 10 minutes before the strike we had torrential rain and my station recorded a record rain rate of 111.6mm/hr.
I am back up and running with a new FO WH2080 but although Cumulus is correctly showing the Highest Rain Rate of 111.6 on 19 July my Top Ten page is showing it as being on 23 July - the date I started recording data again.
I am assuming this is because Cumulus is taking the data from the monthly log file whereas Top 10 is using the dayfile.txt - and there was no dayfile.txt created for 19 July.

What would be the best way to fix the Top 10 page?
By creating a line in the dayfile.txt for 19 July using the data up to the point of failure (then editing the line for 23 July)?
or
By inserting a line in the MySQL database for 19th July with just the Highest Rain Rate field populated or do all the fields have to have valid dated - or perhaps nulled?
My SQL knowledge is limited - which is probably obvious from my question!!!

Re: Top 10 Records Page

Posted: Sat 26 Jul 2014 8:54 pm
by Bridger
Just found the "Create Missing" button in the Dayfile.txt Editor which should do what I want. :oops: :oops:

Re: Top 10 Records Page

Posted: Fri 21 Nov 2014 10:02 am
by bobhutton
For some now I have tried to understand how to implement the Top10 records. I have looked through all the posts so far and cannot find and "idiots guide" which doesn't assume an in depth knowledge of MySQL and PHP.

Can anyone help?

Re: Top 10 Records Page

Posted: Fri 21 Nov 2014 6:01 pm
by PaulMy
I have much less than "in depth knowledge of MySQL and PHP", in fact no knowledge, and following the guidance from this thread I was able to get it implemented. If I recall correctly the first thing was to set up a MySQL database with my webhost, then using the utility from Cumulus Wiki to upload dayfile.txt, then take the code given in one of the posts and some cries for help here and I got it to work.

What steps have you taken so far?

Enjoy,
Paul

Re: Top 10 Records Page

Posted: Fri 21 Nov 2014 9:26 pm
by bobhutton
Thanks for your reply.

I am trying to get it working locally on my laptop because I do not have any web space at the moment.

I have installed XAMPP, have a batch file that runs from Cumulus each day at rollover time and copies dayfile.txt. I have not worked out how to populate the database automatically, so I manually run a file ImportCumulusFile.php which I found in a post on the forum. That is where i am stuck because I am unable to work out what comes next.

Bob

Re: Top 10 Records Page

Posted: Fri 21 Nov 2014 9:43 pm
by PaulMy
Sorry I can't help on how to run locally :(

Paul

Re: Top 10 Records Page

Posted: Fri 21 Nov 2014 11:09 pm
by MackerelSky
bobhutton wrote:For some now I have tried to understand how to implement the Top10 records. I have looked through all the posts so far and cannot find and "idiots guide" which doesn't assume an in depth knowledge of MySQL and PHP.

Can anyone help?
Are you getting any errors Bob? and do you have any other script that has been successful accessing the database. I have the same server on my laptop

Brad

Re: Top 10 Records Page

Posted: Sat 22 Nov 2014 6:34 am
by bobhutton
I am not aware of any errors in the database.
The only thing I have been able to do with the data in the database is to create a couple of queries.

Re: Top 10 Records Page

Posted: Sat 22 Nov 2014 9:25 am
by MackerelSky
I was actually talking about errors when you tried to run the script to access the database.
Like what happens when you type http://localhost/top10s.php into your browser.

Before we go to far in this forum topic of top 10's, do you have anything working yet on your server?

If nothings happening there I might suggest starting a new topic on 'Getting Xampp Working' for other folks benefit and keep this thread for Marks script, or PM me if you feel like it.

Brad

Re: Top 10 Records Page

Posted: Sat 22 Nov 2014 11:16 am
by bobhutton
Sorry, it was not my intention to hijack this this thread.

When I run http://localhost/top10s.php in Firefox I get the following errors above the tables:
2014-11-22 11_00_38-Mozilla Firefox.jpg
The tables look OK.

Below the tables I get
2014-11-22 11_01_40-Mozilla Firefox.jpg
What this means is what is puzzling me.

Bob

Re: Top 10 Records Page

Posted: Sat 22 Nov 2014 12:04 pm
by duke
deleted, didn't read previously post correctly :shock: