admin/model/extension/d_blog_module/post.php

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

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php

class ModelExtensionDBlogModulePost extends Model
{

    public function updateTableAccess()
    {
        $this->db->query();
    }

    public function editPost($post_id, $data)
    {

        $sql = "SELECT * 
              FROM INFORMATION_SCHEMA.COLUMNS 
                WHERE TABLE_NAME = '" . DB_PREFIX . "bm_post'
                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_post`
            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("UPDATE " . DB_PREFIX . "bm_post
            SET
            user_id = '" . (int)$data['current_author'] . "',
            status = '" . (int)$data['status'] . "',
            review_display ='" . (int)$data['review_display'] . "',
            images_review ='" . (int)$data['images_review'] . "', 
            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()) . "',
            date_published = '" . $data['date_published'] . "',
            date_modified = NOW() WHERE post_id = '" . (int)$post_id . "'");
        if (isset($data['image'])) {
            $this->db->query("UPDATE " . DB_PREFIX . "bm_post
                SET image = '" . $this->db->escape($data['image'])
                . "' WHERE post_id = '" . (int)$post_id . "'");
        }

        $this->db->query("DELETE FROM " . DB_PREFIX . "bm_post_description "
            . " WHERE post_id = '" . (int)$post_id . "'");
        foreach ($data['post_description'] as $language_id => $value) {
            $this->db->query("INSERT INTO " . DB_PREFIX . "bm_post_description
                SET post_id = '" . (int)$post_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']) . "',
				tag = '" . $this->db->escape($value['tag']) . "'"
            );
        }