|
|
| SMS Server Tools 3 Community |
| Welcome, Guest. The forum is currently read-only, but will open soon. |
Tue Jul 01, 2025 01:57 |
Page: 1
| Keywords: Mode: All keywords (AND) |
|
Mon Mar 21, 2011 11:28
|
|
|
|
Sun Mar 20, 2011 18:43
|
andre-sms: How it looks like that? In what version of smsd?
For me, It looks like there are more moments that a modem process stops, like after a sms is send?!? :shock: so the "stop = modem command" is executed menny times in the current smsd session.
By the way flipper-machine is a "Pinball-machine" :oops:
But if the stop command is only triggered when smsd stops, it will be use full for me :? .
Command is sent when process is stopping, and when process goes to "suspend" state. If suspend feature is used, usually start string should be defined too. But with AT^SMSO suspend cannot be used, because the modem is powered down.
I'm not interested suspend mode only power-down or shutdown.
My sms-system is not running 24/7, it is just a hobby.
Think Green and save energy. :mrgreen:
|
|
Sun Mar 20, 2011 15:31
|
andre-sms: Corrected missing Sender field in database by "FAILED" or "SENT" ;)
#!/bin/bash
# This is an example script that logs all events into an SQL database
# You need a MYSQL database as described in the documentation.
# Please read the documentation before using this script.
SQL_HOST=localhost
SQL_USER=root
SQL_PASSWORD="XxXxXx"
SQL_DATABASE=smsd
SQL_TABLE=sms_log
DATE=`date +"%Y-%m-%d %H:%M:%S"`
#Extract data from the SMS file
FROM=`formail -zx From: < $2 | sed 's/"//g'`
#Extra line for populating "Send" field in case of "FAILED" or "SENT"
MODEM=`formail -zx Modem: < $2 | sed 's/"//g'`
TO=`formail -zx To: < $2`
#Remove plus sign, spaces, minus and short number prefix
TO=`echo "$TO" | sed 's/ //g' | sed 's/+//g' | sed 's/s//g' | sed 's/-//g'`
SUBJECT=`formail -zx Subject: < $2`
SENT=`formail -zx Sent: < $2`
TEXT=`sed -e '1,/^$/ d' < $2`
TEXTSQL=$(echo "$TEXT" | sed 's/\\/\\\\/g' | sed 's/\"/\\\"/g')
#Set some SQL parameters
if [ "$SQL_PASSWORD" != "" ]; then
SQL_ARGS="-p$SQL_PASSWORD";
else
SQL_ARGS="";
fi
SQL_ARGS="-h $SQL_HOST -u $SQL_USER $SQL_ARGS -D $SQL_DATABASE -s -e"
#Insert a new entry into the SQL table
if [ "$1" = "FAILED" ] || [ "$1" = "SENT" ]; then
mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,sender,receiver,msgid,text) values (\"$1\",\"$DATE\",\"$MODEM\",\"$TO\",\"$3\",\"$TEXTSQL\");";
elif [ "$1" = "RECEIVED" ]; then
mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,received,sender,receiver,text) values (\"RECEIVED\",\"$SENT\",\"$DATE\",\"$FROM\",\"$SUBJECT\",\"$TEXTSQL\");";
elif [ "$1" = "REPORT" ]; then
#Extract more data from the status report file
DISCHARGE=`sed -e 1,/SMS\ STATUS/d < $2 | formail -zx Discharge_timestamp:`
MSGID=`sed -e 1,/SMS\ STATUS/d < $2 | formail -zx Message_id:`
STATUS=`sed -e 1,/SMS\ STATUS/d < $2 | formail -zx Status: | cut -f1 -d,`
if [ "$MSGID" != "" ]; then
ID=`mysql $SQL_ARGS "select id from $SQL_TABLE where receiver=\"$FROM\" and type=\"SENT\" and msgid=\"$MSGID\" order by id desc limit 1;"`
mysql $SQL_ARGS "update $SQL_TABLE set received=\"$DISCHARGE\",status=\"$STATUS\" where id=\"$ID\";"
fi
fi
|
|
Sun Mar 20, 2011 15:16
|
andre-sms: But it looks like there are many moments that will trigger a stop = modem command.
I only want a shutdown command if smsd or when my Server-PC shutdown.
The "stop modem command" will turn the modem into a flipper-machine, to my understanding :shock:
|
|
Sun Mar 20, 2011 14:04
|
andre-sms: Hi folks.
I'm looking for a way the power-down my MC35 and TC35i Terminals gracefully when I shutdown the Server-PC or smsd.
I know the is a AT command (AT^SMSO Power down GSM engine).
Maybe a counterpart of pre-init?
|
|
Mon Jan 17, 2011 17:49
|
andre-sms: Dear KeKe,
Thanks for the post, it works fine.
Best regards,
André
|
|
Mon Jan 17, 2011 14:38
|
andre-sms: Operating system name and version: Ubuntu Linux 10.04.1
Version of smsd: 3.1.11
Smsd installed from: sources
Name and model of a modem / phone: Nokia 6310i
Interface: serial
Dear KeKe,
I like to sent an sms to a voice caller in case of an "Unexpected input: RING".
Copy of the config:
devices = 6310i
#checked = /var/spool/sms/checked #Is a Default value:
#incoming = /var/spool/sms/incoming #Is a Default value:
#outgoing = /var/spool/sms/outgoing #Is a Default value:
failed = /var/spool/sms/failed
sent = /var/spool/sms/sent
logfile = /var/log/smsd.log
loglevel = 5
stats = /var/log/smsd_stats
stats_interval = 3600
stats_no_zeroes = no
blacklist = /etc/smsd.black
hangup_incoming_call = yes
eventhandler = /home/andre/smstools3/scripts/mysmsd-v2
alarmlevel = 7
alarmhandler = /home/andre/smstools3/scripts/alarmhandler
[6310i]
device = /dev/ttyS0
incoming = yes
mode = new
rtscts = yes
baudrate = 19200
Logfile /var/log/smsd.log entry:
2011-01-17 15:30:04,5, 6310i: Ending incoming call: RING RING
2011-01-17 15:30:04,3, 6310i: Unexpected input: RING RING
2011-01-17 15:29:40,5, 6310i: IMSI: 351550002735768
2011-01-17 15:29:36,5, smsd: Outgoing file checker has started. PID: 2447.
2011-01-17 15:29:36,5, 6310i: Using check_memory_method 1: CPMS is used.
2011-01-17 15:29:36,5, 6310i: Modem handler 0 has started. PID: 2449.
2011-01-17 15:29:36,4, smsd: File mode creation mask: 022 (0644, rw-r--r--).
2011-01-17 15:29:36,2, smsd: Smsd v3.1.11 started.
2011-01-17 15:29:36,2, smsd: Running as root:root.
Alarmhandler:
#!/bin/sh
# This is an example how to use an alarm handler with smsd.
file=/var/log/smsd_alarm
echo -n "SMSD alarm: $1 $2 $3 $4 $5 $6" > $file
The current Alarmhandler is only for testing.
Please let me know where i go wrong.
Best regards,
André
|
|
Tue Sep 21, 2010 13:52
|
andre-sms: Copy and paste the text and you have a MySql document with International dialing codes.
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.6
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema smsd
--
CREATE DATABASE IF NOT EXISTS smsd;
USE smsd;
--
-- Definition of table `smsd`.`sms_int-dail-code`
--
DROP TABLE IF EXISTS `smsd`.`sms_int-dail-code`;
CREATE TABLE `smsd`.`sms_int-dail-code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country` char(32) DEFAULT NULL,
`prefix_code` char(8 ) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smsd`.`sms_int-dail-code`
--
/*!40000 ALTER TABLE `sms_int-dail-code` DISABLE KEYS */;
LOCK TABLES `sms_int-dail-code` WRITE;
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (1,'Abkhazia','+7840');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (2,'Afghanistan','+93');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (3,'Albania','+355');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (4,'Algeria','+213');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (5,'American Samoa','+1684');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (6,'ANAC Satellite','+857');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (7,'Andorra','+376');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (8,'Angola','+244');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (9,'Anguilla','+1264');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (10,'Antigua and Barbuda','+1268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (11,'Argentina','+54');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (12,'Armenia','+374');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (13,'Aruba','+297');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (14,'Ascension','+247');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (15,'Australia','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (16,'Australian External Territories','+672');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (17,'Austria','+43');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (18,'Azerbaijan','+994');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (19,'Bahamas','+1242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (20,'Bahrain','+973');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (21,'Bangladesh','+880');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (22,'Barbados','+1246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (23,'Barbuda','+1268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (24,'Belarus','+375');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (25,'Belgium','+32');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (26,'Belize','+501');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (27,'Benin','+229');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (28,'Bermuda','+1441');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (29,'Bhutan','+975');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (30,'Bolivia','+591');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (31,'Bosnia and Herzegovina','+387');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (32,'Botswana','+267');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (33,'Brazil','+55');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (34,'British Indian Ocean Territory','+246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (35,'British Virgin Islands','+1284');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (36,'Brunei','+673');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (37,'Bulgaria','+359');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (38,'Burkina Faso','+226');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (39,'Burundi','+257');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (40,'Cambodia','+855');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (41,'Cameroon','+237');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (42,'Canada','+1');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (43,'Cape Verde','+238');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (44,'Cayman Islands','+1345');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (45,'Central African Republic','+236');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (46,'Chad','+235');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (47,'Chatham Island (New Zealand)','+64');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (48,'Chile','+56');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (49,'China','+86');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (50,'Christmas Island','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (51,'Cocos-Keeling Islands','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (52,'Colombia','+57');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (53,'Comoros','+269');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (54,'Congo','+242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (55,'Congo - Brazzaville','+242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (56,'Congo, Dem. Rep. of (Zaire)','+243');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (57,'Congo - Kinshasa','+243');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (58,'Cook Islands','+682');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (59,'Costa Rica','+506');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (60,'Ivory Coast','+225');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (61,'Croatia','+385');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (62,'Cuba','+53');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (63,'Cuba (Guantanamo Bay)','+5399');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (64,'Curaçao','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (65,'Cyprus','+357');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (66,'Czech Republic','+420');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (67,'Denmark','+45');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (68,'Diego Garcia','+246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (69,'Djibouti','+253');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (70,'Dominica','+1767');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (71,'Dominican Republic','+1809');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (72,'East Timor','+670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (73,'Easter Island','+56');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (74,'Ecuador','+593');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (75,'Egypt','+20');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (76,'El Salvador','+503');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (77,'Ellipso (Mobile Satellite service)','+8812');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (78,'EMSAT (Mobile Satellite service)','+88213');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (79,'Equatorial Guinea','+240');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (80,'Eritrea','+291');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (81,'Estonia','+372');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (82,'Ethiopia','+251');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (83,'Falkland Islands','+500');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (84,'Faroe Islands','+298');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (85,'Fiji','+679');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (86,'Finland','+358');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (87,'France','+33');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (88,'French Antilles','+596');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (89,'French Guiana','+594');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (90,'French Polynesia','+689');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (91,'Gabon','+241');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (92,'Gambia','+220');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (93,'Georgia','+995');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (94,'Germany','+49');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (95,'Ghana','+233');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (96,'Gibraltar','+350');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (97,'Global Mobile Satellite System (GMSS)','+881');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (98,'Globalstar (Mobile Satellite Service)','+8818');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (99,'Greece','+30');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (100,'Greenland','+299');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (101,'Grenada','+1473');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (102,'Guadeloupe','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (103,'Guam','+1671');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (104,'Guantanamo Bay','+5399');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (105,'Guatemala','+502');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (106,'Guinea','+224');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (107,'Guinea-Bissau','+245');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (108,'Guyana','+592');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (109,'Haiti','+509');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (110,'Honduras','+504');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (111,'Hong Kong','+852');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (112,'Hungary','+36');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (113,'Iceland','+354');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (114,'ICO Global (Mobile Satellite Service)','+8810');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (115,'India','+91');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (116,'Indonesia','+62');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (117,'Inmarsat SNAC','+870');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (118,'International Freephone Service','+800');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (119,'International Shared Cost Service (ISCS)','+808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (120,'Iran','+98');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (121,'Iraq','+964');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (122,'Ireland','+353');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (123,'Iridium (Mobile Satellite service)','+8816');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (124,'Israel','+972');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (125,'Italy','+39');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (126,'Jamaica','+1876');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (127,'Japan','+81');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (128,'Jordan','+962');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (129,'Kazakhstan','+76');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (130,'Kenya','+254');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (131,'Kiribati','+686');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (132,'North Korea','+850');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (133,'South Korea','+82');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (134,'Kuwait','+965');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (135,'Kyrgyzstan','+996');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (136,'Laos','+856');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (137,'Latvia','+371');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (138,'Lebanon','+961');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (139,'Lesotho','+266');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (140,'Liberia','+231');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (141,'Libya','+218');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (142,'Liechtenstein','+423');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (143,'Lithuania','+370');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (144,'Luxembourg','+352');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (145,'Macau SAR China','+853');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (146,'Macedonia','+389');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (147,'Madagascar','+261');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (148,'Malawi','+265');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (149,'Malaysia','+60');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (150,'Maldives','+960');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (151,'Mali','+223');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (152,'Malta','+356');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (153,'Marshall Islands','+692');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (154,'Martinique','+596');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (155,'Mauritania','+222');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (156,'Mauritius','+230');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (157,'Mayotte','+262');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (158,'Mexico','+52');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (159,'Micronesia','+691');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (160,'Midway Island','+1808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (161,'Moldova','+373');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (162,'Monaco','+377');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (163,'Mongolia','+976');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (164,'Montenegro','+382');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (165,'Montserrat','+1664');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (166,'Morocco','+212');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (167,'Mozambique','+258');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (168,'Myanmar','+95');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (169,'Namibia','+264');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (170,'Nauru','+674');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (171,'Nepal','+977');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (172,'Netherlands','+31');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (173,'Netherlands Antilles','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (174,'Nevis','+1869');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (175,'New Caledonia','+687');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (176,'New Zealand','+64');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (177,'Nicaragua','+505');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (178,'Niger','+227');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (179,'Nigeria','+234');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (180,'Niue','+683');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (181,'Norfolk Island','+672');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (182,'Northern Mariana Islands','+1670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (183,'Norway','+47');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (184,'Oman','+968');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (185,'Pakistan','+92');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (186,'Palau','+680');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (187,'Palestinian territories','+970');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (188,'Panama','+507');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (189,'Papua New Guinea','+675');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (190,'Paraguay','+595');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (191,'Peru','+51');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (192,'Philippines','+63');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (193,'Poland','+48');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (194,'Portugal','+351');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (195,'Puerto Rico','+1787');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (196,'Qatar','+974');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (197,'Réunion','+262');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (198,'Romania','+40');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (199,'Russia','+7');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (200,'Rwanda','+250');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (201,'Saint Barthélemy','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (202,'Saint Helena','+290');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (203,'Saint Kitts and Nevis','+1869');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (204,'Saint Lucia','+1758');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (205,'Saint Martin','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (206,'Saint Pierre and Miquelon','+508');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (207,'Saint Vincent and the Grenadines','+1784');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (208,'Samoa','+685');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (209,'San Marino','+378');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (210,'São Tomé and Príncipe','+239');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (211,'Saudi Arabia','+966');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (212,'Senegal','+221');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (213,'Serbia','+381');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (214,'Seychelles','+248');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (215,'Sierra Leone','+232');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (216,'Singapore','+65');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (217,'Sint Maarten','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (218,'Slovakia','+421');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (219,'Slovenia','+386');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (220,'Solomon Islands','+677');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (221,'Somalia','+252');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (222,'South Africa','+27');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (223,'South Georgia and the South Sandwich Islands','+500');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (224,'Spain','+34');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (225,'Sri Lanka','+94');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (226,'Sudan','+249');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (227,'Suriname','+597');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (228,'Swaziland','+268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (229,'Sweden','+46');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (230,'Switzerland','+41');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (231,'Syria','+963');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (232,'Taiwan','+886');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (233,'Tajikistan','+992');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (234,'Tanzania','+255');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (235,'Thailand','+66');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (236,'Thuraya (Mobile Satellite service)','+88216');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (237,'Timor-Leste','+670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (238,'Togo','+228');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (239,'Tokelau','+690');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (240,'Tonga','+676');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (241,'Trinidad and Tobago','+1868');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (242,'Tunisia','+216');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (243,'Turkey','+90');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (244,'Turkmenistan','+993');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (245,'Turks and Caicos Islands','+1649');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (246,'Tuvalu','+688');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (247,'Uganda','+256');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (248,'Ukraine','+380');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (249,'United Arab Emirates','+971');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (250,'United Kingdom','+44');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (251,'United States','+1');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (252,'Universal Personal Telecommunications (UPT)','+878');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (253,'Uruguay','+598');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (254,'U.S. Virgin Islands','+1340');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (255,'Uzbekistan','+998');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (256,'Vanuatu','+678');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (257,'Vatican','+39066');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (258,'Venezuela','+58');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (259,'Vietnam','+84');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (260,'Wake Island','+1808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (261,'Wallis and Futuna','+681');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (262,'Yemen','+967');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (263,'Zambia','+260');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (264,'Zanzibar','+255');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (265,'Zimbabwe','+263');
UNLOCK TABLES;
/*!40000 ALTER TABLE `sms_int-dail-code` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Have fun with it :P
|
|
Sun Sep 19, 2010 16:15
|
andre-sms: Description: Just for the fun of it.
Usage: Private (internal users).
Number of users: 1, just me :mrgreen:
Deployment: 1
Volume of 160-character SMs per month: 10
Hardware : Dell Pentium III, Ubuntu Linux 10.04 Server, Nokia 6310i
|
Page: 1
Time in this board is UTC.
|
|
|
 |
|
|
 |
|
