#
# Configuration file for the forms to flat database scripts
#
#  Rob Hartill March 1994 - but revised by DJB 1997

#
#Add the following to get inline GIFs as part of the information returned as
#a result of a query:
#change OUTPUT_FORMAT to include <IMG SRC=\"FIELD[x]\">

#where FIELD[x] is the field containing some pointer to
#the thumbnail gif.
#Remember you can put whatever text you want into the
#OUTPUT_FORMAT.


####
#   Set to 1 if you want to see what the equivalent GET URL should look like
$VERBOSE = 0;

####
# used only by appendref, this is the field number (starting at 1, sorry)
# that contains the image number.
$Key_Field_Number=9;

####
#The names of the fields of the database:
#these just let you give names to the fields, so that when
#checking the query, it names the fields.
#Change them to whatever you want.

@field_names = ("monument","location","commissioner","type","material","date", "artist", "detail", "imagenumber");

####
#   The name of the person to email any comments to
$who_to_mail = "Michael.Greenhalgh@anu.edu.au";

####
#   The datasbase path and name
$DATABASE_FILENAME = "/raid2/newimages/htdocs/bycountry/italy/rome/popolo/pics/alphabetical/newerdb";

$FORM_FILENAME = "/raid2/newimages/htdocs/bycountry/italy/rome/popolo/light_table/popolo.html";

####
#FIELD[n] refers to the nth field of the datafile. OUTPUT_FORMAT
#can however contain any text you want.

# Note the next 3 or so lines are all one string for $OUTPUT_FORMAT. DJB
# AUTODIR[x] will get FIELD[x] and convert to a directory name with 4 digits.
# SAVEFILE will get the value of the variable $Save_file_name
# eg. 14236 becomes 0142/14236
# \033 means an optional break.
#   The format of matching records

$IMAGE_FIELD=9;

$OUTPUT_FORMAT = "<b>FIELD[0] FIELD[1]</b> FIELD[2] FIELD[3]\033 FIELD[4] FIELD[5]\033\n FIELD[6] FIELD[7]<br>\n";

$THUMB_FORMAT =
" <a href=/htdocs/bycountry/italy/rome/popolo/pics/AUTODIR[9]/PFIELD[9].JPG>\n".
" <IMG SRC=\"/htdocs/bycountry/italy/rome/popolo/pics/AUTODIR[9]/PFIELD[9].GIF\">\n".
" </A>\n";

$CHOOSE_FORMAT =
"<inPUT TYPE=\"CHECKBOX\" NAME=\"SAVE_FIELD[1]\" VALUE=\"ON\">\n";
$CHECKED_FORMAT =
"<inPUT TYPE=\"CHECKBOX\" NAME=\"SAVE_FIELD[1]\" VALUE=\"ON\" CHECKED>\n";
$SORT_FORMAT =
"<inPUT TYPE=\"TEXT\" SIZE=5 NAME=\"SAVE_FIELD[1]\" VALUE=\"SORT\">\n";

#$CHOOSE_FORMAT = "<dt><b>FIELD[6]</b> FIELD[3] FIELD[5]\n" .
#" <a href=http://www/ArtHistory/pics/AUTODIR[2]/FIELD[2].JPG>FIELD[7]</a>\n" .
#" (FIELD[4] century)<br>\n";

# Number of records to hold before printing: ie. how many thumbnails accross.
$THUMBS_ACCROSS = 4;
# Number of rows of records to print before giving up and just counting them.
$MAX_ROWS = 3;
# same for light_table final output
$ACCR=2;
$DOWN=3;

####
#   The character used to separate database fields
$FIELD_SEPARATOR = ',';

####
#   Some messages to print at the top and foot of the output
$START_CHECK_MESSAGE = "Please select the items you would like to search for";
$END_CHECK_MESSAGE ="<hr>Whatever text or HTML appears here, will appear at the bottom of the check query page";

$START_SEARCH_MESSAGE = "Here are the results from the search..<hr><p>\n";
$END_SEARCH_MESSAGE =
 "<p>Click <a href=/> here for the home page</a>...";

#the location of the images for pmbtools
$imageroot="//htdocs/bycountry/italy/rome/popolo/pics/";
#"/public/pub/htdocs/extra5/piranesi/";
$imageroothttp="//htdocs/bycountry/italy/rome/popolo/pics/";
#"/public/pub/htdocs/extra5/piranesi/light_table";
$uploaddir="/public/pub/light_table_upload/";

$uploadhttp="/light_table_upload/";
$uploadftp="ftp://rubens/light_table_upload/";

$imagehttp="/.megatemp/light_table/";
$imagedir="/public/pub/htdocs/.megatemp/light_table/";

################ nothing below this point needs changing ###################

####
#   Define some constants   

$ANDING    =1; 
$ORING     =2;
$YEARS     =3;
$CENTURIES =4;
$REG_EXP   =5;