I am wondering if there is anyway, when a new subscriber joins my list, if I can have their email address added to my database. I use MySql.
Is there some little function I can add to my rc.custom script or one of the other scripts?
Love, Light, & Blessings with Joy, Randall
Hmm... Interesting question. I'm certain this is possible.
You'll need to write a small shell script or similar thing to run to do the actual addition and deletions, I suspect. Perhaps you can get away with calling some form of 'mysql -e "insert into subscribers blah blah', or maybe you'll have to actually write a shell script...
I *suspect* that your best bet may be a hack in SmartList's subscribe and unsubscribe scripts, to call your add and delete record script... Maybe add a call at the bottom of each of those files...
Other listers may have better ideas...
Let me know what you come up with.
Regards,
Peter Hartzler SmartList FAQ Maintainer http://www.hartzler.net/smartlist/SmartList-FAQ.html sl-faq@hartzler.net
On Fri, 5 Jan 2001 randall@astromindmagazine.com wrote:
I am wondering if there is anyway, when a new subscriber joins my list, if I can have their email address added to my database. I use MySql.
Is there some little function I can add to my rc.custom script or one of the other scripts?
Love, Light, & Blessings with Joy, Randall
Smartlist mailing list Smartlist@lists.RWTH-Aachen.DE http://MailMan.RWTH-Aachen.DE/mailman/listinfo/smartlist
Hmm...
Another grep in the bin directory suggests to me that a complete solution would need hooks in procbounce and removelist as well as subscribe and unsubscribe... And you'll want to insert the calls in such a way that it'll only run on succesful operations... Still quite doable.
Sorry for the excess list traffic...
Peter Hartzler SmartList FAQ Maintainer http://www.hartzler.net/smartlist/SmartList-FAQ.html sl-faq@hartzler.net
All --
Just a quick note to let you know that the SmartList FAQ is updated based on recent questions. Additionally, I've posted a copy of the latest SmartList manual (1.57 2000/01/29, from SL 3.15), and created linkage from the FAQ citations and the Manual TOC to the relevant Manual entry.
You may notice the logo-like decoration on the FAQ page. This is NOT an official logo of SmartList; it hasn't been blessed in any way; it's just something I cooked up to "beautify" the page.
http://www.hartzler.net/smartlist/
Regards,
Pete.
smartlist@lists.rwth-aachen.de