Item IDs

[Tsukasa]

mikumiku, add them into TD_CARD_USRS.
Only equipment and consumables go into Item_Warehouse.

[pancakelizard]

mikumiku, add them into TD_CARD_USRS.
Only equipment and consumables go into Item_Warehouse.

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:

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

[mikumiku]

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.

[pancakelizard]

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.

Using

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');

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?

[mikumiku]

You got the date format completely wrong. Look at my previous post and try again.

[pancakelizard]

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.

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?