bbsdbpl

Perl scripts for using an SQL database for a Fidonet/FTN compatible BBS.
The SQL database engine is one for which a Perl DBD module exists,
defaulting to SQLite.


Copyright (c) 2001-2004,2010 Robert James Clay.  All Rights Reserved.
This is free software;  you can redistribute it and/or modify it under
the same terms as Perl itself.

==================


Files
----------------
areasbbstable.pl  Perl script that creates a areasbbs table
createarea.sh     Example shell script that uses echotable.pl 
areatable.pl      Perl script that creates a message (echo) table

msgpost.sh        Shell script that uses txt2bbs.pl to post to an echo area
txt2bbs.pl	  Perl script that posts to a message (echo) area
t/tstpost.txt	  Example message body to be posted

desc2bbs.sh	  Example shell script that uses desc2bbs.pl
desc2bbs.pl	  Perl script that adds descriptions to conferences
t/areadesc.txt	  Example Conference (echo) description file

bbs2txt.pl	  Perl script that extracts a message from the bbs & puts
		  to a text file. 
bbs2txt.sh	  Example shell script using the bbs2txt.pl script to bring out
		  msgs to a text file from an SQL (Mysql) based database.

bbs2pkt.pl	  Perl script that extracts a message from the bbs & puts it
		  to FTN packet file. (not yet even a skeleton of a script...)
bbs2pkt.sh	  Example shell script using the bbs2pkt.pl script to bring out
		  msgs to an FTN packet from an SQL (Mysql) based database.

pkt2bbs.pl	  Perl script that extracts messages from an FTN packet to
		  an echo area.
pkt2bbs.sh	  Example shell script using the pkt2bbs.pl script to bring
		  in the msgs in an FTN packet to an SQL (Mysql) based database.

txt2bbs.pl	  Perl script that extracts messages from a text file & posts
		  it to an echo area.
txt2bbs.sh	  Example shell script using the txt2bbs.pl script to bring
		  in a msgs from a text file to an SQL (Mysql) based database.

setup.sh	  Shell script that creates/recreates the various tables  
		  for bbsdbpl scripts to use.

ftndbtst.pl 	  Perl script that creates a test ftn mysql database (get from 
                  ftnpl.sf.net site, if not with this).

README            This file

doc/		  Docs or ref's to docs
doc/TODO	  What needs to be worked on
doc/Changes	  History of changes...
t/		  Various test related files	

========================

Jame
    Robert J. Clay, jame@users.sf.net
    http://ftnpl.sourceforge.net
    Sysop, 1:120/544, ftn.rocasa.us