join.php

<?php
session_start();
$page = "join";
require('conf/variables.php');
require('top.php');
include 'include/genericfunctions.inc.php';
include 'include/avatars.inc.php';
?>
    <p class="header">Join.</p>
    <p class="text">
<?php
if (isset ($_POST['submit'])) {
    $name = check_plain(trim(strip_tags($_POST['name'])));
    $passworddb = trim(strip_tags($_POST['passworddb']));
    $passworddb2 = trim(strip_tags($_POST['passworddb2']));
    $msn = check_plain(trim(strip_tags($_POST['msn'])));
    $icq = check_plain(trim(strip_tags($_POST['icq'])));
    $aim = check_plain(trim(strip_tags($_POST['aim'])));
    $mail = check_plain(trim(strip_tags($_POST['mail'])));
    $WesVersion = check_plain($_POST['version']);
    $MsgMeToPlay = check_plain($_POST['msgme']);
    $avatar = isset($_POST['Avatar']) ? check_plain($_POST['Avatar']) : 'No avatar';
    $length = strlen($name);

    $CanPlay = "";
    foreach ([
                 'MonM', 'MonN', 'MonA', 'MonE', 'MonNi', 'TueM', 'TueN', 'TueA', 'TueE', 'TueNi', 'WedM', 'WedN', 'WedA', 'WedE', 'WedNi', 'ThuM', 'ThuN', 'ThuA', 'ThuE', 'ThuNi', 'FriM', 'FriN', 'FriA', 'FriE', 'FriNi', 'SatM', 'SatN', 'SatA', 'SatE', 'SatNi', 'SunM', 'SunN', 'SunA', 'SunE', 'SunNi',
             ] as $period) {
        if (isset($_POST[$period]) && $_POST[$period] != "") {
            $CanPlay .= ' ' . check_plain($_POST[$period]);
        }
    }

    if ($passworddb == "") {
        echo "Please enter a password.";
    } else if (strtolower($name) == 'system') {
        echo "Sorry, but <strong>$name</strong> is reserved name!";
    } else if ($passworddb != $passworddb2) {
        echo "Passwords don't match. Please retype the passwords..<br>";
    } else if ($mail == "") {
        if (REG_MAILVERIFICATION == 1) {
            echo "Please enter a valid email. An activation link will be sent to it.<br>";
        } else {
            echo "Please enter a valid email. No spam will be sent.<br>";
        }
    } else if ($WesVersion == "") {
        echo "You must specify what version(s) of Wensoth you're using...<br>";
    } else if ($name == "") {
        echo "Please enter a nickname.";
    } else if (($length > REG_MAX_NICKLENGTH) || ($length < REG_MIN_NICKLENGTH)) {
        echo "The name you entered is invalid. It must be " . REG_MIN_NICKLENGTH . " to " . REG_MAX_NICKLENGTH . " characters long.<br />Please go back to correct the error by selecting a different username.";
    } else if (!preg_match("/^[a-zA-Z0-9\-\_]+$/i", $name)) {
        echo "You're only allowed to use standard aA-zZ 0-9 alfanumerical characters and the - and _ signs. <br>Please enter a valid Wesnoth multiplayer nickname.";
    } // If we pass the errorchecking this happens:
    else {

        if (REG_MAILVERIFICATION == 1) {
            // Random confirmation code
            $confirm_code = md5(uniqid(rand()));
        } else {
            $confirm_code = "Ok";
            // if we dont have mail confirmation enabled in the config we will "autoverify" the user by setting him to "Ok" in the Confirmation rown in the players table.
        }

        // Lets generate the encrypted pass... we do it by applying the salt and hashing it twice.
        $emailthispass = $passworddb;
        $passworddb = $salt . $passworddb;
        $passworddb = md5($passworddb);
        $passworddb = md5($passworddb);

        $sql = "SELECT * FROM $playerstable WHERE name = '$name'";
        $result = mysqli_query($db, $sql);
        $samenick = mysqli_num_rows($result);

        // If we didnt find a user with the same nick the following happens:

        if ($samenick < 1) {

            if ($approve == 'yes') {
                $approved = 'no';
            } else {
                $approved = 'yes';
            }

            if (getenv("HTTP_X_FORWARDED_FOR")) {
                $ip = getenv("HTTP_X_FORWARD_FOR");
            } else {
                $ip = getenv("REMOTE_ADDR");
            }

            $sql = "INSERT INTO $playerstable (name, passworddb, mail, icq, aim, msn, country, approved, ip, avatar, HaveVersion, MsgMe, Confirmation, CanPlay) VALUES ('$name', '$passworddb', '$mail','$icq','$aim', '$msn', '$_POST[country]', '$approved', '$ip', '$avatar', '$WesVersion', '$MsgMeToPlay', '$confirm_code', '$CanPlay')";
            $result = mysqli_query($db, $sql);

            if (REG_MAILVERIFICATION == 1) {
                echo "An activation mail has been sent to your mail. To activate your account <b>you must click the link</b> that is within it. <br /><br />If you have not recieved the mail within an hour <b>please check your spam box</b> or contact us.";

                // if suceesfully inserted data into database, send confirmation link to email
                if ($result) {
                    // ---------------- SEND MAIL FORM ----------------

                    // send e-mail to ...
                    $to = $mail;

                    // Your subject
                    $subject = "Ladder of Wesnoth activation link";

                    // Your message
                    $body = "Welcome to the Ladder of Wesnoth. This is your activation mail. \r\n";
                    $body .= "Click the link below to activate your account: \r\n";
                    $body .= "http://ladder.subversiva.org/confirmation.php?passkey=$confirm_code \r\n";
                    $body .= "If it doesnt work you can try to copy & pass it into your browser instead.\r\n";
                    $body .= "\r\n";
                    $body .= "Your username and password is: $name / $emailthispass\r\n";
                    $body .= "Save the info! We can't give it to you if you lose it.\r\n";
                    $body .= "\r\n";
                    $body .= "\r\n";
                    $body .= "As a new player you start with a rating of 1500. That is the average rating that a player who knows the game fairly will have. Players that are new to the game are expected to get a much lower rating after a couple of games, while veterans are expected to get a higher.\r\n";
                    $body .= "\r\n";
                    $body .= "Dont quit if you get low rating - it is fully normal and expected while you learn the game, and Wesnoth takes quite some time to master. The rating is, first and foremost, a personal measure to track your own skills for your own sake. Play to have fun and use the ladder as a tool for information. Use it to find players that have about the same skills as you, thats when the game is most fun to play.\r\n";
                    $body .= "\r\n";
                    $body .= "\r\n";
                    $body .= "Please read the FAQ & Rules before you play a ladder game. Also, feel free to contact us if you need help or have suggestions.\r\n";
                    $body .= "\r\n";
                    $body .= "See you in Wesnoth...\n";

                    // send email
                    $sentmail = send_mail($to, $body, $subject, $laddermailsender, $titlebar);
                } // if not found
                else {
                    echo "Your mail wasn't found in our database.";
                }

                // if your email succesfully sent
                if ($sentmail) {
                } else {
                    echo "Failed to send activation link to your e-mail address. Contact admin if the problem remains tomorrow.";
                }

            } else if (REG_MAILVERIFICATION == 0) {
                echo "<br /> <img align='center' src='graphics/activated.jpg' />";
            }

        } else {
            echo "The name you entered already exists. Please select another name.";
        }


    }
} else {
    ?>

    <b>Multiple accounts are forbidden</b>. If you have problems with your account or registration please read the rules
                                          & faq. Contact us
    <i>after</i> that if you're problems remain. By registering you agree to all the ladder rules.

    <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
        <table border="0" cellpadding="0">
            <tr>
                <td><p class="text"><b>Nickname:</b></p></td>
    <td>&nbsp;<input type="Text" name="name" class="text">
        (<?php echo REG_MIN_NICKLENGTH . " - " . REG_MAX_NICKLENGTH . " "; ?> char, <i>must</i> be same as in the game)
    </td>
    </tr>
    <tr>
        <td><p class="text"><b>Password:</b></p></td>
        <td>&nbsp;<input type="password" name="passworddb" class="text"></td>
    </tr>

    <tr>
        <td><p class="text"><b>Re-type Password:</b></p></td>
        <td>&nbsp;<input type="password" name="passworddb2" class="text"></td>

    </tr>


    <tr>
        <td><p class="text"><b>Mail:</b></p></td>
        <td>&nbsp;<input type="Text" name="mail" value="" class="text"> <?php if (REG_MAILVERIFICATION == 1) {
                echo "Please enter a valid email. An activation link will be sent to it.<br>";
            } else {
                echo "Please enter a valid email. No spam will be sent.<br>";
            } ?></td>
    </tr>
    <tr>
        <td>
            <p class="text">ICQ:</p></td>
        <td>&nbsp;<input type="Text" name="icq" value="n/a" class="text"></td>
    </tr>
    <tr>
        <td>
            <p class="text">Aim:</p></td>
        <td>&nbsp;<input type="Text" name="aim" value="n/a" class="text"></td>
    </tr>
    <tr>
        <td><p class="text">Msn:</p></td>
        <td>&nbsp;<input type="Text" name="msn" value="n/a" class="text"></td>
    </tr>
    <tr>
        <td><p class="text">Country:</p></td>
        <td>&nbsp;<select size="1" name="country" class="text">
                <?php include("include/countries.inc.php"); ?>
            </select></td>
    </tr>

    <tr>
        <td><p class="text">Avatar:</p></td>
        <td>&nbsp;<select size="1" name="avatar" class="text">
                <?php
                foreach (WlAvatar::all() as $avatarKey => $avatarImg) {
                    printf(
                        '<option value="%s">%s</optionvalue>',
                        $avatarKey,
                        $avatarKey
                    );
                }
                ?>
            </select></td>
    </tr>
    <tr>
        <td><p class="text"><b>My version of Wesnoth:</b></p></td>
        <td>&nbsp;<select size="1" name="version" class="text">
                <option></option>
                <option>Stable</option>
                <option>Development</option>
                <option>Both</option>
            </select></td>
    </tr>
    <tr>
        <td><p class="text">Msg me to play:</p></td>
        <td>&nbsp;<select size="1" name="msgme" class="text">
                <option>Yes</option>
                <option>No</option>
            </select></td>
    </tr>
        </table>


        <p class="text">I can usually play these times (GMT):</p>
        <table width="100%">


            <tr>

                <td></td>
                <td>Morning</td>
                <td>Noon</td>
                <td>Afternoon</td>
                <td>Evening</td>
                <td>Night</td>
            </tr>


            <tr>
                <td bgcolor="#E7D9C0">Monday</td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="MonM" value="MonM"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="MonN" value="MonN"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="MonA" value="MonA"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="MonE" value="MonE"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="MonNi" value="MonG"/></td>
            </tr>


            <tr>
                <td>Tuesday</td>
                <td><input type="checkbox" name="TueM" value="TueM"/></td>
                <td><input type="checkbox" name="TueN" value="TueN"/></td>
                <td><input type="checkbox" name="TueA" value="TueA"/></td>
                <td><input type="checkbox" name="TueE" value="TueE"/></td>
                <td><input type="checkbox" name="TueNi" value="TueG"/></td>
            </tr>


            <tr>
                <td bgcolor="#E7D9C0">Wednesday</td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="WedM" value="WedM"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="WedN" value="WedN"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="WedA" value="WedA"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="WedE" value="WedE"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="WedNi" value="WedG"/></td>
            </tr>

            <tr>
                <td>Thursday</td>
                <td><input type="checkbox" name="ThuM" value="ThuM"/></td>
                <td><input type="checkbox" name="ThuN" value="ThuN"/></td>
                <td><input type="checkbox" name="ThuA" value="ThuA"/></td>
                <td><input type="checkbox" name="ThuE" value="ThuE"/></td>
                <td><input type="checkbox" name="ThuNi" value="ThuG"/></td>
            </tr>

            <tr>
                <td bgcolor="#E7D9C0">Friday</td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="FriM" value="FriM"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="FriN" value="FriN"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="FriA" value="FriA"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="FriE" value="FriE"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="FriNi" value="FriG"/></td>
            </tr>

            <tr>
                <td>Saturday</td>
                <td><input type="checkbox" name="SatM" value="SatM"/></td>
                <td><input type="checkbox" name="SatN" value="SatN"/></td>
                <td><input type="checkbox" name="SatA" value="SatA"/></td>
                <td><input type="checkbox" name="SatE" value="SatE"/></td>
                <td><input type="checkbox" name="SatNi" value="SatG"/></td>
            </tr>

            <tr>
                <td bgcolor="#E7D9C0">Sunday</td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="SunM" value="SunM"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="SunN" value="SunN"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="SunA" value="SunA"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="SunE" value="SunE"/></td>
                <td bgcolor="#E7D9C0"><input type="checkbox" name="SunNi" value="SunG"/></td>

        </table>

        <p class="text"><input type="Submit" name="submit" value="Join." class="text"><br><br>
            </form>
        </p>
    <?php
}
require('bottom.php');