tbenyon

You caught me at the right time 🙂

More than happy to help. The basic user storage of WordPress is pretty basic. You can add your own meta data to users and customise how this appears in the admin section so you can grow this however you like.

WordPress originated as simply a blogging platform and although it is growing in functionality the main plan for WordPress I believe is to keep it relatively light and allow plugins to add functionality specific to site needs.

However, It sounds like you’re struggling to find a plugin to do what you want it to do.

I would love to talk to you over the phone about your requirements as this as it’d be quicker, but I’m not allowed to give you my contact information. If you were to write your e-mail in a message here, it would come through to me in an e-mail but the WordPress team would pretty quickly redact it from this forum as it is not allowed.

If you would like to tell me more about what your requirements are I’d be happy to advise.

Thanks,

Tom

Hey Asbell,

Apologies for the delayed reply. No it doesn’t. The main purpose of the plugin is to use an already exisiting login system with a full work flow and be able to login with that table of users.

If you don’t already have that in an external system, you could just use WordPress’ built in users system. I’m guessing there might well be a reason why you don’t want to do this?

Even if this isn’t the plugin you’re looking for, I’m more than happy to come up with ideas for you to help you solve your problem if you want to give me more information.

Thanks Asbell,

Tom

I haven’t heard from you so I’m marking this as resolved. Let me know if you have any more questions as I’m more than happy to help.

Hey Santosh,

Just checking to see if you still need support. If you do there are some thing you can do to help me check things out for you.

As always I recommend you take a databse and code backup before continuing with these steps, but to help me help you, can you please do the following.

– Download the Health Check plugin.
– Go to the admin area
– Click on Dashboard (near the top left)
– Click the “Debug Information” tab
– Click “Show copy and paste field in English”
– Copy and paste the details here so I can have a look at your setup

Once that is done it’d be nice to see if the plugin is clashing with other plugins you have installed.

This same plugin has a “Troubleshooting” tab. Try clicking that and work your way through there, activating one plugin at a time till you see the issue.

Lastly, we could look at any browser errors you’re getting. You can open the developer tools in your browser, go to the “Console” tab and refresh your page. I’d be interested to see if you got any error outputted.

Let me know if you need any further help with any of these steps.

Thanks,

Tom

I’ll have a look into this today to see if I can replicate or add more error logging to help me diagnose the issue.

Hey Santosh,

I’ve just tried to be hacky to test this out live on the site by changing the test code in the wp-admin area. Unfortunately I’m getting the error when I try to save the code:

“Unable to communicate back with site to check for fatal errors, so the PHP change was reverted. You will need to upload your PHP file change by some other means, such as by using SFTP.”

Can I have a copy of your DB and codebase so that I can test locally?

Alternatively, to test if your theory is correct here is the code blocks that need changing so that the query is using mysqli.

In the the plugin root, go to the login directory and open dp.php. There are two blocks that need changing.
— 1) Changing from this:

    $data = array(
        "db_instance" => new wpdb(
            exlog_get_option("external_login_option_db_username"),
            exlog_get_option("external_login_option_db_password"),
            exlog_get_option("external_login_option_db_name"),
            exlog_get_option("external_login_option_db_host")
        ),
        "dbstructure_table" => exlog_get_option('exlog_dbstructure_table'),
        "dbstructure_username" => exlog_get_option('exlog_dbstructure_username'),
        "dbstructure_password" => exlog_get_option('exlog_dbstructure_password'),
        "dbstructure_first_name" => exlog_get_option('exlog_dbstructure_first_name'),
        "dbstructure_last_name" => exlog_get_option('exlog_dbstructure_last_name'),
        "dbstructure_role" => exlog_get_option('exlog_dbstructure_role'),
        "dbstructure_email" => exlog_get_option('exlog_dbstructure_email'),
    );

— 1) to this:

    $data = array(
        "db_instance" => new mysqli(
            exlog_get_option("external_login_option_db_host"),
            exlog_get_option("external_login_option_db_username"),
            exlog_get_option("external_login_option_db_password"),
            exlog_get_option("external_login_option_db_name")
        ),
        "dbstructure_table" => exlog_get_option('exlog_dbstructure_table'),
        "dbstructure_username" => exlog_get_option('exlog_dbstructure_username'),
        "dbstructure_password" => exlog_get_option('exlog_dbstructure_password'),
        "dbstructure_first_name" => exlog_get_option('exlog_dbstructure_first_name'),
        "dbstructure_last_name" => exlog_get_option('exlog_dbstructure_last_name'),
        "dbstructure_role" => exlog_get_option('exlog_dbstructure_role'),
        "dbstructure_email" => exlog_get_option('exlog_dbstructure_email'),
    );

— 2) From this:

    $users = array();
    if (sizeof($rows) > 0) {
        foreach ($rows as $user_data) {
            array_push($users, exlog_build_wp_user_data($db_data, $user_data));
        };
        return $users;
    }

— 2) To this:

    $rows = $db_data["db_instance"]->query($query_string);

    $users = array();
    while ($user = $rows->fetch_assoc()) {
        array_push($users, $user);
    }
    return $users;

Thanks,

Tom

Hey @kumarsmishra,

I’m more than happy to look into this for you. I’m just reading up on this now.

I presume you don’t have an example database that I can demo this with?

Thanks,

Tom