Syncing real hdd space with proftpd mod_quotatab_sql data
 

All users of proftpd`s mod_quotatab_sql knows about that "small" problem - it counts uploaded ammount of data and if you delete file from via FTP, this ammount of uploaded data increases. Ideal and logical, but... What happens if i delete file from user`s directory from terminal? Mod_quotatab_sql thinks it still have same ammount of uploaded data but really that ammount are smallest becouse some files was deleted from terminal or web-application.

For example:
* User have FTP Quota - 100MB
* User uploaded some files and got 70MB of 100MB
* User deleted some files - 30MB - in other way than FTP, for example, php script
* mod_quotatab still thinks about quota 70MB of 100MB (becouse it reads info from mysql) but really user was used only 40MB of 100MB

Currently i am thinking about writing small script or application which sometime will check real ammount of data in user`s directory and updates info to mysql table of mod_quotatab_sql.

Maybe someone knows any other solution for this problem...


P.S. Sorry for my bad English... I hope i was explained enought understandable.