How can I integrate it with wordpress?

Question

I would like to know if it is possible to  integrate this script  with wordpress -joomla users database  .

Comments

Even I would like to know how to integrate with Vbulletin forum.

Answer 1

You can do this with the single sign-on integration option, but it requires manual coding at this time. On the roadmap is a plan to provide built-in integrations with several content management systems, so please be patient!

Answer 2

It's actually quite easy to code the single sign-on for WordPress. Use the instructions at http://www.question2answer.org/advanced.php

A) Ignore step 3 - use the WordPress database settings from wp-config.php in step 5.

B) In step 7, change null to to 'BIGINT UNSIGNED' (including quotes).

C) Check all is OK down to step 10. You will not have any users until you change the file at step 11:

D) Near the top of qa-external-users.php (e.g line 2 - must be after <?php ), insert:
include_once('/home/server/public_html/yoursitedirectory/wp-load.php');

Change this to match your server. This also works if you put it in the qa-config file instead.

E) About line 118, change the qa_get_login_links function to:
        return array(
            'login' => $relative_url_prefix.'../wp-login.php?redirect='.urlencode('question2answer/'.$redirect_back_to_url),
            'register' => $relative_url_prefix.'../wp-login.php?action=register&redirect='.urlencode('question2answer/'.$redirect_back_to_url),
            'logout' => $relative_url_prefix.'../wp-login.php?action=logout&redirect='.urlencode('question2answer/'.$redirect_back_to_url)
        );

Make sure you change question2answer to the directory you installed Question2Answer!

F) About line 203, change qa_get_logged_in_user function to:
        global $current_user;
        get_currentuserinfo();
        if ($current_user->ID > 0)
            return array(
                'userid' => $current_user->ID,
                'publicusername' => $current_user->display_name,
                'email' => $current_user->user_email,
                'level' => ($current_user->user_level==10) ? QA_USER_LEVEL_ADMIN : QA_USER_LEVEL_BASIC
            );
        return null;

There is more scope with level if you have different user levels, but this works fine for most installs.

G) About line 297 change qa_get_user_email function to:
        global $user_info;
        get_userdata($userid);
        return $user_info->user_email;

[Note: edited re gidgreen comment below]

H) About line 343 change qa_get_userids_from_public function:
        $publictouserid=array();
           
        if (count($publicusernames)) {
            $escapedusernames=array();
            foreach ($publicusernames as $publicusername)
                $escapedusernames[]="'".mysql_real_escape_string($publicusername, $qa_db_connection)."'";
           
            $results=mysql_query(
                'SELECT display_name, ID FROM wp_users WHERE display_name IN ('.implode(',', $escapedusernames).')',
                $qa_db_connection
            );
   
            while ($result=mysql_fetch_assoc($results))
                $publictouserid[$result['display_name']]=$result['ID'];
        }
       
        return $publictouserid;

Note that you might need to change the users table name prefix in the SELECT statement (wp_ is standard - but confirm this by checking wp-config.php or your database).

I) About line 425 change qa_get_public_from_userids function to:
        $useridtopublic=array();
       
        if (count($userids)) {
            $escapeduserids=array();
            foreach ($userids as $userid)
                $escapeduserids[]="'".mysql_real_escape_string($userid, $qa_db_connection)."'";
           
            $results=mysql_query(
                'SELECT display_name, ID FROM wp_users WHERE ID IN ('.implode(',', $escapeduserids).')',
                $qa_db_connection
            );
   
            while ($result=mysql_fetch_assoc($results))
                $useridtopublic[$result['ID']]=$result['display_name'];
        }
       
        return $useridtopublic;

Again, check the users table prefix in the SELECT statement.


There are other optional functions that might improve your installation, but the above will give you a working platform accessible by your current users (note that users only get listed in the Users display when they have contributed)

Comments

Wow. Thanks a million for posting this. There's one issue - the qa_get_user_email(...) function needs to return the email address for the user provided as the $userid parameter, not necessarily the current user. Apart from that I haven't tested it but the code makes sense, so thanks again!

---

Sorry gidgreen - I should not have rushed it. Now fixed - thank goodness that, unlike a certain other Q&A application, we can edit entries here :-)

---

I do not understand what do you mean as

B) In step 7, change null to to 'BIGINT UNSIGNED' (including quotes). ????

how???

function qa_get_mysql_user_column_type()   to ......? any sample ?

thank in advance

---

Once I perform step F), any/all q2a pages show nothing (at least end-user display shows this).  Any advice as to how to fix this or at least to get a diagnostic as to what's not working right?

---

@Henry. I'm guessing you mean that old questions have gone? This is expected, as you have switched user tables, so old Q2A users are not accessible. It should be fairly easy to import Q2A user table to WordPress, but I've never tried it.

@minnkyaw. Sorry, but I don't understand. Why not raise a new related question with more details of what you have tried and where it is failing.

---

Hi shrewdies. Nope that's not what I meant:

I started with a fresh q2a install. I've tested your code and it appears step F) is causing all my pages to come up blank (no content). None of the other code causes this problem and I've narrowed it down to this line in step F): get_currentuserinfo();

I think the problem is that it isn't detecting the WP user session properly. When I remove that line, all my q2a pages appear again for the end user but of course the wordpress login session is never detected.

Everything else seems to be ok for now (I went into the qa_posts and manually changed the user_id of a sample anonymous post from NULL to 1, and it did in fact grab the username associated with user_id = 1 in wp_users).

---

Sorry for the misunderstanding Henry.

It suggests that WordPress isn't being called first to set $current_user (you could check this with a temporary print_r($current_user);

Somewhere, I've written about integrating the Q2A theme into WordPress, but I can't find it right now.

In your selected Q2A qa-theme.php you need to call WordPress. The following is probably overkill, but it works:
<?php
include_once('../wp-config.php');
include_once('../wp-load.php');
include_once('../wp-includes/wp-db.php');
global $wpdb;


If you want to wrap the WordPress Headers etc, then the following
function does the trick:
    class qa_html_theme extends qa_html_theme_base
    {
        function head_custom() // add WordPress Header
        {
            $this->output(get_header());
        }

        function body_suffix()
        {
            $this->output(get_footer());
        }
   
    }

---

I've added the include_once lines to qa-config.php, qa-external-users.php, qa-theme-base.php (overkill, I wanted to make sure -- I also adjusted the path to reflect my wp directory) but still can't get a login session to be recognized. The print_r($current_user); outputs this:

WP_User Object ( [data] => [ID] => 0 [id] => 0 [caps] => Array ( ) [cap_key] => [roles] => Array ( ) [allcaps] => Array ( ) [first_name] => [last_name] => [filter] => )

So it looks like [ID] is stuck at 0 even after I login to WP and go back to the page. Btw, the login redirects from step E) don't work like they should. They bring me to the WP login page but once I log in I am brought to the WP control panel instead of back to Q2A. Doesn't seem like it's a related issue though.

Did get this working? If so, could you send me your q2a install? I'll run a comparison of the files. Or if you'd like, I can send mine.

---

It definitely works OK at http://www.shrewdies.net/web-hosting-questions/

I think it might be an issue regarding relative paths vs absolute ones. My q2a install sits directly below the root, so ../wp-config.php works for me, but you might need the full path, similar to my earlier correction to the path in D)

My contact details are at the above link if you want to take this to email.

---

Thanks for the help. I was able to wrap the wordpress headers, which seemed strange, since apparently the function in theme.php was able to access the necessary wordpress variables yet external-users.php couldn't get the login session, even with the paths pointing to the right directory.

However, after observing your site, I decided to move all WP files into the root directory instead of having a wordpress directory. Login sessions were recognized as a result. Definitely a path issue.

I've switched to the absolute paths anyhow since I read there was an issue with AJAX features.


I've run into a new issue with the 1.2 Beta 1 now with external-users... Anytime I try to post a question, I get this error:

Question2Answer query failed:

INSERT INTO qa_posts (categoryid, type, parentid, userid, cookieid, createip, title, content, tags, notify, created) VALUES (NULL, _utf8 'A', 1, _utf8 '2', NULL, INET_ATON(_utf8 '61.51.76.176'), NULL, _utf8 'this is a test', NULL, NULL, NOW())

Error 1364: Field 'acount' doesn't have a default value

---

Please see here: http://www.question2answer.org/qa/1643/1-2-beta-1-external-users-error#a1649