Langsung ke konten utama

Setting custum sql pada smsdrc

[gammu]
model = dummy
connection = none
device = C:\gammu\bin

#device = com35:
#model = AT
#connection = at115200
#name  = Master Vidya 1

[smsd]
Service = sql
Driver = native_mysql
PIN = 1234
logfile = C:\gammu\bin\smsdlog
debuglevel = 2
phoneid = 82394279111
commtimeout = 5
sendtimeout = 30
maxreties   = 5
deliveryreport = no
checksecurity = 0
statusfrequency = 30
receivefrequency = 0
hardresetfrequency = 3600
resetfrequency = 600
loopsleep =0
user = gammu
password = gammu
pc = localhost
database = kalkun


[sql]
delete_phone     = DELETE FROM phones WHERE ID = %P
update_received  = UPDATE phones SET Received = Received + 1 WHERE ID = %P
update_sent      = UPDATE phones SET Sent= Sent + 1 WHERE ID = %P
refresh_phone_status = UPDATE phones SET `TimeOut`= (NOW() + INTERVAL 10 SECOND) + 0,`Battery` = %1, `Signal` = %2 WHERE `ID` = %P

Komentar

Popular Posts

Extjs html class render

Ext.select('.datepicker').each(function(el){ new Ext.form.DateField({ allowBlank : true, renderTo: el, format:'m-d-Y', editable:false, width:140, fieldCls : 'tanggal x-form-field x-form-text x-trigger-noedit', }); }); Ext.select('.note').each(function(el){ new Ext.form.field.TextArea({ allowBlank : false, renderTo: el, grow : true, hideLabel : true, fieldCls : 'pesan x-form-field x-form-text x-trigger-noedit', }); });