function SuperAdminQuery() { $del = false; $okdelete = false; if ($_GET["zDate"] != null) { if (preg_match('#^([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; if (strlen($re[1]) == 4) { $q_zdate = "AND DATE_FORMAT(zDate,'%Y')={$re[1]}"; } } if (preg_match('#^([0-9]+)-([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m')='{$re[1]}-{$re[2]}'"; } if (preg_match('#^([0-9]+)-([0-9]+)-([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m-%d')='{$re[1]}-{$re[2]}-{$re[3]}'"; } if (preg_match('#^([0-9]+)-([0-9]+)-([0-9]+)\\s+([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m-%d %H')='{$re[1]}-{$re[2]}-{$re[3]} {$re[4]}'"; } if (preg_match('#^([0-9]+)-([0-9]+)-([0-9]+)\\s+([0-9]+):([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m-%d %H:%i')='{$re[1]}-{$re[2]}-{$re[3]} {$re[4]}:{$re[5]}'"; } } $limit = "LIMIT 0,100"; if ($_GET["mailfrom"] != null) { $okdelete = true; $_GET["mailfrom"] = str_replace('*', '%', $_GET["mailfrom"]); $q_mailfrom = "AND mailfrom LIKE '{$_GET["mailfrom"]}%'"; } if ($_GET["recipient"] != null) { $okdelete = true; $_GET["recipient"] = str_replace('*', '%', $_GET["recipient"]); $q_mailfrom = "AND mailto LIKE '{$_GET["recipient"]}%'"; } if ($_GET["subject"] != null) { $okdelete = true; $_GET["subject"] = str_replace('*', '%', $_GET["subject"]); $q_mailfrom = "AND subject LIKE '{$_GET["subject"]}%'"; } if ($_GET["delete"] == "yes") { if ($okdelete) { $del = true; } $limit = null; } $sql = "SELECT MessageID,zDate,mailfrom,subject,mailto FROM storage WHERE 1 {$q_zdate} {$q_mailfrom} ORDER BY zDate DESC {$limit}"; $sql = str_replace('%%', '%', $sql); $q = new mysql(); writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__); $html = "<table style='width:99%' class=form>\n\t<tr>\n\t\t<th> </th>\n\t\t<th>{date}</th>\n\t\t<th>{from}</th>\n\t\t<th>{recipient}</th>\n\t\t<th>{subject}</th>\n\t</tr>"; $results = $q->QUERY_SQL($sql, "artica_backup"); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { if ($del) { DeleteOrgMail($ligne["MessageID"]); $ligne["subject"] = "<strong style='color:#d32d2d'>{deleted}</strong>"; } if (strlen($ligne["subject"]) > 50) { $ligne["subject"] = texttooltip(substr($ligne["subject"], 0, 47) . '...', $ligne["subject"]); } $html = $html . "<tr " . CellRollOver("AdminBackup('{$ligne["MessageID"]}')") . ">\n\t\t\t<td width=1%><img src='img/fw_bold.gif'></td>\n\t\t\t<td nowrap>{$ligne["zDate"]}</td>\n\t\t\t<td nowrap>{$ligne["mailfrom"]}</td>\n\t\t\t<td nowrap>{$ligne["mailto"]}</td>\n\t\t\t<td>{$ligne["subject"]}</td>\n\t\t</tr>\n\t\t\t\n\t\t"; } $html = $html . "</table>"; $tpl = new templates(); echo $tpl->_ENGINE_parse_body($html); }
function SuperAdminQuery2() { $del = false; $okdelete = false; $page = CurrentPageName(); if ($_GET["zDate"] != null) { if (preg_match('#^([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; if (strlen($re[1]) == 4) { $q_zdate = "AND DATE_FORMAT(zDate,'%Y')={$re[1]}"; } } if (preg_match('#^([0-9]+)-([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m')='{$re[1]}-{$re[2]}'"; } if (preg_match('#^([0-9]+)-([0-9]+)-([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m-%d')='{$re[1]}-{$re[2]}-{$re[3]}'"; } if (preg_match('#^([0-9]+)-([0-9]+)-([0-9]+)\\s+([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m-%d %H')='{$re[1]}-{$re[2]}-{$re[3]} {$re[4]}'"; } if (preg_match('#^([0-9]+)-([0-9]+)-([0-9]+)\\s+([0-9]+):([0-9]+)#', $_GET["zDate"], $re)) { $okdelete = true; $q_zdate = "AND DATE_FORMAT(zDate,'%Y-%m-%d %H:%i')='{$re[1]}-{$re[2]}-{$re[3]} {$re[4]}:{$re[5]}'"; } } $limit = "LIMIT 0,100"; if ($_GET["mailfrom"] != null) { $okdelete = true; $_GET["mailfrom"] = str_replace('*', '%', $_GET["mailfrom"]); $q_mailfrom = "AND mailfrom LIKE '{$_GET["mailfrom"]}%'"; } if ($_GET["recipient"] != null) { $okdelete = true; $_GET["recipient"] = str_replace('*', '%', $_GET["recipient"]); $q_mailfrom = "AND mailto LIKE '{$_GET["recipient"]}%'"; } if ($_GET["subject"] != null) { $okdelete = true; $_GET["subject"] = str_replace('*', '%', $_GET["subject"]); $q_mailfrom = "AND subject LIKE '{$_GET["subject"]}%'"; } if ($_GET["delete"] == "yes") { if ($okdelete) { $del = true; } $limit = null; } $sql = "SELECT MessageID,zDate,mailfrom,subject,mailto FROM quarantine WHERE 1 {$q_zdate} {$q_mailfrom} ORDER BY zDate DESC {$limit}"; $sql = str_replace('%%', '%', $sql); $q = new mysql(); writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__); $html = "\n\t<table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:99%'>\n\t<thead class='thead'>\n\t\t<tr>\n\t\t<th> </th>\n\t\t<th>{date}</th>\n\t\t<th>{from}</th>\n\t\t<th>{recipient}</th>\n\t\t<th>{subject}</th>\n\t\t</tr>\n\t</thead>\n\t<tbody class='tbody'>\t"; $results = $q->QUERY_SQL($sql, "artica_backup"); $array_selected = unserialize(base64_decode($_GET["MessagesSelected"])); $classtr = null; while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { if ($del) { DeleteOrgMail($ligne["MessageID"]); $ligne["subject"] = "{deleted}"; } $year = date('Y'); $today = date('m-d'); if (strlen($ligne["subject"]) > 50) { $ligne["subject"] = texttooltip(substr($ligne["subject"], 0, 47) . '...', $ligne["subject"]); } $js = "AdminQuarantine('{$ligne["MessageID"]}')"; if ($classtr == "oddRow") { $classtr = null; } else { $classtr = "oddRow"; } if (strlen($ligne["mailfrom"]) > 23) { $ligne["mailfrom"] = texttooltip(substr($ligne["mailfrom"], 0, 20) . "...", $ligne["mailfrom"], $js, null, 0, "font-size:13px"); } if (strlen($ligne["mailto"]) > 23) { $ligne["mailto"] = texttooltip(substr($ligne["mailto"], 0, 20) . "...", $ligne["mailto"], $js, null, 0, "font-size:13px"); } $ligne["zDate"] = str_replace("{$year}-", '', $ligne["zDate"]); $ligne["zDate"] = str_replace("{$today}", '{today}', $ligne["zDate"]); $checkbox_md = md5($ligne["MessageID"]); $checkbox_md_value = 0; if ($array_selected[$ligne["MessageID"]]) { $checkbox_md_value = 1; } $html = $html . "<tr class={$classtr}>\n\t\t\t<td width=1%>" . Field_checkbox($checkbox_md, 1, $checkbox_md_value, "LiberLigne('{$ligne["MessageID"]}','{$checkbox_md}')") . "</td>\n\t\t\t<td nowrap><a href='#' OnClick=\"javascript:{$js}\" style='font-size:13px;'>{$ligne["zDate"]}</a></td>\n\t\t\t<td nowrap><a href='#' OnClick=\"javascript:{$js}\" style='font-size:13px;text-decoration:underline'>{$ligne["mailfrom"]}</a></td>\n\t\t\t<td nowrap><a href='#' OnClick=\"javascript:{$js}\" style='font-size:13px;text-decoration:underline'>{$ligne["mailto"]}</a></td>\n\t\t\t<td><a href='#' OnClick=\"javascript:{$js}\" style='font-size:13px;text-decoration:underline'>{$ligne["subject"]}</a></td>\n\t\t</tr>\n\t\t\t\n\t\t"; } $tpl = new templates(); $libere_text = "{confirm} {release}"; $html = $html . "</tbody></table>\n\t\n\t\n\t<script>\n\t\n\tfunction x_LiberLigneText(obj){\n\t\tvar tempvalue=obj.responseText;\n\t\tdocument.getElementById('queue-quar-text').innerHTML=tempvalue;\n\t}\t\t\n\t\n\tfunction LiberLigneText(){\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('LiberLigneText',document.getElementById('liberequeue').value);\n\t\tXHR.sendAndLoad('{$page}', 'GET',x_LiberLigneText);\n\t}\n\t\n\tfunction x_LiberLignePerform(obj){\n\t\tvar tempvalue=obj.responseText;\n\t\tdocument.getElementById('liberequeue').value=tempvalue;\n\t\tLiberLigneText();\n\t}\t\t\t\n\t\t\t\n\tfunction LiberLignePerform(msgid,add){\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('LiberLignePerform',msgid);\n\t\tXHR.appendData('action',add);\n\t\tXHR.appendData('liste',document.getElementById('liberequeue').value);\n\t\tXHR.sendAndLoad('{$page}', 'GET',x_LiberLignePerform);\t\n\t}\n\t\n\tfunction x_LiberQueue(obj){\n\t\tvar tempvalue=obj.responseText;\n\t\talert(tempvalue);\n\t}\t\t\n\n\tfunction LiberQueue(num){\n\t\tif(confirm('{$libere_text} '+num+' mails')){\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('LiberLigneQueue',document.getElementById('liberequeue').value);\n\t\t\tXHR.sendAndLoad('{$page}', 'POST',x_LiberQueue);\n\t\t}\n\t}\n\t\n\t\n\tfunction LiberLigne(messageid,id){\n\t\tif(document.getElementById(id).checked){LiberLignePerform(messageid,1);}else{LiberLignePerform(messageid,0);}\n\t}\n\t</script>"; echo $tpl->_ENGINE_parse_body($html); }