初始化漂泊官方图片库

51漂泊 · 发表于 2020-3-28 20:44:28

很多朋友说他不想一个一个添加礼品，有没有更加简单的方法，今天漂泊决定把官方礼品库开放给大家：

pre_

复制代码

替换成您数据库的表前缀！非常重要！！！

第一步：导入分类

INSERT INTO `pre_piaobo_gift_center_type` VALUES (1, '友情');
INSERT INTO `pre_piaobo_gift_center_type` VALUES (2, '生日');
INSERT INTO `pre_piaobo_gift_center_type` VALUES (3, '爱情');
INSERT INTO `pre_piaobo_gift_center_type` VALUES (4, '恶搞');
INSERT INTO `pre_piaobo_gift_center_type` VALUES (5, '节日');

复制代码

第二步：导入商品库

INSERT INTO `pre_piaobo_gift_center_details` VALUES (1, 1, '友情', 'iPhone4S', 'source/plugin/piaobo_gift_center/images/20200327093932.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (2, 1, '友情', '智慧奖牌', 'source/plugin/piaobo_gift_center/images/20200327093944.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (3, 1, '友情', '2012船票', 'source/plugin/piaobo_gift_center/images/20200327093959.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (4, 1, '友情', '爱心圣诞', 'source/plugin/piaobo_gift_center/images/20200327094012.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (5, 1, '友情', '草莓巧克力', 'source/plugin/piaobo_gift_center/images/20200327094037.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (6, 1, '友情', '防辐射服', 'source/plugin/piaobo_gift_center/images/20200327094054.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (7, 1, '友情', '防寒帽', 'source/plugin/piaobo_gift_center/images/20200327094108.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (8, 1, '友情', '粉色帆布鞋', 'source/plugin/piaobo_gift_center/images/20200327094118.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (9, 1, '友情', '汉堡包', 'source/plugin/piaobo_gift_center/images/20200327094149.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (10, 4, '恶搞', '豪华小汽车', 'source/plugin/piaobo_gift_center/images/20200327094235.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (11, 3, '爱情', '红色小车', 'source/plugin/piaobo_gift_center/images/20200327094347.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (12, 5, '节日', '为人民服务背包', 'source/plugin/piaobo_gift_center/images/20200327094410.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (13, 5, '节日', '元旦快乐', 'source/plugin/piaobo_gift_center/images/20200327094451.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (14, 4, '恶搞', '革命光荣杯', 'source/plugin/piaobo_gift_center/images/20200327094517.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (15, 4, '恶搞', '黄色奥迪', 'source/plugin/piaobo_gift_center/images/20200327094539.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (16, 5, '节日', '金福杯', 'source/plugin/piaobo_gift_center/images/20200327094623.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (17, 4, '恶搞', '加碘盐', 'source/plugin/piaobo_gift_center/images/20200327094639.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (18, 3, '爱情', '家和万事兴', 'source/plugin/piaobo_gift_center/images/20200327094712.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (19, 4, '恶搞', '打酱油', 'source/plugin/piaobo_gift_center/images/20200327094736.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (20, 4, '恶搞', '百宝囊', 'source/plugin/piaobo_gift_center/images/20200327094803.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (21, 2, '生日', '热水袋', 'source/plugin/piaobo_gift_center/images/20200327094825.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (22, 5, '节日', '圣诞老人', 'source/plugin/piaobo_gift_center/images/20200327094844.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (23, 5, '节日', '圣诞帽', 'source/plugin/piaobo_gift_center/images/20200327094901.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (24, 4, '恶搞', '收音机', 'source/plugin/piaobo_gift_center/images/20200327094923.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (25, 5, '节日', '照相机', 'source/plugin/piaobo_gift_center/images/20200327094944.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (26, 5, '节日', '圣诞树', 'source/plugin/piaobo_gift_center/images/20200327095003.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (27, 3, '爱情', '爱情香槟', 'source/plugin/piaobo_gift_center/images/20200327095024.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (28, 3, '爱情', '祝福香囊', 'source/plugin/piaobo_gift_center/images/20200327095048.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (29, 5, '节日', '包子', 'source/plugin/piaobo_gift_center/images/20200327095111.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (30, 3, '爱情', '长长久久梳', 'source/plugin/piaobo_gift_center/images/20200327095139.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (31, 5, '节日', '幸福到家', 'source/plugin/piaobo_gift_center/images/20200327095201.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (32, 4, '恶搞', '春运火车票', 'source/plugin/piaobo_gift_center/images/20200327095222.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (33, 3, '爱情', '大碗宽面', 'source/plugin/piaobo_gift_center/images/20200327095248.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (34, 1, '友情', '求交往', 'source/plugin/piaobo_gift_center/images/20200327095308.png', 3, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (35, 4, '恶搞', '骗我变如花', 'source/plugin/piaobo_gift_center/images/20200327095331.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (36, 3, '爱情', '幸福围巾', 'source/plugin/piaobo_gift_center/images/20200327095354.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (37, 3, '爱情', '保暖耳套', 'source/plugin/piaobo_gift_center/images/20200327095428.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (38, 3, '爱情', '999朵玫瑰', 'source/plugin/piaobo_gift_center/images/20200327095506.png', 5, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (39, 3, '爱情', '手捧鲜花', 'source/plugin/piaobo_gift_center/images/20200327095528.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (40, 1, '友情', '活雷锋', 'source/plugin/piaobo_gift_center/images/20200327095551.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (41, 3, '爱情', '恩爱米奇与米妮', 'source/plugin/piaobo_gift_center/images/20200327095633.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (42, 3, '爱情', '爱心小熊', 'source/plugin/piaobo_gift_center/images/20200327095650.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (43, 3, '爱情', '心心相印锁', 'source/plugin/piaobo_gift_center/images/20200327095716.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (44, 3, '爱情', '比翼双飞鸟', 'source/plugin/piaobo_gift_center/images/20200327095754.png', 5, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (45, 2, '生日', '爱心蛋糕', 'source/plugin/piaobo_gift_center/images/20200327095818.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (46, 3, '爱情', '最佳老公', 'source/plugin/piaobo_gift_center/images/20200327095841.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (47, 3, '爱情', '最佳老婆', 'source/plugin/piaobo_gift_center/images/20200327095857.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (48, 4, '恶搞', '家里蹲大学毕业证', 'source/plugin/piaobo_gift_center/images/20200327095922.png', 3, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (49, 4, '恶搞', '美如花', 'source/plugin/piaobo_gift_center/images/20200327095947.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (50, 3, '爱情', '帅帅帅', 'source/plugin/piaobo_gift_center/images/20200327100011.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (51, 4, '恶搞', '艰难决定', 'source/plugin/piaobo_gift_center/images/20200327100038.png', 3, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (52, 4, '恶搞', '粑粑', 'source/plugin/piaobo_gift_center/images/20200327100101.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (53, 3, '爱情', '寻觅男友', 'source/plugin/piaobo_gift_center/images/20200327100123.png', 3, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (54, 3, '爱情', '众里寻他千百度', 'source/plugin/piaobo_gift_center/images/20200327100158.png', 3, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (55, 5, '节日', '变幅', 'source/plugin/piaobo_gift_center/images/20200327100222.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (56, 5, '节日', '端午安康', 'source/plugin/piaobo_gift_center/images/20200327100243.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (57, 1, '友情', '光棍一条', 'source/plugin/piaobo_gift_center/images/20200327100313.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (58, 5, '节日', '元宝福地', 'source/plugin/piaobo_gift_center/images/20200327100523.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (59, 4, '恶搞', '魔法棒', 'source/plugin/piaobo_gift_center/images/20200327100809.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (60, 5, '节日', '万事如意', 'source/plugin/piaobo_gift_center/images/20200327100829.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (61, 5, '节日', '阖家欢乐', 'source/plugin/piaobo_gift_center/images/20200327100853.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (62, 2, '生日', '南瓜蛋糕', 'source/plugin/piaobo_gift_center/images/20200327100918.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (63, 5, '节日', '女巫帽', 'source/plugin/piaobo_gift_center/images/20200327100946.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (64, 5, '节日', '五芳斋粽子', 'source/plugin/piaobo_gift_center/images/20200327101011.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (65, 5, '节日', '南瓜灯', 'source/plugin/piaobo_gift_center/images/20200327101033.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (66, 5, '节日', '噼里啪啦', 'source/plugin/piaobo_gift_center/images/20200327101106.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (67, 2, '生日', '顶级蛋糕', 'source/plugin/piaobo_gift_center/images/20200327101132.png', 0, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (68, 2, '生日', '爱心蛋糕', 'source/plugin/piaobo_gift_center/images/20200327101152.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (69, 5, '节日', '恭喜发财', 'source/plugin/piaobo_gift_center/images/20200327101224.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (70, 2, '生日', '巧克力蛋糕', 'source/plugin/piaobo_gift_center/images/20200327101259.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (71, 2, '生日', '生日快乐', 'source/plugin/piaobo_gift_center/images/20200327101326.png', 2, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (72, 2, '生日', '软绵绵蛋糕', 'source/plugin/piaobo_gift_center/images/20200327101345.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (73, 2, '生日', '樱桃蛋糕', 'source/plugin/piaobo_gift_center/images/20200327101410.png', 1, 2, 1);
INSERT INTO `pre_piaobo_gift_center_details` VALUES (74, 5, '节日', '幸福手套', 'source/plugin/piaobo_gift_center/images/20200327101437.png', 0, 2, 1);

复制代码

第三步：下载附件上传至插件目录图片附件：

source\plugin\piaobo_gift_center\images

复制代码

images.zip (附件大小:785.58KB,下载次数:0)

游客, 本次购买需花费金钱 50才能浏览购买附件

帐号		自动登录	找回密码
密码			立即注册

[使用教程] 初始化漂泊官方图片库

本帖子中包含更多资源