Page 10 of 15

Re: Top 10 Records Page

Posted: Wed 09 Mar 2016 1:02 pm
by Mapantz
I'm a bit late to the scene.. but I would like to say thank you for allowing us to use your scripts. I've just found this one after going through the forum, and I've successfully got it working- took just a few minutes!

Excellent work! :)

Re: Top 10 Records Page

Posted: Wed 09 Mar 2016 5:14 pm
by mcrossley
You are welcome, glad you found it useful.

Re: Top 10 Records Page

Posted: Sun 30 Oct 2016 3:56 pm
by jlmr731
Mark you are awesome! Thanks for taking time to code this up.
took a bit to get it to work for me cause of an mysql error "sql_mode=only_full_group_by" and once i goggled that I found the answer to fix mysql.
I did come across this for future references
The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION.

The ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES modes were added in MySQL 5.7.5. The NO_AUTO_CREATE_USER mode was added in MySQL 5.7.7. The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE modes were added in MySQL 5.7.8. For additional discussion regarding these changes to the default SQL mode value, see SQL Mode Changes in MySQL 5.7.
as far as my fix was to edit mysql config to not set only_full_group_by
Using the latest greatest releases can make one go bald :groan:

Also im guessing since I have no frost records yet the few errors in apache error log will show up

Code: Select all

[Sun Oct 30 12:15:21.954092 2016] [:error] [pid 29883] [client 192.168.0.27:36808] PHP   1. {main}() /var/www/html/top10.php:0
[Sun Oct 30 12:18:20.610189 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Notice:  Undefined variable: rtn in /var/www/html/top10.php on line 580
[Sun Oct 30 12:18:20.610218 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Stack trace:
[Sun Oct 30 12:18:20.610236 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   1. {main}() /var/www/html/top10.php:0
[Sun Oct 30 12:18:20.610240 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   2. minMaxFrostDays() /var/www/html/top10.php:402
[Sun Oct 30 12:18:20.610580 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Notice:  Undefined variable: rtn in /var/www/html/top10.php on line 580
[Sun Oct 30 12:18:20.610596 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Stack trace:
[Sun Oct 30 12:18:20.610603 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   1. {main}() /var/www/html/top10.php:0
[Sun Oct 30 12:18:20.610609 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   2. minMaxFrostDays() /var/www/html/top10.php:404
[Sun Oct 30 12:18:20.610858 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Notice:  Undefined variable: rtn in /var/www/html/top10.php on line 607
[Sun Oct 30 12:18:20.610870 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Stack trace:
[Sun Oct 30 12:18:20.610877 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   1. {main}() /var/www/html/top10.php:0
[Sun Oct 30 12:18:20.610882 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   2. cntFrostDays() /var/www/html/top10.php:406
[Sun Oct 30 12:18:20.611309 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Notice:  Undefined variable: rtn in /var/www/html/top10.php on line 669
[Sun Oct 30 12:18:20.611320 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Stack trace:
[Sun Oct 30 12:18:20.611326 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   1. {main}() /var/www/html/top10.php:0
[Sun Oct 30 12:18:20.611331 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   2. frostRun() /var/www/html/top10.php:410
[Sun Oct 30 12:18:20.611660 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Notice:  Undefined variable: rtn in /var/www/html/top10.php on line 635
[Sun Oct 30 12:18:20.611672 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP Stack trace:
[Sun Oct 30 12:18:20.611678 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   1. {main}() /var/www/html/top10.php:0
[Sun Oct 30 12:18:20.611682 2016] [:error] [pid 29885] [client 192.168.0.27:40314] PHP   2. frostSeason() /var/www/html/top10.php:412

Re: Top 10 Records Page

Posted: Sun 30 Oct 2016 4:55 pm
by mcrossley
Thanks, glad you got it working.

Yep, looks like I need some error trapping on the frost records. Its things like that you don;t see when you have data going back a bit.

Re: Top 10 Records Page

Posted: Wed 21 Dec 2016 7:53 pm
by dazza1223
hi can any one help me to set up Top 10 Records

Re: Top 10 Records Page

Posted: Wed 21 Dec 2016 10:48 pm
by jlmr731
dazza1223 wrote:hi can any one help me to set up Top 10 Records
What do you need help with?

Re: Top 10 Records Page

Posted: Fri 23 Dec 2016 10:02 am
by dazza1223
ok i set up my sql and it all work but i want to add it to my own webpages but when i add the code it gose all rong ?

Re: Top 10 Records Page

Posted: Sat 24 Dec 2016 3:46 am
by jlmr731
Is it a layout problem? or the top10 just does not render on the page?
if you could send link to site/page not working or even zip up the web page code and attach it here im sure someone can give more help.

Re: Top 10 Records Page

Posted: Fri 30 Dec 2016 4:50 pm
by dazza1223
yh is the lay out and her is the file for u mate
top.rar
and here the link to the page http://www.davisworthing.co.uk/top.php

Re: Top 10 Records Page

Posted: Fri 30 Dec 2016 7:07 pm
by Mapantz
Do you know what really pisses me off? It's when someone copies your site down to the last detail..

The template is freely available from here: http://www.css3templates.co.uk/template ... index.html

I don't have a problem with folks using the same template if they are making something from scratch, but I do have a problem with folks copying the banner image - which I had edited myself to fit in with the site. The site background was one that I had edited myself, but swapped to a newer one recently. Various .css files which I have edited and added stuff to, so that I got everything working and looking fairly respectful. The menu has my page names and some of my links still in place.
The weather-icons.css is free for anyone to use, but when its flat-out taken from my site, and the exact same code and placement is used (next to my station name in the banner) I find unfair.

I don't know much about html, css, php or javascript - I have always asked for help if I get stuck on where to put things, or how to solve something. I will look at stackoverflow, or github for examples to try guide me through something, and I give thanks & praise to the persons in question, and even credit them with a referral link to where a script comes from. I have spent 10 months of a lot of my free time trying to get my site "just so" and a lot of headaches trying to find out why something doesn't work, only to find out I missed a quotation or a semi-colon somewhere.

I clicked your site, and I momentarily looked away from my screen and then back again, and I actually thought I was on my own site!
I feel quite cross at the moment, that someone would leech everything from my site to use as their own - there's even no acknowledgment or referral to the place where the template came from.

Am I being unreasonable?

I do apologise to everyone else for that rant in here. :(

Re: Top 10 Records Page

Posted: Fri 30 Dec 2016 7:25 pm
by duke
I totally agree and understand your rant. I do however notice, that looking at the various pages / functions on that site, that some cannot even copy correctly.

Re: Top 10 Records Page

Posted: Fri 30 Dec 2016 10:04 pm
by dazza1223
hi are u saying that i took ur website ant u? look i have memory problems and i founed it hard to lean thing and i love what i do it hard for me to reright a website it will take me ages and i did email u asking can i uese ur template but i you dint say any think so i fort ur Contact page wasnt working im sorry for up seting u im relly am how can we sort this out???

Re: Top 10 Records Page

Posted: Sat 31 Dec 2016 1:34 pm
by Mentor
So, let me get this right Mapanz. You copied a free template, modified it a bit and then clamed it as your own?

...and now you're blubbing that someone stole your website and is currently modifying it?

The guy is obviously trying to learn to build a website, you should feel honoured that he thought your website was godd enough to be worth building on.

Seriously, would you kick a toddler who is learning to walk? If it were a corporate website, I could understand the sense of ownership of the design, but then a corporation probably wouldn't use a free template.

So rather than having a rant, it would be much more constructive to suggest modifications that he could do in order to quell your emotional state.

Re: Top 10 Records Page

Posted: Sat 31 Dec 2016 10:56 pm
by duke
Mapantz did not copy / download a free weather template. The template by CSS3 Templates, is a basic html / CSS3 template that can be used for any purpose. It has NO means to display weather data.

Therefore, Mapantz has done all the hard work of researching this forum and others to gain knowledge to integrate the freely available scripts on this forum to display all the data you see displayed.

I am sure, like others here, if he had have been asked, would have helped those less capable.

Re: Top 10 Records Page

Posted: Sun 01 Jan 2017 12:14 pm
by dazza1223
as i said mate i did ask Mapantz for help and i dint do it in a way that to cheat i did it more to get me out and it not like ive cloned the site as i have none of her stuf on the