g00d

Member

Last active 15 years ago

  1. 15 years ago
    Thu Oct 29 12:23:28 2009

    Thanks! May I add this snippet to the default script ?

    Best regards,

    Yes, of course, for this I posted ;)

    and dahdi trunks from "Zap Channel DIDs"
    trunk label = Zap Channel Description

    # DAHDI TRUNKS
    mysql -ENB -u $DBUSER -p$DBPASS -h $DBHOST $DBNAME -e "SELECT concat('DAHDI/',channel) as trunk, description as label, did as did FROM zapchandids ORDER BY zapchandids.channel ASC" | sed '/\*\*/d' | sed 's/: /=/g' | while read LINEA
    do
    echo $LINEA | sed 's/trunk=\(.*\)/\n[\1]\ntype=trunk\nlabel=\1/g'
    done
  2. Fri Oct 23 09:06:21 2009

    dahdi extensions upgrate for autoconfig-buttons-freepbx.sh

    add before "# SIP EXTENSIONS"

    # DAHDI EXTENSIONS
    mysql -ENB -u $DBUSER -p$DBPASS -h $DBHOST $DBNAME -e "select s3.data as channel,extension,name as label,s1.data as mailbox,s2.data as context,concat('*',s1.data) as extenvoicemail from users as u left join zap as s1 on u.extension=s1.id and s1.keyword='mailbox' left join zap as s3 on u.extension=s3.id and s3.keyword='dial' left join zap as s2 on u.extension=s2.id where s2.keyword='context' order by extension" | sed '/\*\*/d' | sed 's/: /=/g' | while read LINEA
    do
    echo $LINEA | sed 's/channel=\(.*\)/\n[\1]\ntype=extension/g'
    done