{"id":77,"date":"2025-08-14T19:07:18","date_gmt":"2025-08-14T19:07:18","guid":{"rendered":"https:\/\/ayoocloud.com.br\/blog\/?p=77"},"modified":"2025-08-14T21:08:55","modified_gmt":"2025-08-14T21:08:55","slug":"myaac-pix-via-mercado-pago-otserv-automatico","status":"publish","type":"post","link":"https:\/\/ayoocloud.com.br\/blog\/2025\/08\/14\/myaac-pix-via-mercado-pago-otserv-automatico\/","title":{"rendered":"Myaac &#8211; Pix via MercadoPago Otserv Automatico"},"content":{"rendered":"<h3><span class=\"mycode_b\"><span class=\"mycode_size\">Comprar Pontos com Pix via Mercado Pago \u2013 Sistema PHP Completo<\/span><\/span><\/h3>\n<div class=\"my-[1px]\">\n<div class=\"py-[3px] whitespace-pre-wrap u-break-words\"><strong>Myaac &#8211; Pix via MercadoPago Otserv Automatico<\/strong><\/div>\n<\/div>\n<div class=\"my-[1px]\">\n<div class=\"py-[3px] whitespace-pre-wrap u-break-words\">Se voc\u00ea administra um Otserv e utiliza o MyAAC, este tutorial \u00e9 a solu\u00e7\u00e3o que voc\u00ea procurava. <strong>Nele, apresentamos<\/strong> um sistema PHP completo para automatizar a compra de pontos usando o Pix do Mercado Pago.<\/div>\n<\/div>\n<div class=\"my-[1px]\">\n<div class=\"py-[3px] whitespace-pre-wrap u-break-words\"><strong>Com este c\u00f3digo,<\/strong> o processo se torna muito simples: o jogador escolhe a quantidade de pontos, gera um QR Code para o pagamento e, <strong>logo ap\u00f3s<\/strong> a confirma\u00e7\u00e3o, o saldo \u00e9 atualizado automaticamente na conta dele. <strong>Portanto,<\/strong> voc\u00ea n\u00e3o precisa mais se preocupar com a entrega manual de pontos.<\/div>\n<\/div>\n<p><strong><span class=\"mycode_size\"><span class=\"mycode_b\">Funcionalidades<\/span><\/span><\/strong><\/p>\n<ol class=\"mycode_list\" type=\"1\">\n<li><strong><span class=\"mycode_b\">Compra de pontos via Pix<\/span><\/strong>\n<ul class=\"mycode_list\">\n<li>Usu\u00e1rio escolhe a quantidade de pontos.<\/li>\n<li>Calcula automaticamente o valor a pagar (ex.:\u00a0<span class=\"mycode_color\">R$0,50<\/span>\u00a0por ponto).<\/li>\n<li>Gera QR Code e c\u00f3digo Pix para pagamento.<\/li>\n<\/ul>\n<\/li>\n<li><strong><span class=\"mycode_b\">Integra\u00e7\u00e3o com Mercado Pago<\/span><\/strong>\n<ul class=\"mycode_list\">\n<li>Cria\u00e7\u00e3o de pagamento via API.<\/li>\n<li>Idempot\u00eancia garantida (mesmo usu\u00e1rio clicando v\u00e1rias vezes, apenas uma transa\u00e7\u00e3o \u00e9 criada).<\/li>\n<li>Consulta de status do pagamento via\u00a0<span class=\"mycode_b\">Webhook<\/span>.<\/li>\n<\/ul>\n<\/li>\n<li><strong><span class=\"mycode_b\">Webhook para atualizar pontos<\/span><\/strong>\n<ul class=\"mycode_list\">\n<li>Recebe notifica\u00e7\u00f5es de pagamento do Mercado Pago.<\/li>\n<li>Atualiza automaticamente a tabela historico_pagamentos\u00a0e soma os pontos na conta do jogador (accounts).<\/li>\n<li>Gerencia status de pagamentos:\u00a0<span class=\"mycode_b\">pendente<\/span>,\u00a0<span class=\"mycode_b\">pago<\/span>,\u00a0<span class=\"mycode_b\">cancelado<\/span>.<\/li>\n<\/ul>\n<\/li>\n<li><strong><span class=\"mycode_b\">Seguran\u00e7a e Logs<\/span><\/strong>\n<ul class=\"mycode_list\">\n<li>Logs de erros (php-error.log)<\/li>\n<li>e de requisi\u00e7\u00f5es do webhook (webhook_log.txt).<\/li>\n<li>Apenas requisi\u00e7\u00f5es POST s\u00e3o aceitas no webhook.<\/li>\n<li>Resposta JSON consistente para erros ou sucesso.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><span class=\"mycode_size\"><strong><span class=\"mycode_b\">Estrutura de Arquivos<\/span><\/strong><br \/>\n<\/span><\/p>\n<ul class=\"mycode_list\">\n<li>Pix-mercadopago.php \u2013 P\u00e1gina principal para o usu\u00e1rio gerar o pagamento Pix.<\/li>\n<li>webhook.php\u00a0\u2013 Recebe notifica\u00e7\u00f5es do Mercado Pago e atualiza o banco.<\/li>\n<li>cacert.pem \u2013 Certificado SSL necess\u00e1rio para chamadas cURL \u00e0 API do Mercado Pago.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<blockquote><p><strong>Este sistema funciona perfeitamente com nossas contas do AyooCloud! Confira planos, recursos extras e suporte completo em<\/strong> <a class=\"cursor-pointer\" href=\"http:\/\/AyooCloud.com.br\" target=\"_new\" rel=\"noopener\" data-start=\"738\" data-end=\"776\">AyooCloud<\/a><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p><span class=\"mycode_b\"><span class=\"mycode_size\"><strong>Requisitos<\/strong><br \/>\n<\/span><\/span><\/p>\n<ul class=\"mycode_list\">\n<li>Servidor PHP 7.4+ com cURL habilitado.<\/li>\n<li>Banco de dados MySQL\/MariaDB com as tabelas:<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mariadb\">CREATE TABLE historico_pagamentos (\r\n    id INT PRIMARY KEY AUTO_INCREMENT,\r\n    account_id INT,\r\n    payment_id BIGINT,\r\n    pontos_adquiridos INT,\r\n    valor_pago DECIMAL(10,2),\r\n    status VARCHAR(20) DEFAULT 'pendente'\r\n);<\/pre>\n<ul class=\"mycode_list\">\n<li>Conta Mercado Pago com\u00a0<span class=\"mycode_b\">Access Token<\/span>\u00a0ativo.<\/li>\n<li>Certificado cacert.pem para cURL.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span class=\"mycode_b\"><span class=\"mycode_size\"><strong>Como usar<\/strong><br \/>\n<\/span><\/span><br \/>\n<span class=\"mycode_b\"><span class=\"mycode_size\">1.<\/span><\/span>\u00a0Adicione o arquivo\u00a0<strong><span class=\"mycode_b\">webhook_mercadopago.php<\/span><\/strong>\u00a0dentro da pasta raiz do seu site.<br \/>\n<span class=\"mycode_b\"><span class=\"mycode_size\">2.<\/span><\/span>\u00a0Adicione o arquivo\u00a0<strong><span class=\"mycode_b\">Pix-mercadopago.php<\/span><\/strong>\u00a0na parte de paginas do seu site.<br \/>\n<span class=\"mycode_b\"><span class=\"mycode_size\">3.<\/span><\/span>\u00a0Adicione o arquivo\u00a0<strong><span class=\"mycode_b\">cacert.pem<\/span><\/strong> dentro das pasta raiz e pasta de paginas do seu site.<br \/>\n<span class=\"mycode_b\"><span class=\"mycode_size\">4.<\/span><\/span>\u00a0Configure as chaves do Mercado Pago no arquivo\u00a0<strong><span class=\"mycode_b\">Pix-mercadopago.php<\/span><\/strong><\/p>\n<blockquote><p>$public_key = &#8216;SUA_PUBLIC_KEY&#8217;;<br \/>\n$access_token = &#8216;SEU_ACCESS_TOKEN&#8217;;<\/p><\/blockquote>\n<p><span class=\"mycode_b\">\u00a0 \u00a0 \u00a0<span class=\"mycode_size\">5<\/span><\/span><span class=\"mycode_b\"><span class=\"mycode_size\">.<\/span><\/span>\u00a0Configure a conex\u00e3o com banco nos dois arquivos (<span class=\"mycode_b\">Pix-mercadopago.php<\/span>\u00a0e\u00a0<span class=\"mycode_b\">webhook.php<\/span>).<br \/>\nExemplo:<\/p>\n<blockquote><p>$db = new PDO(&#8220;mysql:host=localhost;dbname=SEU_BANCO&#8221;, &#8220;USUARIO&#8221;, &#8220;SENHA&#8221;);<\/p><\/blockquote>\n<p>ou MySQLi no webhook:<\/p>\n<blockquote><p>$db = new mysqli(&#8216;localhost&#8217;, &#8216;usuario&#8217;, &#8216;senha&#8217;, &#8216;banco&#8217;);<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p><span class=\"mycode_b\"><span class=\"mycode_size\">6.<\/span><\/span>\u00a0Acesse a p\u00e1gina<span class=\"mycode_b\">\u00a0<strong>Pix-mercadopago.php<\/strong>\u00a0<\/span>pelo navegador,\u00a0selecione a quantidade de pontos.<br \/>\n<span class=\"mycode_b\">\u00a0<span class=\"mycode_size\">7.<\/span><\/span>\u00a0O usu\u00e1rio paga via Pix usando o QR Code ou copia o c\u00f3digo Pix.<br \/>\n<span class=\"mycode_b\"><span class=\"mycode_size\">8.<\/span><\/span>\u00a0Webhook recebe a confirma\u00e7\u00e3o do pagamento e adiciona automaticamente os pontos na conta do usu\u00e1rio.<\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"mycode_b\"><span class=\"mycode_size\"><strong>Observa\u00e7\u00f5es importantes<\/strong><br \/>\n<\/span><\/span><\/p>\n<ul class=\"mycode_list\">\n<li>Certifique-se de que o webhook esteja acess\u00edvel publicamente (<a href=\"https:\/\/seusite.com.br\/webhook.php\" rel=\"nofollow noopener ugc external\">https:\/\/seusite.com.br\/webhook.php<\/a>).<\/li>\n<li>Os logs ajudam a depurar problemas de API ou de banco.<\/li>\n<li>O c\u00f3digo j\u00e1 trata usu\u00e1rios n\u00e3o logados, pagamentos duplicados e erros na API do Mercado Pago.<\/li>\n<li>Para produ\u00e7\u00e3o, mantenha\u00a0<span class=\"mycode_b\">display_errors=0<\/span>\u00a0e use HTTPS.<\/li>\n<li>Para alterar o valor de cada pontos vai no arquivo\u00a0<span class=\"mycode_b\">Pix-mercadopago.php<\/span>\u00a0e altere esse valor\u00a0<span class=\"mycode_b\">$valor = $pontos * 0.50;<\/span><\/li>\n<\/ul>\n<p><strong><span class=\"mycode_size\">*Pronto para come\u00e7ar a ganhar pontos e turbinar sua conta? Visite nosso site <a href=\"http:\/\/ayoocloud.com.br\/\" rel=\"nofollow noopener ugc external\">AyooCloud\u00a0<\/a>e aproveite todos os recursos!*<\/span><\/strong><\/p>\n<p><strong>Algumas fotos<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-80\" src=\"https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151247-300x127.png\" alt=\"Quantidade de pontos\" width=\"305\" height=\"129\" srcset=\"https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151247-300x127.png 300w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151247-768x326.png 768w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151247.png 777w\" sizes=\"auto, (max-width: 305px) 100vw, 305px\" \/><\/p>\n<p><strong>Experimente o sistema completo em\u00a0<a href=\"http:\/\/ayoocloud.com.br\/\" rel=\"nofollow noopener ugc external\">AyooCloud<\/a><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-81 size-medium\" src=\"https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151305-300x227.png\" alt=\"Qrcode exibido com o valor.\" width=\"300\" height=\"227\" srcset=\"https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151305-300x227.png 300w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151305-768x580.png 768w, https:\/\/ayoocloud.com.br\/blog\/wp-content\/uploads\/2025\/08\/Captura-de-tela-2025-08-14-151305.png 781w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span class=\"mycode_size\"><span class=\"mycode_b\">Arquivos:<\/span><\/span><\/strong><\/p>\n<p><a href=\"https:\/\/mega.nz\/file\/RytBgYhC#AcgydMmERlG6gfKMP2yTYpq2EsdbNIFx9wuJ8mkqdME\"><strong><span class=\"mycode_b\"><span class=\"mycode_size\">Pix-mercadopago.php<\/span><\/span><\/strong><\/a><\/p>\n<p><strong><a href=\"https:\/\/mega.nz\/file\/lqFSVCyY#-q9UfqOxteD3iTVMHk8HDtMnwslkllbN6x2MSFNslgA\">webhook_mercadopago.php<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/mega.nz\/file\/13NRFCTT#-kgMfvvqtYHLN763XU5oA_OuTetR9LrKhzWav4Dfss8\">cacert.pem<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"mycode_color\"><span class=\"mycode_size\"><span style=\"color: #ff0000;\"><strong>OBS:<\/strong><\/span>\u00a0<\/span><\/span><span class=\"mycode_color\"><span class=\"mycode_size\">Esse codigo foi testado apenas em site de otserv myaac vers\u00e3o 1.8, n\u00e3o sei se funciona em vers\u00e3o anteriores.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Comprar Pontos com Pix via Mercado Pago \u2013 Sistema PHP Completo Myaac &#8211; Pix via MercadoPago Otserv Automatico Se voc\u00ea administra um Otserv e utiliza o MyAAC, este tutorial \u00e9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,29,11,22],"tags":[],"class_list":["post-77","post","type-post","status-publish","format-standard","hentry","category-ot-server","category-servidor-dedicado","category-servidor-vps","category-tibia"],"_links":{"self":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/comments?post=77"}],"version-history":[{"count":3,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/77\/revisions"}],"predecessor-version":[{"id":84,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/posts\/77\/revisions\/84"}],"wp:attachment":[{"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/categories?post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ayoocloud.com.br\/blog\/wp-json\/wp\/v2\/tags?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}