Untitled

  public function getBuyItem($id) {
    $uid = (int)$_SESSION['user'];
    $item_id = (int)$this->fastClean($id);
    $check_item_in_table = $this->db->single('SELECT * FROM `'. SITE .'`.`itemshop_items` WHERE `id` = ' . $item_id);

    if(sizeof($check_item_in_table) > 1) {
        $item_proto = $this->db->single('SELECT * FROM `'. PLAYER .'`.`item_proto` WHERE `vnum` = '. $check_item_in_table['item_proto_id']);
        $size = $item_proto['size'];

        if ($this->player->account['cash'] >= $check_item_in_table['price']) {
            $work = array();
        } else {
            return 2; break;
        }

        @$free = $this->db->multi('SELECT `pos`, `item_proto`.`size` FROM `'.PLAYER.'`.`item`, `'.PLAYER.'`.`item_proto` WHERE `item`.`vnum` = `item_proto`.`vnum` AND `window` = "MALL" AND `owner_id` = '. $uid);


        $pos = $this->getPositionItem($size);

        if($pos == -1) {  return 3; break; } else {

            $a = 1;
            if($item_proto['limittype0'] == 7) $socket2 = $item_proto['limitvalue0'] / 60;
            if($item_proto['type'] == 16) $socket2 = $item_proto['value0'];

            if($item_proto['limittype0'] == 7)
            {
                $czas = time() + $item_proto['limitvalue0'];
                $this->db->query('INSERT IGNORE INTO `'.PLAYER.'`.`item` (`vnum`, `owner_id`, `window`, `pos`, `count`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`) VALUES ('.$item_proto['vnum'].','.$uid.', "MALL",'.$pos.','.$check_item_in_table['count'].', '.$czas.', '.$item_proto['socket1'].', '.$item_proto['socket2'].', '.$item_proto['socket3'].', '.$item_proto['socket4'].', '.$item_proto['socket5'].')');
            }
            else
            {
                $this->db->query('INSERT IGNORE INTO `'.PLAYER.'`.`item` (`vnum`, `owner_id`, `window`, `pos`, `count`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`) VALUES ('.$item_proto['vnum'].','.$uid.', "MALL",'.$pos.','.$check_item_in_table['count'].', '.$item_proto['socket0'].', '.$item_proto['socket1'].', '.$item_proto['socket2'].', '.$item_proto['socket3'].', '.$item_proto['socket4'].', '.$item_proto['socket5'].')');
            }

            //$this->db->query('INSERT IGNORE INTO `'.PLAYER.'`.`item` (`vnum`, `owner_id`, `window`, `pos`, `count`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`) VALUES ('.$item_proto['vnum'].','.$uid.', "MALL",'.$pos.','.$check_item_in_table['count'].', '.$item_proto['socket0'].', '.$item_proto['socket1'].', '.$item_proto['socket2'].', '.$item_proto['socket3'].', '.$item_proto['socket4'].', '.$item_proto['socket5'].')');

            $this->addCoins(-$check_item_in_table['price']);
            $this->addLog('BUY_ITEM_FOR_' . $check_item_in_table['price'] . ' SM');
            return 4;
        }
    } else {
        return 1;  break;
    }
  }