$gamestring ="";

if ($game == 1   )
{
    $gamestring ="QW";
}

else if ($game == 2   )
{
   $gamestring ="UT";
}

else if ($game == 3   ) 
{
   $gamestring ="BF";
}

else if ($game == 4   )
{
    $gamestring ="CS";
}

else if ($game == 5   )
{
    $gamestring ="CSS";
}

else if ($game == 6   )
{
    $gamestring ="WC3";
}

else if ($game == 7   )
{
    $gamestring ="CoD4";
}

else if ($game == 8   )
{
    $gamestring ="DoW";
}

else if ($game == 9   )
{
    $gamestring ="CyS";
}

else if ($game == 10  )
{
    $gamestring ="FIFA";
}

else if ($game == 11  )
{
    $gamestring ="PES";
}


$sql = mysql_query("INSERT INTO user (

`VNAME`,
`NNAME`,
`NICK`,
`PW`,
`GEB`,
`EMAIL`,
`NAT1`,

`EYE`,
`HAIR`,
`NAT2`,
`HOME`,
`BUND`,
`JOB`,
`UPIC`,
`APIC`,
`FSIG`,
`HP`,
`IRC`,
`ICQ`,
`MSN`,
`SKYPE`,
`HANDY`,
`ORECHTS`,
`URECHTS`,
`OLINKS`,
`ULINKS`,
`".$gamestring."`

) VALUES (

'".$vorn."',
'".$nachn."',
'".$nick."',
'".$pw."',
'".$gebtag.".".$gebmon.".".$gebjahr."',
'".$email."',
'".$nat."',


'".$eye."',
'".$hair."',
'".$nat2."',
'".$home."',
'".$bund."',
'".$beruf."',
'".$upic."',
'".$ava."',
'".$fsig."',
'".$hp."',
'".$irc."',
'".$icq."',
'".$msn."',
'".$skype."',
'".$handy."',
'".$gameid."'    

);");

if (!$sql)
{
    /* Fehlermeldung */
}