[Tikiwiki-cvs] tiki/lib/Galaxia/src/ProcessMonitor ProcessMonitor.php,1.12.4.3,1.12.4.4

[<geo...@us...>]

Update of /cvsroot/tikiwiki/tiki/lib/Galaxia/src/ProcessMonitor
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21726

Modified Files:
      Tag: BRANCH-1-9
	ProcessMonitor.php 
Log Message:
Fixes for MySQL 4.0.x

Index: ProcessMonitor.php
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/lib/Galaxia/src/ProcessMonitor/ProcessMonitor.php,v
retrieving revision 1.12.4.3
retrieving revision 1.12.4.4
diff -u -d -r1.12.4.3 -r1.12.4.4
--- ProcessMonitor.php	27 Jan 2006 11:05:01 -0000	1.12.4.3
+++ ProcessMonitor.php	8 Mar 2006 11:42:52 -0000	1.12.4.4
@@ -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 ";