-- ----------------------------------------------- -- -- SQL Item Update for the Pangya! TH S 4.9 Server -- -- Generated by the Pangya! TH Item Encyclopedia -- -- -- -- -- -- If you redistribute this file, leave this head -- -- intact. It's not a hard thing to do, right? -- -- -- -- Generated from IFF file "Card.iff" -- -- Last update of the IFF: 2022-02-16 01:28:49 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Card.iff contains 148 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Nuri (Normal) -- Item ID: 2080374784 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374784 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri (Normal)' , ICON = N'card_icon_char_00' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374784 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374784, N'Nuri (Normal)', N'card_icon_char_00', 3, 1, 31, 0 ) END -- Item Name: Nuri (Raro) -- Item ID: 2080374785 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374785 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri (Raro)' , ICON = N'card_icon_char_01' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374785 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374785, N'Nuri (Raro)', N'card_icon_char_01', 3, 1, 31, 0 ) END -- Item Name: Nuri (S.Raro) -- Item ID: 2080374786 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374786 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri (S.Raro)' , ICON = N'card_icon_char_02' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374786 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374786, N'Nuri (S.Raro)', N'card_icon_char_02', 3, 1, 31, 0 ) END -- Item Name: Nuri (S.Raro) -- Item ID: 2080374787 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374787 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri (S.Raro)' , ICON = N'card_icon_char_03' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374787 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374787, N'Nuri (S.Raro)', N'card_icon_char_03', 3, 1, 31, 0 ) END -- Item Name: Hana (Normal) -- Item ID: 2080374788 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374788 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana (Normal)' , ICON = N'card_icon_char_04' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374788 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374788, N'Hana (Normal)', N'card_icon_char_04', 3, 1, 31, 0 ) END -- Item Name: Hana (Raro) -- Item ID: 2080374789 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374789 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana (Raro)' , ICON = N'card_icon_char_05' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374789 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374789, N'Hana (Raro)', N'card_icon_char_05', 3, 1, 31, 0 ) END -- Item Name: Hana (S.Raro) -- Item ID: 2080374790 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374790 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana (S.Raro)' , ICON = N'card_icon_char_06' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374790 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374790, N'Hana (S.Raro)', N'card_icon_char_06', 3, 1, 31, 0 ) END -- Item Name: Hana (Secreto) -- Item ID: 2080374791 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374791 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana (Secreto)' , ICON = N'card_icon_char_07' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374791 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374791, N'Hana (Secreto)', N'card_icon_char_07', 3, 1, 31, 0 ) END -- Item Name: Arthur (Normal) -- Item ID: 2080374792 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374792 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur (Normal)' , ICON = N'card_icon_char_08' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374792 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374792, N'Arthur (Normal)', N'card_icon_char_08', 3, 1, 31, 0 ) END -- Item Name: Arthur (Raro) -- Item ID: 2080374793 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374793 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur (Raro)' , ICON = N'card_icon_char_09' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374793 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374793, N'Arthur (Raro)', N'card_icon_char_09', 3, 1, 31, 0 ) END -- Item Name: Arthur (S.Raro) -- Item ID: 2080374794 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374794 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur (S.Raro)' , ICON = N'card_icon_char_10' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374794 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374794, N'Arthur (S.Raro)', N'card_icon_char_10', 3, 1, 31, 0 ) END -- Item Name: Arthur (Secreto) -- Item ID: 2080374795 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374795 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur (Secreto)' , ICON = N'card_icon_char_11' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374795 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374795, N'Arthur (Secreto)', N'card_icon_char_11', 3, 1, 31, 0 ) END -- Item Name: Kooh (Normal) -- Item ID: 2080374796 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374796 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (Normal)' , ICON = N'card_icon_char_12' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374796 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374796, N'Kooh (Normal)', N'card_icon_char_12', 3, 1, 31, 0 ) END -- Item Name: Kooh (Raro) -- Item ID: 2080374797 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374797 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (Raro)' , ICON = N'card_icon_char_13' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374797 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374797, N'Kooh (Raro)', N'card_icon_char_13', 3, 1, 31, 0 ) END -- Item Name: Kooh (S.Raro) -- Item ID: 2080374798 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374798 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (S.Raro)' , ICON = N'card_icon_char_14' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374798 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374798, N'Kooh (S.Raro)', N'card_icon_char_14', 3, 1, 31, 0 ) END -- Item Name: Kooh (Secreto) -- Item ID: 2080374799 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374799 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (Secreto)' , ICON = N'card_icon_char_15' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374799 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374799, N'Kooh (Secreto)', N'card_icon_char_15', 3, 1, 31, 0 ) END -- Item Name: Cesillia (Normal) -- Item ID: 2080374800 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374800 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia (Normal)' , ICON = N'card_icon_char_16' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374800 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374800, N'Cesillia (Normal)', N'card_icon_char_16', 3, 1, 31, 0 ) END -- Item Name: Cesillia (Raro) -- Item ID: 2080374801 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374801 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia (Raro)' , ICON = N'card_icon_char_17' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374801 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374801, N'Cesillia (Raro)', N'card_icon_char_17', 3, 1, 31, 0 ) END -- Item Name: Cesillia (S.Raro) -- Item ID: 2080374802 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374802 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia (S.Raro)' , ICON = N'card_icon_char_18' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374802 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374802, N'Cesillia (S.Raro)', N'card_icon_char_18', 3, 1, 31, 0 ) END -- Item Name: Cesillia (Secreto) -- Item ID: 2080374803 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374803 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia (Secreto)' , ICON = N'card_icon_char_19' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374803 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374803, N'Cesillia (Secreto)', N'card_icon_char_19', 3, 1, 31, 0 ) END -- Item Name: Max (Normal) -- Item ID: 2080374804 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374804 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Max (Normal)' , ICON = N'card_icon_char_20' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374804 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374804, N'Max (Normal)', N'card_icon_char_20', 3, 1, 31, 0 ) END -- Item Name: Max (Raro) -- Item ID: 2080374805 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374805 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Max (Raro)' , ICON = N'card_icon_char_21' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374805 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374805, N'Max (Raro)', N'card_icon_char_21', 3, 1, 31, 0 ) END -- Item Name: Max (S.Raro) -- Item ID: 2080374806 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374806 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Max (S.Raro)' , ICON = N'card_icon_char_22' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374806 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374806, N'Max (S.Raro)', N'card_icon_char_22', 3, 1, 31, 0 ) END -- Item Name: Max (Secreto) -- Item ID: 2080374807 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374807 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Max (Secreto)' , ICON = N'card_icon_char_23' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374807 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374807, N'Max (Secreto)', N'card_icon_char_23', 3, 1, 31, 0 ) END -- Item Name: Arin (Normal) -- Item ID: 2080374808 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374808 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (Normal)' , ICON = N'card_icon_char_24' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374808 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374808, N'Arin (Normal)', N'card_icon_char_24', 3, 1, 31, 0 ) END -- Item Name: Arin (Raro) -- Item ID: 2080374809 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374809 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (Raro)' , ICON = N'card_icon_char_25' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374809 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374809, N'Arin (Raro)', N'card_icon_char_25', 3, 1, 31, 0 ) END -- Item Name: Arin (S.Raro) -- Item ID: 2080374810 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374810 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (S.Raro)' , ICON = N'card_icon_char_26' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374810 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374810, N'Arin (S.Raro)', N'card_icon_char_26', 3, 1, 31, 0 ) END -- Item Name: Arin (Secreto) -- Item ID: 2080374811 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374811 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (Secreto)' , ICON = N'card_icon_char_27' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374811 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374811, N'Arin (Secreto)', N'card_icon_char_27', 3, 1, 31, 0 ) END -- Item Name: Kaz (Normal) -- Item ID: 2080374812 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374812 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz (Normal)' , ICON = N'card_icon_char_28' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374812 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374812, N'Kaz (Normal)', N'card_icon_char_28', 3, 1, 31, 0 ) END -- Item Name: Kaz (Raro) -- Item ID: 2080374813 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374813 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz (Raro)' , ICON = N'card_icon_char_29' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374813 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374813, N'Kaz (Raro)', N'card_icon_char_29', 3, 1, 31, 0 ) END -- Item Name: Kaz (S.Raro) -- Item ID: 2080374814 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374814 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz (S.Raro)' , ICON = N'card_icon_char_30' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374814 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374814, N'Kaz (S.Raro)', N'card_icon_char_30', 3, 1, 31, 0 ) END -- Item Name: Kaz (Secreto) -- Item ID: 2080374815 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374815 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz (Secreto)' , ICON = N'card_icon_char_31' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374815 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374815, N'Kaz (Secreto)', N'card_icon_char_31', 3, 1, 31, 0 ) END -- Item Name: Lucia (Normal) -- Item ID: 2080374816 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374816 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia (Normal)' , ICON = N'card_icon_char_32' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374816 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374816, N'Lucia (Normal)', N'card_icon_char_32', 3, 1, 31, 0 ) END -- Item Name: Lucia (Raro) -- Item ID: 2080374817 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374817 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia (Raro)' , ICON = N'card_icon_char_33' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374817 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374817, N'Lucia (Raro)', N'card_icon_char_33', 3, 1, 31, 0 ) END -- Item Name: Nuri (Normal) -- Item ID: 2080374818 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374818 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri (Normal)' , ICON = N'card_icon_char_34' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374818 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374818, N'Nuri (Normal)', N'card_icon_char_34', 3, 1, 31, 0 ) END -- Item Name: Max (Raro) -- Item ID: 2080374819 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374819 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Max (Raro)' , ICON = N'card_icon_char_35' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374819 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374819, N'Max (Raro)', N'card_icon_char_35', 3, 1, 31, 0 ) END -- Item Name: Cesillia (Normal) -- Item ID: 2080374820 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374820 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia (Normal)' , ICON = N'card_icon_char_36' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374820 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374820, N'Cesillia (Normal)', N'card_icon_char_36', 3, 1, 31, 0 ) END -- Item Name: Kooh (Normal) -- Item ID: 2080374821 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374821 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (Normal)' , ICON = N'card_icon_char_37' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374821 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374821, N'Kooh (Normal)', N'card_icon_char_37', 3, 1, 31, 0 ) END -- Item Name: Arin (Normal) -- Item ID: 2080374822 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374822 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (Normal)' , ICON = N'card_icon_char_38' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374822 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374822, N'Arin (Normal)', N'card_icon_char_38', 3, 1, 31, 0 ) END -- Item Name: Kaz (Normal) -- Item ID: 2080374823 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374823 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz (Normal)' , ICON = N'card_icon_char_39' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374823 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374823, N'Kaz (Normal)', N'card_icon_char_39', 3, 1, 31, 0 ) END -- Item Name: Bongdari (Normal) -- Item ID: 2084569088 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569088 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari (Normal)' , ICON = N'card_icon_caddie_00' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569088 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569088, N'Bongdari (Normal)', N'card_icon_caddie_00', 3, 1, 31, 0 ) END -- Item Name: Bongdari (Raro) -- Item ID: 2084569089 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569089 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari (Raro)' , ICON = N'card_icon_caddie_01' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569089 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569089, N'Bongdari (Raro)', N'card_icon_caddie_01', 3, 1, 31, 0 ) END -- Item Name: Bongdari (S.Raro) -- Item ID: 2084569090 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569090 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari (S.Raro)' , ICON = N'card_icon_caddie_02' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569090 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569090, N'Bongdari (S.Raro)', N'card_icon_caddie_02', 3, 1, 31, 0 ) END -- Item Name: Bongdari (Secreto) -- Item ID: 2084569091 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569091 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari (Secreto)' , ICON = N'card_icon_caddie_03' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569091 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569091, N'Bongdari (Secreto)', N'card_icon_caddie_03', 3, 1, 31, 0 ) END -- Item Name: Pippin (Normal) -- Item ID: 2084569092 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569092 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin (Normal)' , ICON = N'card_icon_caddie_04' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569092 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569092, N'Pippin (Normal)', N'card_icon_caddie_04', 3, 1, 31, 0 ) END -- Item Name: Pippin (Normal) -- Item ID: 2084569093 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569093 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin (Normal)' , ICON = N'card_icon_caddie_05' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569093 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569093, N'Pippin (Normal)', N'card_icon_caddie_05', 3, 1, 31, 0 ) END -- Item Name: Pippin (S.Raro) -- Item ID: 2084569094 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569094 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin (S.Raro)' , ICON = N'card_icon_caddie_06' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569094 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569094, N'Pippin (S.Raro)', N'card_icon_caddie_06', 3, 1, 31, 0 ) END -- Item Name: Pippin (Secreto) -- Item ID: 2084569095 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569095 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin (Secreto)' , ICON = N'card_icon_caddie_07' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569095 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569095, N'Pippin (Secreto)', N'card_icon_caddie_07', 3, 1, 31, 0 ) END -- Item Name: Titan Boo (Raro) -- Item ID: 2084569096 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569096 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan Boo (Raro)' , ICON = N'card_icon_caddie_08' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569096 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569096, N'Titan Boo (Raro)', N'card_icon_caddie_08', 3, 1, 31, 0 ) END -- Item Name: Titan Boo (S.Raro) -- Item ID: 2084569097 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569097 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan Boo (S.Raro)' , ICON = N'card_icon_caddie_09' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569097 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569097, N'Titan Boo (S.Raro)', N'card_icon_caddie_09', 3, 1, 31, 0 ) END -- Item Name: Titan Boo (Secreto) -- Item ID: 2084569098 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569098 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan Boo (Secreto)' , ICON = N'card_icon_caddie_10' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569098 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569098, N'Titan Boo (Secreto)', N'card_icon_caddie_10', 3, 1, 31, 0 ) END -- Item Name: Titan Boo (Normal) -- Item ID: 2084569099 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569099 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan Boo (Normal)' , ICON = N'card_icon_caddie_11' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569099 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569099, N'Titan Boo (Normal)', N'card_icon_caddie_11', 3, 1, 31, 0 ) END -- Item Name: Dolphini (Normal) -- Item ID: 2084569100 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569100 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini (Normal)' , ICON = N'card_icon_caddie_12' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569100 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569100, N'Dolphini (Normal)', N'card_icon_caddie_12', 3, 1, 31, 0 ) END -- Item Name: Dolphini (Raro) -- Item ID: 2084569101 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569101 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini (Raro)' , ICON = N'card_icon_caddie_13' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569101 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569101, N'Dolphini (Raro)', N'card_icon_caddie_13', 3, 1, 31, 0 ) END -- Item Name: Dolphini (S.Raro) -- Item ID: 2084569102 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569102 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini (S.Raro)' , ICON = N'card_icon_caddie_14' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569102 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569102, N'Dolphini (S.Raro)', N'card_icon_caddie_14', 3, 1, 31, 0 ) END -- Item Name: Dolphini (Secreto) -- Item ID: 2084569103 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569103 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini (Secreto)' , ICON = N'card_icon_caddie_15' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569103 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569103, N'Dolphini (Secreto)', N'card_icon_caddie_15', 3, 1, 31, 0 ) END -- Item Name: Lolo (Normal) -- Item ID: 2084569104 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569104 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lolo (Normal)' , ICON = N'card_icon_caddie_16' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569104 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569104, N'Lolo (Normal)', N'card_icon_caddie_16', 3, 1, 31, 0 ) END -- Item Name: Lolo (Raro) -- Item ID: 2084569105 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569105 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lolo (Raro)' , ICON = N'card_icon_caddie_17' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569105 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569105, N'Lolo (Raro)', N'card_icon_caddie_17', 3, 1, 31, 0 ) END -- Item Name: Lolo (S.Raro) -- Item ID: 2084569106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lolo (S.Raro)' , ICON = N'card_icon_caddie_18' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569106, N'Lolo (S.Raro)', N'card_icon_caddie_18', 3, 1, 31, 0 ) END -- Item Name: Lolo (Reliquia) -- Item ID: 2084569107 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569107 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lolo (Reliquia)' , ICON = N'card_icon_caddie_47' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569107 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569107, N'Lolo (Reliquia)', N'card_icon_caddie_47', 3, 1, 31, 0 ) END -- Item Name: Kuma (Normal) -- Item ID: 2084569108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma (Normal)' , ICON = N'card_icon_caddie_20' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569108, N'Kuma (Normal)', N'card_icon_caddie_20', 3, 1, 31, 0 ) END -- Item Name: Kuma (Raro) -- Item ID: 2084569109 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569109 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma (Raro)' , ICON = N'card_icon_caddie_21' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569109 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569109, N'Kuma (Raro)', N'card_icon_caddie_21', 3, 1, 31, 0 ) END -- Item Name: Kuma (S.Raro) -- Item ID: 2084569110 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569110 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma (S.Raro)' , ICON = N'card_icon_caddie_22' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569110 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569110, N'Kuma (S.Raro)', N'card_icon_caddie_22', 3, 1, 31, 0 ) END -- Item Name: Kuma (Secreto) -- Item ID: 2084569111 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569111 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma (Secreto)' , ICON = N'card_icon_caddie_23' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569111 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569111, N'Kuma (Secreto)', N'card_icon_caddie_23', 3, 1, 31, 0 ) END -- Item Name: Cadie (S.Raro) -- Item ID: 2084569112 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569112 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cadie (S.Raro)' , ICON = N'card_icon_caddie_24' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569112 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569112, N'Cadie (S.Raro)', N'card_icon_caddie_24', 3, 1, 31, 0 ) END -- Item Name: Cadie (Secreto) -- Item ID: 2084569113 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569113 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cadie (Secreto)' , ICON = N'card_icon_caddie_25' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569113 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569113, N'Cadie (Secreto)', N'card_icon_caddie_25', 3, 1, 31, 0 ) END -- Item Name: Titan Chan (S.Raro) -- Item ID: 2084569114 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569114 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan Chan (S.Raro)' , ICON = N'card_icon_npc_14' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569114 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569114, N'Titan Chan (S.Raro)', N'card_icon_npc_14', 3, 1, 31, 0 ) END -- Item Name: Cayman (Secreto) -- Item ID: 2084569125 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569125 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cayman (Secreto)' , ICON = N'card_icon_npc_07' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569125 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569125, N'Cayman (Secreto)', N'card_icon_npc_07', 3, 1, 31, 0 ) END -- Item Name: Titan God (Reliquia) -- Item ID: 2084569126 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569126 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan God (Reliquia)' , ICON = N'card_icon_npc_15' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569126 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569126, N'Titan God (Reliquia)', N'card_icon_npc_15', 3, 1, 31, 0 ) END -- Item Name: Bongdari (Normal) -- Item ID: 2084569115 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569115 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari (Normal)' , ICON = N'card_icon_caddie_27' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569115 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569115, N'Bongdari (Normal)', N'card_icon_caddie_27', 3, 1, 31, 0 ) END -- Item Name: Pippin (Normal) -- Item ID: 2084569116 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569116 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin (Normal)' , ICON = N'card_icon_caddie_28' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569116 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569116, N'Pippin (Normal)', N'card_icon_caddie_28', 3, 1, 31, 0 ) END -- Item Name: Tiki (Normal) -- Item ID: 2084569117 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569117 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tiki (Normal)' , ICON = N'card_icon_caddie_29' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569117 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569117, N'Tiki (Normal)', N'card_icon_caddie_29', 3, 1, 31, 0 ) END -- Item Name: Tiki (Raro) -- Item ID: 2084569118 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569118 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tiki (Raro)' , ICON = N'card_icon_caddie_30' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569118 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569118, N'Tiki (Raro)', N'card_icon_caddie_30', 3, 1, 31, 0 ) END -- Item Name: Winkle Pippin (Normal) -- Item ID: 2084569119 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569119 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Winkle Pippin (Normal)' , ICON = N'card_icon_caddie_31' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569119 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569119, N'Winkle Pippin (Normal)', N'card_icon_caddie_31', 3, 1, 31, 0 ) END -- Item Name: Winkle Pippin (Raro) -- Item ID: 2084569120 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569120 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Winkle Pippin (Raro)' , ICON = N'card_icon_caddie_32' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569120 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569120, N'Winkle Pippin (Raro)', N'card_icon_caddie_32', 3, 1, 31, 0 ) END -- Item Name: Cadie (Raro) -- Item ID: 2084569121 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569121 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cadie (Raro)' , ICON = N'card_icon_caddie_33' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569121 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569121, N'Cadie (Raro)', N'card_icon_caddie_33', 3, 1, 31, 0 ) END -- Item Name: Basic Training -- Item ID: 2088763392 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763392 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Basic Training ' , ICON = N'card_icon_special_00' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763392 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763392, N'Basic Training ', N'card_icon_special_00', 3, 1, 31, 0 ) END -- Item Name: Swing Training -- Item ID: 2088763393 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763393 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swing Training ' , ICON = N'card_icon_special_01' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763393 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763393, N'Swing Training ', N'card_icon_special_01', 3, 1, 31, 0 ) END -- Item Name: Training -- Item ID: 2088763394 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763394 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Training' , ICON = N'card_icon_special_02' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763394 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763394, N'Training', N'card_icon_special_02', 3, 1, 31, 0 ) END -- Item Name: Black Jerry Mind -- Item ID: 2088763395 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763395 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Jerry Mind' , ICON = N'card_icon_special_03' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763395 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763395, N'Black Jerry Mind', N'card_icon_special_03', 3, 1, 31, 0 ) END -- Item Name: Black Jerry Heart -- Item ID: 2088763396 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763396 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Jerry Heart' , ICON = N'card_icon_special_04' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763396 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763396, N'Black Jerry Heart', N'card_icon_special_04', 3, 1, 31, 0 ) END -- Item Name: Black Jerry Soul -- Item ID: 2088763397 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763397 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Jerry Soul' , ICON = N'card_icon_special_05' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763397 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763397, N'Black Jerry Soul', N'card_icon_special_05', 3, 1, 31, 0 ) END -- Item Name: White Jerry Mind -- Item ID: 2088763398 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763398 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Jerry Mind' , ICON = N'card_icon_special_06' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763398 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763398, N'White Jerry Mind', N'card_icon_special_06', 3, 1, 31, 0 ) END -- Item Name: White Jerry Heart -- Item ID: 2088763399 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763399 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Jerry Heart' , ICON = N'card_icon_special_07' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763399 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763399, N'White Jerry Heart', N'card_icon_special_07', 3, 1, 31, 0 ) END -- Item Name: White Jerry Soul -- Item ID: 2088763400 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763400 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Jerry Soul' , ICON = N'card_icon_special_08' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763400 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763400, N'White Jerry Soul', N'card_icon_special_08', 3, 1, 31, 0 ) END -- Item Name: Pang Bag Smallç¡) -- Item ID: 2088763401 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763401 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Bag Smallç¡)' , ICON = N'card_icon_special_09' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763401 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763401, N'Pang Bag Smallç¡)', N'card_icon_special_09', 3, 1, 31, 0 ) END -- Item Name: ¶Ø§à§Ô¹»Ñ§ (¡ÅÒ§) -- Item ID: 2088763402 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763402 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¶Ø§à§Ô¹»Ñ§ (¡ÅÒ§)' , ICON = N'card_icon_special_10' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763402 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763402, N'¶Ø§à§Ô¹»Ñ§ (¡ÅÒ§)', N'card_icon_special_10', 3, 1, 31, 0 ) END -- Item Name: ¶Ø§à§Ô¹»Ñ§ (ãË­è) -- Item ID: 2088763403 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763403 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¶Ø§à§Ô¹»Ñ§ (ãË­è)' , ICON = N'card_icon_special_11' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763403 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763403, N'¶Ø§à§Ô¹»Ñ§ (ãË­è)', N'card_icon_special_11', 3, 1, 31, 0 ) END -- Item Name: Pippin`s Time -- Item ID: 2088763404 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763404 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin`s Time' , ICON = N'card_icon_special_12' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763404 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763404, N'Pippin`s Time', N'card_icon_special_12', 3, 1, 31, 0 ) END -- Item Name: Pippin`s Time 2 -- Item ID: 2088763405 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763405 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin`s Time 2' , ICON = N'card_icon_special_13' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763405 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763405, N'Pippin`s Time 2', N'card_icon_special_13', 3, 1, 31, 0 ) END -- Item Name: Cadie`s Magic -- Item ID: 2088763406 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763406 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cadie`s Magic' , ICON = N'card_icon_special_14' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763406 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763406, N'Cadie`s Magic', N'card_icon_special_14', 3, 1, 31, 0 ) END -- Item Name: Cadie`s Magic 2 -- Item ID: 2088763407 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763407 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cadie`s Magic 2' , ICON = N'card_icon_special_15' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763407 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763407, N'Cadie`s Magic 2', N'card_icon_special_15', 3, 1, 31, 0 ) END -- Item Name: Tiki`s Blessing -- Item ID: 2088763408 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763408 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tiki`s Blessing' , ICON = N'card_icon_special_16' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763408 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763408, N'Tiki`s Blessing', N'card_icon_special_16', 3, 1, 31, 0 ) END -- Item Name: Tiki`s Blessing 2 -- Item ID: 2088763409 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763409 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tiki`s Blessing 2' , ICON = N'card_icon_special_17' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763409 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763409, N'Tiki`s Blessing 2', N'card_icon_special_17', 3, 1, 31, 0 ) END -- Item Name: Dolphini`s Trick -- Item ID: 2088763410 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763410 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini`s Trick' , ICON = N'card_icon_special_18' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763410 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763410, N'Dolphini`s Trick', N'card_icon_special_18', 3, 1, 31, 0 ) END -- Item Name: Dolphini`s Trick 2 -- Item ID: 2088763411 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763411 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini`s Trick 2' , ICON = N'card_icon_special_19' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763411 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763411, N'Dolphini`s Trick 2', N'card_icon_special_19', 3, 1, 31, 0 ) END -- Item Name: Kuma`s Support -- Item ID: 2088763412 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763412 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma`s Support' , ICON = N'card_icon_special_20' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763412 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763412, N'Kuma`s Support', N'card_icon_special_20', 3, 1, 31, 0 ) END -- Item Name: Kuma`s Support 2 -- Item ID: 2088763413 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763413 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma`s Support 2' , ICON = N'card_icon_special_21' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763413 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763413, N'Kuma`s Support 2', N'card_icon_special_21', 3, 1, 31, 0 ) END -- Item Name: Assistance Caddie -- Item ID: 2088763414 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763414 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Assistance Caddie' , ICON = N'card_icon_special_22' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763414 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763414, N'Assistance Caddie', N'card_icon_special_22', 3, 1, 31, 0 ) END -- Item Name: Stamina Pack -- Item ID: 2088763415 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763415 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Stamina Pack' , ICON = N'card_icon_special_23' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763415 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763415, N'Stamina Pack', N'card_icon_special_23', 3, 1, 31, 0 ) END -- Item Name: Billy`s Bag -- Item ID: 2088763416 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763416 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Billy`s Bag' , ICON = N'card_icon_special_24' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763416 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763416, N'Billy`s Bag', N'card_icon_special_24', 3, 1, 31, 0 ) END -- Item Name: Snow Ball (Reliquia) -- Item ID: 2088763417 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763417 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Ball (Reliquia)' , ICON = N'card_icon_special_57' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763417 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763417, N'Snow Ball (Reliquia)', N'card_icon_special_57', 3, 1, 31, 0 ) END -- Item Name: Rainbow Feather -- Item ID: 2088763418 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763418 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rainbow Feather' , ICON = N'card_icon_special_26' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763418 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763418, N'Rainbow Feather', N'card_icon_special_26', 3, 1, 31, 0 ) END -- Item Name: Sepia Wind -- Item ID: 2088763419 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763419 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sepia Wind' , ICON = N'card_icon_special_27' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763419 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763419, N'Sepia Wind', N'card_icon_special_27', 3, 1, 31, 0 ) END -- Item Name: Wind Hill -- Item ID: 2088763420 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763420 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Wind Hill' , ICON = N'card_icon_special_28' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763420 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763420, N'Wind Hill', N'card_icon_special_28', 3, 1, 31, 0 ) END -- Item Name: Pink Wind -- Item ID: 2088763421 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763421 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Wind' , ICON = N'card_icon_special_29' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763421 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763421, N'Pink Wind', N'card_icon_special_29', 3, 1, 31, 0 ) END -- Item Name: Blue Moon -- Item ID: 2088763422 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763422 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Moon' , ICON = N'card_icon_special_30' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763422 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763422, N'Blue Moon', N'card_icon_special_30', 3, 1, 31, 0 ) END -- Item Name: Pang bag(small) -- Item ID: 2088763423 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763423 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang bag(small)' , ICON = N'card_icon_special_31' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763423 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763423, N'Pang bag(small)', N'card_icon_special_31', 3, 1, 31, 0 ) END -- Item Name: Elf Ear -- Item ID: 2088763424 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763424 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Elf Ear' , ICON = N'card_icon_special_32' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763424 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763424, N'Elf Ear', N'card_icon_special_32', 3, 1, 31, 0 ) END -- Item Name: Treasure Hunter -- Item ID: 2088763425 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763425 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Treasure Hunter' , ICON = N'card_icon_special_33' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763425 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763425, N'Treasure Hunter', N'card_icon_special_33', 3, 1, 31, 0 ) END -- Item Name: Intermediate Training -- Item ID: 2088763426 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763426 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Intermediate Training ' , ICON = N'card_icon_special_34' , PRICE = 0 , ISCASH = 0 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763426 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763426, N'Intermediate Training ', N'card_icon_special_34', 0, 0, 31, 0 ) END -- Item Name: Black Jerry Mind -- Item ID: 2088763427 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763427 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Jerry Mind' , ICON = N'card_icon_special_35' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763427 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763427, N'Black Jerry Mind', N'card_icon_special_35', 3, 1, 31, 0 ) END -- Item Name: White Jerry Mind -- Item ID: 2088763428 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763428 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Jerry Mind' , ICON = N'card_icon_special_36' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763428 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763428, N'White Jerry Mind', N'card_icon_special_36', 3, 1, 31, 0 ) END -- Item Name: Dolphini's Umbrella -- Item ID: 2088763429 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763429 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini''s Umbrella' , ICON = N'card_icon_special_37' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763429 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763429, N'Dolphini''s Umbrella', N'card_icon_special_37', 3, 1, 31, 0 ) END -- Item Name: Orihakon -- Item ID: 2088763430 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763430 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Orihakon' , ICON = N'card_icon_special_38' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763430 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763430, N'Orihakon', N'card_icon_special_38', 3, 1, 31, 0 ) END -- Item Name: Pangya Card Pack No.1 -- Item ID: 2092957696 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957696 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Card Pack No.1' , ICON = N'card_icon_pack_00' , PRICE = 9900 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957696 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957696, N'Pangya Card Pack No.1', N'card_icon_pack_00', 9900, 1, 31, 0 ) END -- Item Name: Golden Card Ticket -- Item ID: 2092957697 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957697 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Golden Card Ticket ' , ICON = N'card_icon_pack_01' , PRICE = 3 , ISCASH = 0 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957697 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957697, N'Golden Card Ticket ', N'card_icon_pack_01', 3, 0, 31, 0 ) END -- Item Name: Silver Card Ticket -- Item ID: 2092957698 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957698 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Silver Card Ticket ' , ICON = N'card_icon_pack_02' , PRICE = 3 , ISCASH = 0 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957698 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957698, N'Silver Card Ticket ', N'card_icon_pack_02', 3, 0, 31, 0 ) END -- Item Name: Bronze card ticket -- Item ID: 2092957699 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957699 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bronze card ticket' , ICON = N'card_icon_pack_03' , PRICE = 3 , ISCASH = 0 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957699 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957699, N'Bronze card ticket', N'card_icon_pack_03', 3, 0, 31, 0 ) END -- Item Name: Pangya Card Pack No.2 -- Item ID: 2092957700 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957700 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Card Pack No.2' , ICON = N'card_icon_pack_04' , PRICE = 9900 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957700 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957700, N'Pangya Card Pack No.2', N'card_icon_pack_04', 9900, 1, 31, 0 ) END -- Item Name: Pangya Card Box No.2 -- Item ID: 2097152001 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2097152001 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Card Box No.2' , ICON = N'card_icon_box_01' , PRICE = 150 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2097152001 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2097152001, N'Pangya Card Box No.2', N'card_icon_box_01', 150, 1, 31, 0 ) END -- Item Name: Pack de Expansao Vol.1 -- Item ID: 2092957710 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957710 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pack de Expansao Vol.1' , ICON = N'card_icon_pack_08' , PRICE = 9900 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957710 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957710, N'Pack de Expansao Vol.1', N'card_icon_pack_08', 9900, 1, 31, 0 ) END -- Item Name: Pack de Expansao Vol.2 -- Item ID: 2092957711 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2092957711 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pack de Expansao Vol.2' , ICON = N'card_icon_pack_05' , PRICE = 25000 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2092957711 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2092957711, N'Pack de Expansao Vol.2', N'card_icon_pack_05', 25000, 1, 31, 0 ) END -- Item Name: Fred Especial (SR) -- Item ID: 2088763431 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763431 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fred Especial (SR)' , ICON = N'card_icon_special_54' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763431 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763431, N'Fred Especial (SR)', N'card_icon_special_54', 3, 1, 31, 0 ) END -- Item Name: Arin (Normal) -- Item ID: 2080374824 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374824 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (Normal)' , ICON = N'card_icon_char_41' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374824 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374824, N'Arin (Normal)', N'card_icon_char_41', 3, 1, 31, 0 ) END -- Item Name: Kooh (S. Raro) -- Item ID: 2080374825 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374825 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (S. Raro)' , ICON = N'card_icon_char_42' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374825 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374825, N'Kooh (S. Raro)', N'card_icon_char_42', 3, 1, 31, 0 ) END -- Item Name: Nico (Secreto) -- Item ID: 2080374826 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374826 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nico (Secreto)' , ICON = N'card_icon_char_43' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374826 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374826, N'Nico (Secreto)', N'card_icon_char_43', 3, 1, 31, 0 ) END -- Item Name: Lucia (Raro) -- Item ID: 2080374827 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374827 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia (Raro)' , ICON = N'card_icon_char_45' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374827 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374827, N'Lucia (Raro)', N'card_icon_char_45', 3, 1, 31, 0 ) END -- Item Name: Hana (Raro) -- Item ID: 2080374828 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374828 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana (Raro)' , ICON = N'card_icon_char_46' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374828 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374828, N'Hana (Raro)', N'card_icon_char_46', 3, 1, 31, 0 ) END -- Item Name: Nell (Raro) -- Item ID: 2080374829 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374829 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nell (Raro)' , ICON = N'card_icon_char_47' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374829 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374829, N'Nell (Raro)', N'card_icon_char_47', 3, 1, 31, 0 ) END -- Item Name: Nell (Normal) -- Item ID: 2080374830 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374830 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nell (Normal)' , ICON = N'card_icon_char_48' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374830 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374830, N'Nell (Normal)', N'card_icon_char_48', 3, 1, 31, 0 ) END -- Item Name: Nuri (Normal) -- Item ID: 2080374831 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374831 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri (Normal)' , ICON = N'card_icon_char_58' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374831 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374831, N'Nuri (Normal)', N'card_icon_char_58', 3, 1, 31, 0 ) END -- Item Name: Cessilia (Normal) -- Item ID: 2080374832 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374832 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cessilia (Normal)' , ICON = N'card_icon_char_59' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374832 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374832, N'Cessilia (Normal)', N'card_icon_char_59', 3, 1, 31, 0 ) END -- Item Name: Kooh (Normal) -- Item ID: 2080374833 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374833 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh (Normal)' , ICON = N'card_icon_char_60' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374833 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374833, N'Kooh (Normal)', N'card_icon_char_60', 3, 1, 31, 0 ) END -- Item Name: Lucia (Normal) -- Item ID: 2080374834 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374834 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia (Normal) ' , ICON = N'card_icon_char_62' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374834 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374834, N'Lucia (Normal) ', N'card_icon_char_62', 3, 1, 31, 0 ) END -- Item Name: Nell (S. Raro) -- Item ID: 2080374835 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374835 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nell (S. Raro)' , ICON = N'card_icon_char_64' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374835 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374835, N'Nell (S. Raro)', N'card_icon_char_64', 3, 1, 31, 0 ) END -- Item Name: Lolo (Secreto) -- Item ID: 2084569122 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569122 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lolo (Secreto)' , ICON = N'card_icon_caddie_52' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569122 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569122, N'Lolo (Secreto)', N'card_icon_caddie_52', 3, 1, 31, 0 ) END -- Item Name: Mingti (Hyper Secreto) -- Item ID: 2084569123 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569123 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mingti (Hyper Secreto)' , ICON = N'card_icon_caddie_51' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569123 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569123, N'Mingti (Hyper Secreto)', N'card_icon_caddie_51', 3, 1, 31, 0 ) END -- Item Name: Nico (Raro) -- Item ID: 2088763432 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763432 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nico (Raro)' , ICON = N'card_icon_special_56' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763432 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763432, N'Nico (Raro)', N'card_icon_special_56', 3, 1, 31, 0 ) END -- Item Name: Bongdari (Raro) -- Item ID: 2084569124 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2084569124 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari (Raro)' , ICON = N'card_icon_caddie_50' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2084569124 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2084569124, N'Bongdari (Raro)', N'card_icon_caddie_50', 3, 1, 31, 0 ) END -- Item Name: Pang Jar (Raro) -- Item ID: 2088763433 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763433 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Jar (Raro)' , ICON = N'card_icon_special_68' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763433 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763433, N'Pang Jar (Raro)', N'card_icon_special_68', 3, 1, 31, 0 ) END -- Item Name: Pang Jar (S.Raro) -- Item ID: 2088763434 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763434 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Jar (S.Raro)' , ICON = N'card_icon_special_69' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763434 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763434, N'Pang Jar (S.Raro)', N'card_icon_special_69', 3, 1, 31, 0 ) END -- Item Name: Card de Pang -- Item ID: 2088763435 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763435 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Card de Pang' , ICON = N'card_icon_special_67' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763435 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763435, N'Card de Pang', N'card_icon_special_67', 3, 1, 31, 0 ) END -- Item Name: Card de Exp. -- Item ID: 2088763436 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763436 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Card de Exp.' , ICON = N'card_icon_special_66' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763436 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763436, N'Card de Exp.', N'card_icon_special_66', 3, 1, 31, 0 ) END -- Item Name: Arin (S. Raro) -- Item ID: 2080374836 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2080374836 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (S. Raro)' , ICON = N'card_icon_char_61' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2080374836 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2080374836, N'Arin (S. Raro)', N'card_icon_char_61', 3, 1, 31, 0 ) END -- Item Name: Kaz (Raro) -- Item ID: 2088763437 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763437 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz (Raro)' , ICON = N'card_icon_special_72' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763437 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763437, N'Kaz (Raro)', N'card_icon_special_72', 3, 1, 31, 0 ) END -- Item Name: Arin (Raro) -- Item ID: 2088763438 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763438 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin (Raro)' , ICON = N'card_icon_special_71' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763438 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763438, N'Arin (Raro)', N'card_icon_special_71', 3, 1, 31, 0 ) END -- Item Name: Hana (Raro) -- Item ID: 2088763439 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 2088763439 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana (Raro)' , ICON = N'card_icon_special_70' , PRICE = 3 , ISCASH = 1 , TYPE = 31 , IS_SALABLE = 0 WHERE TYPEID = 2088763439 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 2088763439, N'Hana (Raro)', N'card_icon_special_70', 3, 1, 31, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia