generator.php

<?php
    include_once "access.php";
    $ref_email = $_POST["tf_ref_email"];
    $ref_username = $_POST["tf_ref_username"];
    $ref_ign = $_POST["tf_ref_ign"];

    $access = new Access();
    $crux   = $access->getCrux();
    $anchor = $access->getAnchor();
    $user   = $access->getUser();

    try {
        $pdo = new PDO($anchor, $user, $crux);
        $stq = "INSERT INTO referred_users (id, ref_id, ref_email, ref_username, ref_ign, ref_uuid, ref_awarded, new_email, new_username, new_ign, new_uuid, new_awarded) VALUES (:id, :ref_id, :ref_email, :ref_username, :ref_ign, :ref_uuid, :ref_awarded, :new_email, :new_username, :new_ign, :new_uuid, :new_awarded)";

        for($i=0; $i<min(count($_POST["emails"]),10); $i++){
            $ref_id = $_POST["ref_ids"][$i];
            $new_email = $_POST["emails"][$i];

            $new_ref_id = checkId($ref_id, $pdo);

            $query = $pdo->prepare($stq);
            $results = $query->execute(array(
                ':id' => null,
                ':ref_id' => $new_ref_id,
                ':ref_email' => $ref_email,
                ':ref_username' => $ref_username,
                ':ref_ign' => $ref_ign,
                ':ref_uuid' => null,
                ':ref_awarded' => '0',
                ':new_email' => $new_email,
                ':new_username' => null,
                ':new_ign' => null,
                ':new_uuid' => null,
                ':new_awarded' => '0'
            ));

            $to = $new_email;
            $subject = "Check out this AMAZING Minecraft RP Server!";
            $message = "You have been invited to join " . $ref_ign . " in Arithia! Enter your Referral ID in the provided link to get a head start on your first character!" . "\n";
            $message .= "Referral ID: " . $new_ref_id . "\n";
            $message .= "Redeem Rewards: " . "http://www.graphicgoldfish.com/referral/referral.html" . "\n";
            $message .= "By redeeming your referral, you will get:" . "\n";
            $message .= "- 300 Credit Points" . "\n";
            $message .= "- 50 Ducats" . "\n";
            $message .= "- 25 Cooked Beef" . "\n";
            $message .= "- Identification Tome" . "\n";
            $message .= "We look forward to seeing you in Arithia! For more information, visit: http://www.arithia.com" . "\n";
            $headers = "From: $ref_email";
            mail ($to, $subject, $message, $headers);
        }
    } catch(PDOException $e) {
      echo 'Error: ' . $e->getMessage();
    }

    function checkId($id, $con) {
        $stmt = $con->prepare("SELECT ref_id FROM referred_users WHERE ref_id = :ref_id");
        $stmt->bindParam(':ref_id', $id);
        $stmt->execute();

        if($stmt->rowCount() > 0){
            $new_id = rand(1000000, 9999999);
            $id = settype($new_id, "string");
            checkId($ref_id, $con);
        } else {
            return $id;
        }
    }