Saving Order to DB (saveordertodb.inc)"; // // // // // // // // $now_time = date("H:i:s"); $now_date = date("Y-m-d"); $order_sold_to_name = $card_name; $order_sold_to_address = $address; $order_sold_to_city = $city; $order_sold_to_state = $state; $order_sold_to_zip = $zip; $order_sold_to_email = $email; $order_order_total = '$99.99'; $order_order_date = $now_date; $order_order_time = $now_time; $order_order_type = 'type'; $order_order_status = 'new'; $order_cc_transactionID = 'none'; // later it will be: '#foo.RRNO#' print "Card Name = $card_name"; $new_order_query = mysql_query(" INSERT INTO `tkgames_orders` ( sold_to_name, sold_to_address, sold_to_city, sold_to_state, sold_to_zip, sold_to_email, order_total, order_date, order_time, order_type, order_status, cc_transactionID ) VALUES ( '$order_sold_to_name', '$order_sold_to_address', '$order_sold_to_city', '$order_sold_to_state', '$order_sold_to_zip', '$order_sold_to_email', '$order_order_total', '$order_order_date', '$order_order_time', '$order_order_type', '$order_order_status', '$order_cc_transactionID' ) "); $find_new_order_query = mysql_query("SELECT ID FROM `tkgames_orders` WHERE `order_date` = '$order_order_date' AND `order_time` = '$order_order_time' AND `sold_to_email` = '$order_sold_to_email' LIMIT 1"); $new_order_object = mysql_fetch_object($find_new_order_query); $newOrderID = $new_order_object->ID; print "
newOrderId: $newOrderID"; // // $loopcount = 0; $STH_ticket_count = 0; $TKG_ticket_count = 0; $catalog_forsale_query = mysql_query("SELECT * FROM `tkgames_catalog` WHERE `status` = 'forSale' ORDER BY `weight`"); while($item_obj = mysql_fetch_object($catalog_forsale_query)) { $loopcount++; $subtotal = 0; $idX = $item_obj->ID; $sess_storeitemlist = $session->storeitemlist; $z_quantity = $sess_storeitemlist[$idX]; if ($z_quantity == "") { $quant = 0; } else { $quant = $z_quantity; } // print "... quant: $quant .."; if ($quant > 0) { // $item_description = $item_obj->title1; $item_unit_price = $item_obj->price; $item_credits_issued = $item_obj->credits_issued; $item_sth_issued = $item_obj->sth_issued; $item_status = 'new'; $order_items_query = mysql_query(" INSERT INTO `tkgames_order_items` ( orderID, catalogID, description, quantity, unit_price, status ) VALUES ( '$newOrderID', '$idX', '$item_description', '$quant', '$item_unit_price', '$item_status' ) "); for ($XX = 1; $XX <= $quant; $XX++) { // // if ($item_credits_issued > 0) { // $t_orderID = $newOrderID; $t_game_type = "multi"; $t_ticket_type = "40 Credit TKGames Ticket"; $randNumb = rand(100000000,999999999); $t_ticket_number = $randNumb; $t_status = 'initialized'; $t_sth_plays_issued = 0; // $t_credits_issued = $item_credits_issued; $t_sth_plays_used = 0; $t_credits_used = 0; $t_sold_to_name = $order_sold_to_name; $t_sold_to_email = $order_sold_to_email; $t_sale_type = "STH Store"; $t_ticket_price = $item_unit_price; $t_new_time = $now_date; $t_new_date = $now_time; $t_sold_time = "never"; $t_sold_date = "never"; $t_used_time = "never"; $t_used_date = "never"; // print "about to create a new TKG ticket"; // $initialize_ticket = mysql_query(" INSERT INTO `tkgames_tickets` ( orderID, game_type, ticket_type, ticket_number, status, sth_plays_issued, credits_issued, sth_plays_used, credits_used, sold_to_name, sold_to_email, sale_type, ticket_price, new_time, new_date, sold_time, sold_date, used_time, used_date ) VALUES ( '$t_orderID', '$t_game_type', '$t_ticket_type', '$t_ticket_number', '$t_status', '$t_sth_plays_issued', '$t_credits_issued', '$t_sth_plays_used', '$t_credits_used', '$t_sold_to_name', '$t_sold_to_email', '$t_sale_type', '$t_ticket_price', '$t_new_time', '$t_new_date', '$t_sold_time', '$t_sold_date', '$t_used_time', '$t_used_date' ) "); $find_new_ticket_query = mysql_query("SELECT ID, ticket_number FROM `tkgames_tickets` WHERE `status` = 'initialized' AND `orderID` = '$t_orderID' AND `ticket_number` = '$t_ticket_number' LIMIT 1"); $new_ticket_object = mysql_fetch_object($find_new_ticket_query); $ticketID = $new_ticket_object->ID; $final_ticket_number = $t_ticket_number."-".$ticketID; $finalize_ticket_query = mysql_query("UPDATE `tkgames_tickets` SET `ticket_number` = '$final_ticket_number', `status` = 'new' WHERE `ID` = '$ticketID' LIMIT 1"); // print "
saved TKG ticket number:($ticketID / $final_ticket_number
"; //$_SESSION['tkg_ticket_num'] = $final_ticket_number; // var is not in session YET $TKG_ticket_count++; } // // // // if ($item_sth_issued > 0) { // $t_orderID = $newOrderID; $t_game_type = "STH"; $t_ticket_type = "Super Treasure Hunt Party Game"; $randNumb = rand(100000000,999999999); $t_ticket_number = $randNumb; $t_status = 'initialized'; $t_sth_plays_issued = $item_sth_issued; // $t_credits_issued = 0; $t_sth_plays_used = 0; $t_credits_used = 0; $t_sold_to_name = $order_sold_to_name; $t_sold_to_email = $order_sold_to_email; $t_sale_type = "STH Store"; $t_ticket_price = $item_unit_price; $t_new_time = $now_time; $t_new_date = $now_date; $t_sold_time = "never"; $t_sold_date = "never"; $t_used_time = "never"; $t_used_date = "never"; // $initialize_ticket = mysql_query(" INSERT INTO `tkgames_tickets` ( orderID, game_type, ticket_type, ticket_number, status, sth_plays_issued, credits_issued, sth_plays_used, credits_used, sold_to_name, sold_to_email, sale_type, ticket_price, new_time, new_date, sold_time, sold_date, used_time, used_date ) VALUES ( '$t_orderID', '$t_game_type', '$t_ticket_type', '$t_ticket_number', '$t_status', '$t_sth_plays_issued', '$t_credits_issued', '$t_sth_plays_used', '$t_credits_used', '$t_sold_to_name', '$t_sold_to_email', '$t_sale_type', '$t_ticket_price', '$t_new_time', '$t_new_date', '$t_sold_time', '$t_sold_date', '$t_used_time', '$t_used_date' ) "); $find_new_ticket_query = mysql_query("SELECT `ID`, `ticket_number` FROM `tkgames_tickets` WHERE `status` = 'initialized' AND `orderID` = '$t_orderID' AND `ticket_number` = '$t_ticket_number' LIMIT 1"); $new_ticket_object = mysql_fetch_object($find_new_ticket_query); $ticketID = $new_ticket_object->ID; $final_ticket_number = trim($t_ticket_number."-".$ticketID); $finalize_ticket_query = mysql_query("UPDATE `tkgames_tickets` SET `ticket_number` = '$final_ticket_number', `status` = 'unused' WHERE `ID` = '$ticketID' LIMIT 1"); // print "
saved STH ticket number: $final_ticket_number
"; $session->sth_ticket_num = $final_ticket_number; $STH_ticket_count++; // done } // end IF } // done } // } // // print "End of Save to DB include"; ?>