From: <sy...@us...> - 2006-03-16 13:43:59
|
Update of /cvsroot/tikiwiki/tiki/lib/Galaxia/src/ProcessMonitor In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3460/lib/Galaxia/src/ProcessMonitor Modified Files: ProcessMonitor.php Log Message: Instant-Auto-Merge from BRANCH-1-9 to HEAD Index: ProcessMonitor.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/lib/Galaxia/src/ProcessMonitor/ProcessMonitor.php,v retrieving revision 1.14 retrieving revision 1.15 diff -u -d -r1.14 -r1.15 --- ProcessMonitor.php 17 Feb 2006 15:10:39 -0000 1.14 +++ ProcessMonitor.php 16 Mar 2006 13:43:11 -0000 1.15 @@ -372,7 +372,7 @@ $mid.=" and (`properties` like $findesc)"; } - $query = "SELECT `itemId`, DATEDIFF(FROM_UNIXTIME(gw.`ended`), FROM_UNIXTIME(gw.`started`)) AS duration, "; + $query = "SELECT `itemId`, (TO_DAYS(FROM_UNIXTIME(gw.`ended`)) - TO_DAYS(FROM_UNIXTIME(gw.`started`))) AS duration, "; $query .= "ga.`isInteractive`, ga.`type`, gp.`name` AS procname, gp.`version`, ga.`name` AS actname, "; $query .= "ga.`activityId`, gw.`instanceId`, gi.`name` AS iname, `orderId`, gw.`properties`, gw.`started`, "; $query .= "gi.`status`, gw.`ended`, `user` FROM "; |