-- ----------------------------------------------- -- -- 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 "Item.iff" -- -- Last update of the IFF: 2023-11-12 12:06:39 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Item.iff contains 223 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Guaraná do Spin -- Item ID: 402653184 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653184 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guaraná do Spin' , ICON = N'item0_00' , PRICE = 120 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653184 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653184, N'Guaraná do Spin', N'item0_00', 120, 0, 6, 0 ) END -- Item Name: Banana da Curva -- Item ID: 402653185 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653185 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Banana da Curva' , ICON = N'item0_01' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653185 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653185, N'Banana da Curva', N'item0_01', 100, 0, 6, 0 ) END -- Item Name: PangYa da Sorte -- Item ID: 402653186 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653186 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangYa da Sorte' , ICON = N'item0_02' , PRICE = 150 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653186 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653186, N'PangYa da Sorte', N'item0_02', 150, 0, 6, 0 ) END -- Item Name: Tranquilizante -- Item ID: 402653187 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653187 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tranquilizante' , ICON = N'item0_03' , PRICE = 130 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653187 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653187, N'Tranquilizante', N'item0_03', 130, 0, 6, 0 ) END -- Item Name: Suco do Poder -- Item ID: 402653188 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653188 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Suco do Poder' , ICON = N'item0_04' , PRICE = 130 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653188 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653188, N'Suco do Poder', N'item0_04', 130, 0, 6, 0 ) END -- Item Name: Olho Mágico -- Item ID: 402653189 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653189 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Olho Mágico' , ICON = N'item0_05' , PRICE = 180 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653189 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653189, N'Olho Mágico', N'item0_05', 180, 0, 6, 0 ) END -- Item Name: Corta-Vento -- Item ID: 402653190 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653190 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Corta-Vento' , ICON = N'item0_06' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653190 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653190, N'Corta-Vento', N'item0_06', 2900, 1, 6, 0 ) END -- Item Name: PangYa da Sorte -- Item ID: 402653191 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653191 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangYa da Sorte' , ICON = N'item0_07' , PRICE = 40 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653191 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653191, N'PangYa da Sorte', N'item0_07', 40, 0, 6, 0 ) END -- Item Name: Tranquilizante -- Item ID: 402653192 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653192 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tranquilizante' , ICON = N'item0_08' , PRICE = 30 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653192 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653192, N'Tranquilizante', N'item0_08', 30, 0, 6, 0 ) END -- Item Name: Calibradornte -- Item ID: 402653193 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653193 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Calibradornte' , ICON = N'item0_09' , PRICE = 1900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653193 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653193, N'Calibradornte', N'item0_09', 1900, 1, 6, 0 ) END -- Item Name: PangYa da Sorte -- Item ID: 402653194 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653194 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangYa da Sorte' , ICON = N'item0_10' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653194 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653194, N'PangYa da Sorte', N'item0_10', 2900, 1, 6, 0 ) END -- Item Name: Tranquilizante Especial -- Item ID: 402653195 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653195 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tranquilizante Especial' , ICON = N'item0_11' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653195 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653195, N'Tranquilizante Especial', N'item0_11', 2900, 1, 6, 0 ) END -- Item Name: Power stabilizer -- Item ID: 402653196 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653196 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power stabilizer' , ICON = N'item0_12' , PRICE = 100000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653196 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653196, N'Power stabilizer', N'item0_12', 100000, 0, 6, 0 ) END -- Item Name: Question Mark -- Item ID: 402653197 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653197 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Question Mark' , ICON = N'item0_13' , PRICE = 100000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653197 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653197, N'Question Mark', N'item0_13', 100000, 0, 6, 0 ) END -- Item Name: Oblivion Flower -- Item ID: 402653198 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653198 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Oblivion Flower' , ICON = N'item0_14' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653198 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653198, N'Oblivion Flower', N'item0_14', 2900, 1, 6, 0 ) END -- Item Name: Afro Pill -- Item ID: 402653199 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653199 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Afro Pill' , ICON = N'item0_15' , PRICE = 2890 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653199 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653199, N'Afro Pill', N'item0_15', 2890, 1, 6, 0 ) END -- Item Name: Strength Tranquilizer -- Item ID: 402653200 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653200 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Strength Tranquilizer' , ICON = N'item0_16' , PRICE = 3900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653200 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653200, N'Strength Tranquilizer', N'item0_16', 3900, 1, 6, 0 ) END -- Item Name: Spin Tranquilizer -- Item ID: 402653201 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653201 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spin Tranquilizer' , ICON = N'item0_17' , PRICE = 3900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653201 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653201, N'Spin Tranquilizer', N'item0_17', 3900, 1, 6, 0 ) END -- Item Name: Lucky Tranquilizer -- Item ID: 402653202 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653202 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucky Tranquilizer' , ICON = N'item0_18' , PRICE = 3900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653202 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653202, N'Lucky Tranquilizer', N'item0_18', 3900, 1, 6, 0 ) END -- Item Name: Course Spell -- Item ID: 402653203 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653203 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Course Spell' , ICON = N'item0_19' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653203 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653203, N'Course Spell', N'item0_19', 2900, 1, 6, 0 ) END -- Item Name: Tomahark Spell -- Item ID: 402653204 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653204 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tomahark Spell' , ICON = N'item0_20' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653204 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653204, N'Tomahark Spell', N'item0_20', 2900, 1, 6, 0 ) END -- Item Name: Cobra Spell -- Item ID: 402653205 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653205 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cobra Spell' , ICON = N'item0_21' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653205 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653205, N'Cobra Spell', N'item0_21', 2900, 1, 6, 0 ) END -- Item Name: Reward Wind -- Item ID: 402653206 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653206 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Reward Wind' , ICON = N'item0_22' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653206 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653206, N'Reward Wind', N'item0_22', 2900, 1, 6, 0 ) END -- Item Name: Wind Change (Attack) -- Item ID: 402653207 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653207 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Wind Change (Attack)' , ICON = N'item0_23' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653207 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653207, N'Wind Change (Attack)', N'item0_23', 100, 0, 6, 0 ) END -- Item Name: Direction Change (Attack) -- Item ID: 402653208 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653208 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Direction Change (Attack)' , ICON = N'item0_24' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653208 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653208, N'Direction Change (Attack)', N'item0_24', 100, 0, 6, 0 ) END -- Item Name: Transparent grid (Attack) -- Item ID: 402653209 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653209 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Transparent grid (Attack)' , ICON = N'item0_25' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653209 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653209, N'Transparent grid (Attack)', N'item0_25', 100, 0, 6, 0 ) END -- Item Name: Shield (Defense) -- Item ID: 402653210 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653210 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Shield (Defense)' , ICON = N'item0_26' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653210 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653210, N'Shield (Defense)', N'item0_26', 100, 0, 6, 0 ) END -- Item Name: Reflection (Defense) -- Item ID: 402653211 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653211 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Reflection (Defense)' , ICON = N'item0_27' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653211 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653211, N'Reflection (Defense)', N'item0_27', 100, 0, 6, 0 ) END -- Item Name: Turn Back (Attack) -- Item ID: 402653212 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653212 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Turn Back (Attack)' , ICON = N'item0_28' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653212 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653212, N'Turn Back (Attack)', N'item0_28', 100, 0, 6, 0 ) END -- Item Name: Earthquake (Attack) -- Item ID: 402653213 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653213 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Earthquake (Attack)' , ICON = N'item0_29' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653213 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653213, N'Earthquake (Attack)', N'item0_29', 100, 0, 6, 0 ) END -- Item Name: Distance (Attack) -- Item ID: 402653214 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653214 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Distance (Attack)' , ICON = N'item0_30' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653214 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653214, N'Distance (Attack)', N'item0_30', 100, 0, 6, 0 ) END -- Item Name: Fork -- Item ID: 402653215 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653215 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fork' , ICON = N'item0_31' , PRICE = 0 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653215 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653215, N'Fork', N'item0_31', 0, 1, 6, 0 ) END -- Item Name: Tissue -- Item ID: 402653216 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653216 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tissue' , ICON = N'item0_32' , PRICE = 0 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653216 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653216, N'Tissue', N'item0_32', 0, 1, 6, 0 ) END -- Item Name: Duostar Shamrock Pangya(USA) -- Item ID: 402653217 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653217 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Duostar Shamrock Pangya(USA)' , ICON = N'item0_33' , PRICE = 25 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653217 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653217, N'Duostar Shamrock Pangya(USA)', N'item0_33', 25, 1, 6, 0 ) END -- Item Name: Strawberry cake -- Item ID: 402653218 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653218 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Strawberry cake' , ICON = N'item0_34' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653218 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653218, N'Strawberry cake', N'item0_34', 10000000, 0, 6, 0 ) END -- Item Name: Duo Lucky Pangya(PH) -- Item ID: 402653219 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653219 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Duo Lucky Pangya(PH)' , ICON = N'item0_10' , PRICE = 1000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653219 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653219, N'Duo Lucky Pangya(PH)', N'item0_10', 1000, 1, 6, 0 ) END -- Item Name: Duo Nervine Type(PH) -- Item ID: 402653220 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653220 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Duo Nervine Type(PH)' , ICON = N'item0_11' , PRICE = 1000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653220 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653220, N'Duo Nervine Type(PH)', N'item0_11', 1000, 1, 6, 0 ) END -- Item Name: P. Strength Boost -- Item ID: 402653221 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653221 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'P. Strength Boost' , ICON = N'item0_37' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653221 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653221, N'P. Strength Boost', N'item0_37', 10000000, 0, 6, 0 ) END -- Item Name: ?? ???2(CN) -- Item ID: 402653222 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653222 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ???2(CN)' , ICON = N'item0_15' , PRICE = 9 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653222 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653222, N'?? ???2(CN)', N'item0_15', 9, 1, 6, 0 ) END -- Item Name: Double Strength Boost -- Item ID: 402653223 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653223 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Double Strength Boost' , ICON = N'item0_39' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653223 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653223, N'Double Strength Boost', N'item0_39', 2900, 1, 6, 0 ) END -- Item Name: Safe Tee -- Item ID: 402653224 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653224 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Safe Tee' , ICON = N'item0_40' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653224 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653224, N'Safe Tee', N'item0_40', 2900, 1, 6, 0 ) END -- Item Name: Silent Wind -- Item ID: 402653312 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653312 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Silent Wind' , ICON = N'item0_06' , PRICE = 5800 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653312 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653312, N'Silent Wind', N'item0_06', 5800, 1, 6, 0 ) END -- Item Name: Silent Wind -- Item ID: 402653313 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653313 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Silent Wind' , ICON = N'item0_06' , PRICE = 14500 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653313 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653313, N'Silent Wind', N'item0_06', 14500, 1, 6, 0 ) END -- Item Name: Spin Mastery -- Item ID: 402653314 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653314 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spin Mastery' , ICON = N'item0_00' , PRICE = 2400 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653314 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653314, N'Spin Mastery', N'item0_00', 2400, 0, 6, 0 ) END -- Item Name: Lucky PangYa -- Item ID: 402653315 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653315 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucky PangYa' , ICON = N'item0_07' , PRICE = 800 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653315 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653315, N'Lucky PangYa', N'item0_07', 800, 0, 6, 0 ) END -- Item Name: Strength Boost -- Item ID: 402653316 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 402653316 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Strength Boost' , ICON = N'item0_04' , PRICE = 2600 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 402653316 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 402653316, N'Strength Boost', N'item0_04', 2600, 0, 6, 0 ) END -- Item Name: Fita de Replay -- Item ID: 436207616 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207616 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fita de Replay' , ICON = N'item1_00' , PRICE = 2000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207616 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207616, N'Fita de Replay', N'item1_00', 2000, 1, 6, 0 ) END -- Item Name: Poder Pang -- Item ID: 436207617 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207617 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Poder Pang' , ICON = N'item1_01' , PRICE = 6900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207617 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207617, N'Poder Pang', N'item1_01', 6900, 1, 6, 0 ) END -- Item Name: Poder Pang -- Item ID: 436207618 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207618 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Poder Pang' , ICON = N'item1_02' , PRICE = 6900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207618 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207618, N'Poder Pang', N'item1_02', 6900, 1, 6, 0 ) END -- Item Name: Mudar o Nome -- Item ID: 436207619 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207619 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mudar o Nome' , ICON = N'item1_03' , PRICE = 1500 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207619 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207619, N'Mudar o Nome', N'item1_03', 1500, 1, 6, 0 ) END -- Item Name: Bolsa da Sorte -- Item ID: 436207620 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207620 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bolsa da Sorte' , ICON = N'item1_04' , PRICE = 50 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207620 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207620, N'Bolsa da Sorte', N'item1_04', 50, 1, 6, 0 ) END -- Item Name: Nitro Pang Mastery -- Item ID: 436207621 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207621 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nitro Pang Mastery' , ICON = N'item1_05' , PRICE = 45900 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207621 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207621, N'Nitro Pang Mastery', N'item1_05', 45900, 0, 6, 0 ) END -- Item Name: Colar da Sorte -- Item ID: 436207622 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207622 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Colar da Sorte' , ICON = N'item1_06' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207622 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207622, N'Colar da Sorte', N'item1_06', 0, 0, 6, 0 ) END -- Item Name: Love Chocolate -- Item ID: 436207623 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207623 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Chocolate' , ICON = N'item1_07' , PRICE = 1900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207623 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207623, N'Love Chocolate', N'item1_07', 1900, 1, 6, 0 ) END -- Item Name: Justice Chocolate -- Item ID: 436207624 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207624 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Justice Chocolate' , ICON = N'item1_08' , PRICE = 1900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207624 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207624, N'Justice Chocolate', N'item1_08', 1900, 1, 6, 0 ) END -- Item Name: Lucky Chocolate -- Item ID: 436207625 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207625 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucky Chocolate' , ICON = N'item1_09' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207625 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207625, N'Lucky Chocolate', N'item1_09', 10000000, 0, 6, 0 ) END -- Item Name: Love Chocolate -- Item ID: 436207626 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207626 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Chocolate' , ICON = N'item1_10' , PRICE = 1900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207626 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207626, N'Love Chocolate', N'item1_10', 1900, 1, 6, 0 ) END -- Item Name: Delight Chocolate -- Item ID: 436207627 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207627 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Delight Chocolate' , ICON = N'item1_11' , PRICE = 1900 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207627 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207627, N'Delight Chocolate', N'item1_11', 1900, 0, 6, 0 ) END -- Item Name: Lucky Candy -- Item ID: 436207628 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207628 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucky Candy' , ICON = N'item1_12' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207628 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207628, N'Lucky Candy', N'item1_12', 10000000, 0, 6, 0 ) END -- Item Name: Love Candy -- Item ID: 436207629 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207629 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Candy' , ICON = N'item1_13' , PRICE = 1900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207629 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207629, N'Love Candy', N'item1_13', 1900, 1, 6, 0 ) END -- Item Name: Pirulito da Sorte -- Item ID: 436207630 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207630 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirulito da Sorte' , ICON = N'item1_14' , PRICE = 78000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207630 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207630, N'Pirulito da Sorte', N'item1_14', 78000, 0, 6, 0 ) END -- Item Name: Angel Candy -- Item ID: 436207631 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207631 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Angel Candy' , ICON = N'item1_15' , PRICE = 100 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207631 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207631, N'Angel Candy', N'item1_15', 100, 0, 6, 0 ) END -- Item Name: Pang Pocket -- Item ID: 436207632 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207632 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Pocket' , ICON = N'item1_16' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207632 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207632, N'Pang Pocket', N'item1_16', 0, 0, 6, 0 ) END -- Item Name: Corta Tempo -- Item ID: 436207633 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207633 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Corta Tempo' , ICON = N'item1_17' , PRICE = 2900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207633 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207633, N'Corta Tempo', N'item1_17', 2900, 1, 6, 0 ) END -- Item Name: Pangya Cake -- Item ID: 436207634 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207634 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Cake' , ICON = N'item1_18' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207634 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207634, N'Pangya Cake', N'item1_18', 10000000, 0, 6, 0 ) END -- Item Name: Moon Cake (TW) -- Item ID: 436207635 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207635 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moon Cake (TW)' , ICON = N'item1_19' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207635 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207635, N'Moon Cake (TW)', N'item1_19', 10000000, 0, 6, 0 ) END -- Item Name: Halloween Candy -- Item ID: 436207636 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207636 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Halloween Candy' , ICON = N'item1_20' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207636 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207636, N'Halloween Candy', N'item1_20', 10000000, 0, 6, 0 ) END -- Item Name: 1000CP Discount (Event) -- Item ID: 436207637 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207637 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'1000CP Discount (Event)' , ICON = N'item1_21' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207637 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207637, N'1000CP Discount (Event)', N'item1_21', 10000000, 0, 6, 0 ) END -- Item Name: 2000CP Discount (Event) -- Item ID: 436207638 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207638 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2000CP Discount (Event)' , ICON = N'item1_22' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207638 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207638, N'2000CP Discount (Event)', N'item1_22', 10000000, 0, 6, 0 ) END -- Item Name: Free Coupon (Event) -- Item ID: 436207639 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207639 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Free Coupon (Event)' , ICON = N'item1_23' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207639 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207639, N'Free Coupon (Event)', N'item1_23', 10000000, 0, 6, 0 ) END -- Item Name: Red Socks -- Item ID: 436207640 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207640 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Socks' , ICON = N'item1_24' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207640 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207640, N'Red Socks', N'item1_24', 0, 0, 6, 0 ) END -- Item Name: Albatross18 Popper(Us) -- Item ID: 436207641 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207641 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Albatross18 Popper(Us)' , ICON = N'item1_25' , PRICE = 120 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207641 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207641, N'Albatross18 Popper(Us)', N'item1_25', 120, 1, 6, 0 ) END -- Item Name: Lucky Popper(Us) -- Item ID: 436207642 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207642 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucky Popper(Us)' , ICON = N'item1_25' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207642 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207642, N'Lucky Popper(Us)', N'item1_25', 0, 0, 6, 0 ) END -- Item Name: Lucky Bag 2006 (JP) -- Item ID: 436207643 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207643 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucky Bag 2006 (JP)' , ICON = N'item1_04' , PRICE = 50 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207643 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207643, N'Lucky Bag 2006 (JP)', N'item1_04', 50, 1, 6, 0 ) END -- Item Name: ? -- Item ID: 436207644 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207644 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?' , ICON = N'item1_28' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207644 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207644, N'?', N'item1_28', 0, 0, 6, 0 ) END -- Item Name: 1000CP Discount (Gift) -- Item ID: 436207645 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207645 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'1000CP Discount (Gift)' , ICON = N'item1_29' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207645 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207645, N'1000CP Discount (Gift)', N'item1_29', 10000000, 0, 6, 0 ) END -- Item Name: 1000CP Discount (GM) -- Item ID: 436207646 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207646 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'1000CP Discount (GM)' , ICON = N'item1_30' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207646 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207646, N'1000CP Discount (GM)', N'item1_30', 10000000, 0, 6, 0 ) END -- Item Name: Pirulito Secreto -- Item ID: 436207647 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207647 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirulito Secreto' , ICON = N'item1_15' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207647 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207647, N'Pirulito Secreto', N'item1_15', 0, 0, 6, 0 ) END -- Item Name: Half heart (right) -- Item ID: 436207648 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207648 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Half heart (right)' , ICON = N'item1_32' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207648 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207648, N'Half heart (right)', N'item1_32', 10000000, 0, 6, 0 ) END -- Item Name: Good Boy -- Item ID: 436207649 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207649 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Good Boy' , ICON = N'item1_33' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207649 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207649, N'Good Boy', N'item1_33', 10000000, 0, 6, 0 ) END -- Item Name: Good Girl -- Item ID: 436207650 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207650 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Good Girl' , ICON = N'item1_34' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207650 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207650, N'Good Girl', N'item1_34', 10000000, 0, 6, 0 ) END -- Item Name: Valentine Item(2) -- Item ID: 436207651 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207651 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentine Item(2)' , ICON = N'item1_35' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207651 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207651, N'Valentine Item(2)', N'item1_35', 10000000, 0, 6, 0 ) END -- Item Name: Whiteday Item(2) -- Item ID: 436207652 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207652 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Whiteday Item(2)' , ICON = N'item1_36' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207652 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207652, N'Whiteday Item(2)', N'item1_36', 10000000, 0, 6, 0 ) END -- Item Name: Valentine Item(3) -- Item ID: 436207653 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207653 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentine Item(3)' , ICON = N'item1_37' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207653 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207653, N'Valentine Item(3)', N'item1_37', 10000000, 0, 6, 0 ) END -- Item Name: Whiteday Item(3) -- Item ID: 436207654 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207654 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Whiteday Item(3)' , ICON = N'item1_38' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207654 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207654, N'Whiteday Item(3)', N'item1_38', 10000000, 0, 6, 0 ) END -- Item Name: Half heart (Left) -- Item ID: 436207655 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207655 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Half heart (Left)' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207655 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207655, N'Half heart (Left)', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Bongdari CP(Event) -- Item ID: 436207656 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207656 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari CP(Event)' , ICON = N'item1_40' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207656 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207656, N'Bongdari CP(Event)', N'item1_40', 10000000, 0, 6, 0 ) END -- Item Name: Bongdari CP(Gift) -- Item ID: 436207657 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207657 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari CP(Gift)' , ICON = N'item1_41' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207657 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207657, N'Bongdari CP(Gift)', N'item1_41', 10000000, 0, 6, 0 ) END -- Item Name: Bongdari CP(GM) -- Item ID: 436207658 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207658 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari CP(GM)' , ICON = N'item1_42' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207658 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207658, N'Bongdari CP(GM)', N'item1_42', 10000000, 0, 6, 0 ) END -- Item Name: 2000CP Discount (Gift) -- Item ID: 436207659 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207659 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2000CP Discount (Gift)' , ICON = N'item1_43' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207659 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207659, N'2000CP Discount (Gift)', N'item1_43', 10000000, 0, 6, 0 ) END -- Item Name: 2000CP Discount (GM) -- Item ID: 436207660 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207660 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2000CP Discount (GM)' , ICON = N'item1_44' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207660 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207660, N'2000CP Discount (GM)', N'item1_44', 10000000, 0, 6, 0 ) END -- Item Name: Free Coupon (Gift) -- Item ID: 436207661 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207661 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Free Coupon (Gift)' , ICON = N'item1_45' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207661 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207661, N'Free Coupon (Gift)', N'item1_45', 10000000, 0, 6, 0 ) END -- Item Name: Free Coupon (GM) -- Item ID: 436207662 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207662 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Free Coupon (GM)' , ICON = N'item1_46' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207662 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207662, N'Free Coupon (GM)', N'item1_46', 10000000, 0, 6, 0 ) END -- Item Name: PangMastery(PH) -- Item ID: 436207663 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207663 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangMastery(PH)' , ICON = N'item1_02' , PRICE = 1000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207663 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207663, N'PangMastery(PH)', N'item1_02', 1000, 1, 6, 0 ) END -- Item Name: Raspadinha -- Item ID: 436207664 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207664 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Raspadinha' , ICON = N'item1_48' , PRICE = 5000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207664 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207664, N'Raspadinha', N'item1_48', 5000, 1, 6, 0 ) END -- Item Name: ??????? -- Item ID: 436207665 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207665 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????' , ICON = N'item1_49' , PRICE = 0 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207665 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207665, N'???????', N'item1_49', 0, 0, 6, 0 ) END -- Item Name: PangMastery Coupon(PH) -- Item ID: 436207666 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207666 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangMastery Coupon(PH)' , ICON = N'item1_02' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207666 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207666, N'PangMastery Coupon(PH)', N'item1_02', 10000000, 1, 6, 0 ) END -- Item Name: Scratch Card (Event) -- Item ID: 436207667 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207667 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Scratch Card (Event)' , ICON = N'item1_51' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207667 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207667, N'Scratch Card (Event)', N'item1_51', 10000000, 0, 6, 0 ) END -- Item Name: Scratch Card (GM) -- Item ID: 436207668 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207668 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Scratch Card (GM)' , ICON = N'item1_52' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207668 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207668, N'Scratch Card (GM)', N'item1_52', 10000000, 0, 6, 0 ) END -- Item Name: Chestnut -- Item ID: 436207669 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207669 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Chestnut' , ICON = N'item1_53' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207669 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207669, N'Chestnut', N'item1_53', 10000000, 0, 6, 0 ) END -- Item Name: Culture Gift Coupon -- Item ID: 436207670 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207670 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Culture Gift Coupon' , ICON = N'item1_54' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207670 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207670, N'Culture Gift Coupon', N'item1_54', 10000000, 0, 6, 0 ) END -- Item Name: ????(Cn) -- Item ID: 436207671 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207671 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????(Cn)' , ICON = N'item1_55' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207671 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207671, N'????(Cn)', N'item1_55', 10000000, 1, 6, 0 ) END -- Item Name: Santa Bag (PH) -- Item ID: 436207672 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207672 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Santa Bag (PH)' , ICON = N'item1_56' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207672 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207672, N'Santa Bag (PH)', N'item1_56', 10000000, 1, 6, 0 ) END -- Item Name: ???? 2007(JP) -- Item ID: 436207673 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207673 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? 2007(JP)' , ICON = N'item1_57_jp' , PRICE = 50 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207673 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207673, N'???? 2007(JP)', N'item1_57_jp', 50, 1, 6, 0 ) END -- Item Name: 50% Discount -- Item ID: 436207674 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207674 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'50% Discount' , ICON = N'item1_58' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207674 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207674, N'50% Discount', N'item1_58', 10000000, 0, 6, 0 ) END -- Item Name: ????? -- Item ID: 436207675 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207675 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????' , ICON = N'item1_59' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207675 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207675, N'?????', N'item1_59', 10000000, 0, 6, 0 ) END -- Item Name: Cupom de Desconto -- Item ID: 436207676 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207676 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cupom de Desconto' , ICON = N'item1_60' , PRICE = 17900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207676 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207676, N'Cupom de Desconto', N'item1_60', 17900, 1, 6, 0 ) END -- Item Name: Scratch Card Slip -- Item ID: 436207677 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207677 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Scratch Card Slip' , ICON = N'item1_61' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207677 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207677, N'Scratch Card Slip', N'item1_61', 10000000, 0, 6, 0 ) END -- Item Name: 3???????? -- Item ID: 436207678 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207678 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'3????????' , ICON = N'item1_62' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207678 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207678, N'3????????', N'item1_62', 10000000, 0, 6, 0 ) END -- Item Name: ????? -- Item ID: 436207679 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207679 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????' , ICON = N'item1_63' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207679 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207679, N'?????', N'item1_63', 10000000, 0, 6, 0 ) END -- Item Name: Calibrador -- Item ID: 436207680 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207680 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Calibrador' , ICON = N'item1_64' , PRICE = 900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207680 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207680, N'Calibrador', N'item1_64', 900, 1, 6, 0 ) END -- Item Name: Relatório de desistencia -- Item ID: 436207681 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207681 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Relatório de desistencia' , ICON = N'item1_65' , PRICE = 300 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207681 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207681, N'Relatório de desistencia', N'item1_65', 300, 0, 6, 0 ) END -- Item Name: Relatório de desistencia 2 -- Item ID: 436207682 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207682 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Relatório de desistencia 2' , ICON = N'item1_65' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207682 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207682, N'Relatório de desistencia 2', N'item1_65', 10000000, 0, 6, 0 ) END -- Item Name: ??? ???? ??(old) -- Item ID: 436207683 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207683 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ???? ??(old)' , ICON = N'item1_00' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207683 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207683, N'??? ???? ??(old)', N'item1_00', 10000000, 0, 6, 0 ) END -- Item Name: Blue Crystal -- Item ID: 436207684 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207684 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Crystal' , ICON = N'item1_68' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207684 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207684, N'Blue Crystal', N'item1_68', 10000000, 0, 6, 0 ) END -- Item Name: Pink Crystal -- Item ID: 436207685 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207685 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Crystal' , ICON = N'item1_69' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207685 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207685, N'Pink Crystal', N'item1_69', 10000000, 0, 6, 0 ) END -- Item Name: White Crystal -- Item ID: 436207686 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207686 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Crystal' , ICON = N'item1_70' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207686 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207686, N'White Crystal', N'item1_70', 10000000, 0, 6, 0 ) END -- Item Name: Yellow Crystal -- Item ID: 436207687 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207687 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Crystal' , ICON = N'item1_71' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207687 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207687, N'Yellow Crystal', N'item1_71', 10000000, 0, 6, 0 ) END -- Item Name: ??????? -- Item ID: 436207688 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207688 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????' , ICON = N'item1_72' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207688 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207688, N'???????', N'item1_72', 10000000, 0, 6, 0 ) END -- Item Name: ¡ÅèͧÊéÁ -- Item ID: 436207689 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207689 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¡ÅèͧÊéÁ' , ICON = N'item1_73' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207689 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207689, N'¡ÅèͧÊéÁ', N'item1_73', 10000000, 0, 6, 0 ) END -- Item Name: ¡ÅèͧʵÍàºÍÃìÃÕè -- Item ID: 436207690 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207690 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¡ÅèͧʵÍàºÍÃìÃÕè' , ICON = N'item1_74' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207690 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207690, N'¡ÅèͧʵÍàºÍÃìÃÕè', N'item1_74', 10000000, 0, 6, 0 ) END -- Item Name: ¡Åèͧ¡ÕÇÕ -- Item ID: 436207691 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207691 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¡Åèͧ¡ÕÇÕ' , ICON = N'item1_75' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207691 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207691, N'¡Åèͧ¡ÕÇÕ', N'item1_75', 10000000, 0, 6, 0 ) END -- Item Name: ¡ÅèͧͧØè¹ -- Item ID: 436207692 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207692 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¡ÅèͧͧØè¹' , ICON = N'item1_76' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207692 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207692, N'¡ÅèͧͧØè¹', N'item1_76', 10000000, 0, 6, 0 ) END -- Item Name: 3????????? -- Item ID: 436207693 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207693 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'3?????????' , ICON = N'item1_77_jp' , PRICE = 10 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207693 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207693, N'3?????????', N'item1_77_jp', 10, 1, 6, 0 ) END -- Item Name: ??? -- Item ID: 436207694 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207694 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???' , ICON = N'item1_78' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207694 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207694, N'???', N'item1_78', 10000000, 0, 6, 0 ) END -- Item Name: Fita de Replay -- Item ID: 436207695 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207695 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fita de Replay' , ICON = N'item1_00' , PRICE = 2000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207695 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207695, N'Fita de Replay', N'item1_00', 2000, 1, 6, 0 ) END -- Item Name: Fita p/ Gravar -- Item ID: 436207696 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207696 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fita p/ Gravar' , ICON = N'item1_00' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207696 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207696, N'Fita p/ Gravar', N'item1_00', 10000000, 0, 6, 0 ) END -- Item Name: ????? ??????? -- Item ID: 436207697 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207697 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? ???????' , ICON = N'item1_81' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207697 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207697, N'????? ???????', N'item1_81', 10000000, 0, 6, 0 ) END -- Item Name: ????? ???? -- Item ID: 436207698 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207698 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? ????' , ICON = N'item1_82' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207698 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207698, N'????? ????', N'item1_82', 10000000, 0, 6, 0 ) END -- Item Name: ??????????? -- Item ID: 436207699 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207699 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????????' , ICON = N'item1_83' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207699 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207699, N'???????????', N'item1_83', 10000000, 0, 6, 0 ) END -- Item Name: ???? -- Item ID: 436207700 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207700 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????' , ICON = N'item1_84' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207700 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207700, N'????', N'item1_84', 10000000, 0, 6, 0 ) END -- Item Name: Box of Spring -- Item ID: 436207707 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207707 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Box of Spring' , ICON = N'item1_91' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207707 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207707, N'Box of Spring', N'item1_91', 10000000, 0, 6, 0 ) END -- Item Name: Box of Summer -- Item ID: 436207708 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207708 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Box of Summer' , ICON = N'item1_92' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207708 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207708, N'Box of Summer', N'item1_92', 10000000, 0, 6, 0 ) END -- Item Name: Box of Autumn -- Item ID: 436207709 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207709 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Box of Autumn' , ICON = N'item1_93' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207709 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207709, N'Box of Autumn', N'item1_93', 10000000, 0, 6, 0 ) END -- Item Name: Box of Winter -- Item ID: 436207710 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207710 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Box of Winter' , ICON = N'item1_94' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207710 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207710, N'Box of Winter', N'item1_94', 10000000, 0, 6, 0 ) END -- Item Name: Miracle Stone -- Item ID: 436207712 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207712 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Miracle Stone' , ICON = N'item1_96' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207712 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207712, N'Miracle Stone', N'item1_96', 10000000, 0, 6, 0 ) END -- Item Name: ????? ??? -- Item ID: 436207715 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207715 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? ???' , ICON = N'item1_99' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207715 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207715, N'????? ???', N'item1_99', 10000000, 0, 6, 0 ) END -- Item Name: ??? ???? ??? -- Item ID: 436207716 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207716 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ???? ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207716 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207716, N'??? ???? ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ???? ??? -- Item ID: 436207717 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207717 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ???? ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207717 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207717, N'??? ???? ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(??) ??? -- Item ID: 436207718 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207718 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207718 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207718, N'???? ?(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(??) ??? -- Item ID: 436207719 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207719 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207719 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207719, N'???? ?(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(??) ??? -- Item ID: 436207720 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207720 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207720 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207720, N'???? ?(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(????) ??? -- Item ID: 436207721 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207721 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(????) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207721 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207721, N'???? ?(????) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(??) ??? -- Item ID: 436207722 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207722 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207722 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207722, N'???? ?(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(?) ??? -- Item ID: 436207723 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207723 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(?) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207723 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207723, N'???? ?(?) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(??) ??? -- Item ID: 436207724 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207724 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207724 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207724, N'???? ?(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ???? ?(??) ??? -- Item ID: 436207725 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207725 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ?(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207725 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207725, N'???? ?(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(??) ??? -- Item ID: 436207726 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207726 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207726 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207726, N'??? ??(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(??) ??? -- Item ID: 436207727 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207727 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207727 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207727, N'??? ??(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(??) ??? -- Item ID: 436207728 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207728 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207728 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207728, N'??? ??(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(????) ??? -- Item ID: 436207729 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207729 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(????) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207729 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207729, N'??? ??(????) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(??) ??? -- Item ID: 436207730 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207730 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207730 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207730, N'??? ??(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(?) ??? -- Item ID: 436207731 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207731 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(?) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207731 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207731, N'??? ??(?) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(??) ??? -- Item ID: 436207732 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207732 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207732 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207732, N'??? ??(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: ??? ??(??) ??? -- Item ID: 436207733 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207733 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??(??) ???' , ICON = N'item1_100' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207733 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207733, N'??? ??(??) ???', N'item1_100', 10000000, 0, 6, 0 ) END -- Item Name: Pang Mastery -- Item ID: 436207744 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207744 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Mastery' , ICON = N'item1_02' , PRICE = 13800 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207744 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207744, N'Pang Mastery', N'item1_02', 13800, 0, 6, 0 ) END -- Item Name: Pang Mastery -- Item ID: 436207745 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207745 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Mastery' , ICON = N'item1_02' , PRICE = 41400 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207745 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207745, N'Pang Mastery', N'item1_02', 41400, 0, 6, 0 ) END -- Item Name: ??????? -- Item ID: 436207746 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207746 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????' , ICON = N'item1_130' , PRICE = 200 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207746 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207746, N'???????', N'item1_130', 200, 1, 6, 0 ) END -- Item Name: ??????? -- Item ID: 436207747 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207747 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????' , ICON = N'item1_131' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207747 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207747, N'???????', N'item1_131', 10000000, 0, 6, 0 ) END -- Item Name: ??????(JP) -- Item ID: 436207748 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207748 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????(JP)' , ICON = N'item1_132' , PRICE = 24 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207748 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207748, N'??????(JP)', N'item1_132', 24, 1, 6, 0 ) END -- Item Name: ?? ?? ????(JP) -- Item ID: 436207750 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207750 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ?? ????(JP)' , ICON = N'item1_134' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207750 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207750, N'?? ?? ????(JP)', N'item1_134', 10000000, 0, 6, 0 ) END -- Item Name: ????? 1?(TW) -- Item ID: 436207751 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207751 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? 1?(TW)' , ICON = N'item1_128' , PRICE = 25 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207751 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207751, N'????? 1?(TW)', N'item1_128', 25, 1, 6, 0 ) END -- Item Name: ????? 5?(TW) -- Item ID: 436207752 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207752 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? 5?(TW)' , ICON = N'item1_129' , PRICE = 100 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207752 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207752, N'????? 5?(TW)', N'item1_129', 100, 1, 6, 0 ) END -- Item Name: ????? 11?(TW) -- Item ID: 436207753 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207753 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? 11?(TW)' , ICON = N'item1_130' , PRICE = 200 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207753 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207753, N'????? 11?(TW)', N'item1_130', 200, 1, 6, 0 ) END -- Item Name: ???????(TW) -- Item ID: 436207754 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207754 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(TW)' , ICON = N'item1_131' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207754 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207754, N'???????(TW)', N'item1_131', 10000000, 0, 6, 0 ) END -- Item Name: 5000CP Discount(Gift) -- Item ID: 436207755 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207755 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5000CP Discount(Gift)' , ICON = N'item1_139' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207755 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207755, N'5000CP Discount(Gift)', N'item1_139', 10000000, 1, 6, 0 ) END -- Item Name: 5000CP Discount(Event) -- Item ID: 436207756 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207756 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5000CP Discount(Event)' , ICON = N'item1_140' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207756 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207756, N'5000CP Discount(Event)', N'item1_140', 10000000, 1, 6, 0 ) END -- Item Name: 5000CP Discount(GM) -- Item ID: 436207757 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207757 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5000CP Discount(GM)' , ICON = N'item1_141' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207757 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207757, N'5000CP Discount(GM)', N'item1_141', 10000000, 1, 6, 0 ) END -- Item Name: 100Cookie Discount(TW) -- Item ID: 436207758 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207758 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'100Cookie Discount(TW)' , ICON = N'item1_142' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207758 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207758, N'100Cookie Discount(TW)', N'item1_142', 10000000, 1, 6, 0 ) END -- Item Name: 500Cookie Discount(TW) -- Item ID: 436207759 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207759 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'500Cookie Discount(TW)' , ICON = N'item1_143' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207759 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207759, N'500Cookie Discount(TW)', N'item1_143', 10000000, 1, 6, 0 ) END -- Item Name: Thanksgiving Event(USA) -- Item ID: 436207760 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207760 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Thanksgiving Event(USA)' , ICON = N'item1_144' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207760 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207760, N'Thanksgiving Event(USA)', N'item1_144', 10000000, 1, 6, 0 ) END -- Item Name: 10000Cookie Discount(TW) -- Item ID: 436207761 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207761 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'10000Cookie Discount(TW)' , ICON = N'item1_145' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207761 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207761, N'10000Cookie Discount(TW)', N'item1_145', 10000000, 1, 6, 0 ) END -- Item Name: 1Year Anniversary Cake(USA) -- Item ID: 436207762 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207762 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'1Year Anniversary Cake(USA)' , ICON = N'item1_146' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207762 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207762, N'1Year Anniversary Cake(USA)', N'item1_146', 10000000, 1, 6, 0 ) END -- Item Name: ????(cn) -- Item ID: 436207763 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207763 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????(cn)' , ICON = N'item1_147' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207763 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207763, N'????(cn)', N'item1_147', 10000000, 0, 6, 0 ) END -- Item Name: ??? 1?(cn) -- Item ID: 436207764 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207764 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? 1?(cn)' , ICON = N'item1_148' , PRICE = 150 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207764 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207764, N'??? 1?(cn)', N'item1_148', 150, 1, 6, 0 ) END -- Item Name: ???(cn) -- Item ID: 436207765 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207765 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???(cn)' , ICON = N'item1_149' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207765 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207765, N'???(cn)', N'item1_149', 10000000, 0, 6, 0 ) END -- Item Name: ??? 5?(cn) -- Item ID: 436207766 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207766 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? 5?(cn)' , ICON = N'item1_150' , PRICE = 700 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207766 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207766, N'??? 5?(cn)', N'item1_150', 700, 1, 6, 0 ) END -- Item Name: ??? 10?(cn) -- Item ID: 436207767 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207767 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? 10?(cn)' , ICON = N'item1_151' , PRICE = 1300 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207767 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207767, N'??? 10?(cn)', N'item1_151', 1300, 1, 6, 0 ) END -- Item Name: Moon Cake (Cn) -- Item ID: 436207768 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207768 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moon Cake (Cn)' , ICON = N'item1_19' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207768 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207768, N'Moon Cake (Cn)', N'item1_19', 10000000, 0, 6, 0 ) END -- Item Name: Love Chocolate(USA) -- Item ID: 436207769 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207769 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Chocolate(USA)' , ICON = N'item1_153' , PRICE = 98 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207769 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207769, N'Love Chocolate(USA)', N'item1_153', 98, 1, 6, 0 ) END -- Item Name: Easter Egg(USA) -- Item ID: 436207770 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207770 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Easter Egg(USA)' , ICON = N'item1_154' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207770 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207770, N'Easter Egg(USA)', N'item1_154', 10000000, 0, 6, 0 ) END -- Item Name: National Day 2007 (Sg) -- Item ID: 436207771 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207771 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'National Day 2007 (Sg)' , ICON = N'item1_155' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207771 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207771, N'National Day 2007 (Sg)', N'item1_155', 10000000, 0, 6, 0 ) END -- Item Name: Kerupuk(ID) -- Item ID: 436207772 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207772 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kerupuk(ID)' , ICON = N'item1_156' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207772 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207772, N'Kerupuk(ID)', N'item1_156', 10000000, 0, 6, 0 ) END -- Item Name: ????(Cn) -- Item ID: 436207773 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207773 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????(Cn)' , ICON = N'item1_157' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207773 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207773, N'????(Cn)', N'item1_157', 10000000, 0, 6, 0 ) END -- Item Name: ????(USA) -- Item ID: 436207774 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207774 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????(USA)' , ICON = N'item1_158' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207774 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207774, N'????(USA)', N'item1_158', 10000000, 0, 6, 0 ) END -- Item Name: 20 Astros Coupon (USA) -- Item ID: 436207775 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207775 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'20 Astros Coupon (USA)' , ICON = N'item1_21' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207775 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207775, N'20 Astros Coupon (USA)', N'item1_21', 10000000, 0, 6, 0 ) END -- Item Name: ? ?? 5?? ????(EU) -- Item ID: 436207776 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207776 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'? ?? 5?? ????(EU)' , ICON = N'item1_160' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207776 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207776, N'? ?? 5?? ????(EU)', N'item1_160', 10000000, 1, 6, 0 ) END -- Item Name: ? ?? 10?? ????(EU) -- Item ID: 436207777 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207777 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'? ?? 10?? ????(EU)' , ICON = N'item1_161' , PRICE = 10000000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207777 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207777, N'? ?? 10?? ????(EU)', N'item1_161', 10000000, 1, 6, 0 ) END -- Item Name: ¡Ãз§ -- Item ID: 436207780 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207780 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¡Ãз§' , ICON = N'item1_164' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207780 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207780, N'¡Ãз§', N'item1_164', 10000000, 0, 6, 0 ) END -- Item Name: Golden Egg -- Item ID: 436207781 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207781 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Golden Egg' , ICON = N'item1_165' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207781 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207781, N'Golden Egg', N'item1_165', 10000000, 0, 6, 0 ) END -- Item Name: Kooh Birthday Box -- Item ID: 436207785 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207785 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh Birthday Box' , ICON = N'item1_73' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207785 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207785, N'Kooh Birthday Box', N'item1_73', 10000000, 0, 6, 0 ) END -- Item Name: Hana`s Heart -- Item ID: 436207798 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207798 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana`s Heart' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207798 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207798, N'Hana`s Heart', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Cesillia`s Heart -- Item ID: 436207799 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207799 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia`s Heart' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207799 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207799, N'Cesillia`s Heart', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Kooh`s Heart -- Item ID: 436207800 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207800 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh`s Heart' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207800 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207800, N'Kooh`s Heart', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Arin`s Heart -- Item ID: 436207801 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207801 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin`s Heart' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207801 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207801, N'Arin`s Heart', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Lucia`s Heart -- Item ID: 436207802 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207802 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia`s Heart' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207802 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207802, N'Lucia`s Heart', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Heart of Nuri -- Item ID: 436207806 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207806 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart of Nuri' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207806 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207806, N'Heart of Nuri', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Heart of Arthur -- Item ID: 436207807 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207807 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart of Arthur' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207807 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207807, N'Heart of Arthur', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Heart of Max -- Item ID: 436207808 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207808 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart of Max' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207808 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207808, N'Heart of Max', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Heart of Kaz -- Item ID: 436207809 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207809 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart of Kaz' , ICON = N'item1_31' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207809 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207809, N'Heart of Kaz', N'item1_31', 10000000, 0, 6, 0 ) END -- Item Name: Removedor de Cards -- Item ID: 436207810 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207810 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Removedor de Cards' , ICON = N'item1_175' , PRICE = 17900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207810 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207810, N'Removedor de Cards', N'item1_175', 17900, 1, 6, 0 ) END -- Item Name: Removedor de Card Points -- Item ID: 436207811 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207811 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Removedor de Card Points' , ICON = N'item1_175' , PRICE = 17900 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207811 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207811, N'Removedor de Card Points', N'item1_175', 17900, 0, 6, 0 ) END -- Item Name: ??? -- Item ID: 436207819 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207819 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???' , ICON = N'item1_203' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207819 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207819, N'???', N'item1_203', 10000000, 0, 6, 0 ) END -- Item Name: ?? ?? ??? -- Item ID: 436207820 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207820 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ?? ???' , ICON = N'item1_204' , PRICE = 500 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207820 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207820, N'?? ?? ???', N'item1_204', 500, 0, 6, 0 ) END -- Item Name: Card Remover(G) -- Item ID: 436207821 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207821 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Card Remover(G)' , ICON = N'item1_205' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207821 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207821, N'Card Remover(G)', N'item1_205', 10000000, 0, 6, 0 ) END -- Item Name: Removedor de Card Evento -- Item ID: 436207822 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207822 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Removedor de Card Evento' , ICON = N'item1_206' , PRICE = 97000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207822 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207822, N'Removedor de Card Evento', N'item1_206', 97000, 0, 6, 0 ) END -- Item Name: Card Remover(P) -- Item ID: 436207823 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207823 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Card Remover(P)' , ICON = N'item1_207' , PRICE = 52900 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207823 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207823, N'Card Remover(P)', N'item1_207', 52900, 0, 6, 0 ) END -- Item Name: Star Boost Candy -- Item ID: 436207870 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207870 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Star Boost Candy' , ICON = N'item1_14' , PRICE = 12900 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207870 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207870, N'Star Boost Candy', N'item1_14', 12900, 0, 6, 0 ) END -- Item Name: Golden Egg2 -- Item ID: 436207871 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207871 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Golden Egg2' , ICON = N'item1_165' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207871 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207871, N'Golden Egg2', N'item1_165', 10000000, 0, 6, 0 ) END -- Item Name: Aztec pack -- Item ID: 436207877 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207877 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Aztec pack' , ICON = N'item1_244' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207877 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207877, N'Aztec pack', N'item1_244', 10000000, 0, 6, 0 ) END -- Item Name: Card Remover(SR) -- Item ID: 436207889 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207889 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Card Remover(SR)' , ICON = N'item1_175' , PRICE = 17900 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207889 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207889, N'Card Remover(SR)', N'item1_175', 17900, 0, 6, 0 ) END -- Item Name: 5th Anniversary Random Box -- Item ID: 436207907 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207907 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5th Anniversary Random Box' , ICON = N'item_set_07' , PRICE = 9900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207907 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207907, N'5th Anniversary Random Box', N'item_set_07', 9900, 1, 6, 0 ) END -- Item Name: World Cup Ticket -- Item ID: 436207915 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207915 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'World Cup Ticket' , ICON = N'item1_262' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207915 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207915, N'World Cup Ticket', N'item1_262', 10000000, 0, 6, 0 ) END -- Item Name: Lucia Present -- Item ID: 436207917 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207917 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia Present' , ICON = N'item1_218' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207917 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207917, N'Lucia Present', N'item1_218', 10000000, 0, 6, 0 ) END -- Item Name: Season of Cronos -- Item ID: 436207923 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207923 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Season of Cronos' , ICON = N'item1_196' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207923 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207923, N'Season of Cronos', N'item1_196', 10000000, 0, 6, 0 ) END -- Item Name: Halloween Box 2010 -- Item ID: 436207928 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207928 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Halloween Box 2010' , ICON = N'item1_181' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207928 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207928, N'Halloween Box 2010', N'item1_181', 10000000, 0, 6, 0 ) END -- Item Name: Santa Boo Socks -- Item ID: 436207931 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207931 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Santa Boo Socks' , ICON = N'item1_272' , PRICE = 100000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207931 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207931, N'Santa Boo Socks', N'item1_272', 100000000, 0, 6, 0 ) END -- Item Name: ¢Í§¢ÇÑ­¨Ò¡«Ò¹µéÒºÙ(M) -- Item ID: 436207932 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207932 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¢Í§¢ÇÑ­¨Ò¡«Ò¹µéÒºÙ(M)' , ICON = N'item1_273' , PRICE = 100000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207932 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207932, N'¢Í§¢ÇÑ­¨Ò¡«Ò¹µéÒºÙ(M)', N'item1_273', 100000000, 0, 6, 0 ) END -- Item Name: ¢Í§¢ÇÑ­¨Ò¡«Ò¹µéÒºÙ(L) -- Item ID: 436207933 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207933 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'¢Í§¢ÇÑ­¨Ò¡«Ò¹µéÒºÙ(L)' , ICON = N'item1_274' , PRICE = 100000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207933 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207933, N'¢Í§¢ÇÑ­¨Ò¡«Ò¹µéÒºÙ(L)', N'item1_274', 100000000, 0, 6, 0 ) END -- Item Name: Moeda de Prata -- Item ID: 436207955 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207955 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moeda de Prata' , ICON = N'item1_240' , PRICE = 95000 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207955 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207955, N'Moeda de Prata', N'item1_240', 95000, 1, 6, 0 ) END -- Item Name: Moeda de Bronze -- Item ID: 436207956 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207956 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moeda de Bronze' , ICON = N'item1_241' , PRICE = 12900 , ISCASH = 1 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207956 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207956, N'Moeda de Bronze', N'item1_241', 12900, 1, 6, 0 ) END -- Item Name: Moeda Ouro Vip -- Item ID: 436207957 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207957 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moeda Ouro Vip' , ICON = N'item1_170' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207957 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207957, N'Moeda Ouro Vip', N'item1_170', 10000000, 0, 6, 0 ) END -- Item Name: Moeda Bronze Vip -- Item ID: 436207958 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 436207958 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moeda Bronze Vip' , ICON = N'item1_172' , PRICE = 10000000 , ISCASH = 0 , TYPE = 6 , IS_SALABLE = 0 WHERE TYPEID = 436207958 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 436207958, N'Moeda Bronze Vip', N'item1_172', 10000000, 0, 6, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia