<?php $title='Registration'; include("inc/h.php");

date_default_timezone_set('America/New_York');

$ip = $_SERVER['REMOTE_ADDR'];

if ($_SERVER['REQUEST_METHOD'] == "POST") { if (!isset($_POST['starter'])) { $_POST['starter'] = "Bulbasaur"; }

$count = mysql_num_rows(mysql_query("select * from users where ip='".$ip."'"));

if ($count >= 1) { echo '<center>It appears as though your ip already has an account registered with it.<br>At this time, multiple accounts are prohibited and are a bannable offense.<br><b>Please</b> think again before getting another account!</center>';


$user_id = mysql_fetch_array(mysql_query("SELECT * from users where ip='".$ip."'"));
mysql_query("insert into multi_attempt (`ip`,`mid`,`amount`,`date`,`time`) VALUES('".$ip."','".$user_id['id']."','".$count."',CURDATE(),CURTIME())")or die("MySQL Error: computer says no ".mysql_error());

 include("inc/f.php"); exit(); }

    if (isset($_POST['username']) && isset($_POST['email']) && isset($_POST['pass']) && isset($_POST['vpass']) && isset($_POST['gender']) && isset($_POST['referby']))
    {

            if ($_POST['starter'] != "Bulbasaur" && $_POST['starter'] != "Charmander" && $_POST['starter'] != "Squirtle") { echo 'You must choose one of the starters below!'; include("inc/f.php"); exit(); }

$dupe_user = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `username`='".$_POST['username']."'"));
        $types_array = array("Male", "Female");

        if (empty($_POST['username']) || empty($_POST['email']) || empty($_POST['pass']) || empty($_POST['vpass']) || empty($_POST['gender']) || empty($_POST['month']) || empty($_POST['day']) || empty($_POST['year']))
        {
            echo 'You need to fill in all fields.<br><br>';
        }
        elseif ($dupe_user > 0) {
            echo 'The username already exists.<br><br>';
        }
        elseif ($_POST['pass'] != $_POST['vpass']) {
            echo 'The passwords entered do not match.<br><br>';
        }
        elseif (strlen($_POST['username']) < 4 || strlen($_POST['username']) > 20) {
            echo 'The username should be 4-20 characters.<br><br>';
        }
        elseif (strlen($_POST['pass']) < 4) {
            echo 'The password should be 4 characters minimal.<br><br>';
        }
                elseif (!in_array($_POST['gender'], $types_array)) {
            echo 'You\'re trying to pick an invalid gender.<br><br>';
        }
        else { $team = rand(1,3);
            echo 'Thank you for registering! You may now log in.<br><br>';
            mysql_query("INSERT INTO `users` (`username`, `ip`, `email`, `password`, `realname`, `referredby`, `gender`, `rank`, `month`, `day`, `year`,`registered`,`team`) VALUES('".$_POST['username']."', '".$ip."', '".$_POST['email']."', '".md5($_POST['pass'])."','".$_POST['realname']."', '".$_POST['referby']."', '".$_POST['gender']."', 2, '".$_POST['month']."', '".$_POST['day']."', '".$_POST['year']."',CURDATE(),'".$team."')") or die("MySQL Error: computer says no ".mysql_error());



            $colour_chance = rand(1,20);
if ($colour_chance >=15) { $colour = 1; } else { $colour = 0; }
            $owner = mysql_fetch_array(mysql_query("SELECT id from users where username='".$_POST['username']."'"));
            mysql_query("INSERT INTO `box` (`mid`, `colour`, `name`, `exp`, `slot`,`ot`) VALUES('".$owner['id']."', '".$colour."', '".$_POST['starter']."', '125', '1', '".$owner['id']."')");


include("inc/f.php");
 exit();
        }

    }
    else {
        echo 'There was an error during the process.<br><br>';
    }

}

?>


<?php $mem_limit = mysql_fetch_array(mysql_query("SELECT memberlimit from settings where id=1"));

$user_limit = $mem_limit['memberlimit'];
// Count how many users
$count_users = mysql_num_rows(mysql_query("SELECT * FROM `users` where id >0"));

echo '<center>[ <b>Member Limit</b> ]<br> '.$count_users.'/'.$user_limit.'<br><br>';

// If the user limit is reached, registrations are closed.
if ($count_users >= $user_limit) {
    echo '<b>Registration is now closed</b>'; include("inc/f.php"); exit();
} else {




 echo '
<form method="post">';


if (isset($_GET['ref'])) { echo '<input type="hidden" name="referby" value="'.$_GET['ref'].'" />'; } else { echo '<input type="hidden" name="referby" value="0" />'; }

echo '
<table class="list" cellspacing="1" width="100%"><tr><td class="title" colspan="3">Select a Starter</td></tr>
<tr><td class="progress" width="33%">Bulbasaur</td><td class="progress" width="33%">Charmander</td><td class="progress" width="33%">Squirtle</td></tr>
<tr><td class="prog2" width="33%"><img src="images/sprites/0/001.png"></td><td class="prog2" width="33%"><img src="images/sprites/0/004.png"></td><td class="prog2" width="33%"><img src="images/sprites/0/007.png"></td></tr>
<tr><td class="prog2"><input type="radio" name="starter" value="Bulbasaur" onclick=\"reg.disabled=false;\"></td><td class="prog2"><input type="radio" name="starter" value="Charmander" onclick=\"reg.disabled=false;\"></td><td class="prog2"><input type="radio" name="starter" value="Squirtle" onclick=\"reg.disabled=false;\"></td></tr>
<tr><td class="title" colspan="3">User Information</td></tr>
<tr><td class="progress">Username:</td><td class="prog2"><input type="text" name="username" /></td><td class="prog2">4-20 Characters</td></tr>
<tr><td class="progress">Password:</td><td class="prog2"><input type="password" name="pass" /></td><td class="prog2">>4 Characters</td></tr>
<tr><td class="progress">Verify Password:</td><td class="prog2"><input type="password" name="vpass" /></td><td class="prog2">"</td></tr>
<tr><td class="title" colspan="3">Personal Information</td></tr>
<tr><td class="progress">Real Name:</td><td class="prog2"><input type="text" name="realname" /></td><td class="prog2"><10 Characters</td></tr>
<tr><td class="progress">Email:</td><td class="prog2"><input type="text" name="email" /></td><td class="prog2">*Required*</td></tr>
<tr><td class="progress">Gender:</td><td class="prog2"><select name="gender">
    <option value="" disabled="disabled" selected="selected">Choose one</option>
    <option value="Male">Male</option>
    <option value="Female">Female</option></td><td class="prog2">*Required*</td></tr>


    <tr><td class="progress">Birthday:</td><td class="prog2">




    <select name="month">
    <option value="" disabled="disabled" selected="selected">MM</option>
    <option value="01">01</option>
    <option value="02">02</option>
    <option value="03">03</option>
    <option value="04">04</option>
    <option value="05">05</option>
    <option value="06">06</option>
    <option value="07">07</option>
    <option value="08">08</option>
    <option value="09">09</option>
    <option value="10">10</option>
    <option value="11">11</option>
    <option value="12">12</option>
    </select><select name="day">
    <option value="" disabled="disabled" selected="selected">DD</option>';

for ($i = 1; $i <= 31; $i++) {
     if ($i < 10)
          $text = '0'.$i;
     else
          $text = $i;
     echo '<option value="'.$text.'">'.$text.'</option>';
}

echo '</select><select name="year">
    <option value="" disabled="disabled" selected="selected">YYYY</option>';


    for ($i = date('Y'); $i >= 1900; $i--)
     echo '<option value="'.$i.'">'.$i.'</option>';

     echo '</select>


    </td><td class="prog2">*Required*</td></tr>
    <tr><td class="prog2" colspan="3"><input type="submit" value="Register!"></form></td></tr>

</table>'; }



include("inc/f.php"); exit();  ?>