//Split up the fields to the variables
$username = $fields['username'];
$ip = $fields['wpmem_reg_ip'];
$mail = $fields['user_email'];
$memberguidOut = '';
$password = $fields['password'];
$date = $fields['user_registered'];
$classOut = '';
$stateOut = '';
$forestOut = '';
$resultOut = '';

$servername = "someServerIP";
$username = "someUsername";
$password = "somePW";
$myDB = "someDB";

//ini_set('mssql.min_error_severity',         11);
//init_set('mssql.min_message_severity',        11);


//connection to the database
$conn = mssql_connect($servername, $username, $password)
or die("Couldn't connect to SQL Server on $servername");

//select a database to work with
$selectedDB = mssql_select_db($myDB, $conn)
or die("Couldn't open database $myDB");

$proc = mssql_init('someSP', $selectedDB) or die(mssql_get_last_message());

mssql_bind($proc, "@member_id",        $username,        SQLVARCHAR,    FALSE, FALSE, 60);
mssql_bind($proc, "@ip",               $ip,              SQLVARCHAR,    FALSE, FALSE, 60);
mssql_bind($proc, "@mail",             $mail,            SQLVARCHAR,    FALSE, FALSE, 60);
mssql_bind($proc, "@member_guid",      $memberguidOut,   SQLINT2,       TRUE);
mssql_bind($proc, "@pwd",              $password,        SQLVARCHAR,    FALSE, FALSE, 60);
mssql_bind($proc, "@input_date",       $date,            SQLVARCHAR,    FALSE, FALSE, 60);
mssql_bind($proc, "@class",            $classOut,        SQLINT1,       TRUE);
mssql_bind($proc, "@state",            $stateOut,        SQLINT1,       TRUE);
mssql_bind($proc, "@forest",           $forestOut,       SQLINT1,       TRUE);
mssql_bind($proc, "@result",           $resultOut,       SQLINT1,       TRUE);

$result = mssql_execute($proc) or die($wpmem_themsg = mssql_get_last_message());
mssql_free_statement($proc) or die($wpmem_themsg = mssql_get_last_message());