sqlcounter dailycounter {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Daily-Session-Time
    check_name = Max-Daily-Session
    reply_name = Session-Timeout

    key = User-Name
    reset = daily

    $INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}

sqlcounter weeklycounter {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Weekly-Session-Time
    check_name = Max-Weekly-Session
    key = User-Name
    reset = weekly

    query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{${key}}'"
}

sqlcounter monthlycounter {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Monthly-Session-Time
    check_name = Max-Monthly-Session
    reply_name = Session-Timeout
    key = User-Name
    reset = monthly

    $INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}

sqlcounter quaterlycounter {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Quaterly-Session-Time
    check_name = Max-Quaterly-Session
    key = User-Name
    reset = 3m

    query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{${key}}'"
}


sqlcounter yearlycounter {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Yearly-Session-Time
    check_name = Max-Yearly-Session
    key = User-Name
    reset = 12m

    query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{${key}}'"
}


sqlcounter noresetcounter {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Max-All-Session-Time
    check_name = Max-All-Session
    key = User-Name
    reset = never

    $INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}

sqlcounter expire_on_login {
    sql_module_instance = sql
    dialect = mysql

    counter_name = Expire-After-Initial-Login
    check_name = Expire-After
    key = User-Name
    reset = never

    $INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}

sqlcounter counterChilliSpotMaxTotalOctetsDaily {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Total-Octets-Daily
    check_name = CS-Total-Octets-Daily
    counter-type = data
    reply_name = ChilliSpot-Max-Total-Octets
    key = User-Name
    reset = daily
    query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxTotalOctetsWeekly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Total-Octets-Weekly
    check_name = CS-Total-Octets-Weekly
    counter-type = data
    reply_name = ChilliSpot-Max-Total-Octets
    key = User-Name
    reset = weekly

    query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxTotalOctetsMonthly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Total-Octets-Monthly
    check_name = CS-Total-Octets-Monthly
    counter-type = data
    reply_name = ChilliSpot-Max-Total-Octets
    key = User-Name
    reset = monthly

    query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0)FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxTotalOctetsQuarterly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Total-Octets-Quarterly
    check_name = CS-Total-Octets-Quarterly
    counter-type = data
    reply_name = ChilliSpot-Max-Total-Octets
    key = User-Name
    reset = 3m

    query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxTotalOctetsYearly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Total-Octets-Yearly
    check_name = CS-Total-Octets-Yearly
    counter-type = data
    reply_name = ChilliSpot-Max-Total-Octets
    key = User-Name
    reset = 12m

    query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}

sqlcounter counterChilliSpotMaxInputOctetsDaily {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Input-Octets-Daily
    check_name = CS-Input-Octets-Daily
    counter-type = data
    reply_name = ChilliSpot-Max-Input-Octets
    key = User-Name
    reset = daily

    query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxInputOctetsWeekly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Input-Octets-Weekly
    check_name = CS-Input-Octets-Weekly
    counter-type = data
    reply_name = ChilliSpot-Max-Input-Octets
    key = User-Name
    reset = weekly

    query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxInputOctetsMonthly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Input-Octets-Monthly
    check_name = CS-Input-Octets-Monthly
    counter-type = data
    reply_name = ChilliSpot-Max-Input-Octets
    key = User-Name
    reset = monthly

    query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxInputOctetsQuarterly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Input-Octets-Quarterly
    check_name = CS-Input-Octets-Quarterly
    counter-type = data
    reply_name = ChilliSpot-Max-Input-Octets
    key = User-Name
    reset = 3m

    query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxInputOctetsYearly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Input-Octets-Yearly
    check_name = CS-Input-Octets-Yearly
    counter-type = data
    reply_name = ChilliSpot-Max-Input-Octets
    key = User-Name
    reset = 12m

    query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}

sqlcounter counterChilliSpotMaxOutputOctetsDaily {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Output-Octets-Daily
    check_name = CS-Output-Octets-Daily
    counter-type = data
    reply_name = ChilliSpot-Max-Output-Octets
    key = User-Name
    reset = daily

    query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxOutputOctetsWeekly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Output-Octets-Weekly
    check_name = CS-Output-Octets-Weekly
    counter-type = data
    reply_name = ChilliSpot-Max-Output-Octets
    key = User-Name
    reset = weekly

    query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxOutputOctetsMonthly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Output-Octets-Monthly
    check_name = CS-Output-Octets-Monthly
    counter-type = data
    reply_name = ChilliSpot-Max-Output-Octets
    key = User-Name
    reset = monthly

    query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxOutputOctetsQuarterly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Output-Octets-Quarterly
    check_name = CS-Output-Octets-Quarterly
    counter-type = data
    reply_name = ChilliSpot-Max-Output-Octets
    key = User-Name
    reset = 3m

    query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}


sqlcounter counterChilliSpotMaxOutputOctetsYearly {
    sql_module_instance = sql
    dialect = mysql

    counter_name = ChilliSpot-Max-Output-Octets-Yearly
    check_name = CS-Output-Octets-Yearly
    counter-type = data
    reply_name = ChilliSpot-Max-Output-Octets
    key = User-Name
    reset = 12m

    query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}