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);