Adicionando Moedas do game na web Ferarezi!

[Goten]

Bom Pessoal vou ser breve.
Vou ensinar como add moedas do game no site ferra merda
e deixar um codigo aqui para que as moedas apareça no menu lateral
igual a imagem


Primeiro roda essas 2 query na db MuOnline

ALTER TABLE dbo.Z_GameCurrencies ADD
guidColumn nvarchar(50) NULL

ALTER TABLE dbo.Z_GameCurrencies ALTER COLUMN
accountColumn NVARCHAR(50) NULL

depois disso logue no manager
Va em Configurações > loja de Creditos > Gerenciar Moedas.


Depois configure da forma que esta na sua DB (A Coluna guidColumn precisa estar como a imagem)

Depois disso voce usa esse codigo no seu LoginAjax2.php(ele se encontra na pasta do seu template /modules/LoginAjax2.tpl)
Abra ele usando um editor php..(recomendo o notpad++)
Para S4 use esse código

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Transfer.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php");
$db = new MuDatabase();

require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php");
$acc = new Account($db);

$db->Query("SELECT * FROM MEMB_INFO WHERE memb___id = '$acc->memb___id'");
$data = $db->GetRow();
?>
<div style="margin-top:-24px; margin-le1ft:20px; padding-top:0px;">
    <strong style="font-size:14px;">&nbsp;Olá, <span class="text-muted">{name}!</span></strong>
   <hr>
        &nbsp;<a href="#descermenu" onclick="LoadContent('?c=Messages')"><span style="color:#F00">{messages}</span> aviso(s)</a>.<br>
            <div style="margin-right: 20px; margin-bottom: 10px;">
        <i class="fa fa-angle-double-right fa-fw"></i>{vip_status}<br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>Cr&eacute;dito:</strong> R$ {credits},00<br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>Gold:</strong> <?php echo number_format($data['gold'],0,',','.'); ?><br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>Cash:</strong> <?php echo number_format($data['cash'],0,',','.'); ?><br>
        
        
        <!--<i class="fa fa-angle-double-right fa-fw"></i><strong>GlobalCoins:</strong> {Credit_1}<br>--->
                         </div>                                                          
                    <hr>
                     <a href="#gerenciar" onclick="LoadContent('?c=UserPanel')"><button class="btn btn-primary">Gerenciar</button></a> 
                     <a href="http://www.seusite.com.br/site/index.php?logout"><button class="btn btn-default btn-sm">Sair</button></a>
   </div>

Para S6/S8 Use esse ( ambos tem cashshop)

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Config/Transfer.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php");
$db = new MuDatabase();

require_once($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Account.class.php");
$acc = new Account($db);

$db->Query("SELECT * FROM CashShopData WHERE AccountID = '$acc->memb___id'");
$data = $db->GetRow();
?>
<div style="margin-top:-24px; margin-le1ft:20px; padding-top:0px;">
    <strong style="font-size:14px;">&nbsp;Olá, <span class="text-muted">{name}!</span></strong>
   <hr>
        &nbsp;<a href="#descermenu" onclick="LoadContent('?c=Messages')"><span style="color:#F00">{messages}</span> aviso(s)</a>.<br>
            <div style="margin-right: 20px; margin-bottom: 10px;">
        <i class="fa fa-angle-double-right fa-fw"></i>{vip_status}<br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>Cr&eacute;dito:</strong> R$ {credits},00<br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>HuntCoins:</strong> <?php echo number_format($data['WCoinC'],0,',','.'); ?><br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>C.Coins:</strong> <?php echo number_format($data['WCoinP'],0,',','.'); ?><br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>GoblinPoint:</strong> <?php echo number_format($data['GoblinPoint'],0,',','.'); ?></br>
        
        <i class="fa fa-angle-double-right fa-fw"></i><strong>GlobalCoins:</strong> {Credit_1}<br>
                         </div>                                                          
                    <hr>
                     <a href="#gerenciar" onclick="LoadContent('?c=UserPanel')"><button class="btn btn-primary">Gerenciar</button></a> 
                     <a href="http://www.seusite.com.br/site/index.php?logout"><button class="btn btn-default btn-sm">Sair</button></a>
   </div>

Espero que todos tenha entendido '-'

Creditos
Querys: @L.Henrique
Codigo php: ???? nao sei quem fez