大话2天梯自用完美纯净版服务端+附赠冲级礼包修复脚本

链接: https://pan.baidu.com/s/1pKO8HqKSbB9fXv_KN8USFw
提取码: k68i
有需要的直接拿去吧~修复了所有已知和未知BUG！

冲级礼包修复脚本↓
N12新建查询

COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."ID" IS '礼包 id';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."PACKTYPE" IS '礼包类型';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."PACKGRADETYPE" IS '礼包级别';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."PACKGRADE" IS '领取等级';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."PACKGOODS" IS '领取的物品';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."GETNUMBER" IS '当前礼包领取次数';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."DATETIME" IS '异动时间';
COMMENT ON COLUMN "WJTEST"."CHONGJIPACK"."CANPAYMONEY" IS '获取需要支付的金额';



INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('2', '1', '1', '30', '物品=7065$1&212$5&729$5&81239$5&789$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('3', '1', '2', '70', '物品=7065$1&212$5&729$5&81239$5&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('4', '1', '3', '102', '物品=7065$1&212$5&729$5&81239$5&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('5', '1', '4', '1转70', '物品=7065$1&212$5&729$5&81239$5&81068$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('6', '1', '5', '1转100', '物品=7065$1&212$5&729$5&81239$5&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('7', '1', '6', '1转122', '物品=7065$1&212$5&729$5&81239$5&81154$5', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('8', '2', '1', '30', '物品=7070$1&191$3&730$10&891$10&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('9', '2', '2', '70', '物品=7070$1&191$3&730$10&891$10&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('10', '2', '3', '102', '物品=7070$1&191$3&730$10&891$10&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('11', '2', '4', '1转70', '物品=7070$1&191$3&730$10&891$10&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('12', '2', '5', '1转100', '物品=7070$1&8411$3&730$10&891$10&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('13', '2', '6', '1转122', '物品=7070$1&8411$3&730$10&891$10&81154$1', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('14', '3', '1', '30', '物品=7075$1&80124$10&770$5&770$2&890$5', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('15', '3', '2', '70', '物品=7075$1&80124$10&770$5&770$2&890$5', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('16', '3', '3', '102', '物品=7075$1&80124$10&770$5&770$2&890$5', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('17', '3', '4', '1转70', '物品=7075$1&80124$10&770$5&770$2&890$5', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('18', '3', '5', '1转100', '物品=7075$1&80124$10&770$5&770$2&81154$2', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('19', '3', '6', '1转122', '物品=7075$1&80124$10&770$5&820$1&81154$2', '1', null, '0', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('20', '4', '1', '30', '物品=0&81124$10$100&890$5$100&810$1$100&802$1$100&92394$1$100&', '1', null, '30', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('21', '4', '2', '30', '物品=0&81124$50$100&81222$100$100&808$1$100&809$1$100&807$1$100&', '1', null, '100', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('22', '4', '3', '30', '物品=0&81124$100$100&81222$200$100&92311$100$100&92312$100$100', '1', null, '300', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('23', '4', '4', '30', '物品=0&81124$100$100&81222$200$100&92311$150$100&92312$150$100&771$1$100', '1', null, '500', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('24', '4', '5', '30', '物品=0&81124$200$100&81222$200$100&92311$200$100&92312$200$100&771$2$100', '1', null, '1000', null);
INSERT INTO "WJTEST"."CHONGJIPACK" VALUES ('25', '4', '6', '30', '物品=0&81124$300$100&81222$200$100&771$3$100&700005$1$100', '1', null, '2000', null);