Add / Update New Users

[nainil]

I am porting users from our internal cms system to VBulletin.

The internal cms system uses md5 for passwords. So I am using the attached file to add new users using the attached file.

What I want is:

1. To modify this file in such a way that if the user exists in both the system, it should check the password in our cms and update it on vbulliten with the new password. Note our cms stores password in md5. Vbulliten will need to update this user to the md5 password.

2. To mark users inactive if they are inactive in our corporate cms.

What would be the queries for these 2 activities? Any help would be appreciated.

PHP Code:

<?php

function register_in_vb($username, $password, $email)
{
    define('VB_AREA', 'External');
    define('SKIP_SESSIONCREATE', 0);
    define('SKIP_USERINFO', 1);
    //define('CWD', './../../forum/' );
    require_once('includes/init.php');
    require_once('includes/functions_misc.php');

    $registry = $vbulletin; 
    unset($vbulletin); 
    $vbDb = $registry->db; 
    //declare as global vbulletin's registry and db objects 
    global $vbulletin,$db; 
    $vbulletin = $registry; 
    //backup the original $db object (new!!) 
    $backupdb = $db; 
    $db = $vbDb; 

    $newuser =& datamanager_init('User', $vbulletin, ERRTYPE_ARRAY);
    $newuser->set('username', $username);
    $newuser->set('email', $email);
    $newuser->set('password', $password);
    $newuser->set('usergroupid', 2);
    
    $newuser->pre_save();
    
    if(empty($newuser->errors)){
        $db = $backupdb;
        echo 1;
        return $newuser->save();
        
    }else{
        $db = $backupdb;
        echo 0;
        print_r( $newuser->errors);
    }
        
}

$key = $_GET['key'];
$username = $_GET['username'];
$password = $_GET['password'];
$email = $_GET['email'];

if ($key=='mysecretkey')
{
    // Add the users to vBulletin
    $newuserid = register_in_vb($username, $password, $email);
}

?>

[kh99]

I don't think there's any way to convert a password from your old cms system to a vb password. Maybe you could add code to vb for an alternate way to check passwords that matches your old cms and check both when the user enters a password.

Is there such a thing as an inactive user in vb? I suppose you could create a user group for inactive users, then set the usergroup field accordingly.