Quote: "Any help is appreciated on how I can accomplish this task, Thanks very much!
OH! And if it matters at all, I'm using SMF (Simple machines forums)."
I have done it few days ago.
in DBPro you have to code the password with MatrixUtil dll
// Ask User
Display_Name$ = ""
input "User Name: ",User_Name$
input "User Pass: ",User_Pass$
// SMF 2 Password
User_Pass$ = HASH SHA1(FAST LOWER$(User_Name$)+User_Pass$)
and send to a php page User_Name$ and User_Pass$ by post or get
(i send a encrypted version of them with a hash for more secure)
In the php page, you ask the mysql server like that (here, it's for SMF 2)
// Include SMF Settings
@require('Settings.php');
if (empty($ssi_db_user))
$db = @mysql_connect($db_server, $db_user, $db_passwd) or die("KO,Script MySQL Connect");
else
$db = @mysql_connect($db_server, $ssi_db_user, $ssi_db_passwd) or die("KO,Script MySQL SSI Connect");
@mysql_select_db($db_name,$db) or die("KO,Script MySQL DB");
$tb = $db_prefix.'members';
$sql = "SELECT id_member,id_group,id_post_group,last_login,real_name,passwd,is_activated FROM $tb WHERE member_name='".$user_name."' ";
$req = @mysql_query($sql) or die("KO,Script MySQL Query");
in the mysql data returned you can check all what you want
if 'is_activated' > 10 : User is banned
if 'is_activated' !=1 : User account is not activated
if 'last_login' ==0 : User never login to the forum
'real name' is the display name
for what you want : (5 or more, depend of your member group settings)
if 'id_post_group' <5 : Low Member Post Group
and ... compare the row 'passwd' with the $user_pass you have receveid
