I 1111111111111111 11111 1111111111 lllll 111111111111111 111111111111111 IIII IIII
`
`US007548869B2
`
`US 7,548,869 B2
`
`c12) United States Patent
`
`(IO) Patent No.:
`Jun.16,2009
`(45)Date of Patent:
`
`Halavais et al.
`
`(54)SYSTEM AND METHOD FOR SELECTING
`AND RESERVING SETS OF SEATS
`
`(75)Inventors: Richard Arthur Halavais, Anaheim
`
`
`
`
`Hills, CA (US); Tony Cheng-Tong
`
`Chung, Diamond Bar, CA (US)
`
`
`
`
`4,794,530 A 12/1988 Yukiura et al.
`
`4,931,932 A 6/1990
`
`
`Dalnekoff et al.
`
`
`4,974,252 A 11/1990 Osborne
`
`4,984,156 A 1/1991
`
`Mekata
`
`
`
`4,992,647 A 2/1991 Konishi et al.
`
`5,021,953 A 6/1991
`
`Webber eta!.
`
`(Continued)
`
`FOREIGN PATENT DOCUMENTS
`
`2366403 A 8/2000
`
`
`
`62132491 12/1998
`
`OTHER PUBLICATIONS
`
`( *) Notice: Subject to any disclaimer, the term ofthis
`
`GB
`
`
`
`patent is extended or adjusted under 35
`JP
`
`
`U.S.C. 154(b) by 0 days.
`
`(21)Appl. No.: 12/329,533
`
`
`
`(22) Filed:Dec. 5, 2008
`
`(65)
`
`
`
`Prior Publication Data
`
`
`
`US 2009/0083085 Al Mar. 26, 2009
`
`
`
`
`
`Related U.S. Application Data
`
`Anderson, Jennifer, "Ticket to Ride", Apr. 21, 1998, PC Magazine,
`
`
`
`
`
`vl7, n8, p. 40(1).*
`
`(Continued)
`
`Primary Examiner-John W Hayes
`
`
`
`Assistant Examiner-Shannon S Saliard
`
`
`
`
`(74) Attorney, Agent, or Firm-Knobbe Martens Olson &
`BearLLP
`
`ABSTRACT
`
`(63) Continuation of application No. 12/244,727, filed on
`
`
`
`
`(57)
`
`Oct. 2, 2008, which is a continuation of application
`The present invention relates to a system and method for
`
`
`
`
`No. 09/295,577, filed on Apr. 22, 1999, now Pat. No.
`
`
`
`
`selecting and reserving sets of seats in a venue. The system
`7,454,361.
`
`
`
`and method transmit information relating to sets of available
`
`
`seats in a venue to an application running on a general pur­
`(51)
`Int. Cl.
`
`
`pose computer for display to the end user. The system and
`G06Q 10100 (2006.01)
`
`
`method also provide a page that includes an interactive seat­
`(52)
`
`U.S. Cl. .......................................................... 705/5
`
`
`
`ing map showing information relating to the sets of available
`
`Field of Classification Search . ... ... ... ... .. ... ... 705/1,
`(58)
`
`
`
`
`
`
`seats. Through the interactive seating map the end user can
`705/5
`
`
`
`
`
`select one or more available seats or sets of seats. The inter­
`
`See application file for complete search history.
`
`
`
`
`active seating map may provide additional information on
`
`
`one or more of the sets of available seats in response to a user
`
`
`
`interaction with the seating map, for example, when the user
`U.S. PATENT DOCUMENTS
`
`
`
`places a mouse over one of the sets of available seats.
`
`
`
`
`
`(56)
`
`
`
`References Cited
`
`
`3,427,438 A 2/ 1969 Ruscher
`
`4,449,186 A 5/ 1984 Kelly et al.
`
`
`
`6 Claims, 30 Drawing Sheets
`
`
`
`�11:�iw0�1::&ru�tN���RMATION
`EDIN
`�SUPPll
`�fJ��f:��•
`IA) i���ij
`l�L �-=,-=.,-=.,�-=.,��-=.,-=.,�-=.,��-=,-=.,--;'.,
`(C) =�!i��iEv�1i::
`
`Ni
`
`(B)THOSESPECIFICSfATSASSELEGTEDBYTHE
`CUSTOMERAREREMOVEDFROMAVAllA6LE
`
`PRESBjTEflTOTHENEXTPROSPECTII/ECUSTct.lER,
`(D)ENTEREDINTOTIUCCOUNTINGAllD
`IONDATAl!ASEFOR
`ADMINISTRATIOOINFORMAT
`LATERRETRlEVALBYTHEVENUEOPERATOR.
`
`
`
`(73)Assignee: Ceats, Inc. , Las Vegas, NV (US)
`
`
`
`
`
`PAGE 1
`
`

`

`US 7,548,869 B2
`
`Page 2
`
`U.S. PATENT DOCUMENTS
`
`OTHER PUBLICATIONS
`
`2001/0043210 Al* 11/2001 Gilbert et al. ............... 345/420
`
`
`
`6,223,166 Bl 4/2001 Kay
`
`
`
`6,240,396 Bl 5/2001 Walker et al.
`5,027,224 A 6/1991 Yamada
`
`
`
`
`
`6,249,767 Bl 6/2001 Okayama et al.
`
`5,151,692 A Hirahara 9/1992
`
`
`
`
`6,263,315 Bl 7/2001 Talluri
`
`5,237,499 A 8/1993 Garback
`
`
`6,301,574 Bl 10/2001 Thomas et al.
`5,239,480 A
`8/1993 Huegel
`
`
`
`6,304,850 Bl 10/2001 Keller et al.
`
`5,255,184 A 10/1993 Hornick et al.
`
`6,380,959 Bl 4/2002
`
`Wang eta!.
`
`
`5,270,921 A 12/1993 Hornick et al.
`
`
`
`6,418,413 B2 7/2002 DeMarcken et al.
`
`
`5,285,055 A 2/1994 Oonakahara et al.
`
`
`
`6,606,101 Bl 8/2003 Malamud et al.
`
`5,311,425 A 5/1994 Inada
`
`
`6,704,713 Bl 3/2004 Brett
`
`
`5,333,257 A 7/1994 Merrill et al.
`
`
`
`6,824,057 B2 11/2004 Rathus et al.
`
`5,408,417 A 4/1995 Wilder
`
`
`
`6,975,856 B2 12/2005 Ogasawara
`
`
`5,581,461 A 12/1996 Coll et al.
`
`6,999,936 B2 2/2006
`
`Sehr
`
`5,615,342 A 3/1997 Johnson
`
`
`
`
`7,010,533 Bl 3/2006 Kutsumi et al.
`
`5,621,430 A 4/1997 Bricklin
`
`
`
`7,069,228 Bl 6/2006 Rose et al.
`
`
`5,668,592 A 9/1997 Spaulding, II et al.
`
`
`
`7,114,179 Bl 9/2006 Ritter et al.
`
`5,724,520 A 3/1998 Goheen
`2001/0016825 Al
`
`
`8/2001 Pugliese et al.
`
`5,732,398 A 3/1998 Tagawa
`
`
`
`
`
`
`5,754,654 A 5/1998 Hiroya et al.
`
`
`
`2002/0156661 Al 10/2002 Jones et al.
`
`5,769,269 A 6/1998 Peters
`
`
`
`
`2002/0178034 Al 11/2002 Gardner et al.
`
`5,781,892 A 7/1998 Hunt et al.
`
`
`
`
`2004/0107439 Al 6/2004 Hassell et al.
`
`
`5,797,126 A 8/1998 Helbling et al.
`
`
`
`2005/0144115 Al 6/2005 Brett
`
`5,797,127 A 8/1998 Walker et al.
`
`
`2005/0199713 Al 9/2005 Rathus et al.
`
`
`5,806,046 A 9/1998 Curran et al.
`2007/0027794 Al
`
`2/2007 Brett
`
`5,808,894 A 9/1998 Wiens eta!.
`2007/0027798 Al
`
`2/2007 Brett
`
`5,832,451 A 11/1998 Flake et al.
`
`2007/0033131 Al 2/2007 Brett
`
`
`
`5,832,454 A 11/1998 Jafri et al.
`
`
`2007/0038582 Al 2/2007 Brett
`
`
`5,842,176 A 11/1998 Hunt et al.
`
`
`2007/0124232 Al 5/2007 Brett
`
`5,855,006 A 12/1998 Huemoeller et al.
`
`5,897,620 A 4/1999 Walker
`
`et al.
`
`5,926,108 A Wicks eta!. 7/1999
`
`"Electro Tix Offers New Visual Approach to Selling Tickets On
`
`
`
`
`
`
`5,926,798 A
`7/1999 Carter
`
`
`Internet", May 1998, Business Wire, p. 05280356.*
`5,930,761 A
`7/1999 O'Toole
`
`
`
`
`ElectroTix Offers New Visual Approach to Selling Tickets On
`
`5,930,769 A 7/1999
`
`Rose
`
`
`Internet, May 1998, Business Wire.
`
`5,943,651 A 8/1999 Oosawa
`
`
`
`
`
`Anderson, Jennifer, Ticket to Ride,Apr. 21, 1998, PC Magazine, vl 7,
`
`5,948,040 A 9/1999
`
`DeLorme et al.
`n8, p. 40( 1 ).
`
`
`5,974,406 A 10/1999 Bisdikian et al.
`
`
`5,990,927 A 11/1999 Hendricks et al.
`Printout ofTravelocity.com Seat Map archived Dec. 12, 1998 from
`
`
`
`
`6,023,685 A 2/2000 Brett
`
`
`
`
`http://web.archive.org/web/ l 9990428 l 7 l 540/www2 .travelocity.
`
`6,070,149 A Tavor et al. 5/2000
`
`
`
`corn/ttools/seatrnap.htrnl downloaded Sep. 23, 2008.
`
`6,085,169 A 7/2000 Walker
`
`et al.
`
`
`
`Ackerman, No Ticket No Problem: Ttcketless Travel Heralds a Com-
`
`6,085,976 A Sehr et al. 7/2000
`
`
`
`puter-Driven Revolution in the Travel Industry, Boston Globe, Jun. 4,
`6,107,932 A
`
`8/2000 Walker et al.
`1995.
`6,112,185 A
`
`8/2000 Walker et al.
`
`
`
`
`6,119,096 A Mann eta!. 9/2000
`
`1997, PR Newswire.
`
`
`6,134,534 A 10/2000 Walker et al.
`
`* cited by examiner
`
`
`6,167,462 A * 12/2000 Davis et al ..................... 710/5
`
`
`
`
`
`Exciting New Features Now Available on Microsoft Expedia, May 6,
`
`PAGE 2
`
`

`

`
`U.S. Patent Jun.16,2009
`
`Sheet 1 of 30
`
`US 7,548,869 B2
`
`1. A VENUE OPERATOR IMPLEMENTS THE INSTANT2. THAT SPECIFIC VENUE IS RECORDED, CODED AND PLACED
`
`
`
`
`
`
`
`
`ON A SERVER CONNECTED CONVENTIONALLY TO THE INTERNET
`
`
`INVENTION FOR HIS USE AS HIS OWN TICKETING AND
`�
`RESERVATION SYSTEM.OR ANY SUCH WIDE AREA NETWORK.
`
`�
`CUSTOMER ATTACHES TO THE SERVER3. A PROSPECTIVE CUSTOMER FOR TICKETS TO ANY 4. SAID PROSPECTIVE
`
`
`
`
`
`
`
`
`
`
`
`GRAPHICAL BROWSING MEANSANY CONVENTIONAL EVENT LOGS ONTO THE INTERNET, OR OTHER THROUGH
`
`
`
`
`
`AND VIEWS THE AVAILABLE VENUES, PERFORMANCES, DATES,
`
`SUCH WI DEARE NETWORK, IN HIS CONVENTIONAL
`i---.
`
`
`
`OTHER SUCH OFFERINGS.MANNER, WHETHER FROM HOME OR OFFICE OR ANY AND/OR
`
`
`
`REMOTE LOCATION.
`
`•
`6. SAID PROSPECTIVE CUSTOMER SELECTS A SPECIFIC5.UPON FIRST ACCESS AN INQUIRY IS MADE TO THE
`
`
`
`
`
`
`
`
`
`
`
`
`
`AREA OF INTEREST FROM THE AVAILABLE VENUES. SUCHAPPROPRIATE DATABASE ASKING FOR A RETURN TO THE
`
`
`
`
`
`
`MAY BE THEATER TICKETS FOR A PARTICULAR SHOW+- PROSPECTIVE CUSTOMER OF ALL GENERALIZED INFORMATION
`
`
`
`
`
`
`
`
`
`DATE, AIRLINE SEATS FOR A GIVEN FLIGHT, ETC., AND AVAILABLE FROM WHICH HE WILL MAKE A SELECTION OF THE
`
`
`
`INDICATES HIS SELECTION THROUGH A CONVENTIONAL
`
`TYPE OF VENUE HE IS SEEKING.
`
`
`
`HYPERLINK OR OTHER COMPATIBLE MEANS.
`
`L
`7. UPON CONTACT THE SERVER MAKES ANOTHER8. UPON RETURN THE PROSPECTIVE CUSTOM ER IS
`
`
`
`
`
`
`
`
`
`
`
`WITH A REPRESENTATION APPROPRIATE DATABASE QUERY ASKING FOR A RETURNPRESENTED OF ALL AVAILABLE
`
`
`TO THE PROSPECTIVE CUSTOMER OF ALL SPECIFIC
`
`
`
`SEATING FOR HIS SELECTED VENUE. FROM THIS
`�
`
`
`
`
`
`
`
`INFORMATION RELATING TO HIS SELECTION, I.E.,REPRESENTATION, WHICH MAY BE GRAPHICAL OR DISPLAYED
`
`
`
`
`
`
`APPROPRIATE WAY, HE MAKES A SELECTIONAVAILABLE SEATS FOR THE CHOSEN AIRLINE FLIGHT,IN ANY OTHER
`
`
`FROM WHICH HE WILL MAKE HIS SELECTION OR
`
`
`
`OF THE SPECIFIC SEAT OR SEATS HE WISHES TO RESERVE
`SELECTIONS.
`
`AND SUBMITS SUCH TO THE SERVER.
`
`l
`10.THE SERVER REQUESTS PAYMENT INFORMATION
`
`
`
`
`
`9. THE SERVER CREATES A TEMPORARY CUSTOMER
`
`
`
`
`FROM THE NOW CUSTOMER THROUGH A FORM INPUTIDENTIFICATION AND ASSOCIATES THE PROSPECTIVE
`
`
`
`MECHANISM. ONCE COMPLETED AND SUBMITTED, THE
`
`
`
`IDENTIFICATION� CUSTOMER'S SELECTIONS WITH THAT SPECIFIC
`
`
`
`
`
`CUSTOMER'S PAYMENT INFORMATION IS VERIFIEDSO AS TO PRECLUDE CONFUSION AND ALLOW MULTIPLE
`
`
`
`
`ANEOUS USERS.THROUGH CONVENTIONAL MEANS WITH ANY OF THE SIMULT
`
`
`EXISTING PROCESSING MEANS.
`
`11(B). IF CUSTOMER'S PAYMENT INFORMATION VERIFICATION IS
`
`IS GIVEN THE OPPORTUNITY TO CORRECT HIS
`
`t-
`
`.
`11(A). IF CUSTOMER'S PAYMENT INFORMATION
`
`
`
`
`
`
`
`
`
`VERIFICATION IS SUCCESSFUL THEN:
`
`NOT SUCCESSFUL THEN:
`
`
`
`(A)THE CUSTOMER'S INFORMATION, AS SUPPLIED IN (A)CUSTOMER
`
`
`
`
`STEP 10, IS MADE PERMANENT AND;
`
`SUBMITTAL AND TRY AGAIN;
`
`
`
`
`
`
`
`
`
`PROCESS.CUSTOMER ARE REMOVED FROM AVAILABLETHE ENTIRE
`
`INVENTORY AND;
`
`
`(C)MARKED AS UNAVAILABLE ON THE GRAPHICAL
`
`
`REPRESENTATION OF THE VENUE SEA TING AS
`12. A CONFIRMATION OFTHE TRANSACTION, CONTAINING THE
`
`
`
`
`
`PRESENTED TO THE NEXT PROSPECTIVE CUSTOMER;
`
`
`
`H TRANSACTION IDENTIFICATION AND OTHER PERTINENT
`
`
`INFORMATION IS RETURNED TO THE CUSTOMER
`
`
`(D)ENTERED INTO THE ACCOUNTING AND
`
`
`
`ADMINISTRATION INFORMATION DATABASE FOR
`
`
`
`LATER RETRIEVAL BY THE VENUE OPERATOR.
`
`AND REPEATCAN RETURN TO THE BEGINNING (B)THOSE SPECIFIC SEA TS AS SELECTED BY THE (B)CUSTOMER
`
`FIG. 1
`
`PAGE 3
`
`

`

`U.S. Patent
`U.S. Patent Jun.16,2009 Sheet 2 of 30
`
`US 7,548,869 B2
`US 7,548,869 B2
`
`
`
`
`
`7lLAé
`NYvi;7PATNSS
`
`|
`
`aN
`api
`Na
`
`PYOeaNOE
`
`FIG. 2
`FIG. 2
`
`PAGE 4
`
`
`

`

`�
`00 •
`�
`� ��
`
`
`=�
`
`�=
`? ....
`O'I �
`
`N
`0
`0
`1,0
`
`rJJ
`
`=­('D
`
`a �
`
`0 .... �
`
`0
`
`d
`r.,;_ -....l
`tit�00
`00
`
`0--,
`\0
`
`=
`N
`
`STAGE
`
`00�@2�
`®<0 0 00
`C> �®
`----1 8 (> <'.) 00
`0 00 �@Jo
`00� S72
`
`C>�<0 00
`
`0
`
`S119 S116 S114 S112 S110
`S107 S105 S103 S101
`S117O 00 0 0 000 0
`1 s 11 s s 113 s 111 s 1 os 100000000
`S108 S106 S104 S102 I O S100
`I
`
`FIG. 3A
`
`PAGE 5
`
`

`

`�
`00•
`�
`� ��
`
`
`=�
`
`2'
`?
`
`....
`�Cl's
`N
`0
`0
`1,0
`
`rJJ
`
`=­('D
`
`('D .....
`.i;...
`0
`....�
`0
`
`S123 S127
`0019
`�@��
`�@0
`�@)�
`
`(> <'.)
`
`14'NOrl.
`
`C>(:;\ 0
`C>r;;;-.. 0 0®/\ PQ
`�
`◊�<)
`STAGE
`----21 0®0 00
`
`V
`
`(> c)
`
`S119
`S116 S114 S112 S110
`S117O 0 0 0 0 00 00
`I S115 S113 S111 S109
`I
`
`S107 S105 S103 S101
`0 00
`100000
`I O S100
`S108 S106 S104 S102
`
`d
`r.,;_ -....l
`tit�00
`00
`FIG. 3B
`0--,
`\0
`=
`N
`
`PAGE 6
`
`

`

`(:)(§(8]
`I
`
`A
`
`-
`
`
`
`
`
`To reserve your seat(s), please choose the performer you wish to see or the concert date/time you wish
`
`,__
`
`
`
`
`to attend:
`
`Country, The Musical
`
`€J Microsoft
`
`Internet Explorer
`Eile Edit )Liew Favorites
`Iools l::!elp
`� Back ... @ V �
`� Media � I e ... § !ill ,.. �
`� ©I p Search Favorites
`
`*
`
`Addresffi http ://csp-m si. net/concerts/
`El@ Go Links
`II Ml!. CONCERTS
`I I
`
`f' :rs�}l/
`
`22
`
`
`
`Ee _l2_r_u_ar.y_2LI..M._9__(A.;_O_ilpJ_
`
`·,_;
`
`Country!
`
`j-€'.l Done
`
`Brenda Lee
`
`(&A
`
`Februar11 25 1999 (6:3Qp)
`IDD Dlt>lnternet
`
`El
`41
`
`FIG. 4A
`
`�
`r:J)_ •
`�
`� ��
`�
`
`2'
`? ....
`
`�a-­
`N
`0
`0
`1,0
`
`rJ'1=­('D
`('D .....
`0 .... �
`
`Ul
`
`0
`
`d
`r.,;_ -....l
`tit�00
`
`0--,
`\0
`
`=N
`
`PAGE 7
`
`

`

`Microsoft Internet Explorer
`
`
`
`Edit Y.Jew Favorites Iools l::lelp
`
`�)Back .... @ Q � l]l]�J /) search
`*Favorites
`� Media ,,@I@..,.� !ill ..,.�
`AddresffJ http://csp-msl.net/concerts/reserve1.html?id=109&show
`=seats
`(3 (� Go Links
`Concert Reservation System
`
`(:][§�
`
`23
`
`
`
`A
`
`Click on the seat you wish to reserve.
`
`
`0 Barstool o Chair D Booth
`;24
`�
`
`S119
`S107 S105 S103 S101
`S116 S11f S111 S110
`00000000
`S117 00000000
`0 I s11s s113 5111 51os
`51oa 5106 510� s101 I 05100
`I I
`
`
`
`An ''X" denotes a seat that has already been taken.
`Your mouse is over seat#: �
`
`Selected Seats:
`
`27
`I----
`I
`IS21 a S21 b
`Clear Choice
`Reserve Seat
`
`II
`I
`I
`
`26
`
`[�Done
`
`�Internet
`ID
`
`�1 41
`
`FIG. 4B
`
`�
`00•
`�
`� ��
`�
`
`�=
`?
`....
`O'I �
`
`N
`0
`0
`1,0
`
`rJ'1
`
`=­('D
`
`a
`O'I
`
`0 ....
`
`(,H
`0
`
`-....l
`
`d r.,;_
`tit �
`00
`
`00
`
`0--,
`\0
`
`= N
`
`PAGE 8
`
`

`

`
`
`�Microsoft Internet Explorer
`Eile Edit Y..iew Favorites
`Iools Help
`@ Back ,.. @ " 0 [1ID @I f) Search * Favorites
`� Media .(j} I @,. � � ... �
`Addresffi http://csp-m
`
`
`sl.net/concerts/reserve1 .him l?id" 109& show"seats
`[3 ffi Go
`Links
`"'...
`
`(:)(@�
`I
`
`I
`
`
`
`Concert Reservation System
`
`
`
`28
`I
`/
`
`CUSTOM ER IN FORM A Tl ON
`
`Richard Halavais
`
`Name as appear on CC
`714-693-1171I
`rhal@msintergate.com
`
`Phone
`
`Email
`CC Number
`
`4111111111111
`Month � / Year [Qu ... example:
`
`Expiration (MM/YY)
`12/99
`IReserve
`Seats 1"--29
`I Clear Choices I
`
`'-
`
`I
`
`I
`
`I
`
`j�Done
`
`t)lnternet
`IDDDI
`FIG. 4C
`
`41
`
`�
`00•
`�
`� ��
`�
`
`2'
`? ....
`
`�a,,_
`N
`0
`0
`1,0
`
`rJJ=­('D
`('D .....
`0 .... �
`
`-....J
`
`0
`
`d
`r.,;_
`--..l
`tit�00
`00
`0--,
`\0
`
`=
`N
`
`PAGE 9
`
`

`

`�
`00•
`€1 Microsoft Internet Explorer
`
`
`�
`Iools l:ielp
`Eile Edit 'i_iew Favorites
`� ��
`@ Back ... @ v G � ©I j) Search
`� Media .(J} I @.., � [ill ... �
`Favorites
`*
`�
`Addresffi http://csp-msl.net/concerts/reserve1.html?id=109&show=seats
`Links
`E] @ Go
`
`□©Jl2sJ
`I
`
`I Concert
`
`
`Reservation System
`I
`
`
`The credit card has been approved and the reservation has been
`
`
`
`processed.
`
`A
`
`>-
`
`>-
`
`2'
`?
`....
`�a--­
`N
`0
`0
`1,0
`
`rJ'1 =­('D
`('D .....
`
`QO
`
`0 ....�
`
`0
`
`d
`r.,;_ -....l
`tit �00
`\0 =N
`
`00
`0--,
`
`
`
`The following are the Authorization Code and Receipt Number:
`
`
`
`
`
`Authorization Code: AB3107
`
`
`
`Receipt Number: 317
`
`Customer Name: Richard Halavais ------
`
`
`Total Amount: $40.00
`
`Credit Card Number: 4111111111111111
`Month of Expiration:
`09
`Year of Expiration:
`99
`
`30
`
`I I Return to MSI Reservation
`
`Front Desk
`
`,� Done
`
`FIG. 4D
`
`I
`I
`G
`/41
`
`lt)lnternet
`IDD□
`
`PAGE 10
`
`

`

`
`
`Microsoft Internet Explorer
`
`Eile Edit )Liew Favorites Iools 1:lelp
`-�)Back ... @"' � ��I /)search *Favorites <ll/'Media �I e..-� !ill ... �
`
`
`Addresifj http://csp-msl.net/concerts/reserve1.html?id=109&show=seats
`E]@ Go Links
`
`[:)(§)�
`
`A
`
`
`
`
`
`Concert Reservation System
`
`Click on the seat you wish to reserve.
`□Booth
`
`□Premium Seating D Standard Seating O Barstool° Chair
`0000 Ioo 31l lI
`sso18 s123 s12s�(§)� �
`�
`ss11g6 �@ � d � �
`ss21gC�@�S 1r, � ,�
`S53186 � � � J .. :
`
`H
`
`S119
`0 1 s11s s113 s111 s109 s1oa s10, s10, s102 I 0s100
`
`S\07 S105 S�03 S101
`S116 S114 S112 S110
`00000000
`S117 00000000
`I I
`
`
`
`An ''X" denotes a seat that has already been taken.
`
`Your mouse is over seat#: �
`
`Selected Seats:
`
`I
`
`I
`Reserve Seat
`
`Clear Choice
`I
`II
`I
`
`[-{) Done
`
`]OO D [t>lnternet
`
`FIG. 4E
`
`1;1J
`�
`
`00
`
`�
`• � � � �
`�
`
`2'
`?
`....
`
`�a-­N 0 0 1,0
`
`rJ'1
`
`=­('D
`('D
`
`..... 1,0 0 .... � 0
`
`d
`
`r.,;_
`
`� 00
`
`00
`
`0--,
`\0
`
`PAGE 11
`
`

`

`U.S. Patent Jun.16,2009
`Sheet 10 of 30
`
`
`
`US 7,548,869 B2
`
`
`
`Begin Program
`
`
`
`<Markup language>
`
`FIG. 5
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM ---Imports the file "datasource.inc" which creates variable "datasource" which is
`
`
`
`
`
`
`
`
`
`used to tell markup language datasource to connect to.
`
`--->
`
`
`
`<INCLUDE NAM E="database\datasource.inc''>
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM---In case a database or other type of error occurs, this display the error message. -
`
`
`
`
`
`-->
`
`<ERROR>
`
`
`
`
`
`
`
`I
`
`
`
`
`
`<FONT FACE='Verdana Arial" SIZE="+1 "><B>An Error Has Occurred</B></FONT><P> <FONT
`
`
`
`
`FACE='Verdana, Arial" SIZE="-1 ''><B>Error Message
`
`
`
`= :i_errortext </B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana, Arial" SIZE="-1 "><B>database Error =
`
`
`
`
`
`
`
`:i_databaseerrortext</B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana, Arial" SIZE="-1 "><B>database Error= i_databaseerrorstmt
`
`
`
`
`
`
`
`</B></ FONT><P>
`
`</ERROR>
`
`
`
`
`
`<REM ---Begin normal markup language here
`
`--->
`
`
`
`<markup language>
`
`<HEAD>
`
`
`
`
`
`<TITLE> Ticketing &amp; Reservation System</TITLE>
`
`
`
`</HEAD>
`
`LINK=''#006666" ="im ages/background.jpg" TEXT =''#000000"
`
`<BODY BACKGROUND
`
`
`
`VLINK=''#006666">
`
`<CENTER>
`
`
`
`<IMG SRC='1mages/masthead_concerts.gif" HEIGHT =60 WIDTH=280><P>
`
`
`
`
`
`PAGE 12
`
`

`

`
`U.S. Patent Jun.16,2009
`
`
`US 7,548,869 B2
`
`Sheet 11 of 30
`
`
`
`please select <FONT FACE='Verdana,Arial". SIZE=-1 ><B> To begin reserving your seat(s),
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`the concert date/time you wish to attend next to the performer you want to
`
`see:</B></FONT>
`
`
`
`<TABLE BORDER=O CELLSPACING=5 CELLPADDING=5>
`
`
`
`
`
`
`
`<REM ··· Begin database query to retrieve all performances that is --->
`
`
`
`
`
`
`
`--->
`<REM ··· currently available. Will loop until all available
`
`
`
`
`
`
`
`
`
`<REM ··· performing artists and their performances are listed. --->
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM---Part of the return from the query are the links that will --->
`
`
`
`<REM ··· take you to the next step of the reservation. --->
`
`
`
`<database DB NAM E=":datasource"
`
`
`
`
`
`
`
`
`
`database="SELECT id, name, picture, sequence
`
`FROM category
`
`=-1
`=1 AND parent
`WHERE active
`
`ORDER BY sequence"
`
`ALIAS="concert'>
`
`
`
`<databaseF8CH ALIAS="concert">
`
`
`
`<WHILE NOTALIAS=i_databaseempty>
`
`<TR>
`
`<TO COLSPAN
`=2>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE=+1 ><B>:concert_name</B></FONT>
`
`='iop">
`
`</TD></TR><TR><TD VALIGN
`
`
`
`
`="1 '> <img src=imagesLconcert_picture align=top border
`
`
`</TD><TD>
`
`<Markup
`
`language DBNAM E=":datasource"
`
`database
`
`
`
`
`
`="SELECT id, name, date, time
`
`FROM category
`
`WHERE active
`
`=1 AND parent=rconcert_id
`
`
`
`ORDER BY date, time"
`
`FIG. 5
`(CONT.)
`
`
`
`OUTPUT
`
`SIZE=-1 ><B> ="<FONT FACE='Verdana,Arial"
`
`PAGE 13
`
`

`

`
`U.S. Patent Jun.16,2009 Sheet 12 of
`30
`
`US 7,548,869 B2
`
`
`
`
`
`<A HREF=' Reserve1 .ihtml?& id=;1 '>:2</A>
`
`
`FIG. 5
`(CONT.)
`
`</8></FONT><p>">
`
`
`
`
`
`</TD></TR><TR><TD COLSPAN=2><HR></TD></TR>
`
`
`
`<databaseFETCH ALIAS="concert">
`
`
`
`</WHILE ALIAS=i_databaseempty>
`
`
`
`</database ALIAS="concert">
`
`<'TABLE>
`
`</BODY>
`
`
`
`</markup language>
`
`
`
`
`
`processing then passes to:
`
`
`
`<Markup language>
`
`
`
`<REM---Im ports the file "datasource.inc" which creates the --->
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM ---variable "datasource" which is used to tell Markup language which
`
`--->
`
`
`
`
`
`
`
`<REM ---database datasource to connect to.
`
`--->
`
`
`
`<INCLUDE NAM E="database\datasource.inc">
`
`
`
`<REM In case a database or other type of error occurs, this will display the error message.>
`
`
`
`
`
`
`
`
`
`
`
`
`
`<ERROR>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="+1 "><B>An Error Has Occurred</B></FONT><P>
`
`
`
`
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>Error Message=
`
`
`
`
`
`:i_ errortext</8></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>database Error =
`
`
`
`
`
`
`
`:idatabaseerrortext</B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>database Error =
`
`
`
`
`
`
`
`:i_ databaseerrorstm t</8></FONT><P>
`
`</ERROR>
`
`
`
`
`
`
`
`
`
`<REM ---Begin normal markup language here--->
`
`<markup language>
`
`<HEAD>
`
`
`
`
`
`<TITLE> Ticketing &amp; Reservation System -Select Seat(s)</TITLE>
`
`
`
`
`
`PAGE 14
`
`

`

`U.S. Patent Jun.16,2009 Sheet 13 of 30
`
`
`
`
`
`US 7,548,869 B2
`
`</HEAD>
`
`FIG. 5
`(CONT.)
`
`
`
`
`
`
`
`
`
`
`
`<REM ---All seats clicked will pass its information to a input box, "newseats". When done,
`
`
`
`
`
`the information will be passed to "process.ihtml" and be processed by "reserve2.ihtml". --->
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM ---This code allows the ability to select multiple seats before proceeding to the next
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`step of reservation process. Other features include listing the selected seats in the
`
`
`
`
`
`"number" text box to show the seats that has been clicked. This script also alters the button
`
`
`
`
`
`
`
`
`
`
`
`
`
`text to be grammatically correct. --->
`
`="JavaScript'>
`
`<SCRIPT LANGUAGE
`
`<f--
`
`
`
`
`
`function selectseat(idnum, seatnum)
`
`reserved
`
`
`
`
`=document.seats. number. value;
`
`== "')
`if ( reserved
`
`
`
`
`
`
`language DBNAME=:"+"datasource document. seats. newseats. value= "<Markup
`
`
`
`
`
`database
`
`
`
`
`
`
`
`='INSERT INTO basket (custid, pid, qty) VALUES (:"+"custid, "+idnurn+",
`
`
`
`
`
`
`1 )'><database DBNAM E=:"+"datasource database
`
`
`
`=' SELECT cost FROM products WHERE
`
`VALUE=:"+"1 ></database><iEQ
`
`
`EQ NAM E='ticketprice'
`id="+idnum +' '><databaseFETCH><i
`
`
`VALUE=<iEVAL
`NAME='total'
`
`
`
`EXPR=':"+'ticketprice + :"+'fotal' PREC='2'»<Markup
`
`
`
`language DBNAME=:"+" datasource database
`
`
`
`
`
`
`='INSERT INTO orderdetail (pid, aid, qty, sell)
`
`
`
`
`
`VALUES ("+idnum+", :"+"oid, 1, :"+'ticketprice)'>";
`
`
`
`
`
`document.seats.number.value= seatnum;
`
`
`
`
`
`document. seats. button1. value= "Reserve Seat";
`
`
`
`
`
`
`
`
`
`document.seats.button2.value = "Clear Choice";
`
`else
`
`
`
`
`
`
`
`
`
`document. seats.newseats. value+= "<Markup language DBNAME=:"+"datasource
`
`database
`
`
`
`
`
`
`
`
`
`='INSERT INTO basket (custid, pid, qty) VALUES (:"+"custid, "+idnum+",
`
`PAGE 15
`
`

`

`U.S. Patent Jun.16,2009 Sheet 14 of 30
`
`
`
`US 7,548,869 B2
`
`
`
`1)'><database DBNAME=:"+"datasource database
`
`
`
`
`='SELECT cost FROM products WHERE
`
`
`
`id="idnum+"'><databaseFETCH><iEQ NAME=' ticketprice'
`
`
`VALUE=:"-1;"1></database><IEQ
`
`
`
`+ :"+'total' PREC='2'»<Markup EXPR=':"+'licketprice NAME='total' VALUE=<iEVAL
`
`
`
`
`
`
`
`
`
`
`databaselanguage DB NAM E=:"+"datasource
`
`
`
`=' INSERT INTO orderdetail (pid, old, qty, sell)
`
`
`
`VALUES ("+idnum+", :"+"oid, 1, :"+'ticketprice)'>";
`
`
`
`
`
`document.seats.number.value= reserved+", "+seatnum;
`
`
`
`
`
`
`
`Seats"; document. seats. button1. value= "Reserve
`
`
`
`
`= "Clear Choices";
`document.seats.button2.value
`
`}
`
`}
`
`
`
`function clear()
`
`
`
`document.seats.newseats.value = "';
`
`
`
`
`
`}
`
`//-->
`
`</SCRIPT>
`
`<BODY BACKGROUND
`
`
`
`
`="images/background.jpg" TEXT =''#000000" LINK=''#006666"
`
`VLINK=''#006666''>
`
`
`
`<REM··· Begin database query to retrieve the last id number from table "orderdetail" for the
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`purpose of creating a new instance of the stage image whenever a new order has occurred.
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`This will prevent the browser from displaying an old floor image from its cache as a dlfferent
`
`
`
`
`
`
`
`
`
`
`
`
`
`image name is called every time the file is run. •-· >
`
`
`
`
`
`
`
`<database DBNAM E=": datasource"
`
`database
`
`="SELECT max(id)
`
`FROM orderdetail''>
`
`<databasemCH>
`
`=:1>
`<iEQ NAME="imagenum"VALUE
`
`<databaseFETCH>
`
`</database>
`
`FIG. 5
`(CONT.)
`
`PAGE 16
`
`

`

`
`U.S. Patent Jun.16,2009
`
`
`US 7,548,869 B2
`
`Sheet 15 of 30
`
`
`
`<iEQ NAM E="imagetype" VALUE=".jpg''>
`
`<CENTER>
`
`
`
`
`
`<TABLE BGCOLOR=40000001 BORDER=O CELLPADDING=5 CELLSPACING=0
`
`
`
`WIDTH=500>
`
`<TR><TD><CENTER>
`
`
`11 SIZE=+1 COLOR='#FFFFFP><B>
`<FONT FACE='Verdana,Arial
`
`
`
`
`
`Concert Reservation System
`
`</B></FONT>
`
`</CENTER>
`
`
`
`
`
`</TD></TR></TABL E></ CENTER>< p>
`
`
`
`<REM -Loads the core image that will be dynamically altered for use as the image map. - >
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`<ilMAGEFROMFI LE NAM E="stage" FILENAM E="im ages/stage.jpg" TYPE='Jpeg">
`
`
`
`
`
`<MAP NAM E="stage" BORDER=O>
`
`
`
`
`
`
`
`
`
`
`
`<REM ---Begin database query to retrieve all seat information for the image map
`
`
`
`--->
`
`
`"stage". Will loop until all available seat information for this particular performance is listed.
`
`
`
`
`
`
`
`
`
`
`
`<REM ---The return query will be used only if the "active" attribute of that particular seat is
`
`
`
`
`
`
`
`
`
`
`
`marked 'true" or "1 ". --->
`
`
`
`
`
`
`
`
`
`
`
`<REM ---If active, the seat's information, including image map coordinates will be displayed.
`
`
`
`Otherwise, the seat on the image map will be x'd out according to the x and y coordinates
`
`
`
`
`with it. --->
`associated
`
`
`
`<database DBNAM E=":datasource"
`
`
`
`
`
`database="SELECT id, active, x, y, shape, corrds, name, mouseout, mouseover1,
`
`
`
`
`
`
`
`
`
`
`
`mouseover2, mouseover3
`
`FROM products
`
`WHERE catid=:id">
`
`<databaseFETCH>
`
`
`
`
`
`<iEQ NAME="active" VALUE=:2>
`
`
`
`<iCASE ALIAS="active" VALUE=1 >
`
`<iWHILE NOTALIAS=i_databaseempty>
`FIG. 5
`{CONT.)
`
`
`
`
`
`PAGE 17
`
`

`

`U.S. Patent Jun.16,2009 Sheet 16 of 30
`
`
`
`US 7,548,869 B2
`
`
`
`
`
`
`
`
`
`pt:selectseat(: 1,': 7')" ALT ="Seat # : 7" <AREA SHAPE=":5" COORDS=":6" HREF='Javascri
`
`OnMouseOut=:8 OnMouseOver
`
`=:9 :7 :10 :7 :11 >
`
`
`
`</iCASE ALIAS="active">
`
`
`
`
`
`<iCASE ALIAS="active" VALUE=0>
`
`
`
`
`
`<ilMAGETEXT NAME="stage" TEXT ="X" X=:3 Y=:4 COLOR="red">
`
`</iCASE ALIAS="active">
`
`<databaseFETCH>
`
`
`
`</iWHI LE ALIAS=i_databaseempty>
`
`</ database>
`
`</MAP>
`
`<CENTER>
`
`
`
`
`
`<FONT FACE='Verdana,Ari al" SIZE="-1 "><B>
`
`
`
`Click on the seat you wish to reserve.
`
`</B></FONT>
`
`
`
`<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>
`
`
`
`
`
`<TR><TO>
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM ---Converts the dynamically generated image, "stage", into a web friendly image type-
`
`'Jpeg". --->
`
`
`
`
`
`
`
`
`
`
`
`<ilMAGEWRITE NAM E="stage" FILENAM E="images/ch_stage-:id-:imagenum :"imagetype"
`
`
`
`TYPE='jpeg" QUALITY="30'>
`
`
`
`
`
`
`
`
`
`
`
`<REM ---Deletes the tern porary image "stage" as it is no longer needed. --->
`
`
`
`
`
`<ilMAGEDESTROY NAM E="stage">
`
`
`
`<IMG SRC="images/legend.jpg" BORDER=0 HEIGHT=20 WIDTH=584><BR>
`
`
`
`
`
`
`
`<IMG SRC=''images/ch_stage-:id-imagenum:imagetype" BORDER=0 USEMAP=''#stage"
`
`
`
`
`
`HEIGHT=315 WIOTH=584>
`
`</CENTER>
`
`
`
`</TD></TR></TABLE>
`
`
`
`<FONT FACE='Verdana,Arial' SIZE=-1><8>
`
`
`
`An ''.X" denotes a seat that has already been taken.
`
`
`
`FIG. 5
`(CONT.)
`
`PAGE 18
`
`

`

`
`U.S. Patent Jun.16,2009 Sheet 17 of
`30
`
`US 7,548,869 B2
`
`</B></FONT>
`
`
`
`
`
`<FORM NAM E="seats" ACTION="process.ihtm I" M ETHOD="post">
`
`<CENTER>
`
`
`
`<TABLE BGCOLOR='#000000' BORDER=O CELLPADDING=O CELLSPACING=O>
`
`
`
`
`
`
`
`<TR><TD>
`
`
`
`<TABLE BGCOLOR='#FFFFFP BORDER=O CELLPADDING=5 CELLSPACING=1 >
`
`
`
`
`
`
`
`
`
`<TR><TD><CENTER>
`
`
`
`<FONT FACE='Verdana,Arial' SIZE=-1><B>
`
`
`
`
`
`
`
`Your mouse is over seat#: <INPUT TYPE='text" NAME="seatnum" SIZE=S>
`
`
`
`</B></FONT></CENTER>
`
`</TD></TR><TR><TD><CENTER>
`
`
`
`<FONT FACE='Verdana,Arial' SIZE=-1><B>
`
`
`
`Selected Seats:<BR><INPUT TYPE='text" NAME="number" SIZE=40>
`
`
`
`
`
`<BR>
`
`
`
`<INPUT TYPE="hidden" NAME="newseats" SIZE=50>
`
`
`
`
`
`
`
`
`
`<INPUT TYPE="s�bm it" NAM E="button1" VALUE="Reserve Seat">& nbsp;<I NPUT
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`TYPE="reset" NAM E="button2" VALUE="Clear Choice" onClick="clear()">
`
`</B></FONT>
`
`</CENTER>
`
`
`
`</TD></TR></TABLE></TD></TR></TABLE></CENTER>
`
`
`
`</FORM ></CENTER></BODY>
`
`
`
`</markup language>
`
`
`
`which then passes to a template:
`
`
`
`<Markup language>
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM ---Imports the file "datasource.inc" which creates the variable "datasource" which is
`
`
`
`
`
`
`
`
`
`
`
`used to tell Markup language which ODBC datasource to connect to.
`
`
`
`<ilNCLUDE NAM E="database\datasource.inc">
`
`
`
`<REM ---In case a database or other type of error occurs, this will display the error
`
`
`
`
`
`
`
`
`
`
`
`message. - >
`
`FIG. 5
`(CONT.)
`
`PAGE 19
`
`

`

`
`U.S. Patent Jun.16,2009 Sheet 18 of
`30
`
`US 7,548,869 B2
`
`<ERROR>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="+1 '><B>An Error Has Occurred</B></FONT><P>
`
`
`
`
`
`
`
`
`
`=
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>Error Message
`
`
`
`:i_errortext</B></FONT><P>
`
`
`
`
`
`=
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>database Error
`
`:i_ databaseerrortext</B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 '><B>database Error =
`
`
`
`
`
`:i_databaseerrorstmt</B></FONT><P>
`
`</ERROR>
`
`
`
`
`
`
`
`
`
`<REM---Copy a preformatted file, "empty.ihtml" into a new file, --->
`
`--->
`<REM ---"reserve2.ihtml".
`
`
`
`<iCOPYFILE SRC="empty.ihtml" DST ="reserve2.ihtml>
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM ---Appends the information passed from "reseve1 .ihtml" to "reserve2.ihtml" for
`
`
`
`process. Other html information is also passed. --->
`
`
`
`
`
`
`
`<iFILE NAME="reserve2.ihtml" DATA=":newseats" OP="append'>
`
`
`
`
`
`
`
`<iFILE NAME="reserve2.ihtml" DATA="<INPUT TYPE='hidden' NAME='total'
`
`
`
`
`
`
`
`VALUE=:total>" OP="append">
`
`
`
`
`
`<iFILE NAM E="reserve2.ihtml" DATA="</FORM>" OP="append">
`
`
`
`
`
`
`
`<iFILE NAME="reserve2.ihtml" DATA="</CENTER>" OP="append">
`
`
`
`
`
`
`
`<iFILE NAME="reserve2.ihtml" DATA="<P>" OP="append'>
`
`
`
`
`
`
`
`<iFILE NAME="reserve2.ihtml" DATA="</BODY>" OP="append">
`
`
`
`
`
`OP="append'>
`DATA="</markup language>" <iFILE NAME="reserve2.ihtml"
`
`
`
`
`
`
`
`
`
`<REM ---Once the information is appended into "reserve2.ihtml''. it will be automatically
`
`to the browser. --->
`push the page "reserve2.ihtml"
`
`
`
`
`
`<iREDIR URL ="reserve2.ihtm I">
`
`
`
`
`
`
`
`
`
`which then combines information and passes to:
`
`
`
`<Markup language>
`
`
`
`
`
`<REM ---Im ports the file "datasource.inc" which creates the variable "datasource" which is
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`used to tell Markup language which ODBC datasource to connect to. --->
`FIG. 5
`(CONT.)
`
`PAGE 20
`
`

`

`U.S. Patent Jun.16,2009 Sheet 19 of 30
`
`
`
`US 7,548,869 B2
`
`
`
`<ilNCLUDE NAME="database\datasource.inc">
`
`
`
`
`
`<REM ---In case a database or other type of error occurs, this will display the error
`
`
`
`
`
`
`
`
`
`message. - >
`
`<ERROR>
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="+1 '><B>An Error Has Occurred</B></FONT><P>
`
`
`
`
`
`SIZE="-1 '><B>Error Message
`
`<FONT FACE='Verdana,Arial"
`
`=
`
`
`
`:i_errortext</B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 '><B>database Error=
`
`:idatabaseerrortext</B></FONT><P>
`
`<FONT FACE='Verdana,Arial"
`
`SIZE="-1 '><B>database Error
`
`=
`
`
`
`:i_databaseerrorstmt</B></FONT><P>
`
`</ERROR>
`
`
`
`
`
`
`
`
`<REM ---Copy a preformatted file, "empty.ihtml" into a new file, "reserve2.ihtml".
`--->
`
`<iCOPYFI LE SRC="em pty.ihtm
`
`
`I" DST ="reserve2.ihtm r>
`
`
`
`
`
`
`
`
`
`
`
`
`
`<REM Appends the information passed from "reseve1 .ihtm I" to "reserve2.ihtml" for
`
`
`
`
`
`process. Other html information is also passed. --->
`
`
`
`
`
`OP="append">
`DATA=":newseats"
`<iFILE NAM E="reserve2.ihtml"
`
`
`
`
`
`<iFILE NAME="reserve2.ihtml"
`DATA="<INPUT
`TYPE='hidden'
`NAM E='total
`
`
`
`VALUE=:total>" OP="append'>
`
`OP="append">
`I" DATA="</FORM>"
`<iFILE NAM E="reserve2.ihtm
`
`
`
`OP="append"> <iFILE NAME="reserve2.ihtml" DATA="</CENTER>"
`
`
`
`
`
`
`OP="append">
`
`<iFILE NAME="reserve2.ihtml" DATA="<P>"
`
`
`
`OP="append'> <iFILE NAME="reserve2.ihtml" DATA="</BODY>"
`
`
`
`
`
`
`
`
`<iFILE NAM E="reserve2.ihtml"
`
`DATA="</markup language>"
`OP="append">
`
`
`
`<REM ---Once the information is appended into "reserve2.ihtml", it will be automatically
`
`
`
`
`
`
`
`push the page "reserve2.ihtm I" to the browser.
`
`
`
`<iREDIR URL ="reserve2.ihtml'>
`
`
`
`
`
`then (takes all information from index & reserve one and conbines it to with the information
`
`
`
`
`
`
`
`
`
`
`
`in empty) then passes to:
`
`FIG. 5
`(CONT.)
`
`PAGE 21
`
`

`

`
`U.S. Patent Jun.16,2009 Sheet 20 of
`30
`
`US 7,548,869 B2
`
`
`
`<! Markup language>
`
`
`
`
`
`
`
`<REM ---Imports the file "datasource.inc" which creates the variable "datasource" which is
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`used to tell Markup language which ODBC datasource to connect to. --- >
`
`
`
`<ilNCLUDE NAM E="database\datasource.inc">
`
`
`
`
`
`<REM --In case a database or other type of error occurs, this will display the error
`
`
`
`
`
`
`
`
`
`message. -->
`
`<ERROR>
`
`
`
`
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="+1 ''><B>An Error Has Occurred</B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 ''><B>Error Message=
`
`
`
`
`
`:i_errortext</B></FONT><P>
`
`
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>database Error =
`
`
`
`
`
`:i_databaseerrortext</B></FONT><P>
`
`
`
`<FONT FACE='Verdana,Arial" SIZE="-1 "><B>database Error=
`
`
`
`
`
`
`
`
`
`i_ d atabaseerrorstm t</B></FONT><P>
`
`</ERROR>
`
`
`
`
`
`
`
`
`
`<REM ---Begin normal markup language here
`
`--->
`
`
`
`<markup language>
`
`<HEAD>
`
`
`
`
`
`<TITLE> Ticketing &amp; Reservation System -Customer Inform ation</TITLE>
`
`
`
`
`
`
`
`
`
`</HEAD>
`
`
`
`<BODY BACKGROUND="im ages/background.jpg" TEXT =''#000000" LI NK=''#006666"
`
`
`
`
`
`VLI NK=''#006666">
`
`
`
`
`
`<REM-------Get Customer Info------->
`
`<CENTER>
`
`
`
`
`
`<TABLE BGCOLOR='#000000' BORDER=0 CELLPADDING=5 CELLSPACING=0
`
`
`
`
`
`
`
`WIDTH=500>
`
`<TR><TD><CENTER>
`
`
`
`
`
`<FONT FACE='Verdana,Arial' SIZE=+1 COLOR='#FFFFFP><B>
`FIG. 5
`(CONT.)
`
`
`
`
`
`Ticketing &amp; Reservation System
`
`PAGE 22
`
`

`

`
`
`Jun.16,2009
`U.S. Patent
`
`US 7,548,869 B2
`
`Sheet 21 of 30
`
`</B></FONT>
`
`</CENTER>
`
`</TD></TR>
`
`</TABLE><p>
`
`
`
`<FORM ACTION=reserve3.ihtml METHOD=POST>
`
`
`
`
`
`<TABLE BGCOLOR='#000000' BORDER=0 CELLPADDING=0 CELLSPACING=0>
`
`
`
`
`
`<TR><TD>
`
`
`
`<TABLE BGCOLOR='#FFFFFP BORDER=O CELLPADDING=5 CELLSPACING=1 >
`
`
`
`
`
`
`
`
`
`<TR>
`
`
`
`
`
`<TD COLSPAN=2><CENTER><FONT FACE='Verdana,Arial' SIZE=-
`
`
`
`
`
`1 ><B>CUSTOM ER INFORMATION</CENTER></TD>
`
`</TR><TR>
`
`
`
`
`
`<TD><FONT FACE='Verdana,Arial' SIZE=-1><B>Name as appear on
`
`
`
`
`
`
`
`CC</B></FONT></TD>
`
`
`
`<TD><FONT FACE='Verdana,Arial' SIZE=-1><B><INPUT TYPE='lext"
`
`
`
`
`
`
`
`
`
`NAME="name" MAXLENGTH=50 SIZE=40></B></FONT></TD>
`
`</TR><TR>
`
`
`
`
`
`<TD><FONT FACE='Verdana,Arial' SIZE=-1><B>Phone</B></FONT></TD>
`
`
`
`
`
`
`
`<TD><FONT FACE='Verdana,Arial' SIZE=-1 ><B><INPUT TYPE='lext"
`
`
`
`
`
`NAM E="phone" MAXLENGTH=50 SIZE=12></B></FONT></TD>
`
`
`
`
`
`</TR><TR>
`
`
`
`
`
`
`
`
`
`<TD><FONT FACE='Verdana,Arial' SIZE=-1 ><B>Em ail</B