[WiP] Centralised database in My Video, My Pictures and folder settings (4 Viewers)

[ajs]

Little speed improvement

Remove the old database, install, run the configurator, imported NFO. Works, no errors. Speed import and enter the plugin Video increased.

 

[hkjensen]

Hi

Strings with singel pling ' is not saved correctly due to the RemoveInvalidChars function
' should not be escaped by another single pling

RemoveInvalidChars should NOT alter strings for mySQL database

For VideoDataBaseADO:
public void RemoveInvalidChars(ref string strTxt)
{
}

 

[regeszter]

Hi

Strings with singel pling ' is not saved correctly due to the RemoveInvalidChars function
' should not be escaped by another single pling

RemoveInvalidChars should NOT alter strings for mySQL database

For VideoDataBaseADO:
public void RemoveInvalidChars(ref string strTxt)
{
}

Can you explain it? Do you have any issue with this?

 

[hkjensen]

Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files
When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv"

Also for GetMovieTitlesByGenre

The query should be changed to :
var query = (from sql in _connection.movieinfoes
join s3 in _connection.genrelinkmovies on sql.idMovie equals s3.idMovie
join s4 in _connection.genres on s3.idGenre equals s4.idGenre
where s4.strGenre == strGenre
orderby sql.strTitle ascending
select sql).ToList();

The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"
sql.strGenre = "Horror / Sci-Fi" dos not get selected with current query
where sql.strGenre == strGenre //|| sql.strGenre.Contains(strGenre) //like?
The Contains(strGenre) could work but using the genrelinkmovies should be faster

 

[regeszter]

Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files
When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv"

Please try this dll.

 

[hkjensen]

Movie with filename "C'est Pas Moi, Je Le Jure! (2008).mkv" get imported and saved as "\C''est Pas Moi, Je Le Jure! (2008)" in table files
When movie is selected in MP (view: title index) Mp can't find file "C''est Pas Moi, Je Le Jure! (2008).mkv"

Please try this dll.

Tested dll and i works only for movie filename
but not for thumbnail

 

[regeszter]

The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"

Can you test this too?

 

[hkjensen]

The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"

Can you test this too?

When I select genre='Horror' i only get listed 8 movies on the right

the list should contain 131 titles (out of 1509), with current select you could end up with a list with no titles.

Select from my database:
select count(*) from movieinfo
where strGenre='Horror'
count=8

select count(*) from movieinfo, genre, genrelinkmovie
where genre.strGenre='Horror' and Genre.idGenre=genrelinkmovie.idGenre and movieinfo.idMovie=genrelinkmovie.idMovie
count=131

 

[regeszter]

The all movies with f.ex genre "Horror" get listet and not only movies with only genre "Horror"

Can you test this too?

When I select genre='Horror' i only get listed 8 movies on the right
View attachment 163393
the list should contain 131 titles (out of 1509), with current select you could end up with a list with no titles.

Select from my database:
select count(*) from movieinfo
where strGenre='Horror'
count=8

select count(*) from movieinfo, genre, genrelinkmovie
where genre.strGenre='Horror' and Genre.idGenre=genrelinkmovie.idGenre and movieinfo.idMovie=genrelinkmovie.idMovie
count=131

Can you send me a backup of the videodatabase for testing?

 

[regeszter]

MediaPortalSetup_1.11.0_2015-04-03-16-34

• Bugfixes