DataBase Manager

---

DataBase Manager - Do you familiar with Selena Sol's Cgi Scripts Archive, if you don't - hurry and make a bookmark to http://www.extropia.com/products.htmlAfter learning about great DataBase Manager Selana gives you for free (ver. 5.01) come back and get the same Tool but more expanded and extended
Actually it's optimised for the One way User Interaction - User can Only submit an information about himself, He can order goodies. And Two Way Admin Interaction -As Admin you can view the DB of Users, Modify their data, Delete users, Add them manualy, Send them Email reminders
So you will ask what's the difference with the Selena's Tool ?

• The DB is splitted to multiply DB files one per month - this improves the speed of interaction with DB, when quering within a range of dates.
• New Query options: Include and Exclude fields
• New Sorting Options: ByNumber, ByDate , Reverse
• New Query Result Formats: More hits option (dynamically), Slim format to be able to print the query , you can specify how many cells per row to be printed.
• Full support for commercial usage: 
• Email validation
• Credit card Number encryption (a very simple one)
• Credit card Number Validation
• If you get your hands on the stolen card list it even check against that list.,
• Tax calculation mechanism
• Total price
• Email reminders mechanism
• Form's entries validation
• Files with predefind templates to respond to the Client's browser/email
• New sorting options (reverse, bydate , by nember)
• A few minor fixes to the original DB Manager
• File locking fixes (very important) Read a new File locking rutines. If you not convinced that the old get_file_lock routine can trash you DB. run trash.pl script by running it
  trash.pl &;trash.pl &;trash.pl &;
  and then killing the first script. see how the two other will interlieve their output.Don't worry itjust writes to "out-file". Do
  tail -f out-file
  to see the out put in real time.

The last version is 1.01 (07/18/97) .
Download dbmanager.tar.gz or dbmanager.zip

Installation and Documentation: I have tried to keep it documented by the Selena's style. So you will find all the explanations inside the script (I didn't write the README yet). Just run it first to see all the options and then tune it for your needs. All you need is to config the ./Setup_files/sample.setup file and you can run the script by logging in as "stas" passwd "Stas". Be sure to change it after.

Support: Please use Selena's Documentation and Selena Sol's Web Conferencing System I have a very little time to help you out. So I hope I'll have a time to answer the questions about my extensions. Or do it simpler - dig into the code - perl is as intuitive as the language you talk. WYTIWYT - What You Think Is What You Type :-)

History:

• 03-20-97:
• The first upgrade to the Selena's Work. Read about new features
• 07-18-97 Two bug fixed:
1. sub subroutine(){ -> sub subroutine{
   (perl4 didn't accepted this)
2. Fixed the memory of the script when doing more-hits, to remember the parameters which were inserted in the search(filter) form