if ($user_id = $user->register()) { $char = new Char($sql); $char->fillCharInfo(null, $user_id, $_POST['charname'], $_POST['realm'], $class, $spec1, $talents1, $spec2, $talents2); if ($char_id = $char->register()) { $sql->commit(); echo 'Votre compte a bien été créé. Veuillez confirmer votre compte à l\'aide du lien envoyé à l\'adresse e-mail que vous avez renseigné.'; } } else { echo 'Utilisateur déjà enregistré'; } } else { $template = ''; require_once './controller/registering.php'; $classes = new Registering(); $tooltip = 'Le captcha sert à déterminer que vous êtes bien un humain.' . ' Renseignez le texte que vous voyez dans l\'image située au dessus du champ de saisie.'; $sql = $classes->getConnection(); $query = $sql->prepare("SELECT * FROM captcha;"); $query->execute(); $result = $query->fetchAll(); $captcha = $result[rand(0, sizeof($result) - 1)]; ?> <script type="text/javascript" > pullArmory = function(){ $('#charOk').val('no'); realm = $("#realm").val(); charname = $("#charname").val(); url = 'https://eu.api.battle.net/wow/character/' + realm + '/' + charname + '?fields=progression,talents,items&locale=fr_FR&apikey=8yxneggz98xkkpfdqb9383yre75xcn7u'; $("#account_sync").html("Synchronisation...");
$size = str_split("456789"); $salt = ''; for ($i = 0; $i < $size[rand(0, sizeof($size) - 1)]; $i++) { $salt .= $chars[rand(0, sizeof($chars) - 1)]; } return $salt; } if (isset($_POST) && !empty($_POST)) { define('DB_NAME', 'dream'); define('DB_USER', 'da'); define('DB_PASSWORD', 'dream-admin2015'); require_once '../include/DBF.php'; $salt = generateSalt(); $pass = sha1($_POST['pass'] . $salt); $reg = new Registering(); $sql = $reg->getConnection(); try { $sql->beginTransaction(); $query = $sql->prepare("INSERT INTO users " . "(login, pass, salt, lastname, firstname, birthday, gender, mail, phone, city) " . "VALUES (:login, :pass, :salt, :lastname, :firstname, :birthday, :gender, :mail, :phone, :city);"); $query->execute(array('login' => $_POST['nickname'], 'pass' => $pass, 'salt' => $salt, 'lastname' => $_POST['lastname'], 'firstname' => $_POST['firstname'], 'birthday' => $_POST['birthday'], 'gender' => $_POST['gender'], 'mail' => $_POST['mail'], 'phone' => $_POST['phone'], 'city' => $_POST['city'])); $query = $sql->prepare("SELECT id FROM users WHERE login = :login;"); $query->execute(array('login' => $_POST['nickname'])); $result = $query->fetchAll(); $id = $result[0]['id']; $query = $sql->prepare("INSERT INTO chars " . "(user_id, name, spec1, spec2) " . "VALUES (:user_id, :name, :spec1, :spec2);"); $query->execute(array('user_id' => $id, 'name' => $_POST['charname'], 'spec1' => $_POST['ms'], 'spec2' => $_POST['os'])); $i = 0; while ($i < 50) { if (isset($_POST['charname_' . $i]) && !empty($_POST['charname_' . $i]) && isset($_POST['ms_' . $i]) && !empty($_POST['ms_' . $i]) && isset($_POST['os_' . $i]) && !empty($_POST['os_' . $i])) { $query = $sql->prepare("INSERT INTO chars " . "(user_id, name, spec1, spec2) " . "VALUES (:user_id, :name, :spec1, :spec2);"); $query->execute(array('user_id' => $id, 'name' => $_POST['charname_' . $i], 'spec1' => $_POST['ms_' . $i], 'spec2' => $_POST['os_' . $i]));