function listemails() { $order = "ORDER BY zDate DESC"; $page = CurrentPageName(); if (isset($_GET["filter-sender"])) { if ($_GET["filter-sender"] != null) { $_SESSION["QUARANTINE"]["SENDER"] = $_GET["filter-sender"]; if (strpos($_GET["filter-sender"], '*') > 0 or $_GET["filter-sender"][0] == '*') { $and = " AND mailfrom LIKE '" . str_replace("*", "%", "{$_GET["filter-sender"]}") . "'"; } else { $and = " AND mailfrom='{$_GET["filter-sender"]}'"; } $back = true; } } if ($_GET["body"] != null) { $_SESSION["QUARANTINE"]["body"] = $_GET["body"]; $pertinance = ",MATCH (MessageBody) AGAINST (\"{$_GET["body"]}\") AS pertinence "; $order = "ORDER BY pertinence DESC"; } $mailto = mailto($and); $q = new mysql(); $sql = "select MessageID,mailfrom,mailto,zDate,subject{$pertinance} FROM quarantine WHERE ({$mailto}) {$order} LIMIT 0,150"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql, "artica_backup"); $head = "\n\t<table>\n\t<td valign='middle' width=99%>\n\t\t<H3>{quarantine_mails}</H3>\n\t</td>\n\t<td>" . imgtootltip("48-logs.png", '{quarantine_email_report}', "Loadjs('quarantine.report.php')") . "</td>\n\t<td>" . imgtootltip("question-48.png", '{search}', "Loadjs('{$page}?search-js=yes')") . "</td>\n\t<td>" . imgtootltip("48-infos.png", '{infos}', "Loadjs('user.messaging.php?email-infos-js=quarantine')") . "</td>\n\t</tr>\n\t</table>\n\t"; $table = "<table style='width:95%' class=table_form>\n\t\t<tr>\n\t\t<th><span style='color:white'>{date}</span></th>\n\t\t<th><span style='color:white'>{subject}</span></th>\n\t\t<th><span style='color:white'>{senderm}</span></th>\t\t\n\t\t<th><span style='color:white'>{recipient}</span></th>\n\t\t</tr>\n\t\t\n\t\t"; $date_hier = strftime("%Y-%m-%d", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y'))); $date = date('Y-m-d'); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $ligne["zDate"] = str_replace($date, '{today}', $ligne["zDate"]); $ligne["zDate"] = str_replace($date_hier, '{yesterday}', $ligne["zDate"]); if ($class == "row1") { $class = "row2"; } else { $class = "row1"; } if (strlen($ligne["subject"]) > 40) { $ligne["subject"] = substr($ligne["subject"], 0, 37) . "..."; } $table = $table . "<tr class={$class}>\n\t\t<td valign='top' nowrap class={$class} width=1%>{$ligne["zDate"]}</td>\n\t\t<td valign='top' class={$class}>" . divlien("Loadjs('{$page}?ShowID={$ligne["MessageID"]}')", $ligne["subject"]) . "</td>\n\t\t<td valign='top' class={$class}>{$ligne["mailfrom"]}</a></td>\n\t\t<td valign='top' class={$class}>{$ligne["mailto"]}</td>\n\t\t\n\t\t</tr>"; } $table = $table . "</table>"; if ($back) { return "{$head}{$table}"; } return "<div style='width:100%;height:500px;overflow:auto' id='rtmm-panel'>{$head}{$table}</div>\n\t\n\t\n\t"; }
function listemails() { $page = CurrentPageName(); $and = "AND filesize>0"; $head = "\n\t<table>\n\t<td valign='middle' width=99%>\n\t\t<H3>{user_backup_emails_query_text}</H3>\n\t</td>\n\t<td>" . imgtootltip("question-48.png", '{search}', "Loadjs('{$page}?search-js=yes')") . "</td>\n\t<td>" . imgtootltip("48-infos.png", '{infos}', "Loadjs('user.messaging.php?email-infos-js=quarantine')") . "</td>\n\t</tr>\n\t</table>\n\t"; //filter-body //$sql="SELECT storage.MessageID,storage.mailfrom$recipient_to_find_fields,storage.zDate,storage.subject,storage.MessageBody,MATCH (storage.MessageBody) // AGAINST (\"$stringtofind\") AS pertinence // FROM storage,storage_recipients WHERE storage.MessageID=storage_recipients.MessageID$recipient_to_find$sender_to_find ORDER BY pertinence DESC LIMIT 0,90"; $order = "ORDER BY zDate DESC"; if (isset($_GET["filter-sender"])) { if ($_GET["filter-sender"] != null) { if (strpos($_GET["filter-sender"], '*') > 0 or $_GET["filter-sender"][0] == '*') { $and = $and . " AND mailfrom LIKE '" . str_replace("*", "%", "{$_GET["filter-sender"]}") . "'"; } else { $and = $and . " AND mailfrom='{$_GET["filter-sender"]}'"; } $back = true; } } if ($_GET["body"] != null) { $pertinance = ",MATCH (MessageBody) AGAINST (\"{$_GET["filter-body"]}\") AS pertinence "; $order = "ORDER BY pertinence DESC"; } $delivery_users = mailto($and); $q = new mysql(); $sql = "select MessageID,mailfrom,mailto,DATE_FORMAT(zDate,'%Y-%m-%d %H:%i') as tdate ,filesize,subject{$pertinance} FROM storage WHERE ({$delivery_users}) {$order} LIMIT 0,150"; writelogs($sql, __FUNCTION__, __FILE__, __LINE__); $results = $q->QUERY_SQL($sql, "artica_backup"); if ($back) { $html = $html . "<table style='width:90%'>\n\t\t<tr>\n\t\t\t<td><a href='backup.php'><H3>« {back}</H3></td>\n\t\t</tr>\n\t\t</table>"; } $html = $html . "<table style='width:95%' class=table_form>\n\t\n\t\t<tr>\n\t\t<th>{date}</span></th>\n\t\t<th>{size}</span></th>\n\t\t<th>{subject}</span></th>\n\t\t<th>{senderm}</span></th>\t\t\n\t\t<th>{recipient}</span></th>\n\n\t\t</tr>\n\t\t\n\t\t"; $date_hier = strftime("%y-%m-%d", mktime(0, 0, 0, date('m'), date('d') - 1, date('y'))); $date = date('Y-m-d'); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $filesize = $ligne["filesize"] / 1024; if ($class == "row1") { $class = "row2"; } else { $class = "row1"; } $filesize = FormatBytes($filesize); if (strlen($ligne["subject"]) > 40) { $ligne["subject"] = substr($ligne["subject"], 0, 37) . "..."; } $ligne["tdate"] = str_replace($date, '{today}', $ligne["tdate"]); $ligne["tdate"] = str_replace($date_hier, '{yesterday}', $ligne["tdate"]); $html = $html . "\n\t\t<tr class={$class}>\n\t\t<td valign='top' nowrap width=1%> {$ligne["tdate"]} </td>\n\t\t<td valign='top' > {$filesize} </td>\n\t\t\t<td valign='top' class={$class}>" . divlien("Loadjs('{$page}?ShowID={$ligne["MessageID"]}')", $ligne["subject"]) . "</td>\n\t\t<td valign='top' >{$ligne["mailfrom"]}</td>\n\t\t<td valign='top' >{$ligne["mailto"]}</td>\n\t\t</tr>"; } $html = $html . "</table>"; $tpl = new templates(); return $tpl->_ENGINE_parse_body("<div style='width:100%;height:500px;overflow:auto'>{$head}{$html}</div>"); }