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....