[共享]实现霹雳996X版本WEB网站后台无法正常发套装的解决办法！|奇迹Mu技术 - 梦想仙境中文官方社区论坛

离线绝情风

骑士

发帖: 324

祝福宝石: -1

威望: 1770

玛雅之石: 0

创造宝石: 0

只看楼主倒序阅读使用道具楼主发表于: 2006-09-08

把以下代码复制到SQL查询分析器选择MuOnline数据库执行下即可（注意：是使用霹雳网站996X版的才支持哦，是对1.0M版用的）

delete from web_membitem
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('安吉拉的风套装','32','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','EC6C540000000040093D','0C6C5400000000C0093D','2C6C5400000000C0093D','4C6C5400000000C0093D','6C6C5400000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('安吉拉的精灵套装','32','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','0D6C5A00000000C0093D','2D6C5A00000000C0093D','4D6C5A00000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('汉斯的白金套装','128','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','096C6600000000C0093D','FFFFFFFFFFFFFFFFFFFF','496C6600000000C0093D','696C6600000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','A9003200000000C0093D','B7003200000000C0093D','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('汉斯的黄金套装','128','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','086C6000000000C0093D','286C6000000000C0093D','486C6000000000C0093D','686C6000000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','AD003200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('汉斯的龙王套装','128','9','0EEC660000000040093D','FFFFFFFFFFFFFFFFFFFF','E16C780000000040093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','416C7800000000C0093D','616C7800000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('火首饰套件','128','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','AD6CFF00000000FFAE00','A86CFF00000000FF0000','A96CFF00000000FFB400','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('魔导半套','1','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','F66CFF000000007FC400','166CFF00000000FF3D00','366CFF00000000FF1400','566CFF00000000FF2700','766CFF00000000FFDB00','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('魔导全套','1','1','AB6CFF000000007F8D00','CFECFF000000007F5500','F66CFF000000007FC400','166CFF00000000FF3D00','366CFF00000000FF1400','566CFF00000000FF2700','766CFF00000000FFDB00','846CFF00000000FF3D00','FFFFFFFFFFFFFFFFFFFF','AC6CFF00000000FFEC00','A86CFF00000000FFBC00','A96CFF00000000FFE500','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('魔剑半套','48','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','176C8900000000FF0000','376C8900000000FF0000','576C8900000000FF0000','776C8900000000FF0000','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('帕希的魔王套装','0','9','FFFFFFFFFFFFFFFFFFFF','C6EC560000000040093D','E76C580000000040093D','076C5800000000C0093D','276C5800000000C0093D','476C5800000000C0093D','676C5800000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('骑士半套','17','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','F56CFF000000007FD100','156CFF00000000FFDB00','356CFF00000000FFB200','556CFF00000000FFD000','756CFF00000000FFCE00','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('骑士全套','17','1','14ECFF000000007FE800','CDECFF000000007FB500','F56CFF000000007FD100','156CFF00000000FFDB00','356CFF00000000FFB200','556CFF00000000FFD000','756CFF00000000FFCE00','856CFF00000000FFAF00','FFFFFFFFFFFFFFFFFFFF','AD6CFF00000000FFAE00','A86CFF00000000FF0000','A96CFF00000000FFB400','14ECFFFFFFD8297F0B00')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('安吉拉的女神套装','32','9','FFFFFFFFFFFFFFFFFFFF','85EC640000000040093D','FFFFFFFFFFFFFFFFFFFF','0E6C6100000000C0093D','FFFFFFFFFFFFFFFFFFFF','4E6C6100000000C0093D','6E6C6100000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','BC043200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('安吉拉的藤套装','32','9','02EC4B0000000040093D','FFFFFFFFFFFFFFFFFFFF','EA6C4A0000000040093D','FFFFFFFFFFFFFFFFFFFF','2A6C4A00000000C0093D','4A6C4A00000000C0093D','6A6C4A00000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','B6003200000000C00005','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('安吉拉的天蚕套装','32','9','89EC4E0000000040093D','FFFFFFFFFFFFFFFFFFFF','EB6C4E0000000040093D','0B6C4E00000000C0093D','2B6C4E00000000C0093D','4B6C4E00000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('圣导半套','64','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FC6CFF000000007F110F','1C6CFF00000000FF5744','3C6CFF00000000FFE263','5C6CFF00000000FF4E30','7C6CFF00000000FFA957','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('圣导全套','64','1','4C6CFF000000007F6600','CBECFF000000007FE700','FC6CFF000000007F1100','1C6CFF00000000FF5700','3C6CFF00000000FFE200','5C6CFF00000000FF4E00','7C6CFF00000000FFA900','BE6CFF00000000FFC000','FFFFFFFFFFFFFFFFFFFF','AC686100000000FF0000','A8686100000000FF0000','A9686100000000FF0000','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('圣射手全套','33','1','FFFFFFFFFFFFFFFFFFFF','94ECFF000000007F0000','F86CFF000000007F0000','186CFF00000000FF0000','386CFF00000000FF0000','586CFF00000000FF0000','786CFF00000000FF0000','836CFF00000000DF2900','FFFFFFFFFFFFFFFFFFFF','AD6CFF00000000FFB000','A86CFF00000000FFA100','A96CFF00000000FF1D00','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('战士红龙套','0','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('汉斯的翡翠套装','128','9','FFFFFFFFFFFFFFFFFFFF','C9EC5A0000000040093D','E66C5C0000000040093D','066C5C00000000C0093D','266C5C00000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','AC043200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('汉斯的皮套装','128','9','41EC4D0000000040093D','FFFFFFFFFFFFFFFFFFFF','E56C520000000040093D','056C5200000000C0093D','256C5200000000C0093D','456C5200000000C0093D','656C5200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','A8003200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('汉斯的青铜套装','128','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','006C5600000000C0093D','206C5600000000C0093D','FFFFFFFFFFFFFFFFFFFF','606C5600000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('凯文的亚特兰蒂斯套装','48','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','0F6C8400000000C0093D','2F6C8400000000C0093D','FFFFFFFFFFFFFFFFFFFF','6F6C8400000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','BB043200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('雷首饰套件','128','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','AC6CFF00000000FFEF00','A86CFF00000000FF0000','A96CFF00000000FFB400','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('魔剑全套','48','1','15ECFF000000007F0000','CDEC6B000000007F0000','FFFFFFFFFFFFFFFFFFFF','176C8900000000FF0000','376C8900000000FF0000','576C8900000000FF0000','776C8900000000FF0000','866CE800000000DF0000','FFFFFFFFFFFFFFFFFFFF','AC686100000000FF0000','A8686100000000FF0000','A9686100000000FF0000','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('帕希的传说之套装','0','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','E36C5E0000000040093D','036C5E00000000C0093D','FFFFFFFFFFFFFFFFFFFF','436C5E00000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','B5003200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('帕希的革套装','0','9','A06C480000000040093D','FFFFFFFFFFFFFFFFFFFF','E26C500000000040093D','026C5000000000C0093D','226C5000000000C0093D','426C5000000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','B9683F00000000C0093D','B8003200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('帕希的骷髅套装','0','9','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','046C5200000000C0093D','246C5200000000C0093D','FFFFFFFFFFFFFFFFFFFF','646C5200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','BA003200000000C0093D','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')
insert into web_membitem(MEMBTYPE,CLASS,MEMBLVL,PS0,PS1,PS2,PS3,PS4,PS5,PS6,PS7,PS8,PS9,PS10,PS11,PS12) values('圣射手半套','33','0','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','F86CFF000000007F0000','186CFF00000000FF0000','386CFF00000000FF0000','586CFF00000000FF0000','786CFF00000000FF0000','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF','FFFFFFFFFFFFFFFFFFFF')