Yes, but I was meaning, if you let's say want to know real-time of the sending, you're selecting the record from sent_sms table and getting value of time field.
So, if you're doing INSERT with specific time you will get that time regardless if message was sent after that time( if there is big queue). The only indicator is DLR i think, but you'd need to link it with the message via dlr_url. We're actually using this scheme right now for our service, but I think I will modify it later to get in 1 MT record both time of sending and last updated time of new status. 2012/8/3 Rene Kluwen <[email protected]> > I didn’t include users either… my bad…**** > > ** ** > > *From:* Rene Kluwen [mailto:[email protected]] > *Sent:* Thursday, 02 August, 2012 22:19 > *To:* 'spameden' > *Subject:* RE: schedule delivery of sms**** > > ** ** > > No, after sending the sms, the structure, including the time field is > discarded.**** > > Either way, if need be, bearerbox can modify the time field at any time. > Because we’ve already used it and after that the value is of no use anymore. > **** > > According to Emmanuel, it works like a charm.**** > > ** ** > > But as you wish, post your comments on the list and let everybody know > what you think of it. You are right if your opinion is that this is a > cleaner solution.**** > > ** ** > > == Rene**** > > ** ** > > ** ** > > *From:* spameden [mailto:[email protected] <[email protected]>] > *Sent:* Thursday, 02 August, 2012 22:15 > *To:* Rene Kluwen > *Subject:* Re: schedule delivery of sms**** > > ** ** > > I thought time is used in bearerbox as a special field? > > Bearerbox inserts time of the sending there (it's not always the same as > the time you wanted, especially if there is a big queue). > > I'd suggest creating another field, like CREATE_DATE with standard > datetime format and altering query.**** > > 2012/8/3 Rene Kluwen <[email protected]>**** > > This is from an old post from Emmanuel Chanson:**** > > **** > > >in gw/sqlbox_mysql.h**** > > > something like:**** > > > SELECT sql_id, momt, sender, receiver, udhdata, \**** > > >msgdata, time, smsc_id, service, account, id, sms_type, mclass, mwi, > coding, \**** > > >compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, \**** > > >charset, boxc_id, binfo, meta_data FROM %S WHERE time < > UNIX_TIMESTAMP(NOW()) LIMIT 0,1"**** > > **** > > **** > > Having done that, you can just insert a valid time in the “time” field and > sqlbox will automatically send the sms at the desired time.**** > > **** > > == Rene**** > > **** > > **** > > *From:* [email protected] [mailto:[email protected]] > *On Behalf Of *neo nortan**** > > > *Sent:* Thursday, 02 August, 2012 18:12 > *To:* users > *Subject:* schedule delivery of sms**** > > **** > > dear list **** > > > can i schedule delivery of sms. > i am using sqlbox in kannel > > regards > > > **** > > Follow *Rediff Deal ho jaye!* to get exciting offers in your city > everyday.<http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?> > **** > > > <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?> > **** >
