Re: Password database extra fields and SQL

2016-04-29 Thread Gregory Finch
On 2016-04-29 6:49 AM, Dave wrote: > > Hi everyone, > > first post to the list, be gentle with me! > > Perhaps I'm missing something here, but it appears to me that many > password database extra fields currently aren't much use inside SQL > queries? > > All boolean fields like nologin/node

Re: Password database extra fields and SQL

2016-04-29 Thread Dave
On 29/04/2016 14:57, Matthias Fechner wrote: > Am 29.04.2016 um 15:49 schrieb Dave: >> >> For example, say you have a query like: >> >> password_query = SELECT hash AS password, NULLIF(active = 1, 'y') AS >> nologin FROM users WHERE name = '%u' > > why not using a logic like this to block users th

Re: Password database extra fields and SQL

2016-04-29 Thread Matthias Fechner
Am 29.04.2016 um 15:49 schrieb Dave: For example, say you have a query like: password_query = SELECT hash AS password, NULLIF(active = 1, 'y') AS nologin FROM users WHERE name = '%u' why not using a logic like this to block users that are not active: password_query = SELECT username as user,

Password database extra fields and SQL

2016-04-29 Thread Dave
Hi everyone, first post to the list, be gentle with me! Perhaps I'm missing something here, but it appears to me that many password database extra fields currently aren't much use inside SQL queries? All boolean fields like nologin/nodelay/nopassword are set if the column is presen