Fix minibar (dialplan):
FIX minibar :
[minibar]
exten => 37,1,NoOp( ====> Room ${CALLERID(num)} ask a mini-bar <==== )
exten => 37,n,Playback(added&your&information&sales)
exten => 37,n,MYSQL(Connect connid localhost root ${AMPDBPASS} roomx)
exten => 37,n,MYSQL(Query resultid ${connid} SELECT mini_bar FROM rooms WHERE extension= '${CALLERID(NUM)}')
exten => 37,n,MYSQL(Fetch fetchid ${resultid} mini_bar)
exten => 37,n(read_key),Read(Minibar,,1,,,5)
exten => 37,n,GotoIf($["${Minibar}" != ""]?add_mini_bar)
exten => 37,n,Set(minibar=${mini_bar})
exten => 37,n,MYSQL(Query resultid ${connid} UPDATE rooms SET mini_bar = '${mini_bar}' WHERE extension='${CALLERID(NUM)}')
exten => 37,n,MYSQL(Clear ${resultid})
exten => 37,n,MYSQL(Disconnect ${resultid})
exten => 37,n,Playback(goodbye)
exten => 37,n,Goto(end)
exten => 37,n(add_mini_bar),Set(mini_bar=${mini_bar}${Minibar} )
exten => 37,n,ExecIF($["${Minibar:0:1}" != ""]?SayNumber(${Minibar:0:1}):Goto(end))
exten => 37,n,Goto(read_key)
exten => _37,n(end),Hangup()
