MSGID: 1:19/40 3486BAEE
PID: CyberBBS v1.0.10
g00r00,

I have a question about how you laid our your db containing msgs that i
thought you might answer.
In storing messages, specifically echomail, do you save each kludge
as a seperate value or do you just simply save the header info and then
the entire message text with kludge?

Appreicate it bud.

-Nugax (cbbs)


--- CyberBBS v1.0.10 2023/03/01 [Debian Linux/x64/x86_64]
* Origin: CyberBBS WHQ BBS | http://www.cyberbbs.com (1:19/40)

I have a question about how you laid our your db containing msgs that i thought you might answer.
In storing messages, specifically echomail, do you save each kludge
as a seperate value or do you just simply save the header info and then the entire message text with kludge?

The message text and the kludges are stored separately. JAM bases have a message header/index with mostly integer-based data, and then a message text buffer. Part of that text storage is a sub-text buffer that stores custom fields and it has a variable length which allows field expandability without breaking the format. The subtext is where the kludges are stored.

I believe Synchronet's format uses a similar approach too.

... A SQL query walks into a bar and sees two tables. Asks: 'Can I join you?'

--- Mystic BBS v1.12 A49 2023/03/14 (Windows/64)
* Origin: Sector 7 * Mystic WHQ (1:129/215)

thanks!
-Nugax (cbbs)


--- CyberBBS v1.0.11 2023/03/12 [Debian Linux/x64]
* Origin: CyberBBS WHQ BBS | http://www.cyberbbs.co (1:19/40)