function search()
{
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_syslog();
$search = '%';
$table = "logrotate";
$page = 1;
$ORDER = "ORDER BY ID DESC";
$sock = new sockets();
$t = $_GET["t"];
if (!$q->TABLE_EXISTS($table)) {
$q->CheckTables();
}
if ($q->COUNT_ROWS($table) == 0) {
$q->CheckDefaults();
}
$total = 0;
if ($q->COUNT_ROWS($table, $database) == 0) {
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
echo json_encode($data);
return;
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
if ($_POST["query"] != null) {
$_POST["query"] = "*" . $_POST["query"] . "*";
$_POST["query"] = str_replace("**", "*", $_POST["query"]);
$_POST["query"] = str_replace("**", "*", $_POST["query"]);
$_POST["query"] = str_replace("*", "%", $_POST["query"]);
$search = $_POST["query"];
$searchstring = "AND (`{$_POST["qtype"]}` LIKE '{$search}')";
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1 {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database));
$total = $ligne["TCOUNT"];
} else {
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database));
$total = $ligne["TCOUNT"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} {$ORDER} {$limitSql}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql, $database);
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
if (!$q->ok) {
$data['rows'][] = array('id' => $ligne[time() + 1], 'cell' => array($q->mysql_error, "", "", ""));
$data['rows'][] = array('id' => $ligne[time()], 'cell' => array($sql, "", "", ""));
echo json_encode($data);
return;
}
//######"
//TimeText TimeDescription TaskType enabled
$q2 = new mysql();
while ($ligne = mysql_fetch_assoc($results)) {
$color = "black";
$events = " ";
$md5 = md5("RotateTask{$ligne['ID']}");
$jstaskexplain = $tpl->javascript_parse_text($q->tasks_array[$ligne["TaskType"]]);
$ligne["TaskType"] = $tpl->_ENGINE_parse_body($q->tasks_array[$ligne["TaskType"]]);
$enable = Field_checkbox($md5, 1, $ligne["enabled"], "RotateTaskEnable('{$md5}',{$ligne['ID']})");
$delete = imgtootltip("delete-24.png", "{delete} {$ligne['ID']}", "RotateTaskDelete('{$ligne['ID']}')");
if ($ligne["enabled"] == 0) {
$color = "#A0A0A0";
}
$jsEdit = "Loadjs('{$MyPage}?Rotate-js=yes&ID={$ligne['ID']}&t={$t}');";
$RotateFreq = $tpl->_ENGINE_parse_body("{{$ligne["RotateFreq"]}}");
$description = utf8_encode($tpl->_ENGINE_parse_body("{$ligne["description"]}"));
$description = htmlentities($description);
$span = "<a href=\"javascript:blur();\" OnClick=\"javascript:{$jsEdit}\"\n\t\t style='font-size:16px;font-weight:bold;color:{$color};text-decoration:underline'>";
//rowSquidTask
$data['rows'][] = array('id' => "RotateTask" . $ligne['ID'], 'cell' => array("{$span}{$ligne['ID']}</a>", "{$span}{$ligne["RotateFiles"]}</a>", "{$span}{$ligne["MaxSize"]}M</a>", "{$span}{$RotateFreq}</span>", $description, "<div style='margin-top:5px'>{$enable}</div>", $delete));
}
echo json_encode($data);
}
