TBBS2DBF: description of fields used. ------------------------------------- Field Name Type / Length Description ========== ============= =========== OLD_NAME Character 30 "Old" user name (*1) USER_NAME Character 30 Name USER_LOCN Character 30 Location ADDR1 Character 30 Address #1 (*2) ADDR2 Character 30 Address #1 (*2) CITY Character 30 City (*2) STATE Character 30 State (*2) ZIP Character 30 ZIP (*2) PHONE Character 30 Telephone # (*2) COUNTRY Character 30 Country (*2) PASSWORD Character 8 Password NOTES Character 64 Notes comment field PRIV Numerical 0-255 Priv Level A1_FLAGS Character 8 A1 Flags (*3) A2_FLAGS Character 8 A2 Flags (*3) A3_FLAGS Character 8 A3 Flags (*3) A4_FLAGS Character 8 A4 Flags (*3) TERM_NULLS Numerical 0-50 Terminal Nulls needed after CFG_IBM Logical 8-bit Graphics allowed CFG_ANSI Logical ANSI allowed CFG_UPCASE Logical Upper Case only CFG_LFEED Logical Line Feed required after T_WIDTH Numerical 10-132 Terminal column width CLS Character 6 Clear Screen codes LOGONS Numerical 0-64k Total No. of Logons EXPERT_LVL Numerical 0-2 User Expert Level L_MSG_READ Numerical 0-64k System-wide Last Message Read RVW_FULLAC Logical Review Flag: Full Access RVW_CRASHM Logical Review Flag: Crash Mail allowed RVW_FREEML Logical Review Flag: Mail with 0 credit RVW_RDNEWS Logical Review Flag: News File read once RVW_REVIEW Logical Review Flag: Reviewed by Sysop RVW_KEEP Logical Review Flag: "Keep" protected RVW_DELETE Logical Review Flag: Marked for Deletion TIME_LIMIT Numerical 0-255 Per-call Time Limit LAST0_DATE Date Date of Last call LAST0_TIME Character 4 Time of Last call LAST1_DATE Date Date of Last call -1 LAST1_TIME Character 4 Time of Last call -1 LAST2_DATE Date Date of Last call -2 LAST2_TIME Character 4 Time of Last call -2 LAST3_DATE Date Date of Last call -3 LAST3_TIME Character 4 Time of Last call -3 LAST4_DATE Date Date of Last call -4 LAST4_TIME Character 4 Time of Last call -4 LAST5_DATE Date Date of Last call -5 LAST5_TIME Character 4 Time of Last call -5 LAST6_DATE Date Date of Last call -6 LAST6_TIME Character 4 Time of Last call -6 LAST7_DATE Date Date of Last call -7 LAST7_TIME Character 4 Time of Last call -7 LAST8_DATE Date Date of Last call -8 LAST8_TIME Character 4 Time of Last call -8 LAST9_DATE Date Date of Last call -9 LAST9_TIME Character 4 Time of Last call -9 SYS_FLAGS Character 8 System Flags MSG_WTG_NO Numerical 0-64k Message Waiting Chain Head (msg#) DOWNLOADED Numerical 0-4.2gig Total Bytes Downloaded UPLOADED Numerical 0-4.2gig Total Bytes Uploaded DL_LIMIT Numerical 0-4.2gig Download bytes/day limit CALL_LIMIT Numerical 0-255 Call/day limit CALL_TODAY Numerical 0-255 Calls made in last day MINS_LIMIT Numerical 0-1440 Mins/day limit MINS_TODAY Numerical 0-1440 Mins used in last day BC0_L_HRS Numerical 0-64k Billing Class 0: Authorised time limit, Hrs BC0_L_MINS Numerical 0-59 Billing Class 0: Authorised time limit, Mins LOT_HRS Numerical 0-64k Total logged-on time, Hrs LOT_MINS Numerical 0-59 Total logged-on time, Mins BC0_R_HRS Numerical 0-64k Billing Class 0, time REMAINING, Hrs BC0_R_MINS Numerical 0-59 Billing Class 0, time REMAINING, Mins DL_TODAY Numerical 0-4.2gig Bytes downloaded in the last day PAGELEN Numerical 0-250 -more- lines per page (0=no pause) NET_CREDIT Numerical 0-64k Netmail credit, cents NET_DEBIT Numerical 0-64k Netmail Debit, cents INVISIBLE Logical Invisible user, not listed online UP_PROTO Numerical 0-11 Upload Protocol (*4) DOWN_PROTO Numerical 0-11 Download Protocol (*4) MEP_STYLE Numerical 1-3 Line Editor Prompt Style (*5) MEP_POINT Numerical 1-2 Last Message Read Pointer Method (*5) MEP_FSE Numerical 0-2 FSE Mode (*5) MEP_PROMPT Logical "Submit prepared text (y/n)" PWD_CHANGE Date Date of last Password Change CAN_ANSI Logical Logon CAN_ANSI Flag (*6) PWD_EXPIRE Logical Is password expired? AGED_CUBBY Numerical 0-64k # of cubby messages aged out by MFSQZ UL_PTR Numerical 0-4.2gig Pointer to USERLOG.PTR chain (*7) BC1_L_HRS Numerical 0-64k Billing Class 1 Time Limit, Hrs BC1_L_MINS Numerical 0-59 Billing Class 1 Time Limit, Mins BC1_C_HRS Numerical 0-64k Billing Class 1 Total Connect Time, Hrs BC1_C_MINS Numerical 0-59 Billing Class 1 Total Connect Time, Mins BC2_L_HRS Numerical 0-64k Billing Class 2 Time Limit, Hrs BC2_L_MINS Numerical 0-59 Billing Class 2 Time Limit, Mins BC2_C_HRS Numerical 0-64k Billing Class 2 Total Connect Time, Hrs BC2_C_MINS Numerical 0-59 Billing Class 2 Total Connect Time, Mins BC3_L_HRS Numerical 0-64k Billing Class 3 Time Limit, Hrs BC3_L_MINS Numerical 0-59 Billing Class 3 Time Limit, Mins BC3_C_HRS Numerical 0-64k Billing Class 3 Total Connect Time, Hrs BC3_C_MINS Numerical 0-59 Billing Class 3 Total Connect Time, Mins BC4_L_HRS Numerical 0-64k Billing Class 4 Time Limit, Hrs BC4_L_MINS Numerical 0-59 Billing Class 4 Time Limit, Mins BC4_C_HRS Numerical 0-64k Billing Class 4 Total Connect Time, Hrs BC4_C_MINS Numerical 0-59 Billing Class 4 Total Connect Time, Mins BC5_L_HRS Numerical 0-64k Billing Class 5 Time Limit, Hrs BC5_L_MINS Numerical 0-59 Billing Class 5 Time Limit, Mins BC5_C_HRS Numerical 0-64k Billing Class 5 Total Connect Time, Hrs BC5_C_MINS Numerical 0-59 Billing Class 5 Total Connect Time, Mins BC6_L_HRS Numerical 0-64k Billing Class 6 Time Limit, Hrs BC6_L_MINS Numerical 0-59 Billing Class 6 Time Limit, Mins BC6_C_HRS Numerical 0-64k Billing Class 6 Total Connect Time, Hrs BC6_C_MINS Numerical 0-59 Billing Class 6 Total Connect Time, Mins BC7_L_HRS Numerical 0-64k Billing Class 7 Time Limit, Hrs BC7_L_MINS Numerical 0-59 Billing Class 7 Time Limit, Mins BC7_C_HRS Numerical 0-64k Billing Class 7 Total Connect Time, Hrs BC7_C_MINS Numerical 0-59 Billing Class 7 Total Connect Time, Mins BC8_L_HRS Numerical 0-64k Billing Class 8 Time Limit, Hrs BC8_L_MINS Numerical 0-59 Billing Class 8 Time Limit, Mins BC8_C_HRS Numerical 0-64k Billing Class 8 Total Connect Time, Hrs BC8_C_MINS Numerical 0-59 Billing Class 8 Total Connect Time, Mins BC9_L_HRS Numerical 0-64k Billing Class 9 Time Limit, Hrs BC9_L_MINS Numerical 0-59 Billing Class 9 Time Limit, Mins BC9_C_HRS Numerical 0-64k Billing Class 9 Total Connect Time, Hrs BC9_C_MINS Numerical 0-59 Billing Class 9 Total Connect Time, Mins EXPIRY Date Expiration Date Notes ===== 1) The OLD_NAME field should NOT be changed UNDER ANY CIRCUMSTANCES: it is used to "link" the database record with the userlog record, when "merging" the data: it is simply ignored if over-writing the TBBS userlog. When Merging ------------ If the "OLD_NAME" is found in the TBBS userlog (username field), then that record is updated with the rest of the data in that database record: this gives you a way to change the user's name. If the "OLD_NAME" is NOT found in the TBBS userlog (username field), or is BLANK, then the UL_PTR field is zeroed, and the user is added to the TBBS userlog as a new entry: this gives you a way to add new users to the TBBS userlog. Any entries in the TBBS userlog which are not "updated" from the database file are simply left unchanged: thus the use of this pair of programs will only ever GROW the TBBS userlog, and never shrink it! When Over-writing ----------------- As long as you don't mess with the UL_PTR field, your users will not lose any data when over-writing the TBBS userlog. Note that if you delete users from the database prior to importing the data into the TBBS userlog, you will end up with "orphaned" entries in the USERLOG.PTR file. Optionally, the USERLOG.PTR file can be zeroised (and will thus lose all the related data!) NOTE: this program does NO checking for duplicate names: that is the job of your TDBS application. Duplicate names in the userlog are KNOWN to cause problems, and must be avoided at all costs. 2) The text fields ADDR1, ADDR2, CITY, STATE, ZIP, PHONE & COUNTRY have been limited to 30 characters each (simply to save a bit of disk space). If any field is over that size, it will be truncated when exported from the TBBS userlog, and a warning issued to the log file. They are in total limited to 121 characters: if your fields add up to more than this, then the first 121 characters will be used when importing them back into the TBBS userlog, and a warning issued to the log file. (If this 30 characters limit is a problem, let me know, and it can be "tweaked") 3) The A-flags are all 8 characters wide, and each character must be either "X", "x" or ".": anything else will be interpreted as a ".". 4) Upload and Download protocols are as follows: 0 = None (auto select each call) 1 = Prompted Ascii 2 = Ascii, Xon after c/r rcvd 3 = Ascii, Xon/off flow control 4 = Xmodem 5 = Xmodem-1k 6 = Ymodem (batch) 7 = Ymodem-g (batch) 8 = SEALink 9 = Kermit 10 = SuperKermit (sliding Windows) 11 = Zmodem 5) Message Entry Prompt Style flags are interpreted as follows: MEP_STYLE: Line Editor Prompt Style 1 = line # 2 = bytes + line # 3 = plain MEP_POINT:Last Message Read Pointer Method 1 = Highest Read, area-by-area 2 = Lowest NOT Read, area-by-area MEP_FSE: FSE Mode 0 = ask each time 1 = Use FSE 2 = Do NOT use FSE MEP_PROMPT: "Submit prepared text (y/n)" Y/y/T/t = yes N/n/F/f = no 6) The CAN_ANSI flag is transient, in that it is set by the TBBS logon-ansi-poll, and thus can change from call to call. It can be sensibly read, but changing it will have no effect. 7) UL_PTR is the Pointer to the USERLOG.PTR chain: unless you REALLY want to screw up your userlog message etc details DO NOT PLAY WITH THIS VALUE!