Jump to content

Please read the Forum Rules before posting.

Photo
- - - - -

dictionary database format


  • Please log in to reply
6 replies to this topic

#1 Tracey

Tracey

    e-Sword Supporter

  • Veterans
  • PipPipPip
  • 36 posts
Offline

Posted 17 June 2013 - 05:59 AM

Is there a document that explains the format of a .dctx file?

I noticed that the download dialog now forbids the reverse engineering of databases (I have absolutely no problem with protecting the works and efforts of others).

 

After downloading SQLite Database Browser to fix a Bible and Commentary (and before I knew about the policy regarding reverse engineering) I now have the desire to create a customized dictionary, but I want to do it IAW e-Sword and Bible-Support policies.

 

Any help will be appreciated.

Please advise.

Thanks, Tracey (SQL Newbie)
e-Sword 10, SQLite Database Browser v2.0b1, Windows 2000 Pro sp4

 



#2 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,891 posts
  • LocationGallatin, TN
Offline

Posted 17 June 2013 - 08:51 AM

DCTX is pretty simple. Schema is here:

CREATE TABLE Details (Description NVARCHAR(255), Abbreviation NVARCHAR(50), Comments TEXT, Version INT, Strong BOOL);


CREATE TABLE Dictionary (Topic NVARCHAR(100), Definition TEXT);

CREATE INDEX TopicIndex ON Dictionary (Topic);

Attached File  dctx-doc.png   17.45K   24 downloads



#3 Tracey

Tracey

    e-Sword Supporter

  • Veterans
  • PipPipPip
  • 36 posts
Offline

Posted 17 June 2013 - 10:31 AM

In the event that there is a reference to a specific passage, how do I (add / insert) a (link and/or pop-up) within the definition entry?

 

Examples:

I can right-click to search on another word (I assume {only} within the same resource).

I see green underlined references (Book, Chapter, Verse).

 

Thanks, Tracey



#4 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,891 posts
  • LocationGallatin, TN
Offline

Posted 17 June 2013 - 10:44 AM

e-Sword doesn't support any type of real hyperlinking. The tooltips are based on a book syntax with an underscore, like this: Act_1:18 or Mat_1:1. You color them green and underline them with rtf tags like this: \cf11\ul Act_1:18\cf0\ulnone   but the color/underlining isn't required for operation. It's just for looks. 

 

You can right click any word to search all dictionaries for the same word. Dictionaries with matches have the blue (i) icon in that dictionary's tab.



#5 BH.

BH.

    Utility Developer

  • Contributors
  • PipPipPipPipPip
  • 1,244 posts
  • LocationCalifornia
Offline

Posted 17 June 2013 - 12:35 PM

NOTE - the Version INT entry in the database is used to specify which text display engine e-Sword will use.  3=TXText Control, used with images in the document.  2=I believe is the MS RichText control.  4=iPad/iPhone module.  Version does NOT specify the document version.  



#6 Tracey

Tracey

    e-Sword Supporter

  • Veterans
  • PipPipPip
  • 36 posts
Offline

Posted 18 June 2013 - 06:26 AM

...You color them green and underline them with rtf tags like this: \cf11\ul Act_1:18\cf0\ulnone   but the color/underlining isn't required for operation...

 

The '\cf' tag in the RTF Specification is defined as the font foreground color.

What RTF tags are already (defined / predefined) by e-Sword ([aka / similar to] RTF Header)?

 

Please advise.

Thanks, Tracey
 



#7 Josh Bond

Josh Bond

    Administrator

  • Administrators
  • PipPipPipPipPip
  • 2,891 posts
  • LocationGallatin, TN
Offline

Posted 18 June 2013 - 07:55 AM

The '\cf' tag in the RTF Specification is defined as the font foreground color.

What RTF tags are already (defined / predefined) by e-Sword ([aka / similar to] RTF Header)?

 

Please advise.

Thanks, Tracey
 

 

 

Color Tags with RGB, which you can ignore. So \cf1 is black.
 
cf0 = black or default (?)
cf1 = 0   0   0   black
cf2 = 255 0   0   blue -- Standard color for Greek/Hebrew
cf3 = 255 255 0   light bluegreen
cf4 = 0   255 0   light green
cf5 = 255 0   255 light purple
cf6 = 0   0   255 red
cf7 = 0   255 255 light yellow
cf8 = 255 255 255 white
cf9 = 128 0   0    dark blue
cf10= 128 128 0   dark bluegreen
cf11= 0   128 0   light green  -- Standard tooltip color
cf12= 128 0   128 dark purple
cf13= 0   0   128 dark red
cf14= 0   128 128 dark yellow
cf15= 128 128 128 gray
cf16= 192 192 192 light gray
 
Fonts, i.e. Default, Greek, & Hebrew are defined in Options > Font. Thus \f1 indicates greek text. The number in paranthesis is the character set which you can ignore.
 
f0 = Default 
f1 = Greek (161)
f2 = Hebrew (177)
f3 = Latin (0)
f4 = Chinese(traditional) (136)
f5 = Cyrillic (204)
f6 = Eastern European (238)
f7 = Chinese(simplified) (134)
f8 = Thai (222)
f9 = Korean (129)
f10= Arabic (178)
f11= Turkish (162)
f12= Vietnamese (163)
f13= Japanese (128)





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users




Similar Topics



Latest Blogs