관리-도구

편집 파일: tix_confirmOrder.php

<?php
session_start();

$TraxId = date("mdyHis") . rand();
$_SESSION['TraxId']=$TraxId;

$dbhost = 'internal-db.s3783.gridserver.com';
$dbusername = 'aaronmeyer';
$dbuserpassword = 'CQDZZDsu';
$default_dbname = 'db3783_ticketingSystem';
$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
$dbid = mysql_select_db($default_dbname);

$sql = "Insert into bookingmaster values ('','" . $TraxId . "','','','" . $_SERVER['REMOTE_ADDR'] . "','Admin Booking','" . date("Y-m-d H:i:s") . "','" . date ("H:i:s") . "','Success','Success','0.00','" . $_SESSION['event_eid'] . "')";
	$res = mysql_query($sql);

$sql = "select id from bookingmaster where transactionid='" . $TraxId . "'";
	$res = mysql_query($sql);
	$row = mysql_fetch_row($res);
	$bookingId = $row[0];

$sql = "select resseatid from tempseating_details where sessionticketid='" . $_SERVER['REMOTE_ADDR'] . "'";
	$res = mysql_query($sql);
	while ($row = mysql_fetch_row($res))
	{
		$sql1 = "update eventseatingplan set bookingid='" . $bookingId . "' where id='" . $row[0] . "'";
		$res1 = mysql_query($sql1);

$sql1 = "insert into bookingdetail values ('','".$bookingId."','Reserved Seats','".$row[0]."')";
		$res1 = mysql_query($sql1);
	}

$sql2 = "select * from tempseating where sessionticketid='" . $_SERVER['REMOTE_ADDR'] . "'";
	$res2 = mysql_query($sql2);
	$row2 = mysql_fetch_row($res2);
	$totalgenseats = (int)$row2[2] +  (int)$row2[3];
		
	$sql1 = "insert into bookingdetail values ('','".$bookingId."','General Seats','".$totalgenseats."')";
	$res1 = mysql_query($sql1);

$sql3 = "select * from general where eventid='" . $_SESSION['event_eid'] . "'";
	$res3 = mysql_query($sql3);
	$row3 = mysql_fetch_row($res3);
	$availableseats = (int)$row3[1] - $totalgenseats;
	$sql3 = "update general set gen_admission=" . $availableseats . " where eventid='" . $_SESSION['event_eid'] . "'";
	$res3 = mysql_query($sql3);
?>