Folgende Fehler sind aufgetreten:

' . implode('
', $error['ticketerror']) . '

'; closeTableAl(); echo '
'; } OpenTable(); echo ""._TEXT1.""; echo "

"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($numkat > 0) { $sql = "SELECT * FROM " . $prefix . "_" . $ticketsystem_id . "ticketkategorien ORDER BY kat ASC"; $result = sql_query($sql); echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($GLOBALS['ticketon']) { include('includes/captcha/captcha_java.php'); echo "\n" . "\n"; } echo ""; echo ""; echo "

"._NEW_TICKET."
"._NAME.":
"._EMAIL.":
"._KATEGORIE.":
"._SUBJECT.":
"; #echo ""; if ($GLOBALS['wysiwyg'] && $GLOBALS['wysiwyg_ticket']){ // Vorgegebene Variablen in den Editor einbinden $value = isset($error['message']) ? mxEntityQuotes($error['message']): ''; $sw = new SPAW_Wysiwyg('message',$value, _DOC_LANGUAGE,$GLOBALS['wysiwyg_toolbar'], $GLOBALS['wysiwyg_btnset'],'100%','300'); $sw->show(); }else{ // Wenn Editor aus oder nicht vorhanden -normale- Textarea laden echo "" . (isset($error['message']) ? mxEntityQuotes($error['message']): '') . ""; } echo "
	$\""$
" . _CAPTCHAINSERT . "
"; echo " "; echo "

"; CloseTable(); include("footer.php"); } ############################################################################################### # Neues Ticket2 function ticketnew($tname,$email,$kategorie,$betreff,$message) { global $ticketsystem_id,$absendername,$ticketlink,$bemail,$fromemail,$tname,$email,$kategorie,$betreff,$message, $module_name, $prefix,$kats; if (empty($error['email']) || !preg_match('~^[0-9A-Za-z=_+\-/][0-9A-Za-z=_\'+\-/\.]+@[\w\-]+(\.[\w\-]+)*(\.[\w]{2,6})$~', $error['email'])) { $error['ticketerror'][] = _ERROR1; } if (empty($error['tname'])) { $error['ticketerror'][] = _ERROR2; } if ($kategorie == "Bitte Fachbereich selektieren") { $error['ticketerror'][] = "Bitte Fachbereich selektieren."; } if (empty($error['betreff'])) { $error['ticketerror'][] = _ERROR3; } if (empty($error['message'])) { $error['ticketerror'][] = _ERROR4; } // captcha pruefen if (isset($GLOBALS['ticketon']) && $GLOBALS['ticketon']) { if (empty($_POST['captcha'])) { $error['ticketerror'][] = _CAPTCHAWRONG; } else { require_once("includes/captcha/__captcha/PhraseFactory.php"); $storedCaptcha = PhraseFactory::get('', $GLOBALS['passphraselenght'], $_POST['captcha'], $GLOBALS['storagetype']); if ($_POST['captcha'] !== $storedCaptcha) { $error['ticketerror'][] = _CAPTCHAWRONG; } } } if (isset($error['ticketerror'])) { start($error); } else { include("header.php"); menue(); OpenTable(); $query = "select * from ${prefix}_" . $ticketsystem_id . "data"; $result = @sql_query($query); $var = @sql_fetch_array($result); $id = $var['ids']; $temp = $var['ids']+1; $query = "update ${prefix}_" . $ticketsystem_id . "data set ids=\"" . intval($temp) . "\""; sql_query($query); srand(time()); $accesscode = ""; $zeichen= "1234567890"; for ($i = 0; $i < 7; $i++) { $n = rand() % strlen($zeichen); $accesscode .= substr($zeichen, $n, 1); } $result = sql_query("SELECT * FROM ${prefix}_" . $ticketsystem_id . "ticketkategorien WHERE kat='$kategorie'"); $katmail = @sql_fetch_array($result); $query = "insert into ${prefix}_" . $ticketsystem_id . "tickets (id , time, tname, email, kategorie, password, betreff, message, isticket, closed) values (\"" . intval($id) . "\",\"" . intval(time())."\", \"" . mxAddSlashesForSQL($error['tname']) . "\",\"" . mxAddSlashesForSQL($error['email']) . "\",\"" . mxAddSlashesForSQL($kategorie) . "\",\"" . intval($accesscode) . "\",\"" . mxAddSlashesForSQL($error['betreff']) . "\",\"" . mxAddSlashesForSQL($error['message']) . "\",\"" . intval(1) . "\",\"" . intval(0) . "\")"; if (!sql_query($query)) { mxErrorScreen(""._ERROR5."
"); } else { $message1=""._MAIL1." ".$error['tname'].""._MAIL2.""._MAIL3."".$id.""._MAIL4."".$accesscode.""._MAIL5." ".$ticketlink."/modules.php?name=$module_name&op=show2&id=$id&code=$accesscode"._MAIL6." \n\n$message\n\n$absendername"; $message2=""._MAIL1.",\n\n".$error['tname']." "._MAIL7.""._MAIL8." ".$ticketlink."/modules.php?name=$module_name&op=admin_anzeigen&id=$id "._MAIL9."\n$message\n\n$absendername"; mxStripSlashes($message1); mxStripSlashes($message2); mxStripSlashes($error['betreff']); mxMail($error['email'],"RE:" . $error['betreff'] ,$message1,"" . $fromemail . "","text", "", $absendername); // Wenn zur Kateogrie keine Mail Addi angegeben wird, wird die Hauptmail Addi benutzt! if(!empty($kat['mail'])){ mxMail($katmail['mail'],"Anfrage " . $error['betreff'] ,$message2,"" . $fromemail . "","text", "", $absendername); }else{ mxMail($bemail,"Anfrage " . $error['betreff'] ,$message2,"" . $fromemail . "","text", "", $absendername); } echo ""._MESSAGE1.""._MAIL3." $id
"._MAIL4." $accesscode"._MESSAGE2." Link."; } } CloseTable(); include("footer.php"); } ############################################################################################### #Die Hilfe Funktion function help() { include("header.php"); menue(); OpenTable(); echo ""._HELP1."
"; echo ""._HELP2."
"; echo ""._HELP3."

"; echo ""._HELP4."
"; echo ""._HELP5."
"; CloseTable(); include("footer.php"); } ################################################################################################# # Ticket Anzeigen function show($error = array()) { global $module_name, $prefix,$bgcolor1, $bgcolor2; include("header.php"); menue(); if (isset($error['ticketerror'])) { openTableAl(); echo '

Folgende Fehler sind aufgetreten:

' . implode('
', $error['ticketerror']) . '

'; closeTableAl(); echo '
'; } OpenTable(); echo ""._MESSAGE3.""; echo "

\n"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"._TICKET."
"._MAIL3."
"._MAIL4."

"; echo "

\n"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"._MESSAGE4."
"._MAIL3."

"; CloseTable(); include("footer.php"); } ######################################################################################################### # Show function show2($id,$code) { global $ticketsystem_id,$support_name, $module_name, $prefix,$textcolor1,$textcolor2,$bgcolor1, $bgcolor2, $bgcolor3, $wysiwyg, $wysiwyg_btnset, $wysiwyg_toolbar,$userclose; $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" and password=\"$code\" order by time asc"; $number = sql_query($querystr); $number_tickets = sql_num_rows($number); $a=0; if (!$number_tickets) { $error['ticketerror'][] = _ERROR6; } if (isset($error['ticketerror'])) { show($error); } else { include("header.php"); menue(); OpenTable(); echo ""._MESSAGE5." $id ("._MESSAGE6.": ".($number_tickets - 1).")

"; $row = sql_fetch_array($number); $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" and password=\"$code\" order by time desc"; $number = sql_query($querystr); if (!$row['closed']) { echo "

\n "; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if (!empty($userclose)){ echo ""; } echo ""; echo "

"._MESSAGE6."
"._NAME.":	".$row['tname']."
"._SUBJECT.":
"; if ($GLOBALS['wysiwyg'] && $GLOBALS['wysiwyg_ticket']){ // Vorgegebene Variablen in den Editor einbinden $sw = new SPAW_Wysiwyg('message','',_DOC_LANGUAGE,$GLOBALS['wysiwyg_toolbar'], $GLOBALS['wysiwyg_btnset'],'100%','300'); $sw->show(); }else{ // Wenn Editor aus oder nicht vorhanden -normale- Textarea laden echo ""; } echo "
"._TICKETCLOSE." "; echo " Ja"; echo "

"; }else{ openTableAl(); echo '

Dieses Ticket wurde bereits geschlossen!

Sie können nicht mehr auf dieses Ticket antworten.

'; closeTableAl(); echo '
'; } while ($a < $number_tickets) { $row = sql_fetch_array($number); echo "

"; echo ""; echo ""; echo ""; echo ""; if ($row['kategorie']) { echo ""; } echo ""; echo ""; echo "

Ticket#".($number_tickets-$a)." (". uhrzeit($row['time']).")"; if ($row['tname'] == "$support_name"){ echo" - "._MESSAGE7.""; } echo"

"._MESSAGE." "._FROM.": ".$row['tname']."

"._SUBJECT.": ".$row['betreff']."

"._KATEGORIE.": ".$row['kategorie']."

"._MESSAGE.":

".mxPrepareToDisplay($row['message'])."

"; $a++; } } CloseTable(); include("footer.php"); } ####################################################################################### # User Antwort auf Ticket function antw_ticket($tname,$id,$code,$betreff,$message) { global $ticketsystem_id,$ticketlink, $bemail,$absendername,$fromemail,$kategorie, $module_name, $prefix,$textcolor1,$textcolor2,$bgcolor1, $bgcolor2, $bgcolor3; $fehler = false; $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" and password=\"$code\" order by time asc"; $number = sql_query($querystr); if (!sql_num_rows($number)) { mxErrorScreen(""._ERROR8.""); $fehler = true; } if (!$id) { mxErrorScreen(""._ERROR8.""); $fehler = true; } if (!$tname) { mxErrorScreen(""._ERROR2.""); $fehler = true; } if (!$betreff) { mxErrorScreen(""._ERROR3.""); $fehler = true; } if (!$message) { mxErrorScreen(""._ERROR4.""); $fehler = true; } if(empty($_POST['xclose'])) $_POST['xclose'] = 0; $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" and password=\"$code\" order by time asc"; $number = sql_query($querystr); $row = sql_fetch_array($number); $result = sql_query("SELECT * FROM ${prefix}_" . $ticketsystem_id . "ticketkategorien WHERE kat='".$row['kategorie']."'"); $katmail = @sql_fetch_array($result); $query = "insert into ${prefix}_" . $ticketsystem_id . "tickets (id , time, tname, email, kategorie, password, betreff, message, isticket, closed) values (\"" . intval($id) . "\",\"" . intval(time()) . "\", \"" . mxAddSlashesForSQL($tname) . "\",\"\",\"\",\"" . intval($row['password']) . "\",\"" . mxAddSlashesForSQL($betreff) . "\",\"" . mxAddSlashesForSQL($message) . "\",\"" . intval(0) . "\",\"" . intval($_POST['xclose']) . "\")"; if (!sql_query($query)) { mxErrorScreen(""._ERROR5.""); }else{ $query2 = "update ${prefix}_" . $ticketsystem_id . "tickets set closed=\"" . intval($_POST['xclose']) . "\" where id=\"" . intval($id) . "\""; sql_query($query2); $message2=""._MAIL1.",\n\n"._MAIL10." $tname (Ticket#$id) "._MAIL11." "._MAIL8." ".$ticketlink."/modules.php?name=$module_name&op=admin_anzeigen&id=$id "._MAIL9."\n$message\n\n$absendername"; mxStripSlashes($message2); // Wenn zur Kateogrie keine Mail Addi angegeben wird, wird die Hauptmail Addi benutzt! if(!empty($katmail['mail'])){ mxMail($katmail['mail'],""._MESSAGE6." $id ",$message2,"" . $fromemail . "","text", "", $absendername); }else{ mxMail($bemail,""._MESSAGE6." $id ",$message2,"" . $fromemail . "","text", "", $absendername); } mxRedirect("modules.php?name=$module_name&op=show2&id=$id&code=$code",""._MESSAGE8."",6); } } ############################################################ # Tickets Administrieren function admin($ticketsystem_id,$tage_timeout) { global $ticketsystem_id,$kats,$tage_timeout,$support_name,$alles_anzeigen, $module_name, $prefix,$textcolor1,$textcolor2,$bgcolor1, $bgcolor2, $bgcolor3; if (MX_IS_ADMIN) { $image_green = mxCreateImage("modules/$module_name/images/green.gif", $alt = "Green"); $image_red = mxCreateImage("modules/$module_name/images/red.gif", $alt = "Red"); $querystr = "select * from ${prefix}_" . $ticketsystem_id . "data"; $numberx = sql_query($querystr); $rowx = sql_fetch_array($numberx); if (@$fehler == false) { $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where isticket=\"1\" order by time desc"; $number = sql_query($querystr); $number_tickets = @sql_num_rows($number); $a=0; if (!$number_tickets) { mxErrorScreen(""._ERROR11.""); }else{ $lastvisit = $rowx['lastvisit']; } include("header.php"); menue(); OpenTable(); if ($alles_anzeigen == 'true') { echo "["._ADMIN2."$tage_timeout "._ADMIN2_1."]
"; }else{ echo "["._ADMIN3."]
"; } echo"

"; $tickets = array(); $times = array(); while ($a < $number_tickets) { $row = sql_fetch_array($number); $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"".$row['id']."\" order by time desc"; $numberx = sql_query($querystr); $rowx = sql_fetch_array($numberx); $row['ltime'] = $rowx['time']; $tickets[$row['ltime']] = $row; if (time() - $row['ltime'] < $tage_timeout * 24 * 60*60 || $alles_anzeigen == 'true') { array_push($times,$row['ltime']); } $a++; } arsort($times); $a = 0; foreach ($times as $a) { $row = $tickets[$a]; if ($row['closed']) { $fontcolor=$textcolor2; $openclose = ""._ADMIN4.""; }else{ $fontcolor=$textcolor1; $openclose = ""._ADMIN5.""; } echo "

"; echo ""._ADMIN7."#".($row['id'])." (". uhrzeit($row['time']).")
"; //Hier noch eine Konstante einbauen für Kategorie -> Notwending ? echo "Kategorie:".$row['kategorie']."
"; $lastticket = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"".$row['id']."\" order by time desc"; $lastticket1 = sql_query($lastticket); $rows = sql_fetch_array($lastticket1); if ($lastvisit < $row['ltime']) { echo ""._ADMIN8." ".uhrzeit($row['ltime']).""; if (($rows['tname']== "$support_name") || (!empty($rows['closed']))){ echo $image_green; }else{ echo $image_red; } }else{ echo ""._ADMIN8." ".uhrzeit($row['ltime'])."
"; if (($rows['tname']== "$support_name") || (!empty($rows['closed']))){ echo "".$image_green."
"; }else{ echo "".$image_red."
"; } } echo "

[ "._ADMIN9." | "; echo"$openclose | "; echo""._ADMIN10." ]

"; echo " "; echo $row['tname']; echo " - "; echo $row['betreff']."

"; } echo""._ADMIN16." ".$image_green."
"._ADMIN17." ".$image_red.""; echo"

"; } }else{ mxErrorScreen(""._ERROR10.""); } CloseTable(); include("footer.php"); } ############################################################## # Ticket oeffnen oder Schliessen function admin_open($id) { global $ticketsystem_id, $module_name, $prefix; if (MX_IS_ADMIN) { $fehler = false; if ($fehler == false) { $query = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" and isticket=\"1\""; $var = sql_fetch_array(sql_query($query)); if ($var['closed']) { $closed = '0'; }else{ $closed = '1'; } $query = "update ${prefix}_" . $ticketsystem_id . "tickets set closed=\"" . intval($closed) . "\" where id=\"" . intval($id) . "\""; if (sql_query($query)) { mxRedirect("modules.php?name=".$module_name."&op=admin", ""._ADMIN4."/"._ADMIN5." "._ADMIN6." # $id
"._ADMIN11."", 4); }else{ mxErrorScreen(""._ADMIN13.""); } } }else{ mxErrorScreen (""._ERROR10.""); } } ######################################################################## # Admin Ticket Anzeige ? function admin_anzeigen($id) { include("header.php"); menue(); OpenTable(); global $ticketsystem_id,$support_name, $module_name, $prefix,$textcolor1,$textcolor2,$bgcolor1, $bgcolor2, $bgcolor3, $wysiwyg, $wysiwyg_btnset, $wysiwyg_toolbar; if (MX_IS_ADMIN) { $fehler=false; if ($fehler == false) { $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" order by time asc"; $number = sql_query($querystr); $number_tickets = sql_num_rows($number); $a=0; if (!$number_tickets) { mxErrorScreen(""._ERROR11."
"); } else { echo ""._ADMIN14." $id ("._MESSAGE6." ".($number_tickets - 1).")

"; $row = sql_fetch_array($number); $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" order by time desc"; $number = sql_query($querystr); if (!$row['closed']) { echo "[ "._ADMIN12." ]
"; echo "

\n "; echo "

"; echo ""; echo ""; echo ""; echo ""; if ($row['kategorie']) { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"._MESSAGE6."
"._NAME."	".$support_name."
"._KATEGORIE.":	".$row['kategorie']."
"._SUBJECT."
"; #echo ""; if ($GLOBALS['wysiwyg'] && $GLOBALS['wysiwyg_ticket']){ // Vorgegebene Variablen in den Editor einbinden $sw = new SPAW_Wysiwyg('message','',_DOC_LANGUAGE,$wysiwyg_toolbar,$wysiwyg_btnset,'100%','300'); $sw->show(); }else{ // Wenn Editor aus oder nicht vorhanden -normale- Textarea laden echo ""; } echo "
Ticket schließen ?"; echo " Ja"; echo "

"; }else{ openTableAl(); echo '

Dieses Ticket wurde bereits geschlossen!

Sie können nicht mehr auf dieses Ticket antworten.

'; closeTableAl(); echo '
'; } while ($a < $number_tickets) { $row = sql_fetch_array($number); echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; if ($row['kategorie']) { echo ""; } echo ""; echo ""; echo "

Antwort#".($number_tickets-$a)." (". uhrzeit($row['time']).")"; if ($row['tname'] == "$support_name"){ echo" - "._MESSAGE7.""; } echo"

"._MESSAGE." "._FROM.": ".$row['tname']."

Betreff: ".$row['betreff']."

"._KATEGORIE.": ".$row['kategorie']."

"._MESSAGE.":

".mxPrepareToDisplay($row['message'])."

"; $a++; } } } }else{ mxErrorScreen(""._ERROR10.""); } CloseTable(); include("footer.php"); } ##################################################################### # Admin auf Ticket Antworten function admin_antw($tname,$id,$betreff,$message,$xclose) { global $ticketsystem_id,$ticketlink,$fromemail,$absendername,$support_name, $module_name, $prefix; if (MX_IS_ADMIN) { $fehler=false; if ($fehler == false) { if (!$support_name) { mxErrorScreen(""._ERROR2."
"); $fehler = true; } if (!$betreff) { mxErrorScreen(""._ERROR3."
"); $fehler = true; } if (!$message) { mxErrorScreen(""._ERROR4."
"); $fehler = true; } if(empty($_POST['xclose'])) $_POST['xclose'] = 0; $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" order by time asc"; $number = sql_query($querystr); $row = sql_fetch_array($number); $query = "insert into ${prefix}_" . $ticketsystem_id . "tickets (id, time, tname, email, kategorie, password, betreff, message, isticket, closed) values (\"" . intval($id) . "\",\"" . intval(time()) . "\", \"" . mxAddSlashesForSQL($support_name) . "\",\"\",\"\",\"" . intval($row['password']) . "\",\"" . mxAddSlashesForSQL($betreff) . "\",\"" . mxAddSlashesForSQL($message) . "\",\"0\",\"" . intval($xclose) . "\")"; if (!sql_query($query)) { mxErrorScreen(""); }else{ $query2 = "update ${prefix}_" . $ticketsystem_id . "tickets set closed=\"" . intval($_POST['xclose']) . "\" where id=\"" . intval($id) . "\""; sql_query($query2); $message1=""._MAIL1.",\n\n"._MAIL12."\n\n$message\n\n"._MAIL13."\n".$ticketlink."/modules.php?name=$module_name&op=show2&id=$id&code=$row[password]\n"._MAIL14."\n\n"._MAIL3." ".$id."\n"._MAIL4." ".$row['password']."\n\n"._MAIL15." ".$ticketlink."/modules.php?name=$module_name. \n\n$absendername"; mxStripSlashes($message1); mxStripSlashes($betreff); mxMail($row['email'],"$betreff (Ticket#$id)",$message1,"" . $fromemail . "","text", "", $absendername); mxRedirect("modules.php?name=$module_name&op=admin_anzeigen&id=".$id."",""._MESSAGE8."",4); } } }else{ mxErrorScreen(""._ERROR10.""); } } ######################################################### # Neuen Accescode zuschicken function pw($id) { global $ticketsystem_id,$ticketlink,$absendername,$fromemail, $module_name, $prefix; $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\" order by time asc"; $number = sql_query($querystr); $row = sql_fetch_array($number); if(($row['id'] == $id) && (is_numeric($id))){ $message1=""._MAIL1." ".$row['tname'].",\n\n"._MAIL16."\n\n"._MAIL3." ".$id."\n"._MAIL4." ".$row['password']."\n\n"._MAIL5." ".$ticketlink."/modules.php?name=$module_name. \n\n$absendername"; mxStripSlashes($message1); mxMail($row['email'],"RE:(Ticket#$id) "._MAIL4."",$message1,"" . $fromemail . "","text", "", $absendername); mxRedirect("modules.php?name=".$module_name."&op=show",""._MAIL17."",5); }else{ $error['ticketerror'][] = "Sie haben keinen gültigen Ticket ID angegeben."; } if (isset($error['ticketerror'])) { show($error); } } ################################################################################## # Ticket Loeschen function delete($id) { global $ticketsystem_id,$support_name, $module_name,$absendername,$ticketlink,$fromemail, $prefix; if(MX_IS_ADMIN){ $fehler = false; $querystr = "select * from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\""; $number = sql_query($querystr); $rowm = sql_fetch_array($number); $message1=""._MAIL1." ".$rowm['tname'].",\n\n"._MAIL18." $support_name "._MAIL19." \n"._MAIL20." ".$ticketlink."/modules.php?name=$module_name. \n\n$absendername"; mxStripSlashes($message1); mxMail($rowm['email'],""._MAIL21."",$message1,"" . $fromemail . "","text", "", $absendername); if ($fehler == false) { $query = "delete from ${prefix}_" . $ticketsystem_id . "tickets where id=\"$id\""; sql_query($query); mxRedirect("modules.php?name=".$module_name."&op=admin","Lösche TicketID # " . $id ."
"._ADMIN11."",4); }else{ mxErrorScreen(""._ADMIN13.""); } } } ############################################################################# # Admin Config function config(){ global $module_name,$prefix,$ticketsystem_id, $userclose; if (MX_IS_ADMIN){ include("header.php"); $queryconfig = "select * from ${prefix}_" . $ticketsystem_id . "ticketconfig"; $info = sql_query($queryconfig); $infox = sql_fetch_array($info); menue(); OpenTable(); $ticketsystem_id = (empty($ticketsystem_id)) ? 1 : intval($ticketsystem_id); $userclose = (empty($userclose)) ? 0 : intval($userclose); printOverlibDiv(); $kc_overlib = new Overlib(); $kc_overlib->ol_delay = 200; $kc_overlib->ol_hauto = "True"; $kc_overlib->ol_vauto = "True"; $kc_overlib->ol_width = "250"; $myover=$kc_overlib->vover(pmValueToText("Wird gebraucht, wenn bei einer Kategorie keine extra Mail Adresse angegeben wurde."),pmValueToText("Antwort")); $myover2=$kc_overlib->vover(pmValueToText("Diese eMail Adresse wird dem Ticketempfänger als Absender angezeigt."),pmValueToText("Antwort")); $myover3=$kc_overlib->vover(pmValueToText("Der Name, der dem Empfänger bei erhalt des Tickets angezeigt wird."),pmValueToText("Antwort")); $myover4=$kc_overlib->vover(pmValueToText("Der Name, der dem Empfänger als Absender angezeigt wird."),pmValueToText("Antwort")); $myover5=$kc_overlib->vover(pmValueToText("Wie lange sollen die Nachrichten in der Übersicht angezeigt werden ?"),pmValueToText("Antwort")); $myover6=$kc_overlib->vover(pmValueToText("Die Ticket System ID"),pmValueToText("Antwort")); $myover7=$kc_overlib->vover(pmValueToText("Duerfen User Ihre eigenen Tickets selber schließen ?"),pmValueToText("Antwort")); echo""._CONFIG1."
"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo""; echo"

"; echo""._CONFIG2.":"; echo"	"; echo"	?"; echo"	"._CONFIG2_1."
"; echo""._CONFIG3.":"; echo"	"; echo"	?"; echo"	"._CONFIG3_1."
"; echo""._CONFIG4.":"; echo"	"; echo"	?"; echo"
"; echo""._CONFIG5.":"; echo"	"; echo"	?"; echo"	"._CONFIG5_1."
"; echo"Dürfen Benutzer ihre Tickets schließen?"; echo"	"; if (empty($userclose)) echo""; else echo""; echo"	?"; echo"
"; echo""._CONFIG7.":"; echo"	"; echo" "._CONFIG7_1."	?"; echo"
"; echo"Ticket System ID:"; echo"	"; echo"	?"; echo"
"; echo""; echo""; echo"	"; echo""; echo"

"; CloseTable(); }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } include("footer.php"); } ################################################################################ //Config speichern function save_config($bemail1,$frommail1,$support_name1,$absendername1,$ticketlink1,$tage_timeout1,$xticketsystem_id,$ticketsystem_id1) { if (MX_IS_ADMIN){ global $module_name, $prefix, $dbi,$ticketsystem_id; $query = "UPDATE ".$prefix."_".$ticketsystem_id."ticketconfig set bemail=\"" . mxAddSlashesForSQL($bemail1) . "\", frommail=\"" . mxAddSlashesForSQL($frommail1) . "\", support_name=\"" . mxAddSlashesForSQL($support_name1) . "\", absendername=\"" . mxAddSlashesForSQL($absendername1) . "\", ticketlink=\"" . mxAddSlashesForSQL($ticketlink1) . "\", tage_timeout=\"" . intval($tage_timeout1) . "\""; sql_query($query); //config.php speichern $_POST['xticketsystem_id'] = (empty($_POST['xticketsystem_id'])) ? 1 : intval($_POST['xticketsystem_id']); $_POST['xuserclose'] = (empty($_POST['xuserclose'])) ? 0 : intval($_POST['xuserclose']); $xuserclose = $_POST['xuserclose']; #extract($_POST); $line = "/*------------------------------------*/\n"; $confi_inc = ""; /* Bei Readonly versuchen 666 zu setzen*/ #if (!is_writable("modules/".$module_name."/config.inc.php")) { mxChangeFilePerms("modules/".$module_name."/config.inc.php", 0666); #} /* Config speichern*/ $file = fopen("modules/".$module_name."/config.inc.php", "w"); $ok =@fwrite($file, $confi_inc); @fclose($file); /*Versuche aus Sicherheitsgründen 644 zu setzen*/ #if (is_writable("modules/".$module_name."/config.inc.php")) { mxChangeFilePerms("modules/".$module_name."/config.inc.php", 0644); #} if ($ok) { mxRedirect("modules.php?name=".$module_name."&op=config", "Daten wurden gespeichert", 4); return; }else{ mxErrorScreen("Konfiguration konnte nicht gespeichert werden!"); } }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } } ################################################################################ //Kategorien function kategorien(){ global $module_name, $prefix, $dbi,$ticketsystem_id; include("header.php"); menue(); if (MX_IS_ADMIN){ OpenTable(); echo"Ticket - Kategorien
"; echo ""; echo ""; $result = sql_query("SELECT * from ".$GLOBALS['prefix']."_" . $ticketsystem_id . "ticketkategorien ORDER BY kat ASC"); while(list($did, $kat, $mail) = sql_fetch_row($result)) { echo ""; } echo "

Folgende Kategorien existieren	eMail	Aktion
".$kat."	".mxPrepareToDisplay($mail)."	Ändern \| Löschen

"; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "

Neue Kategorie Speichern
Name:
eMail:

"; CloseTable(); }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } include("footer.php"); } ################################################################################ //Kategorien speichern function save_kategorien($kategorie, $mail){ global $module_name, $prefix, $dbi,$ticketsystem_id; if (MX_IS_ADMIN){ if (empty($kategorie)) $error .= mxErrorScreen("Keine Kategorie angegeben"); if (empty($error)){ sql_query("INSERT INTO ".$GLOBALS['prefix']."_" . $ticketsystem_id . "ticketkategorien VALUES (NULL, \"".mxAddSlashesForSQL($kategorie)."\", \"".mxAddSlashesForSQL($mail)."\")"); mxRedirect("modules.php?name=".$module_name."&op=kategorien", "Daten wurden gespeichert", 4); } }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } } ################################################################################ //Kategorien löschen function del_kategorien($did){ global $module_name, $prefix, $dbi,$ticketsystem_id; if (MX_IS_ADMIN){ sql_query("DELETE from ".$GLOBALS['prefix']."_" . $ticketsystem_id . "ticketkategorien WHERE did=\"$did\""); mxRedirect("modules.php?name=".$module_name."&op=kategorien", "Daten wurden gelöscht", 4); }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } } ################################################################################ //Kategorien editieren function edit_kategorien($did){ global $module_name, $prefix, $dbi,$ticketsystem_id; include("header.php"); menue(); if (MX_IS_ADMIN){ OpenTable(); $result = sql_query("SELECT * from ".$GLOBALS['prefix']."_" . $ticketsystem_id . "ticketkategorien WHERE did=\"$did\""); list($did, $kat, $mail) = sql_fetch_row($result); echo ""; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo "

Ändern
Name:
eMail:

"; CloseTable(); }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } include("footer.php"); } ################################################################################ //Editierte Kategorie speichern function save_edit_kategorien($did, $kategorie, $mail){ if (MX_IS_ADMIN){ global $module_name, $prefix, $dbi,$ticketsystem_id; sql_query("UPDATE ".$GLOBALS['prefix']."_" . $ticketsystem_id . "ticketkategorien set kat=\"" . mxAddSlashesForSQL($kategorie) . "\", mail=\"" . mxAddSlashesForSQL($mail) . "\" WHERE did=\"". intval($did) . "\""); mxRedirect("modules.php?name=".$module_name."&op=kategorien", "Daten wurden geändert", 4); }else{ mxErrorScreen("Sie sind nicht als Admin angemeldet"); } } ################################################################################# $op = (isset($_REQUEST['op'])) ? $_REQUEST['op'] : ""; switch($op) { case "admin": admin($ticketsystem_id,$tage_timeout); break; case "admin_open": admin_open($id); break; case "help": help(); break; case "admin_anzeigen": admin_anzeigen($id); break; case "admin_antw": admin_antw($tname,$id,$betreff,$message,$fromemail); break; case "pw": pw($id); break; case "delete": delete($id); break; case "show": show(); break; case "show2": show2($id,$code); break; case "ticketnew": ticketnew($tname,$email,$kategorie,$betreff,$message); break; case "antw_ticket": antw_ticket($tname,$id,$code,$betreff,$message); break; case "install": include("modules/$module_name/install.php"); break; case "config"; config(); break; case "save_config"; save_config($bemail1,$frommail1,$support_name1,$absendername1,$ticketlink1,$tage_timeout1,$xticketsystem_id,$ticketsystem_id1); break; case "kategorien"; kategorien(); break; case "save_kategorien"; save_kategorien($kategorie, $mail); break; case "del_kategorien"; del_kategorien($did); break; case "edit_kategorien"; edit_kategorien($did); break; case "save_edit_kategorien"; save_edit_kategorien($did, $kategorie, $mail); break; default: start(); break; } ?>