I’m trying to set up a way for users to enter a number (A) followed by another number (B) that it will be forwarded to. This would then be stored in a database so that whenever anyone dials A the call will be placed to B.
A real world explanation is I want to prevent users from calling 0845 and 0870 numbers (UK non geographic numbers) as they cost more than calling geographic numbers. When a user dials a 0845 or 0870 number they’ll be told to check a website which lists alternative numbers and then call back with the alternative number. The alternative number would be listed along side the 0845/0870 number in the database. The end result would be that whenever that 0845/0870 number is dialed * would automatically dial the geographic number thus saving money.
I can do this all quite happily with dial plans however I have no great desire to go through the UK phone book listing all the 0845/0870 numbers and their alternatives. Thus I wish to create a system where by users can enter the two numbers either using their phone or a web based application. These numbers would then be stored in a database which * could access through a dial plan.
I come unstuck at the “how-to-get-users-to-do-this” part. I want to make it as easy as possible for the users without having them editing dial plans directly… Does anyone have any ideas as to how I might go about doing this? I’m thinking MySQL (not really experienced in using this) and something to do with AGI scripts possibly (only just started playing with these).
Thanks in advance for any help received!