[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/custom oppdater_utgaatt_objekt.php, 1.3
From: |
sigurdne |
Subject: |
[Phpgroupware-cvs] property/inc/custom oppdater_utgaatt_objekt.php, 1.3 |
Date: |
Thu, 24 Feb 2005 15:29:11 -0000 |
Update of property/inc/custom
Modified Files:
Branch: MAIN
oppdater_utgaatt_objekt.php lines: +8 -4
Log Message:
no message
====================================================
Index: property/inc/custom/oppdater_utgaatt_objekt.php
diff -u property/inc/custom/oppdater_utgaatt_objekt.php:1.2
property/inc/custom/oppdater_utgaatt_objekt.php:1.3
--- property/inc/custom/oppdater_utgaatt_objekt.php:1.2 Thu Jan 13 17:00:04 2005
+++ property/inc/custom/oppdater_utgaatt_objekt.php Tue Feb 1 15:08:10 2005
@@ -160,15 +160,19 @@
for ($i=0; $i<count($update); $i++)
{
- $sql = "SELECT status FROM
$parent_table WHERE location_code= '" . $update[$i]['location_code'] ."'";
+ $sql = "SELECT category FROM
$parent_table WHERE location_code= '" . $update[$i]['location_code'] ."'";
$this->db->query($sql,__LINE__,__FILE__);
$this->db->next_record();
- if($this->db->f('status')!=2)
+ if($this->db->f('category')!=99)
{
$j++;
- $this->db->query("UPDATE
fm_location" . ($type_id-1). " set status= 2 WHERE location_code= '" .
$update[$i]['location_code'] ."'",__LINE__,__FILE__);
+ $this->db->query("UPDATE
fm_location" . ($type_id-1). " set status= 2, category=99 WHERE
location_code= '" . $update[$i]['location_code'] ."'",__LINE__,__FILE__);
+ if($type_id == 2)
+ {
+
$this->db->query("UPDATE fm_location1 set kostra_id = NULL WHERE
location_code= '" . $update[$i]['location_code'] ."'",__LINE__,__FILE__);
+ }
}
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/inc/custom oppdater_utgaatt_objekt.php, 1.3,
sigurdne <=