phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] sms/setup setup.inc.php tables_update.inc.php


From: Sigurd Nes
Subject: [Phpgroupware-cvs] sms/setup setup.inc.php tables_update.inc.php
Date: Fri, 26 May 2006 13:46:30 +0000

CVSROOT:        /sources/phpgroupware
Module name:    sms
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/05/26 13:46:30

Modified files:
        setup          : setup.inc.php tables_update.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/setup/setup.inc.php.diff?tr1=1.5&tr2=1.6&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/setup/tables_update.inc.php.diff?tr1=1.3&tr2=1.4&r1=text&r2=text

Patches:
Index: sms/setup/setup.inc.php
diff -u sms/setup/setup.inc.php:1.5 sms/setup/setup.inc.php:1.6
--- sms/setup/setup.inc.php:1.5 Fri May 26 08:06:04 2006
+++ sms/setup/setup.inc.php     Fri May 26 13:46:30 2006
@@ -6,12 +6,12 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package sms
        * @subpackage setup
-       * @version $Id: setup.inc.php,v 1.5 2006/05/26 08:06:04 sigurdne Exp $
+       * @version $Id: setup.inc.php,v 1.6 2006/05/26 13:46:30 sigurdne Exp $
        */
 
        $setup_info['sms']['name']      = 'sms';
        $setup_info['sms']['title']= 'SMS';
-       $setup_info['sms']['version']   = '0.9.17.502';
+       $setup_info['sms']['version']   = '0.9.17.503';
        $setup_info['sms']['app_order'] = 8;
        $setup_info['sms']['enable']    = 1;
        $setup_info['sms']['app_group'] = 'office';
Index: sms/setup/tables_update.inc.php
diff -u sms/setup/tables_update.inc.php:1.3 sms/setup/tables_update.inc.php:1.4
--- sms/setup/tables_update.inc.php:1.3 Thu May 25 19:47:10 2006
+++ sms/setup/tables_update.inc.php     Fri May 26 13:46:30 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package sms
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.3 2006/05/25 19:47:10 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.4 2006/05/26 13:46:30 
sigurdne Exp $
        */
 
        /**
@@ -99,3 +99,73 @@
                return $GLOBALS['setup_info']['sms']['currentver'];
        }
 
+       $test[] = '0.9.17.502';
+       function sms_upgrade0_9_17_502()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_gwmodclickatell_config');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_gwmodgnokii_config');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_gwmodkannel_config');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_gwmodtemplate_config');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_gwmoduplink_config');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_tblconfig_main');
+               $GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_tbluser');
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('phpgw_sms_tbluser_country');
+       
+               $GLOBALS['phpgw_setup']->oProc->query("DELETE from phpgw_config 
WHERE config_app='sms'");
+               
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_type (id,name, descr) VALUES ('3', 'clickatell', 'The 
clickatell Gateway')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_type (id,name, descr) VALUES ('4', 'uplink', 'The Uplink 
Gateway')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_type (id,name, descr) VALUES ('5', 'kannel', 'The Kannel 
Gateway')");
+       
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 1, 
'text', 'api_id', 'Clickatell API ID')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 2, 
'text', 'username', 'Clickatell username')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 3, 
'text', 'password', 'Clickatell password')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 4, 
'text', 'sender', 'Clickatell Global Sender')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 5, 
'text', 'send_url', 'Clickatell API URL')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 6, 
'text', 'incoming_path', 'Clickatell Incoming Path')");                    
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (3, 7, 
'text', 'credit', 'What is this')");                       
+
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (4, 1, 
'text', 'master', 'Uplink Master URL')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (4, 2, 
'text', 'username', 'Uplink username')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (4, 3, 
'text', 'password', 'Uplink password')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (4, 4, 
'text', 'global_sender', 'Uplink Global Sender')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (4, 5, 
'text', 'incoming_path', 'Uplink Incoming Path')");        
+
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 1, 
'text', 'username', 'Kannel username')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 2, 
'text', 'password', 'Kannel password')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 3, 
'text', 'global_sender', 'Kannel global sender')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 4, 
'text', 'bearerbox_host', 'Kannel bearerbox_host')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 5, 
'text', 'sendsms_port', 'Kannel Send SMS Port')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 6, 
'text', 'playsms_web', 'Playsms Web URL')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_attrib (type_id,id,input_type,name, descr) VALUES (5, 7, 
'text', 'incoming_path', 'Kannel incoming path')");
+       
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 1, 1, 
'123456')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 2, 1, 
'playsms')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 3, 1, 'pwd')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 4, 1, 
'PlaySMS')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 5, 1, 
'http://api.clickatell.com/http')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 6, 1, 
'usr/local')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (3, 7, 1, '10')");
+       
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (4, 1, 1, 
'http://cpanel.smsrakyat.net')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (4, 2, 1, 
'playsms')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (4, 3, 1, 'pwd')");
+
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (4, 5, 1, 
'/usr/local')");
+
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 1, 1, 
'playsms')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 2, 1, 'pwd')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 3, 1, '92824')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 4, 1, 
'127.0.0.1')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 5, 1, '13131')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 6, 1, 
'http://localhost/~playsms')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 7, 1, 
'/usr/local')");                                        
+
+               $GLOBALS['setup_info']['sms']['currentver'] = '0.9.17.503';
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
+               return $GLOBALS['setup_info']['sms']['currentver'];
+       }
+
+




reply via email to

[Prev in Thread] Current Thread [Next in Thread]