Siga-nos em...
Follow us on Twitter Follow us on Facebook Watch us on YouTube
Registro

Alpha Servers
Resultados 1 a 8 de 8
  1. #1

    Avatar de Mr.Junior
    Data de Ingresso
    Jul 2011
    Localização
    Hortolândia
    Idade
    31
    Posts
    507
    Agradecido
    165
    Agradeceu
    97
    Peso da Avaliação
    18

    Padrão VIP MuSite + MuServer X-Team.

    Alguém poderia me dar uma força ? Estou querendo utilizar o MuSite, acontece que o sistema de VIP da X-Team é meio chato.

    Gabriel chegou a fazer algumas alterações nos módulos do MuSite mas estou testando o mesmo, e está acontecendo um probleminha chato.


    Digamos que eu realize o cadastro e ganho X Quantidade de VIP, aparentemente o site está inserindo corretamente o VIP mas quando logo no painel de controle automaticamente é removido os dias de VIP e a conta volta a ser ( Free ) assim também acontece se eu tentar comprar o plano VIP, ele insere é realizado a compra normalmente mas ao atualizar a página e voltar para o painel de controle eu o VIP é removido.

    Alguém poderia me ajudar ?

    Colunas :

    AccountLevel -> Armazena o nível de conta atual do jogador.
    AccountExpireDate -> Armazena a data de vencimento do plano de conta atual.


    ldpaneluser.class.php ( O Arquivo abaixo e outros tiveram alterações pelo Gabriel ).

    <?php
    $PageRequest = strtolower(basename( $_SERVER['REQUEST_URI'] ));
    $PageName = strtolower(basename( __FILE__ ));
    if($PageRequest == $PageName) exit("<strong> Erro: N&atilde;o &eacute; permitido acessar o arquivo diretamente. </strong>");

    if ( class_exists( "ldPanelUser" ) == false ) {
    new ldLanguage( str_replace(".class.", ".lang.", basename(__FILE__)), false );
    class ldPanelUser extends ldMssql {
    public function __construct()
    {
    global $ldTpl, $PANELUSER_PREMISSIONS;
    if(isset($_SESSION['LOGIN']) == false)
    return $ldTpl->open("templates/".TEMPLATE_DIR."/loginerror.tpl.php");

    $this->checkVipDate();
    $this->setPermissions();
    switch(strtoupper($_GET['option']))
    {
    case "MODIFY_DATA":
    if($PANELUSER_PREMISSIONS['MODIFY_DATA'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("MODIFY_DATA") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsModifyData();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[MODIFY_DATA].tpl.php");
    break;
    case "CLEAN_VAULT":
    if($PANELUSER_PREMISSIONS['CLEAN_VAULT'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("CLEAN_VAULT") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsCleanVault();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[CLEAN_VAULT].tpl.php");
    break;
    case "DOUBLE_VAULT":
    if($PANELUSER_PREMISSIONS['DOUBLE_VAULT'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("DOUBLE_VAULT") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsDoubleVault();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DOUBLE_VAULT].tpl.php");
    break;
    case "VIRTUAL_VAULT":
    if($PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("VIRTUAL_VAULT") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsVirtualVault();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[VIRTUAL_VAULT].tpl.php");
    break;
    case "GAME_DISCONNECT":
    if($PANELUSER_PREMISSIONS['GAME_DISCONNECT'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("GAME_DISCONNECT") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsGameDisconnect();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[GAME_DISCONNECT].tpl.php");
    break;
    case "GOLDEN_ARCHER":
    if($PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("GOLDEN_ARCHER") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsGoldenArcher();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[GOLDEN_ARCHER].tpl.php");
    break;
    case "COLLECTOR_POINTS":
    if($PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("COLLECTOR_POINTS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsCollectorPoints();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[COLLECTOR_POINTS].tpl.php");
    break;
    case "AUCTIONS":
    if($PANELUSER_PREMISSIONS['AUCTIONS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("AUCTIONS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsAuctions();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[AUCTIONS].tpl.php");
    break;
    case "QUESTIONS_EVENT":
    $this->loadOptionsQuestionsEvent();
    exit(); //prevent check again
    break;
    case "TRANSFER_CASH":
    $this->loadOptionsTransferCash();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[TRANSFER_CASH].tpl.php");
    break;
    case "LOG_BUYS":
    if($PANELUSER_PREMISSIONS['LOG_BUYS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("LOG_BUYS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsLogBuys();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[LOG_BUYS].tpl.php");
    break;
    case "MODIFY_PERSONALID":
    if($PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("MODIFY_PERSONALID") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsModifyPersonalID();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[MODIFY_PERSONALID].tpl.php");
    break;
    case "RESET":
    if($PANELUSER_PREMISSIONS['RESET'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("RESET") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsReset();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[RESET].tpl.php");
    break;
    case "MASTER_RESET":
    if($PANELUSER_PREMISSIONS['MASTER_RESET'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("MASTER_RESET") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsMasterReset();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[MASTER_RESET].tpl.php");
    break;
    case "RESET_TRANSFER":
    if($PANELUSER_PREMISSIONS['RESET_TRANSFER'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("RESET_TRANSFER") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsResetTransfer();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[RESET_TRANSFER].tpl.php");
    break;
    case "CLEAN_PK":
    if($PANELUSER_PREMISSIONS['CLEAN_PK'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("CLEAN_PK") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsCleanPk();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[CLEAN_PK].tpl.php");
    break;
    case "DISTRIBUTE_POINTS":
    if($PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("DISTRIBUTE_POINTS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsDistributePoints();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DISTRIBUTE_POINTS].tpl.php");
    break;
    case "MOVE_CHARACTER":
    if($PANELUSER_PREMISSIONS['MOVE_CHARACTER'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("MOVE_CHARACTER") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsMoveCharacter();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[MOVE_CHARACTER].tpl.php");
    break;
    case "CHANGE_NICK":
    if($PANELUSER_PREMISSIONS['CHANGE_NICK'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("CHANGE_NICK") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsChangeNick();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[CHANGE_NICK].tpl.php");
    break;
    case "CHANGE_CLASS":
    if($PANELUSER_PREMISSIONS['CHANGE_CLASS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("CHANGE_CLASS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsChangeClass();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[CHANGE_CLASS].tpl.php");
    break;
    case "REDISTRIBUTE_POINTS":
    if($PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("REDISTRIBUTE_POINTS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsRedistributePoints();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[REDISTRIBUTE_POINTS].tpl.php");
    break;
    case "CLEAN_INVENTORY":
    if($PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("CLEAN_INVENTORY") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsCleanInventory();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[CLEAN_INVENTORY].tpl.php");
    break;
    case "MANAGER_PHOTO":
    if($PANELUSER_PREMISSIONS['MANAGER_PHOTO'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("MANAGER_PHOTO") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsManagerPhoto();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[MANAGER_PHOTO].tpl.php");
    break;
    case "BUY_VIPS":
    if($PANELUSER_PREMISSIONS['BUY_VIPS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("BUY_VIPS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsBuyVips();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[BUY_VIPS].tpl.php");
    break;
    case "CONFIRM_PAYMENT":
    if($PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("CONFIRM_PAYMENT") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsConfirmPayment();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[CONFIRM_PAYMENT].tpl.php");
    break;
    case "OPEN_COMPLAINTS":
    if($PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("OPEN_COMPLAINTS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsOpenComplaints();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[OPEN_COMPLAINTS].tpl.php");
    break;
    case "OPEN_TICKET":
    if($PANELUSER_PREMISSIONS['OPEN_TICKET'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("OPEN_TICKET") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsOpenTicket();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[OPEN_TICKET].tpl.php");
    break;
    case "READ_TICKET":
    if($PANELUSER_PREMISSIONS['READ_TICKET'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("READ_TICKET") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsReadTicket();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[READ_TICKET].tpl.php");
    break;
    case "SEND_SMS":
    if($PANELUSER_PREMISSIONS['SEND_SMS'][0] == 0) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[DESACTIVE].tpl.php");
    if($this->checkPermissionModule("SEND_SMS") == false) return $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[ACCESSDANIED].tpl.php");
    $this->loadOptionsSendSMS();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser[SEND_SMS].tpl.php");
    break;
    default:
    $this->loadOptionsDefault();
    $ldTpl->open("templates/".TEMPLATE_DIR."/paneluser.tpl.php");
    break;
    }
    $this->questionsEventCheck();
    }
    private function checkBanAccount()
    {
    $findAccountBanQ = $this->query("SELECT dateend FROM dbo.webBanneds WHERE name='". $_SESSION['LOGIN'] ."' AND type=1");
    $findAccountBan = mssql_fetch_object($findAccountBanQ);
    if(time() > $findAccountBan->dateend)
    {
    $this->query("UPDATE ". DATABASE_ACCOUNTS .".dbo.MEMB_INFO SET bloc_code=0 WHERE memb___id='". $_SESSION['LOGIN'] ."'");
    $this->query("DELETE FROM dbo.webBanneds WHERE name = '". $_SESSION['LOGIN'] ."' AND type=1");
    }
    return $findAccountBan->dateend;
    }
    private function checkBanCharacter($name)
    {
    $findCharacterBanQ = $this->query("SELECT dateend FROM dbo.webBanneds WHERE name='". $name ."' AND type=2");
    $findCharacterBan = mssql_fetch_object($findCharacterBanQ);
    if(time() > $findCharacterBan->dateend)
    {
    $this->query("UPDATE ". DATABASE_CHARACTERS .".dbo.Character SET CtlCode=0 WHERE Name='". $name ."'");
    $this->query("DELETE FROM dbo.webBanneds WHERE name = '". $name ."' AND type=2");
    }
    return $findCharacterBan->dateend;
    }
    private function checkVipDate()
    {
    global $TABLES_CONFIGS;
    $findAccountVipQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." as dateend FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountVip = mssql_fetch_object($findAccountVipQ);
    if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 6)
    {
    if(time() > strtotime($findAccountVip->dateend))
    $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnType']."=0 WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    }
    else
    {
    if(time() > $findAccountVip->dateend)
    $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnType']."=0 WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    }

    }
    private function checkPermissionModule($module)
    {
    global $PANELUSER_PREMISSIONS, $TABLES_CONFIGS;
    $findAccountVipQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountVip = mssql_fetch_object($findAccountVipQ);
    if($PANELUSER_PREMISSIONS[$module][(int)$findAccountVip->type + 1] == 1) return true;
    else return false;
    }
    public function writeLog($type, $account, $character, $extraText)
    {
    global $PANELUSER_MODULE;
    if($PANELUSER_MODULE['LOG']['Active'] == false) return;

    switch($type)
    {
    case 1:
    $args = array("MODIFY_DATA", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_MODIFY_DATA." [{$extraText}]\n");
    break;
    case 2:
    $args = array("CLEAN_VAULT", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_CLEAN_VAULT." [{$extraText}]\n");
    break;
    case 3:
    $args = array("DOUBLE_VAULT", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_DOUBLE_VAULT." [{$extraText}]\n");
    break;
    case 4:
    $args = array("MODIFY_PERSONALID", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_MODIFY_PERSONALID." [{$extraText}]\n");
    break;
    case 5:
    $args = array("RESET", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_RESET." [{$extraText}]\n");
    break;
    case 6:
    $args = array("MASTER_RESET", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_MASTER_RESET." [{$extraText}]\n");
    break;
    case 7:
    $args = array("RESET_TRANSFER", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_RESET_TRANSFER." [{$extraText}]\n");
    break;
    case 8:
    $args = array("CLEAN_PK", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_CLEAN_PK." [{$extraText}]\n");
    break;
    case 9:
    $args = array("DISTRIBUTE_POINTS", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_DISTRIBUTE_POINTS." [{$extraText}]\n");
    break;
    case 10:
    $args = array("MOVE_CHARACTER", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_MOVE_CHARACTER." [{$extraText}]\n");
    break;
    case 11:
    $args = array("CHANGE_NICK", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_CHANGE_NICK." [{$extraText}]\n");
    break;
    case 12:
    $args = array("CHANGE_CLASS", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_CHANGE_CLASS." [{$extraText}]\n");
    break;
    case 13:
    $args = array("REDISTRIBUTE_POINTS", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_REDISTRIBUTE_POINTS." [{$extraText}]\n");
    break;
    case 14:
    $args = array("CLEAN_INVENTORY", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_CLEAN_INVENTORY." [{$extraText}]\n");
    break;
    case 15:
    $args = array("SEND_SMS", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_SEND_SMS." [{$extraText}]\n");
    break;
    case 16:
    $args = array("GAME_DISCONNECT", "[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_GAME_DISCONNECT." [{$extraText}]\n");
    break;
    case 17:
    $args = array("TRANSFER_CASH", "[".date("d/m/Y \a\s G:i:s")."][{$account}] ".LDPU_LOG_TXT_TRANSFER_CASH." [{$extraText}]\n");
    break;
    case 18:
    $args = array("COLLECTOR_POINTS", "[".date("d/m/Y \a\s G:i:s")."][{$account}] ".LDPU_LOG_TXT_COLLECTOR_POINTS." [{$extraText}]\n");
    break;
    default: $args = array("error", sprintf("[".date("d/m/Y \a\s G:i:s")."][{$account} | {$character}] ".LDPU_LOG_TXT_NOT_FOUND." [{$extraText}]\n", $type));
    }
    $handle = fopen($PANELUSER_MODULE['LOG']['DirLog']."/[".date("d-m-Y")."][".$args[0]."].log", "a");
    fwrite($handle, $args[1]);
    fclose($handle);
    }
    public function classNameDefine($numberClass)
    {
    global $CLASS_CHARACTERS;
    switch($numberClass) {
    case $CLASS_CHARACTERS['CLASSCODES']['DW'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DW'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['SM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['SM'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['GM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['GM'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DK'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DK'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['BK'][0] : return $CLASS_CHARACTERS['CLASSCODES']['BK'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['BM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['BM'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['FE'][0] : return $CLASS_CHARACTERS['CLASSCODES']['FE'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['ME'][0] : return $CLASS_CHARACTERS['CLASSCODES']['ME'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['HE'][0] : return $CLASS_CHARACTERS['CLASSCODES']['HE'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['MG'][0] : return $CLASS_CHARACTERS['CLASSCODES']['MG'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DMM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DMM'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DL'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DL'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['LE'][0] : return $CLASS_CHARACTERS['CLASSCODES']['LE'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['SU'][0] : return $CLASS_CHARACTERS['CLASSCODES']['SU'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['BS'][0] : return $CLASS_CHARACTERS['CLASSCODES']['BS'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DMS'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DMS'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['RF'][0] : return $CLASS_CHARACTERS['CLASSCODES']['RF'][1]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['FM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['FM'][1]; break;
    }
    }
    public function resetClassCode($class)
    {
    global $CLASS_CHARACTERS;
    switch($class)
    {
    case $CLASS_CHARACTERS['CLASSCODES']['DW'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DW'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['SM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DW'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['GM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DW'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DK'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DK'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['BK'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DK'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['BM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DK'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['FE'][0] : return $CLASS_CHARACTERS['CLASSCODES']['FE'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['ME'][0] : return $CLASS_CHARACTERS['CLASSCODES']['FE'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['HE'][0] : return $CLASS_CHARACTERS['CLASSCODES']['FE'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['MG'][0] : return $CLASS_CHARACTERS['CLASSCODES']['MG'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DMM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['MG'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DL'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DL'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['LE'][0] : return $CLASS_CHARACTERS['CLASSCODES']['DL'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['SU'][0] : return $CLASS_CHARACTERS['CLASSCODES']['SU'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['BS'][0] : return $CLASS_CHARACTERS['CLASSCODES']['SU'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['DMM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['SU'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['RF'][0] : return $CLASS_CHARACTERS['CLASSCODES']['RF'][0]; break;
    case $CLASS_CHARACTERS['CLASSCODES']['FM'][0] : return $CLASS_CHARACTERS['CLASSCODES']['RF'][0]; break;
    }
    }
    public function checkOnlineAccount($account)
    {
    $findAccountOnlineQ = $this->query("SELECT ConnectStat FROM ".DATABASE_ACCOUNTS.".dbo.MEMB_STAT WHERE memb___id='". $account ."'");
    $findAccountOnlineQ = mssql_fetch_object($findAccountOnlineQ);
    return $findAccountOnlineQ->ConnectStat;
    }
    private function loadOptionsDefault()
    {
    global $ldTpl, $TABLES_CONFIGS, $PANELUSER_MODULE;
    $findAccountBanQ = $this->query("SELECT bloc_code, hashActivate FROM ". DATABASE_ACCOUNTS .".dbo.MEMB_INFO WHERE memb___id='". $_SESSION['LOGIN'] ."'");
    $findAccountBan = mssql_fetch_object($findAccountBanQ);
    if($findAccountBan->bloc_code == 1 && $findAccountBan->hashActivate == null)
    {
    $timestamp = $this->checkBanAccount();
    $tempBanTpl = sprintf("<div class='qdestaques'>".LDPU_OPTIONS_DEFAULT_BANNED_A CCOUNT."</div>", date("d/m/Y g:i a",$timestamp));
    }
    elseif($findAccountBan->hashActivate != null)
    {
    $tempBanTpl = sprintf("<div class='qdestaques'>".LDPU_OPTIONS_DEFAULT_NOT_ACTI VE_ACCOUNT."</div>", $_SESSION['LOGIN']);
    }
    $ldTpl->set("BAN_ACCOUNT_DATAILS", $tempBanTpl);

    $findAccountVipQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." as dateend FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountVip = mssql_fetch_object($findAccountVipQ);

    if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 6)
    $visualDate = date("d/m/Y g:i a",strtotime($findAccountVip->dateend));
    else
    $visualDate = date("d/m/Y g:i a",$findAccountVip->dateend);

    $ldTpl->set("ACCOUNT_PLAN_DATAILS", $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][ $findAccountVip->type ] . ($findAccountVip->type > 0 ? ", ".LDPU_OPTIONS_DEFAULT_FLAT_EXPIRE.": ".$visualDate : NULL ));
    //$ldTpl->set("ACCOUNT_PLAN_DATAILS", ($findAccountVip->type == 0 ? $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][0] : ($findAccountVip->type == 1 ? $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][1].", ".LDPU_OPTIONS_DEFAULT_FLAT_EXPIRE.": ".date("d/m/Y g:i a",$findAccountVip->dateend) : ($findAccountVip->type == 2 ? $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][2].", ".LDPU_OPTIONS_DEFAULT_FLAT_EXPIRE.": ".date("d/m/Y g:i a",$findAccountVip->dateend) : LDPU_OPTIONS_DEFAULT_FLAT_ERROR))));

    $findAccountCashQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnAmount']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountCash = mssql_fetch_object($findAccountCashQ);
    $ldTpl->set("ACCOUNT_CASH", (int)$findAccountCash->amount);

    $findAccountCashQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountCash = mssql_fetch_object($findAccountCashQ);
    $ldTpl->set("ACCOUNT_CASH2", (int)$findAccountCash->amount);

    $findAccountPointsQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnPoints']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountPoints = mssql_fetch_object($findAccountPointsQ);
    $ldTpl->set("ACCOUNT_POINTS", (int)$findAccountPoints->amount);

    $findLastConnectionQ = $this->query("SELECT ConnectTM,IP,ServerName FROM ".DATABASE_ACCOUNTS.".dbo.MEMB_STAT WHERE memb___id='". $_SESSION['LOGIN'] ."'");
    $findLastConnection = mssql_fetch_object($findLastConnectionQ);
    $ldTpl->set("LAST_CONNECTION_DETAILS", $findLastConnection->ConnectTM." ".LDPU_OPTIONS_DEFAULT_LAST_CONNECTION." ". $findLastConnection->ServerName );
    $ldTpl->set("LAST_CONNECTION_DETAILS_IP", $findLastConnection->IP );

    $findLastCharactersQ = $this->query("SELECT Name,Class,".COLUMN_RESETS.",PkCount,CtlCode FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    if(mssql_num_rows($findLastCharactersQ) == 0) $ldTpl->set("CHARACTER_DETAILS","<tr><td colspan='4' align='center'>".LDPU_OPTIONS_DEFAULT_YOU_NOT_HAVE _CHARACTERS."</td></tr>");
    else
    {
    while($findLastCharacters = mssql_fetch_row($findLastCharactersQ))
    {
    $tmpChars .= "<tr><td>". $findLastCharacters[0] ."</td><td>". $this->classNameDefine($findLastCharacters[1]) ."</td><td>". $findLastCharacters[2] ."</td><td>". ($findLastCharacters[3] > 0 ? "Sim":"N�o") ."</td></tr>";
    if($findLastCharacters[4] == 1) $tmpBanChars .= sprintf("<div class='qdestaques'>".LDPU_OPTIONS_DEFAULT_BANNED_C HARACTER."</div>", $findLastCharacters[0], date("d/m/Y g:i a",$this->checkBanCharacter($findLastCharacters[0])));
    }
    $ldTpl->set("CHARACTER_DETAILS", $tmpChars);
    }
    $ldTpl->set("BAN_CHARACETERS_DATAILS", $tmpBanChars);
    }
    private function loadOptionsModifyData()
    {
    global $ldTpl;
    switch($_GET['Write'])
    {
    case 1:
    if(empty($_POST['userName']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_FILL_NAME." </div>";
    elseif(empty($_POST['userTel']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_FILL_PHONE. "</div>";
    elseif(strlen($_POST['userName']) > 10) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_INVALID_SIZ E_NAME."</div>";
    elseif(strlen($_POST['userTel']) > 15) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_INVALID_SIZ E_PHONE."</div>";
    else {
    if($this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.MEMB_INFO SET memb_name = '". $_POST['userName'] ."', tel__numb = '". $_POST['userTel'] ."' WHERE memb___id='". $_SESSION['LOGIN'] ."'"))
    {
    $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_SUCCESS_ALT ER."</div>";
    $this->writeLog(1, $_SESSION['LOGIN'], "", "");
    }
    else
    $tempRepost .= "<div class='qdestaques'>".LDPU_MODIFY_DATA_ERROR_ALTER. "</div>";
    }
    break;
    case 2:
    $Search_data_q = $this->query("SELECT fpas_answ FROM ".DATABASE_ACCOUNTS.".dbo.MEMB_INFO WHERE memb___id='". $_SESSION['LOGIN'] ."'");
    $Search_data_q = mssql_fetch_object($Search_data_q);
    $checkPwdQ = $this->query('exec dbo.webVerifyLogin "'. $_SESSION['LOGIN'] .'","'. $_POST['userPwd'] .'","'. USE_MD5 .'"');
    $checkPwd = mssql_fetch_row($checkPwdQ);
    if(empty($_POST['userPwd']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_FILL_PASSWO RD."</div>";
    elseif(empty($_POST['userPwdNew']) == true || empty($_POST['userPwdNewRe']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_FILL_NEW_PA SSWORD."</div>";
    elseif(empty($_POST['userAnswer']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_FILL_SECRET _ANSWER."</div>";
    elseif(strlen($_POST['userPwdNew']) > 10 || strlen($_POST['userPwdNewRe']) > 10) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_INVALID_SIZ E_PASSWORD."</div>";
    elseif($_POST['userPwdNew'] <> $_POST['userPwdNewRe']) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_PASSWORDS_M UST_BE_IDENTICAL."</div>";
    elseif($_POST['userAnswer'] <> $Search_data_q->fpas_answ) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_INVALID_SEC RET_ANSWER."</div>";
    elseif($checkPwd[0] == 0) $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_INVALID_PAS SWORD."</div>";
    else {
    if(USE_MD5 == false) $result = $this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.MEMB_INFO SET memb__pwd = '". $_POST['userPwdNew'] ."' WHERE memb___id='". $_SESSION['LOGIN'] ."'");
    if(USE_MD5 == true) $result = $this->query("exec dbo.webPwdHashWrite '". $_SESSION['LOGIN'] ."', '". $_POST['userPwdNew'] ."'");
    if($result)
    {
    $tempRepost .= "<div class='qdestaques2'>".LDPU_MODIFY_DATA_SUCCESS_ALT ER."</div>";
    $this->writeLog(1, $_SESSION['LOGIN'], "", LDPU_MODIFY_DATA_LOG_PASSWORD_ALTER);
    }
    else
    $tempRepost .= "<div class='qdestaques'>".LDPU_MODIFY_DATA_ERROR_ALTER. ".</div>";
    }
    break;
    }
    $ldTpl->set("RespostWrite", $tempRepost);

    $SQL_Q = $this->query("SELECT tel__numb,mail_addr,fpas_ques FROM ".DATABASE_ACCOUNTS.".dbo.MEMB_INFO WHERE memb___id='". $_SESSION['LOGIN'] ."'");
    $SQL = mssql_fetch_object($SQL_Q);
    $ldTpl->set("TEL__NUMB", $SQL->tel__numb);
    $ldTpl->set("MAIL_ADDR", $SQL->mail_addr);
    $ldTpl->set("USER_FQUEST", $SQL->fpas_ques);
    }
    private function loadOptionsCleanVault()
    {
    global $ldTpl;
    if($_GET['Write'] == true)
    {
    $vault_check = $this->query("SELECT 1 FROM ".DATABASE_ACCOUNTS.".dbo.warehouse WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    $vault_check = mssql_num_rows($vault_check);
    if($vault_check == 0) $tempRepost .= "<div class='quadros'><strong>".LDPU_CLEAN_VAULT_NOT_HAV E_VAULT."</strong></div>";
    else
    {
    $checkPwdQ = $this->query('exec dbo.webVerifyLogin "'. $_SESSION['LOGIN'] .'","'. $_POST['Pwd'] .'","'. USE_MD5 .'"');
    $checkPwd = mssql_fetch_row($checkPwdQ);
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(empty($_POST['Pwd']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_CLEAN_VAULT_FILL_PASSWO RD."</div>";
    elseif($_POST['Vault1'] == 0 && $_POST['Vault2'] == 0 && $_POST['Zen'] == 0) $tempRepost .= "<div class='qdestaques2'>".LDPU_CLEAN_VAULT_CHOOSE_TASK ."</div>";
    elseif($checkPwd[0] == 0) $tempRepost .= "<div class='qdestaques2'>".LDPU_CLEAN_VAULT_INVALID_PAS SWORD."</div>";
    else {
    switch(VESION_MUSERVER)
    {
    case 0: case 1:
    $number_multiply = 2400; break;
    case 2: case 3: case 4: case 5:
    $number_multiply = 3840; break;
    case 6:
    $number_multiply = 7680; break;
    }
    $tempRepost .= "<div class='qdestaques2'>";
    if ($_POST['Vault1'] == 1) {
    $hex_empty = str_pad($hex_empty, $number_multiply, "F");
    $this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.warehouse SET Items=0x$hex_empty WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    $this->writeLog(2, $_SESSION['LOGIN'], "", LDPU_CLEAN_VAULT_1_LOG_SUCCESS);
    $tempRepost .= LDPU_CLEAN_VAULT_1_TEXT_SUCCESS."<br/>";
    }
    if ($_POST['Vault2'] == 1) {
    $hex_empty = str_pad($hex_empty, $number_multiply, "F");
    $this->writeLog(2, $_SESSION['LOGIN'], "", LDPU_CLEAN_VAULT_2_LOG_SUCCESS);
    $this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.warehouse SET Items2=0x$hex_empty WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    $tempRepost .= LDPU_CLEAN_VAULT_2_TEXT_SUCCESS."<br/>";
    }
    if ($_POST['Zen'] == 1) {
    $this->writeLog(2, $_SESSION['LOGIN'], "", LDPU_CLEAN_VAULT_ZEN_LOG_SUCCESS);
    $this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.warehouse SET Money=0 WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    $tempRepost .= LDPU_CLEAN_VAULT_ZEN_TEXT_SUCCESS;
    }
    $tempRepost .= "</div>";
    $this->query("EXEC [dbo].[webPanelAction_CleanVault] '". $_SESSION['LOGIN'] ."', ''");
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function questionsEventCheck()
    {
    global $ldTpl, $GAME_QUESTION;
    $responseFinal = NULL;

    if($GAME_QUESTION['ENABLE'] == false) { $ldTpl->set("questionResponse","<!-- disabled event -->"); return false; }
    if($_SESSION['GAME_QUESTION_LAST_LUCK'] > time()) { $ldTpl->set("questionResponse","<!-- wait time -->"); return false; }
    //if($_SESSION['GAME_QUESTION_ENABLE'] == true) { $ldTpl->set("questionResponse","<!-- you have one opened answer -->"); return false; }
    $luckNow = rand($GAME_QUESTION['LUCK'][0], $GAME_QUESTION['LUCK'][1]);
    if($luckNow >= $GAME_QUESTION['LUCK'][2])
    {
    $questionQ = $this->query("SELECT TOP 1 [number],[question],[answer1],[answer2],[answer3],[answer4] FROM [dbo].[webQuestions] ORDER BY NEWID()");
    if(mssql_num_rows($questionQ) == 0)
    {
    $ldTpl->set("questionResponse","<!-- empty table -->");
    return false; // jogo interrompido por nao ter perguntas na tabela
    }
    $question = mssql_fetch_object($questionQ);

    $responseFinal = "<div id="stringQuestion">".$question->question."</div>
    <div id="stringsAnswer">
    <input type="hidden" value="0" name="answerFinal" id="answerFinal" />
    <input type="radio" name="asnwer" id="asnwer" value="1" onclick="jQuery('#answerFinal').val(1);" /> ".$question->answer1."<br />
    <input type="radio" name="asnwer" id="asnwer" value="2" onclick="jQuery('#answerFinal').val(2);" /> ".$question->answer2."<br />
    <input type="radio" name="asnwer" id="asnwer" value="3" onclick="jQuery('#answerFinal').val(3);" /> ".$question->answer3."<br />
    <input type="radio" name="asnwer" id="asnwer" value="4" onclick="jQuery('#answerFinal').val(4);" /> ".$question->answer4."<br />
    </div>
    <div id="buttonSubmit"><input type="button" value="".LDPU_QUESTION_EVENT_INPUT_RESPONSE."" onclick="javascript: Verify ('?page=paneluser&option=QUESTIONS_EVENT&answer='+ jQuery('#answerFinal').val(), 'reponseSubmit', 'get');"></div>
    <script type="text/javascript">
    jQuery(document).ready(function(){
    jQuery("#questionsEvent").css("display", "block");
    jQuery.fancybox({content: jQuery("#questionsEvent") });
    interval = setInterval("timerDecrement();", 1000);
    });
    </script>";

    $_SESSION['GAME_QUESTION_ENABLE'] = true;
    $_SESSION['GAME_QUESTION_LAST_LUCK'] = ( time() + $GAME_QUESTION['WAIT'] );
    $_SESSION['GAME_QUESTION_NUMBER'] = $question->number;
    $_SESSION['GAME_QUESTION_TIME'] = time()+60;
    }

    $ldTpl->set("questionResponse", $responseFinal);
    }
    private function loadOptionsQuestionsEvent()
    {
    global $ldTpl, $GAME_QUESTION;
    $responseFinal = NULL;

    if($GAME_QUESTION['ENABLE'] == false) { return false; }
    if($_SESSION['GAME_QUESTION_ENABLE'] == false)
    {
    echo "<p class="incorrectResponse">".LDPU_QUESTION_EVENT_AL READY_ANSWERED."</p>";
    return false;
    }

    if($_GET['answer'] == 0)
    {
    echo "<p class="incorrectResponse">".LDPU_QUESTION_EVENT_SE LECT_ANSWER."</p>";
    return false;
    }

    $_SESSION['GAME_QUESTION_ENABLE'] = false; //libera o sistema para novas perguntas

    if($_SESSION['GAME_QUESTION_TIME'] < time())
    {
    echo "<p class="incorrectResponse">".LDPU_QUESTION_EVENT_TI ME_END."</p>";
    return false;
    }

    $questionQ = $this->query("SELECT TOP 1 [number],[question],[answer1],[answer2],[answer3],[answer4],[correct],[type],[drawn],[matter] FROM [dbo].[webQuestions] WHERE [number] = '".(int)$_SESSION['GAME_QUESTION_NUMBER']."'");
    $question = mssql_fetch_object($questionQ);

    if($_GET['answer'] == $question->correct)
    {

    require_once("ldItemClass/ldItemDatabase.class.php");

    // Gerar / Carregar banco de dados
    ldItemDatabase::setDatabases("modules/", "item.txt", "classes/ldItemClass/data/item.serialize.txt");
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    ldItemDatabase::createDatabase();
    }
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    exit(LDPU_VIRTUAL_VAULT_CANT_LOAD_DB);
    }

    switch($question->type)
    {
    case "A":
    shuffle($GAME_QUESTION['PREMIUM']["A"]);
    $itemPremium = $GAME_QUESTION['PREMIUM']["A"][0];
    break;
    case "B":
    shuffle($GAME_QUESTION['PREMIUM']["B"]);
    $itemPremium = $GAME_QUESTION['PREMIUM']["B"][0];
    break;
    case "C":
    shuffle($GAME_QUESTION['PREMIUM']["C"]);
    $itemPremium = $GAME_QUESTION['PREMIUM']["C"][0];
    break;
    case "D":
    shuffle($GAME_QUESTION['PREMIUM']["D"]);
    $itemPremium = $GAME_QUESTION['PREMIUM']["D"][0];
    break;
    default:
    shuffle($GAME_QUESTION['PREMIUM']["A"]);
    $itemPremium = $GAME_QUESTION['PREMIUM']["A"][0];
    break;
    }

    $serialFinal = $this->createSerial();

    $this->query("INSERT INTO [dbo].[webGoldenArcher] ([username],[pserial1],[pserial2],[pserial3],[status],[itemCategorie],[itemIndex],[itemLevel],[itemOption],[itemSkill],[itemLuck],[excellent1],[excellent2],[excellent3],[excellent4],[excellent5],[excellent6],[ancient],[refine],[harmonyType],[harmonyLevel],[socketOp1],[socketOp2],[socketOp3],[socketOp4],[socketOp5])
    VALUES
    ('".$_SESSION['LOGIN']."'
    ,'".$serialFinal[0]."'
    ,'".$serialFinal[1]."'
    ,'".$serialFinal[2]."'
    ,0
    ,". (int)$itemPremium['idCategorie'] ."
    ,". (int)$itemPremium['idItem'] ."
    ,". (int)$itemPremium['options']['Level'] ."
    ,". (int)$itemPremium['options']['Option'] ."
    ,". (int)$itemPremium['options']['Skill'] ."
    ,". (int)$itemPremium['options']['Luck'] ."
    ,". (int)$itemPremium['options']['Excellent'][0] ."
    ,". (int)$itemPremium['options']['Excellent'][1] ."
    ,". (int)$itemPremium['options']['Excellent'][2] ."
    ,". (int)$itemPremium['options']['Excellent'][3] ."
    ,". (int)$itemPremium['options']['Excellent'][4] ."
    ,". (int)$itemPremium['options']['Excellent'][5] ."
    ,". (int)$itemPremium['options']['Ancient'] ."
    ,". (int)$itemPremium['options']['Refine'] ."
    ,". (int)$itemPremium['options']['HarmonyType'] ."
    ,". (int)$itemPremium['options']['HarmonyLevel'] ."
    ,". (int)$itemPremium['options']['SocketOption'][0] ."
    ,". (int)$itemPremium['options']['SocketOption'][1] ."
    ,". (int)$itemPremium['options']['SocketOption'][2] ."
    ,". (int)$itemPremium['options']['SocketOption'][3] ."
    ,". (int)$itemPremium['options']['SocketOption'][4] .")");

    echo "<p class="correctResponse">".LDPU_QUESTION_EVENT_RESP ONSE_CORRECT."</p>";
    echo "<p>&nbsp;</p>";
    printf("<p>".LDPU_QUESTION_EVENT_RESPONSE_CORRECT_ RECEIVER_ITEM."</p>", utf8_encode(ldItemDatabase::$dbItem[ $itemPremium['idCategorie'] ][ $itemPremium['idItem'] ]["Name"]));
    echo "<p>&nbsp;</p>";
    echo "<p class="serial">".$serialFinal[0]."-".$serialFinal[1]."-".$serialFinal[2]."</p>";
    }
    else
    {
    echo "<p class="incorrectResponse">".LDPU_QUESTION_EVENT_RE SPONSE_INCORRECT."</p>";
    }
    echo "<script> jQuery('#timerString').css("display", "none"); </script>";
    }
    private function createHashSerial()
    {
    return strtoupper(substr(md5(rand(0,10000)),0,4));
    }
    private function checkExistHash()
    {
    $checkExistsQ = $this->query("SELECT 1 FROM [dbo].[webGoldenArcher] WHERE [pserial1] = '". $this->SerialPart1 ."' AND [pserial2] = '". $this->SerialPart2 ."' AND [pserial3] = '". $this->SerialPart3 ."'");
    return mssql_num_rows($checkExistsQ);
    }
    private function createSerial()
    {
    $cond = 1;
    while($cond <> 0)
    {
    $this->SerialPart1 = $this->createHashSerial();

    $this->SerialPart2 = $this->createHashSerial();

    $this->SerialPart3 = $this->createHashSerial();

    $cond = $this->checkExistHash();
    }
    return array($this->SerialPart1, $this->SerialPart2, $this->SerialPart3);
    }
    private function loadOptionsGoldenArcher()
    {
    if($_GET['action'] == "check")
    {
    try
    {
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1)
    throw new Exception(LDPU_YOU_MUST_BE_OFFLINE, 1);

    if(empty($_GET['serial']) == true)
    throw new Exception(LDPU_GOLDEN_ARCHER_FILL_SERIAL, 1);

    $this->serial = $_GET['serial'];
    $this->serial = str_replace("-", "", $this->serial);
    if(strlen($this->serial) != 12)
    throw new Exception(LDPU_GOLDEN_ARCHER_INVALID_SERIAL, 1);

    $this->serial = array( substr($this->serial, 0, 4), substr($this->serial, 4, 4), substr($this->serial, 8, 4) );

    $itemSerial = $this->query("SELECT [id],[username],[status],[itemCategorie],[itemIndex],[itemLevel],[itemOption],[itemSkill],[itemLuck],[excellent1],[excellent2],[excellent3],[excellent4],[excellent5],[excellent6],[ancient],[refine],[harmonyType],[harmonyLevel],[socketOp1],[socketOp2],[socketOp3],[socketOp4],[socketOp5] FROM [dbo].[webGoldenArcher] WHERE [pserial1] = '".$this->serial[0]."' AND [pserial2] = '".$this->serial[1]."' AND [pserial3] = '".$this->serial[2]."'");
    if(mssql_num_rows($itemSerial) == 0)
    throw new Exception(LDPU_GOLDEN_ARCHER_INVALID_SERIAL, 1);

    $itemSerial = mssql_fetch_object($itemSerial);
    if($itemSerial->username != $_SESSION['LOGIN'])
    throw new Exception(LDPU_GOLDEN_ARCHER_SERIAL_NOT_BELONG, 1);

    if($itemSerial->status == 1)
    throw new Exception(LDPU_GOLDEN_ARCHER_SERIAL_IS_ACTIVE, 1);

    require_once("ldItemClass/ldItemDatabase.class.php");
    require_once("ldItemClass/ldItemMake.class.php");
    require_once("ldItemClass/ldItemParse.class.php");
    require_once("ldItemClass/ldVault.class.php");

    // Gerar / Carregar banco de dados
    ldItemDatabase::setDatabases("modules/", "item.txt", "classes/ldItemClass/data/item.serialize.txt");
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    ldItemDatabase::createDatabase();
    }
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    exit(LDPU_VIRTUAL_VAULT_CANT_LOAD_DB);
    }

    if(isset(ldItemDatabase::$dbItem[ $itemSerial->itemCategorie ][ $itemSerial->itemIndex ]) == false)
    throw new Exception(LDPU_GOLDEN_ARCHER_ITEM_NOT_EXISTS, 1);

    $dbVersion = $this->query("SELECT [DbVersion] FROM [".DATABASE_CHARACTERS."].[dbo].[warehouse] WHERE [AccountId] = '". $_SESSION['LOGIN'] ."'");
    if(mssql_num_rows($dbVersion) == 0)
    throw new Exception(LDPU_GOLDEN_ARCHER_ACCOUNT_NOT_VAULT, 1);
    $dbVersion = mssql_fetch_object($dbVersion)->DbVersion;

    $HexItem = NULL;
    $optionsItem = array("Level" => $itemSerial->itemLevel, "Option" => $itemSerial->itemOption, "Skill" => $itemSerial->itemSkill, "Luck" => $itemSerial->itemLuck, "Serial" => true, "Excellent" => array($itemSerial->excellent1, $itemSerial->excellent2, $itemSerial->excellent3, $itemSerial->excellent4, $itemSerial->excellent5, $itemSerial->excellent6), "Ancient" => $itemSerial->ancient, "Refine" => $itemSerial->refine, "HarmonyType" => $itemSerial->harmonyType, "HarmonyLevel" => $itemSerial->harmonyLevel, "SocketOption" => array($itemSerial->socketOp1, $itemSerial->socketOp2, $itemSerial->socketOp3, $itemSerial->socketOp4, $itemSerial->socketOp5));
    if(ldItemMake::makeHexItem($HexItem, $itemSerial->itemIndex, $itemSerial->itemCategorie, $dbVersion, $optionsItem) == true)
    {
    $ldVault = new ldVault($_SESSION['LOGIN'], $dbVersion);
    $ldVault->getVault();
    $ldVault->cutCode();
    $ldVault->structureVault();

    ldItemParse:arseHexItem($HexItem, $dbVersion);
    $slot = $ldVault->searchSlotsInVault(ldItemParse::$dumpTemp['Item']['X'], ldItemParse::$dumpTemp['Item']['Y']);
    if($slot != -1)
    $ldVault->insertItemInSlot($HexItem, $slot);
    else
    throw new Exception(LDPU_GOLDEN_ARCHER_VAULT_NOT_SPACE, 1);

    $ldVault->structureVault();
    $ldVault->writeVault(true);
    unset($ldVault);
    }
    else
    throw new Exception(LDPU_GOLDEN_ARCHER_ERROR_MAKE_ITEM, 1);

    unset($HexItem);

    $updateStatus = $this->query("UPDATE [dbo].[webGoldenArcher] SET [status] = 1 WHERE [id] = '".$itemSerial->id."'");

    throw new Exception(ldItemDatabase::$dbItem[ $itemSerial->itemCategorie ][ $itemSerial->itemIndex ]["Name"], 0);
    }
    catch(Exception $e)
    {
    switch($e->getCode())
    {
    case 1: echo "<p class="white">".$e->getMessage()."</p>"; break;
    case 0: echo "<p class="yellow">".LDPU_GOLDEN_ARCHER_REGISTER_SUCCE SS."</p><p class="yellow">".LDPU_GOLDEN_ARCHER_ITEM_RECEIVER. ": ".$e->getMessage()."</p>"; break;
    }
    }
    exit();
    }
    }
    private function loadOptionsCollectorPoints()
    {
    global $ldTpl, $PANELUSER_MODULE, $TABLES_CONFIGS;
    $responseWrite = NULL;

    require_once("ldItemClass/ldItemDatabase.class.php");
    require_once("ldItemClass/ldItemOptionsDatabase.class.php");
    require_once("ldItemClass/ldItemMake.class.php");
    require_once("ldItemClass/ldItemParse.class.php");
    require_once("ldItemClass/ldVault.class.php");
    require_once("ldItemClass/ldInventory.class.php");
    ldItemDatabase::setDatabases("modules/", "item.txt", "classes/ldItemClass/data/item.serialize.txt");
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    ldItemDatabase::createDatabase();
    }
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    exit(LDPU_VIRTUAL_VAULT_CANT_LOAD_DB);
    }

    $ldTpl->set("POINTS_PER_ITEM", $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['premiumInPoints'] );
    $ldTpl->set("ITEM_NAME", ldItemDatabase::$dbItem[ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idCategorie'] ][ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idItem'] ]["Name"] );

    if($_GET['action'] == "collect")
    {
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1)
    {
    $responseWrite = "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    return false;
    }

    $itemsCollects = 0;
    $this->ldVault = new ldVault($_SESSION['LOGIN']);
    $this->ldVault->getVault();
    $this->ldVault->cutCode();
    $this->ldVault->structureVault();
    for($i = 0; $i < 120; $i++)
    {
    $shortcut = $this->ldVault->codeGroup[$i];
    if($shortcut['Details']['IsItem'] == false) continue;

    if($shortcut['Details']['ItemIdIndex'] == $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idItem'] && $shortcut['Details']["ItemIdSection"] == $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idCategorie'])
    {
    $itemsCollects++;
    $this->ldVault->insertItemInSlot( ($this->ldVault->dbVersion > 2 ? str_repeat("F", 32) : str_repeat("F", 20)) , $i);
    }
    }
    if($itemsCollects > 0)
    {
    $pointsToAdd = $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['premiumInPoints'] * $itemsCollects;

    $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." SET ".$TABLES_CONFIGS['WEBCASH']['columnPoints']."=".$TABLES_CONFIGS['WEBCASH']['columnPoints']."+". $pointsToAdd ." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='". $_SESSION['LOGIN'] ."'");

    $this->ldVault->writeVault(true);

    $responseWrite = sprintf("<div class="qdestaques2">".LDPU_COLLECTOR_POINTS_SUCCES S."</div>", $itemsCollects, ldItemDatabase::$dbItem[ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idCategorie'] ][ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idItem'] ]["Name"], $pointsToAdd);

    $this->writeLog(18, $_SESSION['LOGIN'], "", sprintf(LDPU_COLLECTOR_POINTS_SUCCESS_LOG, $itemsCollects, ldItemDatabase::$dbItem[ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idCategorie'] ][ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idItem'] ]["Name"], $pointsToAdd));
    }
    else
    {
    $responseWrite = sprintf("<div class="qdestaques">".LDPU_COLLECTOR_POINTS_ERROR." </div>", ldItemDatabase::$dbItem[ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idCategorie'] ][ $PANELUSER_MODULE['COLLECTOR_POINTS']['REQUIRE']['idItem'] ]["Name"]);
    }

    }

    $ldTpl->set("RESPONSE_WRITE", $responseWrite );
    }
    private function loadOptionsAuctions()
    {
    global $ldTpl, $TABLES_CONFIGS;

    $RespostWrite = NULL;

    if($_GET['action'] == "showDetailsAuction")
    {
    $getAuctions = $this->query("SELECT [id],[name],[premium],[startDate],[endDate],[active],[minimumBid],[closed],[winner],[winnerText] FROM [dbo].[webAuctions] WHERE [active] = 1 AND [id] = ".(int) $_GET['id']." ORDER BY [id] DESC");
    if(mssql_num_rows($getAuctions) == 0)
    {
    $RespostWrite = "<table style='width: 100%;'>".
    "<tr><td style='text-align: center;' colspan='4'>".LDPU_AUCTIONS_NOT_FOUND."</td></tr>".
    "</table>";
    }
    else
    {
    $getAuctions = mssql_fetch_object($getAuctions);

    if($getAuctions->closed == 1) $status = LDPU_AUCTIONS_STATUS_END;
    elseif($getAuctions->startDate > time()) $status = LDPU_AUCTIONS_STATUS_WAIT_BEGIN;
    elseif($getAuctions->startDate < time() && $getAuctions->endDate > time()) $status = LDPU_AUCTIONS_STATUS_IN_PROGRESS;
    elseif($getAuctions->endDate < time()) $status = LDPU_AUCTIONS_STATUS_WAIT_PREMIUM;
    else $status = "Status desconhecido.";

    $searchLastBid = $this->query("SELECT TOP 1 [username],[amount],CONVERT(varchar, [lastBid], 103) [lastBidDay],CONVERT(varchar, [lastBid], 108) [lastBidHour] FROM [dbo].[webAuctionsBids] WHERE [auction] = ". (int) $getAuctions->id ." ORDER BY [amount] DESC");
    if(mssql_num_rows($searchLastBid) == 0)
    {
    $lastUserBid = LDPU_AUCTIONS_TAKE_FRIST_BID;
    $lastValueBid = $getAuctions->minimumBid;
    }
    else
    {
    $searchLastBid = mssql_fetch_object($searchLastBid);
    $lastUserBid = $searchLastBid->username.", ".$searchLastBid->lastBidDay." ".$searchLastBid->lastBidHour;
    $lastValueBid = $searchLastBid->amount;
    }

    $findAccountPointsQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnPoints']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountPoints = mssql_fetch_object($findAccountPointsQ);

    $searchIfHaveBid = $this->query("SELECT [amount] FROM [dbo].[webAuctionsBids] WHERE [auction] = ". (int) $getAuctions->id ." AND [username] = '".$_SESSION['LOGIN']."'");


    $RespostWrite = "<table style='width: 100%;'>".
    "<tr><td style='width: 150px;'>".LDPU_AUCTIONS_ID.":</td><td><strong>{$getAuctions->id}</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_NAME.":</td><td><strong>{$getAuctions->name}</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_STATUS.":</td><td><strong>{$status}</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_DATE_BEGIN.":</td><td><strong>".date("d/m/Y G:i:s", $getAuctions->startDate)."</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_DATE_END.":</td><td><strong>".date("d/m/Y G:i:s", $getAuctions->endDate)."</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_MIN_BID.":</td><td><strong>{$getAuctions->minimumBid} ".constant("POINTS_NAME")."</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_PREMIUM.":</td><td><strong>{$getAuctions->premium}</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_PHOTO.":</td><td><a href="modules/uploads/auctions/{$getAuctions->id}.large.jpg" id="photoLarge_{$getAuctions->id}">
    <img src='modules/uploads/auctions/{$getAuctions->id}.small.jpg' /></a>
    <script> jQuery("a#photoLarge_{$getAuctions->id}").fancybox();</script></td></tr>".
    "</table>".
    "<br/>".
    "<table style='width: 100%;'>".
    "<tr><td style='width: 150px;'>".LDPU_AUCTIONS_LAST_PUT_BID."</td><td><strong>{$lastUserBid}</strong> - <a href='?page=paneluser&option=AUCTIONS&action=showD etailsAuction&id={$getAuctions->id}'>[".LDPU_AUCTIONS_REFRESH."]</a></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_AUCTION_VALUE.":</td><td><strong>{$lastValueBid} ".constant("POINTS_NAME")."</strong></td></tr>".
    "<tr><td>".LDPU_AUCTIONS_YOUR_LAST_BID.":</td><td><strong>".(int) mssql_fetch_object($searchIfHaveBid)->amount." ".constant("POINTS_NAME")."</strong></td></tr>".
    "<tr>
    <td>".LDPU_AUCTIONS_PUT_TOUR_BID.":</td>
    <td>
    <input type='text' class='inputbox' value='".($lastValueBid+1)."' style='width: 50px;' id='valueToBid'>&nbsp;
    <input type='button' class='button' value='".LDPU_AUCTIONS_INTPUT_PUT_BID."' onclick="window.location = '?page=paneluser&option=AUCTIONS&action=bid&id={$g etAuctions->id}&points='+jQuery('#valueToBid').val()" />&nbsp;
    (".LDPU_AUCTIONS_YOU_HAVE.": {$findAccountPoints->amount} ".constant("POINTS_NAME").")</td></tr>".
    "</table>";

    if($getAuctions->winner == $_SESSION['LOGIN'])
    {
    $RespostWrite .= "<table style='width: 100%; text-align: center;'>".
    "<tr><td style='padding: 20px;'><strong>".LDPU_AUCTIONS_YOU_WINNER."<br /><br />{$getAuctions->winnerText}</strong></td></tr>".
    "</table>";
    }
    }
    }
    elseif($_GET['action'] == "bid")
    {
    try
    {
    if(is_numeric($_GET['points']) == false || $_GET['points'] <= 0)
    throw new Exception(sprintf(LDPU_AUCTIONS_FILL_NUMBER_POSITI VE, constant("POINTS_NAME")), 1);

    if(is_numeric($_GET['id']) == false)
    throw new Exception(LDPU_AUCTIONS_INVALID_AUCTION, 1);

    $getAuctions = $this->query("SELECT [id],[startDate],[endDate],[active],[minimumBid],[closed] FROM [dbo].[webAuctions] WHERE [active] = 1 AND [id] = ".(int) $_GET['id']." ORDER BY [id] DESC");
    if(mssql_num_rows($getAuctions) == 0)
    throw new Exception(LDPU_AUCTIONS_INVALID_AUCTION_OR_NOT_ACT IVE, 1);

    $getAuctions = mssql_fetch_object($getAuctions);
    if($getAuctions->closed == 1) throw new Exception(LDPU_AUCTIONS_STATUS_END, 1);
    elseif($getAuctions->startDate > time()) throw new Exception(LDPU_AUCTIONS_STATUS_WAIT_BEGIN, 1);
    elseif($getAuctions->endDate < time()) throw new Exception(LDPU_AUCTIONS_STATUS_WAIT_PREMIUM, 1);

    if($getAuctions->minimumBid > $_GET['points'])
    throw new Exception(LDPU_AUCTIONS_YOU_NEED_BID_MORE." ".$getAuctions->minimumBid.".", 1);

    $searchLastBid = $this->query("SELECT TOP 1 [amount] FROM [dbo].[webAuctionsBids] WHERE [auction] = ". (int) $getAuctions->id ." ORDER BY [amount] DESC");
    if(mssql_num_rows($searchLastBid) > 0)
    {
    $searchLastBid = mssql_fetch_object($searchLastBid);
    if($searchLastBid->amount >= $_GET['points'])
    throw new Exception(LDPU_AUCTIONS_YOU_NEED_BID_MORE." ".$_GET['points'].".", 1);
    }

    $findAccountPointsQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnPoints']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findAccountPoints = mssql_fetch_object($findAccountPointsQ);
    if($findAccountPoints->amount < $_GET['points'])
    throw new Exception(LDPU_AUCTIONS_YOU_NOT_HAVE_POINTS." ".constant("POINTS_NAME").".", 1);
    /*
    $remove = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnPoints']."=".$TABLES_CONFIGS['WEBCASH']['columnPoints']."-".(int)$_GET['points']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."' AND ".$TABLES_CONFIGS['WEBCASH']['columnPoints']." > ".(int)$_GET['points'].";
    SELECT @@ROWCOUNT [count];");
    if(mssql_fetch_object($remove)->count == 0)
    throw new Exception("Voc� n�o possui essa quantidade de ".constant("POINTS_NAME").".", 1);
    */

    $searchIfHaveBid = $this->query("SELECT 1 FROM [dbo].[webAuctionsBids] WHERE [auction] = ". (int) $getAuctions->id ." AND [username] = '".$_SESSION['LOGIN']."'");
    if(mssql_num_rows($searchIfHaveBid) > 0)
    {
    $this->query("UPDATE [dbo].[webAuctionsBids] SET [amount] = ".(int)$_GET['points']." WHERE [auction] = ". (int) $getAuctions->id ." AND [username] = '".$_SESSION['LOGIN']."'");
    throw new Exception(LDPU_AUCTIONS_BID_SUCCESS_REGISTER, 0);
    }
    else
    {
    $this->query("INSERT INTO [dbo].[webAuctionsBids] ([auction],[amount],[username],[lastBid]) VALUES (".(int) $getAuctions->id.", ".(int) $_GET['points'].", '".$_SESSION['LOGIN']."', getDate());");
    throw new Exception(LDPU_AUCTIONS_BID_SUCCESS_REGISTER, 0);
    }

    }
    catch( Exception $e )
    {
    switch($e->getCode())
    {
    case 0:
    echo "<script>alert('".$e->getMessage()."'); window.location = '?page=paneluser&option=AUCTIONS&action=showDetail sAuction&id=".(int) $getAuctions->id."';</script>";
    break;
    case 1:
    echo "<script>alert('".$e->getMessage()."'); history.go(-1);</script>";
    break;
    }
    }
    exit();
    }
    else
    {
    $getAuctions = $this->query("SELECT [id],[name],[premium],[startDate],[endDate],[closed] FROM [dbo].[webAuctions] WHERE [active] = 1 ORDER BY [id] DESC");
    if(mssql_num_rows($getAuctions) == 0)
    {
    $RespostWrite = "<table style='width: 100%;'>".
    "<tr><td style='width: 27px;'>#</td><td>".LDPU_AUCTIONS_NAME."</td><td>".LDPU_AUCTIONS_PREMIUM."</td><td style='width: 100px;'>".LDPU_AUCTIONS_STATUS."</td></tr>".
    "<tr><td style='text-align: center;' colspan='4'>".LDPU_AUCTIONS_NOT_HAVE_AUCTIONS."</td></tr>".
    "</table>";
    }
    else
    {
    while($auction = mssql_fetch_object($getAuctions))
    {
    if($auction->closed == 1) $status = LDPU_AUCTIONS_STATUS_END;
    elseif($auction->startDate > time()) $status = LDPU_AUCTIONS_STATUS_WAIT_BEGIN;
    elseif($auction->startDate < time() && $auction->endDate > time()) $status = LDPU_AUCTIONS_STATUS_IN_PROGRESS;
    elseif($auction->endDate < time()) $status = LDPU_AUCTIONS_STATUS_WAIT_PREMIUM;
    else $status = LDPU_AUCTIONS_STATUS_ERROR;

    $tmpList .= "<tr>
    <td><a href='?page=paneluser&option=AUCTIONS&action=showD etailsAuction&id={$auction->id}'>{$auction->id}</a></td>
    <td><a href='?page=paneluser&option=AUCTIONS&action=showD etailsAuction&id={$auction->id}'>{$auction->name}</a></td>
    <td><a href='?page=paneluser&option=AUCTIONS&action=showD etailsAuction&id={$auction->id}'>".substr($auction->premium, 0, 40).(strlen($auction->premium) > 40 ? "..." : NULL)."</a></td>
    <td><a href='?page=paneluser&option=AUCTIONS&action=showD etailsAuction&id={$auction->id}'>{$status}</a></td>
    </tr>";

    }
    $RespostWrite = "<table style='width: 100%;'>".
    "<tr><td style='width: 27px;'>#</td><td>".LDPU_AUCTIONS_NAME."</td><td>".LDPU_AUCTIONS_PREMIUM."</td><td style='width: 150px;'>".LDPU_AUCTIONS_STATUS."</td></tr>".
    $tmpList.
    "</table>";
    }
    }
    $ldTpl->set("RespostWrite", $RespostWrite);
    }
    private function loadOptionsVirtualVault()
    {
    global $ldTpl, $VIRTUAL_VAULT;

    /**
    * Find serial query:
    * SELECT * FROM [MuOnline_DKT].[dbo].[ExtWareHouseVirtual] WHERE (CHARINDEX (0x375F9300, Item) = 4)
    */

    require_once("ldItemClass/ldItemDatabase.class.php");
    require_once("ldItemClass/ldItemOptionsDatabase.class.php");
    require_once("ldItemClass/ldItemMake.class.php");
    require_once("ldItemClass/ldItemParse.class.php");
    require_once("ldItemClass/ldVault.class.php");
    require_once("ldItemClass/ldInventory.class.php");
    ldItemDatabase::setDatabases("modules/", "item.txt", "classes/ldItemClass/data/item.serialize.txt");
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    ldItemDatabase::createDatabase();
    }
    if(ldItemDatabase::checkDatabaseExists() == false)
    {
    exit(LDPU_VIRTUAL_VAULT_CANT_LOAD_DB);
    }

    if($_GET['action'] == "details")
    {
    try
    {
    switch($_GET['vault'])
    {
    case "game":
    if($_GET['key'] < 0 || $_GET['key'] > 120)
    throw new Exception("loadOptionsVirtualVault() :: Invalid key");

    $this->ldVault = new ldVault($_SESSION['LOGIN']);
    $this->ldVault->getVault();
    $this->ldVault->cutCode();
    $this->ldVault->structureVault();
    $shortcut = $this->ldVault->codeGroup[$_GET['key']];
    if($shortcut['Details']['IsItem'] == false)
    throw new Exception(LDPU_VIRTUAL_VAULT_ITEM_NOT_FOUND);

    $response .= "<table style="width: 100%">";
    $response .= "<tr>";
    $response .= "<td>";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_ITEM.":</em> <strong>{$shortcut['Details']['ItemName']}</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_LEVEL.":</em> <strong>+{$shortcut['Details']['ItemLevel']}</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_OPTION.":</em> <strong>+".($shortcut['Details']['ItemOption']*4)."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_LUCK.":</em> <strong>".($shortcut['Details']['ItemLuck'] == true ? LDPU_YES : LDPU_NOT)."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_SKILL.":</em> <strong>".($shortcut['Details']['ItemSkill'] == true ? LDPU_YES : LDPU_NOT)."</strong><br />";
    if($this->ldVault->dbVersion > 1) $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_ANCIENT.":</em> <strong>".($shortcut['Details']['ItemAncient'] > 0 ? LDPU_YES : LDPU_NOT)."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_DURABILITY.":</em> <strong>".$shortcut['Details']['ItemDurability']."</strong><br />";
    if($VIRTUAL_VAULT['SHOW_SERIAL'] == true) $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_SERIAL.":</em> <strong>0x".$shortcut['Details']['ItemSerial']."</strong><br />";
    if($shortcut['Details']['ItemExcellents'][6] == 0)
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_EXCELLENT.":</em> <strong>".LDPU_NOT."</strong><br />";
    else
    {
    $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_EXCELLENT.":</em><strong><br />";
    if($shortcut['Details']['ItemExcellents'][0] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt0 ."</em><br />";
    if($shortcut['Details']['ItemExcellents'][1] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt1 ."</em><br />";
    if($shortcut['Details']['ItemExcellents'][2] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt2 ."</em><br />";
    if($shortcut['Details']['ItemExcellents'][3] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt3 ."</em><br />";
    if($shortcut['Details']['ItemExcellents'][4] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt4 ."</em><br />";
    if($shortcut['Details']['ItemExcellents'][5] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt5 ."</em><br />";
    $response .= "</strong>";
    }
    if($this->ldVault->dbVersion > 2) $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_REFINE.":</em> <strong>".($shortcut['Details']['ItemRefine'] > 0 ? ldItemOptionsDatabase::getRefine($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt0.", ".ldItemOptionsDatabase::getRefine($shortcut['Details']['ItemIdSection'], $shortcut['Details']['ItemIdIndex'])->opt1 : LDPU_NOT)."</strong><br />";
    if($this->ldVault->dbVersion > 2) $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_HARMONY.":</em> <strong>".($shortcut['Details']['HarmonyType'] > 0 ? ldItemOptionsDatabase::getHarmony($shortcut['Details']['ItemIdSection'], $shortcut['Details']['HarmonyType'], $shortcut['Details']['HarmonyLevel']) : LDPU_NOT)."</strong><br />";
    if($this->ldVault->dbVersion > 2 && $VIRTUAL_VAULT['SOCKET_OPTIONS'] == true)
    {
    $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_SOCKET.":</em><br />";
    $socketOptions = ldItemOptionsDatabase::getSocket();
    if($VIRTUAL_VAULT['MUSERVER_MANUFACTURER'] == 1)
    foreach( $shortcut['Details']['Sockect'] as &$socket )
    if($socket != $socketOptions["notSocket"] && $socket != $socketOptions["emptySocket"]) $socket++;

    if($shortcut['Details']['Sockect'][0] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 1: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif($shortcut['Details']['Sockect'][0] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 1: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 1: <strong>". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][0] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][0] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][0] % 0x32]["socketsArgs"][1]."</strong><br />";

    if($shortcut['Details']['Sockect'][1] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 2: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif($shortcut['Details']['Sockect'][1] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 2: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 2: <strong>". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][1] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][1] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][1] % 0x32]["socketsArgs"][2]."</strong><br />";

    if($shortcut['Details']['Sockect'][2] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 3: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif($shortcut['Details']['Sockect'][2] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 3: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 3: <strong>". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][2] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][2] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][2] % 0x32]["socketsArgs"][3]."</strong><br />";

    if($shortcut['Details']['Sockect'][3] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 4: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif($shortcut['Details']['Sockect'][3] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 4: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 4: <strong>". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][3] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][3] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][3] % 0x32]["socketsArgs"][4]."</strong><br />";

    if($shortcut['Details']['Sockect'][4] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 5: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif($shortcut['Details']['Sockect'][4] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 5: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 5: <strong>". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][4] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][4] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][$shortcut['Details']['Sockect'][4] % 0x32]["socketsArgs"][5]."</strong><br />";
    }
    $response .= "</td>";
    $response .= "<td align="right" valign="top">";
    $response .= "<input type="button" class="button" value="".LDPU_VIRTUAL_VAULT_TEXT_SEND_TO_VAULT_VIR TUAL."" onclick="jQuery.post('?page=paneluser&option=VIRTU AL_VAULT&action=send&to=virtual&key={$_GET['key']}', function(response) { jQuery('#detailsVault').html( response ); }, 'html');" />";
    $response .= "</td>";
    $response .= "</tr>";
    $response .= "</table>";
    break;
    case "virtual":
    if(is_numeric($_GET['key']) == false)
    throw new Exception("loadOptionsVirtualVault() :: Invalid key");

    $getItemQ = $this->query("SELECT [Number],[Item],[dbVersion] FROM [".DATABASE_ACCOUNTS."].[dbo].[ExtWareHouseVirtual] WHERE [AccountId] = '{$_SESSION['LOGIN']}' AND [Number] = ".(int)$_GET['key']);
    if(mssql_num_rows($getItemQ) == 0)
    throw new Exception(LDPU_VIRTUAL_VAULT_ITEM_NOT_FOUND);

    $getItem = mssql_fetch_object($getItemQ);

    ldItemParse:arseHexItem(bin2hex($getItem->Item), $getItem->dbVersion);

    $response .= "<table style="width: 100%">";
    $response .= "<tr>";
    $response .= "<td>";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_ITEM.":</em> <strong>".ldItemParse::$dumpTemp['ItemName']."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_LEVEL.":</em> <strong>+".ldItemParse::$dumpTemp['ItemLevel']."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_OPTION.":</em> <strong>+".(ldItemParse::$dumpTemp['ItemOption']*4)."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_LUCK.":</em> <strong>".(ldItemParse::$dumpTemp['ItemLuck'] == true ? LDPU_YES : LDPU_NOT)."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_SKILL.":</em> <strong>".(ldItemParse::$dumpTemp['ItemSkill'] == true ? LDPU_YES : LDPU_NOT)."</strong><br />";
    if($getItem->dbVersion > 1) $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_ANCIENT.":</em> <strong>".(ldItemParse::$dumpTemp['ItemAncient'] > 0 ? LDPU_YES : LDPU_NOT)."</strong><br />";
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_DURABILITY.":</em> <strong>".ldItemParse::$dumpTemp['ItemDurability']."</strong><br />";
    if($VIRTUAL_VAULT['SHOW_SERIAL'] == true) $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_SERIAL.":</em> <strong>0x".strtoupper(ldItemParse::$dumpTemp['ItemSerial'])."</strong><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][6] == 0)
    $response .= "<em>".LDPU_VIRTUAL_VAULT_TEXT_EXCELLENT.":</em> <strong>".LDPU_NOT."</strong><br />";
    else
    {
    $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_EXCELLENT.":</em><strong><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][0] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents(ldItemParse:: $dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt0 ."</em><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][1] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents(ldItemParse:: $dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt1 ."</em><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][2] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents(ldItemParse:: $dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt2 ."</em><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][3] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents(ldItemParse:: $dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt3 ."</em><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][4] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents(ldItemParse:: $dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt4 ."</em><br />";
    if(ldItemParse::$dumpTemp['ItemExcellents'][5] == true)
    $response .= "<em> - ". ldItemOptionsDatabase::getExcellents(ldItemParse:: $dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt5 ."</em><br />";
    $response .= "</strong>";
    }
    if($getItem->dbVersion > 2) $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_REFINE.":</em> <strong>".(ldItemParse::$dumpTemp['ItemRefine'] > 0 ? ldItemOptionsDatabase::getRefine(ldItemParse::$dum pTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt0." ,".ldItemOptionsDatabase::getRefine(ldItemParse::$ dumpTemp['ItemIdSection'], ldItemParse::$dumpTemp['ItemIdIndex'])->opt1 : LDPU_NOT)."</strong><br />";
    if($getItem->dbVersion > 2) $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_HARMONY.":</em> <strong>".(ldItemParse::$dumpTemp['HarmonyType'] > 0 ? ldItemOptionsDatabase::getHarmony(ldItemParse::$du mpTemp['ItemIdSection'], ldItemParse::$dumpTemp['HarmonyType'], ldItemParse::$dumpTemp['HarmonyLevel']) : LDPU_NOT)."</strong><br />";
    if($getItem->dbVersion > 2 && $VIRTUAL_VAULT['SOCKET_OPTIONS'] == true)
    {
    $response .= "<br /><em>".LDPU_VIRTUAL_VAULT_TEXT_SOCKET.":</em><br />";
    $socketOptions = ldItemOptionsDatabase::getSocket();
    if($VIRTUAL_VAULT['MUSERVER_MANUFACTURER'] == 1)
    foreach( ldItemParse::$dumpTemp['Sockect'] as &$socket )
    if($socket != $socketOptions["notSocket"] && $socket != $socketOptions["emptySocket"]) $socket++;

    if(ldItemParse::$dumpTemp['Sockect'][0] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 1: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif(ldItemParse::$dumpTemp['Sockect'][0] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 1: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 1: <strong>". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][0] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][0] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][0] % 0x32]["socketsArgs"][1]."</strong><br />";

    if(ldItemParse::$dumpTemp['Sockect'][1] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 2: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif(ldItemParse::$dumpTemp['Sockect'][1] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 2: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 2: <strong>". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][1] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][1] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][1] % 0x32]["socketsArgs"][2]."</strong><br />";

    if(ldItemParse::$dumpTemp['Sockect'][2] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 3: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif(ldItemParse::$dumpTemp['Sockect'][2] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 3: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 3: <strong>". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][2] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][2] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][2] % 0x32]["socketsArgs"][3]."</strong><br />";

    if(ldItemParse::$dumpTemp['Sockect'][3] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 4: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif(ldItemParse::$dumpTemp['Sockect'][3] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 4: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 4: <strong>". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][3] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][3] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][3] % 0x32]["socketsArgs"][4]."</strong><br />";

    if(ldItemParse::$dumpTemp['Sockect'][4] == $socketOptions["notSocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 5: ". $socketOptions["socketTypeNumber"][$socketOptions["notSocket"]]["socketName"] ."<br />";
    elseif(ldItemParse::$dumpTemp['Sockect'][4] == $socketOptions["emptySocket"])
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 5: ". $socketOptions["socketTypeNumber"][$socketOptions["emptySocket"]]["socketName"] ."<br />";
    else
    $response .= "<em> - ".LDPU_VIRTUAL_VAULT_TEXT_SOCKET_NAME." 5: <strong>". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][4] % 0x32]["socketTypeName"] .": ". $socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][4] % 0x32]["socketName"] ." + ".$socketOptions["socketTypeNumber"][ldItemParse::$dumpTemp['Sockect'][4] % 0x32]["socketsArgs"][5]."</strong><br />";
    }

    $response .= "</td>";
    $response .= "<td align="right" valign="top">";
    $response .= "<input type="button" class="button" value="".LDPU_VIRTUAL_VAULT_TEXT_SEND_TO_VAULT_GAM E."" onclick="jQuery.post('?page=paneluser&option=VIRTU AL_VAULT&action=send&to=game&key={$_GET['key']}', function(response) { jQuery('#detailsVault').html( response ); }, 'html');" /><br />";
    //$response .= "<input type="button" class="button" value="Anunciar item" onclick="jQuery.post('?page=paneluser&option=VIRTU AL_VAULT&action=sell&key={$_GET['key']}', function(response) { jQuery('#detailsVault').html( response ); }, 'html');" />";
    $response .= "</td>";
    $response .= "</tr>";
    $response .= "</table>";
    break;
    }
    throw new Exception($response);
    }
    catch(Exception $e)
    {
    exit($e->getMessage());
    }
    }
    elseif($_GET['action'] == "send")
    {
    try
    {
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1)
    throw new Exception("<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>");

    switch($_GET['to'])
    {
    case "virtual":
    if($_GET['key'] < 0 || $_GET['key'] > 120)
    throw new Exception("loadOptionsVirtualVault() :: Invalid key");

    $this->ldVault = new ldVault($_SESSION['LOGIN']);
    $this->ldVault->getVault();
    $this->ldVault->cutCode();
    $this->ldVault->structureVault();
    if($this->ldVault->codeGroup[$_GET['key']]['Details']['IsItem'] == false)
    throw new Exception(LDPU_VIRTUAL_VAULT_ITEM_NOT_FOUND);

    $insert = $this->query("INSERT INTO [".DATABASE_ACCOUNTS."].[dbo].[ExtWareHouseVirtual] ([AccountId] ,[Item], [dbVersion]) VALUES ('{$_SESSION['LOGIN']}', 0x{$this->ldVault->codeGroup[$_GET['key']]['Code']}, {$this->ldVault->dbVersion}); SELECT IDENT_CURRENT('[".DATABASE_ACCOUNTS."].[dbo].[ExtWareHouseVirtual]') as [Number];");
    if($insert == true)
    {
    $insert = mssql_fetch_object($insert);
    $insert = (int)$insert->Number;

    $jqueryTmp = "jQuery('#itemsVaultGame li#liItemVaultGame_{$_GET['key']}').fadeOut('slow', function() { jQuery(this).remove(); } );
    jQuery('#itemsVaultVirtual').fadeIn('slow').prepen d('<li id="liItemVaultVirtual_{$insert}" onclick="Verify(\'?page=paneluser&option=VIRTUAL_V AULT&action=details&vault=virtual&key={$insert}\', \'detailsVault\', \'get\');">{$this->ldVault->codeGroup[$_GET['key']]['Details']['ItemName']} +{$this->ldVault->codeGroup[$_GET['key']]['Details']['ItemLevel']} +".($this->ldVault->codeGroup[$_GET['key']]['Details']['ItemOption']*4)."</li>');";
    $this->ldVault->insertItemInSlot( ($this->ldVault->dbVersion > 2 ? str_repeat("F", 32) : str_repeat("F", 20)) , $_GET['key']);
    $this->ldVault->writeVault(true);
    throw new Exception("<script type="text/javascript">
    jQuery(document).ready(function(){
    {$jqueryTmp}
    });
    </script>");
    }
    else
    {
    throw new Exception(LDPU_VIRTUAL_VAULT_TEXT_SEND_ERROR);
    }
    break;
    case "game":
    if(is_numeric($_GET['key']) == false)
    throw new Exception("loadOptionsVirtualVault() :: Invalid key");

    $getItemQ = $this->query("SELECT [Number],[Item],[dbVersion] FROM [".DATABASE_ACCOUNTS."].[dbo].[ExtWareHouseVirtual] WHERE [AccountId] = '{$_SESSION['LOGIN']}' AND [Number] = ".(int)$_GET['key']);
    if(mssql_num_rows($getItemQ) == 0)
    throw new Exception(LDPU_VIRTUAL_VAULT_ITEM_NOT_FOUND);

    $getItem = mssql_fetch_object($getItemQ);

    $this->ldVault = new ldVault($_SESSION['LOGIN']);
    $this->ldVault->getVault();
    $this->ldVault->cutCode();
    $this->ldVault->structureVault();

    ldItemParse:arseHexItem(bin2hex($getItem->Item), $getItem->dbVersion);

    $slotFree = $this->ldVault->searchSlotsInVault(ldItemParse::$dumpTemp['Item']['X'], ldItemParse::$dumpTemp['Item']['Y']);

    if($slotFree > -1)
    {
    $this->ldVault->insertItemInSlot(bin2hex($getItem->Item), $slotFree);
    if($this->ldVault->writeVault(true) == true)
    {
    $this->query("DELETE FROM [".DATABASE_ACCOUNTS."].[dbo].[ExtWareHouseVirtual] WHERE [AccountId] = '{$_SESSION['LOGIN']}' AND [Number] = ".(int)$_GET['key']);
    throw new Exception("<script type="text/javascript">
    jQuery(document).ready(function(){
    jQuery('#liItemVaultVirtual_{$_GET['key']}').fadeOut('slow', function() { jQuery(this).remove(); } );
    jQuery('#itemsVaultGame').fadeIn('slow').prepend(' <li id="liItemVaultGame_{$slotFree}" onclick="Verify(\'?page=paneluser&option=VIRTUAL_V AULT&action=details&vault=game&key={$slotFree}\', \'detailsVault\', \'get\');">".ldItemParse::$dumpTemp['ItemName']." +".ldItemParse::$dumpTemp['ItemLevel']." +".(ldItemParse::$dumpTemp['ItemOption']*4)."</li>');
    });
    </script>");
    }
    }
    else
    {
    throw new Exception("<div class='qdestaques'>".LDPU_VIRTUAL_VAULT_TEXT_SEND_ ERROR_NO_SPACE."</div>");
    }
    break;
    }
    throw new Exception("");
    }
    catch(Exception $e)
    {
    exit($e->getMessage());
    }
    }
    else
    {
    $this->ldVault = new ldVault($_SESSION['LOGIN']);
    $this->ldVault->getVault();
    $this->ldVault->cutCode();
    $this->ldVault->structureVault();
    foreach($this->ldVault->codeGroup as $key => $item)
    {
    if($item['Details']['IsItem'] == true)
    {
    $liItemsVaultGame .= "<li id="liItemVaultGame_{$key}" onclick="Verify('?page=paneluser&option=VIRTUAL_VA ULT&action=details&vault=game&key={$key}', 'detailsVault', 'get');">{$item['Details']['ItemName']} +{$item['Details']['ItemLevel']} +".($item['Details']['ItemOption']*4)."</li>\n";
    }
    }

    $getVirtualVaultQ = $this->query("SELECT [Number],[Item],[dbVersion] FROM [".DATABASE_ACCOUNTS."].[dbo].[ExtWareHouseVirtual] WHERE [AccountId] = '{$_SESSION['LOGIN']}' ORDER BY [Number] DESC");
    while($getVirtualVault = mssql_fetch_object($getVirtualVaultQ))
    {
    ldItemParse:arseHexItem(bin2hex($getVirtualVault->Item), $getVirtualVault->dbVersion);
    $liItemsVaultVirtual .= "<li id="liItemVaultVirtual_{$getVirtualVault->Number}" onclick="Verify('?page=paneluser&option=VIRTUAL_VA ULT&action=details&vault=virtual&key={$getVirtualV ault->Number}', 'detailsVault', 'get');">".ldItemParse::$dumpTemp['ItemName']." +".ldItemParse::$dumpTemp['ItemLevel']." +".(ldItemParse::$dumpTemp['ItemOption']*4)."</li>\n";
    }

    }
    $ldTpl->set("liItemsVaultVirtual", $liItemsVaultVirtual);
    $ldTpl->set("liItemsVaultGame", $liItemsVaultGame);
    }
    private function loadOptionsDoubleVault()
    {
    global $ldTpl;
    if($_GET['Write'] == true)
    {
    $vault_check = $this->query("SELECT 1 FROM ".DATABASE_ACCOUNTS.".dbo.warehouse WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    $vault_check = mssql_num_rows($vault_check);
    if($vault_check == 0) $tempRepost .= "<div class='quadros'><strong>".LDPU_DOUBLE_VAULT_NOT_HA VE_VAULT."</strong></div>";
    else
    {
    $checkPwdQ = $this->query('exec dbo.webVerifyLogin "'. $_SESSION['LOGIN'] .'","'. $_POST['userPwd'] .'","'. USE_MD5 .'"');
    $checkPwd = mssql_fetch_row($checkPwdQ);
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(empty($_POST['userPwd']) == true) $tempRepost .= "<div class='qdestaques2'>".LDPU_DOUBLE_VAULT_FILL_PASSW ORD."</div>";
    elseif(strlen($_POST['userPwd']) > 10) $tempRepost .= "<div class='qdestaques2'>".LDPU_DOUBLE_VAULT_INVALID_SI ZE_PASSWORD."</div>";
    elseif($checkPwd[0] == 0) $tempRepost .= "<div class='qdestaques2'>".LDPU_DOUBLE_VAULT_INVALID_PA SSWORD."</div>";
    else {
    if($this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.warehouse SET items = items2, items2 = items WHERE AccountID='".$_SESSION['LOGIN']."'"))
    {
    $tempRepost .= "<div class='qdestaques2'>".LDPU_DOUBLE_VAULT_SUCCESS_AL TER."</div>";
    $this->writeLog(3, $_SESSION['LOGIN'], "", "");
    $this->query("EXEC [dbo].[webPanelAction_DoubleVault] '". $_SESSION['LOGIN'] ."', ''");
    }
    else
    $tempRepost .= "<div class='qdestaques'>".LDPU_DOUBLE_VAULT_ERROR_ALTER ."</div>";
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsTransferCash()
    {
    global $ldTpl, $TABLES_CONFIGS;
    try
    {
    if($_GET['action'] == "transfer")
    {
    if(empty($_POST['usernameDestine']) == true)
    throw new Exception(LDPU_TRANSFER_CASH_FILL_LOGIN_DESTINY, 2);

    if(is_numeric($_POST['amount']) == false || $_POST['amount'] < 1)
    throw new Exception(LDPU_TRANSFER_CASH_INVALID_AMOUNT, 2);

    if($_POST['typeCash'] != 1 && $_POST['typeCash'] != 2)
    throw new Exception(LDPU_TRANSFER_CASH_INVALID_TYPE, 2);

    if(mssql_num_rows($this->query("SELECT memb___id FROM ". DATABASE_ACCOUNTS .".dbo.MEMB_INFO WHERE memb___id='".$_POST['usernameDestine']."'")) == 0)
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_LOGIN_NOT_FOU ND, $_POST['usernameDestine']), 2);

    if($_POST['usernameDestine'] == $_SESSION['LOGIN'])
    throw new Exception(LDPU_TRANSFER_CASH_CANT_TRANSF_TO_YOU_LO GIN, 2);

    $checkPermission = $this->query("SELECT resale FROM ". DATABASE_ACCOUNTS .".dbo.MEMB_INFO WHERE memb___id='".$_SESSION['LOGIN']."'");
    if(mssql_fetch_object($checkPermission)->resale == 0)
    throw new Exception(LDPU_TRANSFER_CASH_NOT_HAVE_PREVILEGY, 2);


    switch((int)$_POST['typeCash'])
    {
    case 1:
    $findAmountCashQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnAmount']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");
    $findAmountCash = mssql_fetch_object($findAmountCashQ)->amount;
    if($findAmountCash < $_POST['amount'])
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_NOT_HAVE_THIS _AMOUNT, constant("CASH_NAME")), 2);

    $remove = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount']."-".$_POST['amount']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."' AND ".$TABLES_CONFIGS['WEBCASH']['columnAmount']." > ".$_POST['amount'].";
    SELECT @@ROWCOUNT [count];");
    if(mssql_fetch_object($remove)->count == 0)
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_NOT_HAVE_THIS _AMOUNT, constant("CASH_NAME")), 2);

    $insert = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount']."+".$_POST['amount']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_POST['usernameDestine']."';
    SELECT @@ROWCOUNT [count];");
    if(mssql_fetch_object($insert)->count == 0)
    {
    $remove = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount']."+".$_POST['amount']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");

    throw new Exception(sprintf(LDPU_TRANSFER_CASH_ERROR, constant("CASH_NAME")), 2);
    }
    $this->writeLog(17, $_SESSION['LOGIN'], "", sprintf(LDPU_TRANSFER_CASH_LOG_SUCCESS, $_POST['usernameDestine'], $_POST['amount'], constant("CASH_NAME")));
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_TEXT_SUCCESS, $_POST['amount'], constant("CASH_NAME"), $_POST['usernameDestine']), 1);
    break;
    case 2:
    $findAmountCashQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");
    $findAmountCash = mssql_fetch_object($findAmountCashQ)->amount;
    if($findAmountCash < $_POST['amount'])
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_NOT_HAVE_THIS _AMOUNT, constant("CASH_NAME2")), 2);

    $remove = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount2']."-".$_POST['amount']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."' AND ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." > ".$_POST['amount'].";
    SELECT @@ROWCOUNT [count];");
    if(mssql_fetch_object($remove)->count == 0)
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_NOT_HAVE_THIS _AMOUNT, constant("CASH_NAME2")), 2);

    $insert = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount2']."+".$_POST['amount']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_POST['usernameDestine']."';
    SELECT @@ROWCOUNT [count];");
    if(mssql_fetch_object($insert)->count == 0)
    {
    $remove = $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']."
    SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount2']."+".$_POST['amount']."
    WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");

    throw new Exception(sprintf(LDPU_TRANSFER_CASH_ERROR, constant("CASH_NAME2")), 2);
    }
    $this->writeLog(17, $_SESSION['LOGIN'], "", sprintf(LDPU_TRANSFER_CASH_LOG_SUCCESS, $_POST['usernameDestine'], $_POST['amount'], constant("CASH_NAME2")));
    throw new Exception(sprintf(LDPU_TRANSFER_CASH_TEXT_SUCCESS, $_POST['amount'], constant("CASH_NAME2"), $_POST['usernameDestine']), 1);
    break;
    }
    }
    throw new Exception("", 0);
    }
    catch (Exception $e)
    {

    $findAmountCashQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnAmount']." as amount, ".$TABLES_CONFIGS['WEBCASH']['columnAmount2']." as amount2 FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");
    $findAmountCash = mssql_fetch_object($findAmountCashQ);
    $ldTpl->set("MEMB___ID", $_SESSION['LOGIN']);
    $ldTpl->set("CASH_AMOUNT", $findAmountCash->amount);
    $ldTpl->set("CASH_AMOUNT2", $findAmountCash->amount2);

    if($e->getCode() == 2) //Quadro vermelho
    $ldTpl->set("RespostWrite", "<div class='qdestaques'>".$e->getMessage()."</div>");
    elseif($e->getCode() == 1) // quadro azul
    $ldTpl->set("RespostWrite", "<div class='qdestaques2'>".$e->getMessage()."</div>");
    else
    $ldTpl->set("RespostWrite", $e->getMessage());
    }
    }
    private function loadOptionsGameDisconnect()
    {
    global $ldTpl, $PANELUSER_MODULE, $PANELADMIN_MODULE;
    if($_GET['Write'] == true)
    {
    $checkPwdQ = $this->query('exec dbo.webVerifyLogin "'. $_SESSION['LOGIN'] .'","'. $_POST['password'] .'","'. USE_MD5 .'"');
    $checkPwd = mssql_fetch_row($checkPwdQ);
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 0) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif($checkPwd[0] == 0) $tempRepost .= "<div class='qdestaques2'>".LDPU_GAME_DISCONNECT_INVALID _PASSWORD."</div>";
    else
    {
    $ldGame = new ldGame($PANELADMIN_MODULE['JOINSERVER']['IP'], $PANELADMIN_MODULE['JOINSERVER']['PORT']);
    $tempRepost .= "<div class='qdestaques2'>".str_replace("\\n", "<br />", $ldGame->disconnectPlayer($_SESSION['LOGIN']))."</div>";
    $this->writeLog(16, $_SESSION['LOGIN'], "", "");
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsLogBuys()
    {
    global $ldTpl, $PANELUSER_MODULE;
    switch($_GET['Write'])
    {
    case 1:
    $findLogQ = $this->query("SELECT * FROM dbo.webLogBuyCash WHERE username='". $_SESSION['LOGIN'] ."'");
    while($findLog = mssql_fetch_object($findLogQ))
    {
    $tempRepost .= "<div class="quadros"><em>".LDPU_LOG_BUY_TEXT_ID.":</em> <strong>".$findLog->id."</strong><br /><em>".LDPU_LOG_BUY_TEXT_AMOUNT.":</em> <strong>".$findLog->cash."</strong><br /><em>".LDPU_LOG_BUY_TEXT_DATE.":</em> <strong>".$findLog->data."</strong><br /><em>".LDPU_LOG_BUY_TEXT_HOUR.":</em> <strong>".$findLog->hora."</strong><br /><em>".LDPU_LOG_BUY_TEXT_COMMENT.":</em> <strong>".nl2br(base64_decode($findLog->comentario))."</strong><br /><em>".LDPU_LOG_BUY_TEXT_COMMENT_ADM.":</em> <strong>".nl2br(base64_decode($findLog->comentario_adm))."</strong><br /><em>".LDPU_LOG_BUY_TEXT_STATUS.":</em> <strong>". ($findLog->status == 0 ? LDPU_LOG_BUY_TEXT_IN_PROGRESS : ($findLog->status == 1 ? LDPU_LOG_BUY_TEXT_COMPLETED : ($findLog->status == 0 ? LDPU_LOG_BUY_TEXT_REJECTED : LDPU_LOG_BUY_TEXT_STATUS_ERROR))) ."</strong><br /></div>";
    }
    break;
    case 2:
    $findLogQ = $this->query("SELECT * FROM dbo.webLogBuyVips WHERE username='". $_SESSION['LOGIN'] ."'");
    while($findLog = mssql_fetch_object($findLogQ))
    {
    $tempRepost .= "<div class="quadros"><em>".LDPU_LOG_BUY_TEXT_ID.":</em> <strong>".$findLog->id."</strong><br /><em>".LDPU_LOG_BUY_TEXT_TYPE.":</em> <strong>". ($PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][$findLog->type])."</strong><br /><em>".LDPU_LOG_BUY_TEXT_DAYS.":</em> <strong>".$findLog->days."</strong><br /><em>".LDPU_LOG_BUY_TEXT_VALUE_BY.":</em> <strong>".$findLog->cashAmount."</strong><br /><em>".LDPU_LOG_BUY_TEXT_DATE.":</em> <strong>". date("d/m/Y g:i a",$findLog->date) ."</strong><br /></div>";
    }
    break;
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsModifyPersonalID()
    {
    global $ldTpl;
    if($_GET['Write'] == true)
    {
    $checkPwdQ = $this->query('exec dbo.webVerifyLogin "'. $_SESSION['LOGIN'] .'","'. $_POST['pwd'] .'","'. USE_MD5 .'"');
    $checkPwd = mssql_fetch_row($checkPwdQ);
    if(is_numeric($_POST['pid']) == false) $tempRepost .= "<div class='qdestaques'><strong style='color:red;'>".LDPU_MODIFY_PID_FILL_ONLY_NUM BERS."</strong></div>";
    elseif(strlen($_POST['pid']) != 7) $tempRepost .= "<div class='qdestaques'><strong style='color:red;'>".LDPU_MODIFY_PID_INVALID_SIZE. "</strong></div>";
    elseif($checkPwd[0] == 0) $tempRepost .= "<div class='qdestaques'><strong style='color:red;'>".LDPU_MODIFY_PID_INVALID_PASSW ORD."</strong></div>";
    else {
    $this->writeLog(4, $_SESSION['LOGIN'], "", "");
    $this->query("UPDATE ".DATABASE_ACCOUNTS.".dbo.MEMB_INFO SET sno__numb = 111111".$_POST['pid']." WHERE memb___id='".$_SESSION['LOGIN']."'");
    $tempRepost .= "<div class='quadros'><strong style='color:blue;'>".LDPU_MODIFY_PID_SUCCESS."</strong></div>";
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsReset()
    {
    global $ldTpl, $PANELUSER_MODULE, $TABLES_CONFIGS, $CLASS_CHARACTERS;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT ".COLUMN_RESETS.", Class, Money, cLevel FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_row($findCharactersQ);
    $findTypeAccountQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findTypeAccount = mssql_fetch_object($findTypeAccountQ);
    $findCharacters[0]++;
    switch($PANELUSER_MODULE['RESET']['RESET_MODE'])
    {
    case 1:
    $this->LevelReset = $PANELUSER_MODULE['RESET']['0-10']['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET']['0-10']['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET']['0-10']['ZenRequire'][(int)$findTypeAccount->type];
    $this->Points = $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET']['0-10']['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET']['0-10']['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET']['0-10']['CleanQuests'][(int)$findTypeAccount->type];
    $this->LimitResets = $PANELUSER_MODULE['RESET']['LimitResets'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;
    break;
    case 2:
    if($findCharacters[0] >= 0 && $findCharacters[0] <= 10) $this->intervalResets = '0-10';
    elseif($findCharacters[0] >= 11 && $findCharacters[0] <= 50) $this->intervalResets = '11-50';
    elseif($findCharacters[0] >= 51 && $findCharacters[0] <= 100) $this->intervalResets = '51-100';
    elseif($findCharacters[0] >= 101 && $findCharacters[0] <= 150) $this->intervalResets = '101-150';
    elseif($findCharacters[0] >= 151 && $findCharacters[0] <= 200) $this->intervalResets = '151-200';
    elseif($findCharacters[0] >= 201 && $findCharacters[0] <= 300) $this->intervalResets = '201-300';
    elseif($findCharacters[0] >= 301) $this->intervalResets = '301-XXX';
    $this->LevelReset = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET'][$this->intervalResets]['ZenRequire'][(int)$findTypeAccount->type];
    $this->Points = $PANELUSER_MODULE['RESET'][$this->intervalResets]['Points'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanQuests'][(int)$findTypeAccount->type];
    $this->LimitResets = $PANELUSER_MODULE['RESET']['LimitResets'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;
    break;
    case 3:
    $this->LevelReset = $PANELUSER_MODULE['RESET']['0-10']['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET']['0-10']['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET']['0-10']['ZenRequire'][(int)$findTypeAccount->type];
    $this->Points = $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET']['0-10']['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET']['0-10']['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET']['0-10']['CleanQuests'][(int)$findTypeAccount->type];
    $this->LimitResets = $PANELUSER_MODULE['RESET']['LimitResets'][(int)$findTypeAccount->type];
    $this->ResetPoints = false;
    break;
    case 4:
    if($findCharacters[0] >= 0 && $findCharacters[0] <= 10) $this->intervalResets = '0-10';
    elseif($findCharacters[0] >= 11 && $findCharacters[0] <= 50) $this->intervalResets = '11-50';
    elseif($findCharacters[0] >= 51 && $findCharacters[0] <= 100) $this->intervalResets = '51-100';
    elseif($findCharacters[0] >= 101 && $findCharacters[0] <= 150) $this->intervalResets = '101-150';
    elseif($findCharacters[0] >= 151 && $findCharacters[0] <= 200) $this->intervalResets = '151-200';
    elseif($findCharacters[0] >= 201 && $findCharacters[0] <= 300) $this->intervalResets = '201-300';
    elseif($findCharacters[0] >= 301) $this->intervalResets = '301-XXX';

    $this->LevelReset = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET'][$this->intervalResets]['ZenRequire'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanQuests'][(int)$findTypeAccount->type];
    $this->LimitResets = $PANELUSER_MODULE['RESET']['LimitResets'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;

    if($findCharacters[0] >= 0 && $findCharacters[0] <= 10)
    {
    $this->Points = (int) ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] )
    ;
    }
    elseif($findCharacters[0] >= 11 && $findCharacters[0] <= 50)
    {
    $this->Points = (int)(( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($findCharacters[0] >= 51 && $findCharacters[0] <= 100)
    {
    $this->Points = (int)(( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($findCharacters[0] >= 101 && $findCharacters[0] <= 150)
    {
    $this->Points = (int)(( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($findCharacters[0] >= 151 && $findCharacters[0] <= 200)
    {
    $this->Points = (int)(( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['151-200']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($findCharacters[0] >= 201 && $findCharacters[0] <= 300)
    {
    $this->Points = (int)(( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['151-200']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['201-300']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($findCharacters[0] >= 301)
    {
    $this->Points = (int)(( $findCharacters[0] * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['151-200']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['201-300']['Points'][(int)$findTypeAccount->type] ) +
    ( $findCharacters[0] * $PANELUSER_MODULE['RESET']['301-XXX']['Points'][(int)$findTypeAccount->type] )
    );
    }
    break;
    }
    if($_GET['reset'] == false)
    {
    if($findCharacters[3] < $this->LevelReset) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_NOT_HAVE_LEVEL. "</strong><br />";
    if($findCharacters[2] < $this->ZenRequire) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_NOT_HAVE_ZEN."</strong><br />";
    if($findCharacters[0] >= $this->LimitResets && $this->LimitResets != 0) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_LIMIT_RESETS."</strong><br />";
    $tempRepost .= "<div class='quadros'>
    <em>".LDPU_RESET_TEXT_CHARACTER_SELECTED.":</em> <strong>". $_GET['character'] ."</strong><br />
    <strong><em>".LDPU_RESET_TEXT_YOU_NEED_TO_RESET.": </em></strong><br />
    <em>".LDPU_RESET_TEXT_LEVEL.":</em> <strong>". $this->LevelReset ."</strong><br />
    <em>".LDPU_RESET_TEXT_ZEN.":</em> <strong>". $this->ZenRequire ."</strong><br /><br />
    <strong><em>".LDPU_RESET_TEXT_STATUS_BEFORE_RESET. ":</em></strong><br />
    <em>".LDPU_RESET_TEXT_RESETS.":</em> <strong>". (int)($findCharacters[0]-1) ."</strong><br />
    <em>".LDPU_RESET_TEXT_LEVEL.":</em> <strong>". $findCharacters[3] ."</strong><br />
    <em>".LDPU_RESET_TEXT_ZEN.":</em> <strong>". $findCharacters[2] ."</strong><br />
    <em>".LDPU_RESET_TEXT_CLASS.":</em> <strong>". $this->classNameDefine($findCharacters[1]) ."</strong><br /><br />
    <strong><em>".LDPU_RESET_TEXT_STATUS_AFTER_RESET." :</em></strong><br />
    <em>".LDPU_RESET_TEXT_RESETS.":</em> <strong>". ($findCharacters[0]) ."</strong><br />
    <em>".LDPU_RESET_TEXT_LEVEL.":</em> <strong>". $this->LevelAfter ."</strong><br />
    <em>".LDPU_RESET_TEXT_ZEN.":</em> <strong>". (int)($findCharacters[2]-$this->ZenRequire) ."</strong><br />
    <em>".LDPU_RESET_TEXT_CLASS.":</em> <strong>". ($this->CleanQuests == true ? $this->classNameDefine($this->resetClassCode($findCharacters[1])) : $this->classNameDefine($findCharacters[1])) ."</strong><br />
    <em>".LDPU_RESET_TEXT_MAGICS.":</em> ". ($this->CleanMagics == true ? "<strong style='color:#FF0000'>".LDPU_RESET_TEXT_MAGICS_ERA SE."</strong>":"<strong>".LDPU_RESET_TEXT_MAGICS_NOT_ERA SE."</strong>") ."<br />
    <em>".LDPU_RESET_TEXT_ITEMS.":</em> ". ($this->CleanItens == true ? "<strong style='color:#FF0000'>".LDPU_RESET_TEXT_ITEMS_ERAS E."</strong>":"<strong>".LDPU_RESET_TEXT_ITEMS_NOT_ERAS E."</strong>") ."<br />
    <em>".LDPU_RESET_TEXT_QUESTS.":</em> ". ($this->CleanQuests == true ? "<strong style='color:#FF0000'>".LDPU_RESET_TEXT_QUESTS_ERA SE."</strong>":"<strong>".LDPU_RESET_TEXT_QUESTS_NOT_ERA SE."</strong>") ."<br /><br />";
    if(isset($errorReset)) $tempRepost .= $errorReset; else $tempRepost .= "<input type='button' class='button' value='".LDPU_RESET_TEXT_SUBMIT."' onclick="javascript:window.location='?page=panelus er&amp;option=RESET&amp;character=".urlencode($_GE T['character'])."&amp;reset=true';" />";
    $tempRepost .= "</div>";
    }
    else
    {
    if($findCharacters[3] < $this->LevelReset) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_NOT_HAVE_LEVEL. "</strong><br />";
    if($findCharacters[2] < $this->ZenRequire) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_NOT_HAVE_ZEN."</strong><br />";
    if($findCharacters[0] >= $this->LimitResets && $this->LimitResets != 0) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_LIMIT_RESETS."</strong><br />";

    if(isset($errorReset)) $tempRepost .= "<div class='qdestaques'>".$errorReset."</div>";
    else
    {
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET
    Experience = 0 ,
    ".COLUMN_RESETS." = ".COLUMN_RESETS." + 1 ,
    ".COLUMN_RESETS_WEEK." = ".COLUMN_RESETS_WEEK." + 1,
    ".COLUMN_RESETS_MONTH." = ".COLUMN_RESETS_MONTH." + 1,
    cLevel = ".$this->LevelAfter." ,
    MapNumber = ".($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['FE'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['HE'][0] ? 3 : 0)." ,
    MapPosX = ".($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['FE'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['HE'][0] ? 174 : 125)." ,
    MapPosY = ".($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['FE'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['HE'][0] ? 111 : 125)." ,
    Money = Money - ".$this->ZenRequire." ,
    ". ($this->CleanItens == true ? "Inventory = NULL,":"") ."
    ". ($this->CleanMagics == true ? "MagicList = NULL,":"") ."
    ". ($this->CleanQuests == true ? "Quest = NULL, class = ".$this->resetClassCode($findCharacters[1]).",":"") ."
    ". ($this->ResetPoints == true ? "Strength = 30 , Dexterity = 30 , Energy = 30 , Vitality = 30, LeaderShip = 30 ,":"") ."
    LevelUpPoint = ". ($this->ResetPoints == false ? "LevelUpPoint + ":"").($PANELUSER_MODULE['RESET']['RESET_MODE'] == 4 ? $this->Points : ($findCharacters[0]*$this->Points)) ."
    WHERE Name = '".$_GET['character']."'");

    $this->writeLog(5, $_SESSION['LOGIN'], $_GET['character'], ($this->CleanItens == true ? LDPU_RESET_LOG_SUBMIT_ERASED_ITEMS:""));
    $tempRepost .= "<div class='qdestaques2'>".LDPU_RESET_TEXT_SUCCESS."</div>";
    $this->query("EXEC [dbo].[webPanelAction_Reset] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsMasterReset()
    {
    global $ldTpl, $PANELUSER_MODULE, $TABLES_CONFIGS, $CLASS_CHARACTERS;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT ".COLUMN_RESETS.", Class, Money, cLevel, ".COLUMN_MASTER_RESETS.", Strength, Dexterity, Energy, Vitality, LeaderShip FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_row($findCharactersQ);
    $findTypeAccountQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findTypeAccount = mssql_fetch_object($findTypeAccountQ);
    $findCharacters[0]++;
    $this->masterResetRequireResets = $PANELUSER_MODULE['MASTER_RESET']['ResetsRequire'][(int)$findTypeAccount->type];
    switch($PANELUSER_MODULE['RESET']['RESET_MODE'])
    {
    case 1:
    $this->LevelReset = $PANELUSER_MODULE['RESET']['0-10']['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET']['0-10']['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET']['0-10']['ZenRequire'][(int)$findTypeAccount->type];
    $this->Points = $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET']['0-10']['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET']['0-10']['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET']['0-10']['CleanQuests'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;
    break;
    case 2:
    if($findCharacters[0] >= 0 && $findCharacters[0] <= 10) $this->intervalResets = '0-10';
    elseif($findCharacters[0] >= 11 && $findCharacters[0] <= 50) $this->intervalResets = '11-50';
    elseif($findCharacters[0] >= 51 && $findCharacters[0] <= 100) $this->intervalResets = '51-100';
    elseif($findCharacters[0] >= 101 && $findCharacters[0] <= 150) $this->intervalResets = '101-150';
    elseif($findCharacters[0] >= 151 && $findCharacters[0] <= 200) $this->intervalResets = '151-200';
    elseif($findCharacters[0] >= 201 && $findCharacters[0] <= 300) $this->intervalResets = '201-300';
    elseif($findCharacters[0] >= 301) $this->intervalResets = '301-XXX';
    $this->LevelReset = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET'][$this->intervalResets]['ZenRequire'][(int)$findTypeAccount->type];
    $this->Points = $PANELUSER_MODULE['RESET'][$this->intervalResets]['Points'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanQuests'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;
    break;
    case 3:
    $this->LevelReset = $PANELUSER_MODULE['RESET']['0-10']['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET']['0-10']['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET']['0-10']['ZenRequire'][(int)$findTypeAccount->type];
    $this->Points = $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET']['0-10']['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET']['0-10']['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET']['0-10']['CleanQuests'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;
    break;
    case 4:
    if($findCharacters[0] >= 0 && $findCharacters[0] <= 10) $this->intervalResets = '0-10';
    elseif($findCharacters[0] >= 11 && $findCharacters[0] <= 50) $this->intervalResets = '11-50';
    elseif($findCharacters[0] >= 51 && $findCharacters[0] <= 100) $this->intervalResets = '51-100';
    elseif($findCharacters[0] >= 101 && $findCharacters[0] <= 150) $this->intervalResets = '101-150';
    elseif($findCharacters[0] >= 151 && $findCharacters[0] <= 200) $this->intervalResets = '151-200';
    elseif($findCharacters[0] >= 201 && $findCharacters[0] <= 300) $this->intervalResets = '201-300';
    elseif($findCharacters[0] >= 301) $this->intervalResets = '301-XXX';

    $this->LevelReset = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelReset'][(int)$findTypeAccount->type];
    $this->LevelAfter = $PANELUSER_MODULE['RESET'][$this->intervalResets]['LevelAfter'][(int)$findTypeAccount->type];
    $this->ZenRequire = $PANELUSER_MODULE['RESET'][$this->intervalResets]['ZenRequire'][(int)$findTypeAccount->type];
    $this->CleanItens = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanItens'][(int)$findTypeAccount->type];
    $this->CleanMagics = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanMagics'][(int)$findTypeAccount->type];
    $this->CleanQuests = $PANELUSER_MODULE['RESET'][$this->intervalResets]['CleanQuests'][(int)$findTypeAccount->type];
    $this->ResetPoints = true;

    $newResetsDump = ($findCharacters[0] - $this->masterResetRequireResets);
    if($newResetsDump >= 0 && $newResetsDump <= 10)
    {
    $this->Points = (int) ( ($newResetsDump) * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] )
    ;
    }
    elseif($newResetsDump >= 11 && $newResetsDump <= 50)
    {
    $this->Points = (int)(( $newResetsDump * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($newResetsDump >= 51 && $newResetsDump <= 100)
    {
    $this->Points = (int)(( $newResetsDump * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($newResetsDump >= 101 && $newResetsDump <= 150)
    {
    $this->Points = (int)(( $newResetsDump * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($newResetsDump >= 151 && $newResetsDump <= 200)
    {
    $this->Points = (int)(( $newResetsDump * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['151-200']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($newResetsDump >= 201 && $newResetsDump <= 300)
    {
    $this->Points = (int)(( $newResetsDump * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['151-200']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['201-300']['Points'][(int)$findTypeAccount->type] )
    );
    }
    elseif($newResetsDump >= 301)
    {
    $this->Points = (int)(( $newResetsDump * $PANELUSER_MODULE['RESET']['0-10']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['11-50']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['51-100']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['101-150']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['151-200']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['201-300']['Points'][(int)$findTypeAccount->type] ) +
    ( $newResetsDump * $PANELUSER_MODULE['RESET']['301-XXX']['Points'][(int)$findTypeAccount->type] )
    );
    }
    break;
    }

    if($findCharacters[5] < $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Strength']) $errorReset .= sprintf("<strong style='color:#FF0000'>".LDPU_MRESET_TEXT_NEED_POIN TS_STRENGTH."</strong><br />", $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Strength']);
    if($findCharacters[6] < $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Dexterity']) $errorReset .= sprintf("<strong style='color:#FF0000'>".LDPU_MRESET_TEXT_NEED_POIN TS_DEXTERITY."</strong><br />", $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Dexterity']);
    if($findCharacters[7] < $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Energy']) $errorReset .= sprintf("<strong style='color:#FF0000'>".LDPU_MRESET_TEXT_NEED_POIN TS_ENERGY."</strong><br />", $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Energy']);
    if($findCharacters[8] < $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Vitality']) $errorReset .= sprintf("<strong style='color:#FF0000'>".LDPU_MRESET_TEXT_NEED_POIN TS_VITALITY."</strong><br />", $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Vitality']);
    if($findCharacters[9] < $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Leadership'] && $findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['DL'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['LE'][0]) $errorReset .= sprintf("<strong style='color:#FF0000'>".LDPU_MRESET_TEXT_NEED_POIN TS_LEADERSHIP."</strong><br />", $PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Leadership']);
    if($findCharacters[3] < $this->LevelReset) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_NOT_HAVE_LEVEL. "</strong><br />";
    if($findCharacters[2] < $this->ZenRequire) $errorReset .= "<strong style='color:#FF0000'>".LDPU_RESET_NOT_HAVE_ZEN."</strong><br />";
    if(($findCharacters[0]-1) < $this->masterResetRequireResets) $errorReset .= "<strong style='color:#FF0000'>".LDPU_MRESET_TEXT_NOT_HAVE_ RESETS."</strong><br />";

    if($_GET['reset'] == false)
    {
    $tempRepost .= "<div class='quadros'>
    <em>".LDPU_RESET_TEXT_CHARACTER_SELECTED.":</em> <strong>". $_GET['character'] ."</strong><br /><br />
    <strong><em>".LDPU_RESET_TEXT_YOU_NEED_TO_RESET.": </em></strong><br />
    <em>".LDPU_RESET_TEXT_LEVEL.":</em> <strong>". $this->LevelReset ."</strong><br />
    <em>".LDPU_RESET_TEXT_ZEN.":</em> <strong>". $this->ZenRequire ."</strong><br />
    <em>".LDPU_RESET_TEXT_RESETS."</em>: <strong>".$this->masterResetRequireResets."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_STRENGTH."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Strength']."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_DEXTERITY."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Dexterity']."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_ENERGY."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Energy']."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_VITALITY."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Vitality']."</strong><br />
    ". ($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['DL'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['LE'][0] ? "<em>".LDPU_MRESET_TEXT_POINTS_LEADERSHIP."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsRequire']['Leadership']."</strong><br />" : "") ."
    <br />
    <strong><em>".LDPU_RESET_TEXT_STATUS_BEFORE_RESET. ":</em></strong><br />
    <em>".LDPU_RESET_TEXT_RESETS.":</em> <strong>". (int)($findCharacters[0]-1) ."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_STRENGTH."</em>: <strong>".$findCharacters[5]."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_DEXTERITY."</em>: <strong>".$findCharacters[6]."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_ENERGY."</em>: <strong>".$findCharacters[7]."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_VITALITY."</em>: <strong>".$findCharacters[8]."</strong><br />
    ". ($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['DL'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['LE'][0] ? "<em>".LDPU_MRESET_TEXT_POINTS_LEADERSHIP."</em>: <strong>".$findCharacters[9]."</strong><br />" : "") ."
    <em>".LDPU_MRESET_TEXT_MASTER_RESETS.":</em> <strong>". $findCharacters[4] ."</strong><br />
    <em>".LDPU_RESET_TEXT_LEVEL.":</em> <strong>". $findCharacters[3] ."</strong><br />
    <em>".LDPU_RESET_TEXT_ZEN.":</em> <strong>". $findCharacters[2] ."</strong><br />
    <em>".LDPU_RESET_TEXT_CLASS.":</em> <strong>". $this->classNameDefine($findCharacters[1]) ."</strong><br /><br />
    <strong><em>".LDPU_RESET_TEXT_STATUS_AFTER_RESET." :</em></strong><br />
    <em>".LDPU_RESET_TEXT_RESETS.":</em> <strong>". (($findCharacters[0]-1)-$this->masterResetRequireResets) ."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_STRENGTH."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Strength']."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_DEXTERITY."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Dexterity']."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_ENERGY."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Energy']."</strong><br />
    <em>".LDPU_MRESET_TEXT_POINTS_VITALITY."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Vitality']."</strong><br />
    ". ($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['DL'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['LE'][0] ? "<em>".LDPU_MRESET_TEXT_POINTS_LEADERSHIP."</em>: <strong>".$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Leadership']."</strong><br />" : "") ."
    <em>".LDPU_MRESET_TEXT_MASTER_RESETS.":</em> <strong>". ($findCharacters[4]+1) ."</strong><br />
    <em>".LDPU_RESET_TEXT_LEVEL.":</em> <strong>". $this->LevelAfter ."</strong><br />
    <em>".LDPU_RESET_TEXT_ZEN.":</em> <strong>". (int)($findCharacters[2]-$this->ZenRequire) ."</strong><br />
    <em>".LDPU_RESET_TEXT_CLASS.":</em> <strong>". ($this->CleanQuests == true ? $this->classNameDefine($this->resetClassCode($findCharacters[1])) : $this->classNameDefine($findCharacters[1])) ."</strong><br />
    <em>".LDPU_RESET_TEXT_MAGICS.":</em> ". ($this->CleanMagics == true ? "<strong style='color:#FF0000'>".LDPU_RESET_TEXT_MAGICS_ERA SE."</strong>":"<strong>".LDPU_RESET_TEXT_MAGICS_NOT_ERA SE."</strong>") ."<br />
    <em>".LDPU_RESET_TEXT_ITEMS.":</em> ". ($this->CleanItens == true ? "<strong style='color:#FF0000'>".LDPU_RESET_TEXT_ITEMS_ERAS E."</strong>":"<strong>".LDPU_RESET_TEXT_ITEMS_NOT_ERAS E."</strong>") ."<br />
    <em>".LDPU_RESET_TEXT_QUESTS.":</em> ". ($this->CleanQuests == true ? "<strong style='color:#FF0000'>".LDPU_RESET_TEXT_QUESTS_ERA SE."</strong>":"<strong>".LDPU_RESET_TEXT_QUESTS_NOT_ERA SE."</strong>") ."<br /><br />";
    if(isset($errorReset)) $tempRepost .= $errorReset; else $tempRepost .= "<input type='button' class='button' value='".LDPU_MRESET_TEXT_SUBMIT."' onclick="javascript:window.location='?page=panelus er&amp;option=MASTER_RESET&amp;character=".urlenco de($_GET['character'])."&amp;reset=true';" />";
    $tempRepost .= "</div>";
    }
    else
    {
    if(isset($errorReset)) $tempRepost .= "<div class='qdestaques'>".$errorReset."</div>";
    else
    {
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET
    Experience = 0 ,
    ".COLUMN_RESETS." = ".COLUMN_RESETS." - ".$this->masterResetRequireResets." ,
    ".COLUMN_MASTER_RESETS." = ".COLUMN_MASTER_RESETS." + 1 ,
    cLevel = ".$this->LevelAfter." ,
    MapNumber = ".($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['FE'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['HE'][0] ? 3 : 0)." ,
    MapPosX = ".($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['FE'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['HE'][0] ? 174 : 125)." ,
    MapPosY = ".($findCharacters[1] >= $CLASS_CHARACTERS['CLASSCODES']['FE'][0] && $findCharacters[1] <= $CLASS_CHARACTERS['CLASSCODES']['HE'][0] ? 111 : 125)." ,
    Money = Money - ".$this->ZenRequire." ,
    ". ($this->CleanItens == true ? "Inventory = NULL,":"") ."
    ". ($this->CleanMagics == true ? "MagicList = NULL,":"") ."
    ". ($this->CleanQuests == true ? "Quest = NULL, class = ".$this->resetClassCode($findCharacters[1]).",":"") ."
    ". ($this->ResetPoints == true ? "Strength = {$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Strength']} , Dexterity = {$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Dexterity']} , Energy = {$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Energy']} , Vitality = {$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Vitality']}, LeaderShip = {$PANELUSER_MODULE['MASTER_RESET']['PointsAfter']['Leadership']} ,":"") ."
    LevelUpPoint = ". ($this->ResetPoints == false ? "LevelUpPoint + ":"").($PANELUSER_MODULE['RESET']['RESET_MODE'] == 4 ? $this->Points : (($findCharacters[0]-$this->masterResetRequireResets)*$this->Points)) ."
    WHERE Name = '".$_GET['character']."'");

    if($PANELUSER_MODULE['MASTER_RESET']['Bonus']['Active'] == true)
    $this->query("UPDATE ".$PANELUSER_MODULE['MASTER_RESET']['Bonus']['Columns']['table']." SET ".$PANELUSER_MODULE['MASTER_RESET']['Bonus']['Columns']['columnAmount']." = ".$PANELUSER_MODULE['MASTER_RESET']['Bonus']['Columns']['columnAmount']." + ".$PANELUSER_MODULE['MASTER_RESET']['Bonus']['Amount'][(int)$findTypeAccount->type]." WHERE ".$PANELUSER_MODULE['MASTER_RESET']['Bonus']['Columns']['columnUsername']." = '".$_SESSION['LOGIN']."'");

    $this->writeLog(6, $_SESSION['LOGIN'], $_GET['character'], ($this->CleanItens == true ? LDPU_RESET_LOG_SUBMIT_ERASED_ITEMS:""));
    $tempRepost .= "<div class='qdestaques2'>".LDPU_MRESET_TEXT_SUCCESS."</div>";
    $this->query("EXEC [dbo].[webPanelAction_MasterReset] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsResetTransfer()
    {
    global $ldTpl;
    global $PANELUSER_MODULE;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".$findCharacters->Name."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if($_GET['Write'] == true)
    {
    $findCharacter1Q = $this->query("SELECT ".COLUMN_RESETS." FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_POST['character1'] ."'");
    $findCharacter2Q = $this->query("SELECT ".COLUMN_RESETS." FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_POST['character2'] ."'");
    if($_POST['character1'] == $_POST['character2']) $tempRepost .= "<div class='qdestaques2'>".LDPU_RESET_TRANS_TEXT_CHOOSE _NOT_EQUAL."</div>";
    elseif($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharacter1Q) == 0 || mssql_num_rows($findCharacter2Q) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    if($_GET['SubWrite'] == false)
    {
    $findCharacter1 = mssql_fetch_row($findCharacter1Q);
    $findCharacter2 = mssql_fetch_row($findCharacter2Q);
    $tempRepost .= "<script>
    function varNumeric(e){
    var tecla=(window.event)?event.keyCode:e.which;
    if((tecla > 47 && tecla < 58)) {
    return true;
    } else{
    if (tecla != 8) return false; else return true;
    }
    }
    </script>
    <div class='quadros'>
    <form action='?page=paneluser&amp;option=RESET_TRANSFER& amp;Write=true&amp;SubWrite=true' method='POST'>
    <table width='100%' border='0'>
    <tr>
    <td align='right' width='45%'><strong>".LDPU_RESET_TRANS_TEXT_CHARAC TER_ORIGIN.": </strong></td>
    <td><input name='character1' id='character1' size='10' type='text' class='' value='".$_POST['character1']."' readonly='readonly' /> ".$findCharacter1[0]." ".LDPU_RESET_TRANS_TEXT_RESETS."</td>
    </tr>
    <tr>
    <td align='right' width='45%'><strong>".LDPU_RESET_TRANS_TEXT_CHARAC TER_DESTINY.": </strong></td>
    <td><input name='character2' id='character2' size='10' type='text' class='' value='".$_POST['character2']."' readonly='readonly'/> ".$findCharacter2[0]." ".LDPU_RESET_TRANS_TEXT_RESETS."</td>
    </tr>
    <tr>
    <td align='right' width='45%'><strong>".LDPU_RESET_TRANS_TEXT_TRANSF ER.": </strong></td>
    <td><input name='transresets' id='transresets' onkeypress='return varNumeric(event)' maxlength='5' size='10' type='text' class='' value='0'/> <strong>".LDPU_RESET_TRANS_TEXT_RESETS."</strong></td>
    </tr>
    <tr>
    <td colspan='2' align='center'><br /><strong>".LDPU_RESET_TRANS_TEXT_WARNING."</strong></td>
    </tr>
    </table>
    <div align='center'><input type='submit' value='".LDPU_RESET_TRANS_TEXT_SUBMIT."' id='button_submit' class='button' /></div>
    </form>
    </div>";
    }
    elseif($_GET['SubWrite'] == true)
    {
    $findCharacter1 = mssql_fetch_row($findCharacter1Q);
    $findCharacter2 = mssql_fetch_row($findCharacter2Q);
    if(is_numeric($_POST['transresets']) == false) $tempRepost .= "<div class='qdestaques'>".LDPU_RESET_TRANS_TEXT_FILL_ON LY_NUMBERS."</div>";
    elseif($_POST['transresets'] < 1) $tempRepost .= "<div class='qdestaques'>".LDPU_RESET_TRANS_TEXT_INVALID _AMOUNT."</div>";
    elseif($_POST['transresets'] < $PANELUSER_MODULE['RESET_TRANSFER']['MIN_REQUIRE']) $tempRepost .= sprintf("<div class='qdestaques'>".LDPU_RESET_TRANS_TEXT_MINIMUM _AMOUNT."</div>", $PANELUSER_MODULE['RESET_TRANSFER']['MIN_REQUIRE']);
    elseif($findCharacter1[0] < $_POST['transresets']) $tempRepost .= "<div class='qdestaques'>".LDPU_RESET_TRANS_TEXT_NOT_HAV E_AMOUNT_RESETS."</div>";
    else
    {
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET ".COLUMN_RESETS." = ".COLUMN_RESETS." - ".$_POST['transresets'].", LevelUpPoint = 0, Strength = 30 , Dexterity = 30 , Energy = 30 , Vitality = 30, LeaderShip = 30 WHERE Name='". $_POST['character1'] ."' AND AccountID='". $_SESSION['LOGIN'] ."'");
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET ".COLUMN_RESETS." = ".COLUMN_RESETS." + ".$_POST['transresets'].", LevelUpPoint = 0, Strength = 30 , Dexterity = 30 , Energy = 30 , Vitality = 30, LeaderShip = 30 WHERE Name='". $_POST['character2'] ."' AND AccountID='". $_SESSION['LOGIN'] ."'");
    $tempRepost .= "<div class='qdestaques2'>".LDPU_RESET_TRANS_TEXT_SUCCES S."</div>";
    $this->writeLog(7, $_SESSION['LOGIN'], $_POST['character1'], sprintf(LDPU_RESET_TRANS_LOG_SUCCESS, $_POST['transresets'], $_POST['character2']));
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsCleanPk()
    {
    global $ldTpl, $PANELUSER_MODULE, $TABLES_CONFIGS;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT PkCount, Money FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_row($findCharactersQ);
    $findTypeAccountQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='". $_SESSION['LOGIN'] ."'");
    $findTypeAccount = mssql_fetch_object($findTypeAccountQ);
    switch($PANELUSER_MODULE['CLEAN_PK']['CLEAN_MODE'])
    {
    case 1: $this->pricePk = $PANELUSER_MODULE['CLEAN_PK']['PRICEZEN'][(int)$findTypeAccount->type]; break;
    case 2: $this->pricePk = ($findCharacters[0]*$PANELUSER_MODULE['CLEAN_PK']['PRICEZEN'][(int)$findTypeAccount->type]); break;
    }
    if($_GET['Write'] == false)
    {
    if($findCharacters[0] == 0) $tempRepost .= "<div class='quadros'>".LDPU_CLEAN_PK_NOT_PK."</div>";
    else
    {
    $tempRepost .= "<div class='quadros'>
    <em>".LDPU_CLEAN_SELECTED_CHARACTER.":</em> ". $_GET['character'] ."<br />
    <em>".LDPU_CLEAN_PK_LEVEL.":</em> ". $findCharacters[0] ."<br />
    <em>".LDPU_CLEAN_NEED_ZEN.":</em> ". $this->pricePk ."<br />
    <em>".LDPU_CLEAN_HAVE_ZEN.":</em> ". $findCharacters[1] ."<br />";
    if($findCharacters[1] < $this->pricePk) $tempRepost .= "<strong style='color:red'>".LDPU_CLEAN_NOT_HAVE_ZEN."</strong>"; else $tempRepost .= "<input type='button' class='button' value='".LDPU_CLEAN_SUBMIT."' onclick="javascript: window.location='?page=paneluser&amp;option=CLEAN_ PK&amp;character=".urlencode($_GET['character'])."&amp;Write=true';" />";
    $tempRepost .= "</div>";
    }
    }
    else
    {
    if($findCharacters[1] < $this->pricePk) $tempRepost .= "<strong style='color:red'>".LDPU_CLEAN_NOT_HAVE_ZEN."</strong>";
    else
    {
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET PkCount=0, ".COLUMN_PK_RANKING." = ".COLUMN_PK_RANKING." + PkCount, PkLevel=0, PkTime=0, Money = Money - ".$this->pricePk." WHERE Name='".$_GET['character']."'");
    $tempRepost .= "<div class='qdestaques2'>".LDPU_CLEAN_SUCCESS_TEXT."</div>";
    $this->writeLog(8, $_SESSION['LOGIN'], $_GET['character'], "");
    $this->query("EXEC [dbo].[webPanelAction_CleanPK] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsDistributePoints()
    {
    global $ldTpl, $PANELUSER_MODULE, $CLASS_CHARACTERS;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT LevelUpPoint,Strength,Dexterity,Vitality,Energy,Le adership,Class FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    $this->maxPoints = $PANELUSER_MODULE['DISTRIBUTE_POINTS']['MAXPOINTS'];
    $this->freePoints = $findCharacters->LevelUpPoint;
    $this->usePointsStrength = $findCharacters->Strength;
    $this->usePointsDexterity = $findCharacters->Dexterity;
    $this->usePointsVitality = $findCharacters->Vitality;
    $this->usePointsEnergy = $findCharacters->Energy;
    $this->usePointsLeadership = $findCharacters->Leadership;
    if($_GET['Write'] == false)
    {
    $tempRepost .= "<script type='text/javascript'>
    var MaxPointsCamp = ".$this->maxPoints.";
    function varNumeric(e){
    var tecla=(window.event)?event.keyCode:e.which;
    if((tecla > 47 && tecla < 58)) {
    return true;
    } else{
    if (tecla != 8) return false; else return true;
    }
    }
    function leftPoints(campo) {
    var this_camp = document.getElementById(campo).value;
    var forca = document.getElementById('forca').value;
    var agili = document.getElementById('agili').value;
    var vital = document.getElementById('vital').value;
    var energ = document.getElementById('energ').value;
    var comman = (". $findCharacters->Class ." == ".$CLASS_CHARACTERS['CLASSCODES']['DL'][0]." || ". $findCharacters->Class ." == ".$CLASS_CHARACTERS['CLASSCODES']['LE'][0].") ? document.getElementById('comman').value : 0;
    var forca = (forca == '') ? 0 : forca;
    var agili = (agili == '') ? 0 : agili;
    var vital = (vital == '') ? 0 : vital;
    var energ = (energ == '') ? 0 : energ;
    var comman = (comman == '') ? 0 : comman;

    var total_points = (parseFloat(forca)+parseFloat(agili)+parseFloat(vi tal)+parseFloat(energ)+parseFloat(comman));
    document.getElementById('restam_ponts').innerHTML = ((".$this->freePoints."-total_points) < 0) ? 0 : ".$this->freePoints."-total_points;

    if(total_points > ".$this->freePoints.") {
    document.getElementById(campo).style.border = '1px solid #FF8080';
    document.getElementById(campo).style.color = '#FF2121';
    document.getElementById('erro_max_ponts').innerHTM L = "".LDPU_DISTRIBUTE_POINTS_NOT_HAVE_AMOUNT."";
    document.getElementById('button_submit').disabled = 'disabled';
    } else {
    if(this_camp == 0) {
    document.getElementById(campo).style.border = '1px solid #CFCFCF';
    document.getElementById(campo).style.color = '#777';
    document.getElementById('erro_max_ponts').innerHTM L = "";
    document.getElementById('button_submit').disabled = '';
    } else {
    document.getElementById(campo).style.border = '1px solid #00D800';
    document.getElementById(campo).style.color = '#009F00';
    document.getElementById('erro_max_ponts').innerHTM L = "";
    document.getElementById('button_submit').disabled = '';
    }
    }
    }
    function maxPoints(campo) {
    var pontos_atuais = document.getElementById(campo).value;
    if(campo == 'forca') var points_char = ".$this->usePointsStrength.";
    if(campo == 'agili') var points_char = ".$this->usePointsDexterity.";
    if(campo == 'vital') var points_char = ".$this->usePointsVitality.";
    if(campo == 'energ') var points_char = ".$this->usePointsEnergy.";
    if(campo == 'comman') var points_char = ".$this->usePointsLeadership.";
    if((parseFloat(points_char)+parseFloat(pontos_atua is)) > MaxPointsCamp) {
    document.getElementById(campo).style.border = '1px solid #FF8080';
    document.getElementById(campo).style.color = '#FF2121';
    document.getElementById(campo+'_erro').innerHTML = ".sprintf(""".LDPU_DISTRIBUTE_POINTS_MAX_POINTS_AM OUNT."";", ""+MaxPointsCamp+"")."
    document.getElementById('button_submit').disabled = 'disabled';
    } else {
    if(pontos_atuais == 0) {
    document.getElementById(campo).style.border = '1px solid #CFCFCF';
    document.getElementById(campo).style.color = '#777';
    document.getElementById(campo+'_erro').innerHTML = "".LDPU_DISTRIBUTE_POINTS_CURRENT_AMOUNT.": "+parseFloat(points_char);
    document.getElementById('button_submit').disabled = '';
    } else {
    document.getElementById(campo).style.border = '1px solid #00D800';
    document.getElementById(campo).style.color = '#009F00';
    document.getElementById(campo+'_erro').innerHTML = "".LDPU_DISTRIBUTE_POINTS_NEXT_AMOUNT.": "+(parseFloat(points_char)+parseFloat(pontos_atuai s));
    document.getElementById('button_submit').disabled = '';
    }
    }
    leftPoints(campo);
    }
    </script>
    <div class='quadros'>
    <form action='?page=paneluser&amp;option=DISTRIBUTE_POIN TS&amp;character=".urldecode($_GET['character'])."&amp;Write=true' method='post'>
    <table border='0'>
    <tr>
    <td align='center' colspan='3'><em>".LDPU_DISTRIBUTE_POINTS_CHARACTER .":</em> ".$_GET['character']."</td>
    </tr>
    <tr>
    <td align='center' colspan='3'>".LDPU_DISTRIBUTE_POINTS_YOU_HAVE.": <strong id='restam_ponts'>".$this->freePoints."</strong> ".LDPU_DISTRIBUTE_POINTS_OF_DISTRIBUTE."</td>
    </tr>
    <tr>
    <td align='center' colspan='3'><strong id='erro_max_ponts'></strong></td>
    </tr>
    <tr>
    <td align='right' width='48%'><strong>".LDPU_DISTRIBUTE_POINTS_STREN GTH.": </strong></td>
    <td width='10%'><input name='forca' id='forca' onkeypress='return varNumeric(event)' maxlength='5' size='10' type='text' class='' onblur="maxPoints('forca');" value='0'/></td>
    <td><div id='forca_erro'>".LDPU_DISTRIBUTE_POINTS_CURRENT_A MOUNT.": ".$this->usePointsStrength."</div></td>
    </tr>
    <tr>
    <td align='right'><strong>".LDPU_DISTRIBUTE_POINTS_DEX TERITY.": </strong></td>
    <td><input name='agili' id='agili' onkeypress='return varNumeric(event)' maxlength='5' size='10' type='text' class='' onblur="maxPoints('agili');" value='0'/></td>
    <td><div id='agili_erro'>".LDPU_DISTRIBUTE_POINTS_CURRENT_A MOUNT.": ".$this->usePointsDexterity."</div></td>
    </tr>
    <tr>
    <td align='right'><strong>".LDPU_DISTRIBUTE_POINTS_VIT ALITY.": </strong></td>
    <td><input name='vital' id='vital' onkeypress='return varNumeric(event)' maxlength='5' size='10' type='text' class='' onblur="maxPoints('vital');" value='0'/></td>
    <td><div id='vital_erro'>".LDPU_DISTRIBUTE_POINTS_CURRENT_A MOUNT.": ".$this->usePointsVitality."</div></td>
    </tr>
    <tr>
    <td align='right'><strong>".LDPU_DISTRIBUTE_POINTS_ENE RGY.": </strong></td>
    <td><input name='energ' id='energ' onkeypress='return varNumeric(event)' maxlength='5' size='10' type='text' class='' onblur="maxPoints('energ');" value='0'/></td>
    <td><div id='energ_erro'>".LDPU_DISTRIBUTE_POINTS_CURRENT_A MOUNT.": ".$this->usePointsEnergy."</div></td>
    </tr>";
    if($findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['DL'][0] || $findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['LE'][0]) {
    $tempRepost .= "
    <tr>
    <td align='right'><strong>".LDPU_DISTRIBUTE_POINTS_LEA DERSHIP.": </strong></td>
    <td><input name='comman' id='comman' onkeypress='return varNumeric(event)' maxlength='5' size='10' type='text' class='' onblur="maxPoints('comman');" value='0'/></div></td>
    <td><div id='comman_erro'>".LDPU_DISTRIBUTE_POINTS_CURRENT_ AMOUNT.": ".$this->usePointsLeadership."</div></td>
    </tr>";
    }
    $tempRepost .= "<tr>
    <td align='center' colspan='3'><input type='submit' class='button' value='".LDPU_DISTRIBUTE_POINTS_SUBMIT."' id='button_submit' /></td>
    </tr>
    </table>
    </form>
    </div>";
    }
    else
    {
    $LevelUpPoints = ($_POST['forca'] + $_POST['agili'] + $_POST['vital'] + $_POST['energ'] + $_POST['comman']);
    if($LevelUpPoints > $this->freePoints) $tempRepost .= "<div class='qdestaques'>".LDPU_DISTRIBUTE_POINTS_NOT_HA VE_AMOUNT."</div>";
    elseif(eregi("[^0-9]",$_POST['forca']) || eregi("[^0-9]",$_POST['agili']) || eregi("[^0-9]",$_POST['vital']) || eregi("[^0-9]",$_POST['energ']) || eregi("[^0-9]",$_POST['comman'])) $tempRepost .= "<div class='qdestaques'>".LDPU_DISTRIBUTE_ONLY_NUMBERS. "</div>";
    elseif((($_POST['forca'] + $this->usePointsStrength) > $this->maxPoints) || (($_POST['agili'] + $this->usePointsDexterity) > $this->maxPoints) || (($_POST['vital'] + $this->usePointsVitality) > $this->maxPoints) || (($_POST['energ'] + $this->usePointsEnergy) > $this->maxPoints) || (($_POST['comman'] + $this->usePointsLeadership) > $this->maxPoints)) $tempRepost .= sprintf("<div class='qdestaques'>".LDPU_DISTRIBUTE_MAXIMUM_POINT S."</div>", $this->maxPoints);
    else
    {
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET LevelUpPoint = LevelUpPoint - ".(int)$LevelUpPoints.",Strength = Strength + ".(int)$_POST['forca']." ,Dexterity = Dexterity + ".(int)$_POST['agili'].",Vitality = Vitality + ".(int)$_POST['vital'].",Energy = Energy + ".(int)$_POST['energ'].",Leadership = Leadership + ".(int)$_POST['comman']." WHERE Name='". $_GET['character'] ."'");
    $tempRepost .= "<div class='qdestaques2'>".LDPU_DISTRIBUTE_SUCCESS."</div>";
    $this->writeLog(9, $_SESSION['LOGIN'], $_GET['character'], LDPU_DISTRIBUTE_POINTS_STRENGTH.": ".(int)$_POST['forca'].", ".LDPU_DISTRIBUTE_POINTS_DEXTERITY.": ".(int)$_POST['agili'].", ".LDPU_DISTRIBUTE_POINTS_VITALITY.": ".(int)$_POST['vital'].", ".LDPU_DISTRIBUTE_POINTS_ENERGY.": ".(int)$_POST['energ'].", ".LDPU_DISTRIBUTE_POINTS_LEADERSHIP.": ".(int)$_POST['comman']);
    $this->query("EXEC [dbo].[webPanelAction_DistributePoints] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsMoveCharacter()
    {
    global $ldTpl;
    global $PANELUSER_MODULE;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT MapNumber,MapPosX,MapPosY FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    if($_GET['Write'] == false)
    {
    foreach($PANELUSER_MODULE['MOVE_CHARACTER']['MAPS'] as $listTempArray)
    {
    $scriptTemp .= "case '".$listTempArray[0]."':\nvar coordX = ".$listTempArray[2].";\nvar coordY = ".$listTempArray[3].";\nbreak;\n";
    $listTemp .= "<option value='".$listTempArray[0]."'>".$listTempArray[1]."</option>";
    }
    $tempRepost .= "<script type='text/javascript'>
    function varNumeric(e){
    var tecla=(window.event)?event.keyCode:e.which;
    if((tecla > 47 && tecla < 58)) {
    return true;
    } else{
    if (tecla != 8) return false; else return true;
    }
    }
    function valid_coordener(coord) {
    var value = document.getElementById(coord).value;
    if(value < 0) {
    document.getElementById(coord+'_erro').innerHTML = "".LDPU_MOVE_CHARCTER_MUST_MORE_ZERO."";
    document.getElementById(coord).style.border = '1px solid #FF8080';
    document.getElementById(coord).style.color = '#FF2121';
    document.getElementById('button_submit').disabled = 'disabled';
    }
    if(value > 255) {
    document.getElementById(coord+'_erro').innerHTML = "".LDPU_MOVE_CHARCTER_MUST_LOWER_255."";
    document.getElementById(coord).style.border = '1px solid #FF8080';
    document.getElementById(coord).style.color = '#FF2121';
    document.getElementById('button_submit').disabled = 'disabled';
    }
    if(value >= 0 && value <= 255) {
    document.getElementById(coord+'_erro').innerHTML = "".LDPU_MOVE_CHARCTER_INVALID_COORDENATE."";
    document.getElementById(coord).style.border = '1px solid #00D800';
    document.getElementById(coord).style.color = '#009F00';
    document.getElementById('button_submit').disabled = '';
    }
    }
    function verify_coorderns(map) {
    switch(map) {
    ".$scriptTemp."
    default:
    var coordX = 125;
    var coordY = 125;
    break;
    }
    document.getElementById('coordX').value = coordX;
    document.getElementById('coordY').value = coordY;
    valid_coordener('coordX');
    valid_coordener('coordY');
    }
    </script>
    <div class='quadros'>
    <form action='?page=paneluser&option=MOVE_CHARACTER&char acter=".urlencode($_GET['character'])."&amp;Write=true' method='post'>
    <table width='100%' border='0'>
    <tr>
    <td colspan='3' align='center'><strong>".LDPU_MOVE_CHARCTER_CHARAC TER.": ".$_GET['character']."</strong></td>
    </tr>
    <tr>
    <td align='right' width='47%'><strong>".LDPU_MOVE_CHARCTER_MOVE_TO." : </strong></td>
    <td> <select name='movemap' onchange='verify_coorderns(this.options[this.selectedIndex].value);'>".$listTemp."</select> </td>
    </tr>
    <tr>
    <td align='right' width='47%'><strong>".LDPU_MOVE_CHARCTER_COORD_X." : </strong></td>
    <td><input name='coordX' id='coordX' onkeypress='return varNumeric(event)' value='".$findCharacters->MapPosX."' size='10' maxlength='3' onblur="valid_coordener('coordX');"/></td>
    <td><div id='coordX_erro'></div></td>
    </tr>
    <tr>
    <td align='right' width='47%'><strong>".LDPU_MOVE_CHARCTER_COORD_y." : </strong></td>
    <td><input name='coordY' id='coordY' onkeypress='return varNumeric(event)' value='".$findCharacters->MapPosY."' size='10' maxlength='3' onblur="valid_coordener('coordY');"/></td>
    <td><div id='coordY_erro'></div></td>
    </tr>
    </table>
    <div align='center'><input type='submit' class='button' value='".LDPU_MOVE_CHARCTER_SUBMIT."' id='button_submit' /></div>
    </form>
    </div>";
    }
    else
    {
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET MapNumber=".(int)$_POST['movemap'].", MapPosX=".(int)$_POST['coordX'].", MapPosY=".(int)$_POST['coordY']." WHERE Name='".$_GET['character']."'");
    $tempRepost .= "<div class='qdestaques2'>".LDPU_MOVE_CHARCTER_SUCCESS." </div>";
    $this->writeLog(10, $_SESSION['LOGIN'], $_GET['character'], sprintf(LDPU_MOVE_CHARCTER_SUCCESS_LOG, (int)$_POST['movemap'], (int)$_POST['coordX'], (int)$_POST['coordY']));
    $this->query("EXEC [dbo].[webPanelAction_MoveCharacter] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsChangeNick()
    {
    global $ldTpl;
    global $PANELUSER_MODULE;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT MapNumber,MapPosX,MapPosY FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    if($_GET['Write'] == false)
    {
    $tempRepost .= "<div class='quadros'>
    <form action='?page=paneluser&amp;option=CHANGE_NICK&amp ;character=".urlencode($_GET['character'])."&amp;Write=true' method='post'>
    <table width='100%' border='0'>
    <tr>
    <td align='center' colspan='2'><em>".LDPU_CHANGE_NICK_CHARACTER.":</em> <strong>".$_GET['character']."</strong></td>
    </tr>
    <tr>
    <td align='right' width='40%'><strong>".LDPU_CHANGE_NICK_NEW_NICK.": </strong></td>
    <td><input name='newnick' id='newnick' maxlength='10' size='15' type='text' class='' value='".$_GET['character']."' /></td>
    </tr>
    <tr>
    <td align='center' colspan='2'><input type='submit' class='button' value='".LDPU_CHANGE_NICK_SUBMIT."' /></td>
    </tr>
    </table>
    </form>
    </div>";
    }
    else
    {
    $findCharGuildQ = $this->query("SELECT 1 FROM ".DATABASE_CHARACTERS.".dbo.GuildMember WHERE Name='". $_GET['character'] ."'");
    $findCharQ = $this->query("SELECT 1 FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE Name='". $_POST['newnick'] ."'");
    $findCharStatusQ = $this->query("SELECT CtlCode FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE Name='".$_GET['character']."'");
    $findCharStatus = mssql_fetch_row($findCharStatusQ);
    if(mssql_num_rows($findCharGuildQ) > 0) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_NOT_HAVE_ GUILD."</strong></div>";
    elseif(empty($_POST['newnick']) || eregi("[^a-zA-Z0-9_!=?&-]", $_POST['newnick'])) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_INVALID_C HARS."</strong></div>";
    elseif(strlen($_POST['newnick']) > 10) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_INVALID_N AME_SIZE."</strong></div>";
    elseif($_GET['character'] == $_POST['newnick']) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_FILL_NAME ."</strong></div>";
    elseif(mssql_num_rows($findCharQ) > 0) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_ALREADY_E XISTS_THIS_NICK."</strong></div>";
    elseif($findCharStatus[0] == 1) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_CHARACTER _BANNED."</strong></div>";
    elseif(eregi("WEBZEN",$_POST['newnick']) == true || eregi("ADM",$_POST['newnick']) == true || eregi("GM",$_POST['newnick']) == true || eregi("MD",$_POST['newnick']) == true || eregi("NT",$_POST['newnick']) == true || eregi("DV",$_POST['newnick']) == true) $tempRepost .= "<div class='qdestaques2'><strong style='color:#BB0000'>".LDPU_CHANGE_NICK_INVALID_S IGLES."</strong></div>";
    else {
    $selectSlotQ = $this->query("SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM ".DATABASE_CHARACTERS.".dbo.AccountCharacter WHERE Id='".$_SESSION['LOGIN']."'");
    $selectSlot = mssql_fetch_object($selectSlotQ);

    if($selectSlot->GameID1 == $_GET['character']) $Slot_GameID = "GameID1";
    if($selectSlot->GameID2 == $_GET['character']) $Slot_GameID = "GameID2";
    if($selectSlot->GameID3 == $_GET['character']) $Slot_GameID = "GameID3";
    if($selectSlot->GameID4 == $_GET['character']) $Slot_GameID = "GameID4";
    if($selectSlot->GameID5 == $_GET['character']) $Slot_GameID = "GameID5";

    $Query_part1 = $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.AccountCharacter SET $Slot_GameID='".$_POST['newnick']."' WHERE $Slot_GameID='".$_GET['character']."'");
    $Query_part2 = $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET Name='".$_POST['newnick']."' WHERE Name='".$_GET['character']."'");

    if(MUSERVER_TEAM == 1 && VESION_MUSERVER == 5)
    {
    $this->query("DELETE FROM ".DATABASE_CHARACTERS.".dbo.MasterSkillTree WHERE Name = '". $_GET['character'] ."'");
    }

    $tempRepost .= "<div class='qdestaques2'>".LDPU_CHANGE_NICK_SUCCESS."</div>";
    $this->writeLog(11, $_SESSION['LOGIN'], $_GET['character'], LDPU_CHANGE_NICK_SUCCESS_LOG.": {$_POST['newnick']}");
    $this->query("EXEC [dbo].[webPanelAction_ChargeNick] '". $_SESSION['LOGIN'] ."', '".$_POST['newnick']."', '".$_GET['character']."'");
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsChangeClass()
    {
    global $ldTpl, $PANELUSER_MODULE, $CLASS_CHARACTERS;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT Class FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    if($_GET['Write'] == false)
    {
    switch(VESION_MUSERVER) {
    case 0: //Season 1 ou Abaixo - Sem DL
    $listClass ="<option value='".$CLASS_CHARACTERS['CLASSCODES']['DW'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DW'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['ME'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['ME'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['MG'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['MG'][1]."</option>";
    break;
    case 1: //Season 1 ou Abaixo
    $listClass ="<option value='".$CLASS_CHARACTERS['CLASSCODES']['DW'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DW'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['ME'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['ME'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['MG'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['MG'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DL'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DL'][1]."</option>";
    break;
    case 2: //Season 2
    $listClass ="<option value='".$CLASS_CHARACTERS['CLASSCODES']['DW'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DW'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['ME'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['ME'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['MG'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['MG'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DL'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DL'][1]."</option>";
    break;
    case 3: //Season 3 Episodio 1
    $listClass ="<option value='".$CLASS_CHARACTERS['CLASSCODES']['DW'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DW'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['GM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['GM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['ME'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['ME'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['HE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['HE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['MG'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['MG'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DMM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DMM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DL'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DL'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['LE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['LE'][1]."</option>";
    break;
    case 4: //Season 3 Episodio 2
    $listClass ="<option value='".$CLASS_CHARACTERS['CLASSCODES']['DW'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DW'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['GM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['GM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['ME'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['ME'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['HE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['HE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['MG'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['MG'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DMM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DMM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DL'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DL'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['LE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['LE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SU'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SU'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BS'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BS'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DMS'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DMS'][1]."</option>";
    break;
    case 5: case 6: //Season 6
    $listClass ="<option value='".$CLASS_CHARACTERS['CLASSCODES']['DW'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DW'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['GM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['GM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BK'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BK'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['ME'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['ME'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['HE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['HE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['MG'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['MG'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DMM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DMM'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DL'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DL'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['LE'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['LE'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['SU'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['SU'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['BS'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['BS'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['DMS'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['DMS'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['RF'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['RF'][1]."</option>
    <option value='".$CLASS_CHARACTERS['CLASSCODES']['FM'][0]."'>".$CLASS_CHARACTERS['CLASSCODES']['FM'][1]."</option>";
    break;
    }
    $tempRepost .= "<div class='quadros'>
    <form action='?page=paneluser&amp;option=CHANGE_CLASS&am p;character=". urlencode($_GET['character']) ."&amp;Write=true' method='post'>
    <strong>".LDPU_CHANGE_CLASS_NEW_CLASS.": </strong>
    <select name='newclass'>
    {$listClass}
    </select>
    <input type='submit' class='button' value='".LDPU_CHANGE_CLASS_SUBMIT."' />
    </form>
    </div>";
    }
    else
    {
    switch(VESION_MUSERVER)
    {
    case 0: //Season 1 ou Abaixo - Sem DL
    $quests = 50; $magics = 60; break;
    break;
    case 1: //Season 1 ou Abaixo
    $quests = 50; $magics = 60; break;
    break;
    case 2: //Season 2
    $quests = 50; $magics = 180; break;
    break;
    case 3: //Season 3 Episodio 1
    $quests = 50; $magics = 180; break;
    break;
    case 4: //Season 3 Episodio 2
    $quests = 50; $magics = 180; break;
    break;
    case 5: //Season 6
    $quests = 50; $magics = 180; break;
    break;
    case 6: //Season 6.2
    $quests = 50; $magics = 180; break;
    break;
    }
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character
    SET Class=".$_POST['newclass']."
    ".($PANELUSER_MODULE['CHANGE_CLASS']['RESET_QUESTS'] == TRUE ? ", Quest = cast(REPLICATE(char(0xff),".$quests.") as varbinary(".$quests."))" : NULL)."
    ".($PANELUSER_MODULE['CHANGE_CLASS']['RESET_SKILLS'] == TRUE ? ", MagicList = cast(REPLICATE(char(0xff),".$magics.") as varbinary(".$magics."))" : NULL)."
    WHERE Name='". $_GET['character'] ."'");

    if(MUSERVER_TEAM == 1 && VESION_MUSERVER == 5)
    {
    $this->query("DELETE FROM ".DATABASE_CHARACTERS.".dbo.MasterSkillTree WHERE Name = '". $_GET['character'] ."'");
    }

    $tempRepost .= "<div class='qdestaques2'>".LDPU_CHANGE_CLASS_SUCCESS."</div>";
    $this->writeLog(12, $_SESSION['LOGIN'], $_GET['character'], LDPU_CHANGE_CLASS_SUCCESS_LOG.": {$_POST['newclass']}");
    $this->query("EXEC [dbo].[webPanelAction_ChargeClass] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsRedistributePoints()
    {
    global $ldTpl;
    global $PANELUSER_MODULE, $CLASS_CHARACTERS;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT LevelUpPoint,Strength,Dexterity,Vitality,Energy,Le adership,Class FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    $this->totalPoints = ($findCharacters->LevelUpPoint + $findCharacters->Strength + $findCharacters->Dexterity + $findCharacters->Vitality + $findCharacters->Energy)-120;
    if($findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['DL'][0] || $findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['LE'][0]) $this->totalPoints += ($findCharacters->Leadership-30);
    if($_GET['Write'] == false)
    {
    $tempRepost .= "<div class='quadros'>
    <em>".LDPU_REDISTRIBUTE_POINTS_CHARACTER.":</em> <strong>". $_GET['character'] ."</strong> <br />
    <em>".LDPU_REDISTRIBUTE_POINTS_LEVEL_UP_POINTS." :</em> <strong>". $findCharacters->LevelUpPoint ."</strong> <br />
    <em>".LDPU_REDISTRIBUTE_POINTS_STRENGTH.":</em> <strong>". $findCharacters->Strength ."</strong> <br />
    <em>".LDPU_REDISTRIBUTE_POINTS_DEXTERITY.":</em> <strong>". $findCharacters->Dexterity ."</strong> <br />
    <em>".LDPU_REDISTRIBUTE_POINTS_VITALITY.":</em> <strong>". $findCharacters->Vitality ."</strong> <br />
    <em>".LDPU_REDISTRIBUTE_POINTS_ENERGY.":</em> <strong>". $findCharacters->Energy ."</strong> <br />";
    if($findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['DL'][0] || $findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['LE'][0]) $tempRepost .= "<em>".LDPU_REDISTRIBUTE_POINTS_LEADERSHIP.":</em> <strong>". $findCharacters->Leadership ."</strong> <br />";
    $tempRepost .= "<em>".LDPU_REDISTRIBUTE_POINTS_TOTAL_POINTS." :</em> <strong>". $this->totalPoints ."</strong> <br />
    <input type='button' class='button' value='".LDPU_REDISTRIBUTE_POINTS_SUBMIT."' onclick="javascript: window.location='?page=paneluser&amp;option=REDIST RIBUTE_POINTS&amp;character=".urlencode($_GET['character'])."&amp;Write=true'" />
    </div>";
    }
    else
    {
    if($findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['DL'][0] || $findCharacters->Class == $CLASS_CHARACTERS['CLASSCODES']['LE'][0]) $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET LevelUpPoint = ".$this->totalPoints.",Strength = 30,Dexterity = 30,Vitality = 30,Energy = 30, Leadership = 30 WHERE Name='".$_GET['character']."'");
    else $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET LevelUpPoint = ".$this->totalPoints.",Strength = 30,Dexterity = 30,Vitality = 30,Energy = 30 WHERE Name='".$_GET['character']."'");
    $tempRepost .= "<div class='qdestaques2'>".LDPU_REDISTRIBUTE_POINTS_SUC CESS."</div>";
    $this->writeLog(13, $_SESSION['LOGIN'], $_GET['character'], "");
    $this->query("EXEC [dbo].[webPanelAction_RedistributePoints] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsCleanInventory()
    {
    global $ldTpl;
    global $PANELUSER_MODULE;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT LevelUpPoint,Strength,Dexterity,Vitality,Energy,Le adership,Class FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    $this->totalPoints = ($findCharacters->LevelUpPoint + $findCharacters->Strength + $findCharacters->Dexterity + $findCharacters->Vitality + $findCharacters->Energy)-120;
    if($findCharacters->Class == 64 || $findCharacters->Class == 65) $this->totalPoints += ($findCharacters->Leadership-30);
    if($_GET['Write'] == false)
    {
    $tempRepost .= "<div class='quadros'>
    <form action='?page=paneluser&amp;option=CLEAN_INVENTORY &amp;character=". urlencode($_GET['character']) ."&amp;Write=true' method='post'>
    <table width='100%' border='0'>
    <tr>
    <td align='center' colspan='2'><em>".LDPU_CLEAN_INVENTORY_CHARACTER." :</em> <strong>". $_GET['character'] ."</strong></td>
    </tr>
    <tr>
    <td align='right' width='50%'><strong>".LDPU_CLEAN_INVENTORY_ERASE_I TEMS.":</strong></td>
    <td><select name='clear_itens'><option value='0'>".LDPU_NOT."</option><option value='1'>".LDPU_YES."</option></select></td>
    </tr>
    <tr>
    <td align='right'><strong>".LDPU_CLEAN_INVENTORY_ERASE _MAGICS.":</strong></td>
    <td><select name='clear_magics'><option value='0'>".LDPU_NOT."</option><option value='1'>".LDPU_YES."</option></select></td>
    </tr>
    <tr>
    <td align='right'><strong>".LDPU_CLEAN_INVENTORY_ERASE _ZEN.":</strong></td>
    <td><select name='clear_zen'><option value='0'>".LDPU_NOT."</option><option value='1'>".LDPU_YES."</option></select></td>
    </tr>
    <tr>
    <td align='right'><strong>".LDPU_CLEAN_INVENTORY_PASSW ORD.":</strong></td>
    <td><input name='password' type='password' size='10'></td>
    </tr>
    <tr>
    <td align='center' colspan='2'><input type='submit' class='button' value='".LDPU_CLEAN_INVENTORY_SUBMIT."' /></td>
    </tr>
    </table>
    </form>
    </div>";
    }
    else
    {
    $checkPwdQ = $this->query('exec dbo.webVerifyLogin "'. $_SESSION['LOGIN'] .'","'. $_POST['password'] .'","'. USE_MD5 .'"');
    $checkPwd = mssql_fetch_row($checkPwdQ);
    if($checkPwd[0] == 0) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CLEAN_INVENTORY_INVAL ID_PASSWORD."</strong></div>";
    elseif($_POST['clear_itens'] == 0 && $_POST['clear_magics'] == 0 && $_POST['clear_zen'] == 0) $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CLEAN_INVENTORY_SELEC T_THING."</strong></div>";
    else {
    if($_POST['clear_itens'] == 1) {
    switch(VESION_MUSERVER)
    {
    case 0: case 1:
    $F = str_pad($F, 760*2, "F"); break;
    case 2: case 3: case 4: case 5:
    $F = str_pad($F, 1728*2, "F"); break;
    case 6:
    $F = str_pad($F, 3776*2, "F"); break;
    }
    $option_query_stat = "UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET Inventory=0x$F WHERE Name = '". $_GET['character'] ."'";
    if($this->query($option_query_stat)) {
    $tempRepost .= sprintf("<div class='qdestaques2'><strong style='color:#008040'>".LDPU_CLEAN_INVENTORY_SUCCE SS_ITEM_CLEAR."</strong></div>", $_GET['character']);
    $this->writeLog(14, $_SESSION['LOGIN'], $_GET['character'], LDPU_CLEAN_INVENTORY_SUCCESS_ITEM_CLEAR_LOG);
    } else $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CLEAN_INVENTORY_ERROR _ITEM_CLEAR."</strong></div>";
    }
    if($_POST['clear_magics'] == 1) {
    $F = str_pad($F, 180*2, "F");
    $option_query_stat = "UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET MagicList=0x$F WHERE Name = '". $_GET['character'] ."'";
    if($this->query($option_query_stat))
    {
    $tempRepost .= sprintf("<div class='qdestaques2'><strong style='color:#008040'>".LDPU_CLEAN_INVENTORY_SUCCE SS_MAGICS_CLEAR."</strong></div>", $_GET['character']);
    $this->writeLog(14, $_SESSION['LOGIN'], $_GET['character'], LDPU_CLEAN_INVENTORY_SUCCESS_MAGICS_CLEAR_LOG);
    }
    else $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CLEAN_INVENTORY_ERROR _MAGICS_CLEAR."</strong></div>";
    }
    if($_POST['clear_zen'] == 1) {
    $option_query_stat = "UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET Money=0 WHERE Name = '". $_GET['character'] ."'";
    if($this->query($option_query_stat))
    {
    $tempRepost .= sprintf("<div class='qdestaques2'><strong style='color:#008040'>".LDPU_CLEAN_INVENTORY_SUCCE SS_ZEN_CLEAR."</strong></div>", $_GET['character']);
    $this->writeLog(14, $_SESSION['LOGIN'], $_GET['character'], LDPU_CLEAN_INVENTORY_SUCCESS_ZEN_CLEAR_LOG);
    }
    else $tempRepost .= "<div class='qdestaques'><strong style='color:#BB0000'>".LDPU_CLEAN_INVENTORY_ERROR _ZEN_CLEAR."</strong></div>";
    }
    $this->query("EXEC [dbo].[webPanelAction_CleanInventory] '". $_SESSION['LOGIN'] ."', '".$_GET['character']."'");
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsManagerPhoto()
    {
    global $ldTpl;
    global $PANELUSER_MODULE;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if(empty($_GET['character']) == false)
    {
    $findCharactersQ = $this->query("SELECT image FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    if($this->checkOnlineAccount($_SESSION['LOGIN']) == 1) $tempRepost .= "<div class='qdestaques2'>".LDPU_YOU_MUST_BE_OFFLINE."</div>";
    elseif(mssql_num_rows($findCharactersQ) == 0) $tempRepost .= "<div class='quadros'>".LDPU_THIS_CHARACTER_NOT_EXIST."</div>";
    else
    {
    $findCharacters = mssql_fetch_object($findCharactersQ);
    if(empty($findCharacters->image) == true) $this->photo = "modules/uploads/photos/nophoto.jpg"; else $this->photo = "modules/uploads/photos/".$findCharacters->image;
    if($_GET['Write'] == false)
    {
    $tempRepost .= "<div class='quadros'>
    <form action='?page=paneluser&amp;option=MANAGER_PHOTO&a mp;character=". urlencode($_GET['character']) ."&amp;Write=true' method='post' enctype='multipart/form-data'>
    <table width='100%'>
    <tr>
    <td colspan='2' align='center'><em>".LDPU_MPHOTO_CHARACTER.":</em> <strong>{$_GET["character"]}</strong></td>
    </tr>
    <tr>
    <td width='34%' align='center'>".LDPU_MPHOTO_CURRENT_PHOTO.": <br />
    <img src='{$this->photo}' alt='' width='100' height='100' style='border: 2px solid #222222;' /></td>
    <td width='66%' align='left'>
    ".LDPU_MPHOTO_REFRESH_PHOTO.": <br />
    <input type='file' name='photo' /><br />
    <input type='submit' class='button' value='".LDPU_MPHOTO_SUBMIT."' />
    </td>
    </tr>
    </table>
    </form>
    </div>";
    }
    else
    {
    $this->photo = $_FILES['photo'];
    if(empty($this->photo['name']) == true) return $ldTpl->set("RespostWrite", "<div class='qdestaques2'>".LDPU_MPHOTO_CHOOSE_PHOTO."</div>");
    elseif($this->photo['error'] != 0) return $ldTpl->set("RespostWrite", "<div class='qdestaques'>".LDPU_MPHOTO_UPLOAD_ERROR." {$this->photo['error']}</div>");
    elseif($this->photo['size'] > 500000) return $ldTpl->set("RespostWrite", "<div class='qdestaques'>".LDPU_MPHOTO_MAX_SIZE."</div>");
    elseif(preg_match("/^image\/(pjpeg|jpeg|png|gif|bmp)$/i", $this->photo['type']) == false) return $ldTpl->set("RespostWrite", "<div class='qdestaques'>".LDPU_MPHOTO_INVALID_TYPE."</div>");
    else
    {
    switch($this->photo['type'])
    {
    case 'image/jpeg': case 'image/jpg': $this->ext = ".jpg"; break;
    case 'image/bmp': $this->ext = ".bmp"; break;
    case 'image/gif': $this->ext = ".gif"; break;
    case 'image/png': $this->ext = ".png"; break;
    default: return $ldTpl->set("RespostWrite", "<div class='qdestaques'>".LDPU_MPHOTO_INVALID_TYPE.".</div>");
    }
    $this->tmp_name = time().$_GET['character'].$this->ext;
    move_uploaded_file($this->photo['tmp_name'], "modules/uploads/photos/".$this->tmp_name);
    if(empty($findCharacters->image) == false) @unlink("modules/uploads/photos/".$findCharacters->image);
    $this->query("UPDATE ".DATABASE_CHARACTERS.".dbo.Character SET image = '{$this->tmp_name}' WHERE AccountID='". $_SESSION['LOGIN'] ."' AND Name='". $_GET['character'] ."'");
    $tempRepost = "<div class='qdestaques2'>".LDPU_MPHOTO_SUCCESS."</div>";
    }
    }
    }
    }
    $ldTpl->set("RespostWrite", $tempRepost);
    }
    private function loadOptionsBuyVips()
    {
    global $ldTpl, $PANELUSER_MODULE, $TABLES_CONFIGS;

    $findAmountCashQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBCASH']['columnAmount']." as amount FROM ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");
    $findAmountCash = mssql_fetch_object($findAmountCashQ);
    $ldTpl->set("CASH_AMOUNT", $findAmountCash->amount);

    $ldTpl->set("CASH_AMOUNT_VIPSILVER_30_DAYS",$PANELUSER_MO DULE['BUY_VIPS']['PRICE']['VIP_1'][0]);
    $ldTpl->set("CASH_AMOUNT_VIPSILVER_90_DAYS",$PANELUSER_MO DULE['BUY_VIPS']['PRICE']['VIP_1'][1]);
    $ldTpl->set("CASH_AMOUNT_VIPSILVER_180_DAYS",$PANELUSER_M ODULE['BUY_VIPS']['PRICE']['VIP_1'][2]);
    $ldTpl->set("CASH_AMOUNT_VIPSILVER_365_DAYS",$PANELUSER_M ODULE['BUY_VIPS']['PRICE']['VIP_1'][3]);

    $ldTpl->set("CASH_AMOUNT_VIPGOLD_30_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_2'][0]);
    $ldTpl->set("CASH_AMOUNT_VIPGOLD_90_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_2'][1]);
    $ldTpl->set("CASH_AMOUNT_VIPGOLD_180_DAYS",$PANELUSER_MOD ULE['BUY_VIPS']['PRICE']['VIP_2'][2]);
    $ldTpl->set("CASH_AMOUNT_VIPGOLD_365_DAYS",$PANELUSER_MOD ULE['BUY_VIPS']['PRICE']['VIP_2'][3]);

    $ldTpl->set("CASH_AMOUNT_VIP3_30_DAYS",$PANELUSER_MODUL E['BUY_VIPS']['PRICE']['VIP_3'][0]);
    $ldTpl->set("CASH_AMOUNT_VIP3_90_DAYS",$PANELUSER_MODUL E['BUY_VIPS']['PRICE']['VIP_3'][1]);
    $ldTpl->set("CASH_AMOUNT_VIP3_180_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_3'][2]);
    $ldTpl->set("CASH_AMOUNT_VIP3_365_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_3'][3]);

    $ldTpl->set("CASH_AMOUNT_VIP4_30_DAYS",$PANELUSER_MODUL E['BUY_VIPS']['PRICE']['VIP_4'][0]);
    $ldTpl->set("CASH_AMOUNT_VIP4_90_DAYS",$PANELUSER_MODUL E['BUY_VIPS']['PRICE']['VIP_4'][1]);
    $ldTpl->set("CASH_AMOUNT_VIP4_180_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_4'][2]);
    $ldTpl->set("CASH_AMOUNT_VIP4_365_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_4'][3]);

    $ldTpl->set("CASH_AMOUNT_VIP5_30_DAYS",$PANELUSER_MODUL E['BUY_VIPS']['PRICE']['VIP_5'][0]);
    $ldTpl->set("CASH_AMOUNT_VIP5_90_DAYS",$PANELUSER_MODUL E['BUY_VIPS']['PRICE']['VIP_5'][1]);
    $ldTpl->set("CASH_AMOUNT_VIP5_180_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_5'][2]);
    $ldTpl->set("CASH_AMOUNT_VIP5_365_DAYS",$PANELUSER_MODU LE['BUY_VIPS']['PRICE']['VIP_5'][3]);

    if($_GET['Write'] == true)
    {
    $vip = explode(":", $_POST['vip']);
    switch($vip[0])
    {
    case 1:
    if($PANELUSER_MODULE['BUY_VIPS']['ACTIVES']["VIP_1"] == false) $error = "<div class='qdestaques'>".LDPU_BUY_VIP_DISABLED_TYPE."</div>";
    elseif($vip[1] == 30) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_1'][0];
    elseif($vip[1] == 90) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_1'][1];
    elseif($vip[1] == 180) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_1'][2];
    elseif($vip[1] == 365) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_1'][3];
    else $error = "<div class='qdestaques'>".LDPU_BUY_VIP_ERROR_TIME."</div>";
    break;
    case 2:
    if($PANELUSER_MODULE['BUY_VIPS']['ACTIVES']["VIP_2"] == false) $error = "<div class='qdestaques'>".LDPU_BUY_VIP_DISABLED_TYPE."</div>";
    elseif($vip[1] == 30) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_2'][0];
    elseif($vip[1] == 90) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_2'][1];
    elseif($vip[1] == 180) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_2'][2];
    elseif($vip[1] == 365) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_2'][3];
    else $error = "<div class='qdestaques'>".LDPU_BUY_VIP_ERROR_TIME."</div>";
    break;
    case 3:
    if($PANELUSER_MODULE['BUY_VIPS']['ACTIVES']["VIP_3"] == false) $error = "<div class='qdestaques'>".LDPU_BUY_VIP_DISABLED_TYPE."</div>";
    elseif($vip[1] == 30) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_3'][0];
    elseif($vip[1] == 90) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_3'][1];
    elseif($vip[1] == 180) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_3'][2];
    elseif($vip[1] == 365) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_3'][3];
    else $error = "<div class='qdestaques'>".LDPU_BUY_VIP_ERROR_TIME."</div>";
    break;
    case 4:
    if($PANELUSER_MODULE['BUY_VIPS']['ACTIVES']["VIP_4"] == false) $error = "<div class='qdestaques'>".LDPU_BUY_VIP_DISABLED_TYPE."</div>";
    elseif($vip[1] == 30) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_4'][0];
    elseif($vip[1] == 90) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_4'][1];
    elseif($vip[1] == 180) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_4'][2];
    elseif($vip[1] == 365) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_4'][3];
    else $error = "<div class='qdestaques'>".LDPU_BUY_VIP_ERROR_TIME."</div>";
    break;
    case 5:
    if($PANELUSER_MODULE['BUY_VIPS']['ACTIVES']["VIP_5"] == false) $error = "<div class='qdestaques'>".LDPU_BUY_VIP_DISABLED_TYPE."</div>";
    elseif($vip[1] == 30) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_5'][0];
    elseif($vip[1] == 90) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_5'][1];
    elseif($vip[1] == 180) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_5'][2];
    elseif($vip[1] == 365) $this->priceVip = $PANELUSER_MODULE['BUY_VIPS']['PRICE']['VIP_5'][3];
    else $error = "<div class='qdestaques'>".LDPU_BUY_VIP_ERROR_TIME."</div>";
    break;
    default: $error = "<div class='qdestaques'>".LDPU_BUY_VIP_ERROR_TIME."</div>";
    }

    if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 6)
    {
    $checkMemberVipQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." as dateend FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='".$_SESSION['LOGIN']."'");
    }
    else
    {
    $checkMemberVipQ = $this->query("SELECT ".$TABLES_CONFIGS['WEBVIPS']['columnType']." as type, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." as dateend FROM ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='".$_SESSION['LOGIN']."'");
    }

    $checkMemberVip = mssql_fetch_object($checkMemberVipQ);

    if(isset($error))
    $tempRespost .= $error;
    elseif($this->priceVip > $findAmountCash->amount)
    $tempRespost .= "<div class='qdestaques'>".LDPU_BUY_VIP_NOT_HAVE_CASH."</div>";
    elseif((int)$checkMemberVip->type > 0 && $vip[0] != $checkMemberVip->type)
    $tempRespost .= sprintf("<div class='qdestaques'>".LDPU_BUY_VIP_YOU_IS_VIP."</div>", $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][$checkMemberVip->type], $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][$vip[0]], $PANELUSER_MODULE['BUY_VIPS']['NAME_FLATS'][$checkMemberVip->type]);
    else
    {
    if((int)$checkMemberVip->type > 0)
    {
    $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount']."-".$this->priceVip." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");

    if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 6)
    {
    $newTimeEnd = "DATEADD(day, ".$vip[1].", ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd'].")";
    $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']."=".$newTimeEnd." WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='".$_SESSION['LOGIN']."'");
    }
    else
    {
    $newTimeStamp = strtotime(date("d-m-Y g:i a",$checkMemberVip->dateend)." + ".$vip[1] ." days");
    $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']."='".$newTimeStamp."' WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='".$_SESSION['LOGIN']."'");
    }

    $tempRespost .= sprintf("<div class='qdestaques2'>".LDPU_BUY_VIP_SUCCESS."</em></div>", date("d-m-Y g:i a",$newTimeStamp));
    }
    else
    {
    $this->query("UPDATE ".$TABLES_CONFIGS['WEBCASH']['database'].".dbo.".$TABLES_CONFIGS['WEBCASH']['table']." SET ".$TABLES_CONFIGS['WEBCASH']['columnAmount']."=".$TABLES_CONFIGS['WEBCASH']['columnAmount']."-".$this->priceVip." WHERE ".$TABLES_CONFIGS['WEBCASH']['columnUsername']."='".$_SESSION['LOGIN']."'");

    if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 6)
    {
    $newTimeEnd = "DATEADD(day, ".$vip[1].", getdate())";

    $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET
    ".$TABLES_CONFIGS['WEBVIPS']['columnType']." = ".$vip[0].",
    ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." = ".$newTimeEnd."
    WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='".$_SESSION['LOGIN']."'");
    }
    else
    {
    $timeStampBegin = strtotime("now");
    $timeStampEnd = strtotime("+ ".$vip[1] ." days");

    $this->query("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET
    ".$TABLES_CONFIGS['WEBVIPS']['columnType']." = ".$vip[0].",
    ".$TABLES_CONFIGS['WEBVIPS']['columnDateBegin']."='".$timeStampBegin."',
    ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']."='".$timeStampEnd."'
    WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnUsername']."='".$_SESSION['LOGIN']."'");
    }

    //$this->query("INSERT INTO dbo.webVips (username,type,datebegin,dateend) VALUES ('".$_SESSION['LOGIN']."',".$vip[0].",'".$timeStampBegin."','".$timeStampEnd."')") ;
    $tempRespost .= sprintf("<div class='qdestaques2'>".LDPU_BUY_VIP_SUCCESS."</em></div>", date("d-m-Y g:i a",$timeStampEnd));
    }
    $this->query("INSERT INTO dbo.webLogBuyVips (username,type,cashAmount,days,date) VALUES ('".$_SESSION['LOGIN']."',".$vip[0].",".$this->priceVip.",".$vip[1].",'".strtotime("now")."')");
    }
    }
    $ldTpl->set("RespostWrite", $tempRespost);
    }
    private function loadOptionsConfirmPayment()
    {
    global $ldTpl, $PANELUSER_MODULE;
    if($_GET['Write'] == true)
    {
    $check = $this->query("SELECT count(1) [count] FROM [dbo].[webLogBuyCash] WHERE [username] = '". $_SESSION['LOGIN'] ."' and [status] = 0");
    $check = mssql_fetch_object($check);
    if($check->count >= $PANELUSER_MODULE['CONFIRM_PAYMENT']['MAX_OPEN'])
    $this->Check_List_Error .= sprintf("<ul><li> ". LDPU_CONFIRM_DEPOSIT_ERROR_LIMIT_CONFIRM_OPEN .". </li></ul>", $PANELUSER_MODULE['CONFIRM_PAYMENT']['MAX_OPEN']);

    if(empty($_POST['golds']) == true) $this->Check_List_Error .= "<ul><li> ".LDPU_CONFIRM_DEPOSIT_FILL_AMOUNT_CASH." ". CASH_NAME .". </li></ul>";
    if(empty($_POST['bank']) == true) $this->Check_List_Error .= "<ul><li> ".LDPU_CONFIRM_DEPOSIT_FILL_BANK." </li></ul>";
    if(empty($_POST['data']) == true) $this->Check_List_Error .= "<ul><li> ".LDPU_CONFIRM_DEPOSIT_FILL_DATE." </li></ul>";
    if(empty($_POST['hora']) == true) $this->Check_List_Error .= "<ul><li> ".LDPU_CONFIRM_DEPOSIT_FILL_HOUR." </li></ul>";
    if(empty($_POST['valor']) == true) $this->Check_List_Error .= "<ul><li> ".LDPU_CONFIRM_DEPOSIT_FILL_VALUE." </li></ul>";
    if(empty($_POST['pago_em']) == true) $this->Check_List_Error .= "<ul><li> ".LDPU_CONFIRM_DEPOSIT_FILL_PAY_IN." </li></ul>";

    if(empty($this->Check_List_Error) == false) $this->ResponseTpl = "<div class="qdestaques"><strong><em>".LDPU_CONFIRM_DEPO SIT_ERROR_FOUND.":</em></strong> <br />". $this->Check_List_Error ."</div>";
    else
    {
    if(in_array($_FILES['image']['type'], array('image/jpeg', 'image/pjpeg', 'image/png')))
    {
    $TmpUploadName = "modules/uploads/confirmBuys/". $_SESSION['LOGIN'] ."[". date("d-m-Y~G-i-s") ."].jpg";
    move_uploaded_file($_FILES['image']['tmp_name'], $TmpUploadName);
    }
    $this->ResponseTpl .= "<script type="text/javascript"> document.getElementById('FormConfirm').style.displ ay = 'none'; </script>";
    $this->query("INSERT INTO dbo.webLogBuyCash
    (username,cash,banco,nterminal,ntransferencia,agen cia_acolhedora,nsequencia,ctr,caixa_eletronico,nen velope,ndocumento,ncontrole,noperador,data,hora,pa go_em,anexo,comentario,valor,status) VALUES
    ('". $_SESSION['LOGIN'] ."', '". $_POST['golds'] ."', '". $_POST['bank'] ."', '". $_POST['nterminal'] ."', '". $_POST['ntransferencia'] ."', '". $_POST['agencia_acolhedora'] ."', '". $_POST['nsequencia'] ."', '". $_POST['ctr'] ."', '". $_POST['caixa_eletronico'] ."', '". $_POST['nenvelope'] ."', '". $_POST['ndocumento'] ."', '". $_POST['ncontrole'] ."', '". $_POST['noperador']."', '". $_POST['data'] ."', '". $_POST['hora'] ."', '". $_POST['pago_em'] ."', '". $TmpUploadName ."', '".base64_encode($_POST['comment'])."', '". $_POST['valor'] ."', 0);");
    $this->ResponseTpl .= "<div class="qdestaques">".LDPU_CONFIRM_DEPOSIT_SUCCESS. "</div>";
    }
    }
    $ldTpl->set("RespostWrite",$this->ResponseTpl);
    }
    private function loadOptionsOpenComplaints()
    {
    global $ldTpl;
    if($_GET['Write'] == true && empty($_POST['descricao']) == false)
    {
    if(in_array($_FILES['image']['type'], array('image/jpeg', 'image/pjpeg', 'image/png')))
    {
    $TmpUploadName = "modules/uploads/complaints/". $_SESSION['LOGIN'] ."[". date("d-m-Y~G-i-s") ."].jpg";
    move_uploaded_file($_FILES['image']['tmp_name'], $TmpUploadName);
    $this->query("INSERT INTO dbo.webComplaints (username,image,description,date,ip,status) VALUES ('".$_SESSION['LOGIN']."','". $TmpUploadName ."','".base64_encode($_POST['descricao'])."','".time()."','".$_SERVER['REMOTE_ADDR']."',0)");
    $tempResult .= "<div class='qdestaques2'>".LDPU_COMPLAINT_SUCCESS."</div>";
    }
    else
    $tempResult .= "<div class='qdestaques'>".LDPU_COMPLAINT_INVALID_FILE." </div>";
    }
    $ldTpl->set("RespostWrite", $tempResult);
    }
    private function loadOptionsOpenTicket()
    {
    global $ldTpl, $PANELUSER_MODULE;
    $findCharactersQ = $this->query("SELECT Name FROM ".DATABASE_CHARACTERS.".dbo.Character WHERE AccountID='". $_SESSION['LOGIN'] ."'");
    while($findCharacters = mssql_fetch_object($findCharactersQ)){
    $tempOption .= "<option value="".urlencode($findCharacters->Name)."">". $findCharacters->Name ."</option>";
    }
    $ldTpl->set("CHARACTER_LIST_TAG_OPTION", $tempOption);
    unset($tempOption);

    if($_GET['Write'] == true)
    {
    $this->checkTicketsOpenQ = $this->query("SELECT count(1) as count FROM dbo.webTickets WHERE username='{$_SESSION['LOGIN']}' AND status = 0");
    $this->checkTicketsOpen = mssql_fetch_object($this->checkTicketsOpenQ);
    if($this->checkTicketsOpen->count >= $PANELUSER_MODULE['OPEN_TICKET']['MAX_OPEN'])
    $tempResult .= sprintf("<div class='qdestaques2'>".LDPU_OPEN_TICKET_MAX_TICKET_ OPEN."</div>", $PANELUSER_MODULE['OPEN_TICKET']['MAX_OPEN']);
    else
    {
    $this->query("INSERT INTO dbo.webTickets (username,character,sector,subject,description,dat e,ip,status) VALUES ('". $_SESSION['LOGIN'] ."','".$_POST['character']."','".$_POST['sector']."','".base64_encode($_POST['subject'])."','".base64_encode($_POST['description'])."','".time()."','".$_SERVER['REMOTE_ADDR']."',0)");
    $tempResult .= "<div class='qdestaques2'>".LDPU_OPEN_TICKET_SUCCESS."</div>";
    }
    }
    $ldTpl->set("RespostWrite", $tempResult);
    }
    private function loadOptionsReadTicket()
    {
    global $ldTpl;
    if(isset($_GET['Ticket']) == false)
    {
    $sqlQ = $this->query("SELECT id,subject,date,status FROM dbo.webTickets WHERE username='".$_SESSION['LOGIN']."' ORDER By id DESC");
    while($sql = mssql_fetch_object($sqlQ))
    {
    $tempResult .= "<div class='quadros'><em>".LDPU_READ_TICKET_TEXT_ID."</em>: <strong>".$sql->id."</strong><br /><em>".LDPU_READ_TICKET_TEXT_SUBJECT."</em>: <strong>".base64_decode($sql->subject)."</strong><br /><em>".LDPU_READ_TICKET_TEXT_DATE."</em>: <strong>".date("d/m/Y g:i a",$sql->date)."</strong><br /><em>".LDPU_READ_TICKET_TEXT_STATUS."</em>: <strong>".($sql->status == 0 ? LDPU_READ_TICKET_TEXT_STATUS_OPEN:LDPU_READ_TICKET _TEXT_STATUS_CLOSE)."</strong><br /><a href='?page=paneluser&amp;option=READ_TICKET&amp;T icket=".$sql->id."'>".LDPU_READ_TICKET_TEXT_VIEW_TICKET."</a></div>";
    }
    }
    else
    {
    $sqlQ = $this->query("SELECT id,subject,description,date,status FROM dbo.webTickets WHERE username='".$_SESSION['LOGIN']."' AND id=".(int)$_GET['Ticket']." ORDER By id DESC");
    $sql = mssql_fetch_object($sqlQ);
    $ticketStatus = $sql->status;
    if($_GET['Write'] == true && empty($_POST['answer']) == false && $sql->status == 0) $this->query("INSERT INTO dbo.webTicketsAnswers (id,description,answerBy,date) VALUES (".(int)$_GET['Ticket'].",'".base64_encode($_POST['answer'])."','Player','".time()."');");
    if(mssql_num_rows($sqlQ) == 0) $tempResult .= LDPU_READ_TICKET_TEXT_TICKET_NOT_FOUND;
    else
    {
    $tempResult .= "<em>".LDPU_READ_TICKET_TEXT_ID."</em>: <strong>".$_GET['Ticket']."</strong><br />
    <em>".LDPU_READ_TICKET_TEXT_SUBJECT."</em>: <strong>".base64_decode($sql->subject)."</strong><br />
    <em>".LDPU_READ_TICKET_TEXT_DESCRIPTION."</em>: <strong>".nl2br(base64_decode($sql->description))."</strong><br />
    <em>".LDPU_READ_TICKET_TEXT_STATUS."</em>: ".($sql->status == 0 ? "<strong>".LDPU_READ_TICKET_TEXT_STATUS_OPEN." </strong>":"<strong>".LDPU_READ_TICKET_TEXT_STATUS_C LOSE."</strong>");
    $tempResult .= "<h1>".LDPU_READ_TICKET_TEXT_HISTORY."</h1>";
    $sqlQ = $this->query("SELECT * FROM dbo.webTicketsAnswers WHERE id='".$_GET['Ticket']."' ORDER BY date DESC");
    if(mssql_num_rows($sqlQ) == 0) $tempResult .= "<div class='quadros'>".LDPU_READ_TICKET_TEXT_NO_HISTORY ."</div>";
    while($sql = mssql_fetch_object($sqlQ))
    {
    $tempResult .= "<div class='quadros'><em>".LDPU_READ_TICKET_TEXT_RESPON SE_BY."</em>: <strong>".$sql->answerBy."</strong><br /><em>".LDPU_READ_TICKET_TEXT_DATE."</em>: <strong>".date("d/m/Y g:i a",$sql->date)."</strong><br /><em>".LDPU_READ_TICKET_TEXT_DESCRIPTION."</em>: <strong>".nl2br(base64_decode($sql->description))."</strong><br /></div>";
    }
    if($ticketStatus == 0) $tempResult .= "<form action='?page=paneluser&amp;option=READ_TICKET&amp ;Ticket=".$_GET['Ticket']."&amp;Write=true' method='post'><em>".LDPU_READ_TICKET_TEXT_SEND_RES PONSE.":</em><textarea name='answer'></textarea><input type='submit' class='button' value='".LDPU_READ_TICKET_TEXT_SUBMIT."' /></form>";
    }
    }
    $ldTpl->set("RespostWrite1", $tempResult);
    }
    private function loadOptionsSendSMS()
    {
    global $ldTpl;
    global $Config_SMS;
    global $Config_SMS_Subject;
    global $Config_SMTP;
    for($SMS_Number_Count = 0; $SMS_Number_Count < sizeof($Config_SMS); $SMS_Number_Count++) {
    $tempResponse .= "<input type='radio' name='para' value='".$Config_SMS[$SMS_Number_Count]['Number_Cel_DDD'].$Config_SMS[$SMS_Number_Count]['Number_Cel'].$Config_SMS[$SMS_Number_Count]['Email_Sufixo']."' /> ".$Config_SMS[$SMS_Number_Count]['Name']."<br/>";
    }
    $ldTpl->set("INPUT_RADIOS_NUMBERS",$tempResponse);
    $ldTpl->set("MAXLENGHT", 130-strlen($_SESSION['LOGIN'])-strlen($Config_SMTP['From'])-strlen($Config_SMS_Subject)-2);
    unset($tempResponse);
    if($_GET['Write'] == true)
    {
    date_default_timezone_set("America/Sao_Paulo");
    $mail = new PHPMailer();

    $body .= $_SESSION['LOGIN'].",".$_POST['mensagem'];

    $body = eregi_replace("[\]",'',$body);

    $mail->IsSMTP();
    $mail->SMTPDebug = $Config_SMTP['Debug'];
    $mail->Host = $Config_SMTP['Server'];
    $mail->From = $Config_SMTP['From'];
    $mail->Port = $Config_SMTP['Port'];
    $mail->Username = $Config_SMTP['User'];
    $mail->Password = $Config_SMTP['Password'];
    //$mail->FromName = 'SMS';
    $mail->Subject = $Config_SMS_Subject;

    $mail->MsgHTML($body);

    $mail->AddAddress($_POST['para']);

    if(!$mail->Send()) $Status_send = "<strong>".LDPU_SEND_SMS_ERROR."</strong>";
    else $Status_send = "<strong>".LDPU_SEND_SMS_SUCCESS."</strong>";

    $tempResponse = "<div class='qdestaques2'>".$Status_send."</div>";
    $this->writeLog(15, $_SESSION['LOGIN'], "", $_POST['mensagem']);
    }
    $ldTpl->set("RespostWrite",$tempResponse);
    }
    private function setPermissions()
    {
    global $ldTpl;
    global $PANELUSER_PREMISSIONS;
    $ldTpl->set("MODIFY_DATA_HABILIT", $PANELUSER_PREMISSIONS['MODIFY_DATA'][0]);
    $ldTpl->set("MODIFY_DATA_FREE", $PANELUSER_PREMISSIONS['MODIFY_DATA'][1]);
    $ldTpl->set("MODIFY_DATA_VIP_S", $PANELUSER_PREMISSIONS['MODIFY_DATA'][2]);
    $ldTpl->set("MODIFY_DATA_VIP_G", $PANELUSER_PREMISSIONS['MODIFY_DATA'][3]);
    $ldTpl->set("MODIFY_DATA_VIP_3", $PANELUSER_PREMISSIONS['MODIFY_DATA'][4]);
    $ldTpl->set("MODIFY_DATA_VIP_4", $PANELUSER_PREMISSIONS['MODIFY_DATA'][5]);
    $ldTpl->set("MODIFY_DATA_VIP_5", $PANELUSER_PREMISSIONS['MODIFY_DATA'][6]);

    $ldTpl->set("CLEAN_VAULT_HABILIT", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][0]);
    $ldTpl->set("CLEAN_VAULT_FREE", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][1]);
    $ldTpl->set("CLEAN_VAULT_VIP_S", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][2]);
    $ldTpl->set("CLEAN_VAULT_VIP_G", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][3]);
    $ldTpl->set("CLEAN_VAULT_VIP_3", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][4]);
    $ldTpl->set("CLEAN_VAULT_VIP_4", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][5]);
    $ldTpl->set("CLEAN_VAULT_VIP_5", $PANELUSER_PREMISSIONS['CLEAN_VAULT'][6]);

    $ldTpl->set("DOUBLE_VAULT_HABILIT", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][0]);
    $ldTpl->set("DOUBLE_VAULT_FREE", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][1]);
    $ldTpl->set("DOUBLE_VAULT_VIP_S", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][2]);
    $ldTpl->set("DOUBLE_VAULT_VIP_G", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][3]);
    $ldTpl->set("DOUBLE_VAULT_VIP_3", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][4]);
    $ldTpl->set("DOUBLE_VAULT_VIP_4", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][5]);
    $ldTpl->set("DOUBLE_VAULT_VIP_5", $PANELUSER_PREMISSIONS['DOUBLE_VAULT'][6]);

    $ldTpl->set("VIRTUAL_VAULT_HABILIT", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][0]);
    $ldTpl->set("VIRTUAL_VAULT_FREE", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][1]);
    $ldTpl->set("VIRTUAL_VAULT_VIP_S", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][2]);
    $ldTpl->set("VIRTUAL_VAULT_VIP_G", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][3]);
    $ldTpl->set("VIRTUAL_VAULT_VIP_3", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][4]);
    $ldTpl->set("VIRTUAL_VAULT_VIP_4", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][5]);
    $ldTpl->set("VIRTUAL_VAULT_VIP_5", $PANELUSER_PREMISSIONS['VIRTUAL_VAULT'][6]);

    $ldTpl->set("GAME_DISCONNECT_HABILIT", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][0]);
    $ldTpl->set("GAME_DISCONNECT_FREE", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][1]);
    $ldTpl->set("GAME_DISCONNECT_VIP_S", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][2]);
    $ldTpl->set("GAME_DISCONNECT_VIP_G", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][3]);
    $ldTpl->set("GAME_DISCONNECT_VIP_3", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][4]);
    $ldTpl->set("GAME_DISCONNECT_VIP_4", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][5]);
    $ldTpl->set("GAME_DISCONNECT_VIP_5", $PANELUSER_PREMISSIONS['GAME_DISCONNECT'][6]);

    $ldTpl->set("LOG_BUYS_HABILIT", $PANELUSER_PREMISSIONS['LOG_BUYS'][0]);
    $ldTpl->set("LOG_BUYS_FREE", $PANELUSER_PREMISSIONS['LOG_BUYS'][1]);
    $ldTpl->set("LOG_BUYS_VIP_S", $PANELUSER_PREMISSIONS['LOG_BUYS'][2]);
    $ldTpl->set("LOG_BUYS_VIP_G", $PANELUSER_PREMISSIONS['LOG_BUYS'][3]);
    $ldTpl->set("LOG_BUYS_VIP_3", $PANELUSER_PREMISSIONS['LOG_BUYS'][4]);
    $ldTpl->set("LOG_BUYS_VIP_4", $PANELUSER_PREMISSIONS['LOG_BUYS'][5]);
    $ldTpl->set("LOG_BUYS_VIP_5", $PANELUSER_PREMISSIONS['LOG_BUYS'][6]);

    $ldTpl->set("MODIFY_PERSONALID_HABILIT", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][0]);
    $ldTpl->set("MODIFY_PERSONALID_FREE", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][1]);
    $ldTpl->set("MODIFY_PERSONALID_VIP_S", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][2]);
    $ldTpl->set("MODIFY_PERSONALID_VIP_G", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][3]);
    $ldTpl->set("MODIFY_PERSONALID_VIP_3", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][4]);
    $ldTpl->set("MODIFY_PERSONALID_VIP_4", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][5]);
    $ldTpl->set("MODIFY_PERSONALID_VIP_5", $PANELUSER_PREMISSIONS['MODIFY_PERSONALID'][6]);

    $ldTpl->set("RESET_HABILIT", $PANELUSER_PREMISSIONS['RESET'][0]);
    $ldTpl->set("RESET_FREE", $PANELUSER_PREMISSIONS['RESET'][1]);
    $ldTpl->set("RESET_VIP_S", $PANELUSER_PREMISSIONS['RESET'][2]);
    $ldTpl->set("RESET_VIP_G", $PANELUSER_PREMISSIONS['RESET'][3]);
    $ldTpl->set("RESET_VIP_3", $PANELUSER_PREMISSIONS['RESET'][4]);
    $ldTpl->set("RESET_VIP_4", $PANELUSER_PREMISSIONS['RESET'][5]);
    $ldTpl->set("RESET_VIP_5", $PANELUSER_PREMISSIONS['RESET'][6]);

    $ldTpl->set("MASTER_RESET_HABILIT", $PANELUSER_PREMISSIONS['MASTER_RESET'][0]);
    $ldTpl->set("MASTER_RESET_FREE", $PANELUSER_PREMISSIONS['MASTER_RESET'][1]);
    $ldTpl->set("MASTER_RESET_VIP_S", $PANELUSER_PREMISSIONS['MASTER_RESET'][2]);
    $ldTpl->set("MASTER_RESET_VIP_G", $PANELUSER_PREMISSIONS['MASTER_RESET'][3]);
    $ldTpl->set("MASTER_RESET_VIP_3", $PANELUSER_PREMISSIONS['MASTER_RESET'][4]);
    $ldTpl->set("MASTER_RESET_VIP_4", $PANELUSER_PREMISSIONS['MASTER_RESET'][5]);
    $ldTpl->set("MASTER_RESET_VIP_5", $PANELUSER_PREMISSIONS['MASTER_RESET'][6]);

    $ldTpl->set("RESET_TRANSFER_HABILIT", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][0]);
    $ldTpl->set("RESET_TRANSFER_FREE", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][1]);
    $ldTpl->set("RESET_TRANSFER_VIP_S", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][2]);
    $ldTpl->set("RESET_TRANSFER_VIP_G", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][3]);
    $ldTpl->set("RESET_TRANSFER_VIP_3", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][4]);
    $ldTpl->set("RESET_TRANSFER_VIP_4", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][5]);
    $ldTpl->set("RESET_TRANSFER_VIP_5", $PANELUSER_PREMISSIONS['RESET_TRANSFER'][6]);

    $ldTpl->set("CLEAN_PK_HABILIT", $PANELUSER_PREMISSIONS['CLEAN_PK'][0]);
    $ldTpl->set("CLEAN_PK_FREE", $PANELUSER_PREMISSIONS['CLEAN_PK'][1]);
    $ldTpl->set("CLEAN_PK_VIP_S", $PANELUSER_PREMISSIONS['CLEAN_PK'][2]);
    $ldTpl->set("CLEAN_PK_VIP_G", $PANELUSER_PREMISSIONS['CLEAN_PK'][3]);
    $ldTpl->set("CLEAN_PK_VIP_3", $PANELUSER_PREMISSIONS['CLEAN_PK'][4]);
    $ldTpl->set("CLEAN_PK_VIP_4", $PANELUSER_PREMISSIONS['CLEAN_PK'][5]);
    $ldTpl->set("CLEAN_PK_VIP_5", $PANELUSER_PREMISSIONS['CLEAN_PK'][6]);

    $ldTpl->set("DISTRIBUTE_POINTS_HABILIT", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][0]);
    $ldTpl->set("DISTRIBUTE_POINTS_FREE", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][1]);
    $ldTpl->set("DISTRIBUTE_POINTS_VIP_S", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][2]);
    $ldTpl->set("DISTRIBUTE_POINTS_VIP_G", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][3]);
    $ldTpl->set("DISTRIBUTE_POINTS_VIP_3", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][4]);
    $ldTpl->set("DISTRIBUTE_POINTS_VIP_4", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][5]);
    $ldTpl->set("DISTRIBUTE_POINTS_VIP_5", $PANELUSER_PREMISSIONS['DISTRIBUTE_POINTS'][6]);

    $ldTpl->set("MOVE_CHARACTER_HABILIT", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][0]);
    $ldTpl->set("MOVE_CHARACTER_FREE", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][1]);
    $ldTpl->set("MOVE_CHARACTER_VIP_S", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][2]);
    $ldTpl->set("MOVE_CHARACTER_VIP_G", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][3]);
    $ldTpl->set("MOVE_CHARACTER_VIP_3", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][4]);
    $ldTpl->set("MOVE_CHARACTER_VIP_4", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][5]);
    $ldTpl->set("MOVE_CHARACTER_VIP_5", $PANELUSER_PREMISSIONS['MOVE_CHARACTER'][6]);

    $ldTpl->set("CHANGE_NICK_HABILIT", $PANELUSER_PREMISSIONS['CHANGE_NICK'][0]);
    $ldTpl->set("CHANGE_NICK_FREE", $PANELUSER_PREMISSIONS['CHANGE_NICK'][1]);
    $ldTpl->set("CHANGE_NICK_VIP_S", $PANELUSER_PREMISSIONS['CHANGE_NICK'][2]);
    $ldTpl->set("CHANGE_NICK_VIP_G", $PANELUSER_PREMISSIONS['CHANGE_NICK'][3]);
    $ldTpl->set("CHANGE_NICK_VIP_3", $PANELUSER_PREMISSIONS['CHANGE_NICK'][4]);
    $ldTpl->set("CHANGE_NICK_VIP_4", $PANELUSER_PREMISSIONS['CHANGE_NICK'][5]);
    $ldTpl->set("CHANGE_NICK_VIP_5", $PANELUSER_PREMISSIONS['CHANGE_NICK'][6]);

    $ldTpl->set("CHANGE_CLASS_HABILIT", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][0]);
    $ldTpl->set("CHANGE_CLASS_FREE", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][1]);
    $ldTpl->set("CHANGE_CLASS_VIP_S", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][2]);
    $ldTpl->set("CHANGE_CLASS_VIP_G", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][3]);
    $ldTpl->set("CHANGE_CLASS_VIP_3", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][4]);
    $ldTpl->set("CHANGE_CLASS_VIP_4", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][5]);
    $ldTpl->set("CHANGE_CLASS_VIP_5", $PANELUSER_PREMISSIONS['CHANGE_CLASS'][6]);

    $ldTpl->set("REDISTRIBUTE_POINTS_HABILIT", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][0]);
    $ldTpl->set("REDISTRIBUTE_POINTS_FREE", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][1]);
    $ldTpl->set("REDISTRIBUTE_POINTS_VIP_S", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][2]);
    $ldTpl->set("REDISTRIBUTE_POINTS_VIP_G", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][3]);
    $ldTpl->set("REDISTRIBUTE_POINTS_VIP_3", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][4]);
    $ldTpl->set("REDISTRIBUTE_POINTS_VIP_4", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][5]);
    $ldTpl->set("REDISTRIBUTE_POINTS_VIP_5", $PANELUSER_PREMISSIONS['REDISTRIBUTE_POINTS'][6]);

    $ldTpl->set("CLEAN_INVENTORY_HABILIT", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][0]);
    $ldTpl->set("CLEAN_INVENTORY_FREE", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][1]);
    $ldTpl->set("CLEAN_INVENTORY_VIP_S", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][2]);
    $ldTpl->set("CLEAN_INVENTORY_VIP_G", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][3]);
    $ldTpl->set("CLEAN_INVENTORY_VIP_3", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][4]);
    $ldTpl->set("CLEAN_INVENTORY_VIP_4", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][5]);
    $ldTpl->set("CLEAN_INVENTORY_VIP_5", $PANELUSER_PREMISSIONS['CLEAN_INVENTORY'][6]);

    $ldTpl->set("MANAGER_PHOTO_HABILIT", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][0]);
    $ldTpl->set("MANAGER_PHOTO_FREE", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][1]);
    $ldTpl->set("MANAGER_PHOTO_VIP_S", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][2]);
    $ldTpl->set("MANAGER_PHOTO_VIP_G", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][3]);
    $ldTpl->set("MANAGER_PHOTO_VIP_3", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][4]);
    $ldTpl->set("MANAGER_PHOTO_VIP_4", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][5]);
    $ldTpl->set("MANAGER_PHOTO_VIP_5", $PANELUSER_PREMISSIONS['MANAGER_PHOTO'][6]);

    $ldTpl->set("BUY_VIPS_HABILIT", $PANELUSER_PREMISSIONS['BUY_VIPS'][0]);
    $ldTpl->set("BUY_VIPS_FREE", $PANELUSER_PREMISSIONS['BUY_VIPS'][1]);
    $ldTpl->set("BUY_VIPS_VIP_S", $PANELUSER_PREMISSIONS['BUY_VIPS'][2]);
    $ldTpl->set("BUY_VIPS_VIP_G", $PANELUSER_PREMISSIONS['BUY_VIPS'][3]);
    $ldTpl->set("BUY_VIPS_VIP_3", $PANELUSER_PREMISSIONS['BUY_VIPS'][4]);
    $ldTpl->set("BUY_VIPS_VIP_4", $PANELUSER_PREMISSIONS['BUY_VIPS'][5]);
    $ldTpl->set("BUY_VIPS_VIP_5", $PANELUSER_PREMISSIONS['BUY_VIPS'][6]);

    $ldTpl->set("CONFIRM_PAYMENT_HABILIT", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][0]);
    $ldTpl->set("CONFIRM_PAYMENT_FREE", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][1]);
    $ldTpl->set("CONFIRM_PAYMENT_VIP_S", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][2]);
    $ldTpl->set("CONFIRM_PAYMENT_VIP_G", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][3]);
    $ldTpl->set("CONFIRM_PAYMENT_VIP_3", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][4]);
    $ldTpl->set("CONFIRM_PAYMENT_VIP_4", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][5]);
    $ldTpl->set("CONFIRM_PAYMENT_VIP_5", $PANELUSER_PREMISSIONS['CONFIRM_PAYMENT'][6]);

    $ldTpl->set("OPEN_COMPLAINTS_HABILIT", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][0]);
    $ldTpl->set("OPEN_COMPLAINTS_FREE", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][1]);
    $ldTpl->set("OPEN_COMPLAINTS_VIP_S", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][2]);
    $ldTpl->set("OPEN_COMPLAINTS_VIP_G", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][3]);
    $ldTpl->set("OPEN_COMPLAINTS_VIP_3", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][4]);
    $ldTpl->set("OPEN_COMPLAINTS_VIP_4", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][5]);
    $ldTpl->set("OPEN_COMPLAINTS_VIP_5", $PANELUSER_PREMISSIONS['OPEN_COMPLAINTS'][6]);

    $ldTpl->set("OPEN_TICKET_HABILIT", $PANELUSER_PREMISSIONS['OPEN_TICKET'][0]);
    $ldTpl->set("OPEN_TICKET_FREE", $PANELUSER_PREMISSIONS['OPEN_TICKET'][1]);
    $ldTpl->set("OPEN_TICKET_VIP_S", $PANELUSER_PREMISSIONS['OPEN_TICKET'][2]);
    $ldTpl->set("OPEN_TICKET_VIP_G", $PANELUSER_PREMISSIONS['OPEN_TICKET'][3]);
    $ldTpl->set("OPEN_TICKET_VIP_3", $PANELUSER_PREMISSIONS['OPEN_TICKET'][4]);
    $ldTpl->set("OPEN_TICKET_VIP_4", $PANELUSER_PREMISSIONS['OPEN_TICKET'][5]);
    $ldTpl->set("OPEN_TICKET_VIP_5", $PANELUSER_PREMISSIONS['OPEN_TICKET'][6]);

    $ldTpl->set("READ_TICKET_HABILIT", $PANELUSER_PREMISSIONS['READ_TICKET'][0]);
    $ldTpl->set("READ_TICKET_FREE", $PANELUSER_PREMISSIONS['READ_TICKET'][1]);
    $ldTpl->set("READ_TICKET_VIP_S", $PANELUSER_PREMISSIONS['READ_TICKET'][2]);
    $ldTpl->set("READ_TICKET_VIP_G", $PANELUSER_PREMISSIONS['READ_TICKET'][3]);
    $ldTpl->set("READ_TICKET_VIP_3", $PANELUSER_PREMISSIONS['READ_TICKET'][4]);
    $ldTpl->set("READ_TICKET_VIP_4", $PANELUSER_PREMISSIONS['READ_TICKET'][5]);
    $ldTpl->set("READ_TICKET_VIP_5", $PANELUSER_PREMISSIONS['READ_TICKET'][6]);

    $ldTpl->set("SEND_SMS_HABILIT", $PANELUSER_PREMISSIONS['SEND_SMS'][0]);
    $ldTpl->set("SEND_SMS_FREE", $PANELUSER_PREMISSIONS['SEND_SMS'][1]);
    $ldTpl->set("SEND_SMS_VIP_S", $PANELUSER_PREMISSIONS['SEND_SMS'][2]);
    $ldTpl->set("SEND_SMS_VIP_G", $PANELUSER_PREMISSIONS['SEND_SMS'][3]);
    $ldTpl->set("SEND_SMS_VIP_3", $PANELUSER_PREMISSIONS['SEND_SMS'][4]);
    $ldTpl->set("SEND_SMS_VIP_4", $PANELUSER_PREMISSIONS['SEND_SMS'][5]);
    $ldTpl->set("SEND_SMS_VIP_5", $PANELUSER_PREMISSIONS['SEND_SMS'][6]);

    $ldTpl->set("GOLDEN_ARCHER_HABILIT", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][0]);
    $ldTpl->set("GOLDEN_ARCHER_FREE", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][1]);
    $ldTpl->set("GOLDEN_ARCHER_VIP_S", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][2]);
    $ldTpl->set("GOLDEN_ARCHER_VIP_G", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][3]);
    $ldTpl->set("GOLDEN_ARCHER_VIP_3", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][4]);
    $ldTpl->set("GOLDEN_ARCHER_VIP_4", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][5]);
    $ldTpl->set("GOLDEN_ARCHER_VIP_5", $PANELUSER_PREMISSIONS['GOLDEN_ARCHER'][6]);

    $ldTpl->set("COLLECTOR_POINTS_HABILIT", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][0]);
    $ldTpl->set("COLLECTOR_POINTS_FREE", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][1]);
    $ldTpl->set("COLLECTOR_POINTS_VIP_S", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][2]);
    $ldTpl->set("COLLECTOR_POINTS_VIP_G", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][3]);
    $ldTpl->set("COLLECTOR_POINTS_VIP_3", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][4]);
    $ldTpl->set("COLLECTOR_POINTS_VIP_4", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][5]);
    $ldTpl->set("COLLECTOR_POINTS_VIP_5", $PANELUSER_PREMISSIONS['COLLECTOR_POINTS'][6]);

    $ldTpl->set("AUCTIONS_HABILIT", $PANELUSER_PREMISSIONS['AUCTIONS'][0]);
    $ldTpl->set("AUCTIONS_FREE", $PANELUSER_PREMISSIONS['AUCTIONS'][1]);
    $ldTpl->set("AUCTIONS_VIP_S", $PANELUSER_PREMISSIONS['AUCTIONS'][2]);
    $ldTpl->set("AUCTIONS_VIP_G", $PANELUSER_PREMISSIONS['AUCTIONS'][3]);
    $ldTpl->set("AUCTIONS_VIP_3", $PANELUSER_PREMISSIONS['AUCTIONS'][4]);
    $ldTpl->set("AUCTIONS_VIP_4", $PANELUSER_PREMISSIONS['AUCTIONS'][5]);
    $ldTpl->set("AUCTIONS_VIP_5", $PANELUSER_PREMISSIONS['AUCTIONS'][6]);
    }
    }
    }
    ?>



    também teve algumas alterações no CronJobTask

    global $TABLES_CONFIGS;
    if(MUSERVER_TEAM == 1 && VESION_MUSERVER >= 6)
    $this->queryStatement("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnType']."=0 WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." < getdate()");
    else
    $this->queryStatement("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnType']."=0, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']."=0, ".$TABLES_CONFIGS['WEBVIPS']['columnDateBegin']." = 0, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEndInteger']."=0 WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." < '". time(). "'");
    $this->addSymbol(42, $this->colors['black'], $this->colors['lightgreen']);
    $this->addStringImg(50, "Execução bem sucedida.", $this->colors['black']);
    Última edição por Mr.Junior; 28-06-2017 às 01:30 PM.
    "Só tem o direito de criticar aqueles, que pretendem ajudar "

  2. #2



    Avatar de Renato
    Data de Ingresso
    Nov 2010
    Localização
    Imperyus
    Posts
    1.099
    Agradecido
    2519
    Agradeceu
    492
    Peso da Avaliação
    30

    Padrão

    Tente com a cronjob assim:



    Código PHP:
    global $TABLES_CONFIGS;
    $dateObject = new DateTime('NOW');
    $date $dateObject->format('Y-m-d H:i:s');

    if(
    MUSERVER_TEAM == && VESION_MUSERVER >= 6)
    $this->queryStatement(
    "UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET 
    "
    .$TABLES_CONFIGS['WEBVIPS']['columnType']."=0 
    WHERE 
    "
    .$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." < ".$date."");

    else
        
    $this->queryStatement("UPDATE ".$TABLES_CONFIGS['WEBVIPS']['database'].".dbo.".$TABLES_CONFIGS['WEBVIPS']['table']." SET ".$TABLES_CONFIGS['WEBVIPS']['columnType']."=0, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']."=0, ".$TABLES_CONFIGS['WEBVIPS']['columnDateBegin']." = 0, ".$TABLES_CONFIGS['WEBVIPS']['columnDateEndInteger']."=0 WHERE ".$TABLES_CONFIGS['WEBVIPS']['columnDateEnd']." < '"time(). "'");
    $this->addSymbol(42$this->colors['black'], $this->colors['lightgreen']);
    $this->addStringImg(50"Execução bem sucedida."$this->colors['black']); 
    Obs. Não testei, pois estou sem SQL, etc. Se der erro, cheque o "retorno" e posta print aqui que eu fixo pra você.
    []'s
    Última edição por Renato; 29-06-2017 às 09:48 AM.
    Código PHP:
    <?php
        
    if(Weather::getState() == 'Rainy weather') {
            
    $this->removingLittleHorseFromRain();
        }

  3. #3

    Avatar de Mr.Junior
    Data de Ingresso
    Jul 2011
    Localização
    Hortolândia
    Idade
    31
    Posts
    507
    Agradecido
    165
    Agradeceu
    97
    Peso da Avaliação
    18

    Padrão

    @Renato

    Não da erro porem quando compra o VIP ou cadastra olha isso.

    Sucesso: Sua compra foi efetuada com sucesso.
    Válidade: 31-12-1969 9:00 pm
    Obrigado.

    Olha o ano que é inserido, acho que devido o ano o VIP some mesmo.
    Última edição por Mr.Junior; 29-06-2017 às 10:04 AM.
    "Só tem o direito de criticar aqueles, que pretendem ajudar "

  4. #4



    Avatar de Renato
    Data de Ingresso
    Nov 2010
    Localização
    Imperyus
    Posts
    1.099
    Agradecido
    2519
    Agradeceu
    492
    Peso da Avaliação
    30

    Padrão

    Eu modifiquei o cronjob que verifica se o vip expirou. Não alterei nada das classes de compra kkkkk
    Viajou aushauSHAUHSUASH

    Me chama de tarde que eu fixo isso pra você.
    []'s
    Código PHP:
    <?php
        
    if(Weather::getState() == 'Rainy weather') {
            
    $this->removingLittleHorseFromRain();
        }

  5. #5

    Avatar de Mr.Junior
    Data de Ingresso
    Jul 2011
    Localização
    Hortolândia
    Idade
    31
    Posts
    507
    Agradecido
    165
    Agradeceu
    97
    Peso da Avaliação
    18

    Padrão

    @Renato

    Sim exato como eu mencionei no tópico á algumas classes alteradas o Gabriel alterou mais está dando esse BUG entendeu ?

    Segue os arquivos alterados pelo mesmo.

    [Somente usuários registrados podem vem os links. ]

    Acho que pode ser o que está acontecendo alguma alteração do mesmo.

    Tentei utilizar o sistema padrão fazendo com que o próprio site controla-se o VIP, blz funcionou quando eu compro o VIP pelo painel mais quando eu registro uma conta nova o VIP some quando entro no jogo.


    $TABLES_CONFIGS['WEBVIPS'] = array("database" => DATABASE, //webSite || MuOnline
    "table" => "MEMB_INFO", //webVips || MEMB_INFO
    "columnUsername" => "memb___id", //username || memb___id
    "columnType" => "AccountLevel", //type || vip
    "columnDateBegin" => "dateBegin",
    "columnDateEnd" => "DateEnd",
    "columnDateEndInteger" => "dateEndInteger");
    Nas alterações realizado pelo Gabriel, eu teria que alterar o DateEnd para AccountExpireDate, acontece que quando utilizo essa AccountExpireDate a data BUGA e fica sempre esse 1969.

    Entendeu ?

    E mesmo com os files originais não está dando certo também o VIP acaba sumindo, quando registro eu ganho o VIP normalmente mas quando eu logo no jogo o VIP some.
    Última edição por Mr.Junior; 29-06-2017 às 01:12 PM.
    "Só tem o direito de criticar aqueles, que pretendem ajudar "

  6. #6

    Avatar de iFreeHP
    Data de Ingresso
    Apr 2016
    Localização
    Home
    Posts
    30
    Agradecido
    59
    Agradeceu
    11
    Peso da Avaliação
    0

    Padrão

    O problema era que a classe do painel de usuario estava lendo a DateEnd de forma errada e por isso estava tirando o VIP das contas, resolvido por privado.

  7. O Seguinte Usuário Agradeceu iFreeHP Por este Post Útil:


  8. #7

    Avatar de athos47a
    Data de Ingresso
    Oct 2017
    Localização
    palmas
    Idade
    26
    Posts
    3
    Agradecido
    0
    Agradeceu
    0
    Peso da Avaliação
    0

    Padrão

    Oi bom dia, estou com o mesmo problema. Tem como me ajudar ?

  9. #8

    Avatar de athos47a
    Data de Ingresso
    Oct 2017
    Localização
    palmas
    Idade
    26
    Posts
    3
    Agradecido
    0
    Agradeceu
    0
    Peso da Avaliação
    0

    Padrão

    Citação Postado originalmente por iFreeHP Ver Post
    O problema era que a classe do painel de usuario estava lendo a DateEnd de forma errada e por isso estava tirando o VIP das contas, resolvido por privado.
    me ajuda, estou com o mesmo problema

 

 

Informações de Tópico

Usuários Navegando neste Tópico

Há 1 usuários navegando neste tópico. (0 registrados e 1 visitantes)

Tópicos Similares

  1. |Dúvida| MuSite Web Daldegam + Muserver WHTeam
    Por matheusc no fórum Dúvidas
    Respostas: 3
    Último Post: 03-03-2014, 08:20 PM
  2. |Download| MuServer 97J - DarkSide Team | Wolf Dark Team
    Por Guz3rax no fórum [1.01 -]
    Respostas: 21
    Último Post: 08-09-2012, 12:15 PM

Marcadores

Permissões de Postagem

  • Você não pode iniciar novos tópicos
  • Você não pode enviar respostas
  • Você não pode enviar anexos
  • Você não pode editar suas mensagens
  •