Ejemplo n.º 1
0
				<?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) {
Ejemplo n.º 2
0
     *  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>