phpgroupware-cvs
[Top][All Lists]
Advanced

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

[Phpgroupware-cvs] sms ./INSTALL bin/phpgwsmsd bin/phpgwsmsd.php b...


From: Sigurd Nes
Subject: [Phpgroupware-cvs] sms ./INSTALL bin/phpgwsmsd bin/phpgwsmsd.php b...
Date: Mon, 29 May 2006 07:57:41 +0000

CVSROOT:        /sources/phpgroupware
Module name:    sms
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/05/29 07:57:41

Modified files:
        .              : INSTALL 
        bin            : phpgwsmsd phpgwsmsd.php phpgwsmsd_start 
        inc/plugin/gateway/clickatell: README 
        inc/plugin/gateway/kannel: config.php fn.php manage.php 
        setup          : default_records.inc.php tables_current.inc.php 
                         tables_update.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/INSTALL.diff?tr1=1.1.1.1&tr2=1.2&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/bin/phpgwsmsd.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/bin/phpgwsmsd.php.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/bin/phpgwsmsd_start.diff?tr1=1.3&tr2=1.4&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/plugin/gateway/clickatell/README.diff?tr1=1.1.1.1&tr2=1.2&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/plugin/gateway/kannel/config.php.diff?tr1=1.1.1.1&tr2=1.2&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/plugin/gateway/kannel/fn.php.diff?tr1=1.1.1.1&tr2=1.2&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/plugin/gateway/kannel/manage.php.diff?tr1=1.1.1.1&tr2=1.2&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/setup/default_records.inc.php.diff?tr1=1.6&tr2=1.7&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/setup/tables_current.inc.php.diff?tr1=1.7&tr2=1.8&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/setup/tables_update.inc.php.diff?tr1=1.4&tr2=1.5&r1=text&r2=text

Patches:
Index: sms/INSTALL
diff -u sms/INSTALL:1.1.1.1 sms/INSTALL:1.2
--- sms/INSTALL:1.1.1.1 Mon May 15 10:29:22 2006
+++ sms/INSTALL Mon May 29 07:57:40 2006
@@ -4,17 +4,6 @@
 It is based on PlaySMS version 0.8.1
 
 
-WARNING !!!
------------
-PlaySMS is not save for kids!
-But if you're a kid, and you met requirement's below, you can install PlaySMS, 
savely!
-Kids must:
-1. Not nervous when logon to Linux console remotely
-2. Be able to read and understand README, INSTALL and FAQ in this package
-3. Be able to use yahoogroups to join PlaySMS mailing list, and ask good 
questions
-4. Be serious after this WARNING
-
-
 REQUIREMENT
 -----------
 Minimum Required Hardware
@@ -29,9 +18,6 @@
     - Access to SMTP server (ability to send email via SMTP server)
 Minimum Required Server Operator (or Developer)
     - Understand howto make sure installed PHP has MySQL module enabled 
(phpinfo)
-    - Understand howto create/drop MySQL database
-    - Understand howto insert SQL statements into created database
-    - Understand the meaning of installing PlaySMS as 'root'
     - Understand howto install php application package without 'root' access 
(if needed)
     - Always find reading README, INSTALL, FAQ and other docs as a fun 
activity :)
 
@@ -41,47 +27,18 @@
 INSTALLATION on Linux
 ---------------------
 
-Note:
-- I assumed that you have root priviledge. If you dont, understand that im 
trying to 
-  guide you to install PlaySMS on /home/playsms under user 'playsms'. You may 
use your own
-  username and your own home directory or any preferred directory.
-- This installation instructions MIGHT BE working for *other NIX based 
operating system, 
-  I know someone installing PlaySMS on FreeBSD
 
-PlaySMS Web Interface:
+PHPGWSMS Web Interface:
 1.  It is important to meet all minimum requiments above (Its a must!)
-2.  Setup a system user named 'playsms' to manage PlaySMS
-    # adduser playsms
-    # passwd playsms
-    Note: on some Linux distributions adduser and passwd combined (debian?)
-3.  On most Linux distributions actions (2) will create system user and group 
named 'playsms'
-    with home directory /home/playsms, there you will install all PlaySMS files
-4.  Create public_html on user's home directory followed by directory named 
'sms'
-    # mkdir -p /home/playsms/public_html/sms
-5.  Extract PlaySMS package somewhere (Commonly in /usr/local/src)
-    # tar -zxvf playsms-x.x.x.tar.gz -C /usr/local/src
-    Note: x.x.x may be vary according to the package name you've download
-6.  Copy 'web' directory to public_html directory and set owner back to user 
playsms again
-    (for security reason)
-    # cd /usr/local/src/playsms-x.x.x
-    # cp -rR web/* /home/playsms/public_html/sms
-    Note: above command will copy all files under 'web' NOT the 'web' 
directory it self
-    # chown -R playsms /home/playsms/public_html
-    # chmod 701 /home/playsms
-7.  Setup database (import database)
-    # mysqladmin -u root -p create playsms
-    # mysql -u root -p playsms < /usr/local/src/playsms-x.x.x/db/playsms.sql
-    Note: you dont need to use MySQL root access nor this method to setup 
PlaySMS
-    database, but this is beyond our scope, you should read MySQL manual's for 
custom
-    installation method or howto insert SQL statements into existing database
-
-8.  Edit config.php on phpgwsms web directory (phpgroupware/sms/config.php)
+2.  Install the application as normal in setup.
+3.  Edit config.php on phpgwsms web directory (phpgroupware/sms/config.php)
     Please read and fill all required fields with coutious
-9.  Enter bin directory and copy phpgwsmsd and phpgwsmsd_start to 
/usr/local/bin
+4.  Enter bin directory and copy phpgwsmsd and phpgwsmsd_start to 
/usr/local/bin
     # cd phpgroupware/sms
     # cd bin
     # cp phpgwsmsd phpgwsmsd_start /usr/local/bin/
-10. Enter /etc/init.d or /etc/rc.d/init.d and look for file named 'rc.local', 
im sure you'll 
+5.  Edit the $PHPGWSMS_PATH in  /usr/local/bin/phpgwsmsd 
+6. Enter /etc/init.d or /etc/rc.d/init.d and look for file named 'rc.local', 
im sure you'll 
     found it, otherwise ask for it on mailing lists. Edit rc.local and put: 
     "/usr/local/bin/phpgwsmsd_start" (without quotes)
     on the bottom of the file (before exit if theres exit command). This way 
phpgwsmsd_start 
@@ -149,6 +106,41 @@
     running everytime the system starting-up
 
 
+Note:
+If you decide to use kannel gateway module, then you must install kannel on 
the same
+server where phpgwsms installed. There are discussion on howto install Kannel 
on separate machine
+with PlaySMS.
+Due to complexity of installation process for kannel, we decide to leave this 
module for experts. 
+Well experts, there's something you should see on this package 
contrib/kannel/kannel.conf, 
+sms service 'Default' part.
+
+Dont forget to:
+1.  Create kannel cache directory and make it writable to the web servers user
+    # mkdir -p /usr/local/cache/logs
+    # mkdir /usr/local/cache/smsd
+    # chmod -R 777 /usr/local/cache
+    Note: 
+    - the make-it-writable-to-the-world part (chmod -R 777) is just to 
simplify installation
+    - it is better if you know what is the web server's user (eg: 'nobody')
+      and instead of chmod -R 777, you can do this:
+      # chown -R nobody /usr/local/cache
+2.  Create log directory
+    # mkdir /var/log/kannel
+    Note: this can be any directory according to the kannel configurations file
+3.  Enter bin directory in this package, and copy kannel_incoming to 
/usr/local/bin
+    # cd /path_to/phpgroupware/sms/bin
+    # cp kannel_incoming /usr/local/bin
+
+If you decide to use kannel gateway module, but you dont want to use 'exec' 
method in sms service,
+just replace your kannel.conf near to sms service 'Default' part, with sms 
service 'Default' part in
+this package contrib/kannel/kannel-geturl.conf
+After copying sample configuration, dont forget to change 
'CHANGE_THIS_TO_YOUR_PHPGWSMS_URL' 
+in your kannel.conf near to sms service 'Default' part, to your working 
PHPGWSMS URL
+
+If you decide to use clickatell gateway module, please register your self at 
Clickatell's website 
+And then read the README file in $apps_path[base]/plugin/gateway/clickatell
+
+
 
 NOTES
 -----
@@ -156,4 +148,3 @@
    safe_mode = Off
    register_globals = Off
    magic_quotes_gpc = On
-2. Dont forget to read FAQ and CHANGELOG carefully
Index: sms/bin/phpgwsmsd
diff -u sms/bin/phpgwsmsd:1.2 sms/bin/phpgwsmsd:1.3
--- sms/bin/phpgwsmsd:1.2       Mon May 22 12:50:05 2006
+++ sms/bin/phpgwsmsd   Mon May 29 07:57:41 2006
@@ -1,14 +1,14 @@
 #!/usr/bin/php -q
 <?php
 
-// The path to directory of installed playsms
-$PLAYSMS_PATH = "/home/sn5607/public_html/phpgroupware/sms";
+// The path to directory of installed phpgwsms
+$PHPGWSMS_PATH = "/home/sn5607/public_html/phpgroupware/sms";
 
 // DO NOT CHANGE ANYTHING BELOW THE LINE
 // ------------------------------------------------------
 
 $DAEMON_PROCESS = true;
-chdir($PLAYSMS_PATH);
+chdir($PHPGWSMS_PATH);
 if (!function_exists("validatelogin"))
 {
     include_once("init.php");
@@ -18,7 +18,7 @@
 
 while(true)
 {
-    if (file_exists($PLAYSMS_PATH))
+    if (file_exists($PHPGWSMS_PATH))
     {
        $DAEMON_COUNTER++;
        $sms->getsmsinbox();
Index: sms/bin/phpgwsmsd.php
diff -u sms/bin/phpgwsmsd.php:1.2 sms/bin/phpgwsmsd.php:1.3
--- sms/bin/phpgwsmsd.php:1.2   Mon May 22 12:50:05 2006
+++ sms/bin/phpgwsmsd.php       Mon May 29 07:57:41 2006
@@ -1,14 +1,14 @@
 #!/usr/bin/php -q
 <?php
 
-// The path to directory of installed playsms
-$PLAYSMS_PATH = "/home/sn5607/public_html/phpgroupware/sms";
+// The path to directory of installed phpgwsms
+$PHPGWSMS_PATH = "/home/sn5607/public_html/phpgroupware/sms";
 
 // DO NOT CHANGE ANYTHING BELOW THE LINE
 // ------------------------------------------------------
 
 $DAEMON_PROCESS = true;
-chdir($PLAYSMS_PATH);
+chdir($PHPGWSMS_PATH);
 if (!function_exists("validatelogin"))
 {
     include_once("init.php");
@@ -19,7 +19,7 @@
 //while(true)
 while($DAEMON_COUNTER < 1)
 {
-    if (file_exists($PLAYSMS_PATH))
+    if (file_exists($PHPGWSMS_PATH))
     {
        $DAEMON_COUNTER++;
        $sms->getsmsinbox();
Index: sms/bin/phpgwsmsd_start
diff -u sms/bin/phpgwsmsd_start:1.3 sms/bin/phpgwsmsd_start:1.4
--- sms/bin/phpgwsmsd_start:1.3 Tue May 23 08:07:37 2006
+++ sms/bin/phpgwsmsd_start     Mon May 29 07:57:41 2006
@@ -1,5 +1,5 @@
 #!/bin/bash
 
-# playsmsd must be in PATH eg: /usr/bin or /usr/local/bin
+# phpgwsmsd must be in PATH eg: /usr/bin or /usr/local/bin
 
 /usr/local/bin/phpgwsmsd &
Index: sms/inc/plugin/gateway/clickatell/README
diff -u sms/inc/plugin/gateway/clickatell/README:1.1.1.1 
sms/inc/plugin/gateway/clickatell/README:1.2
--- sms/inc/plugin/gateway/clickatell/README:1.1.1.1    Mon May 15 10:29:23 2006
+++ sms/inc/plugin/gateway/clickatell/README    Mon May 29 07:57:41 2006
@@ -1,4 +1,4 @@
-PlaySMS gateway module for clickatell.com
+phpgwsms gateway module for clickatell.com (based on PlaySMS)
 Incoming SMS use gnokii model (spool directory, but dont have tobe gnokii) or 
callback URL
 Outgoing SMS use clickatell.com
 
@@ -9,4 +9,4 @@
 Dont forget to point callback setting on Clickatell control panel
 to callback.php in this directory
 eg:
-http://your_playsms_website/plugin/gateway/clickatell/callback.php
+http://your_phpgwsms_website/plugin/gateway/clickatell/callback.php
Index: sms/inc/plugin/gateway/kannel/config.php
diff -u sms/inc/plugin/gateway/kannel/config.php:1.1.1.1 
sms/inc/plugin/gateway/kannel/config.php:1.2
--- sms/inc/plugin/gateway/kannel/config.php:1.1.1.1    Mon May 15 10:29:23 2006
+++ sms/inc/plugin/gateway/kannel/config.php    Mon May 29 07:57:41 2006
@@ -13,7 +13,7 @@
     $kannel_param['global_sender']     = $db_row['cfg_global_sender'];
     $kannel_param['bearerbox_host']    = $db_row['cfg_bearerbox_host'];
     $kannel_param['sendsms_port']      = $db_row['cfg_sendsms_port'];
-    $kannel_param['playsms_web']       = $db_row['cfg_playsms_web'];
+    $kannel_param['phpgwsms_web']      = $db_row['cfg_phpgwsms_web'];
 }
 
 $gateway_number = $kannel_param['global_sender'];
Index: sms/inc/plugin/gateway/kannel/fn.php
diff -u sms/inc/plugin/gateway/kannel/fn.php:1.1.1.1 
sms/inc/plugin/gateway/kannel/fn.php:1.2
--- sms/inc/plugin/gateway/kannel/fn.php:1.1.1.1        Mon May 15 10:29:23 2006
+++ sms/inc/plugin/gateway/kannel/fn.php        Mon May 29 07:57:41 2006
@@ -36,7 +36,7 @@
     }
     $URL = 
"/cgi-bin/sendsms?username=".urlencode($kannel_param['username'])."&password=".urlencode($kannel_param['password']);
     $URL .= 
"&from=".urlencode($sms_from)."&to=".urlencode($sms_to)."&text=".urlencode($sms_msg);
-    $URL .= 
"&dlr-mask=31&dlr-url=".urlencode($kannel_param['playsms_web']."/plugin/gateway/kannel/dlr.php?type=%d&slid=$smslog_id&uid=$uid");
+    $URL .= 
"&dlr-mask=31&dlr-url=".urlencode($kannel_param['phpgwsms_web']."/plugin/gateway/kannel/dlr.php?type=%d&slid=$smslog_id&uid=$uid");
     $URL .= "&mclass=$sms_type";
     $connection = 
fsockopen($kannel_param['bearerbox_host'],$kannel_param['sendsms_port'],&$error_number,&$error_description,60);
     if($connection) 
Index: sms/inc/plugin/gateway/kannel/manage.php
diff -u sms/inc/plugin/gateway/kannel/manage.php:1.1.1.1 
sms/inc/plugin/gateway/kannel/manage.php:1.2
--- sms/inc/plugin/gateway/kannel/manage.php:1.1.1.1    Mon May 15 10:29:23 2006
+++ sms/inc/plugin/gateway/kannel/manage.php    Mon May 29 07:57:41 2006
@@ -33,7 +33,7 @@
            <p>Global Sender: <input type=text size=16 maxlength=16 
name=up_global_sender value=\"".$kannel_param[global_sender]."\"> (Max. 16 
numeric or 11 alphanumeric char.)
            <p>Bearerbox IP: <input type=text size=30 maxlength=250 
name=up_bearerbox_host value=\"".$kannel_param[bearerbox_host]."\"> (Kannel's 
specific)
            <p>Send SMS Port: <input type=text size=10 maxlength=10 
name=up_sendsms_port value=\"".$kannel_param[sendsms_port]."\"> (Kannel's 
specific)
-           <p>Playsms Web URL: <input type=text size=30 maxlength=250 
name=up_playsms_web value=\"".$kannel_param[playsms_web]."\">
+           <p>phpgwsms Web URL: <input type=text size=30 maxlength=250 
name=up_phpgwsms_web value=\"".$kannel_param[phpgwsms_web]."\">
            <p>Kannel Incoming Path: <input type=text size=40 maxlength=250 
name=up_incoming_path value=\"".$kannel_param[path]."\"> (No trailing slash 
\"/\")
            <p>Note :<br>
            - When you put <b>/usr/local</b> above, the real path is 
<b>/usr/local/cache/smsd</b>
@@ -49,10 +49,10 @@
        $up_global_sender = $_POST['up_global_sender'];
        $up_bearerbox_host = $_POST['up_bearerbox_host'];
        $up_sendsms_port = $_POST['up_sendsms_port'];
-       $up_playsms_web = $_POST['up_playsms_web'];
+       $up_phpgwsms_web = $_POST['up_phpgwsms_web'];
        $up_incoming_path = $_POST['up_incoming_path'];
        $error_string = "No changes made!";
-       if ($up_username && $up_password && $up_bearerbox_host && 
$up_sendsms_port && $up_playsms_web && $up_incoming_path)
+       if ($up_username && $up_password && $up_bearerbox_host && 
$up_sendsms_port && $up_phpgwsms_web && $up_incoming_path)
        {
            $db_query = "
                UPDATE phpgw_sms_gwmodkannel_config 
@@ -62,7 +62,7 @@
                    cfg_global_sender='$up_global_sender',
                    cfg_bearerbox_host='$up_bearerbox_host',
                    cfg_sendsms_port='$up_sendsms_port',
-                   cfg_playsms_web='$up_playsms_web',
+                   cfg_phpgwsms_web='$up_phpgwsms_web',
                    cfg_incoming_path='$up_incoming_path'
            ";
            if (@dba_affected_rows($db_query))
Index: sms/setup/default_records.inc.php
diff -u sms/setup/default_records.inc.php:1.6 
sms/setup/default_records.inc.php:1.7
--- sms/setup/default_records.inc.php:1.6       Fri May 26 08:06:04 2006
+++ sms/setup/default_records.inc.php   Mon May 29 07:57:41 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: default_records.inc.php,v 1.6 2006/05/26 08:06:04 
sigurdne Exp $
+       * @version $Id: default_records.inc.php,v 1.7 2006/05/29 07:57:41 
sigurdne Exp $
        */
 
 
@@ -54,7 +54,7 @@
        $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, 6, 
'text', 'phpgwsms_web', 'phpgwsms 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_choice (type_id,attrib_id,id,value) VALUES (1, 1, 1, 
'gnokii')");
@@ -67,26 +67,26 @@
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (2, 1, 1, 
'/usr/local')");
 
        $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, 2, 1, 
'phpgwsms')");
        $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, 4, 1, 
'phpgwsms')");
        $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, 2, 1, 
'phpgwsms')");
        $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, 4, 1, '')");
        $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, 1, 1, 
'phpgwsms')");
        $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, 6, 1, 
'http://localhost/~phpgroupware/sms')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_config_value (type_id,attrib_id,id,value) VALUES (5, 7, 1, 
'/usr/local')");                                        
 
 
@@ -101,7 +101,7 @@
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_featautoreply_scenario 
(autoreply_id,autoreply_scenario_param1,autoreply_scenario_param2,autoreply_scenario_param3,autoreply_scenario_param4,autoreply_scenario_param5,autoreply_scenario_param6,autoreply_scenario_param7,autoreply_scenario_result)
 VALUES (1,'WEBMAIL','PASSWORD','ERROR','','','','','Please use forgot password 
link, and follow given instructions')");
 
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featboard 
(uid,board_code,board_forward_email,board_pref_template) VALUES 
(1,'PHP','address@hidden','<font color=black 
size=-1><b>##SENDER##</b></font><br><font color=black 
size=-2><i>##DATETIME##</i></font><br><font color=black 
size=-1>##MESSAGE##</font>')");
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_featcommand (uid,command_code,command_exec) VALUES 
(1,'UPTIME','/home/playsms/public_html/beta/bin/uptime.sh ##SMSSENDER##')");
+       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_featcommand (uid,command_code,command_exec) VALUES 
(1,'UPTIME','/home/playsms/public_html/phpgroupware/sms/bin/uptime.sh 
##SMSSENDER##')");
 
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featcustom 
(uid,custom_code,custom_url) VALUES 
(1,'CURR','http://www.ngoprek.org/currency.php?toeuro=##CUSTOMPARAM##&sender=##SMSSENDER##')");
 
@@ -120,7 +120,7 @@
 
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_tblusergroupphonebook ( uid, gp_name, gp_code) VALUES ( 1, 'Friends', 
'FR')");
 
-       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_tbluserphonebook ( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1, 
'+628562283138', 'Nero', 'address@hidden')");
+       $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_tbluserphonebook ( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1, 
'+628562283138', 'Nero', 'address@hidden')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_tbluserphonebook ( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1, 
'+628562205510', 'Sleepless', 'address@hidden')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_tbluserphonebook ( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1, 
'+39933993399339', 'Crafted Chees', '')");
        $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_sms_tbluserphonebook ( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1, 
'+122334455', 'Morfren', 'address@hidden')");
Index: sms/setup/tables_current.inc.php
diff -u sms/setup/tables_current.inc.php:1.7 
sms/setup/tables_current.inc.php:1.8
--- sms/setup/tables_current.inc.php:1.7        Fri May 26 08:06:04 2006
+++ sms/setup/tables_current.inc.php    Mon May 29 07:57:41 2006
@@ -7,7 +7,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package sms
        * @subpackage setup
-       * @version $Id: tables_current.inc.php,v 1.7 2006/05/26 08:06:04 
sigurdne Exp $
+       * @version $Id: tables_current.inc.php,v 1.8 2006/05/29 07:57:41 
sigurdne Exp $
        */
 
 
@@ -214,7 +214,7 @@
                                'cfg_global_sender' => array('type' => 
'varchar', 'precision' => 20,'nullable' => True),
                                'cfg_bearerbox_host' => array('type' => 
'varchar', 'precision' => 250,'nullable' => True),
                                'cfg_sendsms_port' => array('type' => 
'varchar', 'precision' => 10,'nullable' => True),
-                               'cfg_playsms_web' => array('type' => 'varchar', 
'precision' => 250,'nullable' => True)
+                               'cfg_phpgwsms_web' => array('type' => 
'varchar', 'precision' => 250,'nullable' => True)
                        ),
                        'pk' => array(),
                        'fk' => array(),
Index: sms/setup/tables_update.inc.php
diff -u sms/setup/tables_update.inc.php:1.4 sms/setup/tables_update.inc.php:1.5
--- sms/setup/tables_update.inc.php:1.4 Fri May 26 13:46:30 2006
+++ sms/setup/tables_update.inc.php     Mon May 29 07:57:41 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.4 2006/05/26 13:46:30 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.5 2006/05/29 07:57:41 
sigurdne Exp $
        */
 
        /**
@@ -138,29 +138,29 @@
                $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, 6, 
'text', 'phpgwsms_web', 'phpgwsms 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, 2, 1, 
'phpgwsms')");
                $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, 4, 1, 
'phpgwsms')");
                $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, 2, 1, 
'phpgwsms')");
                $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, 1, 1, 
'phpgwsms')");
                $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, 6, 1, 
'http://localhost/~phpgroupware/sms')");
                $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';




reply via email to

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