由 mittere 在 05-07-2004 21:44 发表:
关于proftpd+mysql
我的配置文件如下
SQLNamedQuery get-quota-limit SELECT "name, 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 name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
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 name = '%{6}' AND quota_type = '%{7}'" quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies
我看着有点问题啊，在quotatallies表中能建立记录，无法记录我的上传和下载文件的大小和数量，总是0
我总觉得第三个SQLNamedQuery别扭，大家给看看
这些%{0}-%{7}的值从何而来？
配置：AthlonXP 2200+512MRam+Quadro550+80G+Yamaha 44xCDRW
系统：
Windows XP
Redhat AS3 Update2
Kylix3+JBuilder9
只用KDE
由 mittere 在 05-07-2004 22:05 发表:
其他的都ok
匿名访问也没事
在普通用户login以后，用quote site quota察看状态一切正常
put或get以