[Encerrado] Problema com site donate

[JoaquimJunior 0]

Estou tentado usar o server para mim poder zoar em casa, sem internet e tals o server está funcionando normal ainda estou pegado o jeito dos novos sistemas

e o problema maior e o site quando vou adicionar Tibia Coins na conta é como não entendo muito de php e de programação não consigo usar o sistema de compra no site queria cortar a parte que verifica se foi feito o deposito no pagseguro final só vou usar sem net e em rede local. se possível me ajudem a cortar esses staps.

Spoiler

 

retpagseguro.php

<?php

### DONT TOUCH IN THIS CODE ###
### WORKING FINE 19/08/2006 ###
###       IVENSPONTES       ###
### github.com/ivenspontes/ ###

header("access-control-allow-origin: https://pagseguro.uol.com.br");
require_once 'custom_scripts/PagSeguroLibrary/PagSeguroLibrary.php';
require 'config/config.php';

// comment to show E_NOTICE [undefinied variable etc.], comment if you want make script and see all errors
error_reporting(E_ALL ^ E_STRICT ^ E_NOTICE);

// true = show sent queries and SQL queries status/status code/error message
define('DEBUG_DATABASE',false);

define('INITIALIZED', true);

// if not defined before, set 'false' to load all normal
if(!defined('ONLY_PAGE'))
    define('ONLY_PAGE', false);

// check if site is disabled/requires installation
include_once('./system/load.loadCheck.php');

// fix user data, load config, enable class auto loader
include_once('./system/load.init.php');

// DATABASE
include_once('./system/load.database.php');
if(DEBUG_DATABASE)
    Website::getDBHandle()->setPrintQueries(true);
// DATABASE END

$method = $_SERVER['REQUEST_METHOD'];

if('POST' == $method){

    $type = $_POST['notificationType'];

    $notificationCode = $_POST['notificationCode'];

    if ($type === 'transaction'){

        try {
            $credentials = PagSeguroConfig::getAccountCredentials();
            $transaction = PagSeguroNotificationService::checkTransaction($credentials, $notificationCode);

            $reference= explode("-",$transaction->getReference());

            $transaction_code = $transaction->getCode();
            $arrayPDO['transaction_code'] = $transaction->getCode();

            $name = $reference[0]; //exploded from reference;
            $arrayPDO['name'] = $name;
            $arrayPDO['payment_method'] = $transaction->getPaymentMethod()->getType()->getTypeFromValue();
            $arrayPDO['status'] = $transaction->getStatus()->getTypeFromValue();
            $arrayPDO['payment_amount'] = $transaction ->getGrossAmount();
            $item = $transaction->getItems();
            $arrayPDO['item_count'] = $reference[1];
            $date_now = date('Y-m-d H:i:s');
            $arrayPDO['data'] = $date_now;

            try {

                $conn = $SQLPDO;
                $stmt = $conn->prepare('INSERT into pagseguro_transactions SET transaction_code = :transaction_code, name = :name, payment_method = :payment_method, status = :status, item_count = :item_count, data = :data, payment_amount = :payment_amount');
                $stmt->execute($arrayPDO);

                if ($arrayPDO['status'] == 'PAID') {
                    if ($config['pagseguro']['doublePoints']) {
                        $arrayPDO['item_count'] = $arrayPDO['item_count']*2;
                    }
                    $stmt = $conn->prepare('UPDATE accounts SET coins = coins + :item_count WHERE name = :name');
                    $stmt->execute(array('item_count' => $arrayPDO['item_count'], 'name' => $arrayPDO['name']));

                    $stmt = $conn->prepare("UPDATE pagseguro_transactions SET status = 'DELIVERED' WHERE transaction_code = :transaction_code AND status = 'PAID'");
                    $stmt->execute(array('transaction_code' => $arrayPDO['transaction_code']));
                }
                echo 'wow';

            } catch(PDOException $e) {
                echo 'ERROR: ' . $e->getMessage();
            }

        } catch(PagSeguroServiceException $e) {
            die($e->getMessage());
        }

    }
}
 

Spoiler

dntpagseguro.php

 

<?php

### DONT TOUCH IN THIS CODE ###
### WORKING FINE 19/08/2006 ###
###       IVENSPONTES       ###
### github.com/ivenspontes/ ###

require_once 'custom_scripts/PagSeguroLibrary/PagSeguroLibrary.php';
require 'config/config.php';

$product_id = $_POST['pid'];

$account_name = $_POST['accname'];

if(!isset($product_id, $account_name) || !isset($config['pagseguro']['offers'][intval($product_id)])){
    die("invalid parameters");
}
else {

    $coinCount = $config['pagseguro']['offers'][intval($product_id)];

    $paymentRequest = new PagSeguroPaymentRequest();
    $paymentRequest->addItem('1', $coinCount . " " . $config['pagseguro']['produtoNome'], 1, $product_id/100.0);
    $paymentRequest->setCurrency("BRL");
    $paymentRequest->setShippingType(3); //Not specified
    $paymentRequest->setShippingCost(0.0);
    $paymentRequest->setReference($account_name . "-" . $coinCount);
    $paymentRequest->setRedirectUrl($config['pagseguro']['urlRedirect']);
    $paymentRequest->addParameter('notificationURL', $config['pagseguro']['urlNotification']);

    try {

        $credentials = PagSeguroConfig::getAccountCredentials();
        $checkoutUrl = $paymentRequest->register($credentials);
        header('location:' . $checkoutUrl);

    } catch (PagSeguroServiceException $e) {
        die($e->getMessage());
    }
}

?>

 

Spoiler

config.php

 

<?PHP
// ----Config Shop----
$outfits_list = array();
$loyalty_title = array(50 => 'Scout', 100 => 'Sentinel', 200 => 'Steward', 400 => 'Warden', 1000 => 'Squire', 2000 => 'Warrior', 3000 => 'Keeper', 4000 => 'Guardian', 5000 => 'Sage');
$config['shop']['newitemdays'] = 1; #days to item be new in shop

# Pagseguro configs
$config['pagseguro']['testing'] = true;
$config['pagseguro']['tokentest'] = "true";
$config['pagseguro']['email'] = '';
$config['pagseguro']['apitoken'] = '';

# Bank transfer data
$config['banktransfer']['bank'] = "Caixa EconĂ´mica";
$config['banktransfer']['agency'] = "";
$config['banktransfer']['account'] = "";
$config['banktransfer']['name'] = "";
$config['banktransfer']['operation'] = 003; // 0 = no operation

# PayPal configs
$config['paypal']['email'] = "";

# Social Networks
$config['social']['status'] = true;
$config['social']['facebook'] = "https://www.facebook.com/tibia";

# PAGE: characters.php
$config['site']['quests'] = array(
"Demon Helmet" => 2213,
"In Service of Yalahar" => 12279,
"Pits Of Inferno" => 10544,
"The Ancient Tombs" => 50220,
"The Annihilator" => 2215,
"The Demon Oak" => 1010,
"Wrath Of The Emperor" => 12374);

# time in days to show the former names
$config['site']['formerNames'] = 10;
$config['site']['formerNames_amount'] = 10;

# Account Maker Config
$config['site']['serverPath'] = "C:/otxserver-new-master/"; 

$config['site']['useServerConfigCache'] = false;
$towns_list = array(
1 => 'Venore', 
2 => 'Thais', 
3 => 'Kazordoon', 
4 => 'Carlin', 
5 => 'Ab\'Dendriel', 
6 => 'Rookgaard', 
7 => 'Liberty Bay', 
8 => 'Port Hope', 
9 => 'Ankrahmun', 
10 => 'Darashia', 
11 => 'Edron', 
12 => 'Svargrond', 
13 => 'Yalahar', 
14 => 'Farmine', 
28 => 'Gray Beach',
29 => 'Roshamuul',
33 => 'Rathleton',
34 => 'Krailos',
51 => 'Dawnport',
52 => 'Feyrist',
);
# this is important if you want to use ajax check in your create account
$config['site']['sqlHost'] = "localhost";
$config['site']['sqlUser'] = "root";
$config['site']['sqlPass'] = "654321";
$config['site']['sqlBD'] = "database";

# Create Account Options
$config['site']['one_email'] = true;
$config['site']['create_account_verify_mail'] = true;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 7;
$config['site']['newaccount_premdays'] = 0;
$config['site']['send_register_email'] = true;

# Create Character Options
$config['site']['newchar_vocations'] = array(0 => 'Rook Sample'); // if you wan't use rook, put (1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'] = array(6, 51);
$config['site']['max_players_per_account'] = 10;

# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "";
$config['site']['mail_senderName'] = "";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "ssl://smtp.gmail.com";
$config['site']['smtp_port'] = 465;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "";
$config['site']['smtp_pass'] = "";
$config['site']['smtp_secure'] = true;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['email_time_change'] = 7;
$config['site']['daystodelete'] = 7;
$config['site']['flash_client_enabled'] = false;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 8;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(3, 4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

#  Pagseguro offers
// ValorR$ => Qtd_coins
$config['pagseguro']['offers'] = array(
    600=>80,
    800=>125,
    1500=>250,
    2800=>500,
    4000=>1000
);
// Nome do produto
$config['pagseguro']['produtoNome'] = 'Tibia Coins';

$config['pagseguro']['urlRedirect'] =  'https://127.0.0.1/';
$config['pagseguro']['urlNotification'] = 'https://127.0.0.1/retpagseguro.php';

# Layout Config
$config['site']['layout'] = 'tibiarl';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;

[VictorWEBMaster 369]

Insira direto os coins no banco de dados.

[Refe 320]

A questão neste suporte foi encerrada por falta de respostas. Este tópico está fechado e foi movido para Suporte - Tópicos Sem Resposta.

+ Caso a dúvida não tenha sido resolvida você poderá criar outro tópico solicitando ajuda.
* Lembre-se que é permitido dar UP no tópico a cada 24 horas para assim o destacar e manter movimentado.