'.$beschwerde.'
Protokoll der beiden:
';
$mail .= '';
while($a = mysql_fetch_array($result)){
$mail .= ''.$a['time_stamp'].' '.$a['from_chatter'].' '.$a['line'].'
';
}
$mail .= ' |
';
$paten_online=0;
$sql = "select c.nick, c.Raum from chat c inner join paten p on p.Nick = c.Nick";
$result = mysql_query($sql,$db_handle);
while($a = mysql_fetch_assoc($result)){
$paten_online = 1;
$sql = "insert into chat_mail (time, Nick, Sender, Subject, Body, unread) values
(now(),'".$a['nick']."', 'Pausenaufsicht', 'Patenruf von ".$_SESSION['nick']." über ".$chatter."',
'".$mail."', '0')";
mysql_query($sql, $db_handle);
if($nick == 'Supermann'){
echo mysql_error();
}
schreib_zeile(' neuer Patenruf, bitte checke deine Chatmail', $a['Raum'], 'Pausenaufsicht', $a['nick'], '', '', 1);
}
$sql = "SELECT d.Email FROM chat_data d, paten p WHERE p.nick = d.nick";
$result = mysql_query($sql,$db_handle);
include 'phpmailer/class.phpmailer.php';
$mailc = new PHPMailer();
$mailc->From = "team@schulhofchat.de";
$mailc->FromName = "Schulhofchat-Server - Patenruf";
$mailc->Host = "schulhofchat.de";
$mailc->mailer = 'mail';
$mailc->IsMail();
$mailc->Hostname = 'foreach.de';
$mailc->Subject = 'Patennotruf von '.$_SESSION['nick'] .' über '.$chatter;
$mailc->Body = $mail;
$mailc->AltBody = strip_tags(str_replace('
',"\n",$mailc->Body));
if(!$paten_online){
while($row = mysql_fetch_assoc($result)){
$mailc->AddAddress($row['Email']);
}
}else{
$mailc->AddAddress('team@schulhofchat.de');
}
$mailc->send();
echo 'Dein Patenruf wurde weitergeleitet.';exit;
}
?>
Patenruf