Card Packs

Status
Not open for further replies.
P

prapra

Newbie Spellweaver
Joined
Apr 20, 2006
Messages
13
Reaction score
1
shadowsfx said:
Hey prapra would you mind helping me with the card? how did u manage to add them?
Click to expand...

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 ----------
chreadie said:
Modify the SP and change "Pangya_GDBLog.DBO.TZ_CARD_LOG" to "Pangya_S4_TH.DBO.TZ_CARD_LOG"
Click to expand...
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:
N

Nootres

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
 
C

chreadie

Creator of Code
10 Happy Years
Joined
Mar 5, 2006
Messages
371
Reaction score
131

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 ----------
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.
 
T

tourweb01

Newbie Spellweaver
10 Happy Years
Joined
Jan 12, 2011
Messages
9
Reaction score
0


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

Beginner
 
P

prapra

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 :?:
 

shadowsfx

Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1

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

----


I'm having this problem too.
 
Last edited:

shadowsfx

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.
 
O

o800920

Newbie Spellweaver
10 Happy Years
Joined
Dec 27, 2008
Messages
46
Reaction score
0
shadowsfx said:
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.
Click to expand...

do you have Pangya_GDBLog.DBO.TZ_CARD_LOG process sql code??
 

shadowsfx

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:

shadowsfx

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?
 
O

o800920

Newbie Spellweaver
10 Happy Years
Joined
Dec 27, 2008
Messages
46
Reaction score
0


it have some error that i cant create the table????
 

shadowsfx

Newbie Spellweaver
Joined
Jun 24, 2009
Messages
20
Reaction score
1
lol don't worry about all that, just make it a comment.
 
L

lizardo

Newbie Spellweaver
Joined
Jan 22, 2011
Messages
11
Reaction score
0
pangyaplus said:
Cardpack can open but can't equip card. Error pic in attach Files need help
Click to expand...

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:

Acardia

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
 

malcomtidus

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.