2013-05-28, 11:59
(2013-05-28, 11:34)Jandalf Wrote: SELECT c00, c09 FROM movie WHERE c09='';
gives me only 1 movie.
the movies where i'm missing correct votes have the IMDB ID.
could there be a problem with your LIMIT statement in your SQL query?
Code:
def listing( self ):
Movies = []
match = RawXbmcDb.query( 'SELECT idMovie FROM movie' )
total = len( match )
match = RawXbmcDb.query( 'SELECT c00, c09, c04, c05 FROM movie WHERE c09!="" ORDER BY c00 ASC LIMIT %s, %s' % ( str( self.Resume ), str( total ) ) )
for base in match: Movies.append( ( base[0], base[1], base[2], base[3] ) )
return Movies
Checks in the script folder under userdata/addon_data/
The resume_movies file contain the value of self.Resume, also you can delete the file to restore the initial settings.
The script should ask you if you want resume when the resume_movies file is present and at the end it sum the temporary total value with the resume value to get the total of the movies.