if (!$result) {
$success = MetabaseRollbackTransaction($gDatabase);
$errorhandler->display('SQL', 'editbook.php', $query);
} else {
$success = MetabaseCommitTransaction($gDatabase);
$success = MetabaseAutoCommitTransactions($gDatabase, true);
}
} else {
if ($request->GetVar('frm_step', 'post') == "changeguest") {
$query = sprintf("SELECT fk_guest_id FROM {$tbl_booking} \n\t\t\t\t\t WHERE pk_booking_id = %s ", $bookid);
$result = MetabaseQuery($gDatabase, $query);
if (!$result) {
$errorhandler->display('SQL', 'editbook.php', $query);
}
$oldguestid = MetabaseFetchResult($gDatabase, $result, 0, 0);
$smarty->assign('tpl_guestlist', $guest->getListWithoutEscorts($bookingdetailid, $oldguestid));
$smarty->assign('tpl_step', 'changeguest');
} else {
if ($request->GetVar('frm_step', 'post') == "saveguest") {
$success = MetabaseAutoCommitTransactions($gDatabase, false);
$query = sprintf("SELECT fk_guest_id FROM {$tbl_booking} \n\t\t\t\t\t WHERE pk_booking_id = %s ", $bookid);
$result = MetabaseQuery($gDatabase, $query);
if (!$result) {
$success = MetabaseRollbackTransaction($gDatabase);
$errorhandler->display('SQL', 'editbook.php', $query);
}
$oldguestid = MetabaseFetchResult($gDatabase, $result, 0, 0);
$query = sprintf("UPDATE {$tbl_booking} SET fk_guest_id = %s,\n\t\t\t\t\t updated_date = NOW(), fk_updated_user_id = %s \n\t\t\t\t\t WHERE pk_booking_id = %s ", $request->GetVar('frm_guest', 'post'), $request->GetVar('uid', 'session'), $bookid);
$result = MetabaseQuery($gDatabase, $query);
if (!$result) {
$success = MetabaseRollbackTransaction($gDatabase);
