The location field is a unique key in the db. So... how about this:
Originally Posted by psycik
So in your case, the OfflineID would contain the MediaLabel field, and the Location field would contain the unique generated value.
- The location and offlineID fields default with the generated number. This is basically 'AMC_' + your catalog name + MovieNumber.
- If the MediaLabel field exists
- AND it's value points to an existing file, the location field is updated with this value AND the offlineFlag is set to false
- If value does not point to a file, the offlineID field is set to the MediaLabel value, and the location field is left with the generated value above.
NPVR Server: Win8 / AMD Phenom II X4 965 / 8gRAM / ATI Radeon 7700 Series / Hauppauge 2250
Misc: Multiple Wired-Wireless clients, XMBC Clients, rPI OpenElec client