u mine problema i ne polucheatsa resahati...

    SQLNamedQuery uid SELECT "domain.uid FROM ftp_users,domain WHERE domain.id=ftp_users.domain AND ftp_users.email='%u'"
    #domain.uid eto id usera... a etot user mojet imeti neskoliko ftp_user a limit quota totje

    SQLNamedQuery get-quota-limit SELECT "uid, quota_type, per_session, limit_type, \
        bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE uid=%{uid}"

    SQLNamedQuery get-quota-tally SELECT "uid, quota_type, bytes_in_used, bytes_out_used, \
        bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE uid=%{uid}"

    SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, \
        bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, \
        files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, \
        files_xfer_used = files_xfer_used + %{5} WHERE uid = %{uid}" quotatallies
    SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{uid}" quotatallies
    QuotaLimitTable sql:/get-quota-limit
    QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
    QuotaLog                        /var/log/proftpd/quota.log


pomaghi pojalusta....


material vzeat s 
 http://www.opennet.ru/base/net/proftpd_mysql_quota.txt.html

Модератор: Пользуемся тэгами "код" и транслитом (нажми ESC)
А в чем собственно вопрос?