For an application I’m developing now, users have to call a number and dial a unique pincode (8 digits).
How can I achieve that Asterisk does the following:
Check if the pincode exists in an external MySQL database (simple SQL query)
If it exists:
Immediately after confirming the pincode: store the call start timestamp in the external database
[*]On call end: store the call end timestamp in the external database
I have a little experience in writing dialplans but this goes way above my head. Thanks in advance for pointing me in the right direction!