Summoner SQL код для Webshop в MU Online и SQL Server

[ketanof]

by scvaer on 18 Nov 2008, 10:16

Идем в SQL Query Analyzer.

/////////////////////////////////////////////////////////////


/* Scroll of Sleep */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (24,'Scroll of Sleep',1,1,2,15,-1,0,0,0,0,0,255,0,0,0,0,15,0,0,0,0,1,0);

/* Scroll of Night */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (23,'Scroll of Night',1,1,2,15,-1,0,0,0,0,0,255,0,0,0,0,15,0,0,0,0,1,0);

/* Scroll of Damage Reflex */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (22,'Scroll of Damage Reflex',1,1,2,15,-1,0,0,0,0,0,255,0,0,0,0,15,0,0,0,0,1,0);

/* Scroll of Electric Surge */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (21,'Scroll of Electric Surge',1,1,2,15,-1,0,0,0,0,0,255,0,0,0,0,15,0,0,0,0,1,0);

/* Scroll of Chain Lightning */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (20,'Scroll of Chain Lightning',1,1,2,15,-1,0,0,0,0,0,255,0,0,0,0,15,0,0,0,0,1,0);

/* Scroll of Drain Life */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (19,'Scroll of Drain Life',1,1,2,15,-1,0,0,0,0,0,255,0,0,0,0,15,0,0,0,0,1,0);

/* Mistery Helm */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (39,'Mistery Helm',130,2,2,7,1,0,0,1,0,1,255,0,0,1,0,7,0,0,0,0,1,0);

/* Red Wing Helm */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (40,'Red Wing Helm',130,2,2,7,1,0,0,1,0,1,255,0,0,1,0,7,0,0,0,0,1,0);

/* Ancient helm */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (41,'Ancient Helm',130,2,2,7,1,0,0,1,0,1,255,0,0,1,0,7,0,0,0,0,1,0);

/* Black Rose Helm */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (42,'Black Rose Helm',130,2,2,7,1,0,0,1,0,1,255,0,0,1,0,7,0,0,0,0,1,0);

/* Aura Helm */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (43,'Aura Helm',130,2,2,7,1,0,0,1,0,1,255,0,0,1,0,7,0,0,0,0,1,0);

/* Lilium Helm */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (44,'Lilium Helm',130,2,2,7,1,0,0,1,0,1,255,0,0,1,0,7,0,0,0,0,1,0);

/* Mistery Armor */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (39,'Mistery Armor',18,2,2,8,1,0,0,1,0,1,255,0,0,1,0,8,0,0,0,0,1,0);

/* Red Wing Armor */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (40,'Red Wing Armor',18,2,2,8,1,0,0,1,0,1,255,0,0,1,0,8,0,0,0,0,1,0);

/* Ancient Armor */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (41,'Ancient Armor',18,2,2,8,1,0,0,1,0,1,255,0,0,1,0,8,0,0,0,0,1,0);

/* Black Rose Armor */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (42,'Black Rose Armor',18,2,2,8,1,0,0,1,0,1,255,0,0,1,0,8,0,0,0,0,1,0);

/* Aura Armor */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (43,'Aura Armor',18,2,2,8,1,0,0,1,0,1,255,0,0,1,0,8,0,0,0,0,1,0);

/* Lilium Armor */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (44,'Lilium Armor',18,2,2,8,1,0,0,1,0,1,255,0,0,1,0,8,0,0,0,0,1,0);

/* Mistery Boots */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (39,'Mistery Boots',12,2,2,11,1,0,0,1,0,1,255,0,0,1,0,11,0,0,0,0,1,0);

/* Red Wing Boots */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (40,'Red Wing Boots',12,2,2,11,1,0,0,1,0,1,255,0,0,1,0,11,0,0,0,0,1,0);

/* Ancient Boots */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (41,'Ancient Boots',12,2,2,11,1,0,0,1,0,1,255,0,0,1,0,11,0,0,0,0,1,0);

/* Black Rose Boots */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (42,'Black Rose Boots',12,2,2,11,1,0,0,1,0,1,255,0,0,1,0,11,0,0,0,0,1,0);

/* Aura Boots */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (43,'Aura Boots',12,2,2,11,1,0,0,1,0,1,255,0,0,1,0,11,0,0,0,0,1,0);

/* Lilium Boots */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (44,'Lilium Boots',12,2,2,11,1,0,0,1,0,1,255,0,0,1,0,11,0,0,0,0,1,0);

/* Mistery Pants */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (39,'Mistery Pants',20,2,2,9,1,0,0,1,0,1,255,0,0,1,0,9,0,0,0,0,1,0);

/* Red Wing Pants */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (40,'Red Wing Pants',20,2,2,9,1,0,0,1,0,1,255,0,0,1,0,9,0,0,0,0,1,0);

/* Ancient Pants */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (41,'Ancient Pants',20,2,2,9,1,0,0,1,0,1,255,0,0,1,0,9,0,0,0,0,1,0);

/* Black Rose Pants */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (42,'Black Rose Pants',20,2,2,9,1,0,0,1,0,1,255,0,0,1,0,9,0,0,0,0,1,0);

/* Aura Pants */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (43,'Aura Pants',20,2,2,9,1,0,0,1,0,1,255,0,0,1,0,9,0,0,0,0,1,0);

/* Lilium Pants */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (44,'Lilium Pants',20,2,2,9,1,0,0,1,0,1,255,0,0,1,0,9,0,0,0,0,1,0);

/* Mistery Gloves */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (39,'Mistery Gloves',135,2,2,10,1,0,0,1,0,1,255,0,0,1,0,10,0,0,0,0,1,0);

/* Red Wing Gloves */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (40,'Red Wing Gloves',135,2,2,10,1,0,0,1,0,1,255,0,0,1,0,10,0,0,0,0,1,0);

/* Ancient Gloves */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (41,'Ancient Gloves',135,2,2,10,1,0,0,1,0,1,255,0,0,1,0,10,0,0,0,0,1,0);

/* Black Rose Gloves */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (42,'Black Rose Gloves',135,2,2,10,1,0,0,1,0,1,255,0,0,1,0,10,0,0,0,0,1,0);

/* Aura Gloves */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (43,'Aura Gloves',135,2,2,10,1,0,0,1,0,1,255,0,0,1,0,10,0,0,0,0,1,0);

/* Lilium Gloves */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (44,'Lilium Gloves',135,2,2,10,1,0,0,1,0,1,255,0,0,1,0,10,0,0,0,0,1,0);

/* Wing of Misery */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (41,'Wing of Misery',45,3,2,14,2,0,0,1,0,1,255,0,0,1,0,14,0,0,0,0,1,0);

/* Wing of Despair */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (42,'Wing of Despair',150,3,3,14,2,0,0,1,0,1,255,0,0,1,0,14,0,0,0,0,1,0);

/* Wing of Violent Wind */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (43,'Wing of Violent Wind',250,4,3,14,4,0,0,1,0,1,255,0,0,1,0,14,0,0,0,0,1,0);

/* Churchills Eyes */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (68,'Churchills Eyes',1,1,2,13,-1,0,0,0,0,0,255,0,0,0,0,13,0,0,0,0,1,0);

/* Mistery Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (14,'Mistery Staff',130,1,4,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Violent Wind Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (15,'Violent Wind Staff',130,1,4,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Red Wing Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (16,'Red Wing Staff',130,1,4,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Ancient Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (17,'Ancient Staff',130,1,4,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Black Rose Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (18,'Black Rose Staff',130,1,4,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Aura Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (19,'Aura Staff',130,2,3,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Lilium Staff */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (20,'Lilium Staff',130,2,3,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Book of Sahamutt */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (21,'Book of Sahamutt',130,1,2,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);

/* Book of Neil */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability
,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansell
item,class) VALUES (22,'Book of Neil',130,1,2,5,0,50,16,1,0,1,255,0,0,1,0,5,0,0,0,0,1,0);


///////////////////////////////////////////////////////////////////////////////////////

[seveL]

Ммм , довненько ето искал  спасибки тебе d-man55 !

[Lynn]

dla teh kto neznaet... kodi mozhno spisatj s items.txt, tam tot zhe kod

[CagucTuK]

у меня не алё вебшоп 0.9b а сервер с версией 1.04х ;(( и не идет

[Rockstar]

Жалко что не везде идёт ( хотелось бы чтоб в му s4 шло )

[Rok_]

может выложишь сразу полный webshop ? (точнее SQL код) ...
чтоб не мучались все по частям собирать ^^

[MercifuL]

ммдаа не плохо ... вам 5 )))

[079199979]

Kla$ благодарен.Нашол что искал.

[ketanof]

Смотрем дату:  26.1.2009, 1:48

Уже и полный скачать можно WebShop 09, (c,B) версии.

Нечачто.