<?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_vip_points = $account_logged->getCustomField('vip_points');
}
else
{
$user_vip_points = 'CONECTARSE PARA COMPRAR';
}
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'] == 'vip')
{
$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'] == 'addonitem')
{
$offer['id'] = $data['id'];
$offer['type'] = $data['offer_type'];
$offer['item_id'] = $data['itemid1'];
$offer['item_count'] = $data['count1'];
$offer['points'] = $data['points'];
$offer['description'] = $data['offer_description'];
$offer['name'] = $data['offer_name'];
}
elseif ($data['offer_type'] == 'container')
{
$offer['id'] = $data['id'];
$offer['type'] = $data['offer_type'];
$offer['container_id'] = $data['itemid2'];
$offer['container_count'] = $data['count2'];
$offer['item_id'] = $data['itemid1'];
$offer['item_count'] = $data['count1'];
$offer['points'] = $data['points'];
$offer['description'] = $data['offer_description'];
$offer['name'] = $data['offer_name'];
}
elseif ($data['offer_type'] == 'unban')
{
$offer['id'] = $data['id'];
$offer['type'] = $data['offer_type'];
$offer['points'] = $data['points'];
$offer['description'] = $data['offer_description'];
$offer['name'] = $data['offer_name'];
}
elseif ($data['offer_type'] == 'redskull')
{
$offer['id'] = $data['id'];
$offer['type'] = $data['offer_type'];
$offer['points'] = $data['points'];
$offer['description'] = $data['offer_description'];
$offer['name'] = $data['offer_name'];
}
elseif ($data['offer_type'] == 'itemlogout')
{
$offer['id'] = $data['id'];
$offer['type'] = $data['offer_type'];
$offer['points'] = $data['points'];
$offer['description'] = $data['offer_description'];
$offer['pid'] = $data['pid'];
$offer['count1'] = $data['count1'];
$offer['item_id'] = $data['itemid1'];
$offer['free_cap'] = $data['free_cap'];
}
elseif ($data['offer_type'] == '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_item = 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_container = 0;
while($data = $offer_list->fetch()) {
if ($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++;
}
}
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_vip = 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'] == 'vip')
{
$offer_array['vip'][$i_vip]['id'] = $data['id'];
$offer_array['vip'][$i_vip]['days'] = $data['count1'];
$offer_array['vip'][$i_vip]['points'] = $data['points'];
$offer_array['vip'][$i_vip]['description'] = $data['offer_description'];
$offer_array['vip'][$i_vip]['name'] = $data['offer_name'];
$i_vip++;
}
}
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_unban = 0;
$i_redskull = 0;
$i_itemlogout = 0;
$i_changename = 0;
while($data = $offer_list->fetch())
{
if ($data['offer_type'] == 'unban')
{
$offer_array['unban'][$i_unban]['id'] = $data['id'];
$offer_array['unban'][$i_unban]['points'] = $data['points'];
$offer_array['unban'][$i_unban]['description'] = $data['offer_description'];
$offer_array['unban'][$i_unban]['name'] = $data['offer_name'];
$i_unban++;
}
elseif ($data['offer_type'] == 'redskull')
{
$offer_array['redskull'][$i_redskull]['id'] = $data['id'];
$offer_array['redskull'][$i_redskull]['points'] = $data['points'];
$offer_array['redskull'][$i_redskull]['description'] = $data['offer_description'];
$offer_array['redskull'][$i_redskull]['name'] = $data['offer_name'];
$i_redskull++;
}
elseif ($data['offer_type'] == 'itemlogout')
{
$offer_array['itemlogout'][$i_itemlogout]['id'] = $data['id'];
$offer_array['itemlogout'][$i_itemlogout]['points'] = $data['points'];
$offer_array['itemlogout'][$i_itemlogout]['description'] = $data['offer_description'];
$offer_array['itemlogout'][$i_itemlogout]['name'] = $data['offer_name'];
$offer_array['itemlogout'][$i_itemlogout]['count1'] = $data['count1'];
$offer_array['itemlogout'][$i_itemlogout]['pid'] = $data['pid'];
$offer_array['itemlogout'][$i_itemlogout]['item_id'] = $data['itemid1'];
$offer_array['itemlogout'][$i_itemlogout]['free_cap'] = $data['free_cap'];
$i_itemlogout++;
}
elseif ($data['offer_type'] == '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_addonitem = 0;
while($data = $offer_list->fetch()) {
if ($data['offer_type'] == 'addonitem')
{
$offer_array['addonitem'][$i_addonitem]['id'] = $data['id'];
$offer_array['addonitem'][$i_addonitem]['item_id'] = $data['itemid1'];
$offer_array['addonitem'][$i_addonitem]['item_count'] = $data['count1'];
$offer_array['addonitem'][$i_addonitem]['points'] = $data['points'];
$offer_array['addonitem'][$i_addonitem]['description'] = $data['offer_description'];
$offer_array['addonitem'][$i_addonitem]['name'] = $data['offer_name'];
$i_addonitem++;
}
}
return $offer_array;
}
if($action == '')
{
unset($_SESSION['viewed_confirmation_page']);
$main_content .= '<h2><center>Tienda '.$config['server']['serverName'].'</center></h2><br>';
$offer_list = getOfferArray_cat1();
//show list of items offers
if(count($offer_list['item']) > 0)
{
$main_content .= '<center>
<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #FFFFFF;"><b>Items</b></a>
<a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Backpacks</a>
<a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Especiales</a>
<a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Addon Items</a>
<a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Otros</a></center>';
$main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:'.$config['site']['lightborder'].';"><td colspan="4" style="height:5px;"></td></tr></table>';
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> ITEMS</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['item'] as $item)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="images/items/'.$item['item_id'].'.gif"></td><td><b>'.$item['name'].'</b> ('.$item['points'].' puntos)<br />'.$item['description'].'</td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para comprar</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="'.$item['name'].'"><br><b>por '.$item['points'].' puntos</b></form>';
}
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
if($action == 'category=2')
{
unset($_SESSION['viewed_confirmation_page']);
$main_content .= '<h2><center>Tienda '.$config['server']['serverName'].'</center></h2><br>';
$offer_list = getOfferArray_cat2();
//show list of containers offers
if(count($offer_list['container']) > 0)
{
$main_content .= '<center>
<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; 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: '.$config['site']['lightborder'].'; color: #FFFFFF;"><b>Backpacks</b></a>
<a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Especiales</a>
<a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Addon Items</a>
<a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Otros</a></center>';
$main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:'.$config['site']['lightborder'].';"><td colspan="4" style="height:5px;"></td></tr></table>';
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> BACKPACKS</b><center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['container'] as $container)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="images/items/'.$container['item_id'].'.gif"></td><td><b>'.$container['name'].'</b> ('.$container['points'].' puntos)<br />'.$container['description'].'</td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para comprar</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="'.$container['name'].'"><br><b>por '.$container['points'].' puntos</b></form>';
}
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
if($action == 'category=4')
{
unset($_SESSION['viewed_confirmation_page']);
$main_content .= '<h2><center>Tienda '.$config['server']['serverName'].'</center></h2><br>';
$offer_list = getOfferArray_cat4();
if(count($offer_list['itemlogout']) > 0)
{
$main_content .= '<center>
<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; 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: '.$config['site']['lightborder'].'; color: #aaaaaa;">Backpacks</a>
<a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Especiales</a>
<a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Addon Items</a>
<a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #FFFFFF;"><b>Otros</b></a></center>';
$main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:'.$config['site']['lightborder'].';"><td colspan="4" style="height:5px;"></td></tr></table>';
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> ITEMS AL DESCONECTARSE</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['itemlogout'] as $itemlogout)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="images/items/'.$itemlogout['item_id'].'.gif"></td><td><center><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' puntos)<br />'.$itemlogout['description'].'</center></td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para Comprar</b>';
}
else
{
$main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemlogout['id'].'"><input type="submit" value="'.$itemlogout['name'].'"><br><b>por '.$itemlogout['points'].' puntos</b></form>';
}
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
if($action == 'category=5')
{
unset($_SESSION['viewed_confirmation_page']);
$main_content .= '<h2><center>Tienda '.$config['server']['serverName'].'</center></h2><br>';
$offer_list = getOfferArray_cat5();
//show list of items offers
if(count($offer_list['addonitem']) > 0)
{
$main_content .= '<center>
<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; 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: '.$config['site']['lightborder'].'; color: #aaaaaa;">Backpacks</a>
<a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Especiales</a>
<a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #FFFFFF;"><b>Addon Items</b></a>
<a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Otros</a></center>';
$main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:'.$config['site']['lightborder'].';"><td colspan="4" style="height:5px;"></td></tr></table>';
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> ADDON ITEMS</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['addonitem'] as $addonitem)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="images/items/'.$addonitem['item_id'].'.gif"></td><td><b>'.$addonitem['name'].'</b> ('.$addonitem['points'].' puntos)<br />'.$addonitem['description'].'</td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para comprar</b>';
}
else
{
$main_content .= '<form action="?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$addonitem['id'].'"><input type="submit" value="'.$addonitem['name'].'"><br><b>por '.$addonitem['points'].' puntos</b></form>';
}
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
if($action == "category=3")
{
unset($_SESSION['viewed_confirmation_page']);
$main_content .= '<h2><center>Tienda '.$config['server']['serverName'].'</center></h2><br>';
$offer_list = getOfferArray_cat3();
if(count($offer_list['pacc']) > 0)
{
$main_content .= '<center>
<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; 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: '.$config['site']['lightborder'].'; color: #aaaaaa;">Backpacks</a>
<a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #FFFFFF;"><b>Especiales</b></a>
<a href="index.php?subtopic=shopsystem&action=category=5" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Addon Items</a>
<a href="index.php?subtopic=shopsystem&action=category=4" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: '.$config['site']['lightborder'].'; color: #aaaaaa;">Otros</a></center>';
$main_content .= '<table style="width:100%;" cellpadding="1" cellspacing="1"><tr style="background:'.$config['site']['lightborder'].';"><td colspan="4" style="height:5px;"></td></tr></table>';
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> PACC</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Days</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['pacc'] as $pacc)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center">'.$pacc['days'].'</td><td><b>'.$pacc['name'].'</b> ('.$pacc['points'].' puntos)<br />'.$pacc['description'].'</td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para Comprar</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="'.$pacc['name'].'"><br><b>por '.$pacc['points'].' puntos</b></form>';
}
}
$main_content .= '</table><br />';
}
if(count($offer_list['vip']) > 0)
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> VIP</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Days</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['vip'] as $vip)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center">'.$vip['days'].'</td><td><b>'.$vip['name'].'</b> ('.$vip['points'].' puntos)<br />'.$vip['description'].'</td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para Comprar</b>';
}
else
{
$main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$vip['id'].'"><input type="submit" value="'.$vip['name'].'"><br><b>por '.$vip['points'].' puntos</b></form>';
}
}
$main_content .= '</table><br />';
}
if($action == "category=4")
{
unset($_SESSION['viewed_confirmation_page']);
$offer_list = getOfferArray_cat4();
if(count($offer_list['changename']) > 0)
{
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> CAMBIA NOMBRE</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['changename'] as $changename)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="item_images/'.$changename['id'].'.gif"></td><td><center><b>'.$changename['name'].'</b> ('.$changename['points'].' puntos)<br />'.$changename['description'].'</td></center><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para Comprar</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="'.$changename['name'].'"><br><b>por '.$changename['points'].' puntos</b></form>';
}
}
$main_content .= '</table><br />';
}
//Remove Red Skull
if(count($offer_list['redskull']) > 0)
{
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> RED SKULL</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['redskull'] as $redskull)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="item_images/'.$redskull['id'].'.gif"></td><td><center><b>'.$redskull['name'].'</b> ('.$redskull['points'].' puntos)<br />'.$redskull['description'].'</center></td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para Comprar</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=" '.$redskull['name'].'"><br><b>por '.$redskull['points'].' puntos</b></form>';
}
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
//Unban
if(count($offer_list['unban']) > 0)
{
$main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="550"><tr width="550" bgcolor="'.$config['site']['darkborder'].'"><td colspan="3"><font color="#FFFFFF" size="4"><center><b> DESBANEAR</b></center></font></td></tr><tr bgcolor="'.$config['site']['darkborder'].'"><td width="50" align="center"><font color=#FFFFFF><b>Imagen</b></font></td><td width="350" align="left"><font color=#FFFFFF><center><b>Descripcion</b></center></font></td><td width="250" align="center"><font color=#FFFFFF><b>Seleccionar Producto</b></font></td></tr>';
foreach($offer_list['unban'] as $unban)
{
$main_content .= '<tr bgcolor="'.$config['site']['lightborder'].'"><td align="center"><img src="item_images/'.$unban['id'].'.gif"></td><td><center><b>'.$unban['name'].'</b> ('.$unban['points'].' puntos)<br />'.$unban['description'].'</center></td><td align="center">';
if(!$logged)
{
$main_content .= '<b>Conectarse para Comprar</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="'.$unban['name'].'"><br><b>por '.$unban['points'].' puntos</b></form>';
}
$main_content .= '</td></tr>';
}
$main_content .= '</table><br />';
}
}
elseif($action == 'select_player')
{
unset($_SESSION['viewed_confirmation_page']);
if(!$logged) {
$main_content .= 'Por favor, conectarse.';
}
else
{
$buy_id = (int) $_REQUEST['buy_id'];
if(empty($buy_id))
{
$main_content .= 'Por favor, <a href="index.php?subtopic=shopsystem">elejir item</a> antes de avanzar.';
}
else
{
$buy_offer = getItemByID($buy_id);
if(isset($buy_offer['id'])) //item exist in database
{
if($buy_offer['type'] != 'changename') {
if($user_vip_points >= $buy_offer['points'])
{
$main_content .= '<h2>Elije Jugador</h2>
<table border="0" cellpadding="1" cellspacing="1" width="550">
<tr bgcolor="'.$config['site']['lightborder'].'"><td colspan="2"><font color="white" size="4"><b>Oferta Seleccionada</b></font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><font color="white"><b>Nombre:</b></td><td width="550">'.$buy_offer['name'].'</font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><font color="white"><b>Descripcion:</b></td><td width="550">'.$buy_offer['description'].'</font></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="550">
<tr bgcolor="'.$config['site']['lightborder'].'"><td colspan="2"><font color="white" size="4"><b>Dar item/dias a tu jugador</b></font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="110"><font color="white"><b>Nombre:</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 .= 'No tienes jugadores en tu cuenta.';
}
$main_content .= '</select> <input type="submit" value="Aceptar"></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="550">
<tr bgcolor="'.$config['site']['lightborder'].'"><td colspan="2"><font color="white" size="4"><b>Dar item/dias a otro jugador</b></font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="110"><font color="white"><b>Para:</b></font></td><td width="550"><input type="text" name="buy_name"> - nombre del personaje</td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="110"><font color="white"><b>Desde:</b></font></td><td width="550"><input type="text" name="buy_from"> <input type="submit" value="Aceptar"> - tu nick, \'vacio\' = Anonimo</td></tr>
</table><br />
</form>';
}
else
{
$main_content .= 'Para este item necesitas <b>'.$buy_offer['points'].'</b> puntos. Y tienes solo <b>'.$user_vip_points.'</b> puntos. Por favor <a href="index.php?subtopic=shopsystem">selecciona otro item</a> o <a href="index.php?subtopic=buypoints">compra mas puntos</a>.';
}
}
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="550">
<tr bgcolor="'.$config['site']['lightborder'].'"><td colspan="2"><font color="white" size="4"><b>Cambiar Nombre:</b></font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="110"><font color="white"><b>Nombre:</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="'.$config['site']['darkborder'].'"><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 .= 'Por favor, conectarse.';
}
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_vip_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_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('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
if($player_premdays == 0)
{
$buy_player_account->setCustomField('lastday', time());
}
$main_content .= '<h2>PACC added!</h2><b>'.$buy_offer['days'].' days</b> of Premium Account added to account of player <b>'.$buy_player->getName().'</b> por <b>'.$buy_offer['points'].' vip puntos</b> from your account.<br />Now you have <b>'.$user_vip_points.' vip puntos</b>.<br /><a href="index.php?subtopic=shopsystem">IR A LA PAGINA PRINCIPAL DE COMPRAS</a>';
}
elseif($buy_offer['type'] == 'vip')
{
$player_vipdays = $buy_player_account->getCustomField('vip_days');
$player_lastlogin = $buy_player_account->getCustomField('lastday');
$save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_vip').' (id, to_name, to_account, from_nick, from_account, price, vip_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('vip_days', ($player_vipdays+$buy_offer['days']*24*60*60));
$account_logged->setCustomField('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
/*if($player_vipdays == 0)
{
$buy_player_account->setCustomField('lastday', time());
}
*/
$main_content .= '<h2>VIP added!</h2><b>'.$buy_offer['days'].' days</b> of VIP Account added to account of player <b>'.$buy_player->getName().'</b> por <b>'.$buy_offer['points'].' vip puntos</b> from your account.<br />Now you have <b>'.$user_vip_points.' vip puntos</b>.<br /><a href="index.php?subtopic=shopsystem">IR A LA PAGINA PRINCIPAL DE COMPRAS</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('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
$main_content .= '
<h2>
Ban Deleted!
</h2>
<b>
Your account has been unbanned por '.$buy_offer['points'].' vip puntos
</b>
from your account.
<br>
Now you have
<b>
'.$user_vip_points.' vip puntos
</b>.
<br>
<a href="index.php?subtopic=shopsystem">
IR A LA PAGINA PRINCIPAL DE COMPRAS
</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('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
$main_content .= '
<h2>
Item received to player: '.$buy_player->getName().'!
</h2>
<br>
Now you have
<b>
'.$user_vip_points.' vip puntos
</b>.
<br>
<a href="index.php?subtopic=shopsystem">
IR A LA PAGINA PRINCIPAL DE COMPRAS
</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();
if($dataget['online'] == '0') {
$buybuy = 'buy_from';
$SQL->query('UPDATE `players` SET `name` = '. $SQL->quote($buy_from) .' WHERE `id` = '. $my_acc_id.' ;');
$account_logged->setCustomField('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_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_vip_points.' vip puntos left
</b>.
<br>
<a href="index.php?subtopic=shopsystem">
IR A LA PAGINA PRINCIPAL DE COMPRAS
</a>';
} 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['skull'] >= '1' AND $dataget['online'] >= '0' AND $dataget['skulltime'] > '0') {
$SQL->query('UPDATE players SET skull=0, skulltime=0 WHERE id='. $my_acc_id .';');
$account_logged->setCustomField('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
$main_content .= '
<h2>
Skull Removed!
</h2>
<b>
Your skull has been removed to the player '.$buy_player->getName().',
<br>
Now you have
<b>
'.$user_vip_points.' vip points
</b>.
<br>
<a href="index.php?subtopic=shopsystem">
IR A LA PAGINA PRINCIPAL DE COMPRAS
</a>';
} else
{
$main_content .= '
<b>
'.$buy_player->getName().' has to be offline or have skull 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('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
$main_content .= '<h2>Item AGREGADO!</h2><b>'.$buy_offer['name'].'</b> agregado a el jugador <b>'.$buy_player->getName().'</b>.<br />El item '.$buy_offer['name'].' (el item sera agregado despues de conectarse) por <b>'.$buy_offer['points'].' vip puntos</b> desde tu cuenta.<br />Ahora tienes <b>'.$user_vip_points.' vip puntos</b>.<br /><a href="index.php?subtopic=shopsystem">IR A LA PAGINA PRINCIPAL DE COMPRAS</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('vip_points', $user_vip_points-$buy_offer['points']);
$user_vip_points = $user_vip_points - $buy_offer['points'];
$main_content .= '<h2>Backpack con objetos AGREGADA!</h2><b>'.$buy_offer['name'].'</b> agregado a el jugador <b>'.$buy_player->getName().'</b>.<br />El item '.$buy_offer['name'].' (el item sera agregado despues de conectarse) por <b>'.$buy_offer['points'].' vip puntos</b> desde tu cuenta.<br />Ahora tienes <b>'.$user_vip_points.' vip puntos</b>.<br /><a href="index.php?subtopic=shopsystem">IR A LA PAGINA PRINCIPAL DE COMPRAS</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="500">
<tr bgcolor='.$config['site']['lightborder'].'><td colspan="3"><font color="white" size="4"><b>Confirm transaction</b></font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><b>Nombre:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><b>Descripcion:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><b>Costo:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' vip puntos</b> de tu cuenta</td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><b>Para:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td width="100"><b>De:</b></td><td width="550" colspan="2"><font color="red">'.$buy_from.'</font></td></tr>
<tr bgcolor="'.$config['site']['lightborder'].'"><td width="100"><b>Transaccion?</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="Aceptar"></form></td>
<td align="right"><form action="index.php?subtopic=shopsystem" method="POST"><input type="submit" value="Cancelar"></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="550">
<tr bgcolor="black"><td colspan="3"><font color="gold" size="4"><b>Confirm transaction</b></font></td></tr>
<tr bgcolor="gold"><td width="100"><b>Name:</b></td><td width="550" colspan="2">'.$buy_offer['name'].'</td></tr>
<tr bgcolor="gold"><td width="100"><b>Description:</b></td><td width="550" colspan="2">'.$buy_offer['description'].'</td></tr>
<tr bgcolor="gold"><td width="100"><b>Cost:</b></td><td width="550" colspan="2"><b>'.$buy_offer['points'].' vip points</b> from your account</td></tr>
<tr bgcolor="gold"><td width="100"><b>Current Name:</b></td><td width="550" colspan="2"><font color="red">'.$buy_player->getName().'</font></td></tr>
<tr bgcolor="gold"><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 .= 'por this item you need <b>'.$buy_offer['points'].'</b> puntos. You have only <b>'.$user_vip_points.'</b> vip puntos. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy vip puntos.';
}
}
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 .= 'Por favor, conectarse.';
}
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="gold"><td><font color="'.$char_color.'"><a href="?subtopic=characters&name='.$item_received['to_name'].'">'.$item_received['to_name'].'</font></td><td>';
if($account_logged->getId() == $item_received['from_account'])
$items_received_text .= '<i>Tu cuenta</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="gold"><td><font color="'.$char_color.'"><a href="?subtopic=characters&name='.$pacc_received['to_name'].'">'.$pacc_received['to_name'].'</font></td><td>';
if($account_logged->getId() == $pacc_received['from_account'])
$paccs_received_text .= '<i>Tu cuenta</i>';
else
$paccs_received_text .= $pacc_received['from_nick'];
$paccs_received_text .= '</td><td>'.$pacc_received['pacc_days'].' dias</td><td>'.$pacc_received['price'].' puntos</td><td>'.date("j F Y, H:i:s", $pacc_received['trans_real']).'</td></tr>';
}
}
$vip_history_received = $SQL->query('SELECT * FROM '.$SQL->tableName('z_shop_history_vip').' WHERE '.$SQL->fieldName('to_account').' = '.$SQL->quote($account_logged->getId()).' OR '.$SQL->fieldName('from_account').' = '.$SQL->quote($account_logged->getId()).';');
if(is_object($vip_history_received)) {
foreach($vip_history_received as $vip_received)
{
if($account_logged->getId() == $vip_received['to_account'])
$char_color = 'green';
else
$char_color = 'red';
$vip_received_text .= '<tr bgcolor="gold"><td><font color="'.$char_color.'"><a href="?subtopic=characters&name='.$vip_received['to_name'].'">'.$vip_received['to_name'].'</font></td><td>';
if($account_logged->getId() == $vip_received['from_account'])
$vip_received_text .= '<i>Tu cuenta</i>';
else
$vip_received_text .= $vip_received['from_nick'];
$vip_received_text .= '</td><td>'.$vip_received['vip_days'].' dias</td><td>'.$vip_received['price'].' puntos</td><td>'.date("j F Y, H:i:s", $vip_received['trans_real']).'</td></tr>';
}
}
$main_content .= '<center><h1>Historial de Transaccion</h1></center>';
if(!empty($items_received_text))
{
$main_content .= '<h2><center>Transaccion de Objetos</center></h2><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><tr bgcolor="gold"><td><b>Para:</b></td><td><b>Desde:</b></td><td><b>Nombre de Oferta</b></td><td><b>Comprado el Dia</b></td><td><b>Recibido en el Server</b></td></tr>'.$items_received_text.'</table><br />';
}
if(!empty($paccs_received_text))
{
$main_content .= '<h2><center>Transaccion PACC</center></h2><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><tr bgcolor="gold"><td><b>Para:</b></td><td><b>Desde:</b></td><td><b>Duracion</b></td><td><b>Costo</b></td><td><b>Agregado:</b></td></tr>'.$paccs_received_text.'</table><br />';
}
if(!empty($vip_received_text))
{
$main_content .= '<h2><center>Transaccion VIP</center></h2><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=100%><tr bgcolor="gold"><td><b>Para:</b></td><td><b>Desde:</b></td><td><b>Duracion</b></td><td><b>Costo</b></td><td><b>Agregado:</b></td></tr>'.$vip_received_text.'</table><br />';
}
if(empty($paccs_received_text) && empty($items_received_text) && empty($vip_received_text))
$main_content .= 'No has recibido o comprado nada aun en la tienda.';
}
}
if($logged)
{
$main_content .= '<br><br><b><center><font color="green">TIENES </font>'.$user_vip_points.' <font color="green">PUNTOS VIP</font></b</center>';
}
else
$main_content .= '<br><br><center><b>'.$user_vip_points.'</b></center>';
}
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';
?>
Rep
