Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - lcer

Pages: [1]

Feature Suggestions / Re: Grouping for episodes

« on: June 26, 2010, 10:10:25 pm »

Hallo,

while my database is growing, i'm more and more missing some grouping-feature.

But first it would be nice, to change a movie to a episode manually. If the filescanner misses some episode due to wrong regex I could fix it manually.

thanks

lcer

Feature Suggestions / auto-screenshot from menu

« on: December 30, 2009, 01:17:31 pm »

Hallo forum,

it would be nice to have a menu entry for auto-generating screenshots from the movie-list. This function is already implementen when using the search/import from disk tool and should be easely included into the movie-menu. So the auto-generating could be done later.

Thanks

lcer

Feature Suggestions / Grouping for episodes

« on: December 30, 2009, 01:12:18 pm »

Hallo forum,

I suggest do implement a function to group Episodes into an exsiting Movie. If you import movies form your disk which can not be grouped by the import tool, manual grouping becomes nessesary. I have solved it with a smoll C# program, but it schould be done from context-menu:

Code: [Select]

            // strMID ist the MID of the series-entry in MOVIES
            sqlQuery = "UPDATE MOVIES SET \"series\" = '-1' WHERE \"mid\" = " + strMID + ";";
            rows = PVD.execute(sqlQuery);
            // each line contains the mid of an imported, but not grouped episode
            string[] lines = Regex.Split(this.textBoxEPISODEN.Text, "\r\n");
            foreach (string line in lines)
            {
                sqlQuery = "SELECT gen_id(GEN_EPID,1) FROM RDB$DATABASE ;";
                FbDataReader myReader;
                myReader = PVD.select(sqlQuery);
                while (myReader.Read())
                {
                    strEID = myReader.GetString(0);
                }
                myReader.Close();

                sqlQuery = "INSERT INTO EPISODES (\"epid\", \"mid\", \"epnum\", \"season\") VALUES (" + strEID + ", " + strMID + ", '1', '1');";
                rows = PVD.execute(sqlQuery);

                sqlQuery = "UPDATE MOVIES SET \"epid\" = '" + strEID + "' WHERE \"mid\" = " + "'" + line.Trim() + "'" + ";";
                rows = PVD.execute(sqlQuery);
            }
            PVD.commit();
            PVD.close();

Thanks

lcer