Database Table Mapping-where condition

  • Resolved volt74

    (@volt74)


    6 years, 6 months ago

    this plugin works realy well. I use postgress db and everything works on first try. Thanks for it.

    Anyway i would suggest one improvement. I have table with active and deleted users and I don’t want to allow removed user to log in. Because of that i would suggest to extend current section “Database Table Mapping” and add another input field “table where condition” which could be possible to use to filter rows in table according current needs.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author tbenyon

    (@tbenyon)

    Hey @volt74,

    I can have a look at adding this functionality for you.

    I’d only ask that once completed if you could kindly write me a review.

    Will start looking at this now but will keep you posted on when it will be completed.

    Would this functionality be useful for you by a specific date? I can’t promise anything but it’d be good to know.

    Thanks,

    Tom

    Thread Starter volt74

    (@volt74)

    Hi Tom,
    thanks for quick response. Yes of course I can test it and let you know.
    I dont need it by specific date.

    thanks
    Volt

    Plugin Author tbenyon

    (@tbenyon)

    Cool, I’m a bit busy for a week but will get round to it for you. I won’t be offended if you chase me so feel free to message me in 1-2 weeks to see if I’ve made progress but I’ll try and keep you posted.

    Thanks,

    Tom

    Thread Starter volt74

    (@volt74)

    ok, thanks

    Plugin Author tbenyon

    (@tbenyon)

    Hey @volt74,

    Just wanted to say I haven’t forgotten about your suggestion.

    I’ve had another thread here where I discuss a solution that also meets your needs. Still working on it but just wanted to update and say thanks again for reaching out.

    Other thread:
    https://www.ads-software.com/support/topic/active-inactive-users/

    Will update you when I’ve got a working prototype incase it is of any use to you ??

    Thanks,

    Tom

    Plugin Author tbenyon

    (@tbenyon)

    Hey @volt74,

    I’ve got a working prototype relating to this. This allows you to give the name of a field and a set of values for that field that would block a user.

    For example, I want to look in the “status” field and block any users who’s status is “blocked” or “sat out”.

    Would you be able to help by downloading the code from GitHub and testing it before I make it live?

    https://github.com/tbenyon/wordpress_external_login_plugin/archive/eb0a1e4b67ea4fa3d21d4923b03e24f12b3c1a07.zip

    Any feedback would be very welcome!

    If this isn’t possible – it’s no problem ??

    Next I’m going to make it so that certain roles can block login also.

    Tom

    Plugin Author tbenyon

    (@tbenyon)

    Hey @volt74,

    This is now live and other users have told me it’s working. If you have any issues, please feel free to re-open this ticket but I’ll mark it as resolved for now.

    Thanks,

    Tom

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database Table Mapping-where condition’ is closed to new replies.