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.
Printable View
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.
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.
http://www.freeimagehosting.net/uploads/c694071420.jpg
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.Quote:
Originally Posted by lizardo
here
Code: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
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.
I follow the method Does not work
My above solution is for equip card to cloths.Quote:
Originally Posted by malcomtidus
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
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.
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:Quote:
Originally Posted by lizardo
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/pangy...2/#post6142981Quote:
Originally Posted by malcomtidus
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...Quote:
Originally Posted by Acardia
Jeez... what could have gone so wrong...
Thanks for both of your attempts at helping, I'm sure it's something stupidly small...
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.Quote:
Originally Posted by Acardia
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...
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:
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.
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 :D