[Resolved] Using my Member's with VB3

[Sayian]

I have a very large member base ... My site use's a MySQL backend
I know this can be done b/c their is a site doing it already ..

What i need to do is make vbulletin able to use my member list's , or copy the member list's , or something.

The way the site that ive seen has it , is when they register on vbulliten , they have to register using their account or it wont work .. how this is done , i have no clue.

Any help on this issue would be GREATLY appriciated.

Im not asking for anyone to do this for me .. b/c i know they wont. I want to learn how to do this .. it shouldnt be too complicated should it?

Is anyone avaliable on an instant messenger that could give me some advice or guide me through this .. i really need the help. Thanks.

[Sayian]

Ok , not a very friendly crowd i see.

Forget the instant messenger thing.

Can someone just help me figure out how i would go about this?

[drew010]

i think one way you could do it is to edit the vbulletin registration files to connect to your existing user database, if the username and password they entered for vb registration isnt in your database, you raise an error and tell them they must use their existing name and proceed with normal vb reg.

[Sayian]

I see where your getting at , i will try to come up with something , thanks.

[Sayian]

Ok , im gonna take your advice drew and check to see if the member they are posting exsit's in my other database , if so , then continue with registration , if not , then exit.

a little confused on how to do this ..

here is where im at so far

// ############################### start add member ###############################
if ($_POST['do'] == 'addmember')
{

globalize($_POST, array('options'));

if (!$vboptions['allowregistration'])
{
	eval(print_standard_error('error_noregister'));
}


// check for multireg
if ($bbuserinfo['userid'] != 0 AND !$vboptions['allowmultiregs'])
{
	$username = $bbuserinfo['username'];
	eval(print_standard_error('error_alreadyregistered'));
}

$errors = array();

// check username does not contain semi-colons
if (preg_match('/(?<!&#[0-9]{3}|&#[0-9]{4}|&#[0-9]{5});/', $_POST['username']))
{
	//eval(print_standard_error('error_username_semicolon'));
	eval('$errors[10] = "' . fetch_phrase('username_semicolon', PHRASETYPEID_ERROR) . '";');
}

// strip 'blank' ascii chars if admin wants to do so
$_POST['username'] = strip_blank_ascii($_POST['username'], ' ');

// convert any whitespace to a single space to prevent users entering 'user    one' to look like 'user one'
$_POST['username'] = trim(preg_replace('#\s+#si', ' ', $_POST['username']));


  ////////////////////////////////////CHECK FOR USER IN MY USERS TABLE //////////////////////////////////////





 ////////////////////////////////////////////////////////////////////////////////////////////////////////////

Their is already a database connection open for vbulletin's registration script obviously .. so is it safe to open another one? and what would i use for this ..

[drew010]

its safe to open another connection, just make sure you assign the resource to a new variable and use that in all your queries.
i.e.
$my_connection = mysql_connect(....)
mysql_query($q, $my_connection);

[Sayian]

So this SHOULD be as easy as just connecting to my other database , seeing if the account exist's , if mysql_num_rows returns true , then check the username and password against the return , if correct , no flag , proceed with registration , if not correct , flag , error output " You Must register with your correct name/pass on sitename" , right?

[Sayian]

I have coded some code .. could someone please help me to find where i am goign wrong

//this is supposed to connect to my other database to see if they have an account on my site before they can register with vbulliten , but it is giving me an error saying

  define("DB_SERVER", "localhost"); // Server
  define("DB_USER", "xxxxxx"); // Username
  define("DB_PASS", "xxxxxx"); // User pass
  define("DB_NAME", "xxxxxx"); // Database
  mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error()); // Connection
  mysql_select_db(DB_NAME) or die(mysql_error()); // Selection of database
  // start user check at other site

 $check = ("SELECT username, password FROM shocc_users WHERE username='$_POST['username']' AND password='$_POST['password']'");
 $result = mysql_query($check) or die (mysql_error());
 		// OK if results were found ...
if(mysql_num_rows($check) = 0){

  eval('$errors[20] = "' . fetch_phrase('usernametaken', PHRASETYPEID_ERROR) . '";');
}

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in

[drew010]

try changing
$check = ("SELECT username, password FROM shocc_users WHERE username='$POST['username']' AND password='$POST['password']'");
to
$check = ("SELECT username, password FROM shocc_users WHERE username='{$POST['username']}' AND password='{$POST['password']}'");

[Sayian]

Ok , next error is saying
Fatal error: Can't use function return value in write context

what does this mean?

thanks for helping me with this drew =)

[drew010]

im not sure about that. does it give a line number and if so paste like 10 lines before and after the given number.

[Sayian]

Line 211

which is the if(mysql_num_rows = 0) statement

// going up

// ############################### start add member ###############################
if ($_POST['do'] == 'addmember')
{

globalize($_POST, array('options'));

if (!$vboptions['allowregistration'])
{
	eval(print_standard_error('error_noregister'));
}


// check for multireg
if ($bbuserinfo['userid'] != 0 AND !$vboptions['allowmultiregs'])
{
	$username = $bbuserinfo['username'];
	eval(print_standard_error('error_alreadyregistered'));
}

$errors = array();

// check username does not contain semi-colons
if (preg_match('/(?<!&#[0-9]{3}|&#[0-9]{4}|&#[0-9]{5});/', $_POST['username']))
{
	//eval(print_standard_error('error_username_semicolon'));
	eval('$errors[10] = "' . fetch_phrase('username_semicolon', PHRASETYPEID_ERROR) . '";');
}

// strip 'blank' ascii chars if admin wants to do so
$_POST['username'] = strip_blank_ascii($_POST['username'], ' ');

// convert any whitespace to a single space to prevent users entering 'user    one' to look like 'user one'
$_POST['username'] = trim(preg_replace('#\s+#si', ' ', $_POST['username']));


  ////////////////////////////////////CHECK FOR USER IN MY USERS TABLE //////////////////////////////////////

  define("DB_SERVER", "localhost"); // Server
  define("DB_USER", "xxx"); // Username
  define("DB_PASS", "xxx"); // User pass
  define("DB_NAME", "xxx"); // Database
  mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error()); // Connection
  mysql_select_db(DB_NAME) or die(mysql_error()); // Selection of database
  // start user check 

 $check = ("SELECT username, password FROM shocc_users WHERE username='{$_POST['username']}' AND password='{$_POST['password']}'");

 $result = mysql_query($check) or die (mysql_error());
 		// OK if results were found ...
if(mysql_num_rows($check) = 0){
         eval('$errors[20] = "' . fetch_phrase('usernametaken', PHRASETYPEID_ERROR) . '";');
}


 ////////////////////////////////////////////////////////////////////////////////////////////////////////////

[mtmosier]

if(mysql_num_rows($check) = 0){

Change to

if(mysql_num_rows($result) == 0){

The single equals sign (assignment) instead of double (comparison) would give that error.

[Sayian]

Yes that solved the problem , thanks , let me get back to work , i appriciate all of your reply's on this.

[Sayian]

Ok 1 more issue ..

It's flagging error on account's that i know exist in my other site database ..

My other database user's MD5 encryption for the password .. so to select "username" and "password" , it's gonna select a MD5 password from my other database right? b/c they are stored encrpted .. so how can i check the password they are posting to register the VB account against my Md5 pass in my other database?

[mtmosier]

Try

$check = ("SELECT username, password FROM shocc_users WHERE username='{$_POST['username']}' AND password=MD5('{$_POST['password']}')");

[Sayian]

also it is giving me this error at the top of the screen , the page still loads tho

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /register.php on line 211

i dont understand why it would be saying this.

[drew010]

$result = mysql_query($check) or die (mysql_error());
// OK if results were found ...
if(mysql_num_rows($check) = 0){

put $result in mysql_num_rows instead of $check

[Sayian]

Ok , i have changed the password to use MD5 ,

But it still is coming back as the user account that im trying to register doesnt exsist in my site , when i know it does .. i just logged into it on my site to test.

[drew010]

try connecting to mysql from the command line and try issuing the queries by hand til you find out exactly how it needs to be formed, then put it in php code