Finding out Item Group from TID

[chreadie]

If you want to know what itemgroup an item belongs to:

SELECT [Pangya_S4_TH].[dbo].[UDF_PARTS_GROUP] (
TypeID)

One can also check the SP "PROCISUSERENABLETOHAVEITEM" which states (When you choose modify on it):

@PIG_CHAR = 1, --PANGYA_CHARACTER_INFORMATION 에 있으면 선물 불가
@PIG_PART = 2,
@PIG_CLUB = 3,
@PIG_CLUBSET = 4,
@PIG_BALL = 5,
@PIG_ITEM = 6,
@PIG_CADDIE = 7,
@PIG_CADITEM = 8, --PANGYA_CADDIE_INFO에 캐디가 있어야하고, CADITEM은 없어야 선물 가능
@PIG_SETITEM = 9,
@PIG_COURSE = 10,
@PIG_MATCH = 11,
@PIG_TITLE = 12,
@PIG_ENCHANT = 13,
@PIG_SKIN = 14,
@PIG_HAIR = 15, -- 헤어(염색약)의 경우 PANGYA_CHARACTER_INFORMATION의 DEFAULT_HAIR 검색
@PIG_MASCOT = 16, -- 마스코트 : IFF에서 그룹 인덱스 - PLUTO1ST 2006_05_10
@PIG_CHILDITEM = 17,
@PIG_AUXPART = 28,
@PIG_QUESTDROP = 29,
@PIG_QUEST = 30
CARD = 31 -- bubbastic

 

[bubbastic]

You can add @PIG_CARD = 31 (based on USP_HAVE_ITEM)

/***********************************************
@PIG_CHAR = 1 --PANGYA_CHARACTER_INFORMATION 에 있으면 선물 불가
@PIG_PART = 2
@PIG_CLUB = 3
@PIG_CLUBSET = 4
@PIG_BALL = 5
@PIG_ITEM = 6
@PIG_CADDIE = 7
@PIG_CADITEM = 8 --PANGYA_CADDIE_INFO 에 캐디가 있어야 하고 CADITEM 은 없어야 선물 가능
@PIG_SETITEM = 9
@PIG_COURSE = 10
@PIG_MATCH = 11
@PIG_TITLE = 12
@PIG_ENCHANT = 13
@PIG_SKIN = 14
@PIG_HAIR = 15 --헤어(염색약)의 경우 PANGYA_CHARACTER_INFORMATION 의 DEFAULT_HAIR 검색
@PIG_MASCOT = 16 --마스코트:IFF 에서 그룹인덱스 -PLUTO1ST 2006_05_10
@PIG_CHILDITEM = 17
@PIG_FURNITURE = 18 -- 2008-12-08, FURNITURE 추가
@PIG_AUXPART = 28
@PIG_QUESTDROP = 29
@PIG_QUEST = 30
@PIG_CARD = 31
***********************************************/