Beiträge von Sven4972

$datum_array = explode(":",$zeile_1);
  $liste_data = explode(".",$datum_array[1]);
  
  $jahr = $datum_array[0];
  $monat = $datum_array[1];
  $tag = $datum_array[2];
  $stunde = $datum_array[3];
  $minute = $datum_array[4];
  $sekunde = $atum_array[5];
  echo $jahr;
  echo "<br>";
  echo $monat;
  echo "<br>";
  echo $tag;
  echo "<br>";
  echo $stunde;
  echo "<br>";
  echo $minute;
  echo "<br>";
  echo $sekunde;
  echo "<br>";

<?php
error_reporting(E_ALL ^ E_NOTICE);
$msg = 1;
include "mail-erg-verbindung.inc";
$imapi = imap_check($mbox);

$result = imap_fetch_overview($mbox,"1:{$imapi->Nmsgs}",0);

foreach ($result as $overview) 
{
    //  if(!stristr($overview->subject,'Ergebnisliste')) // Betreff darf den Text Spielergebnis nicht enthalten
    if($overview->subject != 'Ergebnisliste') // Alle was nicht genau Spielergebnis ist 
    {
         // Diese Nachricht wird gelöscht....
         echo "#{$overview->msgno} ({$overview->subject}) - From: {$overview->from} {$overview->subject}\n";
         imap_delete($mbox, $overview->msgno); // Löschen der Nachricht
         imap_expunge($mbox);
     }
}

$nmsg = $imapi->Nmsgs;
if ($nmsg == 0)
         {
        echo "Mailbox leer";
        exit;
         }
for ($msg = 1 ; $msg <= $nmsg; $msg++)
{
  $header = imap_fetchheader($mbox, $msg);
  if (preg_match('%boundary=(.*)%', $header, $boundary))
  {
    $boundary = $boundary[1];
    if(substr($boundary, 0, 1) == '"') $boundary = substr($boundary, 1, -2);
  }
  else
    $boundary = " ";
    
    $body = imap_body($mbox, $msg);

  $u = 0;
  $mailparts = explode("$boundary", $body);
  
  foreach ($mailparts as $content)
 {
    $u++;
    
    if ($u== 2)
    {
      $content = trim($content);
      $content = substr($content, 0, -2);
      if (preg_match('%filename=(.*)%', $content, $fname))
      {
        $fname = $fname[1];
        if (substr($fname, 0, 1) == '"') $fname = substr($fname, 1, -2);
      }
      if ($p = strpos($content, "\r\n\r\n"))
        $content = trim(substr($content, $p)); 
echo "Mail Nr:".$msg;
      auswerten ($fname, $content);
echo "<br><br>";      
    }
}

//imap_delete($mbox, $msg);

}
imap_expunge($mbox);
imap_close($mbox);
  
function auswerten($fname, $content)
{
  $content = explode("\n", $content);
  $zeile_0 = $content[0];
  echo "<br>";
  echo $zeile_0; 
  $zeile_1 = $content[1];
  echo "<br>";
  echo $zeile_1; 
  $zeile_2 = $content[2];
  echo "<br>";
  echo $zeile_2;
  $zeile_3 = $content[3];
  echo "<br>";
  echo $zeile_3;
  $zeile_4 = $content[4];
  echo "<br>";
  echo $zeile_4;
?>

<?php
//Mailbox  
$cfgMailserver = "{mail.++++.de:143/imap/notls}INBOX";  
$cfgMailuser = "++++";  
$cfgMailpassword = "++++";  
$cfgAttachDir = ".";  
  
  
//Mailbox öffnen  
$mbox = imap_open($cfgMailserver,$cfgMailuser,$cfgMailpassword);  
$gesamtemail = imap_num_msg($mbox);  
  
echo 'Insgesamt: '.$gesamtemail.'<hr>';  
  
//eMails einzeln abarbeiten  
for ($num = 1; $num <= $gesamtemail; $num++)  
{  
 $h = @imap_header($mbox,$num);  
  
 //Sender  
 $mailfrom = trim(strtolower($h->from[0]->mailbox."@".$h->from[0]->host));  
 $mailfromname = trim(($h->from[0]->personal));  
  
 echo 'von: '.$mailfrom.'<br>';  
  
 //Empfänger  
 $mailto = trim(strtolower($h->to[0]->mailbox."@".$h->to[0]->host));  
 $mailtoname = trim(($h->to[0]->personal));  
  
 echo 'an: '.$mailto.'<br>';  
  
 //Subject  
 $mailsubjectarray = imap_mime_header_decode($h->subject);  
 $mailsubject = trim($mailsubjectarray[0]->text);  
  
 echo 'Betreff: '.$mailsubject.'<br>';  
  
 //Antwort senden an  
 $mailreply = trim(strtolower($h->reply_to[0]->mailbox."@".$h->reply_to[0]->host));  
 $mailreplyname = trim(($h->reply_to[0]->personal));  
 if(trim($mailreply)){$mailfrom = $mailreply;}  
 if(trim($mailreplyname)){$mailfromname = $mailreplyname;}  
  
 //Sendezeitpunkt  
 $mailtime = trim($h->udate);  
  
 echo 'Zeit: '.$mailtime.'<br>';  
  
 //Format  
 $structure = imap_fetchstructure($mbox, $num);  
 //Bodyformat  
 if($structure->type == 1)  
 {  
  //Body Multipart, Attachments  
  $mailbody = imap_fetchbody($mbox,$num,'1',FT_INTERNAL);  
 }  
 else  
 {  
  //Body plain  
  $mailbody = imap_body($mbox,$num,FT_INTERNAL);  
 }  
 $mailbody = trim(quoted_printable_decode($mailbody));  
  
 //Attachements  
 $attach = "";  
 $att = "";  
 $struct = imap_fetchstructure($mbox,$num);  
 $contentParts = count($struct->parts);  
 if ($contentParts >= 2)  
 {  
  for ($i=2;$i<=$contentParts;$i++)  
  {  
   $att[$i-2] = imap_bodystruct($mbox,$num,$i);  
  }  
     for ($k=0;$k<sizeof($att);$k++)  
  {  
      if ($att[$k]->parameters[0]->value == "us-ascii" || $att[$k]->parameters[0]->value    == "US-ASCII")  
   {  
       if ($att[$k]->parameters[1]->value != "")  
    {  
     $attach[$k] = $att[$k]->parameters[1]->value;  
    }  
      }  
   elseif ($att[$k]->parameters[0]->value != "iso-8859-1" && $att[$k]->parameters[0]->value != "ISO-8859-1")  
   {  
       $attach[$k] = $att[$k]->parameters[0]->value;  
      }  
     }  
 }  
  
 if (sizeof($attach) > 0)  
 {  
  for ($j=0;$j<sizeof($attach);$j++)  
  {  
   if(trim($attach[$j]))  
   {  
    //Original Dateiname  
    $filename = trim($attach[$j]);  
  
    echo 'Anhang '.$j.': '.$filename.'<br>';  
  
    //Dateityp  
    $filetype = strtolower((eregi_replace("\.","",strrchr($filename,"."))));  
  
    echo 'Anhang-Typ: '.$filetype.'<br>';  
  
    //Wenn CSV-Datei vorhanden, Datei speichern  
    if($filetype == "csv")  
    {  
      //Attachment holen  
      $fileContent = imap_fetchbody($mbox,$num,$j+2);  
      $fileContent = imap_base64($fileContent);  
  
      //Attachment speichern  
      $filename_save = $filename;  
      $fp = fopen($cfgAttachDir."/".$filename_save ,"wb+");  
      fwrite ($fp,$fileContent);  
      fclose($fp);  
    }  
   }  
  }  
 }  
  
 //eMail löschen  
// imap_delete($mbox,$num);  
  
echo "<hr>";  
  
}  
imap_expunge ($mbox);  
imap_close ($mbox);  
?>

//    Alle Bildinfos laden
    $sql    = "SELECT id,name,link FROM mx108f40_videos WHERE 1";
    $result    = mysqli_query($db, $sql);

//    Init
    $laufende_nummer = 0;
    $anzahl_spalten = 4;
    
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Ohne_Titel_1</title>
<style type="text/css">
.auto-style1 {
    border-collapse: collapse;
    border: 1px solid #599CAB;
}
.auto-style2 {
    border: 1px solid #599CAB;
    text-align: center;
}
.auto-style3 {
    border-collapse: collapse;
    border: 1px solid #599CAB;
    text-align: center;
}
</style>
</head>
<body>
    
<?php        

//    Tabelle beginn
    echo "<table align='center' class='auto-style1' style='width: 100%'>";

//    Tabellenzeilen erstellen
    while($row = mysqli_fetch_assoc($result)){
        
        //    Neue Zeile?
            if ($laufende_nummer % $anzahl_spalten == 0){
                echo "<tr>";
            }
        
        //    Zelle mit Bild ausgeben
            echo "<td class='auto-style2'>";
            echo "<p></p>";
            echo "<img src=media/images/QwanKiDo_mini.jpg></a>";
            echo "<p></p>";
            echo "".$row['name']."";
            echo "<p></p>";
            echo "</td>";
        
        //    $laufende nummer erhöhen
            $laufende_nummer++;
        
        //    Zeile beenden?
            if ($laufende_nummer % $anzahl_spalten == 0){
                echo "</tr>";
            }
    }

//    Anzahl Zellen korrigieren (fehlende Zellen leer ergänzen)
    if($laufende_nummer % $anzahl_spalten > 0){
        //    Anzahl fehlernder Zellen ermitteln
            $anzahl_fehlende_zellen = $anzahl_spalten - ($laufende_nummer % $anzahl_spalten);
        
        //    Zellen ausgeben
            for($i = 0; $i < $anzahl_fehlende_zellen; $i++){
                echo "<td>&nbsp;</td>";
            }

        //    Zeile beenden        
            echo "</tr>";
    }

//    Tabelle schließen
    echo "</table>";