Gesior AAC SHOP System

[vitorxx 4]

Estou usando um gesior com sistema de shop do mesmo, porém ao enviar os itens, eles não vão para o jogo, eles são adicionados na database na z_ots_communication se não me engano, e ficam la, não vão para o game.

Alguem sabe o que fazer ?

[Switz 27]

O script "shop.lua" foi instalado corretamente no globalevents?

[vitorxx 4]

Sim, tudo certo

[Switz 27]

Porque a função do site é adicionar o item no "z_ots_communication",

ai o servidor, através do globalevent shop.lua que faria o resto,

"tirando" o item de lá e entregando para o player.

 

Tem como postar o shop.lua (pasta globalevents) e shopsystem.php (pasta das paginas do site)?

Encontrando o erro fica mais fácil de te ajudar.

[vitorxx 4]

shop.lua

-- ### CONFIG ###
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
    local result_plr = db.storeQuery("SELECT * FROM z_ots_comunication")
    if result_plr ~= false then
        repeat
            local id = tonumber(result.getDataInt(result_plr, "id"))
            local action = tostring(result.getDataString(result_plr, "action"))
            local delete = tonumber(result.getDataInt(result_plr, "delete_it"))
            local player = Player(tostring(result.getDataString(result_plr, "name")))
            if player then
                local itemtogive_id = tonumber(result.getDataInt(result_plr, "param1"))
                local itemtogive_count = tonumber(result.getDataInt(result_plr, "param2"))
                local container_id = tonumber(result.getDataInt(result_plr, "param3"))
                local container_count = tonumber(result.getDataInt(result_plr, "param4"))
                local add_item_type = tostring(result.getDataString(result_plr, "param5"))
                local add_item_name = tostring(result.getDataString(result_plr, "param6"))
                local received_item = 0
                local full_weight = 0
                local itemType = ItemType(itemtogive_id)
                if add_item_type == 'container' then
                    if itemType:isRune() then
                        items_weight = container_count * itemType:getWeight()
                    else
                        items_weight = container_count * itemType:getWeight(itemtogive_count)
                    end
                    full_weight = items_weight + ItemType(container_id):getWeight()
                else
                    if itemType:isRune() then
                        full_weight = itemType:getWeight()
                    else
                        full_weight = itemType:getWeight(itemtogive_count)
                    end
                end
                local free_cap = player:getFreeCapacity()
                if full_weight <= free_cap then
                    if add_item_type == 'container' then
                        local new_container = Game.createItem(container_id, 1)
                        local iter = 0
                        while iter ~= container_count do
                            new_container:addItem(itemtogive_id, itemtogive_count)
                            iter = iter + 1
                        end
                        received_item = player:addItemEx(new_container)
                    else
                        local new_item = Game.createItem(itemtogive_id, itemtogive_count)
                        received_item = player:addItemEx(new_item)
                    end
                    if type(received_item) == 'number' and received_item == RETURNVALUE_NOERROR then
                        player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, 'You received >> '.. add_item_name ..' << from OTS shop.')
                        db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                        db.query("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
                    else
                        player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.')
                    end
                else
                    player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.')
                end
            end
        until not result.next(result_plr)
        result.free(result_plr)
    end
    return true
end

 

shopsystem.lua

<?php
$items = simplexml_load_file($config['site']['serverPath'].'/data/items/items.xml') or die('<b>Could not load items!</b>');
    
foreach($items->item as $v)
    $itemList[(int)$v['id']] = ucwords(strtolower($v['name']));

if($config['site']['shop_system'] == 1) {
    if($logged)
        $user_premium_points = $account_logged->getCustomField('premium_points');
    else
        $user_premium_points = 'Login first';

    function getItemByID($id) {
        $id = (int) $id;
        $SQL = $GLOBALS['SQL'];
        $data = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_offer').' WHERE '.$SQL->fieldName('id').' = '.$SQL->quote($id).';')->fetch();
        if ($data['offer_type'] == 'pacc') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['days'] = $data['count1'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
            $offer['offer_type'] = $data['offer_type'];
        }elseif ($data['offer_type'] == 'item') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['item_id'] = $data['itemid1'];
            $offer['item_count'] = $data['count1'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }elseif ($data['offer_type'] == 'vipdays') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['days'] = $data['count1'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
            $offer['offer_type'] = $data['offer_type'];
        }elseif ($data['offer_type'] == 'itemvip') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['item_id'] = $data['itemid1'];
            $offer['item_count'] = $data['count1'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }elseif ($data['offer_type'] == 'container') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['container_id'] = $data['itemid2'];
            $offer['container_count'] = $data['count2'];
            $offer['item_id'] = $data['itemid1'];
            $offer['item_count'] = $data['count1'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }elseif ($data['offer_type'] == 'unban') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }elseif ($data['offer_type'] == 'redskull')    {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }elseif ($data['offer_type'] == 'itemlogout') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['pid'] = $data['pid'];
            $offer['count1'] = $data['count1'];
            $offer['item_id'] = $data['itemid1'];
            $offer['free_cap'] = $data['free_cap'];
        }elseif ($data['offer_type'] == 'storage') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['item_id'] = $data['itemid1'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }elseif ($data['offer_type'] == 'changename') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['points'] = $data['points'];
            $offer['description'] = $data['offer_description'];
            $offer['name'] = $data['offer_name'];
        }return $offer;
    }

    function getOfferArray() {
        $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').';');
        $i_pacc = 0;
        $i_item = 0;
        $i_vipdays = 0;
        $i_itemvip = 0;
        $i_container = 0;
        $i_unban = 0;
        $i_redskull = 0;
        $i_itemlogout = 0;
        $i_changename = 0;
        $i_storage = 0;
        while($data = $offer_list->fetch()) {
            if ($data['offer_type'] == 'pacc') {
                $offer_array['pacc'][$i_pacc]['id'] = $data['id'];
                $offer_array['pacc'][$i_pacc]['days'] = $data['count1'];
                $offer_array['pacc'][$i_pacc]['points'] = $data['points'];
                $offer_array['pacc'][$i_pacc]['description'] = $data['offer_description'];
                $offer_array['pacc'][$i_pacc]['name'] = $data['offer_name'];
                $offer_array['pacc'][$i_pacc]['offer_type'] = $data['offer_type'];
                $i_pacc++;
            }elseif ($data['offer_type'] == 'item') {
                $offer_array['item'][$i_item]['id'] = $data['id'];
                $offer_array['item'][$i_item]['item_id'] = $data['itemid1'];
                $offer_array['item'][$i_item]['item_count'] = $data['count1'];
                $offer_array['item'][$i_item]['points'] = $data['points'];
                $offer_array['item'][$i_item]['description'] = $data['offer_description'];
                $offer_array['item'][$i_item]['name'] = $data['offer_name'];
                $i_item++;
            }elseif ($data['offer_type'] == 'vipdays') {
                $offer_array['vipdays'][$i_vipdays]['id'] = $data['id'];
                $offer_array['vipdays'][$i_vipdays]['days'] = $data['count1'];
                $offer_array['vipdays'][$i_vipdays]['points'] = $data['points'];
                $offer_array['vipdays'][$i_vipdays]['description'] = $data['offer_description'];
                $offer_array['vipdays'][$i_vipdays]['name'] = $data['offer_name'];
                $offer_array['vipdays'][$i_vipdays]['offer_type'] = $data['offer_type'];
                $i_vipdays++;
            }elseif ($data['offer_type'] == 'itemvip') {
                $offer_array['itemvip'][$i_itemvip]['id'] = $data['id'];
                $offer_array['itemvip'][$i_itemvip]['item_id'] = $data['itemid1'];
                $offer_array['itemvip'][$i_itemvip]['item_count'] = $data['count1'];
                $offer_array['itemvip'][$i_itemvip]['points'] = $data['points'];
                $offer_array['itemvip'][$i_itemvip]['description'] = $data['offer_description'];
                $offer_array['itemvip'][$i_itemvip]['name'] = $data['offer_name'];
                $i_itemvip++;
            }elseif ($data['offer_type'] == 'container'){
                $offer_array['container'][$i_container]['id'] = $data['id'];
                $offer_array['container'][$i_container]['container_id'] = $data['itemid2'];
                $offer_array['container'][$i_container]['container_count'] = $data['count2'];
                $offer_array['container'][$i_container]['item_id'] = $data['itemid1'];
                $offer_array['container'][$i_container]['item_count'] = $data['count1'];
                $offer_array['container'][$i_container]['points'] = $data['points'];
                $offer_array['container'][$i_container]['description'] = $data['offer_description'];
                $offer_array['container'][$i_container]['name'] = $data['offer_name'];
                $i_container++;
            }elseif ($data['offer_type'] == 'unban') {
                $offer_array['unban'][$i_unban]['id'] = $data['id'];
                $offer_array['unban'][$i_unban]['points'] = $data['points'];
                $offer_array['unban'][$i_unban]['description'] = $data['offer_description'];
                $offer_array['unban'][$i_unban]['name'] = $data['offer_name'];
                $i_unban++;
            }elseif ($data['offer_type'] == 'redskull') {
                $offer_array['redskull'][$i_redskull]['id'] = $data['id'];
                $offer_array['redskull'][$i_redskull]['points'] = $data['points'];
                $offer_array['redskull'][$i_redskull]['description'] = $data['offer_description'];
                $offer_array['redskull'][$i_redskull]['name'] = $data['offer_name'];
                $i_redskull++;
            }elseif ($data['offer_type'] == 'itemlogout') {
                $offer_array['itemlogout'][$i_itemlogout]['id'] = $data['id'];
                $offer_array['itemlogout'][$i_itemlogout]['points'] = $data['points'];
                $offer_array['itemlogout'][$i_itemlogout]['description'] = $data['offer_description'];
                $offer_array['itemlogout'][$i_itemlogout]['name'] = $data['offer_name'];
                $offer_array['itemlogout'][$i_itemlogout]['count1'] = $data['count1'];
                $offer_array['itemlogout'][$i_itemlogout]['pid'] = $data['pid'];
                $offer_array['itemlogout'][$i_itemlogout]['item_id'] = $data['itemid1'];
                $offer_array['itemlogout'][$i_itemlogout]['free_cap'] = $data['free_cap'];
                $i_itemlogout++;
            }elseif ($data['offer_type'] == 'storage') {
                $offer_array['storage'][$i_storage]['id'] = $data['id'];
                $offer_array['storage'][$i_storage]['points'] = $data['points'];
                $offer_array['storage'][$i_storage]['item_id'] = $data['itemid1'];
                $offer_array['storage'][$i_storage]['description'] = $data['offer_description'];
                $offer_array['storage'][$i_storage]['name'] = $data['offer_name'];
                $i_storage++;
            }elseif ($data['offer_type'] == 'changename') {
                $offer_array['changename'][$i_changename]['id'] = $data['id'];
                $offer_array['changename'][$i_changename]['points'] = $data['points'];
                $offer_array['changename'][$i_changename]['description'] = $data['offer_description'];
                $offer_array['changename'][$i_changename]['name'] = $data['offer_name'];
                $i_changename++;
            }
        }
        return $offer_array;
    }

    if($action == '') {
        unset($_SESSION['viewed_confirmation_page']);
        $main_content .= '<div style="text-align: justify;"><center><h2>Welcome to '.$config['server']['serverName'].' Shop.</h2></center></div>';
        $offer_list = getOfferArray();
        // show storage

        if(count($offer_list['storage']) > 0){
            $main_content .= '
                <div class="TableContainer">
                    <div class="CaptionContainer">
                        <div class="CaptionInnerContainer">
                            <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                            <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                            <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
                            <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
                            <div class="Text">Storages for Sale</div>
                            <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
                            <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
                            <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                            <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                        </div>
                    </div>
                    <table class="Table5" cellpadding="0" cellspacing="0">
                        <tbody>
                            <tr>
                                <td>
                                    <div class="InnerTableContainer">
                                        <table style="width:100%;">
                                            <tbody>
                                                <tr>
                                                    <td>
                                                        <div class="TableShadowContainerRightTop">
                                                            <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
                                                        </div>
                                                        <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
                                                            <div class="TableContentContainer">
                                                                <table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
                                                                    <tbody>';
                                                                    if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
                                                                    $main_content.='
                                                                        <tr bgcolor="'.$bgcolor.'">
                                                                            <td valign="middle" width="10%" align="center"><b>Product</b></td>
                                                                            <td valign="middle" width="60%"><b>Description</b></td>
                                                                            <td valign="middle">&nbsp;</td>
                                                                        </tr>';
                                                                    if(count($offer_list['storage']) > 0)
                                                                        foreach($offer_list['storage'] as $storage) {
                                                                            if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
                                                                            $main_content .= '<tr bgcolor="'.$bgcolor.'">
                                                                                <td valign="middle" align="center"><img src="images/items/storage/'.$storage['item_id'].'.gif" width="32" height="32" /></td>
                                                                                <td><font style="font-size:16px; font-weight:bold;">'.$storage['name'].'</font>&nbsp;';
                                                                            $main_content .='<small>('.$storage['points'].' points)</small>';
                                                                            $main_content .='<br />
                                                                            '.$storage['description'].'</td>
                                                                            <td align="center">';
                                                                            if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
                                                                                $main_content .= '
                                                                                    <form action="index.php?subtopic=shopsystem&action=select_player" method="POST">
                                                                                        <input type="hidden" name="buy_id" value="'.$storage['id'].'">
                                                                                        <table border="0" cellpadding="0" cellspacing="0">
                                                                                            <tbody>
                                                                                                <tr>
                                                                                                    <td style="border: 0px none;">
                                                                                                        <div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
                                                                                                            <div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
                                                                                                            <input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
                                                                                                        </div>
                                                                                                    </div>
                                                                                                </td>
                                                                                            </tr>
                                                                                        </tbody>
                                                                                    </table>
                                                                                    </form>';}
                                                                                $main_content .= '
                                                                                </tbody>
                                                                            </table>
                                                                        </div>
                                                                    </div>
                                                                    <div class="TableShadowContainer">
                                                                        <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
                                                                            <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
                                                                            <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
                                                                        </div>
                                                                    </div>
                                                                </td>
                                                            </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div><br />';}

                //show list of vipdays offers
                if(count($offer_list['vipdays']) > 0 or count($offer_list['pacc']) > 0){
                    $main_content .= '
                        <div class="TableContainer">
                            <div class="CaptionContainer">
                                <div class="CaptionInnerContainer">
                                    <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                                    <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                                    <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
                                    <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
                                    <div class="Text">VIP Account</div>
                                    <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
                                    <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
                                    <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                                    <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                                </div>
                            </div>
                            <table class="Table5" cellpadding="0" cellspacing="0">
                                <tbody>
                                    <tr>
                                        <td>
                                            <div class="InnerTableContainer">
                                                <table style="width:100%;">
                                                    <tbody>
                                                        <tr>
                                                            <td>
                                                                <div class="TableShadowContainerRightTop">
                                                                    <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
                                                                </div>
                                                                <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
                                                                    <div class="TableContentContainer">
                                                                        <table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
                                                                            <tbody>';
                                                                        if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
                                                                        $main_content.='
                                                                            <tr bgcolor="'.$bgcolor.'">
                                                                                <td valign="middle" width="10%" align="center"><b>Product</b></td>
                                                                                <td valign="middle" width="60%"><b>Description</b></td>
                                                                                <td valign="middle">&nbsp;</td>
                                                                            </tr>';
                                                                        if(count($offer_list['pacc']) > 0)
                                                                            foreach($offer_list['pacc'] as $pacc) {
                                                                                if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
                                                                                $main_content .= '
                                                                                    <tr bgcolor="'.$bgcolor.'">
                                                                                        <td valign="middle" align="center"><img src="images/shop/premium.gif" /></td>
                                                                                        <td><font style="font-size:16px; font-weight:bold;">'.$pacc['days'].' VIP Days</font>&nbsp;<small>('.$pacc['points'].' points)</small><br />'.$pacc['description'].'</td>
                                                                                        <td align="center">';
                                                                                if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
                                                                                $main_content .= '
                                                                                    <form action="index.php?subtopic=shopsystem&action=select_player" method=POST>
                                                                                        <input type="hidden" name="buy_id" value="'.$pacc['id'].'">
                                                                                        <table border="0" cellpadding="0" cellspacing="0">
                                                                                            <tbody>
                                                                                                <tr>
                                                                                                    <td style="border: 0px none;">
                                                                                                        <div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
                                                                                                            <div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
                                                                                                            <input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
                                                                                                        </div>
                                                                                                    </div>
                                                                                                </td>
                                                                                            </tr>
                                                                                        </tbody>
                                                                                    </table>
                                                                                    </form>';}
                                                                                foreach($offer_list['vipdays'] as $vipdays) {
                                                                                    if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
                                                                                    $main_content .= '<tr bgcolor="'.$bgcolor.'"><td valign="middle" align="center"><img src="images/shop/premium.gif" /></td>
                                                                                    <td><font style="font-size:16px; font-weight:bold;">'.$vipdays['days'].' VIP Days</font>&nbsp;<small>('.$vipdays['points'].' points)</small><br />'.$vipdays['description'].'</td>
                                                                                    <td align="center">';
                                                                                    if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
                                                                                    $main_content .= '
                                                                                        <form action="index.php?subtopic=shopsystem&action=select_player" method=POST>
                                                                                            <input type="hidden" name="buy_id" value="'.$vipdays['id'].'">
                                                                                            <table border="0" cellpadding="0" cellspacing="0">
                                                                                                <tbody>
                                                                                                    <tr>
                                                                                                        <td style="border: 0px none;">
                                                                                                            <div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
                                                                                                                <div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
                                                                                                                <input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
                                                                                                            </div>
                                                                                                        </div>
                                                                                                    </td>
                                                                                                </tr>
                                                                                            </tbody>
                                                                                        </table>
                                                                                    </form>';
                                                                        $main_content .= '
                                                                            </td>
                                                                        </tr>';
                                                                        }
                                                                    $main_content .= '
                                                                        </tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                            <div class="TableShadowContainer">
                                                                <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
                                                                    <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
                                                                    <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
                                                                </div>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div><br />';}
//show list of itemsvip offers
if(count($offer_list['itemvip']) > 0) {
$main_content .= '
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Items VIP</div>
<span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>
<div class="InnerTableContainer">
<table style="width:100%;">
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div><div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
<tbody>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content.='
<tr bgcolor="'.$bgcolor.'">
<td valign="middle" width="10%" align="center"><b>Product</b></td>
<td valign="middle" width="60%"><b>Description</b></td>
<td valign="middle">&nbsp;</td>
</tr>';
foreach($offer_list['itemvip'] as $itemvip) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td valign="middle" align="center">
';
if(file_exists('images/items/'.$itemvip['item_id'].'.gif')) { $main_content .= '<br /><img src="images/items/'.$itemvip['item_id'].'.gif" height="32" width="32"><br /> '; } else { $main_content .= '<br /> <img src="images/monsters/nophoto.png" height="32" width="32">'; } 
$main_content .='</td>
<td><font style="font-size:16px; font-weight:bold;">'.$itemList[(int)$itemvip['item_id']].'</font>&nbsp;<small>('.$itemvip['points'].' points)</small><br />'.$itemvip['description'].'</td>
<td align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method=POST>
<input type="hidden" name="buy_id" value="'.$itemvip['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';
$main_content .= '</td></tr>';
}
$main_content .= '</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div><br />';}
//show list of items offers
if(count($offer_list['item']) > 0 or count($offer_list['itemlogout']) > 0){
$main_content .= '
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Items</div>
<span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>
<div class="InnerTableContainer">
<table style="width:100%;">
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div><div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
<tbody>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content.='
<tr bgcolor="'.$bgcolor.'">
<td valign="middle" width="10%" align="center"><b>Product</b></td>
<td valign="middle" width="60%"><b>Description</b></td>
<td valign="middle">&nbsp;</td>';
if(count($offer_list['item']) > 0) {
foreach($offer_list['item'] as $item) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '
</tr>
<tr bgcolor="'.$bgcolor.'">
<td valign="middle" align="center">'; if(file_exists('images/items/'.$item['item_id'].'.gif')) { $main_content .= '<br /><img src="images/items/'.$item['item_id'].'.gif" height="32" width="32"><br /> '; } else { $main_content .= '<br /> <img src="images/monsters/nophoto.png" height="32" width="32">'; } 
$main_content .='
</td>
<td><font style="font-size:16px; font-weight:bold;">'.$itemList[(int)$item['item_id']].'</font>&nbsp;';
$main_content .='<small>('.$item['points'].' points)</small>';
$main_content .='<br />
'.$item['description'].'
</td>
<td valign="middle" align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method="POST">
<input type="hidden" name="buy_id" value="'.$item['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';
$main_content .= '</td></tr>'; 
}
$main_content .= '</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div></td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div><br />';
}
}
//show list of containers offers

if(count($offer_list['itemlogout']) > 0) {
$main_content .= '
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Items Logout</div>
<span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>
<div class="InnerTableContainer">
<table style="width:100%;">
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div><div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
<tbody>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content.='
<tr bgcolor="'.$bgcolor.'">
<td valign="middle" width="10%" align="center"><b>Product</b></td>
<td valign="middle" width="60%"><b>Description</b></td>
<td valign="middle">&nbsp;</td>
</tr>';
foreach($offer_list['itemlogout'] as $itemlogout) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td valign="middle" align="center"><img src="images/items/'.$itemlogout['id'].'.gif"></td><td><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' points)<br />'.$itemlogout['description'].'</td><td align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method=POST>
<input type="hidden" name="buy_id" value="'.$itemlogout['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';
$main_content .= '</td></tr>';
}
$main_content .= '</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div><br />';}
if(count($offer_list['container']) > 0) {
$main_content .= '
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Containers Of Items</div>
<span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>
<div class="InnerTableContainer">
<table style="width:100%;">
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div><div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
<tbody>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content.='
<tr bgcolor="'.$bgcolor.'">
<td valign="middle" width="10%" align="center"><b>Product</b></td>
<td valign="middle" width="60%"><b>Description</b></td>
<td valign="middle">&nbsp;</td>

</tr>';
foreach($offer_list['container'] as $container) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td valign="middle" align="center">'; if(file_exists('images/items/'.$container['item_id'].'.gif')) { $main_content .= '<img src="images/items/'.$container['item_id'].'.gif" height="32" width="32">'; } else { $main_content .= '<img src="images/monsters/nophoto.png" height="32" width="32">'; } $main_content .='</td>
<td><b style="font-height: bold; font-size: 16px;">'.$container['name'].'</b> ('.$container['points'].' points)<br />'.$container['description'].'</td><td align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="?subtopic=shopsystem&action=select_player" method="POST">
<input type="hidden" name="buy_id" value="'.$container['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';
$main_content .= '</td></tr>';
}
$main_content .= '</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div><br />';}
if(count($offer_list['changename']) > 0 or count($offer_list['redskull']) > 0 or count($offer_list['unban']) > 0){
$main_content .= '
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Account Additional</div>
<span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>
<div class="InnerTableContainer">
<table style="width:100%;">
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div><div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border:1px solid #faf0d7;" width="100%">
<tbody>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content.='
<tr bgcolor="'.$bgcolor.'">
<td valign="middle" width="10%" align="center"><b>Product</b></td>
<td valign="middle" width="60%"><b>Description</b></td>
<td valign="middle">&nbsp;</td>
</tr>';
//Change Name
if(count($offer_list['changename']) > 0)
foreach($offer_list['changename'] as $changename) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$bgcolor.'">
<td valign="middle" align="center"><img src="images/shop/name.gif" /></td>
<td><font style="font-size:16px; font-weight:bold;">'.$changename['name'].'</font>&nbsp;';
$main_content .='<small>('.$changename['points'].' points)</small>';
$main_content .='<br />
'.$changename['description'].'</td>
<td align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method="POST">
<input type="hidden" name="buy_id" value="'.$changename['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';}

//Remove Red Skull
if(count($offer_list['redskull']) > 0)
foreach($offer_list['redskull'] as $redskull) {
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$bgcolor.'">
<td valign="middle" align="center"><img src="images/shop/skull.gif" /></td>
<td><font style="font-size:16px; font-weight:bold;">'.$redskull['name'].'</font>&nbsp;';
$main_content .='<small>('.$redskull['points'].' points)</small>';
$main_content .='<br />'.$redskull['description'].'</td>
<td align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method="POST">
<input type="hidden" name="buy_id" value="'.$redskull['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';
$main_content .= '</td></tr>';}
//Unban
if(count($offer_list['unban']) > 0)
foreach($offer_list['unban'] as $unban){
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<tr bgcolor="'.$bgcolor.'">
<td valign="middle" align="center"><br /><img src="images/shop/ban.gif" /></td>
<td><font style="font-size:16px; font-weight:bold;">'.$unban['name'].'</font>&nbsp;';
$main_content .='<small>('.$unban['points'].' points)</small>';
$main_content .='<br />'.$unban['description'].'</td>
<td align="center">';
if(!$logged) $main_content .= '<input type="submit" value="Login First" class="btn disabled btn-danger" />'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method="POST">
<input type="hidden" name="buy_id" value="'.$unban['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_purchase.gif" type="image">
</div>
</div>
</td>
</tr>
</tbody>
</table>
</form>';
$main_content .= '</td></tr>';}
$main_content .= '
</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>';}}
elseif($action == 'select_player') {
unset($_SESSION['viewed_confirmation_page']);
if(!$logged) {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="4" WIDTH="100%">
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD CLASS=white><B>Shoping Error</B></TD>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<td>
<TABLE BORDER="0" CELLSPACING="1" cellpadding="4">
<TR>
<TD>Please login first.</TD>
</TR>
</TABLE>
</td>
</tr>
</TABLE>';} 
else {
$buy_id = (int) $_REQUEST['buy_id'];
if(empty($buy_id)) {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="4" WIDTH="100%">
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD CLASS=white><B>Shoping Error</B></TD>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<td>
<TABLE BORDER="0" CELLSPACING="1" cellpadding="4">
<TR>
<TD>Please <a href="index.php?subtopic=shopsystem">select item</a> first.</TD>
</TR>
</TABLE>
</td>
</tr>
</TABLE>';} 
else {
$buy_offer = getItemByID($buy_id);
if(isset($buy_offer['id'])) { //item exist in database
if($buy_offer['type'] != 'changename') {
if($user_premium_points >= $buy_offer['points']) {
if(empty($_REQUEST['page'])) { $color1 = 'blue'; $color2 = 'green-blue'; $color3 = 'blue'; $color4 = 'blue'; $color5 = 'blue'; }
if($_REQUEST['page'] == 'confirm') { $color1 = 'blue'; $color2 = 'green'; $color3 = 'green'; $color4 = 'green-blue'; $color5 = 'blue'; }
if($_REQUEST['page'] == 'transfer') { $color1 = 'green'; $color2 = 'green'; $color3 = 'green'; $color4 = 'green'; $color5 = 'green'; }
$main_content .= '
<div id="ProgressBar" >
<center><h2>Shop Buy Item</h2></center>
<div id="MainContainer" >
<div id="BackgroundContainer" >
<img id="BackgroundContainerLeftEnd" src="'.$layout_name.'/images/vips/stonebar-left-end.gif" />
<div id="BackgroundContainerCenter">
<div id="BackgroundContainerCenterImage" style="background-image:url('.$layout_name.'/images/vips/stonebar-center.gif);" />
</div>
</div>
<img id="BackgroundContainerRightEnd" src="'.$layout_name.'/images/vips/stonebar-right-end.gif" />
</div>
<img id="TubeLeftEnd" src="'.$layout_name.'/images/vips/progress-bar-tube-left-green.gif" />
<img id="TubeRightEnd" src="'.$layout_name.'/images/vips/progress-bar-tube-right-'.$color1.'.gif" />
<div id="FirstStep" class="Steps" >
<div class="SingleStepContainer" >
<img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-0-green.gif" />
<div class="StepText" style="font-weight:normal;" >Item Selected</div>
</div>
</div>
<div id="StepsContainer1" ><div id="StepsContainer2" ><div class="Steps" style="width:50%" >
<div class="TubeContainer" ><img class="Tube" src="'.$layout_name.'/images/vips/progress-bar-tube-'.$color2.'.gif" /></div><div class="SingleStepContainer" ><img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-3-'.$color3.'.gif" /><div class="StepText" style="font-weight:normal;" >Confirm Data</div>
</div></div><div class="Steps" style="width:50%" ><div class="TubeContainer" ><img class="Tube" src="'.$layout_name.'/images/vips/progress-bar-tube-'.$color4.'.gif" /></div><div class="SingleStepContainer" ><img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-4-'.$color5.'.gif" />
<div class="StepText" style="font-weight:normal;" >Transfer Result</div></div></div></div></div></div></div>';
$main_content .= '
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer"> 
<span class="CaptionEdgeLeftTop" style="background-image: url('.$layout_name.'/images/content/box-frame-edge.gif);"></span> 
<span class="CaptionEdgeRightTop" style="background-image: url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image: url('.$layout_name.'/images/content/table-headline-border.gif);"></span> 
<span class="CaptionVerticalLeft" style="background-image: url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span> 
<div class="Text">Delivery Informations</div> 
<span class="CaptionVerticalRight" style="background-image: url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image: url('.$layout_name.'/images/content/table-headline-border.gif);"></span> 
<span class="CaptionEdgeLeftBottom" style="background-image: url('.$layout_name.'/images/content/box-frame-edge.gif);"></span> 
<span class="CaptionEdgeRightBottom" style="background-image: url('.$layout_name.'/images/content/box-frame-edge.gif);"></span> 
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0"> 
<tbody><tr>
<td>
<div class="InnerTableContainer"> 
<table style="width: 100%;"><tbody><tr><td>
<div class="InnerTableContainer">
<table>
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image: url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div>
<div class="TableContentAndRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border: 1px solid #faf0d7;">
<tbody>
<tr style="background-color: #505050;">
</tr>
<tr class="Table" style="background-color: #d4c0a1;">
<td style="width: 800; border: 1px; border-style: solid; border-color: #FAF0D7; padding: 4px;">
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="'.$config['site']['vdarkborder'].'">
<td colspan="2"><font style="font-size:16px; font-weight:bold; color: #FFFFFF;"><b>Item Informations</b></font></td>
</tr>
<tr bgcolor="#D4C0A1">
<td width="100"><b>Image:</b></td>
<td width="550">';
if(file_exists('images/items/'.$buy_offer['item_id'].'.gif')) {
$main_content .= '<img src="images/items/'.$buy_offer['item_id'].'.gif" height="32" width="32">';
} else {
if ($buy_offer['offer_type'] == 'pacc' or $buy_offer['offer_type'] == 'vipdays'){$main_content .='<img src="images/shop/premium.gif" />';} else $main_content .= '<img src="images/monsters/nophoto.png" height="32" width="32">';
}

$main_content .='
</td>
</tr>
<tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550">'.$itemList[(int)$buy_offer['item_id']].'</td></tr>
<tr bgcolor="#D4C0A1"><td width="100"><b>Description:</b></td><td width="550">'.$buy_offer['description'].'</td></tr>';
$main_content .='<tr bgcolor="#F1E0C6"><td width="100"><b>Cost:</b></td><td width="550"><small><b>'.$buy_offer['points'].'</b> premium points</small></td></tr>';
$main_content .='
</table>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="InnerTableContainer">
<table>
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image: url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div>
<div class="TableContentAndRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border: 1px solid #faf0d7;">
<tbody>
<tr style="background-color: #505050;">
</tr>
<tr class="Table" style="background-color: #d4c0a1;">
<td style="width: 800; border: 1px; border-style: solid; border-color: #FAF0D7; padding: 4px;">
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST>
<input type="hidden" name="buy_id" value="'.$buy_id.'">
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="'.$config['site']['vdarkborder'].'">
<td colspan="2"><font style="font-size:16px; font-weight:bold; color: #FFFFFF;"><b>Select one Player</b></font></td>
</tr>
<tr bgcolor="#D4C0A1"><td width="110"><b>Name:</b>&nbsp;&nbsp;<select name="buy_name" style="padding: 5px;">';
$players_from_logged_acc = $account_logged->getPlayersList();
if(count($players_from_logged_acc) > 0) {
foreach($players_from_logged_acc as $player)
$main_content .= '<option>'.$player->getName().'</option>';
} else {
$main_content .= 'You don\'t have any character on your account.';
}
$main_content .= '</select>&nbsp;<input type="submit" class="btn btn-success" style="margin-top: -2.5px;" value="Purschase"><br /><small>Character <b> your account </b> you will receive.</small></td></tr></table>
</form>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="InnerTableContainer">
<table>
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image: url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>
</div>
<div class="TableContentAndRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table class="TableContent" style="border: 1px solid #faf0d7;">
<tbody>
<tr style="background-color: #505050;">
</tr>
<tr class="Table" style="background-color: #d4c0a1;">
<td style="width: 800; border: 1px; border-style: solid; border-color: #FAF0D7; padding: 4px;">
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST"><input type="hidden" name="buy_id" value="'.$buy_id.'">
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="'.$config['site']['vdarkborder'].'">
<td colspan="2"><font style="font-size:16px; font-weight:bold; color: #FFFFFF;"><b>Send Gift</b></font></td>
</tr>
<tr bgcolor="#D4C0A1"><td width="110"><b>To player:</b>&nbsp;&nbsp;<input type="text" name="buy_name" autocomplete="off" placeholder="Character&nbsp;to&nbsp;recive&nbsp;'.$buy_offer['name'].'" size="25">&nbsp;<input type="submit" value="Purschase to friend" class="btn btn-success" style="margin-top: -2.5px;"><br /><small>Put in the field above the name of the character that will receive the item.</small></td></tr>
</table>
</form>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>';
} else {
$main_content .= '
<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="4" WIDTH="100%">
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD CLASS="white"><b>Erro</b></td>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'><TD>To buy <b>'.$buy_offer['name'].'</b> you need <b>'.$buy_offer['points'].' premium points</b>.<br />Your balance is currently <b>'.$user_premium_points.'</b> premium points.</TD>
</TR>
</TABLE>
<br />
<table width="100%">
<tbody>
<tr align="center">
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tbody><tr><td style="border: 0px none;">
<a href="javascript:void();" onclick=location.href="index.php?subtopic=doacao">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<div class="ButtonText" style="background-image:url('.$layout_name.'/images/buttons/_sbutton_buypoints.png);"></div>
</div>
</div>
</a>
</td>
</tr>
<tr>
</tr>
</tbody>
</table>
</td>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<a href="javascript:void();" onclick=location.href="index.php?subtopic=shopsystem"><div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif); visibility: hidden;"></div>
<input class="ButtonText" name="Back" alt="Back" src="'.$layout_name.'/images/vips/_sbutton_back.gif" type="image">
</table>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>';}
} else {
$main_content .= '<script type="text/javascript">

var accountHttp;

//sprawdza czy dane konto istnieje czy nie
function checkAccount()
{
    if(document.getElementById("account_name").value=="")
    {
        document.getElementById("acc_name_check").innerHTML = \'<img src="images/nok.gif" />\';
        return;
    }
    accountHttp=GetXmlHttpObject();
    if (accountHttp==null)
    {
        return;
    }
    var account = document.getElementById("account_name").value;
    var url="ajax/check_account.php?account=" + account + "&uid="+Math.random();
    accountHttp.onreadystatechange=AccountStateChanged;
    accountHttp.open("GET",url,true);
    accountHttp.send(null);
} 

function AccountStateChanged() 
{ 
    if (accountHttp.readyState==4)
    { 
        document.getElementById("acc_name_check").innerHTML=accountHttp.responseText;
    }
}

var emailHttp;

//sprawdza czy dane konto istnieje czy nie
function checkEmail()
{
    if(document.getElementById("email").value=="")
    {
        document.getElementById("email_check").innerHTML = \'<img src="images/nok.gif" />\';
        return;
    }
    emailHttp=GetXmlHttpObject();
    if (emailHttp==null)
    {
        return;
    }
    var email = document.getElementById("email").value;
    var url="ajax/check_email.php?email=" + email + "&uid="+Math.random();
    emailHttp.onreadystatechange=EmailStateChanged;
    emailHttp.open("GET",url,true);
    emailHttp.send(null);
} 

function EmailStateChanged() 
{ 
    if (emailHttp.readyState==4)
    { 
        document.getElementById("email_check").innerHTML=emailHttp.responseText;
    }
}

    function validate_required(field,alerttxt)
    {
    with (field)
    {
    if (value==null||value==""||value==" ")
      {alert(alerttxt);return false;}
    else {return true}
    }
    }

    function validate_email(field,alerttxt)
    {
    with (field)
    {
    apos=value.indexOf("@");
    dotpos=value.lastIndexOf(".");
    if (apos<1||dotpos-apos<2) 
      {alert(alerttxt);return false;}
    else {return true;}
    }
    }

    function validate_form(thisform)
    {
    with (thisform)
    {
    if (validate_required(buy_from,"Please enter a new name of your character!")==false)
      {buy_from.focus();return false;}
    if (validate_required(email,"Please enter your e-mail!")==false)
      {email.focus();return false;}
    if (validate_email(email,"Invalid e-mail format!")==false)
      {email.focus();return false;}
    if (verifpass==1) {
    if (validate_required(passor,"Please enter password!")==false)
      {passor.focus();return false;}
    if (validate_required(passor2,"Please repeat password!")==false)
      {passor2.focus();return false;}
    if (passor2.value!=passor.value)
      {alert(\'Repeated password is not equal to password!\');return false;}
    }
    if(rules.checked==false)
      {alert(\'To create account you must accept server rules!\');return false;}
    }
    }
    </script>';
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="post" onsubmit="return validate_form(this)">
<input type="hidden" name="buy_id" value="'.$buy_id.'">
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="#505050">
<td colspan="2"><b class="white">Change Name</b></td>
</tr>
<tr bgcolor="#D4C0A1">
<td width="110"><b>Name:</b></td>
<td width="550">
<select style="padding: 5px;" name="buy_name">';
$players_from_logged_acc = $account_logged->getPlayersList();
if(count($players_from_logged_acc) > 0) {
foreach($players_from_logged_acc as $player) {
$main_content .= '<option>'.$player->getName().'</option>';}
} else {
$main_content .= 'You don\'t have any character on your account.';}
$main_content .= '</select>
</td>
</tr>
<tr bgcolor="#F1E0C6">
<td width="110"><b>New name:</b></td>
<td width="550"><input type="text" name="buy_from" id="buy_from" style="padding: 5px;" />&nbsp;';
if ($account_logged->getCustomField("premium_points") <= $buy_offer['points']){$main_content .='<input type="submit" value="New Name" class="btn disabled btn-danger" disabled />';} else {$main_content .='<input type="button" value="New Name" class="btn btn-success" />';}
$main_content .='</td>
</tr>
</table>
</form>
<br />
<form action="index.php?subtopic=shopsystem" method="post"><input type="submit" value="Back to Shop" class="btn btn-primary" /></form>';}
} else {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="5" WIDTH="100%">
<tr BGCOLOR="'.$config['site']['vdarkborder'].'">
<td CLASS="white"><b>Error</b></td>
</tr>
<tr BGCOLOR='.$config['site']['darkborder'].'>
<td>Offer with ID <b>'.$buy_id.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem">select item</a> again.</td>
</tr>
</TABLE>';}
}}}
elseif($action == 'confirm_transaction') {
if(!$logged) {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="4" WIDTH="100%">
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD CLASS=white><B>Shoping Error</B></TD>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<td>
<TABLE BORDER="0" CELLSPACING="1" cellpadding="4">
<TR>
<TD>Please login first.</TD>
</TR>
</TABLE>
</td>
</tr>
</TABLE>';} 
else {
$buy_id = (int) $_POST['buy_id'];
$buy_name = stripslashes(urldecode($_POST['buy_name']));
$buy_from = stripslashes(urldecode($_POST['buy_from']));
if(empty($buy_id)) {
$main_content .= 'Please <a href="index.php?subtopic=shopsystem">select item</a> first.';
} else {
if($buy_offer['type'] == 'changename'){
if(!check_name_new_char($buy_from)) {
$main_content .= 'Invalid name format of new name.';
}}
else {
$buy_offer = getItemByID($buy_id);
$check_name_in_database = new Player();
$check_name_in_database->find($buy_from);
if($buy_offer['type'] == 'changename'){
if(!$check_name_in_database->isLoaded()) {
}}
if(isset($buy_offer['id'])) { //item exist in database
if($user_premium_points >= $buy_offer['points']) {
if(check_name($buy_name)) {
$buy_player = new Player();
$buy_player->find($buy_name);
if($buy_player->isLoaded()) {
$buy_player_account = $buy_player->getAccount();
if($_SESSION['viewed_confirmation_page'] == 'yes' && $_POST['buy_confirmed'] == 'yes') {
if($buy_offer['type'] == 'pacc') {
$player_premdays = $buy_player_account->getCustomField('premdays');
$player_lastlogin = $buy_player_account->getCustomField('lastday');
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_pacc').' (id, to_name, to_account, from_nick, from_account, price, pacc_days, trans_state, trans_start, trans_real) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).', '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['days']).', \'realized\', '.$SQL->quote(time()).', '.$SQL->quote(time()).');';
$SQL->query($save_transaction);
$buy_player_account->setCustomField('premdays', $player_premdays+$buy_offer['days']);
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];

$main_content .= '<h2>VIP account added!</h2><b>'.$buy_offer['days'].' days</b> of VIP account added to the account of player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
}
elseif($buy_offer['type'] == 'unban'){
$my_acc_id = $account_logged->getCustomField('id');
$datadata = $SQL->query('SELECT * FROM '.$SQL->tableName('bans').' WHERE value = '.$my_acc_id.';')->fetch();
if($datadata['value'] == $my_acc_id) {
if($SQL->query('DELETE FROM bans WHERE value= '.$my_acc_id.' LIMIT 1;')) {
} else {
$SQL->query('DELETE FROM bans WHERE account= '.$my_acc_id.' LIMIT 1;');
}
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>Ban Deleted!</h2><b>Your account has been unbanned for '.$buy_offer['points'].' premium points</b> from your account.
<br>Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
} else {
$main_content .= '<center><b>You don\'t have any bans in your account!</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
}
}

elseif($buy_offer['type'] == 'storage') {
$datadata = $SQL->query("SELECT * FROM  `player_storage` WHERE  `player_id` = ".$buy_player->getCustomField('id')." AND  `key` = '".$buy_offer['item_id']."'")->fetch();
$player = $SQL->query("SELECT *  FROM `players` WHERE `id` = ".$buy_player->getCustomField('id')."")->fetch();
if($datadata['key'] == $buy_offer['item_id']) {
$main_content .='
<table cellspacing="1" cellpadding="4" width="100%">
<tr bgcolor="#505050">
<td colspan="4" class="white"><b>Shop Message</b></td>
</tr>
<TR BGCOLOR='.$config['site']['darkborder'].'><TD align="center"><i>Your character already has this storage, please select another storage or another character to continue with the purchase.</i></TD></TR>
</TABLE>
<br />
<br />
';
}
else
{
if ($player['online'] == 0){
$SQL->query("INSERT INTO `player_storage` (`player_id` ,`key` ,`value`)
VALUES ('".$buy_player->getCustomField('id')."',  '".$buy_offer['item_id']."',  '1');");
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>Storage enviada!</h2><b>Voc&ecirc recebeu sua storage por '.$buy_offer['points'].' pontos</b> da sua account.
<br>Agora voc&ecirc possui <b>'.$user_premium_points.' pontos</b>.<br /><br />';
}
}
if ($player['online'] == 1){
$main_content .='
<table cellspacing="1" cellpadding="4" width="100%">
<tr bgcolor="#505050">
<td colspan="4" class="white"><b>Shop Message</b></td>
</tr>
<TR BGCOLOR='.$config['site']['darkborder'].'><TD align="center">
<i>
Your character is online at this time, so that the system can properly credit the storage, we require that you log out your character before buying any other type of storage.
</i>
</TD></TR>
</TABLE>
<br />
<br />
';
}
$main_content .='
<center>
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="border: 0px none;">
<div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);">
<div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
<form action="index.php?subtopic=shopsystem" method="post">
<input class="ButtonText" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" type="image">
</form>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</center>
';
}
////////////////////////////////
elseif($buy_offer['type'] == 'itemlogout') {
$my_acc_id = $buy_player->getCustomField('id');
$playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE id = '.$my_acc_id.';')->fetch();
$playerslot = $SQL->query('SELECT * FROM '.$SQL->tableName('player_items').' WHERE player_id = '.$my_acc_id.';')->fetch();
if ($playerinfo['online'] == '0') {
if ($playerslot['pid'] != '10') {
if ($datadata['cap'] >= $SQL->quote($buy_offer['free_cap'])) {
$SQL->query('INSERT INTO player_items (player_id, pid, itemtype, count) VALUES ('.$my_acc_id.', '.$SQL->quote($buy_offer['pid']).', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['count1']).');');
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<h2>Item received to player: '.$buy_player->getName().'!</h2><br />Now you have <b>'.$user_premium_points.' premium points</b>.
<br /><a href="index.php?subtopic=shopsystem">Go to Shop Site</a>';
} else {
$main_content .= '<b>You need '.$SQL->quote($buy_offer['free_cap']).' or more of cap!</b><br /><a href="index.php?subtopic=shopsystem">Go back</a>';
}} else {
$main_content .= '<b>Please leave the arrow slot in blank to receive item!</b><br /><a href="index.php?subtopic=shopsystem">Go back</a>';
}} else {
$main_content .= '<b>You need to be offline!</b><br /><a href="index.php?subtopic=shopsystem">Go back</a>';
}
}
////////////////////////////////
elseif($buy_offer['type'] == 'changename') {
$my_acc_id = $buy_player->getCustomField('id');
$playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
$checkname = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('name').' = '. $SQL->quote($buy_from) .';')->fetch();
if($playerinfo['online'] == '0') {
if($checkname == true) {
$SQL->query('UPDATE `players` SET `name` = '. $SQL->quote($buy_from) .' WHERE `id` = '. $my_acc_id.' ;');
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>Your name has been changed to '.$buy_from.'.</h2><br /><b>You have '.$user_premium_points.' premium points left</b>.
<br /><br /><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br />';
} else {
$main_content .= '<center><h2>Sorry, the name "<i>'.$buy_from.'</i>" does already exist.<br />Please select another name.</h2><br />';
}} else {
$main_content .= '<center><h2>'.$buy_name.' has to be offline to complete transaction.</h2><br /><br /><a href="index.php?subtopic=shopsystem">Go back</a><br />';
}}
////////////////////////////////
elseif($buy_offer['type'] == 'redskull') {
$my_acc_id = $buy_player->getCustomField('id');
$playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
if($playerinfo['skull'] == '4' AND $playerinfo['online'] >= '0' AND $playerinfo['skulltime'] > '0') {
$SQL->query('UPDATE killers SET unjustified=0 WHERE id IN (SELECT kill_id FROM player_killers WHERE player_id='. $my_acc_id .');');
$SQL->query('UPDATE players SET skulltime=0, skull=0 WHERE id='. $my_acc_id .';');
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>RedSkull Removed!</h2><br /><b>Your redskull has been removed from the player '.$buy_player->getName().'.</b>
<br />Now you have<b> '.$user_premium_points.' premium points</b>.<br /><br /><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br />';
} else {
$main_content .= '<center><b>'.$buy_player->getName().' has to be offline or have redskull to complete transaction!.</b><br /><br /><a href="index.php?subtopic=shopsystem">Go back</a><br />';
}}
//////////////////////////
elseif($buy_offer['type'] == 'item') {
$sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'item\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
$SQL->query($sql);
                                            $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['item_id']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                                            $SQL->query($save_transaction);
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
 $color1 = 'green'; $color2 = 'green'; $color3 = 'green'; $color4 = 'green'; $color5 = 'green'; 
$main_content .= '
<div id="ProgressBar" >
<center><h2>Character World Transfer</h2></center>
<div id="MainContainer" >
<div id="BackgroundContainer" >
<img id="BackgroundContainerLeftEnd" src="'.$layout_name.'/images/vips/stonebar-left-end.gif" />
<div id="BackgroundContainerCenter">
<div id="BackgroundContainerCenterImage" style="background-image:url('.$layout_name.'/images/vips/stonebar-center.gif);" />
</div>
</div>
<img id="BackgroundContainerRightEnd" src="'.$layout_name.'/images/vips/stonebar-right-end.gif" />
</div>
<img id="TubeLeftEnd" src="'.$layout_name.'/images/vips/progress-bar-tube-left-green.gif" />
<img id="TubeRightEnd" src="'.$layout_name.'/images/vips/progress-bar-tube-right-'.$color1.'.gif" />
<div id="FirstStep" class="Steps" >
<div class="SingleStepContainer" >
<img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-0-green.gif" />
<div class="StepText" style="font-weight:normal;" >Item Selected</div>
</div>
</div>
<div id="StepsContainer1" ><div id="StepsContainer2" ><div class="Steps" style="width:50%" >
<div class="TubeContainer" ><img class="Tube" src="'.$layout_name.'/images/vips/progress-bar-tube-'.$color2.'.gif" /></div><div class="SingleStepContainer" ><img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-3-'.$color3.'.gif" /><div class="StepText" style="font-weight:normal;" >Confirm Data</div>
</div></div><div class="Steps" style="width:50%" ><div class="TubeContainer" ><img class="Tube" src="'.$layout_name.'/images/vips/progress-bar-tube-'.$color4.'.gif" /></div><div class="SingleStepContainer" ><img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-4-'.$color5.'.gif" />
<div class="StepText" style="font-weight:normal;" >Transfer Result</div></div></div></div></div></div></div>';
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="4" WIDTH="100%">
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD CLASS="white"><b>Item added successfully !</b></td>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<TD>
Item was sent to the player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />
Now you have <b>'.$user_premium_points.' premium points</b>.
</TD>
</TR>
</TABLE>
<br /><form action="index.php?subtopic=shopsystem" method="post"><input type="submit" value="Back to Shop" class="btn btn-primary" /></form><br /><br />';}
if($buy_offer['type'] == 'vipdays') {
$player_vip_time = $buy_player_account->getCustomField('vip_time');
$player_lastlogin = $buy_player_account->getCustomField('lastday');
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_pacc').' (id, to_name, to_account, from_nick, from_account, price, pacc_days, trans_state, trans_start, trans_real) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).', '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['days']).', \'realized\', '.$SQL->quote(time()).', '.$SQL->quote(time()).');';
$SQL->query($save_transaction);
$nomedoComprador = $buy_player_account->getName();
if($player_vip_time > 0){
    $newVipDays = $player_vip_time + ($buy_offer['days'] * 86400);
    $merda = $SQL->query("UPDATE `accounts` SET `vip_time` = '$newVipDays' WHERE `name` = '$nomedoComprador'");
}else{
    $newVipDays2 = time() + ($buy_offer['days'] * 86400);
    $merda = $SQL->query("UPDATE `accounts` SET `vip_time` = '$newVipDays2' WHERE `name` = '$nomedoComprador'");
}
$nomedoCara = $account_logged->getName();
$anyThing = $user_premium_points-$buy_offer['points'];
$SQL->query("UPDATE `accounts` SET `premium_points` = '$anyThing' WHERE `name` = '$nomedoCara'");
$user_premium_points = $user_premium_points - $buy_offer['points'];
if ($player_vip_days >= 1) {
}
$main_content .= '<center><h2>VIP Days added!</h2><b>'.$buy_offer['days'].' days</b> of VIP days added to the account of player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br /><br /><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br />';} 
elseif($buy_offer['type'] == 'itemvip') {
$sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['megaitems_count']).', \'\', \'\', \'megaitems\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
$SQL->query($sql);
                                            $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['item_id']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                                            $SQL->query($save_transaction);
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>Mega Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br>Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
}
elseif($buy_offer['type'] == 'container') {
$sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', '.$SQL->quote($buy_offer['container_id']).', '.$SQL->quote($buy_offer['container_count']).', \'container\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
$SQL->query($sql);
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).', '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
$SQL->query($save_transaction);
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>Container of items added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br /><br /><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br />';
}} 
else {
if($buy_offer['type'] != 'changename') {
$set_session = TRUE;
$_SESSION['viewed_confirmation_page'] = 'yes';
if(empty($_REQUEST['page'])) { $color1 = 'blue'; $color2 = 'green-blue'; $color3 = 'blue'; $color4 = 'blue'; $color5 = 'blue'; }
if($_REQUEST['action'] == 'confirm_transaction') { $color1 = 'blue'; $color2 = 'green'; $color3 = 'green'; $color4 = 'green-blue'; $color5 = 'blue'; }
if($_REQUEST['page'] == 'transfer') { $color1 = 'green'; $color2 = 'green'; $color3 = 'green'; $color4 = 'green'; $color5 = 'green'; }
$main_content .= '
<div id="ProgressBar" >
<center><h2>Shop Buy Item</h2></center>
<div id="MainContainer" >
<div id="BackgroundContainer" >
<img id="BackgroundContainerLeftEnd" src="'.$layout_name.'/images/vips/stonebar-left-end.gif" />
<div id="BackgroundContainerCenter">
<div id="BackgroundContainerCenterImage" style="background-image:url('.$layout_name.'/images/vips/stonebar-center.gif);" />
</div>
</div>
<img id="BackgroundContainerRightEnd" src="'.$layout_name.'/images/vips/stonebar-right-end.gif" />
</div>
<img id="TubeLeftEnd" src="'.$layout_name.'/images/vips/progress-bar-tube-left-green.gif" />
<img id="TubeRightEnd" src="'.$layout_name.'/images/vips/progress-bar-tube-right-'.$color1.'.gif" />
<div id="FirstStep" class="Steps" >
<div class="SingleStepContainer" >
<img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-0-green.gif" />
<div class="StepText" style="font-weight:normal;" >Item Selected</div>
</div>
</div>
<div id="StepsContainer1" ><div id="StepsContainer2" ><div class="Steps" style="width:50%" >
<div class="TubeContainer" ><img class="Tube" src="'.$layout_name.'/images/vips/progress-bar-tube-'.$color2.'.gif" /></div><div class="SingleStepContainer" ><img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-3-'.$color3.'.gif" /><div class="StepText" style="font-weight:normal;" >Confirm Data</div>
</div></div><div class="Steps" style="width:50%" ><div class="TubeContainer" ><img class="Tube" src="'.$layout_name.'/images/vips/progress-bar-tube-'.$color4.'.gif" /></div><div class="SingleStepContainer" ><img class="StepIcon" src="'.$layout_name.'/images/vips/progress-bar-icon-4-'.$color5.'.gif" />
<div class="StepText" style="font-weight:normal;" >Transfer Result</div></div></div></div></div></div></div>';
$main_content .= '
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="#505050"><td colspan="3"><font color="white"><b>Confirm transaction</b></font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td><b>Image:</b></td><td width="550" colspan="2">';
if(file_exists('images/items/'.$buy_offer['item_id'].'.gif')) {
$main_content .= '<img src="images/items/'.$buy_offer['item_id'].'.gif" height="32" width="32">';
} else {
if ($buy_offer['offer_type'] == 'pacc' or $buy_offer['offer_type'] == 'vipdays'){$main_content .='<img src="images/shop/premium.gif" />';} else $main_content .= '<img src="images/monsters/nophoto.png" height="32" width="32">';
}
$main_content .='<br /><small><b>'.$buy_offer['name'].'</b></small></td></tr>
<tr bgcolor="'.$config['site']['lightborder'].'"><td><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>';
$main_content .='
<tr bgcolor="'.$config['site']['darkborder'].'">
<td><b>Cost:</b></td>
<td width="550" colspan="2"><b>'.$buy_offer['points'].' premium points</b> from your account</td>
</tr>';
$main_content .='
<tr bgcolor="'.$config['site']['lightborder'].'"><td><b>For Player:</b></td><td width="550" colspan="2">'.$buy_player->getName().' <small>[<a href="index.php?subtopic=characters&name='.$buy_player->getName().'" target="_blank">View Character</a>]</small></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td><b>Confirm Transaction ?</b></td>
<td><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST">
<input type="hidden" name="buy_confirmed" value="yes">
<input type="hidden" name="buy_id" value="'.$buy_id.'">
<input type="hidden" name="buy_from" value="'.urlencode($new_name).'">
<input type="hidden" name="buy_name" value="'.urlencode($buy_name).'">
<input type="submit" value="Accept" class="btn btn-success" />
</form>
</td>
<td>
<form action="index.php?subtopic=shopsystem" method="POST">
<input type="submit" value="Cancel" class="btn btn-danger" />
</form>
</td>
</tr>
</table><br />';
} else {
$set_session = TRUE;
$_SESSION['viewed_confirmation_page'] = 'yes';
$main_content .= '<center><h2>Confirm Name Changing</h2>
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>Confirm transaction</b></font></td></tr>
<tr bgcolor="#D4C0A1"><td width="130"><b>Name:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
<tr bgcolor="#F1E0C6"><td width="130"><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
<tr bgcolor="#D4C0A1"><td width="130"><b>Cost:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' premium points</b></td></tr>
<tr bgcolor="#F1E0C6"><td width="130"><b>Current Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
<tr bgcolor="#D4C0A1"><td width="130"><b>New Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_from.'</font></td></tr>
<tr bgcolor="#F1E0C6"><td width="130"><b>Change Name?</b></td><td width="275" align="left">
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST">
<input type="hidden" name="buy_confirmed" value="yes">
<input type="hidden" name="buy_id" value="'.$buy_id.'">
<input type="hidden" name="buy_from" value="'.urlencode($buy_from).'">
<input type="hidden" name="buy_name" value="'.urlencode($buy_name).'">
<input type="submit" value="Accept">
</form>
</td>
<td align="right"><form action="index.php?subtopic=shopsystem" method="POST">
<input type="submit" value="Cancel">
</form>
</td>
</tr>
</table>';}}} 
else {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="5" WIDTH="100%">
<tr BGCOLOR="'.$config['site']['vdarkborder'].'">
<td CLASS="white"><b>Error</b></td>
</tr>
<tr BGCOLOR='.$config['site']['darkborder'].'>
<td>Player with name <b>'.$buy_name.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a>.</td>
</tr>
</TABLE>';
}
} else {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="4" WIDTH="100%">
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD CLASS=white><B>Shoping Error</B></TD>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<td>
<TABLE BORDER="0" CELLSPACING="1" cellpadding="4">
<TR>
<TD>Invalid name format. Please <a href="index.php?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a>.</TD>
</TR>
</TABLE>
</td>
</tr>
</TABLE><br />';}
} else {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="5" WIDTH="100%">
<tr BGCOLOR="'.$config['site']['vdarkborder'].'">
<td CLASS="white"><b>Error</b></td>
</tr>
<tr BGCOLOR='.$config['site']['darkborder'].'>
<td>For this item you need <b>'.$buy_offer['points'].'</b> points. You have only <b>'.$user_premium_points.'</b> premium points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy premium points.</td>
</tr>
</TABLE>';
}}
else {
$main_content .= '<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="5" WIDTH="100%">
<tr BGCOLOR="'.$config['site']['vdarkborder'].'">
<td CLASS="white"><b>Error</b></td>
</tr>
<tr BGCOLOR='.$config['site']['darkborder'].'>
<td>Offer with ID <b>'.$buy_id.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem">select item</a> again.</td>
</tr>
</TABLE>';
}}}}
if(!$set_session) {
unset($_SESSION['viewed_confirmation_page']);
}}
    elseif($action == 'show_history') {
        if(!$logged) {
            $main_content .= 'Please login first.';
        } else{
            $items_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_history_item').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
            if(is_object($items_history_received)) {
                foreach($items_history_received as $item_received) {
                    if($account_logged->getId() == $item_received['to_account'])
                        $char_color = 'green';
                    else
                        $char_color = 'red';
                        $items_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$item_received['to_name'].'</font></td><td>';
                    if($account_logged->getId() == $item_received['from_account'])
                        $items_received_text .= '<i>Your account</i>';
                    else
                        $items_received_text .= $item_received['from_nick'];
                        
                        $items_received_text .= '</td><td>'.$item_received['offer_id'].'</td><td>'.$item_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $item_received['trans_start']).'</td>';
                    
                    
                    
                    
                    if($item_received['trans_real'] > 0)
                        $items_received_text .= '<td>'.date("j F Y, H:i:s", $item_received['trans_real']).'</td>';
                    else
                        $items_received_text .= '<td><b><font color="red">Not realized yet.</font></b></td>';
                        $items_received_text .= '</tr>';
                }
            }
            $itemsguild_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shopguild_history_item').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
            if(is_object($itemsguild_history_received)) {
                foreach($itemsguild_history_received as $itemguild_received) {
                    if($account_logged->getId() == $itemguild_received['to_account'])
                        $char_color = 'green';
                    else
                        $char_color = 'red';
                        $itemsguild_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$itemguild_received['to_name'].'</font></td><td>';
                    if($account_logged->getId() == $itemguild_received['from_account'])
                        $itemsguild_received_text .= '<i>Your account</i>';
                    else
                        $itemsguild_received_text .= $itemguild_received['from_nick'];
                        
                        $itemsguild_received_text .= '</td><td>'.$itemguild_received['offer_id'].'</td><td>'.$itemguild_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $itemguild_received['trans_start']).'</td>';
                    
                    
                    
                    
                    if($itemguild_received['trans_real'] > 0)
                        $itemsguild_received_text .= '<td>'.date("j F Y, H:i:s", $itemguild_received['trans_real']).'</td>';
                    else
                        $itemsguild_received_text .= '<td><b><font color="red">Not realized yet.</font></b></td>';
                        $itemsguild_received_text .= '</tr>';
                }
            }
            $paccs_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_history_pacc').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
            if(is_object($paccs_history_received)) {
                foreach($paccs_history_received as $pacc_received) {
                    if($account_logged->getId() == $pacc_received['to_account'])
                        $char_color = 'green';
                    else
                        $char_color = 'red';
                        $paccs_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$pacc_received['to_name'].'</font></td><td>';
                    if($account_logged->getId() == $pacc_received['from_account'])
                        $paccs_received_text .= '<i>Your account</i>';
                    else
                        $paccs_received_text .= $pacc_received['from_nick'];
                        $paccs_received_text .= '</td><td>'.$pacc_received['pacc_days'].' days</td><td>'.$pacc_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $pacc_received['trans_real']).'</td></tr>';
                }
            }
            $paccsguild_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shopguild_history_pacc').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
            if(is_object($paccsguild_history_received)) {
                foreach($paccsguild_history_received as $paccguild_received) {
                    if($account_logged->getId() == $paccguild_received['to_account'])
                        $char_color = 'green';
                    else
                        $char_color = 'red';
                        $paccsguild_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$paccguild_received['to_name'].'</font></td><td>';
                    if($account_logged->getId() == $paccguild_received['from_account'])
                        $paccsguild_received_text .= '<i>Your account</i>';
                    else
                        $paccsguild_received_text .= $paccguild_received['from_nick'];
                        $paccsguild_received_text .= '</td><td>'.$paccguild_received['pacc_days'].' days</td><td>'.$paccguild_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $paccguild_received['trans_real']).'</td></tr>';
                }
            }
            $main_content .= '<center><h1>Transactions History</h1></center>';
            if(!empty($items_received_text)) 
                $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="6"><font color="white" size="4"><b>&nbsp;ShopServer Item Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Item ID</b></td><td><b>Cost</b></td><td><b>Data da compra SITE</b></td><td><b>Data de entrega SERVER</b></td></tr>'.$items_received_text.'</table><br />';
            if(!empty($itemsguild_received_text)) 
                $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="6"><font color="white" size="4"><b>&nbsp;ShopGuild Item Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Item ID</b></td><td><b>Cost</b></td><td><b>Data da compra SITE</b></td><td><b>Data de entrega SERVER</b></td></tr>'.$itemsguild_received_text.'</table><br />';
            if(!empty($paccs_received_text))
                $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;ShopServer VIP Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Duration</b></td><td><b>Cost</b></td><td><b>Added:</b></td></tr>'.$paccs_received_text.'</table><br />';
            if(!empty($paccsguild_received_text))
                $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;ShopGuild VIP Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Duration</b></td><td><b>Cost</b></td><td><b>Added:</b></td></tr>'.$paccsguild_received_text.'</table><br />';
            if(empty($paccs_received_text) && empty($items_received_text))
                $main_content .= 'You did not buy/receive any items or PACC.';
            if(empty($paccsguild_received_text) && empty($itemsguild_received_text))
                $main_content .= 'You did not buy/receive any items or PACC.';
        }
    }
}
if(!$logged)
$main_content .= '<br /><center><div class="notice"><b>Please login to see how much points you have</b></div></center>';
else
if($account_logged->getCustomField("premium_points") <= 0)
$main_content .='<br /><center><div class="error"><b>You do not have premium points available.</b><br /><br /><form action="index.php?subtopic=doacao" method="post"><input type="submit" value="Buy now Premium Points here!" class="btn btn-success" /></form></div></center>'; 
else
if($account_logged->getCustomField("premium_points") >= 1)
$main_content .='<br /><center><div class="success" style="width: 300px;">You have&nbsp;<b>'.$account_logged->getCustomField("premium_points").'</b>&nbsp;premium points available</div></center>';

else
$main_content .= '
<div class="error">
Shop for disabled the internal maintenance, back in a moment with our standard systems.<br /><br /><b><small>Graciously, Staff</small></b>
</div>
';
?> 

[CoyoteStark 16]

ja observou o ot comunication na database? 

ja que esta tudo certo com o shop.lua

Editado Maio 16, 2016 por CoyoteStark (veja o histórico de edições)

[vitorxx 4]

Tudo certo com o ot communication tambem

[vitorxx 4]

UP