Item IDs

Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Apprentice Buffzillla is offline
    MemberRank
    Dec 2010 Join Date
    9Posts

    Item IDs

    I'm kind of confused on how to find item IDs through .iff files.
    I've read through the release forums multiple times just wondering if anyone could help...thanks!


  2. #2
    Enthusiast pancakelizard is offline
    MemberRank
    Dec 2010 Join Date
    39Posts

    Re: Item IDs

    Quote Originally Posted by Buffzillla View Post
    I'm kind of confused on how to find item IDs through .iff files.
    I've read through the release forums multiple times just wondering if anyone could help...thanks!
    I couldn't find some of them either... most of them match with the EU release though and you can find the typeids for the items in the page source for each item on the pangya EU encyclopedia page... (listed as ItemID).

  3. #3
    Valued Member top1 is offline
    MemberRank
    Apr 2006 Join Date
    THAILANDLocation
    128Posts

    Re: Item IDs

    actually , you need to unpack iff file then open whatever you want (eg. ClubSet.iff)

    and you must convert ARRAY OF BYTES to Bytes to add ItemID!

  4. #4
    Enthusiast pancakelizard is offline
    MemberRank
    Dec 2010 Join Date
    39Posts

    Re: Item IDs

    Quote Originally Posted by top1 View Post
    actually , you need to unpack iff file then open whatever you want (eg. ClubSet.iff)

    and you must convert ARRAY OF BYTES to Bytes to add ItemID!
    When I open card.iff... I don't see anything that looks like the TypeIDs for the item... I just see ascii names and then a tiny bit of some other data... but it is mostly 00's between the names... and pretty much the only hex data I see there are the names...

    In part.iff I see stuff that could be the itemid... but what I really need are the IDs for the cards so I can try to fix the table "TA_CARDPACK_ACC"... but they don't seem to be in card.iff
    Last edited by pancakelizard; 31-12-10 at 09:15 PM.

  5. #5
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: Item IDs

    The IDs are in the file. They are UInt32 values, meaning 4 bytes long. Although it's not entirely correct for all files, you should just treat the 4 bytes before the name as the ID.

  6. #6
    Valued Member top1 is offline
    MemberRank
    Apr 2006 Join Date
    THAILANDLocation
    128Posts

    Re: Item IDs

    If you want me to show you how to find ITEMID , leave the message

  7. #7
    Enthusiast pancakelizard is offline
    MemberRank
    Dec 2010 Join Date
    39Posts

    Re: Item IDs

    Quote Originally Posted by Tsukasa View Post
    The IDs are in the file. They are UInt32 values, meaning 4 bytes long. Although it's not entirely correct for all files, you should just treat the 4 bytes before the name as the ID.
    Ok thanks... one other question though... when I add items such as say clothes I just add them like this:

    Code:
    INSERT INTO [Pangya_S4_TH].[dbo].[Pangya_Item_WareHouse]
    	(UID, typeid, valid, regdate, gift_flag, flag, applytime, enddate, C0, C1, C2, C3, C4, Purchase, ItemType ) 
    	VALUES ('15', '2084569113', '1', '2010-12-24 11:41.00', '0', '0', '2010-12-24 11:41.00', '2010-12-24 11:41.00', '0', '0', '0', '0', '0', '0', '0');
    The Cx columns seem to have to do with qty of the item (if potions) or # of days left if it is an item that lasts a specific time... but, I'm still confused what some of the other columns are for... like the "flag" and "itemtype"...

    I tried adding some cards w/ typeid's I got from the Pangya EU encyclopedia but couldn't get them to show up like I could clothes... I'll compare the item/typeids in cards.iff with what I find on the EU encyclopedia later... maybe the typeids are just different like they seem to be with clubs... clothes seem to all be the same so far though... it also might just be that TA_CARDPACK_ACC is empty though...

    Another thing is I have to restart the server whenever I insert items into the DB to get them to show up... I guess maybe I should try buying a potion at the store after inserting items into the Item_Warehouse... and see if that will do it... but if not... anyone have any other ideas?
    Last edited by pancakelizard; 31-12-10 at 09:58 PM.

  8. #8
    Enthusiast mikumiku is offline
    MemberRank
    Dec 2010 Join Date
    47Posts

    Re: Item IDs

    I'm having trouble trying to figure out Caddie IDs. The 1st hex value is the same, but the 4th doesn't seem to match up for any of the caddies I already have. I figure this would be the thread to ask since it's technically the same.
    Last edited by mikumiku; 31-12-10 at 11:45 PM.

  9. #9
    Valued Member top1 is offline
    MemberRank
    Apr 2006 Join Date
    THAILANDLocation
    128Posts

    Re: Item IDs

    you have to change the array to 4 bytes

  10. #10
    Enthusiast pancakelizard is offline
    MemberRank
    Dec 2010 Join Date
    39Posts

    Re: Item IDs

    Quote Originally Posted by top1 View Post
    If you want me to show you how to find ITEMID , leave the message

    Actually you know what.. I just dont' get how to extract the type ID from those 4 bytes of hex at all.... I thought it was simple hex to decimal conversion but that doesn't seem to be it...

    For example...

    I find sky blue bikini and the hex before it is 1E 40 14 08 ... but how does that equal a typeid of 135544862 ??

    Edit: I gotta flip the bytes... > 1E 40 14 08 -> 0814401E
    Last edited by pancakelizard; 01-01-11 at 03:55 AM.

  11. #11
    Valued Member top1 is offline
    MemberRank
    Apr 2006 Join Date
    THAILANDLocation
    128Posts

    Re: Item IDs

    When I got home , I'll show you

  12. #12
    Account Upgraded | Title Enabled! mrNickname is offline
    MemberRank
    May 2005 Join Date
    Isolated TowerLocation
    270Posts

    Re: Item IDs

    Why look into the database if you can just open up SQL dump and get the ID from there? The Repack N6 folder contain every equitable items ID, name, and price. Myself edited 4 and half character items with proper name and alignments already.

  13. #13
    Deny everything. Tsukasa is offline
    MemberRank
    Jun 2005 Join Date
    Net SlumLocation
    558Posts

    Re: Item IDs

    Since the client pulls names and prices from it's local data in the .iff files, your effort is laudable but somewhat futile. You still have to fix the client side.

  14. #14
    Account Upgraded | Title Enabled! mrNickname is offline
    MemberRank
    May 2005 Join Date
    Isolated TowerLocation
    270Posts

    Re: Item IDs

    Ohhh this is ragezone~ But then what's the point of releasing the repack if the data aren't going to get use by the client? Weird.

    I actually searched pancake's Blue Sky Bikini ID on the dump but proven match from the result, oh well i thought it would be useful anyway.

  15. #15
    Enthusiast mikumiku is offline
    MemberRank
    Dec 2010 Join Date
    47Posts

    Re: Item IDs

    Quote Originally Posted by top1 View Post
    you have to change the array to 4 bytes
    I'm not sure if you read my full post or not, but I already did that. The bytes in the IFF don't match the result I get from converting the ID in the table. I triple-checked, deleted my caddies and re-bought them, so I'm absolutely certain. I wouldn't have asked if it was that simple.

    Caddies aside, I'm also wondering about Card IDs. I tried using the same method used for items, but it didn't seem to add any cards to my list. Figured if I can't open card packs, I'll just put them directly in my inventory.



Page 1 of 2 12 LastLast

Advertisement