Untitled


<html>
<head><title>RaidPlaner - TAP</title>
</head>
<body>

    <form action='./raid_prihlaseni1.php' method='post' enctype='text/form-data'>


<?php


 if (!empty($_POST['player']))
  {
    $user = $_POST["player"];
    $pass = $_POST["role"];

      mysql_query("insert into raidplaner(player, role, druha_role, koment, password) values ('".$_POST["player"]."','".$_POST["role"]."','".$_POST["druha"]."', '".$_POST["koment"]."', '".md5($_POST["pass"])."')");
      $vypis_id = mysql_query("select id from raidplaner where player = '".$_POST["player"]."')");
      while($row=mysql_fetch_array($vypis_id)) {
  echo ("Prihlaseni bylo uspesne! Bylo ti prideleno ID - <b>'".$row["id"]."'</b>.");
  }

  }
 ?>


<fieldset>

<table>
<tr>
<td>Herni nick</td><td><input type='text' name='player' /></td>
</tr>
<tr>
<td>Role</td><td><input type='text' name='role' /></td>
</tr>
<tr>
<tr>
<td>DualSpec role</td><td><input type='text' name='druha' /></td>
</tr>
<tr>
<td>Komentar</td><td><input type='text' name='koment' /></td>
</tr>
<tr>
<td>Heslo pro upravu</td><td><input type='password' name='pass' /></td>
</tr>
<td colspan='2'><input type='submit' name='submit' value='odeslat' /></td>
</tr>

</table>
</fieldset>
</form>
<h1>Vypis hracu, kteri se prihlasili na raid</h1>

<?php
   $vypis_prihlaseno = mysql_query ("select id, player, role, druha_role, koment from raidplaner");
 echo "<table border='1'>";
 echo "<tr>";
 echo "<td><b>ID</b></td><td><b>Ucet</b></td><td><b>Role</b></td><td><b>Druha Role</b></td><td><b>Komentar</b></td>";
 echo "</tr>";
 while($row2=mysql_fetch_array($vypis_prihlaseno)) {
 	echo "<tr>";
 	echo "<td>".$row2["id"]."</td><td>".$row2["player"]."</td><td>".$row2["role"]."</td><td>".$row2["druha_role"]."</td><td>".$row2["koment"]."</td>";
 	echo "</tr>" ;
 }
 echo "</table>";

?>
 <h2>Mazani</h2>
<form action='./raid_prihlaseni1.php' method='post' enctype='multipart/form-data'>
ID <input type='text' name='idd' /><br />
Heslo pro ID <input type='password' name='passss' /><br />
<input type='submit' value='Smazat' />
</form>

  <h3>Delete all</h3>
<form action='./raid_prihlaseni1.php' method='post' enctype='multipart/form-data'>
Master heslo <input type='text' name='mpassform' /><br />
<input type='submit' value='Delete all' />
</form>

<?php

 if (!empty($_POST['mpassform']))
  {
    $mpass = $_POST["mpassform"];


if($_POST["mpassform"]!=null) {

$passwordd = @mysql_result(mysql_query("select mpass from mpass"),0);

if($passwordd!=null and $passwordd==($_POST["mpassform"])){
echo "shoda";

//$_SESSION["user"]="true";

$smazanii = mysql_query ("TRUNCATE TABLE raidplaner");
header("Location:./raid_prihlaseni1.php");

}else{
echo "Zadal jsi spatne heslo nebo id";
}

}elseif($_POST["mpassform"]!=null){
echo "nezadany hodnoty";
}
}
?>

 <?php

 if (!empty($_POST['idd']))
  {
    $userr = $_POST["idd"];
    $passs = $_POST["passss"];

if($_POST["idd"]!=null and $_POST["passss"]!=null) {

$password = @mysql_result(mysql_query("select password from raidplaner where id='".$_POST["idd"]."'"),0);

if($password!=null and $password==md5($_POST["passss"])){
echo "shoda";

//$_SESSION["user"]="true";

$smazani = mysql_query ("delete from raidplaner where id = '".$_POST["idd"]."'")   ;
header("Location:./raid_prihlaseni1.php");

}else{
echo "Zadal jsi spatne heslo nebo id";
}

}elseif($_POST["passss"]!=null){
echo "nezadany hodnoty";
}
}
?>

<?php
 $invite_macro = mysql_query ("select player from raidplaner");
 echo "Invite macro <p></p>";
  while($row3=mysql_fetch_array($invite_macro)) {
    echo "/invite ".$row3["player"]." ";
  }

?>


</body>
</html>