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

Postado Junho 9, 2015 10 anos

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:

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> <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"> <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"> <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> 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> 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> 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> 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> 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> 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> 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> 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> <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"> <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"> <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 Junho 9, 2015 10 anos por Fausto32 (veja o histórico de edições)

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

Citar

Mention

Entrar

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

Featured Replies

Participe da conversa

Quem Está Navegando 0

Conteúdo Similar

Estatísticas dos Fóruns

Informação Importante

Account

Navigation

Pesquisar