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

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.

Code:

---

/* 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);

---

http://img291.imageshack.usimg2917590rf0r.jpg

http://img843.imageshack.us/img843/5015/rf1g.jpg

http://img690.imageshack.us/img690/1030/worksf.jpg

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

Quote:

---

Originally Posted by tutero69

POST a complete guide please :)

---

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

http://img577.imageshack.us/img577/9394/edite.jpg

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.

http://img690.imageshack.us/img690/9599/solvedi.jpg

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.

[Download]

Approved

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 ?

anyone have sql query for season 4 item? please share :)

Quote:

---

Originally Posted by GoldbertGTR

anyone have sql query for season 4 item? please share :)

---

here it is :
MEGAUPLOAD - The leading online storage and file delivery service

Quote:

---

Originally Posted by Taurus2001

here it is :
MEGAUPLOAD - The leading online storage and file delivery service

---

thanks for helping :thumbup:

Quote:

---

Originally Posted by 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 ?

---

Manually...

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

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

Thanks!

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..

Quote:

---

Originally Posted by forplaymastah

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

Thanks!

---

POST a complete guide please :)

can someone give us the images :?

Quote:

---

Originally Posted by forplaymastah

Manually...

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

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.

Quote:

---

Originally Posted by Taurus2001

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!:thumbup1:

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

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