";
$link = mysql_connect("localhost", "matsux1", "24xdqe");
mysql_select_db("esddbdb",$link);
/////////////////////////////
// Sending Emails
////////////////////////////
function sendemail($to,$sp_email,$sp_name,$subject,$message,$lang) {
if($lang != "")
include 'language/' . $lang . '.lang';
else
include 'language/english.lang';
$headers = "From: " . $l_calendar_title . "<" . $l_email . ">\n";
$headers .= "X-Sender: " . $l_calendar_title . "<" . $l_email . ">\n";
$headers .= "X-Mailer: PHP\n"; //mailer
$headers .= "X-Priority: 3\n"; //1 UrgentMessage, 3 Normal
$headers .= "Return-Path: " . $l_calendar_title . "<" . $l_email . ">\n";
$headers .= "CC: CC <" . $l_email . ">," . $sp_email . "," . $l_email_bcc . "\n"; //;
//$headers .= "BCC: " . $l_email_bcc;
@mail($to,$subject,$message,$headers);
}
/////////////////////////////
// Redirecting
////////////////////////////
function goto($adr) {
echo "";
}
/////////////////////////////
// Sending Reminder
////////////////////////////
$d = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$result = mysql_query("SELECT * FROM scanner_events WHERE date = '" . strftime ("%Y-%m-%d", $d) . "'");
if(mysql_numrows($result) > 0) {
$row = mysql_fetch_array($result);
if(mysql_numrows(mysql_query("SELECT * FROM scanner_erinnerung WHERE date = '" . strftime ("%Y-%m-%d", $d) . "' AND id='" . $row['id'] . "'")) == 0) {
$result2 = mysql_query("SELECT DISTINCT * FROM scanner_event2anm WHERE ev_id = '" . $row['id'] . "'");
if($row['erin1'] != "" && $row['erin2'] != "") {
while($row2 = mysql_fetch_array($result2)) {
sendemail($n_email,$sp_email,$row2['sponsor'],$l_email_rem_title,stripslashes($row['erin1']) . "
$l_email_ww
$l_email_date: " . date("d.m. Y", strtotime($row['date'])) . "
$l_email_time: " . $row2['time'] . "
$l_email_place: " . $row['ort'] . "
$l_email_data:
$l_email_name: " . $row2['name'] . "
$l_email_email: " . $row2['n_email'] . "
$l_email_tel: " . $row2['tel'] . "
$l_email_sponsor: " . $row2['sponsor'] . "\n\n" . stripslashes($row['erin2']),$lang);
}
} else {
while($row2 = mysql_fetch_array($result2)) {
sendemail($row2['n_email'],$row2['sp_email'],$row2['sponsor'],"$l_email_rem_title","==========================
$l_email_rem_title
==========================
$l_email_ww
$l_email_date: " . date("d.m Y", strtotime($row['date'])) . "
$l_email_time: " . $row2['time'] . "
$l_email_place: " . $row['ort'] . "
$l_email_data:
$l_email_name: " . $row2['name'] . "
$l_email_email: " . $row2['n_email'] . "
$l_email_tel: " . $row2['tel'] . "
$l_email_sponsor: " . $row2['sponsor'] . "\n",$lang);
}
}
mysql_query("INSERT scanner_erinnerung VALUES('" . $row['date'] . "','" . $row['id'] . "')");
}
}
/////////////////////////////
// Show Registration form
////////////////////////////
if($anm == "true") {
$row = mysql_fetch_array(mysql_query("SELECT * FROM scanner_events WHERE id='$id'"));
echo "
|
|
";
/////////////////////////////
// Fill Slots
////////////////////////////
} elseif($fill == "true") {
foreach($checkit as $check) {
if(mysql_numrows(mysql_query("SELECT * FROM scanner_free WHERE ev_id='$id' AND time='$check'")) > 0)
mysql_query("UPDATE scanner_free SET free='0' WHERE ev_id='$id' AND time='$check'");
else
mysql_query("INSERT scanner_free VALUES('$id','0','$check')");
}
//header("location: index.php?id=$id&superuser=true&lang=$lang");
goto("index.php?id=$id&superuser=true&lang=$lang");
/////////////////////////////
// Update and Insert new registration
////////////////////////////
} elseif($event_anm == "true") {
if($name != "" && $sponsor != "") {
$query2 = "SELECT * FROM scanner_free WHERE ev_id='$id' AND time='$time'";
$result = mysql_query($query2);
$row = mysql_fetch_array($result);
echo "
";
$stillfree = true;
if(mysql_numrows($result) > 0) {
if($row['free'] <= 0)
{
$stillfree = false;
} else {
$free = $row['free'] - 1;
$query = "INSERT scanner_event2anm VALUES('','$id','$time','$name','$n_email','$sponsor','$sp_email','$tel','$ges')";
$query2 = "UPDATE scanner_free SET free='$free' WHERE ev_id='$id' AND time='$time'";
}
} else {
$row1 = mysql_fetch_array(mysql_query("SELECT maxno FROM scanner_events WHERE id='$id'"));
$query = "INSERT scanner_event2anm VALUES('','$id','$time','$name','$n_email','$sponsor','$sp_email','$tel','$ges')";
$m = $row1['maxno']-1;
$query2 = "INSERT scanner_free VALUES('$id','$m','$time')";
}
if($stillfree == true) {
if(mysql_query($query)) {
if(isset($n_email) || isset($sp_email)) {
$row = mysql_fetch_array(mysql_query("SELECT date,ort,anm1,anm2,erin1,erin2 FROM scanner_events WHERE id='$id'"));
if($row['anm1'] != "" && $row['anm2'] != "") {
sendemail($n_email,$sp_email,$row2['sponsor'],"$l_email_conf",stripslashes($row['anm1']) . "
$l_email_ww
$l_email_date: " . date("d.m.Y", strtotime($row['date'])) . "
$l_email_time: " . $time . "
$l_email_place: " . $row['ort'] . "
$l_email_data:
$l_email_name: " . $name . "
$l_email_email: " . $n_email . "
$l_email_tel: " . $tel . "
$l_email_sponsor: " . $sponsor . "\n\n" . stripslashes($row['anm2']),$lang);
} else {
sendemail($n_email,$sp_email,$row2['sponsor'],"$l_email_conf","=============
$l_email_conf
=============
$l_email_ww
$l_email_date: " . date("d.m.Y", strtotime($row['date'])) . "
$l_email_time: " . $time . "
$l_email_place: " . $row['ort'] . "
$l_email_data:
$l_email_name: " . $name . "
$l_email_email: " . $n_email . "
$l_email_tel: " . $tel . "
$l_email_sponsor: " . $sponsor . "\n",$lang);
}
}
mysql_query($query2);
echo "$l_sys_succ_reg.";
echo "
$l_sys_back_over.";
} else {
echo "$l_sys_err_reg.";
echo "
$l_sys_back";
}
} else {
echo "$l_sys_no_slot.";
echo "
$l_sys_back_over";
}
} else {
echo "$l_sys_err_fill.
$l_sys_back";
}
/////////////////////////////
// Delete registration
////////////////////////////
} elseif($task == "delentry") {
$query1 = "DELETE FROM scanner_event2anm WHERE id='$uid'";
$query2 = "UPDATE scanner_free SET free=free+1 WHERE ev_id='$ev_id' AND time='$time'";
if(mysql_query($query1)) {
if(mysql_query($query2)) {
//header("location: index.php?id=$ev_id&superuser=true&admin=true");
goto("index.php?id=$ev_id&superuser=true&admin=true&lang=$lang");
} else {
mail("webmaster@123punkt.com","Meeting Registration Error","Nicht ausgetragen im free Table:\nev_id: $ev_id\ntime: $time","FROM: Scanner Kalender<>");
//header("location: index.php?id=$ev_id&superuser=true&admin=true");
goto("index.php?id=$ev_id&superuser=true&admin=true&lang=$lang");
}
} else {
echo "$l_sys_err_del.";
}
/////////////////////////////
// New Event form
////////////////////////////
} elseif($neu == "true") {
if($edit == "true" || $double == "true") {
$row3 = mysql_fetch_array(mysql_query("SELECT * FROM scanner_events WHERE id='$id'"));
$date = explode("-",$row['date']);
}
echo "
|
|
";
/////////////////////////////
// Create new event
////////////////////////////
} elseif($neu_submit == "true") {
$date = $date_year . "-" . $date_month . "-" . $date_day;
if(isset($editevent)) {
if(isset($del)) {
$query = mysql_query("DELETE FROM scanner_events WHERE id='$id'");
$query2 = mysql_query("DELETE FROM scanner_event2anm WHERE ev_id='$id'");
$query3 = mysql_query("DELETE FROM scanner_free WHERE ev_id='$id'");
if($query && $query2) {
echo "$l_sys_succ_del.
$l_sys_back_over.";
} else
echo "$l_sys_err_del2.
$l_sys_back";
} else {
if($start < $end) {
$query = mysql_query("UPDATE scanner_events SET date='$date', ort='$ort', start='$start', end='$end', anm1='" . addslashes($anm1) . "', anm2='" . addslashes($anm2) . "', erin1='" . addslashes($erin1) . "', erin2='" . addslashes($erin2) . "', maxno='$maxno', evperh='$evperh' WHERE id='$id'");
if($query) {
echo "$l_sys_succ_edit.
$l_sys_back_over
$l_sys_link_copy:
http://www.123punkt.com/scanner_international/index.php?id=$id";
} else
echo "$l_sys_err_edit.
$l_sys_back";
} else
echo "$l_sys_err_edit.
$l_sys_err_startend.
$l_sys_back";
}
} else {
if($start < $end) {
$query = "INSERT scanner_events VALUES('','$date','$ort','$start','$end','" . addslashes($anm1) . "','" . addslashes($anm2) . "','" . addslashes($erin1) . "','" . addslashes($erin2) . "','$maxno','$evperh')";
if(mysql_query($query)) {
$row = mysql_fetch_array(mysql_query("SELECT * FROM scanner_events WHERE date='$date'"));
echo "$l_sys_succ_saved .
$l_sys_back_over
$l_sys_link_copy:
http://www.123punkt.com/scannerinternational/index.php?id=" . $row['id'] . "&lang=$lang";
} else
echo "$l_sys_err_saved." . mysql_errno() . "
$l_sys_back";
} else
echo "$l_sys_err_saved.
$l_sys_err_startend.
$l_sys_back";
}
/////////////////////////////
// Check login and display login form
////////////////////////////
} elseif($login == "true") {
if($superuser == "true") {
if($task == "neu" && $task2 == "edit") {
if($admin=="true")
//header("location: index.php?neu=true&edit=true&id=$id&superuser=true&admin=true&lang=$lang");
goto("index.php?neu=true&edit=true&id=$id&superuser=true&admin=true&lang=$lang");
else
//header("location: index.php?neu=true&edit=true&id=$id&superuser=true&lang=$lang");
goto("index.php?neu=true&edit=true&id=$id&superuser=true&lang=$lang");
} elseif($task == "neu" && $task2 == "double") {
if($admin == "true")
//header("location: index.php?neu=true&double=true&id=$id&superuser=true&admin=true&lang=$lang");
goto("index.php?neu=true&double=true&id=$id&superuser=true&admin=true&lang=$lang");
else
//header("location: index.php?neu=true&double=true&id=$id&superuser=true&lang=$lang");
goto("index.php?neu=true&double=true&id=$id&superuser=true&lang=$lang");
} elseif($task == "neu") {
if($admin=="true")
//header("location: index.php?neu=true&id=$id&superuser=true&admin=true&lang=$lang");
goto("index.php?neu=true&id=$id&superuser=true&admin=true&lang=$lang");
else
//header("location: index.php?neu=true&id=$id&superuser=true&lang=$lang");
goto("index.php?neu=true&id=$id&superuser=true&lang=$lang");
} elseif($task == "superuser") {
//header("location: index.php?id=$id&superuser=true&lang=$lang");
goto("index.php?id=$id&superuser=true&lang=$lang");
} else {
if($admin=="true")
//header("location: index.php?show_anm=true&id=$id&superuser=true&admin=true&lang=$lang");
goto("index.php?show_anm=true&id=$id&superuser=true&admin=true&lang=$lang");
else
//header("location: index.php?show_anm=true&id=$id&superuser=true&lang=$lang");
goto("index.php?show_anm=true&id=$id&superuser=true&lang=$lang");
}
} else {
echo "
|
|
";
}
/////////////////////////////
// Check login
////////////////////////////
} elseif($login_check == "true") {
//echo "SELECT * FROM scanner_admin WHERE user = '$user' AND pass = '$pass'";
$result1 = mysql_query("SELECT * FROM scanner_admin WHERE user = '$user' AND pass = '$pass'");
$result = mysql_query("SELECT * FROM ltw_users_at WHERE username = '$user' AND password = '" . crypt($pass, "a3f1h2li9") . "'");
if($task == "neu") {
if(mysql_numrows($result1) > 0) {
if($task2 == "edit")
//header("location: index.php?neu=true&edit=true&id=$id&admin=true&lang=$lang");
goto("index.php?neu=true&edit=true&id=$id&admin=true&lang=$lang");
elseif($task2 == "double")
//header("location: index.php?neu=true&double=true&id=$id&admin=true&lang=$lang");
goto("index.php?neu=true&double=true&id=$id&admin=true&lang=$lang");
else
//header("location: index.php?neu=true&id=$id&admin=true&lang=$lang");
goto("index.php?neu=true&id=$id&admin=true&lang=$lang");
} else
echo "$l_login_err.
$l_sys_back";
} elseif(mysql_numrows($result1) > 0) {
if($task == "superuser") {
//header("location: index.php?id=$id&superuser=true&admin=true&lang=$lang");
goto("index.php?id=$id&superuser=true&admin=true&lang=$lang");
} else
//header("location: index.php?show_anm=true&id=$id&admin=true&lang=$lang");
goto("index.php?show_anm=true&id=$id&admin=true&lang=$lang");
} elseif(mysql_numrows($result) > 0) {
if($task == "superuser") {
//header("location: index.php?id=$id&superuser=true&lang=$lang");
goto("index.php?id=$id&superuser=true&lang=$lang");
} else
//header("location: index.php?show_anm=true&id=$id&lang=$lang");
goto("index.php?show_anm=true&id=$id&lang=$lang");
} else
echo "$l_login_err.
$l_sys_back";
/////////////////////////////
// Display event
////////////////////////////
} elseif(isset($id)) {
$query = "SELECT * FROM scanner_events WHERE id='$id'";
$result=mysql_query($query);
$row = mysql_fetch_array($result);
$query2 = "SELECT count(*) AS anm FROM scanner_event2anm WHERE ev_id='$id'";
$result2=mysql_query($query2);
$row2 = mysql_fetch_array($result2);
if(mysql_numrows($result) > 0) {
if($superuser == "true")
echo "";
echo " | ";
if(isset($id) && $superuser=="true")
echo "
$l_sys_logout
";
echo "
- $l_disp_new_ev
";
if(isset($id)) {
echo "- $l_disp_copy
";
echo "- $l_disp_edit
";
echo "- $l_disp_list";
}
echo " |
";
} else {
echo " | $l_sys_err_no_event.";
echo "";
echo " |
";
}
} else {
echo " | $l_sys_err_no_selected. ";
echo "";
echo " |
";
}
?>