if anyone has a similiar request to change useronly callbacks after 30 minutes if not dialed until to normal callbacks.
create a crontab like this:
- Code: Select all
mysql -ucron -p1234 -hlocalhost --database=asterisk --execute="UPDATE vicidial_callbacks SET recipient = 'anyone', status = 'active' WHERE recipient = 'USERONLY' AND status = 'LIVE' AND callback_time < now() - interval 30 minute;"
if u only change recipient to "anyone" it doesn't work, because status is live. so u have to change the status to active, after a short time, vicidial change the status to live and place it in the hopper.
if u reset ur hopper, live callbacks get missed cause they are not loaded anymore in the hopper, i don't know if it's a bug or feature

regards
philip