$pageTitle

%0.2f \n", $_SESSION["subtotal"]); printf(" Tax

%0.2f \n", $_SESSION["tax"]); printf(" Total

$ %0.2f \n", $_SESSION["total"]); print "\n"; } // puts standard banner on top function topBanner($pageTitle) { print "\n\n$pageTitle\n"; print <<

END; } // puts a heading up like you would on an invoice function invoiceHeader() { print ""; print $_SESSION["bname"]; print "
\n"; if($_SESSION["bcompany"] != "") { print $_SESSION["bcompany"]; print "
\n"; } print $_SESSION["baddr1"]; print "
\n"; if($_SESSION["baddr2"] != "") { print $_SESSION["baddr2"]; print "
\n"; } print $_SESSION["bcity"]; print ", "; print $_SESSION["bstate"]; print $_SESSION["bzip"]; print " "; print $_SESSION["bcountry"]; print "

\n"; print $_SESSION["bphone"]; print "
\n"; print $_SESSION["email"]; print "

\n"; print ""; } // closes out the bottom of a page function cartPageFinish() { print <<< END

Made in USA

END; } function shoppingButtons($backLink) { // print "

Keep Shopping "; // print <<Empty Cart Check Out //END; print <<

END; } // puts info for a line item into a table output function doCartRow($catNumber,$count) { $result = mysql_query ("SELECT * FROM item WHERE itemNo = '$catNumber'"); $row = mysql_fetch_array($result); print "$count"; print (" "); print $row["description"]; print (""); printf(" %0.2f", $row["price"] * $row["qty"]); print (""); $extended = $count * $row["price"] * $row["qty"]; printf(" %0.2f", $extended); print (" "); return $extended; } // clear out items in the cart function emptyCart() { $sess_id = session_id(); $result = mysql_query ("DELETE FROM lineItem WHERE sessionID = '$sess_id'"); $_SESSION["finished"] = "true"; unset($_SESSION["bzip"]); session_destroy(); } // outputs hidden fields function outHidden($fieldName, $val) { print "\n"; } // save all the useful info after a sale function recordSale() { $querystring = sprintf("INSERT INTO customer (customerName, businessName, address1, address2, city, state, postalCode, phoneNumber, email, country) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", $_SESSION["bname"], $_SESSION["bcompany"], $_SESSION["baddr1"], $_SESSION["baddr2"], $_SESSION["bcity"], $_SESSION["bstate"], $_SESSION["bzip"], $_SESSION["bphone"], $_SESSION["email"], $_SESSION["bcountry"]); $result = mysql_query ($querystring); } function addItemToCart($catNumber) { // look up the item then use it to insert into a line item $result = mysql_query ("SELECT * FROM item WHERE itemNo = '$catNumber'"); $itemRow = mysql_fetch_array($result); $sess_id = session_id(); $querystring = sprintf("INSERT INTO lineItem (sessionID, itemNo, quantity) VALUES ('%s','%s','1')", $sess_id, $catNumber); $result = mysql_query ($querystring); } function showItemsInCart() { $sess_id = session_id(); $result = mysql_query ("SELECT item.itemNo, lineItem.quantity, description, price*lineItem.quantity FROM lineItem, item where sessionID = '$sess_id' and lineItem.itemNo = item.itemNo"); $total = 0.0; $row = mysql_fetch_array($result); if($noRecords || $row == 0) { print "

Your cart is empty.\n"; return $total; } setupCartOutput(); do { $total += doCartRow($row["itemNo"], $row["quantity"]); } while ($row = mysql_fetch_array($result)); finishCartOutput($total); return $total; } function displayCatalog() { $result = mysql_query ("SELECT * from item where itemNo != -1 order by itemNo"); $row = mysql_fetch_array($result); print ""; print ""; do { $item = $row["itemNo"]; // header print ""; print "\n"; print "\n", $item, $row["price"] * $row["qty"]); } while ($row = mysql_fetch_array($result)); // print "
"; print $row["description"]; print "
"; print $row["longDescription"]; print "
%0.2f

View Cart"; print ""; print <<< END END; } function displayFullCatalog() { $result = mysql_query ("SELECT * from item order by itemNo"); $row = mysql_fetch_array($result); print ""; print ""; do { $item = $row["itemNo"]; // header print ""; print "\n"; print "\n", $item, $row["price"] * $row["qty"]); } while ($row = mysql_fetch_array($result)); // print "
"; print $row["description"]; print "
"; print $row["longDescription"]; print "
%0.2f

View Cart"; print ""; print <<< END END; } function goodReferal($url) { $parts = parse_url($url); if($parts["host"] == "localhost") return true; if($parts["host"] == "www.frodis.com") return true; if($parts["host"] == "secure.linkpt.net") return true; if($parts["host"] == "www.linkpointcentral.com") return true; printf("Bad referal:%s

\n",$url); return false; } // generates keys for licenses function generateKeys($catNumber,$count) { $result = mysql_query ("SELECT * FROM item WHERE itemNo = '$catNumber'"); $itemRow = mysql_fetch_array($result); $keyNo = $itemRow["keyNo"]; $result = mysql_query ("SELECT * FROM serialGen WHERE product = '$keyNo'"); $serialRow = mysql_fetch_array($result); print "

"; print $itemRow["description"]; print "

\n";
	$productNumber = $itemRow["keyNo"];
	$licenseNumber = $serialRow["lastLicNo"];
	$versionNumber = $itemRow["verNo"];
	
	$numToMake = $count * $itemRow["qty"];
	$passString = sprintf("./serial.pl %d %d %d %d",
		$productNumber, $licenseNumber, $versionNumber, $numToMake);
	passthru($passString);
	print "

"; $licenseNumber += $count; $result = mysql_query ("UPDATE serialGen SET lastLicNo = '$licenseNumber' where product = '$keyNo'"); } // generates keys for licenses function generateLicenseKeys() { $sess_id = session_id(); $result = mysql_query ("SELECT item.itemNo, lineItem.quantity, description FROM lineItem, item where sessionID = '$sess_id' and lineItem.itemNo = item.itemNo"); $row = mysql_fetch_array($result); if($noRecords || $row == 0) { print("

Cart Error.

Please contact The Frodis Co."); return; } do { generateKeys($row["itemNo"], $row["quantity"]); } while ($row = mysql_fetch_array($result)); } ?>

"; print $row["description"]; print "
"; print $row["longDescription"]; print "	%0.2f