sqlite3, Setup & bookmark.sdb

**wigout** · 10-23-2010, 04:21 AM

Part of the way that DvdPlayer saves its settings are in the
/usr/local/etc/dvdplayer/Setup
file.

It is a sqlite3 database.

From the latest gpl offering from patriot is a dynamically compiled version (but has run on three different firmwares so far) of sqlite3, which I am attaching to this post. It is around 1.1mb.

sqlite3 is also available through /opt/ so, if you have opt installed you can just search for it.

For the sake of argument, let say you add the statically compiled version to your /usr/local/etc

Try the following:
/usr/local/etc/sqlite3 /usr/local/etc/dvdplayer/Setup

this will bring up a command prompt:

Code:

Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

try this for starters:

Code:

.tables

then:

Code:

.dump

The exact codes & id's will vary based on the firmware you are running.

But if your .dump above included a line like:

Code:

INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-10);

You could change the value using the following commands:

Code:

UPDATE SetupKeyValue
   ...> SET Value=-40
   ...> WHERE id=273;

running .dump again should show the line changed to:

Code:

INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-40);

The important table in Setup is SetupKeyValue
The important table in bookmark.sdb is tParameter

The DvdPlayer seems to treat the Setup file as a repository of settings. It only read the files for updates at startup.
That is, if you change the file by hand using sqlite3 while DvdPlayer is already running, DvdPlayer will ignore your changes.
If you use stopall, make your changes, and then restart DvdPlayer your changes will be applied.

On the other hand DvdPlayer saves any settings given by way of the GUI to the /usr/local/bin/dvdplayer/Setup file. Everytime you change a setting, when DvdPlayer applies the changes, it saves it's changes to the Setup file.

Anyway, some interesting settings in here... I'm pretty sure a number of them are relics.

-wigout

**aasoror** · 10-23-2010, 04:45 AM

Great find wigout.
Now this means you can recover from the restore factory default brick (brightness auto set to -7 and black screen after that) by:
- telnetting and removing the whole Setup file.
- telnetting and over write the Setup file with your last working one (would be like loading you saved settings).
- telnetting and issuing an SQL update query to fix the brightness value.

This thread gets 5 stars from me

**wigout** · 10-23-2010, 03:15 PM

Just as an example of what the contents of /usr/local/etc/dvdplayer/Setup can look like (this WILL vary by firmware, both options and id #'s), here's the .dump of MedeBO_V4Beta4_2_October2010's Setup file:
Part 1 (too long for a single post):

Code:

sqlite> .dump 
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE tParameter (id INTEGER PRIMARY KEY, fKey TEXT, fValue BLOB);
INSERT INTO "tParameter" VALUES(1,'DB_VERSION','1');
INSERT INTO "tParameter" VALUES(2,'DB_DEVELOP_VERSION','6');
INSERT INTO "tParameter" VALUES(3,'SETUP_INIT',0);
INSERT INTO "tParameter" VALUES(4,'RESTORE_DEFAULT_FROM_DB','0');
CREATE TABLE SetupKeyValue (
    id INTEGER PRIMARY KEY,
    Key TEXT,
    Value BLOB,
    UNIQUE(Key)
);
INSERT INTO "SetupKeyValue" VALUES(1,'SETUP_MAJOR_MODEL',3850);
INSERT INTO "SetupKeyValue" VALUES(2,'SETUP_MINOR_MODEL',31);
INSERT INTO "SetupKeyValue" VALUES(4,'SETUP_AUDIO_LANGUAGE',0);
INSERT INTO "SetupKeyValue" VALUES(5,'SETUP_SUBTITLE_LANGUAGE',1);
INSERT INTO "SetupKeyValue" VALUES(6,'SETUP_MENU_LANGUAGE',0);
INSERT INTO "SetupKeyValue" VALUES(9,'SETUP_SUBTITLE_YOFFSET',0);
INSERT INTO "SetupKeyValue" VALUES(17,'SETUP_REC_TV_SYSTEM',2);
INSERT INTO "SetupKeyValue" VALUES(18,'SETUP_AUTO_TV_SYSTEM',0);
INSERT INTO "SetupKeyValue" VALUES(19,'SETUP_VIDEO_PREPROCESS',0);
INSERT INTO "SetupKeyValue" VALUES(20,'SETUP_COPY_PROTECT',1);
INSERT INTO "SetupKeyValue" VALUES(21,'SETUP_REC_QUALITY',1);
INSERT INTO "SetupKeyValue" VALUES(22,'SETUP_AUTO_CHAPTER',2);
INSERT INTO "SetupKeyValue" VALUES(23,'SETUP_REC_DEVICE',0);
INSERT INTO "SetupKeyValue" VALUES(24,'SETUP_TIMESHIFT_DEVICE',0);
INSERT INTO "SetupKeyValue" VALUES(25,'SETUP_REC_PRIORITY',0);
INSERT INTO "SetupKeyValue" VALUES(26,'SETUP_LAST_REC_FILE','');
INSERT INTO "SetupKeyValue" VALUES(27,'SETUP_AUTO_TIMESHIFT',0);
INSERT INTO "SetupKeyValue" VALUES(28,'SETUP_RATING_IS_ENABLE',0);
INSERT INTO "SetupKeyValue" VALUES(29,'SETUP_RATING_UNRATED_IS_ENABLE',0);
INSERT INTO "SetupKeyValue" VALUES(30,'SETUP_RATING_LEVEL',0);
INSERT INTO "SetupKeyValue" VALUES(31,'SETUP_RATING_REGION',0);
INSERT INTO "SetupKeyValue" VALUES(33,'SETUP_TIME_SERVER',1);
INSERT INTO "SetupKeyValue" VALUES(34,'SETUP_TIME_SUMMER_TIME',1);
INSERT INTO "SetupKeyValue" VALUES(35,'SETUP_NET_REMOTE_CONTROL',0);
INSERT INTO "SetupKeyValue" VALUES(36,'SETUP_USBSWITCH',2);
INSERT INTO "SetupKeyValue" VALUES(37,'SETUP_CARDSWITCH',2);
INSERT INTO "SetupKeyValue" VALUES(38,'SETUP_OPEN_VCHIP_TABLE',NULL);
INSERT INTO "SetupKeyValue" VALUES(39,'SETUP_OPEN_VCHIP_RATING_INFO',NULL);
INSERT INTO "SetupKeyValue" VALUES(40,'SETUP_RATING_PASSWD',0);
INSERT INTO "SetupKeyValue" VALUES(41,'SETUP_TV_RATING_BIT_VALUE',0);
INSERT INTO "SetupKeyValue" VALUES(42,'SETUP_TV_XRATING_BIT_VALUE',0);
INSERT INTO "SetupKeyValue" VALUES(43,'SETUP_AUTO_PLAY',1);
INSERT INTO "SetupKeyValue" VALUES(44,'SETUP_SEAMLESS_PLAYBACK',1);
INSERT INTO "SetupKeyValue" VALUES(47,'SETUP_BRIGHTNESS',32);
INSERT INTO "SetupKeyValue" VALUES(48,'SETUP_CONTRAST',32);
INSERT INTO "SetupKeyValue" VALUES(49,'SETUP_HUE',32);
INSERT INTO "SetupKeyValue" VALUES(50,'SETUP_SATURATION',32);
INSERT INTO "SetupKeyValue" VALUES(51,'SETUP_VIDEO_OUTPUT',0);
INSERT INTO "SetupKeyValue" VALUES(53,'SETUP_ANGLE_MARK',1);
INSERT INTO "SetupKeyValue" VALUES(54,'SETUP_REGION_CODE',0);
INSERT INTO "SetupKeyValue" VALUES(56,'SETUP_SPEAKER_OUT',0);
INSERT INTO "SetupKeyValue" VALUES(57,'SETUP_HDMI_AUDIO_OUTPUT_MODE',1);
INSERT INTO "SetupKeyValue" VALUES(58,'SETUP_SPDIF_AUDIO_OUTPUT_MODE',1);
INSERT INTO "SetupKeyValue" VALUES(59,'SETUP_SPDIF_MODE',4);
INSERT INTO "SetupKeyValue" VALUES(60,'SETUP_DOLBY_PROLOGIC_ENABLE',0);
INSERT INTO "SetupKeyValue" VALUES(61,'SETUP_AUDIO_AGC_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(62,'SETUP_SORT_MODE_HDD',1);
INSERT INTO "SetupKeyValue" VALUES(63,'SETUP_SORT_MODE_DISC',1);
INSERT INTO "SetupKeyValue" VALUES(64,'SETUP_KARAOKE_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(65,'SETUP_MIC1_VOLUME',6);
INSERT INTO "SetupKeyValue" VALUES(66,'SETUP_MIC2_VOLUME',6);
INSERT INTO "SetupKeyValue" VALUES(67,'SETUP_MUSIC_VOLUME',25);
INSERT INTO "SetupKeyValue" VALUES(68,'SETUP_MIC_ECHO',0);
INSERT INTO "SetupKeyValue" VALUES(69,'SETUP_VOCAL_REMOVAL_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(70,'SETUP_KEY_SHIFT_STONE',0);
INSERT INTO "SetupKeyValue" VALUES(71,'SETUP_EQUALIZER_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(72,'SETUP_REVERB_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(73,'SETUP_PASSTHROUGH_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(74,'SETUP_SOURCE',10);
INSERT INTO "SetupKeyValue" VALUES(75,'SETUP_DEVICE',0);
INSERT INTO "SetupKeyValue" VALUES(77,'SETUP_CURR_CHANNEL',2);
INSERT INTO "SetupKeyValue" VALUES(78,'SETUP_SUBTITLEFLAG',1);
INSERT INTO "SetupKeyValue" VALUES(79,'SETUP_BROWSERMODE',1);
INSERT INTO "SetupKeyValue" VALUES(81,'SETUP_MELEFTP',1);
INSERT INTO "SetupKeyValue" VALUES(82,'SETUP_SOUNDBAR_SPEAKER',0);
INSERT INTO "SetupKeyValue" VALUES(83,'SETUP_DTV_CURR_CHANNLE',1);
INSERT INTO "SetupKeyValue" VALUES(84,'SETUP_DTV_REGION',0);
INSERT INTO "SetupKeyValue" VALUES(87,'SETUP_RESUME_MODE',1);
INSERT INTO "SetupKeyValue" VALUES(88,'SETUP_BOOKMARK',X'');
INSERT INTO "SetupKeyValue" VALUES(89,'SETUP_SIGNATURE',X'');
INSERT INTO "SetupKeyValue" VALUES(90,'SETUP_SCREEN_SAVER',1);
INSERT INTO "SetupKeyValue" VALUES(92,'SETUP_EWHA_VIDEO_HD_SYSTEM',0);
INSERT INTO "SetupKeyValue" VALUES(93,'SETUP_SET_RATING_TIMEOUT',5000);
INSERT INTO "SetupKeyValue" VALUES(96,'SETUP_EWHA_MIX_PLAY',1);
INSERT INTO "SetupKeyValue" VALUES(97,'SETUP_EWHA_MOVIE_PREVIEW',1);
INSERT INTO "SetupKeyValue" VALUES(99,'SETUP_ERROR_CONCEALMENT_LEVEL',0);
INSERT INTO "SetupKeyValue" VALUES(105,'SETUP_TIME_ZONE',0);
INSERT INTO "SetupKeyValue" VALUES(106,'SETUP_DAYLIGHT_SAVING',0);
INSERT INTO "SetupKeyValue" VALUES(107,'SETUP_POWER_SAVING',0);
INSERT INTO "SetupKeyValue" VALUES(108,'SETUP_VIDEO_DNR_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(109,'SETUP_VIDEO_ZOOM_OUT_MODE',0);
INSERT INTO "SetupKeyValue" VALUES(110,'SETUP_SECURITY_SETTING',0);
INSERT INTO "SetupKeyValue" VALUES(111,'SETUP_DIVX_CODE','');
INSERT INTO "SetupKeyValue" VALUES(112,'SETUP_DISABLE_EXTHDD_DB',0);
INSERT INTO "SetupKeyValue" VALUES(113,'SETUP_DISABLE_AUTOSCAN_EXTHDD',0);
INSERT INTO "SetupKeyValue" VALUES(117,'SETUP_NET_ETH0_IPADDR',X'7F000001');
INSERT INTO "SetupKeyValue" VALUES(118,'SETUP_NET_ETH0_MASK',X'FFFFFF00');
INSERT INTO "SetupKeyValue" VALUES(119,'SETUP_NET_ETH0_GATEWAY',X'7F000001');
INSERT INTO "SetupKeyValue" VALUES(120,'SETUP_NET_ETH0_DNS',X'7F000001');
INSERT INTO "SetupKeyValue" VALUES(121,'SETUP_NET_WLAN0_ENABLE',0);
INSERT INTO "SetupKeyValue" VALUES(122,'SETUP_NET_WLAN0_PROFILE',0);
INSERT INTO "SetupKeyValue" VALUES(123,'SETUP_NET_PPP0_ENABLE',0);
INSERT INTO "SetupKeyValue" VALUES(124,'SETUP_NET_PPP0_USERNAME','');
INSERT INTO "SetupKeyValue" VALUES(125,'SETUP_NET_PPP0_PASSWORD','');
INSERT INTO "SetupKeyValue" VALUES(126,'SETUP_NET_PPP0_INTERFACE',0);
INSERT INTO "SetupKeyValue" VALUES(131,'SETUP_EWHA_VIDEO_SD_SYSTEM',0);
INSERT INTO "SetupKeyValue" VALUES(132,'SETUP_OSD_LANGUAGE',0);
INSERT INTO "SetupKeyValue" VALUES(133,'SETUP_NET_ETH0_DHCP_ENABLE',1);
INSERT INTO "SetupKeyValue" VALUES(134,'SETUP_NET_ETH0_ENABLE',1);
INSERT INTO "SetupKeyValue" VALUES(135,'SETUP_NET_DEFAULT_ROUTE',0);
INSERT INTO "SetupKeyValue" VALUES(136,'SETUP_TIME_MELETIMEZONE',7);
INSERT INTO "SetupKeyValue" VALUES(137,'SETUP_INITIAL_FLAG',0);
INSERT INTO "SetupKeyValue" VALUES(139,'SETUP_EWHA_TRANS_EFFECT',8);
INSERT INTO "SetupKeyValue" VALUES(140,'SETUP_HISTORYFLAG',1);
INSERT INTO "SetupKeyValue" VALUES(144,'SETUP_SCREENSAVER_TIME',90);
INSERT INTO "SetupKeyValue" VALUES(145,'SETUP_PIN_PROTECTION',0);
INSERT INTO "SetupKeyValue" VALUES(148,'SETUP_EWHA_VIDEO_1080P24',1);
INSERT INTO "SetupKeyValue" VALUES(160,'SETUP_NET_SAMBAOPEN',1);
INSERT INTO "SetupKeyValue" VALUES(239,'SETUP_VOLUME',16);
INSERT INTO "SetupKeyValue" VALUES(252,'SETUP_KEN_BURNS',1);
INSERT INTO "SetupKeyValue" VALUES(263,'SETUP_SUBTITLE_COLOR',0);
INSERT INTO "SetupKeyValue" VALUES(265,'SETUP_SUBTITLE_ENCODE',0);
INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-10);
INSERT INTO "SetupKeyValue" VALUES(282,'SETUP_EWHA_SLIDE_SHOW_TIME',3);
INSERT INTO "SetupKeyValue" VALUES(284,'SETUP_ASPECT_RATIO',2);
INSERT INTO "SetupKeyValue" VALUES(296,'SETUP_TV_SYSTEM_AUTO_MODE',2);
INSERT INTO "SetupKeyValue" VALUES(298,'SETUP_TV_SYSTEM',5);
INSERT INTO "SetupKeyValue" VALUES(299,'SETUP_TV_STANDARD',1);
INSERT INTO "SetupKeyValue" VALUES(301,'SETUP_CURRENT_HDMI_TV_VID',0);
INSERT INTO "SetupKeyValue" VALUES(302,'SETUP_SUBTITLE_OFFSET',0);
INSERT INTO "SetupKeyValue" VALUES(303,'SETUP_SCREENSIZE_X',36);
INSERT INTO "SetupKeyValue" VALUES(304,'SETUP_SCREENSIZE_Y',19);
INSERT INTO "SetupKeyValue" VALUES(305,'SETUP_SCREENSIZE_W',1208);
INSERT INTO "SetupKeyValue" VALUES(306,'SETUP_SCREENSIZE_H',682);
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
);

**wigout** · 10-23-2010, 03:15 PM

Part 2:

Code:

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
);
INSERT INTO "SetupWlan0Profile"  VALUES(1,'Connection1',2,1,2130706433,-256,2130706433,'',0,'',1,2130706433,-1062716418,-1062716671,-1062716419);
INSERT INTO "SetupWlan0Profile"  VALUES(2,'Connection2',2,1,2130706433,-256,2130706433,'',0,'',1,2130706433,-1062716418,-1062716671,-1062716419);
INSERT INTO "SetupWlan0Profile"  VALUES(3,'Connection3',2,1,2130706433,-256,2130706433,'',0,'',1,2130706433,-1062716418,-1062716671,-1062716419);
INSERT INTO "SetupWlan0Profile"  VALUES(4,'Connection4',2,1,2130706433,-256,2130706433,'',0,'',1,2130706433,-1062716418,-1062716671,-1062716419);
CREATE TABLE SetupVCRPlusChMap(
    GCN_Ch INTEGER PRIMARY KEY,
    Received_Source NUMERIC,
    Received_Ch NUMERIC
);
CREATE TABLE SetupAvailableLang(
    type NUMERIC,
    Language_id NUMERIC,
    sOrder NUMERIC,
    Primary Key(type,Language_id)
);
INSERT INTO "SetupAvailableLang" VALUES(1,0,10);
INSERT INTO "SetupAvailableLang" VALUES(1,5,20);
INSERT INTO "SetupAvailableLang" VALUES(1,3,30);
INSERT INTO "SetupAvailableLang" VALUES(1,4,40);
INSERT INTO "SetupAvailableLang" VALUES(1,6,50);
INSERT INTO "SetupAvailableLang" VALUES(1,8,60);
INSERT INTO "SetupAvailableLang" VALUES(1,11,70);
CREATE TABLE SetupAvailableRegion(
    type NUMERIC,
    Region_id NUMERIC,
    sOrder NUMERIC,
    Primary Key(type,Region_id)
);
INSERT INTO "SetupAvailableRegion" VALUES(1,2,10);
INSERT INTO "SetupAvailableRegion" VALUES(1,3,20);
INSERT INTO "SetupAvailableRegion" VALUES(1,9,30);
INSERT INTO "SetupAvailableRegion" VALUES(1,10,40);
INSERT INTO "SetupAvailableRegion" VALUES(1,14,50);
INSERT INTO "SetupAvailableRegion" VALUES(1,17,60);
INSERT INTO "SetupAvailableRegion" VALUES(1,18,70);
INSERT INTO "SetupAvailableRegion" VALUES(1,21,80);
INSERT INTO "SetupAvailableRegion" VALUES(1,25,90);
INSERT INTO "SetupAvailableRegion" VALUES(1,26,100);
INSERT INTO "SetupAvailableRegion" VALUES(1,28,110);
CREATE TABLE DB_VERSION_CONTROL(
    id INTEGER PRIMARY KEY,
    Version NUMERIC,
    CmdOrder NUMERIC,
    CmdSQL TEXT
);
CREATE UNIQUE INDEX iParameter_1 ON tParameter(fKey ASC);
COMMIT;

**wigout** · 10-23-2010, 03:26 PM

I have a wireless adapter that I've given up on, but I went ahead and configured it for the player to see how the settings would change:
The SetupWlan0Profile table in the /usr/local/etc/dvdplayer/Setup is where these network settings are saved.

here's the default settings:
INSERT INTO "SetupWlan0Profile"

Code:

VALUES(1,'Connection1',2,1,2130706433,-256,2130706433,'',0,'',1,2130706433,-1062716418,-1062716671,-1062716419);

Here in a more human readable form:

Code:

id INTEGER PRIMARY KEY   1
Name TEXT                'Connection1'
Mode NUMERIC             2
DHCP_enable NUMERIC      1
IP NUMERIC               2130706433
MASK NUMERIC            -256
GATEWAY NUMERIC         2130706433
APNAME TEXT             ''
SECURITY NUMERIC        0
WEP_KEY TEXT            ''
ACTIVE_WEP_KEY NUMERIC  1
DNS NUMERIC             2130706433
DHCPD_HostIP NUMERIC    -1062716418
DHCPD_StartIP NUMERIC   -1062716671
DHCPD_EndIP NUMERIC     -1062716419

Here's the info when I've chosen wpa (it's wpa2 on the router) and auto for all the rest of the setup options:
INSERT INTO "SetupWlan0Profile"

Code:

VALUES(1,'Connection1',0,1,2130706433,-256,2130706433,'YourNetworkSSID',2,'YourNetworkPasspharse',1,2130706433,-1062716418,-1062716671,-1062716419);

And in a more human readable format:

Code:

id INTEGER PRIMARY KEY   1
Name TEXT                'Connection1'
Mode NUMERIC             2
DHCP_enable NUMERIC      1
IP NUMERIC               2130706433
MASK NUMERIC             -256
GATEWAY NUMERIC          2130706433
APNAME TEXT              'YourNetworkSSID'
SECURITY NUMERIC         2
WEP_KEY TEXT             'YourNetworkPassphrase'
ACTIVE_WEP_KEY NUMERIC   1
DNS NUMERIC              2130706433
DHCPD_HostIP NUMERIC     -1062716418
DHCPD_StartIP NUMERIC    -1062716671
DHCPD_EndIP NUMERIC      -1062716419

So for my setup, just these three fields changed:

Code:

 APNAME TEXT              'YourNetworkSSID'
SECURITY NUMERIC         2
WEP_KEY TEXT             'YourNetworkPassphrase'

The other options are there for some reason, but remain unchanged for an "auto" selected wpa2 setup.

-wigout

**token** · 09-24-2011, 07:47 AM

Originally Posted by wigout

Part of the way that DvdPlayer saves its settings are in the
/usr/local/etc/dvdplayer/Setup
file.

It is a sqlite3 database.

From the latest gpl offering from patriot is a dynamically compiled version (but has run on three different firmwares so far) of sqlite3, which I am attaching to this post. It is around 1.1mb.

sqlite3 is also available through /opt/ so, if you have opt installed you can just search for it.

For the sake of argument, let say you add the statically compiled version to your /usr/local/etc

Try the following:
/usr/local/etc/sqlite3 /usr/local/etc/dvdplayer/Setup

this will bring up a command prompt:

Code:

Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

try this for starters:

Code:

.tables

then:

Code:

.dump

The exact codes & id's will vary based on the firmware you are running.

But if your .dump above included a line like:

Code:

INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-10);

You could change the value using the following commands:

Code:

UPDATE SetupKeyValue
   ...> SET Value=-40
   ...> WHERE id=273;

running .dump again should show the line changed to:

Code:

INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-40);

The important table in Setup is SetupKeyValue
The important table in bookmark.sdb is tParameter

The DvdPlayer seems to treat the Setup file as a repository of settings. It only read the files for updates at startup.
That is, if you change the file by hand using sqlite3 while DvdPlayer is already running, DvdPlayer will ignore your changes.
If you use stopall, make your changes, and then restart DvdPlayer your changes will be applied.

On the other hand DvdPlayer saves any settings given by way of the GUI to the /usr/local/bin/dvdplayer/Setup file. Everytime you change a setting, when DvdPlayer applies the changes, it saves it's changes to the Setup file.

Anyway, some interesting settings in here... I'm pretty sure a number of them are relics.

-wigout

Hi wigout, I got an "/usr/local/etc/sqlite3: can't load library 'libgcc_s.so.1'" error when the attached file. Any idea where I can download one with all the so statically compiled in? Many thanks.

Cheers,

**aasoror** · 09-24-2011, 06:03 PM

Originally Posted by token

Hi wigout, I got an "/usr/local/etc/sqlite3: can't load library 'libgcc_s.so.1'" error when the attached file. Any idea where I can download one with all the so statically compiled in? Many thanks.

Cheers,

He mentions optware, if you have a BC16 official firmware or a BCN semiofficial firmware you can try the instructions here:
http://www.patriotmemory.com/forums/...-office-device

Best of luck,

**token** · 09-28-2011, 09:10 PM

Originally Posted by aasoror

He mentions optware, if you have a BC16 official firmware or a BCN semiofficial firmware you can try the instructions here:
http://www.patriotmemory.com/forums/...-office-device

Best of luck,

Thanks. I just read up on the thread but I'm on BC81-27, guess I'm out of luck eh?

Cheers,

**aasoror** · 09-29-2011, 06:07 AM

Originally Posted by token

Thanks. I just read up on the thread but I'm on BC81-27, guess I'm out of luck eh?

Cheers,

what is BC81-27 ?
You mean bootcode 27 ? you can just use a BCN semiofficial version, it is compatible with all bootcodes.

**Shela** · 10-10-2012, 01:57 AM

Sorry, total newb here. I'm trying to install sqlite3, so I can reset the brightness levels as mentioned here ( http://www.patriotmemory.com/forums/...1538#post31538) hoping this will fix my black screen problem.

I'm not sure where or how to install sqlite3. I'm computer literate, just confused - sorry. I have downloaded sqlite3 to my computer and am not sure what to do next. Once it's installed, I should be able to handle the rest.

Hope someone can help! Thanks!

Originally Posted by wigout

Part of the way that DvdPlayer saves its settings are in the
/usr/local/etc/dvdplayer/Setup
file.

It is a sqlite3 database.

From the latest gpl offering from patriot is a dynamically compiled version (but has run on three different firmwares so far) of sqlite3, which I am attaching to this post. It is around 1.1mb.

sqlite3 is also available through /opt/ so, if you have opt installed you can just search for it.

For the sake of argument, let say you add the statically compiled version to your /usr/local/etc

Try the following:
/usr/local/etc/sqlite3 /usr/local/etc/dvdplayer/Setup

this will bring up a command prompt:

Code:

Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

try this for starters:

Code:

.tables

then:

Code:

.dump

The exact codes & id's will vary based on the firmware you are running.

But if your .dump above included a line like:

Code:

INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-10);

You could change the value using the following commands:

Code:

UPDATE SetupKeyValue
   ...> SET Value=-40
   ...> WHERE id=273;

running .dump again should show the line changed to:

Code:

INSERT INTO "SetupKeyValue" VALUES(273,'SETUP_SUBTITLE_FONTSIZE',-40);

The important table in Setup is SetupKeyValue
The important table in bookmark.sdb is tParameter

The DvdPlayer seems to treat the Setup file as a repository of settings. It only read the files for updates at startup.
That is, if you change the file by hand using sqlite3 while DvdPlayer is already running, DvdPlayer will ignore your changes.
If you use stopall, make your changes, and then restart DvdPlayer your changes will be applied.

On the other hand DvdPlayer saves any settings given by way of the GUI to the /usr/local/bin/dvdplayer/Setup file. Everytime you change a setting, when DvdPlayer applies the changes, it saves it's changes to the Setup file.

Anyway, some interesting settings in here... I'm pretty sure a number of them are relics.

-wigout

Thread: sqlite3, Setup & bookmark.sdb

Thread Tools

Display

sqlite3, Setup & bookmark.sdb

Installing sqlite3 to fix black screen problem - need help, please! : )

Posting Permissions