System information

For unified pricing you can use the “smsprice” and the “smstime”. (in this case all sms messages will be billed with the same price, regardless of the
destination)
Otherwise the pricing can be set on the “Price Setup” form the same way as for voice calls. The only difference is that all SMS messages appear with 60 sec
duration.
Unicode messages are supported.
If you wish to route to SMS messages to multiple providers then you should follow the following steps:
-set the smsrouting global config option to 1
-add SMS GW users
-setup the routing
-setup billing
You might also have to run this statement to upgrade old db versions:
insert into tb_dirtypes (id,name) values (6,'SMS GW')
5.97. Working with groups using direct SQL
Open “Direcy Query” from MizuManage or MS SQL Management Studio.
--check related tables
select top 1000 * from tb_groups
select top 1000 * from tb_grouptypes
select top 1000 * from tb_groupentries
select * from tb_groups, tb_groupentries, tb_grouptypes
where tb_groupentries.groupid = tb_groups.id and tb_groupentries.entrytype = tb_grouptypes.dirid
--create a new group
insert into tb_groups (name) values ('testgroup')
--add 1 user to the new group (by id)
insert into tb_groupentries (groupid,entrytype,entryid) values
(
(select id from tb_groups where name = 'testgroup'), --group id instered previously
1, --entry type. 1 means "endusers" (values from tb_grouptypes.dirid)
100207 --id from tb_users
)
--add all users to this group which username contains "111"
insert into tb_groupentries (groupid,entrytype,entryid)
select