/*
Navicat MySQL Data Transfer

Source Server         : 本地站点
Source Server Version : 50726
Source Host           : localhost:3306
Source Database       : root

Target Server Type    : MYSQL
Target Server Version : 50726
File Encoding         : 65001

Date: 2026-05-21 12:03:49
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for carts
-- ----------------------------
DROP TABLE IF EXISTS `carts`;
CREATE TABLE `carts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `specs` text,
  `bundle_ids` text,
  `quantity` int(11) NOT NULL DEFAULT '1',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_checkout` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of carts
-- ----------------------------

-- ----------------------------
-- Table structure for categories
-- ----------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `template` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'list.html' COMMENT '列表模板绑定',
  `status` tinyint(4) DEFAULT '1',
  `display` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `custom_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `archiveid` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `virtual_top` tinyint(1) NOT NULL DEFAULT '0',
  `virtual_top_anchor` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of categories
-- ----------------------------
INSERT INTO `categories` VALUES ('1', 'QKCMS', 'QKCMS建站系统-轻量级AI智能CMS产品下载授权购买与更新日志', 'QKCMS建站系统栏目集中展示产品介绍、程序下载、授权购买和版本更新日志，是QKCMS官方产品核心页面。提供轻量级AI智能CMS系统下载、正版授权购买入口、最新版本发布记录和功能升级说明，帮助用户快速了解产品并完成部署。', '/assets/images/moren.jpg', 'QKCMS建站系统,QKCMS官网,QKCMS下载,QKCMS授权购买,QKCMS更新日志,轻量级CMS,AI智能建站系统,企业建站CMS', 'list.html', '1', '1', '2026-05-13 15:48:20', '2026-05-18 17:16:09', null, '0', '1', '0', '0');

-- ----------------------------
-- Table structure for catgroup
-- ----------------------------
DROP TABLE IF EXISTS `catgroup`;
CREATE TABLE `catgroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `color` varchar(20) NOT NULL DEFAULT '#64748b',
  `custom_url` varchar(255) DEFAULT NULL,
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_keywords` text,
  `seo_description` text,
  `template` varchar(50) NOT NULL DEFAULT 'catgroup.html',
  `sort` int(11) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_catgroup_custom_url` (`custom_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of catgroup
-- ----------------------------

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) DEFAULT '0',
  `report_count` int(11) DEFAULT '0',
  `dislike_count` int(11) DEFAULT '0',
  `likes` int(11) DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `reply_to` varchar(50) NOT NULL DEFAULT '',
  `content_type` varchar(20) NOT NULL DEFAULT 'post',
  PRIMARY KEY (`id`),
  KEY `idx_post_id` (`post_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_parent_id` (`parent_id`),
  KEY `idx_content_type` (`content_type`),
  KEY `idx_ct_post_status_parent` (`content_type`,`post_id`,`status`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES ('1', '1', '1', '<p>大家好，我是QKCMS第一条评论</p>', '2026-05-21 11:20:33', '1', '0', '0', '0', '0', '', 'post');
INSERT INTO `comments` VALUES ('2', '3', '1', '<p>2444wrtt</p>', '2026-05-21 11:49:47', '1', '0', '0', '0', '0', '', 'post');

-- ----------------------------
-- Table structure for counter
-- ----------------------------
DROP TABLE IF EXISTS `counter`;
CREATE TABLE `counter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stat_date` date NOT NULL,
  `page_title` varchar(255) NOT NULL DEFAULT '',
  `page_url` varchar(500) NOT NULL DEFAULT '',
  `entry_url` varchar(500) NOT NULL DEFAULT '',
  `os_name` varchar(60) NOT NULL DEFAULT '',
  `browser` varchar(80) NOT NULL DEFAULT '',
  `language` varchar(20) NOT NULL DEFAULT '',
  `timezone` varchar(80) NOT NULL DEFAULT '',
  `resolution` varchar(40) NOT NULL DEFAULT '',
  `pv` int(11) NOT NULL DEFAULT '0',
  `uv` int(11) NOT NULL DEFAULT '0',
  `ip_count` int(11) NOT NULL DEFAULT '0',
  `spider_count` int(11) NOT NULL DEFAULT '0',
  `speed_ms` decimal(10,2) NOT NULL DEFAULT '0.00',
  `avg_time_ms` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bounce_rate` decimal(6,2) NOT NULL DEFAULT '0.00',
  `session_count` int(11) NOT NULL DEFAULT '0',
  `bounce_count` int(11) NOT NULL DEFAULT '0',
  `sum_speed_ms` bigint(20) NOT NULL DEFAULT '0',
  `sum_time_ms` bigint(20) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uv_keys` mediumtext,
  `ip_keys` mediumtext,
  `session_keys` mediumtext,
  `bounce_keys` mediumtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_stat_page` (`stat_date`,`page_url`(191)),
  KEY `idx_stat_date` (`stat_date`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of counter
-- ----------------------------
INSERT INTO `counter` VALUES ('1', '2026-05-21', 'QKCMS建站系统-轻量级AI智能CMS-织梦CMS替代方案-启肯网络', '/', '/', 'Windows', 'Chrome', 'zh-CN', 'Asia/Shanghai', '1440x900', '7', '5', '1', '0', '1107.00', '150423.86', '60.00', '5', '3', '7749', '1052967', '2026-05-21 10:22:39', '2026-05-21 10:47:09', '1f2f02457d33aa4e,c8628263ce251a32,b566902068bea458,67dfe54fba1c482c,817d4f17c96fdc2a', '837ec5754f503cfa', '899dd1b10219c8bd,b6902db958f837d0,80e9aa3ab799ac2f,3009b0f34e834d70,69d9ba968ae40f1c', '899dd1b10219c8bd,3009b0f34e834d70,69d9ba968ae40f1c');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `image` text,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `stock` int(11) NOT NULL DEFAULT '0',
  `sales` int(11) NOT NULL DEFAULT '0',
  `parent_id` text,
  `keywords` varchar(255) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `category_id` int(11) NOT NULL DEFAULT '0',
  `content` longtext NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `specs` text,
  `mp4url` text,
  `template` varchar(50) DEFAULT 'goods.php',
  `stamp_config` text COMMENT '盖章配置',
  PRIMARY KEY (`id`),
  KEY `idx_category_status` (`category_id`,`status`,`id`),
  KEY `idx_status_create_time` (`status`,`create_time`,`id`),
  KEY `idx_status_sales` (`status`,`sales`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1', 'QKCMS授权专用商品', 'http://localhost/uploads/goods/thumbnail_1_6a01dcfd994ca4.83680948.png', '99.00', '1', '0', '0', 'QKCMS商业版,QKCMS授权', 'QKCMS采用AI智能技术，标签化模板开发引擎，体积轻巧仅1MB多，比织梦系统更简洁易用。零门槛高效建站系统，让部署变得轻松高效，适合个人与企业快速建站', '1', '1', '<p><br></p>', '2026-05-11 21:34:17', '2026-05-20 20:21:16', '', '', 'templates/goods.php', '[{\"post_id\":1,\"prop_id\":0,\"xPct\":0.72708333333333,\"yPct\":0.32030581962678,\"text\":\"普通\",\"config\":{\"style\":\"19\",\"color\":\"#277dbe\",\"opacity\":\"0.9\",\"rotate\":\"334\",\"size\":\"240\",\"textFont\":\"\",\"copyright\":\"QKCMS\",\"copyrightFont\":\"WenQuanYi Micro Hei\",\"copyrightSize\":\"20\",\"copyrightWeight\":\"700\",\"copyrightOpacity\":\"0.7\",\"name\":\"普通\"},\"id\":\"st6a01e189812bd7.21493164\"}]');

-- ----------------------------
-- Table structure for levels
-- ----------------------------
DROP TABLE IF EXISTS `levels`;
CREATE TABLE `levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `icon` varchar(255) DEFAULT NULL,
  `permissions` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of levels
-- ----------------------------
INSERT INTO `levels` VALUES ('1', '游客', '', '{\"view\":1}');
INSERT INTO `levels` VALUES ('2', 'VIP会员', '', '{\"view\":1,\"post\":1}');
INSERT INTO `levels` VALUES ('3', '管理员', '', '{\"view\":1,\"post\":1,\"admin\":1}');

-- ----------------------------
-- Table structure for likes
-- ----------------------------
DROP TABLE IF EXISTS `likes`;
CREATE TABLE `likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_type` varchar(20) NOT NULL DEFAULT '',
  `content_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `type` enum('like','dislike') NOT NULL DEFAULT 'like',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_like` (`content_type`,`content_id`,`user_id`,`type`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of likes
-- ----------------------------
INSERT INTO `likes` VALUES ('1', 'comment', '1', '1', 'like', '2026-05-20 21:27:55');
INSERT INTO `likes` VALUES ('2', 'comment', '1', '1', 'dislike', '2026-05-20 21:28:01');

-- ----------------------------
-- Table structure for navigation
-- ----------------------------
DROP TABLE IF EXISTS `navigation`;
CREATE TABLE `navigation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `target` varchar(20) DEFAULT '_self',
  `display_order` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `parent_id` int(11) DEFAULT '0',
  `category_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of navigation
-- ----------------------------
INSERT INTO `navigation` VALUES ('1', '首页', '/', '_self', '1', '1', '2026-05-11 18:30:48', '2026-05-13 15:01:50', '0', '0');
INSERT INTO `navigation` VALUES ('2', 'QKCMS建站系统下载', '/download.html', '_self', '2', '1', '2026-05-13 12:49:02', '2026-05-21 11:33:29', '0', '0');
INSERT INTO `navigation` VALUES ('3', 'QKCMS', '/list_id1.html', '_self', '3', '1', '2026-05-13 15:07:49', '2026-05-21 11:33:29', '0', '1');
INSERT INTO `navigation` VALUES ('4', '联系我们', '/contact.html', '_self', '4', '1', '2026-05-21 11:17:26', '2026-05-21 11:33:29', '0', '0');
INSERT INTO `navigation` VALUES ('5', '产品介绍', '/intro.html', '_self', '1', '1', '2026-05-21 11:23:08', '2026-05-21 12:03:16', '3', '0');

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(32) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `points` int(11) NOT NULL,
  `pay_type` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `goods_id` int(11) DEFAULT '0',
  `goods_info` text,
  `address` text,
  `message` text,
  `shipping_status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `pay_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_no` (`order_no`),
  KEY `user_id` (`user_id`),
  KEY `goods_id` (`goods_id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_pay_type` (`pay_type`),
  KEY `idx_order_type` (`type`),
  KEY `idx_shipping_status` (`shipping_status`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order
-- ----------------------------
INSERT INTO `order` VALUES ('1', 'JFW260329231243', '1', '100.00', '1000', '微信', '积分类', '0', '积分充值', '', '', '1', '2026-03-29 23:12:43', '2026-03-29 23:12:43');
INSERT INTO `order` VALUES ('2', 'JFA260330231243', '2', '200.00', '2000', '支付宝', '积分类', '0', '积分充值', '', '', '1', '2026-03-30 23:12:43', '2026-03-30 23:12:43');
INSERT INTO `order` VALUES ('3', 'ZYW260410231243', '7', '499.00', '4990', '微信', '资源类', '7', '终极资源包', '', '', '1', '2026-04-10 23:12:43', '2026-04-10 23:12:43');
INSERT INTO `order` VALUES ('4', 'ZYA260411231243', '8', '129.00', '1290', '支付宝', '资源类', '8', '入门资源包', '', '', '1', '2026-04-11 23:12:43', '2026-04-11 23:12:43');
INSERT INTO `order` VALUES ('5', 'ZYW260412231243', '9', '279.00', '2790', '微信', '资源类', '9', '精英资源包', '', '', '1', '2026-04-12 23:12:43', '2026-04-12 23:12:43');
INSERT INTO `order` VALUES ('6', 'ZYA260413231243', '10', '349.00', '3490', '支付宝', '资源类', '10', '专家资源包', '', '', '1', '2026-04-13 23:12:43', '2026-04-13 23:12:43');
INSERT INTO `order` VALUES ('7', 'GJW260412231243', '9', '199.00', '1990', '微信', '工具类', '19', '专业工具', '', '', '1', '2026-04-12 23:12:43', '2026-04-12 23:12:43');
INSERT INTO `order` VALUES ('8', 'GJA260413231243', '10', '299.00', '2990', '支付宝', '工具类', '20', '高级工具', '', '', '1', '2026-04-13 23:12:43', '2026-04-13 23:12:43');
INSERT INTO `order` VALUES ('9', 'SPW260329231243', '1', '299.00', '2990', '微信', '商品类', '21', '智能手机', '北京市朝阳区建国路88号', '请尽快发货', '1', '2026-03-29 23:12:43', '2026-03-29 23:12:43');
INSERT INTO `order` VALUES ('10', 'SPA260330231243', '2', '199.00', '1990', '支付宝', '商品类', '22', '无线耳机', '上海市浦东新区陆家嘴环路1000号', '希望包装完好', '1', '2026-03-30 23:12:43', '2026-03-30 23:12:43');

-- ----------------------------
-- Table structure for plugin
-- ----------------------------
DROP TABLE IF EXISTS `plugin`;
CREATE TABLE `plugin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(60) NOT NULL DEFAULT '',
  `event` varchar(60) NOT NULL DEFAULT '',
  `payload` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_plugin_created` (`plugin`,`created_at`),
  KEY `idx_plugin_event_created` (`plugin`,`event`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of plugin
-- ----------------------------

-- ----------------------------
-- Table structure for posts
-- ----------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` longtext NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `keywords` text,
  `description` text,
  `thumbnail` text,
  `property` tinyint(1) DEFAULT '0',
  `template` varchar(50) NOT NULL DEFAULT 'post.php' COMMENT '文章模板绑定',
  `custom_url` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `views` int(11) DEFAULT '0',
  `likes` int(11) DEFAULT '0',
  `points` int(11) DEFAULT '0',
  `mp4url` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tool_url` varchar(255) DEFAULT NULL,
  `status_switch` tinyint(1) DEFAULT '0',
  `price` decimal(10,2) DEFAULT '0.00',
  `redirect_url` varchar(255) DEFAULT NULL,
  `function_type` varchar(20) DEFAULT 'tool',
  `stamp_config` text COMMENT '盖章配置',
  `bind_domain` varchar(255) DEFAULT NULL,
  `top_type` tinyint(1) NOT NULL DEFAULT '0',
  `access_password` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_category_id` (`category_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of posts
-- ----------------------------
INSERT INTO `posts` VALUES ('1', 'QKCMS介绍', '<p><br></p><p><strong>QKCMS系统要求</strong></p><p>QKCMS作为轻量级内容管理系统，对服务器环境要求明确且实用。系统运行需要PHP 7.0或以上版本，确保现代PHP特性的完整支持，同时需要MySQL 5.7或以上数据库版本，保证数据存储和查询的高效性。系统采用UTF-8编码，完美支持中文内容处理。得益于精简的代码架构。对服务器资源占用极低，即使在配置较低的服务器上也能稳定运行，兼容Apache、Nginx等主流服务器。</p><p><br></p><p><strong>核心功能与技术亮点</strong></p><p>QKCMS采用创新的标签化模板机制，通过简洁的标签即可实现复杂功能。例如，使用【qkcms:posts_thumbnail】标签可直接调用文章缩略图，【qkcms:posts_comments】标签显示文章评论数，【qkcms:cat_description】标签输出分类描述，无需编写繁琐的PHP代码。系统深度集成AI智能引擎，支持AI智能批量发布文章、AI生图等先进技术，大幅提升内容创作效率。前台和后台均采用现代化UI设计，界面美观大方，用户体验优秀。丰富的插件生态涵盖数据备份、支付集成等功能模块，满足多样化需求。</p><p><br></p><p><strong>为什么选择QKCMS？</strong></p><p>选择QKCMS的理由显而易见。首先，AI智能技术让内容管理变得前所未有的简单，自动化的内容生成和发布功能极大提升工作效率。其次，超轻量级的设计理念让系统运行快速稳定，几十KB的程序体积在同类CMS中独树一帜，部署和维护成本极低。再者，标签化模板机制降低了开发门槛，即使非专业开发者也能快速上手。完善的插件生态、持续的版本更新、活跃的技术支持，为用户提供了长期稳定的技术保障。选择QKCMS，就是选择了高效、智能、稳定的建站解决方案。</p><p><br></p><p><strong>核心文件结构</strong></p><p>QKCMS的文件结构清晰简洁。index.php作为网站入口文件，负责路由分发；common.php是公共函数库，集成数据库、缓存、模板、插件等核心功能；config.php存放数据库配置；license.php作为授权验证引擎，保障系统安全。系统还包含.htaccess或web.config用于URL重写规则实现伪静态，robots.txt规定搜索引擎爬虫规则，sitemap.xml生成网站地图。admin目录包含20多个后台管理功能模块，templates目录存放21个前台模板文件，assets目录包含CSS、JS、图片、Quill编辑器和qkcms.sql数据库文件，uploads目录用于用户上传文件，toolsrc目录包含插件开发规范等工具源文件。</p><p><br></p><p><strong>AI智能引擎</strong></p><table><tbody><tr><td data-row=\"1\"><strong>AI 功能</strong></td><td data-row=\"1\"><strong>说明</strong></td></tr><tr><td data-row=\"2\">AI 批量发布</td><td data-row=\"2\">基于 AI 模型自动生成并发布文章</td></tr><tr><td data-row=\"3\">AI 生图</td><td data-row=\"3\">集成 AI 图像生成，自动生成配图</td></tr><tr><td data-row=\"4\">AI 评论</td><td data-row=\"4\">AI 自动生成评论互动内容</td></tr><tr><td data-row=\"5\">长尾词生成</td><td data-row=\"5\">AI 生成 SEO 长尾关键词</td></tr><tr><td data-row=\"6\">AI 视频生成</td><td data-row=\"6\">基于火山引擎豆包模型生成短视频</td></tr></tbody></table><p><strong>安全体系</strong></p><table><tbody><tr><td data-row=\"1\"><strong>安全机制</strong></td><td data-row=\"1\"><strong>说明</strong></td></tr><tr><td data-row=\"2\">授权验证</td><td data-row=\"2\">云端授权验证，未授权限制功能使用</td></tr><tr><td data-row=\"3\">防篡改监控</td><td data-row=\"3\">实时监控文件完整性，识别异常变动</td></tr><tr><td data-row=\"4\">数据备份</td><td data-row=\"4\">一键备份数据库，快速恢复</td></tr><tr><td data-row=\"5\">密码加密</td><td data-row=\"5\">用户密码加密存储，防泄露</td></tr><tr><td data-row=\"6\">XSS 防护</td><td data-row=\"6\">输入过滤，防跨站脚本攻击</td></tr><tr><td data-row=\"7\">SQL 注入防护</td><td data-row=\"7\">预处理语句，防 SQL 注入</td></tr><tr><td data-row=\"8\">权限控制</td><td data-row=\"8\">角色权限分离，精细访问控制</td></tr></tbody></table><p><strong>伪静态规则</strong></p><p>系统支持 Apache（.htaccess）、Nginx、IIS（web.config）伪静态，实现友好 URL：</p><table><tbody><tr><td data-row=\"1\"><strong>URL格式</strong></td><td data-row=\"1\"><strong>说明</strong></td></tr><tr><td data-row=\"2\">/post_id1.php</td><td data-row=\"2\">文章页</td></tr><tr><td data-row=\"3\">/list_id2.html</td><td data-row=\"3\">分类列表</td></tr><tr><td data-row=\"4\">/search_关键词.html</td><td data-row=\"4\">搜索页</td></tr><tr><td data-row=\"5\">/tag_TAG词.html</td><td data-row=\"5\">标签页</td></tr></tbody></table><p><strong>应用场景</strong></p><table><tbody><tr><td data-row=\"1\"><strong>场景</strong></td><td data-row=\"1\"><strong>说明</strong></td></tr><tr><td data-row=\"2\">企业官网</td><td data-row=\"2\">快速搭建企业形象展示网站</td></tr><tr><td data-row=\"3\">个人博客</td><td data-row=\"3\">极简博客系统，轻量高效</td></tr><tr><td data-row=\"4\">资讯门户</td><td data-row=\"4\">海量内容管理，AI 辅助发布</td></tr><tr><td data-row=\"5\">产品展示</td><td data-row=\"5\">商品列表/详情/在线支付</td></tr><tr><td data-row=\"6\">行业门户</td><td data-row=\"6\">多栏目/多模板灵活切换</td></tr><tr><td data-row=\"7\">软件官网</td><td data-row=\"7\">产品介绍/下载/授权购买</td></tr></tbody></table><p><strong>系统要求</strong></p><table><tbody><tr><td data-row=\"1\"><strong>项目</strong></td><td data-row=\"1\"><strong>最低配置</strong></td><td data-row=\"1\"><strong>推荐配置</strong></td></tr><tr><td data-row=\"2\">PHP</td><td data-row=\"2\">7.0</td><td data-row=\"2\">7.4+</td></tr><tr><td data-row=\"3\">MySQL</td><td data-row=\"3\">5.7</td><td data-row=\"3\">8.0+</td></tr><tr><td data-row=\"4\">磁盘空间</td><td data-row=\"4\">50 MB</td><td data-row=\"4\">100 MB+</td></tr><tr><td data-row=\"5\">内存</td><td data-row=\"5\">128 MB</td><td data-row=\"5\">256 MB+</td></tr></tbody></table>', '1', '1', 'QKCMS,QKCMS介绍,轻量级CMS', '选择QKCMS的理由显而易见。首先，AI智能技术让内容管理变得前所未有的简单，自动化的内容生成和发布功能极大提升工作效率。其次，超轻量级的设计理念让系统运行快速稳定，1MB左右的程序体积在同类CMS中独树一帜，部署和维护成本极低。再者，标签化模板机制降低了开发门槛，即使非专业开发者也能快速上手。完善的插件生态、持续的版本更新、活跃的技术支持，为用户提供了长期稳定的技术保障。选择QKCMS，就是选择了高效稳定的建站解决方案。', '', '5', 'skin/5_post.php', 'intro.html', '1', '1713', '0', '0', '', '2026-03-08 21:17:51', '2026-05-21 11:19:45', '', '0', '0.00', '', 'tool', null, '', '0', '');
INSERT INTO `posts` VALUES ('2', 'QKCMS产品下载', '<p><br></p>', '1', '1', 'QKCMS下载,产品下载,CMS下载', 'QKCMS轻量级AI智能内容管理系统，支持AI智能建站、标签化模板、企业级安全防护、响应式设计、海量插件，无需编程基础，零门槛高效建站，适合个人与企业快速搭建各类网站。', '', '4', 'skin/8_post.php', 'download.html', '1', '1480', '0', '0', '', '2026-03-11 23:49:17', '2026-05-21 02:46:16', '', '0', '0.00', '', 'tool', null, '', '0', '');
INSERT INTO `posts` VALUES ('3', '联系我们', '<p><br></p>', '1', '1', '联系我们,联系方式,客服联系', 'QKCMS轻量级AI智能内容管理建站系统，由温州启肯科技开发，支持标签化模板、体积轻巧，提供电话、微信、QQ、邮箱等多种联系方式，专业技术值得信赖。', '', '2', 'skin/7_post.html', 'contact.html', '1', '1424', '0', '0', '', '2026-03-09 00:47:29', '2026-05-21 11:51:11', '', '0', '0.00', '', 'tool', null, '', '0', '');

-- ----------------------------
-- Table structure for properties
-- ----------------------------
DROP TABLE IF EXISTS `properties`;
CREATE TABLE `properties` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int(11) NOT NULL DEFAULT '0',
  `color` varchar(20) NOT NULL DEFAULT '#999999',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of properties
-- ----------------------------
INSERT INTO `properties` VALUES ('0', '普通', '1', '1', '0', '#8c8c8c');
INSERT INTO `properties` VALUES ('1', '头条', '1', '1', '1', '#0391d8');
INSERT INTO `properties` VALUES ('2', '热门', '1', '1', '2', '#4fbf65');
INSERT INTO `properties` VALUES ('3', '推荐', '1', '1', '3', '#9e50ed');
INSERT INTO `properties` VALUES ('4', '公告', '1', '1', '4', '#96c039');
INSERT INTO `properties` VALUES ('5', '给力', '1', '1', '5', '#ff4405');

-- ----------------------------
-- Table structure for publish
-- ----------------------------
DROP TABLE IF EXISTS `publish`;
CREATE TABLE `publish` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `keywords` text,
  `description` text,
  `content` longtext NOT NULL,
  `thumbnail` text,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `post_id` int(11) NOT NULL DEFAULT '0',
  `scheduled_at` datetime DEFAULT NULL,
  `task_id` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_status_created_at` (`status`,`created_at`),
  KEY `idx_category_id` (`category_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of publish
-- ----------------------------
INSERT INTO `publish` VALUES ('1', '11', '1', 'QKCM轻量级内容管理系统第一篇投稿文章', 'QKCMS', 'QKCMS,投稿', '<p>QKCMS,投稿</p>', '', '0', '2026-05-20 19:43:15', '0', null, null);

-- ----------------------------
-- Table structure for reports
-- ----------------------------
DROP TABLE IF EXISTS `reports`;
CREATE TABLE `reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_type` varchar(20) NOT NULL DEFAULT '',
  `content_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `reason` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `idx_content_id` (`content_id`),
  KEY `idx_status_created` (`status`,`created_at`),
  KEY `idx_content_type_id` (`content_type`,`content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of reports
-- ----------------------------
INSERT INTO `reports` VALUES ('1', 'post', '9', '1', '大家好，我是QKCMS第一条举报数据', '2026-05-21 11:21:31', '0');

-- ----------------------------
-- Table structure for search
-- ----------------------------
DROP TABLE IF EXISTS `search`;
CREATE TABLE `search` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `search_term` varchar(100) NOT NULL DEFAULT '',
  `search_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_search_term` (`search_term`),
  KEY `idx_search_time` (`search_time`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of search
-- ----------------------------
INSERT INTO `search` VALUES ('1', 'admin', 'QKCMS', '2026-05-13 17:13:32');

-- ----------------------------
-- Table structure for settings
-- ----------------------------
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `site_title` varchar(255) NOT NULL DEFAULT '',
  `site_keywords` varchar(255) DEFAULT NULL,
  `site_description` text,
  `site_copyright` varchar(255) DEFAULT NULL,
  `primary_color` varchar(20) DEFAULT NULL,
  `home_template` varchar(50) NOT NULL DEFAULT 'index.php',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment_check` tinyint(1) DEFAULT '0',
  `debug_mode` tinyint(1) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `close_reason` varchar(255) DEFAULT NULL,
  `Prohw` varchar(255) DEFAULT '垃圾垃圾，骗子，去死',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of settings
-- ----------------------------
INSERT INTO `settings` VALUES ('1', 'QKCMS', '', 'QKCMS建站系统-轻量级AI智能CMS-织梦CMS替代方案-启肯网络', 'QKCMS,QKCMS建站系统,织梦替代,DEDECMS,轻量级CMS,AI建站系统,企业建站CMS,内容管理系统,QKCMS授权,QKCMS插件授权', 'QKCMS建站系统是一套轻量级AI智能CMS，体积小、部署快、开发灵活。适合快速搭建博客与企业官网，并可通过插件扩展实现论坛、商城等场景，可无缝替代织梦CMS。平台拥有完善的插件生态与模板市场，由启肯网络倾力研发，提供正版授权与定制开发服务。', '© 2025 QKCMS.  <a href=\'http://www.qiken.com\' target=\'_blank\'>温州启肯科技有限公司</a> 版权所有', '#10b981', 'templates/index.html', '2026-05-21 02:45:39', '1', '0', '0', '网站维护中..', '垃圾，骗子，去死，傻逼，脑瘫，杂种，滚蛋，色情，赌博，毒品，诈骗，翻墙，传销，造谣, 代购');

-- ----------------------------
-- Table structure for shares
-- ----------------------------
DROP TABLE IF EXISTS `shares`;
CREATE TABLE `shares` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_type` varchar(20) NOT NULL DEFAULT '',
  `content_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `idx_content` (`content_type`,`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shares
-- ----------------------------

-- ----------------------------
-- Table structure for tplmark
-- ----------------------------
DROP TABLE IF EXISTS `tplmark`;
CREATE TABLE `tplmark` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_cn` varchar(50) NOT NULL DEFAULT '',
  `code` varchar(50) NOT NULL DEFAULT '',
  `category` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT '',
  `example` text,
  `description` text,
  `description_html` longtext,
  `sort_order` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=450 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tplmark
-- ----------------------------
INSERT INTO `tplmark` VALUES ('1', '调用头部模板', 'head.html', 'site', 'single', '{qkcms:head.html}', '《调用头部模板》标签说明：单值标签，用于输出调用头部模板内容', '', '1');
INSERT INTO `tplmark` VALUES ('2', '调用尾部模板', 'footer.html', 'site', 'single', '{qkcms:footer.html}', '调用尾部模板文件', '', '2');
INSERT INTO `tplmark` VALUES ('3', '调用评论模块', 'comment.php', 'site', 'single', '{qkcms:comment.php}', '调用评论模块', '', '4');
INSERT INTO `tplmark` VALUES ('4', '网站名称', 'site_name', 'site', 'single', '{qkcms:site_name}', '网站名称', '', '5');
INSERT INTO `tplmark` VALUES ('5', '站点标题', 'site_title', 'site', 'single', '{qkcms:site_title}', '站点标题', '', '3');
INSERT INTO `tplmark` VALUES ('6', '站点描述', 'site_description', 'site', 'single', '{qkcms:site_description}', '站点描述', '', '6');
INSERT INTO `tplmark` VALUES ('7', '站点关键词', 'site_keywords', 'site', 'single', '{qkcms:site_keywords}', '站点关键词', '', '7');
INSERT INTO `tplmark` VALUES ('8', '页脚信息', 'site_copyright', 'site', 'single', '{qkcms:site_copyright}', '页脚信息', '', '8');
INSERT INTO `tplmark` VALUES ('9', '网站违禁词', 'site_Prohw', 'site', 'single', '{qkcms:site_Prohw}', '网站违禁词', '', '9');
INSERT INTO `tplmark` VALUES ('10', '当前位置', 'current_position', 'site', 'single', '{qkcms:current_position}', '当前位置', '', '10');
INSERT INTO `tplmark` VALUES ('11', '总评论数', 'total_comments', 'site', 'single', '{qkcms:total_comments}', '总评论数', '', '11');
INSERT INTO `tplmark` VALUES ('12', '关键词总数', 'total_keywords', 'site', 'single', '{qkcms:total_keywords}', '关键词总数', '', '12');
INSERT INTO `tplmark` VALUES ('13', '分类总数', 'total_categories', 'site', 'single', '{qkcms:total_categories}', '分类总数', '', '13');
INSERT INTO `tplmark` VALUES ('14', '总会员数', 'total_members', 'site', 'single', '{qkcms:total_members}', '总会员数', '', '14');
INSERT INTO `tplmark` VALUES ('15', '举报总数', 'total_reports', 'site', 'single', '{qkcms:total_reports}', '举报总数', '', '15');
INSERT INTO `tplmark` VALUES ('16', '总文章数', 'total_posts', 'site', 'single', '{qkcms:total_posts}', '总文章数', '', '16');
INSERT INTO `tplmark` VALUES ('17', '总订单数', 'total_order', 'site', 'single', '{qkcms:total_order}', '总订单数', '', '17');
INSERT INTO `tplmark` VALUES ('18', '搜索词匹配数量', 'total_search', 'site', 'single', '{qkcms:total_search}', '搜索词匹配数量', '', '18');
INSERT INTO `tplmark` VALUES ('19', 'TAG匹配数量', 'total_tag', 'site', 'single', '{qkcms:total_tag}', 'TAG匹配数量', '', '19');
INSERT INTO `tplmark` VALUES ('20', '网站累计访问量', 'total_visit', 'site', 'single', '{qkcms:total_visit}', '网站累计访问量', '', '20');
INSERT INTO `tplmark` VALUES ('21', '当前账号ID', 'user_id', 'site', 'single', '{qkcms:user_id}', '当前账号ID', '', '21');
INSERT INTO `tplmark` VALUES ('22', '当前账号', 'user_nickname', 'site', 'single', '{qkcms:user_nickname}', '当前账号', '', '22');
INSERT INTO `tplmark` VALUES ('23', '当前用户头像', 'user_avatar', 'site', 'single', '{qkcms:user_avatar}', '当前用户头像', '', '23');
INSERT INTO `tplmark` VALUES ('24', '当前用户等级', 'user_levels', 'site', 'single', '{qkcms:user_levels}', '当前用户等级', '', '24');
INSERT INTO `tplmark` VALUES ('25', '当前账号状态', 'user_status', 'site', 'single', '{qkcms:user_status}', '当前账号状态', '', '25');
INSERT INTO `tplmark` VALUES ('26', '当前账号积分', 'user_points', 'site', 'single', '{qkcms:user_points}', '当前账号积分', '', '26');
INSERT INTO `tplmark` VALUES ('27', '注册时间', 'user_created_at', 'site', 'single', '{qkcms:user_created_at}', '注册时间', '', '27');
INSERT INTO `tplmark` VALUES ('28', '文章ID', 'posts_id', 'article', 'single', '{qkcms:posts_id}', '文章ID', '', '1');
INSERT INTO `tplmark` VALUES ('29', '文章标题', 'posts_title', 'article', 'single', '{qkcms:posts_title}', '文章标题', '', '2');
INSERT INTO `tplmark` VALUES ('30', '文章URL', 'posts_url', 'article', 'single', '{qkcms:posts_url}', '文章URL', '', '3');
INSERT INTO `tplmark` VALUES ('31', '文章内容', 'posts_content', 'article', 'single', '{qkcms:posts_content}', '文章内容', '', '4');
INSERT INTO `tplmark` VALUES ('32', '文章关键词', 'posts_keywords', 'article', 'single', '{qkcms:posts_keywords}<br>{qkcms:posts_keywords_links}用这个可以自动分词+自动加连接', '《文章关键词》标签说明：单值标签，用于输出文章关键词内容', '', '5');
INSERT INTO `tplmark` VALUES ('33', '文章缩略图', 'posts_thumbnail', 'article', 'single', '{qkcms:posts_thumbnail}', '文章缩略图', '', '7');
INSERT INTO `tplmark` VALUES ('34', '文章描述', 'posts_description', 'article', 'single', '{qkcms:posts_description}', '文章描述', '', '8');
INSERT INTO `tplmark` VALUES ('35', '文章评论数', 'posts_comments', 'article', 'single', '{qkcms:posts_comments}', '文章评论数', '', '9');
INSERT INTO `tplmark` VALUES ('36', '分享数', 'posts_share_count', 'article', 'single', '{qkcms:posts_share_count}', '分享数', '', '10');
INSERT INTO `tplmark` VALUES ('37', '点赞数', 'posts_like_count', 'article', 'single', '{qkcms:posts_like_count}', '点赞数', '', '11');
INSERT INTO `tplmark` VALUES ('38', '举报数', 'posts_report_count', 'article', 'single', '{qkcms:posts_report_count}', '举报数', '', '12');
INSERT INTO `tplmark` VALUES ('39', '文章浏览量', 'posts_views', 'article', 'single', '{qkcms:posts_views}', '文章浏览量', '', '13');
INSERT INTO `tplmark` VALUES ('40', '发布日期', 'posts_created', 'article', 'single', '{qkcms:posts_created}', '发布日期', '', '14');
INSERT INTO `tplmark` VALUES ('41', '所属分类', 'posts_category', 'article', 'single', '{qkcms:posts_category}', '所属分类', '', '15');
INSERT INTO `tplmark` VALUES ('42', '分类URL', 'posts_category_url', 'article', 'single', '{qkcms:posts_category_url}', '分类URL', '', '16');
INSERT INTO `tplmark` VALUES ('43', '文章属性', 'posts_property', 'article', 'single', '{qkcms:posts_property}', '文章属性', '', '17');
INSERT INTO `tplmark` VALUES ('44', '文章作者', 'posts_author', 'article', 'single', '{qkcms:posts_author}', '文章作者', '', '18');
INSERT INTO `tplmark` VALUES ('45', '文章作者ID', 'posts_author_id', 'article', 'single', '{qkcms:posts_author_id}', '文章作者ID', '', '19');
INSERT INTO `tplmark` VALUES ('46', '作者头像', 'posts_author_avatar', 'article', 'single', '{qkcms:posts_author_avatar}', '作者头像', '', '20');
INSERT INTO `tplmark` VALUES ('47', '工具文件URL', 'posts_tool_url', 'article', 'single', '{qkcms:posts_tool_url}', '工具文件URL', '', '21');
INSERT INTO `tplmark` VALUES ('48', '工具开关', 'posts_status_switch', 'article', 'single', '{qkcms:posts_status_switch}', '工具开关状态', '', '22');
INSERT INTO `tplmark` VALUES ('49', '工具售价', 'posts_price', 'article', 'single', '{qkcms:posts_price}', '工具售价', '', '23');
INSERT INTO `tplmark` VALUES ('50', '跳转地址', 'posts_redirect_url', 'article', 'single', '{qkcms:posts_redirect_url}', '跳转地址', '', '24');
INSERT INTO `tplmark` VALUES ('51', '栏目ID', 'category_id', 'category', 'single', '{qkcms:category_id}', '《栏目ID》标签说明：单值标签，用于输出栏目ID内容', '', '3');
INSERT INTO `tplmark` VALUES ('52', '栏目名称', 'cat_name', 'category', 'single', '{qkcms:cat_name}', '《栏目名称》标签说明：单值标签，用于输出栏目名称内容', '', '1');
INSERT INTO `tplmark` VALUES ('53', '栏目描述', 'cat_description', 'category', 'single', '{qkcms:cat_description}', '《栏目描述》标签说明：单值标签，用于输出栏目描述内容', '', '4');
INSERT INTO `tplmark` VALUES ('54', '栏目关键词', 'cat_keywords', 'category', 'single', '{qkcms:cat_keywords}', '《栏目关键词》标签说明：单值标签，用于输出栏目关键词内容', '', '6');
INSERT INTO `tplmark` VALUES ('55', '栏目文章数', 'cat_posts', 'category', 'single', '{qkcms:cat_posts}', '《栏目文章数》标签说明：单值标签，用于输出栏目文章数内容', '', '8');
INSERT INTO `tplmark` VALUES ('56', '栏目缩略图', 'cat_thumbnail', 'category', 'single', '{qkcms:cat_thumbnail}', '《栏目缩略图》标签说明：单值标签，用于输出栏目缩略图内容', '', '9');
INSERT INTO `tplmark` VALUES ('57', '栏目链接', 'cat_url', 'category', 'single', '{qkcms:cat_url}', '《栏目链接》标签说明：单值标签，用于输出栏目链接内容', '', '5');
INSERT INTO `tplmark` VALUES ('58', '文章列表', 'articles', 'loop', 'loop', '{qkcms:articles row=5 col=2 property=0 order=comment titlelen=40 description_len=100 tag=\"1,TAG词\"}\r\n<img src=\"{thumbnail}\" alt=\"{title}\" />\r\n<h4><a href=\"{url}\">{title_id} {title}</a></h4>\r\n<span>作者ID: {author_id}</span>\r\n<span>作者账号: {author}</span>\r\n<span>作者等级: {author_level}</span>\r\n<span>作者头像<img src=\"{author_avatar}\" alt=\"{title}\" /> \r\n<span>时间: {date}</span>\r\n<span>浏览: {views}</span> \r\n<span>评论: {comments}</span>\r\n<span>点赞: {like_count}</span> \r\n<span>分类:<a href=\"{cat_url}\"> {category}</a></span>\r\n<p>描述: {description}</p>\r\n<p>关键词: {keywords}</p>\r\n<p>根据逗号分词+自动加链接的关键词: {keywords_links}</p>\r\n{/qkcms:articles}', '文章列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">col=2 列数</span><span class=\"generator-param-tag\">order=comment 排序（latest按发布时间 &nbsp  updated按更新时间 &nbsp  comment按评论量  &nbsp hot按浏览量  &nbsp keywords按第一个关键词）</span><span class=\"generator-param-tag\">category_id=0或者不写表示调用当前栏目  参数category_id=-1表示全站 category_id=某个栏目的ID 表示调用指定栏目下的文章\r\n   \r\n</span><span class=\"generator-param-tag\">titlelen=40 标题长度</span><span class=\"generator-param-tag\">description_len=100 描述长度</span><span class=\"generator-param-tag\">property=属性ID 属性筛选（<?php\r\n$properties = getArticleProperties();\r\n$prop_desc = [];\r\nforeach ($properties as $prop_id => $prop) {\r\n    $prop_desc[] = $prop_id . \'=\' . $prop[\'name\'];\r\n}\r\necho implode(\' &nbsp; \', $prop_desc);\r\n?>）</span><span class=\"generator-param-tag\">tag=\"1,TAG词\"  注意需要有双引号（匹配文章标题、描述、所有关键词）tag=\"2,TAG词\"（获取当前文章第一个关键词，去匹配其他文章关键词 也支持直接写固定的关键词匹配）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div class=\"generator-tags-container\"><span class=\"generator-sub-tag\">{thumbnail} 缩略图</span><span class=\"generator-sub-tag\">{title_id} 序号</span><span class=\"generator-sub-tag\">{title} 标题</span><span class=\"generator-sub-tag\">{url} 链接</span><span class=\"generator-sub-tag\">{author} 作者账号</span><span class=\"generator-sub-tag\">{author_level} 作者等级</span><span class=\"generator-sub-tag\">{author_avatar} 作者头像</span><span class=\"generator-sub-tag\">\r\n1{date} 时间格式1 &nbsp&nbsp2{date_only} &nbsp&nbsp 3{date_mo} &nbsp&nbsp 4{date_dy}</span><span class=\"generator-sub-tag\">{views} 浏览</span><span class=\"generator-sub-tag\">{comments} 评论</span><span class=\"generator-sub-tag\">{like_count} 点赞量</span><span class=\"generator-sub-tag\">{category} 分类</span><span class=\"generator-sub-tag\">{cat_url} 分类连接</span><span class=\"generator-sub-tag\">{description} 描述</span><span class=\"generator-sub-tag\">{keywords} 关键词</span><span class=\"generator-sub-tag\">{property} 文章属性名称</span></div></div></div>', '1');
INSERT INTO `tplmark` VALUES ('59', '子栏目列表', 'categories', 'loop', 'loop', '{qkcms:categories row=5 parent_id=-1 sa=1 sort=1 page=1}\r\n<img src=\"{thumbnail}\" alt=\"{name}\" />\r\n<h4><a href=\"{url}\">{name}</a> <span>({count})</span></h4>\r\n<p>描述: {description}</p>\r\n<p>关键词: {keywords}</p>\r\n{/qkcms:categories}', '分类列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数 </span>\r\n								\r\n<span class=\"generator-param-tag\">parent_id=-1 分类ID</span>\r\n<span class=\"generator-param-tag\">sa=-1 (sa=1 显示所有分类 sa=2 &nbsp只显示已开启的分类)</span>\r\n<span class=\"generator-param-tag\">sort=1排序&nbsp sort=1最新时间&nbsp sort=2最老时间&nbsp sort=3按分类文章数&nbsp sort=4随机数)</span>\r\n<span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对分类列表进行分页处理</span>\r\n</div>\r\n</div>\r\n\r\n<div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-sub-tag\">{name} 分类名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 文章数量</span><span class=\"generator-template-tag\">{thumbnail} 分类缩略图</span><span class=\"generator-template-tag\">{description} 描述</span><span class=\"generator-template-tag\">{keywords} 关键词</span></div></div></div>', '2');
INSERT INTO `tplmark` VALUES ('60', '评论循环标签', 'comments', 'loop', 'loop', '{qkcms:comments row=5 order=1 date_format=1 article_id=2 allow_html=1}\n<img src=\"{avatar}\" alt=\"{author}\" />\n<a href=\"/Member_id{author_id}.php\">{author}[{user_level}]</a>\n<span>时间: {date}</span>\n<p>编号{comment_id} 主评论内容：{content}</p>\n\n{reply_comment row=5 reply.date=1}\n回复ID {reply.id} \n回复楼层号 {reply.reply_id}\n回复者头像  {reply.avatar}\n回复者账号 {reply.author}\n回复者账号ID {reply.user_id}\n回复者等级 {user_reply.level}\n\n回复时间  {reply.date}\n回复内容  {reply.content}\n回复内容点赞数  {reply.like_count}\n被回复者用户名  {reply.reply_to}\n{/reply_comment}\n\n点赞数{like_count}\n举报数{report_count}\n{/qkcms:comments}', '评论循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数） </span><span class=\"generator-param-tag\">order=1排序（1最新评论-默认   &nbsp 2最早评论   &nbsp 3最热评论） </span><span class=\"generator-param-tag\">date_format=1时间格式（1如49分钟前  &nbsp  2如2025-5-5） </span><span class=\"generator-param-tag\">article_id=1（1调用全站评论   &nbsp 2调用当前文章评论）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{author} 作者</span><span class=\"generator-template-tag\">{author_id} 主评论作者ID</span><span class=\"generator-template-tag\">{user_level} 作者等级</span><span class=\"generator-template-tag\">{date} 时间</span><span class=\"generator-template-tag\">{content} 评论内容</span><span class=\"generator-template-tag\">{article_url} 文章链接</span><span class=\"generator-template-tag\">{article_title} 文章标题</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{comment_id} 父评论ID</span><span class=\"generator-template-tag\">{user_level} 用户等级</span><span class=\"generator-template-tag\">{allow_html=1} 评论内容支持html 参数=0不支持html格式）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 回复条数限制，默认显示5条回复</span><span class=\"generator-param-tag\">reply.date=1 回复时间格式（1如49分钟前  &nbsp 2如2025-5-5）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签</h5><p style=\"margin:10px 0;\">使用 {reply_comment row=5 reply.date=1} 和 {/reply_comment} 标签包裹嵌套回复内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{reply.id} 回复ID</span><span class=\"generator-template-tag\">{reply.reply_id} 回复楼层号</span><span class=\"generator-template-tag\">{reply.avatar} 回复者头像</span><span class=\"generator-template-tag\">{reply.author} 回复者账号</span><span class=\"generator-template-tag\">{reply.user_id} 回复者账号ID</span><span class=\"generator-template-tag\">{reply.level} 回复者等级</span><span class=\"generator-template-tag\">{reply.date} 回复时间</span><span class=\"generator-template-tag\">{reply.content} 回复内容</span><span class=\"generator-template-tag\">{reply.like_count} 回复内容点赞数</span><span class=\"generator-template-tag\">{reply.reply_to} 被回复者用户名</span></div></div></div>', '3');
INSERT INTO `tplmark` VALUES ('61', '用户列表', 'members', 'loop', 'loop', '{qkcms:members row=5 type=1}\n<a href=\"{user_center_url}\"><img src=\"{avatar}\" alt=\"{username}\" /></a>\n用户名：{username}\n用户等级：{level}\n<span>用户点赞数：{like_count}</span>\n<span>用户举报数：{report_count}</span>\n<span>用户文章数：{post_count}</span>\n{/qkcms:members}', '用户列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">type=1 用户类型（1 最新注册用户&nbsp 2 最近登录的用户 &nbsp3 随机调用全站用户 &nbsp4 最近访问文章的用户）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{username} 用户名</span><span class=\"generator-template-tag\">{username} 用户等级 {level}</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{post_count} 文章数</span><span class=\"generator-template-tag\">{user_center_url} 用户主页链接</span></div></div></div>', '4');
INSERT INTO `tplmark` VALUES ('62', '关键词', 'tags', 'loop', 'loop', '{qkcms:tags row=5 order=1}\n<a href=\"{url}\">{name}({count})</a>\n{/qkcms:tags}', '关键词循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序 (order=1时间 order=2调用次数 order=3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{name} 标签名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 使用次数</span></div></div></div>', '5');
INSERT INTO `tplmark` VALUES ('63', '导航列表', 'navigation', 'loop', 'loop', '{qkcms:navigation row=5}\n<a href=\"{url}\" target=\"{target}\">{title}</a>\n{sub_navigation}\n<a href=\"{sub.url}\" target=\"{sub.target}\">{sub.title}</a>\n{/sub_navigation}\n{/qkcms:navigation}', '导航列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{target} 目标窗口</span><span class=\"generator-template-tag\">{title} 导航标题</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">二级导航嵌套标签</h5><p style=\"margin:10px 0;\">使用 {sub_navigation} 和 {/sub_navigation} 标签包裹二级导航内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{sub.id} 二级导航ID</span><span class=\"generator-template-tag\">{sub.title} 二级导航标题</span><span class=\"generator-template-tag\">{sub.url} 二级导航链接</span><span class=\"generator-template-tag\">{sub.target} 二级导航目标窗口</span><span class=\"generator-template-tag\">{sub.display_order} 二级导航排序</span><span class=\"generator-template-tag\">{sub.sub_id} 二级导航序号</span></div></div></div>', '6');
INSERT INTO `tplmark` VALUES ('64', '分页循环标签', 'page', 'loop', 'loop', '{qkcms:page type=1 page=1}\n {first_page}     - 首页链接\n {prev_page}      - 上一页链接\n {page_numbers}   - 数字页码链接（1 2 3 4 5）\n {next_page}      - 下一页链接\n {last_page}      - 尾页链接\n {page_status}    - 页码信息（第X页/共X页）\n {jump_to_page}   - 页码跳转下拉框\n{/qkcms:page}', '分页循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出分页导航</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=1 类型（1 文章列表分页 2 评论列表分页 3分类列表分页 4商品分页）</span><span class=\"generator-param-tag\">page=1 分页绑定标识</span><span class=\"generator-param-tag\">row 继承文章或评论列表配置</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{first_page} 首页链接</span><span class=\"generator-template-tag\">{prev_page} 上一页链接</span><span class=\"generator-template-tag\">{page_numbers} 数字页码链接</span><span class=\"generator-template-tag\">{next_page} 下一页链接</span><span class=\"generator-template-tag\">{last_page} 尾页链接</span><span class=\"generator-template-tag\">{page_status} 页码信息</span><span class=\"generator-template-tag\">{jump_to_page} 页码跳转下拉框</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">功能说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">支持首页/上一页/下一页/尾页链接</span><span class=\"generator-template-tag\">支持页码跳转功能</span><span class=\"generator-template-tag\">自动适应文章列表和评论列表</span><span class=\"generator-template-tag\">文章或评论循环标签也必须添加page=1参数才能绑定</span></div></div></div>', '7');
INSERT INTO `tplmark` VALUES ('65', '搜索词列表', 'search', 'loop', 'loop', '{qkcms:search row=5 order=1} \n <span>搜索词ID {id}</span>\n <span>搜索者 {username}</span>\n <span>搜索词 {search_term}</span>\n <span>搜索时间 {search_time}</span>\n <span>搜索词统计数 {count}</span>\n {/qkcms:search}', '搜索词列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序（1最新搜索 2最多搜索 3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{id} 搜索词ID</span><span class=\"generator-template-tag\">{username} 搜索者</span><span class=\"generator-template-tag\">{search_term} 搜索词</span><span class=\"generator-template-tag\">{search_time} 搜索时间</span><span class=\"generator-template-tag\">{count} 搜索词统计数</span></div></div></div>', '8');
INSERT INTO `tplmark` VALUES ('66', '友情链接列表', 'friendlink', 'loop', 'loop', '{qkcms:friendlink row=5} \n <a href=\"{url}\" >{title}</a>\n {/qkcms:friendlink}', '友情链接列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{title} 标题</span></div></div></div>', '9');
INSERT INTO `tplmark` VALUES ('67', '商品分类ID', 'goods_category_id', 'goods', 'single', '{qkcms:goods_category_id}', '商品分类ID', '', null);
INSERT INTO `tplmark` VALUES ('68', '商品分类', 'goods_category_name', 'goods', 'single', '{qkcms:goods_category_name}', '商品分类', '', null);
INSERT INTO `tplmark` VALUES ('69', '分类关键词', 'cat_keywords', 'goods', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('70', '分类描述', 'cat_description', 'goods', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('71', '分类URL', 'cat_url', 'goods', 'single', '{qkcms:cat_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('72', '商品ID', 'goods_id', 'goods', 'single', '{qkcms:goods_id}', '商品ID', '', null);
INSERT INTO `tplmark` VALUES ('73', '商品标题', 'goods_title', 'goods', 'single', '{qkcms:goods_title}', '商品标题', '', null);
INSERT INTO `tplmark` VALUES ('74', '商品关键词', 'goods_keywords', 'goods', 'single', '{qkcms:goods_keywords}', '商品关键词', '', null);
INSERT INTO `tplmark` VALUES ('75', '商品描述', 'goods_description', 'goods', 'single', '{qkcms:goods_description}', '商品描述', '', null);
INSERT INTO `tplmark` VALUES ('76', '商品详情', 'goods_content', 'goods', 'single', '{qkcms:goods_content}', '商品详情', '', null);
INSERT INTO `tplmark` VALUES ('77', '商品价格', 'goods_price', 'goods', 'single', '{qkcms:goods_price}', '商品价格', '', null);
INSERT INTO `tplmark` VALUES ('78', '商品销量', 'goods_sales', 'goods', 'single', '{qkcms:goods_sales}', '商品销量', '', null);
INSERT INTO `tplmark` VALUES ('79', '商品库存', 'goods_stock', 'goods', 'single', '{qkcms:goods_stock}', '商品库存', '', null);
INSERT INTO `tplmark` VALUES ('80', '商品状态', 'goods_status', 'goods', 'single', '{qkcms:goods_status}', '商品状态', '', null);
INSERT INTO `tplmark` VALUES ('81', '创建时间', 'goods_created_at', 'goods', 'single', '{qkcms:goods_created_at}', '创建时间', '', null);
INSERT INTO `tplmark` VALUES ('82', '更新时间', 'goods_updated_at', 'goods', 'single', '{qkcms:goods_updated_at}', '更新时间', '', null);
INSERT INTO `tplmark` VALUES ('83', '商品缩略图', 'goods_thumbnail', 'goods', 'single', '{qkcms:goods_thumbnail}', '商品缩略图', '', null);
INSERT INTO `tplmark` VALUES ('84', '商品链接', 'goods_url', 'goods', 'single', '{qkcms:goods_url}', '商品链接', '', null);
INSERT INTO `tplmark` VALUES ('85', '商品规格', 'goods_specs', 'goods', 'single', '{qkcms:goods_specs}', '商品规格', '', null);
INSERT INTO `tplmark` VALUES ('86', '商品视频URL', 'goods_mp4url', 'goods', 'single', '{qkcms:goods_mp4url}', '商品视频URL', '', null);
INSERT INTO `tplmark` VALUES ('87', '商品图片循环', 'goods_images', 'goods', 'loop', '{qkcms:goods_images type=specs}\n<img src=\"{image.url}\" alt=\"{image.title}\">\n{/qkcms:goods_images}', '商品图片循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=specs 类型（specs规格图 images商品图）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{image.url} 图片URL</span><span class=\"generator-template-tag\">{image.title} 图片标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('88', '商品列表循环', 'goods', 'goods', 'loop', '{qkcms:goods row=8 type=new where=status=1}\n<span>分类关键词: {qkcms:cat_keywords}</span>\n<span>分类描述: {qkcms:cat_description}</span>\n<span>分类URL: {qkcms:cat_url}</span>\n<img src=\"{goods.thumbnail}\" alt=\"{goods.title}\">\n<h4><a href=\"{goods.url}\">{goods.title}</a></h4>\n<span>商品链接: {goods.url}</span>\n<span>商品规格: {goods.specs}</span>\n<span>视频URL: {goods.mp4url}</span>\n<span>ID: {goods.id}</span>\n<span>价格: ¥{goods.price}</span>\n<span>销量: {goods.sales}</span>\n<span>库存: {goods.stock}</span>\n<span>分类ID: {goods.category_id}</span>\n<span>分类: <a href=\"{goods.category_url}\">{goods.category_name}</a></span>\n<span>创建时间: {goods.create_time}</span>\n<span>更新时间: {goods.update_time}</span>\n{/qkcms:goods}', '商品列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=8 条数</span><span class=\"generator-param-tag\">type=new 类型（new最新 hot热门 recommend推荐）</span><span class=\"generator-param-tag\">where=status=1 条件筛选（status=1上架 status=0下架）</span><span class=\"generator-param-tag\">category_id 分类ID</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{goods.id} 商品ID</span><span class=\"generator-template-tag\">{goods.title} 商品标题</span><span class=\"generator-template-tag\">{goods.url} 商品链接</span><span class=\"generator-template-tag\">{goods.thumbnail} 商品缩略图</span><span class=\"generator-template-tag\">{goods.price} 商品价格</span><span class=\"generator-template-tag\">{goods.sales} 商品销量</span><span class=\"generator-template-tag\">{goods.stock} 商品库存</span><span class=\"generator-template-tag\">{goods.specs} 商品规格</span><span class=\"generator-template-tag\">{goods.mp4url} 商品视频URL</span><span class=\"generator-template-tag\">{goods.category_id} 分类ID</span><span class=\"generator-template-tag\">{goods.category_name} 分类名称</span><span class=\"generator-template-tag\">{goods.category_url} 分类链接</span><span class=\"generator-template-tag\">{goods.create_time} 创建时间</span><span class=\"generator-template-tag\">{goods.update_time} 更新时间</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('89', '调用头部模板', 'head.html', 'site', 'single', '{qkcms:head.html}', '调用头部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('90', '调用尾部模板', 'footer.html', 'site', 'single', '{qkcms:footer.html}', '调用尾部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('91', '调用评论模块', 'comment.php', 'site', 'single', '{qkcms:comment.php}', '调用评论模块', '', null);
INSERT INTO `tplmark` VALUES ('92', '网站名称', 'site_name', 'site', 'single', '{qkcms:site_name}', '网站名称', '', null);
INSERT INTO `tplmark` VALUES ('93', '站点标题', 'site_title', 'site', 'single', '{qkcms:site_title}', '站点标题', '', null);
INSERT INTO `tplmark` VALUES ('94', '站点描述', 'site_description', 'site', 'single', '{qkcms:site_description}', '站点描述', '', null);
INSERT INTO `tplmark` VALUES ('95', '站点关键词', 'site_keywords', 'site', 'single', '{qkcms:site_keywords}', '站点关键词', '', null);
INSERT INTO `tplmark` VALUES ('96', '页脚信息', 'site_copyright', 'site', 'single', '{qkcms:site_copyright}', '页脚信息', '', null);
INSERT INTO `tplmark` VALUES ('97', '网站违禁词', 'site_Prohw', 'site', 'single', '{qkcms:site_Prohw}', '网站违禁词', '', null);
INSERT INTO `tplmark` VALUES ('98', '当前位置', 'current_position', 'site', 'single', '{qkcms:current_position}', '当前位置', '', null);
INSERT INTO `tplmark` VALUES ('99', '总评论数', 'total_comments', 'site', 'single', '{qkcms:total_comments}', '总评论数', '', null);
INSERT INTO `tplmark` VALUES ('100', '关键词总数', 'total_keywords', 'site', 'single', '{qkcms:total_keywords}', '关键词总数', '', null);
INSERT INTO `tplmark` VALUES ('101', '分类总数', 'total_categories', 'site', 'single', '{qkcms:total_categories}', '分类总数', '', null);
INSERT INTO `tplmark` VALUES ('102', '总会员数', 'total_members', 'site', 'single', '{qkcms:total_members}', '总会员数', '', null);
INSERT INTO `tplmark` VALUES ('103', '举报总数', 'total_reports', 'site', 'single', '{qkcms:total_reports}', '举报总数', '', null);
INSERT INTO `tplmark` VALUES ('104', '总文章数', 'total_posts', 'site', 'single', '{qkcms:total_posts}', '总文章数', '', null);
INSERT INTO `tplmark` VALUES ('105', '总订单数', 'total_order', 'site', 'single', '{qkcms:total_order}', '总订单数', '', null);
INSERT INTO `tplmark` VALUES ('106', '搜索词匹配数量', 'total_search', 'site', 'single', '{qkcms:total_search}', '搜索词匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('107', 'TAG匹配数量', 'total_tag', 'site', 'single', '{qkcms:total_tag}', 'TAG匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('108', '网站累计访问量', 'total_visit', 'site', 'single', '{qkcms:total_visit}', '网站累计访问量', '', null);
INSERT INTO `tplmark` VALUES ('109', '当前账号ID', 'user_id', 'site', 'single', '{qkcms:user_id}', '当前账号ID', '', null);
INSERT INTO `tplmark` VALUES ('110', '当前账号', 'user_nickname', 'site', 'single', '{qkcms:user_nickname}', '当前账号', '', null);
INSERT INTO `tplmark` VALUES ('111', '当前用户头像', 'user_avatar', 'site', 'single', '{qkcms:user_avatar}', '当前用户头像', '', null);
INSERT INTO `tplmark` VALUES ('112', '当前用户等级', 'user_levels', 'site', 'single', '{qkcms:user_levels}', '当前用户等级', '', null);
INSERT INTO `tplmark` VALUES ('113', '当前账号状态', 'user_status', 'site', 'single', '{qkcms:user_status}', '当前账号状态', '', null);
INSERT INTO `tplmark` VALUES ('114', '当前账号积分', 'user_points', 'site', 'single', '{qkcms:user_points}', '当前账号积分', '', null);
INSERT INTO `tplmark` VALUES ('115', '注册时间', 'user_created_at', 'site', 'single', '{qkcms:user_created_at}', '注册时间', '', null);
INSERT INTO `tplmark` VALUES ('116', '文章ID', 'posts_id', 'article', 'single', '{qkcms:posts_id}', '文章ID', '', null);
INSERT INTO `tplmark` VALUES ('117', '文章标题', 'posts_title', 'article', 'single', '{qkcms:posts_title}', '文章标题', '', null);
INSERT INTO `tplmark` VALUES ('118', '文章URL', 'posts_url', 'article', 'single', '{qkcms:posts_url}', '文章URL', '', null);
INSERT INTO `tplmark` VALUES ('119', '文章内容', 'posts_content', 'article', 'single', '{qkcms:posts_content}', '文章内容', '', null);
INSERT INTO `tplmark` VALUES ('120', '文章关键词', 'posts_keywords', 'article', 'single', '{qkcms:posts_keywords}', '文章关键词', '', null);
INSERT INTO `tplmark` VALUES ('121', '文章缩略图', 'posts_thumbnail', 'article', 'single', '{qkcms:posts_thumbnail}', '文章缩略图', '', null);
INSERT INTO `tplmark` VALUES ('122', '文章描述', 'posts_description', 'article', 'single', '{qkcms:posts_description}', '文章描述', '', null);
INSERT INTO `tplmark` VALUES ('123', '文章评论数', 'posts_comments', 'article', 'single', '{qkcms:posts_comments}', '文章评论数', '', null);
INSERT INTO `tplmark` VALUES ('124', '分享数', 'posts_share_count', 'article', 'single', '{qkcms:posts_share_count}', '分享数', '', null);
INSERT INTO `tplmark` VALUES ('125', '点赞数', 'posts_like_count', 'article', 'single', '{qkcms:posts_like_count}', '点赞数', '', null);
INSERT INTO `tplmark` VALUES ('126', '举报数', 'posts_report_count', 'article', 'single', '{qkcms:posts_report_count}', '举报数', '', null);
INSERT INTO `tplmark` VALUES ('127', '文章浏览量', 'posts_views', 'article', 'single', '{qkcms:posts_views}', '文章浏览量', '', null);
INSERT INTO `tplmark` VALUES ('128', '发布日期', 'posts_created', 'article', 'single', '{qkcms:posts_created}', '发布日期', '', null);
INSERT INTO `tplmark` VALUES ('129', '所属分类', 'posts_category', 'article', 'single', '{qkcms:posts_category}', '所属分类', '', null);
INSERT INTO `tplmark` VALUES ('130', '分类URL', 'posts_category_url', 'article', 'single', '{qkcms:posts_category_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('131', '文章属性', 'posts_property', 'article', 'single', '{qkcms:posts_property}', '文章属性', '', null);
INSERT INTO `tplmark` VALUES ('132', '文章作者', 'posts_author', 'article', 'single', '{qkcms:posts_author}', '文章作者', '', null);
INSERT INTO `tplmark` VALUES ('133', '文章作者ID', 'posts_author_id', 'article', 'single', '{qkcms:posts_author_id}', '文章作者ID', '', null);
INSERT INTO `tplmark` VALUES ('134', '作者头像', 'posts_author_avatar', 'article', 'single', '{qkcms:posts_author_avatar}', '作者头像', '', null);
INSERT INTO `tplmark` VALUES ('135', '工具文件URL', 'posts_tool_url', 'article', 'single', '{qkcms:posts_tool_url}', '工具文件URL', '', null);
INSERT INTO `tplmark` VALUES ('136', '工具开关状态', 'posts_status_switch', 'article', 'single', '{qkcms:posts_status_switch}', '工具开关状态', '', null);
INSERT INTO `tplmark` VALUES ('137', '工具售价', 'posts_price', 'article', 'single', '{qkcms:posts_price}', '工具售价', '', null);
INSERT INTO `tplmark` VALUES ('138', '跳转地址', 'posts_redirect_url', 'article', 'single', '{qkcms:posts_redirect_url}', '跳转地址', '', null);
INSERT INTO `tplmark` VALUES ('139', '分类ID', 'category_id', 'category', 'single', '{qkcms:category_id}', '分类ID', '', null);
INSERT INTO `tplmark` VALUES ('140', '分类名称', 'cat_name', 'category', 'single', '{qkcms:cat_name}', '分类名称', '', null);
INSERT INTO `tplmark` VALUES ('141', '分类描述', 'cat_description', 'category', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('142', '分类关键词', 'cat_keywords', 'category', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('143', '分类文章数', 'cat_posts', 'category', 'single', '{qkcms:cat_posts}', '分类文章数', '', null);
INSERT INTO `tplmark` VALUES ('144', '分类缩略图', 'cat_thumbnail', 'category', 'single', '{qkcms:cat_thumbnail}', '分类缩略图', '', null);
INSERT INTO `tplmark` VALUES ('145', '分类连接', 'cat_url', 'category', 'single', '{qkcms:cat_url}', '分类连接', '', null);
INSERT INTO `tplmark` VALUES ('146', '文章列表', 'articles', 'loop', 'loop', '{qkcms:articles row=5 col=2 property=0 order=comment titlelen=40 description_len=100 tag=\"1,TAG词\"}\n<img src=\"{thumbnail}\" alt=\"{title}\" />\n<h4><a href=\"{url}\">{title_id} {title}</a></h4>\n<span>作者ID: {author_id}</span>\n<span>作者账号: {author}</span>\n<span>作者等级: {author_level}</span>\n<span>作者头像<img src=\"{author_avatar}\" alt=\"{title}\" /> \n<span>时间: {date}</span>\n<span>浏览: {views}</span> \n<span>评论: {comments}</span>\n<span>点赞: {like_count}</span> \n<span>分类:<a href=\"{cat_url}\"> {category}</a></span>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:articles}', '文章列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">col=2 列数</span><span class=\"generator-param-tag\">order=comment 排序（latest按发布时间 &nbsp  updated按更新时间 &nbsp  comment按评论量  &nbsp hot按浏览量  &nbsp keywords按第一个关键词）</span><span class=\"generator-param-tag\">category_id=0或者不写表示调用当前栏目  参数category_id=-1表示全站 category_id=某个栏目的ID 表示调用指定栏目下的文章\n   \n</span><span class=\"generator-param-tag\">titlelen=40 标题长度</span><span class=\"generator-param-tag\">description_len=100 描述长度</span><span class=\"generator-param-tag\">property=属性ID 属性筛选（<?php\n$properties = getArticleProperties();\n$prop_desc = [];\nforeach ($properties as $prop_id => $prop) {\n    $prop_desc[] = $prop_id . \'=\' . $prop[\'name\'];\n}\necho implode(\' &nbsp; \', $prop_desc);\n?>）</span><span class=\"generator-param-tag\">tag=\"1,TAG词\"  注意需要有双引号（匹配文章标题、描述、所有关键词）tag=\"2,TAG词\"（获取当前文章第一个关键词，去匹配其他文章关键词 也支持直接写固定的关键词匹配）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div class=\"generator-tags-container\"><span class=\"generator-sub-tag\">{thumbnail} 缩略图</span><span class=\"generator-sub-tag\">{title_id} 序号</span><span class=\"generator-sub-tag\">{title} 标题</span><span class=\"generator-sub-tag\">{url} 链接</span><span class=\"generator-sub-tag\">{author} 作者账号</span><span class=\"generator-sub-tag\">{author_level} 作者等级</span><span class=\"generator-sub-tag\">{author_avatar} 作者头像</span><span class=\"generator-sub-tag\">\n1{date} 时间格式1 &nbsp&nbsp2{date_only} &nbsp&nbsp 3{date_mo} &nbsp&nbsp 4{date_dy}</span><span class=\"generator-sub-tag\">{views} 浏览</span><span class=\"generator-sub-tag\">{comments} 评论</span><span class=\"generator-sub-tag\">{like_count} 点赞量</span><span class=\"generator-sub-tag\">{category} 分类</span><span class=\"generator-sub-tag\">{cat_url} 分类连接</span><span class=\"generator-sub-tag\">{description} 描述</span><span class=\"generator-sub-tag\">{keywords} 关键词</span><span class=\"generator-sub-tag\">{property} 文章属性名称</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('147', '分类列表', 'categories', 'loop', 'loop', '{qkcms:categories row=5 parent_id=-1 sa==1 sort=1 page=1}\n<img src=\"{thumbnail}\" alt=\"{name}\" />\n<h4><a href=\"{url}\">{name}</a> <span>({count})</span></h4>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:categories}', '分类列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数 </span>\n								\n<span class=\"generator-param-tag\">parent_id=-1 分类ID</span>\n<span class=\"generator-param-tag\">sa=-1 (sa=1 显示所有分类 sa=2 &nbsp只显示已开启的分类)</span>\n<span class=\"generator-param-tag\">sort=1排序&nbsp sort=1最新时间&nbsp sort=2最老时间&nbsp sort=3按分类文章数&nbsp sort=4随机数)</span>\n<span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对分类列表进行分页处理</span>\n</div>\n</div>\n\n<div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-sub-tag\">{name} 分类名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 文章数量</span><span class=\"generator-template-tag\">{thumbnail} 分类缩略图</span><span class=\"generator-template-tag\">{description} 描述</span><span class=\"generator-template-tag\">{keywords} 关键词</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('148', '评论循环标签', 'comments', 'loop', 'loop', '{qkcms:comments row=5 order=1 date_format=1 article_id=2 allow_html=1}\n<img src=\"{avatar}\" alt=\"{author}\" />\n<a href=\"/Member_id{author_id}.php\">{author}[{user_level}]</a>\n<span>时间: {date}</span>\n<p>编号{comment_id} 主评论内容：{content}</p>\n\n{reply_comment row=5 reply.date=1}\n回复ID {reply.id} \n回复楼层号 {reply.reply_id}\n回复者头像  {reply.avatar}\n回复者账号 {reply.author}\n回复者账号ID {reply.user_id}\n回复者等级 {user_reply.level}\n\n回复时间  {reply.date}\n回复内容  {reply.content}\n回复内容点赞数  {reply.like_count}\n被回复者用户名  {reply.reply_to}\n{/reply_comment}\n\n点赞数{like_count}\n举报数{report_count}\n{/qkcms:comments}', '评论循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数） </span><span class=\"generator-param-tag\">order=1排序（1最新评论-默认   &nbsp 2最早评论   &nbsp 3最热评论） </span><span class=\"generator-param-tag\">date_format=1时间格式（1如49分钟前  &nbsp  2如2025-5-5） </span><span class=\"generator-param-tag\">article_id=1（1调用全站评论   &nbsp 2调用当前文章评论）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{author} 作者</span><span class=\"generator-template-tag\">{author_id} 主评论作者ID</span><span class=\"generator-template-tag\">{user_level} 作者等级</span><span class=\"generator-template-tag\">{date} 时间</span><span class=\"generator-template-tag\">{content} 评论内容</span><span class=\"generator-template-tag\">{article_url} 文章链接</span><span class=\"generator-template-tag\">{article_title} 文章标题</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{comment_id} 父评论ID</span><span class=\"generator-template-tag\">{user_level} 用户等级</span><span class=\"generator-template-tag\">{allow_html=1} 评论内容支持html 参数=0不支持html格式）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 回复条数限制，默认显示5条回复</span><span class=\"generator-param-tag\">reply.date=1 回复时间格式（1如49分钟前  &nbsp 2如2025-5-5）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签</h5><p style=\"margin:10px 0;\">使用 {reply_comment row=5 reply.date=1} 和 {/reply_comment} 标签包裹嵌套回复内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{reply.id} 回复ID</span><span class=\"generator-template-tag\">{reply.reply_id} 回复楼层号</span><span class=\"generator-template-tag\">{reply.avatar} 回复者头像</span><span class=\"generator-template-tag\">{reply.author} 回复者账号</span><span class=\"generator-template-tag\">{reply.user_id} 回复者账号ID</span><span class=\"generator-template-tag\">{reply.level} 回复者等级</span><span class=\"generator-template-tag\">{reply.date} 回复时间</span><span class=\"generator-template-tag\">{reply.content} 回复内容</span><span class=\"generator-template-tag\">{reply.like_count} 回复内容点赞数</span><span class=\"generator-template-tag\">{reply.reply_to} 被回复者用户名</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('149', '用户列表', 'members', 'loop', 'loop', '{qkcms:members row=5 type=1}\n<a href=\"{user_center_url}\"><img src=\"{avatar}\" alt=\"{username}\" /></a>\n用户名：{username}\n用户等级：{level}\n<span>用户点赞数：{like_count}</span>\n<span>用户举报数：{report_count}</span>\n<span>用户文章数：{post_count}</span>\n{/qkcms:members}', '用户列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">type=1 用户类型（1 最新注册用户&nbsp 2 最近登录的用户 &nbsp3 随机调用全站用户 &nbsp4 最近访问文章的用户）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{username} 用户名</span><span class=\"generator-template-tag\">{username} 用户等级 {level}</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{post_count} 文章数</span><span class=\"generator-template-tag\">{user_center_url} 用户主页链接</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('150', '关键词', 'tags', 'loop', 'loop', '{qkcms:tags row=5 order=1}\n<a href=\"{url}\">{name}({count})</a>\n{/qkcms:tags}', '关键词循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序 (order=1时间 order=2调用次数 order=3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{name} 标签名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 使用次数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('151', '导航列表', 'navigation', 'loop', 'loop', '{qkcms:navigation row=5}\n<a href=\"{url}\" target=\"{target}\">{title}</a>\n{sub_navigation}\n<a href=\"{sub.url}\" target=\"{sub.target}\">{sub.title}</a>\n{/sub_navigation}\n{/qkcms:navigation}', '导航列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{target} 目标窗口</span><span class=\"generator-template-tag\">{title} 导航标题</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">二级导航嵌套标签</h5><p style=\"margin:10px 0;\">使用 {sub_navigation} 和 {/sub_navigation} 标签包裹二级导航内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{sub.id} 二级导航ID</span><span class=\"generator-template-tag\">{sub.title} 二级导航标题</span><span class=\"generator-template-tag\">{sub.url} 二级导航链接</span><span class=\"generator-template-tag\">{sub.target} 二级导航目标窗口</span><span class=\"generator-template-tag\">{sub.display_order} 二级导航排序</span><span class=\"generator-template-tag\">{sub.sub_id} 二级导航序号</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('152', '分页循环标签', 'page', 'loop', 'loop', '{qkcms:page type=1 page=1}\n {first_page}     - 首页链接\n {prev_page}      - 上一页链接\n {page_numbers}   - 数字页码链接（1 2 3 4 5）\n {next_page}      - 下一页链接\n {last_page}      - 尾页链接\n {page_status}    - 页码信息（第X页/共X页）\n {jump_to_page}   - 页码跳转下拉框\n{/qkcms:page}', '分页循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出分页导航</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=1 类型（1 文章列表分页 2 评论列表分页 3分类列表分页 4商品分页）</span><span class=\"generator-param-tag\">page=1 分页绑定标识</span><span class=\"generator-param-tag\">row 继承文章或评论列表配置</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{first_page} 首页链接</span><span class=\"generator-template-tag\">{prev_page} 上一页链接</span><span class=\"generator-template-tag\">{page_numbers} 数字页码链接</span><span class=\"generator-template-tag\">{next_page} 下一页链接</span><span class=\"generator-template-tag\">{last_page} 尾页链接</span><span class=\"generator-template-tag\">{page_status} 页码信息</span><span class=\"generator-template-tag\">{jump_to_page} 页码跳转下拉框</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">功能说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">支持首页/上一页/下一页/尾页链接</span><span class=\"generator-template-tag\">支持页码跳转功能</span><span class=\"generator-template-tag\">自动适应文章列表和评论列表</span><span class=\"generator-template-tag\">文章或评论循环标签也必须添加page=1参数才能绑定</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('153', '搜索词列表', 'search', 'loop', 'loop', '{qkcms:search row=5 order=1} \n <span>搜索词ID {id}</span>\n <span>搜索者 {username}</span>\n <span>搜索词 {search_term}</span>\n <span>搜索时间 {search_time}</span>\n <span>搜索词统计数 {count}</span>\n {/qkcms:search}', '搜索词列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序（1最新搜索 2最多搜索 3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{id} 搜索词ID</span><span class=\"generator-template-tag\">{username} 搜索者</span><span class=\"generator-template-tag\">{search_term} 搜索词</span><span class=\"generator-template-tag\">{search_time} 搜索时间</span><span class=\"generator-template-tag\">{count} 搜索词统计数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('154', '友情链接列表', 'friendlink', 'loop', 'loop', '{qkcms:friendlink row=5} \n <a href=\"{url}\" >{title}</a>\n {/qkcms:friendlink}', '友情链接列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{title} 标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('155', '商品分类ID', 'goods_category_id', 'goods', 'single', '{qkcms:goods_category_id}', '商品分类ID', '', null);
INSERT INTO `tplmark` VALUES ('156', '商品分类', 'goods_category_name', 'goods', 'single', '{qkcms:goods_category_name}', '商品分类', '', null);
INSERT INTO `tplmark` VALUES ('157', '分类关键词', 'cat_keywords', 'goods', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('158', '分类描述', 'cat_description', 'goods', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('159', '分类URL', 'cat_url', 'goods', 'single', '{qkcms:cat_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('160', '商品ID', 'goods_id', 'goods', 'single', '{qkcms:goods_id}', '商品ID', '', null);
INSERT INTO `tplmark` VALUES ('161', '商品标题', 'goods_title', 'goods', 'single', '{qkcms:goods_title}', '商品标题', '', null);
INSERT INTO `tplmark` VALUES ('162', '商品关键词', 'goods_keywords', 'goods', 'single', '{qkcms:goods_keywords}', '商品关键词', '', null);
INSERT INTO `tplmark` VALUES ('163', '商品描述', 'goods_description', 'goods', 'single', '{qkcms:goods_description}', '商品描述', '', null);
INSERT INTO `tplmark` VALUES ('164', '商品详情', 'goods_content', 'goods', 'single', '{qkcms:goods_content}', '商品详情', '', null);
INSERT INTO `tplmark` VALUES ('165', '商品价格', 'goods_price', 'goods', 'single', '{qkcms:goods_price}', '商品价格', '', null);
INSERT INTO `tplmark` VALUES ('166', '商品销量', 'goods_sales', 'goods', 'single', '{qkcms:goods_sales}', '商品销量', '', null);
INSERT INTO `tplmark` VALUES ('167', '商品库存', 'goods_stock', 'goods', 'single', '{qkcms:goods_stock}', '商品库存', '', null);
INSERT INTO `tplmark` VALUES ('168', '商品状态', 'goods_status', 'goods', 'single', '{qkcms:goods_status}', '商品状态', '', null);
INSERT INTO `tplmark` VALUES ('169', '创建时间', 'goods_created_at', 'goods', 'single', '{qkcms:goods_created_at}', '创建时间', '', null);
INSERT INTO `tplmark` VALUES ('170', '更新时间', 'goods_updated_at', 'goods', 'single', '{qkcms:goods_updated_at}', '更新时间', '', null);
INSERT INTO `tplmark` VALUES ('171', '商品缩略图', 'goods_thumbnail', 'goods', 'single', '{qkcms:goods_thumbnail}', '商品缩略图', '', null);
INSERT INTO `tplmark` VALUES ('172', '商品链接', 'goods_url', 'goods', 'single', '{qkcms:goods_url}', '商品链接', '', null);
INSERT INTO `tplmark` VALUES ('173', '商品规格', 'goods_specs', 'goods', 'single', '{qkcms:goods_specs}', '商品规格', '', null);
INSERT INTO `tplmark` VALUES ('174', '商品视频URL', 'goods_mp4url', 'goods', 'single', '{qkcms:goods_mp4url}', '商品视频URL', '', null);
INSERT INTO `tplmark` VALUES ('175', '商品图片循环', 'goods_images', 'goods', 'loop', '{qkcms:goods_images type=specs}\n<img src=\"{image.url}\" alt=\"{image.title}\">\n{/qkcms:goods_images}', '商品图片循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=specs 类型（specs规格图 images商品图）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{image.url} 图片URL</span><span class=\"generator-template-tag\">{image.title} 图片标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('176', '商品列表循环', 'goods', 'goods', 'loop', '{qkcms:goods row=8 type=new where=status=1}\n<span>分类关键词: {qkcms:cat_keywords}</span>\n<span>分类描述: {qkcms:cat_description}</span>\n<span>分类URL: {qkcms:cat_url}</span>\n<img src=\"{goods.thumbnail}\" alt=\"{goods.title}\">\n<h4><a href=\"{goods.url}\">{goods.title}</a></h4>\n<span>商品链接: {goods.url}</span>\n<span>商品规格: {goods.specs}</span>\n<span>视频URL: {goods.mp4url}</span>\n<span>ID: {goods.id}</span>\n<span>价格: ¥{goods.price}</span>\n<span>销量: {goods.sales}</span>\n<span>库存: {goods.stock}</span>\n<span>分类ID: {goods.category_id}</span>\n<span>分类: <a href=\"{goods.category_url}\">{goods.category_name}</a></span>\n<span>创建时间: {goods.create_time}</span>\n<span>更新时间: {goods.update_time}</span>\n{/qkcms:goods}', '商品列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=8 条数</span><span class=\"generator-param-tag\">type=new 类型（new最新 hot热门 recommend推荐）</span><span class=\"generator-param-tag\">where=status=1 条件筛选（status=1上架 status=0下架）</span><span class=\"generator-param-tag\">category_id 分类ID</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{goods.id} 商品ID</span><span class=\"generator-template-tag\">{goods.title} 商品标题</span><span class=\"generator-template-tag\">{goods.url} 商品链接</span><span class=\"generator-template-tag\">{goods.thumbnail} 商品缩略图</span><span class=\"generator-template-tag\">{goods.price} 商品价格</span><span class=\"generator-template-tag\">{goods.sales} 商品销量</span><span class=\"generator-template-tag\">{goods.stock} 商品库存</span><span class=\"generator-template-tag\">{goods.specs} 商品规格</span><span class=\"generator-template-tag\">{goods.mp4url} 商品视频URL</span><span class=\"generator-template-tag\">{goods.category_id} 分类ID</span><span class=\"generator-template-tag\">{goods.category_name} 分类名称</span><span class=\"generator-template-tag\">{goods.category_url} 分类链接</span><span class=\"generator-template-tag\">{goods.create_time} 创建时间</span><span class=\"generator-template-tag\">{goods.update_time} 更新时间</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('177', '调用头部模板', 'head.html', 'site', 'single', '{qkcms:head.html}', '调用头部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('178', '调用尾部模板', 'footer.html', 'site', 'single', '{qkcms:footer.html}', '调用尾部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('179', '调用评论模块', 'comment.php', 'site', 'single', '{qkcms:comment.php}', '调用评论模块', '', null);
INSERT INTO `tplmark` VALUES ('180', '网站名称', 'site_name', 'site', 'single', '{qkcms:site_name}', '网站名称', '', null);
INSERT INTO `tplmark` VALUES ('181', '站点标题', 'site_title', 'site', 'single', '{qkcms:site_title}', '站点标题', '', null);
INSERT INTO `tplmark` VALUES ('182', '站点描述', 'site_description', 'site', 'single', '{qkcms:site_description}', '站点描述', '', null);
INSERT INTO `tplmark` VALUES ('183', '站点关键词', 'site_keywords', 'site', 'single', '{qkcms:site_keywords}', '站点关键词', '', null);
INSERT INTO `tplmark` VALUES ('184', '页脚信息', 'site_copyright', 'site', 'single', '{qkcms:site_copyright}', '页脚信息', '', null);
INSERT INTO `tplmark` VALUES ('185', '网站违禁词', 'site_Prohw', 'site', 'single', '{qkcms:site_Prohw}', '网站违禁词', '', null);
INSERT INTO `tplmark` VALUES ('186', '当前位置', 'current_position', 'site', 'single', '{qkcms:current_position}', '当前位置', '', null);
INSERT INTO `tplmark` VALUES ('187', '总评论数', 'total_comments', 'site', 'single', '{qkcms:total_comments}', '总评论数', '', null);
INSERT INTO `tplmark` VALUES ('188', '关键词总数', 'total_keywords', 'site', 'single', '{qkcms:total_keywords}', '关键词总数', '', null);
INSERT INTO `tplmark` VALUES ('189', '分类总数', 'total_categories', 'site', 'single', '{qkcms:total_categories}', '分类总数', '', null);
INSERT INTO `tplmark` VALUES ('190', '总会员数', 'total_members', 'site', 'single', '{qkcms:total_members}', '总会员数', '', null);
INSERT INTO `tplmark` VALUES ('191', '举报总数', 'total_reports', 'site', 'single', '{qkcms:total_reports}', '举报总数', '', null);
INSERT INTO `tplmark` VALUES ('192', '总文章数', 'total_posts', 'site', 'single', '{qkcms:total_posts}', '总文章数', '', null);
INSERT INTO `tplmark` VALUES ('193', '总订单数', 'total_order', 'site', 'single', '{qkcms:total_order}', '总订单数', '', null);
INSERT INTO `tplmark` VALUES ('194', '搜索词匹配数量', 'total_search', 'site', 'single', '{qkcms:total_search}', '搜索词匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('195', 'TAG匹配数量', 'total_tag', 'site', 'single', '{qkcms:total_tag}', 'TAG匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('196', '网站累计访问量', 'total_visit', 'site', 'single', '{qkcms:total_visit}', '网站累计访问量', '', null);
INSERT INTO `tplmark` VALUES ('197', '当前账号ID', 'user_id', 'site', 'single', '{qkcms:user_id}', '当前账号ID', '', null);
INSERT INTO `tplmark` VALUES ('198', '当前账号', 'user_nickname', 'site', 'single', '{qkcms:user_nickname}', '当前账号', '', null);
INSERT INTO `tplmark` VALUES ('199', '当前用户头像', 'user_avatar', 'site', 'single', '{qkcms:user_avatar}', '当前用户头像', '', null);
INSERT INTO `tplmark` VALUES ('200', '当前用户等级', 'user_levels', 'site', 'single', '{qkcms:user_levels}', '当前用户等级', '', null);
INSERT INTO `tplmark` VALUES ('201', '当前账号状态', 'user_status', 'site', 'single', '{qkcms:user_status}', '当前账号状态', '', null);
INSERT INTO `tplmark` VALUES ('202', '当前账号积分', 'user_points', 'site', 'single', '{qkcms:user_points}', '当前账号积分', '', null);
INSERT INTO `tplmark` VALUES ('203', '注册时间', 'user_created_at', 'site', 'single', '{qkcms:user_created_at}', '注册时间', '', null);
INSERT INTO `tplmark` VALUES ('204', '文章ID', 'posts_id', 'article', 'single', '{qkcms:posts_id}', '文章ID', '', null);
INSERT INTO `tplmark` VALUES ('205', '文章标题', 'posts_title', 'article', 'single', '{qkcms:posts_title}', '文章标题', '', null);
INSERT INTO `tplmark` VALUES ('206', '文章URL', 'posts_url', 'article', 'single', '{qkcms:posts_url}', '文章URL', '', null);
INSERT INTO `tplmark` VALUES ('207', '文章内容', 'posts_content', 'article', 'single', '{qkcms:posts_content}', '文章内容', '', null);
INSERT INTO `tplmark` VALUES ('208', '文章关键词', 'posts_keywords', 'article', 'single', '{qkcms:posts_keywords}', '文章关键词', '', null);
INSERT INTO `tplmark` VALUES ('209', '文章缩略图', 'posts_thumbnail', 'article', 'single', '{qkcms:posts_thumbnail}', '文章缩略图', '', null);
INSERT INTO `tplmark` VALUES ('210', '文章描述', 'posts_description', 'article', 'single', '{qkcms:posts_description}', '文章描述', '', null);
INSERT INTO `tplmark` VALUES ('211', '文章评论数', 'posts_comments', 'article', 'single', '{qkcms:posts_comments}', '文章评论数', '', null);
INSERT INTO `tplmark` VALUES ('212', '分享数', 'posts_share_count', 'article', 'single', '{qkcms:posts_share_count}', '分享数', '', null);
INSERT INTO `tplmark` VALUES ('213', '点赞数', 'posts_like_count', 'article', 'single', '{qkcms:posts_like_count}', '点赞数', '', null);
INSERT INTO `tplmark` VALUES ('214', '举报数', 'posts_report_count', 'article', 'single', '{qkcms:posts_report_count}', '举报数', '', null);
INSERT INTO `tplmark` VALUES ('215', '文章浏览量', 'posts_views', 'article', 'single', '{qkcms:posts_views}', '文章浏览量', '', null);
INSERT INTO `tplmark` VALUES ('216', '发布日期', 'posts_created', 'article', 'single', '{qkcms:posts_created}', '发布日期', '', null);
INSERT INTO `tplmark` VALUES ('217', '所属分类', 'posts_category', 'article', 'single', '{qkcms:posts_category}', '所属分类', '', null);
INSERT INTO `tplmark` VALUES ('218', '分类URL', 'posts_category_url', 'article', 'single', '{qkcms:posts_category_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('219', '文章属性', 'posts_property', 'article', 'single', '{qkcms:posts_property}', '文章属性', '', null);
INSERT INTO `tplmark` VALUES ('220', '文章作者', 'posts_author', 'article', 'single', '{qkcms:posts_author}', '文章作者', '', null);
INSERT INTO `tplmark` VALUES ('221', '文章作者ID', 'posts_author_id', 'article', 'single', '{qkcms:posts_author_id}', '文章作者ID', '', null);
INSERT INTO `tplmark` VALUES ('222', '作者头像', 'posts_author_avatar', 'article', 'single', '{qkcms:posts_author_avatar}', '作者头像', '', null);
INSERT INTO `tplmark` VALUES ('223', '工具文件URL', 'posts_tool_url', 'article', 'single', '{qkcms:posts_tool_url}', '工具文件URL', '', null);
INSERT INTO `tplmark` VALUES ('224', '工具开关状态', 'posts_status_switch', 'article', 'single', '{qkcms:posts_status_switch}', '工具开关状态', '', null);
INSERT INTO `tplmark` VALUES ('225', '工具售价', 'posts_price', 'article', 'single', '{qkcms:posts_price}', '工具售价', '', null);
INSERT INTO `tplmark` VALUES ('226', '跳转地址', 'posts_redirect_url', 'article', 'single', '{qkcms:posts_redirect_url}', '跳转地址', '', null);
INSERT INTO `tplmark` VALUES ('227', '分类ID', 'category_id', 'category', 'single', '{qkcms:category_id}', '分类ID', '', null);
INSERT INTO `tplmark` VALUES ('228', '分类名称', 'cat_name', 'category', 'single', '{qkcms:cat_name}', '分类名称', '', null);
INSERT INTO `tplmark` VALUES ('229', '分类描述', 'cat_description', 'category', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('230', '分类关键词', 'cat_keywords', 'category', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('231', '分类文章数', 'cat_posts', 'category', 'single', '{qkcms:cat_posts}', '分类文章数', '', null);
INSERT INTO `tplmark` VALUES ('232', '分类缩略图', 'cat_thumbnail', 'category', 'single', '{qkcms:cat_thumbnail}', '分类缩略图', '', null);
INSERT INTO `tplmark` VALUES ('233', '分类连接', 'cat_url', 'category', 'single', '{qkcms:cat_url}', '分类连接', '', null);
INSERT INTO `tplmark` VALUES ('234', '文章列表', 'articles', 'loop', 'loop', '{qkcms:articles row=5 col=2 property=0 order=comment titlelen=40 description_len=100 tag=\"1,TAG词\"}\n<img src=\"{thumbnail}\" alt=\"{title}\" />\n<h4><a href=\"{url}\">{title_id} {title}</a></h4>\n<span>作者ID: {author_id}</span>\n<span>作者账号: {author}</span>\n<span>作者等级: {author_level}</span>\n<span>作者头像<img src=\"{author_avatar}\" alt=\"{title}\" /> \n<span>时间: {date}</span>\n<span>浏览: {views}</span> \n<span>评论: {comments}</span>\n<span>点赞: {like_count}</span> \n<span>分类:<a href=\"{cat_url}\"> {category}</a></span>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:articles}', '文章列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">col=2 列数</span><span class=\"generator-param-tag\">order=comment 排序（latest按发布时间 &nbsp  updated按更新时间 &nbsp  comment按评论量  &nbsp hot按浏览量  &nbsp keywords按第一个关键词）</span><span class=\"generator-param-tag\">category_id=0或者不写表示调用当前栏目  参数category_id=-1表示全站 category_id=某个栏目的ID 表示调用指定栏目下的文章\n   \n</span><span class=\"generator-param-tag\">titlelen=40 标题长度</span><span class=\"generator-param-tag\">description_len=100 描述长度</span><span class=\"generator-param-tag\">property=属性ID 属性筛选（0=普通 1=头条 2=热门 3=推荐 4=公告 5=给力）</span><span class=\"generator-param-tag\">tag=\"1,TAG词\"  注意需要有双引号（匹配文章标题、描述、所有关键词）tag=\"2,TAG词\"（获取当前文章第一个关键词，去匹配其他文章关键词 也支持直接写固定的关键词匹配）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div class=\"generator-tags-container\"><span class=\"generator-sub-tag\">{thumbnail} 缩略图</span><span class=\"generator-sub-tag\">{title_id} 序号</span><span class=\"generator-sub-tag\">{title} 标题</span><span class=\"generator-sub-tag\">{url} 链接</span><span class=\"generator-sub-tag\">{author} 作者账号</span><span class=\"generator-sub-tag\">{author_level} 作者等级</span><span class=\"generator-sub-tag\">{author_avatar} 作者头像</span><span class=\"generator-sub-tag\">\n1{date} 时间格式1 &nbsp&nbsp2{date_only} &nbsp&nbsp 3{date_mo} &nbsp&nbsp 4{date_dy}</span><span class=\"generator-sub-tag\">{views} 浏览</span><span class=\"generator-sub-tag\">{comments} 评论</span><span class=\"generator-sub-tag\">{like_count} 点赞量</span><span class=\"generator-sub-tag\">{category} 分类</span><span class=\"generator-sub-tag\">{cat_url} 分类连接</span><span class=\"generator-sub-tag\">{description} 描述</span><span class=\"generator-sub-tag\">{keywords} 关键词</span><span class=\"generator-sub-tag\">{property} 文章属性名称</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('235', '分类列表', 'categories', 'loop', 'loop', '{qkcms:categories row=5 parent_id=-1 sa==1 sort=1 page=1}\n<img src=\"{thumbnail}\" alt=\"{name}\" />\n<h4><a href=\"{url}\">{name}</a> <span>({count})</span></h4>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:categories}', '分类列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数 </span>\n								\n<span class=\"generator-param-tag\">parent_id=-1 分类ID</span>\n<span class=\"generator-param-tag\">sa=-1 (sa=1 显示所有分类 sa=2 &nbsp只显示已开启的分类)</span>\n<span class=\"generator-param-tag\">sort=1排序&nbsp sort=1最新时间&nbsp sort=2最老时间&nbsp sort=3按分类文章数&nbsp sort=4随机数)</span>\n<span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对分类列表进行分页处理</span>\n</div>\n</div>\n\n<div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-sub-tag\">{name} 分类名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 文章数量</span><span class=\"generator-template-tag\">{thumbnail} 分类缩略图</span><span class=\"generator-template-tag\">{description} 描述</span><span class=\"generator-template-tag\">{keywords} 关键词</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('236', '评论循环标签', 'comments', 'loop', 'loop', '{qkcms:comments row=5 order=1 date_format=1 article_id=2 allow_html=1}\n<img src=\"{avatar}\" alt=\"{author}\" />\n<a href=\"/Member_id{author_id}.php\">{author}[{user_level}]</a>\n<span>时间: {date}</span>\n<p>编号{comment_id} 主评论内容：{content}</p>\n\n{reply_comment row=5 reply.date=1}\n回复ID {reply.id} \n回复楼层号 {reply.reply_id}\n回复者头像  {reply.avatar}\n回复者账号 {reply.author}\n回复者账号ID {reply.user_id}\n回复者等级 {user_reply.level}\n\n回复时间  {reply.date}\n回复内容  {reply.content}\n回复内容点赞数  {reply.like_count}\n被回复者用户名  {reply.reply_to}\n{/reply_comment}\n\n点赞数{like_count}\n举报数{report_count}\n{/qkcms:comments}', '评论循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数） </span><span class=\"generator-param-tag\">order=1排序（1最新评论-默认   &nbsp 2最早评论   &nbsp 3最热评论） </span><span class=\"generator-param-tag\">date_format=1时间格式（1如49分钟前  &nbsp  2如2025-5-5） </span><span class=\"generator-param-tag\">article_id=1（1调用全站评论   &nbsp 2调用当前文章评论）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{author} 作者</span><span class=\"generator-template-tag\">{author_id} 主评论作者ID</span><span class=\"generator-template-tag\">{user_level} 作者等级</span><span class=\"generator-template-tag\">{date} 时间</span><span class=\"generator-template-tag\">{content} 评论内容</span><span class=\"generator-template-tag\">{article_url} 文章链接</span><span class=\"generator-template-tag\">{article_title} 文章标题</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{comment_id} 父评论ID</span><span class=\"generator-template-tag\">{user_level} 用户等级</span><span class=\"generator-template-tag\">{allow_html=1} 评论内容支持html 参数=0不支持html格式）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 回复条数限制，默认显示5条回复</span><span class=\"generator-param-tag\">reply.date=1 回复时间格式（1如49分钟前  &nbsp 2如2025-5-5）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签</h5><p style=\"margin:10px 0;\">使用 {reply_comment row=5 reply.date=1} 和 {/reply_comment} 标签包裹嵌套回复内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{reply.id} 回复ID</span><span class=\"generator-template-tag\">{reply.reply_id} 回复楼层号</span><span class=\"generator-template-tag\">{reply.avatar} 回复者头像</span><span class=\"generator-template-tag\">{reply.author} 回复者账号</span><span class=\"generator-template-tag\">{reply.user_id} 回复者账号ID</span><span class=\"generator-template-tag\">{reply.level} 回复者等级</span><span class=\"generator-template-tag\">{reply.date} 回复时间</span><span class=\"generator-template-tag\">{reply.content} 回复内容</span><span class=\"generator-template-tag\">{reply.like_count} 回复内容点赞数</span><span class=\"generator-template-tag\">{reply.reply_to} 被回复者用户名</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('237', '用户列表', 'members', 'loop', 'loop', '{qkcms:members row=5 type=1}\n<a href=\"{user_center_url}\"><img src=\"{avatar}\" alt=\"{username}\" /></a>\n用户名：{username}\n用户等级：{level}\n<span>用户点赞数：{like_count}</span>\n<span>用户举报数：{report_count}</span>\n<span>用户文章数：{post_count}</span>\n{/qkcms:members}', '用户列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">type=1 用户类型（1 最新注册用户&nbsp 2 最近登录的用户 &nbsp3 随机调用全站用户 &nbsp4 最近访问文章的用户）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{username} 用户名</span><span class=\"generator-template-tag\">{username} 用户等级 {level}</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{post_count} 文章数</span><span class=\"generator-template-tag\">{user_center_url} 用户主页链接</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('238', '关键词', 'tags', 'loop', 'loop', '{qkcms:tags row=5 order=1}\n<a href=\"{url}\">{name}({count})</a>\n{/qkcms:tags}', '关键词循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序 (order=1时间 order=2调用次数 order=3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{name} 标签名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 使用次数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('239', '导航列表', 'navigation', 'loop', 'loop', '{qkcms:navigation row=5}\n<a href=\"{url}\" target=\"{target}\">{title}</a>\n{sub_navigation}\n<a href=\"{sub.url}\" target=\"{sub.target}\">{sub.title}</a>\n{/sub_navigation}\n{/qkcms:navigation}', '导航列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{target} 目标窗口</span><span class=\"generator-template-tag\">{title} 导航标题</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">二级导航嵌套标签</h5><p style=\"margin:10px 0;\">使用 {sub_navigation} 和 {/sub_navigation} 标签包裹二级导航内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{sub.id} 二级导航ID</span><span class=\"generator-template-tag\">{sub.title} 二级导航标题</span><span class=\"generator-template-tag\">{sub.url} 二级导航链接</span><span class=\"generator-template-tag\">{sub.target} 二级导航目标窗口</span><span class=\"generator-template-tag\">{sub.display_order} 二级导航排序</span><span class=\"generator-template-tag\">{sub.sub_id} 二级导航序号</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('240', '分页循环标签', 'page', 'loop', 'loop', '{qkcms:page type=1 page=1}\n {first_page}     - 首页链接\n {prev_page}      - 上一页链接\n {page_numbers}   - 数字页码链接（1 2 3 4 5）\n {next_page}      - 下一页链接\n {last_page}      - 尾页链接\n {page_status}    - 页码信息（第X页/共X页）\n {jump_to_page}   - 页码跳转下拉框\n{/qkcms:page}', '分页循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出分页导航</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=1 类型（1 文章列表分页 2 评论列表分页 3分类列表分页 4商品分页）</span><span class=\"generator-param-tag\">page=1 分页绑定标识</span><span class=\"generator-param-tag\">row 继承文章或评论列表配置</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{first_page} 首页链接</span><span class=\"generator-template-tag\">{prev_page} 上一页链接</span><span class=\"generator-template-tag\">{page_numbers} 数字页码链接</span><span class=\"generator-template-tag\">{next_page} 下一页链接</span><span class=\"generator-template-tag\">{last_page} 尾页链接</span><span class=\"generator-template-tag\">{page_status} 页码信息</span><span class=\"generator-template-tag\">{jump_to_page} 页码跳转下拉框</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">功能说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">支持首页/上一页/下一页/尾页链接</span><span class=\"generator-template-tag\">支持页码跳转功能</span><span class=\"generator-template-tag\">自动适应文章列表和评论列表</span><span class=\"generator-template-tag\">文章或评论循环标签也必须添加page=1参数才能绑定</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('241', '搜索词列表', 'search', 'loop', 'loop', '{qkcms:search row=5 order=1} \n <span>搜索词ID {id}</span>\n <span>搜索者 {username}</span>\n <span>搜索词 {search_term}</span>\n <span>搜索时间 {search_time}</span>\n <span>搜索词统计数 {count}</span>\n {/qkcms:search}', '搜索词列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序（1最新搜索 2最多搜索 3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{id} 搜索词ID</span><span class=\"generator-template-tag\">{username} 搜索者</span><span class=\"generator-template-tag\">{search_term} 搜索词</span><span class=\"generator-template-tag\">{search_time} 搜索时间</span><span class=\"generator-template-tag\">{count} 搜索词统计数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('242', '友情链接列表', 'friendlink', 'loop', 'loop', '{qkcms:friendlink row=5} \n <a href=\"{url}\" >{title}</a>\n {/qkcms:friendlink}', '友情链接列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{title} 标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('243', '商品分类ID', 'goods_category_id', 'goods', 'single', '{qkcms:goods_category_id}', '商品分类ID', '', null);
INSERT INTO `tplmark` VALUES ('244', '商品分类', 'goods_category_name', 'goods', 'single', '{qkcms:goods_category_name}', '商品分类', '', null);
INSERT INTO `tplmark` VALUES ('245', '分类关键词', 'cat_keywords', 'goods', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('246', '分类描述', 'cat_description', 'goods', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('247', '分类URL', 'cat_url', 'goods', 'single', '{qkcms:cat_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('248', '商品ID', 'goods_id', 'goods', 'single', '{qkcms:goods_id}', '商品ID', '', null);
INSERT INTO `tplmark` VALUES ('249', '商品标题', 'goods_title', 'goods', 'single', '{qkcms:goods_title}', '商品标题', '', null);
INSERT INTO `tplmark` VALUES ('250', '商品关键词', 'goods_keywords', 'goods', 'single', '{qkcms:goods_keywords}', '商品关键词', '', null);
INSERT INTO `tplmark` VALUES ('251', '商品描述', 'goods_description', 'goods', 'single', '{qkcms:goods_description}', '商品描述', '', null);
INSERT INTO `tplmark` VALUES ('252', '商品详情', 'goods_content', 'goods', 'single', '{qkcms:goods_content}', '商品详情', '', null);
INSERT INTO `tplmark` VALUES ('253', '商品价格', 'goods_price', 'goods', 'single', '{qkcms:goods_price}', '商品价格', '', null);
INSERT INTO `tplmark` VALUES ('254', '商品销量', 'goods_sales', 'goods', 'single', '{qkcms:goods_sales}', '商品销量', '', null);
INSERT INTO `tplmark` VALUES ('255', '商品库存', 'goods_stock', 'goods', 'single', '{qkcms:goods_stock}', '商品库存', '', null);
INSERT INTO `tplmark` VALUES ('256', '商品状态', 'goods_status', 'goods', 'single', '{qkcms:goods_status}', '商品状态', '', null);
INSERT INTO `tplmark` VALUES ('257', '创建时间', 'goods_created_at', 'goods', 'single', '{qkcms:goods_created_at}', '创建时间', '', null);
INSERT INTO `tplmark` VALUES ('258', '更新时间', 'goods_updated_at', 'goods', 'single', '{qkcms:goods_updated_at}', '更新时间', '', null);
INSERT INTO `tplmark` VALUES ('259', '商品缩略图', 'goods_thumbnail', 'goods', 'single', '{qkcms:goods_thumbnail}', '商品缩略图', '', null);
INSERT INTO `tplmark` VALUES ('260', '商品链接', 'goods_url', 'goods', 'single', '{qkcms:goods_url}', '商品链接', '', null);
INSERT INTO `tplmark` VALUES ('261', '商品规格', 'goods_specs', 'goods', 'single', '{qkcms:goods_specs}', '商品规格', '', null);
INSERT INTO `tplmark` VALUES ('262', '商品视频URL', 'goods_mp4url', 'goods', 'single', '{qkcms:goods_mp4url}', '商品视频URL', '', null);
INSERT INTO `tplmark` VALUES ('263', '商品图片循环', 'goods_images', 'goods', 'loop', '{qkcms:goods_images type=specs}\n<img src=\"{image.url}\" alt=\"{image.title}\">\n{/qkcms:goods_images}', '商品图片循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=specs 类型（specs规格图 images商品图）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{image.url} 图片URL</span><span class=\"generator-template-tag\">{image.title} 图片标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('264', '商品列表循环', 'goods', 'goods', 'loop', '{qkcms:goods row=8 type=new where=status=1}\n<span>分类关键词: {qkcms:cat_keywords}</span>\n<span>分类描述: {qkcms:cat_description}</span>\n<span>分类URL: {qkcms:cat_url}</span>\n<img src=\"{goods.thumbnail}\" alt=\"{goods.title}\">\n<h4><a href=\"{goods.url}\">{goods.title}</a></h4>\n<span>商品链接: {goods.url}</span>\n<span>商品规格: {goods.specs}</span>\n<span>视频URL: {goods.mp4url}</span>\n<span>ID: {goods.id}</span>\n<span>价格: ¥{goods.price}</span>\n<span>销量: {goods.sales}</span>\n<span>库存: {goods.stock}</span>\n<span>分类ID: {goods.category_id}</span>\n<span>分类: <a href=\"{goods.category_url}\">{goods.category_name}</a></span>\n<span>创建时间: {goods.create_time}</span>\n<span>更新时间: {goods.update_time}</span>\n{/qkcms:goods}', '商品列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=8 条数</span><span class=\"generator-param-tag\">type=new 类型（new最新 hot热门 recommend推荐）</span><span class=\"generator-param-tag\">where=status=1 条件筛选（status=1上架 status=0下架）</span><span class=\"generator-param-tag\">category_id 分类ID</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{goods.id} 商品ID</span><span class=\"generator-template-tag\">{goods.title} 商品标题</span><span class=\"generator-template-tag\">{goods.url} 商品链接</span><span class=\"generator-template-tag\">{goods.thumbnail} 商品缩略图</span><span class=\"generator-template-tag\">{goods.price} 商品价格</span><span class=\"generator-template-tag\">{goods.sales} 商品销量</span><span class=\"generator-template-tag\">{goods.stock} 商品库存</span><span class=\"generator-template-tag\">{goods.specs} 商品规格</span><span class=\"generator-template-tag\">{goods.mp4url} 商品视频URL</span><span class=\"generator-template-tag\">{goods.category_id} 分类ID</span><span class=\"generator-template-tag\">{goods.category_name} 分类名称</span><span class=\"generator-template-tag\">{goods.category_url} 分类链接</span><span class=\"generator-template-tag\">{goods.create_time} 创建时间</span><span class=\"generator-template-tag\">{goods.update_time} 更新时间</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('265', '调用头部模板', 'head.html', 'site', 'single', '{qkcms:head.html}', '调用头部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('266', '调用尾部模板', 'footer.html', 'site', 'single', '{qkcms:footer.html}', '调用尾部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('267', '调用评论模块', 'comment.php', 'site', 'single', '{qkcms:comment.php}', '调用评论模块', '', null);
INSERT INTO `tplmark` VALUES ('268', '网站名称', 'site_name', 'site', 'single', '{qkcms:site_name}', '网站名称', '', null);
INSERT INTO `tplmark` VALUES ('269', '站点标题', 'site_title', 'site', 'single', '{qkcms:site_title}', '站点标题', '', null);
INSERT INTO `tplmark` VALUES ('270', '站点描述', 'site_description', 'site', 'single', '{qkcms:site_description}', '站点描述', '', null);
INSERT INTO `tplmark` VALUES ('271', '站点关键词', 'site_keywords', 'site', 'single', '{qkcms:site_keywords}', '站点关键词', '', null);
INSERT INTO `tplmark` VALUES ('272', '页脚信息', 'site_copyright', 'site', 'single', '{qkcms:site_copyright}', '页脚信息', '', null);
INSERT INTO `tplmark` VALUES ('273', '网站违禁词', 'site_Prohw', 'site', 'single', '{qkcms:site_Prohw}', '网站违禁词', '', null);
INSERT INTO `tplmark` VALUES ('274', '当前位置', 'current_position', 'site', 'single', '{qkcms:current_position}', '当前位置', '', null);
INSERT INTO `tplmark` VALUES ('275', '总评论数', 'total_comments', 'site', 'single', '{qkcms:total_comments}', '总评论数', '', null);
INSERT INTO `tplmark` VALUES ('276', '关键词总数', 'total_keywords', 'site', 'single', '{qkcms:total_keywords}', '关键词总数', '', null);
INSERT INTO `tplmark` VALUES ('277', '分类总数', 'total_categories', 'site', 'single', '{qkcms:total_categories}', '分类总数', '', null);
INSERT INTO `tplmark` VALUES ('278', '总会员数', 'total_members', 'site', 'single', '{qkcms:total_members}', '总会员数', '', null);
INSERT INTO `tplmark` VALUES ('279', '举报总数', 'total_reports', 'site', 'single', '{qkcms:total_reports}', '举报总数', '', null);
INSERT INTO `tplmark` VALUES ('280', '总文章数', 'total_posts', 'site', 'single', '{qkcms:total_posts}', '总文章数', '', null);
INSERT INTO `tplmark` VALUES ('281', '总订单数', 'total_order', 'site', 'single', '{qkcms:total_order}', '总订单数', '', null);
INSERT INTO `tplmark` VALUES ('282', '搜索词匹配数量', 'total_search', 'site', 'single', '{qkcms:total_search}', '搜索词匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('283', 'TAG匹配数量', 'total_tag', 'site', 'single', '{qkcms:total_tag}', 'TAG匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('284', '网站累计访问量', 'total_visit', 'site', 'single', '{qkcms:total_visit}', '网站累计访问量', '', null);
INSERT INTO `tplmark` VALUES ('285', '当前账号ID', 'user_id', 'site', 'single', '{qkcms:user_id}', '当前账号ID', '', null);
INSERT INTO `tplmark` VALUES ('286', '当前账号', 'user_nickname', 'site', 'single', '{qkcms:user_nickname}', '当前账号', '', null);
INSERT INTO `tplmark` VALUES ('287', '当前用户头像', 'user_avatar', 'site', 'single', '{qkcms:user_avatar}', '当前用户头像', '', null);
INSERT INTO `tplmark` VALUES ('288', '当前用户等级', 'user_levels', 'site', 'single', '{qkcms:user_levels}', '当前用户等级', '', null);
INSERT INTO `tplmark` VALUES ('289', '当前账号状态', 'user_status', 'site', 'single', '{qkcms:user_status}', '当前账号状态', '', null);
INSERT INTO `tplmark` VALUES ('290', '当前账号积分', 'user_points', 'site', 'single', '{qkcms:user_points}', '当前账号积分', '', null);
INSERT INTO `tplmark` VALUES ('291', '注册时间', 'user_created_at', 'site', 'single', '{qkcms:user_created_at}', '注册时间', '', null);
INSERT INTO `tplmark` VALUES ('292', '文章ID', 'posts_id', 'article', 'single', '{qkcms:posts_id}', '文章ID', '', null);
INSERT INTO `tplmark` VALUES ('293', '文章标题', 'posts_title', 'article', 'single', '{qkcms:posts_title}', '文章标题', '', null);
INSERT INTO `tplmark` VALUES ('294', '文章URL', 'posts_url', 'article', 'single', '{qkcms:posts_url}', '文章URL', '', null);
INSERT INTO `tplmark` VALUES ('295', '文章内容', 'posts_content', 'article', 'single', '{qkcms:posts_content}', '文章内容', '', null);
INSERT INTO `tplmark` VALUES ('296', '文章关键词', 'posts_keywords', 'article', 'single', '{qkcms:posts_keywords}', '文章关键词', '', null);
INSERT INTO `tplmark` VALUES ('297', '文章缩略图', 'posts_thumbnail', 'article', 'single', '{qkcms:posts_thumbnail}', '文章缩略图', '', null);
INSERT INTO `tplmark` VALUES ('298', '文章描述', 'posts_description', 'article', 'single', '{qkcms:posts_description}', '文章描述', '', null);
INSERT INTO `tplmark` VALUES ('299', '文章评论数', 'posts_comments', 'article', 'single', '{qkcms:posts_comments}', '文章评论数', '', null);
INSERT INTO `tplmark` VALUES ('300', '分享数', 'posts_share_count', 'article', 'single', '{qkcms:posts_share_count}', '分享数', '', null);
INSERT INTO `tplmark` VALUES ('301', '点赞数', 'posts_like_count', 'article', 'single', '{qkcms:posts_like_count}', '点赞数', '', null);
INSERT INTO `tplmark` VALUES ('302', '举报数', 'posts_report_count', 'article', 'single', '{qkcms:posts_report_count}', '举报数', '', null);
INSERT INTO `tplmark` VALUES ('303', '文章浏览量', 'posts_views', 'article', 'single', '{qkcms:posts_views}', '文章浏览量', '', null);
INSERT INTO `tplmark` VALUES ('304', '发布日期', 'posts_created', 'article', 'single', '{qkcms:posts_created}', '发布日期', '', null);
INSERT INTO `tplmark` VALUES ('305', '所属分类', 'posts_category', 'article', 'single', '{qkcms:posts_category}', '所属分类', '', null);
INSERT INTO `tplmark` VALUES ('306', '分类URL', 'posts_category_url', 'article', 'single', '{qkcms:posts_category_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('307', '文章属性', 'posts_property', 'article', 'single', '{qkcms:posts_property}', '文章属性', '', null);
INSERT INTO `tplmark` VALUES ('308', '文章作者', 'posts_author', 'article', 'single', '{qkcms:posts_author}', '文章作者', '', null);
INSERT INTO `tplmark` VALUES ('309', '文章作者ID', 'posts_author_id', 'article', 'single', '{qkcms:posts_author_id}', '文章作者ID', '', null);
INSERT INTO `tplmark` VALUES ('310', '作者头像', 'posts_author_avatar', 'article', 'single', '{qkcms:posts_author_avatar}', '作者头像', '', null);
INSERT INTO `tplmark` VALUES ('311', '工具文件URL', 'posts_tool_url', 'article', 'single', '{qkcms:posts_tool_url}', '工具文件URL', '', null);
INSERT INTO `tplmark` VALUES ('312', '工具开关状态', 'posts_status_switch', 'article', 'single', '{qkcms:posts_status_switch}', '工具开关状态', '', null);
INSERT INTO `tplmark` VALUES ('313', '工具售价', 'posts_price', 'article', 'single', '{qkcms:posts_price}', '工具售价', '', null);
INSERT INTO `tplmark` VALUES ('314', '跳转地址', 'posts_redirect_url', 'article', 'single', '{qkcms:posts_redirect_url}', '跳转地址', '', null);
INSERT INTO `tplmark` VALUES ('315', '分类ID', 'category_id', 'category', 'single', '{qkcms:category_id}', '分类ID', '', null);
INSERT INTO `tplmark` VALUES ('316', '分类名称', 'cat_name', 'category', 'single', '{qkcms:cat_name}', '分类名称', '', null);
INSERT INTO `tplmark` VALUES ('317', '分类描述', 'cat_description', 'category', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('318', '分类关键词', 'cat_keywords', 'category', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('319', '分类文章数', 'cat_posts', 'category', 'single', '{qkcms:cat_posts}', '分类文章数', '', null);
INSERT INTO `tplmark` VALUES ('320', '分类缩略图', 'cat_thumbnail', 'category', 'single', '{qkcms:cat_thumbnail}', '分类缩略图', '', null);
INSERT INTO `tplmark` VALUES ('321', '分类连接', 'cat_url', 'category', 'single', '{qkcms:cat_url}', '分类连接', '', null);
INSERT INTO `tplmark` VALUES ('322', '文章列表', 'articles', 'loop', 'loop', '{qkcms:articles row=5 col=2 property=0 order=comment titlelen=40 description_len=100 tag=\"1,TAG词\"}\n<img src=\"{thumbnail}\" alt=\"{title}\" />\n<h4><a href=\"{url}\">{title_id} {title}</a></h4>\n<span>作者ID: {author_id}</span>\n<span>作者账号: {author}</span>\n<span>作者等级: {author_level}</span>\n<span>作者头像<img src=\"{author_avatar}\" alt=\"{title}\" /> \n<span>时间: {date}</span>\n<span>浏览: {views}</span> \n<span>评论: {comments}</span>\n<span>点赞: {like_count}</span> \n<span>分类:<a href=\"{cat_url}\"> {category}</a></span>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:articles}', '文章列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">col=2 列数</span><span class=\"generator-param-tag\">order=comment 排序（latest按发布时间 &nbsp  updated按更新时间 &nbsp  comment按评论量  &nbsp hot按浏览量  &nbsp keywords按第一个关键词）</span><span class=\"generator-param-tag\">category_id=0或者不写表示调用当前栏目  参数category_id=-1表示全站 category_id=某个栏目的ID 表示调用指定栏目下的文章\n   \n</span><span class=\"generator-param-tag\">titlelen=40 标题长度</span><span class=\"generator-param-tag\">description_len=100 描述长度</span><span class=\"generator-param-tag\">property=属性ID 属性筛选（0=普通 1=头条 2=热门 3=推荐 4=公告 5=给力）</span><span class=\"generator-param-tag\">tag=\"1,TAG词\"  注意需要有双引号（匹配文章标题、描述、所有关键词）tag=\"2,TAG词\"（获取当前文章第一个关键词，去匹配其他文章关键词 也支持直接写固定的关键词匹配）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div class=\"generator-tags-container\"><span class=\"generator-sub-tag\">{thumbnail} 缩略图</span><span class=\"generator-sub-tag\">{title_id} 序号</span><span class=\"generator-sub-tag\">{title} 标题</span><span class=\"generator-sub-tag\">{url} 链接</span><span class=\"generator-sub-tag\">{author} 作者账号</span><span class=\"generator-sub-tag\">{author_level} 作者等级</span><span class=\"generator-sub-tag\">{author_avatar} 作者头像</span><span class=\"generator-sub-tag\">\n1{date} 时间格式1 &nbsp&nbsp2{date_only} &nbsp&nbsp 3{date_mo} &nbsp&nbsp 4{date_dy}</span><span class=\"generator-sub-tag\">{views} 浏览</span><span class=\"generator-sub-tag\">{comments} 评论</span><span class=\"generator-sub-tag\">{like_count} 点赞量</span><span class=\"generator-sub-tag\">{category} 分类</span><span class=\"generator-sub-tag\">{cat_url} 分类连接</span><span class=\"generator-sub-tag\">{description} 描述</span><span class=\"generator-sub-tag\">{keywords} 关键词</span><span class=\"generator-sub-tag\">{property} 文章属性名称</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('323', '分类列表', 'categories', 'loop', 'loop', '{qkcms:categories row=5 parent_id=-1 sa==1 sort=1 page=1}\n<img src=\"{thumbnail}\" alt=\"{name}\" />\n<h4><a href=\"{url}\">{name}</a> <span>({count})</span></h4>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:categories}', '分类列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数 </span>\n								\n<span class=\"generator-param-tag\">parent_id=-1 分类ID</span>\n<span class=\"generator-param-tag\">sa=-1 (sa=1 显示所有分类 sa=2 &nbsp只显示已开启的分类)</span>\n<span class=\"generator-param-tag\">sort=1排序&nbsp sort=1最新时间&nbsp sort=2最老时间&nbsp sort=3按分类文章数&nbsp sort=4随机数)</span>\n<span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对分类列表进行分页处理</span>\n</div>\n</div>\n\n<div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-sub-tag\">{name} 分类名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 文章数量</span><span class=\"generator-template-tag\">{thumbnail} 分类缩略图</span><span class=\"generator-template-tag\">{description} 描述</span><span class=\"generator-template-tag\">{keywords} 关键词</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('324', '评论循环标签', 'comments', 'loop', 'loop', '{qkcms:comments row=5 order=1 date_format=1 article_id=2 allow_html=1}\n<img src=\"{avatar}\" alt=\"{author}\" />\n<a href=\"/Member_id{author_id}.php\">{author}[{user_level}]</a>\n<span>时间: {date}</span>\n<p>编号{comment_id} 主评论内容：{content}</p>\n\n{reply_comment row=5 reply.date=1}\n回复ID {reply.id} \n回复楼层号 {reply.reply_id}\n回复者头像  {reply.avatar}\n回复者账号 {reply.author}\n回复者账号ID {reply.user_id}\n回复者等级 {user_reply.level}\n\n回复时间  {reply.date}\n回复内容  {reply.content}\n回复内容点赞数  {reply.like_count}\n被回复者用户名  {reply.reply_to}\n{/reply_comment}\n\n点赞数{like_count}\n举报数{report_count}\n{/qkcms:comments}', '评论循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数） </span><span class=\"generator-param-tag\">order=1排序（1最新评论-默认   &nbsp 2最早评论   &nbsp 3最热评论） </span><span class=\"generator-param-tag\">date_format=1时间格式（1如49分钟前  &nbsp  2如2025-5-5） </span><span class=\"generator-param-tag\">article_id=1（1调用全站评论   &nbsp 2调用当前文章评论）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{author} 作者</span><span class=\"generator-template-tag\">{author_id} 主评论作者ID</span><span class=\"generator-template-tag\">{user_level} 作者等级</span><span class=\"generator-template-tag\">{date} 时间</span><span class=\"generator-template-tag\">{content} 评论内容</span><span class=\"generator-template-tag\">{article_url} 文章链接</span><span class=\"generator-template-tag\">{article_title} 文章标题</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{comment_id} 父评论ID</span><span class=\"generator-template-tag\">{user_level} 用户等级</span><span class=\"generator-template-tag\">{allow_html=1} 评论内容支持html 参数=0不支持html格式）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 回复条数限制，默认显示5条回复</span><span class=\"generator-param-tag\">reply.date=1 回复时间格式（1如49分钟前  &nbsp 2如2025-5-5）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签</h5><p style=\"margin:10px 0;\">使用 {reply_comment row=5 reply.date=1} 和 {/reply_comment} 标签包裹嵌套回复内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{reply.id} 回复ID</span><span class=\"generator-template-tag\">{reply.reply_id} 回复楼层号</span><span class=\"generator-template-tag\">{reply.avatar} 回复者头像</span><span class=\"generator-template-tag\">{reply.author} 回复者账号</span><span class=\"generator-template-tag\">{reply.user_id} 回复者账号ID</span><span class=\"generator-template-tag\">{reply.level} 回复者等级</span><span class=\"generator-template-tag\">{reply.date} 回复时间</span><span class=\"generator-template-tag\">{reply.content} 回复内容</span><span class=\"generator-template-tag\">{reply.like_count} 回复内容点赞数</span><span class=\"generator-template-tag\">{reply.reply_to} 被回复者用户名</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('325', '用户列表', 'members', 'loop', 'loop', '{qkcms:members row=5 type=1}\n<a href=\"{user_center_url}\"><img src=\"{avatar}\" alt=\"{username}\" /></a>\n用户名：{username}\n用户等级：{level}\n<span>用户点赞数：{like_count}</span>\n<span>用户举报数：{report_count}</span>\n<span>用户文章数：{post_count}</span>\n{/qkcms:members}', '用户列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">type=1 用户类型（1 最新注册用户&nbsp 2 最近登录的用户 &nbsp3 随机调用全站用户 &nbsp4 最近访问文章的用户）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{username} 用户名</span><span class=\"generator-template-tag\">{username} 用户等级 {level}</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{post_count} 文章数</span><span class=\"generator-template-tag\">{user_center_url} 用户主页链接</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('326', '关键词', 'tags', 'loop', 'loop', '{qkcms:tags row=5 order=1}\n<a href=\"{url}\">{name}({count})</a>\n{/qkcms:tags}', '关键词循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序 (order=1时间 order=2调用次数 order=3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{name} 标签名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 使用次数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('327', '导航列表', 'navigation', 'loop', 'loop', '{qkcms:navigation row=5}\n<a href=\"{url}\" target=\"{target}\">{title}</a>\n{sub_navigation}\n<a href=\"{sub.url}\" target=\"{sub.target}\">{sub.title}</a>\n{/sub_navigation}\n{/qkcms:navigation}', '导航列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{target} 目标窗口</span><span class=\"generator-template-tag\">{title} 导航标题</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">二级导航嵌套标签</h5><p style=\"margin:10px 0;\">使用 {sub_navigation} 和 {/sub_navigation} 标签包裹二级导航内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{sub.id} 二级导航ID</span><span class=\"generator-template-tag\">{sub.title} 二级导航标题</span><span class=\"generator-template-tag\">{sub.url} 二级导航链接</span><span class=\"generator-template-tag\">{sub.target} 二级导航目标窗口</span><span class=\"generator-template-tag\">{sub.display_order} 二级导航排序</span><span class=\"generator-template-tag\">{sub.sub_id} 二级导航序号</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('328', '分页循环标签', 'page', 'loop', 'loop', '{qkcms:page type=1 page=1}\n {first_page}     - 首页链接\n {prev_page}      - 上一页链接\n {page_numbers}   - 数字页码链接（1 2 3 4 5）\n {next_page}      - 下一页链接\n {last_page}      - 尾页链接\n {page_status}    - 页码信息（第X页/共X页）\n {jump_to_page}   - 页码跳转下拉框\n{/qkcms:page}', '分页循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出分页导航</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=1 类型（1 文章列表分页 2 评论列表分页 3分类列表分页 4商品分页）</span><span class=\"generator-param-tag\">page=1 分页绑定标识</span><span class=\"generator-param-tag\">row 继承文章或评论列表配置</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{first_page} 首页链接</span><span class=\"generator-template-tag\">{prev_page} 上一页链接</span><span class=\"generator-template-tag\">{page_numbers} 数字页码链接</span><span class=\"generator-template-tag\">{next_page} 下一页链接</span><span class=\"generator-template-tag\">{last_page} 尾页链接</span><span class=\"generator-template-tag\">{page_status} 页码信息</span><span class=\"generator-template-tag\">{jump_to_page} 页码跳转下拉框</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">功能说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">支持首页/上一页/下一页/尾页链接</span><span class=\"generator-template-tag\">支持页码跳转功能</span><span class=\"generator-template-tag\">自动适应文章列表和评论列表</span><span class=\"generator-template-tag\">文章或评论循环标签也必须添加page=1参数才能绑定</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('329', '搜索词列表', 'search', 'loop', 'loop', '{qkcms:search row=5 order=1} \n <span>搜索词ID {id}</span>\n <span>搜索者 {username}</span>\n <span>搜索词 {search_term}</span>\n <span>搜索时间 {search_time}</span>\n <span>搜索词统计数 {count}</span>\n {/qkcms:search}', '搜索词列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序（1最新搜索 2最多搜索 3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{id} 搜索词ID</span><span class=\"generator-template-tag\">{username} 搜索者</span><span class=\"generator-template-tag\">{search_term} 搜索词</span><span class=\"generator-template-tag\">{search_time} 搜索时间</span><span class=\"generator-template-tag\">{count} 搜索词统计数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('330', '友情链接列表', 'friendlink', 'loop', 'loop', '{qkcms:friendlink row=5} \n <a href=\"{url}\" >{title}</a>\n {/qkcms:friendlink}', '友情链接列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{title} 标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('331', '商品分类ID', 'goods_category_id', 'goods', 'single', '{qkcms:goods_category_id}', '商品分类ID', '', null);
INSERT INTO `tplmark` VALUES ('332', '商品分类', 'goods_category_name', 'goods', 'single', '{qkcms:goods_category_name}', '商品分类', '', null);
INSERT INTO `tplmark` VALUES ('333', '分类关键词', 'cat_keywords', 'goods', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('334', '分类描述', 'cat_description', 'goods', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('335', '分类URL', 'cat_url', 'goods', 'single', '{qkcms:cat_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('336', '商品ID', 'goods_id', 'goods', 'single', '{qkcms:goods_id}', '商品ID', '', null);
INSERT INTO `tplmark` VALUES ('337', '商品标题', 'goods_title', 'goods', 'single', '{qkcms:goods_title}', '商品标题', '', null);
INSERT INTO `tplmark` VALUES ('338', '商品关键词', 'goods_keywords', 'goods', 'single', '{qkcms:goods_keywords}', '商品关键词', '', null);
INSERT INTO `tplmark` VALUES ('339', '商品描述', 'goods_description', 'goods', 'single', '{qkcms:goods_description}', '商品描述', '', null);
INSERT INTO `tplmark` VALUES ('340', '商品详情', 'goods_content', 'goods', 'single', '{qkcms:goods_content}', '商品详情', '', null);
INSERT INTO `tplmark` VALUES ('341', '商品价格', 'goods_price', 'goods', 'single', '{qkcms:goods_price}', '商品价格', '', null);
INSERT INTO `tplmark` VALUES ('342', '商品销量', 'goods_sales', 'goods', 'single', '{qkcms:goods_sales}', '商品销量', '', null);
INSERT INTO `tplmark` VALUES ('343', '商品库存', 'goods_stock', 'goods', 'single', '{qkcms:goods_stock}', '商品库存', '', null);
INSERT INTO `tplmark` VALUES ('344', '商品状态', 'goods_status', 'goods', 'single', '{qkcms:goods_status}', '商品状态', '', null);
INSERT INTO `tplmark` VALUES ('345', '创建时间', 'goods_created_at', 'goods', 'single', '{qkcms:goods_created_at}', '创建时间', '', null);
INSERT INTO `tplmark` VALUES ('346', '更新时间', 'goods_updated_at', 'goods', 'single', '{qkcms:goods_updated_at}', '更新时间', '', null);
INSERT INTO `tplmark` VALUES ('347', '商品缩略图', 'goods_thumbnail', 'goods', 'single', '{qkcms:goods_thumbnail}', '商品缩略图', '', null);
INSERT INTO `tplmark` VALUES ('348', '商品链接', 'goods_url', 'goods', 'single', '{qkcms:goods_url}', '商品链接', '', null);
INSERT INTO `tplmark` VALUES ('349', '商品规格', 'goods_specs', 'goods', 'single', '{qkcms:goods_specs}', '商品规格', '', null);
INSERT INTO `tplmark` VALUES ('350', '商品视频URL', 'goods_mp4url', 'goods', 'single', '{qkcms:goods_mp4url}', '商品视频URL', '', null);
INSERT INTO `tplmark` VALUES ('351', '商品图片循环', 'goods_images', 'goods', 'loop', '{qkcms:goods_images type=specs}\n<img src=\"{image.url}\" alt=\"{image.title}\">\n{/qkcms:goods_images}', '商品图片循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=specs 类型（specs规格图 images商品图）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{image.url} 图片URL</span><span class=\"generator-template-tag\">{image.title} 图片标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('352', '商品列表循环', 'goods', 'goods', 'loop', '{qkcms:goods row=8 type=new where=status=1}\n<span>分类关键词: {qkcms:cat_keywords}</span>\n<span>分类描述: {qkcms:cat_description}</span>\n<span>分类URL: {qkcms:cat_url}</span>\n<img src=\"{goods.thumbnail}\" alt=\"{goods.title}\">\n<h4><a href=\"{goods.url}\">{goods.title}</a></h4>\n<span>商品链接: {goods.url}</span>\n<span>商品规格: {goods.specs}</span>\n<span>视频URL: {goods.mp4url}</span>\n<span>ID: {goods.id}</span>\n<span>价格: ¥{goods.price}</span>\n<span>销量: {goods.sales}</span>\n<span>库存: {goods.stock}</span>\n<span>分类ID: {goods.category_id}</span>\n<span>分类: <a href=\"{goods.category_url}\">{goods.category_name}</a></span>\n<span>创建时间: {goods.create_time}</span>\n<span>更新时间: {goods.update_time}</span>\n{/qkcms:goods}', '商品列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=8 条数</span><span class=\"generator-param-tag\">type=new 类型（new最新 hot热门 recommend推荐）</span><span class=\"generator-param-tag\">where=status=1 条件筛选（status=1上架 status=0下架）</span><span class=\"generator-param-tag\">category_id 分类ID</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{goods.id} 商品ID</span><span class=\"generator-template-tag\">{goods.title} 商品标题</span><span class=\"generator-template-tag\">{goods.url} 商品链接</span><span class=\"generator-template-tag\">{goods.thumbnail} 商品缩略图</span><span class=\"generator-template-tag\">{goods.price} 商品价格</span><span class=\"generator-template-tag\">{goods.sales} 商品销量</span><span class=\"generator-template-tag\">{goods.stock} 商品库存</span><span class=\"generator-template-tag\">{goods.specs} 商品规格</span><span class=\"generator-template-tag\">{goods.mp4url} 商品视频URL</span><span class=\"generator-template-tag\">{goods.category_id} 分类ID</span><span class=\"generator-template-tag\">{goods.category_name} 分类名称</span><span class=\"generator-template-tag\">{goods.category_url} 分类链接</span><span class=\"generator-template-tag\">{goods.create_time} 创建时间</span><span class=\"generator-template-tag\">{goods.update_time} 更新时间</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('353', '调用头部模板', 'head.html', 'site', 'single', '{qkcms:head.html}', '调用头部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('354', '调用尾部模板', 'footer.html', 'site', 'single', '{qkcms:footer.html}', '调用尾部模板文件', '', null);
INSERT INTO `tplmark` VALUES ('355', '调用评论模块', 'comment.php', 'site', 'single', '{qkcms:comment.php}', '调用评论模块', '', null);
INSERT INTO `tplmark` VALUES ('356', '网站名称', 'site_name', 'site', 'single', '{qkcms:site_name}', '网站名称', '', null);
INSERT INTO `tplmark` VALUES ('357', '站点标题', 'site_title', 'site', 'single', '{qkcms:site_title}', '站点标题', '', null);
INSERT INTO `tplmark` VALUES ('358', '站点描述', 'site_description', 'site', 'single', '{qkcms:site_description}', '站点描述', '', null);
INSERT INTO `tplmark` VALUES ('359', '站点关键词', 'site_keywords', 'site', 'single', '{qkcms:site_keywords}', '站点关键词', '', null);
INSERT INTO `tplmark` VALUES ('360', '页脚信息', 'site_copyright', 'site', 'single', '{qkcms:site_copyright}', '页脚信息', '', null);
INSERT INTO `tplmark` VALUES ('361', '网站违禁词', 'site_Prohw', 'site', 'single', '{qkcms:site_Prohw}', '网站违禁词', '', null);
INSERT INTO `tplmark` VALUES ('362', '当前位置', 'current_position', 'site', 'single', '{qkcms:current_position}', '当前位置', '', null);
INSERT INTO `tplmark` VALUES ('363', '总评论数', 'total_comments', 'site', 'single', '{qkcms:total_comments}', '总评论数', '', null);
INSERT INTO `tplmark` VALUES ('364', '关键词总数', 'total_keywords', 'site', 'single', '{qkcms:total_keywords}', '关键词总数', '', null);
INSERT INTO `tplmark` VALUES ('365', '分类总数', 'total_categories', 'site', 'single', '{qkcms:total_categories}', '分类总数', '', null);
INSERT INTO `tplmark` VALUES ('366', '总会员数', 'total_members', 'site', 'single', '{qkcms:total_members}', '总会员数', '', null);
INSERT INTO `tplmark` VALUES ('367', '举报总数', 'total_reports', 'site', 'single', '{qkcms:total_reports}', '举报总数', '', null);
INSERT INTO `tplmark` VALUES ('368', '总文章数', 'total_posts', 'site', 'single', '{qkcms:total_posts}', '总文章数', '', null);
INSERT INTO `tplmark` VALUES ('369', '总订单数', 'total_order', 'site', 'single', '{qkcms:total_order}', '总订单数', '', null);
INSERT INTO `tplmark` VALUES ('370', '搜索词匹配数量', 'total_search', 'site', 'single', '{qkcms:total_search}', '搜索词匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('371', 'TAG匹配数量', 'total_tag', 'site', 'single', '{qkcms:total_tag}', 'TAG匹配数量', '', null);
INSERT INTO `tplmark` VALUES ('372', '网站累计访问量', 'total_visit', 'site', 'single', '{qkcms:total_visit}', '网站累计访问量', '', null);
INSERT INTO `tplmark` VALUES ('373', '当前账号ID', 'user_id', 'site', 'single', '{qkcms:user_id}', '当前账号ID', '', null);
INSERT INTO `tplmark` VALUES ('374', '当前账号', 'user_nickname', 'site', 'single', '{qkcms:user_nickname}', '当前账号', '', null);
INSERT INTO `tplmark` VALUES ('375', '当前用户头像', 'user_avatar', 'site', 'single', '{qkcms:user_avatar}', '当前用户头像', '', null);
INSERT INTO `tplmark` VALUES ('376', '当前用户等级', 'user_levels', 'site', 'single', '{qkcms:user_levels}', '当前用户等级', '', null);
INSERT INTO `tplmark` VALUES ('377', '当前账号状态', 'user_status', 'site', 'single', '{qkcms:user_status}', '当前账号状态', '', null);
INSERT INTO `tplmark` VALUES ('378', '当前账号积分', 'user_points', 'site', 'single', '{qkcms:user_points}', '当前账号积分', '', null);
INSERT INTO `tplmark` VALUES ('379', '注册时间', 'user_created_at', 'site', 'single', '{qkcms:user_created_at}', '注册时间', '', null);
INSERT INTO `tplmark` VALUES ('380', '文章ID', 'posts_id', 'article', 'single', '{qkcms:posts_id}', '文章ID', '', null);
INSERT INTO `tplmark` VALUES ('381', '文章标题', 'posts_title', 'article', 'single', '{qkcms:posts_title}', '文章标题', '', null);
INSERT INTO `tplmark` VALUES ('382', '文章URL', 'posts_url', 'article', 'single', '{qkcms:posts_url}', '文章URL', '', null);
INSERT INTO `tplmark` VALUES ('383', '文章内容', 'posts_content', 'article', 'single', '{qkcms:posts_content}', '文章内容', '', null);
INSERT INTO `tplmark` VALUES ('384', '文章关键词', 'posts_keywords', 'article', 'single', '{qkcms:posts_keywords}', '文章关键词', '', null);
INSERT INTO `tplmark` VALUES ('385', '文章缩略图', 'posts_thumbnail', 'article', 'single', '{qkcms:posts_thumbnail}', '文章缩略图', '', null);
INSERT INTO `tplmark` VALUES ('386', '文章描述', 'posts_description', 'article', 'single', '{qkcms:posts_description}', '文章描述', '', null);
INSERT INTO `tplmark` VALUES ('387', '文章评论数', 'posts_comments', 'article', 'single', '{qkcms:posts_comments}', '文章评论数', '', null);
INSERT INTO `tplmark` VALUES ('388', '分享数', 'posts_share_count', 'article', 'single', '{qkcms:posts_share_count}', '分享数', '', null);
INSERT INTO `tplmark` VALUES ('389', '点赞数', 'posts_like_count', 'article', 'single', '{qkcms:posts_like_count}', '点赞数', '', null);
INSERT INTO `tplmark` VALUES ('390', '举报数', 'posts_report_count', 'article', 'single', '{qkcms:posts_report_count}', '举报数', '', null);
INSERT INTO `tplmark` VALUES ('391', '文章浏览量', 'posts_views', 'article', 'single', '{qkcms:posts_views}', '文章浏览量', '', null);
INSERT INTO `tplmark` VALUES ('392', '发布日期', 'posts_created', 'article', 'single', '{qkcms:posts_created}', '发布日期', '', null);
INSERT INTO `tplmark` VALUES ('393', '所属分类', 'posts_category', 'article', 'single', '{qkcms:posts_category}', '所属分类', '', null);
INSERT INTO `tplmark` VALUES ('394', '分类URL', 'posts_category_url', 'article', 'single', '{qkcms:posts_category_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('395', '文章属性', 'posts_property', 'article', 'single', '{qkcms:posts_property}', '文章属性', '', null);
INSERT INTO `tplmark` VALUES ('396', '文章作者', 'posts_author', 'article', 'single', '{qkcms:posts_author}', '文章作者', '', null);
INSERT INTO `tplmark` VALUES ('397', '文章作者ID', 'posts_author_id', 'article', 'single', '{qkcms:posts_author_id}', '文章作者ID', '', null);
INSERT INTO `tplmark` VALUES ('398', '作者头像', 'posts_author_avatar', 'article', 'single', '{qkcms:posts_author_avatar}', '作者头像', '', null);
INSERT INTO `tplmark` VALUES ('399', '工具文件URL', 'posts_tool_url', 'article', 'single', '{qkcms:posts_tool_url}', '工具文件URL', '', null);
INSERT INTO `tplmark` VALUES ('400', '工具开关状态', 'posts_status_switch', 'article', 'single', '{qkcms:posts_status_switch}', '工具开关状态', '', null);
INSERT INTO `tplmark` VALUES ('401', '工具售价', 'posts_price', 'article', 'single', '{qkcms:posts_price}', '工具售价', '', null);
INSERT INTO `tplmark` VALUES ('402', '跳转地址', 'posts_redirect_url', 'article', 'single', '{qkcms:posts_redirect_url}', '跳转地址', '', null);
INSERT INTO `tplmark` VALUES ('403', '分类ID', 'category_id', 'category', 'single', '{qkcms:category_id}', '分类ID', '', null);
INSERT INTO `tplmark` VALUES ('404', '分类名称', 'cat_name', 'category', 'single', '{qkcms:cat_name}', '分类名称', '', null);
INSERT INTO `tplmark` VALUES ('405', '分类描述', 'cat_description', 'category', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('406', '分类关键词', 'cat_keywords', 'category', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('407', '分类文章数', 'cat_posts', 'category', 'single', '{qkcms:cat_posts}', '分类文章数', '', null);
INSERT INTO `tplmark` VALUES ('408', '分类缩略图', 'cat_thumbnail', 'category', 'single', '{qkcms:cat_thumbnail}', '分类缩略图', '', null);
INSERT INTO `tplmark` VALUES ('409', '分类连接', 'cat_url', 'category', 'single', '{qkcms:cat_url}', '分类连接', '', null);
INSERT INTO `tplmark` VALUES ('410', '文章列表', 'articles', 'loop', 'loop', '{qkcms:articles row=5 col=2 property=0 order=comment titlelen=40 description_len=100 tag=\"1,TAG词\"}\n<img src=\"{thumbnail}\" alt=\"{title}\" />\n<h4><a href=\"{url}\">{title_id} {title}</a></h4>\n<span>作者ID: {author_id}</span>\n<span>作者账号: {author}</span>\n<span>作者等级: {author_level}</span>\n<span>作者头像<img src=\"{author_avatar}\" alt=\"{title}\" /> \n<span>时间: {date}</span>\n<span>浏览: {views}</span> \n<span>评论: {comments}</span>\n<span>点赞: {like_count}</span> \n<span>分类:<a href=\"{cat_url}\"> {category}</a></span>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:articles}', '文章列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">col=2 列数</span><span class=\"generator-param-tag\">order=comment 排序（latest按发布时间 &nbsp  updated按更新时间 &nbsp  comment按评论量  &nbsp hot按浏览量  &nbsp keywords按第一个关键词）</span><span class=\"generator-param-tag\">category_id=0或者不写表示调用当前栏目  参数category_id=-1表示全站 category_id=某个栏目的ID 表示调用指定栏目下的文章\n   \n</span><span class=\"generator-param-tag\">titlelen=40 标题长度</span><span class=\"generator-param-tag\">description_len=100 描述长度</span><span class=\"generator-param-tag\">property=属性ID 属性筛选（0=普通 1=头条 2=热门 3=推荐 4=公告 5=给力）</span><span class=\"generator-param-tag\">tag=\"1,TAG词\"  注意需要有双引号（匹配文章标题、描述、所有关键词）tag=\"2,TAG词\"（获取当前文章第一个关键词，去匹配其他文章关键词 也支持直接写固定的关键词匹配）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div class=\"generator-tags-container\"><span class=\"generator-sub-tag\">{thumbnail} 缩略图</span><span class=\"generator-sub-tag\">{title_id} 序号</span><span class=\"generator-sub-tag\">{title} 标题</span><span class=\"generator-sub-tag\">{url} 链接</span><span class=\"generator-sub-tag\">{author} 作者账号</span><span class=\"generator-sub-tag\">{author_level} 作者等级</span><span class=\"generator-sub-tag\">{author_avatar} 作者头像</span><span class=\"generator-sub-tag\">\n1{date} 时间格式1 &nbsp&nbsp2{date_only} &nbsp&nbsp 3{date_mo} &nbsp&nbsp 4{date_dy}</span><span class=\"generator-sub-tag\">{views} 浏览</span><span class=\"generator-sub-tag\">{comments} 评论</span><span class=\"generator-sub-tag\">{like_count} 点赞量</span><span class=\"generator-sub-tag\">{category} 分类</span><span class=\"generator-sub-tag\">{cat_url} 分类连接</span><span class=\"generator-sub-tag\">{description} 描述</span><span class=\"generator-sub-tag\">{keywords} 关键词</span><span class=\"generator-sub-tag\">{property} 文章属性名称</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('411', '分类列表', 'categories', 'loop', 'loop', '{qkcms:categories row=5 parent_id=-1 sa==1 sort=1 page=1}\n<img src=\"{thumbnail}\" alt=\"{name}\" />\n<h4><a href=\"{url}\">{name}</a> <span>({count})</span></h4>\n<p>描述: {description}</p>\n<p>关键词: {keywords}</p>\n{/qkcms:categories}', '分类列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-param-card\"><h5 class=\"generator-section-title\">参数说明</h5><div class=\"generator-tags-container\"><span class=\"generator-param-tag\">row=5 条数 </span>\n								\n<span class=\"generator-param-tag\">parent_id=-1 分类ID</span>\n<span class=\"generator-param-tag\">sa=-1 (sa=1 显示所有分类 sa=2 &nbsp只显示已开启的分类)</span>\n<span class=\"generator-param-tag\">sort=1排序&nbsp sort=1最新时间&nbsp sort=2最老时间&nbsp sort=3按分类文章数&nbsp sort=4随机数)</span>\n<span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对分类列表进行分页处理</span>\n</div>\n</div>\n\n<div class=\"generator-sub-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-sub-tag\">{name} 分类名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 文章数量</span><span class=\"generator-template-tag\">{thumbnail} 分类缩略图</span><span class=\"generator-template-tag\">{description} 描述</span><span class=\"generator-template-tag\">{keywords} 关键词</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('412', '评论循环标签', 'comments', 'loop', 'loop', '{qkcms:comments row=5 order=1 date_format=1 article_id=2 allow_html=1}\n<img src=\"{avatar}\" alt=\"{author}\" />\n<a href=\"/Member_id{author_id}.php\">{author}[{user_level}]</a>\n<span>时间: {date}</span>\n<p>编号{comment_id} 主评论内容：{content}</p>\n\n{reply_comment row=5 reply.date=1}\n回复者头像  {reply.avatar}\n回复ID {reply.id} \n回复楼层号 {reply.reply_id}\n回复者账号 {reply.author}\n回复者账号ID {reply.user_id}\n回复者等级 {user_reply.level}\n\n回复时间  {reply.date}\n回复内容  {reply.content}\n回复内容点赞数  {reply.like_count}\n被回复者用户名  {reply.reply_to}\n{/reply_comment}\n\n点赞数{like_count}\n举报数{report_count}\n{/qkcms:comments}', '评论循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数） </span><span class=\"generator-param-tag\">order=1排序（1最新评论-默认   &nbsp 2最早评论   &nbsp 3最热评论） </span><span class=\"generator-param-tag\">date_format=1时间格式（1如49分钟前  &nbsp  2如2025-5-5） </span><span class=\"generator-param-tag\">article_id=1（1调用全站评论   &nbsp 2调用当前文章评论）</span><span class=\"generator-param-tag\">page=1 填写此参数 可以配合绑定，分页循环标签对文章列表进行分页处理</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{author} 作者</span><span class=\"generator-template-tag\">{author_id} 主评论作者ID</span><span class=\"generator-template-tag\">{user_level} 作者等级</span><span class=\"generator-template-tag\">{date} 时间</span><span class=\"generator-template-tag\">{content} 评论内容</span><span class=\"generator-template-tag\">{article_url} 文章链接</span><span class=\"generator-template-tag\">{article_title} 文章标题</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{comment_id} 父评论ID</span><span class=\"generator-template-tag\">{user_level} 用户等级</span><span class=\"generator-template-tag\">{allow_html=1} 评论内容支持html 参数=0不支持html格式）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 回复条数限制，默认显示5条回复</span><span class=\"generator-param-tag\">reply.date=1 回复时间格式（1如49分钟前  &nbsp 2如2025-5-5）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">嵌套回复标签</h5><p style=\"margin:10px 0;\">使用 {reply_comment row=5 reply.date=1} 和 {/reply_comment} 标签包裹回复内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{reply.avatar} 回复者头像</span><span class=\"generator-template-tag\">{reply.id} 回复ID</span><span class=\"generator-template-tag\">{reply.reply_id} 回复楼层号</span><span class=\"generator-template-tag\">{reply.author} 回复者账号</span><span class=\"generator-template-tag\">{reply.user_id} 回复者账号ID</span><span class=\"generator-template-tag\">{user_reply.level} 回复者账号等级</span><span class=\"generator-template-tag\">{reply.date} 回复时间</span><span class=\"generator-template-tag\">{reply.content} 回复内容</span><span class=\"generator-template-tag\">{reply.like_count} 回复内容点赞数</span><span class=\"generator-template-tag\">{reply.reply_to} 被回复者用户名</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('413', '用户列表', 'members', 'loop', 'loop', '{qkcms:members row=5 type=1}\n<a href=\"{user_center_url}\"><img src=\"{avatar}\" alt=\"{username}\" /></a>\n用户名：{username}\n用户等级：{level}\n<span>用户点赞数：{like_count}</span>\n<span>用户举报数：{report_count}</span>\n<span>用户文章数：{post_count}</span>\n{/qkcms:members}', '用户列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">type=1 用户类型（1 最新注册用户&nbsp 2 最近登录的用户 &nbsp3 随机调用全站用户 &nbsp4 最近访问文章的用户）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{avatar} 头像</span><span class=\"generator-template-tag\">{username} 用户名</span><span class=\"generator-template-tag\">{username} 用户等级 {level}</span><span class=\"generator-template-tag\">{like_count} 点赞数</span><span class=\"generator-template-tag\">{report_count} 举报数</span><span class=\"generator-template-tag\">{post_count} 文章数</span><span class=\"generator-template-tag\">{user_center_url} 用户主页链接</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('414', '关键词', 'tags', 'loop', 'loop', '{qkcms:tags row=5 order=1}\n<a href=\"{url}\">{name}({count})</a>\n{/qkcms:tags}', '关键词循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序 (order=1时间 order=2调用次数 order=3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{name} 标签名称</span><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{count} 使用次数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('415', '导航列表', 'navigation', 'loop', 'loop', '{qkcms:navigation row=5}\n<a href=\"{url}\" target=\"{target}\">{title}</a>\n{sub_navigation}\n<a href=\"{sub.url}\" target=\"{sub.target}\">{sub.title}</a>\n{/sub_navigation}\n{/qkcms:navigation}', '导航列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{target} 目标窗口</span><span class=\"generator-template-tag\">{title} 导航标题</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">二级导航嵌套标签</h5><p style=\"margin:10px 0;\">使用 {sub_navigation} 和 {/sub_navigation} 标签包裹二级导航内容，内部可用以下子标签：</p><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{sub.id} 二级导航ID</span><span class=\"generator-template-tag\">{sub.title} 二级导航标题</span><span class=\"generator-template-tag\">{sub.url} 二级导航链接</span><span class=\"generator-template-tag\">{sub.target} 二级导航目标窗口</span><span class=\"generator-template-tag\">{sub.display_order} 二级导航排序</span><span class=\"generator-template-tag\">{sub.sub_id} 二级导航序号</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('416', '分页循环标签', 'page', 'loop', 'loop', '{qkcms:page type=1 page=1}\n {first_page}     - 首页链接\n {prev_page}      - 上一页链接\n {page_numbers}   - 数字页码链接（1 2 3 4 5）\n {next_page}      - 下一页链接\n {last_page}      - 尾页链接\n {page_status}    - 页码信息（第X页/共X页）\n {jump_to_page}   - 页码跳转下拉框\n{/qkcms:page}', '分页循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出分页导航</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=1 类型（1 文章列表分页 2 评论列表分页 3分类列表分页 4商品分页）</span><span class=\"generator-param-tag\">page=1 分页绑定标识</span><span class=\"generator-param-tag\">row 继承文章或评论列表配置</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{first_page} 首页链接</span><span class=\"generator-template-tag\">{prev_page} 上一页链接</span><span class=\"generator-template-tag\">{page_numbers} 数字页码链接</span><span class=\"generator-template-tag\">{next_page} 下一页链接</span><span class=\"generator-template-tag\">{last_page} 尾页链接</span><span class=\"generator-template-tag\">{page_status} 页码信息</span><span class=\"generator-template-tag\">{jump_to_page} 页码跳转下拉框</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">功能说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">支持首页/上一页/下一页/尾页链接</span><span class=\"generator-template-tag\">支持页码跳转功能</span><span class=\"generator-template-tag\">自动适应文章列表和评论列表</span><span class=\"generator-template-tag\">文章或评论循环标签也必须添加page=1参数才能绑定</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('417', '搜索词列表', 'search', 'loop', 'loop', '{qkcms:search row=5 order=1} \n <span>搜索词ID {id}</span>\n <span>搜索者 {username}</span>\n <span>搜索词 {search_term}</span>\n <span>搜索时间 {search_time}</span>\n <span>搜索词统计数 {count}</span>\n {/qkcms:search}', '搜索词列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span><span class=\"generator-param-tag\">order=1 排序（1最新搜索 2最多搜索 3随机）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{id} 搜索词ID</span><span class=\"generator-template-tag\">{username} 搜索者</span><span class=\"generator-template-tag\">{search_term} 搜索词</span><span class=\"generator-template-tag\">{search_time} 搜索时间</span><span class=\"generator-template-tag\">{count} 搜索词统计数</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('418', '友情链接列表', 'friendlink', 'loop', 'loop', '{qkcms:friendlink row=5} \n <a href=\"{url}\" >{title}</a>\n {/qkcms:friendlink}', '友情链接列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=5 条数</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{url} 链接</span><span class=\"generator-template-tag\">{title} 标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('419', '商品分类ID', 'goods_category_id', 'goods', 'single', '{qkcms:goods_category_id}', '商品分类ID', '', null);
INSERT INTO `tplmark` VALUES ('420', '商品分类', 'goods_category_name', 'goods', 'single', '{qkcms:goods_category_name}', '商品分类', '', null);
INSERT INTO `tplmark` VALUES ('421', '分类关键词', 'cat_keywords', 'goods', 'single', '{qkcms:cat_keywords}', '分类关键词', '', null);
INSERT INTO `tplmark` VALUES ('422', '分类描述', 'cat_description', 'goods', 'single', '{qkcms:cat_description}', '分类描述', '', null);
INSERT INTO `tplmark` VALUES ('423', '分类URL', 'cat_url', 'goods', 'single', '{qkcms:cat_url}', '分类URL', '', null);
INSERT INTO `tplmark` VALUES ('424', '商品ID', 'goods_id', 'goods', 'single', '{qkcms:goods_id}', '商品ID', '', null);
INSERT INTO `tplmark` VALUES ('425', '商品标题', 'goods_title', 'goods', 'single', '{qkcms:goods_title}', '商品标题', '', null);
INSERT INTO `tplmark` VALUES ('426', '商品关键词', 'goods_keywords', 'goods', 'single', '{qkcms:goods_keywords}', '商品关键词', '', null);
INSERT INTO `tplmark` VALUES ('427', '商品描述', 'goods_description', 'goods', 'single', '{qkcms:goods_description}', '商品描述', '', null);
INSERT INTO `tplmark` VALUES ('428', '商品详情', 'goods_content', 'goods', 'single', '{qkcms:goods_content}', '商品详情', '', null);
INSERT INTO `tplmark` VALUES ('429', '商品价格', 'goods_price', 'goods', 'single', '{qkcms:goods_price}', '商品价格', '', null);
INSERT INTO `tplmark` VALUES ('430', '商品销量', 'goods_sales', 'goods', 'single', '{qkcms:goods_sales}', '商品销量', '', null);
INSERT INTO `tplmark` VALUES ('431', '商品库存', 'goods_stock', 'goods', 'single', '{qkcms:goods_stock}', '商品库存', '', null);
INSERT INTO `tplmark` VALUES ('432', '商品状态', 'goods_status', 'goods', 'single', '{qkcms:goods_status}', '商品状态', '', null);
INSERT INTO `tplmark` VALUES ('433', '创建时间', 'goods_created_at', 'goods', 'single', '{qkcms:goods_created_at}', '创建时间', '', null);
INSERT INTO `tplmark` VALUES ('434', '更新时间', 'goods_updated_at', 'goods', 'single', '{qkcms:goods_updated_at}', '更新时间', '', null);
INSERT INTO `tplmark` VALUES ('435', '商品缩略图', 'goods_thumbnail', 'goods', 'single', '{qkcms:goods_thumbnail}', '商品缩略图', '', null);
INSERT INTO `tplmark` VALUES ('436', '商品链接', 'goods_url', 'goods', 'single', '{qkcms:goods_url}', '商品链接', '', null);
INSERT INTO `tplmark` VALUES ('437', '商品规格', 'goods_specs', 'goods', 'single', '{qkcms:goods_specs}', '商品规格', '', null);
INSERT INTO `tplmark` VALUES ('438', '商品视频URL', 'goods_mp4url', 'goods', 'single', '{qkcms:goods_mp4url}', '商品视频URL', '', null);
INSERT INTO `tplmark` VALUES ('439', '商品图片循环', 'goods_images', 'goods', 'loop', '{qkcms:goods_images type=specs}\n<img src=\"{image.url}\" alt=\"{image.title}\">\n{/qkcms:goods_images}', '商品图片循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">type=specs 类型（specs规格图 images商品图）</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{image.url} 图片URL</span><span class=\"generator-template-tag\">{image.title} 图片标题</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('440', '商品列表循环', 'goods', 'goods', 'loop', '{qkcms:goods row=8 type=new where=status=1}\n<span>分类关键词: {qkcms:cat_keywords}</span>\n<span>分类描述: {qkcms:cat_description}</span>\n<span>分类URL: {qkcms:cat_url}</span>\n<img src=\"{goods.thumbnail}\" alt=\"{goods.title}\">\n<h4><a href=\"{goods.url}\">{goods.title}</a></h4>\n<span>商品链接: {goods.url}</span>\n<span>商品规格: {goods.specs}</span>\n<span>视频URL: {goods.mp4url}</span>\n<span>ID: {goods.id}</span>\n<span>价格: ¥{goods.price}</span>\n<span>销量: {goods.sales}</span>\n<span>库存: {goods.stock}</span>\n<span>分类ID: {goods.category_id}</span>\n<span>分类: <a href=\"{goods.category_url}\">{goods.category_name}</a></span>\n<span>创建时间: {goods.create_time}</span>\n<span>更新时间: {goods.update_time}</span>\n{/qkcms:goods}', '商品列表循环标签', '<div class=\"generator-tag-container\"><p class=\"generator-info-text\">《${tagNameCN}》循环标签，用于输出${tagNameCN}列表</p><div class=\"generator-card\"><h5 class=\"generator-section-title\">参数说明</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-param-tag\">row=8 条数</span><span class=\"generator-param-tag\">type=new 类型（new最新 hot热门 recommend推荐）</span><span class=\"generator-param-tag\">where=status=1 条件筛选（status=1上架 status=0下架）</span><span class=\"generator-param-tag\">category_id 分类ID</span></div></div><div class=\"generator-card\"><h5 class=\"generator-section-title\">子标签</h5><div style=\"display:flex;flex-wrap:wrap;gap:10px\"><span class=\"generator-template-tag\">{goods.id} 商品ID</span><span class=\"generator-template-tag\">{goods.title} 商品标题</span><span class=\"generator-template-tag\">{goods.url} 商品链接</span><span class=\"generator-template-tag\">{goods.thumbnail} 商品缩略图</span><span class=\"generator-template-tag\">{goods.price} 商品价格</span><span class=\"generator-template-tag\">{goods.sales} 商品销量</span><span class=\"generator-template-tag\">{goods.stock} 商品库存</span><span class=\"generator-template-tag\">{goods.specs} 商品规格</span><span class=\"generator-template-tag\">{goods.mp4url} 商品视频URL</span><span class=\"generator-template-tag\">{goods.category_id} 分类ID</span><span class=\"generator-template-tag\">{goods.category_name} 分类名称</span><span class=\"generator-template-tag\">{goods.category_url} 分类链接</span><span class=\"generator-template-tag\">{goods.create_time} 创建时间</span><span class=\"generator-template-tag\">{goods.update_time} 更新时间</span></div></div></div>', null);
INSERT INTO `tplmark` VALUES ('441', '顶级栏目（双）循环标签', 'catgroup', 'loop', 'loop', '{qkcms:catgroup row=10 order=1 filter=17,16,15,14,13,12,11}\r\n\r\n<h3><a href=\"/catgroup_id{id}.php\">{group_name}</a></h3>\r\n<p>顶级关键词：{group_keywords}</p>\r\n<p>顶级描述：{group_description}</p>\r\n\r\n{qkcms:categories row=10 sa=1 sort=1 filter=70,39,29,19}\r\n<h4><a href=\"{url}\">{name}</a></h4>\r\n<p>子栏目文章数：{count}</p>\r\n<p>子栏目关键词：{keywords}</p>\r\n<p>子栏目描述：{description}</p>\r\n{/qkcms:categories}\r\n\r\n{/qkcms:catgroup}', '', '<div class=\"generator-tag-container\">\r\n\r\n<p class=\"generator-info-text\">《顶级栏目+子栏目》双循环标签，用于输出指定/全站顶级栏目及其子栏目列表（不含文章循环）</p>\r\n\r\n<div class=\"generator-card\">\r\n\r\n<h5 class=\"generator-section-title\">外循环标签（qkcms:catgroup）参数说明</h5>\r\n\r\n<div style=\"display:flex;flex-wrap:wrap;gap:10px\">\r\n\r\n<span class=\"generator-param-tag\">row=10 条数</span>\r\n\r\n<span class=\"generator-param-tag\">id=12 指定顶级栏目ID（可选）</span>\r\n\r\n<span class=\"generator-param-tag\">filter=17,16,15 排除顶级栏目ID（支持多个，英文逗号分隔）</span>\r\n\r\n<span class=\"generator-param-tag\">order=1 排序（1按sort升序-默认  2按sort降序  3按ID升序  4按ID降序  5随机）</span>\r\n\r\n<span class=\"generator-param-tag\">current=1 当前顶级栏目（可选）</span>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"generator-card\">\r\n\r\n<h5 class=\"generator-section-title\">外循环子标签（qkcms:catgroup）</h5>\r\n\r\n<div style=\"display:flex;flex-wrap:wrap;gap:10px\">\r\n\r\n<span class=\"generator-template-tag\">{id} 顶级栏目ID</span>\r\n\r\n<span class=\"generator-template-tag\">{group_name} 顶级栏目名称</span>\r\n\r\n<span class=\"generator-template-tag\">{group_title} SEO标题</span>\r\n\r\n<span class=\"generator-template-tag\">{group_keywords} SEO关键词</span>\r\n\r\n<span class=\"generator-template-tag\">{group_description} SEO描述</span>\r\n\r\n<span class=\"generator-template-tag\">{color} 颜色</span>\r\n\r\n<span class=\"generator-template-tag\">{sort} 排序值</span>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n<div class=\"generator-card\">\r\n\r\n<h5 class=\"generator-section-title\">内循环标签（qkcms:categories）参数说明</h5>\r\n\r\n<div style=\"display:flex;flex-wrap:wrap;gap:10px\">\r\n\r\n<span class=\"generator-param-tag\">row=10 条数（默认10）</span>\r\n\r\n<span class=\"generator-param-tag\">sa=1 显示全部（sa=2仅显示开启展示）</span>\r\n\r\n<span class=\"generator-param-tag\">sort=1 排序（1最新  2最早  3按规则排序  4随机）</span>\r\n\r\n<span class=\"generator-param-tag\">keyword=关键词 栏目关键词搜索（可选）</span>\r\n\r\n<span class=\"generator-param-tag\">filter=101,102 排除子栏目ID（支持多个，英文逗号分隔）</span>\r\n\r\n<span class=\"generator-param-tag\">page=1 绑定分页标识（可选）</span>\r\n\r\n</div>\r\n\r\n<p style=\"margin:10px 0;\">在 <code>{qkcms:catgroup}{/qkcms:catgroup}</code> 内部使用时，系统会自动把当前顶级栏目ID桥接给内层 categories（自动按当前顶级栏目取子栏目）。</p>\r\n\r\n</div>\r\n\r\n<div class=\"generator-card\">\r\n\r\n<h5 class=\"generator-section-title\">内循环子标签（qkcms:categories）</h5>\r\n\r\n<div style=\"display:flex;flex-wrap:wrap;gap:10px\">\r\n\r\n<span class=\"generator-template-tag\">{id} 子栏目ID</span>\r\n\r\n<span class=\"generator-template-tag\">{name} 子栏目名称</span>\r\n\r\n<span class=\"generator-template-tag\">{url} 子栏目链接</span>\r\n\r\n<span class=\"generator-template-tag\">{count} 子栏目文章数</span>\r\n\r\n<span class=\"generator-template-tag\">{keywords} 子栏目关键词</span>\r\n\r\n<span class=\"generator-template-tag\">{description} 子栏目描述</span>\r\n\r\n<span class=\"generator-template-tag\">{thumbnail} 子栏目缩略图</span>\r\n\r\n<span class=\"generator-template-tag\">{parent_id} 父级ID</span>\r\n\r\n</div>\r\n\r\n</div>\r\n\r\n</div>', '11');
INSERT INTO `tplmark` VALUES ('445', '关键词链接', 'posts_keywords_links', 'article', 'single', '{qkcms:posts_keywords_links}', '《关键词链接》标签说明：单值标签，用于输出关键词链接内容', '', '6');
INSERT INTO `tplmark` VALUES ('446', '关键词+链接', 'cat_keywords_links', 'category', 'single', '{qkcms:cat_keywords_links}', '《关键词+链接》标签说明：单值标签，用于输出关键词+链接内容', '', '7');
INSERT INTO `tplmark` VALUES ('447', '子栏目SEO标题', 'cat_seo_title', 'category', 'single', '{qkcms:cat_seo_title}', '《子栏目SEO标题》标签说明：单值标签，用于输出子栏目SEO标题内容', '', '2');
INSERT INTO `tplmark` VALUES ('449', '顶级栏目（单）循环标签', 'catgroup1', 'loop', 'loop', '{qkcms:catgroup row=10 order=3 filter=17,16,15}\r\n\r\n  <h3><a href=\"{url}\">{group_name}</a></h3>\r\n  <p>顶级SEO标题：{group_title}</p>\r\n  <p>顶级关键词：{group_keywords}</p>\r\n  <p>顶级关键词链接：{group_keywords_links}</p>\r\n  <p>顶级描述：{group_description}</p>\r\n  <p>类型：{item_type}</p>\r\n  <p>颜色：{color}</p>\r\n  <p>排序：{sort}</p>\r\n  <p>创建时间：{created}</p>\r\n  <p>更新时间：{updated}</p>\r\n\r\n{/qkcms:catgroup}', '', '', '10');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(100) DEFAULT NULL,
  `levels_id` int(11) DEFAULT '1',
  `avatar` varchar(255) DEFAULT NULL,
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(20) DEFAULT NULL,
  `points` int(11) DEFAULT '0',
  `bio` text,
  `bought` text,
  `tool_bought` text,
  `address` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `idx_levels_id` (`levels_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', '$2y$10$rveUzWIueJLxKl8mYj.Nqe5BwBHL0.7PawnYwYD4HLiTnt5o2m29q', 'admin@example.com', '3', '/assets/images/admin.jpg', '2026-05-21 10:57:49', '2025-04-10 02:19:30', '1', '100', 'QKCMS快速建站18', '', null, null);
INSERT INTO `users` VALUES ('2', '75083eb990', 'e10adc3949ba59abbe56e057f20f883e', '0655f656@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10001&s=100', '2025-12-08 14:15:15', '2024-03-02 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('3', '2c6fb3dda5', 'e10adc3949ba59abbe56e057f20f883e', '0d221@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10002&s=100', '2025-09-25 01:22:09', '2024-02-10 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('4', 'ffd80bd', 'e10adc3949ba59abbe56e057f20f883e', '86dd8f7f@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10003&s=100', '2024-06-22 08:45:34', '2024-03-25 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('5', '47ecd14', 'e10adc3949ba59abbe56e057f20f883e', '9c828cc6@example.com', '2', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10004&s=100', '2026-03-24 17:39:36', '2024-03-31 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('6', 'd70d0', 'e10adc3949ba59abbe56e057f20f883e', '6adacc@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10005&s=100', '2024-07-17 16:22:31', '2024-02-27 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('7', '321970dd', 'e10adc3949ba59abbe56e057f20f883e', '8d1ae3@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10006&s=100', '2025-06-18 03:19:07', '2024-03-08 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('8', 'eafa223e6', 'e10adc3949ba59abbe56e057f20f883e', '671df87575@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10007&s=100', '2024-10-04 04:15:10', '2024-03-25 00:00:00', '1', '0', null, null, null, null);
INSERT INTO `users` VALUES ('9', 'c8bc49', 'e10adc3949ba59abbe56e057f20f883e', 'c50313@example.com', '1', 'https://thirdqq.qlogo.cn/g?b=qq&nk=10008&s=100', '2026-05-21 01:34:46', '2024-03-24 00:00:00', '0', '0', null, null, null, null);

-- ----------------------------
-- Table structure for usvisits
-- ----------------------------
DROP TABLE IF EXISTS `usvisits`;
CREATE TABLE `usvisits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visitorid` int(11) NOT NULL,
  `visitedid` int(11) NOT NULL,
  `visittime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_visit` (`visitorid`,`visitedid`),
  KEY `idx_visitorid` (`visitorid`),
  KEY `idx_visitedid` (`visitedid`),
  KEY `idx_visittime` (`visittime`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of usvisits
-- ----------------------------
INSERT INTO `usvisits` VALUES ('1', '1', '-11', '2026-05-20 19:38:13');
INSERT INTO `usvisits` VALUES ('2', '1', '-1', '2026-05-20 19:38:59');
INSERT INTO `usvisits` VALUES ('3', '1', '-2', '2026-05-20 19:39:03');
INSERT INTO `usvisits` VALUES ('4', '1', '-3', '2026-05-20 19:39:05');
INSERT INTO `usvisits` VALUES ('5', '1', '-4', '2026-05-20 19:39:08');
INSERT INTO `usvisits` VALUES ('6', '1', '-5', '2026-05-20 19:39:10');
INSERT INTO `usvisits` VALUES ('7', '1', '-6', '2026-05-20 19:39:13');
INSERT INTO `usvisits` VALUES ('8', '1', '-7', '2026-05-20 19:39:16');
INSERT INTO `usvisits` VALUES ('9', '1', '-8', '2026-05-20 19:39:19');
INSERT INTO `usvisits` VALUES ('10', '1', '-9', '2026-05-20 19:39:22');
INSERT INTO `usvisits` VALUES ('11', '1', '-10', '2026-05-21 02:14:21');

-- ----------------------------
-- Table structure for visit
-- ----------------------------
DROP TABLE IF EXISTS `visit`;
CREATE TABLE `visit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_time` (`time`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of visit
-- ----------------------------
INSERT INTO `visit` VALUES ('1', '2026-05-15 00:49:18', '127.0.0.1');
