diff -r f1a7c14d5601 -r a42166cbb19a bmsd/mysql.c --- a/bmsd/mysql.c Sat Mar 07 21:05:49 2020 +0100 +++ b/bmsd/mysql.c Sun Mar 08 17:11:18 2020 +0100 @@ -729,7 +729,7 @@ snprintf(query, 2559, "INSERT INTO mon_ispindels SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', alarm='%d', " \ - "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d'", + "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d', og_gravity='0.0'", ispindel->uuid, ispindel->alias, ispindel->node, ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval); @@ -747,9 +747,9 @@ snprintf(query, 2559, "UPDATE mon_ispindels SET online='%d', mode='%s', alarm='%d', " \ - "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d' WHERE uuid='%s'", + "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d', og_gravity=GREATEST(og_gravity, '%.5f') WHERE uuid='%s'", ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, - ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval, ispindel->uuid); + ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval, ispindel->gravity, ispindel->uuid); bms_mysql_query(query); free(query);