$rs = $xhprof_runs_impl->getUrlStats($criteria);
list($header, $body) = showChart($rs, true);
$_xh_header .= $header;
include "../xhprof_lib/templates/header.phtml";
$rs = $xhprof_runs_impl->getRuns($criteria);
include "../xhprof_lib/templates/emptyBody.phtml";
$url = htmlentities($_GET['geturl'], ENT_QUOTES, "UTF-8");
displayRuns($rs, "Runs with URL: {$url}");
} elseif (isset($_GET['getcurl'])) {
$last = isset($_GET['last']) ? $_GET['last'] : 100;
$last = (int) $last;
$criteria['c_url'] = $_GET['getcurl'];
$criteria['limit'] = $last;
$criteria['order by'] = 'timestamp';
$rs = $xhprof_runs_impl->getUrlStats($criteria);
list($header, $body) = showChart($rs, true);
$_xh_header .= $header;
include "../xhprof_lib/templates/header.phtml";
$url = htmlentities($_GET['getcurl'], ENT_QUOTES, "UTF-8");
$rs = $xhprof_runs_impl->getRuns($criteria);
include "../xhprof_lib/templates/emptyBody.phtml";
displayRuns($rs, "Runs with Simplified URL: {$url}");
} elseif (isset($_GET['getruns'])) {
include "../xhprof_lib/templates/header.phtml";
$days = (int) $_GET['days'];
switch ($_GET['getruns']) {
case "cpu":
$load = "cpu";
break;
case "wt":
$load = "wt";
$rs = $xhprof_runs_impl->getUrlStats($criteria);
list($header, $body) = showChart($rs, TRUE);
$_xh_header .= $header;
include "../lib/templates/header.phtml";
$rs = $xhprof_runs_impl->getRuns($criteria);
include "../lib/templates/emptyBody.phtml";
$url = htmlentities($_GET['geturl'], ENT_QUOTES, "UTF-8");
displayRuns($rs, "Runs with URL: {$url}");
} elseif (isset($_GET['getcurl'])) {
$last = isset($_GET['last']) ? $_GET['last'] : 100;
$last = (int) $last;
$criteria['c_url'] = $_GET['getcurl'];
$criteria['limit'] = $last;
$criteria['order by'] = 'timestamp';
$rs = $xhprof_runs_impl->getUrlStats($criteria);
list($header, $body) = showChart($rs, TRUE);
$_xh_header .= $header;
include "../lib/templates/header.phtml";
$url = htmlentities($_GET['getcurl'], ENT_QUOTES, "UTF-8");
$rs = $xhprof_runs_impl->getRuns($criteria);
include "../lib/templates/emptyBody.phtml";
displayRuns($rs, "Runs with Simplified URL: {$url}");
} elseif (isset($_GET['getruns'])) {
include "../lib/templates/header.phtml";
$days = (int) $_GET['days'];
switch ($_GET['getruns']) {
case "cpu":
$load = "cpu";
break;
case "wt":
$load = "wt";
<html>
<head>
<title>SAVED DATA</title>
<head>
<meta charset="utf-8" />
<link rel="stylesheet" href="records.css" />
</head>
<body>
<h2>SAVED DATA</h2>
<?php
$url = "import.php";
if (isset($_GET['query'])) {
echo getList($url);
} else {
if (isset($_GET['num'])) {
echo showChart($_GET['num']);
} else {
echo "<h2>BAD REQUEST</h2>";
}
}
function showChart($num)
{
$out = '';
$data = file_get_contents('mapData.src');
if (!$data) {
$r = "THERE WAS AN ERROR RETRIEVING THE DATA";
return $r;
}
$data = unserialize($data);
$len = count($data);
$err = "<h2>BAD REQUEST</h2>";
function runWeekly($user_pref)
{
$database = DB::getInstance();
$db = $database->getConnection();
//grab time
$time = grab_timeframe();
//get breakdown pref
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
$user_sql = "SELECT \tuser_time_register,\n\t\t\t\t\t\t\t\tuser_pref_breakdown,\n\t\t\t\t\t\t\t\tuser_pref_chart,\n\t\t\t\t\t\t\t\tuser_pref_show\n\t\t\t\t\t FROM 202_users LEFT JOIN 202_users_pref USING (user_id) \n\t\t\t\t\t WHERE 202_users.user_id='" . $mysql['user_id'] . "'";
$user_result = _mysqli_query($user_sql);
//($user_sql);
$user_row = $user_result->fetch_assoc();
if ($user_row['user_pref_show'] == 'all') {
$click_flitered = '';
}
if ($user_row['user_pref_show'] == 'real') {
$click_filtered = " AND click_filtered='0' ";
}
if ($user_row['user_pref_show'] == 'filtered') {
$click_filtered = " AND click_filtered='1' ";
}
if ($user_row['user_pref_show'] == 'filtered_bot') {
$click_filtered = " AND click_bot='1' ";
}
if ($user_row['user_pref_show'] == 'leads') {
$click_filtered = " AND click_lead='1' ";
}
//breakdown should be hour, day, month, or year.
$breakdown = 'day';
$pref_chart = $user_row['user_pref_chart'];
//first delete old report
$breakdown_sql = "\n\t\t\tDELETE\n\t\t\tFROM 202_sort_breakdowns\n\t\t\tWHERE user_id='" . $mysql['user_id'] . "'\n\t\t";
$breakdown_result = _mysqli_query($breakdown_sql);
//($breakdown_sql);
//find where to start from.
$start = $time['from'];
$end = $time['to'];
//make sure the start isn't past this users registration time, and likewise, make sure END isn't past today, else theses will try to grab reports for dates that do not exists slowing down mysql doing reports for nothing.
if ($user_row['user_time_register'] > $start) {
$start = $user_row['user_time_register'];
}
if (time() < $end) {
$end = time();
}
$x = 0;
while ($end > $start) {
$from = mktime(0, 0, 0, date('m', $end), date('d', $end), date('y', $end));
$to = mktime(23, 59, 59, date('m', $end), date('d', $end), date('y', $end));
$end = $end - 86400;
$end1 = $end + 86400;
$day = date('D', $end1);
switch ($day) {
case "Sun":
$day = 1;
break;
case "Mon":
$day = 2;
break;
case "Tue":
$day = 3;
break;
case "Wed":
$day = 4;
break;
case "Thu":
$day = 5;
break;
case "Fri":
$day = 6;
break;
case "Sat":
$day = 7;
break;
}
$mysql['from'] = $db->real_escape_string($from);
$mysql['to'] = $db->real_escape_string($to);
//build query
$command = "\n\t\t\tSELECT\n\t\t\t\tCOUNT(*) AS clicks,\n\t\t\t\tSUM(2cr.click_out) AS click_throughs,\n\t\t\t\tSUM(click_cpc) AS cost,\n\t\t\t\tSUM(2c.click_lead) AS leads,\n\t\t\t\tSUM(2c.click_payout*2c.click_lead) AS income\n\t\t\tFROM\n\t\t\t\t202_clicks AS 2c\n\t\t\t\tLEFT JOIN 202_clicks_record AS 2cr ON 2cr.click_id = 2c.click_id\n\t\t";
$db_table = "2c";
$pref_time = false;
if ($user_pref == true) {
$pref_adv = true;
$command = $command . "\n\t\t\t\tLEFT JOIN 202_clicks_advance AS 2ca ON (2ca.click_id = 2c.click_id)\n\t\t\t\tLEFT JOIN 202_clicks_site AS 2cs ON (2cs.click_id = 2c.click_id)\n\t\t\t";
} else {
$pref_adv = false;
}
$command = $command . "\n\t\t\tLEFT JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id)\n\t\t\tLEFT JOIN 202_aff_networks AS 2an ON (2an.aff_network_id = 2ac.aff_network_id)\n\t\t";
$pref_show = false;
$pref_order = "\n\t\t\tAND (2c.click_alp = '1' OR (2ac.aff_campaign_deleted='0' AND 2an.aff_network_deleted='0'))\n\t\t\t{$click_filtered}\n\t\t\tAND 2c.click_time > " . $mysql['from'] . "\n\t\t\tAND 2c.click_time <= " . $mysql['to'] . "\n\t\t";
$offset = false;
$pref_limit = false;
$count = false;
$query = query($command, $db_table, $pref_time, $pref_adv, $pref_show, $pref_order, $offset, $pref_limit, $count);
$click_sql = $query['click_sql'];
$click_result = _mysqli_query($click_sql);
//($click_sql);
$click_row = $click_result->fetch_assoc();
//for AVG Payouts
$payouts_sql = "\n\t\t\tSELECT\n\t\t\t\tSUM(2c.click_payout) AS payout\n\t\t\tFROM 202_clicks AS 2c\n\t\t\tWHERE 2c.click_lead='1'\n\t\t\tAND 2c.click_time > " . $mysql['from'] . "\n\t\t\tAND 2c.click_time <= " . $mysql['to'] . "\n\t\t";
$payout_result = _mysqli_query($payouts_sql);
//($breakdown_sql);
$payout_row = $payout_result->fetch_assoc();
//get the stats
$clicks[$day] = $click_row['clicks'] + $clicks[$day];
$total_clicks = $total_clicks + $click_row['clicks'];
//click_throughs
$click_throughs[$day] = $click_row['click_throughs'] + $click_throughs[$day];
$total_click_throughs = $total_click_throughs + $click_row['click_throughs'];
//ctr
$ctr[$day] = @round($click_throughs[$day] / $clicks[$day] * 100, 2);
$total_ctr = @round($total_click_throughs / $total_clicks * 100, 2);
//avg cpc and cost
$cost[$day] = $click_row['cost'] + $cost[$day];
if ($clicks[$day] > 0) {
$avg_cpc[$day] = $cost[$day] / $clicks[$day];
}
$total_cost = $total_cost + $click_row['cost'];
$total_avg_cpc = @round($total_cost / $total_clicks, 5);
//leads
$leads[$day] = $click_row['leads'] + $leads[$day];
$total_leads = $total_leads + $click_row['leads'];
//signup ratio
$su_ratio[$day] = @round($leads[$day] / $clicks[$day] * 100, 2);
$total_su_ratio = @round($total_leads / $total_clicks * 100, 2);
//current payout
if ($click_row['leads'] > 0) {
$payout[$day] = $payout_row['payout'] / $leads[$day];
}
//income
$income[$day] = $click_row['income'] + $income[$day];
$total_income = $total_income + $click_row['income'];
//grab the EPC
$epc = @round($income[$day] / $clicks[$day], 2);
$total_epc = @round($total_income / $total_clicks, 2);
//net income
$net[$day] = $income[$day] - $cost[$day];
$total_net = $total_income - $total_cost;
//roi
$roi[$day] = @round($net[$day] / $cost[$day] * 100);
$total_roi = @round($total_net / $total_cost);
}
for ($day = 1; $day < 8; $day++) {
//html escape vars
$from = $day;
//$to = $hour +1; if ($to == 24) { $to = 0; }
$mysql['from'] = $db->real_escape_string($from);
$mysql['to'] = $db->real_escape_string($to);
$mysql['clicks'] = $db->real_escape_string($clicks[$day]);
$mysql['click_throughs'] = $db->real_escape_string($click_throughs[$day]);
$mysql['ctr'] = $db->real_escape_string($ctr[$day]);
$mysql['leads'] = $db->real_escape_string($leads[$day]);
$mysql['su_ratio'] = $db->real_escape_string($su_ratio[$day]);
$mysql['payout'] = $db->real_escape_string($payout[$day]);
$mysql['epc'] = $db->real_escape_string($epc[$day]);
$mysql['avg_cpc'] = $db->real_escape_string($avg_cpc[$day]);
$mysql['income'] = $db->real_escape_string($income[$day]);
$mysql['cost'] = $db->real_escape_string($cost[$day]);
$mysql['net'] = $db->real_escape_string($net[$day]);
$mysql['roi'] = $db->real_escape_string($roi[$day]);
//insert chart
$sort_breakdown_sql = "\n\t\t\tINSERT INTO 202_sort_breakdowns\n\t\t\tSET\n\t\t\t\tsort_breakdown_from='" . $mysql['from'] . "',\n\t\t\t\tsort_breakdown_to='" . $mysql['to'] . "',\n\t\t\t\tuser_id='" . $mysql['user_id'] . "',\n\t\t\t\tsort_breakdown_clicks='" . $mysql['clicks'] . "',\n\t\t\t\tsort_breakdown_click_throughs='" . $mysql['click_throughs'] . "',\n\t\t\t\tsort_breakdown_ctr='" . $mysql['ctr'] . "',\n\t\t\t\tsort_breakdown_leads='" . $mysql['leads'] . "',\n\t\t\t\tsort_breakdown_su_ratio='" . $mysql['su_ratio'] . "',\n\t\t\t\tsort_breakdown_payout='" . $mysql['payout'] . "',\n\t\t\t\tsort_breakdown_epc='" . $mysql['epc'] . "',\n\t\t\t\tsort_breakdown_avg_cpc='" . $mysql['avg_cpc'] . "',\n\t\t\t\tsort_breakdown_income='" . $mysql['income'] . "',\n\t\t\t\tsort_breakdown_cost='" . $mysql['cost'] . "',\n\t\t\t\tsort_breakdown_net='" . $mysql['net'] . "',\n\t\t\t\tsort_breakdown_roi='" . $mysql['roi'] . "'\n\t\t";
$sort_breakdown_result = _mysqli_query($sort_breakdown_sql);
#echo "<p>$sort_breakdown_sql</p>";
}
$breakdown_sql = "\n\t\tSELECT *\n\t\tFROM 202_sort_breakdowns\n\t\tWHERE user_id='" . $mysql['user_id'] . "'\n\t\tORDER BY sort_breakdown_from ASC\n\t";
$breakdown_result = _mysqli_query($breakdown_sql);
//($breakdown_sql);
$chartWidth = $_POST['chartWidth'];
$chartHeight = 180;
/* THIS IS A NET INCOME BAR GRAPH */
if ($pref_chart == 'profitloss') {
//start the PHP multi-dimensional array and create the region titles
$chart['chart_data'][0][0] = "";
$chart['chart_data'][1][0] = "Income";
$chart['chart_data'][2][0] = "Cost";
$chart['chart_data'][3][0] = "Net";
//extract the data from the query result one row at a time
for ($i = 0; $i < $breakdown_result->num_rows; $i++) {
//determine which column in the PHP array the current data belongs to
$breakdown_result->field_seek($breakdown_result->current_field);
$row = $breakdown_result->fetch_assoc();
$col = $row['sort_breakdown_from'];
$col++;
//populate the PHP array with the Year title
$day = $row['sort_breakdown_from'];
switch ($day) {
case 1:
$day = "Sun";
break;
case 2:
$day = "Mon";
break;
case 3:
$day = "Tue";
break;
case 4:
$day = "Wed";
break;
case 5:
$day = "Thu";
break;
case 6:
$day = "Fri";
break;
case 7:
$day = "Sat";
break;
}
$chart['chart_data'][0][$col] = $day;
//populate the PHP array with the revenue data
$chart['chart_data'][1][$col] = $row['sort_breakdown_income'];
$chart['chart_data'][2][$col] = $row['sort_breakdown_cost'];
$chart['chart_data'][3][$col] = $row['sort_breakdown_net'];
}
$chart['series_color'] = array("70CF40", "CF4040", "409CCF", "000000");
$chart['series_gap'] = array('set_gap' => 40, 'bar_gap' => -35);
$chart['chart_grid_h'] = array('alpha' => 20, 'color' => "000000", 'thickness' => 1, 'type' => "dashed");
$chart['axis_value'] = array('bold' => false, 'size' => 10);
$chart['axis_category'] = array('skip' => 3, 'bold' => false, 'size' => 10);
$chart['legend_label'] = array('bold' => true, 'size' => 12);
$chart['chart_pref'] = array('line_thickness' => 1, 'point_shape' => "none", 'fill_shape' => true);
$chart['chart_rect'] = array('x' => 40, 'y' => 20, 'width' => $chartWidth - 60, 'height' => $chartHeight);
$chart['chart_transition'] = array('type' => "scale", 'delay' => 0.5, 'duration' => 0.5, 'order' => "series");
} else {
//start the PHP multi-dimensional array and create the region titles
$chart['chart_data'][0][0] = "";
if ($pref_chart == 'clicks') {
$chart['chart_data'][1][0] = "Clicks";
} elseif ($pref_chart == 'leads') {
$chart['chart_data'][1][0] = "Leads";
} elseif ($pref_chart == 'su_ratio') {
$chart['chart_data'][1][0] = "Signup Ratio";
} elseif ($pref_chart == 'payout') {
$chart['chart_data'][1][0] = "Payout";
} elseif ($pref_chart == 'epc') {
$chart['chart_data'][1][0] = "EPC";
} elseif ($pref_chart == 'cpc') {
$chart['chart_data'][1][0] = "Avg CPC";
} elseif ($pref_chart == 'income') {
$chart['chart_data'][1][0] = "Income";
} elseif ($pref_chart == 'cost') {
$chart['chart_data'][1][0] = "Cost";
} elseif ($pref_chart == 'net') {
$chart['chart_data'][1][0] = "Net";
} elseif ($pref_chart == 'roi') {
$chart['chart_data'][1][0] = "ROI";
}
//extract the data from the query result one row at a time
for ($i = 0; $i < $breakdown_result->num_rows; $i++) {
//determine which column in the PHP array the current data belongs to
$breakdown_result->field_seek($breakdown_result->current_field);
$row = $breakdown_result->fetch_assoc();
$col = $row['sort_breakdown_from'];
$col++;
//populate the PHP array with the Year title
$day = $row['sort_breakdown_from'];
switch ($day) {
case 1:
$day = "Sun";
break;
case 2:
$day = "Mon";
break;
case 3:
$day = "Tue";
break;
case 4:
$day = "Wed";
break;
case 5:
$day = "Thu";
break;
case 6:
$day = "Fri";
break;
case 7:
$day = "Sat";
break;
}
$chart['chart_data'][0][$col] = $day;
//populate the PHP array with the revenue data
if ($pref_chart == 'clicks') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_clicks'];
} elseif ($pref_chart == 'leads') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_leads'];
} elseif ($pref_chart == 'su_ratio') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_su_ratio'];
} elseif ($pref_chart == 'payout') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_payout'];
} elseif ($pref_chart == 'epc') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_epc'];
} elseif ($pref_chart == 'cpc') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_avg_cpc'];
} elseif ($pref_chart == 'income') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_income'];
} elseif ($pref_chart == 'cost') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_cost'];
} elseif ($pref_chart == 'net') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_net'];
} elseif ($pref_chart == 'roi') {
$chart['chart_data'][1][$col] = $row['sort_breakdown_roi'];
}
}
//$chart[ 'series_color' ] = array ( "003399");
$chart['series_color'] = array("000000");
$chart['chart_type'] = "Line";
$chart['chart_transition'] = array('type' => "dissolve", 'delay' => 0.5, 'duration' => 0.5, 'order' => "series");
$chart['chart_grid_h'] = array('alpha' => 20, 'color' => "000000", 'thickness' => 1, 'type' => "dashed");
}
$chart['chart_pref'] = array('line_thickness' => 1, 'point_shape' => "circle", 'fill_shape' => false);
$chart['axis_value'] = array('bold' => false, 'size' => 10);
$chart['axis_category'] = array('bold' => false, 'size' => 10);
$chart['legend_label'] = array('bold' => true, 'size' => 12);
$chart['chart_rect'] = array('x' => 40, 'y' => 20, 'width' => $chartWidth - 60, 'height' => $chartHeight);
showChart($chart, $chartWidth - 20, $chartHeight + 40);
?>
<div style="padding: 3px 0px;"></div><?php
}
<?php
global $urlsite;
$localPageName = $_GET['act'];
$id = $_GET['id'];
include "controller/" . $localPageName . ".php";
// if(!isset($_SESSION['usersessid'])){
// echo"<br><br><center><span class=notFound>"._PLEASELOGINUSER."</span></center><br><br>
// <br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>";
// } else {
?>
<script>var localPageName = "<?php
echo $localPageName;
?>
"</script>
<script type="text/javascript" language="JavaScript" src="js/<?php
echo $localPageName;
?>
.js"></script>
<div id="table-list"><?php
showChart($id, 0);
?>
</div>
<?php
// }
} elseif (isset($_GET['geturl'])) {
$criteria['url'] = $_GET['geturl'];
$criteria['limit'] = 100;
$rs = $xhprof_runs_impl->getUrlStats($criteria);
list($header, $body) = showChart($rs);
$_xh_header .= $header;
include "../xhprof_lib/templates/header.phtml";
$rs = $xhprof_runs_impl->getRuns(array('url' => $_GET['geturl'], 'limit' => 100));
include "../xhprof_lib/templates/emptyBody.phtml";
$url = htmlentities($_GET['geturl'], ENT_QUOTES);
displayRuns($rs, "Runs with URL: {$url}");
} elseif (isset($_GET['getcurl'])) {
$criteria['c_url'] = $_GET['getcurl'];
$criteria['limit'] = 100;
$rs = $xhprof_runs_impl->getUrlStats($criteria);
list($header, $body) = showChart($rs);
$_xh_header .= $header;
include "../xhprof_lib/templates/header.phtml";
$url = htmlentities($_GET['getcurl'], ENT_QUOTES);
$rs = $xhprof_runs_impl->getRuns($criteria);
include "../xhprof_lib/templates/emptyBody.phtml";
displayRuns($rs, "Runs with Simplified URL: {$url}");
} elseif (isset($_GET['getruns'])) {
include "../xhprof_lib/templates/header.phtml";
$days = (int) $_GET['days'];
switch ($_GET['getruns']) {
case "cpu":
$load = "cpu";
break;
case "wt":
$load = "wt";
function showAllCharts()
{
global $names;
//global $DEBUG;
$DEBUG = true;
$htmltext = "";
$images = array(1 => "<img src='house.png' height='64'/>", 2 => "<img src='bed.png' height='32'/>", 3 => "<img src='teddy.png' height='48'/>'", 4 => "<img src='bad.png' height='48'/>'");
$htmltext .= "\n<table border='1'>";
for ($id = 1; $id <= 4; $id++) {
$query = "Select temp*.1 as temp1,humidity,channel,date_time, DATE_FORMAT(date_time, '%d.%m.%Y<p>%k:%i</p>') as date_timeStr FROM `avrtemp` WHERE channel=" . $id . " ORDER by date_time DESC LIMIT 1;";
$result = mysql_query($query);
if ($result) {
while ($row = mysql_fetch_array($result)) {
$name = $names[$row["channel"]];
$image = $images[$row["channel"]];
$temperature = $row["temp1"];
$humidity = $row["humidity"];
$htmltext .= "\n<tr>";
$htmltext .= "<td align='center'>" . $image . "<p><small>" . $row['date_timeStr'] . "</small></p></td>";
$htmltext .= "<td>" . showChart("temp", $temperature) . "</td>";
$htmltext .= "<td>" . showChart("humi", $humidity) . "</td>";
$htmltext .= "\n</tr>";
}
} else {
if ($DEBUG) {
echo "\n<p>showAllCharts() no data!</p>\n";
$htmltext .= "\n<tr><td>showAllCharts() no data!</td></tr>\n";
}
}
}
$htmltext .= "</table>\n";
return $htmltext;
}
$vbar = ' class="vbar"';
$vwbar = ' class="vwbar"';
$vwlbar = ' class="vwlbar"';
$vbbar = ' class="vbbar"';
$vrbar = ' class="vrbar"';
$vgbar = ' class="vgbar"';
$xhprof_runs_impl = new XHProfRuns_Default();
if (isset($_GET['geturl'])) {
$rs = $xhprof_runs_impl->getUrlStats(array("url" => $_GET['geturl'], 'limit' => 100));
showChart($rs);
$rs = $xhprof_runs_impl->getRuns(array('url' => $_GET['geturl'], 'limit' => 100));
$url = htmlentities($_GET['geturl'], ENT_QUOTES);
displayRuns($rs, "Runs with URL: {$url}");
} elseif (isset($_GET['getcurl'])) {
$rs = $xhprof_runs_impl->getUrlStats(array("c_url" => $_GET['getcurl'], 'limit' => 100));
showChart($rs);
$url = htmlentities($_GET['getcurl'], ENT_QUOTES);
$rs = $xhprof_runs_impl->getRuns(array('c_url' => $_GET['getcurl'], 'limit' => 100));
displayRuns($rs, "Runs with Simplified URL: {$url}");
} elseif (isset($_GET['last'])) {
$last = (int) $_GET['last'];
$rs = $xhprof_runs_impl->getRuns(array("order by" => 'timestamp', 'limit' => $last));
displayRuns($rs, "Last {$last} Runs");
} elseif (isset($_GET['getruns'])) {
$days = (int) $_GET['days'];
switch ($_GET['getruns']) {
case "cpu":
$load = "cpu";
break;
case "wt":
$load = "wt";
function showAllCharts()
{
global $names;
//global $DEBUG;
$DEBUG = true;
$htmltext = "";
$images = array(1 => "<img src='house.png' height='64'/>", 2 => "<img src='bed.png' height='32'/>", 3 => "<img src='teddy.png' height='48'/>'", 4 => "<img src='bad.png' height='48'/>'");
$htmltext .= "\n<table border='1'>";
$aussentemp = 0;
$innentemp = 0;
$aussenfeuchte = 0;
$innenfeuchte = 0;
$innenfeuchteberechnet = 0;
$innentempberechnet = 0;
$lueftenjanein = 0;
for ($id = 1; $id <= 4; $id++) {
$query = "Select temp*.1 as temp1,humidity,channel,date_time, DATE_FORMAT(date_time, '%d.%m.%Y<p>%k:%i</p>') as date_timeStr FROM `avrtemp` WHERE channel=" . $id . " ORDER by date_time DESC LIMIT 1;";
$result = mysql_query($query);
if ($result) {
while ($row = mysql_fetch_array($result)) {
$name = $names[$row["channel"]];
$image = $images[$row["channel"]];
$temperature = $row["temp1"];
$humidity = $row["humidity"];
// see http://web-docs.gsi.de/~giese/luftfeuchtigkeit.php
if ($id == 1) {
//aussen
$aussentemp = $temperature;
$aussenfeuchte = $humidity;
}
if ($id == 2) {
//schlafzimmer
$innentemp = $temperature;
if ($innentemp > $aussentemp) {
$innenfeuchteberechnet = $aussenfeuchte - 3 * ($innentemp - $aussentemp);
} else {
$innenfeuchteberechnet = $aussenfeuchte - 3 * ($aussentemp - $innentemp);
}
if ($innenfeuchteberechnet < $innenfeuchte) {
$lueftenjanein = 1;
} else {
$lueftenjanein = 0;
}
$innentempberechnet = ($innentemp + $aussentemp) / 2;
}
//$innentempberechnet=diff75($innentempberechnet,$innentemp); //75% austausch
//$innenfeuchteberechnet=diff75($innenfeuchteberechnet, $innenfeuchte);
$htmltext .= "\n<tr>";
$htmltext .= "<td align='center'>" . $image . "<p><small>" . $row['date_timeStr'] . "</small></p></td>";
$htmltext .= "<td align='center'>" . showChart("temp", $temperature);
if ($id == 2) {
$htmltext .= "<br>lueften->" . $innentempberechnet . "</td>";
} else {
$htmltext .= "</td>";
}
if ($id == 2) {
$htmltext .= "<td align='center'>" . showChart("humi", $humidity) . "<br>" . "lueften?->" . $innenfeuchteberechnet . "</td>";
} else {
$htmltext .= "<td>" . showChart("humi", $humidity) . "</td>";
}
$htmltext .= "\n</tr>";
}
} else {
if ($DEBUG) {
echo "\n<p>showAllCharts() no data!</p>\n";
$htmltext .= "\n<tr><td>showAllCharts() no data!</td></tr>\n";
}
}
}
$htmltext .= "</table>\n";
return $htmltext;
}
