R.F. Items Query For S-y Webshop.

[4pLay]

Just Got Generous Today To Share This Query For (S-y)Webshop, Maybe I'll Add Some More New Items Or Some Other Stuff Later.

Before Using This Query You Must Have Savoy's Webhop Installed First Before You RUN This Query.

This Includes (Helms, Armors, Gloves, Pants, Boots, Capes And Parchments)

"Just Got Some Request To Whom Who Will Use This And Have Knowledge On How To Put The Images In The Web?" Please P.M. Me Or Just Reply Here On How To Do It.

Coz' The Items Will Not Show Any Images In Your Web Unless You Have It Also Configured In Your Web, But Its Working Pefectly.

/* Small Cloak Of Warrior*/
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,cansellitem) VALUES (135,'Small Cloak Of Warrior',250,2,2,14,2,0,0,1,1,1,1,0,0,0,0,14,2,0,0,0,1);

/* Cloak of Warrior */
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,cansellitem) VALUES (49,'Cloak Of Warrior',350,2,3,14,2,0,0,1,1,1,1,0,0,0,0,14,2,0,0,0,1);

/* Lord Of Cape */
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,cansellitem) VALUES (50,'Lord Of Cape',500,2,3,14,2,0,0,1,1,1,1,0,0,0,0,14,2,0,0,0,1);


/* Sacred Glove */
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,cansellitem) VALUES (32,'Sacred Glove',150,1,2,0,0,85,35,1,1,1,1,0,0,1,0,0,0,0,0,0,1);

/* Sacred 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,cansellitem) VALUES (59,'Sacred Helm',150,2,2,7,1,0,0,1,0,1,1,0,0,1,0,7,0,0,0,0,1);

/* Sacred 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,cansellitem) VALUES (59,'Sacred Armor',150,2,3,8,1,0,0,1,0,1,1,0,0,1,0,8,0,0,0,0,1);

/* Sacred 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,cansellitem) VALUES (59,'Sacred Pants',150,2,2,9,1,0,0,1,0,1,1,0,0,1,0,9,0,0,0,0,1);

/* Sacred 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,cansellitem) VALUES (59,'Sacred Boots',150,2,2,11,1,0,0,1,0,1,1,0,0,1,0,11,0,0,0,0,1);


/* Holly Storm Claws */
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,cansellitem) VALUES (33,'Holly Storm Claws',200,1,2,0,0,100,50,1,1,1,1,0,0,1,0,0,0,0,0,0,1);

/* Storm Hard 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,cansellitem) VALUES (60,'Storm Hard Helm',200,2,2,7,1,0,0,1,0,1,1,0,0,1,0,7,0,0,0,0,1);

/* Storm Hard 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,cansellitem) VALUES (60,'Storm Hard Armor',200,2,3,8,1,0,0,1,0,1,1,0,0,1,0,8,0,0,0,0,1);

/* Storm Hard 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,cansellitem) VALUES (60,'Storm Hard Pants',200,2,2,9,1,0,0,1,0,1,1,0,0,1,0,9,0,0,0,0,1);

/* Storm Hard 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,cansellitem) VALUES (60,'Storm Hard Boots',200,2,2,11,1,0,0,1,0,1,1,0,0,1,0,11,0,0,0,0,1);


/* Piercing Glove */
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,cansellitem) VALUES (34,'Piercing Glove',250,1,2,0,0,120,60,1,1,1,1,0,0,1,0,0,0,0,0,0,1);

/* Piercing 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,cansellitem) VALUES (61,'Piercing Helm',250,2,2,7,1,0,0,1,0,1,1,0,0,1,0,7,0,0,0,0,1);

/* Piercing 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,cansellitem) VALUES (61,'Piercing Armor',250,2,3,8,1,0,0,1,0,1,1,0,0,1,0,8,0,0,0,0,1);

/* Piercing 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,cansellitem) VALUES (61,'Piercing Pants',250,2,2,9,1,0,0,1,0,1,1,0,0,1,0,9,0,0,0,0,1);

/* Piercing 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,cansellitem) VALUES (61,'Piercing Boots',250,2,2,11,1,0,0,1,0,1,1,0,0,1,0,11,0,0,0,0,1);


/* Chain Driver Parchment */
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,cansellitem) VALUES (30,'Chain Driver Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

/* Dark Side Parchment */
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,cansellitem) VALUES (31,'Dark Side Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

/* Dragon Lore Parchment */
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,cansellitem) VALUES (32,'Dragon Lore Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

/* Dragon Slayer Parchment */
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,cansellitem) VALUES (33,'Dragon Slayer Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

/* Red Armor Ignore Parchment */
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,cansellitem) VALUES (34,'Red Armor Ignore Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

/* Fitness Parchment */
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,cansellitem) VALUES (35,'Fitness Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

/* Defense Rate Parchment */
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,cansellitem) VALUES (36,'Defense Rate Parchment',100,1,2,15,-1,0,0,0,0,0,1,0,0,0,0,15,0,0,0,0,1);

Simple Guide For Adding Items With Your (S-y)Webshop.

POST a complete guide please

Simply Put Your Account On The "wshconf.cfg"...

Like This!

Then Log In With The Account That You Putted On "wshconf.cfg".

Then After Logging In, Just Open Your "item.kor" On Your "X:\Muserver\Data\Lang" So That You Can Have A Summary For What Item You Will Be Adding On The Webshop.

After Editing The Item That You Have Added On, Just Click "Create A New Item" On Top Of The New Item Creator.

Then After Just Simply Edit File Name Of The Image That Is Given By The New Item Creator.

That's It!


Added!
[Taurus2001] - Items plus SQL Query Season4 W/ Images.

[

You must be registered to see links

]

 

[KarLi]

Approved

 

[2SeXy]

Is there a way to auto generate such querry script based on item(lang).txt ? or did you manually write every row insertion for the querry ?

 

[GoldbertGTR]

anyone have sql query for season 4 item? please share

 

[Taurus2001]

anyone have sql query for season 4 item? please share

here it is :

You must be registered to see links

 

[GoldbertGTR]

here it is :

You must be registered to see links

thanks for helping

 

[4pLay]

Is there a way to auto generate such querry script based on item(lang).txt ? or did you manually write every row insertion for the querry ?

Manually...

You Can Add Anything You Want If You Just Follow The Codes Carefully...

But Im Still Asking If Someone Knows How To Put Images On The Web? If Somebody/ Someone Knows, Please Do Share!

Thanks!

 

[martaino]

Adding the images to the web is easy.. you must go to Item Manager, find the item and it will tell you the name of the .gif image.. create the image, save it with that name and upload it..

 

[tutero69]

Got It! I Seriously Forgot To Put My Account On 'Admin'...

Thanks!

POST a complete guide please

 

[WeaKy]

can someone give us the images :?

 

[Taurus2001]

Manually...

You Can Add Anything You Want If You Just Follow The Codes Carefully...

But Im Still Asking If Someone Knows How To Put Images On The Web? If Somebody/ Someone Knows, Please Do Share!

Thanks!

I uploaded in the link above Items folder for webshop with season4 images, and SQL query for it.

 

[4pLay]

I uploaded in the link above Items folder for webshop with season4 images, and SQL query for it.

I'll Update This With Your's! Thanks!

 

[Jayar]

dude megaupload doesnt open.. any mirror on this link?

 

[ewtn]

Why when a SM resets the skills disappear? Anyone know how to fix it