Release Rejected - English is wanted but found Dutch

[Mirx_NL]

This is what I ended up doing. Works like a charm. You could either include it in the retrieve.php of spotweb, or schedule them separately.

Just to note, proper multi-language support is still on the table on github, but it would still fail due to the series naming.

@Mirx_NL

I ended up scheduling 3 SQL queries in myphpadmin. Couldn’t manage to get it into a single update command. Nested replace only works with select, and my version of MariaDB does not support regex and wildcards.

I used spotterid instead of poster to limit enabling spam in Sonarr.

Remove NL Subs from QoQ Series:UPDATE spots SET title= REPLACE (title, ’ NLSubs ', ’ ') WHERE spotterid = ‘C7w1uw’ AND subcatz = ‘z1|’

Remove (2015) from QoQ Series:UPDATE spots SET title= REPLACE (title, ‘(2015)’, ‘’) WHERE spotterid = ‘C7w1uw’ AND subcatz = ‘z1|’

Remove (2016) from QoQ Series:UPDATE spots SET title= REPLACE (title, ‘(2016)’, ‘’) WHERE spotterid = ‘C7w1uw’ AND subcatz = ‘z1|’