admin/model/extension/d_blog_module/category.php

（开头部分） 21KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

<?php
class ModelExtensionDBlogModuleCategory extends Model {

    public function addCategory($data) {
        $sql = "SELECT * 
              FROM INFORMATION_SCHEMA.COLUMNS 
                WHERE TABLE_NAME = '" . DB_PREFIX . "bm_category'
                AND COLUMN_NAME = 'limit_access_user_group'
                AND TABLE_SCHEMA = '" . DB_DATABASE . "'
                ";
        if (empty($this->db->query($sql)->rows)) {
            $this->db->query("ALTER TABLE `" . DB_PREFIX . "bm_category`
            ADD COLUMN `limit_access_user` INT(1) DEFAULT 0  NOT NULL AFTER `status`,
            ADD COLUMN `limit_users` TEXT(255) NULL AFTER `limit_access_user`,
            ADD COLUMN `limit_access_user_group` INT(1) DEFAULT 0  NOT NULL AFTER `limit_users`,
            ADD COLUMN `limit_user_groups` TEXT(255) NULL AFTER `limit_access_user_group`;
        ");
        }

        $this->db->query("INSERT INTO " . DB_PREFIX
            . "bm_category SET parent_id = '" . (int) $data['parent_id']
            . "', sort_order = '" . (int) $data['sort_order']
            . "', status = '" . (int) $data['status']
            . "', limit_access_user ='" . (int)$data['limit_access_user']
            . "', limit_users ='" . implode(",", isset($data['access_user']) ? $data['access_user'] : array())
            . "', limit_access_user_group ='" . (int)$data['limit_access_user_group']
            . "', limit_user_groups ='" . implode(",", isset($data['access_user_group']) ? $data['access_user_group'] : array())
            . "', custom = '" . (int) $data['custom']
            . "', setting = '" . $this->db->escape(json_encode($data['setting']))
            . "', date_modified = NOW(), date_added = NOW()");

        $category_id = $this->db->getLastId();



        if (isset($data['image'])) {
            $this->db->query("UPDATE " . DB_PREFIX . "bm_category "
                . "SET image = '" . $this->db->escape($data['image'])
                . "' WHERE category_id = '" . (int) $category_id . "'");
        }

        foreach ($data['category_description'] as $language_id => $value) {
            $this->db->query("INSERT INTO " . DB_PREFIX . "bm_category_description "
                . "SET category_id = '" . (int) $category_id
                . "', language_id = '" . (int) $language_id
                . "', title = '" . $this->db->escape($value['title'])
				. "', short_description = '" . $this->db->escape($value['short_description'])
                . "', description = '" . $this->db->escape($value['description'])
                . "', meta_title = '" . $this->db->escape($value['meta_title'])
                . "', meta_description = '" . $this->db->escape($value['meta_description'])
                . "', meta_keyword = '" . $this->db->escape($value['meta_keyword']) . "'");
        }

// MySQL Hierarchical Data Closure Table Pattern
        $level = 0;

        $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "bm_category_path` WHERE category_id = '" . (int) $data['parent_id'] . "' ORDER BY `level` ASC");

        foreach ($query->rows as $result) {
            $this->db->query("INSERT INTO `" . DB_PREFIX . "bm_category_path` SET
后面还有 429 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。