[Entwicklung] Fwd: Cron <root@service01> php5 /var/www/xres_xpur/utility/calculateLogHistory.php

6 May 2014


      Dieser CronJob spamt auf allen service01 Servern der Kunden, bitte prüfen.


-------- Original-Nachricht --------
Betreff: 	Cron <root@service01> php5
/var/www/xres_xpur/utility/calculateLogHistory.php
Datum: 	Tue, 6 May 2014 01:00:01 +0200 (CEST)
Von: 	root@service01.xpur.xres.de (Cron Daemon)
An: 	root@service01.xpur.xres.de


[2014-05-06T01:00:01+02:00] DEBUG = [3] display data and XML<br><!DOCTYPE html><head><style type="text/css"><!--body {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 12px;
}

div.menu {
    height: 40px;
    margin: 5px;
    border: 1px solid #000;
}

span {
    display: block;
    float: left;
    margin: 9px;
    padding: 3px;
    background-color: #ddd;
    border: 1px solid #000;
    width: 90px;
    height: 14px;
    cursor: pointer;
}

span.searchLevelTwo, span.filterLevelTwo, span.backToLevelOne {
    width: 130px;
}

input {
    display: block;
    float:left;
    margin: 9px;
    padding: 3px;
    color: #000;
    border: 1px solid #000;
}

div.header {
    margin-top:1px;
    padding: 5px;
    color: #FFFFFF;
}

div.data {
    margin-top: 0px;
    margin-bottom: 0px;
    background-color: #F0F0FF;
    padding: 5px;
    border: 1px solid #7099C5"
}

div.click {
    display: inline;
    cursor: pointer;
    font-weight: bold;
}--></style><script type="text/javascript" src="../../xadmin/js/jquery14/jquery-1.4.2.min.js"></script><script type="text/javascript" src="../../xadmin/js/jquery14/jquery-ui-1.8.4.custom.min.js"></script><script type="text/javascript">// Shows all entries that are of this debug id, hides all other
function showEntries(currentId) {
    $("div.header").hide();
    $("div.data").hide();
    $("div[class$=" + currentId + "]").show();
    $("input.searchLevelTwo").val(currentId);
}

// Shows all entries
function showAllEntries() {
    $("div.header").show();
    $("div.data").show();
}

// searches for a certain pattern
function search() {
    var searchText = $("input.search").val(); // Input field text

    var objectArray = new Array();
    var dataBlocks = $("div.data");
    var arrayLength = dataBlocks.length

    // Iterating through the items and scanning the html code
    for (var i = 0; i < arrayLength; i++) {
        if (dataBlocks[i].innerHTML.search(searchText) > -1) {
            // We found an entry and remember the id
            var id = dataBlocks[i].getAttribute('class').replace("data ", "").replace("header ", "");
            objectArray[id] = id;
        }
    }

    // Hiding everything
    $("div.header").hide();
    $("div.data").hide();

    // Showing the ones we want
    for (var key in objectArray) {
        $("div." + key).show();
    }
}

// Links ot the level 2 logs ans filters the given ID
function searchLevelTwo() {
    var searchText = $("input.searchLevelTwo").val(); // Input field text
    var newURL = window.location.href.replace('debugLog', 'debugLogLevelTwo')+ '?id=' + searchText;
    window.location.href = newURL;
}

// Grabs the parameter from the url and filters the level two log for that one
function filterLevelTwo()
{
    var url = window.location.href;
    var id = url.substr(url.indexOf('?id=') + 4);
    $("input.filterLevelTwo").val(id);

    showEntries(id);
}

function backToLevelOne()
{
    var newURL = window.location.href.replace('debugLogLevelTwo', 'debugLog');
    newURL = newURL.substr(0, newURL.indexOf('?id='));
    window.location.href = newURL;
}

function toDbEntry(processId)
{
    var newURL = window.location.href.substr(0, window.location.href.indexOf('/xres/'));
    newURL = newURL + '/xres/showLogEntry.php?processid=' + processId;
    console.log(newURL);
    window.location.href = newURL;
}

function backToMainPage()
{
    window.history.back();
}</script></head><body><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.00s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b></b><br>Testbeginn</div><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.03s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b>Mapper_Log_Abstract::getLastDays</b><br>Search SQL</div><pre><div class="data 13993308018381">SELECT hotelRequest, flightRequest, DATE(createdAt), COUNT(*) as amount, SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) as successes, ROUND((SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) / SUM(1)), 2) as ratio, ROUND(AVG(runtime),2) as avgRunTime FROM log_ba WHERE createdAt >='2014-05-05' AND createdAt <= '2014-05-05 23:59:59' GROUP BY hotelRequest, flightRequest, DATE(createdAt)</div></pre><div
  class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.10s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b>Mapper_Log_Abstract::getLastDays</b><br>Search SQL</div><pre><div class="data 13993308018381">SELECT hotelRequest, flightRequest, DATE(createdAt), COUNT(*) as amount, SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) as successes, ROUND((SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) / SUM(1)), 2) as ratio, ROUND(AVG(runtime),2) as avgRunTime FROM log_b WHERE createdAt >='2014-05-05' AND createdAt <= '2014-05-05 23:59:59' GROUP BY hotelRequest, flightRequest, DATE(createdAt)</div></pre><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.11s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b></b><br>result</div>

[Entwicklung] Fwd: Cron <root@service01> php5 /var/www/xres_xpur/utility/calculateLogHistory.php

Tilo Werner