function PrizeWinner(&$db, $post)
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/Language/{$MainLanguage}/Events.php";
$db->Query("SELECT AccountID FROM Character WHERE Name = '" . $post['Name'] . "'");
if ($db->NumRows() != 1) {
return $EventsMessage035;
}
$data = $db->GetRow();
$memb___id = $data[0];
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($db);
$db->Query("SELECT * FROM Z_EventsSchedule WHERE idx = '" . $post['idx'] . "' AND (winner IS NULL OR winner = '')");
if ($db->NumRows() != 1) {
return "Oops ;)";
}
$data = $db->GetRow();
for ($i = 1; $i <= 5; $i++) {
if ($data["currency{$i}"] > 0) {
$acc->AddCredits($memb___id, $i, $data["currency{$i}"], $db);
}
}
$db->Query("UPDATE Z_EventsSchedule SET winner = '" . $post['Name'] . "' WHERE idx = '" . $post['idx'] . "'");
return $EventsMessage034;
}
if (in_array('', $post) && $post['type'] == 0) {
$mensagem = "<div class='alert alert-info'><b>{$acc->memb_name}</b>, por favor preencha todas os campos para continuar.</div>";
} elseif ($post['valor'] < VALOR_MIN || $post['valor'] > VALOR_MAX) {
$mensagem = "<div class='alert alert-warning'><b>{$acc->memb_name}</b>, o valor transferido deve conter no mínimo " . VALOR_MIN . " e máximo " . VALOR_MAX . ".</div>";
} else {
$db->Query("SELECT memb___id FROM MEMB_INFO WHERE memb___id = '" . $post['destino'] . "'");
if ($db->NumRows() <= 0) {
$mensagem = "<div class='alert alert-danger'><b>{$acc->memb_name}</b>, login não encontrado no banco de dados, por favor digite novamente.</div>";
} elseif ($post['destino'] == $acc->memb___id) {
$mensagem = "<div class='alert alert-warning'><b>{$acc->memb_name}</b>, você não pode transferir para sua propria conta, por favor digite um login diferente do seu.</div>";
} elseif ($acc->GetCreditAmount($acc->memb___id, $post['type'], $db) < $post['valor']) {
$mensagem = "<div class='alert alert-info'><b>{$acc->memb_name}</b>, você não tem " . $moedas[$post['type']] . " suficiente para fazer a transferencia.</div>";
} else {
//
$acc->ReduceCredits($acc->memb___id, $post['type'], $post['valor'], $db);
$acc->AddCredits($post['destino'], $post['type'], $post['valor'], $db);
$mensagem = "<div class='alert alert-success'><b>{$acc->memb_name}</b>, você acaba de transferir <b>" . $post['valor'] . " " . $moedas[$post['type']] . "</b> para a conta <b>" . $post['destino'] . "</b>.</b></div>";
}
}
}
break;
}
}
?>
<div class="panel-group" id="accordion">
<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title"> <a> <i class="fa fa-arrow-circle-o-right"></i> Transferência de Moedas </a> </h4>
</div>
<div class="panel-body">
function ConfirmDonation(&$db, $idx)
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Donations.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/Language/{$MainLanguage}/Donations.php";
$db->Query("SELECT * FROM Z_Income WHERE idx = '{$idx}'");
$data = $db->GetRow();
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($db);
$Amount = $data['amount'];
if (isset($DonationsPercentDeposit) && $DonationsPercentDeposit != 100) {
$Amount = (int) ($Amount * $DonationsPercentDeposit / 100);
}
$acc->AddCredits($data['memb___id'], 0, $Amount, $db);
$db->Query("UPDATE Z_Income SET status = '1' , date_confirm = getdate() WHERE idx = '{$idx}'");
$dateClass = new Date();
$currentDateTime = $dateClass->DateFormat(date("Y-m-d")) . " " . $dateClass->TimeFormat(date("H:i"), "h");
$replaces = array("[number]" => $idx, "[amount]" => $Amount, "[date]" => $currentDateTime);
foreach ($replaces as $Key => $Value) {
$DonationsMessage29 = str_replace($Key, $Value, $DonationsMessage29);
$DonationsMessage33 = str_replace($Key, $Value, $DonationsMessage33);
$DonationsMessage34 = str_replace($Key, $Value, $DonationsMessage34);
}
if ($DonationsMessage) {
$acc->NewUserMessage($db, $data['memb___id'], $DonationsMessage29, $DonationsMessage34);
}
if ($DonationsMail) {
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Mail.class.php";
$db->Query("SELECT mail_addr,memb_name FROM MEMB_INFO WHERE memb___id = '" . $data['memb___id'] . "'");
$userData = $db->GetRow();
$mailCass = new Mail();
$mailCass->SendMail($userData['mail_addr'], $userData['memb_name'], $DonationsMessage29, $DonationsMessage33);
}
return $DonationsMessage35;
}
function SaveServerData(&$db, $post)
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/Language/{$MainLanguage}/Users.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Language/{$MainLanguage}/GenericMessages.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/VIP_.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/SQL.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Manager.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($db);
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/System/Manager.class.php";
$mn = new Manager();
if ($mn->GetUserLevel($_SESSION['ManagerId'], $db) >= $ManagerServerSaveLevel) {
$query = "\n\t\t\tUPDATE MEMB_INFO SET \n\t\t\t{$SQLVIPColumn} = '" . $post['VipId'] . "',\n\t\t\t{$SQLVIPDateColumn} = '" . $post['DueYear'] . "-" . $post['DueMonth'] . "-" . $post['DueDay'] . "'\n\t\t\tWHERE memb___id = '" . $post['memb___id'] . "'";
$db->Query($query);
$NewDue = $post['ItemDueYear'] . "-" . $post['ItemDueMonth'] . "-" . $post['ItemDueDay'];
$acc->SetVipItem($post['memb___id'], $post['VipItem'], $db, $NewDue);
for ($i = 1; $i <= 5; $i++) {
if (isset($post["Credit{$i}"])) {
$acc->AddCredits($post['memb___id'], $i, $post["Credit{$i}"], $db, "set");
}
}
for ($i = 1; $i <= 5; $i++) {
if (isset($post["GameCredit{$i}"]) && strlen($post["GameCredit{$i}"]) > 0) {
$db->Query("SELECT * FROM Z_GameCurrencies WHERE idx = '{$i}'");
$data = $db->GetRow();
$database = $data['database'];
$table = $data['table'];
$column = $data['column'];
$accountColumn = $data['accountColumn'];
if (!empty($accountColumn)) {
$db->Query("SELECT {$column} FROM {$database}.dbo.{$table} WHERE {$accountColumn} = '" . $post['memb___id'] . "'");
if ($db->NumRows() < 1) {
if (!$db->Query("INSERT INTO {$database}.dbo.{$table} ({$column},{$accountColumn}) VALUES ('" . $post["GameCredit{$i}"] . "','" . $post['memb___id'] . "')")) {
return "Fatal error.";
}
} else {
$db->Query("UPDATE {$database}.dbo.{$table} SET {$column} = '" . $post["GameCredit{$i}"] . "' WHERE {$accountColumn} = '" . $post['memb___id'] . "'");
}
}
}
}
return $UsersMessage040;
}
return $GenericMessage07;
}
exit;
}
curl_close($ch);
if (strcmp($res, "VERIFIED") == 0) {
// check whether the payment_status is Completed
// check that txn_id has not been previously processed
$item_name = $_POST['item_name'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$custom = $_POST['custom'];
if ($payment_status == "Completed") {
$payment_amount *= ${"PayPalExchangeTo" . $payment_currency};
$payment_amount = round($payment_amount);
$db->Query("SELECT COUNT(idx) FROM Z_Income WHERE data = '{$txn_id}'");
$data = $db->GetRow();
if ($data[0] < 1) {
$acc->AddCredits($custom, 0, $payment_amount, $db);
//$db->Query("INSERT INTO XW_Income (memb___id, amount, bank, way, date_confirm, data, status) VALUES ('$custom', '$payment_amount', 'PayPal', 'PayPal', getdate(), '$txn_id', '1')");
}
}
$string = "" . date("Y-m-d") . "\t\"{$payment_status}\"\t\"{$custom}\"\t\"R\${$payment_amount}\"\t\"{$txn_id}\"\r\n";
$file = fopen("PayPalLog.txt", "a");
fwrite($file, $string);
fclose($file);
}
$db->Disconnect();
echo "<script>window.location.href='/';</script>";
if ($confirma) {
$TransacaoID = $_POST['TransacaoID'];
$Referencia = $_POST['Referencia'];
$StatusTransacao = $_POST['StatusTransacao'];
$CliNome = $_POST['CliNome'];
$ProdValor_1 = explode(",", $_POST['ProdValor_1']);
$ProdValor_1 = $ProdValor_1[0];
$TipoPagamento = $_POST['TipoPagamento'];
if (strpos($TipoPagamento, "Cart") !== false) {
$TipoPagamento = "Cartao de Credito";
}
if ($StatusTransacao == "Aprovado") {
if (isset($DonationsPercentPagSeg) && $DonationsPercentPagSeg != 100) {
$ProdValor_1 = ceil($ProdValor_1 * $DonationsPercentPagSeg / 100);
}
$acc->AddCredits($Referencia, 0, $ProdValor_1, $db);
if (!$db->Query("INSERT INTO Z_Income (memb___id, amount, bank, way, date_confirm, data, status) VALUES ('{$Referencia}', '{$ProdValor_1}', 'PagSeguro', '{$TipoPagamento}', getdate(), '{$TransacaoID}', '1')")) {
$handle = fopen("PagSeguroError.txt", "a");
if ($handle) {
$string = date("Y-m-d H:i") . " - Erro de escrita no INSERT: -> ('{$Referencia}', '{$ProdValor_1}', '{$TipoPagamento}', '{$TransacaoID}', '1') \r\n";
fwrite($handle, $string);
fclose($handle);
}
}
$db->Query("SELECT memb___id FROM Z_Income WHERE bank = 'PagSeguro' AND data = '{$TransacaoID}'");
if ($db->NumRows() < 1) {
$handle = fopen("PagSeguroError.txt", "a");
if ($handle) {
$string = date("Y-m-d H:i") . " - Erro de leitura da linha\r\n";
fwrite($handle, $string);
fclose($handle);
function CancelPurchases(&$db, $post)
{
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Main.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/WebShop.php";
require $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Manager/Language/{$MainLanguage}/WebShop.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php";
$acc = new Account($db);
$chargeBack = 0;
foreach ($post['purchases'] as $key => $value) {
$db->Query("SELECT * FROM Z_WebShopLog WHERE idx = '{$value}' AND status = '1'");
if ($db->NumRows() > 0) {
$data = $db->GetRow();
if ($data['insurance'] == 0) {
$reversal = (int) ($data['price'] * $WebShopCancelPercentNoInsurance / 100);
} else {
$reversal = (int) ($data['price'] * $WebShopCancelPercentInsurance / 100);
}
$acc->AddCredits($data['memb___id'], $data['currency'], $reversal, $db, "add");
$chargeBack += $reversal;
$db->Query("UPDATE Z_WebShopLog SET status = '0' WHERE idx = '{$value}'");
}
}
return count($post['purchases']) . " " . $WebShopMessage025 . "<br />" . $WebShopMessage131 . $chargeBack;
}