PHP Dosya Yöneticisi

<?php
class ModelToolPathManager extends Model {
  public $cachedPath = array();
  
	public function getFullProductPath($product_id, $breadcrumbs_mode = false) {
		$path_mode = 'mlseo_fpp_mode';
    
		if ($breadcrumbs_mode) {
			$path_mode = 'mlseo_fpp_bc_mode';
		}
		
		if (!$this->config->get($path_mode)) {
			return array();
    }
    
		if ($this->config->get($path_mode) == '3') {
			$man_id = $this->db->query("SELECT manufacturer_id FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "'")->row;
			
			if (!empty($man_id['manufacturer_id'])) {
				return array('manufacturer_id' => $man_id['manufacturer_id']);
			}
      
      return array();
		} else if ($this->config->get($path_mode) == '4') {
			$category = $this->db->query("SELECT p2c.category_id FROM " . DB_PREFIX . "product_to_category p2c LEFT JOIN " . DB_PREFIX . "category_path cp ON (p2c.category_id = cp.category_id) WHERE p2c.product_id = '" . (int)$product_id . "' ORDER BY cp.level DESC LIMIT 1")->row;
    
			if (!empty($category['category_id'])) {
				return array('path' => $category['category_id']);
			}
      
      return array();
		}
		
		$path = array();
		$categories = $this->db->query("SELECT c.category_id, c.parent_id, p.seo_canonical FROM " . DB_PREFIX . "product_to_category p2c LEFT JOIN " . DB_PREFIX . "category c ON (p2c.category_id = c.category_id) LEFT JOIN " . DB_PREFIX . "product p ON (p2c.product_id = p.product_id) WHERE p2c.product_id = '" . (int)$product_id . "'")->rows;
		
    $catsId = '';
    
		foreach ($categories as $key => $category) {
      if (!empty($category['seo_canonical']) && $category['seo_canonical'] != $category['category_id']) {
        unset($categories[$key]);
        continue;
      }
      
      $catsId .= ($catsId ? '|' : '') . $category['category_id'];
    }
    
    if (isset($this->cachedPath[$catsId])) {
      // pathis cached, get it
      $path = $this->cachedPath[$catsId];
    } else {
      $banned_cats = $this->config->get('mlseo_fpp_categories') ? $this->config->get('mlseo_fpp_categories') : array();
      
      // path not in cache, generate it
      foreach ($categories as $key => $category) {
        $path[$key] = '';
        
        if (!$category) continue;
        
        $path[$key] = $category['category_id'];
        
        while (!empty($category['parent_id'])) {
          if (!in_array($category['parent_id'], $banned_cats)) {
            $path[$key] = $category['parent_id'] . '_' . $path[$key];
          }
          $category = $this->db->query("SELECT category_id, parent_id FROM " . DB_PREFIX . "category WHERE category_id = '" . $category['parent_id']. "'")->row;
        }
        
        $path[$key] = $path[$key];
        
        /*
        if (is_array($banned_cats) && is_array($categories) && count($banned_cats) && (count($categories) > 1)) {
          if (in_array($path[$key], $banned_cats)) {
              unset($path[$key]);
          } else if (preg_match('#[_=](\d+)$#', $path[$key], $cat)) {
            if (in_array($cat[1], $banned_cats)) {
              unset($path[$key]);
            }
          }
        }
        */
      }
      
      if (!count($path)) return array();

// wich one is the largest ?
      $whichone = array_map('strlen', $path);
      asort($whichone);
      $whichone = array_keys($whichone);
      
      if ($this->config->get($path_mode) == '2') {
        $whichone = array_pop($whichone);
      } else {
        $whichone = array_shift($whichone);
      }
      
      $path = $path[$whichone];
      
      if ((int) $this->config->get('mlseo_fpp_depth')) {
        $path_parts  = explode('_', $path);
        while (count($path_parts) > (int) $this->config->get('mlseo_fpp_depth')) {
          array_pop($path_parts);
        }
        $path = implode('_', $path_parts);
      }
      
      $this->cachedPath[$catsId] = $path;
		}
    
		return array('path' => $path);
	}

public function getFullCategoryPath($category_id) {
    $path = '';
    $category = $this->db->query("SELECT category_id, parent_id FROM " . DB_PREFIX . "category WHERE category_id = '" . (int)$category_id . "'")->row;
    
    if (!$category) {
      return '';
    }
    
    $path = $category['category_id'];
    
    while ($category['parent_id']) {
      $path = $category['parent_id'] . '_' . $path;
      $category = $this->db->query("SELECT category_id, parent_id FROM " . DB_PREFIX . "category WHERE category_id = '" . $category['parent_id']. "'")->row;
    }
    
    return $path;
	}

public function getManufacturerKeyword() {
    if ($this->config->get('mlseo_ml_mode')) {
      $ml_mode = "AND (`language_id` = '" . (int)$this->config->get('config_language_id') . "' OR `language_id` = 0)";
    } else {
      $ml_mode = '';
    }
    
    if (version_compare(VERSION, '3', '>=')) {
      $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = 'route=product/manufacturer'". $ml_mode ." LIMIT 1")->row;
    } else {
      $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` LIKE '%product/manufacturer'". $ml_mode ." LIMIT 1")->row;
    }
    
    if (!empty($query['keyword'])) {
      return '/' . $query['keyword'];
    }
    
    return '';
  }
}

İptal

📁 PHP Dosya Yöneticisi

📝 path_manager.php

📝 path_manager.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)