Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.