Guild of Writers

johnsojc wrote:(oh, why do I mess with code I don't understand? Because it's fun!)

Yeah, I have a similar problem.

While taking a break from updating Python scripts, I decided to look into the issue of the global devices and journals.

Although I lack the necessary expertise in writing SQL code, that never stopped me from manually tinkering with a database in the past .

I've successfully tacked on nodes and noderefs to enable the global inbox that shows in the KI (Laxman's welcome message). However, when I managed to get the right db entries to enable Sharper's Journal, I found that the field to hold the journal data is way too small.

Using ( ) MOSS as an example, I went looking for the reason. In dirtsand, the field to hold the title (character varying(64)) seems fine. However, the field to hold the journal contents (character varying(1024)) is just too small. In moss, both these fields are defined as <text> which appears to have more room. I don't have a character count but I think the journal is more than 30kB long.

EDIT: I knew better but I thought I'd try anyway... I changed the field for text_1 to text which allowed me to enter Sharper's journal but caused the client to die a quick and silent death when I tried to open the journal. Poking around in the client source showed it is looking for character varying(1024) in that field and it ain't agonna take nothing else. It appears that a textnote is limited to 1KB if I understand everything correctly. Changing the database structure and client code to fix this and maintain compatibility with MOULa may not be realistic.

Got the Memorial Imager working... I put all 19 names on it with 5 space intervals... only used about 350 chars so there's plenty of room (for now) but this field has the same length restriction as the Journals,

Manually entering Global Nodes using pgAdmin3...

Procedure Show Spoiler

On a DIRTSAND server the GlobalInbox node in table Nodes is usually 10002...
(It will have the value 22 in NodeType and 30 in Int32_1)

For Welcome Message: (child node to GlobalInbox)

Insert a new row in Nodes and
Enter (a timestamp) into CreateTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter (a timestamp) into ModifyTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter 0 into CreatorIdx
Enter 26 into NodeType (textnote)
Enter 0 into Int32_1
Enter 0 into Int32_2
Enter Welcome into String64_1
Enter (message body for KI mail) into Text_1 (ex. Welcome to DIRTSAND!)
Note the idx number for the new row (you may need to refresh your view) (ex. 10939)

Insert a new row into NodeRefs and
Enter 10002 into ParentIdx
Enter (idx for Welcome textnote node) into ChildIdx (in this case - 10939)
Enter 0 into OwnerIdx
Enter 0 into Seen

For CommunityImager: (child node to GlobalInbox)

Insert a new row in Nodes and
Enter (a timestamp) into CreateTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter (a timestamp) into ModifyTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter 0 into CreatorIdx
Enter 22 into NodeType (folder)
Enter 10 into Int32_1 (indicates child to this node is an image node)
Enter CommunityImager into String64_1
Note the idx number for the new row (you may need to refresh your view) (ex. 10940)

Insert a new row into NodeRefs and
Enter 10002 into ParentIdx
Enter (idx of CommunityImager folder node) into ChildIdx (in this case - 10940)
Enter 0 into OwnerIdx
Enter 0 into Seen

(I have no info on the type of image node to create for this folder node)

For Journals: (child node to GlobalInbox)

Insert a new row in Nodes and
Enter (a timestamp) into CreateTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter (a timestamp) into ModifyTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter 0 into CreatorIdx
Enter 22 into NodeType (folder)
Enter 0 into Int32_1
Enter Journals into String64_1
Note the idx number for the new row (you may need to refresh your view) (ex. 10941)

Insert a new row into NodeRefs and
Enter 10002 into ParentIdx
Enter (idx of Journals folder node) into ChildIdx (in this case - 10941)
Enter 0 into OwnerIdx
Enter 0 into Seen

For Sharper: (child node to Journals)

Insert a new row in Nodes and
Enter (a timestamp) into CreateTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter (a timestamp) into ModifyTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter 0 into CreatorIdx
Enter 26 into NodeType (textnote)
Enter 0 into Int32_1
Enter 0 into Int32_2
Enter Sharper into String64_1
Enter (journal contents) into Text_1 (ex. I'm an empty book or
<cover src="xSharperJournalCover*1#0.hsm"><font size=18 face=Sharper color=982A2A><margin left=62 right=62 top=48>4.5.11 - Someone seems to have run off with my journal.)
Note the idx number for the new row (you may need to refresh your view) (ex. 10942)

Insert a new row into NodeRefs and
Enter (idx of Journals node) into ParentIdx (in this case - 10941)
Enter (idx of Sharper node) into ChildIdx (in this case - 10942)
Enter 0 into OwnerIdx
Enter 0 into Seen

For MemorialImager: (child node to GlobalInbox)

Insert a new row in Nodes and
Enter (a timestamp) into CreateTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter (a timestamp) into ModifyTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter 0 into CreatorIdx
Enter 22 into NodeType (folder)
Enter 0 into Int32_1
Enter MemorialImager into String64_1
Note the idx number for the new row (you may need to refresh your view) (ex. 10943)

Insert a new row into NodeRefs and
Enter 10002 into ParentIdx
Enter (idx of MemorialImager folder node) into ChildIdx (in this case - 10943)
Enter 0 into OwnerIdx
Enter 0 into Seen

For MemorialImager: (child textnote node to folder MemorialImager)

Insert a new row in Nodes and
Enter (a timestamp) into CreateTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter (a timestamp) into ModifyTime (ex. 1376909755) - for SQL INSERT use EXTRACT(EPOCH FROM NOW())
Enter 0 into CreatorIdx
Enter 26 into NodeType (textnote)
Enter 0 into Int32_1
Enter 0 into Int32_2
Enter MemorialImager into String64_1
Enter (names) into Text_1 (ex. Willow "Wheely" Engberg<5 spaces>Rosette Taylor<5 spaces>...)
Note the idx number for the new row (you may need to refresh your view) (ex. 10944)

Insert a new row into NodeRefs and
Enter (idx of MemorialImager folder node) into ParentIdx (in this case - 10943)
Enter (idx of MemorialImager textnote node) into ChildIdx (in this case - 10944)
Enter 0 into OwnerIdx
Enter 0 into Seen

I really did try to do this programmatically but I couldn't get it to work...