mysql_all_domain_alias:
  driver        = redirect
  domains       = +local_domains
  local_parts   = alle
  data          = ${lookup mysql{ SELECT CONCAT(username,'@',domain) AS sendto FROM users WHERE domain='${quote_mysql:$domain}' }}
  condition     = ${if or {{
                        def:authenticated_id
                    }{
                        eq {$sender_host_address}{127.0.0.1}
                    }}
                  }
  file_transport = address_file
  pipe_transport = address_pipe


mysql_alias:
  driver                = redirect
  domains               = +local_domains
  file_transport        = address_file
  pipe_transport        = address_pipe
  data                  = ${if or {{
                                def:authenticated_id
                          }{
                                eq {$sender_host_address}{127.0.0.1}
                          }}{
                                ${lookup mysql{ SELECT sendto FROM alias WHERE ( username='${quote_mysql:$local_part}' AND (domain='${quote_mysql:$domain}' OR domain='') )}}
                          } {
                                ${lookup mysql{ SELECT sendto FROM alias WHERE ( ( username='${quote_mysql:$local_part}' AND (domain='${quote_mysql:$domain}' OR domain='')) AND internal='NO' )}}
                          }}
  local_part_suffix     = +*
  local_part_suffix_optional

mysql_user_condition:
  driver                = accept
  domains               = +local_domains
  caseful_local_part    = true
  condition             = ${if and {{
                                        eq {${lookup mysql{
                                                SELECT CONCAT(username,'@',domain) AS email
                                                FROM users
                                                WHERE username='${quote_mysql:$local_part}'
                                                AND domain='${quote_mysql:$domain}'
                                        }{true}{false}}}{true}
                                   }{
                                        or {{
                                                and {{
                                                        eq {${sg{$local_part_suffix}{^#([^#]+)#[0-9]{8}$}{$1}}}{before}
                                                }{
                                                        lt {$tod_logfile}{${sg{$local_part_suffix}{^#[^#]+#([0-9]{8})$}{$1}}}
                                                }
                                           }
                                           }{
                                                and {{
                                                        eq {${sg{$local_part_suffix}{^#([^#]+)#.*$}{$1}}}{fromdomain}
                                                    }{
                                                        eq {$sender_address_domain}{${sg{$local_part_suffix}{^#[^#]+#(.*)$}{$1}}}
                                                    }
                                                }
                                           }{
                                                and {{
                                                        eq {${sg{$local_part_suffix}{^#([^#]+)#.*$}{$1}}}{b64from}
                                                    }{
                                                        eq {${str2b64:$sender_address}}{${sg{$local_part_suffix}{^#[^#]+#(.*)$}{$1}}}
                                                    }
                                                }
                                           }
                                        }
                                   }
                          }
                          }
  local_part_suffix     = #*
  transport             = local_mysql_delivery


mysql_user:
  driver                = accept
  domains               = +local_domains
  condition             = ${lookup mysql{
                                SELECT CONCAT(username,'@',domain) AS email
                                FROM users
                                WHERE username='${quote_mysql:$local_part}'
                                AND domain='${quote_mysql:$domain}'
                          }{true}{false}}
  local_part_suffix     = +*
  local_part_suffix_optional
  transport             = local_mysql_delivery
  no_more