* * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. */ require_once 'geograph/global.inc.php'; init_session(); $USER->mustHavePerm("admin"); $smarty = new GeographPage(); $db = NewADOConnection($GLOBALS['DSN']); dump_sql_table('SHOW ' . (empty($_GET['full']) ? '' : 'FULL ') . 'PROCESSLIST', 'Current mySQL Process List'); function dump_sql_table($sql, $title, $autoorderlimit = false) { $result = mysql_query($sql . ($autoorderlimit ? " order by count desc limit 25" : '')) or die("Couldn't select photos : {$sql} " . mysql_error() . "\n"); $row = mysql_fetch_array($result, MYSQL_ASSOC); print "<H3>{$title}</H3>"; print "<TABLE border='1' cellspacing='0' cellpadding='2'><TR>"; foreach ($row as $key => $value) { print "<TH>{$key}</TH>"; } print "</TR>"; do { print "<TR>"; $align = "left"; foreach ($row as $key => $value) { print "<TD ALIGN={$align}>" . htmlentities($value) . "</TD>";
dump_sql_table($sql, 'Most Used Classification'); $sql = "select limit3,count(distinct user_id) as users,count(*) as count from queries where {$datecrit} group by limit3"; dump_sql_table($sql, 'Most Used Image Category'); $sql = "select limit4,count(distinct user_id) as users,count(*) as count from queries where {$datecrit} group by limit4"; dump_sql_table($sql, 'Most Used Reference Index'); $sql = "select limit5,count(distinct user_id) as users,count(*) as count from queries where {$datecrit} group by limit5"; dump_sql_table($sql, 'Most Used Grid Square'); $sql = "select displayclass,count(distinct user_id) as users,count(*) as count from queries where {$datecrit} group by displayclass"; dump_sql_table($sql, 'Most Used View Class'); $sql = "select orderby,count(distinct user_id) as users,count(*) as count from queries where {$datecrit} group by orderby"; dump_sql_table($sql, 'Most Used Order'); print "<HR/><H2>Search Stats for whole time</H2>"; $sql = "select searchclass,count(distinct user_id) as users,count(*) as count from queries group by searchclass"; dump_sql_table($sql, 'Most Used Search Class'); $sql = "select searchq,count(distinct user_id) as users,count(*) as count from queries group by searchq"; dump_sql_table($sql, 'Most Used Query Strings'); } $smarty->display('_std_end.tpl'); exit; function dump_sql_table($sql, $title, $autoorderlimit = true) { $result = mysql_query($sql . ($autoorderlimit ? " order by count desc limit 25" : '')) or die("Couldn't select photos : {$sql} " . mysql_error() . "\n"); $row = mysql_fetch_array($result, MYSQL_ASSOC); print "<H3>{$title}</H3>"; print "<TABLE border='1' cellspacing='0' cellpadding='2'><TR>"; foreach ($row as $key => $value) { print "<TH>{$key}</TH>"; } print "</TR><TR>"; foreach ($row as $key => $value) { print "<TD>{$value}</TD>";
* but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. */ require_once 'geograph/global.inc.php'; init_session(); $USER->mustHavePerm("admin"); $smarty = new GeographPage(); $db = NewADOConnection($GLOBALS['DSN']); dump_sql_table('select rendered,level,url,filename,count(*),min(ts),max(ts) from kmlcache group by rendered,level order by level,rendered', 'KML - Superlayer Rendering Progress'); dump_sql_table('select now()', ''); dump_sql_table("select substring(ts,1,10),count(*),count(distinct level),sum(rendered=1),sum(rendered=0) from kmlcache group by substring(ts,1,10) order by ts desc limit 20", 'Last few days'); function dump_sql_table($sql, $title, $autoorderlimit = false) { $result = mysql_query($sql . ($autoorderlimit ? " order by count desc limit 25" : '')) or die("Couldn't select photos : {$sql} " . mysql_error() . "\n"); $row = mysql_fetch_array($result, MYSQL_ASSOC); print "<H3>{$title}</H3>"; print "<TABLE border='1' cellspacing='0' cellpadding='2'><TR>"; foreach ($row as $key => $value) { print "<TH>{$key}</TH>"; } print "</TR>"; do { print "<TR>"; $align = "left"; foreach ($row as $key => $value) { print "<TD ALIGN={$align}>" . htmlentities($value) . "</TD>";