EUROMOVERS International Event Registration

A fatal MySQL error occured.\n
Query: " . $query . "
\nError: (" . mysql_errno() . ") " . mysql_error() ); $rows = array(); while($r = mysql_fetch_assoc($result)) { $rows[] = $r; } header('Cache-Control: no-cache, must-revalidate'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); header('Content-type: application/json'); print json_encode($rows); die(); } // Bestellung speichern // und zu Paypal weiterleiten if($_POST['gesendet'] == true AND $_POST['zahlungsmethode'] == "creditcard") { $unique_id = uniqid(); // Bestell-ID $email = ""; $email .= "REGISTRATION ------------ "; $form1 = explode("&", utf8_decode(urldecode($_POST['form1']))); for($i = 3; $i <= (count($form1) - 1);) { $dummy1 = explode("=", $form1[$i]); $dummy2 = explode("=", $form1[$i+1]); $dummy3 = explode("=", $form1[$i+2]); // TYP bestimmen if($dummy3[1] == "1000") $typ = "Delegate Registration"; elseif($dummy3[1] == "750") $typ = "Spouse Registration"; $email .= $typ . ": " . mysql_real_escape_String($dummy1[1]) . " " . mysql_real_escape_String($dummy2[1]) ." - " . $dummy3[1] . " EUR "; $sql_query = "INSERT INTO `personen` (`unique_id`, `vorname`, `nachname`, `typ`, `kosten`) VALUES ('" . $unique_id . "', '" . mysql_real_escape_String($dummy1[1]) . "', '" . mysql_real_escape_String($dummy2[1]) . "', '" . $typ . "', '" . $dummy3[1] . "');"; $sql_result = mysql_query($sql_query) or die("insert 'Person' fails"); unset($dummy1); unset($dummy2); unset($dummy3); $i = $i + 3; } $email .= " HOTEL ----- "; $form2 = explode("&", utf8_decode(urldecode($_POST['form2']))); for($i = 5; $i <= (count($form2) - 1);) { $dummy1 = explode("=", $form2[$i]); $dummy2 = explode("=", $form2[$i+1]); $dummy3 = explode("=", $form2[$i+2]); $dummy4 = explode("=", $form2[$i+3]); $dummy5 = explode("=", $form2[$i+4]); // TYP bestimmen //if($dummy3[1] == "165") $typ = "Single Room"; if($dummy3[1] == "205") $typ = "Single Room"; elseif($dummy3[1] == "230") $typ = "Double Room"; $email .= $dummy5[1] . " Night(s) in a " . $typ . " (" . $dummy1[1] . " to " . $dummy2[1] .") - " . $dummy4[1] . " EUR "; $sql_query2 = "INSERT INTO `zimmer` (`unique_id`, `ankunft`, `abreise`, `typ`, `preis`, `tage`, `gesamtkosten`) VALUES ('" . $unique_id . "', '" . $dummy1[1] . "', '" . $dummy2[1] . "', '" . $typ . "', '" . $dummy3[1] . "', '" . $dummy5[1] . "', '" . $dummy4[1] . "');"; $sql_result2 = mysql_query($sql_query2) or die("insert 'Hotelzimmer' fails: " . $sql_query2); unset($dummy1); unset($dummy2); unset($dummy3); unset($dummy4); unset($dummy5); $i = $i + 5; } $form3_keys = ""; $form3_values = ""; $form3 = explode("&", $_POST['form3']); for($i = 0; $i <= (count($form3) - 1); $i++) { $dummy = explode("=", $form3[$i]); $form3_keys .= "`" . $dummy[0] . "`, "; $form3_values .= "'" . mysql_real_escape_String(utf8_decode(urldecode( $dummy[1] ))) . "', "; unset($dummy); } $sql_query3 = "INSERT INTO `bestellungen` (`unique_id`, " . $form3_keys . " `total`, `taxes`, `cc_fee`, `email_text`) VALUES ('" . $unique_id . "', " . $form3_values . "'" . $_POST['total_price'] . "', '" . $_POST['total_taxes'] . "', '" . $_POST['cc_fee_price'] . "', '" . ($email) . "');"; $sql_result3 = mysql_query($sql_query3) or die("insert 'Bestelldaten' fails: " . $sql_query3); // Bestätigungsmail an Juchum versenden bestaetigung_versenden( $unique_id, false, "creditcard" ); $rechnungsnummer = generiereRechnung( htmlspecialchars(mysql_real_escape_String($unique_id)),"creditcard" ); // Rechnung wurde korrekt angelegt if( $rechnungsnummer ) { // Rechnung per E-Mail an den Vermittler senden rechnung_versenden( $rechnungsnummer, false, "creditcard" ); $success = true; } $_GET['id'] = $unique_id; } // Bestellung speichern // und zu Paypal weiterleiten if($_POST['gesendet'] == true AND $_POST['zahlungsmethode'] == "paypal") { $unique_id = uniqid(); // Bestell-ID $email = ""; $email .= "REGISTRATION ------------ "; $form1 = explode("&", utf8_decode(urldecode($_POST['form1']))); for($i = 3; $i <= (count($form1) - 1);) { $dummy1 = explode("=", $form1[$i]); $dummy2 = explode("=", $form1[$i+1]); $dummy3 = explode("=", $form1[$i+2]); // TYP bestimmen if($dummy3[1] == "1000") $typ = "Delegate Registration"; elseif($dummy3[1] == "750") $typ = "Spouse Registration"; $email .= $typ . ": " . mysql_real_escape_String($dummy1[1]) . " " . mysql_real_escape_String($dummy2[1]) ." - " . $dummy3[1] . " EUR "; $sql_query = "INSERT INTO `personen` (`unique_id`, `vorname`, `nachname`, `typ`, `kosten`) VALUES ('" . $unique_id . "', '" . mysql_real_escape_String($dummy1[1]) . "', '" . mysql_real_escape_String($dummy2[1]) . "', '" . $typ . "', '" . $dummy3[1] . "');"; $sql_result = mysql_query($sql_query) or die("insert 'Person' fails"); unset($dummy1); unset($dummy2); unset($dummy3); $i = $i + 3; } $email .= " HOTEL ----- "; $form2 = explode("&", utf8_decode(urldecode($_POST['form2']))); for($i = 5; $i <= (count($form2) - 1);) { $dummy1 = explode("=", $form2[$i]); $dummy2 = explode("=", $form2[$i+1]); $dummy3 = explode("=", $form2[$i+2]); $dummy4 = explode("=", $form2[$i+3]); $dummy5 = explode("=", $form2[$i+4]); // TYP bestimmen //if($dummy3[1] == "165") $typ = "Single Room"; if($dummy3[1] == "205") $typ = "Single Room"; elseif($dummy3[1] == "230") $typ = "Double Room"; $email .= $dummy5[1] . " Night(s) in a " . $typ . " (" . $dummy1[1] . " to " . $dummy2[1] .") - " . $dummy4[1] . " EUR "; $sql_query2 = "INSERT INTO `zimmer` (`unique_id`, `ankunft`, `abreise`, `typ`, `preis`, `tage`, `gesamtkosten`) VALUES ('" . $unique_id . "', '" . $dummy1[1] . "', '" . $dummy2[1] . "', '" . $typ . "', '" . $dummy3[1] . "', '" . $dummy5[1] . "', '" . $dummy4[1] . "');"; $sql_result2 = mysql_query($sql_query2) or die("insert 'Hotelzimmer' fails: " . $sql_query2); unset($dummy1); unset($dummy2); unset($dummy3); unset($dummy4); unset($dummy5); $i = $i + 5; } $form3_keys = ""; $form3_values = ""; $form3 = explode("&", $_POST['form3']); for($i = 0; $i <= (count($form3) - 1); $i++) { $dummy = explode("=", $form3[$i]); $form3_keys .= "`" . $dummy[0] . "`, "; $form3_values .= "'" . mysql_real_escape_String(utf8_decode(urldecode( $dummy[1] ))) . "', "; unset($dummy); } $sql_query3 = "INSERT INTO `bestellungen` (`unique_id`, " . $form3_keys . " `total`, `taxes`, `email_text`) VALUES ('" . $unique_id . "', " . $form3_values . "'" . $_POST['total_price'] . "', '" . $_POST['total_taxes'] . "', '" . ($email) . "');"; $sql_result3 = mysql_query($sql_query3) or die("insert 'Bestelldaten' fails: " . $sql_query3); // Bestätigungsmail an Juchum versenden bestaetigung_versenden( $unique_id ); $id = db_query_value("SELECT id FROM bestellungen WHERE unique_id = '" . $unique_id . "' LIMIT 1"); // Zu Paypal weiterleiten header("Location: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=thomas.juchum@euromovers.com&item_name=".urlencode("Your Booking for 2019 EUROMOVERS International Conference Copenhagen, Denmark #".$id)."&cpp_header_image=".urlencode("https://www.euromovers.com/events/img/logo.png")."¤cy_code=EUR&amount=".$_POST['total_price']."&rm=1&cancel_return=".urlencode("https://www.euromovers.com/events/index.php?id=" . $unique_id . "&paypal_failure=true")."&return=".urlencode("https://www.euromovers.com/events/index.php?id=" . $unique_id . "&paypal_success=1fe1cw4151c151")); //header("Location: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=thomas.juchum@euromovers.com&item_name=".urlencode("Your Booking for 2018 EUROMOVERS International Conference Prague, Czech Republic")."&cpp_header_image=".urlencode("https://www.euromovers.com/events/img/logo.png")."¤cy_code=EUR&amount=0.01&on0=EchterPreis&os0=".$_POST['total_price']."&rm=1&cancel_return=".urlencode("https://www.euromovers.com/events/index.php?id=" . $unique_id . "&paypal_failure=true")."&return=".urlencode("https://www.euromovers.com/events/index.php?id=" . $unique_id . "&paypal_success=1fe1cw4151c151")); header("Connection: close"); die; } // Nach PayPal soll // die Rechnung erstellt // und versendet werden if( $_GET['id'] AND $_GET['paypal_success'] == "1fe1cw4151c151" ) { if(!db_query_value("SELECT id FROM bestellungen WHERE unique_id = '" . $_GET['id'] . "' LIMIT 1")) $error = true; else { $rechnungsnummer = generiereRechnung( htmlspecialchars(mysql_real_escape_String($_GET['id'])) ); // Rechnung wurde korrekt angelegt if( $rechnungsnummer ) { // Rechnung per E-Mail an den Vermittler senden rechnung_versenden( $rechnungsnummer ); $success = true; } } } // Falls Vorkasse soll // die Rechnung erstellt // und versendet werden if( $_POST['gesendet'] == true AND $_POST['zahlungsmethode'] == "vorkasse" ) { $unique_id = uniqid(); // Bestell-ID $email = ""; $email .= "REGISTRATION ------------ "; $form1 = explode("&", utf8_decode(urldecode($_POST['form1']))); for($i = 3; $i <= (count($form1) - 1);) { $dummy1 = explode("=", $form1[$i]); $dummy2 = explode("=", $form1[$i+1]); $dummy3 = explode("=", $form1[$i+2]); // TYP bestimmen if($dummy3[1] == "1000") $typ = "Delegate Registration"; elseif($dummy3[1] == "750") $typ = "Spouse Registration"; $email .= $typ . ": " . mysql_real_escape_String($dummy1[1]) . " " . mysql_real_escape_String($dummy2[1]) ." - " . $dummy3[1] . " EUR "; $sql_query = "INSERT INTO `personen` (`unique_id`, `vorname`, `nachname`, `typ`, `kosten`) VALUES ('" . $unique_id . "', '" . mysql_real_escape_String($dummy1[1]) . "', '" . mysql_real_escape_String($dummy2[1]) . "', '" . $typ . "', '" . $dummy3[1] . "');"; $sql_result = mysql_query($sql_query) or die("insert 'Person' fails"); unset($dummy1); unset($dummy2); unset($dummy3); $i = $i + 3; } $email .= " HOTEL ----- "; $form2 = explode("&", utf8_decode(urldecode($_POST['form2']))); for($i = 5; $i <= (count($form2) - 1);) { $dummy1 = explode("=", $form2[$i]); $dummy2 = explode("=", $form2[$i+1]); $dummy3 = explode("=", $form2[$i+2]); $dummy4 = explode("=", $form2[$i+3]); $dummy5 = explode("=", $form2[$i+4]); // TYP bestimmen //if($dummy3[1] == "165") $typ = "Single Room"; if($dummy3[1] == "205") $typ = "Single Room"; elseif($dummy3[1] == "230") $typ = "Double Room"; $email .= $dummy5[1] . " Night(s) in a " . $typ . " (" . $dummy1[1] . " to " . $dummy2[1] .") - " . $dummy4[1] . " EUR "; $sql_query2 = "INSERT INTO `zimmer` (`unique_id`, `ankunft`, `abreise`, `typ`, `preis`, `tage`, `gesamtkosten`) VALUES ('" . $unique_id . "', '" . $dummy1[1] . "', '" . $dummy2[1] . "', '" . $typ . "', '" . $dummy3[1] . "', '" . $dummy5[1] . "', '" . $dummy4[1] . "');"; $sql_result2 = mysql_query($sql_query2) or die("insert 'Hotelzimmer' fails: " . $sql_query2); unset($dummy1); unset($dummy2); unset($dummy3); unset($dummy4); unset($dummy5); $i = $i + 5; } $form3_keys = ""; $form3_values = ""; $form3 = explode("&", $_POST['form3']); for($i = 0; $i <= (count($form3) - 1); $i++) { $dummy = explode("=", $form3[$i]); $form3_keys .= "`" . $dummy[0] . "`, "; $form3_values .= "'" . mysql_real_escape_String(utf8_decode(urldecode( $dummy[1] ))) . "', "; unset($dummy); } $sql_query3 = "INSERT INTO `bestellungen` (`unique_id`, " . $form3_keys . " `total`, `taxes`, `email_text`) VALUES ('" . $unique_id . "', " . $form3_values . "'" . $_POST['total_price'] . "', '" . $_POST['total_taxes'] . "', '" . ($email) . "');"; $sql_result3 = mysql_query($sql_query3) or die("insert 'Bestelldaten' fails: " . $sql_query3); // Bestätigungsmail an Juchum versenden bestaetigung_versenden( $unique_id, false, "vorkasse" ); //$id = db_query_value("SELECT id FROM bestellungen WHERE unique_id = '" . $unique_id . "' LIMIT 1"); $_GET['id'] = $unique_id; $rechnungsnummer = generiereRechnung( $unique_id, "vorkasse" ); // Rechnung wurde korrekt angelegt if( $rechnungsnummer ) { // Rechnung per E-Mail an den Vermittler senden rechnung_versenden( $rechnungsnummer, false, "vorkasse" ); $success = true; } } if( $_GET['paypal_failure'] ) { $error = true; if($_GET['id'] != "") { bestaetigung_versenden( $_GET['id'], true ); } } // Event-Daten if ($event == "") $event = 1; if ($event == 1) { } ?> EUROMOVERS International Event Registration

Andreas Brücker

2020 EUROMOVERS International Conference Lisbon, Portugal

Caution!

Registration via this application is only authorized for persons who are officially invited to attend this annual conference. Unauthorized registrations will not be processed. Moneys paid via this application will be returned, less any and all fees occurred and once banking details are available.

EARLY BIRD PRICE

€900

available until 24/02/2020
Spouse/Accompanying Person Fee: € 650

REGULAR PRICE

€1.000

valid from 24/02/2020
Spouse/Accompanying Person Fee: € 750

REGISTRATION

Due to the booking situation we have deactivated this online registration tool.

Please contact thomas.juchum@euromovers.com if you like to join our conference in Lisbon.
Thank you.

If the company is located in the EU and no EU VAT Number has been entered, 17% Luxembourg Tax is applicable! If the company is located outside of the EU, no VAT Number and no Tax is applicable!

Please choose your payment methode:

Credit card payment will be available again shortly.

Directly with your credit card.

Payment via bank transfer. An invoice will be processed which is due for immediate payment.

Important: You will receive a confirmation of your registration, once the invoice is paid.

CC fee: € 555,-

Total Amount: € 555,-

Your order was successfully delivered.

We sent you a copy of your invoice to your mail address.

Something went wrong!

We received an error from Paypal, so we had to cancel the ordering-process.
Please try again or contact our office via one of the options below.

Useful Links

Contact Us

13, Rue Edmond Reuter
L-5326 Contern, Luxembourg
Phone: +352-26-70-1656
Website: www.euromovers.com
Email: info@euromovers.com