[Gesior Aac]Shop Itens Com Categorias.

tyuahoi · Julho 18, 2010

Olá

Vi Augumas Pessoas Presisando Desse Script Entao Descidi Postar ;D

1º Va Em: C:\xampp\htdocs

Abra o Shopsystem

Apague Tudo E Cole Isso.

   <?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 Server Name 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: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;">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="#b7a58a"><td colspan="3"><font color="#F1E0C6" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
              foreach($offer_list['item'] as $item)
              {
                  $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="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="#b7a58a"><td colspan="3"><font color="#F1E0C6" size="4"><b> CONTAINERS WITH ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
              foreach($offer_list['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="#b7a58a"><td colspan="3"><font color="#F1E0C6" size="4"><b> PACC</b></font></td></tr><tr bgcolor="#b7a58a"><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 Server Name 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: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">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="#b7a58a"><td colspan="3"><font color="#F1E0C6" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
              foreach($offer_list['item'] as $item)
              {
                  $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="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 Server Name 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: #000000;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">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="#b7a58a"><td colspan="3"><font color="#FFFFFF" size="4"><b> ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
              foreach($offer_list['item'] as $item)
              {
                  $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="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="#b7a58a"><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="#b7a58a"><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="#b7a58a"><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="#b7a58a"><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';
  ?>

Salve E feche.

Agora Va Em: Shopadmin

Apague Tudo E Cole Isso:

   <?PHP
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
$offertype = $_REQUEST['offer_type'];
if((empty($action)) AND (empty($offertype))) {
   $main_content .= '<br><h2><center><a href="?subtopic=shopadmin&offer_type=item">ADD SHOP OFFER</a><br><br>
   <a href="?subtopic=shopadmin&action=viewoffer">VIEW SHOP OFFER <i>(EDIT/DELETE)</i></a><br><br><a href="?subtopic=shopadmin&action=points">ADD POINTS</a></center>';
   }
if($_REQUEST['offer_type']){
   $shop_points = stripslashes(ucwords(strtolower(trim($_REQUEST['shop_points']))));
   $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
       if(empty($shop_points)) {
           $main_content .= '<table border="0"><tr><td  align="center"><b>Select offer type:</b></td><td><table border="0" ><tr bgcolor="#505050">
               <td><font color="white">Item</td><td><font color="white">Container</td><td><font color="white">Pacc</td><td><font color="white">Redskull</td><td><font color="white">Unban</td><td><font color="white">Changename</td></tr>
               <tr bgcolor="#D4C0A1">
               <td align="center"><a href="?subtopic=shopadmin&offer_type=item"><input type="radio" name="offer_type" value="item"></a></td>
               <td align="center"><a href="?subtopic=shopadmin&offer_type=container"><input type="radio" name="offer_type" value="container" ></a></td>
               <td align="center"><a href="?subtopic=shopadmin&offer_type=pacc"><input type="radio" name="offer_type" value="pacc" ></a></td>
               <td align="center"><a href="?subtopic=shopadmin&offer_type=redskull"><input type="radio" name="offer_type" value="redskull" ></a></td>
               <td align="center"><a href="?subtopic=shopadmin&offer_type=unban"><input type="radio" name="offer_type" value="unban" ></a></td>
               <td align="center"><a href="?subtopic=shopadmin&offer_type=changename"><input type="radio" name="offer_type" value="changename" ></a></td>
               </tr></table></td></tr>';
               $main_content .= '<form action="?subtopic=shopadmin&offer_type='.$shop_offer_type.'&check" method="post" ><table border="0"><tr><td align="center" ><b>Points:</b></td>
               <td><input type="textbox" name="shop_points" maxlenght="7" style="width: 70px"></td></tr>';
               if($_REQUEST['offer_type'] == 'container'){
                   $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                   <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                   <tr><td align="center" ><b>Count Container:</b></td>
                   <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>
                   <tr><td align="center" ><b>Item ID:</b></td>
                   <td><input type="text" name="shop_itemid2" maxlenght="7" style="width: 70px" ></td></tr>
                   <tr><td align="center" ><b>Count Item:</b></td>
                   <td><input type="text" name="shop_count2" maxlenght="7" style="width: 70px" ></td></tr>';
               }
               if($_REQUEST['offer_type'] == 'item'){
                   $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                   <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                   <tr><td align="center"><b>Item Count:</b></td>
                   <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
               }
               if($_REQUEST['offer_type'] == 'pacc'){
                   $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                   <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
               }
               $main_content .= '<tr><td align="center" ><b>Offer Description:</b></td>
               <td ><textarea name="shop_offer_description" rows="2" cols="35"></textarea></td></tr>
   	    <tr><td align="center" ><b>Category:</b></td>
	    <td><input type="text" name="shop_category" maxlenght="7" style="width: 70px" ></td></tr>
               <tr><td align="center" ><b>Offer Name:</b></td>
               <td><input type="text" name="shop_offer_name" maxlenght="40" style="width: 200px" ></td></tr>
               <tr><td><input name="submit" type="submit" value="Submit" /></form></td><td>
               <form action="?subtopic=shopadmin&offer_type=container" method="post" >
               <input name="submit" type="submit" value="Reset" /></form></td></tr></table>';
           $main_content .= '<form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
           }
           else
           {
           $shop_points = stripslashes(trim($_POST['shop_points']));
           $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
           $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
           $shop_count1 = stripslashes(trim($_POST['shop_count1']));
           $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
           $shop_count2 = stripslashes(trim($_POST['shop_count2']));
           $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
           $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
	$shop_category = stripslashes(trim($_POST['shop_category']));
               $SQL->query('INSERT INTO `z_shop_offer` (id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid, category) VALUES (NULL, '.$SQL->quote($shop_points).', '.$SQL->quote($shop_itemid1).', '.$SQL->quote($shop_count1).', '.$SQL->quote($shop_itemid2).', '.$SQL->quote($shop_count2).', '.$SQL->quote($shop_offer_type).', '.$SQL->quote($shop_offer_description).', '.$SQL->quote($shop_offer_name).', 0, '.$SQL->quote($shop_category).')');
               $main_content .= '<center><h2><font color="red">Added to Shop:</font></h2></center><hr/>
               <tr><td align="center" ><b>Points:</b></td>
               <td>'.$shop_points.'</td></tr><br>';
               if($shop_offer_type == 'container'){
                   $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                   <td>'.$shop_itemid1.'</td></tr><br>
                   <tr><td align="center" ><b>Count Container:</b></td>
                   <td>'.$shop_count1.'</td></tr><br>
                   <tr><td align="center" ><b> Item ID (in Container):</b></td>
                   <td>'.$shop_itemid2.'</td></tr><br>
                   <tr><td align="center" ><b>Count Item (in Container):</b></td>
                   <td>'.$shop_count2.'</td></tr><br>
		 <tr><td align="center" ><b>Category:</b></td>
                  <td>'.$shop_category.'</td></tr><br>'; }
               if ($shop_offer_type == 'item'){
                   $main_content .= '<tr><td align="center" ><b>Item ID:</b></td>
                   <td>'.$shop_itemid1.'</td></tr><br>
                   <tr><td align="center" ><b>Count Item:</b></td>
                   <td>'.$shop_count1.'</td></tr><br>
		 <tr><td align="center" ><b>Category:</b></td>
                  <td>'.$shop_category.'</td></tr><br>'; }
               if ($shop_offer_type == 'pacc'){
                   $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                   <td>'.$shop_count1.'</td></tr><br>
		 <tr><td align="center" ><b>Category:</b></td>
                  <td>'.$shop_category.'</td></tr><br>'; }
               $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
               <td>'.$shop_offer_type.'</td></tr><br>
               <tr><td align="center" ><b>Offer Description:</b></td>
               <td>'.$shop_offer_description.'</td></tr><br>
               <tr><td align="center" ><b>Offer Name:</b></td>
               <td>'.$shop_offer_name.'</td></tr>
               <br><form action="?subtopic=shopadmin&offer_type=item" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
               }
   }
if($action == "viewoffer") {
   $items = simplexml_load_file($config['site']['server_path'].'/data/items/items.xml') or die('<b>Could not load items!</b>');
       foreach($items->item as $v)
           $itemList[(int)$v['id']] = $v['name'];
       $order = array("id" => "id", "points" => "points", "offer_type" => "offer_type", "itemid1" => "itemid1", "itemid2" => "itemid2");
               $main_content .= '<center><table width="550"><tr BGCOLOR="#505050"><td width="5"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'id') . '" class=white>ID:</td><td width="5"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'points') . '" class=white>Points:</td><td width="7">
                   <font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'itemid1') . '" class=white>Item ID:</td><td width="5"><font color="white">Count:</td><td width="7"><center><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'itemid2') . '" class=white>Container ID:</center></td><td width="5"><font color="white">Count:</td><td width="7"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'offer_type') . '" class=white>Offer Type:</td>
                   <td width="85"><font color="white">Offer Description:</td><td width="30"><font color="white">Offer Name:</td><td width="30"></td></tr>';
       $shopoffers = $SQL->query('SELECT id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid FROM z_shop_offer ' . makeOrder($order, 'order', 'id'));
           foreach($shopoffers as $shop) {
                 $main_content .= '</B><tr BGCOLOR="#D4C0A1"><td align="center">'.$shop['id'].'<td align="center">'.$shop['points'].'</td>';
           if($shop['itemid1'] == "0") {
                 $main_content .= '<td align="center">'.$shop['itemid1'].'<br></td>';
           }
           else
           {
               $main_content .= '<td align="center">'.$shop['itemid1'].'<br>(' . $itemList[(int)$shop['itemid1']] . ')</td>';
           }
           $main_content .= '<td align="center">'.$shop['count1'].'</td>';
       if($shop['itemid2'] == "0") {
           $main_content .= '<td align="center">'.$shop['itemid2'].'</td>';
       }
       else
       {
           $main_content .= '<td align="center">'.$shop['itemid2'].'<br>(' . $itemList[(int)$shop['itemid2']] . ')</td>';
       }
       $main_content .= '<td align="center">'.$shop['count2'].'</td><td align="center">'.$shop['offer_type'].'</td><td align="left">'.$shop['offer_description'].'</td><td align="left">'.$shop['offer_name'].'</td>';
       $main_content .= '<td align="center"><a href="?subtopic=shopadmin&action=editoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/edit_news.png" border="0"></a><br><br><a href="?subtopic=shopadmin&action=deleteoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/delete_news.png" border="0"></a></td>';
   }
   $main_content .= '</td></tr></TABLE><br><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
}
if($action == "deleteoffer") {
   $id = (int) $_REQUEST['id'];
   $SQL->query('DELETE FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
   $main_content .= '<center>Shop offer has been deleted.</center><br><center><form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form></center>';
   }
if($action == "editoffer") {
   $id = (int) $_REQUEST['id'];
   $shopoffers = $SQL->query('SELECT * FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
       foreach($shopoffers as $shop) {
   $main_content .= '<form action="?subtopic=shopadmin&action=edited&id='.$id.'" method="post" ><table border="0"><tr><td align="center" ><b>Points:</b></td>
   <td><input type="textbox" name="shop_points" maxlenght="7" value="'.$shop['points'].'" style="width: 70px"></td></tr>';
   if($shop['offer_type'] == 'container'){
       $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
       <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
       <tr><td align="center" ><b>Count Container:</b></td>
       <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>
       <tr><td align="center" ><b>Item ID:</b></td>
       <td><input type="text" name="shop_itemid2" maxlenght="7" value="'.$shop['itemid2'].'" style="width: 70px" ></td></tr>
       <tr><td align="center" ><b>Count Item:</b></td>
       <td><input type="text" name="shop_count2" maxlenght="7" value="'.$shop['count2'].'" style="width: 70px" ></td></tr>';
   }
   if($shop['offer_type'] == 'item'){
       $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
       <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
       <tr><td align="center"><b>Item Count:</b></td>
       <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>';
   }
   if($shop['offer_type'] == 'pacc'){
       $main_content .= '<tr><td align="center" ><b>Days:</b></td>
       <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
   }
   $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
   <td><input type="text" name="shop_offer_type" value="'.$shop['offer_type'].'" maxlenght="40" style="width: 200px" ></td></tr>
   <tr><td align="center" ><b>Offer Description:</b></td>
   <td ><textarea name="shop_offer_description" rows="2" cols="35">'.$shop['offer_description'].'</textarea></td></tr>
   <tr><td align="center" ><b>Offer Name:</b></td>
   <td><input type="text" name="shop_offer_name" value="'.$shop['offer_name'].'" maxlenght="40" style="width: 200px" ></td></tr>
   <tr><td><input name="submit" type="submit" value="Submit" /></form></td><td></td></tr></table>';
   $main_content .= '<form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
   }
   }
if($action == "edited") {
   $id = (int) $_REQUEST['id'];
   $shop_points = stripslashes(trim($_POST['shop_points']));
   $shop_offer_type = stripslashes(trim($_POST['shop_offer_type']));
   $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
   $shop_count1 = stripslashes(trim($_POST['shop_count1']));
   $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
   $shop_count2 = stripslashes(trim($_POST['shop_count2']));
   $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
   $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
   $SQL->query('UPDATE `z_shop_offer` SET `points` = '.$shop_points.', `itemid1` = '.$SQL->quote($shop_itemid1).', `count1` = '.$SQL->quote($shop_count1).', `itemid2` = '.$SQL->quote($shop_itemid2).', `count2` = '.$SQL->quote($shop_count2).', `offer_type` = '.$SQL->quote($shop_offer_type).', `offer_description` = '.$SQL->quote($shop_offer_description).', `offer_name` = '.$SQL->quote($shop_offer_name).' WHERE `id` = '.$id.';');
   $main_content .= '<b><center>Shop offer successfully edited.</b><br><br><form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form><meta http-equiv="refresh" content="1;url=/?subtopic=shopadmin&action=viewoffer" />';
}
if($action == "points") {
   $player = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
   $points = $_POST['points'];
   if(empty($player)) {
       $main_content .= '<form action="" method="post"><B>Enter Character Name:</B><input type="textbox" name="character"><br>
       <B>Enter Points Amount:</B><input type="textbox" name="points"><br><input type="submit" value="Submit">
       </form></center><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
   }
   else
   {
       $player_data = $SQL->query("SELECT * FROM `players` WHERE `name` = '".$player."';")->fetch();
       $SQL->query("UPDATE `accounts` SET `premium_points` = `premium_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");
       $main_content .= '<b><center>'.$points.' Premium Points added to the account of <i>'.$player.'</i> !</b></center><br>
       <form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
       }
   }
}
else
{
$main_content .= 'Sorry, you have not the rights to access this page.';
}
?>

Salve E Feche.

Agora Va Em Sua Detabase E adicione Isso:

ALTER TABLE `z_shop_offer` ADD `category` INT( 11 ) NOT NULL DEFAULT '1';

Quando Voçê for adicionar um iten ira aparecer a opçao, Category Ali Voçê Coloca 1 Para Aparecer Nos Itens, 2 Para Aparecer nos Addon Items, e 3 para aparecer em Others.

Pronto.

Bom Uso.

felipedorgas · Julho 18, 2010

pow, mto bom!

ta evoluindo ein, continue assim ! :thumbsupsmiley:

rep!

Doidin · Julho 22, 2010

Muito bom para quem tem VIP System no seu server.

Este tutorial com certeza ele vai ajudar muita gente...

Obrigado por trazer o conteúdo ao XTibia.com!

Tutorial movido e aprovado, abraços...

Himmler · Julho 27, 2010

Dei uma olhadinha rapida mais nao axei.

Onde eu posso editar os nomes das categorias (itens, addon itens e tal).

E antes de me esquecer. Brigadao man, fico um pokinho melhor aki ;P vlwzao!

tyuahoi · Julho 28, 2010

to sem site aki pra t testa aki

apenas de ctrl+f e procure pelo nome das categorias que vc quer mudar é rapido e simples.

Piabeta Kun · Agosto 2, 2010

como eu add na database akela linha??

tyuahoi · Agosto 2, 2010

http://localhost:8090/phpmyadmin < se estiver mudado a porta ou

http://localhost/phpmyadmin < se nao estiver mudado a porta

clicke em sua detabase nas 'abas' em cima atara escrito assim 'SQL' clicke col a linha no quadrado que estiver em branco, após clicke em executar.

Pronto.

gutaoh · Setembro 12, 2010

To com um serio problema,

o item que eu compro no site nao esta indo para o personagem... ou nao sei pra onde o item vai

mangous · Outubro 7, 2010

Manowww Muito bom isso... MAS!

Por exemplo eu Fiz tudo que você falou, mas na hora de add o item e talz, não aparece esse negocio pra mim selecionar a categoria ai é tenso!!

Eu fiz esse negocio mas Gostaria de Reverter.... queria tirar aquele comando que adicionei na database do SQL e deixar como antigamente, como posso fazer isso ?!?!

Obrigado Desde Já!!

felipedorgas · Outubro 7, 2010

Manowww Muito bom isso... MAS!

Por exemplo eu Fiz tudo que você falou, mas na hora de add o item e talz, não aparece esse negocio pra mim selecionar a categoria ai é tenso!!

Eu fiz esse negocio mas Gostaria de Reverter.... queria tirar aquele comando que adicionei na database do SQL e deixar como antigamente, como posso fazer isso ?!?!

Obrigado Desde Já!!

não tem problema deixa aquilo lá, se vc quer o shop antigo, baixe denovo o gesior e copie o Shop admin.php e o shp system

.php e substitua lá na pasta do site

mangous · Outubro 7, 2010

Brigadão ai Dorgas!!

Eu tava com medo que isso atrapalhace em alguma coisa....

Aproveitando que já estou aqui escrevendo!

Gostaria de saber Como eu posso Fazer a parte do Buypoints = A todos os servidores grandes que tem a tabelinha e a fotinho do banco e talz..

pois eu tentei fazer e não consegui :S:S:S

Se alguem puder ajudar, ficaria muito agradecido!!

Dorgas me amor : Rep+

Editado Outubro 7, 2010 por mangous

baaNisHed · Fevereiro 16, 2011

Muito bom cara, me salvou, eu estava suando a camisa pra achar isso.

Aprovado :button_ok:

kevonus · Agosto 2, 2011

Muinta gente vai se bater, porque ai tá configurado para pegar as imagens na Pasta item_images, e geralmente a nova só vem com a pasta imagem, e mesmo você mudando o nome dela não adianta, pois a pasta precisa ser acima, no caso a pasta images tem que trocar o nome para item_images, e assim bugando todos os outros adsuasdh.

copas · Setembro 6, 2011

Quando vou coloar a linha no dataBase aparece isso:

#1060 - Duplicate column name 'category'

Alguem sabe me responder?

REP+ pra quem ajudar!

Editado Setembro 6, 2011 por copas

tyuahoi · Setembro 7, 2011

@copas

é porque na sua database já existe a coluna 'category'

Entrar

[Gesior Aac]Shop Itens Com Categorias.

Posts Recomendados

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Link para o comentário

Compartilhar em outros sites

Quem Está Navegando 0 membros estão online

Conteúdo Similar