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]
Re: R.F. Items Query For S-y Webshop.
Re: R.F. Items Query For S-y Webshop.
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 ?
Re: R.F. Items Query For S-y Webshop.
anyone have sql query for season 4 item? please share :)
Re: R.F. Items Query For S-y Webshop.
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
Re: R.F. Items Query For S-y Webshop.
Quote:
Originally Posted by
Taurus2001
thanks for helping :thumbup:
Re: R.F. Items Query For S-y Webshop.
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!
Re: R.F. Items Query For S-y Webshop.
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..
Re: R.F. Items Query For S-y Webshop.
Quote:
Originally Posted by
forplaymastah
Got It! I Seriously Forgot To Put My Account On 'Admin'...
Thanks!
POST a complete guide please :)
Re: R.F. Items Query For S-y Webshop.
can someone give us the images :?
Re: R.F. Items Query For S-y Webshop.
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.
Re: R.F. Items Query For S-y Webshop.
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:
Re: R.F. Items Query For S-y Webshop.
dude megaupload doesnt open.. any mirror on this link?
Re: R.F. Items Query For S-y Webshop.
Why when a SM resets the skills disappear? Anyone know how to fix it