Hi,
I was trying to modify the contents of the database, something like what was done here
http://forum.kodi.tv/showthread.php?tid=84932
I just want to migrate the folder of my movies, and possibly replace ‘\’ with ‘/’ since I want to move from Windows to Linux
I suspect the link above is for older versions
What I see in the database, for instance in table path is
idPath=3, strPath=c:\Movies1, idParentPath=NULL
idPath=39, strPath=c:\Movies1\folder1, idParentPath=3
I create an entry in Kodi for source c:\Movies2, and scan the movie on folder1. table ‘path’ gets added:
idPath=1901, strPath=c:\Movies2, idParentPath=NULL
idPath=1902, strPath=c:\Movies2\folder1, idParentPath=1901
So since there is one path entry for each movie, I cannot just replace idPath on table files
I guess I could modify path by path. But what is the elgant/good way of doing it?