add đồ sum vào webshop 0.9 của bác BCS

[vuhiep88]

bác nào hương dẫn em add đồ của sum vào cái webshop 0.9 của bác BCS với em add mãi không được

[hateroc22]

chay query là đc thôi .Sửa lại DB 1 chút

[hateroc22]

INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (404,39,7,1,'Mistery Helm',290,2,2,0,0,0,0,1,0,1,1,1,0,7,0,0,0,0,1,0,0) ;
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (405,40,7,1,'Red Wing Helm',300,2,2,0,0,0,0,1,0,1,1,1,0,7,0,0,0,0,1,0,0) ;
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (406,41,7,1,'Ancient Helm',320,2,2,0,0,0,0,1,0,1,1,1,0,7,0,0,0,0,1,0,0) ;
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (404,42,7,1,'Black Rose Helm',290,2,2,0,0,0,0,1,0,1,1,1,0,7,0,0,0,0,1,0,0) ;
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (405,43,7,1,'Aura Helm',300,2,2,0,0,0,0,1,0,1,1,1,0,7,0,0,0,0,1,0,0) ;
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (406,44,7,1,'Lilium Helm',320,2,2,0,0,0,0,1,0,1,1,1,0,7,0,0,0,0,1,0,0) ;
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (413,53,7,1,'Queen Armor',330,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (407,39,8,1,'Mistery Armor',244,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (408,40,8,1,'Red Wing Armor',260,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (409,41,8,1,'Ancient Armor',280,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (410,42,8,1,'Black Rose Armor',290,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (411,43,8,1,'Aura Armor',300,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (412,44,8,1,'Lilium Armor',310,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (413,53,8,1,'Queen Armor',330,2,3,0,0,0,0,1,0,1,1,1,0,8,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (415,39,9,1,'Mistery Pants',244,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (416,40,9,1,'Red Wing Pants',260,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (417,41,9,1,'Ancient Pants',270,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (418,42,9,1,'Black Rose Pants',280,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (419,43,9,1,'Aura Pants',290,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (420,44,9,1,'Lilium Pants',300,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (421,53,9,1,'Queen Pants',310,2,2,0,0,0,0,1,0,1,1,1,0,9,0,0,0,0,1,0,0 );
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (423,39,10,1,'Mistery Gloves',244,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (424,40,10,1,'Red Wing Gloves',260,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (425,41,10,1,'Ancient Gloves',270,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (426,42,10,1,'Black Rose Gloves',280,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (428,43,10,1,'Aura Gloves',290,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (429,44,10,1,'Lilium Gloves',300,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (430,53,10,1,'Queen Gloves',310,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (423,39,11,1,'Mistery Boots',244,2,2,0,0,0,0,1,0,1,1,1,0,10,0,0,0,0,1,0 ,0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (432,40,11,1,'Red Wing Boots',260,2,2,0,0,0,0,1,0,1,1,1,0,11,0,0,0,0,1,0, 0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (433,41,11,1,'Ancient Boots',270,1,1,0,0,0,0,1,0,1,1,1,0,11,0,0,0,0,1,0, 0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (434,42,11,1,'Black Rose Boots',270,2,2,0,0,0,0,1,0,1,1,1,0,11,0,0,0,0,1,0, 0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (435,43,11,1,'Aura Boots',270,2,2,0,0,0,0,1,0,1,1,1,0,11,0,0,0,0,1,0, 0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (436,44,11,1,'Lilium Boots',300,2,2,0,0,0,0,1,0,1,1,1,0,11,0,0,0,0,1,0, 0);
INSERT INTO [WebShop] (uid, id, type, ex_type, name, credits, X, Y, str, agi, nrg, cmd, luck, skill, hasLevel, default_durability, hasOption, optionType, category, stickLevel, maxitop, maxitlv, maxitxl, cansellitem, class, groupid) VALUES (437,53,11,1,'Queen Boots',310,2,2,0,0,0,0,1,0,1,1,1,0,11,0,0,0,0,1,0, 0);

Chạy Query này là đc .^^!.Nếu lỗi

FIX
sql > muonline db > tables > webshop > design table > identity yes > identity > no

Lâu rồi ko làm .Nhớ backup DB muonline nhé

[huynhkim]

Còn cái image của nó thì chỉnh kiểu j ak ?

[hateroc22]

Còn cái image của nó thì chỉnh kiểu j ak ?

copy từ mumaker bỏ vào WEBSHOP thôi

[huynhkim]

copy từ mumaker bỏ vào WEBSHOP thôi

A có thể nói rõ hơn ko ? EM ko hiểu ?

[hateroc22]

A có thể nói rõ hơn ko ? EM ko hiểu ?

copy hình ảnh từ folder mumaker 1.13 sang WEBSHOP nới chứa hình ảnh

[tuantep]

Chụp ảnh rồi cắt hả bạn? Hay có cách convert đuôi ảnh của MuMaker ko?

[lequangvu]

Cái này hateroc22 [-C.N.C-] chỉ tận tình vậy mà các bạn không làm được nữa thì thôi MuServer đi nhé