<?php
}
}
}
?>
<?php
echo $user_data['first_name'];
?>
▼</a>
<ul>
<!--<li><a href="<?php
echo $user_data['username'];
?>
">Profile</a></li>-->
<li><a href="accSettings.php">Account settings</a></li>
<li><a href="changepassword.php">Change password</a></li>
<?php
if (admin_rights($user_data['username']) === true) {
?>
<li><a href="admin_control.php">Administration</a></li> <?php
}
?>
<li><a href="logout.php">Logout</a></li>
</ul><!-- nested UL ends here -->
</li><!-- main LI ends here -->
</ul><!-- main UL ends here -->
<br class="clear-float" />
</div><!-- nav-menu ends here -->
</div><!-- nav-wrapper ends here -->
</div><!-- headding ends here -->
</div><!--heading-wrapper-->
<?php
include 'core/init.php';
if (admin_rights($user_data['username']) === false) {
//redirects if no access
header('Location: index.php');
}
$use = $_POST['use'];
//this is for use 1 => issue books
if ($use == 1) {
$book_id = $_POST['book_id'];
$user_id = $user_data['user_id'];
$query = "SELECT * from library WHERE sl_no = {$book_id}";
$result = mysql_query($query);
$book_data = mysql_fetch_array($result);
//book is avilable
//Book copy 2, issued none
if ($book_data['copies'] == 2) {
if ($book_data['unissued'] == 2 && $book_data['not_requested'] == 1) {
$issued_to_1 = $book_data['request_by_1'];
//updating library table
mysql_query("UPDATE `library` SET `not_requested` = 1, `issued_to_1` = {$issued_to_1}, `unissued` = 1 WHERE `book_id` = {$book_id}");
//Book copy 2, one already issued
} elseif ($book_data['unissued'] == 2 && $book_data['not_requested'] == 0) {
$issued_to_1 = $book_data['request_by_1'];
$issued_to_2 = $book_data['request_by_2'];
//updating library table
mysql_query("UPDATE `library` SET `not_requested` = 0, `issued_to_2` = {$issued_to_2}, `issued_to_1` = {$issued_to_1},`unissued` = 1 WHERE `book_id` = {$book_id}");
//Book copy 2, one already issued
} elseif ($book_data['unissued'] == 1 && $book_data['not_requested'] == 0) {
$issued_to_2 = $book_data['request_by_2'];
