There’s an API here: https://ukvehicledata.co.uk/Fuel-Prices for UK fuel prices.
It’d be useful to someone I’m sure, rather like MMM-Fuel

Just a thought, if anyone were interested!

I have the MMM-MysqlQuery module working OK, just a couple of queries:

How might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

(As posted in the CSS area, but no replies there.)

I’m looking at the border-bottom in the ‘Lower third’ region.
Currently, the line below the heading, when enabled, crosses the entire display.

The CSS attributeborder-bottom-width changes not the width, but the height of the line, not what I want.

How then, do I get border-bottom in lower-third, to be just the width of what it’s showing, and not the entire width of the display?

Thank you.

@Richard238 said in MMM-MysqlQuery module just released!:

I have this module working quite well, just a couple of queries:

How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.

And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

How do you get the title “______________MYSQL SPICES” line displayed?
Fixed that one in config.js with header: 'Module Title',

Other enhancements still need attention, if anyone can help, please?

I’m looking at the border-bottom in the ‘Lower third’ region.
Currently, the line below the heading, when enabled, crosses the entire display.

The CSS attributeborder-bottom-width changes not the width, but the height of the line, not what I want.

How then, do I get border-bottom in lower-third, to be just the width of what it’s showing, and not the entire width of the display?

Thank you.

I have this module working quite well, just a couple of queries:

How do you get the title “______________MYSQL SPICES” line displayed?
I am getting just the table, not the title header line.

And how might you change “Amt” form an integer, to a message saying “Too High” or Too low"?
[I am actually measuring temperature and lux levels, but the principle’s the same.]

Thank you.

Had to add a line:

position: 'bottom_right'

Now to make the SQL work with the Mysqli db I have running on an adjacent pi.

My currentweather module isn’t showing its location.

Module.register("currentweather",{

	// Default module config.
	defaults: {
		location: false,
		locationID: 1234567,
		appid: "", 
		units: config.units,

		{
			module: 'currentweather',
			position: 'top_right',
			config: {
				location: 'AnyTown,GB',
				locationID: '1234567',  //ID from http://www.openweathermap.org
				appid: '############'
			}
		},

How do I get the location back on the current weather, please?

Doesn’t help much, but mine is still OK.

Hi Joe,

I just ran the updates, which cleared the “undefined” message.
No code was changed.

Richard.