Ir para conteúdo
  • Cadastre-se

Shop não entrega Premium após troca da Database.

Fausto32

Por ,
em Suporte Tibia Otserv

 Share Seguidores 0

Posts Recomendados

Fausto32

Fausto32 92

Postado
Postado (editado)

Trocando o shopsystem.php foi possível a entrega normalmente, porem gostaria de usar essa que tá dando defeito por ser mais organizada, a troca da Database foi forçada, não tenho como voltar a antiga, no caso compro a Premium, os pontos são descontados, mas não e entregue nada, configurei a Shopsystem.php para a tabela alvo, ai a Premium e entregue, porem se compro 30 dias, vem 129018290Dias, alguém sabe como resolver?

Aqui a imagem do Shop e da tabela Account:

2hqry3m.jpg200e9i0.jpg

 

E aqui o php do shop da print que eu quero usar no caso:

<?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 = 'Entre Primeiro';
 
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'] == 'item')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['item_id'] = $data['itemid1'];
    $offer['item_count'] = $data['count1'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
  elseif ($data['offer_type'] == 'vipdays')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['days'] = $data['count1'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
  elseif ($data['offer_type'] == 'itemvip')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['item_id'] = $data['itemid1'];
    $offer['item_count'] = $data['count1'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
  elseif ($data['offer_type'] == 'container')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['container_id'] = $data['itemid2'];
    $offer['container_count'] = $data['count2'];
    $offer['item_id'] = $data['itemid1'];
    $offer['item_count'] = $data['count1'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
  elseif ($data['offer_type'] == 'unban')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
  elseif ($data['offer_type'] == 'frags')
  {
    $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'] == 'blackskull')
  {
    $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'] == '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'] == 'itemlogout')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['pid'] = $data['pid'];
    $offer['count1'] = $data['count1'];
    $offer['item_id'] = $data['itemid1'];
    $offer['free_cap'] = $data['free_cap'];
  }
  elseif ($data['offer_type'] == 'changename')
  {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
  return $offer;
}
 
function getOfferArray()
{
  $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').';');
  $i_pacc = 0;
  $i_item = 0;
  $i_vipdays = 0;
  $i_itemvip = 0;
  $i_container = 0;
  $i_unban = 0;
  $i_redskull = 0;
  $i_blackskull = 0;
  $i_itemvip = 0;
  $i_itemlogout = 0;
  $i_changename = 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'] == 'item')
    {
      $offer_array['item'][$i_item]['id'] = $data['id'];
      $offer_array['item'][$i_item]['item_id'] = $data['itemid1'];
      $offer_array['item'][$i_item]['item_count'] = $data['count1'];
      $offer_array['item'][$i_item]['points'] = $data['points'];
      $offer_array['item'][$i_item]['description'] = $data['offer_description'];
      $offer_array['item'][$i_item]['name'] = $data['offer_name'];
      $i_item++;
    }
    elseif ($data['offer_type'] == 'vipdays')
    {
      $offer_array['vipdays'][$i_vipdays]['id'] = $data['id'];
      $offer_array['vipdays'][$i_vipdays]['days'] = $data['count1'];
      $offer_array['vipdays'][$i_vipdays]['points'] = $data['points'];
      $offer_array['vipdays'][$i_vipdays]['description'] = $data['offer_description'];
      $offer_array['vipdays'][$i_vipdays]['name'] = $data['offer_name'];
      $i_vipdays++;
    }
    elseif ($data['offer_type'] == 'itemvip')
    {
      $offer_array['itemvip'][$i_itemvip]['id'] = $data['id'];
      $offer_array['itemvip'][$i_itemvip]['item_id'] = $data['itemid1'];
      $offer_array['itemvip'][$i_itemvip]['item_count'] = $data['count1'];
      $offer_array['itemvip'][$i_itemvip]['points'] = $data['points'];
      $offer_array['itemvip'][$i_itemvip]['description'] = $data['offer_description'];
      $offer_array['itemvip'][$i_itemvip]['name'] = $data['offer_name'];
      $i_itemvip++;
    }
    elseif ($data['offer_type'] == 'container')
    {
      $offer_array['container'][$i_container]['id'] = $data['id'];
      $offer_array['container'][$i_container]['container_id'] = $data['itemid2'];
      $offer_array['container'][$i_container]['container_count'] = $data['count2'];
      $offer_array['container'][$i_container]['item_id'] = $data['itemid1'];
      $offer_array['container'][$i_container]['item_count'] = $data['count1'];
      $offer_array['container'][$i_container]['points'] = $data['points'];
      $offer_array['container'][$i_container]['description'] = $data['offer_description'];
      $offer_array['container'][$i_container]['name'] = $data['offer_name'];
      $i_container++;
    }
    elseif ($data['offer_type'] == 'unban')
    {
      $offer_array['unban'][$i_unban]['id'] = $data['id'];
      $offer_array['unban'][$i_unban]['points'] = $data['points'];
      $offer_array['unban'][$i_unban]['description'] = $data['offer_description'];
      $offer_array['unban'][$i_unban]['name'] = $data['offer_name'];
      $i_unban++;
    }
    elseif ($data['offer_type'] == 'frags')
    {
      $offer_array['frags'][$i_frags]['id'] = $data['id'];
      $offer_array['frags'][$i_frags]['points'] = $data['points'];
      $offer_array['frags'][$i_frags]['description'] = $data['offer_description'];
      $offer_array['frags'][$i_frags]['name'] = $data['offer_name'];
      $i_redskull++;
    }
    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'] == 'blackskull')
    {
      $offer_array['blackskull'][$i_blackskull]['id'] = $data['id'];
      $offer_array['blackskull'][$i_blackskull]['points'] = $data['points'];
      $offer_array['blackskull'][$i_blackskull]['description'] = $data['offer_description'];
      $offer_array['blackskull'][$i_blackskull]['name'] = $data['offer_name'];
      $i_redskull++;
    }
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'] == 'itemlogout')
    {
      $offer_array['itemlogout'][$i_itemlogout]['id'] = $data['id'];
      $offer_array['itemlogout'][$i_itemlogout]['points'] = $data['points'];
      $offer_array['itemlogout'][$i_itemlogout]['description'] = $data['offer_description'];
      $offer_array['itemlogout'][$i_itemlogout]['name'] = $data['offer_name'];
      $offer_array['itemlogout'][$i_itemlogout]['count1'] = $data['count1'];
      $offer_array['itemlogout'][$i_itemlogout]['pid'] = $data['pid'];
      $offer_array['itemlogout'][$i_itemlogout]['item_id'] = $data['itemid1'];
      $offer_array['itemlogout'][$i_itemlogout]['free_cap'] = $data['free_cap'];
      $i_itemlogout++;
    }
    elseif ($data['offer_type'] == 'changename')
    {
      $offer_array['changename'][$i_changename]['id'] = $data['id'];
      $offer_array['changename'][$i_changename]['points'] = $data['points'];
      $offer_array['changename'][$i_changename]['description'] = $data['offer_description'];
      $offer_array['changename'][$i_changename]['name'] = $data['offer_name'];
      $i_changename++;
    }
  }
  return $offer_array;
}
 
if($action == '') {
unset($_SESSION['viewed_confirmation_page']);
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquira mais Points(Points).</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                                                               <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                              <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
if(count($offer_list['changename']) > 0 or count($offer_list['pacc']) > 0 or count($offer_list['redskull']) > 0 or count($offer_list['blackskull']) > 0 or count($offer_list['unban']) > 0 )
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</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="images/items/16101.gif"></td><td><b>'.$pacc['name'].'</b> ('.$pacc['points'].' Points)<br />'.$pacc['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="'.$pacc['id'].'"><input type=submit" value="Buy '.$pacc['name].'"><br><b>for '.$pacc['points'].' Points</b></form>';
}
$main_content .= '</table><br />';
}
elseif($action == 'itens') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                                                               <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
<td align="center">                                                             <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
unset($_SESSION['viewed_confirmation_page']);
$offer_list = getOfferArray();
//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="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></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>';
if(count($offer_list['item']) > 0) {
foreach($offer_list['item'] as $item) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$item['item_id'].'.gif"></td><td><b>'.$item['name'].'</b> ('.$item['points'].' Points)<br />'.$item['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="'.$item['id'].'"><input type=submit" value="Buy '.$item['name].'"><br><b>for '.$item['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
elseif($action == 'itemvip') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                                                               <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                             <td align="center"> <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
unset($_SESSION['viewed_confirmation_page']);
$offer_list = getOfferArray();
//show list of items offers
if(count($offer_list['itemvip']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></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>';
if(count($offer_list['itemvip']) > 0) {
foreach($offer_list['itemvip'] as $itemvip) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$itemvip['item_id'].'.gif"></td><td><b>'.$itemvip['name'].'</b> ('.$itemvip['points'].' Points)<br />'.$itemvip['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="'.$itemvip['id'].'"><input type=submit" value="Buy '.$itemvip['name].'"><br><b>for '.$itemvip['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
elseif($action == 'containers') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                                                               <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                             <td align="center">
<td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
$offer_list = getOfferArray();
//show list of containers offers
if(count($offer_list['container']) > 0) {
$main_content .= '<table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></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="images/items/'.$container['item_id'].'.gif"></td><td><b>'.$container['name'].'</b> ('.$container['points'].' Points)<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'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
elseif($action == 'vip') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                       <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
<td align="center">                                                               <td align="center">
<td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
if(count($offer_list['changename']) > 0 or count($offer_list['pacc']) > 0 or count($offer_list['redskull']) > 0 or count($offer_list['unban']) > 0 )
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</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="images/items/16101.gif"></td><td><b>'.$pacc['name'].'</b> ('.$pacc['points'].' Points)<br />'.$pacc['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="'.$pacc['id'].'"><input type=submit" value="Buy '.$pacc['name].'"><br><b>for '.$pacc['points'].' Points</b></form>';
}
$main_content .= '</table><br />';
}
elseif($action == 'changename') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                       <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                              <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
//Change Name
if(count($offer_list['changename']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</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['changename'] as $changename) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/changename.gif"></td><td><b>'.$changename['name'].'</b> ('.$changename['points'].' Points)<br />'.$changename['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="'.$changename['id'].'"><input type=submit" value="Buy '.$changename['name].'"><br><b>for '.$changename['points'].' Points</b></form>';
}
$main_content .= '</table><br />';
}
                        elseif($action == 'frags') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
<td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                                                                    <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
//Account Modifications
if(count($offer_list['frags']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</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['frags'] as $frags) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/frags.gif"></td><td><b>'.$frags['name'].'</b> ('.$frags['points'].' Points)<br />'.$frags['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="'.$frags['id'].'"><input type=submit" value="Buy '.$frags['name].'"><br><b>for '.$frags['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
elseif($action == 'redskull') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                       <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
 
                                                                <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
//Remove Red Skull
if(count($offer_list['redskull']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</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['redskull'] as $redskull) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/redskull.gif"></td><td><b>'.$redskull['name'].'</b> ('.$redskull['points'].' Points)<br />'.$redskull['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="'.$redskull['id'].'"><input type=submit" value="Buy '.$redskull['name].'"><br><b>for '.$redskull['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
elseif($action == 'blackskull') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                       <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                                <td align="center"> <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
//Remove Black Skull
if(count($offer_list['blackskull']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</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['blackskull'] as $blackskull) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/blackskull.gif"></td><td><b>'.$blackskull['name'].'</b> ('.$blackskull['points'].' Points)<br />'.$blackskull['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="'.$blackskull['id'].'"><input type=submit" value="Buy '.$blackskull['name].'"><br><b>for '.$blackskull['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
elseif($action == 'itens') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                                                               <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
                                                                <td align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
unset($_SESSION['viewed_confirmation_page']);
$offer_list = getOfferArray();
//show list of items offers
if(count($offer_list['itemvip']) > 0 or count($offer_list['container']) > 0 or count($offer_list['itemlogout']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></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>';
if(count($offer_list['itemvip']) > 0) {
foreach($offer_list['itemvip'] as $itemvip) {
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$itemvip['item_id'].'.gif"></td><td><b>'.$itemvip['name'].'</b> ('.$itemvip['points'].' Points)<br />'.$itemvip['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="'.$itemvip['id'].'"><input type=submit" value="Buy '.$itemvip['name].'"><br><b>for '.$itemvip['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
elseif($action == 'unban') {
$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.</center></h2><h3><center><a href="index.php?subtopic=terms">Adquire seus pontos.</a></center></h3>';
$main_content .= '<table border="0" cellpadding="4" cellspacing="0">
<tr bgcolor="#D4C0A1">
<td align="center"><a href="index.php?subtopic=shopsystem&action=vip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;">VIP</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itens" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=itemvip" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Special Itens</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=containers" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Containers</a></td>
<td align="center"><a href="index.php?subtopic=shopsystem&action=changename" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Change Name</a></td>
                                       <td align="center"><a href="index.php?subtopic=shopsystem&action=frags" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Account Modifications</a></td>
<td align="center">                                                               <td bgcolor="#505050" align="center"><a href="index.php?subtopic=shopsystem&action=unban" style="color:#FFFFFF; font-size: 105%; padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px;"">Unban</a></td>
</tr>
</table>';
$offer_list = getOfferArray();
unset($_SESSION['viewed_confirmation_page']);
//Unban
if(count($offer_list['unban']) > 0)
$main_content .= '<center><table border="0" cellpadding="4" cellspacing="0" width="100%"><tr width="650" bgcolor="#505050"><td colspan="3"></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>#</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['unban'] as $unban){
$main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/unban.gif"></td><td><b>'.$unban['name'].'</b> ('.$unban['points'].' Points)<br />'.$unban['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="'.$unban['id'].'"><input type=submit" value="Buy '.$unban['name].'"><br><b>for '.$unban['points'].' Points</b></form>';
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
elseif($action == 'select_player') {
unset($_SESSION['viewed_confirmation_page']);
if(!$logged) {
$main_content .= 'Please login first.';
} 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']) {
$main_content .= '<center><h2>Select player</h2><table border="0" cellpadding="1" cellspacing="1" width="650">
<tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Selected offer</b></font></td></tr>
<tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550">'.$buy_offer['name'].'</td></tr>
<tr bgcolor="#D4C0A1"><td width="100"><b>Description:</b></td><td width="550">'.$buy_offer['description'].'</td></tr>
</table><br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
<table border="0" cellpadding="1" cellspacing="1" width="650">
<tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Give item to a player from your account</b></font></td></tr>
<tr bgcolor="#F1E0C6"><td width="110"><b>Name:</b></td><td width="550"><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>';
} else {
$main_content .= 'You don\'t have any character on your account.';
}
$main_content .= '</select>&nbsp;<input type="submit" value="Give"></td></tr></table>
</form><br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
<table border="0" cellpadding="1" cellspacing="1" width="650">
<tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Give item to other player</b></font></td></tr>
<tr bgcolor="#D4C0A1"><td width="110"><b>To player:</b></td><td width="550"><input type="text" name="buy_name"> - name of the player who should get item</td></tr>
<tr bgcolor="#F1E0C6"><td width="110"><b>From:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Give"> - your nick, \'empty\' = Evenmous</td></tr>
</table><br /></form>';
} else {
$main_content .= 'For this item you need <b>'.$buy_offer['points'].'</b> Points.<br>You have only <b>'.$user_premium_points.'</b> Points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy Points.';
}
} else {
$main_content .= '<center><h2>Change Name</h2><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
<table border="0" cellpadding="1" cellspacing="1" width="650"><tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Change Name:</b></font></td></tr>
<tr bgcolor="#D4C0A1"><td width="110"><b>Name:</b></td><td width="550"><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>';
}
} else {
$main_content .= 'You don\'t have any character on your account.';
}
$main_content .= '</select></td></tr><tr bgcolor="#F1E0C6"><td width="110"><b>New name:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Change Name"></td></tr></table><br /></form>';
}
} 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 .= 'Please login first.';
} 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'] * 24 * 60 * 60));
else
$buy_player_account->setCustomField('viptime', time() + ($buy_offer['days'] * 24 * 60 * 60));
 
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
if($player_viptime == 0)
{
$buy_player_account->setCustomField('lastday', time());
}
$main_content .= '<h2>VIP Days added!</h2><b>'.$buy_offer['days'].' days</b> of Vip Account added to account of player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' Points</b> from your account.<br />Now you have <b>'.$user_premium_points.' Points(Points)</b>.<br /><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a>';
}
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'].' Points</b> from your account.
<br>Now you have <b>'.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
} else {
$main_content .= '<center><b>You don\'t have any bans in your account!</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
}
}
////////////////////////////////
elseif($buy_offer['type'] == '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.' Points</b>.
<br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a>';
} else {
$main_content .= '<b>You need '.$SQL->quote($buy_offer['free_cap']).' or more of cap!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
}
} else {
$main_content .= '<b>Please leave the arrow slot in blank to receive item!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
}
} else {
$main_content .= '<b>You need to be offline!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
}
}
////////////////////////////////
elseif($buy_offer['type'] == 'changename') {
$my_acc_id = $buy_player->getCustomField('id');
$playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
$checkname = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('name').' = '. $SQL->quote($buy_from) .';')->fetch();
  if($playerinfo['online'] == '0') {
if($checkname == 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>Your name has been changed to '.$buy_from.'.</h2><br><b>You have '.$user_premium_points.' Points left</b>.
<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
} else {
$main_content .= '<center><h2>Sorry, the name "<i>'.$buy_from.'</i>" does already exist.<br>Please select another name.</h2><br>';
}
} else {
$main_content .= '<center><h2>'.$buy_name.' has to be offline to complete transaction.</h2><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
}
}
                                                                                ////////////////////////////////
elseif($buy_offer['type'] == 'frags') {
$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'] == '0' AND $playerinfo['online'] == '0') {
$SQL->query('UPDATE killers SET unjustified=0 WHERE id IN (SELECT kill_id FROM player_killers WHERE player_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>All Frags Removed!</h2><br><b>Yours frags has been removed from the player '.$buy_player->getName().'.</b>
<br>Now you have<b> '.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
} else {
$main_content .= '<center><b>O jogador '.$buy_player->getName().' deve estar sem skull e offline!.</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
}
}
////////////////////////////////
elseif($buy_offer['type'] == 'redskull') {
$my_acc_id = $buy_player->getCustomField('id');
$playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
if($playerinfo['skull'] == '4' AND $playerinfo['online'] >= '0' AND $playerinfo['skulltime'] > '0') {
$SQL->query('UPDATE killers SET unjustified=0 WHERE id IN (SELECT kill_id FROM player_killers WHERE player_id='. $my_acc_id .');');
$SQL->query('UPDATE players SET skulltime=0, skull=0 WHERE id='. $my_acc_id .';');
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>RedSkull Removed!</h2><br><b>Your redskull has been removed from the player '.$buy_player->getName().'.</b>
<br>Now you have<b> '.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
} else {
$main_content .= '<center><b>'.$buy_player->getName().' has to be offline or have redskull to complete transaction!.</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
}
}
                                                                                ////////////////////////////////
elseif($buy_offer['type'] == 'blackskull') {
$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'] == '5' 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>BlackSkull Removed!</h2><br><b>Your blackskull has been removed from the player '.$buy_player->getName().'.</b>
<br>Now you have<b> '.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
} else {
$main_content .= '<center><b>'.$buy_player->getName().' has to be offline or have blackskull to complete transaction!.</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
}
}
//////////////////////////
elseif($buy_offer['type'] == 'item') {
$sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'item\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
$SQL->query($sql);
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['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> for <b>'.$buy_offer['points'].' Points</b> from your account.<br>Now you have <b>'.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN 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']).', \'\', \'\', \'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> for <b>'.$buy_offer['points'].' Points</b> from your account.<br>Now you have <b>'.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
}
                                                                                if($buy_offer['type'] == 'vipdays') {
                                                                                      $player_premdays = $buy_player_account->getCustomField('premdays');
$player_lastlogin = $buy_player_account->getCustomField('lastday');
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_pacc').' (id, to_name, to_account, from_nick, from_account, price, pacc_days, trans_state, trans_start, trans_real) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['days']).', \'realized\', '.$SQL->quote(time()).', '.$SQL->quote(time()).');';
$SQL->query($save_transaction);
$buy_player_account->setCustomField('premdays', $player_premdays+$buy_offer['days']);
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
 
$main_content .= '<center><h2>VIP account added!</h2><b>'.$buy_offer['days'].' days</b> of VIP account added to the account of player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' Points</b> from your account.<br />Now you have <b>'.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
}
elseif($buy_offer['type'] == 'itemvip') {
$sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['megaitems_count']).', \'\', \'\', \'megaitems\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
$SQL->query($sql);
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['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>Mega Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' Points</b> from your account.<br>Now you have <b>'.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
}
elseif($buy_offer['type'] == 'container') {
$sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', '.$SQL->quote($buy_offer['container_id']).', '.$SQL->quote($buy_offer['container_count']).', \'container\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
$SQL->query($sql);
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
$SQL->query($save_transaction);
$account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
$user_premium_points = $user_premium_points - $buy_offer['points'];
$main_content .= '<center><h2>Container of items added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' Points</b> from your account.<br />Now you have <b>'.$user_premium_points.' Points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
}
} else {
if($buy_offer['type'] != 'changename') {
$set_session = TRUE;
$_SESSION['viewed_confirmation_page'] = 'yes';
$main_content .= '<center><h2>Confirm transaction</h2>
<table border="0" cellpadding="1" cellspacing="1" width="700">
<tr bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>Confirm transaction</b></font></td></tr>
<tr bgcolor="#D4C0A1"><td width="100"><b>Name:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
<tr bgcolor="#F1E0C6"><td width="100"><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
<tr bgcolor="#D4C0A1"><td width="100"><b>Cost:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' Points</b> from your account</td></tr>
<tr bgcolor="#F1E0C6"><td width="100"><b>For Player:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
<tr bgcolor="#D4C0A1"><td width="100"><b>From:</b></td><td width="550" colspan="2"><font color="red">'.$buy_from.'</font></td></tr>
<tr bgcolor="#F1E0C6"><td width="100"><b>Transaction?</b></td><td width="275" align="left">
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST"><input type="hidden" name="buy_confirmed" value="yes"><input type="hidden" name="buy_id" value="'.$buy_id.'"><input type="hidden" name="buy_from" value="'.urlencode($new_name).'"><input type="hidden" name="buy_name" value="'.urlencode($buy_name).'"><input type="submit" value="Accept"></form></td>
<td align="right"><form action="index.php?subtopic=shopsystem" method="POST"><input type="submit" value="Cancel"></form></td></tr>
</table>';
} else {
$set_session = TRUE;
$_SESSION['viewed_confirmation_page'] = 'yes';
$main_content .= '<center><h2>Confirm Name Changing</h2>
<table border="0" cellpadding="1" cellspacing="1" width="700">
<tr bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>Confirm transaction</b></font></td></tr>
<tr bgcolor="#D4C0A1"><td width="130"><b>Name:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
<tr bgcolor="#F1E0C6"><td width="130"><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
<tr bgcolor="#D4C0A1"><td width="130"><b>Cost:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' Points</b> from your account</td></tr>
<tr bgcolor="#F1E0C6"><td width="130"><b>Current Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
<tr bgcolor="#D4C0A1"><td width="130"><b>New Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_from.'</font></td></tr>
<tr bgcolor="#F1E0C6"><td width="130"><b>Change Name?</b></td><td width="275" align="left">
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST"><input type="hidden" name="buy_confirmed" value="yes"><input type="hidden" name="buy_id" value="'.$buy_id.'"><input type="hidden" name="buy_from" value="'.urlencode($buy_from).'"><input type="hidden" name="buy_name" value="'.urlencode($buy_name).'"><input type="submit" value="Accept"></form></td>
<td align="right"><form action="index.php?subtopic=shopsystem" method="POST"><input type="submit" value="Cancel"></form></td></tr>
</table>';
}
}
} else {
$main_content .= '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> Points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy Points(Points).';
}
          } 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 == 'show_history') {
if(!$logged) {
$main_content .= 'Please login first.';
} else{
$items_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_history_item').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
if(is_object($items_history_received)) {
foreach($items_history_received as $item_received) {
if($account_logged->getId() == $item_received['to_account'])
$char_color = 'green';
else
$char_color = 'red';
$items_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$item_received['to_name'].'</font></td><td>';
if($account_logged->getId() == $item_received['from_account'])
$items_received_text .= '<i>Your account</i>';
else
$items_received_text .= $item_received['from_nick'];
$items_received_text .= '</td><td>'.$item_received['price'].' Points</td><td>'.date("j F Y, H:i:s", $item_received['trans_start']).'</td>';
if($item_received['trans_real'] > 0)
$items_received_text .= '<td>'.date("j F Y, H:i:s", $item_received['trans_real']).'</td>';
else
$items_received_text .= '<td><b><font color="red">Not realized yet.</font></b></td>';
$items_received_text .= '</tr>';
}
}
$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>';
}
}
$pagseguro_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('PagSeguroTransacoes').' WHERE '.$SQL->fieldName('Anotacao').' = '.$SQL->quote($account_logged->getCustomField("name")).';');
if(is_object($pagseguro_history_received)) {
foreach($pagseguro_history_received as $pagseguro_received) {
if($account_logged->getCustomField("name") == $pagseguro_received['Anotacao'])
$char_color = 'green';
else
$char_color = 'red';
$pagseguro_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$pagseguro_received['TransacaoID'].'</font></td><td>';
 
$pagseguro_received_text .= ''.$pagseguro_received['TipoPagamento'].'';
 
$pagseguro_received_text .= '</td><td>R$'.$pagseguro_received['NumItens'].',00</td><td>'.$pagseguro_received['Extras'].' Points</td><td><b style=color:red;">'.$pagseguro_received['StatusTransacao].'</b></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>Cost</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($pagseguro_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;PagSeguro Donations</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>ID:</b></td><td><b>Type</b></td><td><b>Cost</b></td><td><b>Points</b></td><td><b>Status</b></td></tr>'.$pagseguro_received_text.'</table><br />';
 
 
 
if(empty($paccs_received_text) && empty($items_received_text))
$main_content .= 'You did not buy/receive any items or PACC.';
}
}
if(!$logged)
$main_content .= 'Please login to see how much points you have.';
else
$main_content .= '<br><b><font color="green">You have Points(Points): </font></b>'.$user_premium_points;
}
else
$main_content .= '<br><center><b>Shop System is currently disabled for this server.Please ask the admin for more information.</b></center>';
?>

 
E aqui o shop.php que funciona perfeitamente porem não é organizado:

  <?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'] == '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'] == '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'] == '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'] == 'changename')
      {
    $offer['id'] = $data['id'];
    $offer['type'] = $data['offer_type'];
    $offer['points'] = $data['points'];
    $offer['description'] = $data['offer_description'];
    $offer['name'] = $data['offer_name'];
  }
       
       return $offer;
   }
   
   function getOfferArray_cat1()
   {
   
       $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').' WHERE `category` = 1 ORDER BY `id`;');
       $i_pacc = 0;
       $i_item = 0;
       $i_container = 0;
       $i_changename = 0;
       $i_redskull = 0;
       while($data = $offer_list->fetch()) {
           if ($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++;
           }
       }
       return $offer_array;
   }
   function getOfferArray_cat2()
   {
   
       $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').' WHERE `category` = 2 ORDER BY `id`;');
       $i_pacc = 0;
       $i_item = 0;
       $i_container = 0;
       $i_changename = 0;
         $i_redskull = 0;
       while($data = $offer_list->fetch()) {
           if ($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++;
           }
       }
       return $offer_array;
   }       
   function getOfferArray_cat3()
   {
   
       $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').' WHERE `category` = 3 ORDER BY `id`;');
       $i_pacc = 0;
       $i_item = 0;
       $i_container = 0;
                $i_changename = 0;
                  $i_redskull = 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++;
           
           }
          
       }
       return $offer_array;
   }       
   
   
   function getOfferArray_cat4()
   {
   
       $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').' WHERE `category` = 4 ORDER BY `id`;');
       $i_pacc = 0;
       $i_item = 0;
       $i_container = 0;
       $i_changename = 0;
         $i_redskull = 0;
       while($data = $offer_list->fetch()) {
           
      if ($data['offer_type'] == 'changename')
    {
      $offer_array['changename'][$i_changename]['id'] = $data['id'];
      $offer_array['changename'][$i_changename]['points'] = $data['points'];
      $offer_array['changename'][$i_changename]['description'] = $data['offer_description'];
      $offer_array['changename'][$i_changename]['name'] = $data['offer_name'];
      $i_changename++;
    }
          
       }
       return $offer_array;
   }       
   
   
   
      
   function getOfferArray_cat5()
   {
   
       $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').' WHERE `category` = 5 ORDER BY `id`;');
       $i_pacc = 0;
       $i_item = 0;
       $i_container = 0;
       $i_changename = 0;
         $i_redskull = 0;
       while($data = $offer_list->fetch()) {
           
                if ($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++;
    }
          
       }
       return $offer_array;
   }       
   
   
   
   
    if($action == "category=5")
           {
           unset($_SESSION['viewed_confirmation_page']);
           $main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.<br /><br /></center></h2>';
           $offer_list = getOfferArray_cat5();
 
          
           
           
               if(count($offer_list['redskull']) > 0)
           {
             $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">VIP</a><a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Name</a><a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;">Frags</a>';
               $main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:#F1E0C6;"><td colspan="4" style="height:5px;"></td></tr></table>';
               $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#b7a58a"><td colspan="3"><font color="white" size="4"><b>&nbsp;Remove Frags</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Image</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['redskull'] as $redskull)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Remove Frags</td><td><b>'.$redskull['name'].'</b> ('.$redskull['points'].' points)<br />'.$redskull['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="'.$redskull['id'].'"><input type=submit" value="Buy '.$redskull['name].'"><br><font color="black"<b>for '.$redskull['points'].' points</b></form>';
                   }
               }
               $main_content .= '</table><br />';
           }
 
   
           
       }
   
   
   
   
   
   
   
   if($action == "category=4")
           {
           unset($_SESSION['viewed_confirmation_page']);
           $main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.<br /><br /></center></h2>';
           $offer_list = getOfferArray_cat4();
 
           
           //show list of pacc offers
    if(count($offer_list['changename']) > 0)
           {
             $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">VIP</a><a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;">Name</a><a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Frags</a>';
               $main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:#F1E0C6;"><td colspan="4" style="height:5px;"></td></tr></table>';
               $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#b7a58a"><td colspan="3"><font color="white" size="4"><b>&nbsp;Change name</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Image</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['changename'] as $changename)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="http://images3.wikia.nocookie.net/tibia/en/images/4/41/Bill.gif"></td><td><b>'.$changename['name'].'</b>('.$changename['points'].' points)<br />'.$changename['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="'.$changename['id'].'"><input type=submit" value="Buy '.$changename['name].'"><br><font color="black"<b>for '.$changename['points'].' points</b></form>';
                   }
               }
               $main_content .= '</table><br />';
           }
 
   
           
       }
   
   
   
   
        if($action == "category=3")
           {
           unset($_SESSION['viewed_confirmation_page']);
           $main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.<br /><br /></center></h2>';
           $offer_list = getOfferArray_cat3();
 
 
 
           //show list of pacc offers
            if(count($offer_list['pacc']) > 0)
           {
             $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;">VIP</a><a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Name</a><a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Frags</a>';
               $main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:#F1E0C6;"><td colspan="4" style="height:5px;"></td></tr></table>';
               $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#b7a58a"><td colspan="3"><font color="white" size="4"><b>&nbsp;VIP Account</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Image</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['pacc'] as $pacc)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="http://images3.wikia.nocookie.net/tibia/en/images/e/ea/Document_(Certificate).gif"></td><td><b>'.$pacc['name'].'</b>('.$pacc['points'].' points)<br />'.$pacc['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="'.$pacc['id'].'"><input type=submit" value="Buy '.$pacc['name].'"><br><b>for '.$pacc['points'].' points</b></form>';
                   }
               }
               $main_content .= '</table><br />';
           }
           
           
           
          
           
           
       }
         if($action == "category=2")
           {
           unset($_SESSION['viewed_confirmation_page']);
           $main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.<br /><br /></center></h2>';
           $offer_list = getOfferArray_cat2();
           //show list of items offers
           if(count($offer_list['item']) > 0)
           {
                $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">VIP</a><a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Name</a><a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Frags</a>';
               $main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:#F1E0C6;"><td colspan="4" style="height:5px;"></td></tr></table>';
               $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#b7a58a"><td colspan="3"><font color="white" size="4"><b>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['item'] as $item)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$item['item_id'].'.gif"></td><td><b>'.$item['name'].'</b> ('.$item['points'].' points)<br />'.$item['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="'.$item['id'].'"><input type=submit" value="Buy '.$item['name].'"><br><b>for '.$item['points'].' points</b></form>';
                   }
                   $main_content .= '</td></tr>';
               }
               $main_content .= '</table><br />';
           }
       }
       if($action == '')
       {
           unset($_SESSION['viewed_confirmation_page']);
           $main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' Shop.<br /><br /></center></h2>';
           $offer_list = getOfferArray_cat1();
           //show list of items offers
           if(count($offer_list['item']) > 0)
           { 
               $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">VIP</a><a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Name</a><a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Frags</a>';
               $main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:#F1E0C6;"><td colspan="4" style="height:5px;"></td></tr></table>';
               $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#b7a58a"><td colspan="3"><font color="#FFFFFF" size="4"><b>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['item'] as $item)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$item['item_id'].'.gif"></td><td><b>'.$item['name'].'</b> ('.$item['points'].' points)<br />'.$item['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="'.$item['id'].'"><input type=submit" value="Buy '.$item['name].'"><br><b>for '.$item['points'].' points</b></form>';
                   }
                   $main_content .= '</td></tr>';
               }
               $main_content .= '</table><br />';
           }
       }
       elseif($action == 'select_player')
       {
           unset($_SESSION['viewed_confirmation_page']);
           if(!$logged) {
               $main_content .= 'Please login first.';
           }
           else
           {
               $buy_id = (int) $_REQUEST['buy_id'];
               if(empty($buy_id))
               {
                   $main_content .= 'Please <a href="?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'])
          {
            $main_content .= '<h2>Select player</h2>
            <table border="0" cellpadding="1" cellspacing="1" width="650">
            <tr bgcolor="#b7a58a"><td colspan="2"><font color="white" size="4"><b>Selected offer</b></font></td></tr>
            <tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550">'.$buy_offer['name'].'</td></tr>
            <tr bgcolor="#F1E0C6"><td width="100"><b>Description:</b></td><td width="550">'.$buy_offer['description'].'</td></tr>
            </table><br />
            <form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
            <table border="0" cellpadding="1" cellspacing="1" width="650">
            <tr bgcolor="#b7a58a"><td colspan="2"><font color="white" size="4"><b>Give to player from your account</b></font></td></tr>
            <tr bgcolor="#F1E0C6"><td width="110"><b>Name:</b></td><td width="550"><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>';
              }
            }
            else
            {
              $main_content .= 'You don\'t have any character on your account.';
            }
            $main_content .= '</select>&nbsp;<input type="submit" value="Give"></td></tr>
            </table>
            </form><br />
 
<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST>
<input type="hidden" name="buy_id" value="'.$buy_id.'">
              <table border="0" cellpadding="1" cellspacing="1" width="650">
              <tr bgcolor="#b7a58a"><td colspan="2"><font color="white" size="4"><b>Give item to other player</b></font></td></tr>
              <tr bgcolor="#F1E0C6"><td width="110"><b>To player:</b></td><td width="550"><input type="text" name="buy_name"> - name of player on</td></tr>
              <tr bgcolor="#F1E0C6"><td width="110"><b>From:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Give"> - your nick, \'empty\' = Anonymous</td></tr>
              </table><br />
              </form>
 
';
 
            $main_content .= '*VIP is for all characters from account of selected player name';
          }
          else
          {
            $main_content .= 'For this item you need <b>'.$buy_offer['points'].'</b> points. You have only <b>'.$user_premium_points.'</b> premium points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy premium points.';
          }
        }
        else
        {
              $main_content .= '<form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
              <table border="0" cellpadding="1" cellspacing="1" width="650">
              <tr bgcolor="#b7a58a"><td colspan="2"><font color="white" size="4"><b>Change Name:</b></font></td></tr>
              <tr bgcolor="#F1E0C6"><td width="110"><b>Name:</b></td><td width="550"><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>';
              }
            }
            else
            {
              $main_content .= 'You don\'t have any character on your account.';
            }
            $main_content .= '</select></td></tr>
              <tr bgcolor="#F1E0C6"><td width="110"><b>New name:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Change Name"></td></tr>
              </table><br />
              </form>';
              }
        }
        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 .= 'Please login first.';
    }
    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);
// $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    // $user_premium_points = $user_premium_points - $buy_offer['points'];
                                            else
                                                $buy_player_account->setCustomField('viptime', time() + $buy_offer['days'] * 86400);
 $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                            // $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'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                            }
elseif($buy_offer['type'] == 'unban')
  {
  $my_acc_id = $account_logged->getCustomField('id');
  $datadata = $SQL->query('SELECT * FROM '.$SQL->tableName('bans').' WHERE value = '.$my_acc_id.';')->fetch();
  if($datadata['value'] == $my_acc_id) {
 
    if($SQL->query('DELETE FROM bans WHERE value= '.$my_acc_id.' LIMIT 1;')) {
    }
    else
    {
    $SQL->query('DELETE FROM bans WHERE account= '.$my_acc_id.' LIMIT 1;');
    }
    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    $user_premium_points = $user_premium_points - $buy_offer['points'];
    $main_content .= '
      <h2>
        Ban Deleted!
      </h2>
      <b>
        Your account has been unbanned for '.$buy_offer['points'].' premium points
      </b>
      from your account.
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
      You don\'t have any bans in your account!
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }
  ////////////////////////////////
  elseif($buy_offer['type'] == 'itemlogout')
  {
  $my_acc_id = $buy_player->getCustomField('id');
  $datadata = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE id = '.$my_acc_id.';')->fetch();
  $datadata2 = $SQL->query('SELECT * FROM '.$SQL->tableName('player_items').' WHERE player_id = '.$my_acc_id.';')->fetch();
  if($datadata['online'] == '0') {
  if ($datadata2['pid'] != '10') {
  if ($datadata['cap'] >= $SQL->quote($buy_offer['free_cap'])) {
    $SQL->query('INSERT INTO player_items (player_id, pid, itemtype, count) VALUES ('.$my_acc_id.', '.$SQL->quote($buy_offer['pid']).', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['count1']).');');
    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    $user_premium_points = $user_premium_points - $buy_offer['points'];
    $main_content .= '
      <h2>
        Item received to player: '.$buy_player->getName().'!
      </h2>
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN 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');
  $dataget = $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($dataget['online'] == '0') {
    if($checkname == false) { 
  $buybuy = 'buy_from';
      $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'];
    $suma_levels = $buy_offer['level'] + $dataget['level'];
    $main_content .= '
      <h2>
        Your name has changed to '.$buy_from.'
      </h2>
      <b>
        You have
      </b>
      <br>
        <b>
          '.$user_premium_points.' premium points left
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '<b>Sorry the name "<i>'.$buy_from.'</i>" does already exist.</b>';
  }
  } else
  {
  $suma_levels = $buy_offer['level'] + $dataget['level'];
    $main_content .= '
    <b>
     '.$buy_name.' has to be offline to complete transaction.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }
  //////////////////////////
    ////////////////////////////////
  elseif($buy_offer['type'] == 'redskull')
  {
  //Obtener id ed la cuenta
  $my_acc_id = $buy_player->getCustomField('id');
  $dataget = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
  if($dataget['frags'] >= '1' AND $dataget['online'] <= '1') {
 
        $SQL->query('UPDATE players SET skull=0, skulltime=0, frags=0 WHERE id='. $my_acc_id .';');
        $SQL->query('UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_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 .= '
      <h2>
        Frags Removed!
      </h2>
      <b>
        Your frags has been removed to the player '.$buy_player->getName().',
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
    '.$buy_player->getName().' has to be offline or have frags to complete transaction!.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }
  
  //////////////////////////
 
 
 
              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 .= '<h2>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> items (he will get this items after relog) for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br /><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a>';
                    }
                    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 .= '<h2>Container of items added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> items (he will get this container with items after relog) for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br /><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a>';
                    }
                  }
                  else
                  {
                  if($buy_offer['type'] != 'changename') {
                    $set_session = TRUE;
                    $_SESSION['viewed_confirmation_page'] = 'yes';
                    $main_content .= '<h2>Confirm transaction</h2>
                    <table border="0" cellpadding="1" cellspacing="1" width="650">
                    <tr bgcolor="#b7a58a"><td colspan="3"><font color="white" size="4"><b>Confirm transaction</b></font></td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Cost:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' premium points</b> from your account</td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>For Player:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>From:</b></td><td width="550" colspan="2"><font color="red">'.$buy_from.'</font></td></tr>
                    <tr bgcolor="gold"><td width="100"><b>Transaction?</b></td><td width="275" align="left">
                    <form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST"><input type="hidden" name="buy_confirmed" value="yes"><input type="hidden" name="buy_id" value="'.$buy_id.'"><input type="hidden" name="buy_from" value="'.urlencode($new_name).'"><input type="hidden" name="buy_name" value="'.urlencode($buy_name).'"><input type="submit" value="Accept"></form></td>
                    <td align="right"><form action="index.php?subtopic=shopsystem" method="POST"><input type="submit" value="Cancel"></form></td></tr>
                    </table>
                    ';
                    }
                    else
                    {
                    $set_session = TRUE;
                    $_SESSION['viewed_confirmation_page'] = 'yes';
                    $main_content .= '<h2>Confirm change name</h2>
                    <table border="0" cellpadding="1" cellspacing="1" width="650">
                    <tr bgcolor="#b7a58a"><td colspan="3"><font color="white" size="4"><b>Confirm transaction</b></font></td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Cost:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' premium points</b> from your account</td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>Current Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
                    <tr bgcolor="#F1E0C6"><td width="100"><b>New Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_from.'</font></td></tr>
                    <tr bgcolor="red"><td width="100"><b>Change Name?</b></td><td width="275" align="left">
                    <form action="index.php?subtopic=shopsystem&action=confirm_transaction" method="POST"><input type="hidden" name="buy_confirmed" value="yes"><input type="hidden" name="buy_id" value="'.$buy_id.'"><input type="hidden" name="buy_from" value="'.urlencode($buy_from).'"><input type="hidden" name="buy_name" value="'.urlencode($buy_name).'"><input type="submit" value="Accept"></form></td>
                    <td align="right"><form action="index.php?subtopic=shopsystem" method="POST"><input type="submit" value="Cancel"></form></td></tr>
                    </table>
                    ';
                    }
                  }
                }
                else
                {
                  $main_content .= '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> premium points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy premium points.';
            }
          }
          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 == 'show_history')
  {
    if(!$logged) {
      $main_content .= 'Please login first.';
    }
    else
    {
      $items_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_history_item').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
      if(is_object($items_history_received)) {
        foreach($items_history_received as $item_received)
        {
          if($account_logged->getId() == $item_received['to_account'])
            $char_color = 'green';
          else
            $char_color = 'red';
          $items_received_text .= '<tr bgcolor="#F1E0C6"><td><font color="'.$char_color.'">'.$item_received['to_name'].'</font></td><td>';
          if($account_logged->getId() == $item_received['from_account'])
            $items_received_text .= '<i>Your account</i>';
          else
            $items_received_text .= $item_received['from_nick'];
          $items_received_text .= '</td><td>'.$item_received['offer_id'].'</td><td>'.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 .= '<h2>Item transactions</h2><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><tr bgcolor="#F1E0C6"><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 OTS</b></td></tr>'.$items_received_text.'</table><br />';
      }
      if(!empty($paccs_received_text))
      {
        $main_content .= '<h2>VIP transactions</h2><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><tr bgcolor="#F1E0C6"><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 item or VIP Account.';
    }
  }
  $main_content .= '<br><br><b><font color="green">You have premium points: </font></b>'.$user_premium_points;
}
else
  $main_content .= 'Shop system is blocked on this server. Admin must install this script (LUA and in database only, PHP is installed) on server and set <b>shop_system = "1"</b> in config.ini file';
?>  

 
Sei que é um trabalho meio grande, mais se alguém souber ao menos me indicar o que devo fazer já ajuda bastante, Obrigado.
Editado por Fausto32 (veja o histórico de edições)

          Procuro Equipe para projeto sério com remuneração, maior necessidade Programador em C\C++.

Link para o post
Compartilhar em outros sites
Fausto32

Fausto32 92

Postado
  • Autor
Postado

Não, realmente aquele script tá com um sistema de premium e um de vip days, mais não consegui remover por completo nem um sem dar algum erro na página.

          Procuro Equipe para projeto sério com remuneração, maior necessidade Programador em C\C++.

Link para o post
Compartilhar em outros sites

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emojis são permitidos.

×   Seu link foi automaticamente incorporado.   Mostrar como link

×   Seu conteúdo anterior foi restaurado.   Limpar o editor

×   Não é possível colar imagens diretamente. Carregar ou inserir imagens do URL.

×
 Share
Seguidores 0
Ir para a lista de tópicos

  • Quem Está Navegando   0 membros estão online

    Nenhum usuário registrado visualizando esta página.

  • Conteúdo Similar

    • Tomaxx
      (Resolvido)(AJUDA) Erro Pagina Cast System Gesior ACC
      Por Tomaxx
      Olá Pessoal Eu aqui de novo Estou precisando de ajuda
       
       
      Adiciono Normal A Pagina De Cast System Lembrando Que O Meu é o gesior 2012 que não precisa adicionar a pagina no Index.php
       
      ai tento entrar na pagina segue código de erro
       
       
       
       
      Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\pages\cast.php on line 158
       
       
       
      Segue minha pagina de cast Clique Aqui
       
       
       
      Lembrando que não é necessária mente esta pagina se alguém tiver uma que esta funcionando ok p:
       
       
      Valendo REP ><
    • Tomaxx
      (Resolvido)(PEDIDO) Pagina De Cast Para O Novo Gesior
      Por Tomaxx
      Olá Gostaria de fazer um pedido
       
      Meu Gesior é esse dos novo da mesma plataforma do GESIOR VICTORWEBMASTER 1.0 V2
      tenho uma pagina de cast system aqui mas é do gesior antigo e não consigo adicionar neste novo gesior e gostaria de estar pedindo uma pagina de cast compatível com o novo gesior 
       
      Valendo REP ><
    • Tomaxx
      (Resolvido)(AJUDA) Gesior ACC Check Account, Check Email E Check Name
      Por Tomaxx
      Olá eu aqui novamente rs bom amigos estou com o seguinte problema posso tentar por diversos nomes emails e etc... mas não fica verdinho segue imagens ressaltando que uso Gesior 2012 TFS 1.0
       
       
       
      Account
       
       

       
      Character
       

       
       
      Valendo REP
       
      ><
    • Helliab
      [Gesior ACC] Compra e Venda de personagens por pontos
      Por Helliab
      Compra e venda de personagens por pontos para Gesior ACC.
      Vamos lá..
       
      FOTOS:
       
      Venda:

       
       
      Compra:

       

       
       
      Crie um arquivo dentro do htdocs, chamado buychar.php e dentro dele coloque:
       
      <?PHP if($logged) { if ($action == '') { $main_content .= '<center>Here is the list of the current characters that are in the shop!</center>'; $main_content .= '<BR>'; $main_content .= '<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white width="64px"><CENTER><B>Name</B></CENTER></TD><TD CLASS=white width="64px"><CENTER><B>Vocation</B></CENTER></TD><TD CLASS=white width="64px"><CENTER><B>Level</B></CENTER></TD><TD CLASS=white width="64px"><CENTER><B>Price</B></CENTER></TD><TD CLASS=white width="64px"><CENTER><B>Buy it</B></CENTER></TD></TR>'; $getall = $SQL->query('SELECT `id`, `name`, `price`, `status` FROM `sellchar` ORDER BY `id`')or die(mysql_error()); foreach ($getall as $tt) { $namer = $tt['name']; $queryt = $SQL->query("SELECT `name`, `vocation`, `level` FROM `players` WHERE `name` = '$namer'"); foreach ($queryt as $ty) { if ($ty['vocation'] == 1) { $tu = 'Sorcerer'; } else if ($ty['vocation'] == 2) { $tu = 'Druid'; } else if ($ty['vocation'] == 3) { $tu = 'Paladin'; } else if ($ty['vocation'] == 4) { $tu = 'Knight'; } else if ($ty['vocation'] == 5) { $tu = 'Sorcerer'; } else if ($ty['vocation'] == 6) { $tu = 'Druid'; } else if ($ty['vocation'] == 7) { $tu = 'Paladin'; } else if ($ty['vocation'] == 8) { $tu = 'Knight'; } $ee = $tt['name']; $ii = $tt['price']; $main_content .= '<TR BGCOLOR='.$config['site']['darkborder'].'><TD CLASS=black width="64px"><CENTER><B><a href="index.php?subtopic=characters&name='.$tt['name'].'">'.$tt['name'].'</a></B></CENTER></TD><TD CLASS=black width="64px"><CENTER><B>'.$tu.'</B></CENTER></TD><TD CLASS=black width="64px"><CENTER><B>'.$ty['level'].'</B></CENTER></TD><TD CLASS=black width="64px"><CENTER><B>'.$tt['price'].'</B></CENTER></TD><TD CLASS=black width="64px"><CENTER><B> <form action="?subtopic=buychar&action=buy" method="POST"> <input type="hidden" name="char" value="'.$ee.'"> <input type="hidden" name="price" value="'.$ii.'"> <input type="submit" name="submit" value="Buy it"></B></CENTER></TD></TR></form>'; } } $main_content .= '</TABLE>'; } if ($action == 'buy') { $name = $_POST['char']; $price = $_POST['price']; $ceh = $SQL->query("SELECT `name` FROM `sellchar` WHERE `name` = '$name'"); if ($ceh) { if ($name == '') { $main_content .= '<b><center>Select a character to buy first/b>'; } else { $user_premium_points = $account_logged->getCustomField('premium_points'); $user_id = $account_logged->getCustomField('id'); if ($user_premium_points >= $price) { $check = $SQL->query("SELECT * FROM `sellchar` WHERE `name` = '$name'") or die(mysql_error()); $check1 = $SQL->query("SELECT * FROM `players` WHERE `name` = '$name'") or die(mysql_error()); $check2 = $SQL->query("SELECT `oldid` FROM `sellchar` WHERE `name` = '$name'"); foreach ($check as $result) { foreach($check1 as $res) { foreach($check2 as $ress) { $oid = $ress['oldid']; $main_content .= '<center>You bought<b> '.$name.' ( '.$res['level'].' ) </b>for <b>'.$result['price'].' points.</b><br></center>'; $main_content .= '<br>'; $main_content .= '<center><b>The character is in your account, have fun!</b></center>'; $execute1 = $SQL->query("UPDATE `accounts` SET `premium_points` = `premium_points` - '$price' WHERE `id` = '$user_id'"); $execute2 = $SQL->query("UPDATE `players` SET `account_id` = '$user_id' WHERE `name` = '$name'"); $execute2 = $SQL->query("UPDATE `accounts` SET `premium_points` = `premium_points` + '$price' WHERE `id` = '$oid'"); $execute3 = $SQL->query("DELETE FROM `sellchar` WHERE `name` = '$name'"); } } } } else { $main_content .= '<center><b>You dont have enought premium points</b></center>'; } } } else { $main_content .= '<center><b>Character cannot be buyed</b></center>'; } } } else { $main_content .= '<center>Please log in first!</center>'; } ?>  
      depois crie um chamado sellchar.php e coloque isso:
      <?PHP if($logged) { $main_content .= '<center><b>Here you can put your character on sale!</center></b><br>'; $main_content .= 'If you put your character on sale anyone can buy it, you will lose acces to that character and you wont be able to log in with that character until someone buys it, you can also delete your offer by talking to an admin!<br><b>when someone buys your character you will get the price in points!</b>'; $main_content .= '<br>'; $main_content .= '<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white width="64px"><CENTER><B>Sell your characters</B></CENTER></TD></TR>'; $main_content .= '<TR BGCOLOR='.$config['site']['darkborder'].'><TD CLASS=black width="64px"><B></B>'; $players_from_logged_acc = $account_logged->getPlayersList(); $players_from_logged_acc->orderBy('name'); $main_content .= '<form action="" method="post"><select name="char">'; foreach($players_from_logged_acc as $player) { $main_content .= '<option>'.$player->getName().'</option>'; } $main_content .= '</select>Select a character to sell<br>'; $main_content .= '<input type="text" name="price" maxlength="10" size="4" >Select the price of the character<br>'; $main_content .= '<input type="submit" name="submit" value="Sell character"></TD></TR>'; $main_content .= '</form></table>'; if (isset($_POST['submit'])) { $char = stripslashes($_POST['char']); $price = stripslashes($_POST['price']); if ($char && $price) { if(is_numeric(trim($_POST['price']))) { $check2 = $SQL->query("SELECT * FROM `players` WHERE `name` = '$char'") or die(mysql_error()); foreach ($check2 as $re) { $voc = $re['vocation']; $oid = $re['account_id']; } $check1 = $SQL->query("UPDATE `players` SET `account_id` = 1 WHERE `name` = '$char'") or die(mysql_error()); $check3 = $SQL->query("INSERT INTO `sellchar` VALUES ('','$char','$voc','$price','1','$oid')"); $main_content .= '<b><center>You added your character correctly, thanks!</b></center>'; header("Location: index.php?subtopic=buychar"); } else { $main_content .= '<b><center>Set a numeric price!!</b></center>'; } } else { $main_content .= '<b><center>Fill out all fields!</b></center>'; } } } else { $main_content .= '<b><center>Please log in first!</b></center>'; } ?>  
      depois disso vá em htdocs/layouts/layout que você usa/layouts e insira as duas páginas aonde você bem querer(sugiro que seja na aba shop, pois é venda e compra).. caso alguém não saiba posta aqui no tópico que eu ensino.
       
      Agora adicione isso no index.php
      case "sellchar";                 $topic = "Sell Char";                 $subtopic = "sellchar";                 include("sellchar.php");     break;          case "buychar";                 $topic = "Buy Char";                 $subtopic = "buychar";                 include("buychar.php");     break;  
      Agora acesse a database do OT e insira este comando SQL
      CREATE TABLE IF NOT EXISTS `sellchar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL, `vocation` int(11) NOT NULL, `price` int(11) NOT NULL, `status` varchar(40) NOT NULL, `oldid` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Pronto para ser usado!!
       
       
       
       
      obs1: Caso você não adicionou a página no layouts acesse assim:
       
      127.0.0.1/?subtopic=sellchar
      127.0.0.1/?subtopic=buychar
       
      obs2: não tem como a pessoa que colocou a venda tirá-lo depois, se algum programador se habilitar a fazer o esquema aí para nós, fico grato.
       
       
       
       
      --- Créditos ---
      Raggaer
      Helliab por trazer ao TK.
       
      REP++
       
      @helliabsantana
    • Swiruseq69
      NRTN Template
      Por Swiruseq69
      Preview

       
      ___________________________________________________
       
      Créditos
      Azuu
      TenTypSwir
      ___________________________________________________
       
      Scan
      https://www.virustotal.com/#/file/580c501a5e3b2aa8f29888873a92660d7b6bdb94f99893cbf1eb73e17b9ade52/detection
       
      Download
      nrtn_layout.tgz

TibiaKing

Open Tibia Server

Quer aprender a criar seu próprio servidor de Tibia? Então está no lugar certo, aqui você encontrará milhares de tutorias, scripts, códigos, mapas e utilitários para que você possa fazer o seu próprio servidor de Tibia começando do zero.

Redes Sociais

Anuncie no TibiaKing

Precisa de mais visibilidade em seus projetos? Quer fazer um plano publicitário para o seu servidor? Anuncie no OTKing e faça sua divulgação, possuímos centenas de acessos simultâneos e milhares diários, com certeza será a sua solução!

×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo

  Eu aceito