2017-02-04, 12:39
If you like to move your Watched status over from an older Database
Just update this to point to your new and old Database and Fields
NEWTBL = New Database Table
OLDTBL = Old Database Table
Just update this to point to your new and old Database and Fields
NEWTBL = New Database Table
OLDTBL = Old Database Table
PHP Code:
------------------------------
--- COPY OVER WATCH STATUS ---
------------------------------
SET SQL_SAFE_UPDATES = 0;
UPDATE Kodi_Matt_Video_T_107.global_files AS NEWTBL
INNER JOIN
Kodi_Matt_Video_93.globalfiles AS OLDTBL ON NEWTBL.strFilename = OLDTBL.strFilename
SET
NEWTBL.lastPlayed_U01 = OLDTBL.lastPlayedMatt,
NEWTBL.playCount_U01 = OLDTBL.playCountMatt
WHERE
NEWTBL.strFilename = OLDTBL.strFilename;
SET SQL_SAFE_UPDATES = 1;