<script>
// Set the date we're counting down to
var countDownDatex = new Date("Nov 11, 2017 23:59:00").getTime();

// Update the count down every 1 second
var xx = setInterval(function() {

  // Get todays date and time
  var nowx = new Date().getTime();

  // Find the distance between now an the count down date
  var distancex = countDownDatex - nowx;

  // Time calculations for days, hours, minutes and seconds
  var daysx = Math.floor(distancex / (1000 * 60 * 60 * 24));
  var hoursx = Math.floor((distancex % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60));
  var minutesx = Math.floor((distancex % (1000 * 60 * 60)) / (1000 * 60));
  var secondsx = Math.floor((distancex % (1000 * 60)) / 1000);

  // Display the result in the element with id="demo"
  document.getElementById("demo").innerHTML = daysx + "d " + hoursx + "h "
  + minutesx + "m " + secondsx + "s";

  // If the count down is finished, write some text
  if (distancex < 0) {
    clearInterval(xx);
    document.getElementById("demo").innerHTML = "EXPIRA EM INSTANTES";
  }
}, 1000);
</script>

<script>
// Set the date we're counting down to
var countDownDatey = new Date("Nov 10, 2017 23:59:00").getTime();

// Update the count down every 1 second
var xy = setInterval(function() {

  // Get todays date and time
  var nowy = new Date().getTime();

  // Find the distance between now an the count down date
  var distancey = countDownDatey - nowy;

  // Time calculations for days, hours, minutes and seconds
  var daysy = Math.floor(distancey / (1000 * 60 * 60 * 24));
  var hoursy = Math.floor((distancey % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60));
  var minutesy = Math.floor((distancey % (1000 * 60 * 60)) / (1000 * 60));
  var secondsy = Math.floor((distancey % (1000 * 60)) / 1000);

  // Display the result in the element with id="demo"
  document.getElementById("demo3").innerHTML = daysy + "d " + hoursy + "h "
  + minutesy + "m " + secondsy + "s";

  // If the count down is finished, write some text
  if (distancey < 0) {
    clearInterval(xy);
    document.getElementById("demo3").innerHTML = "EXPIRA EM INSTANTES";
  }
}, 1000);
</script>

<script>
// Set the date we're counting down to
var countDownDate = new Date("Nov 22, 2017 23:59:00").getTime();

// Update the count down every 1 second
var x = setInterval(function() {

  // Get todays date and time
  var now = new Date().getTime();

  // Find the distance between now an the count down date
  var distance = countDownDate - now;

  // Time calculations for days, hours, minutes and seconds
  var days = Math.floor(distance / (1000 * 60 * 60 * 24));
  var hours = Math.floor((distance % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60));
  var minutes = Math.floor((distance % (1000 * 60 * 60)) / (1000 * 60));
  var seconds = Math.floor((distance % (1000 * 60)) / 1000);

  // Display the result in the element with id="demo"
  document.getElementById("demo2").innerHTML = days + "d " + hours + "h "
  + minutes + "m " + seconds + "s";

  // If the count down is finished, write some text
  if (distance < 0) {
    clearInterval(x);
    document.getElementById("demo2").innerHTML = "EXPIRA EM INSTANTES";
  }
}, 1000);
</script>

<?PHP

//  ALTER TABLE `z_shop_history_item` CHANGE `offer_id` `offer_id` VARCHAR( 255 ) NOT NULL;
// UPDATE `z_shop_history_item`, `z_shop_offer` SET `z_shop_history_item`.`offer_id` = `z_shop_offer`.`offer_name` WHERE `z_shop_history_item`.`offer_id` = `z_shop_offer`.`id`;

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'];
  }
  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'];
  }
  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'] == 'gold')
  {
    $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'];
  }
  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'] == 'itemvipp')
  {
    $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'] == 'montarias')
  {
    $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'] == 'outfits')
  {
    $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'] == 'itemvippp')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['item_id'] = $data['itemid1'];
    $offer['item_id1'] = $data['itemid2'];
    $offer['item_id2'] = $data['itemid3'];
    $offer['item_count'] = $data['count1'];
    $offer['item_count1'] = $data['count2'];
    $offer['item_count2'] = $data['count3'];
    $offer['points'] = $data['points'];
    $offer['realpoints'] = $data['realpoints'];
    $offer['description'] = $data['offer_description'];
    $offer['prazo'] = $data['prazo'];
    $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'];
  }
  return $offer;
}


function getOfferArray()
{
  $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').';');
  $i_pacc = 0;
  $i_changename = 0;
  $i_item = 0;
  $i_gold = 0;
  $i_itemvip = 0;
  $i_itemvipp = 0;
  $i_montarias = 0;
  $i_outfits = 0;
  $i_itemvippp = 0;
  $i_container = 0;
  $i_unban = 0;
  $i_redskull = 0;
  $i_itemlogout = 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'];
      $i_pacc++;
    }
    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++;
    }
    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'] == 'gold')
    {
      $offer_array['gold'][$i_gold]['id'] = $data['id'];
      $offer_array['gold'][$i_gold]['days'] = $data['count1'];
      $offer_array['gold'][$i_gold]['points'] = $data['points'];
      $offer_array['gold'][$i_gold]['description'] = $data['offer_description'];
      $offer_array['gold'][$i_gold]['name'] = $data['offer_name'];
      $i_gold++;
    }
    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'] == 'itemvipp')
    {
      $offer_array['itemvipp'][$i_itemvipp]['id'] = $data['id'];
      $offer_array['itemvipp'][$i_itemvipp]['item_id'] = $data['itemid1'];
      $offer_array['itemvipp'][$i_itemvipp]['item_count'] = $data['count1'];
      $offer_array['itemvipp'][$i_itemvipp]['points'] = $data['points'];
      $offer_array['itemvipp'][$i_itemvipp]['description'] = $data['offer_description'];
      $offer_array['itemvipp'][$i_itemvipp]['name'] = $data['offer_name'];
      $i_itemvipp++;
    }
    elseif ($data['offer_type'] == 'montarias')
    {
      $offer_array['montarias'][$i_montarias]['id'] = $data['id'];
      $offer_array['montarias'][$i_montarias]['item_id'] = $data['itemid1'];
      $offer_array['montarias'][$i_montarias]['item_count'] = $data['count1'];
      $offer_array['montarias'][$i_montarias]['points'] = $data['points'];
      $offer_array['montarias'][$i_montarias]['description'] = $data['offer_description'];
      $offer_array['montarias'][$i_montarias]['name'] = $data['offer_name'];
      $i_montarias++;
    }
    elseif ($data['offer_type'] == 'outfits')
    {
      $offer_array['outfits'][$i_outfits]['id'] = $data['id'];
      $offer_array['outfits'][$i_outfits]['item_id'] = $data['itemid1'];
      $offer_array['outfits'][$i_outfits]['item_count'] = $data['count1'];
      $offer_array['outfits'][$i_outfits]['points'] = $data['points'];
      $offer_array['outfits'][$i_outfits]['description'] = $data['offer_description'];
      $offer_array['outfits'][$i_outfits]['name'] = $data['offer_name'];
      $i_outfits++;
    }
    elseif ($data['offer_type'] == 'itemvippp')
    {
      $offer_array['itemvippp'][$i_itemvippp]['id'] = $data['id'];
      $offer_array['itemvippp'][$i_itemvippp]['item_id'] = $data['itemid1'];
      $offer_array['itemvippp'][$i_itemvippp]['item_id1'] = $data['itemid2'];
      $offer_array['itemvippp'][$i_itemvippp]['item_id2'] = $data['itemid3'];
      $offer_array['itemvippp'][$i_itemvippp]['item_count'] = $data['count1'];
      $offer_array['itemvippp'][$i_itemvippp]['item_count1'] = $data['count2'];
      $offer_array['itemvippp'][$i_itemvippp]['item_count2'] = $data['count3'];
      $offer_array['itemvippp'][$i_itemvippp]['points'] = $data['points'];
      $offer_array['itemvippp'][$i_itemvippp]['realpoints'] = $data['realpoints'];
      $offer_array['itemvippp'][$i_itemvippp]['description'] = $data['offer_description'];
      $offer_array['itemvippp'][$i_itemvippp]['name'] = $data['offer_name'];
      $offer_array['itemvippp'][$i_itemvippp]['prazo'] = $data['prazo'];
      $i_itemvippp++;
    }
    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++;
    }
  }
  return $offer_array;
}


  if($action == '') {
    unset($_SESSION['viewed_confirmation_page']);

    $main_content .= '
    <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><TABLE BORDER=0><TR><TR>';
    if($logged && $user_premium_points == 1) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center>';
    }
    else if($logged) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center>';
    }

    $main_content .= '<table><tr><td></td></tr></table><font size=3><center><b>[Equipamentos]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=armas">Armas</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=diversos">Diversos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=montarias">Montarias</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=outfits">Outfits</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=ofertas">Ofertas</a><b>]</b></center></font><table><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TABLE>';

    $offer_list = getOfferArray();
    if(count($offer_list['pacc']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Premium Account</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';

        //Pacc


        if(count($offer_list['pacc']) > 0)
          foreach($offer_list['pacc'] as $pacc) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/Premium_Scroll.gif"></td><td><br><b><center>'.$pacc['name'].'</b> (<font color="red">'.$pacc['points'].' Elemental Coins</font>)<br /></center><center>'.$pacc['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$pacc['id'].'"><input type="submit" value="Comprar"><br><b></b></form>';
          }
          $main_content .= '</table>';

      //show list of gold card offers
        if(count($offer_list['gold']) > 0) {
        $main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>Gold Card</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
          foreach($offer_list['gold'] as $gold) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/goldcard.gif"></td><td><b>'.$gold['name'].'</b> ('.$gold['points'].' pontos)<br />'.$gold['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Logue para comprar</b>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$gold['id'].'"><input type="submit" value="Comprar"><br></form>';
          }
          $main_content .= '</table><br />';
        }
              //show list of items offers
      if(count($offer_list['item']) > 0 or count($offer_list['container']) > 0 or count($offer_list['itemlogout']) > 0)
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Equipamentos</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
        if(count($offer_list['item']) > 0) {
          foreach($offer_list['item'] as $item) {

          if($item['points'] == 1) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$item['item_id'].'.png"></td><td><br><b><center>'.$item['name'].'</b> (<font color="red">'.$item['points'].' Elemental Coin</font>)<br /></center><center>'.$item['description'].'</center><br></td><td align="center">';
          }
          else {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$item['item_id'].'.png"></td><td><br><b><center>'.$item['name'].'</b> (<font color="red">'.$item['points'].' Elemental Coins</font>)<br /></center><center>'.$item['description'].'</center><br></td><td align="center">';
          }



            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$item['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><TABLE BORDER=0><TR><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TR></TABLE>';
        }
      //show list of itemsvip offers

        //show list of containers offers
        if(count($offer_list['container']) > 0) {
          $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
          foreach($offer_list['container'] as $container) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$container['id'].'.gif"></td><td><b>'.$container['name'].'</b> ('.$container['points'].' pontos)<br />'.$container['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Login to buy</b>'; else
            $main_content .= '<form action="?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$container['id'].'"><input type="submit" value="Buy '.$container['name'].'"><br><b>for '.$container['points'].' pontos</b></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }
        if(count($offer_list['itemlogout']) > 0) {
          $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Receive Item on Logout</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></font></td><td width="350" align="left"><b>Description</b></font></td><td width="250" align="center"><b>Select product</b></font></td></tr>';
          foreach($offer_list['itemlogout'] as $itemlogout) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemlogout['id'].'.gif"></td><td><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' pontos)<br />'.$itemlogout['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Login to buy</b>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemlogout['id'].'"><input type="submit" value="Buy '.$itemlogout['name'].'"><br><b></b></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }

        //Remove Red Skull
        if(count($offer_list['redskull']) > 0)
          foreach($offer_list['redskull'] as $redskull) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/removerred.png"></td><td><br><b><center>'.$redskull['name'].'</b> (<font color="red">'.$redskull['points'].' Elemental Coins</font>)<br /></center><center>'.$redskull['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$redskull['id'].'"><br><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
        //Unban
        if(count($offer_list['unban']) > 0)
          foreach($offer_list['unban'] as $unban){
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Unban</td><td><b>'.$unban['name'].'</b> ('.$unban['points'].' pontos)<br />'.$unban['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Logue para comprar</b>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$unban['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br>';
  }





  elseif($action == 'ofertas') {
    unset($_SESSION['viewed_confirmation_page']);

    $main_content .= '
    <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><TABLE BORDER=0><TR><TR>';
    if($logged && $user_premium_points == 1) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center>';
    }
    else if($logged) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center>';
    }

    $main_content .= '<table><tr><td></td></tr></table><font size=3><center><b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem">Equipamentos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=armas">Armas</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=diversos">Diversos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=montarias">Montarias</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=outfits">Outfits</a><b>]</b> <b>[Ofertas]</b></center></font><table><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TABLE>';

    $offer_list = getOfferArray();
    if(count($offer_list['pacc']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Premium Account</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';

        //Pacc


            if(count($offer_list['itemvippp']) > 0) {
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Ofertas</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
          foreach($offer_list['itemvippp'] as $itemvippp) {

            if ($itemvippp['points'] == 1) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemvippp['name'].'.png"></td><td><br><center><b>'.$itemvippp['name'].'</b> (De <strike>'.$itemvippp['realpoints'].'</strike> por: <font color="red">'.$itemvippp['points'].' Elemental Coin</font>)<br /></center><center>'.$itemvippp['description'].'<table><tr><td></td></tr></table>'.$itemvippp['prazo'].'</center><br></td><td align="center">';
            }
            else {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemvippp['name'].'.png"></td><td><br><center><b>'.$itemvippp['name'].'</b> (De <strike>'.$itemvippp['realpoints'].'</strike> por: <font color="red">'.$itemvippp['points'].' Elemental Coins</font>)<br /></center><center>'.$itemvippp['description'].'<table><tr><td></td></tr></table>'.$itemvippp['prazo'].'</center><br></td><td align="center">';
            }

            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemvippp['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }
  }



  elseif($action == 'diversos') {
    unset($_SESSION['viewed_confirmation_page']);

    $main_content .= '
    <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><TABLE BORDER=0><TR><TR>';
    if($logged && $user_premium_points == 1) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center>';
    }
    else if($logged) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center>';
    }

    $main_content .= '<table><tr><td></td></tr></table><font size=3><center><b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem">Equipamentos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=armas">Armas</a><b>]</b> <b>[Diversos]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=montarias">Montarias</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=outfits">Outfits</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=ofertas">Ofertas</a><b>]</b></center></font><table><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TABLE>';

    $offer_list = getOfferArray();
    if(count($offer_list['pacc']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Premium Account</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';

        //Pacc


        if(count($offer_list['pacc']) > 0)
          foreach($offer_list['pacc'] as $pacc) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/Premium_Scroll.gif"></td><td><br><b><center>'.$pacc['name'].'</b> (<font color="red">'.$pacc['points'].' Elemental Coins</font>)<br /></center><center>'.$pacc['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$pacc['id'].'"><input type="submit" value="Comprar"><br><b></b></form>';
          }
          $main_content .= '</table>';

      //show list of gold card offers
        if(count($offer_list['gold']) > 0) {
        $main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>Gold Card</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
          foreach($offer_list['gold'] as $gold) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/goldcard.gif"></td><td><b>'.$gold['name'].'</b> ('.$gold['points'].' pontos)<br />'.$gold['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Logue para comprar</b>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$gold['id'].'"><input type="submit" value="Comprar"><br></form>';
          }
          $main_content .= '</table><br />';
        }
              //show list of items offers

      //show list of itemsvip offers
      if(count($offer_list['itemvip']) > 0) {
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Diversos</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
          foreach($offer_list['itemvip'] as $itemvip) {

            if ($itemvip['points'] == 1) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemvip['item_id'].'.png"></td><td><br><b><center>'.$itemvip['name'].'</b> (<font color="red">'.$itemvip['points'].' Elemental Coin</font>)<br /></center><center>'.$itemvip['description'].'</center><br></td><td align="center">';
            }
            else {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemvip['item_id'].'.png"></td><td><br><b><center>'.$itemvip['name'].'</b> (<font color="red">'.$itemvip['points'].' Elemental Coins</font>)<br /></center><center>'.$itemvip['description'].'</center><br></td><td align="center">';
            }

            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemvip['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table>';
        }
        //show list of containers offers
        if(count($offer_list['container']) > 0) {
          $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
          foreach($offer_list['container'] as $container) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$container['id'].'.gif"></td><td><b>'.$container['name'].'</b> ('.$container['points'].' pontos)<br />'.$container['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Login to buy</b>'; else
            $main_content .= '<form action="?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$container['id'].'"><input type="submit" value="Buy '.$container['name'].'"><br><b>for '.$container['points'].' pontos</b></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }
        if(count($offer_list['itemlogout']) > 0) {
          $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Receive Item on Logout</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></font></td><td width="350" align="left"><b>Description</b></font></td><td width="250" align="center"><b>Select product</b></font></td></tr>';
          foreach($offer_list['itemlogout'] as $itemlogout) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemlogout['id'].'.gif"></td><td><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' pontos)<br />'.$itemlogout['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Login to buy</b>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemlogout['id'].'"><input type="submit" value="Buy '.$itemlogout['name'].'"><br><b></b></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }

        //Remove Red Skull
        if(count($offer_list['redskull']) > 0)
          foreach($offer_list['redskull'] as $redskull) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/removerred.png"></td><td><br><b><center>'.$redskull['name'].'</b> (<font color="red">'.$redskull['points'].' Elemental Coins</font>)<br /></center><center>'.$redskull['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$redskull['id'].'"><br><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
        //Unban
        if(count($offer_list['unban']) > 0)
          foreach($offer_list['unban'] as $unban){
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Unban</td><td><b>'.$unban['name'].'</b> ('.$unban['points'].' pontos)<br />'.$unban['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Logue para comprar</b>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$unban['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br>';



if(count($offer_list['changename']) > 0 or count($offer_list['redskull']) > 0 or count($offer_list['unban']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Mudar Nome</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
        if(count($offer_list['changename']) > 0)
          foreach($offer_list['changename'] as $changename) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/changenick.gif"></td><td><br><b><center>'.$changename['name'].'</b> (<font color="red">'.$changename['points'].' Elemental Coins</font>)<br /></center><center>'.$changename['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$changename['id'].'"><br><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</table><br />';
          }
          $main_content .= '</table><br>';



  }
















  elseif($action == 'montarias') {
    unset($_SESSION['viewed_confirmation_page']);

    $main_content .= '
    <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><TABLE BORDER=0><TR><TR>';
    if($logged && $user_premium_points == 1) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center>';
    }
    else if($logged) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center>';
    }

    $main_content .= '<table><tr><td></td></tr></table><font size=3><center><b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem">Equipamentos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=armas">Armas</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=diversos">Diversos</a><b>]</b> <b>[Montarias]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=outfits">Outfits</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=ofertas">Ofertas</a><b>]</b></center></font><table><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TABLE>';

    $offer_list = getOfferArray();
    if(count($offer_list['pacc']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Premium Account</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';

        //Pacc


      if(count($offer_list['montarias']) > 0) {
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Montarias</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
          foreach($offer_list['montarias'] as $montarias) {

            if ($montarias['points'] == 1) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$montarias['name'].'.gif"></td><td><br><b><center>'.$montarias['name'].'</b> (<font color="red">'.$montarias['points'].' Elemental Coin</font>)<br /></center><center>'.$montarias['description'].'</center><br></td><td align="center">';
            }
            else {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$montarias['name'].'.gif"></td><td><br><b><center>'.$montarias['name'].'</b> (<font color="red">'.$montarias['points'].' Elemental Coins</font>)<br /></center><center>'.$montarias['description'].'</center><br></td><td align="center">';
            }

            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$montarias['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }

  }









  elseif($action == 'outfits') {
    unset($_SESSION['viewed_confirmation_page']);

    $main_content .= '
    <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><TABLE BORDER=0><TR><TR>';
    if($logged && $user_premium_points == 1) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center>';
    }
    else if($logged) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center>';
    }

    $main_content .= '<table><tr><td></td></tr></table><font size=3><center><b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem">Equipamentos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=armas">Armas</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=diversos">Diversos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=montarias">Montarias</a><b>]</b> <b>[Outfits]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=ofertas">Ofertas</a><b>]</b></center></font><table><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TABLE>';

    $offer_list = getOfferArray();
    if(count($offer_list['pacc']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Premium Account</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';

        //Pacc


      if(count($offer_list['outfits']) > 0) {
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Outfits</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
          foreach($offer_list['outfits'] as $outfits) {

            if ($outfits['points'] == 1) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$outfits['name'].'.gif"><img src="item_images/'.$outfits['name'].'.png"></td><td><br><b><center>'.$outfits['name'].'</b> (<font color="red">'.$outfits['points'].' Elemental Coin</font>)<br /></center><center>'.$outfits['description'].'</center><br></td><td align="center">';
            }
            else {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$outfits['name'].'.gif"><img src="item_images/'.$outfits['name'].'.png"></td><td><br><b><center>'.$outfits['name'].'</b> (<font color="red">'.$outfits['points'].' Elemental Coins</font>)<br /></center><center>'.$outfits['description'].'</center><br></td><td align="center">';
            }

            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$outfits['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }

  }









  elseif($action == 'armas') {
    unset($_SESSION['viewed_confirmation_page']);

    $main_content .= '
    <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><TABLE BORDER=0><TR><TR>';
    if($logged && $user_premium_points == 1) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center>';
    }
    else if($logged) {
      $main_content .= '<center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center>';
    }

    $main_content .= '<table><tr><td></td></tr></table><font size=3><center><b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem">Equipamentos</a><b>]</b> <b>[Armas]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=diversos">Diversos</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=montarias">Montarias</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=outfits">Outfits</a><b>]</b> <b>[</b><a href="http://avatarworld.org/index.php?subtopic=shopsystem&action=ofertas">Ofertas</a><b>]</b></center></font><table><TR><TR><TR><TR><TD></TD></TR></TR></TR></TR></TABLE>';

    $offer_list = getOfferArray();
    if(count($offer_list['pacc']) > 0 )
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Premium Account</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';

        //Pacc


        if(count($offer_list['pacc']) > 0)
          foreach($offer_list['pacc'] as $pacc) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/Premium_Scroll.gif"></td><td><br><b><center>'.$pacc['name'].'</b> (<font color="red">'.$pacc['points'].' Elemental Coins</font>)<br /></center><center>'.$pacc['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$pacc['id'].'"><input type="submit" value="Comprar"><br><b></b></form>';
          }
          $main_content .= '</table>';

      //show list of gold card offers
        if(count($offer_list['gold']) > 0) {
        $main_content .= '<center><table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>Gold Card</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
          foreach($offer_list['gold'] as $gold) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/goldcard.gif"></td><td><b>'.$gold['name'].'</b> ('.$gold['points'].' pontos)<br />'.$gold['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Logue para comprar</b>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$gold['id'].'"><input type="submit" value="Comprar"><br></form>';
          }
          $main_content .= '</table><br />';
        }
              //show list of items offers

      //show list of itemsvip offers
      if(count($offer_list['itemvipp']) > 0) {
        $main_content .= '<center><table border="1" cellpadding="3" cellspacing="1" width="746"><tr width="746" bgcolor="#505050"><td colspan="3"><font color="white" size="3"><b>&nbsp;Armas</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="100" align="center"><b>Imagem</b></td><td width="390" align="left"><b><center>Descrição do Produto</center></b></td><td width="160" align="center"><b>Comprar Produto</b></td></tr>';
          foreach($offer_list['itemvipp'] as $itemvipp) {

            if ($itemvipp['points'] == 1) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemvipp['item_id'].'.png"></td><td><br><b><center>'.$itemvipp['name'].'</b> (<font color="red">'.$itemvipp['points'].' Elemental Coin</font>)<br /></center><center>'.$itemvipp['description'].'</center><br></td><td align="center">';
            }
            else {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemvipp['item_id'].'.png"></td><td><br><b><center>'.$itemvipp['name'].'</b> (<font color="red">'.$itemvipp['points'].' Elemental Coins</font>)<br /></center><center>'.$itemvipp['description'].'</center><br></td><td align="center">';
            }

            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemvipp['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }


        //show list of containers offers
        if(count($offer_list['container']) > 0) {
          $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
          foreach($offer_list['container'] as $container) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$container['id'].'.gif"></td><td><b>'.$container['name'].'</b> ('.$container['points'].' pontos)<br />'.$container['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Login to buy</b>'; else
            $main_content .= '<form action="?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$container['id'].'"><input type="submit" value="Buy '.$container['name'].'"><br><b>for '.$container['points'].' pontos</b></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }
        if(count($offer_list['itemlogout']) > 0) {
          $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Receive Item on Logout</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></font></td><td width="350" align="left"><b>Description</b></font></td><td width="250" align="center"><b>Select product</b></font></td></tr>';
          foreach($offer_list['itemlogout'] as $itemlogout) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemlogout['id'].'.gif"></td><td><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' pontos)<br />'.$itemlogout['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Login to buy</b>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemlogout['id'].'"><input type="submit" value="Buy '.$itemlogout['name'].'"><br><b></b></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br />';
        }

        //Remove Red Skull
        if(count($offer_list['redskull']) > 0)
          foreach($offer_list['redskull'] as $redskull) {
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/removerred.png"></td><td><br><b><center>'.$redskull['name'].'</b> (<font color="red">'.$redskull['points'].' Elemental Coins</font>)<br /></center><center>'.$redskull['description'].'</center><br></td><td align="center">';
            if(!$logged) $main_content .= '</br><form action="index.php?subtopic=accountmanagement" method=POST><input type="submit" value="Login"><br></form>'; else
            $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$redskull['id'].'"><br><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
        //Unban
        if(count($offer_list['unban']) > 0)
          foreach($offer_list['unban'] as $unban){
            $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Unban</td><td><b>'.$unban['name'].'</b> ('.$unban['points'].' pontos)<br />'.$unban['description'].'</td><td align="center">';
            if(!$logged) $main_content .= '<b>Logue para comprar</b>'; else
            $main_content .= '</br><form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$unban['id'].'"><input type="submit" value="Comprar"><br></form>';
            $main_content .= '</td></tr>';
          }
          $main_content .= '</table><br>';
  }






  elseif($action == 'select_player') {
    unset($_SESSION['viewed_confirmation_page']);
    if(!$logged) {
      $main_content .= 'You are not logged in. <a href="?subtopic=accountmanagement">Log in</a> first to make a donate.';
    } else {
      $buy_id = (int) $_REQUEST['buy_id'];
      if(empty($buy_id)) {
        $main_content .= 'Please <a href="index.php?subtopic=shopsystem">select item</a> first.';
      } 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($user_premium_points == 1) {
              $main_content .= '
              <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center></TABLE>';
              }
              else {
              $main_content .= '
              <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center></TABLE>';
              }

              $main_content .= '
              <table border="1" cellpadding="3" cellspacing="1" width="746">
                <tr bgcolor="#505050"><td colspan="2"><font color="white" size="3"><b>&nbsp;Selecione seu Character</b></font></td></tr>
                <tr bgcolor="#D4C0A1"><td width="160"><b><center>Produto Escolhido:</center></b></td><td width="490">&nbsp;<font color="red">'.$buy_offer['name'].'</font></td></tr>
                <br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                <tr bgcolor="#F1E0C6"><td width="160"><b><center>Character Escolhido:</center></b></td><td width="490">&nbsp;<select name="buy_name">';
                $players_from_logged_acc = $account_logged->getPlayersList();
              if(count($players_from_logged_acc) > 0) {
                $players_from_logged_acc->orderBy('name');
                foreach($players_from_logged_acc as $player)
                  $main_content .= '<option>'.$player->getName().'</option><br />';
              } else {
                $main_content .= 'You don\'t have any character on your account.';
              }
              $main_content .= '</select></table>
      <TABLE BORDER=0 WIDTH=100%>
        <TR><br>
          <TD ALIGN=center VALIGN=top>
              <INPUT TYPE="submit" value="Continuar Comprando" BORDER=0 WIDTH=120 HEIGHT=18>
          </TD></form>
          <TD ALIGN=center>
            <FORM  ACTION="index.php?subtopic=shopsystem" METHOD=post>
              <INPUT TYPE="submit" value="Cancelar Compra" BORDER=0 WIDTH=120 HEIGHT=18>
              </FORM>
          </TD>
        </TR>
      </TABLE>
              ';
            } else {
              $main_content .= 'You dont have enough <B>Elemental Coins</B> to buy this item. Please <a href="index.php?subtopic=shopsystem">select other item</a> or <a href="index.php?subtopic=donate">buy elemental coins</a>.';
            }
          } elseif($user_premium_points >= $buy_offer['points']) {
              if($user_premium_points == 1) {
              $main_content .= '
              <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center></TABLE>';
              }
              else {
              $main_content .= '
              <div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div><center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center></TABLE>';
              }
$main_content .= '<br> ';
          $main_content .= '
          <form id="change" name="change" action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST onsubmit="return validaCampo(); return false;">
          <input type="hidden" name="buy_id" value="'.$buy_id.'">
            <table border="1" cellpadding="3" cellspacing="1" width="746">
            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="3"><b>&nbsp;Mudar Nome</b></font></td></tr>
            <tr bgcolor="#D4C0A1"><td width="160"><b><center>Character Escolhido:</center></b></td><td width="490">&nbsp;<select name="buy_name">';
            $players_from_logged_acc = $account_logged->getPlayersList();
            $players_from_logged_acc->orderBy('name');
              foreach($players_from_logged_acc as $player) {
                $main_content .= '<option>'.$player->getName().'</option>';
              }
            $main_content .= '</select></td></tr>
            <tr bgcolor="#F1E0C6"><td width="160"><b><center>Novo Nome:</center></b></td><td width="490">&nbsp;<input id="buy_from" name="buy_from" onkeyup="checkbuy_from();" value="'.$buy_from.'" size="25" maxlength="16" type="text" name="buy_from"></td></tr></table>
';














function allLetter($inputtxt)
{
  $name = (string) $inputtxt;
  $name_to_check = strtolower($name);
  //first word can't be:
  $first_words_blocked = array('gm ','cm ', 'god ','tutor ', "'", '-');
  //names blocked:
  $names_blocked = array('gm','cm', 'god', 'tutor');
  //name can't contain:
  $words_blocked = array('gamemaster', 'game master', 'game-master', "game'master", '--', "''","' ", " '", '- ', ' -', "-'", "'-", 'fuck', 'sux', 'suck', 'noob', 'tutor');
  foreach($first_words_blocked as $word)
    if($word == substr($name_to_check, 0, strlen($word)))
      return false;
  if(substr($name_to_check, -1) == "'" || substr($name_to_check, -1) == "-")
    return false;
  if(substr($name_to_check, 1, 1) == ' ')
    return false;
  if(substr($name_to_check, -2, 1) == " ")
    return false;
  foreach($names_blocked as $word)
    if($word == $name_to_check)
      return false;
  for($i = 0; $i < strlen($name_to_check); $i++)
    if($name_to_check[$i-1] == ' ' && $name_to_check[$i+1] == ' ')
      return false;
  foreach($words_blocked as $word)
    if (!(strpos($name_to_check, $word) === false))
      return false;
  for($i = 0; $i < strlen($name_to_check); $i++)
    if($name_to_check[$i] == $name_to_check[($i+1)] && $name_to_check[$i] == $name_to_check[($i+2)])
      return false;
  for($i = 0; $i < strlen($name_to_check); $i++)
    if($name_to_check[$i-1] == ' ' && $name_to_check[$i+1] == ' ')
      return false;
  $temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM- '");
  if ($temp != strlen($name))
    return false;
  if(strlen($name) < 1)
    return false;
  if(strlen($name) > 25)
    return false;
  return true;
}

function listaPlayers()
    {
        $_players = $GLOBALS['_players'];
        $o = '<select name="buy_from" id="buy_from"><option value=""></option>';
        foreach($_players as $_player)
        {
            $o .= '<option value="'.$_player->getName().'">'.$_player->getName().'</option>';
        }
        $o .= '</select></td></tr>';

        return $o;
    }

$main_content .= '

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>CADASTRO DE CLIENTES COM BANCO DE DADOS E PHP</title>
<style type="text/css">
<!--
.style1 {
  color: #FF0000;
  font-size: x-small;
}
.style3 {color: #0000FF; font-size: x-small; }
-->
</style>

<script type="text/javascript">


function isUpperCase(char) {
    return char !== char.toLowerCase();
}

function hasUpperCaseChars(str) {
  var len=str.length;
  for(var i=1;i<len;i++) {
    if(/[A-Z]/.test(str.charAt(i))) return true;
  }
  return false;
}

function validaCampo()
{
if(document.change.buy_from.value=="")
  {
  alert("Digite o novo nome escolhido.");
  document.change.buy_from.focus();
  return false;
  }
else
  if(document.change.buy_from.value.length>14 || document.change.buy_from.value.length<4)
  {
  alert("Digite o novo nome contendo entre 4 a 14 letras.");
  document.change.buy_from.focus();
  return false;
  }
else
  if(!isUpperCase(document.change.buy_from.value.charAt(0)) || hasUpperCaseChars(document.change.buy_from.value))
  {
  alert("Digite o novo nome com a primeira letra maiúscula e o restante letras minúsculas.");
  document.change.buy_from.focus();
  return false;
  }
else
  if(!document.change.buy_from.value.match(/^[a-zA-Z_]+$/))
 {
  alert("Digite o novo nome sem símbolos (sem espaço, hífen, apóstrofo, entre outros).");
  document.change.buy_from.focus();
  return false;
  }
else
return true;
}

<!-- Fim do JavaScript que validará os campos obrigatórios! -->
</script>
</head>













          <TABLE BORDER=0 WIDTH=100%>
        <TR><br>
          <TD ALIGN=center VALIGN=top>
              <INPUT TYPE="submit" value="Continuar Comprando" BORDER=0 WIDTH=120 HEIGHT=18>
          </TD></form>
          <TD ALIGN=center>
            <FORM  ACTION="index.php?subtopic=shopsystem" METHOD=post>
              <INPUT TYPE="submit" value="Cancelar Compra" BORDER=0 WIDTH=120 HEIGHT=18>
              </FORM>
          </TD>
        </TR>
      </TABLE>

            ';
          }
          else {
              $main_content .= 'You dont have enough <B>Elemental Coins</B> to buy this item or dont have any <b>character</b> on your account. Please <a href="index.php?subtopic=shopsystem">select other item</a> or <a href="index.php?subtopic=donate">buy elemental coins</a> or <a href="index.php?subtopic=accountmanagement&action=createcharacter">create a new character</a>.';
            }
        } else {
                  $main_content .= 'Offer with ID <b>'.$buy_id.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem">select item</a> again.';
        }
      }
    }
  }
  elseif($action == 'confirm_transaction') {
    if(!$logged) {
      $main_content .= 'You are not logged in. <a href="?subtopic=accountmanagement">Log in</a> first to make a donate.';
    } 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 = $ots->createObject('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 OTS_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_viptime = $buy_player_account->getCustomField('viptime');
                                            $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);
                                            if($player_viptime > 0)
                                                $buy_player_account->setCustomField('viptime', $player_viptime + $buy_offer['days'] * 86400);
                                            else
                                                $buy_player_account->setCustomField('viptime', time() + $buy_offer['days'] * 86400);
                                            $buy_player_account->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                            $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'].' elemental coins</b> from your account.<br />Now you have <b>'.$user_premium_points.' elemental coins</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                            }

                    elseif($buy_offer['type'] == 'unban') {
                      $my_acc_id = $account_logged->getCustomField('id');
                      $datadata = $SQL->query('SELECT * FROM '.$SQL->tableName('bans').' WHERE value = '.$my_acc_id.';')->fetch();
                        if($datadata['value'] == $my_acc_id) {
                          if($SQL->query('DELETE FROM bans WHERE value= '.$my_acc_id.' LIMIT 1;')) {
                          } else {
                            $SQL->query('DELETE FROM bans WHERE account= '.$my_acc_id.' LIMIT 1;');
                          }
                          $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                          $user_premium_points = $user_premium_points - $buy_offer['points'];
                          $main_content .= '<center><h2>Ban Deleted!</h2><b>Your account has been unbanned for '.$buy_offer['points'].' elemental coins</b> from your account.
                            <br>Now you have <b>'.$user_premium_points.' elemental coins</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'] == '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.' elemental coins</b>.
                              <br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a>';
                          } else {
                            $main_content .= '<b>You need '.$SQL->quote($buy_offer['free_cap']).' or more of cap!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                          }
                        } else {
                          $main_content .= '<b>Please leave the arrow slot in blank to receive item!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                        }
                      } else {
                        $main_content .= '<b>You need to be offline!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                      }
                    }
                    ////////////////////////////////
                    elseif($buy_offer['type'] == 'changename') {
                      $my_acc_id = $buy_player->getCustomField('id');
                      $playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
                      $checkname = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('name').' = '. $SQL->quote($buy_from) .';')->fetch();
                      if($playerinfo['online'] == '0') {
                        if($checkname == false) {
                          $SQL->query('UPDATE `players` SET `name` = '. $SQL->quote($buy_from) .' WHERE `id` = '. $my_acc_id.' ;');
                          $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                          $user_premium_points = $user_premium_points - $buy_offer['points'];
                          $main_content .= '<center><h2>Name changed!</h2>
                          <b>Your name</b> has been changed to <b>'.$buy_from.'</b> for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>

                            <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                        } else {
                          $main_content .= 'Sorry, the name "<b>'.$buy_from.'</b>" does already exist. Go back to <a href="index.php?subtopic=shopsystem">shop site</a>.';
                        }
                      } else {
                        $main_content .= 'Sorry, "<b>'.$buy_name.'</b>" has to be offline to complete transaction. Go back to <a href="index.php?subtopic=shopsystem">shop site</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'];
                        $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.' elemental coins</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                      } else {
                        $main_content .= '
                        <center><h2>Not completed!</h2>The player <b>'.$buy_player->getName().'</b> has to be <b>offline</b> or <b>have redskull</b> to complete transaction!<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>
                        ';
                      }
                    }





                    //////////////////////////
                    elseif($buy_offer['type'] == 'item') {
                      $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'item\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                      $SQL->query($sql);
                      $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['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>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b>';

                      if ($buy_offer['points'] == 1) {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coin</b> from your account.<br>';
                      }

                      else {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>';
                      }

                      $main_content .= '
                        <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                    }


                                                                                if($buy_offer['type'] == 'gold') {
                                                                             $player_card_time = $buy_player_account->getCustomField('card_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);
                      if($player_card_time > 0)
                        $buy_player_account->setCustomField('card_time', $player_card_time + $buy_offer['days'] * 86400);
                      else
                        $buy_player_account->setCustomField('card_time', time() + $buy_offer['days'] * 86400);
                      $buy_player_account->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                      $user_premium_points = $user_premium_points - $buy_offer['points'];
                      if ($player_card_time >= 1) {
                      }
                      $main_content .= '<center><h2>Gold Card added!</h2><b>'.$buy_offer['days'].' days</b> of Gold Card days added to the account of player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br />Now you have <b>'.$user_premium_points.' elemental coins</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['item_count']).', \'\', \'\', \'itemvip\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                      $SQL->query($sql);
                      $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                      $SQL->query($save_transaction);
                      $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                      $user_premium_points = $user_premium_points - $buy_offer['points'];
                      $main_content .= '<center><h2>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b>';

                      if ($buy_offer['points'] == 1) {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coin</b> from your account.<br>';
                      }

                      else {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>';
                      }

                      $main_content .= '
                        <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                    }









                    elseif($buy_offer['type'] == 'itemvipp') {
                      $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']).', \'\', \'\', \'itemvipp\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                      $SQL->query($sql);
                      $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                      $SQL->query($save_transaction);
                      $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                      $user_premium_points = $user_premium_points - $buy_offer['points'];
                      $main_content .= '<center><h2>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b>';

                      if ($buy_offer['points'] == 1) {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coin</b> from your account.<br>';
                      }

                      else {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>';
                      }

                      $main_content .= '
                        <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                    }










                    elseif($buy_offer['type'] == 'montarias') {
                      $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']).', \'\', \'\', \'montarias\', '.$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, 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>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b>';

                      if ($buy_offer['points'] == 1) {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coin</b> from your account.<br>';
                      }

                      else {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>';
                      }

                      $main_content .= '
                        <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                    }






                    elseif($buy_offer['type'] == 'outfits') {
                      $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']).', \'\', \'\', \'outfits\', '.$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, 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>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b>';

                      if ($buy_offer['points'] == 1) {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coin</b> from your account.<br>';
                      }

                      else {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>';
                      }

                      $main_content .= '
                        <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                    }










                      elseif($buy_offer['type'] == 'itemvippp') {
                      $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'itemvippp\', '.$SQL->quote($buy_offer['name']).', \'\', '.$SQL->quote($buy_offer['item_id1']).', '.$SQL->quote($buy_offer['item_count1']).', '.$SQL->quote($buy_offer['item_id2']).', '.$SQL->quote($buy_offer['item_count2']).', \'1\');';
                      $SQL->query($sql);
                      $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                      $SQL->query($save_transaction);
                      $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                      $user_premium_points = $user_premium_points - $buy_offer['points'];
                      $main_content .= '<center><h2>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b>';

                      if ($buy_offer['points'] == 1) {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coin</b> from your account.<br>';
                      }

                      else {
                      $main_content .= '
                      for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br>';
                      }

                      $main_content .= '
                        <br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                    }











                    elseif($buy_offer['type'] == 'container') {
                      $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', '.$SQL->quote($buy_offer['container_id']).', '.$SQL->quote($buy_offer['container_count']).', \'container\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                      $SQL->query($sql);
                      $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                      $SQL->query($save_transaction);
                      $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                      $user_premium_points = $user_premium_points - $buy_offer['points'];
                      $main_content .= '<center><h2>Container of items added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' elemental coins</b> from your account.<br />Now you have <b>'.$user_premium_points.' elemental coins</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';
                      $main_content .= '<div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div>';

                      if($user_premium_points == 1){
                      $main_content .= '
                      <center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center></TABLE>';
                      }
                      else {
                        $main_content .= '
                      <center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center></TABLE>';
                      }


                      $main_content .= '
                      <br>
                        <table border="1" cellpadding="3" cellspacing="1" width="746">
                <tr bgcolor="#505050"><td colspan="2"><font color="white" size="3"><b>&nbsp;Confirmar Compra</b></font></td></tr>
                        <tr bgcolor="#D4C0A1"><td width="178"><b><center>Produto Escolhido:</center></b></td><td width="472" colspan="2"><font color="red">&nbsp;'.$buy_offer['name'].'</font></td></tr>';

                    if($buy_offer['points'] == 1){
                      $main_content .= '
                        <tr bgcolor="#F1E0C6"><td width="178"><b><center>Valor do Produto:</center></b></td><td width="472" colspan="2"><b>&nbsp;'.$buy_offer['points'].'</b> Elemental Coin</td></tr>';
                    }
                    else {
                      $main_content .= '
                        <tr bgcolor="#F1E0C6"><td width="178"><b><center>Valor do Produto:</center></b></td><td width="472" colspan="2"><b>&nbsp;'.$buy_offer['points'].'</b> Elemental Coins</td></tr>';
                    }


                      $main_content .= '
                        <tr bgcolor="#D4C0A1"><td width="178"><b><center>Character Escolhido:</center></b></td><td width="485" colspan="2"><font color="red">&nbsp;'.$buy_player->getName().'</font></td></tr>
                        <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).'">
                        </table>
      <TABLE BORDER=0 WIDTH=100%>
        <TR><br>
          <TD ALIGN=center VALIGN=top>
              <INPUT TYPE="submit" value="Confirmar Compra" BORDER=0 WIDTH=120 HEIGHT=18>
          </TD></form>
          <TD ALIGN=center>
            <FORM  ACTION="index.php?subtopic=shopsystem" METHOD=post>
              <INPUT TYPE="submit" value="Cancelar Compra" BORDER=0 WIDTH=120 HEIGHT=18>
              </FORM>
          </TD>
        </TR>
      </TABLE>
                        ';
                    } else {
                      $set_session = TRUE;
                      $_SESSION['viewed_confirmation_page'] = 'yes';
                      $main_content .= '<div id="ProgressBar">  <div id="Headline"><big><big><big><big>Shopping Online</big></big></big></div></div>';

                      if($user_premium_points == 1){
                      $main_content .= '
                      <center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coin)</center></TABLE>';
                      }
                      else {
                        $main_content .= '
                      <center>(Seu saldo: <b><font color="green">'.$user_premium_points.'</font></b> Elemental Coins)</center></TABLE>';
                      }


                      $main_content .= '
                      <br>
                        <table border="1" cellpadding="3" cellspacing="1" width="746">
                        <tr bgcolor="#505050"><td colspan="2"><font color="white" size="3"><b>&nbsp;Confirmar Compra</b></font></td></tr>
                        <tr bgcolor="#D4C0A1"><td width="178"><b><center>Produto Escolhido:</center></b></td><td width="472" colspan="2"><font color="red">&nbsp;'.$buy_offer['name'].'</font></td></tr>
                        <tr bgcolor="#F1E0C6"><td width="178"><b><center>Valor do Produto:</center></b></td><td width="472" colspan="2"><b>&nbsp;'.$buy_offer['points'].'</b> Elemental Coins</td></tr>
                        <tr bgcolor="#D4C0A1"><td width="178"><b><center>Character Escolhido:</center></b></td><td width="485" colspan="2"><font color="red">&nbsp;'.$buy_player->getName().'</font></td></tr>
                        <tr bgcolor="#F1E0C6"><td width="178"><b><center>Novo Nome:</center></b></td><td width="485" colspan="2"><font color="red">&nbsp;'.$buy_from.'</font></td></tr>

                        <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).'">
                        </table>
      <TABLE BORDER=0 WIDTH=100%>
        <TR><br>
          <TD ALIGN=center VALIGN=top>
              <INPUT TYPE="submit" value="Confirmar Compra" BORDER=0 WIDTH=120 HEIGHT=18>
          </TD></form>
          <TD ALIGN=center>
            <FORM  ACTION="index.php?subtopic=shopsystem" METHOD=post>
              <INPUT TYPE="submit" value="Cancelar Compra" BORDER=0 WIDTH=120 HEIGHT=18>
              </FORM>
          </TD>
        </TR>
      </TABLE>';
                    }
                  }
                } else {
                  $main_content .= '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>.';
                }
              } else {
                $main_content .= 'Invalid name format. Please <a href="index.php?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a> or contact with administrator.';
              }
            } else {
              $main_content .= 'For this item you need <b>'.$buy_offer['points'].'</b> points. You have only <b>'.$user_premium_points.'</b> elemental coins. Please <a href="index.php?subtopic=shopsystem">select other item</a> or <a href="index.php?subtopic=donate">buy elemental coins</a>.';
            }
                  } else {
            $main_content .= 'Offer with ID <b>'.$buy_id.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem">select item</a> again.';
          }
        }
      }
    }
    if(!$set_session) {
      unset($_SESSION['viewed_confirmation_page']);
    }
  }

  elseif($action == 'showerwerre2390ww_histo32wrrerwerwry') {
    if(!$logged) {
      $main_content .= 'You are not logged in. <a href="?subtopic=accountmanagement">Log in</a> first to make a donate.';
    } else{
      $items_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_history_item').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
      if(is_object($items_history_received)) {
        foreach($items_history_received as $item_received) {
          if($account_logged->getId() == $item_received['to_account'])
            $char_color = 'green';
          else
            $char_color = 'red';
            $items_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$item_received['to_name'].'</font></td><td>';
          if($account_logged->getId() == $item_received['from_account'])
            $items_received_text .= '<i>Your account</i>';
          else
            $items_received_text .= $item_received['from_nick'];
            $items_received_text .= '</td><td>'.$item_received['offer_id'].'</td><td>'.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>';
        }
      }
      $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>';
        }
      }
      $main_content .= '<center><h1>Transactions History</h1></center>';
      if(!empty($items_received_text))
        $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;Item Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Offer name</b></td><td><b>Bought on page</b></td><td><b>Received on '.$config['server']['serverName'].'</b></td></tr>'.$items_received_text.'</table><br />';
      if(!empty($paccs_received_text))
        $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;Pacc Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Duration</b></td><td><b>Cost</b></td><td><b>Added:</b></td></tr>'.$paccs_received_text.'</table><br />';
      if(empty($paccs_received_text) && empty($items_received_text))
        $main_content .= 'You did not buy/receive any items or PACC.';
    }
  }
  }
?>