Adding a last login timestamp to the login page
I keep getting an error from my modifications.
Warning: mysql_select_db() expects parameter 2 to be resource, null given in /usr/www/users/gtsweb/webassist/security_assist/helper_php.php on line 30
Warning: mysql_query() expects parameter 2 to be resource, null given in /usr/www/users/gtsweb/webassist/security_assist/helper_php.php on line 35
What am I not getting right? I think may error is in the $WA_fieldValuesStr value.
$WA_connection = $GTSCommunityW;
$WA_table = "pcms2_users";
$WA_redirectURL = "Docs_Search.php";
if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";
$WA_keepQueryString = false;
$WA_indexField = "UserID";
$WA_fieldNamesStr = "LastLogin|LoginCount";
$WA_fieldValuesStr = "". (date("Y-m-d h:n:s")) ."" . $WA_AB_Split . "".$row_rsLoggeduser['LoginCount']+1 ."";
$WA_columnTypesStr = "',none,NULL|',none,''";
$WA_comparisonStr = " = | LIKE ";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode($WA_AB_Split, $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_where_fieldValuesStr = "".((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"") ."";
$WA_where_columnTypesStr = "',none,''";
$WA_where_comparisonStr = "=";
$WA_where_fieldNames = explode("|", $WA_indexField);
$WA_where_fieldValues = explode($WA_AB_Split, $WA_where_fieldValuesStr);
$WA_where_columns = explode("|", $WA_where_columnTypesStr);
$WA_where_comparisons = explode("|", $WA_where_comparisonStr);