Functions used by the Pureftpd MYSQL database

PureftpdIt is a fast, high-quality, and fully functional ftp server. The most important thing is that it supports setting the Default Client encoding. Pureftpd is very powerful and useful, this article analyzes the functions used by MYSQL databases under Pureftpd.

MYSQLGetPW SELECT Password FROM users WHERE User = "L"

# Password field. I use the 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: If this option is enabled, MYSQLGetUID will be ineffective)

MYSQLGetGID SELECT Gid FROM users WHERE User = "L"

# GID group ID field

MYSQLDefaultGID 1000

# Default GID (Note: If this option is enabled, MYSQLGetGID will be ineffective)

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 Quota and file quantity limit. For example, 1000 allows users to upload thousands of files.

MySQLGetQTASZ SELECT QuotaSize FROM users WHERE User = "L"

# Disk quota, FTP user space limit (unit: M), for example: 100 M

MySQLGetRatioUL SELECT ULRatio FROM users WHERE User = "L"

MySQLGetRatioDL SELECT DLRatio FROM users WHERE User = "L"

# Upload/download Ratio. MySQLGetRatioUL indicates the upload ratio and MySQLGetRatioDL indicates the download ratio. Example: 1: 5

MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User = "L"

MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User = "L"

# Download/download bandwidth (unit: KB/s ). MySQLGetBandwidthUL upload bandwidth and MySQLGetBandwidthDL download bandwidth. For example, upload

Kb/s, download 50KB/s

MySQLForceTildeExpansion 1

MySQLTransactions On

Through the description and analysis in the article, we learned which functions are used in the MYSQL database and their Chinese parsing! Hope to help you!

• Pureftpd-mysql.conf settings
• Pureftpd
• PureFTPd adds an FTP user database to mysql
• PureFTPd configuration file Overview
• Pureftpd tips to benefit you
• Introduction to Pureftpd
• Folder permission for Pureftpd configuration in ubuntu