header("Location: https://www.euromovers.com/"); session_start(); include("database.php"); include("functions.php"); // EVENT REGISTRIERUNG NICHT MEHR MÖGLICH (ausgebucht) $ausgebucht = false; $event = $_GET['event']; $todo = $_GET['todo']; if ($todo=="countryList") { mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $db); $sql = "SELECT * from countries ORDER BY name"; $result = mysql_query($sql) or die("A fatal MySQL error occured.\n
Please contact thomas.juchum@euromovers.com if you like to join our conference in Lisbon.
Thank you.
Credit card payment will be available again shortly.
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.
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)
{
}
?>