comparison: bmsd/mysql.c
bmsd/mysql.c
- changeset 718
- 59b02b64131b
- parent 705
- d77b723f7b35
- child 747
- b6fbe6821468
equal
deleted
inserted
replaced
| 717:aad750d942df | 718:59b02b64131b |
|---|---|
| 589 "profile_inittemp_high='%.3f', profile_inittemp_low='%.3f', profile_steps='%s', stage='%s', " \ | 589 "profile_inittemp_high='%.3f', profile_inittemp_low='%.3f', profile_steps='%s', stage='%s', " \ |
| 590 "yeast_lo='%.1f', yeast_hi='%.1f', webcam_url='%s', webcam_light='%d'", | 590 "yeast_lo='%.1f', yeast_hi='%.1f', webcam_url='%s', webcam_light='%d'", |
| 591 fermenter->uuid, fermenter->alias, fermenter->node, fermenter->online ? 1:0, | 591 fermenter->uuid, fermenter->alias, fermenter->node, fermenter->online ? 1:0, |
| 592 fermenter->beercode ? fermenter->beercode : "", fermenter->beername ? fermenter->beername : "", | 592 fermenter->beercode ? fermenter->beercode : "", fermenter->beername ? fermenter->beername : "", |
| 593 fermenter->beeruuid ? fermenter->beeruuid : "", | 593 fermenter->beeruuid ? fermenter->beeruuid : "", |
| 594 fermenter->air_address ? fermenter->air_address : "", fermenter->air_state ? fermenter->air_state : "", fermenter->air_temperature, | 594 fermenter->air_address ? fermenter->air_address : "", fermenter->air_state ? fermenter->air_state : "MISSING", fermenter->air_temperature, |
| 595 fermenter->beer_address ? fermenter->beer_address : "", fermenter->beer_state ? fermenter->beer_state : "", fermenter->beer_temperature, | 595 fermenter->beer_address ? fermenter->beer_address : "", fermenter->beer_state ? fermenter->beer_state : "MISSING", fermenter->beer_temperature, |
| 596 fermenter->chiller_address ? fermenter->chiller_address : "", fermenter->chiller_state ? fermenter->chiller_state : "", fermenter->chiller_temperature, | 596 fermenter->chiller_address ? fermenter->chiller_address : "", fermenter->chiller_state ? fermenter->chiller_state : "MISSING", fermenter->chiller_temperature, |
| 597 fermenter->heater_address ? fermenter->heater_address : "", fermenter->heater_state, fermenter->heater_usage, | 597 fermenter->heater_address ? fermenter->heater_address : "", fermenter->heater_state, fermenter->heater_usage, |
| 598 fermenter->cooler_address ? fermenter->cooler_address : "", fermenter->cooler_state, fermenter->cooler_usage, | 598 fermenter->cooler_address ? fermenter->cooler_address : "", fermenter->cooler_state, fermenter->cooler_usage, |
| 599 fermenter->fan_address ? fermenter->fan_address : "", fermenter->fan_state, fermenter->fan_usage, | 599 fermenter->fan_address ? fermenter->fan_address : "", fermenter->fan_state, fermenter->fan_usage, |
| 600 fermenter->light_address ? fermenter->light_address : "", fermenter->light_state, fermenter->light_usage, | 600 fermenter->light_address ? fermenter->light_address : "", fermenter->light_state, fermenter->light_usage, |
| 601 fermenter->door_address ? fermenter->door_address : "", fermenter->door_state, | 601 fermenter->door_address ? fermenter->door_address : "", fermenter->door_state, |
| 602 fermenter->psu_address ? fermenter->psu_address : "", fermenter->psu_state, | 602 fermenter->psu_address ? fermenter->psu_address : "", fermenter->psu_state, |
| 603 fermenter->mode, fermenter->alarm, fermenter->setpoint_high, fermenter->setpoint_low, | 603 fermenter->mode, fermenter->alarm, fermenter->setpoint_high, fermenter->setpoint_low, |
| 604 fermenter->profile_uuid ? fermenter->profile_uuid : "", fermenter->profile_name ? fermenter->profile_name : "", | 604 fermenter->profile_uuid ? fermenter->profile_uuid : "", fermenter->profile_name ? fermenter->profile_name : "", |
| 605 fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent, | 605 fermenter->profile_state ? fermenter->profile_state : "OFF", fermenter->profile_percent, |
| 606 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, | 606 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, |
| 607 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, | 607 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, |
| 608 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light); | 608 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light); |
| 609 | 609 |
| 610 if (bms_mysql_query(query) == 0) { | 610 if (bms_mysql_query(query) == 0) { |
| 644 fermenter->light_address ? fermenter->light_address : "", fermenter->light_state, fermenter->light_usage, | 644 fermenter->light_address ? fermenter->light_address : "", fermenter->light_state, fermenter->light_usage, |
| 645 fermenter->door_address ? fermenter->door_address : "", fermenter->door_state, | 645 fermenter->door_address ? fermenter->door_address : "", fermenter->door_state, |
| 646 fermenter->psu_address ? fermenter->psu_address : "", fermenter->psu_state, | 646 fermenter->psu_address ? fermenter->psu_address : "", fermenter->psu_state, |
| 647 fermenter->mode, fermenter->alarm, fermenter->setpoint_high, fermenter->setpoint_low, | 647 fermenter->mode, fermenter->alarm, fermenter->setpoint_high, fermenter->setpoint_low, |
| 648 fermenter->profile_uuid ? fermenter->profile_uuid : "", fermenter->profile_name ? fermenter->profile_name : "", | 648 fermenter->profile_uuid ? fermenter->profile_uuid : "", fermenter->profile_name ? fermenter->profile_name : "", |
| 649 fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent, | 649 fermenter->profile_state ? fermenter->profile_state : "OFF", fermenter->profile_percent, |
| 650 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, | 650 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, |
| 651 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, | 651 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, |
| 652 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light, fermenter->uuid); | 652 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light, fermenter->uuid); |
| 653 | 653 |
| 654 bms_mysql_query(query); | 654 bms_mysql_query(query); |
