"; echo ""; if($db->connected) { $sql_latest_10 = "Select dofcall_message, dofcall_sender_name, dofcall_date, dofcall_group, UCASE(dofcall_group) As message_group From tbl_dofcall Where dofcall_group LIKE BINARY '%@dofcall.dk%' AND dofcall_group NOT LIKE '%test@dofcall.dk%' AND dofcall_message NOT LIKE '%MIME format%' AND dofcall_group IS NOT NULL Order By dofcall_upload_date Desc Limit 10"; $db->query($sql_latest_10, "latest_10"); $dofcall_added_last_one = ""; $rowNumber = 0; while($row = $db->row("latest_10")) { $dofcall_message = $row["dofcall_message"]; $dofcall_sender_name = $row["dofcall_sender_name"]; $dofcall_date = $row["dofcall_date"]; $message_group = $row["message_group"]; $dofcall_group = $row["dofcall_group"]; $dofcall_added_date = date("Y\-n\-j", strtotime($dofcall_date)); if($dofcall_added_date != $dofcall_added_last_one) { if($dofcall_added_last_one != "") { echo ""; echo " "; echo ""; } echo ""; echo ""; echo gui_date_time($dofcall_added_date, 0, 1); echo ""; echo ""; $dofcall_added_last_one = $dofcall_added_date; } echo ""; echo "" . date("H\:i", strtotime($dofcall_date)) . ""; echo ""; echo substr($message_group, 0, strpos($message_group, '@')); echo ""; echo ""; echo $row["dofcall_message"]; $dofcall_sender_name = trim($dofcall_sender_name); if(!is_null($dofcall_sender_name) AND $dofcall_sender_name != ''){ $dofcall_sender_name_45 = str_replace("+45", "", $dofcall_sender_name); } if($dofcall_sender_name != '') { if(!(strstr($row["dofcall_message"], $dofcall_sender_name) OR strstr($row["dofcall_message"], $dofcall_sender_name_45))) { echo " " . $dofcall_sender_name; } } echo ""; echo ""; } //End while } else { echo ""; echo "DOFcalls kan ikke vises, da serveren er nede!"; echo ""; } echo ""; echo ""; $db->db_close(); ?>