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!
Printable View
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).Quote:
Originally Posted by Buffzillla
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...Quote:
Originally Posted by top1
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
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.
If you want me to show you how to find ITEMID , leave the message
Ok thanks... one other question though... when I add items such as say clothes I just add them like this:Quote:
Originally Posted by Tsukasa
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"...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');
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?
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.
you have to change the array to 4 bytes
Quote:
Originally Posted by top1
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
When I got home , I'll show you
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.
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. :ott1:
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.
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.Quote:
Originally Posted by top1
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.
mikumiku, add them into TD_CARD_USRS.
Only equipment and consumables go into Item_Warehouse.
Quote:
Originally Posted by Tsukasa
I tried inserting a card that way... but I have no idea what to put for "card_type"... and when I try to equip the card it says "card could not be used"... do I need to fill in the TA_CARDPACK_ACC table for it to equip? Or did I put in the wrong thing for "card_type"... I just used "1" for Cadie SC...
I used:
Code:INSERT INTO TD_CARD_USRS ( [UID], [CARD_TYPEID], [CARD_TYPE], [QTY], [USE_YN] )
VALUES ( 1, 2084569106, 1, 30, 'Y');
Edit: saw this in the logs
[E_ODBC] ErrCode(42S02) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'Pangya_GDBLog.DBO.TZ_CARD_LOG'.)
But wtf I don't have a db called "Pangya_GDBLog"... ???
Add GET_DT (get date) to the VALUES list (string format is 'MM/DD/YYYY 6:00:00 AM'). I use all the same values, plus GET_DT, and it works fine for me.
As for the CARD_TYPE, I'm not sure myself. I noticed that the card packs from the shop are CARD_TYPE 3. What difference it makes, I have no idea.
UsingQuote:
Originally Posted by mikumiku
And still saying card can't be used when I try to equip.. what are you putting in for card_type ? I've tried '1' and '3'... are you sure I don't need that TA_CARDPACK_ACC table filled in?Code:INSERT INTO TD_CARD_USRS ( UID, CARD_TYPEID, CARD_TYPE, QTY, GET_DT, USE_YN )
VALUES ( 4, 2084569106, 1, 30, '2010-12-31 10:00.00', 'Y');
You got the date format completely wrong. Look at my previous post and try again.
From what I understand both of those date formats should work as far as SQL is concerned... and the assuming it is a "datetime" key... Also the GET_DT is in the format I used already... I'll try it with your date format later though, thanks.Quote:
Originally Posted by mikumiku
Edit: I was right.. the date shows up the same in the table whether I enter it in your format or mine, SQL automatically converts it.... still same problem when I use your date format. Still says card can't be used.
The quantity is going down when I try to use it tho I notice... (at least in the DB)... also I am deleting the old unworking entries from the table... I think it is because I'm missing the data needed to fill in TA_CARDPACK_ACC... can someone please dump theirs and save me the grief of trying to fill in that table manually?