<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
    <meta name="author" content="Than; e-mail: ">
    <meta name="author" content="HosipLan; e-mail: HosipLan@seznam.cz">
  <title>Formulář pro příjem nových GM</title>
  </head>
  <body>
<?php

mysql_connect('localhost','root','gurubashi')
  OR DIE('<p>Spojení s MySQL databází se nezdařilo.</p>');
mysql_select_db('wow',$ID_Spojeni)
  OR DIE("<p>".mysql_errno().": ".mysql_error()."<br>\nNepodařilo se vybrat databázi pokus.</p>");

$nick = $_POST['nick'];
$game_nick= $_POST['game_nick'];
$icq = $_POST['icq'];
$email = $_POST['email'];
$answer1 = $_POST['answer1'];
$answer2 = $_POST['answer2'];
$answer3 = $_POST['answer3'];
$gm_command= $_POST['gm_command'];
$Podminka= $_POST['Podminka'];

$Language = @$_POST['Pascal'].@$_POST['Delphi'].@$_POST['Sql'].@$_POST['Php'].@$_POST['C#'].@$_POST['C++'].@$_POST['Html'].@$_POST['Jiné'];

//echo $Language;
  if($gm_command=='1') {
    $a='Ano';
  }
  if($gm_command=='0') {
    $a='Ne';
  }
//  echo $a;

$db= $_POST['db'];
  if($db=='1') {
    $b='Ano';
  }
  if($db=='0') {
    $b='Ne';
  }
//  echo $b;

$server= $_POST['server'];
  if($server=='1') {
    $c='Ano';
  }
  if($server=='0') {
    $c='Ne';
  }
 // echo $c;
  
$answer4 = $_POST['answer4'];
$answer5 = $_POST['answer5'];
$answer6 = $_POST['answer6'];
$answer7 = $_POST['answer7'];
$answer8 = $_POST['answer8'];
$old = $_POST['old'];

$sql = "INSERT INTO newgm values('NULL', 0, ".
                                 "'".addslashes($nick)."', ".
                                 "'".addslashes($game_nick)."', ".
                                 "'".addslashes($icq)."', ".
                                 "'".addslashes($email)."', ".
                                 "'".addslashes($answer1)."', ".
                                 "'".addslashes($answer2)."', ".
                                 "'".addslashes($answer3)."', ".
                                 "'".addslashes($a)."', ".
                                 "'".addslashes($b)."', ".
                                 "'".addslashes($c)."', ".
                                 "'".addslashes($answer4)."', ".
                                 "'".addslashes($answer5)."', ".
                                 "'".addslashes($answer6)."', ".
                                 "'".addslashes($answer7)."', ".
                                 "'".addslashes($answer8)."', ".
                                 "'".addslashes($Language)."', ".
                                 "'".addslashes($Podminka)."', ".
                                 "'".addslashes($old)."', ".
                                 " now() )";

if ( !mysql_query($sql) ){ 
  echo mysql_errno($ID_Spojeni),': ',mysql_error($ID_Spojeni),'<br>';
  die('<p>Nepodařil se vložit váš záznam do databáze příkaz.</p>');
  };

if(@mail($email, "Automaticky e-mail o vyplneni formulare", "Vase prihlaska na post administratora na serveru Heroes of Fantasy byla ulozena do databaze. V blízké dobe se vám ozveme jestli jste byli prijati nebo ne. \n Vas nick: $nick\n ICQ: $icq \n E-mail: $email")){
  echo '<p>Zpráva je zapsána.<br>Byl vám zaslán Automatický e-mail na adresu: <b>'.$email.'</b></p>';
  }
else{ echo "<p>Nepodařilo se odesat vám informační E-mail.</p>"; };

mysql_close();

?>

</body>
</html>
