There is a huge clock counting down and I'm stuck
This is what I need
Needs to look something like this
exten => _X.,1,MYSQL(Connect connid localhost boost boost123 boost)
exten => _X.,2,MYSQL(Query resultid ${connid} UPDATE boost SET PhoneTime =
NOW() WHERE Number =?
exten => _X.,3,EXEC PLAYBACK (Sound File)
exten => _X.,8,MYSQL(Clear ${resultid})
exten => _X.,9,MYSQL(Disconnect ${connid})
exten => _X.,10,Hangup
The database looks like this
Channel
Int
1-30
StartTime
DateTime
Phonetime
DateTime
Number
Bigint
18667777777
I just need it to update Phone time based on the trunk coming in
Just need someone to assist me in figuring out where to put this? Using FreePBX
but I'm editing custom conf files
Please, please, please
Should only be a short period like 1/2 hour
Regards,
Blake
