FREESEAT

FAQ

FreeSeat hasn't been updated for a long while. What's up?

There are no known issues, and I don't need any additional feature. If you find a bug or need a new feature, please post it in the appropriate tracker (see the answer of the last question).

How do I set up a seating plan?

That's actually the most tedious part of installing FreeSeat. It requires either some programming knowledge (shell scripting) or lots of patience. I provided two example scripts that you may want to use as a base (they output a MySQL script which you can then execute to populate your seats table). If you are under Windows you will probably require Cygwin to execute them.

Another way is to enter the seats one by one with statements such as

insert into seats (theatre,row,col,x,y,class,extra,zone) values (1 ,1 ,2 ,3 ,13 ,1 ,"Pair" ,"Balcon" );

to be executed in the MySQL client.

To help you decide whether FreeSeat is right for you I provided an example seating plan here (which is for the theatre in Vevey). You can simply execute it in your mysql client by typing \. theatrevevey.sql at the prompt. Note that that script will erase any pre-existing seating plan of id 1.

Admin over HTTP?

I don't recommend it, but if for some reason you really can't use HTTPS on your website, you can do the following change to support admin mode over HTTP:

Look for the function admin_mode in mysqlstuff.php, and replace the following code:

return ( isset( $_SESSION["adminpass"] ) && 
	((isset( $_SERVER['HTTPS'] ) && $_SERVER['HTTPS'] == 'on') ||
	(isset( $_SERVER['SERVER_PORT']) &&
	$_SERVER['SERVER_PORT']=='443')));

by

return isset( $_SESSION["adminpass"]);

I need more than two price categories (e.g. different prices for Members, Students, Children, etc)

I wrote a patch again version 1.1.5d for that. Please read the instructions in the patched README file for installation.

Tickets are cut when printing more than can hold on one page

This is a failure of the browser to handle the page-break-inside property. Last time I checked, Opera and Konqueror (linux) handled it correctly.

I noticed people can obtain and print tickets without having paid them!

True. This may change in a future version, but currently FreeSeat will give access to a ticket as soon as it has been booked, rather than waiting for it to be paid. The motivation is two-fold:

1. People can book tickets without having/giving an e-mail address (they use the site a single time, print their tickets, then pay)
2. I don't want to give the administrator a false sense of trust, that anybody holding a ticket can be assumed to have paid. Anyway you are going to have to check the tickets against a list of known valid tickets (see next question)

So, how should the ticket checking procedure go?

You need to check three things:

1. The ticket has a valid id (those numbers written on the border)
2. The ticket's information (date, class, rate) is correct with respect to that id (people should not be allowed to print the same ticket many times with different dates)
3. A given ticket number is used only once (we don't want two persons to enter with two copies of the same ticket)

Depending on how many people you are expecting, how much you trust them and how long you are ready to make them wait, there are various things you can do:

• After on-line reservation closes, prepare a stack of tokens, one for each known valid reservation id (as obtained from the booking server database). When people come, exchange their printed ticket with the token with a matching number. If you don't find a token matching number, one of the three conditions above has failed. This is quite fool proof but very time consuming. Note that if someone "guesses" a valid reservation id and comes in before the actual buyer, the latter won't be let in. Can be a problem, so you may want to put more information on the tokens (person's name, etc) than just the id, to make it harder for cheaters.
• Another, faster way, is to have a list of valid reservation ids. When someone comes, check if his ticket id is valid. If so, tear out the part of his ticket with reservation id and let him in. This secures you against (1) and (2), but not (3). When the show is over, check the list of reservation ids you have torn out, and look for duplicates. Then you will know how many people have cheated (if any), and may decide to switch to another strategy for future shows if you think it is too large.
• Another, even faster, way, is to do the previous strategy without checking anything beforehand, just keep the reservation ids and check afterwards. You may want to alter the ticket to display the ids differently for reduced tickets and non-reduced ones, for (2) - Otherwise people can buy a reduced ticket on-line, and manually change the ticket to display "full price", and you will never know it. Again, this is interesting if you want to trust your customers but still know afterwards if it was a good idea or not.
• Another option may be to have a list of valid ticket ids, and, for each person, take them to their seat. Then you'll see for yourself if there's someone else sitting there already. This makes it much harder for people with duplicate tickets to go unnoticed.

I need more than one ticket checking point. How does it change things for me?

All but the first method in the previous question still work. For the first method (exchanging tickets for tokens), either label the checking points according to reservation id (as in "People with tickets ending in -2 and -3 check in here" etc), modify the ticket generation code to display something like "check in at counter G", or use a networked application that marks valid tickets as "used", every ticket checking counter being connected to the same server.

I have a question which isn't answered here

Please use the source forge trackers if you need help for installation, configuration, to request additional features, to post bug reports, and to post patches.

Of course you'll understand, the program being free, that I can't give any guarantee as to solving/implementing these issues.

Against payment, though (amounts to be discussed - there's no fixed price), I may provide partial or full management of your ticketing requirements, including hosting, configuration and developing additional features. Please contact me at maxime at gamboni dot org