bookmark.db

Congratulations!!!!
Preliminary testing are fine. Ready to download with secret numeric code.
This could be the end of weeks of work and investigations

vic1972 escribió:Congratulations!!!!
Preliminary testing are fine. Ready to download with secret numeric code.
This could be the end of weeks of work and investigations

It sounds great!

But maybe we have to solve another problem. I downloaded the last PM and tested it just in the "real" conditions, ie I programmed a timer and then played some ts file. When the programmed time occured, warning window was shown and after 30 seconds machine returned to TDT mode. So I tried to push the Red button but it didn't worked (as we discussed about it before) so I went to REC menu manually and I saw that the current active recording is at the first place of list instead of 0_RecentFile.ts! Later I tried to start the recording manually and the active recording was also placed as the first item in the list of recordings. I also noticed very interesting thing - active recording was ALWAYS at the first place in the list regardless the type of sorting! So the changing the sorting method didn't matter and active recording with name of "Kriminálka Paříž ...." was in the list before 0_RecentFile.ts even using the sorting by TITLE NAME.

Please could you test it, too? If you will get the same results then we should modify the Red Button command sequence slighty - in case of active recording we must add the "X" command ("arrow down") just after the "$" command to select the second item in the list (ie 0_RecentFile.ts) ...

This seems like endless history.
AH yes, I see what you mean, I cannot test right now, as i am away.
But yes, when a recording is active, it is created like a part_R000 like file, and it is always "touched" by the system,
so, you are right, it is always the first.
I will think of a solution...
think i have already.
When we are in the list of recording, you know there is a preview in little window, and some log is generated with the filename;
so I can sniffer a bit (yes i know;) , and detect if it is 0_RecentFile.ts and if not move one hit down as you suggested. good idea.

AHH One more thing, yesterday I detected that the red button in the remote controller is labelled
curiouly as Repeat. funny right

This color-button was selected because of the next available color button

Do you think it is a good idea, to change the name of the file from 0_RecentFile.ts to 0_ReplayFile.ts
or 0_Replay.ts .For me it is fine like it is now, but the idea is there ...

vic1972 escribió:AHH One more thing, yesterday I detected that the red button in the remote controller is labelled
curiouly as Repeat. funny right

This color-button was selected because of the next available color button

Do you think it is a good idea, to change the name of the file from 0_RecentFile.ts to 0_ReplayFile.ts
or 0_Replay.ts .For me it is fine like it is now, but the idea is there ...

That's great with the Red Button label And it is very good idea to rename RecentFile to Replay! I was also thinking about remove "0" from the start of name because the "future compatibility", ie replaying all movie files (not only ts), as I have some files with name which start with non-alphabetical character (eg. "!movie.avi"). But maybe it is my problem only so I don't insist of it

vic1972 escribió: This seems like endless history.
AH yes, I see what you mean, I cannot test right now, as i am away.
But yes, when a recording is active, it is created like a part_R000 like file, and it is always "touched" by the system,
so, you are right, it is always the first.
I will think of a solution...
think i have already.
When we are in the list of recording, you know there is a preview in little window, and some log is generated with the filename;
so I can sniffer a bit (yes i know;) , and detect if it is 0_RecentFile.ts and if not move one hit down as you suggested. good idea.

Exactly, resume playing is a quite challenge from LG But we could see the light at the end of the tunnel, actually
Btw: there is just interesting thing (as I wrote) that the active recording is always at the first position in list even using sorting by TITLE NAME, although the name of active recording is not the first in alphabetical order ...

I was also thinking about that some "flag" of just active recording could be used in other db files as I noticed that sqlite journal file appeared in the time of active recording ... I will try to investigate it.

ok,
thanks to the clear triggers.sql the only change to: 0_RecentFile.ts to 0_Replay.ts is:
these two lines:

Código:


INSERT OR IGNORE INTO tHarmony (id, fKey, fValue) VALUES (2,'RecentFilenameText','fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/0_Replay.ts'); /* full name of Recent File in TEXT form */
INSERT OR IGNORE INTO tHarmony (id, fKey, fValue) VALUES (3,'RecentFilenameBLOB',X'66696C657365743A2F2F2F746D702F72616D66732F766F6C756D65732F484444202820496E7465726E616C20292F5245432F305F5265706C61792E7473'); /* full name od Recent File in BLOB form */


I have already applied the changes, later I will change PM binary.
The idea of 0_ is to be the first in the alpha-list; I am open to any other suggestion.
thanks. regards.

ok,
regarding the issue that 0_Replay.ts is not always first file in the list, i have an idea,
"if you can't beat them, join them"
Lets use the other way round, lets be the last of the list, zReplay.ts or z_Replay.ts ???
and then we change the date of the file to be 18-6-1972 23:59
this way will be always the oldest file, in date and in hour also, and lattest also by alphanum order.

so, now, we click the $ dollar sign to go to rec list, and then up button one time, then the ok.

will work?

vic1972 escribió:ok,
regarding the issue that 0_Replay.ts is not always first file in the list, i have an idea,
"if you can't beat them, join them"
Lets use the other way round, lets be the last of the list, zReplay.ts or z_Replay.ts ???
and then we change the date of the file to be 18-6-1972 23:59
this way will be always the oldest file, in date and in hour also, and lattest also by alphanum order.

so, now, we click the $ dollar sign to go to rec list, and then up button one time, then the ok.

will work?

Great idea! But there is a problem with non-english (eg czech and maybe other languages) characters, as the "z" is not last character, actually - the last char in Czech is "z" with accent, ie "ž"
In fact, I tried to learn the alphabetical order used by LG and I got this (it's the same as ASCII order practically, except of characters with accents):

Código:

<space>  !  #  $  %  &  '  (  )  +  ,  -  .  0-9  =  @  A-Z  [  ]  ^  _  a-z  {  }  ~  Á-Ž  á-ž

I see,
I am sure there should be an easy solution for this.

I am rather puzzled, because in the ascii table
http://www.asciitable.com/
I cannot find exactly the czech chars you have with the accents, so it seems like it is using extend. ascii or ucs2 ... ??¿¿

Obviously one solution is to used somethin like: ž_Repeat.ts
But we havent even that accent char in our keyboards

So, I am sure someone could help us with some others ideas...
We are also limited, because normally first char of filenames should be a "normal" char ...

Probably is silly question, but you have in your languague words that start with first letters any of these : Á-Ž á-ž ...?

vic1972 escribió:I see,
I am sure there should be an easy solution for this.

I am rather puzzled, because in the ascii table
http://www.asciitable.com/
I cannot find exactly the czech chars you have with the accents, so it seems like it is using extend. ascii or ucs2 ... ??¿¿

Obviously one solution is to used somethin like: ž_Repeat.ts
But we havent even that accent char in our keyboards

So, I am sure someone could help us with some others ideas...
We are also limited, because normally first char of filenames should be a "normal" char ...

Probably is silly question, but you have in your languague words that start with first letters any of these : Á-Ž á-ž ...?

Sorry I didn't expressed it clearly before, the czech characters aren't in standard ASCII table, of course, so I just wanted to write that it was an exception from ASCII sorting ...

Anyway, as I like the "universal" solutions (ie not only for one language ) and LG seems to support UCS-2 I was thinking about using the characters from the finish of the universal character table which could be used for all languages. So I found this character: U+FF3F . It is a "bold underscore" from Bold Glyphs Subarea. "Optically" it appears as a quite longer underscore ("_"). So I tested in LG and it works actually - the file "_Replay.ts" (ie with the bold underscore at the start) was the last item actually.

So if we use this filename with date eg. 1.1.1970 (Unix Epoch start date ) and time of 23:59:59 then such file will be the last item using EVERY sorting method including the BY TIME sorting which was a problem in previous solution ...

http://www.fileformat.info/info/unicode/char/ff3f/index.htm

ok, I understand.
but now i have problem in the c languague to post ucs2 chars,
I have been reading a little in google, and it seems like it is supported but in c++ with
widechars wchar

we need some more investigation or help,
we need to do something like the following in c
sprintf(gral_buffer,"ln -f %s %s", REAL_FILENAME, "\uFF3FRepeat.ts");

So, how to create a filename string in c with ucs2? "\uFF3FRepeat.ts" ?????

vic1972 escribió:

http://www.fileformat.info/info/unicode/char/ff3f/index.htm

ok, I understand.
but now i have problem in the c languague to post ucs2 chars,
I have been reading a little in google, and it seems like it is supported but in c++ with
widechars wchar

we need some more investigation or help,
we need to do something like the following in c
sprintf(gral_buffer,"ln -f %s %s", REAL_FILENAME, "\uFF3FRepeat.ts");

So, how to create a filename string in c with ucs2? "\uFF3FRepeat.ts" ?????

Oops, as I'm not a C programmer, I didn't know that there could be a problem with using unicode characters Maybe it could help "swprintf" function (http://www.kernel.org/doc/man-pages/online/pages/man3/wprintf.3.html), who knows

YESS!!!!
Thanks for the great idea
I did not know this set of funcions, very usefull for ucs2.

example

Código:


#include <stdio.h>
#include <string.h>
 
int main(void)
  {
 wprintf(L"Hola\n");
 wprintf(L"This is working: ->%lc<- \n",0xFF3F);
 wprintf(L"%lcRepeat.ts",0xFF3F);
 
  return 0;
}


The good result:

[victor@asus ucs2]$ gcc ucs2.c
[victor@asus ucs2]$ ./a.out
Hola
This is working: ->_<-
_Repeat.ts[victor@asus ucs2]$


so, we are almost done!!!
I will tomorrow put final solution in PM.
btw, how is the ucs2 inserted in the triggers.... ? please,provide me new version of triggers. thanks.

vic1972 escribió:YESS!!!!
Thanks for the great idea
I did not know this set of funcions, very usefull for ucs2.

example

Código:


#include <stdio.h>
#include <string.h>
 
int main(void)
  {
 wprintf(L"Hola\n");
 wprintf(L"This is working: ->%lc<- \n",0xFF3F);
 wprintf(L"%lcRepeat.ts",0xFF3F);
 
  return 0;
}


The good result:

[victor@asus ucs2]$ gcc ucs2.c
[victor@asus ucs2]$ ./a.out
Hola
This is working: ->_<-
_Repeat.ts[victor@asus ucs2]$

so, we are almost done!!!
I will tomorrow put final solution in PM.
btw, how is the ucs2 inserted in the triggers.... ? please,provide me new version of triggers. thanks.

Woow, It sounds great
New version of triggers is here: http://www.rysi.duha.cz/lg/triggers/triggers.sql
In fact, it is a normal text file in UTF-8 so it is able to contain Unicode characters. For its editing I use PSPad editor for Windows (http://www.pspad.com).

Hello,
I am little rather lost.



For one part, I cannot compile the swprintf for mipsel, yes for linux-pc (yesterday testing).
See below

Código:


[victor@diablo ucs2]$ make
/home/victor/buildroot-2009.11/output/staging/usr/bin/mipsel-linux-gcc -O2 -g -Wall    ucs2.c  -lc -static -l pthread -o ucs2
ucs2.c: In function 'main':
ucs2.c:13: warning: implicit declaration of function 'wprintf'
ucs2.c:16: warning: implicit declaration of function 'swprintf'
ucs2.c:19: warning: implicit declaration of function 'system'
/tmp/cc4F6xxa.o: In function `main':
/home/victor/Dropbox/MS450H/Programacion/Pruebas/ucs2/ucs2.c:13: undefined reference to `wprintf'
/home/victor/Dropbox/MS450H/Programacion/Pruebas/ucs2/ucs2.c:14: undefined reference to `wprintf'
/home/victor/Dropbox/MS450H/Programacion/Pruebas/ucs2/ucs2.c:15: undefined reference to `wprintf'
/home/victor/Dropbox/MS450H/Programacion/Pruebas/ucs2/ucs2.c:16: undefined reference to `swprintf'
/home/victor/Dropbox/MS450H/Programacion/Pruebas/ucs2/ucs2.c:18: undefined reference to `wprintf'
collect2: ld returned 1 exit status
make: *** [ucs2] Error 1
[victor@diablo ucs2]$ gcc ucs2.c
[victor@diablo ucs2]$


As you can see, linux-pc gcc does not complain, but yes the make of the cross-compiler for mipsel.

The code is:

Código:


#include <stdio.h>
#include <string.h>
#include <stdio.h>


// General purpose buffer 2
char gral_buffer2[250];
 
int main(void)
  {
 wprintf(L"Hola\n");
 wprintf(L"This is working: ->%lc<- \n",0xFF3F);
 wprintf(L"%lcRepeat.ts",0xFF3F);
 swprintf(gral_buffer2, L"ln -f /tmp/hdd/volumes/HDD1/REC/Transporter3.ts %lcRepeat.ts",0xFF3F);
 printf("%s\n",gral_buffer2);
 wprintf("%s\n",gral_buffer2);
 system(gral_buffer2);

 
  return 0;
}


In the hope someone could give us a hand.


Now, in the other side, I have been checking your triggers, to see how the _Repeat.ts is represented , and i found:
INSERT OR IGNORE INTO tHarmony (id, fKey, fValue) VALUES (2,'RecentFilenameText','
fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/＿Repeat.ts');
INSERT OR IGNORE INTO tHarmony (id, fKey, fValue) VALUES (3,'RecentFilenameBLOB',X
66696C657365743A2F2F2F746D702F72616D66732F766F6C756D65732F484444202820496E7465726E616C20292F
52 45 43 2F EF BC BF 52 65 70 65 61 74 2E 74 73
R E C / R e p e a t . t s

I was expecting something similar to FF 3F, but instead I found 3 bytes!! : EF BC BF

I will continue with the investigation to see if i can continue.

I think we could go for: ž_Repeat.ts for the initial version....
As the feature is optional, user can enable/disable from config,; and also it will appear always at the end of REC folder,
I think we could sourvive watching this funny z .

I am verry sorry, that you have got such problems because of our weird language

The byte sequence "EF BC BF" is correct actually, because it is the UTF-8 enconding which has the variable length (1 to 6 bytes) - see http://en.wikipedia.org/wiki/UTF-8.

So, the version of triggers using "ž_Repeat.ts" is here: http://www.rysi.duha.cz/lg/triggers/triggers.sql.
Btw: It could be a first lesson of Czech language for LG users ("z" with accent)

Ahoj George

I've start already learning

ok, you gave me the final clue (UTF- , and think i have it finally with the special _

UTF8 basically is a solution for not having the whole document in UCS2.

execution of my test miniprogram is fine in LG:
root@Venus:/tmp/hdd/volumes/HDD1/REC# ./utf8
/tmp/hdd/volumes/HDD1/REC/＿Repeat.ts
ln -f /tmp/hdd/volumes/HDD1/REC/Transporter3.ts /tmp/hdd/volumes/HDD1/REC/＿Repeat.ts

the special file is created, and of course I cannot delete because it does not start with standard _ underscode.
There is way to delete from command line, but I will live this open for people to think.

Finally I have done this way, I am sure there is a better way, but this one goes fine:

Código:


#include <stdio.h>
#include <string.h>
#include <stdio.h>



// General purpose buffer 2
char gral_buffer2[250];

 
int main(void)
  {
 
  char destination[]="/tmp/hdd/volumes/HDD1/REC/ABCRepeat.ts";
  destination[26]=0xEF;
  destination[27]=0xBC;
  destination[28]=0xBF;
 
 printf("%s\n",destination);
 sprintf(gral_buffer2, "ln -f /tmp/hdd/volumes/HDD1/REC/Transporter3.ts %s",destination);
 printf("%s\n",gral_buffer2);
 system(gral_buffer2);

 
  return 0;
}


Now, next points are if the inclusion of the triggers is fine,
because I see the strange chars ... so, lets see in next chapter whats happens
INSERT OR IGNORE INTO tHarmony (id, fKey, fValue) VALUES (2,'RecentFilenameText','
fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/＿Repeat.ts');

vic1972 escribió:Ahoj George

I've start already learning

ok, you gave me the final clue (UTF- , and think i have it finally with the special _

UTF8 basically is a solution for not having the whole document in UCS2.

execution of my test miniprogram is fine in LG:
root@Venus:/tmp/hdd/volumes/HDD1/REC# ./utf8
/tmp/hdd/volumes/HDD1/REC/＿Repeat.ts
ln -f /tmp/hdd/volumes/HDD1/REC/Transporter3.ts /tmp/hdd/volumes/HDD1/REC/＿Repeat.ts

the special file is created, and of course I cannot delete because it does not start with standard _ underscode.
There is way to delete from command line, but I will live this open for people to think.

Finally I have done this way, I am sure there is a better way, but this one goes fine:

Código:


#include <stdio.h>
#include <string.h>
#include <stdio.h>



// General purpose buffer 2
char gral_buffer2[250];

 
int main(void)
  {
 
  char destination[]="/tmp/hdd/volumes/HDD1/REC/ABCRepeat.ts";
  destination[26]=0xEF;
  destination[27]=0xBC;
  destination[28]=0xBF;
 
 printf("%s\n",destination);
 sprintf(gral_buffer2, "ln -f /tmp/hdd/volumes/HDD1/REC/Transporter3.ts %s",destination);
 printf("%s\n",gral_buffer2);
 system(gral_buffer2);

 
  return 0;
}


Now, next points are if the inclusion of the triggers is fine,
because I see the strange chars ... so, lets see in next chapter whats happens
INSERT OR IGNORE INTO tHarmony (id, fKey, fValue) VALUES (2,'RecentFilenameText','
fileset:///tmp/ramfs/volumes/HDD ( Internal )/REC/＿Repeat.ts');

Hola Victor!
You are very good in Czech

Congratulation You did an excellent hack how to manage UTF-8 encoding for "_" character in C code!

Well, you are right, that there is a problem to delete a file with filename using UTF-8 characters (I know that issue exactly, because there are almost all files created upon the czech EPG ). It is not even possible to delete them using FTP client, maybe because FTP server doesn't support UTF-8 fully (it could be a reason for Keltek to solve it now...). But such files should be deleted directly from REC menu of LG machine, because I often use this method to delete files with czech characters.

Btw: the importing of triggers should work correctly as sqlite3 accepts UTF-8 without problems. Of course I tried it before and it passed successfully.

As I wrote in different post, system is now fully UTF-8 compatible (tested). Ftp is working, sh is working so don't worry about it
I know you ask me when I send you this new version... I have only one last problem - I want to compile ext2fs tools to busybox (because of size of entire flash image). In new busybox there is rewritten ext2fs tools from scratch which are unable to compile with our mipsel compiler (and linux headers). Also there are old sources of ext2fs tools, which are unable to compile too because of atomic headers, which (already) not works. I'm confused about it.

Keltek escribió:As I wrote in different post, system is now fully UTF-8 compatible (tested). Ftp is working, sh is working so don't worry about it
I know you ask me when I send you this new version... I have only one last problem - I want to compile ext2fs tools to busybox (because of size of entire flash image). In new busybox there is rewritten ext2fs tools from scratch which are unable to compile with our mipsel compiler (and linux headers). Also there are old sources of ext2fs tools, which are unable to compile too because of atomic headers, which (already) not works. I'm confused about it.

OK, thanks a lot for your effort to support UTF-8 fully in the LG machine and I wish you to solve all problems you have encountered ...

Hello George,
is it possible for you to publish again in a new url the final triggers.sql using utf-8 like triggers_utf8.sql
I think my ISP is playing with the caches and getting old version. thanks

vic1972 escribió:Hello George,
is it possible for you to publish again in a new url the final triggers.sql using utf-8 like triggers_utf8.sql
I think my ISP is playing with the caches and getting old version. thanks

OK, I published the file with "_" as this: http://www.rysi.duha.cz/lg/triggers/triggers_utf8.sql
I also remained published the file with "ž" as this: http://www.rysi.duha.cz/lg/triggers/triggers_utf8_z.sql

ok, thanks, now downloaded fine.

I have done some preliminary testing, and i have some issue regarding the ordering files in lg.

choosing alphanumerical and time is fine; but when i select last

I get this:
-rwxrwxrwx 1 root root 6700187648 Jan 1 23:59 Transporter3.ts
-rwxrwxrwx 1 root root 5337202688 Jan 30 22:59 Los Protegidos_20110130_2158.ts

that is first in the list the one of first January, and the list continues fine, 30 Jan, 29Jan, etc

The only thing is that i modified the date/hour manually to the file Transporter3.ts
it is like if lg detecte that you have just "touched" file, (it does not matter the date), it is then posted the first of the list
Is this hapenning to you?

vic1972 escribió:ok, thanks, now downloaded fine.

I have done some preliminary testing, and i have some issue regarding the ordering files in lg.

choosing alphanumerical and time is fine; but when i select last

I get this:
-rwxrwxrwx 1 root root 6700187648 Jan 1 23:59 Transporter3.ts
-rwxrwxrwx 1 root root 5337202688 Jan 30 22:59 Los Protegidos_20110130_2158.ts

that is first in the list the one of first January, and the list continues fine, 30 Jan, 29Jan, etc

The only thing is that i modified the date/hour manually to the file Transporter3.ts
it is like if lg detecte that you have just "touched" file, (it does not matter the date), it is then posted the first of the list
Is this hapenning to you?

Oops, you are right I made some investigation and found out that LG sorting BY LATEST is based on ctime (ie the change time of inode - try to use ls with ctime sorting ("ls -lc") and you get the same order as LG shows). But the problem is that there is not possible to change ctime directly by touch command Maybe some hacks exist to change inode directly, but I have no experiences with them ...

I just tested the "dumb hack", ie to change system date to 1.1.1970 & touch the file also with date of 1.1.1970 and then change system date back to 31.1.2011. It worked actually so the file was shown at the last position but I am not sure if the system date changing to 1970 (even for a short time) could cause some problems (eg with timer etc.) ...