[calisro]

I should be able to do that in a sqllite real quick. This is interesting though. It seems kodi is encoding almost everything. What a mess.

Code:

->$ ls -l /data/Media/Videos/Movies/Lock*/*mp4
Lock,.Stock.and.Two.Smoking.Barrels.(1998).720p.bluray.h264.!@#$%^&*()_+=<>?:";,.\\|`~{}.mp4

Code:

mysql> select url from art where url like '%Lock%fan%';
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| url                                                                                                                                                                                                                                                                                                     |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| davs://xxxxxx/base/Media/Videos/Movies/Lock%2c.Stock.and.Two.Smoking.Barrels.%281998%29.720p.bluray.h2641/Lock%2c.Stock.and.Two.Smoking.Barrels.%281998%29.720p.bluray.h264.%21%40%23%24%25%5e%26%2a%28%29_%2b%3d%3c%3e%3f%3a%22%3b%2c.%5c%5c%7c%60~%7b%7d-fanart.jpg |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql> select * from files where strfilename like '%Lock%';
+--------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------+---------------------+
| idFile | idPath | strFilename                                                                                                                                          | playCount | lastPlayed          | dateAdded           |
+--------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------+---------------------+
|   1864 |    463 | Lock%2c.Stock.and.Two.Smoking.Barrels.%281998%29.720p.bluray.h264.%21%40%23%24%25%5e%26%2a%28%29_%2b%3d%3c%3e%3f%3a%22%3b%2c.%5c%5c%7c%60~%7b%7d.mp4 |      NULL | 2015-07-29 00:00:00 | 2015-08-13 16:34:36 |
+--------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------+---------------------+
1 row in set (0.00 sec)