got a folder
Found 1 subtiles
Page [1] of [0.1] (Total count => 1)
ID TV Series Movie File Folder Language Type Actions
40 Assassins (1995) Bluray-1080p x264 DTS 5.1.sub /lan/bp-l01/media/movies/A/Assassins (1995) Unknown sub Raw | View | Edit | Delete | Translate | Set TV Series | Set Movie
Page [1] of [0.1] (Total count => 1)
=========================
=== DEBUG INFORMATION ===
=========================
Array ( [tables] => Array ( [subfiles] => subfiles [tvseries] => tv_series [movies] => movies [languages] => languages ) [sub_fields] => Array ( [0] => file_id [1] => file_name [2] => folder [3] => language [4] => type [5] => tv_series_id [6] => movie_id ) [tv_fields] => Array ( [0] => tv_id [1] => name as sName [2] => synopses as sSynopses [3] => genres as sGenre [4] => imdb_id as sImdb_id [5] => tmdb_id as sTmdb_id [6] => tvdb_id as sTvdb_id [7] => trakt_id as sTrakt_id ) [movie_fields] => Array ( [0] => movie_id [1] => name as mName [2] => synopses as mSynopses [3] => genres as mGenre [4] => imdb_id as mImdb_id [5] => tmdb_id as mTmdb_id [6] => tvdb_id as mTvdb_id [7] => trakt_id as mTrakt_id ) [lFields] => Array ( [0] => lang_id [1] => language [2] => lang_patterns [3] => displayed as lang_display ) [join] => Array ( [iTable] => Array ( [0] => tv_series [1] => movies [2] => languages ) [iField] => Array ( [0] => tv_id [1] => movie_id [2] => lang_id ) [mTable] => Array ( [0] => subfiles [1] => subfiles [2] => subfiles ) [mField] => Array ( [0] => tv_series_id [1] => movie_id [2] => language ) ) [query_fields] => Array ( [0] => `subfiles`.`file_id` [1] => `subfiles`.`file_name` [2] => `subfiles`.`folder` [3] => `subfiles`.`language` [4] => `subfiles`.`type` [5] => `subfiles`.`tv_series_id` [6] => `subfiles`.`movie_id` [7] => `tv_series`.`tv_id` [8] => `tv_series`.`name` as sName [9] => `tv_series`.`synopses` as sSynopses [10] => `tv_series`.`genres` as sGenre [11] => `tv_series`.`imdb_id` as sImdb_id [12] => `tv_series`.`tmdb_id` as sTmdb_id [13] => `tv_series`.`tvdb_id` as sTvdb_id [14] => `tv_series`.`trakt_id` as sTrakt_id [15] => `movies`.`movie_id` [16] => `movies`.`name` as mName [17] => `movies`.`synopses` as mSynopses [18] => `movies`.`genres` as mGenre [19] => `movies`.`imdb_id` as mImdb_id [20] => `movies`.`tmdb_id` as mTmdb_id [21] => `movies`.`tvdb_id` as mTvdb_id [22] => `movies`.`trakt_id` as mTrakt_id [23] => `languages`.`lang_id` [24] => `languages`.`language` [25] => `languages`.`lang_patterns` [26] => `languages`.`displayed` as lang_display ) [qWhere] => Array ( [0] => `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassins (1995)%' ) [db_subfiles] => Array ( [sql] => SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassins (1995)%' ORDER BY file_id ASC LIMIT 1, 50 [success] => 1 [row_count] => 1 [new_sql] => SELECT `subfiles`.`file_id`, `subfiles`.`file_name`, `subfiles`.`folder`, `subfiles`.`language`, `subfiles`.`type`, `subfiles`.`tv_series_id`, `subfiles`.`movie_id`, `tv_series`.`tv_id`, `tv_series`.`name` as sName, `tv_series`.`synopses` as sSynopses, `tv_series`.`genres` as sGenre, `tv_series`.`imdb_id` as sImdb_id, `tv_series`.`tmdb_id` as sTmdb_id, `tv_series`.`tvdb_id` as sTvdb_id, `tv_series`.`trakt_id` as sTrakt_id, `movies`.`movie_id`, `movies`.`name` as mName, `movies`.`synopses` as mSynopses, `movies`.`genres` as mGenre, `movies`.`imdb_id` as mImdb_id, `movies`.`tmdb_id` as mTmdb_id, `movies`.`tvdb_id` as mTvdb_id, `movies`.`trakt_id` as mTrakt_id, `languages`.`lang_id`, `languages`.`language`, `languages`.`lang_patterns`, `languages`.`displayed` as lang_display FROM subfiles LEFT JOIN tv_series ON `subfiles`.`tv_series_id` = `tv_series`.`tv_id` LEFT JOIN movies ON `subfiles`.`movie_id` = `movies`.`movie_id` LEFT JOIN languages ON `subfiles`.`language` = `languages`.`lang_id` WHERE `subfiles`.`folder` LIKE '%/lan/bp-l01/media/movies/A/Assassins (1995)%' ORDER BY file_id ASC LIMIT 1, 50 [time] => Array ( [start] => 1782038798.1255 [end] => 1782038798.1337 [exec] => 0.0081400871276855 ) [results] => Array ( [0] => Array ( [file_id] => 40 [file_name] => Assassins (1995) Bluray-1080p x264 DTS 5.1.sub [folder] => /lan/bp-l01/media/movies/A/Assassins (1995) [language] => [type] => sub [tv_series_id] => 0 [movie_id] => [tv_id] => [sName] => [sSynopses] => [sGenre] => [sImdb_id] => [sTmdb_id] => [sTvdb_id] => [sTrakt_id] => [mName] => [mSynopses] => [mGenre] => [mImdb_id] => [mTmdb_id] => [mTvdb_id] => [mTrakt_id] => [lang_id] => [lang_patterns] => [lang_display] => ) ) [pagination] => Array ( [max_rows] => 50 [start] => 51 [current_page] => 1.02 [first_page] => 1 [next_page] => 2.02 [prev_page] => 0.02 [last_page] => 1 [total_rows] => 2 ) ) ) =========================