[otrs-de] Validierung FreeTestFeld (an welche List schicken)

15 Jan 2007

      Hallo,

ich will ein FreeTextFeld gegen den Inhalt einer externen Datenbank
validieren.
Folgender Code funktioniert aber nicht:

# --
# CustomerMessageNew.dtl - provides HTML form for customer message
# Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/
# --
# $Id: CustomerTicketMessage.dtl,v 1.5 2006/10/12 10:16:00 martin Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (GPL). If you
# did not receive this file, see http://www.gnu.org/licenses/gpl.txt.
# --
<!-- start form -->
<script language="JavaScript" type="text/javascript">
<!--
function findserial($seriennr)
{ <?php
$db = mysql_connect("localhost", "user", "password");
$sqlab = "select seriennr, ipadress, hostname, betreutbis form plus700";
$sqlab .= " where seriennr like '$seriennr' ";
$res = mysql_db_query("otrsPlus700", $sqlab);
$num = mysql_num_rows($res);
echo "$num"
if ($num==0) return False;

for ($i=0; $i<$num; $i++)
{
$sn = mysql_result($res, $i, "seriennr");
echo "$sn"
document.compose.TicketFreeText1.value = $sn;
}
mysql_close($db);
return True;
?>
}

function submit_compose()
{
     if (document.compose.Subject.value == "") {
         alert('$JSText{"A message should have a subject!"}');
         document.compose.Subject.focus();
         return false;
     }
     else if (document.compose.Body.value == "") {
         alert('$JSText{"A message should have a body!"}');
         document.compose.Body.focus();
         return false;
     }
   else {
            if findserial(document.compose.TicketFreeText1.value)
              return true;
            else
              return false;
          }

}
//-->
</script>

<table border="0" width="100%" cellspacing="0" cellpadding="3" cols="1">
   <tr>
     <td class="mainhead">
       $Env{"Box0"}$Text{"new ticket"}$Env{"Box1"}
     </td>
   </tr>
   <tr>
     <td class="mainbody">

       <br>

       <table border="0" width="680" align="center" cellspacing="0"
cellpadding="4">
         <tr>
           <td colspan="2" class="contenthead">$Text{"Options"}</td>
         </tr>
         <tr>
           <td class="contentbody">

             <form action="$Env{"CGIHandle"}" method="post" name="compose"
enctype="multipart/form-data">
               <input type="hidden" name="Action" value="$Env{"Action"}">
               <input type="hidden" name="Subaction" value="StoreNew">
               <input type="hidden" name="FormID" value="$QData{"FormID"}">
               <table border="0">
                 <tr>
                   <td width="15%" class="contentkey">$Text{"To"}:</td>
                   <td width="85%" class="contentvalue">$Data{"ToStrg"}</td>
                 </tr>
                 <tr>
                   <td class="contentkey">$Text{"Subject"}:</td>
                   <td class="contentvalue"><input type="text" name="Subject"
value="$QData{"Subject"}" size="70"><font color="red"
size="-2">$Text{"$Data{"Subject invalid"}"}</font></td>
                 </tr>
                 <tr>
                   <td class="contentkey">$Text{"Text"}:</td>
                   <td class="contentvalue"><textarea name="Body" rows="15"
cols="$Config{"Ticket::Frontend::TextAreaNote"}"
wrap="$Env{"BrowserWrap"}">$QData{"Body"}</textarea><font color="red"
size="-2">$Text{"$Data{"Body invalid"}"}</font>
                   </td>
                 </tr>
                 <tr>
                   <td class="contentkey">$Text{"Attachment"}:</td>
                   <td class="contentvalue">
                     <table cellspacing="0" cellpadding="0" width="400">
<!-- dtl:block:Attachment -->
                       <tr>
                         <td>$QData{"Filename"}</td>
                         <td>$QData{"Filesize"}</td>
                         <td align="right"><input class="button"
type="submit" name="AttachmentDelete$QData{"FileID"}"
value="$Text{"Delete"}"></td>
                       </tr>
<!-- dtl:block:Attachment -->
                       <tr>
                         <td colspan="2"><input name="file_upload"
type="file" size="40" class="fixed"></td>
                         <td align="right"><input class="button"
type="submit" name="AttachmentUpload" value="$Text{"Attach"}"><a
name="attachment"></td>
                       </tr>
                     </table>
                   </td>
                 </tr>
<!-- dtl:block:Priority -->
                 <tr>
                   <td class="contentkey">$Text{"Priority"}:</td>
                   <td class="contentvalue"> $Data{"PriorityStrg"}</td>
                 </tr>
<!-- dtl:block:Priority -->
<!-- dtl:block:FreeText -->
                 <tr>
                   <td class="contentkey">$Data{"TicketFreeKeyField"}</td>
                   <td class="contentvalue">$Data{"TicketFreeTextField"}</td>
                 </tr>
<!-- dtl:block:FreeText -->
#       <tr>
#         <td class="contentkey">$Data{"TicketFreeKeyField1"}:</td>
#         <td class="contentvalue">$Data{"TicketFreeTextField1"}</td>
#       </tr>
#       <tr>
#         <td class="contentkey">$Data{"TicketFreeKeyField2"}:</td>
#         <td class="contentvalue">$Data{"TicketFreeTextField2"}</td>
#       </tr>
#       <tr>
#         <td class="contentkey">$Data{"TicketFreeKeyField3"}:</td>
#         <td class="contentvalue">$Data{"TicketFreeTextField3"}</td>
#       </tr>
#       <tr>
#         <td class="contentkey">$Data{"TicketFreeKeyField4"}:</td>
#         <td class="contentvalue">$Data{"TicketFreeTextField4"}</td>
#       </tr>
<!-- dtl:block:FreeTime -->
                 <tr>
                   <td
class="contentkey">$Text{"$QData{"TicketFreeTimeKey"}"}</td>
                   <td class="contentvalue">$Data{"TicketFreeTime"}</td>
                 </tr>
<!-- dtl:block:FreeTime -->
#       <tr>
#         <td
class="contentkey">$Text{"$Config{"TicketFreeTimeKey1"}"}:</td>
#         <td class="contentvalue">$Data{"TicketFreeTime1"}</td>
#       </tr>
#       <tr>
#         <td
class="contentkey">$Text{"$Config{"TicketFreeTimeKey2"}"}:</td>
#         <td class="contentvalue">$Data{"TicketFreeTime2"}</td>
#       </tr>
               </table>

             </td>
           </tr>
           <tr>
             <td class="contentfooter">
               <input class="button" accesskey="g" type="submit"
value="$Text{"submit"}" onclick="snplus700.php">
             </td>
           </tr>
         </table>

       </form>

       <br>

     </td>
   </tr>
</table>
<!-- end form -->

Wie muss ich den PHP-Code denn sonst einbinden oder hab ich einen Denkfehler

Danke

Dipl.-Ing.(FH) Uli Kohfink
Arbeitsbereich PC-Support
Zentrum für Datenverarbeitung
Universität Tübingen
Wächterstr. 76

D-72074 Tübingen

Telefon: +49 7071 29 70306
Fax: +49 7071 29 5912
Email: ulrich.kohfink@zdv.uni-tuebingen.de

[otrs-de] Validierung FreeTestFeld (an welche List schicken)

Ukohfink