Card Pack Tables ???

[Acardia]

Im Currently Working On Filling In The Card Pack Tables To Open Packs And I Plan To Release Them Here ASAP But Does Anyone Know Which Tables Allow Us To Equip Cards ??? I Can Open But Not Equip.

 

[lizardo]

Try to edit procedures "USP_CARD_...." by change "Pangya_GDBLog.DBO.TZ_CARD_LOG" to "Pangya_S4_TH.DBO.TZ_CARD_LOG"
then create new table name "TZ_CARD_LOG".

it's work for me.

You must be registered to see links

comment all lines those have red underlined "Pangya_GDBLog.DBO.TZ_CARD_LOG" may work too, but I don't try it yet.

 

[Acardia]

Try to edit procedures "USP_CARD_...." by change "Pangya_GDBLog.DBO.TZ_CARD_LOG" to "Pangya_S4_TH.DBO.TZ_CARD_LOG"
then create new table name "TZ_CARD_LOG".

it's work for me.

You must be registered to see links

comment all lines those have red underlined "Pangya_GDBLog.DBO.TZ_CARD_LOG" may work too, but I don't try it yet.

Can You Post The Script To Create The Table I Dont Know What Values The Table Would Need.

 

[lizardo]

here

USE [Pangya_S4_TH]
GO

/****** Object:  Table [dbo].[TZ_CARD_LOG]    Script Date: 01/31/2011 13:20:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TZ_CARD_LOG](
	[TYPES] [nchar](10) NULL,
	[ERRCODE] [nchar](10) NULL,
	[UID] [nchar](10) NULL,
	[ORI_ITEMID] [int] NULL,
	[CARD_ITEMID] [int] NULL,
	[CARD_TYPEID] [int] NULL,
	[QTY] [int] NULL,
	[FINAL_QTY] [nchar](10) NULL,
	[REGDATE] [nchar](10) NULL
) ON [PRIMARY]

GO

 

[malcomtidus]

Hello, I'm having a similar problem - Card Pack Cannot Be Opened when using a pack on the tear-open screen. I have used the above script and changed all references in the appropriate functions, yet still get the error. I don't mean to hijack the thread but the lack of card-use is a little upsetting.

 

[tourweb01]

I follow the method Does not work

 

[lizardo]

Hello, I'm having a similar problem - Card Pack Cannot Be Opened when using a pack on the tear-open screen. I have used the above script and changed all references in the appropriate functions, yet still get the error. I don't mean to hijack the thread but the lack of card-use is a little upsetting.

My above solution is for equip card to cloths.

If card pack cannot open in the 1st place, that mean you may not add your cardlist to cardpack table yet.

try thishttp://forum.ragezone.com/6116958-post21.html

 

[Acardia]

Im currently filling in the rows as we speak but the problem is i dont know how to export the filled in rows to a files ppl can import.

 

[malcomtidus]

My above solution is for equip card to cloths.

If card pack cannot open in the 1st place, that mean you may not add your cardlist to cardpack table yet.

try thishttp://forum.ragezone.com/6116958-post21.html

I have read the following post, but now I'm having a separate issue from that, when trying to insert data to the table, I receive an error about IDENTITY_INSERT. Something along the lines of:

23000 - [SQL Server]Cannot insert explicit value for identity column in table TA_CARDPACK_ITEM when IDENTITY_INSERT is set to off.

In addition I have attempted through Query to SET IDENTITY_INSERT dbo.TA_CARDPACK_ITEM ON, and I still receive the error regardless.

 

[Acardia]

I have read the following post, but now I'm having a separate issue from that, when trying to insert data to the table, I receive an error about IDENTITY_INSERT. Something along the lines of:

23000 - [SQL Server]Cannot insert explicit value for identity column in table TA_CARDPACK_ITEM when IDENTITY_INSERT is set to off.

In addition I have attempted through Query to SET IDENTITY_INSERT dbo.TA_CARDPACK_ITEM ON, and I still receive the error regardless.

http://forum.ragezone.com/f513/pangya-card-equip-fix-723962/#post6142981

Download that zip and run those files see if it helps

 

[malcomtidus]

http://forum.ragezone.com/f513/pangya-card-equip-fix-723962/#post6142981

Download that zip and run those files see if it helps

I still receive the error after having run all scripts in that file, and restarting the server...

Jeez... what could have gone so wrong...

Thanks for both of your attempts at helping, I'm sure it's something stupidly small...

 

[burningchr0me]

Im currently filling in the rows as we speak but the problem is i dont know how to export the filled in rows to a files ppl can import.

There's probably a way with the SQL Management Studio, but I use a program called Navicat Premium. You can right-click on a table and select DUMP SQL FILE, then I think you'd just have to remove the DUMP and CREATE statements at the start of the file and leave the INSERT INTO stuff.

I know that the SQL Management has an Import Export wizard, so you could at least extract the stuff out to a comma-separated file that people could then import, maybe...

 

[burningchr0me]

If you don't care about making the card packs open, and just want to add cards to an account so you can use them, use this:

Spoiler

USE Pangya_S4_TH;
GO
INSERT INTO TD_CARD_USRS (UID, CARD_TYPEID, CARD_TYPE, QTY, GET_DT, USE_YN)
VALUES (N'<USERIDHERE>',N'2080374784',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374785',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374786',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374787',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374788',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374789',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374790',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374791',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374792',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374793',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374794',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374795',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374796',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374797',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374798',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374799',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374800',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374801',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374802',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374803',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374804',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374805',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374806',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374807',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374808',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374809',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374810',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374811',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374812',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374813',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374814',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374815',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374816',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374817',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374818',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374819',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374820',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374821',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374822',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2080374823',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569088',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569089',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569090',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569091',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569092',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569093',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569094',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569095',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569096',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569097',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569098',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569099',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569100',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569101',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569102',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569103',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569104',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569105',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569106',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569107',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569108',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569109',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569110',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569111',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569112',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569113',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569114',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569115',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569116',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569117',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569118',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569119',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569120',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2084569121',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763392',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763393',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763394',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763395',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763396',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763397',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763398',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763399',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763400',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763401',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763402',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763403',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763404',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763405',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763406',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763407',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763408',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763409',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763410',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763411',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763412',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763413',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763414',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763415',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763416',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763417',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763418',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763419',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763420',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763421',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763422',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763423',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763424',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763425',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763426',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763427',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763428',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763429',N'1','<CARDQTYHERE>',GETDATE(),N'Y'),(N'<USERIDHERE>',N'2088763430',N'1','<CARDQTYHERE>',GETDATE(),N'Y');
GO

That's all the cards, and as long as you've applied the card fix from elsewhere on the site, you can use the cards. Just replace <USERIDHERE> and <CARDQTYHERE> and you should be good to go.

 

[malcomtidus]

Thanks for the list burningchr0me, and as far as my issue goes I've got cards working now. Thanks to a few people of course

But that list is very helpful for just setting cards in. I may need to borrow some of the Card IDs