Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE tasks,components
- INNER JOIN presets ON presets.id = tasks.id_preset
- INNER JOIN preset_values ON preset_values.id_preset = presets.id
- INNER JOIN preset_values AS pv2 ON pv2.serial_number = components.serial_number
- SET tasks.start_date = DATE_ADD(
- tasks.start_date, INTERVAL tasks.frequency SECOND
- ),
- components.value = pv2.value,
- components.state = pv2.on_off
- WHERE tasks.start_date <= CURRENT_DATE AND tasks.hour <= CURRENT_TIME
Add Comment
Please, Sign In to add comment