gistfile1.txt

# A manual SELECT needs to return data in order specified bellow:
# username, cryptpw, clearpw, uid, gid, home, maildir, quota, fullname, options
#

MYSQL_SELECT_CLAUSE     SELECT CONCAT(email.name, '@', domain.name), \
                        user.password,                          \
                        '',                                     \
                        503,                                    \
                        500,                                    \
                        TRIM(TRAILING '/Maildir/' FROM CASE     \
                          WHEN email.homedir LIKE "/netapp%" THEN email.homedir \
                          ELSE CONCAT('/IV/user_data/email/', email.homedir) END), \
                        CASE WHEN email.homedir LIKE "/netapp%" THEN email.homedir \
                          ELSE CONCAT('/IV/user_data/email/', email.homedir) END, \
                        email.quota,                            \
                        CONCAT(user.first_name,' ', user.last_name), \
                        ''                                      \
                        FROM email, domain, user                \
                        WHERE email.name = '$(local_part)'      \
                        AND domain.name = '$(domain)'           \
                        AND email.domain_id = domain.id         \
                        AND user.email_id = email.id            \
                        AND domain.active = 1