This is a software which enables that every sent fax is logged in mySQL
table. Table's name is ``fax'' in database ``telcent''. These names are
#defined whereever possible. This is relatively simple log of output faxes.
Fax table has a following structure :

Field	Type	Null	Key	Default	Extra
DATET	int(4) unsigned		PRI	0	
DATUM	varchar(11) binary			2001-08-02	
VREME	varchar(11) binary			01:05:00	
KORISNIK	varchar(20) binary		MUL	NEPOZNAT	
DEVICE	varchar(10) binary			/DEV/NULL	
BROJ	varchar(20) binary		MUL	NEPOZNAT	
CSI	varchar(10) binary			NEPOZNAT	
BROJSTRANA	int(4) unsigned			1	
FAX	longblob				

OR if you like a create statement:

CREATE TABLE fax (
	DATET INT (4) UNSIGNED DEFAULT 0 NOT NULL PRIMARY KEY,
	DATUM CHAR (11) BINARY DEFAULT "2001-08-02" NOT NULL,
  VREME CHAR (11) BINARY DEFAULT "01:05:00" NOT NULL,
	KORISNIK CHAR (20) BINARY DEFAULT "NEPOZNAT" NOT NULL,
	DEVICE CHAR (10) BINARY DEFAULT "/DEV/NULL" NOT NULL,
	BROJ CHAR (20) BINARY DEFAULT "NEPOZNAT" NOT NULL,
	CSI  CHAR (10) BINARY DEFAULT "NEPOZNAT" NOT NULL,
	BROJSTRANA INT (4) UNSIGNED DEFAULT 1 NOT NULL,
	FAX LONGBLOB NOT NULL,
	INDEX (KORISNIK), INDEX (BROJ)
);

Change NEPOZNAT to UNKNOWN or what so ever. This log is presented with
www-sql module for apache (get it at www.tcx.se), and it generates a link 
on faxes, which when clicked outputs image in Netscape or IE.

For it to function you must configure Apache server to accept www-sql for 
files with extension .sql, change in it your server name (do not use https,
as I have, but http). Server name should be changed in faxlog.sql, instead
of 200.0.0.33 (my PC masqueraded and invisible on Net) put your own server.
Instead of cgi-telcent put your own Apache alias, where getfax program is
located.

You also need sendFaxApp.c++, changed to insert data. Compile it with 
-I/usr/local/include/mysql and link with -L/usr/local/lib/mysql -lmysqlclient.
You need a C++ wrapper for mysql. You need faxlog.sql (www-sql script) and 
getfax.cc for getting jpeg pictures into browser. 

All of these are included in this release !!!!


Of external programs you will require convert from ImageMagick !!!!!!!


There are few system() calls in faxSendApp.c++. Check them out, because
they contain full paths.

Now, faxlog.sql and create table contain some Serbian names. Here goes trans-
lation:

Datum -  Date
Vreme -  Time
Korisnik - User
Broj     - Fax number
Brojstrana (or Broj Strana) - Number of pages

TODO:

 I am working on a Partners project (with FAST CGI), which would make 
 possible fast searching of partner names and addresses, phone , fax
 numbers etc . When I finish (I have barely started) this I shall make
 a new log where you could see WHO received a fax. This will also make
 possible for NT/95 Hylafax Client (whfc) to access a phonebook through
 ODBC !!!!!!


mailto: sinisa@coresinc.com

