1
Users / Re: Energy Monitor configuration?
« on: March 18, 2014, 07:21:35 am »
OK, I'll have to dig into it. I don't understand a lot of linuxmce right now, haha.
I note that the mysql select looks for a specific FK_DeviceData and a FK_Unit. Where would I find the documentation on what that stuff references?
$deviceQuery = mysql_query('SELECT EK_Device, Description, IK_DeviceData FROM Datapoints, pluto_main.Device, pluto_main.Device_DeviceData WHERE FK_Unit='.$unit.' AND EK_Device=PK_Device AND EK_Device=FK_Device AND FK_DeviceData=289
GROUP BY EK_Device ORDER BY FK_Room');
Thanks!
I note that the mysql select looks for a specific FK_DeviceData and a FK_Unit. Where would I find the documentation on what that stuff references?
$deviceQuery = mysql_query('SELECT EK_Device, Description, IK_DeviceData FROM Datapoints, pluto_main.Device, pluto_main.Device_DeviceData WHERE FK_Unit='.$unit.' AND EK_Device=PK_Device AND EK_Device=FK_Device AND FK_DeviceData=289
GROUP BY EK_Device ORDER BY FK_Room');
Thanks!