|
|
Kaffeine Media Player forum
|
 |
|
|
|
|
|
|
|
|
| View previous topic :: View next topic |
| Author |
Message |
alansecker
Joined: 24 Feb 2008
Posts: 30
Location: London UK
|
 Posted: Sat Nov 19, 2011 7:19 pm Post subject: Freeview Channels |
 |
|
| If I cannot pick an odd station or two on scanning, is there way of manually editing whatever file Kaffeine stores the channel details in? |
|
| Back to top |
|
 |
mtron
Joined: 31 Jul 2007
Posts: 225
|
| Posted: Mon Nov 21, 2011 8:25 pm Post subject: |
|
|
hello alan!
The kaffeine channel list is a SQLite Databse and is located @ ~/.kde/share/apps/kaffeine/sqlite.db. You can use e.g. the Firefox Addon "Sqlite Manager" https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ to manipulate the db
This is the database table index:
| Code: | - table "Channels"
- column "Id"
- INTEGER PRIMARY KEY
- column "Name"
- string; not empty
- column "Number"
- int; Number >= 1
- column "Source"
- string; not empty
- column "Transponder"
- string; linuxtv format
- column "NetworkId"
- int; -1 <= NetworkId <= 0xffff; from SDT
- column "TransportStreamId"
- int; 0 <= TransportStreamId <= 0xffff; from PAT
- column "PmtPid"
- int; 0 <= PmtPid <= 0x1fff; from PAT
- column "PmtSection"
- byte array; not empty; from PMT
- column "AudioPid"
- int; -1 <= AudioPid <= 0x1fff; from PMT
- column "Flags"
- int; (1 << 0) = has video (from PMT), (1 << 1) = is scrambled (from SDT or VCT)
- table "RecordingSchedule"
- column "Id"
- INTEGER PRIMARY KEY
- column "Name"
- string; not empty
- column "Channel"
- string; not empty
- column "Begin"
- string; ISO 8601 encoded date and time; UTC (ends with 'Z') or local time (older versions)
- column "Duration"
- string; ISO 8601 encoded time
- column "Repeat"
- int; (1 << 0) = on Mondays ... (1 << 6) = on Sundays |
|
|
| Back to top |
|
|
alansecker
Joined: 24 Feb 2008
Posts: 30
Location: London UK
|
| Posted: Fri Apr 27, 2012 12:04 pm Post subject: Freeview Channels |
|
|
I installed SQLite and on inspection found sqlite.db to be empty!
What would the next best move be in your opinion? |
|
| Back to top |
|
|
|
