Delete old Covers and Backdrops no longer in movingpictures.db3 (1 Viewer)

[Knives03]

I haven't had a chance to mess around with this yet, but I have moved my fanart and databases to a separate partition (drive labeled D:\) and was glad to see that you can choose custom locations for cleaning. I will probably try it out sometime later this week and will report back!

 

[Der_Bub]

seems to be a very usefull tool, but I get an error (because I don't use online series):

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
 
************** Exception Text **************
System.Data.SQLite.SQLiteException (0x80004005): SQLite error
no such table: online_series
  at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
  at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
  at System.Data.SQLite.SQLiteDataReader.NextResult()
  at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader()
  at FanartCleaner.FanartCleaner.Process_TVSeries()
  at FanartCleaner.FanartCleaner.Delete_Click(Object sender, EventArgs e)
  at System.Windows.Forms.Control.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ButtonBase.WndProc(Message& m)
  at System.Windows.Forms.Button.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
 
 
************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.239 (RTMGDR.030319-2300)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
FanartCleaner
    Assembly Version: 1.2.0.0
    Win32 Version: 1.2.0.0
    CodeBase: file:///D:/download/FanartCleaner%20v1.2.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.233 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.233 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.235 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data.SQLite
    Assembly Version: 1.0.81.0
    Win32 Version: 1.0.81.0
    CodeBase: file:///D:/download/System.Data.SQLite.DLL
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.233 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
 
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
 
For example:
 
<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>
 
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

 

[m3rcury]

seems to be a very usefull tool, but I get an error (because I don't use online series):

Der_Bub, can you try the attached version below. Should cater for non-usage of either MovingPictures and/or TVSeries.

 

[m3rcury]

Hi all, have managed to produce my very first plugin. In order to have your feedback early, am attaching the beta version here and would be grateful to have your views. Please bear with me as I have only tested it on a 32bit Windows 7 machine. I strongly recommend that on the configuration screen, you choose "Delete to trash" so that if plugin does not work correctly on your setup, you can recover all your images from the trashcan.

The attached rar contains an installer MPCleaner.exe which will install MPCleaner.dll in C:\Program Files\Team MediaPortal\MediaPortal\plugins\process or the path you choose.

From the MediaPortal configuration screen choose Plugins and then under Process, search for MPCleaner:

After pressing Config you will be presented with the following screen:

Once you press save and exit from MediaPortal Configuration by pressing OK, MPCleaner.xml will be created under C:\ProgramData\Team MediaPortal\MediaPortal or your respective directory.

On MediaPortal startup, the plugin should execute in a background thread and delete the images that are no longer in use.

Hope you like it.


Thanks

 

[SpudR]

Thanks for this
Might be worth adding a schedule to run daily/weekly/monthly or sum such, and an option to run if idle...
Also, can you make an MPEI for it?
Nice

 

[m3rcury]

Thanks for this
Might be worth adding a schedule to run daily/weekly/monthly or sum such, and an option to run if idle...
Also, can you make an MPEI for it?
Nice

SpudR, thanks for the suggestions. In the meantime, manged to create an MPE1 installer and is attached above.

 

[SpudR]

Fab

 

[m3rcury]

Uploaded new installer in post #34 where I've added an icon to show in the MediaPortal Extensions and also introduced logging in MediaPortal.log.

Also, started a new forum thread in the Plugins section which can be accessed from here.

 

[m3rcury]

The stable version for MPCleaner v1.0.0.0 plugin can be downloaded from here.

 

[RoChess]

The stable version for MPCleaner v1.0.0.0 plugin can be downloaded from here.

With MediaPortal v1.3.0Alpha close to release, be sure you adjust your assembly.cs file to contain the following:

[assembly: CompatibleVersion("1.2.100.0", "1.1.6.27644")]

So that your plugin is compatible.