Card Packs

Hi as i just fixed the shop thanks to Tsukasa i found some other problems which i thought could be fixed after fixing the shop.

I can't open the card packs, i get this error:

http://img138.imageshack.us/img138/465/pangya026vh.jpg

Can someone please help me with that?

PD: I think I'll post the other questions i have too, instead of opening new threads each time.

1 - The card packs - how opening them?
1.1 - After managing to open the card packs how can i edit the cards i
want the card pack to give me?
1.2 - For temporary cards such as "Elfen Ear Card" how can i edit the
duration time?

2 - I remember applying the fix to make the server remember the equips
but after i re-log the character is unequipped. Is there a new queue
inquiry to fix it or something? maybe i accidentally skipped it while
reading.

3 - Is there a way to create accounts that have the crimson ring already included in their
inventory?

Greatly appreciate all the help i can get in this matters, thank you =)

1 - The card packs - how opening them? - You need to insert data into some tables in the database. One table is "TA_CARDPACK_ACC", one is "TA_CARDPACK_ITEM", the table "TD_CARD_USRS" is populated when u buy and use card-packs.

1.1 - After managing to open the card packs how can i edit the cards i want the card pack to give me? - I havent checked yet but i think you need to edit the .iff files, not sure about this tho. And there are a table in the database for this.
1.2 - For temporary cards such as "Elfen Ear Card" how can i edit theduration time? - Im pretty sure this is in the .iff files

2 - I remember applying the fix to make the server remember the equips but after i re-log the character is unequipped. Is there a new queue inquiry to fix it or something? maybe i accidentally skipped it while reading. - Check the gameserver logs, it should tell u which Stored Procedure thats broken.

3 - Is there a way to create accounts that have the crimson ring already included in their inventory? - Use the stored procedure "ProcInsertNewItem" with the values of that item, which can be found in the .iff files or in the table "PANGYA_ITEM_TYPELIST"

I hope this answers your questions

Okay, thank you. I'll start working on those right now.

about the question 1, excuse the ignorance lol. what data? i mean what am i supposed to fill there? o.O

What chreadie said, one correction though: The cards you want to get from the pack are entirely database-based. You can find them in the table TA_CARDPACK_ITEM.

To add additional items to a new user account you can edit the procedure ProcEventRookieF. It already contains the default items, so you can easily adapt what you see there to add new items. Please note that this will only work for new user accounts.

Quote:

---

Originally Posted by Tsukasa

What chreadie said, one correction though: The cards you want to get from the pack are entirely database-based. You can find them in the table TA_CARDPACK_ITEM.

To add additional items to a new user account you can edit the procedure ProcEventRookieF. It already contains the default items, so you can easily adapt what you see there to add new items. Please note that this will only work for new user accounts.

---

Ooohh Perfect. understandable, thank you a lot.

Quote:

---

Originally Posted by Tsukasa

What chreadie said, one correction though: The cards you want to get from the pack are entirely database-based. You can find them in the table TA_CARDPACK_ITEM.

To add additional items to a new user account you can edit the procedure ProcEventRookieF. It already contains the default items, so you can easily adapt what you see there to add new items. Please note that this will only work for new user accounts.

---

I cant believe i missed that table, oh well. I got the cards working here but didnt bother with changing items :)

i'm feeling such a noob with this question, but, where can i find the PACK_TYPEID???
edit: the only thing i found was CARD_TYPEID


could someone show me what should look like those 3 tables? i made a ugly mess there!

this is what happens when i open both card packs hahaha
http://img193.imageshack.us/img193/9158/pangya000q.jpg

Quote:

---

Originally Posted by chreadie

2 - I remember applying the fix to make the server remember the equips but after i re-log the character is unequipped. Is there a new queue inquiry to fix it or something? maybe i accidentally skipped it while reading. - Check the gameserver logs, it should tell u which Stored Procedure thats broken.

---

Same problem, here's the log:

Code:

---

2011-01-16 11:44:55    ProcUpdateCharacterInfo Failed { call dbo.USP_CHAR_EQUIP
_SAVE_S4 (1, 3, '1^134480896^0|2^134489088^0|3^134496256^53|4^134505472^0|5^0^0|
6^0^0|7^134530048^0|8^134538240^0|9^0^0|10^0^0|11^0^0|12^0^0|13^0^0|14^0^0|15^0^
0|16^0^0|17^0^0|18^0^0|19^0^0|20^134636544^0|21^0^0|22^0^0|23^0^0|24^0^0|25^0|26
^0|27^0|28^0|29^0') }

---

Quote:

---

Originally Posted by prapra

i'm feeling such a noob with this question, but, where can i find the PACK_TYPEID???
edit: the only thing i found was CARD_TYPEID


could someone show me what should look like those 3 tables? i made a ugly mess there!

this is what happens when i open both card packs hahaha
http://img193.imageshack.us/img193/9158/pangya000q.jpg

---

I get the same

Quote:

---

Originally Posted by StarNet

Same problem, here's the log:

Code:

---

2011-01-16 11:44:55    ProcUpdateCharacterInfo Failed { call dbo.USP_CHAR_EQUIP
_SAVE_S4 (1, 3, '1^134480896^0|2^134489088^0|3^134496256^53|4^134505472^0|5^0^0|
6^0^0|7^134530048^0|8^134538240^0|9^0^0|10^0^0|11^0^0|12^0^0|13^0^0|14^0^0|15^0^
0|16^0^0|17^0^0|18^0^0|19^0^0|20^134636544^0|21^0^0|22^0^0|23^0^0|24^0^0|25^0|26
^0|27^0|28^0|29^0') }

---

---

that is the exact same error i get.

where can i found "TA_CARDPACK_ACC","TA_CARDPACK_ITEM","TD_CARD_USRS" process THX

Quote:

---

Originally Posted by o800920

where can i found "TA_CARDPACK_ACC","TA_CARDPACK_ITEM","TD_CARD_USRS" process THX

---

Pangya_S4_TH > Tables ? (not sure if that is what you are asking for)

If the tables is what you want they are easy to find, the problem is that all those are empty.

Can someone please explain me exactly what table should i fill and how?
about the card id's; i have tried to look around, spent nearly 1 hour looking at the tables and i couldn't find anything except every item id.

Quote:

---

Originally Posted by shadowsfx

Pangya_S4_TH > Tables ? (not sure if that is what you are asking for)

If the tables is what you want they are easy to find, the problem is that all those are empty.

Can someone please explain me exactly what table should i fill and how?
about the card id's; i have tried to look around, spent nearly 1 hour looking at the tables and i couldn't find anything except every item id.

---

The Card ID's are in the Card.iff, and there are 2 card packs in Card.iff too.


Card pack ID's:
2092957700 - Pangya Card Pack No.2
2097152001 - Pangya Card Box No.2
2092957696 - Pangya Card Pack No.1

Example of Card ID's:

Max (Normal) - 2080374804
Max (Rare) - 2080374819
Elf Ear - 2088763424

I hope this helps!

I've managed to add the cards, i can open now any cardpack with any card i want, but now i'm stuck on other thing, i can't equip the cards!
http://img143.imageshack.us/img143/984/pangya010wp.jpg

Does anyone knows what to do?

Quote:

---

Originally Posted by prapra

I've managed to add the cards, i can open now any cardpack with any card i want, but now i'm stuck on other thing, i can't equip the cards!
http://img143.imageshack.us/img143/984/pangya010wp.jpg

Does anyone knows what to do?

---

First thing is to check the gameserver logs to see what SP it is that is broken, report back with that and we will be able to help you.