//get data
$button = mysql_real_escape_string(strip_tags($_GET['submitun']));
$search = mysql_real_escape_string(strip_tags($_GET['searchun']));
$button1 = mysql_real_escape_string(strip_tags($_GET['submitnick']));
$search2 = mysql_real_escape_string(strip_tags($_GET['searchnick']));


$sql = mysql_query("SELECT * FROM user WHERE Id='$user'");
$sqlly = mysql_fetch_assoc($sql);
$sqlauth = $sqlly['Authority'];


$query_info = mysql_query("SELECT * FROM game WHERE Id='$search'");
$rowInfo = mysql_fetch_assoc($query_info);
$user_name = $rowInfo['Id'];
$gp = $rowInfo['TotalScore'];
$rank = $rowInfo['TotalRank'];
$grade = $rowInfo['TotalGrade'];
$guild = $rowInfo['Guild'];
$numguildmem = $rowInfo['MemberCount'];
$shots = $rowInfo['AccumShot'];
$damage = $rowInfo['AccumDamage'];
$guildrank = $rowInfo['GuildRank'];
$noupdate = $rowInfo['NoRankUpdate'];
$gold = $rowInfo['Money'];

$query_cash = mysql_query("SELECT * FROM cash WHERE ID='$search'");
$rowCash = mysql_fetch_assoc($query_cash);
$cash1 = $rowCash['Cash'];

$query_info2 = mysql_query("SELECT * FROM user WHERE Id='$search'");
$rowInfo2 = mysql_fetch_assoc($query_info2);
$nick_user = $rowInfo2['NickName'];
$user_pass = $rowInfo2['Password'];
$email = $rowInfo2['E_Mail'];
$email_verify = $rowInfo2['E_Mail_Verify'];
$country = $rowInfo2['Country'];
$bday = $rowInfo2['Birthdate'];
$sex = $rowInfo2['Gender'];
$ip = $rowInfo2['IP'];

//checking gameid search
$query_game = mysql_query("SELECT Id FROM game WHERE Id='$search'") or die(mysql_error());
$count = mysql_num_rows($query_game);
if ($count==0)
   {
   die("Username doesn't exist");
   }