<!-- projectCharacterModify.php - Kristin Tillotson 
This is the all purpose inventory and character modification page.
It is also the action page for character selection (login).
It is also also the action page for taking an item.
-->

<?php   session_start();

	$name = $_POST['name'];
	if($name != "")
		$_SESSION['char'] = $name;

        $char = $_SESSION['char'];
        if($char == "")
                print "<A HREF=projectCharacterSelect.php>Log In</A>";
        else
                print "<A HREF=projectCharacterModify.php> $char </A> |
        <A HREF=projectLogout.php> Logout</A>";
?>

<CENTER> <A HREF=project.php> Homepage</A> |
<A HREF=projectAreas.php> Areas</A> |
<A HREF=projectCharacterDisplay.php> Characters</A><HR>
<H2><Font color=green> Souvenirs: A Fantasy Exploration Game </font></H2><HR>

<?php 
if($char == "")
        print "<H2><A HREF=projectCharacterSelect.php>Log In</A></H2>";
else{ 
        $host = 'localhost';
        $user = 'kvtillotson';
        $passwd = 'cs389';
        $database = 'kvtillotson';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from Characters where Name='$char'";
//        print "The query is <i> $query </i> ";	\\debug
        mysqli_select_db($connect, $database);

	$slot = $_POST['slot'];
        if($slot != "") {
	$item = $_SESSION['item'];
        $queryI = "update Characters set $slot='$item' where Name='$char'";
//        print "The query is <i> $queryI </i> ";	//debug
        $result_idI = mysqli_query($connect, $queryI);
        if($result_idI)
                print "$slot set to $item.<p>";		//confirmation
	}

	$result_id = mysqli_query($connect, $query);
        if($result_id)
	{       print '<table border=1>';
                print '<TH> Name <TH> Race <TH> Item 1 <TH> Item 2 <TH> Item 3';
                while($row = mysqli_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
                print '</table>';
        }
        else
                print "Fail.<p>";

        mysqli_close($connect); 
?>

<HR>
<form action=projectCharacterModifyAct.php method=post>
Change Race to:
<input type=radio name=race value=Human> Human
<input type=radio name=race value=Elf> Elf
<input type=radio name=race value=Dragon> Dragon
<BR> Item 1: <input type=radio name=item1 value=remove> Empty Slot 
<BR> Item 2: <input type=radio name=item2 value=remove> Empty Slot 
<BR> Item 3: <input type=radio name=item3 value=remove> Empty Slot 
<BR> <input type=reset value=Reset>
<input type=submit value="Apply Changes">
</form>

<?php
} 
?>