// $result = mysql_query("SELECT * FROM $table WHERE username = '******' AND password = '******'");
$result = $member->getOneByUsernameAndPassword($username, $password);
if ($result->num_rows > 0) {
$row = $result->fetch_array();
$leadproviderid = $row['leadProviderId'];
$_SESSION['username'] = htmlspecialchars($apiusername);
// htmlspecialchars() sanitises XSS
$session['memberId'] = $row["id"];
print_r('<code> 0 </code><msg>(Authorized), Authentication Successfull </msg>');
print_r("</header>");
/*
mysql_connect($host, $user, $pass);
$result_rules = "SELECT rl.PHPLocation, rl.value, rl.FieldName FROM `member` m LEFT JOIN `RulesManagementSet` rm ON rm.`memberID` = `m`.`id` LEFT JOIN `rules` rl ON `rl`.`rulesID` = `rm`.`rulesID` WHERE username = '******' AND rm.Active = 1";
$result_rl = mysql_query($result_rules);
*/
$result_rl = $rules->getRulesByMemberId($memberId);
//echo '<sql>';
//print_r($result_rules);
//echo '</sql>';
$rules_Array = array();
while ($row = $result_rl->fetch_array()) {
$rules_Array[] = $row;
}
$bbcore = new BBCORE($urlstring, $rules_Array);
} else {
// Invalid username/password
print_r('<code> 401 </code><msg>(Not Authorized), Authentication Failed, Failure with 1 or more API Authentication Elements Supplied </msg>');
print_r("</header>");
//echo $password;
//header('Location: http://20ae-fscbb-primary.hgsitebuilder.comindex.php');
}
$array3 = flatten_array($array, 2, $newarraytest, $last_subarray_found);
// print_r($array3 );
// $apiusername = $_POST["apiusername"];
// $apipassword = $_POST["apipassword"];
// $apikey = $_POST["apikey"];
$apiId = $_POST["apiId"];
$apiKey = $_POST["apiKey"];
$apiRef = $_POST["apiRef"];
$resultLP = $leadProvider->getOneByAPIIdAndKey($apiId, $apiKey);
if ($resultLP->num_rows == 1) {
echo '<code> 0 </code><msg>(Authorized), Authentication Successful Post received</msg>';
$resultMem = $member->getOneByAPIRef($apiRef);
if ($resultMem->num_rows == 1) {
echo "Checking vs Ruleset";
$row = $resultMem->fetch_array();
$rules_result = $rules->getRulesByMemberId($row['id']);
$rulesArray = array();
// print_r($array3);
while ($row = $rules_result->fetch_array()) {
// instead of copying to a new array simply run the rules test now
$rulesArray[] = call_user_func($row["PHPLocation"], $row["value"], strtoupper($row["FieldName"]), $array3);
//$rules_Array[] = $row;
}
//$bbcore = new BBCORE($array3, $rules_Array, $dbDataArr);
} else {
echo "Error in Ruleset";
}
} else {
// fail
$bolUnAuth = true;
}
