<?php
mysql_connect('localhost','root','');
mysql_select_db('gunbound');

//add your own security, im too damn lazy to do this, and validate it yourself too, it's not that difficult haha.

if ( isset( $_POST['submit'] ) )
{
//form variables
$username = $_POST['username'];
$nickname = $_POST['nickname'];
$password = $_POST['password'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$cash = 10000;
$gold = 80000;
$grade = 19;   //rank (hammer = 20, chick = 19, etc)
$gp = 1000; //starting amount of GP


//insert data to the database..
//this is simplicity, there are security breaches here and better ways to do this but i don't have time
$insert1 = mysql_query("INSERT INTO game (`Id`, `Guild`, `MemberCount`, `Money`, `Authority`, `EventScore0`, `EventScore1`, `EventScore2`, `EventScore3`, `AvatarWear`, `Prop1`, `Prop2`, `AdminGift`, `TotalScore`, `SeasonScore`, `TotalGrade`, `SeasonGrade`, `TotalRank`, `SeasonRank`, `GuildRank`, `AccumShot`, `AccumDamage`, `StageRecords`, `MobileRecords`, `LastUpdateTime`, `NoRankUpdate`, `NickName`)
                       VALUES  ('$username','','','$gold','','','','','','','','','','','','','','','$gp','','$grade','','','','','','$nickname')");

$insert2 = mysql_query("INSERT INTO user (`Id`, `user`, `Gender`, `NickName`, `Password`, `Status`, `MuteTime`, `RestrictTime`, `Authority`, `E_Mail`, `Country`, `User_Level`)")
         VALUES ('$username','$username','$gender','$nickname','$password','','','','','$email','','');

$insert3 = mysql_query("INSERT INTO cash (`ID`, `Cash`))
         VALUES ('$username','$cash')
}
?>
<form action='' method='post'>
Username: <input type="text" name="username" /><br />

Password: <input type="password" name="password" /><br />


Nickname: <input type="text" name="nickname" /><br />


E_Mail: <input type="text" name="email" /><br />


Gender: <input name=gender type=radio value=0 checked> Male <input name=gender type=radio value=1> Female<br>

<input type='submit' name='submit' value='Register'
</form>