Hello, I'm looking to do the following, and I wonder if Asterisk can be used for it, and if yes, if anyone can point me to the relevant information (commands, sample config...):
1. Caller dials 111, 222 or 333. 2. Based on the dialed number, Asterisk queries an external MySQL table and retrieves alphanumeric data, plays/announces it to the user and deletes the row from the database: The SQL queries would look something like: SELECT user, pwd FROM codes WHERE dialed = '111'; DELETE FROM codes WHERE user=$user AND pwd=$pwd; Thanks, David ____________________________________________________________________________________Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo.com/ _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users