session_start(); // LOAD DATABASE CONNECTION FIRST include("../meta/mysql/mysqli_connect_wigglefish2016.php"); include("meta/php/loadCodexArt.php"); $randomNumber = rand(1,5); switch ($randomNumber) { case 1: $artQuality = "important"; break; case 2: $artQuality = "accessible"; break; case 3: $artQuality = "matter"; break; case 4: $artQuality = "meaningful"; break; case 5: $artQuality = "inspiring"; break; default: $artQuality = "delicious"; } switch ($thisView) { default: if(isset($_POST['but_submit'])) { $uname = mysqli_real_escape_string($mysqli,$_POST['txt_uname']); $password = mysqli_real_escape_string($mysqli,$_POST['txt_pwd']); if ($uname != "" && $password != ""){ $sql_query = " SELECT count(*) as cntUser FROM person_attribute ua1, person_attribute ua2, person u, person_attribute ua3 WHERE ua1.type='Email' AND ua1.app_id = '2020' AND ua1.value='$uname' AND ua1.id=ua2.id AND ua2.type='Password' AND ua2.app_id = '2020' AND ua2.value='$password' AND ua2.id = u.id AND u.type='Person' AND u.id = ua3.id AND ua3.type='Role' AND ua3.app_id = '2020' AND ua3.name='Suturo Curator' AND ua3.value = 'Yes' "; $result = mysqli_query($mysqli,$sql_query); $row = mysqli_fetch_array($result); $count = $row['cntUser']; echo $count; if($count == 1){ $_SESSION['uname'] = $uname; header('Location: main.php'); }else{ $confirmationMessage = "
The login credentials as submitted are not recognized. Need help with your login? Click here.";
}
}
}
$thisBackgroundImage = $thisCodexImage;
$thisFooterMessage = "Curatorial Site | Exhibition Site
Need help with your login? Click here.";
$thisContent = "