home *** CD-ROM | disk | FTP | other *** search
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- ::::::::::::::: ::::::::::::: ::::::::::::::
- :::::::::::::::: ::::::::::::::: ::::::::::::::::
- ::::: ::::: ::::: ::::: ::::: ::::::
- ::::: ::::: ::::: ::::: ::::: :::::
- :::::::::::::::: ::::::::::::::::: ::::: :::::
- ::::::::::::::: ::::::::::::::::: ::::: :::::
- ::::: ::::: ::::: ::::: ::::: :::::
- ::::: ::::: ::::: ::::: ::::: ::::::
- ::::: ::::: ::::: ::::: ::::::::::::::::
- ::::: ::::: ::::: ::::: :::::::::::::: Plus
-
-
- Remote Access Database v2.12
-
- (dBASE III & dBASE III Plus Compatible)
-
- Copyright (C) 1990 Overerx Inc.
- Box 323 Sta A, Kingston, Ontario, Canada K7M 6R2
- Harvey Parisien * FidoNet 1:249/114
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- RAD Plus - Remote Access Database
-
-
-
-
-
-
-
-
-
- Background / What is RAD?
-
-
-
- RAD v1.00 series has been around for a while now. It is a
- simple online database system with it's own dedicated file
- structure. It is simple to operate, and serves a purpose.
- Primarily it is directed towards BBS use. It is available on
- a shareware basis and distributed via SDS (Software
- Distribution System).
-
- RAD Plus v2.00 series is the commercial version which is in
- dBASE III format file structure for optimum flexibility and
- compatibility with current and future environments. It tends
- to simulate standard dBASE<tm> type commands, which are
- familiar to dBASE users. It is also offered on a shareware
- basis and distributed via SDS.
-
- This document will deal only with RAD Plus, but will simply
- make reference to the name RAD to save key strokes.
-
- We will refer to the RAD Operator, and the RAD User. The RAD
- Operator is the System Operator (SysOp) or the System
- Administrator whatever the case may be. The RAD User is the
- remote caller.
-
- RAD is designed with many considerations to offer maximum
- security to the BBS SysOp, and in non-bbs (less secure)
- environments. However, the concern for security does not
- make remote maintenance difficult for the RAD Operator. All
- maintenance can be performed remotely with the correct
- security level. For non-bbs type setups, you may request
- from the author a Host/Terminal system which will allow
- control of your computer remotely (including file transfers),
- and can be used to answer the phone for RAD, clear passwords,
- and so on (it will create a dorinfo1.def exit file - more on
- that later). HTERM is a nice terminal for the remote user as
- well, written by the author of RAD. It is available as
- freeware on most BBS systems, or request HTERM from the
- FidoNet address stated below.
-
-
-
-
-
-
-
-
-
- Page 1
- RAD Plus - Remote Access Database
-
- Files required to setup RAD...
-
- RAD comes in an archived format. We use LHA as our standard, but some BBS's or
- distribution systems may convert the archive structure. The archive name is
- usually RAD???.LZH where ??? is the version number. IE: RAD209.LZH is the
- archive for version 2.09.
-
- The files in RAD???.LZH are:
-
- DB.EXE A dBASE III file editor (used for setup).
- DB.DOC Documentation for above.
- * RADPLUS.EXE RAD the program.
- RADPLUS.DOC This document.
- * RADCFG.DBF RAD's main configuration file.
- * RADDIR.DBF RAD's file directory/file subject file.
-
- * = required for RAD to operate.
-
- ARTICLES DBF Sample database...
- BOOKS DBF Sample database...
- SERVICES DBF Sample database...
- SUPPORT DBF Sample database...
-
- INFO.TXT Some general information text files...
- RAD2??.SDA Some general information text files...
-
- REGISTER.TXT An application for to register RAD.
-
- DORINFO1 DEF Sample exit file (created by BBS or other answering devices)
-
- The only files required to run RAD are the ones marked with a *. Your security
- levels and modem information etc. are contained in RADCFG.DBF and RADDIR.DBF.
- Let's look at each file and discuss them in detail. Use DB.EXE to edit both
- RADDIR.DBF and RADCFG.DBF for your initial setup.
-
-
- RADCFG.DBF
-
- Record: 1 of 1
-
- SYSOP_NAME :Harvey Parisien :
- SYSTEMNAME :The Lighthouse BBS :
- Reserved : :
- LEVEL1 : 5:
- LEVEL2 : 20:
- LEVEL3 : 40:
- LEVEL4 : 100:
- USAGE_LOG : :
- DOOR_INFO :dorinfo1.def :
- MIN_TIME : 5:
- MAX_TIME : 120:
- COM_PORT :COM1:
- MAX_BAUD :2400 : (NOTE: by an L in this field, it will lock the baud rate
- USE_SCREEN :T: ie: 19200L )
-
- SYSOP_NAME is the name of the System Operator (can be a department or company
-
- Page 2
- RAD Plus - Remote Access Database
-
- name also), and SYSTEMNAME is the BBS name (can be just an internal system name
- of any sort). The next field is reserved for future expansion.
-
- Level1 through to level4 are basically translation tables to translate your
- numeric security levels from your BBS, to RAD's 4 basic user levels. In the
- scenario above, in order to have level 3 access, your BBS access level must be
- at least 40 or greater.
-
- If you would like RAD to keep a usage log for you, enter a complete drive spec
- and path for your log file. The log will record logons, and database changes,
- and each applicable record number. Here's an example...
-
- + 29 Sep 21:09:25 BINK end, Binkley 2.40
- + 01 Oct 19:21:00 MAX Begin, v2.00
- + 01 Oct 19:21:01 MAX Harvey Parisien calling (U#=0)
- # 01 Oct 19:21:02 MAX Given 10000 min.
- # 01 Oct 19:21:10 MAX External program: `C:\bc7\bin\radplus.exe /pC:\max\rad'
- + 01 Oct 19:21:11 RAD Begin, v2.09 (user='HARVEY PARISIEN')
- + 01 Oct 19:21:11 RAD File write: SUPPORT.DBF # 59
- + 01 Oct 19:21:11 RAD End, v2.09
- : 01 Oct 19:21:31 MAX Return from: `C:\bc7\bin\radplus.exe /pC:\max\rad' (0)
- + 01 Oct 19:21:34 MAX Harvey Parisien off-line. Calls=429, Len=0, Today=0
- : 01 Oct 19:21:35 MAX End, v2.00 (5)
-
- As you can see, RAD has a log format compatible with Binkley, and/or Maximus.
- There are 3 entries above...
-
- DORINFO1.DEF is a standard exit control file produced by QuickBBS and other
- popular BBS systems, containing the current users information. As your BBS
- system exits to operate an external program like RAD, it writes this little
- file to allow the external program to read it and have the current transfer
- information. Take a look at the file description that follows for the type of
- information it contains. If you describe dorinfo1.def complete with drive spec
- and path, it will be used to decide whether the user can support ANSI/Color, how
- much time he/she has left online, current access level, etc...
-
- If you do not have a parent system that creates DORINFO1.DEF, let us know and
- we'll try to accommodate. Most BBS systems produce exit control files of one
- type or another, and there are many little conversion programs available on
- BBS's that will convert from one to another. In that case you would have to run
- RADPLUS from a batch file. For example
-
- Sample batch for systems that don't produce dorinfo1.def
-
- WINGWANG ... THE BBS SYSTEM
- CONVERT ... THE CONVERTER (changes wingwang.xit to dorinfo1.def)
- RADPLUS ... RADPLUS
-
- Sample dorinfo1.def...
-
- The Lighthouse BBS ;Systems name
- HARVEY ;SysOps first name
- PARISIEN ;SysOps last name
- COM1 ;Current port
-
- Page 3
- RAD Plus - Remote Access Database
-
- 2400 BAUD,N,8,1 ;Current connection information
- 0
- JOHN ;User's first name
- SMITH ;User's last name
- KINGSTON, ON ;User's address
- 1 ;ANSI on/off flag
- 20 ;User's SECURITY LEVEL
- 59 ;User's MAX TIME ALLOWED (balance of time from recent
- BBS activities)
-
- The next fields MIN_TIME and MAX_TIME are online time limits, and are in
- minutes. If you enter information here, it overrides dorinfo1.def (can be used
- for systems that don't produce proper dorinfo1.def's to limit access time). IE,
- if your user has 90 minutes left online and your MAX_TIME is set to 10, then
- he/she will have 10 minutes in RAD only. It is recommended that you set
- MIN_TIME to 0 if it is your intention to NOT allow further access once a users
- time has run out.
-
- Your COM_PORT must be described as COM1, COM2, COM3, or COM4.
-
- Your MAX_BAUD can range from 300 baud to 115200 baud.
-
- The USE_SCREEN field is a logical setting of T or F (true or false). If you set
- this to F then the screen will remain BLANK during RAD operations. This may be
- desirable for multitasking situations. Normally this would be T. It is
- possible for the SysOp while the user is online to turn the screen ON or OFF by
- pressing F2 (snoop) on the HOST system. It is also possible for a user with the
- maximum level 4 setting to turn the screen on or off remotely.
-
- RADDIR.CFG
-
-
- Record: 1 of 8
-
- FILE :RADCFG.DBF :
- SUBJECT :RAD Main Configuration File :
- DISPLAY_ON :T:
- USER_NOTES :SYSOP :
- DISPLAY1 :Keep this file marked private :
- DISPLAY2 : :
- DISPLAY3 :This file contains your setup and default information. :
- DISPLAY4 : :
- DISPLAY5 :Use DB3ED (DB.EXE) or RAD to edit this file. :
- DISPLAY6 : :
- DISPLAY7 :NOTE: Leave the field DOOR_PATH blank if you will be :
- DISPLAY8 : using RAD offline only! :
- PASSWORD :YOURPASSWORD :
- MIN_LEVEL :4:
-
- This database file contains the FILE name and SUBJECT line for each file that is
- to be displayed by a DIR command online. If a *.dbf file exists and is not
- recorded in the RADDIR file, it will show up in a DIR, but will have a ? for
- subject line and have no password or minimum level access requirement. The
- third field DISPLAY_ON can be set to T or F. It determines whether the Display1
- through to Display8 fields are displayed when the file is accessed with a DIR
- command. Display1 to Display8 are not displayed when the file is accessed using
-
- Page 4
- RAD Plus - Remote Access Database
-
- a USE command. See the next few screens which simulate the DIR and file
- selection screens. USER_NOTES can be anything you like. The person who lists
- the file usually puts his/her John/Martha Henry here. PASSWORD is your 16
- character password required for this file. You don't need a password for the
- MIN_LEVEL system to work. The MIN_LEVEL is an absolute minimum access level
- required to even have the ability to enter a password. The TWO levels of
- security for each database file should cover most situations. MAKE SURE YOUR
- RADCFG.DBF AND RADDIR.DBF FILES ARE BOTH PASSWORDED AND SET TO 4 AS THE
- MIN_LEVEL. If you do not want to allow online editing of these two files by a
- remote SysOp who has level4 access, then set the MIN_LEVEL to 5 so they can't be
- accessed at all.
-
- Here is a DIR simulation from the dot prompt...
-
- .dir
-
- RAD v2.09 - Remote Access Database - Copyright (C) 1990 Overerx Inc.
-
- # Filename Records Updated Subject
- 1 BBSLIST.DBF 1280 11/04/90 A list of BBS's with >= 100megs online
- 2 DB.DBF 3 11/04/90 A list of contacts for local services...
- 3 IDEAS.DBF 1 11/04/90 Ideas for RAD databases ...
- 4 SUPPORT.DBF 68 11/04/90 Computer related product support lines
-
- Enter # _
-
- NOTE: RADCFG.DBF and RADDIR.DBF will not be displayed in a Directory.
-
- When you enter RAD, you are presented with a pretty nifty title page (free ad
- for me), and then displayed your current stats like the following session
- simulation.
-
-
- RAD v2.09 - Remote Access Database - Copyright (C) 1990 Overerx Inc.
-
- 11/05/90 9:48a
-
- Registered to.......... The Lighthouse BBS
- System Operator........ Harvey Parisien
- User................... HARVEY PARISIEN
- User level............ 4
- Balance online time... 19 minutes
-
- Hello HARVEY ...
-
- CHOICE: Help Dir Find Browse N]ext Prev Goto List Info Add Edit Cmd Quit _
-
-
- Rad starts up in MENU mode. If the user has ansi.sys installed, they will be
- displayed a lotus like menu bar which has a description of each function in the
- menu bar itself. For non ansi users, the basic menu bar shown above is used.
- Alternatively, you can choose command mode, which gives you a DOT prompt like
- dBASE. In command mode you have the following commands, which can be displayed
- anytime by entering the command HELP.
-
-
-
- Page 5
- RAD Plus - Remote Access Database
-
- .HELP
-
- Command: Function: Level:
- / Invoke command MENU option. 1
- HELP (or ?) Display this screen 1
- INFO Display system and user information 1
- CLS Clears Screen and Resets FIND search to ALL 1
- DIR Displays directory of *.DBF files 1
- USE filename.dbf USE or LOAD database (.dbf not required) 1
- LIST STRUCTURE List the file structure for the current database 1
- FIND text FIND and display record matching text 1
- BROWSE text FIND and list records (max fields that fit on one line) 1
- NEXT FIND and display NEXT record (or just press ENTER) 1
- PREV More to previous record 1
- GOTO n where n is the record number (also GOTO FIRST or LAST) 1
- COUNT FIND and COUNT occurrences of FIND 1
- SUM fieldnumber Add contents of a field and display total 1
- ADD ADD (or append) a new record 2
- EDIT n n is an optional record number (default = current record) 2
- DELETE n n is an optional record number (default = current record) 2
- CREATE Closes current file, and prompts for creation details 3
- PACK Pack current database (removes deleted files) 3
- SORT fieldnumber SORT database on a field (will prompt for fieldnumber) 3
- QUIT Exit program (closes all files) 1
- .
-
-
- The online commands will be very intuitive to dBASE users and non dBASE users
- alike. The screens and prompts should provide adequate information for the
- typical user online.
-
-
- SYSOP FUNCTIONS
-
- USER: Joe Blow PARAM: COM1:2400,N,8,1,RB1024,XON LEVEL: 3
- 1 CHAT |2 SNOOP|3 |4 |5 |6 JUMP |7 |8 |9 LEVEL|10 HANG
-
- The last two lines on your HOST screen remain in position at all times. They
- constantly display the Users name, and current communications data. It shows
- the users level which can be toggled with F9. OK, let's continue from right to
- left just to be different. F10 causes an immediate hang up to which the user is
- given no indication or warning as to what happened. F6 allows the host to jump
- to DOS. F2 allows the HOST to toggle the HOST screen on/off. F1 allows the
- host to enter into CHAT mode, where both host and user can chat to each other
- with their keyboards. By the way, when a users time online gets to be 2 minutes
- or less, he/she is given a warning to that effect (even if in chat mode). They
- can always enter INFO to see their current status.
-
-
- Operating RAD Plus from the command line, or a parent program.
-
- RADPLUS /Pdrive:fullpath
-
- IE: from a DOS prompt... D:\>c:\dbase\radplus /Pc:\dbase
-
- drive:path is where RADPLUS.EXE RADDIR.DBF RADCFG.DIR AND *.DBF files are kept.
-
- Page 6
- RAD Plus - Remote Access Database
-
-
- If no path is given the current directory is assumed.
-
- IE: QuickBBS type 7 command line: c:\rad\radplus.exe /Pc:\rad
-
- IE: Maximus control lines for menus.ctl ...
- NoDsp Display_File misc\dorinfo Privil "Radplus"
- Xtern_Run C:\max\rad\radplus.exe_/pC:\max\rad Privil "Radplus"
-
- It is important that if /P is used, that the path is complete with drive spec
- as in these examples.
-
- If you are operating RAD locally (ie from your BBS in local mode) it will
- sense there is no carrier so it requires you to press L to enter locally or
- it exits back to the board automatically. RAD has a built in carrier detect
- system. If carrier is dropped while a user is in RAD (or on their way to rad),
- it gracefully exits back to your board and let's your board do it's own thing.
-
-
-
- MISC FEATURES
-
- LOCK_EDIT
-
- If the first field name in a database is called LOCK_EDIT, then the record will
- will automatically be restricted in terms of a users ability to edit it. When a
- record is added, the current users name is automatically inserted into the
- LOCK_EDIT field. This field can not be changed (except by the SysOp Level4).
- To Edit the record, you must be the user, or have level4 access.
-
- AUTOEXEC.RAD
-
- If a file called Autoexec.RAD exists in the Rad directory, RAD will look in tha
- file on the first line for a filename. If it's a legal name IE: XXXXXXXX.DBF it
- will automatically be loaded.
-
- Locked baud rates are supported now, just put an L as the last character of your
- MAX_BAUD field in radcfg.dbf.
-
- Multiuser nodes can use RADPLUS now without using separate directories. While a
- database is in use, it is stamped as ????????.BSY (like the system used by
- BinkleyTerm).
-
-
-
-
-
-
-
-
-
- This program is shareware. It may be used for a 20 day trial period, and then
- must be registered.
-
-
-
-
- Page 7
- RAD Plus - Remote Access Database
-
- Distribution, and Registration
-
-
- RAD is marketed as shareware. It may be used for a 20 day
- trial period, and then must be registered.
-
- RAD is fully functional. There are no timers, or limits
- imposed. There are no keys required for installation. Your
- honesty is our only protection against insufficient
- development funds, and we have learned to trust in that.
-
- To register, please fill out the REGISTER.TXT application.
- You can load it into your word processor or editor, and edit
- it, or copy it to your printer and do it by hand (COPY
- REGISTER.TXT PRN).
-
- Harvey Parisien
- Box 323 Station A
- Kingston, Ontario
- Canada K7M 6R2
-
- Registering RAD is only necessary once, and entitles you
- to new versions of RAD as they are released. The latest
- versions of RAD will be available on your favorite SDS
- system, or directly from FidoNet 1:249/114.
-
-
- Registration is $75.00.
-
- Non Commercial BBS SysOps may register RAD Plus for $ 25.00.
-
-
-
- Page 8
- RAD Plus - Remote Access Database
-
-
-
- LEGAL STUFF
-
- DISCLAIMER - This program is provided as is. You may use it
- at your own risk. There is no warranty of any kind or any
- form covering this program. The author may in no way be held
- liable for any damage of any form in connection or arising
- from the quality and/or use of this program and any
- associated files included with it.
-
- Registered users feel free to contact me via NETMAIL, or by
- calling my BBS for instant support...
-
- Harvey Parisien, FidoNet 1:249/114
- 613-389-3992 BBS
-
-
- ** YOUR FEEDBACK, AND SUPPORT IS APPRECIATED **
-
-
- Page 8
-