(Resolvido)Problema no History do gesior acc

[duhisback 1]

Galera estou com um problema no meu gesior acc, não sei o que está causando esse problema, que funciona da seguinte forma!

Eu compro um item no shop, ele chega no char normal, mas não está ficando salvo os dados no history e nem no banco de dados na tabela "

z_shop_history_item" alguém pode me ajudar?

 

Lembrando que vip days ele ta salvando no history normal

 

segue o systema de shop do meu gesior e também o shop.lua do globalevents

 

shopadmin.php

  Mostrar conteúdo oculto

<?PHP
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
    $offertype = $_REQUEST['offer_type'];
    if((empty($action)) AND (empty($offertype))) {
            $main_content .= '<br>
                                                        <div class="TableShadowContainerRightTop" >
                                                            <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                        </div>
                                                        <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                            <div class="TableContentContainer" >
                                                                <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >
                                                                    <tr>
                                                                        <td><center><font size="5"><a href="?subtopic=shopadmin&action=addoffer">ADD SHOP OFFER</a></font></center></td>
                                                                    </tr>                                    
                                                                </table>
                                                            </div>
                                                        </div>                                            
                                                        <div class="TableShadowContainer" >
                                                            <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                                <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                                <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                            </div>
                                                        </div>
                                                    </td>
                                                        <div class="TableShadowContainerRightTop" >
                                                            <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                        </div>
                                                        <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                            <div class="TableContentContainer" >
                                                                <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >
                                                                    <tr>
                                                                        <td><center><font size="5"><a href="?subtopic=shopadmin&action=points">ADD POINTS</a></font></center></td>
                                                                    </tr>                                    
                                                                </table>
                                                            </div>
                                                        </div>                                            
                                                        <div class="TableShadowContainer" >
                                                            <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                                <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                                <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                            </div>
                                                        </div>
                                                    </td>';
    }
    if($action == "addoffer"){
        $shop_points = stripslashes(ucwords(strtolower(trim($_REQUEST['shop_points']))));
        $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
        if(empty($shop_points)) {
            $main_content .= '<table border="0"><tr><td  align="center"><b>Select offer type:</b></td><td><table border="0" ><tr bgcolor="#505050">
                <td><font color="white">Item</td><td><font color="white">Item VIP</td><td><font color="white">Container</td><td><font color="white">Pacc</td><td><font color="white">VIP Days</td><td><font color="white">Redskull</td>
                <td><font color="white">Unban</td><td><font color="white">Changename</td><td><font color="white">Outfit</td></tr><tr bgcolor="#D4C0A1"><form action="" method="post">
                <td align="center"><input type="radio" name="offer_type" value="item" onClick="this.form.submit()"></td></lable>
                <td align="center"><input type="radio" name="offer_type" value="itemvip" onClick="this.form.submit()"></td></lable>
                <td align="center"><input type="radio" name="offer_type" value="container" onClick="this.form.submit()"></td>
                <td align="center"><input type="radio" name="offer_type" value="pacc" onClick="this.form.submit()"></td>
                <td align="center"><input type="radio" name="offer_type" value="vipdays" onClick="this.form.submit()"></td>
                <td align="center"><input type="radio" name="offer_type" value="redskull" onClick="this.form.submit()"></td>
                <td align="center"><input type="radio" name="offer_type" value="unban" onClick="this.form.submit()"></td>
                <td align="center"><input type="radio" name="offer_type" value="changename" onClick="this.form.submit()"></td>
                <td align="center"><input type="radio" name="offer_type" value="outfit" onClick="this.form.submit()"></td>
                </form></tr></table></td></tr>';
            $main_content .= '<form action="?subtopic=shopadmin&action=addoffer&offer_type='.$shop_offer_type.'" method="post" ><table border="0"><tr>
                <td align="center" ><b>Points:</b></td><td><input type="textbox" name="shop_points" maxlenght="7" style="width: 70px"></td></tr>';
            if($_REQUEST['offer_type'] == 'container'){
                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                    <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                    <tr><td align="center" ><b>Count Container:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>
                    <tr><td align="center" ><b>Item ID:</b></td>
                    <td><input type="text" name="shop_itemid2" maxlenght="7" style="width: 70px" ></td></tr>
                    <tr><td align="center" ><b>Count Item:</b></td>
                    <td><input type="text" name="shop_count2" maxlenght="7" style="width: 70px" ></td></tr>';
            }
            if($_REQUEST['offer_type'] == 'item'){
                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                    <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                    <tr><td align="center"><b>Item Count:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
            }
            if($_REQUEST['offer_type'] == 'itemvip'){
                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                    <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                    <tr><td align="center"><b>Item Count:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
            }
            if($_REQUEST['offer_type'] == 'pacc'){
                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
            }
            if($_REQUEST['offer_type'] == 'vipdays'){
                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';            }
            
            if($_REQUEST['offer_type'] == 'outfit')
                $main_content .= '
                <tr><td align="center" ><b>Offer Name:</b></td>
                    <td><select name="shop_offer_name">
                      <option value="Citizen">Citizen</option>
                      <option value="Hunter">Hunter</option>
                      <option value="Mage">Mage</option>
                      <option value="Knight">Knight</option>
                      <option value="Noblewoman">Noblewoman</option>
                      <option value="Summoner">Summoner</option>
                      <option value="Warrior">Warrior</option>
                      <option value="Barbarian">Barbarian</option>
                      <option value="Druid">Druid</option>
                      <option value="Wizard">Wizard</option>
                      <option value="Oriental">Oriental</option>
                      <option value="Pirate">Pirate</option>
                      <option value="Assassin">Assassin</option>
                      <option value="Beggar">Beggar</option>
                      <option value="Shaman">Shaman</option>
                      <option value="Norsewoman">Norsewoman</option>
                      <option value="Nightmare">Nightmare</option>
                      <option value="Jester">Jester</option>
                      <option value="Brotherhood">Brotherhood</option>
                      <option value="Demonhunter">Demonhunter</option>
                      <option value="Yalaharian">Yalaharian</option>
                      <option value="Warmaster">Warmaster</option>
                      <option value="Wayfarer">Wayfarer</option>
                    </select></td>';
            else
            $main_content .= '
            <tr><td align="center" ><b>Offer Description:</b></td>
            <td ><textarea name="shop_offer_description" rows="2" cols="35"></textarea></td></tr>
            <tr><td align="center" ><b>Offer Name:</b></td>
            <td><input type="text" name="shop_offer_name" maxlenght="40" style="width: 200px" ></td></tr>';
            
                        
            
            $main_content .= '
            </table>
            <input name="submit" type="submit" value="Submit" /></form>
                <form action="?subtopic=shopadmin&action=addoffer" method="post" >
                <input name="submit" type="submit" value="Reset" /></form>';
            $main_content .= '<form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        } else {
            $shop_points = stripslashes(trim($_POST['shop_points']));
            $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
            $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
            $shop_count1 = stripslashes(trim($_POST['shop_count1']));
            $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
            $shop_count2 = stripslashes(trim($_POST['shop_count2']));
            $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
            $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
            $SQL->query('INSERT INTO `z_shop_offer` (id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid) VALUES (NULL, '.$SQL->quote($shop_points).', '.$SQL->quote($shop_itemid1).', '.$SQL->quote($shop_count1).', '.$SQL->quote($shop_itemid2).', '.$SQL->quote($shop_count2).', '.$SQL->quote($shop_offer_type).', '.$SQL->quote($shop_offer_description).', '.$SQL->quote($shop_offer_name).', 0)');
            $main_content .= '<center><h2><font color="red">Added to Shop:</font></h2></center><hr/>
                <tr><td align="center" ><b>Points:</b></td>
                <td>'.$shop_points.'</td></tr><br>';
            if($shop_offer_type == 'container'){
                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                    <td>'.$shop_itemid1.'</td></tr><br>
                    <tr><td align="center" ><b>Count Container:</b></td>
                    <td>'.$shop_count1.'</td></tr><br>
                    <tr><td align="center" ><b> Item ID (in Container):</b></td>
                    <td>'.$shop_itemid2.'</td></tr><br>
                    <tr><td align="center" ><b>Count Item (in Container):</b></td>
                    <td>'.$shop_count2.'</td></tr><br>';
            }
            if ($shop_offer_type == 'item'){
                $main_content .= '<tr><td align="center" ><b>Item ID:</b></td>
                    <td>'.$shop_itemid1.'</td></tr><br>
                    <tr><td align="center" ><b>Count Item:</b></td>
                    <td>'.$shop_count1.'</td></tr><br>';
            }
            if ($shop_offer_type == 'itemvip'){
                $main_content .= '<tr><td align="center" ><b>Item ID:</b></td>
                    <td>'.$shop_itemid1.'</td></tr><br>
                    <tr><td align="center" ><b>Count Item:</b></td>
                    <td>'.$shop_count1.'</td></tr><br>';
            }
            if ($shop_offer_type == 'pacc'){
                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                    <td>'.$shop_count1.'</td></tr><br>';
            }
            if ($shop_offer_type == 'vipdays'){
                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                    <td>'.$shop_count1.'</td></tr><br>';
            }
            $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
                <td>'.$shop_offer_type.'</td></tr><br>
                <tr><td align="center" ><b>Offer Description:</b></td>
                <td>'.$shop_offer_description.'</td></tr><br>
                <tr><td align="center" ><b>Offer Name:</b></td>
                <td>'.$shop_offer_name.'</td></tr>
                <br><form action="?subtopic=shopadmin&action=addoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        }
    }
    if($action == "viewoffer") {
        $items = simplexml_load_file($config['site']['server_path'].'/data/items/items.xml') or die('<b>Could not load items!</b>');
        foreach($items->item as $v)
            $itemList[(int)$v['id']] = $v['name'];
        $order = array("id" => "id", "points" => "points", "offer_type" => "offer_type", "itemid1" => "itemid1", "itemid2" => "itemid2");
        $main_content .= '<center><table width="550"><tr BGCOLOR="#505050"><td width="5"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'id') . '" class=white>ID:</td><td width="5"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'points') . '" class=white>Points:</td><td width="7">
            <font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'itemid1') . '" class=white>Item ID:</td><td width="5"><font color="white">Count:</td><td width="7"><center><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'itemid2') . '" class=white>Container ID:</center></td><td width="5"><font color="white">Count:</td><td width="7"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'offer_type') . '" class=white>Offer Type:</td>
            <td width="85"><font color="white">Offer Description:</td><td width="30"><font color="white">Offer Name:</td><td width="30"></td></tr>';
        $shopoffers = $SQL->query('SELECT id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid FROM z_shop_offer ' . makeOrder($order, 'order', 'id'));
        foreach($shopoffers as $shop) {
            $main_content .= '</B><tr BGCOLOR="#D4C0A1"><td align="center">'.$shop['id'].'<td align="center">'.$shop['points'].'</td>';
            if($shop['itemid1'] == "0") {
                $main_content .= '<td align="center">'.$shop['itemid1'].'<br></td>';
            } else {
                $main_content .= '<td align="center">'.$shop['itemid1'].'<br>(' . $itemList[(int)$shop['itemid1']] . ')</td>';
            }
            $main_content .= '<td align="center">'.$shop['count1'].'</td>';
            if($shop['itemid2'] == "0") {
                $main_content .= '<td align="center">'.$shop['itemid2'].'</td>';
            } else {
                $main_content .= '<td align="center">'.$shop['itemid2'].'<br>(' . $itemList[(int)$shop['itemid2']] . ')</td>';
            }
            $main_content .= '<td align="center">'.$shop['count2'].'</td><td align="center">'.$shop['offer_type'].'</td><td align="left">'.$shop['offer_description'].'</td><td align="left">'.$shop['offer_name'].'</td>';
            $main_content .= '<td align="center"><a href="?subtopic=shopadmin&action=editoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/edit_news.png" border="0"></a><br><br><a href="?subtopic=shopadmin&action=deleteoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/delete_news.png" border="0"></a></td>';
        }
        $main_content .= '</td></tr></TABLE><br><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
    }
    if($action == "deleteoffer") {
        $id = (int) $_REQUEST['id'];
        $SQL->query('DELETE FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
        $main_content .= '<center>Shop offer has been deleted.</center><br><center><form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form></center>';
    }
    if($action == "editoffer") {
        $id = (int) $_REQUEST['id'];
        $shopoffers = $SQL->query('SELECT * FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
        foreach($shopoffers as $shop) {
            $main_content .= '<form action="?subtopic=shopadmin&action=edited&id='.$id.'" method="post" ><table border="0"><tr><td align="center" ><b>Points:</b></td>
                <td><input type="textbox" name="shop_points" maxlenght="7" value="'.$shop['points'].'" style="width: 70px"></td></tr>';
            if($shop['offer_type'] == 'container'){
                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                    <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                    <tr><td align="center" ><b>Count Container:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>
                    <tr><td align="center" ><b>Item ID:</b></td>
                    <td><input type="text" name="shop_itemid2" maxlenght="7" value="'.$shop['itemid2'].'" style="width: 70px" ></td></tr>
                    <tr><td align="center" ><b>Count Item:</b></td>
                    <td><input type="text" name="shop_count2" maxlenght="7" value="'.$shop['count2'].'" style="width: 70px" ></td></tr>';
            }
            if($shop['offer_type'] == 'item'){
                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                    <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                    <tr><td align="center"><b>Item Count:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>';
            }
            if($shop['offer_type'] == 'itemvip'){
                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                    <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                    <tr><td align="center"><b>Item Count:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>';
            }
            if($shop['offer_type'] == 'pacc'){
                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
            }
            if($shop['offer_type'] == 'vipdays'){
                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                    <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
            }
            $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
                <td><input type="text" name="shop_offer_type" value="'.$shop['offer_type'].'" maxlenght="40" style="width: 200px" ></td></tr>
                <tr><td align="center" ><b>Offer Description:</b></td>
                <td ><textarea name="shop_offer_description" rows="2" cols="35">'.$shop['offer_description'].'</textarea></td></tr>
                <tr><td align="center" ><b>Offer Name:</b></td>
                <td><input type="text" name="shop_offer_name" value="'.$shop['offer_name'].'" maxlenght="40" style="width: 200px" ></td></tr>
                <tr><td><input name="submit" type="submit" value="Submit" /></form></td><td></td></tr></table>';
            $main_content .= '<form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        }
    }
    if($action == "edited") {
        $id = (int) $_REQUEST['id'];
        $shop_points = stripslashes(trim($_POST['shop_points']));
        $shop_offer_type = stripslashes(trim($_POST['shop_offer_type']));
        $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
        $shop_count1 = stripslashes(trim($_POST['shop_count1']));
        $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
        $shop_count2 = stripslashes(trim($_POST['shop_count2']));
        $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
        $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
        $SQL->query('UPDATE `z_shop_offer` SET `points` = '.$shop_points.', `itemid1` = '.$SQL->quote($shop_itemid1).', `count1` = '.$SQL->quote($shop_count1).', `itemid2` = '.$SQL->quote($shop_itemid2).', `count2` = '.$SQL->quote($shop_count2).', `offer_type` = '.$SQL->quote($shop_offer_type).', `offer_description` = '.$SQL->quote($shop_offer_description).', `offer_name` = '.$SQL->quote($shop_offer_name).' WHERE `id` = '.$id.';');
        $main_content .= '<b><center>Shop offer successfully edited.</b><br><br><form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form><meta http-equiv="refresh" content="1;url=/?subtopic=shopadmin&action=viewoffer" />';
    }
    if($action == "points") {
        $player = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
        $points = $_POST['points'];
        if(empty($player)) {
            $main_content .= '<form action="?subtopic=shopadmin&action=points" method="post"><B>Enter Character Name:</B><input type="textbox" name="character"><br>
                <B>Enter Points Amount:</B><input type="textbox" name="points"><br><br><input type="submit" value="Submit">
                </form></center><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        } else {
            $player_data = $SQL->query("SELECT * FROM `players` WHERE `name` = '".$player."';")->fetch(); 
            $SQL->query("UPDATE `accounts` SET `premium_points` = `premium_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");
            $SQL->query("UPDATE `accounts` SET `backup_points` = `backup_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");
            $main_content .= '<b><center>'.$points.' Premium Points added to the account of <i>'.$player.'</i> !</b></center><br>
                <form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        }
    }
} else {
    $main_content .= 'Sorry, you have not the rights to access this page.';
}
?> 

 

 

shopsystem.php

  Mostrar conteúdo oculto

<?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'] == 'outfit') {
            $offer['id'] = $data['id'];
            $offer['type'] = $data['offer_type'];
            $offer['points'] = $data['points'];
            $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_outfit = 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'] == 'outfit') {
                $offer_array['outfit'][$i_outfit]['id'] = $data['id'];
                $offer_array['outfit'][$i_outfit]['points'] = $data['points'];
                $offer_array['outfit'][$i_outfit]['name'] = $data['offer_name'];
                $i_outfit++;
            }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="Table3" 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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 />';}

if($logged){            $main_content .= '
                <a name="History" ></a>
                <div class="TableContainer" >
                    <table class="Table5" cellpadding="0" cellspacing="0">
                        <div class="CaptionContainer" >
                            <div class="CaptionInnerContainer" > 
                                <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/global/content/box-frame-edge.gif);" /></span>
                                <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/global/content/box-frame-edge.gif);" /></span>
                                <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/global/content/table-headline-border.gif);" ></span> 
                                <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/global/content/box-frame-vertical.gif);" /></span>                            
                                <div class="Text" >History</div>
                                <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/global/content/box-frame-vertical.gif);" /></span>
                                <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/global/content/table-headline-border.gif);" ></span> 
                                <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/global/content/box-frame-edge.gif);" /></span>
                                <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/global/content/box-frame-edge.gif);" /></span>
                            </div>
                        </div>
                        <tr>
                            <td>
                                <div class="InnerTableContainer" >
                                    <table style="width:100%;" >';
                                    $main_content .= '
                                        <tr>
                                            <td>
                                                <div class="TableShadowContainerRightTop" >
                                                    <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                </div>
                                                <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                    <div class="TableContentContainer" >
                                                        <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >
                                                            <tr>
                                                                <td>
                                                                    <div style="float:right;" >
                                                                        <form action="?subtopic=shopsystem&action=show_history" method="post" style="padding:0px;margin:0px;" >
                                                                            <div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton_green.gif)" >
                                                                                <div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_green_over.gif);" ></div>
                                                                                    <input class="ButtonText" type="image" name="View History" alt="View History" src="'.$layout_name.'/images/buttons/_sbutton_viewhistory.gif" >
                                                                                </div>
                                                                            </div>
                                                                        </form>
                                                                    </div>
                                                                    <b>Shopping History</b><br/>
                                                                    Contains all historical data of your payments.
                                                                </td>
                                                            </tr>
                                                        </table>
                                                    </div>
                                                </div>
                                                <div class="TableShadowContainer" >
                                                    <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                        <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                        <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                    </div>
                                                </div>
                                            </td>
                                        </tr>';
                                                        
                                $main_content .= '
                                    </table>
                                </div>
                            </table>
                        </div>
                    </td>
                </tr>
                <br/>';}

                //show list of vipdays offers
                if(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">Premium 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="Table3" 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'].' Premium Days</font>&nbsp;<small>('.$pacc['points'].' points)</small><br />'.$pacc['description'].'</td>
                                                                                        <td align="center">';
                                                                                if(!$logged) $main_content .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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>';}
                                                                        $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['vipdays']) > 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="Table3" 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['vipdays']) > 0)
                                                                            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/vip.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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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">Extra Services</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="Table3" 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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 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="Table3" 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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 outfits offers
if(count($offer_list['outfit']) > 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">Outfits</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="Table3" 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['outfit']) > 0) {
foreach($offer_list['outfit'] as $outfit) {
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($layout_name.'/images/outfits/'.$outfit['name'].'_male.gif')) {
        $main_content .= '<img src="'.$layout_name.'/images/outfits/'.$outfit['name'].'_male.gif"">';
        $main_content .= '<img src="'.$layout_name.'/images/outfits/'.$outfit['name'].'_female.gif"">';
    } else {
        $main_content .= '<img src="'.$layout_name.'/images/items/notfound.gif">';
    }    
    
$main_content .= '
</td>
<td><font style="font-size:16px; font-weight:bold;">'.$outfit['name'].' Outfits</font>&nbsp;';
$main_content .='<small>('.$outfit['points'].' points)</small></td>
<td valign="middle" align="center">';
if(!$logged) $main_content .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; else 
$main_content .= '
<form action="index.php?subtopic=shopsystem&action=select_player" method="POST">
<input type="hidden" name="buy_id" value="'.$outfit['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="Table3" 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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="Table3" 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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="Table3" 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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"  height="32" width="32"/></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 .= '<a href="/?subtopic=accountmanagement"><input type="submit" value="Login First" class="btn disabled btn-danger" /></a>'; 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="Table3" 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 ($buy_offer['type'] == 'pacc')
    $main_content .= '<img src="images/shop/premium.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'vipdays')
    $main_content .= '<img src="images/shop/vip.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'redskull') 
    $main_content .= '<img src="images/shop/skull.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'unban') 
    $main_content .= '<img src="images/shop/ban.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'item')
    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 {
        $main_content .= '<img src="images/items/notfound.gif" height="32" width="32">';
    }
elseif ($buy_offer['type'] == 'outfit')
    if(file_exists($layout_name.'/images/outfits/'.$buy_offer['name'].'_male.gif')) {
        $main_content .= '<img src="'.$layout_name.'/images/outfits/'.$buy_offer['name'].'_male.gif"">';
        $main_content .= '<img src="'.$layout_name.'/images/outfits/'.$buy_offer['name'].'_female.gif"">';
    } else {
        $main_content .= '<img src="'.$layout_name.'/images/items/notfound.gif">';
    }    
elseif ($buy_offer['type'] == 'itemvip')
    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 {
        $main_content .= '<img src="images/items/notfound.gif" height="32" width="32">';
    }

$main_content .='
</td>
</tr>
<tr bgcolor="#F1E0C6"><td width="100"><b>Product:</b></td><td width="550">';

if ($buy_offer['type'] == 'pacc')
    $main_content .= 'Premium Days';
elseif ($buy_offer['type'] == 'vipdays')
    $main_content .= 'VIP Days';
elseif ($buy_offer['type'] == 'redskull') 
    $main_content .= 'Remove Skull';
elseif ($buy_offer['type'] == 'unban') 
    $main_content .= 'Unban or Remove Ban';
elseif ($buy_offer['type'] == 'item')
    $main_content .= $itemList[(int)$buy_offer['item_id']];
elseif ($buy_offer['type'] == 'itemvip')
    $main_content .= $itemList[(int)$buy_offer['item_id']];
elseif ($buy_offer['type'] == 'outfit') 
    $main_content .= $buy_offer['name'].' outfits';
    
$main_content .= '. '.$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="Purchase"><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="Purchase 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="?subtopic=donate">
<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 checkName()
{
        if(document.getElementById("newcharname").value=="")
        {
            document.getElementById("name_check").innerHTML = \'<b><font color="red">Please enter new character name.</font></b>\';
            return;
        }
        nameHttp=GetXmlHttpObject();
        if (nameHttp==null)
        {
            return;
        }
        var newcharname = document.getElementById("newcharname").value;
        var url="?subtopic=ajax_check_name&name=" + newcharname + "&uid="+Math.random();
        nameHttp.onreadystatechange=NameStateChanged;
        nameHttp.open("GET",url,true);
        nameHttp.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.'">
<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">Change Name</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="Table3" 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/global/content/table-shadow-rt.gif);" ></div>
</div>
<div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<table border="0" cellpadding="4" cellspacing="1" width="100%">
<tr bgcolor="#505050">
<td colspan="2"><b class="white">You must be offline to change the 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="submit" value="New Name" class="btn btn-success"/>';}
$main_content .=' &nbsp;&nbsp;&nbsp;&nbsp;<form action="index.php?subtopic=shopsystem" method="post"><input type="submit" value="Back to Shop" class="btn btn-primary" /></form></td>
</tr>
</table>
</div>
</div>                                            
<div class="TableShadowContainer" >
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
</div>
</div>
</td>
</tr>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</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);
$nomedoComprador = $buy_player_account->getName();
if($player_premdays > 0){
    $newVipDays = $player_premdays + ($buy_offer['days']);
    $merda = $SQL->query("UPDATE `accounts` SET `premdays` = '$newVipDays' WHERE `name` = '$nomedoComprador'");
}else{
    $newVipDays2 = ($buy_offer['days']);
    $merda = $SQL->query("UPDATE `accounts` SET `premdays` = '$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>Premium 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'] == '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'];
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, offer_desc, 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']).', \'0003\', \'\', \'wait\', '.$SQL->quote(time()).', \'0\');';
$SQL->query($save_transaction);
$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') {
    
    $charID = $buy_player->getCustomField('id');
    $newchar_errors = array();
    $newchar_name = ucwords(strtolower(trim($buy_from)));
    if(empty($newchar_name))
        $newchar_errors[] = 'Please enter a new name for your character!';
    if(!check_name_new_char($newchar_name))
        $newchar_errors[] = 'This name contains invalid letters, words or format. Please use only a-Z, - , \' and space.';
        $check_name_in_database = new Player();
        $check_name_in_database->find($newchar_name);
    if($check_name_in_database->isLoaded())
        $newchar_errors[] = 'This name is already used. Please choose another name!';
 
        $charToEdit = new Player($charID);
    if(!$charToEdit->isLoaded())
        $newchar_errors[] = 'This player does not exist.';
    if($charToEdit->isOnline())
        $newchar_errors[] = 'This player is ONLINE. Logout first.';
    elseif($account_logged->getID() != $charToEdit->getAccountID())
        $newchar_errors[] = 'This player is not on your account.';
 
    if(empty($newchar_errors))
    {
        $main_content .= '<center>Name of character <b>' . htmlspecialchars($charToEdit->getName()) . '</b> changed to <b>' . htmlspecialchars($newchar_name) . '</b></center><br><br>';
        $charToEdit->setName($newchar_name);
        $charToEdit->save();
        $account_logged->setCustomField('premium_points', $account_logged->getCustomField('premium_points') - $buy_offer['points']);
        $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, offer_desc, 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']).', \'0001\', \'\', \'wait\', '.$SQL->quote(time()).', \'0\');';
        $SQL->query($save_transaction);
    }
    else
    {
        $main_content .= 'Some errors occured:<br />';
        foreach($newchar_errors as $e)
        {
            $main_content .= '<li>' . $e . '</li>';
        }
        $main_content .= '<br /><a href="index.php?subtopic=shopsystem">Go back</a>';
    }
}

////////////////////////////////
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'];

$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, offer_desc, 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']).', \'0002\', \'\', \'wait\', '.$SQL->quote(time()).', \'0\');';
$SQL->query($save_transaction);

$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, offer_desc, 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 />';}

//////////////////////////

elseif($buy_offer['type'] == 'outfit') {
    
$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['online'] >= '0') { 
    
$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_outfit\', \'\', \'\', '.$SQL->quote($buy_offer['name']).', \'\', \'outfit\', '.$SQL->quote($buy_offer['name']).', '.$SQL->quote($buy_offer['points']).', \'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, offer_desc, 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']).', \'0004\', '.$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'];

$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>Outfit added successfully!</b></td>
</TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<TD>
The <b>'.$buy_offer['name'].'</b> outfits 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 />';}
} else {
$main_content .= '<center><b>'.$buy_player->getName().' has to be offline to complete transaction!.</b><br /><br /><a href="index.php?subtopic=shopsystem">Go back</a><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, offer_desc, 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, offer_desc, 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 .= '
<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">Shop Box</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/global/content/table-shadow-rt.gif);" ></div>
</div>
<div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<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 ($buy_offer['type'] == 'pacc')
    $main_content .= '<img src="images/shop/premium.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'vipdays')
    $main_content .= '<img src="images/shop/vip.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'redskull') 
    $main_content .= '<img src="images/shop/skull.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'unban') 
    $main_content .= '<img src="images/shop/ban.gif" height="32" width="32" />';
elseif ($buy_offer['type'] == 'item')
    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 {
        $main_content .= '<img src="images/items/notfound.gif" height="32" width="32">';
    }
elseif ($buy_offer['type'] == 'outfit')
    if(file_exists($layout_name.'/images/outfits/'.$buy_offer['name'].'_male.gif')) {
        $main_content .= '<img src="'.$layout_name.'/images/outfits/'.$buy_offer['name'].'_male.gif"">';
        $main_content .= '<img src="'.$layout_name.'/images/outfits/'.$buy_offer['name'].'_female.gif"">';
    } else {
        $main_content .= '<img src="'.$layout_name.'/images/items/notfound.gif">';
    }    
    
elseif ($buy_offer['type'] == 'itemvip')
    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 {
        $main_content .= '<img src="images/items/notfound.gif" 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>
</div>
</div>                                            
<div class="TableShadowContainer" >
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
</div>
</div>
</td>
</tr>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div><br />';
} else {
$set_session = TRUE;
$_SESSION['viewed_confirmation_page'] = 'yes';
$main_content .= '<center>
<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">Shop Box</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="Table3" 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/global/content/table-shadow-rt.gif);" ></div>
</div>
<div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
<div class="TableContentContainer" >
<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>
</div>
</div>                                            
<div class="TableShadowContainer" >
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
</div>
</div>
</td>
</tr>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
';
}}} 
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($item_received['offer_id'] != 0001 && $item_received['offer_id'] != 0002 && $item_received['offer_id'] != 0003 && $item_received['offer_id'] != 0004)
                    {    
                        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>';
                    }        
                            
                    else {
                                
                        $services_received_text .= '<tr bgcolor="#F1E0C6"><td>';
                        
                        if($item_received['offer_id'] == 0001)    
                            $services_received_text .= 'Character name <b>'.$item_received['to_name'].'</b> changed to name <b>'.$item_received['from_nick'].'</b>.';
                        elseif ($item_received['offer_id'] == 0002)
                            $services_received_text .= 'Skull removed from character name <b>'.$item_received['to_name'].'</b>.';
                        elseif ($item_received['offer_id'] == 0003)
                            $services_received_text .= 'The character <b>'.$item_received['to_name'].'</b> has been unbanned.';
                        elseif ($item_received['offer_id'] == 0004)
                            $services_received_text .= 'The <b>'.$item_received['offer_desc'].'</b> outfits to character <b>'.$item_received['to_name'].'</b> .';
                        
                        $services_received_text .= '</td>';            
                        
                        $services_received_text .= '<td>'.$item_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $item_received['trans_start']).'</td>';
                        
                        $services_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($itemguild_received['offer_id'] != 0001 && $itemguild_received['offer_id'] != 0002 && $itemguild_received['offer_id'] != 0003)
                    {    
                        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>';
                    }        
                            
                    else {
                                
                        $servicesguild_received_text .= '<tr bgcolor="#F1E0C6"><td>';
                        
                        if($itemguild_received['offer_id'] == 0001)    
                            $servicesguild_received_text .= 'Character name <b>'.$itemguild_received['to_name'].'</b> changed to name <b>'.$itemguild_received['from_nick'].'</b>.';
                        elseif ($itemguild_received['offer_id'] == 0002)
                            $servicesguild_received_text .= 'Skull removed from character name <b>'.$itemguild_received['to_name'].'</b>.';
                        elseif ($itemguild_received['offer_id'] == 0003)
                            $servicesguild_received_text .= 'The character <b>'.$itemguild_received['to_name'].'</b> has been unbanned.';
                        
                        $servicesguild_received_text .= '</td>';            
                        
                        $servicesguild_received_text .= '<td>'.$itemguild_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $itemguild_received['trans_start']).'</td>';
                        
                        $servicesguild_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 .= '
<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 | Items VIP\'s Transactions</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="Table3" 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">
<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><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>Buy on site</b></td><td><b>Received on game</b></td></tr>'.$items_received_text.'</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>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </td>
            </tr>
        </tbody>
    </table>
</div><br />';

if(!empty($services_received_text)) 
                $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 Transactions</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="Table3" 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">
<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><tr bgcolor="#D4C0A1"><td><b>Service description:</b></td><td><b>Cost</b></td><td><b>Buy on site</b></td></tr>'.$services_received_text.'</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>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </td>
            </tr>
        </tbody>
    </table>
</div><br />';

            if(!empty($paccs_received_text))
                $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">Premium/VIP Days Transactions</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="Table3" 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">
<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><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>
                                </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>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </td>
            </tr>
        </tbody>
    </table>
</div><br />';
            if(empty($paccs_received_text) && empty($items_received_text) && empty($itemsguild_received_text) && empty($services_received_text))
                $main_content .= '<center>You did not buy/receive any items or PACC.</center><br>';
        }
    }
}
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="?subtopic=donate" 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>
';
?>
 

 

 

shop,lua do global events

  Mostrar conteúdo oculto

-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "data/lib/000-constants.lua")
SHOP_MSG_TYPE = MESSAGE_STATUS_CONSOLE_BLUE
-- time (in seconds) between queries to MySQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
    local result_plr = db.getResult("SELECT * FROM `z_ots_comunication` WHERE `type` = 'login';")
    if(result_plr:getID() ~= -1) then
        while(true) do
            id = tonumber(result_plr:getDataInt("id"))
            action = tostring(result_plr:getDataString("action"))
            delete = tonumber(result_plr:getDataInt("delete_it"))
            cid = getCreatureByName(tostring(result_plr:getDataString("name")))
            if isPlayer(cid) == TRUE then
                local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
                local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
                local container_id = tonumber(result_plr:getDataInt("param3"))
                local container_count = tonumber(result_plr:getDataInt("param4"))
                local add_item_type = tostring(result_plr:getDataString("param5"))
                local add_item_name = tostring(result_plr:getDataString("param6"))
                local received_item = 0
                local full_weight = 0
                if add_item_type == 'container' then
                    container_weight = getItemWeightById(container_id, 1)
                    if isItemRune(itemtogive_id) == TRUE then
                        items_weight = container_count * getItemWeightById(itemtogive_id, 1)
                    else
                        items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                    full_weight = items_weight + container_weight
                else
                    full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    if isItemRune(itemtogive_id) == TRUE then
                        full_weight = getItemWeightById(itemtogive_id, 1)
                    else
                        full_weight = getItemWeightById(itemtogive_id, itemtogive_count)
                    end
                end
                local free_cap = getPlayerFreeCap(cid)
                if full_weight <= free_cap then
                    if add_item_type == 'container' then
                        local new_container = doCreateItemEx(container_id, 1)
                        doItemSetAttribute(new_container, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
                        doItemSetAttribute(new_container, "tid", id)
                        local iter = 0
                        while iter ~= container_count do
                            local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                            doItemSetAttribute(new_item, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
                            doItemSetAttribute(new_item, "tid", id)
                            doAddContainerItemEx(new_container, new_item)
                            iter = iter + 1
                        end
                        received_item = doPlayerAddItemEx(cid, new_container)
                    else
                        local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                        doItemSetAttribute(new_item, "description", 'Bought by ' .. getCreatureName(cid) .. ' [ID:' .. id .. '].')
                        doItemSetAttribute(new_item, "tid", id)
                        received_item = doPlayerAddItemEx(cid, new_item)
                    end
                    if received_item == RETURNVALUE_NOERROR then
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '{BaiakSky Shopping} Entrega do Item '.. add_item_name ..' Feita com Sucesso!.')
                        doPlayerSave(cid)
                        db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                        db.executeQuery("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";")
                    else
                        doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '{BaiakSky Shopping} Sua Backpack Nao Tem Espaco Para Receber o Item '.. add_item_name ..' Por Favor Abra Espaco em Sua Backpack, Estaremos Tentando Entregar o Item Em '.. SQL_interval ..' Segundos!.')
                    end
                else
                    doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. 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
            if not(result_plr:next()) then
                break
            end
        end
        result_plr:free()
    end
    return true
end

 

Editado Dezembro 1, 2018 por duhisback (veja o histórico de edições)

[duhisback 1]

Alguém pode ajudar??

[Celulose 138]

zzz

 

na linha de baixo da função

$account_logged->setCustomField('premium_points

você adiciona

$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, offer_desc, 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']).', \'0002\', \'\', \'wait\', '.$SQL->quote(time()).', \'0\');';

 

 

[duhisback 1]

  Em 01/12/2018 em 04:53, Celulose disse:

zzz

 

na linha de baixo da função

$account_logged->setCustomField('premium_points

você adiciona

$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, offer_desc, 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']).', \'0002\', \'\', \'wait\', '.$SQL->quote(time()).', \'0\');';

 

 

 

Mostrar mais  

E ai amigo eu adicionei essa linha abaixo de todos os 

  Citar

$account_logged->setCustomField('premium_points

Expand   Mostrar mais  

 que não tinha a linha save, mas não funcionou continua do mesmo jeito lembrando que só está salvando quando compro Vip ai fica salvo mas os itens não salva no banco de dados quando eu compro algo!

 

Veja como fica no site e no banco de dados ao comprar o item, não acontece nada.

[duhisback 1]

consegui resolver o problema podem fecharem o tópico, resolvi apenas mudando a tabela no banco de dados!

[f0lp 3]

Execute a query no SQL da sua database:

DROP TABLE IF EXISTS shop_history;CREATE TABLE shop_history(`id` int(11) NOT NULL auto_increment,`to_name` varchar(255) NOT NULL default '0',`to_account` int(11) NOT NULL default '0',`from_nick` varchar(255) NOT NULL,`from_account` int(11) NOT NULL default '0',`price` int(11) NOT NULL default '0',`offer_id` int(11) NOT NULL default '0',`trans_state` varchar(255) NOT NULL,`trans_start` int(11) NOT NULL default '0',`trans_real` int(11) NOT NULL default '0',PRIMARY KEY (`id`));