bmsd/mysql.c

changeset 505
c09b67fd8323
parent 502
a8a6901b5a99
child 558
a8e065a9f851
--- a/bmsd/mysql.c	Fri Oct 11 11:44:37 2019 +0200
+++ b/bmsd/mysql.c	Fri Oct 11 13:38:31 2019 +0200
@@ -606,10 +606,10 @@
     char        *query = malloc(2560);
 
     snprintf(query, 2559,
-        "INSERT INTO mon_co2meters SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', " \
+        "INSERT INTO mon_co2meters SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', alarm='%d', " \
         "temperature_address='%s', temperature_state='%s', temperature='%.3f', " \
 	"pressure_state='%s', pressure_channel='%d', pressure_voltage='%.3f', pressure_zero='%.3f', pressure_bar='%.3f'",
-        co2meter->uuid, co2meter->alias, co2meter->node, co2meter->online ? 1:0, co2meter->mode,
+        co2meter->uuid, co2meter->alias, co2meter->node, co2meter->online ? 1:0, co2meter->mode, co2meter->alarm,
         co2meter->temperature_address, co2meter->temperature_state, co2meter->temperature,
 	co2meter->pressure_state, co2meter->pressure_channel, co2meter->pressure_voltage, co2meter->pressure_zero, co2meter->pressure_bar);
 
@@ -626,11 +626,11 @@
     char        *query = malloc(2560);
 
     snprintf(query, 2559,
-        "UPDATE mon_co2meters SET online='%d', mode='%s', " \
+        "UPDATE mon_co2meters SET online='%d', mode='%s', alarm='%d', " \
 	"temperature_address='%s', temperature_state='%s', temperature='%.3f', " \
         "pressure_state='%s', pressure_channel='%d', pressure_voltage='%.3f', pressure_zero='%.3f', pressure_bar='%.3f' " \
 	"WHERE uuid='%s'",
-        co2meter->online ? 1:0, co2meter->mode,
+        co2meter->online ? 1:0, co2meter->mode, co2meter->alarm,
 	co2meter->temperature_address, co2meter->temperature_state, co2meter->temperature,
         co2meter->pressure_state, co2meter->pressure_channel, co2meter->pressure_voltage, co2meter->pressure_zero, co2meter->pressure_bar,
 	co2meter->uuid);

mercurial