• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

ShopSystem - Delete Skull With TFS 0.3.5+

QuaS

QuaS

Cykotitan Pwned =/
Joined
Sep 11, 2008
Messages
838
Reaction score
28
Location
Poland/ Wroclaw
hello i noticed that some things have to be changed in your shopsystem.lua:

Here we go. Open this file. Find:

PHP: 
  elseif($buy_offer['type'] == 'redskull')
  {
  //Obtener id ed la cuenta
  $my_acc_id = $buy_player->getCustomField('id');
  $dataget = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
  if($dataget['redskull'] == '1' AND $dataget['online'] >= '0' AND $dataget['redskulltime'] > '0') {

        $SQL->query('UPDATE players SET redskull=0, redskulltime=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 .= '
      <h2>
        RedSkull Removed!
      </h2>
      <b>
        Your redskull has been removed to the player '.$buy_player->getName().',
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
    '.$buy_player->getName().' has to be offline or have redskull to complete transaction!.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }


and change to
PHP: 
  elseif($buy_offer['type'] == 'redskull')
  {
  //Obtener id ed la cuenta
  $my_acc_id = $buy_player->getCustomField('id');
  $dataget = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
  if($dataget['skull'] >= '1' AND $dataget['online'] >= '0' AND $dataget['skulltime'] > '0') {

        $SQL->query('UPDATE players SET skull=0, skulltime=0 WHERE id='. $my_acc_id .';');
    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    $user_premium_points = $user_premium_points - $buy_offer['points'];
    $main_content .= '
      <h2>
        Skull Removed!
      </h2>
      <b>
        Your skull has been removed to the player '.$buy_player->getName().',
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
    '.$buy_player->getName().' has to be offline or have skull to complete transaction!.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }
  elseif($buy_offer['type'] == 'redskull')
  {
  //Obtener id ed la cuenta
  $my_acc_id = $buy_player->getCustomField('id');
  $dataget = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
  if($dataget['skull'] >= '1' AND $dataget['online'] >= '0' AND $dataget['skulltime'] > '0') {

        $SQL->query('UPDATE players SET skull=0, skulltime=0 WHERE id='. $my_acc_id .';');
    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    $user_premium_points = $user_premium_points - $buy_offer['points'];
    $main_content .= '
      <h2>
        Skull Removed!
      </h2>
      <b>
        Your skull has been removed to the player '.$buy_player->getName().',
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
    '.$buy_player->getName().' has to be offline or have skull to complete transaction!.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }

same + Frag Deleting!!

PHP: 
  elseif($buy_offer['type'] == 'redskull')
  {
  //Obtener id ed la cuenta
  $my_acc_id = $buy_player->getCustomField('id');
  $dataget = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
  if($dataget['skull'] >= '1' AND $dataget['online'] == '0' AND $dataget['skulltime'] > '0') {

        $SQL->query('UPDATE players SET skull=0, skulltime=0 WHERE id='. $my_acc_id .';');
	  $SQL->query('UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = '. $my_acc_id .');');
    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    $user_premium_points = $user_premium_points - $buy_offer['points'];
    $main_content .= '
      <h2>
        Skull Removed!
      </h2>
      <b>
        Your skull has been removed to the player '.$buy_player->getName().',
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
    '.$buy_player->getName().' has to be offline or have skull to complete transaction!.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }

This change have to me added because of new skull system in TFS 0.3.5


//QuaS~
 
Last edited:
It delete also black skull *_* that sux I think.

//If you want it to work only with red skull PM me.
 
@up. yes it delete black too. (what is meaning in adding to shopsysyem "remvoe skull" if it won't delete black too?)
 
quas said:
@up. yes it delete black too. (what is meaning in adding to shopsysyem "remvoe skull" if it won't delete black too?)
Click to expand...

I know but someone can make that offert as both (remove red skull and remove black skull). Why player could remove red skull when he can get black and then delete it by same price as red skull? ;)
 
same as 1st page + Frag Deleting!!

PHP: 
  elseif($buy_offer['type'] == 'redskull')
  {
  //Obtener id ed la cuenta
  $my_acc_id = $buy_player->getCustomField('id');
  $dataget = $SQL->query('SELECT * FROM '.$SQL->tableName('players').' WHERE '.$SQL->fieldName('id').' = '.$my_acc_id.';')->fetch();
  if($dataget['skull'] >= '1' AND $dataget['online'] == '0' AND $dataget['skulltime'] > '0') {

        $SQL->query('UPDATE players SET skull=0, skulltime=0 WHERE id='. $my_acc_id .';');
	  $SQL->query('UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = '. $my_acc_id .');');
    $account_logged->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
    $user_premium_points = $user_premium_points - $buy_offer['points'];
    $main_content .= '
      <h2>
        Skull Removed!
      </h2>
      <b>
        Your skull has been removed to the player '.$buy_player->getName().',
      <br>
      Now you have
        <b>
          '.$user_premium_points.' premium points
        </b>.
      <br>
      <a href="index.php?subtopic=shopsystem">
        GO TO MAIN SHOP SITE
      </a>';
  } else
  {
    $main_content .= '
    <b>
    '.$buy_player->getName().' has to be offline or have skull to complete transaction!.
    </b>
    <br>
    <a href="index.php?subtopic=shopsystem">
      GO BACK
    </a>';
  }
  }
 
It´s a nice script, but can you give me it for tfs 0.2 please??

Greating!
 
Wow nice!

I just have one little problem. I cant find the lines. I think I have a different shopsystem.php.

It's looks like this:

PHP: 
   <?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 Britories shop!<br </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>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['item'] as $item)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$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="#b7a58a"><td colspan="3"><font color="#F1E0C6" size="4"><b>&nbsp;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'].'.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="#b7a58a"><td colspan="3"><font color="#F1E0C6" size="4"><b>&nbsp;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 Britories shop!<br </center></h2>';
           $offer_list = getOfferArray_cat2();
           //show list of items offers
           if(count($offer_list['item']) > 0)
           {
                $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">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>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['item'] as $item)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$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 Britories shop!<br </center></h2>';
           $offer_list = getOfferArray_cat1();
           //show list of items offers
           if(count($offer_list['item']) > 0)
           { 
               $main_content .= '<a href="index.php?subtopic=shopsystem" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #000000;">Items</a><a href="index.php?subtopic=shopsystem&action=category=2" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">Addon Items</a><a href="index.php?subtopic=shopsystem&action=category=3" style="padding: 5px 5px 1px 5px; margin: 5px 1px 0px 1px; background-color: #F1E0C6; color: #aaaaaa;">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>&nbsp;ITEMS</b></font></td></tr><tr bgcolor="#b7a58a"><td width="50" align="center"><font color=#FFFFFF><b>Picture</b></font></td><td width="350" align="left"><font color=#FFFFFF><b>Description</b></font></td><td width="250" align="center"><font color=#FFFFFF><b>Select product</b></font></td></tr>';
               foreach($offer_list['item'] as $item)
               {
                   $main_content .= '<tr bgcolor="#F1E0C6"><td align="center"><img src="item_images/'.$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="#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>&nbsp;<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">&nbsp;<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';
   ?>


Can someone just look at it and explain for me?

Thanks in advice!
 
Back
Top