I added your code ad below:
// Call User Validated event
$row = $rs->fields;
$UserProfile->assign($row);
$UserProfile->delete('Password'); // Delete password
$valid = $this->User_Validated($row) !== FALSE; // For backward compatibility
}
and the errors when input wrong password:
( ! ) Notice: unserialize(): Error at offset 172 of 1088 bytes in D:\wamp64\www\vn1erpupgrade\phpfn15.php on line 10450
Call Stack
Time Memory Function Location
1 0.0004 389520 {main}( ) ...\login.php:0
2 0.1867 13554408 PHPMaker2019\Material\login->run( ) ...\login.php:23
3 0.2308 15260024 PHPMaker2019\Material\UserProfile->exceedLoginRetry( ) ...\login.php:495
4 0.2309 15260024 PHPMaker2019\Material\UserProfile->loadProfileFromDatabase( ) ...\phpfn15.php:10484
5 0.2356 15288128 PHPMaker2019\Material\UserProfile->loadProfile( ) ...\phpfn15.php:10414
6 0.2356 15288128 unserialize ( ) ...\phpfn15.php:10450
( ! ) Notice: unserialize(): Error at offset 172 of 1088 bytes in D:\wamp64\www\vn1erpupgrade\phpfn15.php on line 10450
Call Stack
Time Memory Function Location
1 0.0004 389520 {main}( ) ...\login.php:0
2 0.1867 13554408 PHPMaker2019\Material\login->run( ) ...\login.php:23
3 0.4983 15263168 PHPMaker2019\Material\AdvancedSecurity->validateUser( ) ...\login.php:525
4 0.5032 15289872 PHPMaker2019\Material\UserProfile->loadProfileFromDatabase( ) ...\phpfn15.php:6444
5 0.5085 15316448 PHPMaker2019\Material\UserProfile->loadProfile( ) ...\phpfn15.php:10414
6 0.5086 15316448 unserialize ( ) ...\phpfn15.php:10450
=======================
Debug
0.001980: Connecting... hostname: 10.0.1.251\xnkserver2; params: array ( 'ReturnDatesAsStrings' => true, 'CharacterSet' => 'UTF-8', 'Database' => 'MATERIAL', )
0.004950: (mssqlnative): SET DATEFORMAT ymd
0.006630: Running query: 'SET DATEFORMAT ymd'; input array: false; result: NULL
...
0.434231: (mssqlnative): UPDATE [dbo].[employees] SET [Profile]='a:3:{s:15:"LoginRetryCount";i:1;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:0:"";}' WHERE ([Username] = 'vuong')
0.436194: Running query: 'UPDATE [dbo].[employees] SET [Profile]=\'a:3:{s:15:"LoginRetryCount";i:1;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:0:"";}\' WHERE ([Username] = \'vuong\')'; input array: false; result: NULL
=============================debug when enter correct password===================
Debug
0.002366: Connecting... hostname: 10.0.1.251\xnkserver2; params: array ( 'ReturnDatesAsStrings' => true, 'CharacterSet' => 'UTF-8', 'Database' => 'MATERIAL', )
...
0.199358: (mssqlnative): UPDATE [dbo].[employees] SET [Profile]='a:31:{s:15:"LoginRetryCount";i:0;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:10:"2018/08/31";s:8:"LastName";s:14:"Dương Quốc";s:9:"FirstName";s:8:"Vượng";s:5:"Title";s:30:"Chief of Import Export Departm";s:15:"TitleOfCourtesy";s:3:"Mr.";s:9:"BirthDate";N;s:8:"HireDate";N;s:7:"Address";N;s:4:"City";N;s:6:"Region";N;s:10:"PostalCode";N;s:7:"Country";N;s:9:"HomePhone";N;s:9:"Extension";N;s:5:"Email";s:19:"vuong@seshin.com.vn";s:5:"Photo";N;s:5:"Notes";N;s:9:"ReportsTo";i:0;s:9:"UserLevel";i:-1;s:8:"Username";s:5:"vuong";s:9:"Activated";s:1:"Y";s:7:"Profile";s:126:"a:3:{s:15:"LoginRetryCount";i:1;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:0:"";}";s:21:"NGAYBAOCAOHOPDONGFROM";s:27:"2014-04-01 00:00:00.0000000";s:14:"NGAYBAOCAOFROM";s:27:"2014-04-01 00:00:00.0000000";s:12:"NGAYBAOCAOTO";s:27:"2018-12-31 00:00:00.0000000";s:16:"FILTER_LOAI_HANG";s:47:"LOAI_HANG=''1'' or LOAI_HANG=''2'' or LOAI_HANG=''3''";s:10:"EmployeeID";i:1;s:13:"FILTER_HDGCID";s:5:"73246";s:19:"FILTER_MATERIALTYPE";s:3:"1,2";}' WHERE ([Username] = 'vuong')
0.202739: Running query: 'UPDATE [dbo].[employees] SET [Profile]=\'a:31:{s:15:"LoginRetryCount";i:0;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:10:"2018/08/31";s:8:"LastName";s:14:"Dương Quốc";s:9:"FirstName";s:8:"Vượng";s:5:"Title";s:30:"Chief of Import Export Departm";s:15:"TitleOfCourtesy";s:3:"Mr.";s:9:"BirthDate";N;s:8:"HireDate";N;s:7:"Address";N;s:4:"City";N;s:6:"Region";N;s:10:"PostalCode";N;s:7:"Country";N;s:9:"HomePhone";N;s:9:"Extension";N;s:5:"Email";s:19:"vuong@seshin.com.vn";s:5:"Photo";N;s:5:"Notes";N;s:9:"ReportsTo";i:0;s:9:"UserLevel";i:-1;s:8:"Username";s:5:"vuong";s:9:"Activated";s:1:"Y";s:7:"Profile";s:126:"a:3:{s:15:"LoginRetryCount";i:1;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:0:"";}";s:21:"NGAYBAOCAOHOPDONGFROM";s:27:"2014-04-01 00:00:00.0000000";s:14:"NGAYBAOCAOFROM";s:27:"2014-04-01 00:00:00.0000000";s:12:"NGAYBAOCAOTO";s:27:"2018-12-31 00:00:00.0000000";s:16:"FILTER_LOAI_HANG";s:47:"LOAI_HANG=\'\'1\'\' or LOAI_HANG=\'\'2\'\' or LOAI_HANG=\'\'3\'\'";s:10:"EmployeeID";i:1;s:13:"FILTER_HDGCID";s:5:"73246";s:19:"FILTER_MATERIALTYPE";s:3:"1,2";}\' WHERE ([Username] = \'vuong\')'; input array: false; result: NULL
...
=========================Profile when enter wrong password====================
a:3:{s:15:"LoginRetryCount";i:1;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:0:"";}
=========================Profile when enter correct password==========================
a:31:{s:15:"LoginRetryCount";i:0;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:10:"2018/08/31";s:8:"LastName";s:14:"Duong Qu?c";s:9:"FirstName";s:8:"Vu?ng";s:5:"Title";s:30:"Chief of Import Export Departm";s:15:"TitleOfCourtesy";s:3:"Mr.";s:9:"BirthDate";N;s:8:"HireDate";N;s:7:"Address";N;s:4:"City";N;s:6:"Region";N;s:10:"PostalCode";N;s:7:"Country";N;s:9:"HomePhone";N;s:9:"Extension";N;s:5:"Email";s:19:"vuong@seshin.com.vn";s:5:"Photo";N;s:5:"Notes";N;s:9:"ReportsTo";i:0;s:9:"UserLevel";i:-1;s:8:"Username";s:5:"vuong";s:9:"Activated";s:1:"Y";s:7:"Profile";s:126:"a:3:{s:15:"LoginRetryCount";i:1;s:20:"LastBadLoginDateTime";s:19:"2018/08/31 13:00:03";s:23:"LastPasswordChangedDate";s:0:"";}";s:21:"NGAYBAOCAOHOPDONGFROM";s:27:"2014-04-01 00:00:00.0000000";s:14:"NGAYBAOCAOFROM";s:27:"2014-04-01 00:00:00.0000000";s:12:"NGAYBAOCAOTO";s:27:"2018-12-31 00:00:00.0000000";s:16:"FILTER_LOAI_HANG";s:47:"LOAI_HANG='1' or LOAI_HANG='2' or LOAI_HANG='3'";s:10:"EmployeeID";i:1;s:13:"FILTER_HDGCID";s:5:"73246";s:19:"FILTER_MATERIALTYPE";s:3:"1,2";}