What are the functions used by the MYSQL database in Pureftpd
Editor to share with you what functions are used in the MYSQL database in Pureftpd, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
MYSQLGetPW SELECT Password FROM users WHERE User= "L"
# password field. I use Password in the users table as the password field
MYSQLGetUID SELECT Uid FROM users WHERE User= "L"
# UID user ID field
MYSQLDefaultUID 1000
# default UID (Note: how to turn on this option, MYSQLGetUID will have no effect)
MYSQLGetGID SELECT Gid FROM users WHERE User= "L"
# GID group ID field
MYSQLDefaultGID 1000
# default GID (Note: how to turn on this option, MYSQLGetGID will have no effect)
MYSQLGetDir SELECT Dir FROM users WHERE User= "L"
# FTP user directory such as / home/web/www-9812-net
MySQLGetQTAFS SELECT QuotaFiles FROM users WHERE User= "L"
# disk limit, file number limit. For example, 1000 allows users to upload 1, 000 files
MySQLGetQTASZ SELECT QuotaSize FROM users WHERE User= "L"
# disk limit, FTP user space limit (in M), such as 100m
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User= "L"
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User= "L"
# upload / download ratio. MySQLGetRatioUL is upload ratio, MySQLGetRatioDL download ratio. Such as 1:5
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User= "L"
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User= "L"
# download / download bandwidth (in KB/s). MySQLGetBandwidthUL upload bandwidth, MySQLGetBandwidthDL download bandwidth. Such as uploading
500KB/s, download 50KB/s
MySQLForceTildeExpansion 1
MySQLTransactions On
These are all the contents of the article "what are the functions used by the MYSQL database in Pureftpd?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
