[Phpgroupware-cvs] property/class.sop_of_town.php, 1.1.1.7

[nomail]

Update of /property
Modified Files:
        Branch: 
          class.sop_of_town.php

date: 2004/05/09 13:42:24;  author: sigurdne;  state: Exp;  lines: +10 -4

Log Message:
no message
=====================================================================
Index: property/class.sop_of_town.php
diff -u property/class.sop_of_town.php:1.1.1.6 
property/class.sop_of_town.php:1.1.1.7
--- property/class.sop_of_town.php:1.1.1.6      Thu Apr 29 07:10:49 2004
+++ property/class.sop_of_town.php      Sun May  9 13:42:24 2004
@@ -127,12 +127,18 @@
                {
                        $p_of_town['name'] = 
$this->functions->db_addslashes($p_of_town['name']);
 
-                       $GLOBALS['phpgw']->db->Execute("INSERT INTO 
fm_part_of_town (name,district_id) "
-                               . "VALUES ('" . $p_of_town['name']
+                       $GLOBALS['phpgw']->db->begintrans();
+                       $id = 
$GLOBALS['phpgw']->db->genid('fm_part_of_town_part_of_town_id_seq');
+
+                       $GLOBALS['phpgw']->db->Execute("INSERT INTO 
fm_part_of_town (part_of_town_id,name,district_id) "
+                               . "VALUES ($id,'" . $p_of_town['name']
                                . "','" . $p_of_town['district_id'] . "')");
 
-                       $receipt['part_of_town_id']= 
$this->db->get_last_insert_id('fm_part_of_town','part_of_town_id');
+//                     $receipt['part_of_town_id']= 
$this->db->get_last_insert_id('fm_part_of_town','part_of_town_id');
+                       $receipt['part_of_town_id']=$id;
                        $receipt['message'][] = array('msg'=>lang('Part of town 
%1 has been saved',$receipt['part_of_town_id']));
+                       $GLOBALS['phpgw']->db->committrans();
+
                        return $receipt;
                }