[prev in list] [next in list] [prev in thread] [next in thread] 

List:       proftpd-devel
Subject:    Re: [Proftpd-devel] mod_sql maintainer? mod_sql ideas.
From:       TJ Saunders <tj () castaglia ! org>
Date:       2007-10-23 18:09:46
Message-ID: Pine.LNX.4.58.0710231332130.19712 () mercury ! skynetbb ! com
[Download RAW message or body]


> But what about joins, functions, unions,... in the query?
> Eg.:
> auth_query=SELECT passwd as password from accounts left join ftpusers on
> account.id=ftpusers.account_id where ftpusers.warned IS NULL

Any custom query can be used, as long as it returns the necessary fields
in the order documented:

  username, passwd, uid, gid, homedir, shell

So JOINs, UNIONs, etc all are fair game, as long as your database client
supports the syntax.

> The logic of how to query the database is actually in the mod (exception
> the WHERE clause). If you could move the logic (query) out of the mod
> then the flexibility would increase.

To which logic, in particular, are you referring?

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   And knows that yesterday is but today's memory and tomorrow is today's
   dream.

     -Kahlil Gibran

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
ProFTPD Developers List
<proftpd-devel@proftpd.org>
https://lists.sourceforge.net/lists/listinfo/proftp-devel
[prev in list] [next in list] [prev in thread] [next in thread]