$count[] = $row['count'];
// Use something like below to filter off domain names
// $host[] = preg_replace("/\.tld.domain.*/", "", $row['host']);
$host[] = $row['host'];
}
}
// CDUKES: Jun 18, 2008: Added in support of the SQZ feature
if (defined('SQZ_ENABLED') && SQZ_ENABLED == TRUE) {
$query = "SELECT SUM(counter) FROM " . DEFAULTLOGTABLE . " ";
$result = perform_query($query, $dbLink) or die(mysql_error());
$row = fetch_array($result);
$totalrows = commify($row[0]);
// die ("Total COUNT rows: $totalrows");
} else {
if (defined('COUNT_ROWS') && COUNT_ROWS == TRUE && $num_results) {
$totalrows = commify(get_total_rows(DEFAULTLOGTABLE));
// die ("Total COUNT rows:" . $totalrows);
} else {
// Get Total number of rows
$query = "SELECT count(*) from " . DEFAULTLOGTABLE;
$result = perform_query($query, $dbLink) or die(mysql_error());
$numrows = mysql_num_rows($result);
$totalrows = commify($numrows);
// die ("Total rows: $query<br>" . $totalrows);
}
}
// A new pie graph
$graph = new PieGraph(640, 480, 'auto');
$graph->SetShadow();
// Title setup
/* cdukes - 2-28-08: Added a test to notify the user if they selected more TopX than what was available in the database
*
*/
$basePath = dirname(__FILE__);
require_once $basePath . "/../common_funcs.php";
$dbLink = db_connect_syslog(DBADMIN, DBADMINPW);
session_start();
$username = $_SESSION['username'];
$action = get_input('action');
switch ($action) {
case "get":
$username = $_SESSION['username'];
$sql = "SELECT totd FROM users where username='******'";
$result = perform_query($sql, $dbLink, $_SERVER['PHP_SELF']);
$line = fetch_array($result);
if ($line[0] == "show") {
$count = get_total_rows('totd', $dbLink);
$sql = "SELECT * FROM totd where lastshown<(SELECT NOW() - INTERVAL " . $_SESSION['TOOLTIP_REPEAT'] . " MINUTE) ORDER BY RAND() LIMIT 1";
$result = perform_query($sql, $dbLink, $_SERVER['PHP_SELF']);
while ($line = fetch_array($result)) {
$num = $line['tipnum'];
$id = $line['id'];
$name = $line['name'];
$text = $line['text'];
}
if ($id) {
echo "<i>Tip #{$num} of {$count}</i><br><b>{$name}:</b><br>{$text}";
$sql = "UPDATE totd SET lastshown=NOW() WHERE id='" . $id . "'";
perform_query($sql, $dbLink, $_SERVER['PHP_SELF']);
}
}
break;
$content_mask = $_GET['content_mask'];
} else {
$content_mask = "";
}
//construct where clause
$where = "WHERE 1=1";
/*
if (LOG_QUERIES == 'TRUE') {
$myFile = MYSQL_QUERY_LOG;
$fh = fopen($myFile, 'a') or die("can't open file $myFile");
fwrite($fh, print_r($_GET));
fclose($fh);
}
*/
$where .= " AND user='******'username'] . "'";
$count = get_total_rows("ui_layout", $dbLink, "{$where}");
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
// do not put $limit*($page - 1)
$response->page = $page;
$response->total = $total_pages;
$response->records = $count;
$sql = "SELECT * FROM ui_layout {$where} ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}";
$result = perform_query($sql, $dbLink, $_REQUEST['pageId']);
