[Phpgroupware-cvs] [18530] add some log, fix the SQL (at least for psql)

[Caeies]

Revision: 18530
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=18530
Author:   Caeies
Date:     2008-05-14 17:34:13 +0000 (Wed, 14 May 2008)

Log Message:
-----------
add some log, fix the SQL (at least for psql)

Modified Paths:
--------------
    trunk/syncml/inc/class.somappings.inc.php

Modified: trunk/syncml/inc/class.somappings.inc.php
===================================================================
--- trunk/syncml/inc/class.somappings.inc.php   2008-05-14 17:33:17 UTC (rev 
18529)
+++ trunk/syncml/inc/class.somappings.inc.php   2008-05-14 17:34:13 UTC (rev 
18530)
@@ -130,10 +130,16 @@
                 */
                function update_mapping($ch_id, $luid, $guid, $flag)
                {
+                               
syncml_logger::get_instance()->log("update_mapping($ch_id, $luid, $guid, 
$flag)");
+                               syncml_logger::get_instance()->log(" 
update_mapping :". '
+                               UPDATE phpgw_syncml_mappings SET dirty = \'' . 
intval($flag) . '\' WHERE ' .
+                                       (!is_null($ch_id) ?
+                                               'channel_id = \'' . $ch_id . 
'\' AND ' : '') .
+                                       (!is_null($luid) ? 'luid = \'' . $luid 
. '\' AND ' : '') .
+                                       (!is_null($guid) ? 'guid = \'' . $guid 
. '\' AND ' : '') .
+                                       '1 = 1');
                        $GLOBALS['phpgw']->db->query('
-                               UPDATE phpgw_syncml_mappings m
-                               SET m.dirty = \'' . intval($flag) . '\'
-                               WHERE ' .
+                               UPDATE phpgw_syncml_mappings SET dirty = \'' . 
intval($flag) . '\' WHERE ' .
                                        (!is_null($ch_id) ?
                                                'channel_id = \'' . $ch_id . 
'\' AND ' : '') .
                                        (!is_null($luid) ? 'luid = \'' . $luid 
. '\' AND ' : '') .