By SimonVlc on

Hi all,

I don´t want to generate a discussion between drupal forum system against vbulletin. The truth is that I run a Drupal community with a vBulletin forum for a while yet, and It would be great if I can merge the two login systems into one.

I can offer 100$ for anyone interested in developing this module, and because I´m sure that I´m not the only one interested in this feature, I encourage some other people to join and making this a good opportunity for both developers and users.

Only an idea. Bye all, Simon.

⋅ Categories: Drupal 4.6.x

Comments

drubeedoo’s picture

drubeedoo commented

http://www.vbdrupal.org/

SimonVlc’s picture

SimonVlc commented

The problem with vbDrupal is that it doesn´t allow compatibility with all modules, and we can´t be sure of the continuity of the development.

I think it´s better to develop a drupal module and maintain the independenxy between the 2 systems.

styro’s picture

styro commented

A vbulletin developer or user wrote something for this a little while back.

Try searching for Drupal on the vbulletin site. That should hopefully pick something up.

--
Anton

adixon’s picture

adixon commented

i've got a client who thinks they want something like this as well, but as I look at it, it seems to me that they're not using any features in vbulletin that aren't in drupal comments, so i've written a short migration script that fills in an empty 4.7 install with data from a populated vbulletin install (including generating empty nodes for each thread, filling the users table, and then adding all the comments). I can email it to you if you think that might be helpful. I haven't looked at how the passwords are encrypted, it might be that the users will have to get new passwords, or you could write a little hack into the users module to use whatever encryption vbulletin uses (probably already solved by vbDrupal).

SimonVlc’s picture

SimonVlc commented

Thanks adixon,

but what I really need is a common login system for both systems.

I can upper the reward up to 200$ closing the next month (April 01) if anyone interested.

Regards, Simon.

tamarian’s picture

tamarian commented

If by "coomon login", you just mean accepting the password of either system, then it's not a big major developemnt, and can be done by a module. The problem is if you want more than just bypassing the password, like maintaining a common session after you login, or be able to move between both sites without re-login. This will require major changes to either vBulletin, or Drupal, to synchronize sessions, user data and cookies, and I can't see it happening with just modules.

SimonVlc’s picture

SimonVlc commented

Hi tamarian,

I´m referring just to that. I heard that a module that makes that for phpbb and drupal... could it be?

Regards, Simon.

tamarian’s picture

tamarian commented

If there's already a module for phpBB that does it, then it can be re-used, and just copy the password/login code from vB Drupal.

alexis’s picture

alexis commented

Hi, Adixon, could you please provide a link to your migration script or contact me? I have a vBulletin installation (3.0.3 and was thinking on upgrading to 3.5.x) and I'm moving my whole site to Drupal 4.7, would love to manage everything with just Drupal.

Thanks!

Alexis Bellido - Ventanazul web solutions

Scott Halliday’s picture

Scott Halliday commented

Simon,

You are definately not the only one looking for this type of functionality between drupal and vBulletin. There are hundreds if not thousands of vBulletin sites out there because it is probably the best forums software available and the support is incredible. Having the two login systems merged into one would cerainly encourage many more to jump on the Drupal bandwagon, myself included. I keep watching and waiting, hoping someone eventually releases a module to do this.

adixon’s picture

adixon commented

there's at least two potential issues here:

1. getting drupal to recognize vbulletin logins. I've done this for a migration, it's not to difficult. The trick is that vbulletin does a md5 on the password with a 'salt', so you need to know the user's salt somehow. I did a bad thing and just stuck it in the drupal users' signature field (and then rewrote the password and cleared the signature field the first time they log in to drupal).

2. sharing sessions. In the site settings.php file, there are some php settings you can put in, and you can specify the name of the server session token. I've done this to share a login session between two drupal installs on the same machine, so I'm guessing you can so something similar for a drupal and vbulleting install.

Of course, this isn't a recipe, and it'll depend on how you want your to applications to interact which of these pieces you might want to use. I've appended my little patch for the user.module (from 4.7, one of the rcs)

svn diff -r1 user.module
Index: user.module
===================================================================
--- user.module (revision 1)
+++ user.module (working copy)
@@ -53,8 +53,9 @@
       $params[] = $value;
     }
     else if ($key == 'pass') {
-      $query[] = "pass = '%s'";
-      $params[] = md5($value);
+      $query[] = "((pass = '%s') OR (pass = md5(concat('%s',u.signature))))";
+      $params[] = $md5_pass = md5($value);
+      $params[] = $md5_pass;
     }
     else {
       $query[]= "LOWER($key) = LOWER('%s')";
@@ -66,7 +67,9 @@
   if (db_num_rows($result)) {
     $user = db_fetch_object($result);
     $user = drupal_unpack($user);
-
+    if (isset($array['pass']) && ($user->pass != $md5_pass)) {
+      db_query("UPDATE {users} SET pass = '%s', signature = '' WHERE uid = %d", $md5_pass, $user->uid);
+    }
     $user->roles = array();
     if ($user->uid) {
       $user->roles[DRUPAL_AUTHENTICATED_RID] = 'authenticated user';

A quick tour of the changes:
1. add an another way to match the password (ie used md5(concat('%s',u.signature)), but you'll have to replace signature with your vbulletin users' salt)
2. update the signature and password with the drupal version.

This is NOT a way to keep the systems in parallel though - you'd want to pick one or the other as your login authority and just have the other system accept the session info, or something like that ...

drupaldevloper’s picture

drupaldevloper commented

i am using the drupalvb module, but as specified in its feature it want work for common login.

read you above post, good work.

can u pleas provide me the full detail to work on above issue

for
1. getting drupal to recognize vbulletin logins. I've done this for a migration, it's not to difficult. The trick is that vbulletin does a md5 on the password with a 'salt', so you need to know the user's salt somehow. I did a bad thing and just stuck it in the drupal users' signature field (and then rewrote the password and cleared the signature field the first time they log in to drupal).

2. sharing sessions. In the site settings.php file, there are some php settings you can put in, and you can specify the name of the server session token. I've done this to share a login session between two drupal installs on the same machine, so I'm guessing you can so something similar for a drupal and vbulleting instal

adixon’s picture

adixon commented

I provided a lot of detail in my post. Please ask a more specific question after you've read it.