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

10/25/2011 08:42 808Saga#1

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

10/25/2011 10:13 viper4513#2

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)

10/25/2011 20:28 808Saga#3

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,

10/26/2011 00:15 viper4513#4

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

the bottom ones "/getitem" where ingame commands.

10/26/2011 03:30 JohnHeatz#5

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:
[Only registered and activated users can see links. Click Here To Register...]

10/26/2011 03:54 808Saga#6

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

10/26/2011 04:15 JohnHeatz#7

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

10/26/2011 05:18 808Saga#8

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

10/26/2011 12:42 SafeBett#9

LOL

umm do you have a P-Server running?

11/30/2011 01:46 808Saga#10

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

11/30/2011 14:12 [Dev]Ansem#11

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.
-> [Only registered and activated users can see links. Click Here To Register...]

If you want to use them for ingame take a look here:
->[Only registered and activated users can see links. Click Here To Register...]

12/17/2011 07:05 808Saga#12

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

12/17/2011 07:29 JohnHeatz#13

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:
[Only registered and activated users can see links. Click Here To Register...]

I thought that I had explained it already :rolleyes: