3.43.3. BasicSelect Previous topic Parent topic Child topic Next topic

AuthBy PLATYPUS works slightly differently to AuthBy SQL when it comes to how the user attribute selection query is assembled.
BasicSelect specifies the SQL query used to fetch user attributes from the Platypus database. It is expected to return the following attributes in this order:
  • password
  • active
  • timeleft
  • blockuser
  • guarantor
  • possibly other attributes as selected by AuthSelect
%0 is replaced with the contents of AuthSelect, which is expected to be a list of additional columns to select from the database. For more information, see Section 3.43.4. AuthSelect.
%1 is replaced with the user name.
The default will work with the standard Platypus database and need not be changed:
BasicSelect select password, active, timeleft, blockuser, \
guarantor %0 from customer where username=%1