comprovarpg

<?php
//comprovarpg.php

if(!defined('INITIALIZED'))
  exit;


if($action == "check")
{

    if($logged){

    if(isset($_POST['accname']))
    {

        $accname = trim(stripslashes($_POST['accname']));
        $email = trim(stripslashes($_POST['email']));
        $code = trim(stripslashes($_POST['id']));
        $price = trim(stripslashes($_POST['price']));
        $dataAtual = time();

        $loadAcc = new Account();
        $loadAcc->loadByName($accname);

        if(!isset($loadAcc->data['id']))
        {
            $errors[] = 'Esta conta não existe, ou não possui um pagamento';
        }

        $get = $SQL->prepare('SELECT * FROM `mercado_pago` WHERE email = ? AND code = ? ORDER BY `date` DESC LIMIT 1');
        $get->execute([$email, $code]);
        $infos = $get->fetch();

        if(!is_int($price))
        {
            $errors[] = 'Valor digitado é inválido.';
        }

        if(!isset($infos['status']) && $infos['status'] != 'approved')
        {
            $errors[] = 'Esta compra não foi encontrada.';
        }else{
            if($price != $infos['payment_amount'])
                $errors[] = 'O valor digitado esta incorreto, o pagamento não foi finalizado. ';
        }


        if(!empty($errors))
        {
            $main_content .= '
                        <div class="SmallBox" >
                            <div class="MessageContainer" >
                                <div class="BoxFrameHorizontal" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-horizontal.gif);" /></div>
                                <div class="BoxFrameEdgeLeftTop" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-edge.gif);" /></div>
                                <div class="BoxFrameEdgeRightTop" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-edge.gif);" /></div>
                                <div class="ErrorMessage" >
                                    <div class="BoxFrameVerticalLeft" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-vertical.gif);" /></div>
                                    <div class="BoxFrameVerticalRight" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-vertical.gif);" /></div>
                                    <div class="AttentionSign" style="background-image:url(' . $layout_name . '/images/global/content/attentionsign.gif);" /></div>
                                    <b>Aconteceram os seguintes erros:</b><br/>';

                        foreach ($errors as $erro)
                            $main_content .= $erro . '<br />';

                    $main_content .= '
                    <br /> Caso tenha alguma dificuldade envie um email para: <b>forteraglobaloficial@gmail.com</b> <br />
                                </div>
                                <div class="BoxFrameHorizontal" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-horizontal.gif);" /></div>
                                <div class="BoxFrameEdgeRightBottom" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-edge.gif);" /></div>
                                <div class="BoxFrameEdgeLeftBottom" style="background-image:url(' . $layout_name . '/images/global/content/box-frame-edge.gif);" /></div>
                            </div>
                        </div>
                        <br/>';
        }else
        {

            $get = $SQL->prepare('SELECT * FROM `mercado_pago` WHERE email = ? AND code = ? ORDER BY `date` DESC LIMIT 1');
            $get->execute([$email, $code]);
            $infos = $get->fetch();

        if(isset($infos['status']) && $infos['status'] == 'approved'){
            if($infos['payment_amount'] == $price)
            {
                if(isset($loadAcc->data['id']))
                {
                    if($loadAcc->data['id'] == $account_logged->getID())
                    {
                    $pricedb = $infos['payment_amount'];
                    $statusn = 'ready';
                    $in = $SQL->prepare('UPDATE `mercado_pago` SET `status`='.$statusn.', account_id='.$loadAcc->data['id'].' WHERE code = ?');

                    if($in->execute([$code])){
                    $loadAcc->setPremiumPoints($loadAcc->getPremiumPoints() + $pricedb);
                    if($loadAcc->save()){
                        $statusp = 'sent';
                        $in = $SQL->prepare('UPDATE `mercado_pago` SET `status`='.$statusp.' WHERE code = ?');
                        $in->execute([$code]);
                        $main_content .= '<center>A entrega dos coins foi enviada com sucesso para a conta sua conta, o pagamento foi aprovado.<br /> <b> +'.$infos['item_count'].'</b></center>';
                        }else
                    $main_content .= 'Ocorreu algum erro. Entre em contato com <b>forteraglobaloficial@gmail.com</b>.';

                    }else
                    $main_content .= 'Ocorreu algum erro. Entre em contato com <b>forteraglobaloficial@gmail.com</b>.';

                    }else
                    $main_content .= 'A conta não corresponde a sua conta. Pagamento Inválido. <br /> Caso tenha alguma dificuldade envie um email para: <b>forteraglobaloficial@gmail.com</b>';
                }else
                $main_content .= 'Account Name inválido. <br /> Caso tenha alguma dificuldade envie um email para: <b>forteraglobaloficial@gmail.com</b>';
            }
        }else{
            $main_content .= '<center>O pagamento é inválido, e não foi aprovado. <br /> Caso tenha alguma dificuldade envie um email para: <b>forteraglobaloficial@gmail.com</b></center>';
        }
    }
}
}else
     $main_content .= '<center>É necessário efetuar o <a href="?subtopic=accountmanagement">Login</a> para comprovar um pagamento</center>';

}

if($action == ""){
    $main_content .= '
<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="5" WIDTH="100%">
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image: url(./layouts/tibiacom/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image: url(./layouts/tibiacom/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image: url(./layouts/tibiacom/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image: url(./layouts/tibiacom/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Comprovar Pagamento</div>
<span class="CaptionVerticalRight" style="background-image: url(./layouts/tibiacom/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image: url(./layouts/tibiacom/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image: url(./layouts/tibiacom/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image: url(./layouts/tibiacom/images/content/box-frame-edge.gif);"></span>
</div>
</div>
     <div class="InnerTableContainer">
         <table style="width:101%;">
                            <tbody>
                            <tr>



                                <td>


                                    <div class="TableShadowContainerRightTop">
                                        <div class="TableShadowRightTop" style="background-image:url(./layouts/tibiacom/images/content/table-shadow-rt.gif);"></div>
                                    </div>

                                    <div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiacom/images/content/table-shadow-rm.gif);">
                                        <div class="TableContentContainer">
                                            <table class="TableContent" width="100%" style="border:1px solid #faf0d7;background-color;#faf0d7;">

                                                </tr>

<td>
<style type="text/css">
#compg {
    font-family: Arial, Helvetica, sans-serif;
}

#compg input, #compg textarea {
    font-family: Arial, Helvetica, sans-serif;
    padding: 5px;
    width: 250px;
}
</style>

<form action="?subtopic=comprovarpg&action=check" method="post" id="compg" >
<fieldset>
<legend>Comprovar Pagamento</legend>

<strong>Preencha todos os campos corretamente, caso tenha alguma duvida verifique o Histórico de pagamento</strong><br><br>

    <label><b>Account Name:</b></label><br>
    <input name="accname" type="text" required /><br /><br />

    <label><b>E-mail:</b></label><br>
    <input name="email" type="text" required /><br /><br />
    <small><font color="red"><b>O e-mail utilizado na conta do mercadoPago que efetuoou a doação.</b></font></small>

    <label><b>ID da transação:</b></label><br>
    <input name="id" type="text" required /><br /><br />

    <label><b>Valor da Doação:</b></label><br>
    <input name="price" type="text" required /><br /><br />
    <small>O valor digitado exatamente igual a doação, sem virgulas.(exemplo: 40)</small>

    <br /><br />
    <!-- Codigo reCaptcha -->
    <!-- <div class="g-recaptcha" data-sitekey="INSIRA-AQUI-A-CHAVE-DO-SITE"></div> -->




    <br /><br />

    <input name="submit" type="submit" value="Comprovar" style="width: auto;" />
</fieldset>
</form>

</td>
</tr>
</TABLE>
<br />
<center>


<td>
</td>
</tr>
</TABLE>
<br />
';

}