$rFindTicket = db_fetch($qFindTicket); # $qFindUser = db_query("SELECT * FROM ".$sql_prefix."_users WHERE ID = '$rFindTicket->user'"); # $rFindUser = db_fetch($qFindUser); $content .= user_profile($rFindTicket->user); # $content .= $rFindUser->firstName." ".$rFindUser->lastName." ".lang("a.k.a.", "seating")." ".$rFindUser->nick; # if($sessioninfo->userID != 1 && $rFindUser->EMail != '') { # $qCheckMailSetting = db_query("SELECT * FROM ".$sql_prefix."_userPreferences WHERE name = 'allowViewMail' AND userID = '$rFindTicket->user'"); # $rCheckMailSetting = db_fetch($qCheckMailSetting); # if($rCheckMailSetting->value == 'on') $content .= "<br />".lang("Contact this user: "******"seating").$rFindUser->EMail; # } // End if sessioninfo->userID != 1 } // End db_num > 0 } // End !empty $content .= "<br /><br />"; $content .= display_systemstatic("seatmap"); } elseif ($_GET['action'] == "takeseat") { $seatX = $_GET['seatX']; $seatY = $_GET['seatY']; $ticketID = $_GET['ticketID']; $eventID = $sessioninfo->eventID; $password = $_POST['password']; $newlog['ticketID'] = $ticketID; $newlog['seatX'] = $seatX; $newlog['seatY'] = $seatY; $newlog['password'] = $password; if (seating_rights($seatX, $seatY, $ticketID, $eventID, $password)) { // We have rights to seat that ticket. Update DB $qTicketInfo = db_query("SELECT * FROM " . $sql_prefix . "_tickets WHERE ticketID = '" . db_escape($ticketID) . "'"); $rTicketInfo = db_fetch($qTicketInfo); // Check if that ticket is already used
// End while } // End if(db_num(qListBuyTickets) if (config("enable_reseller", $sessioninfo->eventID)) { $content .= "<tr><td>" . lang("Ticketcode from reseller", "ticketorder") . "</td>\n"; $content .= "<form method=POST action=?module=ticketorder&action=buyticket>\n"; $content .= "<td><input type=text name=resellercode size=10>\n"; $content .= "<input type=submit value='" . lang("Claim ticket", "ticketorder") . "'>\n"; $content .= "</form></td></tr>"; } // End config(enable_reseller) $content .= "</table>"; $content .= "<br /><br />"; $content .= display_systemstatic("ticketorder"); if ($prepaid_amount > 1) { $system_msg = display_systemstatic("ticketorder_unpaid_tickets"); $system_msg = str_replace("%%AMOUNT%%", $prepaid_amount, $system_msg); $system_msg = str_replace("%%USERID%%", $sessioninfo->userID, $system_msg); $content .= $system_msg; } // End if } elseif ($action == "buyticket" && !empty($_GET['tickettype']) && !empty($_POST['numTickets'])) { // Buy tickets $numTickets = $_POST['numTickets']; $tickettype = $_GET['tickettype']; if ($numTickets > $maxTicketsPrUser) { $numTickets = $maxTicketsPrUser; } while ($numTickets) { // Check what type the ticket has $qTicketType = db_query("SELECT type FROM " . $sql_prefix . "_ticketTypes WHERE ticketTypeID = " . db_escape($tickettype));