<?php echo $Realm['realmName']; ?> </p> <p id="info"> <?php echo $Realm['rate']; ?> Rates </p> </div> <div id="body" class="clearfix text-shadow"> <p id="online"> <?php $OnlineQuerySQL = $db->Personajes()->query("SELECT COUNT(*) FROM characters WHERE online='1'"); $OnlinePlayers = MysqliResultFlame($OnlineQuerySQL); ?> <font color="#d28010"><?php echo $OnlinePlayers; ?> /1000</font> Players Online </p> <p id="uptime"> <?php $sql = $db->CuentaSQL("SELECT * FROM `uptime` WHERE realmid='{$Realm['Id']}' ORDER BY `starttime` DESC LIMIT 1"); $uptime_results = $sql->fetch_array(); if ($uptime_results['uptime'] > 2592000) { $uptime = round($uptime_results['uptime'] / 30 / 24 / 60 / 60, 2) . " Mes(es)"; } elseif ($uptime_results['uptime'] > 86400) { $uptime = round($uptime_results['uptime'] / 24 / 60 / 60, 2) . " Dia(s)"; } elseif ($uptime_results['uptime'] > 3600) {
* Whether the email format is correct */ if (filter_var($email, FILTER_VALIDATE_EMAIL)) { $checkEmailSQL = $db->Web("SELECT * FROM account WHERE email = '{$email}'"); $checkEmail = mysqli_num_rows($checkEmailSQL) > 0; if ($checkEmail) { echo ' <center> <p class="text-red title">This Email is already used.</p> </center> <meta http-equiv="refresh" content="2;url=' . CUENTA_URL . 'register"/>'; } else { // Register Server $register = $db->CuentaSQL("INSERT INTO `account`(`username`,`sha_pass_hash`,`email`) VALUES ( UPPER('{$username}'),'{$sha_pass_hash_server}','{$email}')"); $IdAccount = $db->CuentaSQL("SELECT MAX(id) FROM account"); $IdWoW = MysqliResultFlame($IdAccount); // RBAC Account Permissions Server $register = $db->CuentaSQL("INSERT INTO `rbac_account_permissions`(`accountId`,`permissionId`) VALUES ( '{$IdWoW}','195')"); // Register CMS $createAccount = $db->Web("INSERT INTO `account`(`first_name`,`last_name`,`email`,`password`,`secret_question`,`answer_question`,`country`,`date_of_birth`,`activation_code`) VALUES ('{$firstName}','{$lastName}','{$email}','{$sha_pass_hash_cms}','{$question}', UPPER('{$answer}'),'{$country}','{$dob}','{$code}')"); if ($createAccount) { echo ' <div class="alert-page "> <div class="alert-page-message success-page"> <p class="text-green title"> <strong>Account Creation Successful!</strong> </p> <div class="result-desc"> <div class="email-verification-highlight"> <h6>Next: Confirm your email address.</h6> <p>