Freeradius stanzim-moghararat logger
====================================

Public domain
********************************************************************************
    
    #!/bin/bash
    DATE="2009-01-01"
    PASS="123456"
    DB="radius"
    TMP="tmp.log"
    LOG="${DATE}.csv"
    
    mysql -p${PASS} $DB -e "
      SELECT
        AcctStartTime,AcctStopTime,FramedIPAddress,CallingStationId
      FROM
        radacct
      WHERE
        date(AcctStartTime)='${DATE}'
      OR
        date(AcctStopTime)='${DATE}'
      "  |\
    egrep -v '^AcctStartTime' |\
    awk '{if ($6 == "") print$1" "$2","$3" "$4",,"$5; else print$1" "$2","$3" "$4","$5","$6}' > ${LOG}
    sed -i -e "s/,242/,/" ${LOG}
    awk -F ',' '{print$1","$2","$3",242"$4}' ${LOG} > ${TMP}
    mv ${TMP} ${LOG}
    sed -i -e 's,-,/,g' ${LOG}
    
********************************************************************************
_BY: Pejman Moghadam_  
_TAG: tanzim, sed, awk, bash-script, bash_  
_DATE: 2010-01-02 19:10:32_