How can I delete all card to all user

[Kamikaze1]

I want to delete all the card in all user

how can I do ?


Can I do it ?

please help me

 

[Tsukasa]

To get rid of all cards, you can run this query:

USE Pangya_S4_TH
GO

-- Removes cards from all users' cardbooks
TRUNCATE TABLE TD_CARD_USRS

-- Get rid of joined cards
TRUNCATE TABLE TD_Card_Join2

-- More cleaning up
TRUNCATE TABLE TD_Card_Spcl

GO

Your users shouldn't have any cards left on their equipment or in their cardbook afterwards.

 

[Kamikaze1]

what is about
-- More cleaning up
TRUNCATE TABLE TD_Card_Spc

If I want delete card to all user card book I just use this ?
-- Removes cards from all users' cardbooks
TRUNCATE TABLE TD_CARD_USRS

Thank you for your help

 

[hvdaedalus]

Your users shouldn't have any cards left on their equipment or in their cardbook afterwards.

Why don't you just read, what he wrote? He already wrote in detail, what those functions do (at least for us developers it is a very detailed answer)

 

[Tsukasa]

what is about
-- More cleaning up
TRUNCATE TABLE TD_Card_Spc

If I want delete card to all user card book I just use this ?
-- Removes cards from all users' cardbooks
TRUNCATE TABLE TD_CARD_USRS

Thank you for your help

I won't comment on the second part of the question, I think it's pretty clear and there's no need for explanations.

If you want to know what the mysterious third query does, please take a look at the table and find out for yourself. Look at the IDs of the cards in there and cross-reference these IDs to the card-names and the special effect these cards provide. There's a common factor to all those cards you'll find in there... If you think that's too much hassle - no worries, the rows in there are volatile anyway.

 

[Kamikaze1]

I'm sorry I'm bad English.

but thank you for answer.