function login($_POST) { global $_SESSION; extract($_POST); require_lib("validate"); $v = new validate(); $v->isOk($code, "string", 1, 5, "Invalid company name."); # Display errors, if any if ($v->isError()) { $confirm = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirm .= "<li class='err'>" . $e["msg"] . "</li>"; } return slctcomp($confirm); } # Change code to lowercase $code = strtolower($code); if (!db_check("cubit_" . $code)) { return slctcomp("<li class='err'>Invalid Company. Select another company or<br />\n\t\t\tclick <a href='company-new.php?key=recover'>here</a> to see if Cubit can recover from this error.</li>"); } # Get Company Name db_conn("cubit"); $sql = "SELECT name FROM companies WHERE code = '{$code}'"; $compRslt = db_exec($sql) or errDie("Unable to access database.", SELF); if (pg_numrows($compRslt) < 1) { $comp['name'] = ""; } else { $comp = pg_fetch_array($compRslt); } $_SESSION["code"] = $code; $_SESSION["comp"] = $comp['name']; header("Location: doc-index.php"); }
function recover() { extract($_REQUEST); require_lib("validate"); $v = new validate(); $v->isOk($code, "string", 1, 5, "Invalid company code."); # Display errors, if any if ($v->isError()) { $confirm = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirm .= "<li class='err'>" . $e["msg"] . "</li>"; } return slctcomp($confirm); } # Change code to lowercase $code = strtolower($code); # Get Company Name db_con("cubit"); $sql = "SELECT * FROM companies WHERE code = '{$code}'"; $compRslt = db_exec($sql) or errDie("Unable to access database.", SELF); if (pg_numrows($compRslt) < 1) { return "<li class='err'> Invalid Company Code</li>"; } else { $comp = pg_fetch_array($compRslt); } $sql = "UPDATE companies SET status='active' WHERE code = '{$code}'"; $delRslt = db_exec($sql) or errDie("Unable to access database.", SELF); $date = date("Y-m-d"); $Sl = "INSERT INTO ch(comp,code,des,f,t,date) VALUES ('{$comp['name']}','{$comp['code']}','Recover by " . USER_NAME . "','{$comp['ver']}','{$comp['ver']}','{$date}')"; $Ri = db_exec($Sl); $rem = "\n\t\t\t<h3>Recover Company</h3>\n\t\t\t<h4><li> Company : {$comp['name']} has been successfully been recovered and marked as active.</h4>"; return $rem; }