Card Packs

[pangyaplus]

bra bra bra

[shadowsfx]

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?

[o800920]

it looks like this:

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

[shadowsfx]

lol don't worry about all that, just make it a comment.

[o800920]

lol don't worry about all that, just make it a comment.

but no tab in my Pangya_S4_TH,and some card cant use

[pangyaplus]

brabrabra

[lizardo]

Cardpack can open but can't equip card. Error pic in attach Files need help

same problem.

here's log data

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.

[pangyaplus]

bra bra bra

[Acardia]

heres my error

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]

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?

[tourweb01]

I read this thread Card Packs but not understand

This problem comes next two days

Please help me