[Top][All Lists]
[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'];
+ }
+
+
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] sms/setup setup.inc.php tables_update.inc.php,
Sigurd Nes <=