KGRKJGETMRETU895U-589TY5MIGM5JGB5SDFESFREWTGR54TY
Server : Apache/2.4.62
System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64
User : www ( 80)
PHP Version : 8.3.8
Disable Function : NONE
Directory :  /domains/thomasjolly1/cgi-bin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /domains/thomasjolly1/cgi-bin/web_store.setup.db
#######################################################################
#                    Global File Location variables                   #
#######################################################################

###

$cgi_bin_location = "/cgi-bin";   #update to the location of your cgi-bin
$image_dir_root = "/cartimages"; #update to the location of the cartimages directory

$sc_sales_tax_form_variable = "05-b_state";
$cart_font_style = "<FONT FACE=ARIAL SIZE=2>";

$sc_cgi_lib_path = "./Library/cgi-lib.pl";
$sc_mail_lib_path = "./Library/mail-lib.pl";

$sc_html_search_routines_library_path = "./Library/web_store_html_search.pl";
$sc_html_setup_file_path = "./Library/web_store_html_lib.pl";

$sc_commerce_subs_path = "./Library/commerce_subs.pl";
$sc_cookie_lib = "./Library/cookie-lib.pl";

$sc_store_header_file = "./Html/headers/store_header.inc";
$sc_store_footer_file = "./Html/footers/store_footer.inc";

$sc_db_lib_path = "./Library/web_store_db_lib.pl";
$sc_order_lib_path = "./Library/web_store_order_lib.pl";
$sc_pgp_lib_path = "./Library/pgp-lib.pl";

$sc_user_carts_directory_path = "./User_carts";
$sc_data_file_path = "./Data_files/data.file";

$sc_options_directory_path = "./Html/Options/";
$sc_html_product_directory_path = "./Html/Products";
$sc_html_order_form_path = "./Html/orderform.html";
$sc_store_front_path = "./Html/frontpage.htm";

$sc_counter_file_path = "./Admin_files/counter.file";
$sc_error_log_path = "./Admin_files/error.log";

$sc_access_log_path = "./Admin_files/access.log";
$sc_order_log_file = "./Admin_files/$sc_order_log_name";

$sc_main_script_url = "cart.cgi";
$error_page = "./Html/Products/error.html";

#######################################################################
#                Database Definition Variables                        #
#######################################################################

$db{"product_id"} = 0;
$db{"product"}    = 1;
$db{"price"}      = 2;
$db{"name"}       = 3;
$db{"image_url"}  = 4;
$db{"description"}= 5;
$db{"options"}    = 6;


@sc_db_display_fields = ("Product", "Description");

@sc_db_index_for_display = ($db{"image_url"},
                            $db{"description"},
                            $db{"options"});

@sc_db_index_for_defining_item_id =
  ($db{"product_id"},
   $db{"product"},
   $db{"price"},
   $db{"name"},
   $db{"image_url"});

$sc_db_index_of_price = $db{"price"};

#
# Db_variables for searching
#
# All query fields should begin with
# sc_query_ so that they will be passed
# from screen to screen as hidden variables
# if they have value
#
# Special query input form fields are
# sc_db_exact_match = "yes" if no pattern match
# and sc_db_case_sensitive = "yes", if we are doing
# a case insensitive search
#
@sc_db_query_criteria = ("query_price_low_range|2|<=|number",
                         "query_price_high_range|2|>=|number",
                         "product|1|=|string",
                         "keywords|1,2,3,4,5|=|string");  

# We want to restrict the number of rows returned 
# so that the browser does not get overloaded
#
$sc_db_max_rows_returned = 25;

#######################################################################
#                    Cart Definition Variables                        #
#######################################################################

# The cart associative array is defined via the following steps:
#                
# 1. The 0th field is ALWAYS the quantity of the purchased item
#
# 2. The subsequent fields are the same fields defined
#    in the @sc_db_index_for_defining_item_id variable.
#    This is done because whatever is defined in this array,
#    becomes the part of the product defined in the user's cart.
#
#       
# 3. The field before the next to last field is ALWAYS the   
#    "options" that have been selected by the user.  If you are    
#     not using options, this field still needs to be here. It will
#     just be used as an empty place marker.
#       
# 4. The next to last field is ALWAYS the price
#    after options have been calculated in with the normal price.
#       
# 5. The last field is ALWAYS a computer generated
#    unique identifier to distinguish cart line items from
#    each other.
#
                    
$cart{"quantity"}            = 0;
$cart{"product_id"}          = 1;
$cart{"product"}             = 2;
$cart{"price"}               = 3;
$cart{"name"}                = 4;
$cart{"image_url"}           = 5;
$cart{"options"}             = 6;
$cart{"price_after_options"} = 7;
$cart{"unique_cart_line_id"} = 8;

$sc_cart_index_of_price = $cart{"price"};
$sc_cart_index_of_price_after_options =
$cart{"price_after_options"};

		# this will show the index of another column of our choice
		# to measure -- such as weight or volume if we are selling
		# something where the weight or volume affects the shipping
		# or discount logic.

$sc_cart_index_of_measured_value = $cart{"price"};

@sc_cart_display_fields = ("Product", "Description", "Options"); #, "Price After Options");

@sc_cart_index_for_display = ($cart{"image_url"}, $cart{"name"}, $cart{"options"}); #, $cart{"price_after_options"});


$sc_cart_index_of_item_id = $cart{"product_id"};
$sc_cart_index_of_quantity = $cart{"quantity"};

#######################################################################
#                    Order Form Definition Variables                  #
#######################################################################

 %sc_order_form_array =('01-fname', 'First Name',
                        '02-lname', 'Last Name',
                        '03-b_street_address', 'Billing Address Street',
                        '04-b_city', 'Billing Address City',
                        '05-b_state', 'Billing Address State',
                        '06-b_zip', 'Billing Address Zip',
                        '07-b_country', 'Billing Address Country',
                        '08-m_street_adress', 'Mailing Address Street',
                        '09-m_city', 'Mailing Address City',
                        '10-m_state', 'Mailing Address State',
                        '11-m_zip', 'Mailing Address Zip',
                        '12-m_country', 'Mailing Address Country',
                        '13-phone', 'Phone Number',
                        '14-fax', 'Fax Number',
                        '15-e-mail', 'Email',
                        '16-URL', 'URL',
                        '17-link', 'Link',
                        '18-type_of_card', 'Type of Card',
                        '19-cardname', 'Name Appearing on Card',
                        '20-card_number', 'Card Number',
                        '21-ex_date', 'Card Expiration',
	   			'22-shipping', 'Shipping Method');

  @sc_order_form_required_fields =
    ("01-fname",
     "02-lname",
     "03-b_street_address",
     "04-b_city",
     "05-b_state",
     "06-b_zip",        
     "13-phone",
     "15-e-mail");

  #the following will generate hidden fields with
  #the contents of the cart inside of them.
 
  $sc_order_with_hidden_fields = "yes";

# increasing numerical value (1,2,3) if its 0,
# then it never gets calculated at this stage

  $sc_calculate_discount_at_display_form = 0;
  $sc_calculate_discount_at_process_form = 0;

  $sc_calculate_shipping_at_display_form = 2;
  $sc_calculate_shipping_at_process_form = 2;

  $sc_calculate_sales_tax_at_display_form = 0;
  $sc_calculate_sales_tax_at_process_form = 1;

  @sc_order_form_shipping_related_fields = 
    ();

  @sc_order_form_discount_related_fields =
    ();

# Shipping_logic is an array of criteria of what type of
# shipping cost to apply.
# The first pipe-delimited fields correspond to the
# sc_order_form_shipping_related_fields. 
#
# Subsequent fields correspond to total quantity, total price,
# and total measurement field. If the field is left blank,
# then that total does not enter into the equation of what
# shipping logic to apply.
#
# The last field is the amount of shipping to apply.
# It is either a hard dollar amount or it is a percentage
# (indicated by % sign) that will be applied to the 
# total price of the order.
#
  @sc_shipping_logic =
     ("|1||$ship_amount","|2||$ship_amount");
#
# Discount logic is the same as shipping logic except
# that whatever value is calculated for the discount will
# be subtracted rather than added to the grand total.
#
  @sc_discount_logic  = ();

#
# Sales tax is always a percentage of the total order
# 

# 
# Process Order Variables:
# 

$sc_order_check_db = "yes";
 
#
# Do we use PGP Encryption -- WARNING: This is a difficult
# option to setup. You must go into the pgp-lib.pl file
# and edit the pgp variables in the header for your specific
# setup.
# 
$sc_use_pgp = "no";
$sc_pgp_temp_file_path = "$cgi_bin_location/Admin_files";

#######################################################################
#                     Store Option Variables                          #
#######################################################################

$sc_use_html_product_pages = "no"; # A yes means that you will not generate
				 # Product pages using a database.
$sc_should_i_display_cart_after_purchase = "yes"; # A no means that the
				# client will be sent back to the product
				# page from which they just ordered.
				# A yes means that they will be taken to a
				# page displaying their current cart after
				# every purchase. 
$sc_shall_i_let_client_know_item_added = "yes";
$sc_item_ordered_message = "<H2><CENTER>Your order has been added to your
			    cart! Thank you!</CENTER></H2>";
$sc_shall_i_email_if_error = "no";
$sc_shall_i_log_errors = "yes"; 
$sc_shall_i_log_accesses = "yes";

#######################################################################
#                    HTML Search Variables                            #  
#######################################################################

$sc_server_url = "$sc_root_url/store/Html/Products";
@sc_unwanted_files = ('*.cgi');

#######################################################################
#                  Error Message Variables                            #
#######################################################################

$sc_page_load_security_warning = "I am sorry, but you may only use this
	program to view HTML pages.";

$sc_randomizer_error_message = "There must be something wrong with your local
	rand function because I cannot get a unique, random number for
	your shopping cart. Please check the call to rand in the Assign a
	Shopping Cart routine.";

#######################################################################
#                  Miscellaneous Variables                            #
#######################################################################


@acceptable_file_extensions_to_display = (".html", ".htm", ".shtml");
$sc_money_symbol = "\$";
$sc_money_symbol_placement = "front";
$sc_current_century = "20";
$sc_number_days_keep_old_carts = .5;
@sc_sales_tax_form_values = ("$sc_sales_tax_state");

$sc_no_frames_button = qq!
<INPUT TYPE = "submit" NAME = "return_to_frontpage_button"
       VALUE = "Return to Frontpage">!;

$sc_product_display_title = "Product Listing";


$sc_product_display_header = qq!
  <CENTER>
  <TABLE BORDER = "0" WIDTH = "550">
  
  <TR ALIGN=CENTER WIDTH=550>
  <TD ALIGN=CENTER WIDTH=125><FONT FACE=ARIAL SIZE=2><B>Quantity</B></FONT></TD>
  <TD ALIGN=CENTER WIDTH=150><FONT FACE=ARIAL SIZE=2><B>%s</B></FONT></TD>
  <TD ALIGN=CENTER WIDTH=275><FONT FACE=ARIAL SIZE=2><B>%s</B></FONT></TD>
  </TR>
  <TR>
  <TD COLSPAN = "3"><HR></TD>
  </TR>!;

$sc_product_display_footer = qq!
  </TABLE></CENTER>!;
             
$sc_product_display_row = qq~

<TR WIDTH=550> 
  
<TD ALIGN=CENTER WIDTH=125>

<CENTER>
<FONT FACE=ARIAL SIZE=2>
<FORM METHOD = "post" ACTION = "$sc_main_script_url">
<SELECT NAME = "item-%s">
<OPTION VALUE = "">Select Quantity
<OPTION VALUE = "1"> 1
<OPTION VALUE = "2"> 2
<OPTION VALUE = "3"> 3
<OPTION VALUE = "4"> 4
<OPTION VALUE = "5"> 5
</SELECT>
</FONT>
<BR>
<INPUT TYPE = "submit" NAME = "add_to_cart_button" VALUE = "Add To Cart">
</CENTER>

</TD>

<TD ALIGN=CENTER WIDTH=150>%s</TD>
  
<TD WIDTH=275><FONT FACE=ARIAL SIZE=2>%s<BR>%s</FONT></TD>

</TR>

</TR>

<TR> 
<TD COLSPAN = "3">
<A HREF=cart.cgi?add_to_cart_button=yes>
<FONT FACE=ARIAL>Check Out
</FONT>
</A>
</TD>
</TR>

<TR> 
<TD COLSPAN = "3"><HR></TD>
</TR>~;


Anon7 - 2021