Shaiya Item/ID/Type

spazysmalls · 10/31/2012, 13:04

hey im in the middle of making something and i really really need the items from ep5 or 6 would be better but the catch is i need the item, the item type, and the items ID for all the items any one can help me ?

nubness · 10/31/2012, 13:23

I'm not sure that the thing you're in the middle of making is going to be very great, considering that you don't know where to get IDs of items from.
Item.SData <--- Everything is in it.

spazysmalls · 10/31/2012, 21:28

lmao dude i know where to get em from but i dont wanna sit there and type in every item,every item id, and the type i was wondering if i could just take those 3 columns out of like the 10 that there is

JohnHeatz · 10/31/2012, 23:13

I know that nowadays people are way too lazy to even bother learning basics of SQL, and they just use some software that substitutes their brains, but here is what you are looking for, plain and simple, the most basic Select query from any SQL engine

Code:

Use PS_GameDefs
Select ItemID, ItemName, Type, TypeID, Grade from dbo.Items

And yes, you can export the result for you to manage it on whatever way you want, but that is something that you will need to look for.