Skip to content

Instantly share code, notes, and snippets.

@ambiorixg12
Created March 5, 2021 04:58
Show Gist options
  • Select an option

  • Save ambiorixg12/96226a46f8f746a1851dae244ac3bcb6 to your computer and use it in GitHub Desktop.

Select an option

Save ambiorixg12/96226a46f8f746a1851dae244ac3bcb6 to your computer and use it in GitHub Desktop.
asterisk sequential audio
[audio-admin]
exten=>_x.,1,Answer()
same=>n,Noop( ******* ${DB(test/count)} ***)
same=>n,Set(t=${SHELL( mysql --user=admin --password='112354552' --skip-column-names audio_admin -e 'SELECT count(audio_unique) FROM audio')})
same=>n,Set(t=$[${t} - 1]);
same=>n,GotoIf($[${DB(test/count)} >${t}]?del)
same=>n,GotoIf($[${DB(test/count)} >0]?inc)
same =>n,Set(DB(test/count)=1)
same=>n,Set(COUNT=${DB(test/count)})
same=>n,Set(audio=$[${COUNT} - 1]);
same=>n,Set(id=${SHELL( mysql --user=admin --password='112354552' --skip-column-names audio_admin -e 'SELECT audio_unique FROM audio limit ${audio},1')})
same => n,Playback(${id:0:-1})
same=>n,hangup()
same => n(inc),Set(DB(test/count)=$[${DB(test/count)} + 1])
same=>n,Set(COUNT=${DB(test/count)})
same=>n,Set(audio=$[${COUNT} - 1]);
same=>n,Set(id=${SHELL( mysql --user=admin --password='112354552' --skip-column-names audio_admin -e 'SELECT audio_unique FROM audio limit ${audio},1')})
same => n,Playback(${id:0:-1})
same=>n,hangup()
same=>n(del),Set(del=${DB_DELETE(test/count)})
same=>n,goto(1)
same=>n,hangup()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment