ioShareDB uses tinyblob on password, limits, ratio, stats and credits.
On password because itâs binary in the userfile structure.
On limits, ratio, stats and credits to simplify the DB table and the module coding.
To store credits as bigint, would require 10 fields,
limits would require 5 fields, ratio would require 10 fields,
and all stats would require 240 fields.
Storing it as tinyblob only require 11 fields.
v1.0.0 saves a userfile in ioftpd/users/ for each user. (local cache)
So most of the scripts that reads directly form the userfile will work,
but the scripts that modify the userfile will not work since
the userfile cache is only used if the db is offline at ioftpd startup.
|