[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] sms inc/class.bosms.inc.php inc/class.sms.inc.p...
|
From: |
Sigurd Nes |
|
Subject: |
[Phpgroupware-cvs] sms inc/class.bosms.inc.php inc/class.sms.inc.p... |
|
Date: |
Thu, 18 May 2006 13:27:59 +0000 |
CVSROOT: /sources/phpgroupware
Module name: sms
Branch:
Changes by: Sigurd Nes <address@hidden> 06/05/18 13:27:59
Modified files:
inc : class.bosms.inc.php class.sms.inc.php
class.sosms.inc.php class.uisms.inc.php
hook_admin.inc.php
setup : default_records.inc.php tables_current.inc.php
templates/base : sms.xsl
Log message:
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/class.bosms.inc.php.diff?tr1=1.4&tr2=1.5&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/class.sms.inc.php.diff?tr1=1.5&tr2=1.6&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/class.sosms.inc.php.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/class.uisms.inc.php.diff?tr1=1.6&tr2=1.7&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/inc/hook_admin.inc.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.3&tr2=1.4&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/setup/tables_current.inc.php.diff?tr1=1.2&tr2=1.3&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/sms/templates/base/sms.xsl.diff?tr1=1.3&tr2=1.4&r1=text&r2=text
Patches:
Index: sms/inc/class.bosms.inc.php
diff -u sms/inc/class.bosms.inc.php:1.4 sms/inc/class.bosms.inc.php:1.5
--- sms/inc/class.bosms.inc.php:1.4 Thu May 18 09:48:38 2006
+++ sms/inc/class.bosms.inc.php Thu May 18 13:27:59 2006
@@ -8,7 +8,7 @@
* @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
* @package hrm
* @subpackage place
- * @version $Id: class.bosms.inc.php,v 1.4 2006/05/18 09:48:38 sigurdne
Exp $
+ * @version $Id: class.bosms.inc.php,v 1.5 2006/05/18 13:27:59 sigurdne
Exp $
*/
/**
@@ -24,6 +24,7 @@
var $sort;
var $order;
var $cat_id;
+ var $acl_location;
var $public_functions = array
(
@@ -114,11 +115,19 @@
$this->cat_id = $data['cat_id'];
}
+ function read_inbox()
+ {
+ $inbox = $this->so->read_inbox(array('start' =>
$this->start,'query' => $this->query,'sort' => $this->sort,'order' =>
$this->order,
+
'allrows'=>$this->allrows,'acl_location' =>$this->acl_location));
+ $this->total_records = $this->so->total_records;
+ return $inbox;
+ }
+
function read_outbox()
{
$outbox = $this->so->read_outbox(array('start' =>
$this->start,'query' => $this->query,'sort' => $this->sort,'order' =>
$this->order,
-
'allrows'=>$this->allrows));
+
'allrows'=>$this->allrows,'acl_location' =>$this->acl_location));
$this->total_records = $this->so->total_records;
return $outbox;
}
Index: sms/inc/class.sms.inc.php
diff -u sms/inc/class.sms.inc.php:1.5 sms/inc/class.sms.inc.php:1.6
--- sms/inc/class.sms.inc.php:1.5 Thu May 18 09:48:38 2006
+++ sms/inc/class.sms.inc.php Thu May 18 13:27:59 2006
@@ -8,7 +8,7 @@
* @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
* @package sms
* @subpackage sms
- * @version $Id: class.sms.inc.php,v 1.5 2006/05/18 09:48:38 sigurdne
Exp $
+ * @version $Id: class.sms.inc.php,v 1.6 2006/05/18 13:27:59 sigurdne
Exp $
*/
/**
@@ -1132,7 +1132,7 @@
{
$message .= " ".$array_target_user[$i];
}
- if
(insertsmstoinbox($sms_datetime,$sms_sender,$target_user,$message))
+ if
($this->insertsmstoinbox($sms_datetime,$sms_sender,$target_user,$message))
{
$ok = true;
}
@@ -1178,7 +1178,7 @@
$db_query = "SELECT board_id FROM
phpgw_sms_featboard WHERE board_code='$target_code'";
if ($db_result = dba_num_rows($db_query))
{
- if
(insertsmstodb($sms_datetime,$sms_sender,$target_code,$message))
+ if
($this->insertsmstodb($sms_datetime,$sms_sender,$target_code,$message))
{
$ok = true;
}
@@ -1187,7 +1187,7 @@
if (!$ok)
{
$message = $target_code." ".$message;
- if
(insertsmstoinbox($sms_datetime,$sms_sender,"admin",$message))
+ if
($this->insertsmstoinbox($sms_datetime,$sms_sender,"admin",$message))
{
$ok = true;
}
Index: sms/inc/class.sosms.inc.php
diff -u sms/inc/class.sosms.inc.php:1.2 sms/inc/class.sosms.inc.php:1.3
--- sms/inc/class.sosms.inc.php:1.2 Thu May 18 09:48:38 2006
+++ sms/inc/class.sosms.inc.php Thu May 18 13:27:59 2006
@@ -8,7 +8,7 @@
* @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
* @package hrm
* @subpackage place
- * @version $Id: class.sosms.inc.php,v 1.2 2006/05/18 09:48:38 sigurdne
Exp $
+ * @version $Id: class.sosms.inc.php,v 1.3 2006/05/18 13:27:59 sigurdne
Exp $
*/
/**
@@ -31,12 +31,100 @@
$this->db = clone($GLOBALS['phpgw']->db);
$this->db2 = clone($this->db);
- $this->grants =
$GLOBALS['phpgw']->acl->get_grants('sms');
$this->left_join = $this->db->left_join;
$this->join = $this->db->join;
$this->like = $this->db->like;
}
+ function read_inbox($data)
+ {
+ if(is_array($data))
+ {
+ if ($data['start'])
+ {
+ $start=$data['start'];
+ }
+ else
+ {
+ $start=0;
+ }
+ $query =
(isset($data['query'])?$data['query']:'');
+ $sort =
(isset($data['sort'])?$data['sort']:'DESC');
+ $order =
(isset($data['order'])?$data['order']:'');
+ $allrows =
(isset($data['allrows'])?$data['allrows']:'');
+ $acl_location =
(isset($data['acl_location'])?$data['acl_location']:'');
+ }
+
+ if($acl_location)
+ {
+ $grants =
$GLOBALS['phpgw']->acl->get_grants('sms',$acl_location);
+ }
+
+ if ($order)
+ {
+ $ordermethod = " ORDER BY $order $sort";
+
+ }
+ else
+ {
+ $ordermethod = ' ORDER BY in_id DESC';
+ }
+
+ $table = 'phpgw_sms_tbluserinbox';
+
+ $where= 'WHERE';
+
+ if (is_array($grants))
+ {
+ while (list($user) = each($grants))
+ {
+ $public_user_list[] = $user;
+ }
+ reset($public_user_list);
+ $filtermethod .= " $where ( $table.in_uid IN("
. implode(',',$public_user_list) . "))";
+
+ $where= 'AND';
+ }
+
+ if($query)
+ {
+ $query = ereg_replace("'",'',$query);
+ $query = ereg_replace('"','',$query);
+
+ $querymethod = " AND in_sender $this->like
'%$query%'";
+ }
+
+ $sql = "SELECT * FROM $table $filtermethod AND
in_hidden='0' $querymethod";
+
+ $this->db2->query($sql,__LINE__,__FILE__);
+ $this->total_records = $this->db2->num_rows();
+
+ if(!$allrows)
+ {
+ $this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
+ }
+ else
+ {
+ $this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
+ }
+
+ while ($this->db->next_record())
+ {
+ $inbox[] = array
+ (
+ 'id' =>
$this->db->f('in_id'),
+ 'sender' =>
stripslashes($this->db->f('in_sender')),
+ 'entry_time' =>
$this->db->f('in_datetime'),
+ 'message' =>
stripslashes($this->db->f('in_msg')),
+ 'user' =>
$GLOBALS['phpgw']->accounts->id2name($this->db->f('in_uid')),
+ 'grants' =>
(int)$this->grants[$this->db->f('uid')]
+ );
+
+ }
+
+ return $inbox;
+ }
+
function read_outbox($data)
{
if(is_array($data))
@@ -53,6 +141,12 @@
$sort =
(isset($data['sort'])?$data['sort']:'DESC');
$order =
(isset($data['order'])?$data['order']:'');
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
+ $acl_location =
(isset($data['acl_location'])?$data['acl_location']:'');
+ }
+
+ if($acl_location)
+ {
+ $grants =
$GLOBALS['phpgw']->acl->get_grants('sms',$acl_location);
}
if ($order)
@@ -70,9 +164,9 @@
$where= 'WHERE';
- if (is_array($this->grants))
+ if (is_array($grants))
{
- while (list($user) = each($this->grants))
+ while (list($user) = each($grants))
{
$public_user_list[] = $user;
}
@@ -125,7 +219,7 @@
'entry_time' =>
$this->db->f('p_datetime'),
'message' =>
stripslashes($this->db->f('p_msg')),
'status' =>
$status_array[$this->db->f('p_status')],
- 'grants' =>
(int)$this->grants[$this->db->f('uid')]
+ 'grants' =>
(int)$grants[$this->db->f('uid')]
);
}
Index: sms/inc/class.uisms.inc.php
diff -u sms/inc/class.uisms.inc.php:1.6 sms/inc/class.uisms.inc.php:1.7
--- sms/inc/class.uisms.inc.php:1.6 Thu May 18 09:48:38 2006
+++ sms/inc/class.uisms.inc.php Thu May 18 13:27:59 2006
@@ -8,7 +8,7 @@
* @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
* @package sms
* @subpackage sms
- * @version $Id: class.uisms.inc.php,v 1.6 2006/05/18 09:48:38 sigurdne
Exp $
+ * @version $Id: class.uisms.inc.php,v 1.7 2006/05/18 13:27:59 sigurdne
Exp $
*/
/**
@@ -75,26 +75,39 @@
$GLOBALS['phpgw']->xslttpl->add_file(array('sms','nextmatchs','menu',
'search_field'));
- $this->menu->sub='.inbox';
+ $acl_location = '.inbox';
+ $this->bo->acl_location = $acl_location;
+ $this->menu->sub = $acl_location;
$links = $this->menu->links();
- // $sms_info = $this->bo->read();
+ $sms_info = $this->bo->read_inbox();
while (is_array($sms_info) && list(,$entry) =
each($sms_info))
{
+
+
if($this->bocommon->check_perms($entry['grants'], PHPGW_ACL_DELETE))
+ {
+ $link_delete =
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uisms.delete_in&id='
. $entry['id']);
+ $text_delete =
lang('delete');
+ $lang_delete_sms_text = lang('delete
the sms from outbox');
+ }
+
$content[] = array
(
- 'name'
=> $entry['name'],
- 'link_edit'
=>
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uisms.edit&sms_id='
. $entry['id']),
- 'link_delete'
=>
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uisms.delete&sms_id='
. $entry['id']),
- 'link_view'
=>
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uisms.view&sms_id='
. $entry['id']),
- 'lang_view_place_text'
=> lang('view the place'),
- 'lang_edit_place_text'
=> lang('edit the place'),
- 'text_view'
=> lang('view'),
- 'text_edit'
=> lang('edit'),
- 'text_delete'
=> lang('delete'),
- 'lang_delete_place_text'
=> lang('delete the place'),
+ 'id'
=> $entry['id'],
+ 'sender'
=> $entry['sender'],
+ 'user'
=> $entry['user'],
+ 'message'
=> $entry['message'],
+ 'entry_time'
=> $entry['entry_time'],
+ 'link_delete'
=> $link_delete,
+ 'text_delete'
=> $text_delete,
+ 'lang_delete_sms_text'
=> $lang_delete_sms_text,
);
+
+ unset ($link_delete);
+ unset ($text_delete);
+ unset ($lang_delete_sms_text);
+
}
//_debug_array($content);
@@ -102,10 +115,10 @@
$table_header[] = array
(
- 'sort_name' =>
$this->nextmatchs->show_sort_order(array
+ 'sort_entry_time' =>
$this->nextmatchs->show_sort_order(array
(
'sort' => $this->sort,
-
'var' => 'name',
+
'var' => 'in_datetime',
'order' => $this->order,
'extra' => array('menuaction' =>
$this->currentapp.'.uisms.index',
'query' =>$this->query,
@@ -113,8 +126,11 @@
'allrows' => $this->allrows)
)),
'lang_delete' => lang('delete'),
- 'lang_edit' => lang('edit'),
- 'lang_view' => lang('view'),
+ 'lang_id' => lang('id'),
+ 'lang_user' => lang('user'),
+ 'lang_sender' => lang('sender'),
+ 'lang_entry_time'=> lang('time'),
+ 'lang_message' => lang('message'),
);
if(!$this->allrows)
@@ -158,25 +174,23 @@
'record_limit'
=> $record_limit,
'num_records'
=> count($place_info),
'all_records'
=> $this->bo->total_records,
- 'link_url'
=> $GLOBALS['phpgw']->link('/index.php',$link_data),
- 'img_path'
=> $GLOBALS['phpgw']->common->get_image_path('phpgwapi','default'),
- 'lang_searchfield_statustext' => lang('Enter
the search string. To show all entries, empty this field and press the SUBMIT
button again'),
- 'lang_searchbutton_statustext' => lang('Submit
the search string'),
- 'query'
=> $this->query,
+ 'link_url'
=> $GLOBALS['phpgw']->link('/index.php',$link_data),
+ 'img_path'
=> $GLOBALS['phpgw']->common->get_image_path('phpgwapi','default'),
+ 'lang_searchfield_statustext'
=> lang('Enter the search string. To show all entries, empty this field and
press the SUBMIT button again'),
+ 'lang_searchbutton_statustext'
=> lang('Submit the search string'),
+ 'query'
=> $this->query,
'lang_search'
=> lang('search'),
- 'table_header'
=> $table_header,
+ 'table_header_inbox'
=> $table_header,
'table_add'
=> $table_add,
- 'values'
=> $content
+ 'values_inbox'
=> $content
);
$appname =
lang('inbox');
$function_msg =
lang('list inbox');
$GLOBALS['phpgw_info']['flags']['app_header'] =
lang($this->currentapp) . ' - ' . $appname . ': ' . $function_msg;
-
$GLOBALS['phpgw']->xslttpl->set_var('phpgw',array('list' => $data));
+
$GLOBALS['phpgw']->xslttpl->set_var('phpgw',array('list_inbox' => $data));
$this->save_sessiondata();
-
-
}
@@ -184,7 +198,9 @@
{
$GLOBALS['phpgw']->xslttpl->add_file(array('sms','nextmatchs','menu',
'search_field'));
- $this->menu->sub='.outbox';
+ $acl_location = '.outbox';
+ $this->bo->acl_location = $acl_location;
+ $this->menu->sub = $acl_location;
$links = $this->menu->links();
$receipt =
$GLOBALS['phpgw']->session->appsession('session_data','sms_send_receipt');
@@ -194,6 +210,13 @@
while (is_array($sms_info) && list(,$entry) =
each($sms_info))
{
+
if($this->bocommon->check_perms($entry['grants'], PHPGW_ACL_DELETE))
+ {
+ $link_delete =
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uisms.delete_out&id='
. $entry['id']);
+ $text_delete =
lang('delete');
+ $lang_delete_sms_text = lang('delete
the sms from outbox');
+ }
+
$content[] = array
(
'id'
=> $entry['id'],
@@ -203,10 +226,15 @@
'dst_group'
=> $entry['dst_group'],
'entry_time'
=> $entry['entry_time'],
'status'
=> $entry['status'],
- 'link_delete'
=>
$GLOBALS['phpgw']->link('/index.php','menuaction='.$this->currentapp.'.uisms.delete_out&id='
. $entry['id']),
- 'text_delete'
=> lang('delete'),
- 'lang_delete_sms_text'
=> lang('delete the sms from outbox'),
+ 'link_delete'
=> $link_delete,
+ 'text_delete'
=> $text_delete,
+ 'lang_delete_sms_text'
=> $lang_delete_sms_text,
);
+
+ unset ($link_delete);
+ unset ($text_delete);
+ unset ($lang_delete_sms_text);
+
}
//_debug_array($content);
@@ -277,11 +305,11 @@
'all_records'
=> $this->bo->total_records,
'link_url'
=> $GLOBALS['phpgw']->link('/index.php',$link_data),
'img_path'
=> $GLOBALS['phpgw']->common->get_image_path('phpgwapi','default'),
- 'lang_searchfield_statustext' => lang('Enter
the search string. To show all entries, empty this field and press the SUBMIT
button again'),
- 'lang_searchbutton_statustext' => lang('Submit
the search string'),
+ 'lang_searchfield_statustext'
=> lang('Enter the search string. To show all entries, empty this field and
press the SUBMIT button again'),
+ 'lang_searchbutton_statustext'
=> lang('Submit the search string'),
'query'
=> $this->query,
'lang_search'
=> lang('search'),
- 'table_header_outbox'
=> $table_header,
+ 'table_header_outbox'
=> $table_header,
'table_add'
=> $table_add,
'values_outbox'
=> $content
);
Index: sms/inc/hook_admin.inc.php
diff -u sms/inc/hook_admin.inc.php:1.1.1.1 sms/inc/hook_admin.inc.php:1.2
--- sms/inc/hook_admin.inc.php:1.1.1.1 Mon May 15 10:29:23 2006
+++ sms/inc/hook_admin.inc.php Thu May 18 13:27:59 2006
@@ -8,13 +8,14 @@
* @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
* @package sms
* @subpackage admin
- * @version $Id: hook_admin.inc.php,v 1.1.1.1 2006/05/15 10:29:23
sigurdne Exp $
+ * @version $Id: hook_admin.inc.php,v 1.2 2006/05/18 13:27:59 sigurdne
Exp $
*/
{
$file = array
(
'Configuration' =>
$GLOBALS['phpgw']->link('/index.php','menuaction=admin.uiconfig.index&appname='
. $appname),
+ 'Configure Access Permissions'=>
$GLOBALS['phpgw']->link('/index.php','menuaction=preferences.uiadmin_acl.list_acl&acl_app='.$appname),
);
display_section($appname,$appname,$file);
}
Index: sms/setup/default_records.inc.php
diff -u sms/setup/default_records.inc.php:1.3
sms/setup/default_records.inc.php:1.4
--- sms/setup/default_records.inc.php:1.3 Thu May 18 09:48:38 2006
+++ sms/setup/default_records.inc.php Thu May 18 13:27:59 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.3 2006/05/18 09:48:38
sigurdne Exp $
+ * @version $Id: default_records.inc.php,v 1.4 2006/05/18 13:27:59
sigurdne Exp $
*/
@@ -17,236 +17,239 @@
* @package property
*/
-$GLOBALS['phpgw_setup']->oProc->query("DELETE from phpgw_config WHERE
config_app='sms'");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config (config_app,
config_name, config_value) VALUES ('sms','gnokii_cfg', '/usr/local')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config (config_app,
config_name, config_value) VALUES ('sms','email_service', 'address@hidden')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config (config_app,
config_name, config_value) VALUES ('sms','gateway_module', 'gnokii')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config (config_app,
config_name, config_value) VALUES ('sms','gateway_number', '+4790665164')");
-$reserved_codes = serialize(array
("PV","BC","GET","PUT","INFO","SAVE","DEL","LIST","RETR","POP3","SMTP","BROWSE","NEW","SET","POLL","VOTE","REGISTER","REG","DO","USE","EXECUTE","EXEC","RUN","ACK"));
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config (config_app,
config_name, config_value) VALUES ('sms','reserved_codes', '$reserved_codes')");
-
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featautoreply
(uid, autoreply_code) VALUES (1,'HELP')");
-
-$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,'INTERNET','DOWN','','','','','','Please contact sysadmin via phone:
+62 21 8613027')");
-$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_featcustom
(uid,custom_code,custom_url) VALUES
(1,'CURR','http://www.ngoprek.org/currency.php?toeuro=##CUSTOMPARAM##&sender=##SMSSENDER##')");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featpoll
(uid,poll_title,poll_code,poll_enable) VALUES (1,'Which do you prefer
?','PREFER',1)");
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featpoll_choice
(poll_id,choice_title,choice_code) VALUES (1,'Love Without Sex','LWS')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featpoll_choice
(poll_id,choice_title,choice_code) VALUES (1,'Sex Without Love','SWL')");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodclickatell_config
(cfg_name,cfg_api_id,cfg_username,cfg_password,cfg_sender,cfg_send_url,cfg_incoming_path,cfg_credit)
VALUES
('clickatell','123456','playsms','pwd','PlaySMS','http://api.clickatell.com/http','/usr/local',10)");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodTemplate_config (cfg_name,cfg_path) VALUES
('template','/usr/local')");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_gwmodUplink
(up_local_slid,up_remote_slid,up_status) VALUES (3,259,1)");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodUplink_config
(cfg_name,cfg_master,cfg_username,cfg_password,cfg_global_sender,cfg_incoming_path)
VALUES
('uplink','http://cpanel.smsrakyat.net','playsms','pwd','','/usr/local')");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodgnokii_config (cfg_name, cfg_path) VALUES ('gnokii',
'/usr/local')");
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodkannel_config (cfg_name, cfg_incoming_path, cfg_username,
cfg_password, cfg_global_sender, cfg_bearerbox_host, cfg_sendsms_port,
cfg_playsms_web) VALUES ('kannel', '/usr/local', 'playsms', 'pwd', '92824',
'127.0.0.1', '13131', 'http://localhost/~playsms')");
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tblconfig_main
(cfg_web_title, cfg_email_service, cfg_email_footer, cfg_gateway_module,
cfg_gateway_number) VALUES ('PlaySMS MPS (Mobile Portal System)',
'address@hidden', 'PlaySMS MPS (Mobile Portal System)', 'gnokii', '')");
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tblsmsoutgoing (
flag_deleted, uid, p_gateway, p_src, p_dst, p_footer, p_msg, p_datetime,
p_status, p_gpid, p_credit, p_sms_type, unicode) VALUES ( 0, 1, 'gnokii',
'+628568809027', '+628562283138', ' - anton', 'Hi u there, good morning!!',
'2004-12-12 2:39:13', 0, 0, 0, 'text', 0)");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tblsmsoutgoing (
flag_deleted, uid, p_gateway, p_src, p_dst, p_footer, p_msg, p_datetime,
p_status, p_gpid, p_credit, p_sms_type, unicode) VALUES ( 0, 1, 'gnokii',
'+628568809027', '+628562205510', ' - anton', 'Hi u there, good morning!!',
'2004-12-12 2:39:13', 0, 0, 0, 'text', 0)");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tblsmsoutgoing (
flag_deleted, uid, p_gateway, p_src, p_dst, p_footer, p_msg, p_datetime,
p_update, p_status, p_gpid, p_credit, p_sms_type, unicode) VALUES ( 0, 1,
'uplink', '+628568809027', '+628568809027', '- anton', 'Hello my dear me,
testing testing the message', '2004-12-12 2:54:12', '2004-12-12 2:55:11', 1, 0,
0, 'text', 0)");
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tblsmstemplate (
uid, t_title, t_text) VALUES ( 1, 'Good morning', 'Hi u there, good
morning!!')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tblsmstemplate (
uid, t_title, t_text) VALUES ( 1, 'Good night have a sweet dream', 'Hi
sweetheart, good night and have a sweet dream :*')");
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser ( status,
ticket, username, password, name, mobile, email, sender, dailysms, gender, age,
address, city, state, country, birthday, marital, education, zipcode,
junktimestamp) VALUES (2, 'd0b3239a5da9504a1a38f7745790c3c4', 'admin', 'admin',
'Administrator', '+628568809027', 'address@hidden', '- anton', 0, 1, 0, 'Jl.
Pangkalan Jati II no. 19 Kalimalang', 'Jakarta Timur', 'DKI Jakarta', 132,
'1979-02-14', 1, 1, '13620', '1102793982')");
-
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (1, 'Afghanistan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (2, 'Albania')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (3, 'Algeria')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (5, 'Andorra')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (10, 'Argentina')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (11, 'Armenia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (14, 'Australia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (16, 'Austria')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (18, 'Azerbaijan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (19, 'Bahamas')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (20, 'Bahrain')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (21, 'Bangladesh')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (24, 'Belarus')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (25, 'Belgium')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (29, 'Bermuda')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (30, 'Bhutan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (31, 'Bolivia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (32, 'Bosnia-Herzegovina')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (33, 'Botswana')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (35, 'Brazil')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (38, 'Brunei')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (39, 'Bulgaria')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (41, 'Burundi')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (42, 'Cambodia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (44, 'Cameroon')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (45, 'Canada')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (51, 'Chile')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (52, 'China')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (55, 'Columbia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (58, 'Congo')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (60, 'Costa Rica')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (61, 'Croatia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (62, 'Cuba')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (66, 'Czech Republic')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (67, 'Denmark')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (74, 'East Timor')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (76, 'Ecuador')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (77, 'Egypt')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (78, 'El Salvador')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (81, 'Estonia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (84, 'Fiji Islands')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (85, 'Finland')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (86, 'France')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (93, 'Gabon')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (94, 'Gambia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (96, 'Germany')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (98, 'Ghana')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (100, 'Greece')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (105, 'Guam')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (107, 'Guatemala')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (108, 'UK')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (111, 'Guyana')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (112, 'Haiti')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (113, 'Honduras')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (114, 'HongKong')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (118, 'Hungary')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (120, 'Iceland')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (121, 'India')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (132, 'Indonesia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (139, 'Iran')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (140, 'Iraq')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (141, 'Ireland')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (143, 'Israel')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (144, 'Italy')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (146, 'Ivory Coast')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (147, 'Jamaica')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (148, 'Japan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (150, 'Jordan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (151, 'Kazakhstan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (153, 'Kenya')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (155, 'Korea (South)')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (156, 'Korea (North)')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (157, 'Kuwait')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (158, 'Kyrgyzstan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (160, 'Latvia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (161, 'Lebanon')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (163, 'Liberia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (164, 'Libya')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (166, 'Lithuania')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (167, 'Luxembourg')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (170, 'Macedonia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (171, 'Malawi')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (173, 'Malaysia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (175, 'Maldives')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (177, 'Mali Republic')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (178, 'Malta')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (181, 'Mauritania')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (184, 'Mexico')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (186, 'Moldova')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (188, 'Mongolia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (189, 'Montserrat')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (190, 'Morocco')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (192, 'Mozambique')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (193, 'Myanmar')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (194, 'Namibia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (196, 'Nepal')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (197, 'Netherlands')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (201, 'New Zealand')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (202, 'Nicaragua')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (203, 'Niger')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (204, 'Nigeria')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (208, 'Norway')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (209, 'Oman')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (210, 'Pakistan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (211, 'Palau')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (212, 'Palestine')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (213, 'Panama')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (214, 'Papua New Guinea')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (215, 'Paraguay')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (216, 'Peru')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (217, 'Philippines')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (220, 'Poland')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (223, 'Portugal')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (225, 'Puerto Rico')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (226, 'Qatar')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (228, 'Romania')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (229, 'Russia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (232, 'Rwanda')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (238, 'Samoa')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (241, 'Saudi Arabia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (242, 'Senegal')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (244, 'Sierra Leone')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (245, 'Singapore')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (248, 'Slovakia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (249, 'Slovenia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (251, 'Somalia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (252, 'South Africa')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (253, 'Spain')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (256, 'Sri Lanka')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (257, 'Sudan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (258, 'Suriname')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (259, 'Swaziland')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (260, 'Sweden')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (262, 'Switzerland')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (263, 'Syria')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (264, 'Taiwan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (267, 'Tajikistan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (268, 'Tanzania')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (269, 'Thailand')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (274, 'Trinidad and Tobago')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (275, 'Tunisia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (276, 'Turkey')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (277, 'Turkmenistan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (279, 'Tuvalu')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (280, 'Uganda')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (281, 'Ukraine')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (284, 'USA')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (289, 'United Arab Emirates')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (290, 'Uruguay')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (291, 'Uzbekistan')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (293, 'Vatican City State')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (294, 'Venezuela')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (295, 'Vietnam')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (299, 'Yemen')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (300, 'Yugoslavia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (303, 'Zambia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (305, 'Zimbabwe')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (312, 'Ethiopia')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (314, 'South Korea')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (318, 'Angola')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (319, 'Aruba')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (320, 'Laos')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (325, 'Serbia & Montenegro (Yugoslavia)')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (332, 'Jersey')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser_country
(country_id, country_name) VALUES (334, 'OTHER (unlisted)')");
-
-
-$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, '+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')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluserphonebook
( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1, '+628568809027', 'My Self',
'address@hidden')");
+ $GLOBALS['phpgw_setup']->oProc->query("DELETE from phpgw_acl_location
WHERE appname ='sms'");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_acl_location
(appname,id, descr) VALUES ('sms', '.', 'Top')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_acl_location
(appname,id, descr, allow_grant) VALUES ('sms', '.inbox', 'InBox',1)");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_acl_location
(appname,id, descr, allow_grant) VALUES ('sms', '.outbox', 'OutBox',1)");
+
+ $GLOBALS['phpgw_setup']->oProc->query("DELETE from phpgw_config WHERE
config_app='sms'");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config
(config_app, config_name, config_value) VALUES ('sms','gnokii_cfg',
'/usr/local')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config
(config_app, config_name, config_value) VALUES ('sms','email_service',
'address@hidden')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config
(config_app, config_name, config_value) VALUES ('sms','gateway_module',
'gnokii')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config
(config_app, config_name, config_value) VALUES ('sms','gateway_number',
'+4790665164')");
+ $reserved_codes = serialize(array
("PV","BC","GET","PUT","INFO","SAVE","DEL","LIST","RETR","POP3","SMTP","BROWSE","NEW","SET","POLL","VOTE","REGISTER","REG","DO","USE","EXECUTE","EXEC","RUN","ACK"));
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_config
(config_app, config_name, config_value) VALUES ('sms','reserved_codes',
'$reserved_codes')");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_featautoreply (uid, autoreply_code) VALUES (1,'HELP')");
+
+ $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,'INTERNET','DOWN','','','','','','Please contact sysadmin via phone:
+62 21 8613027')");
+ $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_featcustom
(uid,custom_code,custom_url) VALUES
(1,'CURR','http://www.ngoprek.org/currency.php?toeuro=##CUSTOMPARAM##&sender=##SMSSENDER##')");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_featpoll
(uid,poll_title,poll_code,poll_enable) VALUES (1,'Which do you prefer
?','PREFER',1)");
+
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_featpoll_choice (poll_id,choice_title,choice_code) VALUES (1,'Love
Without Sex','LWS')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_featpoll_choice (poll_id,choice_title,choice_code) VALUES (1,'Sex
Without Love','SWL')");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodclickatell_config
(cfg_name,cfg_api_id,cfg_username,cfg_password,cfg_sender,cfg_send_url,cfg_incoming_path,cfg_credit)
VALUES
('clickatell','123456','playsms','pwd','PlaySMS','http://api.clickatell.com/http','/usr/local',10)");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodTemplate_config (cfg_name,cfg_path) VALUES
('template','/usr/local')");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodUplink (up_local_slid,up_remote_slid,up_status) VALUES
(3,259,1)");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodUplink_config
(cfg_name,cfg_master,cfg_username,cfg_password,cfg_global_sender,cfg_incoming_path)
VALUES
('uplink','http://cpanel.smsrakyat.net','playsms','pwd','','/usr/local')");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodgnokii_config (cfg_name, cfg_path) VALUES ('gnokii',
'/usr/local')");
+
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_gwmodkannel_config (cfg_name, cfg_incoming_path, cfg_username,
cfg_password, cfg_global_sender, cfg_bearerbox_host, cfg_sendsms_port,
cfg_playsms_web) VALUES ('kannel', '/usr/local', 'playsms', 'pwd', '92824',
'127.0.0.1', '13131', 'http://localhost/~playsms')");
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tblconfig_main (cfg_web_title, cfg_email_service, cfg_email_footer,
cfg_gateway_module, cfg_gateway_number) VALUES ('PlaySMS MPS (Mobile Portal
System)', 'address@hidden', 'PlaySMS MPS (Mobile Portal System)', 'gnokii',
'')");
+
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tblsmsoutgoing ( flag_deleted, uid, p_gateway, p_src, p_dst,
p_footer, p_msg, p_datetime, p_status, p_gpid, p_credit, p_sms_type, unicode)
VALUES ( 0, 1, 'gnokii', '+628568809027', '+628562283138', ' - anton', 'Hi u
there, good morning!!', '2004-12-12 2:39:13', 0, 0, 0, 'text', 0)");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tblsmsoutgoing ( flag_deleted, uid, p_gateway, p_src, p_dst,
p_footer, p_msg, p_datetime, p_status, p_gpid, p_credit, p_sms_type, unicode)
VALUES ( 0, 1, 'gnokii', '+628568809027', '+628562205510', ' - anton', 'Hi u
there, good morning!!', '2004-12-12 2:39:13', 0, 0, 0, 'text', 0)");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tblsmsoutgoing ( flag_deleted, uid, p_gateway, p_src, p_dst,
p_footer, p_msg, p_datetime, p_update, p_status, p_gpid, p_credit, p_sms_type,
unicode) VALUES ( 0, 1, 'uplink', '+628568809027', '+628568809027', '- anton',
'Hello my dear me, testing testing the message', '2004-12-12 2:54:12',
'2004-12-12 2:55:11', 1, 0, 0, 'text', 0)");
+
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tblsmstemplate ( uid, t_title, t_text) VALUES ( 1, 'Good morning',
'Hi u there, good morning!!')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tblsmstemplate ( uid, t_title, t_text) VALUES ( 1, 'Good night have a
sweet dream', 'Hi sweetheart, good night and have a sweet dream :*')");
+
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_sms_tbluser (
status, ticket, username, password, name, mobile, email, sender, dailysms,
gender, age, address, city, state, country, birthday, marital, education,
zipcode, junktimestamp) VALUES (2, 'd0b3239a5da9504a1a38f7745790c3c4', 'admin',
'admin', 'Administrator', '+628568809027', 'address@hidden', '- anton', 0, 1,
0, 'Jl. Pangkalan Jati II no. 19 Kalimalang', 'Jakarta Timur', 'DKI Jakarta',
132, '1979-02-14', 1, 1, '13620', '1102793982')");
+
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (1,
'Afghanistan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (2, 'Albania')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (3, 'Algeria')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (5, 'Andorra')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (10, 'Argentina')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (11, 'Armenia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (14, 'Australia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (16, 'Austria')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (18,
'Azerbaijan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (19, 'Bahamas')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (20, 'Bahrain')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (21,
'Bangladesh')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (24, 'Belarus')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (25, 'Belgium')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (29, 'Bermuda')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (30, 'Bhutan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (31, 'Bolivia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (32,
'Bosnia-Herzegovina')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (33, 'Botswana')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (35, 'Brazil')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (38, 'Brunei')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (39, 'Bulgaria')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (41, 'Burundi')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (42, 'Cambodia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (44, 'Cameroon')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (45, 'Canada')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (51, 'Chile')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (52, 'China')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (55, 'Columbia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (58, 'Congo')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (60, 'Costa
Rica')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (61, 'Croatia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (62, 'Cuba')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (66, 'Czech
Republic')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (67, 'Denmark')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (74, 'East
Timor')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (76, 'Ecuador')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (77, 'Egypt')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (78, 'El
Salvador')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (81, 'Estonia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (84, 'Fiji
Islands')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (85, 'Finland')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (86, 'France')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (93, 'Gabon')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (94, 'Gambia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (96, 'Germany')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (98, 'Ghana')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (100, 'Greece')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (105, 'Guam')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (107,
'Guatemala')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (108, 'UK')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (111, 'Guyana')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (112, 'Haiti')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (113, 'Honduras')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (114, 'HongKong')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (118, 'Hungary')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (120, 'Iceland')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (121, 'India')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (132,
'Indonesia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (139, 'Iran')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (140, 'Iraq')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (141, 'Ireland')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (143, 'Israel')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (144, 'Italy')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (146, 'Ivory
Coast')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (147, 'Jamaica')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (148, 'Japan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (150, 'Jordan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (151,
'Kazakhstan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (153, 'Kenya')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (155, 'Korea
(South)')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (156, 'Korea
(North)')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (157, 'Kuwait')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (158,
'Kyrgyzstan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (160, 'Latvia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (161, 'Lebanon')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (163, 'Liberia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (164, 'Libya')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (166,
'Lithuania')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (167,
'Luxembourg')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (170,
'Macedonia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (171, 'Malawi')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (173, 'Malaysia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (175, 'Maldives')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (177, 'Mali
Republic')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (178, 'Malta')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (181,
'Mauritania')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (184, 'Mexico')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (186, 'Moldova')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (188, 'Mongolia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (189,
'Montserrat')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (190, 'Morocco')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (192,
'Mozambique')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (193, 'Myanmar')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (194, 'Namibia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (196, 'Nepal')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (197,
'Netherlands')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (201, 'New
Zealand')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (202,
'Nicaragua')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (203, 'Niger')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (204, 'Nigeria')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (208, 'Norway')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (209, 'Oman')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (210, 'Pakistan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (211, 'Palau')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (212,
'Palestine')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (213, 'Panama')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (214, 'Papua New
Guinea')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (215, 'Paraguay')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (216, 'Peru')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (217,
'Philippines')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (220, 'Poland')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (223, 'Portugal')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (225, 'Puerto
Rico')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (226, 'Qatar')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (228, 'Romania')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (229, 'Russia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (232, 'Rwanda')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (238, 'Samoa')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (241, 'Saudi
Arabia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (242, 'Senegal')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (244, 'Sierra
Leone')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (245,
'Singapore')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (248, 'Slovakia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (249, 'Slovenia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (251, 'Somalia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (252, 'South
Africa')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (253, 'Spain')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (256, 'Sri
Lanka')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (257, 'Sudan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (258, 'Suriname')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (259,
'Swaziland')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (260, 'Sweden')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (262,
'Switzerland')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (263, 'Syria')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (264, 'Taiwan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (267,
'Tajikistan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (268, 'Tanzania')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (269, 'Thailand')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (274, 'Trinidad and
Tobago')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (275, 'Tunisia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (276, 'Turkey')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (277,
'Turkmenistan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (279, 'Tuvalu')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (280, 'Uganda')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (281, 'Ukraine')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (284, 'USA')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (289, 'United Arab
Emirates')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (290, 'Uruguay')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (291,
'Uzbekistan')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (293, 'Vatican City
State')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (294,
'Venezuela')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (295, 'Vietnam')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (299, 'Yemen')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (300,
'Yugoslavia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (303, 'Zambia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (305, 'Zimbabwe')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (312, 'Ethiopia')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (314, 'South
Korea')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (318, 'Angola')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (319, 'Aruba')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (320, 'Laos')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (325, 'Serbia &
Montenegro (Yugoslavia)')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (332, 'Jersey')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluser_country (country_id, country_name) VALUES (334, 'OTHER
(unlisted)')");
+
+
+ $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,
'+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')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
phpgw_sms_tbluserphonebook ( gpid, uid, p_num, p_desc, p_email) VALUES ( 1, 1,
'+628568809027', 'My Self', 'address@hidden')");
Index: sms/setup/tables_current.inc.php
diff -u sms/setup/tables_current.inc.php:1.2
sms/setup/tables_current.inc.php:1.3
--- sms/setup/tables_current.inc.php:1.2 Wed May 17 20:23:25 2006
+++ sms/setup/tables_current.inc.php Thu May 18 13:27:59 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.2 2006/05/17 20:23:25
sigurdne Exp $
+ * @version $Id: tables_current.inc.php,v 1.3 2006/05/18 13:27:59
sigurdne Exp $
*/
@@ -295,7 +295,7 @@
'in_masked' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'in_code' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'in_msg' => array('type' => 'varchar',
'precision' => 200,'nullable' => False),
- 'in_datetime' => array('type' => 'varchar',
'precision' => 20,'nullable' => False,'default' => '0000-00-00 00:00:00')
+ 'in_datetime' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('in_id'),
'fk' => array(),
@@ -401,7 +401,7 @@
'in_sender' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
'in_uid' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
'in_msg' => array('type' => 'varchar',
'precision' => 200,'nullable' => False),
- 'in_datetime' => array('type' => 'varchar',
'precision' => 20,'nullable' => False,'default' => '0000-00-00 00:00:00'),
+ 'in_datetime' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'in_hidden' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0')
),
'pk' => array('in_id'),
Index: sms/templates/base/sms.xsl
diff -u sms/templates/base/sms.xsl:1.3 sms/templates/base/sms.xsl:1.4
--- sms/templates/base/sms.xsl:1.3 Thu May 18 09:48:38 2006
+++ sms/templates/base/sms.xsl Thu May 18 13:27:59 2006
@@ -1,4 +1,4 @@
-<!-- $Id: sms.xsl,v 1.3 2006/05/18 09:48:38 sigurdne Exp $ -->
+<!-- $Id: sms.xsl,v 1.4 2006/05/18 13:27:59 sigurdne Exp $ -->
<xsl:template name="app_data">
<xsl:choose>
@@ -12,12 +12,12 @@
<xsl:apply-templates select="list_outbox"/>
</xsl:when>
<xsl:otherwise>
- <xsl:apply-templates select="list"/>
+ <xsl:apply-templates select="list_inbox"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
- <xsl:template match="list">
+ <xsl:template match="list_inbox">
<xsl:call-template name="menu"/>
<table width="100%" cellpadding="2" cellspacing="2"
align="center">
@@ -44,23 +44,32 @@
</tr>
</table>
<table width="100%" cellpadding="2" cellspacing="2"
align="center">
- <xsl:apply-templates select="table_header"/>
- <xsl:apply-templates select="values"/>
+ <xsl:apply-templates
select="table_header_inbox"/>
+ <xsl:apply-templates select="values_inbox"/>
<xsl:apply-templates select="table_add"/>
</table>
</xsl:template>
- <xsl:template match="table_header">
- <xsl:variable name="sort_name"><xsl:value-of
select="sort_name"/></xsl:variable>
+ <xsl:template match="table_header_inbox">
+ <xsl:variable name="sort_entry_time"><xsl:value-of
select="sort_entry_time"/></xsl:variable>
<tr class="th">
- <td class="th_text" width="10%" align="left">
- <a href="{$sort_name}"><xsl:value-of
select="lang_name"/></a>
+ <td class="th_text" width="1%" align="right">
+ <xsl:value-of select="lang_id"/>
</td>
- <td class="th_text" width="5%" align="center">
- <xsl:value-of select="lang_edit"/>
+ <td class="th_text" width="1%" align="right">
+ <xsl:value-of select="lang_user"/>
</td>
+
<td class="th_text" width="5%" align="center">
- <xsl:value-of select="lang_view"/>
+ <xsl:value-of select="lang_sender"/>
+ </td>
+
+ <td class="th_text" width="10%" align="center">
+ <a href="{$sort_entry_time}"><xsl:value-of
select="lang_entry_time"/></a>
+ </td>
+
+ <td class="th_text" width="50%" align="center">
+ <xsl:value-of select="lang_message"/>
</td>
<td class="th_text" width="5%" align="center">
<xsl:value-of select="lang_delete"/>
@@ -68,10 +77,8 @@
</tr>
</xsl:template>
- <xsl:template match="values">
- <xsl:variable name="lang_view_place_text"><xsl:value-of
select="lang_view_place_text"/></xsl:variable>
- <xsl:variable name="lang_edit_place_text"><xsl:value-of
select="lang_edit_place_text"/></xsl:variable>
- <xsl:variable name="lang_delete_place_text"><xsl:value-of
select="lang_delete_place_text"/></xsl:variable>
+ <xsl:template match="values_inbox">
+ <xsl:variable name="lang_delete_sms_text"><xsl:value-of
select="lang_delete_place_text"/></xsl:variable>
<tr>
<xsl:attribute name="class">
@@ -88,26 +95,31 @@
</xsl:choose>
</xsl:attribute>
- <td align="left">
- <xsl:value-of select="name"/>
+ <td align="right">
+ <xsl:value-of select="id"/>
</td>
- <td align="center">
- <xsl:variable
name="link_edit"><xsl:value-of select="link_edit"/></xsl:variable>
- <a href="{$link_edit}"
onMouseover="window.status='{$lang_edit_place_text}';return true;"
onMouseout="window.status='';return true;"><xsl:value-of
select="text_edit"/></a>
+ <td align="right">
+ <xsl:value-of select="user"/>
</td>
- <td align="center">
- <xsl:variable
name="link_view"><xsl:value-of select="link_view"/></xsl:variable>
- <a href="{$link_view}"
onMouseover="window.status='{$lang_view_place_text}';return true;"
onMouseout="window.status='';return true;"><xsl:value-of
select="text_view"/></a>
+ <td align="right">
+ <xsl:value-of select="sender"/>
+ </td>
+
+ <td align="right">
+ <xsl:value-of select="entry_time"/>
+ </td>
+ <td align="left">
+ <xsl:value-of select="message"/>
</td>
+
<td align="center">
<xsl:variable
name="link_delete"><xsl:value-of select="link_delete"/></xsl:variable>
- <a href="{$link_delete}"
onMouseover="window.status='{$lang_delete_place_text}';return true;"
onMouseout="window.status='';return true;"><xsl:value-of
select="text_delete"/></a>
+ <a href="{$link_delete}"
onMouseover="window.status='{$lang_delete_sms_text}';return true;"
onMouseout="window.status='';return true;"><xsl:value-of
select="text_delete"/></a>
</td>
</tr>
</xsl:template>
<xsl:template match="list_outbox">
-
<xsl:call-template name="menu"/>
<table width="100%" cellpadding="2" cellspacing="2"
align="center">
<xsl:choose>
@@ -145,6 +157,9 @@
<td class="th_text" width="1%" align="right">
<xsl:value-of select="lang_id"/>
</td>
+ <td class="th_text" width="1%" align="right">
+ <xsl:value-of select="lang_user"/>
+ </td>
<td class="th_text" width="10%" align="center">
<a href="{$sort_entry_time}"><xsl:value-of
select="lang_entry_time"/></a>
@@ -190,6 +205,9 @@
<td align="right">
<xsl:value-of select="id"/>
</td>
+ <td align="right">
+ <xsl:value-of select="user"/>
+ </td>
<td align="right">
<xsl:value-of select="entry_time"/>