• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Card Packs

Status
Not open for further replies.
Newbie Spellweaver
Joined
Apr 20, 2006
Messages
13
Reaction score
1
Hey prapra would you mind helping me with the card? how did u manage to add them?

i had to add manually the cards i wanted to drop from the card packs
this is on [Pangya_S4_TH].[dbo].[TA_CARDPACK_ITEM]
Code:
PACK_TYPEID	CARD_TYPEID    QTY RARETYPE    SEQ      PROB	USE_YN	MOD_SEQ	MOD_DT	card_type
2092957696	2080374791	1	1	23	50.000	 y	23	2011-01-17 15:39:00	3
2092957696	2080374794	2	1	24	50.000	 y	24	2011-01-17 15:39:00	3
2092957696	2080374795	3	1	25	50.000	 y	25	2011-01-17 15:39:00	3
2092957696	2084569098	1	1	26	50.000	 y	26	2011-01-17 15:40:00	3
2092957696	2084569106	2	1	28	50.000	 y	28	2011-01-17 15:40:00	3
2092957696	2084569113	3	1	29	50.000	 y	29	2011-01-17 15:40:00	3
2092957696	2088763414	1	1	31	50.000	 y	31	2011-01-17 15:41:00	3
2092957696	2088763416	2	1	30	50.000	 y	30	2011-01-17 15:40:00	3
2092957696	2088763424	3	1	34	50.000	 y	1	2011-01-17 16:13:00	3
this one is [dbo].[TA_CARDPACK_ACC]
Code:
PACK_TYPEID	SEQ	PACK_NM_KR	PACK_NM_EN	OUTQTY	USE_YN	IN_DATE
2092957696	4	2092957696	NULL	3	Y	2011-01-16 19:12:00
2092957700	3	2092957700	NULL	1	Y	2011-01-16 19:03:00

and here is some ID for the cards i used
Code:
2080374794	Arthur S. Rare   +3 spin slot
2080374791	Hana Secret      +1 control slot + 4 curve slot 
2084569098	Titan Boo Secret (Wind 9-6 -2 wind, 5-2 -1 Wind)
2088763424	Elf Card         (add for 30 min Elf' effect)
2084569106	Lolo S.Rare      (+6y on power shot)
2084569113	Caddie Secret    (add +2 pixels on impact zone)
2088763416	Billy            (+1 item on inventory)
2088763414	power gauge      (start with +1 Powershot)


---------- Post added at 08:47 PM ---------- Previous post was at 08:44 PM ----------

Modify the SP and change "Pangya_GDBLog.DBO.TZ_CARD_LOG" to "Pangya_S4_TH.DBO.TZ_CARD_LOG"
still the same!
i found this too:
Code:
2011-01-17 19:27:54	107	Lolo	1	[E_ODBC] ErrCode(42S02) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'Pangya_GDBLog.DBO.TZ_CARD_LOG'.)
2011-01-17 19:27:54	107	Lolo	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery(exec dbo.USP_CARD_JOIN_S4 3, 134242307, 4559, 2084569106, 17, 1, 1)
2011-01-17 19:27:55	101	Lolo	2	CallProfile [Count:1671]
 
Last edited:
Initiate Mage
Joined
Dec 20, 2010
Messages
2
Reaction score
0
The cards can I add a user.
But once I open a game room.
is following in the log

Code:
0x00642160 4 ei.tmp->ei.log.txt E:\PANGYA_SRV\PY_LOGDIR/20201_20110101_2256.1.ei.tmp ]]  0x00B155A8 4 4 ] 2011-01-01 22:57:09	1	Pang-CB Server	4	[S_CARD]Card Attach : Card(TID:2084569113, ItemID:32) PARTS(TID:134242331, ItemID:8926) SLOT:5
0x00642160 4 ei.tmp->ei.log.txt E:\PANGYA_SRV\PY_LOGDIR/20201_20110101_2256.1.ei.tmp ]]  0x00B155A8 4 4 ] 2011-01-01 22:57:09	1	Pang-CB Server	4	[N_CARD] Delete : Cadie (Secret)(Tid:2084569113, Uid:32), CurrNum(28), DecreaseNum(1), RemainNum(27)


the card is delete
 
Creator of Code
Joined
Mar 5, 2006
Messages
371
Reaction score
131
i had to add manually the cards i wanted to drop from the card packs
this is on [Pangya_S4_TH].[dbo].[TA_CARDPACK_ITEM]
Code:
PACK_TYPEID	CARD_TYPEID    QTY RARETYPE    SEQ      PROB	USE_YN	MOD_SEQ	MOD_DT	card_type
2092957696	2080374791	1	1	23	50.000	 y	23	2011-01-17 15:39:00	3
2092957696	2080374794	2	1	24	50.000	 y	24	2011-01-17 15:39:00	3
2092957696	2080374795	3	1	25	50.000	 y	25	2011-01-17 15:39:00	3
2092957696	2084569098	1	1	26	50.000	 y	26	2011-01-17 15:40:00	3
2092957696	2084569106	2	1	28	50.000	 y	28	2011-01-17 15:40:00	3
2092957696	2084569113	3	1	29	50.000	 y	29	2011-01-17 15:40:00	3
2092957696	2088763414	1	1	31	50.000	 y	31	2011-01-17 15:41:00	3
2092957696	2088763416	2	1	30	50.000	 y	30	2011-01-17 15:40:00	3
2092957696	2088763424	3	1	34	50.000	 y	1	2011-01-17 16:13:00	3
this one is [dbo].[TA_CARDPACK_ACC]
Code:
PACK_TYPEID	SEQ	PACK_NM_KR	PACK_NM_EN	OUTQTY	USE_YN	IN_DATE
2092957696	4	2092957696	NULL	3	Y	2011-01-16 19:12:00
2092957700	3	2092957700	NULL	1	Y	2011-01-16 19:03:00

and here is some ID for the cards i used
Code:
2080374794	Arthur S. Rare   +3 spin slot
2080374791	Hana Secret      +1 control slot + 4 curve slot 
2084569098	Titan Boo Secret (Wind 9-6 -2 wind, 5-2 -1 Wind)
2088763424	Elf Card         (add for 30 min Elf' effect)
2084569106	Lolo S.Rare      (+6y on power shot)
2084569113	Caddie Secret    (add +2 pixels on impact zone)
2088763416	Billy            (+1 item on inventory)
2088763414	power gauge      (start with +1 Powershot)


---------- Post added at 08:47 PM ---------- Previous post was at 08:44 PM ----------


still the same!
i found this too:
Code:
2011-01-17 19:27:54	107	Lolo	1	[E_ODBC] ErrCode(42S02) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'Pangya_GDBLog.DBO.TZ_CARD_LOG'.)
2011-01-17 19:27:54	107	Lolo	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery(exec dbo.USP_CARD_JOIN_S4 3, 134242307, 4559, 2084569106, 17, 1, 1)
2011-01-17 19:27:55	101	Lolo	2	CallProfile [Count:1671]

I forgot i added that table to my database, either add it or comment that row in the SP. A comment in MS SQL Server is a line that starts with --

---------- Post added at 06:23 AM ---------- Previous post was at 06:22 AM ----------

The cards can I add a user.
But once I open a game room.
is following in the log

Code:
0x00642160 4 ei.tmp->ei.log.txt E:\PANGYA_SRV\PY_LOGDIR/20201_20110101_2256.1.ei.tmp ]]  0x00B155A8 4 4 ] 2011-01-01 22:57:09	1	Pang-CB Server	4	[S_CARD]Card Attach : Card(TID:2084569113, ItemID:32) PARTS(TID:134242331, ItemID:8926) SLOT:5
0x00642160 4 ei.tmp->ei.log.txt E:\PANGYA_SRV\PY_LOGDIR/20201_20110101_2256.1.ei.tmp ]]  0x00B155A8 4 4 ] 2011-01-01 22:57:09	1	Pang-CB Server	4	[N_CARD] Delete : Cadie (Secret)(Tid:2084569113, Uid:32), CurrNum(28), DecreaseNum(1), RemainNum(27)


the card is delete

It doesnt give you an error and back when i played there were no cards so my guess is that it should be like that. Its a consumable like Lucky Pangya.
 
Newbie Spellweaver
Joined
Jan 12, 2011
Messages
9
Reaction score
0
i had to add manually the cards i wanted to drop from the card packs
this is on [Pangya_S4_TH].[dbo].[TA_CARDPACK_ITEM]
Code:
PACK_TYPEID	CARD_TYPEID    QTY RARETYPE    SEQ      PROB	USE_YN	MOD_SEQ	MOD_DT	card_type
2092957696	2080374791	1	1	23	50.000	 y	23	2011-01-17 15:39:00	3
2092957696	2080374794	2	1	24	50.000	 y	24	2011-01-17 15:39:00	3
2092957696	2080374795	3	1	25	50.000	 y	25	2011-01-17 15:39:00	3
2092957696	2084569098	1	1	26	50.000	 y	26	2011-01-17 15:40:00	3
2092957696	2084569106	2	1	28	50.000	 y	28	2011-01-17 15:40:00	3
2092957696	2084569113	3	1	29	50.000	 y	29	2011-01-17 15:40:00	3
2092957696	2088763414	1	1	31	50.000	 y	31	2011-01-17 15:41:00	3
2092957696	2088763416	2	1	30	50.000	 y	30	2011-01-17 15:40:00	3
2092957696	2088763424	3	1	34	50.000	 y	1	2011-01-17 16:13:00	3
this one is [dbo].[TA_CARDPACK_ACC]
Code:
PACK_TYPEID	SEQ	PACK_NM_KR	PACK_NM_EN	OUTQTY	USE_YN	IN_DATE
2092957696	4	2092957696	NULL	3	Y	2011-01-16 19:12:00
2092957700	3	2092957700	NULL	1	Y	2011-01-16 19:03:00

and here is some ID for the cards i used
Code:
2080374794	Arthur S. Rare   +3 spin slot
2080374791	Hana Secret      +1 control slot + 4 curve slot 
2084569098	Titan Boo Secret (Wind 9-6 -2 wind, 5-2 -1 Wind)
2088763424	Elf Card         (add for 30 min Elf' effect)
2084569106	Lolo S.Rare      (+6y on power shot)
2084569113	Caddie Secret    (add +2 pixels on impact zone)
2088763416	Billy            (+1 item on inventory)
2088763414	power gauge      (start with +1 Powershot)


---------- Post added at 08:47 PM ---------- Previous post was at 08:44 PM ----------



I do not understand. Add to it a problem
Will be able to add these lines to what it
Please Help me

Beginner
 
Newbie Spellweaver
Joined
Apr 20, 2006
Messages
13
Reaction score
1
OK, i now can equip cards, but when i try to use a Billy card, i get this error
Code:
2011-01-18 14:00:01	107	Lolo	1	[E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_CARD_SPCL_POP_S5'.)
2011-01-18 14:00:01	107	Lolo	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery(exec dbo.USP_CARD_SPCL_POP_S5  3, 2088763416, 15, 0, 11, 2, 120)
and i cant find this dbo.USP_CARD_SPCL_POP on dbo.ProcGet_PCBang_Point_Item :?:
 
Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1
i had to add manually the cards i wanted to drop from the card packs
this is on [Pangya_S4_TH].[dbo].[TA_CARDPACK_ITEM]
Code:
PACK_TYPEID	CARD_TYPEID    QTY RARETYPE    SEQ      PROB	USE_YN	MOD_SEQ	MOD_DT	card_type
2092957696	2080374791	1	1	23	50.000	 y	23	2011-01-17 15:39:00	3
2092957696	2080374794	2	1	24	50.000	 y	24	2011-01-17 15:39:00	3
2092957696	2080374795	3	1	25	50.000	 y	25	2011-01-17 15:39:00	3
2092957696	2084569098	1	1	26	50.000	 y	26	2011-01-17 15:40:00	3
2092957696	2084569106	2	1	28	50.000	 y	28	2011-01-17 15:40:00	3
2092957696	2084569113	3	1	29	50.000	 y	29	2011-01-17 15:40:00	3
2092957696	2088763414	1	1	31	50.000	 y	31	2011-01-17 15:41:00	3
2092957696	2088763416	2	1	30	50.000	 y	30	2011-01-17 15:40:00	3
2092957696	2088763424	3	1	34	50.000	 y	1	2011-01-17 16:13:00	3
this one is [dbo].[TA_CARDPACK_ACC]
Code:
PACK_TYPEID	SEQ	PACK_NM_KR	PACK_NM_EN	OUTQTY	USE_YN	IN_DATE
2092957696	4	2092957696	NULL	3	Y	2011-01-16 19:12:00
2092957700	3	2092957700	NULL	1	Y	2011-01-16 19:03:00

and here is some ID for the cards i used
Code:
2080374794	Arthur S. Rare   +3 spin slot
2080374791	Hana Secret      +1 control slot + 4 curve slot 
2084569098	Titan Boo Secret (Wind 9-6 -2 wind, 5-2 -1 Wind)
2088763424	Elf Card         (add for 30 min Elf' effect)
2084569106	Lolo S.Rare      (+6y on power shot)
2084569113	Caddie Secret    (add +2 pixels on impact zone)
2088763416	Billy            (+1 item on inventory)
2088763414	power gauge      (start with +1 Powershot)


---------- Post added at 08:47 PM ---------- Previous post was at 08:44 PM ----------


still the same!
i found this too:
Code:
2011-01-17 19:27:54	107	Lolo	1	[E_ODBC] ErrCode(42S02) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'Pangya_GDBLog.DBO.TZ_CARD_LOG'.)
2011-01-17 19:27:54	107	Lolo	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery(exec dbo.USP_CARD_JOIN_S4 3, 134242307, 4559, 2084569106, 17, 1, 1)
2011-01-17 19:27:55	101	Lolo	2	CallProfile [Count:1671]

Thank you very much prapra, ill test it right now, i didn't have the chance to check the forum before because of my classes and work. u.u

----

OK, i now can equip cards, but when i try to use a Billy card, i get this error
Code:
2011-01-18 14:00:01	107	Lolo	1	[E_ODBC] ErrCode(42000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'dbo.USP_CARD_SPCL_POP_S5'.)
2011-01-18 14:00:01	107	Lolo	1	[F_QUERY] LastSuccQuery(exec dbo.ProcGet_PCBang_Point_Item), CurrQuery(exec dbo.USP_CARD_SPCL_POP_S5  3, 2088763416, 15, 0, 11, 2, 120)
and i cant find this dbo.USP_CARD_SPCL_POP on dbo.ProcGet_PCBang_Point_Item :?:

I'm having this problem too.
 
Last edited:
Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1
it's probably because of the Pangya_GDBLog.DBO.TZ_CARD_LOG call, since it's trying to modify a non-existent table from a non existent db. make a comment out of the entire block and check again.
 
Newbie Spellweaver
Joined
Dec 27, 2008
Messages
46
Reaction score
0
it's probably because of the Pangya_GDBLog.DBO.TZ_CARD_LOG call, since it's trying to modify a non-existent table from a non existent db. make a comment out of the entire block and check again.

do you have Pangya_GDBLog.DBO.TZ_CARD_LOG process sql code??
 
Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1
it looks like this:

Code:
-- FINAL NEW CARD LOG
--	INSERT INTO Pangya_GDBLog.DBO.TZ_CARD_LOG (TYPES, ERRCODE, UID, ORI_ITEMID, CARD_ITEMID, CARD_TYPEID, QTY, FINAL_QTY, REGDATE)
	--SELECT	@TYPES, ERRCODE = @ERR, @UID, ORI_CARD_ITEMID = @CARD_ITEMID, 
	--		CARD_ITEMID = @JOIN_ITEM_ID, 
	--		CARD_TYPEID = @JOIN_ITEMID, 
	--		ADD_QTY = CASE WHEN (@ERR != 0) THEN 0 ELSE @QTY END, 
	--		QTY = CASE WHEN (@ERR != 0) THEN 0 ELSE @QTY END, GETDATE()
	-- FINAL NEW CARD LOG

just like that put a -- to comment it out. those blocks are in the SP for the cards in the Pangya_TH_S4 db

-----------------

Now going back on track. Does someone know a fix for the timed cards? i've been trying like crazy but nothing ):
 
Last edited:
Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1
that's an old issue that has been fixed already. re-read this thread.

PD: Still needing help with the temporary cards. someone found a fix already?
 
Newbie Spellweaver
Joined
Dec 27, 2008
Messages
46
Reaction score
0
it looks like this:

Code:
-- FINAL NEW CARD LOG
--	INSERT INTO Pangya_GDBLog.DBO.TZ_CARD_LOG (TYPES, ERRCODE, UID, ORI_ITEMID, CARD_ITEMID, CARD_TYPEID, QTY, FINAL_QTY, REGDATE)
	--SELECT	@TYPES, ERRCODE = @ERR, @UID, ORI_CARD_ITEMID = @CARD_ITEMID, 
	--		CARD_ITEMID = @JOIN_ITEM_ID, 
	--		CARD_TYPEID = @JOIN_ITEMID, 
	--		ADD_QTY = CASE WHEN (@ERR != 0) THEN 0 ELSE @QTY END, 
	--		QTY = CASE WHEN (@ERR != 0) THEN 0 ELSE @QTY END, GETDATE()
	-- FINAL NEW CARD LOG

just like that put a -- to comment it out. those blocks are in the SP for the cards in the Pangya_TH_S4 db

-----------------

Now going back on track. Does someone know a fix for the timed cards? i've been trying like crazy but nothing ):


it have some error that i cant create the table????
 
Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1
lol don't worry about all that, just make it a comment.
 
Newbie Spellweaver
Joined
Jan 22, 2011
Messages
11
Reaction score
0
Cardpack can open but can't equip card. Error pic in attach Files need help

same problem.

here's log data
Code:
0x00645190 3 ei.spl->ei.srv_log C:\PANGYA_GS_LOG/20201_20110123_1000.1.ei.spl ]]  0x00C45880 3 3 ] 2011-01-23 10:02:22	107	Lolo	1	[E_ODBC] ErrCode(42S22) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'UCC_IDX'.)
0x00645190 3 ei.spl->ei.srv_log C:\PANGYA_GS_LOG/20201_20110123_1000.1.ei.spl ]]  0x00C45880 3 3 ] 2011-01-23 10:02:22	107	Lolo	1	[E_ODBC] ErrCode(25000) ErrMsg([Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.)
0x00645190 3 ei.spl->ei.srv_log C:\PANGYA_GS_LOG/20201_20110123_1000.1.ei.spl ]]  0x00C45880 3 3 ] 2011-01-23 10:02:22	107	Lolo	1	[F_QUERY] LastSuccQuery(exec dbo.ProcInsertNewItem 1, 135847971, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), CurrQuery({ call dbo.USP_CHAR_EQUIP_SAVE_S4 (1, 2, '1^0^0|2^136586240^0|3^136593419^15|4^136602113^0|5^136609795^17|6^0^0|7^136626695^0|8^136634375^16|9^136643584^0|10^0^0|11^136660993^14|12^0^0|13^0^0|14^0^0|15^0^0|16^0^0|17^136708097^18|18^0^0|19^0^0|20^0^0|21^0^0|22^0^0|23^0^0|24^0^0|25^0|26^0|27^0|28^0|29^0') })

I think I'm need to do something about "UCC_IDX" column in "USP_CHAR_EQUIP_SAVE_S4" but I don't know how to do.

help please, Thank you.

***Edit:It's work right now.
 
Last edited:
Junior Spellweaver
Joined
Jan 18, 2011
Messages
113
Reaction score
25
heres my error

Code:
UpdateCharacterInfo: { call dbo.USP_CHAR_EQUIP_SAVE_S4 (1, 2, '1^0^0|2^135537664^0|3^135544985^12|4^0^0|5^135562240^0|6^0^0|7^135578192^0|8^135585934^13|9^135595008^0|10^135603200^0|11^0^0|12^0^0|13^0^0|14^135637070^14|15^0^0|16^0^0|17^0^0|18^0^0|19^0^0|20^0^0|21^0^0|22^0^0|23^0^0|24^0^0|25^0|26^0|27^0|28^0|29^0') }
 C:\PANGYA_GS_LOG/20201_20110124_1853.1.ei.tmp ]]  0x00B255A8 4 4 ] 2011-01-24 18:53:59	0	Lolo	1	{ call dbo.USP_CHAR_EQUIP_SAVE_S4 (1, 2, '1^0^0|2^135537664^0|3^135544985^12|4^0^0|5^135562240^0|6^0^0|7^135578192^0|8^135585934^13|9^135595008^0|10^135603200^0|11^0^0|12^0^0|13^0^0|14^135637070^14|15^0^0|16^0^0|17^0^0|18^0^0|19^0^0|20^0^0|21^0^0|22^0^0|23^0^0|24^0^0|25^0|26^0|27^0|28^0|29^0') }
 C:\PANGYA_GS_LOG/20201_20110124_1853.1.ei.tmp ]]  0x00B255A8 4 4 ] 2011-01-24 18:53:59	1	Lolo	1
 
Newbie Spellweaver
Joined
Jan 23, 2011
Messages
44
Reaction score
6
Hello, I just recently signed up for the forums but I've used RageZone before and have some familiarity in private engine software and their SQL backends, but I need some help solving an issue that was deemed solved on the last page.

As I enter the pack screen and click the button to tear it open, it tells me "Card Pack could not be opened."

Taken from the second response:
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.

Not only did my repack (I used the one with the very helpful guide from terror in the Complete Setup thread) not place a TD_CARD_USRS table, but the other two tables are completely blank. Did I make a wrong step in the installation process?
 
Status
Not open for further replies.
Back
Top