users_login.php
Hey Ray
On the users_login.php page, have updated the SA authenticate login
<?php
if(isset($_POST["LogIN"]) || isset($_POST["LogIN_x"])){
$WA_Auth_Parameter = array(
"connection" => $PowerCMSConnection,
"database" => $database_PowerCMSConnection,
"tableName" => "pcms2_users",
"columns" => explode($WA_Auth_Separator,"UserEmail".$WA_Auth_Separator."UserPassword"),
"columnValues" => explode($WA_Auth_Separator,"".((isset($_POST["userName"]))?$_POST["userName"]:"") ."".$WA_Auth_Separator."".((isset($_POST["Password"]))?$_POST["Password"]:"") .""),
"columnTypes" => explode($WA_Auth_Separator,"text".$WA_Auth_Separator."text"),
"sessionColumns" => explode($WA_Auth_Separator,"UserID".$WA_Auth_Separator."UserGroupID".$WA_Auth_Separator."UserFirstName".$WA_Auth_Separator."UserLastName".$WA_Auth_Separator."UserEmail"),
"sessionNames" => explode($WA_Auth_Separator,"UserID".$WA_Auth_Separator."UserGroupID".$WA_Auth_Separator."UserFirstName".$WA_Auth_Separator."UserLastName".$WA_Auth_Separator."UserEmail"),
"successRedirect" => "",
"failRedirect" => "",
"gotoPreviousURL" => FALSE,
"keepQueryString" => FALSE
);
WA_AuthenticateUser($WA_Auth_Parameter);
}
?>
to
<?php
$Authenticate = new WA_MySQLi_Auth($DBConnection);
$Authenticate->Action = "authenticate";
$Authenticate->Trigger = (isset($_POST["LogIN"]) || isset($_POST["LogIN_x"]));
$Authenticate->Name = "LoggedIn";
$Authenticate->Table = "pcms2_users";
$Authenticate->addFilter("UserEmail", "=", "s", "".((isset($_POST["userName"]))?$_POST["userName"]:"") ."");
$Authenticate->addFilter("UserPassword", "=", "s", "".((isset($_POST["Password"]))?$_POST["Password"]:"") ."");
$Authenticate->storeResult("UserID", "UserID");
$Authenticate->storeResult("UserGroupID", "UserGroupID");
$Authenticate->storeResult("UserFirstName", "UserFirstName");
$Authenticate->storeResult("UserLastName", "UserLastName");
$Authenticate->storeResult("UserEmail", "UserEmail");
$Authenticate->AutoReturn = false;
$SuccessRedirect = "";
$FailedRedirect = "";
if (function_exists("rel2abs")) $SuccessRedirect = $SuccessRedirect?rel2abs($SuccessRedirect,dirname(__FILE__)):"";
if (function_exists("rel2abs")) $FailedRedirect = $FailedRedirect?rel2abs($FailedRedirect,dirname(__FILE__)):"";
$Authenticate->SuccessRedirect = $SuccessRedirect;
$Authenticate->FailRedirect = $FailedRedirect;
$Authenticate->execute();
?>
the resulting page is blank and the error is
Warning: require_once(../webassist/mysqli/authentication.php): failed to open stream: No such file or directory in /home/motle7bk/public_html/clients/template/admin_cms/users_login.php on line 21
Fatal error: require_once(): Failed opening required '../webassist/mysqli/authentication.php' (include_path='.:/opt/alt/php54/usr/share/pear:/opt/alt/php54/usr/share/php') in /home/motle7bk/public_html/clients/template/admin_cms/users_login.php on line 21
have checked the webassist/mysqli/ folder and authentication.php has not been created