function login($email, $password)
{
// check username and password with db
// if yes, return true
// else throw exception
// connect to db
$dbInfo = initialize_db_info();
$dbLink = db_connect($dbInfo);
db_select($dbLink, $dbInfo);
$sql = generateUserVerificationSql($email, $password);
// check if username is unique
$result = mysql_query($sql, $dbLink);
if (!$result || mysql_num_rows($result) == 0) {
// The username and password did not match.
// Check to see if the user exists.
if (findUsername($email)) {
} else {
}
}
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_assoc($result);
$currentUser = new user_info();
$currentUser->setId($row['id']);
$currentUser->setFirstName($row['first_name']);
$currentUser->setLastName($row['last_name']);
$currentUser->setEmail($row['email']);
$currentUser->setHunterId($row['hunter_id']);
$currentUser->setLoggedIn(true);
$_SESSION['current_user'] = $currentUser;
$_SESSION['roles'] = getRoles($currentUser);
return $currentUser;
} else {
throw new Exception('no user found 2');
}
}
print $title;
?>
</td>
<td><?php
print $archive;
?>
</td>
<td><?php
print $type;
?>
</td>
<?php
if (isSuper()) {
?>
<td><?php
print findUsername($userID);
?>
</td>
<?php
}
?>
<td>
<a href="view?id=<?php
print $id;
?>
" class="btn btn-sm btn-primary">View</a>
<a href="edit?id=<?php
print $id;
?>
" class="btn btn-sm btn-success">Edit</a>
<a href="rdf?id=<?php
/**
* Renders a data table on the comments page.
*
* @param {String} $value: The value of the selected item.
*/
function renderTable($value)
{
global $mysqli;
$statement;
if ($value == "genre") {
$statement = $mysqli->prepare("SELECT genre_required_available, genre_controlled_available, suggested_terms_genre, user_id FROM comments");
} else {
if ($value == "type_available") {
$statement = $mysqli->prepare("SELECT type_available, suggested_terms_type, user_id FROM comments");
} else {
if ($value == "role_available") {
$statement = $mysqli->prepare("SELECT role_available, suggested_terms_role, user_id FROM comments");
} else {
$statement = $mysqli->prepare("SELECT {$value}, user_id FROM comments");
}
}
}
$statement->execute();
$statement->store_result();
if ($value == "genre") {
$statement->bind_result($required, $controlled, $suggested, $userID);
} else {
if ($value == "type_available" || $value == "role_available") {
$statement->bind_result($available, $suggested, $userID);
} else {
$statement->bind_result($commentColumn, $userID);
}
}
?>
<table class="table table-striped table-hover dt">
<thead>
<tr>
<th>Username</th>
<?php
if ($value == "genre") {
?>
<th>Required/Optional</th>
<th>Controlled/Free-Form</th>
<th>Suggested Terms</th>
<?php
} elseif ($value == "type_available" || $value == "role_available") {
?>
<th>Available</th>
<th>Suggested Terms</th>
<?php
} else {
?>
<th>Decision</th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
while ($statement->fetch()) {
?>
<tr>
<td><?php
print findUsername($userID);
?>
</td>
<?php
if ($value == "genre") {
?>
<td><?php
print $required == "true" ? "Required" : $required == "false" ? "Optional" : "<em>No data given</em>";
?>
</td>
<td><?php
print $controlled == "true" ? "Controlled" : $required == "false" ? "Free-form" : "<em>No data given</em>";
?>
</td>
<td><?php
print renderTableCell($suggested);
?>
</td>
<?php
} elseif ($value == "type_available" || $value == "role_available") {
?>
<td><?php
print renderTableCell($available);
?>
</td>
<td><?php
print renderTableCell($suggested);
?>
</td>
<?php
} else {
?>
<td><?php
print renderTableCell($commentColumn);
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
}
