[Fmsystem-commits] [9952] sms: more on pswin

[Sigurd Nes]

Revision: 9952
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9952
Author:   sigurdne
Date:     2012-08-31 11:03:24 +0000 (Fri, 31 Aug 2012)
Log Message:
-----------
sms: more on pswin

Modified Paths:
--------------
    trunk/sms/setup/default_records.inc.php
    trunk/sms/setup/tables_current.inc.php

Modified: trunk/sms/setup/default_records.inc.php
===================================================================
--- trunk/sms/setup/default_records.inc.php     2012-08-31 10:14:12 UTC (rev 
9951)
+++ trunk/sms/setup/default_records.inc.php     2012-08-31 11:03:24 UTC (rev 
9952)
@@ -3,7 +3,7 @@
        * phpGroupWare - sms: A SMS Gateway
        *
        * @author Sigurd Nes <address@hidden>
-       * @copyright Copyright (C) 2003-2005 Free Software Foundation, Inc. 
http://www.fsf.org/
+       * @copyright Copyright (C) 2003-2012 Free Software Foundation, Inc. 
http://www.fsf.org/
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package sms
@@ -24,6 +24,22 @@
 
        $location_id = $GLOBALS['phpgw']->locations->get_id('sms', 'run');
 
+       $db->query("SELECT id FROM phpgw_config2_section WHERE location_id = 
'$location_id'");
+       
+       $old_sections = array();
+       while($db->next_record())
+       {
+               $old_sections[] = $db->f('id');
+       }
+       
+       if ($old_sections)
+       {
+               $db->query('DELETE FROM phpgw_config2_section WHERE id IN (' . 
explode(',',$old_sections ) . ')');
+               $db->query('DELETE FROM phpgw_config2_attrib WHERE section_id 
IN (' . explode(',',$old_sections ) . ')');
+               $db->query('DELETE FROM phpgw_config2_choice WHERE section_id 
IN (' . explode(',',$old_sections ) . ')');
+               $db->query('DELETE FROM phpgw_config2_value WHERE section_id IN 
(' . explode(',',$old_sections ) . ')');
+       }
+
        $db->query("DELETE FROM phpgw_locations where app_id = {$app_id} AND 
name != 'run'");
        $db->query("INSERT INTO phpgw_locations (app_id, name, descr) VALUES 
({$app_id}, '.', 'Top')");
        $db->query("INSERT INTO phpgw_locations (app_id, name, descr, 
allow_grant) VALUES ({$app_id}, '.inbox', 'InBox',1)");

Modified: trunk/sms/setup/tables_current.inc.php
===================================================================
--- trunk/sms/setup/tables_current.inc.php      2012-08-31 10:14:12 UTC (rev 
9951)
+++ trunk/sms/setup/tables_current.inc.php      2012-08-31 11:03:24 UTC (rev 
9952)
@@ -314,7 +314,7 @@
                'phpgw_sms_received_data' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto', 'nullable' => 
False),
-                               'type' => array('type' => 'varchar', 
'precision' => 15, 'nullable' => False),,/*sms/mms/report*/
+                               'type' => array('type' => 'varchar', 
'precision' => 15, 'nullable' => False),/*sms/mms/report*/
                                'data' => array('type' => 'text', 'nullable' => 
False),
                                'status' => array('type' => 'int', 'precision' 
=> 4, 'nullable' => False, 'default' => '0'),
                                'entry_date' => array('type' => 'int', 
'precision' => 4, 'nullable' => False, 'default' => '0'),