Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "INSERT INTO {{ t('Settings') }}
- (
- site_id,
- settings_part_id,
- name,
- title,
- description,
- order_id,
- class,
- rules,
- value,
- created_ts
- )
- VALUES
- {{ BEGIN Values }}
- (
- {{ i(site_id) }},
- {{ i(settings_part_id) }},
- {{ s(name) }},
- {{ s(title) }},
- {{ snul(description) }},
- {{ i(order_id) }},
- {{ s(class) }},
- {{ jsonEncode(rules) }},
- {{ s(value) }},
- {{ now() }}
- ){{ UNLESS _last }},{{ END }}
- {{ END }}
- ON DUPLICATE KEY UPDATE
- name = VALUES(name),
- title = VALUES(title),
- description = VALUES(description),
- order_id = VALUES(order_id),
- class = VALUES(class),
- rules = VALUES(rules),
- value = VALUES(value)"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement