Im in need of a Script for EP6 New Styled Gear

01/11/2013 16:30 Dotzie#1
Hey I should need get a Script To Add the New EP6 Gear. If anyone got this script with Complete Name of the Gear for my SQL server it should be Lovely if you could share them here.










Here is a Tag With a Picture wish are the gear Script im looking for.

Thanks alot for the help (:
01/11/2013 17:00 nubness#2
Having them in the database is not enough. You must have them in the client and again Item.SData is not enough.
My opinion is that you should know what's in your client and server, and the best solution for that is to take the .3DC and .DDS files and manually place them in your .MLTs and then create them in Item.SData and then generate the query*(not script as some people say) in Shaiya Studio that will make your dbo.Items match with your Item.SData.
01/11/2013 17:12 Dotzie#3
Hmm, I know i have to Add the Items in manualy into Item.SData.

But im using a EP6 Client that are used to have those already.

My DB and Server Files are EP6. So they should been added from the start. arent that right?

But you want me to Extract the SData and Manualy make the Query?

My english arent the best tho. So i do not understand Completely every word your using.

Thx for Replay if you could just make it a lil easyer to understand completely (:
01/11/2013 19:11 zokylove#4
[Only registered and activated users can see links. Click Here To Register...]
This is EP 6 Item.SData u need.U have same ting in database.This 1 works for ep 5 Client and Ep6.0 client not enctipted.
01/11/2013 20:55 TeddyBear94#5
i still suggest to do it per hand and not via a item.sdata since u might have already stuff in ur one changed which gets lost by using just another item.sdata
01/12/2013 09:59 Dotzie#6
Quote:
Originally Posted by nubness View Post
Having them in the database is not enough. You must have them in the client and again Item.SData is not enough.
My opinion is that you should know what's in your client and server, and the best solution for that is to take the .3DC and .DDS files and manually place them in your .MLTs and then create them in Item.SData and then generate the query*(not script as some people say) in Shaiya Studio that will make your dbo.Items match with your Item.SData.
I have Extract the .3DC and .DDS files, But were do i find the .MLTs so that i can add them? And what do you mean with Creat them in the Item.SData and Generate the Query then i dont have the Query after all.

I do know whats in my Client. and i know whats in my server. Thats why i want add the stuff into my SQL and Server files. My Client got everything i want. But my SQL cant show them.

I have set up my Server to be able practicing on it. I dont know everything, Thats what im trying to learn by asking for help and do the work on my own. But i need some more info to learn the way all program works and how to add files, creat files, edit files.

I think i have to add the Files to DDS and 3DC inte the PS_DataDefs. But for that i have to Use a program to open the PS_DataDef file. and then add the files in there. After that i need to get a Query to add into the SQL if im not wrong. Do you want me to make the Query on my own? If so tell me how it works and i will try it out.
01/12/2013 10:27 zokylove#7
He meant use shStudio.Database haves noting to do whit adding or editing DDS and 3DC files.Download shStudio(use search button)
01/12/2013 10:44 Dotzie#8
I have all the programs. And i didnt mean Edit the DDS, 3DC files. I ment i have to add the files to the PS_DataDefs..
01/12/2013 11:33 nubness#9
Ok, I'm now going to explain something, that I hope will make you understand how it works.
Whatever is in the client is what you see in game, while the server sided files and the database is responsible for what actually happens in game.
The .MLT, .3DC and .DDS files are in the client only, not in the database, because they are responsible for what you see in game.
If you want to add the new items in the database you only need to know their ItemID in the client(Item.SData) and complete the respective rows in the database.
For example, let's assume the ItemID of the new priest helmet you want to add in the database is 72 253. You go in game, /getitem 72 253, look at the item's stats then manually add them in your database.
01/12/2013 11:40 Dotzie#10
Quote:
Originally Posted by nubness View Post
Ok, I'm now going to explain something, that I hope will make you understand how it works.
Whatever is in the client is what you see in game, while the server sided files and the database is responsible for what actually happens in game.
The .MLT, .3DC and .DDS files are in the client only, not in the database, because they are responsible for what you see in game.
If you want to add the new items in the database you only need to know their ItemID in the client(Item.SData) and complete the respective rows in the database.
For example, let's assume the ItemID of the new priest helmet you want to add in the database is 72 253. You go in game, /getitem 72 253, look at the item's stats then manually add them in your database.
Thats what i ment, The problem is that i wanted a Query for those stuff instead of adding them 1 by 1 wish are alot of work. I know i can use the SHstudio to get all the info about the item (ItemID etcetc). But the work of editing it all in the SQL will be a pain. Anyways thx for the help, i really Appreciated the help.
01/12/2013 12:35 zokylove#11
Dotzie add me on Skype .Skype Name same as forum user and il help you on this issue.