Change userrating in KODI db using DB Browser?
#1
Hi,

i don't know much about SQL, but i've been able to edit my db using this guide and the replace function:
http://kodi.wiki/view/HOW-TO:Update_SQL_...files_move


I now want to change every song with a userrating of 2 to a 0, to make them unrated.

How can i achieve that Huh

Any nod to the right direction is appreciated.
KODI Player: Nvidia Shield TV Pro [2019] | Receiver: Marantz SR6013 | TV: LG 55SJ800V | Toaster: Severin AT 2515

How to:
Create custom video nodes like Documentaries, Concerts, Kids etc
 
Reply
#2
I would guess something along the lines of:
Code:
UPDATE "main"."song" SET userrating="0" WHERE userrating="2"

scott s.
.
maintainer of skin  Aeon MQ5 mods for post-Gotham Kodi releases:
Matrix see: Aeon MQ5 Mod Martix release thread
Leia see: Aeon MQ5 Mod Leia release thread
Reply
#3
that worked, thank you very much Smile
KODI Player: Nvidia Shield TV Pro [2019] | Receiver: Marantz SR6013 | TV: LG 55SJ800V | Toaster: Severin AT 2515

How to:
Create custom video nodes like Documentaries, Concerts, Kids etc
 
Reply



Logout Mark Read Team Forum Stats Members Help
Change userrating in KODI db using DB Browser?0
This forum uses Lukasz Tkacz MyBB addons.