[Help] Where Can I Find Item ID Codes ???

808Saga · 10/25/2011, 08:42

I need help to find the item ID codes. right now im just typing in ramdom codes and hoping to get what i want

Please could you tell me how to find the ID codes...

Thanks

viper4513 · 10/25/2011, 10:13

Look at the Item Table in your GameDefs table

or in query

Code:

USE PS_GameDefs
SELECT * FROM Items

If you wanna search by level
add this into the query, changing the number to the level you're looking for.

Code:

WHERE Reqlevel = 1

There is also a full item list written by Ariez in these forums somewhere. Just search Ariez item list. Or look in the dev section

The codes are type + type ID

so long sword would be
/getitem 1 1 (Type 1, TypeID 1)
if you want 2 of that item
/getitem 1 1 2 (Type 1, TypeID 1, Ammount 2)

808Saga · 10/25/2011, 20:28

Im still confuzed, it that a ingame command, or is it some out of game file i need to look up..

i know, i know its simple to you, but its new to me,

viper4513 · 10/26/2011, 00:15

The top ones where sql querys (you run those in your SQL manager program)

the bottom ones "/getitem" where ingame commands.

JohnHeatz · 10/26/2011, 03:30

If you want it to simply show what you want, you can filter the SQL query a little bit more:

Code:

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

This will just show the needed information for you to make the item with the /getitem code.

Another way would be getting AriezOMG's code list:

808Saga · 10/26/2011, 03:54

What do i need to look at PS_GameDef ? i have no clue what your talking about... Think of me as a child who need to be told their shape and colors

JohnHeatz · 10/26/2011, 04:15

What I posted there is the full query you need to run in your SQL Server Management Studio....but is easier to just get the ID Codes from the link I provided...

808Saga · 10/26/2011, 05:18

i check out that link and it dosnt have the enchant items 70 gear and the new 70 weapons like Dragon's Roar

SafeBett · 10/26/2011, 12:42

LOL

umm do you have a P-Server running?

808Saga · 11/30/2011, 01:46

I am an ADM on a new server... But its not my P server...

[Dev]Ansem · 11/30/2011, 14:12

Quote:

Originally Posted by 808Saga

I need help to find the item ID codes. right now im just typing in ramdom codes and hoping to get what i want

Please could you tell me how to find the ID codes...

Thanks

Here you can find an EP 5 list of the Item ID's.
->

If you want to use them for ingame take a look here:
->

808Saga · 12/17/2011, 07:05

Help me still lost I used SQL to open it up then i went to PS_GameDefs now im lost... where do i go from here. there is lots of other folders

JohnHeatz · 12/17/2011, 07:29

Quote:
Originally Posted by JohnHeatz
If you want it to simply show what you want, you can filter the SQL query a little bit more:
Code:
Use PS_GameDefs
Select ItemName, Type, TypeID from dbo.Items
This will just show the needed information for you to make the item with the /getitem code.

Another way would be getting AriezOMG's code list:

I thought that I had explained it already