17.02.2017, 08:57
Try this, just make sure to make a backup beforehand
Code:
oldname = 'lignt - grightness'
newname = 'light'
db:query('UPDATE visobjects SET name=? WHERE name=?', newname, oldname)
oldicon = 'weather-night-A0F007-010101.svg'
newicon = 'my_weather_icon.svg'
db:query('UPDATE visobjects SET params=replace(params,?,?)', oldicon, newicon)
oldicon = 'bulb-A0F007-010101.svg'
newicon = 'my_lights_on_icon.svg'
db:query('UPDATE visobjects SET params=replace(params,?,?)', oldicon, newicon)