[Ayuda] Reedem Key (Canjear Puntos En La Pagina)

Descripcion escribió:<center><?php
if(!defined('INITIALIZED'))
exit;
if($logged){
if(isset($_POST['code'])) {

$code = $SQL->quote($_POST['code']);
$query = $SQL->query('SELECT * FROM `__cornex_redeem` WHERE `code` = '.$code.' LIMIT 1;');



// Key exist in database
if ($query->rowCount() >= 1) {
// $query = $query[0];
$result = $query->fetchAll(PDO::FETCH_ASSOC)[0];

if ($result['used_by'] > 0) {
$error[] = 'Key has already been used';
}

if (!empty($error)) {

foreach ($error as $err) {
echo $err.'<br>';
}

}


if (empty($error)) {
$time = time();
$code = $result['code'];
$points = $result['points'];
$querys = sprintf('UPDATE `__cornex_redeem` SET `time`='.time().', `used_by`='.$account_logged->getId().' WHERE `code`="'.$result['code'].'" ');
$SQL->query($querys);
$account_logged->setPremiumPoints($account_logged->getPremiumPoints() + $points);
$account_logged->save();

echo 'Amount of '.$points.' points has been added to your account!';
}

} else {
echo 'Key is not valid';
}

}
$accid = $account_logged->getID();
$main_content .= '
<center>
<div style="border:3px solid brown; border-radius:5px; width:650px; background-color:rgb(245, 240, 220); padding:5px; margin-top:10px;">
<h2>Redeem a Key</h2>
<p>Within this page, you may redeem a code and transform it into a reward to any of your characters, these codes are randomly given by Admins and probably other of the community fellows, but they are mostly shared on social media websites such as <a href="https://www.facebook.com/Rlvanoria">Facebook fanpage.</a><p>
<form action="" method="post">
<label style="float:left; width:169px;">Enter Code:</label> <input style="margin-left:31px;" name="code" type="text"> <br />
<input style="margin-top:10px;" class="btn btn-primaryyyy" type="submit" value="Unlock">
</form>
</div>
</center>

</TR>
</TABLE>
</TD></TR></TABLE></FORM>';
} else {
$main_content .= '
<div class="ui warning message">
<div class="header">
You dont have permission to do that Please Login Your Account First!
</div>
</div>
';
}

Imagen Explicativa escribió:Imagen Explicativa:
Version del Scripts: TFs 0.4.0