[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);
}

?>