• TibiaFace

    Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...

    .
    demo menumenu

    Afiliados



    Votar:

    Show Item y Guild

    Ver el tema anterior Ver el tema siguiente Ir abajo  Mensaje (Página 1 de 1.)

    1default Show Item y Guild el Mar Nov 28, 2017 4:14 pm

    Buenas
    Tengo estos Dos errores en mi web site
    como podre arreglarlo
    Este es el Error que cargo en Shop los item no sale la imagen


    Este es el error que cargo en el Guild logo

    Les agradecería la ayuda por favor

    Ver perfil de usuario

    2default Re: Show Item y Guild el Mar Nov 28, 2017 8:40 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    lamentablemnte esto no se arregla offline hay que mirar la linea online viendo que direccion tienes la imagenes



    Ver perfil de usuario http://www.tibiaface.com

    3default Re: Show Item y Guild el Mar Nov 28, 2017 8:46 pm

    Este es el Shopsystem.php
    Código:
    <?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'];
          }
          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;
          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;
          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;
          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'] == '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;
      }     
          if($action == "category=3")
              {
              unset($_SESSION['viewed_confirmation_page']);
              $main_content .= '<h2><center>Welcome to the Seinox Online Shop!<br /> Here you can buy some items.</center></h2>';
              $offer_list = getOfferArray_cat3();
              //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;">Mage Set</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;">Rp, ek Set</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: #CD3539;">Others</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="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#676362"><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="item_images/'.$item['id'].'.jpg"></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 />';
              }
              //show list of containers offers
              if(count($offer_list['container']) > 0)
              {
                  $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#676362"><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['container'] as $container)
                  {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$container['id'].'.jpg"></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 />';
              }
              //show list of pacc offers
              if(count($offer_list['pacc']) > 0)
              {
                  $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> PACC</b></font></td></tr><tr bgcolor="#676362"><td width="50" align="center"><font color=#FFFFFF><b>Days</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">'.$pacc['days'].'</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 the Seinox Online Shop!<br /> Here you can buy some items.</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: #000000;">Mage Set</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: #CD3539;;">Rp, Ek set</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;">Others</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="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#676362"><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="item_images/'.$item['id'].'.jpg"></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 the Seinox Online Shop!<br /> Here you can buy some items.</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: #CD3539;">Mage Set</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;">Rp, ek Set</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;">Others</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="#676362"><td colspan="3"><font color="#FFFFFF" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#676362"><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="item_images/'.$item['id'].'.jpg"></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($user_premium_points >= $buy_offer['points'])
                          {
                              $main_content .= '<h2>Select player</h2>
                              <table border="0" cellpadding="1" cellspacing="1" width="650">
                              <tr bgcolor="#676362"><td colspan="2"><font color="#F1E0C6" 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="?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="#676362"><td colspan="2"><font color="#F1E0C6" size="4"><b>Give item/pacc* 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="?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="#676362"><td colspan="2"><font color="#F1E0C6" size="4"><b>Give item/pacc* 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</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 .= '*PACC 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="?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="?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_from))
                  {
                      $buy_from = 'Anonymous';
                  }
                  if(empty($buy_id))
                  {
                      $main_content .= 'Please <a href="?subtopic=shopsystem">select item</a> first.';
                  }
                  else
                  {
                      if(!check_name($buy_from))
                      {
                          $main_content .= 'Invalid nick ("from player") format. Please <a href="?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a> or contact with administrator.';
                      }
                      else
                      {
                          $buy_offer = getItemByID($buy_id);
                          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_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'];
                                                  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> 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="?subtopic=shopsystem">GO TO MAIN SHOP SITE</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="?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="?subtopic=shopsystem">GO TO MAIN SHOP SITE</a>';
                                              }
                                          }
                                          else
                                          {
                                              $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="#676362"><td colspan="3"><font color="#F1E0C6" 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="#FFFFFF">'.$buy_player->getName().'</font></td></tr>
                                              <tr bgcolor="#F1E0C6"><td width="100"><b>From:</b></td><td width="550" colspan="2"><font color="#FFFFFF">'.$buy_from.'</font></td></tr>
                                              <tr bgcolor="#FFFFFF"><td width="100"><b>Transaction?</b></td><td width="275" align="left">
                                              <form action="?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="?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="?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a>.';
                                      }
                                  }
                                  else
                                  {
                                      $main_content .= 'Invalid name format. Please <a href="?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="?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="?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 = '#FFFFFF';
                          $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="#FFFFFF">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 = '#FFFFFF';
                          $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>PACC 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 PACC.';
              }
          }
          $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';
      ?>

    Ver perfil de usuario

    4default Re: Show Item y Guild el Mar Nov 28, 2017 8:48 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    publica la shop normal como otro comentario



    Ver perfil de usuario http://www.tibiaface.com

    5default Re: Show Item y Guild el Mar Nov 28, 2017 9:01 pm

    Esta es la shop normal la que tenia el gessior
    Código:
    <?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'] == '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()
    {
      $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').';');
      $i_pacc = 0;
      $i_item = 0;
      $i_container = 0;
      $i_unban = 0;
      $i_redskull = 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'] == 'container')
        {
          $offer_array['container'][$i_container]['id'] = $data['id'];
          $offer_array['container'][$i_container]['container_id'] = $data['itemid2'];
          $offer_array['container'][$i_container]['container_count'] = $data['count2'];
          $offer_array['container'][$i_container]['item_id'] = $data['itemid1'];
          $offer_array['container'][$i_container]['item_count'] = $data['count1'];
          $offer_array['container'][$i_container]['points'] = $data['points'];
          $offer_array['container'][$i_container]['description'] = $data['offer_description'];
          $offer_array['container'][$i_container]['name'] = $data['offer_name'];
          $i_container++;
        }
        elseif ($data['offer_type'] == 'unban')
        {
          $offer_array['unban'][$i_unban]['id'] = $data['id'];
          $offer_array['unban'][$i_unban]['points'] = $data['points'];
          $offer_array['unban'][$i_unban]['description'] = $data['offer_description'];
          $offer_array['unban'][$i_unban]['name'] = $data['offer_name'];
          $i_unban++;
        }
        elseif ($data['offer_type'] == 'redskull')
        {
          $offer_array['redskull'][$i_redskull]['id'] = $data['id'];
          $offer_array['redskull'][$i_redskull]['points'] = $data['points'];
          $offer_array['redskull'][$i_redskull]['description'] = $data['offer_description'];
          $offer_array['redskull'][$i_redskull]['name'] = $data['offer_name'];
          $i_redskull++;
        }
        elseif ($data['offer_type'] == 'itemlogout')
        {
          $offer_array['itemlogout'][$i_itemlogout]['id'] = $data['id'];
          $offer_array['itemlogout'][$i_itemlogout]['points'] = $data['points'];
          $offer_array['itemlogout'][$i_itemlogout]['description'] = $data['offer_description'];
          $offer_array['itemlogout'][$i_itemlogout]['name'] = $data['offer_name'];
          $offer_array['itemlogout'][$i_itemlogout]['count1'] = $data['count1'];
          $offer_array['itemlogout'][$i_itemlogout]['pid'] = $data['pid'];
          $offer_array['itemlogout'][$i_itemlogout]['item_id'] = $data['itemid1'];
          $offer_array['itemlogout'][$i_itemlogout]['free_cap'] = $data['free_cap'];
          $i_itemlogout++;
        }
        elseif ($data['offer_type'] == '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>';
          $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="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
                if(count($offer_list['item']) > 0) {
                   foreach($offer_list['item'] as $item) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$item['id'].'.jpg"></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 />';
                }
                //show list of containers offers
                if(count($offer_list['container']) > 0) {
                   $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
                   foreach($offer_list['container'] as $container) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$container['id'].'.jpg"></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 />';
                }
                if(count($offer_list['itemlogout']) > 0) {
                   $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Receive Item on Logout</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></font></td><td width="350" align="left"><b>Description</b></font></td><td width="250" align="center"><b>Select product</b></font></td></tr>';
                   foreach($offer_list['itemlogout'] as $itemlogout) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$itemlogout['id'].'.jpg"></td><td><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' points)<br />'.$itemlogout['description'].'</td><td align="center">';
                      if(!$logged) $main_content .= '<b>Login to buy</b>'; else
                      $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemlogout['id'].'"><input type="submit" value="Buy '.$itemlogout['name'].'"><br><b>for '.$itemlogout['points'].' points</b></form>';
                      $main_content .= '</td></tr>';
                   }
                   $main_content .= '</table><br />';
                }
             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="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Others</b></font></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">'.$pacc['days'].'</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>';
                   }
                //Change Name
                if(count($offer_list['changename']) > 0)
                   foreach($offer_list['changename'] as $changename) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Change Name</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>';
                   }
                //Remove Red Skull
                if(count($offer_list['redskull']) > 0)
                   foreach($offer_list['redskull'] as $redskull) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$redskull['id'].'.jpg"></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>';
                   }
                //Unban
                if(count($offer_list['unban']) > 0)
                   foreach($offer_list['unban'] as $unban){
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Unban</td><td><b>'.$unban['name'].'</b> ('.$unban['points'].' 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>';
       }
       elseif($action == 'select_player') {
          unset($_SESSION['viewed_confirmation_page']);
          if(!$logged) {
             $main_content .= 'Please login first.';
          } else {
             $buy_id = (int) $_REQUEST['buy_id'];
             if(empty($buy_id)) {
                $main_content .= 'Please <a href="index.php?subtopic=shopsystem">select item</a> first.';
             } else {
                $buy_offer = getItemByID($buy_id);
                if(isset($buy_offer['id'])) {  //item exist in database
                   if($buy_offer['type'] != 'changename') {
                      if($user_premium_points >= $buy_offer['points']) {
                         $main_content .= '<center><h2>Select player</h2><table border="0" cellpadding="1" cellspacing="1" width="650">
                            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Selected offer</b></font></td></tr>
                            <tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550">'.$buy_offer['name'].'</td></tr>
                            <tr bgcolor="#D4C0A1"><td width="100"><b>Description:</b></td><td width="550">'.$buy_offer['description'].'</td></tr>
                            </table><br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                            <table border="0" cellpadding="1" cellspacing="1" width="650">
                            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Give item to a player from your account</b></font></td></tr>
                            <tr bgcolor="#F1E0C6"><td width="110"><b>Name:</b></td><td width="550"><select name="buy_name">';
                            $players_from_logged_acc = $account_logged->getPlayersList();
                         if(count($players_from_logged_acc) > 0) {
                            $players_from_logged_acc->orderBy('name');
                            foreach($players_from_logged_acc as $player)
                               $main_content .= '<option>'.$player->getName().'</option>';
                         } else {
                            $main_content .= 'You don\'t have any character on your account.';
                         }
                         $main_content .= '</select>&nbsp;<input type="submit" value="Give"></td></tr></table>
                            </form><br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                            <table border="0" cellpadding="1" cellspacing="1" width="650">
                            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Give item to other player</b></font></td></tr>
                            <tr bgcolor="#D4C0A1"><td width="110"><b>To player:</b></td><td width="550"><input type="text" name="buy_name"> - name of the player who should get item</td></tr>
                            <tr bgcolor="#F1E0C6"><td width="110"><b>From:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Give"> - your nick, \'empty\' = Anonymous</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> premium points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy premium points.';
                      }
                   } else {
                   $main_content .= '<center><h2>Change Name</h2><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                      <table border="0" cellpadding="1" cellspacing="1" width="650"><tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Change Name:</b></font></td></tr>
                      <tr bgcolor="#D4C0A1"><td width="110"><b>Name:</b></td><td width="550"><select name="buy_name">';
                   $players_from_logged_acc = $account_logged->getPlayersList();
                      if(count($players_from_logged_acc) > 0) {
                         $players_from_logged_acc->orderBy('name');
                         foreach($players_from_logged_acc as $player) {
                            $main_content .= '<option>'.$player->getName().'</option>';
                         }
                      } else {
                         $main_content .= 'You don\'t have any character on your account.';
                      }
                      $main_content .= '</select></td></tr><tr bgcolor="#F1E0C6"><td width="110"><b>New name:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Change Name"></td></tr></table><br /></form>';
                   }
                } else {
                          $main_content .= 'Offer with ID <b>'.$buy_id.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem">select item</a> again.';
                }
             }
          }
       }
       elseif($action == 'confirm_transaction') {
          if(!$logged) {
             $main_content .= 'Please login first.';
          } else {
             $buy_id = (int) $_POST['buy_id'];
             $buy_name = stripslashes(urldecode($_POST['buy_name']));
             $buy_from = stripslashes(urldecode($_POST['buy_from']));
             if(empty($buy_id)) {
                $main_content .= 'Please <a href="index.php?subtopic=shopsystem">select item</a> first.';
             } else {
                if($buy_offer['type'] == 'changename'){
                   if(!check_name_new_char($buy_from)) {
                      $main_content .= 'Invalid name format of new name.';
                   }
                } else {
                   $buy_offer = getItemByID($buy_id);
                   $check_name_in_database = $ots->createObject('Player');
                   $check_name_in_database->find($buy_from);
                   if($buy_offer['type'] == 'changename'){
                      if(!$check_name_in_database->isLoaded()) {
                      }
                   }
                   if(isset($buy_offer['id'])) {  //item exist in database
                      if($user_premium_points >= $buy_offer['points']) {
                         if(check_name($buy_name)) {
                            $buy_player = new OTS_Player();
                            $buy_player->find($buy_name);
                            if($buy_player->isLoaded()) {
                               $buy_player_account = $buy_player->getAccount();
                               if($_SESSION['viewed_confirmation_page'] == 'yes' && $_POST['buy_confirmed'] == 'yes') {
                                  if($buy_offer['type'] == 'pacc') {
                                     $player_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'];
                                     if($player_premdays == 0) {
                                        $buy_player_account->setCustomField('lastday', time());
                                     }
                                     $main_content .= '<center><h2>Premium ACcount added!</h2><b>'.$buy_offer['days'].' days</b> of Premium Account 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 .= '<center><h2>Ban Deleted!</h2><b>Your account has been unbanned for '.$buy_offer['points'].' premium points</b> from your account.
                                              <br>Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                        } else {
                                           $main_content .= '<center><b>You don\'t have any bans in your account!</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
                                        }
                                     }
                                  ////////////////////////////////
                                  elseif($buy_offer['type'] == 'itemlogout') {
                                     $my_acc_id = $buy_player->getCustomField('id');
                                     $playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE id = '.$my_acc_id.';')->fetch();
                                     $playerslot = $SQL->query('SELECT * FROM '.$SQL->tableName('player_items').' WHERE player_id = '.$my_acc_id.';')->fetch();
                                     if($playerinfo['online'] == '0') {
                                        if ($playerslot['pid'] != '10') {
                                           if ($datadata['cap'] >= $SQL->quote($buy_offer['free_cap'])) {
                                              $SQL->query('INSERT INTO player_items (player_id, pid, itemtype, count) VALUES ('.$my_acc_id.', '.$SQL->quote($buy_offer['pid']).', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['count1']).');');
                                              $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                              $user_premium_points = $user_premium_points - $buy_offer['points'];
                                              $main_content .= '<h2>Item received to player: '.$buy_player->getName().'!</h2><br>Now you have <b>'.$user_premium_points.' premium points</b>.
                                                 <br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a>';
                                           } else {
                                              $main_content .= '<b>You need '.$SQL->quote($buy_offer['free_cap']).' or more of cap!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                                           }
                                        } else {
                                           $main_content .= '<b>Please leave the arrow slot in blank to receive item!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                                        }
                                     } else {
                                        $main_content .= '<b>You need to be offline!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                                     }
                                  }
                                  ////////////////////////////////
                                  elseif($buy_offer['type'] == 'changename') {
                                     $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.' premium 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'] == '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.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                     } else {
                                        $main_content .= '<center><b>'.$buy_player->getName().' has to be offline or have redskull to complete transaction!.</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
                                     }
                                  }
                                  //////////////////////////
                                  elseif($buy_offer['type'] == 'item') {
                                     $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'item\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                                     $SQL->query($sql);
                                     $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, 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'].' premium points</b> from your account.<br>Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                                  }
                                  elseif($buy_offer['type'] == 'container') {
                                     $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', '.$SQL->quote($buy_offer['container_id']).', '.$SQL->quote($buy_offer['container_count']).', \'container\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                                     $SQL->query($sql);
                                     $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                                     $SQL->query($save_transaction);
                                     $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                     $user_premium_points = $user_premium_points - $buy_offer['points'];
                                     $main_content .= '<center><h2>Container of items added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                                  }
                               } else {
                                  if($buy_offer['type'] != 'changename') {
                                     $set_session = TRUE;
                                     $_SESSION['viewed_confirmation_page'] = 'yes';
                                     $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'].' 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="#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'].' premium 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> 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 .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;Item Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Offer name</b></td><td><b>Bought on page</b></td><td><b>Received on '.$config['server']['serverName'].'</b></td></tr>'.$items_received_text.'</table><br />';
             if(!empty($paccs_received_text))
                $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;Pacc Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Duration</b></td><td><b>Cost</b></td><td><b>Added:</b></td></tr>'.$paccs_received_text.'</table><br />';
             if(empty($paccs_received_text) && empty($items_received_text))
                $main_content .= 'You did not buy/receive any items or PACC.';
          }
       }
       if(!$logged)
          $main_content .= 'Please login to see how much points you have.';
       else
          $main_content .= '<br><b><font color="green">You have premium 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>';
    ?>

    Ver perfil de usuario

    6default Re: Show Item y Guild el Mar Nov 28, 2017 9:18 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    aqui tienes

    Código:
    <?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'];
          }
          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;
          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;
          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;
          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'] == '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;
      }      
           if($action == "category=3")
              {
              unset($_SESSION['viewed_confirmation_page']);
              $main_content .= '<h2><center>Welcome to the Seinox Online Shop!<br /> Here you can buy some items.</center></h2>';
              $offer_list = getOfferArray_cat3();
              //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;">Mage Set</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;">Rp, ek Set</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: #CD3539;">Others</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="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#676362"><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['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 />';
              }
              //show list of containers offers
              if(count($offer_list['container']) > 0)
              {
                  $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#676362"><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['container'] as $container)
                  {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$container['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 />';
              }
              //show list of pacc offers
              if(count($offer_list['pacc']) > 0)
              {
                  $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> PACC</b></font></td></tr><tr bgcolor="#676362"><td width="50" align="center"><font color=#FFFFFF><b>Days</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">'.$pacc['days'].'</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 the Seinox Online Shop!<br /> Here you can buy some items.</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: #000000;">Mage Set</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: #CD3539;;">Rp, Ek set</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;">Others</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="#676362"><td colspan="3"><font color="#F1E0C6" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#676362"><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['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 the Seinox Online Shop!<br /> Here you can buy some items.</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: #CD3539;">Mage Set</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;">Rp, ek Set</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;">Others</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="#676362"><td colspan="3"><font color="#FFFFFF" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#676362"><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['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($user_premium_points >= $buy_offer['points'])
                          {
                              $main_content .= '<h2>Select player</h2>
                              <table border="0" cellpadding="1" cellspacing="1" width="650">
                              <tr bgcolor="#676362"><td colspan="2"><font color="#F1E0C6" 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="?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="#676362"><td colspan="2"><font color="#F1E0C6" size="4"><b>Give item/pacc* 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="?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="#676362"><td colspan="2"><font color="#F1E0C6" size="4"><b>Give item/pacc* 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</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 .= '*PACC 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="?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="?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_from))
                  {
                      $buy_from = 'Anonymous';
                  }
                  if(empty($buy_id))
                  {
                      $main_content .= 'Please <a href="?subtopic=shopsystem">select item</a> first.';
                  }
                  else
                  {
                      if(!check_name($buy_from))
                      {
                          $main_content .= 'Invalid nick ("from player") format. Please <a href="?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a> or contact with administrator.';
                      }
                      else
                      {
                          $buy_offer = getItemByID($buy_id);
                          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_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'];
                                                  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> 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="?subtopic=shopsystem">GO TO MAIN SHOP SITE</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="?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="?subtopic=shopsystem">GO TO MAIN SHOP SITE</a>';
                                              }
                                          }
                                          else
                                          {
                                              $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="#676362"><td colspan="3"><font color="#F1E0C6" 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="#FFFFFF">'.$buy_player->getName().'</font></td></tr>
                                              <tr bgcolor="#F1E0C6"><td width="100"><b>From:</b></td><td width="550" colspan="2"><font color="#FFFFFF">'.$buy_from.'</font></td></tr>
                                              <tr bgcolor="#FFFFFF"><td width="100"><b>Transaction?</b></td><td width="275" align="left">
                                              <form action="?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="?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="?subtopic=shopsystem&action=select_player&buy_id='.$buy_id.'">select other name</a>.';
                                      }
                                  }
                                  else
                                  {
                                      $main_content .= 'Invalid name format. Please <a href="?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="?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="?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 = '#FFFFFF';
                          $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="#FFFFFF">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 = '#FFFFFF';
                          $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>PACC 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 PACC.';
              }
          }
          $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';
      ?>



    Ver perfil de usuario http://www.tibiaface.com

    7default Re: Show Item y Guild el Mar Nov 28, 2017 9:19 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    shop

    Código:


    [code]<?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'] == '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()
    {
      $offer_list = $GLOBALS['SQL']->query('SELECT * FROM '.$GLOBALS['SQL']->tableName('z_shop_offer').';');
      $i_pacc = 0;
      $i_item = 0;
      $i_container = 0;
      $i_unban = 0;
      $i_redskull = 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'] == 'container')
        {
          $offer_array['container'][$i_container]['id'] = $data['id'];
          $offer_array['container'][$i_container]['container_id'] = $data['itemid2'];
          $offer_array['container'][$i_container]['container_count'] = $data['count2'];
          $offer_array['container'][$i_container]['item_id'] = $data['itemid1'];
          $offer_array['container'][$i_container]['item_count'] = $data['count1'];
          $offer_array['container'][$i_container]['points'] = $data['points'];
          $offer_array['container'][$i_container]['description'] = $data['offer_description'];
          $offer_array['container'][$i_container]['name'] = $data['offer_name'];
          $i_container++;
        }
        elseif ($data['offer_type'] == 'unban')
        {
          $offer_array['unban'][$i_unban]['id'] = $data['id'];
          $offer_array['unban'][$i_unban]['points'] = $data['points'];
          $offer_array['unban'][$i_unban]['description'] = $data['offer_description'];
          $offer_array['unban'][$i_unban]['name'] = $data['offer_name'];
          $i_unban++;
        }
        elseif ($data['offer_type'] == 'redskull')
        {
          $offer_array['redskull'][$i_redskull]['id'] = $data['id'];
          $offer_array['redskull'][$i_redskull]['points'] = $data['points'];
          $offer_array['redskull'][$i_redskull]['description'] = $data['offer_description'];
          $offer_array['redskull'][$i_redskull]['name'] = $data['offer_name'];
          $i_redskull++;
        }
        elseif ($data['offer_type'] == 'itemlogout')
        {
          $offer_array['itemlogout'][$i_itemlogout]['id'] = $data['id'];
          $offer_array['itemlogout'][$i_itemlogout]['points'] = $data['points'];
          $offer_array['itemlogout'][$i_itemlogout]['description'] = $data['offer_description'];
          $offer_array['itemlogout'][$i_itemlogout]['name'] = $data['offer_name'];
          $offer_array['itemlogout'][$i_itemlogout]['count1'] = $data['count1'];
          $offer_array['itemlogout'][$i_itemlogout]['pid'] = $data['pid'];
          $offer_array['itemlogout'][$i_itemlogout]['item_id'] = $data['itemid1'];
          $offer_array['itemlogout'][$i_itemlogout]['free_cap'] = $data['free_cap'];
          $i_itemlogout++;
        }
        elseif ($data['offer_type'] == '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>';
          $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="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
                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['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 />';
                }
                //show list of containers offers
                if(count($offer_list['container']) > 0) {
                  $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></td><td width="350" align="left"><b>Description</b></td><td width="250" align="center"><b>Select product</b></td></tr>';
                  foreach($offer_list['container'] as $container) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$container['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 />';
                }
                if(count($offer_list['itemlogout']) > 0) {
                  $main_content .= '<table border="0" cellpadding="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Receive Item on Logout</b></font></td></tr><tr bgcolor="#D4C0A1"><td width="50" align="center"><b>Picture</b></font></td><td width="350" align="left"><b>Description</b></font></td><td width="250" align="center"><b>Select product</b></font></td></tr>';
                  foreach($offer_list['itemlogout'] as $itemlogout) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$itemlogout['id'].'.gif"></td><td><b>'.$itemlogout['name'].'</b> ('.$itemlogout['points'].' points)<br />'.$itemlogout['description'].'</td><td align="center">';
                      if(!$logged) $main_content .= '<b>Login to buy</b>'; else
                      $main_content .= '<form action="index.php?subtopic=shopsystem&action=select_player" method=POST><input type="hidden" name="buy_id" value="'.$itemlogout['id'].'"><input type="submit" value="Buy '.$itemlogout['name'].'"><br><b>for '.$itemlogout['points'].' points</b></form>';
                      $main_content .= '</td></tr>';
                  }
                  $main_content .= '</table><br />';
                }
            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="1" cellspacing="1" width="650"><tr width="650" bgcolor="#505050"><td colspan="3"><font color="white" size="4"><b>&nbsp;Others</b></font></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">'.$pacc['days'].'</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>';
                  }
                //Change Name
                if(count($offer_list['changename']) > 0)
                  foreach($offer_list['changename'] as $changename) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Change Name</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>';
                  }
                //Remove Red Skull
                if(count($offer_list['redskull']) > 0)
                  foreach($offer_list['redskull'] as $redskull) {
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="images/items/'.$redskull['id'].'.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>';
                  }
                //Unban
                if(count($offer_list['unban']) > 0)
                  foreach($offer_list['unban'] as $unban){
                      $main_content .= '<tr bgcolor="#F1E0C6"><td align="center">Unban</td><td><b>'.$unban['name'].'</b> ('.$unban['points'].' 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>';
      }
      elseif($action == 'select_player') {
          unset($_SESSION['viewed_confirmation_page']);
          if(!$logged) {
            $main_content .= 'Please login first.';
          } else {
            $buy_id = (int) $_REQUEST['buy_id'];
            if(empty($buy_id)) {
                $main_content .= 'Please <a href="index.php?subtopic=shopsystem">select item</a> first.';
            } else {
                $buy_offer = getItemByID($buy_id);
                if(isset($buy_offer['id'])) {  //item exist in database
                  if($buy_offer['type'] != 'changename') {
                      if($user_premium_points >= $buy_offer['points']) {
                        $main_content .= '<center><h2>Select player</h2><table border="0" cellpadding="1" cellspacing="1" width="650">
                            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Selected offer</b></font></td></tr>
                            <tr bgcolor="#F1E0C6"><td width="100"><b>Name:</b></td><td width="550">'.$buy_offer['name'].'</td></tr>
                            <tr bgcolor="#D4C0A1"><td width="100"><b>Description:</b></td><td width="550">'.$buy_offer['description'].'</td></tr>
                            </table><br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                            <table border="0" cellpadding="1" cellspacing="1" width="650">
                            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Give item to a player from your account</b></font></td></tr>
                            <tr bgcolor="#F1E0C6"><td width="110"><b>Name:</b></td><td width="550"><select name="buy_name">';
                            $players_from_logged_acc = $account_logged->getPlayersList();
                        if(count($players_from_logged_acc) > 0) {
                            $players_from_logged_acc->orderBy('name');
                            foreach($players_from_logged_acc as $player)
                              $main_content .= '<option>'.$player->getName().'</option>';
                        } else {
                            $main_content .= 'You don\'t have any character on your account.';
                        }
                        $main_content .= '</select>&nbsp;<input type="submit" value="Give"></td></tr></table>
                            </form><br /><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                            <table border="0" cellpadding="1" cellspacing="1" width="650">
                            <tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Give item to other player</b></font></td></tr>
                            <tr bgcolor="#D4C0A1"><td width="110"><b>To player:</b></td><td width="550"><input type="text" name="buy_name"> - name of the player who should get item</td></tr>
                            <tr bgcolor="#F1E0C6"><td width="110"><b>From:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Give"> - your nick, \'empty\' = Anonymous</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> premium points. Please <a href="index.php?subtopic=shopsystem">select other item</a> or buy premium points.';
                      }
                  } else {
                  $main_content .= '<center><h2>Change Name</h2><form action="index.php?subtopic=shopsystem&action=confirm_transaction" method=POST><input type="hidden" name="buy_id" value="'.$buy_id.'">
                      <table border="0" cellpadding="1" cellspacing="1" width="650"><tr bgcolor="#505050"><td colspan="2"><font color="white" size="4"><b>Change Name:</b></font></td></tr>
                      <tr bgcolor="#D4C0A1"><td width="110"><b>Name:</b></td><td width="550"><select name="buy_name">';
                  $players_from_logged_acc = $account_logged->getPlayersList();
                      if(count($players_from_logged_acc) > 0) {
                        $players_from_logged_acc->orderBy('name');
                        foreach($players_from_logged_acc as $player) {
                            $main_content .= '<option>'.$player->getName().'</option>';
                        }
                      } else {
                        $main_content .= 'You don\'t have any character on your account.';
                      }
                      $main_content .= '</select></td></tr><tr bgcolor="#F1E0C6"><td width="110"><b>New name:</b></td><td width="550"><input type="text" name="buy_from">&nbsp;<input type="submit" value="Change Name"></td></tr></table><br /></form>';
                  }
                } else {
                          $main_content .= 'Offer with ID <b>'.$buy_id.'</b> doesn\'t exist. Please <a href="index.php?subtopic=shopsystem">select item</a> again.';
                }
            }
          }
      }
      elseif($action == 'confirm_transaction') {
          if(!$logged) {
            $main_content .= 'Please login first.';
          } else {
            $buy_id = (int) $_POST['buy_id'];
            $buy_name = stripslashes(urldecode($_POST['buy_name']));
            $buy_from = stripslashes(urldecode($_POST['buy_from']));
            if(empty($buy_id)) {
                $main_content .= 'Please <a href="index.php?subtopic=shopsystem">select item</a> first.';
            } else {
                if($buy_offer['type'] == 'changename'){
                  if(!check_name_new_char($buy_from)) {
                      $main_content .= 'Invalid name format of new name.';
                  }
                } else {
                  $buy_offer = getItemByID($buy_id);
                  $check_name_in_database = $ots->createObject('Player');
                  $check_name_in_database->find($buy_from);
                  if($buy_offer['type'] == 'changename'){
                      if(!$check_name_in_database->isLoaded()) {
                      }
                  }
                  if(isset($buy_offer['id'])) {  //item exist in database
                      if($user_premium_points >= $buy_offer['points']) {
                        if(check_name($buy_name)) {
                            $buy_player = new OTS_Player();
                            $buy_player->find($buy_name);
                            if($buy_player->isLoaded()) {
                              $buy_player_account = $buy_player->getAccount();
                              if($_SESSION['viewed_confirmation_page'] == 'yes' && $_POST['buy_confirmed'] == 'yes') {
                                  if($buy_offer['type'] == 'pacc') {
                                    $player_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'];
                                    if($player_premdays == 0) {
                                        $buy_player_account->setCustomField('lastday', time());
                                    }
                                    $main_content .= '<center><h2>Premium ACcount added!</h2><b>'.$buy_offer['days'].' days</b> of Premium Account 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 .= '<center><h2>Ban Deleted!</h2><b>Your account has been unbanned for '.$buy_offer['points'].' premium points</b> from your account.
                                              <br>Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                        } else {
                                          $main_content .= '<center><b>You don\'t have any bans in your account!</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
                                        }
                                    }
                                  ////////////////////////////////
                                  elseif($buy_offer['type'] == 'itemlogout') {
                                    $my_acc_id = $buy_player->getCustomField('id');
                                    $playerinfo = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE id = '.$my_acc_id.';')->fetch();
                                    $playerslot = $SQL->query('SELECT * FROM '.$SQL->tableName('player_items').' WHERE player_id = '.$my_acc_id.';')->fetch();
                                    if($playerinfo['online'] == '0') {
                                        if ($playerslot['pid'] != '10') {
                                          if ($datadata['cap'] >= $SQL->quote($buy_offer['free_cap'])) {
                                              $SQL->query('INSERT INTO player_items (player_id, pid, itemtype, count) VALUES ('.$my_acc_id.', '.$SQL->quote($buy_offer['pid']).', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['count1']).');');
                                              $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                              $user_premium_points = $user_premium_points - $buy_offer['points'];
                                              $main_content .= '<h2>Item received to player: '.$buy_player->getName().'!</h2><br>Now you have <b>'.$user_premium_points.' premium points</b>.
                                                <br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a>';
                                          } else {
                                              $main_content .= '<b>You need '.$SQL->quote($buy_offer['free_cap']).' or more of cap!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                                          }
                                        } else {
                                          $main_content .= '<b>Please leave the arrow slot in blank to receive item!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                                        }
                                    } else {
                                        $main_content .= '<b>You need to be offline!</b><br><a href="index.php?subtopic=shopsystem">Go back</a>';
                                    }
                                  }
                                  ////////////////////////////////
                                  elseif($buy_offer['type'] == 'changename') {
                                    $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.' premium 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'] == '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.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                    } else {
                                        $main_content .= '<center><b>'.$buy_player->getName().' has to be offline or have redskull to complete transaction!.</b><br><br><a href="index.php?subtopic=shopsystem">Go back</a><br>';
                                    }
                                  }
                                  //////////////////////////
                                  elseif($buy_offer['type'] == 'item') {
                                    $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'item\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                                    $SQL->query($sql);
                                    $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, 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'].' premium points</b> from your account.<br>Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                                  }
                                  elseif($buy_offer['type'] == 'container') {
                                    $sql = 'INSERT INTO '.$SQL->tableName('z_ots_comunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', '.$SQL->quote($buy_offer['container_id']).', '.$SQL->quote($buy_offer['container_count']).', \'container\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                                    $SQL->query($sql);
                                    $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['name']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                                    $SQL->query($save_transaction);
                                    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                    $user_premium_points = $user_premium_points - $buy_offer['points'];
                                    $main_content .= '<center><h2>Container of items added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">GO TO MAIN SHOP SITE</a><br>';
                                  }
                              } else {
                                  if($buy_offer['type'] != 'changename') {
                                    $set_session = TRUE;
                                    $_SESSION['viewed_confirmation_page'] = 'yes';
                                    $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'].' 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="#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'].' premium 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> 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 .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;Item Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Offer name</b></td><td><b>Bought on page</b></td><td><b>Received on '.$config['server']['serverName'].'</b></td></tr>'.$items_received_text.'</table><br />';
            if(!empty($paccs_received_text))
                $main_content .= '<center><table BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=95%><tr width="100%" bgcolor="#505050"><td colspan="5"><font color="white" size="4"><b>&nbsp;Pacc Transactions</b></font></td></tr><tr bgcolor="#D4C0A1"><td><b>To:</b></td><td><b>From:</b></td><td><b>Duration</b></td><td><b>Cost</b></td><td><b>Added:</b></td></tr>'.$paccs_received_text.'</table><br />';
            if(empty($paccs_received_text) && empty($items_received_text))
                $main_content .= 'You did not buy/receive any items or PACC.';
          }
      }
      if(!$logged)
          $main_content .= 'Please login to see how much points you have.';
      else
          $main_content .= '<br><b><font color="green">You have premium 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>';
    ?>[/code]



    Ver perfil de usuario http://www.tibiaface.com

    8default Re: Show Item y Guild el Mar Nov 28, 2017 9:22 pm

    Lo puse y mira como sale ahora

    Ver perfil de usuario

    9default Re: Show Item y Guild el Mar Nov 28, 2017 9:33 pm

    [Admin] God Maya

    avatar
    Administrador
    Administrador
    lo que sucede que esta web son antiguas para que se vea el objeto o laimagen de lo que agregaste tienes que hacer esto

    si el primer objeto que agregaste es 2160 los crystal coin tienes que renombrar a la imagen con nombre 1 y asi sucesivamente en el orden que vas añadiendo



    Ver perfil de usuario http://www.tibiaface.com

    10default Re: Show Item y Guild el Mar Nov 28, 2017 9:53 pm

    Ya entendí Pues para eso tendría mejor que entrar en el PhpMyadmin y le cambio los ids para la imagen que quiero Gracias por la ayuda

    Ver perfil de usuario

    Contenido patrocinado


    Ver el tema anterior Ver el tema siguiente Volver arriba  Mensaje (Página 1 de 1.)

    Permisos de este foro:
    No puedes responder a temas en este foro.

     

    BienvenidosTibiaFace es una comunidad de Open Tibia. Para participar debes estar registrado (click para Regístrate).