*smile* I am having a deja-vu. I sent this patch to Alex to begin with. Heh
@Emmanuel: I agree with you and will suggest this on your behalf to the devel mailinglist. @devel: Alex suggested to make this even more configurable by putting the SELECT query in kannel.conf (/sqlbox.conf). However, I think this gives that much extra flexibility (and maintaining backward compatibility) that this quick patch can be incorporated already. It is useful for a lot of persons and it is just a quick patch. Todo: also patch the sql statements for other storage types. Rene Kluwen Chimit From: Emmanuel CHANSON [mailto:emmanuelchan...@gmail.com] Sent: woensdag 2 juni 2010 2:46 To: rene.klu...@chimit.nl Cc: Alejandro Guerrieri Subject: Re: Sqlbox and scheduled pushes Hello Rene I had sent my email to a wrong person... Emmanuel 2010/5/31 Emmanuel CHANSON <emmanuelchan...@gmail.com> Hello Rene, I would like to tell you about sqlbox and a requirement I have done on sqlbox source advised by Alex :) My need was to be able to send a scheduled batch using sqlbox. Alex told me first that sqlbox could not and I have to do this from the application but after a while he advised me to try to patch the source like this: 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" That is what I have done and it seems to work like a charm :) So I wonder if this can not be proposed to others because it is something very usefull...for me at least.. Regards, Emmanuel -- Emmanuel CHANSON Emmanuel Mobile Nouvelle-Calédonie: +687.77.35.02 Mobile France: +33 (0) 6.68.03.89.56 @email : emmanuelchan...@gmail.com -- Emmanuel CHANSON Emmanuel Mobile Nouvelle-Calédonie: +687.77.35.02 Mobile France: +33 (0) 6.68.03.89.56 @email : emmanuelchan...@gmail.com