bookmark.db

Página 2 de 8. Precedente  1, 2, 3, 4, 5, 6, 7, 8  Siguiente

Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Jue Ene 06, 2011 10:43 am

woww
many tables in that db ..... bookmark

sqlite> .tables
DB_VERSION_CONTROL SetupKeyValue SetupVCRPlusChMap
SetupAvailableLang SetupTVChannelInfo SetupWlan0Profile
SetupAvailableRegion SetupTVRatingType tParameter




I have listed the contents of all tables,
it seems there is no limit in the size of records...
so probably we can add a new record for our Recent_Play file, instead of reusing ...

or the other way round ...
what did you do? reuse ? then try inserting new row



Código:

sqlite> select * from DB_VERSION_CONTROL;
sqlite> select * from SetupKeyValue;
1|SETUP_MAJOR_MODEL|3850
2|SETUP_MINOR_MODEL|31
sqlite> select * from SetupVCRPlusChMap; 
sqlite> select * from SetupAvailableLang;
1|0|10
1|5|20
1|3|30
1|4|40
1|6|50
1|8|60
1|11|70
sqlite> select * from SetupTVChannelInfo;
sqlite> select * from SetupWlan0Profile;
sqlite> select * from SetupAvailableRegion;
1|2|10
1|3|20
1|9|30
1|10|40
1|14|50
1|17|60
1|18|70
1|21|80
1|25|90
1|26|100
1|28|110
sqlite> select * from SetupTVRatingType;
sqlite> select * from tParameter;
1|DB_VERSION|1
2|DB_DEVELOP_VERSION|6
3|SETUP_INIT|1
4|RESTORE_DEFAULT_FROM_DB|0
5|0m�M
6|0k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Shreky Movie_20101205_2210.ts
7|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Shreky Movie_20101205_2210.ts|B
8|1m|M
9|1k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Presentación 3MSC_20101202_2201.ts
10|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Presentación 3MSC_20101202_2201.ts|�4
11|2m|�TM
12|2k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Un perdedor con suerte_20101211_2353.ts
13|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Un perdedor con suerte_20101211_2353.ts|�

14|3m|`:M
15|3k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/AMAZING SPIEZ!_20101212_1118.ts
16|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/AMAZING SPIEZ!_20101212_1118.ts|0
17|4m|�ZM
18|4k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_El_mejor_dia_de_mi_vida.ts
19|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_El_mejor_dia_de_mi_vida.ts|�
20|5m|��M
21|5k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2027.ts
23|6m|��M
24|6k|fileset:///tmp/ramfs/volumes/USB ( C: )/Kung_fu_panda.avi
25|fileset:///tmp/ramfs/volumes/USB ( C: )/Kung_fu_panda.avi|�A
26|7m|�   M
27|7k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/SWAT.ts
28|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/SWAT.ts|
29|8m|��M
30|8k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_El ladron rosa.ts
32|9m|8{
M
33|9k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Carta para Sweaper.ts
34|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Carta para Sweaper.ts|�
35|10m|��
M
36|10k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The last templar1.avi
37|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The last templar1.avi|%U
38|11m|K�
        M
39|11k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/ArtAttack/Art Attack. Presentador_ Jordi Cruz_20100207_0159.ts
41|12m|��M
42|12k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Amar_a_ina_hamburguesa.ts
43|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Amar_a_ina_hamburguesa.ts|)
44|13m|�
        M
45|13k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The Code.ts
46|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The Code.ts|
48|14m|7v
        M
49|14k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'EL RETO DE ACUARIOS'_20101018_1555.ts
50|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'EL RETO DE ACUARIOS'_20101018_1555.ts|
M1|15m|xd
52|15k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2333.ts
54|fileset:///tmp/ramfs/volumes/HDD ( Internal )/ArtAttack/Art Attack. Presentador_ Jordi Cruz_20100207_0159.ts|
M5|16m|fl
56|16k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Hispania_20101215_2238.ts
57|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Hispania_20101215_2238.ts|�

M8|17m|Z
59|17k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2242.ts
60|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2242.ts|
61|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2333.ts|
M2|18m|
63|18k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/HÉRCULES_20101218_2143.ts
64|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/HÉRCULES_20101218_2143.ts|�
M5|19m|�
66|19k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BabyEinstein/Neptune.mkv
67|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BabyEinstein/Neptune.mkv|
68|20m|+PM
69|20k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Jefe_Bob.ts
70|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Jefe_Bob.ts|H
71|21m|+M
72|21k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Kung_fu_panda.avi
73|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Kung_fu_panda.avi|�
75|22m|#M
76|22k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dinosaur_King/DINOSAUR_KING_ JUEGO DE NINOS.ts
77|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dinosaur_King/DINOSAUR_KING_ JUEGO DE NINOS.ts|
78|23m|�FM
79|23k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Codigo_CarloMagno.ts
80|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Codigo_CarloMagno.ts|W%
81|24m|�XM
82|24k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100417_1747.ts
83|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100417_1747.ts|?
84|25m|NYM
85|25k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Trituradores_crustaceo.ts
86|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Trituradores_crustaceo.ts|
87|26m|�M
88|26k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Anormal.ts
89|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Anormal.ts|
90|27m|�M
91|27k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/ROBO.ts
93|28m|t�M
94|28k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100410_1831.ts
95|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100410_1831.ts|
96|29m|�M
97|29k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Algas_Verdes.ts
98|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Algas_Verdes.ts|
99|30m|��M
100|30k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Sexo en Nueva York.ts
102|31m|�M
103|31k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1552.ts
104|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1552.ts|a
105|32m|L�M
106|32k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100408_1338.ts
107|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100408_1338.ts|
108|33m|��M
109|33k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Arandanos.ts
110|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Arandanos.ts|
111|34m|�7M
112|34k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101111_2023.ts
113|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101111_2023.ts|
114|35m|�#M
115|35k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1111.ts
116|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1111.ts|
117|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2027.ts|�
118|36m|�fM
119|36k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Especiales Peanuts_20101226_2231.ts
121|37m|�M
122|37k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Minzy, más allá de la imaginación_20101218_2200.ts
123|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Minzy, más allá de la imaginación_20101218_2200.ts|(
124|38m|��M
125|38k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2136.ts
126|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2136.ts|T
127|39m|/�M
128|39k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'RECUERDOS DE RIO'_20100930_1859.ts
129|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'RECUERDOS DE RIO'_20100930_1859.ts|�
130|40m|�}M
131|40k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101223_2241.ts
132|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101223_2241.ts|�
133|41m|��M
134|41k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ La última legión_20101221_2215.ts
135|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ La última legión_20101221_2215.ts|
136|42m|�>M
137|42k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101224_0025.ts
138|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101224_0025.ts|
139|43m|��M
140|43k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Blizzard. El Reno Mágico_20101224_2128.ts
141|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Blizzard. El Reno Mágico_20101224_2128.ts|2
142|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Sexo en Nueva York.ts|0
143|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Especiales Peanuts_20101226_2231.ts|�
144|44m|3bM
145|44k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Casa_Elegante.ts
147|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_El ladron rosa.ts|�
148|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/ROBO.ts|W
149|45m|��M
150|45k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Tren Chuu Chuu.ts
151|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Tren Chuu Chuu.ts|
152|46m|�M
153|46k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Bob Esponja_20101128_1518.ts
154|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Bob Esponja_20101128_1518.ts|E
155|47m|X�M
156|47k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101031_2127.ts
157|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101031_2127.ts|
158|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Casa_Elegante.ts|+
159|48m|��!M
160|48k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Noticias fin de semana_20110101_2155.ts
161|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Noticias fin de semana_20110101_2155.ts|u
162|49m|��$M
163|49k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/300.ts
165|50m|��!M
166|50k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20101229_2156.ts
167|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20101229_2156.ts|U
168|51m|�!M
169|51k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/JEWELPET_20101228_1305.ts
170|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/JEWELPET_20101228_1305.ts|
171|52m|1#M
172|52k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Toy_Story_2.ts
173|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Toy_Story_2.ts|
174|53m|;'#M
175|53k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Transporter3.ts
176|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Transporter3.ts|

177|54m|�x$M
178|54k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_astilla.ts
180|55m|#�$M
181|55k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts
182|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts|p
183|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/300.ts|�
184|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_astilla.ts|
185|56m�$M
186|56k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_Pelicula.avi
187|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_Pelicula.avi|��
188|57m|8�$M
189|57k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/INFORMATIVOS TELECINCO_20110104_2155.ts
190|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/INFORMATIVOS TELECINCO_20110104_2155.ts|B
191|58m|
        %M
192|58k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20110105_2155.ts
193|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20110105_2155.ts|�
sqlite>


And the schema in case needed
Código:

sqlite> .schema
CREATE TABLE DB_VERSION_CONTROL(
    id INTEGER PRIMARY KEY,
    Version NUMERIC,
    CmdOrder NUMERIC,
    CmdSQL TEXT
);
CREATE TABLE SetupAvailableLang(
    type NUMERIC,
    Language_id NUMERIC,
    sOrder NUMERIC,
    Primary Key(type,Language_id)
);
CREATE TABLE SetupAvailableRegion(
    type NUMERIC,
    Region_id NUMERIC,
    sOrder NUMERIC,
    Primary Key(type,Region_id)
);
CREATE TABLE SetupKeyValue (
    id INTEGER PRIMARY KEY,
    Key TEXT,
    Value BLOB,
    UNIQUE(Key)
);
CREATE TABLE SetupTVChannelInfo(
    id INTEGER PRIMARY KEY,
    Status NUMERIC,
    Standard NUMERIC,
    CNI_STATION BLOB,
    Freq NUMERIC,
    Name TEXT,
    Favorite NUMERIC,
    PayTv  NUMERIC
);
CREATE TABLE SetupTVRatingType(
    RatingLevel INTEGER PRIMARY KEY,
    RatingType NUMERIC
);
CREATE TABLE SetupVCRPlusChMap(
    GCN_Ch INTEGER PRIMARY KEY,
    Received_Source NUMERIC,
    Received_Ch NUMERIC
);
CREATE TABLE SetupWlan0Profile(
    id INTEGER PRIMARY KEY,
    Name TEXT,
    Mode NUMERIC,
    DHCP_enable NUMERIC,
    IP NUMERIC,
    MASK NUMERIC,
    GATEWAY NUMERIC,
    APNAME TEXT,
    SECURITY NUMERIC,
    WEP_KEY TEXT,
    ACTIVE_WEP_KEY NUMERIC,
    DNS NUMERIC,
    DHCPD_HostIP NUMERIC,
    DHCPD_StartIP NUMERIC,
    DHCPD_EndIP NUMERIC
);
CREATE TABLE tParameter (id INTEGER PRIMARY KEY, fKey TEXT, fValue BLOB);
CREATE UNIQUE INDEX iParameter_1 ON tParameter(fKey ASC);

vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Jue Ene 06, 2011 10:57 am

Question George,
ln -f did not work in your system,
but because
1. ln -f not supported in UFS (your disk)
2. because of the strange chars ' ', ( , and others
try something simple as ln -f Film1.ts test.ts

Because i think the link is the best solution, better than copy
vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Jue Ene 06, 2011 12:32 pm

vic1972 escribió:woww
many tables in that db ..... bookmark

sqlite> .tables
DB_VERSION_CONTROL SetupKeyValue SetupVCRPlusChMap
SetupAvailableLang SetupTVChannelInfo SetupWlan0Profile
SetupAvailableRegion SetupTVRatingType tParameter




I have listed the contents of all tables,
it seems there is no limit in the size of records...
so probably we can add a new record for our Recent_Play file, instead of reusing ...

or the other way round ...
what did you do? reuse ? then try inserting new row



Código:

sqlite> select * from DB_VERSION_CONTROL;
sqlite> select * from SetupKeyValue;
1|SETUP_MAJOR_MODEL|3850
2|SETUP_MINOR_MODEL|31
sqlite> select * from SetupVCRPlusChMap; 
sqlite> select * from SetupAvailableLang;
1|0|10
1|5|20
1|3|30
1|4|40
1|6|50
1|8|60
1|11|70
sqlite> select * from SetupTVChannelInfo;
sqlite> select * from SetupWlan0Profile;
sqlite> select * from SetupAvailableRegion;
1|2|10
1|3|20
1|9|30
1|10|40
1|14|50
1|17|60
1|18|70
1|21|80
1|25|90
1|26|100
1|28|110
sqlite> select * from SetupTVRatingType;
sqlite> select * from tParameter;
1|DB_VERSION|1
2|DB_DEVELOP_VERSION|6
3|SETUP_INIT|1
4|RESTORE_DEFAULT_FROM_DB|0
5|0m�M
6|0k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Shreky Movie_20101205_2210.ts
7|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Shreky Movie_20101205_2210.ts|B
8|1m|M
9|1k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Presentación 3MSC_20101202_2201.ts
10|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Presentación 3MSC_20101202_2201.ts|�4
11|2m|�TM
12|2k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Un perdedor con suerte_20101211_2353.ts
13|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ Un perdedor con suerte_20101211_2353.ts|�

14|3m|`:M
15|3k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/AMAZING SPIEZ!_20101212_1118.ts
16|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/AMAZING SPIEZ!_20101212_1118.ts|0
17|4m|�ZM
18|4k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_El_mejor_dia_de_mi_vida.ts
19|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_El_mejor_dia_de_mi_vida.ts|�
20|5m|��M
21|5k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2027.ts
23|6m|��M
24|6k|fileset:///tmp/ramfs/volumes/USB ( C: )/Kung_fu_panda.avi
25|fileset:///tmp/ramfs/volumes/USB ( C: )/Kung_fu_panda.avi|�A
26|7m|�   M
27|7k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/SWAT.ts
28|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/SWAT.ts|
29|8m|��M
30|8k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_El ladron rosa.ts
32|9m|8{
M
33|9k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Carta para Sweaper.ts
34|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Carta para Sweaper.ts|�
35|10m|��
M
36|10k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The last templar1.avi
37|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The last templar1.avi|%U
38|11m|K�
        M
39|11k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/ArtAttack/Art Attack. Presentador_ Jordi Cruz_20100207_0159.ts
41|12m|��M
42|12k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Amar_a_ina_hamburguesa.ts
43|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Amar_a_ina_hamburguesa.ts|)
44|13m|�
        M
45|13k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The Code.ts
46|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/The Code.ts|
48|14m|7v
        M
49|14k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'EL RETO DE ACUARIOS'_20101018_1555.ts
50|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'EL RETO DE ACUARIOS'_20101018_1555.ts|
M1|15m|xd
52|15k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2333.ts
54|fileset:///tmp/ramfs/volumes/HDD ( Internal )/ArtAttack/Art Attack. Presentador_ Jordi Cruz_20100207_0159.ts|
M5|16m|fl
56|16k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Hispania_20101215_2238.ts
57|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Hispania_20101215_2238.ts|�

M8|17m|Z
59|17k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2242.ts
60|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2242.ts|
61|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101216_2333.ts|
M2|18m|
63|18k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/HÉRCULES_20101218_2143.ts
64|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/HÉRCULES_20101218_2143.ts|�
M5|19m|�
66|19k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BabyEinstein/Neptune.mkv
67|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BabyEinstein/Neptune.mkv|
68|20m|+PM
69|20k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Jefe_Bob.ts
70|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Jefe_Bob.ts|H
71|21m|+M
72|21k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Kung_fu_panda.avi
73|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Kung_fu_panda.avi|�
75|22m|#M
76|22k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dinosaur_King/DINOSAUR_KING_ JUEGO DE NINOS.ts
77|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dinosaur_King/DINOSAUR_KING_ JUEGO DE NINOS.ts|
78|23m|�FM
79|23k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Codigo_CarloMagno.ts
80|fileset:///tmp/ramfs/volumes/HDD ( Internal )/movie/Codigo_CarloMagno.ts|W%
81|24m|�XM
82|24k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100417_1747.ts
83|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100417_1747.ts|?
84|25m|NYM
85|25k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Trituradores_crustaceo.ts
86|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Trituradores_crustaceo.ts|
87|26m|�M
88|26k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Anormal.ts
89|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Anormal.ts|
90|27m|�M
91|27k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/ROBO.ts
93|28m|t�M
94|28k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100410_1831.ts
95|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100410_1831.ts|
96|29m|�M
97|29k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Algas_Verdes.ts
98|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Algas_Verdes.ts|
99|30m|��M
100|30k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Sexo en Nueva York.ts
102|31m|�M
103|31k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1552.ts
104|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1552.ts|a
105|32m|L�M
106|32k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100408_1338.ts
107|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Cristal_Gawain/El Cristal De Gawayn _ The Questers_20100408_1338.ts|
108|33m|��M
109|33k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Arandanos.ts
110|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Arandanos.ts|
111|34m|�7M
112|34k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101111_2023.ts
113|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101111_2023.ts|
114|35m|�#M
115|35k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1111.ts
116|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Bucea_Ollie/¡bucea Olly!_20100427_1111.ts|
117|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2027.ts|�
118|36m|�fM
119|36k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Especiales Peanuts_20101226_2231.ts
121|37m|�M
122|37k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Minzy, más allá de la imaginación_20101218_2200.ts
123|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Minzy, más allá de la imaginación_20101218_2200.ts|(
124|38m|��M
125|38k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2136.ts
126|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101109_2136.ts|T
127|39m|/�M
128|39k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'RECUERDOS DE RIO'_20100930_1859.ts
129|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BeyBlade/BEYBLADE METAL FUSION_ 'RECUERDOS DE RIO'_20100930_1859.ts|�
130|40m|�}M
131|40k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101223_2241.ts
132|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101223_2241.ts|�
133|41m|��M
134|41k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ La última legión_20101221_2215.ts
135|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Cine_ La última legión_20101221_2215.ts|
136|42m|�>M
137|42k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101224_0025.ts
138|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/CASTLE (T2)_20101224_0025.ts|
139|43m|��M
140|43k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Blizzard. El Reno Mágico_20101224_2128.ts
141|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Blizzard. El Reno Mágico_20101224_2128.ts|2
142|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/El peliculón_ Sexo en Nueva York.ts|0
143|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Especiales Peanuts_20101226_2231.ts|�
144|44m|3bM
145|44k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Casa_Elegante.ts
147|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_El ladron rosa.ts|�
148|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/ROBO.ts|W
149|45m|��M
150|45k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Tren Chuu Chuu.ts
151|fileset:///tmp/ramfs/volumes/HDD ( Internal )/Dora/Dora Tren Chuu Chuu.ts|
152|46m|�M
153|46k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Bob Esponja_20101128_1518.ts
154|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Bob Esponja_20101128_1518.ts|E
155|47m|X�M
156|47k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101031_2127.ts
157|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob Esponja_20101031_2127.ts|
158|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_Casa_Elegante.ts|+
159|48m|��!M
160|48k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Noticias fin de semana_20110101_2155.ts
161|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Noticias fin de semana_20110101_2155.ts|u
162|49m|��$M
163|49k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/300.ts
165|50m|��!M
166|50k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20101229_2156.ts
167|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20101229_2156.ts|U
168|51m|�!M
169|51k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/JEWELPET_20101228_1305.ts
170|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/JEWELPET_20101228_1305.ts|
171|52m|1#M
172|52k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Toy_Story_2.ts
173|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Toy_Story_2.ts|
174|53m|;'#M
175|53k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Transporter3.ts
176|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Transporter3.ts|

177|54m|�x$M
178|54k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_astilla.ts
180|55m|#�$M
181|55k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts
182|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts|p
183|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/300.ts|�
184|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_astilla.ts|
185|56m�$M
186|56k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_Pelicula.avi
187|fileset:///tmp/ramfs/volumes/HDD ( Internal )/BobEsponja/Bob_Esponja_La_Pelicula.avi|��
188|57m|8�$M
189|57k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/INFORMATIVOS TELECINCO_20110104_2155.ts
190|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/INFORMATIVOS TELECINCO_20110104_2155.ts|B
191|58m|
        %M
192|58k|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20110105_2155.ts
193|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Antena 3 Noticias 2_20110105_2155.ts|�
sqlite>

You are right, there are quite interesting tables in that db file Wink

Structure for resume playing in tParameter is quite easy (xx - number):
1. row: xxm -> BLOB (I think that data in this BLOB store the resume playing information actually)
2. row xxk -> BLOB (URI/filename)
3. URI/filename -> BLOB (first 4 bytes: resume playing time in "plain" form, second 4 bytes: ???, last bytes: maybe something like ID (it seems to be still same for the same file). Notice: for non .ts file (eg mpg) there are first 4 bytes only there

So I will continue to investigate in the evening ...

George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Jue Ene 06, 2011 12:51 pm

vic1972 escribió:Question George,
ln -f did not work in your system,
but because
1. ln -f not supported in UFS (your disk)
2. because of the strange chars ' ', ( , and others
try something simple as ln -f Film1.ts test.ts

Because i think the link is the best solution, better than copy

Well,
ln -f seems to work on ufs actually, the problem is with the "strange" chars which could be solved by escaping.


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Jue Ene 06, 2011 6:54 pm

Very good Smile
So, we will continue for the moment with the links.

AHHH
Today I release one thing, bad news I am afraid.
In REC folder, only appears .ts files Sad
If you place there a .avi , it will not appear Sad
So, we need a workaround for the workaround Wink



vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 2:22 am

vic1972 escribió:Very good Smile
So, we will continue for the moment with the links.

AHHH
Today I release one thing, bad news I am afraid.
In REC folder, only appears .ts files Sad
If you place there a .avi , it will not appear Sad
So, we need a workaround for the workaround Wink




You are right, but I tried to change file extension for MPEG file from .mpg to .ts and I copied it to REC folder and it worked, so it could be a solution ... (well, I didn't tested other formats like .avi etc.)


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 2:58 am

The change of resume playing seems to work Very Happy

The problem is that the DVDPlayer uses cached bookmark.db in /tmp/ramfs/ so it is needed to make changes there, not in /usr/local/etc/dvdplayer/bookmark.db (I hope that changing the file at ramfs won't cause any data inconsistences). I also learned the meaning of the first BLOB, so the structure is following:

1st row: xxm -> BLOB - modify time as unix timestamp (last time where the playing was interrupted).
2nd row: xxk -> BLOB - URI/filename
3rd row: URI/filename -> BLOB - first 4 bytes: resume playing time in seconds (probably also unix timestamp), second 4 bytes: maybe some transport stream synchro data ???, last bytes: maybe something like ID (it seems to be still same for the same file). For non .ts file (eg mpg) there are first 4 bytes only there
Notice: in BLOB there is a little endian byte order (which maybe doesn't matter in case of using some db tool)

In one case I encountered the problem with changing the resume playing time in .ts file - although the playing resumed at the correct time, there was a black screen only. I had to jump ahead by right arrow to fix it - I think that it could be caused by something like "desynchronization" of transport stream so the second 4 bytes in the 3rd row's BLOB could manage it. But it will take some further investigation ...



George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 9:51 am

George2005 escribió:So I have done some investigation and I have realized that the resume playing times are stored in /usr/local/etc/dvdplayer/bookmark.db, table: "tParameter", column: "fValue". In record with appropriate fullname there is a BLOB whose the first 4 bytes store resume playing time in seconds - see picture:

bookmark.db - Página 2 Lg3


Hi,
which program do you use to navigate the sqlite3 db?
Your image seems very nice, is that within firefox webbrowser ...?

I am in linux, and using the ugly command line interface ..... Sad

vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 10:18 am

vic1972 escribió:
George2005 escribió:So I have done some investigation and I have realized that the resume playing times are stored in /usr/local/etc/dvdplayer/bookmark.db, table: "tParameter", column: "fValue". In record with appropriate fullname there is a BLOB whose the first 4 bytes store resume playing time in seconds - see picture:

bookmark.db - Página 2 Lg3


Hi,
which program do you use to navigate the sqlite3 db?
Your image seems very nice, is that within firefox webbrowser ...?

I am in linux, and using the ugly command line interface ..... Sad


Yes, I use firefox add-on called SQLite Manager (https://addons.mozilla.org/cs/firefox/addon/5817/)


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 11:01 am

Thanks,
pity, with my actual firefox3.5.9 cannot install that plugin.

Anyway, I use the hex parameter to select the fValue column,
and get something like:
154|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Bob Esponja_20101128_1518.ts|45020000430F02008CA6D58E01000000
Which is enogh!! Smile

So, second field parameter is the filename, always start with fileset.
And third field is fValue BLOB.
How did you find out the offset is stored in the first four bytes?
Where could we found more info regarding this table, or this BLOB field ... ?
I have tried google with no much results ... Sad



vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 11:07 am

George2005 escribió:

You are right, but I tried to change file extension for MPEG file from .mpg to .ts and I copied it to REC folder and it worked, so it could be a solution ... (well, I didn't tested other formats like .avi etc.)


I will have to test again.
I remember that this .avi linked to .ts in REC folder, launched an error in display like codec not supported, or something like that,
Press OK to continue.

I will test also later, I am away now Smile

As pressing OK while playing a movie, I think we can send OK twice,
one for resuming play, and a second time just in case this message appear.....




vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  George2005 el Vie Ene 07, 2011 11:19 am

vic1972 escribió:Thanks,
pity, with my actual firefox3.5.9 cannot install that plugin.

Anyway, I use the hex parameter to select the fValue column,
and get something like:
154|fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/Bob Esponja_20101128_1518.ts|45020000430F02008CA6D58E01000000
Which is enogh!! Smile

So, second field parameter is the filename, always start with fileset.
And third field is fValue BLOB.
How did you find out the offset is stored in the first four bytes?
Where could we found more info regarding this table, or this BLOB field ... ?
I have tried google with no much results ... Sad




Well, you can go here: http://code.google.com/p/sqlite-manager/, where is an older version compatible with firefox 3.5.

Unfortunately, I also haven't found any information of that table elsewhere on the Internet so I had to compare BLOB values with the resume times which I had "set" on LG manually before. Then I found out, that time resume time is stored in the 3rd row's BLOB. The 2rd row's BLOB is filename and the 1st row's BLOB is modify time (unix timestamp of last playing interruption). But the trick is use the /tmp/ramfs/bookmark.db (see my previous post) - which seems to work Very Happy


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 5:45 pm

I have doing some testing:
1:30 = 90sec -> 0x5A INSERT INTO "someTable" VALUES ("7","5A0000000A9100000BC5765301000000");
2:00 = 120sec -> 0x78 INSERT INTO "someTable" VALUES ("7","78000000BBBD00000BC5765301000000");
4:41 = 281sec -> 0x119 INSERT INTO "someTable" VALUES ("7","1901000016A201000BC5765301000000");
1H1min11sec= INSERT INTO "someTable" VALUES ("7","570E000098B10F000BC5765301000000");
61x60=3671sec=0xE57

So, is the total number of seconds, converted into hexa, and then reverse writen in the DB Smile

Anyway, i think we are just going to copy these value.
The mistery are the rest of bytes...
vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 6:00 pm

OK,
mechanism seems to be working fine,
I have edited last entry (Original file), changing filename to RecentFile.ts
then executed REcentFile.ts
and it started where original file stopped!!!! Smile

I can edit rows with sqlite manager,but cannot duplicate entries or create entries, can you?

Strange,
this sql should work:
INSERT INTO tParameter VALUES (11,"fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts","BLOB (Size: 16)");

sure i can doing somehting wrong...Wink


Última edición por vic1972 el Vie Ene 07, 2011 6:03 pm, editado 1 vez
vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 6:02 pm

vic1972 escribió:I have doing some testing:
1:30 = 90sec -> 0x5A INSERT INTO "someTable" VALUES ("7","5A0000000A9100000BC5765301000000");
2:00 = 120sec -> 0x78 INSERT INTO "someTable" VALUES ("7","78000000BBBD00000BC5765301000000");
4:41 = 281sec -> 0x119 INSERT INTO "someTable" VALUES ("7","1901000016A201000BC5765301000000");
1H1min11sec= INSERT INTO "someTable" VALUES ("7","570E000098B10F000BC5765301000000");
61x60=3671sec=0xE57

So, is the total number of seconds, converted into hexa, and then reverse writen in the DB Smile

Anyway, i think we are just going to copy these value.
The mistery are the rest of bytes...

Exactly! As I posted before, the so far known structure for one file in tParameter table in /tmp/ramfs/bookmark.db is following:

1st row: xxm -> BLOB - modify time as unix timestamp (last time where the playing was interrupted).
2nd row: xxk -> BLOB - URI/filename
3rd row: URI/filename -> BLOB - first 4 bytes: resume playing time in seconds (probably also unix timestamp), second 4 bytes: maybe some transport stream synchro data ???, last bytes: maybe something like ID (it seems to be still same for the same file). For non .ts file (eg mpg) there are first 4 bytes only there
Notice: in BLOB there is a little endian byte order (which maybe doesn't matter in case of using some db tool)

I will try to investigate the meaning of rest of bytes in the 3rd row's BLOB ...



George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 6:07 pm

OK

I am not quite sure If I understand you well, when you say:

1st row: xxm -> BLOB - modify time as unix timestamp (last time where the playing was interrupted).
2nd row: xxk -> BLOB - URI/filename
3rd row: URI/filename -> BLOB - first 4 bytes: resume playing time in seconds (probably also unix timestamp), second 4 bytes: maybe

what do you mean with first row?
you men the first column id ..?
what is xxm? any minutes, right?
and xxk ? what is k?
sorry, probably is clear, but i am rather puzzled Wink


Now, I am going to investigate how to comunicate from C program to read/edit sqlite db.

I will ask Keltek, to see if he has any samples for this interface in c language.
Keltek, any suggestion or sample...?



vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 6:08 pm

vic1972 escribió:OK,
mechanism seems to be working fine,
I have edited last entry (Original file), changing filename to RecentFile.ts
then executed REcentFile.ts
and it started where original file stopped!!!! Smile

I can edit rows with sqlite manager,but cannot duplicate entries or create entries, can you?

Strange,
this sql should work:
INSERT INTO tParameter VALUES (11,"fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts","BLOB (Size: 16)");

sure i can doing somehting wrong...Wink

In SQLite Manager I just edited rows only so I didn't use Duplicate and Create buttons but I will try it in the evening ...


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 6:28 pm

vic1972 escribió:OK

I am not quite sure If I understand you well, when you say:

1st row: xxm -> BLOB - modify time as unix timestamp (last time where the playing was interrupted).
2nd row: xxk -> BLOB - URI/filename
3rd row: URI/filename -> BLOB - first 4 bytes: resume playing time in seconds (probably also unix timestamp), second 4 bytes: maybe

what do you mean with first row?
you men the first column id ..?
what is xxm? any minutes, right?
and xxk ? what is k?
sorry, probably is clear, but i am rather puzzled Wink


Now, I am going to investigate how to comunicate from C program to read/edit sqlite db.

I will ask Keltek, to see if he has any samples for this interface in c language.
Keltek, any suggestion or sample...?




Sorry,

xx - the number of file in tParameter table
Every file has 3 db records (3 rows)
The first 4 records in the table are not concerning with any file

Example (for file no. 10)

idfKeyfValue
3110mBLOB<- 1st row
3210kBLOB<- 2nd row
33URI filenameBLOB<- 3rd row
and so on ...

"m" in the 1st row means maybe "modify time"
"k" in the 2nd row means ???



George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 6:49 pm

OK
now i understand, yes, you right,
3 rows per each file.
and now i see the k and m .

Now, we know more about the k row

66 69 6C 65 73 65 74 3A 2F 2F 2F 74 6D 70 2F 72 61 6D 66 73 2F 76 6F 6C 75 6D 65 73 2F 48 44 44 20 28 20 49 6E 74 65 72 6E 61 6C 20 29 2F 52 45 43 2F 68 6F 72 6D 69 67 75 65 72 6F 2E 74 73 ") ;
f i l e s e t .ts
fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts","0C000000901400000BC5765301000000

Yes, it is the hexadecimal conversion of the string:
fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/RecentFile.ts","0C000000901400000BC5765301000000


Smile We are nearly discovering everything Wink

I think we should move this thread into main forum, more people might help, or might be instersted...
And we could make a summary with all investigation summary in first post; what do you think ..?














vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty SQLite in C/C++

Mensaje  Keltek el Vie Ene 07, 2011 6:55 pm

Hi all you both Smile
this seems to be a great feature.
Victor, the SQLite API is described here -> http://www.sqlite.org/cintro.html
Simple example is here -> http://souptonuts.sourceforge.net/code/simplesqlite3.c.html - to open and execute the SQL

There is little limitation - the SQLite library, which is in user-root partition. If you start PM and the partition is not mounted, the library cannot be loaded. The library have about 1MB so cannot be in /usr/local/etc (this partition is only 1MB in size). I'm not sure it fit the / partition.
I don't know how to solve this Sad

EDIT: I have an idea... calling something like the custom script.
Keltek
Keltek

Mensajes : 291
Fecha de inscripción : 10/03/2010
Edad : 41
Localización : Praha - Czech Republic

Ver perfil de usuario http://www.fozona.cz/

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 8:56 pm

OK, it is a very good idea to move information about bookmark.db etc. into the main forum!

So I tried to duplicate and add records by SQLite Manager and it seems to work. But I have the version 0.6.5 for Firefox 3.6.x

Bye the Way: Last days I have encountered with a problem of turning off the LG machine. If the LG is on and I want to turn it off that I press the power button, the machine turns off but then immediately it turns on again (it seems like a resetting). Have both you ever encountered with this problem Question


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  Keltek el Vie Ene 07, 2011 9:13 pm

As I remember, this do some old version PipeManagement. Check it and get the latest one Smile
Keltek
Keltek

Mensajes : 291
Fecha de inscripción : 10/03/2010
Edad : 41
Localización : Praha - Czech Republic

Ver perfil de usuario http://www.fozona.cz/

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  vic1972 el Vie Ene 07, 2011 9:28 pm

George2005 escribió:OK, it is a very good idea to move information about bookmark.db etc. into the main forum!

So I tried to duplicate and add records by SQLite Manager and it seems to work. But I have the version 0.6.5 for Firefox 3.6.x

Bye the Way: Last days I have encountered with a problem of turning off the LG machine. If the LG is on and I want to turn it off that I press the power button, the machine turns off but then immediately it turns on again (it seems like a resetting). Have both you ever encountered with this problem Question


can you paste your PM.ini file
I am also working in the force power down,
which first force a reboot, and then it does a proper shutdown Smile
probably you are also testing this feature .... Smile
vic1972
vic1972

Mensajes : 2260
Fecha de inscripción : 09/12/2009
Edad : 47
Localización : Malaga

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 9:42 pm

Keltek escribió:As I remember, this do some old version PipeManagement. Check it and get the latest one Smile

Hi Keltek,

thanks a lot for information. I have the latest working (beta) version of PM 3.5 with Red Button support just for testing resume playing in MOVIE mode. Maybe it is an important information for Victor about the problem of the latest working PM.

Sorry to all that I will write in czech language to Keltek - it's about a regionally specific problem with a teletext font, thanks
----
Jo a taky mě naštvali u LG, že ten poslední firmware 101027A už zase má problém s malými českými znaky s diakritikou v teletextu, když to v předchozí verzí už bylo OK. V /usr/local/bin/Resource/TT_Font/ jsem našel soubor 01_G0_Latin_cze_slo_double_12x20_1bits.raw, ale nevím, jestli to je ten problematický font ... sorry, už se mi to ani nechtělo překládat Mad
----

George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: PM 3.5: RedButton RePlay

Mensaje  George2005 el Vie Ene 07, 2011 9:50 pm

vic1972 escribió:
George2005 escribió:OK, it is a very good idea to move information about bookmark.db etc. into the main forum!

So I tried to duplicate and add records by SQLite Manager and it seems to work. But I have the version 0.6.5 for Firefox 3.6.x

Bye the Way: Last days I have encountered with a problem of turning off the LG machine. If the LG is on and I want to turn it off that I press the power button, the machine turns off but then immediately it turns on again (it seems like a resetting). Have both you ever encountered with this problem Question


can you paste your PM.ini file
I am also working in the force power down,
which first force a reboot, and then it does a proper shutdown Smile
probably you are also testing this feature .... Smile

Thanks a lot for the valuable information! OK, I notice that there is a new key in PM.ini called ForcePowerOFF_Enable. So it's not a bug, it's the feature Very Happy
Well, I will change the value for this key and test it.


George2005

Mensajes : 112
Fecha de inscripción : 26/10/2010
Edad : 44
Localización : Olomouc - Czech Republic

Ver perfil de usuario

Volver arriba Ir abajo

bookmark.db - Página 2 Empty Re: bookmark.db

Mensaje  Contenido patrocinado


Contenido patrocinado


Volver arriba Ir abajo

Página 2 de 8. Precedente  1, 2, 3, 4, 5, 6, 7, 8  Siguiente

Volver arriba


 
Permisos de este foro:
No puedes responder a temas en este foro.