Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
YaBB message file formats (Read 6129 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
YaBB message file formats
18.11.07 at 21:55:44
 
YaBB message file formats
 
I am trying to understand the YaBB file formats in the hope I can build some software that uses the contents of the messages posted on the boards.
 
There are 2 files per message that seem to be important. There is a .CTB file and a .TXT file. An example of both files is given below:
 
.CTB file example:


sqlxlfeatures
9
1918
martin
1130252208
00
1180933572|admin|0

Back to top
 
« Last Edit: 18.11.07 at 21:59:33 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: YaBB message file formats
Reply #1 - 18.11.07 at 22:01:42
 
.CTB file definition


line 1: sqlxlfeatures
line 2: 9
line 3: 1918
line 4: martin
line 5: 1130252208
line 6: 00
line 7: 1180933572|admin|0


 
Explanation of each line in the file:

  • line 1:  
    The board name where the message is listed (sqlxlfeatures)
  • line 2:  
    The number of replies to this message. In total there are 10 texts. This is the number of records in the .txt file.
  • line 3:
  • line 4:
    Name of the user posting the original message. (martin)
  • line 5:
    Date and time of last reply. Unit: the number of seconds since 1/jan/1970.
    (1130252208; this converts to 25-okt-2005 14:56:48)
  • line 6:
  • line 7:
    There are 3 fields:

    • field 1:
      (1180933572; if this is a date it converts to 04-jun-2007  05:06:12)
    • field 2:
      (admin)
    • field 3:
      (0)
Back to top
 
« Last Edit: 18.11.07 at 22:18:03 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: YaBB message file formats
Reply #2 - 18.11.07 at 22:29:47
 
For each message and reply there is an entry in the .txt file. Definition of the fields in each entry. Example entry:
 


Running multiple selects in different cells|martin|martin@yahoo.com|1130252208|martin|xx|0|123.456.789.1|As mentioned above, due to the formula getting too large I have had to use the ...||||


 

  • field 1: Subject
    (Running multiple selects in different cells)
  • field 2: User
    (martin)
  • field 3: User email address
    (martin@yahoo.com)
  • field 4: Date and time of posting
    (1130252208; converts to 25-okt-05  14:56:48)
  • field 5: User
    (martin)
  • field 6: ?
    (xx)
  • field 7: ?
    (0)
  • field 8: IP address of user
    (123.456.789.1)
  • field 9: Message text
    (As mentioned above, due to the formula getting too large I have had to use the ...)
  • field 10: empty?
  • field 11: empty?
  • field 12: empty?
  • field 13: empty?

Back to top
 
« Last Edit: 18.11.07 at 22:31:56 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1