-- ----------------------------------------------- -- -- 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 "Setitem.iff" -- -- Last update of the IFF: 2022-02-16 01:28:50 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Setitem.iff contains 331 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: ªØ´ÇèÒ¹éÓ (¹ÙÃÔ ¤ÃºªØ´) -- Item ID: 606076928 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076928 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ (¹ÙÃÔ ¤ÃºªØ´)' , ICON = N'm_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076928 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076928, N'ªØ´ÇèÒ¹éÓ (¹ÙÃÔ ¤ÃºªØ´)', N'm_set_01', 49900, 1, 9, 0 ) END -- Item Name: Swimsuit Set(Nuri) (JP) -- Item ID: 606076929 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076929 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set(Nuri) (JP)' , ICON = N'm_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076929 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076929, N'Swimsuit Set(Nuri) (JP)', N'm_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Puppy Set (¹ÙÃÔ ¤ÃºªØ´) -- Item ID: 606076930 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076930 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set (¹ÙÃÔ ¤ÃºªØ´)' , ICON = N'm_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076930 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076930, N'Puppy Set (¹ÙÃÔ ¤ÃºªØ´)', N'm_set_01', 36, 1, 9, 0 ) END -- Item Name: Nuri Hanbok (¹ÙÃÔ ¤ÃºªØ´) -- Item ID: 606076931 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076931 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri Hanbok (¹ÙÃÔ ¤ÃºªØ´)' , ICON = N'm_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076931 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076931, N'Nuri Hanbok (¹ÙÃÔ ¤ÃºªØ´)', N'm_set_01', 49900, 1, 9, 0 ) END -- Item Name: Student Set (¹ÙÃÔ ¤ÃºªØ´) -- Item ID: 606076932 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076932 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Student Set (¹ÙÃÔ ¤ÃºªØ´)' , ICON = N'm_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076932 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076932, N'Student Set (¹ÙÃÔ ¤ÃºªØ´)', N'm_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Tony J.Set -- Item ID: 606076933 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076933 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tony J.Set' , ICON = N'm_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076933 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076933, N'Tony J.Set', N'm_set_01', 59900, 1, 9, 0 ) END -- Item Name: Swimsuit Set2 (Nuri)(TW) -- Item ID: 606076934 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076934 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set2 (Nuri)(TW)' , ICON = N'm_set_01' , PRICE = 9400 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076934 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076934, N'Swimsuit Set2 (Nuri)(TW)', N'm_set_01', 9400, 1, 9, 0 ) END -- Item Name: Dolphin Set -- Item ID: 606076935 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076935 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphin Set' , ICON = N'm_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076935 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076935, N'Dolphin Set', N'm_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Ribbon Set -- Item ID: 606076936 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076936 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Ribbon Set' , ICON = N'm_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076936 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076936, N'Black Ribbon Set', N'm_set_01', 39900, 1, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Nuri)(JP) -- Item ID: 606076937 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076937 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Nuri)(JP)' , ICON = N'm_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076937 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076937, N'Tecmo Swimsuit (Nuri)(JP)', N'm_set_02', 16960, 0, 9, 0 ) END -- Item Name: R.Patan Set (¹ÙÃÔ ¤ÃºªØ´) -- Item ID: 606076938 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076938 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'R.Patan Set (¹ÙÃÔ ¤ÃºªØ´)' , ICON = N'm_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076938 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076938, N'R.Patan Set (¹ÙÃÔ ¤ÃºªØ´)', N'm_set_01', 49900, 1, 9, 0 ) END -- Item Name: Tony J. Set (Nuri) -- Item ID: 606076947 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076947 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tony J. Set (Nuri)' , ICON = N'm_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076947 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076947, N'Tony J. Set (Nuri)', N'm_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Nuri) -- Item ID: 606076955 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076955 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Nuri)' , ICON = N'm_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076955 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076955, N'Funky Waiter Set(Nuri)', N'm_set_01', 59900, 1, 9, 0 ) END -- Item Name: Belts Dl Set (N) -- Item ID: 606076957 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076957 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Belts Dl Set (N)' , ICON = N'm_set_02' , PRICE = 120000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076957 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076957, N'Belts Dl Set (N)', N'm_set_02', 120000, 1, 9, 0 ) END -- Item Name: Vocal Loid Set (N) -- Item ID: 606076956 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606076956 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (N)' , ICON = N'm_set_02' , PRICE = 150000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606076956 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606076956, N'Vocal Loid Set (N)', N'm_set_02', 150000, 0, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ (ÎҹР¤ÃºªØ´) -- Item ID: 606085120 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085120 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085120 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085120, N'ªØ´ÇèÒ¹éÓ (ÎҹР¤ÃºªØ´)', N'f_set_01', 49900, 1, 9, 0 ) END -- Item Name: Swimsuit Set(Hana) (JP) -- Item ID: 606085121 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085121 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set(Hana) (JP)' , ICON = N'f_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085121 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085121, N'Swimsuit Set(Hana) (JP)', N'f_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Puppy Set (ÎҹР¤ÃºªØ´) -- Item ID: 606085122 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085122 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085122 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085122, N'Puppy Set (ÎҹР¤ÃºªØ´)', N'f_set_01', 36, 1, 9, 0 ) END -- Item Name: Hana Hanbok (ÎҹР¤ÃºªØ´) -- Item ID: 606085123 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085123 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana Hanbok (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085123 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085123, N'Hana Hanbok (ÎҹР¤ÃºªØ´)', N'f_set_01', 44900, 1, 9, 0 ) END -- Item Name: Popular Set (ÎҹР¤ÃºªØ´) -- Item ID: 606085124 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085124 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Popular Set (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085124 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085124, N'Popular Set (ÎҹР¤ÃºªØ´)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Summer Uniform Set -- Item ID: 606085125 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085125 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Summer Uniform Set' , ICON = N'f_set_01' , PRICE = 20900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085125 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085125, N'Summer Uniform Set', N'f_set_01', 20900, 1, 9, 0 ) END -- Item Name: Bongdari Set -- Item ID: 606085126 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085126 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bongdari Set' , ICON = N'f_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085126 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085126, N'Bongdari Set', N'f_set_01', 44900, 1, 9, 0 ) END -- Item Name: Cosmoblue Set -- Item ID: 606085127 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085127 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cosmoblue Set' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085127 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085127, N'Cosmoblue Set', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Shine Hanbok Set -- Item ID: 606085128 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085128 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Shine Hanbok Set' , ICON = N'f_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085128 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085128, N'Pink Shine Hanbok Set', N'f_set_01', 44900, 1, 9, 0 ) END -- Item Name: Sheep Set (ÎҹР¤ÃºªØ´)(TW) -- Item ID: 606085130 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085130 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sheep Set (ÎҹР¤ÃºªØ´)(TW)' , ICON = N'f_set_01' , PRICE = 1000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085130 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085130, N'Sheep Set (ÎҹР¤ÃºªØ´)(TW)', N'f_set_01', 1000000, 1, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Hana)(JP) -- Item ID: 606085131 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085131 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Hana)(JP)' , ICON = N'f_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085131 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085131, N'Tecmo Swimsuit (Hana)(JP)', N'f_set_02', 16960, 0, 9, 0 ) END -- Item Name: Vocal Loid Set (H) -- Item ID: 606085132 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085132 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (H)' , ICON = N'f_set_02' , PRICE = 150000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085132 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085132, N'Vocal Loid Set (H)', N'f_set_02', 150000, 0, 9, 0 ) END -- Item Name: Perking Set (H) -- Item ID: 606085133 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085133 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Perking Set (H)' , ICON = N'f_set_02' , PRICE = 120000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085133 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085133, N'Perking Set (H)', N'f_set_02', 120000, 1, 9, 0 ) END -- Item Name: Silk Set (ÎҹР¤ÃºªØ´) -- Item ID: 606085134 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085134 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Silk Set (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085134 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085134, N'Silk Set (ÎҹР¤ÃºªØ´)', N'f_set_01', 49900, 1, 9, 0 ) END -- Item Name: ??????????(????)(TW) -- Item ID: 606085136 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085136 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(????)(TW)' , ICON = N'f_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085136 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085136, N'??????????(????)(TW)', N'f_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ???????????(????)(TW) -- Item ID: 606085137 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085137 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????????(????)(TW)' , ICON = N'f_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085137 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085137, N'???????????(????)(TW)', N'f_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ??????(????)(Cn) -- Item ID: 606085138 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085138 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????(????)(Cn)' , ICON = N'f_set_01' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085138 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085138, N'??????(????)(Cn)', N'f_set_01', 10000000, 1, 9, 0 ) END -- Item Name: ???????(????)(Cn) -- Item ID: 606085140 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606085140 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(????)(Cn)' , ICON = N'f_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606085140 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606085140, N'???????(????)(Cn)', N'f_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Police Set -- Item ID: 606093312 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093312 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Police Set' , ICON = N'a_set_01' , PRICE = 29900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093312 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093312, N'Police Set', N'a_set_01', 29900, 1, 9, 0 ) END -- Item Name: Formal Set -- Item ID: 606093313 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093313 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Formal Set' , ICON = N'a_set_01' , PRICE = 29900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093313 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093313, N'Formal Set', N'a_set_01', 29900, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ -- Item ID: 606093314 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093314 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ' , ICON = N'a_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093314 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093314, N'ªØ´ÇèÒ¹éÓ', N'a_set_01', 49900, 1, 9, 0 ) END -- Item Name: Swimsuit Set(Azer) (JP) -- Item ID: 606093315 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093315 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set(Azer) (JP)' , ICON = N'a_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093315 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093315, N'Swimsuit Set(Azer) (JP)', N'a_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Puppy Set -- Item ID: 606093316 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093316 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set' , ICON = N'a_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093316 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093316, N'Puppy Set', N'a_set_01', 36, 1, 9, 0 ) END -- Item Name: Arthur Hanbok -- Item ID: 606093317 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093317 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur Hanbok' , ICON = N'a_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093317 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093317, N'Arthur Hanbok', N'a_set_01', 44900, 1, 9, 0 ) END -- Item Name: Businees Set (ÍÒà¸ÍÃì ¤ÃºªØ´)(JP) -- Item ID: 606093318 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093318 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Businees Set (ÍÒà¸ÍÃì ¤ÃºªØ´)(JP)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093318 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093318, N'Businees Set (ÍÒà¸ÍÃì ¤ÃºªØ´)(JP)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Sor.Arthur Set (ÍÒà¸ÍÃì ¤ÃºªØ´) -- Item ID: 606093319 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093319 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sor.Arthur Set (ÍÒà¸ÍÃì ¤ÃºªØ´)' , ICON = N'a_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093319 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093319, N'Sor.Arthur Set (ÍÒà¸ÍÃì ¤ÃºªØ´)', N'a_set_01', 49900, 1, 9, 0 ) END -- Item Name: Diver Set -- Item ID: 606093320 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093320 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Diver Set' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093320 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093320, N'Diver Set', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Gold Line Set -- Item ID: 606093321 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093321 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gold Line Set' , ICON = N'a_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093321 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093321, N'Gold Line Set', N'a_set_01', 39900, 1, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Arthur)(JP) -- Item ID: 606093322 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093322 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Arthur)(JP)' , ICON = N'a_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093322 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093322, N'Tecmo Swimsuit (Arthur)(JP)', N'a_set_02', 16960, 0, 9, 0 ) END -- Item Name: ????????(Cn) -- Item ID: 606093323 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093323 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(Cn)' , ICON = N'e_set_02' , PRICE = 450 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093323 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093323, N'????????(Cn)', N'e_set_02', 450, 1, 9, 0 ) END -- Item Name: Funky Waiter Set(Arthur) -- Item ID: 606093336 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606093336 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Arthur)' , ICON = N'a_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606093336 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606093336, N'Funky Waiter Set(Arthur)', N'a_set_01', 59900, 1, 9, 0 ) END -- Item Name: Mate Set -- Item ID: 606101504 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101504 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mate Set' , ICON = N'c_set_01' , PRICE = 29900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101504 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101504, N'Mate Set', N'c_set_01', 29900, 1, 9, 0 ) END -- Item Name: Sonia Set -- Item ID: 606101505 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101505 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sonia Set' , ICON = N'c_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101505 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101505, N'Sonia Set', N'c_set_01', 39900, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ Set1 -- Item ID: 606101506 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101506 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ Set1' , ICON = N'c_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101506 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101506, N'ªØ´ÇèÒ¹éÓ Set1', N'c_set_01', 59900, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ Set2 -- Item ID: 606101507 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101507 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ Set2' , ICON = N'c_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101507 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101507, N'ªØ´ÇèÒ¹éÓ Set2', N'c_set_01', 59900, 1, 9, 0 ) END -- Item Name: Swimsuit Set(Cesi) (JP) -- Item ID: 606101508 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101508 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set(Cesi) (JP)' , ICON = N'c_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101508 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101508, N'Swimsuit Set(Cesi) (JP)', N'c_set_01', 10000000, 0, 9, 0 ) END -- Item Name: CowBoy Set -- Item ID: 606101509 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101509 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'CowBoy Set' , ICON = N'c_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101509 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101509, N'CowBoy Set', N'c_set_01', 39900, 1, 9, 0 ) END -- Item Name: Puppy Set -- Item ID: 606101510 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101510 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set' , ICON = N'c_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101510 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101510, N'Puppy Set', N'c_set_01', 36, 1, 9, 0 ) END -- Item Name: Cesillia Hanbok -- Item ID: 606101511 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101511 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia Hanbok' , ICON = N'c_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101511 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101511, N'Cesillia Hanbok', N'c_set_01', 49900, 1, 9, 0 ) END -- Item Name: Geisha Set (Cesillia)(JP) -- Item ID: 606101512 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101512 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Geisha Set (Cesillia)(JP)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101512 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101512, N'Geisha Set (Cesillia)(JP)', N'c_set_02', 10000000, 1, 9, 0 ) END -- Item Name: Elegance Set -- Item ID: 606101513 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101513 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Elegance Set' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101513 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101513, N'Elegance Set', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Orange Blue Hanbok Set -- Item ID: 606101514 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101514 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Orange Blue Hanbok Set' , ICON = N'c_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101514 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101514, N'Orange Blue Hanbok Set', N'c_set_01', 49900, 1, 9, 0 ) END -- Item Name: ?????????(????)(TW) -- Item ID: 606101516 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101516 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????????(????)(TW)' , ICON = N'c_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101516 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101516, N'?????????(????)(TW)', N'c_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Cesillia)(JP) -- Item ID: 606101517 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101517 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Cesillia)(JP)' , ICON = N'c_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101517 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101517, N'Tecmo Swimsuit (Cesillia)(JP)', N'c_set_02', 16960, 0, 9, 0 ) END -- Item Name: Vocal Loid Set (C) -- Item ID: 606101518 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101518 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (C)' , ICON = N'c_set_02' , PRICE = 140000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101518 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101518, N'Vocal Loid Set (C)', N'c_set_02', 140000, 0, 9, 0 ) END -- Item Name: ????????(Cn) -- Item ID: 606101520 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101520 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(Cn)' , ICON = N'e_set_02' , PRICE = 450 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101520 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101520, N'????????(Cn)', N'e_set_02', 450, 1, 9, 0 ) END -- Item Name: ???????????(??????)(TW) -- Item ID: 606101521 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101521 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????????(??????)(TW)' , ICON = N'c_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101521 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101521, N'???????????(??????)(TW)', N'c_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ??????????TW(??????)(TW) -- Item ID: 606101522 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101522 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????TW(??????)(TW)' , ICON = N'c_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101522 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101522, N'??????????TW(??????)(TW)', N'c_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ???????(??????)(Cn) -- Item ID: 606101525 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606101525 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??????)(Cn)' , ICON = N'c_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606101525 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606101525, N'???????(??????)(Cn)', N'c_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Tennis Set -- Item ID: 606109696 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109696 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tennis Set' , ICON = N'd_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109696 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109696, N'Tennis Set', N'd_set_01', 49900, 1, 9, 0 ) END -- Item Name: Red Bike Set -- Item ID: 606109697 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109697 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Bike Set' , ICON = N'd_set_01' , PRICE = 48000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109697 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109697, N'Red Bike Set', N'd_set_01', 48000, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ (áÁ¡«ì ¤ÃºªØ´) -- Item ID: 606109698 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109698 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ (áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109698 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109698, N'ªØ´ÇèÒ¹éÓ (áÁ¡«ì ¤ÃºªØ´)', N'd_set_01', 59900, 1, 9, 0 ) END -- Item Name: Swimsuit Set(Max) (JP) -- Item ID: 606109699 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109699 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set(Max) (JP)' , ICON = N'd_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109699 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109699, N'Swimsuit Set(Max) (JP)', N'd_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Puppy Set (áÁ¡«ì ¤ÃºªØ´) -- Item ID: 606109700 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109700 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set (áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109700 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109700, N'Puppy Set (áÁ¡«ì ¤ÃºªØ´)', N'd_set_01', 36, 1, 9, 0 ) END -- Item Name: Max Hanbok (áÁ¡«ì ¤ÃºªØ´) -- Item ID: 606109701 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109701 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Max Hanbok (áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109701 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109701, N'Max Hanbok (áÁ¡«ì ¤ÃºªØ´)', N'd_set_01', 44900, 1, 9, 0 ) END -- Item Name: Black Zipper -- Item ID: 606109702 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109702 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Zipper' , ICON = N'd_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109702 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109702, N'Black Zipper', N'd_set_01', 49900, 1, 9, 0 ) END -- Item Name: ?? ??(??)(JP) -- Item ID: 606109703 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109703 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ??(??)(JP)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109703 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109703, N'?? ??(??)(JP)', N'd_set_02', 10000000, 1, 9, 0 ) END -- Item Name: Mariner Set -- Item ID: 606109705 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109705 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mariner Set' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109705 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109705, N'Mariner Set', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Red Wind Set (áÁ¡«ì ¤ÃºªØ´) -- Item ID: 606109706 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109706 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Wind Set (áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109706 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109706, N'Red Wind Set (áÁ¡«ì ¤ÃºªØ´)', N'd_set_01', 39900, 1, 9, 0 ) END -- Item Name: Dandeloin Wedding Set (áÁ¡«ì ¤ÃºªØ´) -- Item ID: 606109707 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109707 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dandeloin Wedding Set (áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109707 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109707, N'Dandeloin Wedding Set (áÁ¡«ì ¤ÃºªØ´)', N'd_set_01', 39900, 1, 9, 0 ) END -- Item Name: ??????????(????) -- Item ID: 606109708 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109708 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(????)' , ICON = N'd_set_01' , PRICE = 89 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109708 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109708, N'??????????(????)', N'd_set_01', 89, 1, 9, 0 ) END -- Item Name: ????????(Cn) -- Item ID: 606109709 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109709 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(Cn)' , ICON = N'e_set_02' , PRICE = 450 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109709 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109709, N'????????(Cn)', N'e_set_02', 450, 1, 9, 0 ) END -- Item Name: Skull Leather Set(áÁ¡«ì ¤ÃºªØ´) -- Item ID: 606109711 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109711 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Skull Leather Set(áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_02' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109711 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109711, N'Skull Leather Set(áÁ¡«ì ¤ÃºªØ´)', N'd_set_02', 39900, 1, 9, 0 ) END -- Item Name: Funky Waiter Set(Max) -- Item ID: 606109723 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606109723 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Max)' , ICON = N'd_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606109723 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606109723, N'Funky Waiter Set(Max)', N'd_set_01', 59900, 1, 9, 0 ) END -- Item Name: Waitress Set -- Item ID: 606117888 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117888 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Waitress Set' , ICON = N'e_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117888 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117888, N'Waitress Set', N'e_set_01', 59900, 1, 9, 0 ) END -- Item Name: Pirates Set -- Item ID: 606117889 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117889 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirates Set' , ICON = N'e_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117889 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117889, N'Pirates Set', N'e_set_01', 49900, 1, 9, 0 ) END -- Item Name: Green Stripe One-Piece (Kooh ¤ÃºªØ´) -- Item ID: 606117890 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117890 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Stripe One-Piece (Kooh ¤ÃºªØ´)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117890 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117890, N'Green Stripe One-Piece (Kooh ¤ÃºªØ´)', N'e_set_01', 10000000, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ (Kooh ¤ÃºªØ´) -- Item ID: 606117891 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117891 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ (Kooh ¤ÃºªØ´)' , ICON = N'e_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117891 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117891, N'ªØ´ÇèÒ¹éÓ (Kooh ¤ÃºªØ´)', N'e_set_01', 59900, 1, 9, 0 ) END -- Item Name: Swimsuit Set (Kooh)(JP) -- Item ID: 606117892 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117892 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set (Kooh)(JP)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117892 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117892, N'Swimsuit Set (Kooh)(JP)', N'e_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Fusion China Set (Kooh ¤ÃºªØ´) -- Item ID: 606117893 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117893 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fusion China Set (Kooh ¤ÃºªØ´)' , ICON = N'e_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117893 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117893, N'Fusion China Set (Kooh ¤ÃºªØ´)', N'e_set_01', 39900, 1, 9, 0 ) END -- Item Name: Kimono Set (Kooh) -- Item ID: 606117894 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117894 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kimono Set (Kooh)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117894 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117894, N'Kimono Set (Kooh)', N'e_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Puppy Set (Kooh ¤ÃºªØ´) -- Item ID: 606117895 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117895 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set (Kooh ¤ÃºªØ´)' , ICON = N'e_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117895 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117895, N'Puppy Set (Kooh ¤ÃºªØ´)', N'e_set_01', 36, 1, 9, 0 ) END -- Item Name: Kooh Hanbok (Kooh ¤ÃºªØ´) -- Item ID: 606117896 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117896 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh Hanbok (Kooh ¤ÃºªØ´)' , ICON = N'e_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117896 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117896, N'Kooh Hanbok (Kooh ¤ÃºªØ´)', N'e_set_01', 49900, 1, 9, 0 ) END -- Item Name: Foxy Set -- Item ID: 606117897 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117897 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Foxy Set' , ICON = N'e_set_01' , PRICE = 55900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117897 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117897, N'Foxy Set', N'e_set_01', 55900, 1, 9, 0 ) END -- Item Name: Red Chinese Set -- Item ID: 606117898 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117898 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Chinese Set' , ICON = N'e_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117898 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117898, N'Red Chinese Set', N'e_set_01', 44900, 1, 9, 0 ) END -- Item Name: Swimsuit Set2 (Kooh)(TW) -- Item ID: 606117899 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117899 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set2 (Kooh)(TW)' , ICON = N'e_set_01' , PRICE = 9400 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117899 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117899, N'Swimsuit Set2 (Kooh)(TW)', N'e_set_01', 9400, 1, 9, 0 ) END -- Item Name: Colorful Set -- Item ID: 606117900 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117900 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Colorful Set' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117900 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117900, N'Colorful Set', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Kimono Set (Kooh) -- Item ID: 606117901 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117901 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kimono Set (Kooh)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117901 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117901, N'Kimono Set (Kooh)', N'e_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Amber striped Hanbok (Kooh ¤ÃºªØ´) -- Item ID: 606117902 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117902 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Amber striped Hanbok (Kooh ¤ÃºªØ´)' , ICON = N'e_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117902 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117902, N'Amber striped Hanbok (Kooh ¤ÃºªØ´)', N'e_set_01', 49900, 1, 9, 0 ) END -- Item Name: Penguin Set (TW) -- Item ID: 606117904 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117904 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Penguin Set (TW)' , ICON = N'e_set_01' , PRICE = 1000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117904 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117904, N'Penguin Set (TW)', N'e_set_01', 1000000, 1, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Kooh)(JP) -- Item ID: 606117905 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117905 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Kooh)(JP)' , ICON = N'e_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117905 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117905, N'Tecmo Swimsuit (Kooh)(JP)', N'e_set_02', 16960, 0, 9, 0 ) END -- Item Name: Vocal Loid Set (K) -- Item ID: 606117906 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117906 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (K)' , ICON = N'e_set_02' , PRICE = 150000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117906 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117906, N'Vocal Loid Set (K)', N'e_set_02', 150000, 0, 9, 0 ) END -- Item Name: ??????????(???)(TW) -- Item ID: 606117908 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117908 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(???)(TW)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117908 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117908, N'??????????(???)(TW)', N'e_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ??????????(???)(TW) -- Item ID: 606117909 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117909 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(???)(TW)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117909 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117909, N'??????????(???)(TW)', N'e_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ??????(???)(CN) -- Item ID: 606117911 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117911 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????(???)(CN)' , ICON = N'e_set_01' , PRICE = 1000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117911 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117911, N'??????(???)(CN)', N'e_set_01', 1000000, 1, 9, 0 ) END -- Item Name: ???????(???)(Cn) -- Item ID: 606117913 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117913 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(???)(Cn)' , ICON = N'e_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117913 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117913, N'???????(???)(Cn)', N'e_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Classis Pirate Set(Kooh) -- Item ID: 606117939 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606117939 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Classis Pirate Set(Kooh)' , ICON = N'e_set_02' , PRICE = 520000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606117939 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606117939, N'Classis Pirate Set(Kooh)', N'e_set_02', 520000, 0, 9, 0 ) END -- Item Name: Training Wear(with Kooh) -- Item ID: 606118016 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606118016 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Training Wear(with Kooh)' , ICON = N'e_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606118016 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606118016, N'Training Wear(with Kooh)', N'e_set_01', 59900, 1, 9, 0 ) END -- Item Name: ????????(Cn) -- Item ID: 606118017 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606118017 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(Cn)' , ICON = N'e_set_02' , PRICE = 450 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606118017 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606118017, N'????????(Cn)', N'e_set_02', 450, 1, 9, 0 ) END -- Item Name: Devil Blue Set -- Item ID: 606126080 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126080 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Devil Blue Set' , ICON = N'g_set_01' , PRICE = 58000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126080 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126080, N'Devil Blue Set', N'g_set_01', 58000, 1, 9, 0 ) END -- Item Name: Yellow Lady Set -- Item ID: 606126081 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126081 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Lady Set' , ICON = N'g_set_01' , PRICE = 54900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126081 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126081, N'Yellow Lady Set', N'g_set_01', 54900, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ Set1 (ÍÒÃÔ¹ ¤ÃºªØ´) -- Item ID: 606126082 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126082 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ Set1 (ÍÒÃÔ¹ ¤ÃºªØ´)' , ICON = N'g_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126082 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126082, N'ªØ´ÇèÒ¹éÓ Set1 (ÍÒÃÔ¹ ¤ÃºªØ´)', N'g_set_01', 59900, 1, 9, 0 ) END -- Item Name: ªØ´ÇèÒ¹éÓ Set2 (ÍÒÃÔ¹ ¤ÃºªØ´) -- Item ID: 606126083 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126083 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'ªØ´ÇèÒ¹éÓ Set2 (ÍÒÃÔ¹ ¤ÃºªØ´)' , ICON = N'g_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126083 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126083, N'ªØ´ÇèÒ¹éÓ Set2 (ÍÒÃÔ¹ ¤ÃºªØ´)', N'g_set_01', 59900, 1, 9, 0 ) END -- Item Name: Swimsuit Set(Arin) (JP) -- Item ID: 606126084 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126084 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Swimsuit Set(Arin) (JP)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126084 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126084, N'Swimsuit Set(Arin) (JP)', N'g_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Elvin Set -- Item ID: 606126085 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126085 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Elvin Set' , ICON = N'g_set_01' , PRICE = 54900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126085 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126085, N'Elvin Set', N'g_set_01', 54900, 1, 9, 0 ) END -- Item Name: Kimono Set (Arin) -- Item ID: 606126086 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126086 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kimono Set (Arin)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126086 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126086, N'Kimono Set (Arin)', N'g_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Puppy Set -- Item ID: 606126087 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126087 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Puppy Set' , ICON = N'g_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126087 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126087, N'Puppy Set', N'g_set_01', 36, 1, 9, 0 ) END -- Item Name: Purple Wing Set -- Item ID: 606126088 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126088 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Purple Wing Set' , ICON = N'g_set_01' , PRICE = 54900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126088 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126088, N'Purple Wing Set', N'g_set_01', 54900, 1, 9, 0 ) END -- Item Name: ?? ??????? (JP) -- Item ID: 606126089 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126089 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ??????? (JP)' , ICON = N'g_set_01' , PRICE = 36 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126089 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126089, N'?? ??????? (JP)', N'g_set_01', 36, 1, 9, 0 ) END -- Item Name: Arin Hanbok -- Item ID: 606126090 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126090 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin Hanbok' , ICON = N'g_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126090 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126090, N'Arin Hanbok', N'g_set_01', 49900, 1, 9, 0 ) END -- Item Name: Spring&Autumn Set -- Item ID: 606126091 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126091 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spring&Autumn Set' , ICON = N'g_set_01' , PRICE = 57900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126091 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126091, N'Spring&Autumn Set', N'g_set_01', 57900, 1, 9, 0 ) END -- Item Name: Red Chinese Set -- Item ID: 606126092 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126092 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Chinese Set' , ICON = N'g_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126092 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126092, N'Red Chinese Set', N'g_set_01', 44900, 1, 9, 0 ) END -- Item Name: Marine Set -- Item ID: 606126093 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126093 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Marine Set' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126093 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126093, N'Marine Set', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Kimono Set (Arin) -- Item ID: 606126094 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126094 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kimono Set (Arin)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126094 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126094, N'Kimono Set (Arin)', N'g_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Red Light Hanbok -- Item ID: 606126095 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126095 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Light Hanbok' , ICON = N'g_set_01' , PRICE = 49900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126095 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126095, N'Red Light Hanbok', N'g_set_01', 49900, 1, 9, 0 ) END -- Item Name: Sheep Set (Arin)(TW) -- Item ID: 606126097 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126097 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sheep Set (Arin)(TW)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126097 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126097, N'Sheep Set (Arin)(TW)', N'g_set_01', 10000000, 1, 9, 0 ) END -- Item Name: Choco Sheep Set(Arin) -- Item ID: 606126098 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126098 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Choco Sheep Set(Arin)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126098 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126098, N'Choco Sheep Set(Arin)', N'g_set_01', 10000000, 1, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Arin)(JP) -- Item ID: 606126099 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126099 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Arin)(JP)' , ICON = N'g_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126099 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126099, N'Tecmo Swimsuit (Arin)(JP)', N'g_set_02', 16960, 0, 9, 0 ) END -- Item Name: Vocal Loid Set (A) -- Item ID: 606126100 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126100 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (A)' , ICON = N'g_set_02' , PRICE = 150000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126100 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126100, N'Vocal Loid Set (A)', N'g_set_02', 150000, 0, 9, 0 ) END -- Item Name: ????????(Cn) -- Item ID: 606126102 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126102 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(Cn)' , ICON = N'm_set_02' , PRICE = 450 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126102 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126102, N'????????(Cn)', N'm_set_02', 450, 1, 9, 0 ) END -- Item Name: ??????????(????)(TW) -- Item ID: 606126104 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126104 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(????)(TW)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126104 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126104, N'??????????(????)(TW)', N'g_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ?????????(????)(TW) -- Item ID: 606126105 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126105 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????????(????)(TW)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126105 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126105, N'?????????(????)(TW)', N'g_set_01', 10000000, 0, 9, 0 ) END -- Item Name: ??????(????)(CN) -- Item ID: 606126106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????(????)(CN)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126106, N'??????(????)(CN)', N'g_set_01', 10000000, 1, 9, 0 ) END -- Item Name: ???????(????)(Cn) -- Item ID: 606126108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606126108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(????)(Cn)' , ICON = N'g_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606126108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606126108, N'???????(????)(Cn)', N'g_set_01', 10000000, 0, 9, 0 ) END -- Item Name: White Veble Set -- Item ID: 606134272 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134272 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Veble Set' , ICON = N'h_set_01' , PRICE = 41900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134272 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134272, N'White Veble Set', N'h_set_01', 41900, 1, 9, 0 ) END -- Item Name: River Battle Set -- Item ID: 606134273 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134273 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'River Battle Set' , ICON = N'h_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134273 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134273, N'River Battle Set', N'h_set_01', 39900, 1, 9, 0 ) END -- Item Name: Red Belt Set -- Item ID: 606134274 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134274 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Belt Set' , ICON = N'h_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134274 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134274, N'Red Belt Set', N'h_set_01', 44900, 1, 9, 0 ) END -- Item Name: Black Plane Hanbok Set -- Item ID: 606134275 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134275 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Plane Hanbok Set' , ICON = N'h_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134275 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134275, N'Black Plane Hanbok Set', N'h_set_01', 44900, 1, 9, 0 ) END -- Item Name: Blue Plane Hanbok Set -- Item ID: 606134276 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134276 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Plane Hanbok Set' , ICON = N'h_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134276 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134276, N'Blue Plane Hanbok Set', N'h_set_01', 44900, 1, 9, 0 ) END -- Item Name: Black Wedding Set -- Item ID: 606134277 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134277 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wedding Set' , ICON = N'h_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134277 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134277, N'Black Wedding Set', N'h_set_01', 39900, 1, 9, 0 ) END -- Item Name: Waiter Set -- Item ID: 606134278 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134278 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Waiter Set' , ICON = N'h_set_01' , PRICE = 51900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134278 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134278, N'Waiter Set', N'h_set_01', 51900, 1, 9, 0 ) END -- Item Name: Tecmo Swimsuit (Kaz)(JP) -- Item ID: 606134279 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134279 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Swimsuit (Kaz)(JP)' , ICON = N'h_set_02' , PRICE = 16960 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134279 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134279, N'Tecmo Swimsuit (Kaz)(JP)', N'h_set_02', 16960, 0, 9, 0 ) END -- Item Name: ???????(??)(JP) -- Item ID: 606134280 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134280 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)(JP)' , ICON = N'h_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134280 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134280, N'???????(??)(JP)', N'h_set_02', 1000000, 0, 9, 0 ) END -- Item Name: ?? ?? ??? -- Item ID: 606134285 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134285 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ?? ???' , ICON = N'h_set_01' , PRICE = 76 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134285 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134285, N'?? ?? ???', N'h_set_01', 76, 1, 9, 0 ) END -- Item Name: ?? ?? ??? -- Item ID: 606134286 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134286 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ?? ???' , ICON = N'h_set_01' , PRICE = 88 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134286 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134286, N'?? ?? ???', N'h_set_01', 88, 1, 9, 0 ) END -- Item Name: Officer Set -- Item ID: 606134287 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134287 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Officer Set ' , ICON = N'h_set_02' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134287 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134287, N'Officer Set ', N'h_set_02', 44900, 1, 9, 0 ) END -- Item Name: Basic Slate Set(Kaz) -- Item ID: 606134296 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134296 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Basic Slate Set(Kaz)' , ICON = N'h_set_02' , PRICE = 520000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134296 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134296, N'Basic Slate Set(Kaz)', N'h_set_02', 520000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Kaz) -- Item ID: 606134299 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134299 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Kaz)' , ICON = N'h_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134299 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134299, N'Funky Waiter Set(Kaz)', N'h_set_01', 59900, 1, 9, 0 ) END -- Item Name: Vocal Loid Set (KZ) -- Item ID: 606134300 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606134300 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (KZ)' , ICON = N'h_set_02' , PRICE = 150000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606134300 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606134300, N'Vocal Loid Set (KZ)', N'h_set_02', 150000, 0, 9, 0 ) END -- Item Name: Shining Concert Set (Lucia) -- Item ID: 606142464 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142464 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Shining Concert Set (Lucia)' , ICON = N'i_set_01' , PRICE = 32900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142464 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142464, N'Shining Concert Set (Lucia)', N'i_set_01', 32900, 1, 9, 0 ) END -- Item Name: Pink Ribbon Idol Set (Lucia) -- Item ID: 606142465 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142465 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Ribbon Idol Set (Lucia)' , ICON = N'i_set_01' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142465 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142465, N'Pink Ribbon Idol Set (Lucia)', N'i_set_01', 39900, 1, 9, 0 ) END -- Item Name: Light Red Hanbok Set (Lucia) -- Item ID: 606142473 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142473 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Light Red Hanbok Set (Lucia)' , ICON = N'i_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142473 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142473, N'Light Red Hanbok Set (Lucia)', N'i_set_01', 44900, 1, 9, 0 ) END -- Item Name: Dark Blue Hanbok Set (Lucia) -- Item ID: 606142474 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142474 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dark Blue Hanbok Set (Lucia)' , ICON = N'i_set_01' , PRICE = 44900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142474 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142474, N'Dark Blue Hanbok Set (Lucia)', N'i_set_01', 44900, 1, 9, 0 ) END -- Item Name: ?? ??? ??? -- Item ID: 606142476 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142476 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ??? ???' , ICON = N'i_set_01' , PRICE = 76 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142476 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142476, N'?? ??? ???', N'i_set_01', 76, 1, 9, 0 ) END -- Item Name: ?? ??? ??? -- Item ID: 606142477 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142477 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ??? ???' , ICON = N'i_set_01' , PRICE = 88 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142477 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142477, N'?? ??? ???', N'i_set_01', 88, 1, 9, 0 ) END -- Item Name: ????? ??(?????) -- Item ID: 606142485 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142485 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? ??(?????)' , ICON = N'i_set_01' , PRICE = 92 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142485 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142485, N'????? ??(?????)', N'i_set_01', 92, 1, 9, 0 ) END -- Item Name: Deep Blue Uniform Set (Lucia) -- Item ID: 606142486 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142486 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Deep Blue Uniform Set (Lucia)' , ICON = N'i_set_02' , PRICE = 520000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142486 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142486, N'Deep Blue Uniform Set (Lucia)', N'i_set_02', 520000, 0, 9, 0 ) END -- Item Name: Vocal Loid Set (L) -- Item ID: 606142487 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606142487 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Vocal Loid Set (L)' , ICON = N'i_set_02' , PRICE = 150000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606142487 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606142487, N'Vocal Loid Set (L)', N'i_set_02', 150000, 0, 9, 0 ) END -- Item Name: Trump Pink Set (Nell) -- Item ID: 606150656 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606150656 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Trump Pink Set (Nell)' , ICON = N'j_set_01' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606150656 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606150656, N'Trump Pink Set (Nell)', N'j_set_01', 59900, 1, 9, 0 ) END -- Item Name: SSAF Set(Nell) -- Item ID: 606150658 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606150658 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'SSAF Set(Nell)' , ICON = N'j_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606150658 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606150658, N'SSAF Set(Nell)', N'j_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Cyber Amarelo (NL) -- Item ID: 606150662 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606150662 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cyber Amarelo (NL)' , ICON = N'j_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606150662 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606150662, N'Cyber Amarelo (NL)', N'j_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Hanbok Set (Nell) -- Item ID: 606150665 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 606150665 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Hanbok Set (Nell)' , ICON = N'j_set_02' , PRICE = 59900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 606150665 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 606150665, N'Pink Hanbok Set (Nell)', N'j_set_02', 59900, 1, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608174091 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174091 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'm_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174091 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174091, N'???????(??)', N'm_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Sky Pajamas Set (Nuri) -- Item ID: 608174092 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174092 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sky Pajamas Set (Nuri)' , ICON = N'm_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174092 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174092, N'Sky Pajamas Set (Nuri)', N'm_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Oracle Set2 -- Item ID: 608174093 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174093 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Oracle Set2' , ICON = N'm_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174093 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174093, N'Oracle Set2', N'm_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Oracle Set -- Item ID: 608174094 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174094 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Oracle Set' , ICON = N'm_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174094 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174094, N'Oracle Set', N'm_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Pirate Set (Nuri) -- Item ID: 608174095 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174095 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirate Set (Nuri)' , ICON = N'm_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174095 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174095, N'Pirate Set (Nuri)', N'm_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pangya Baseball Set (Nuri) -- Item ID: 608174097 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174097 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Baseball Set (Nuri)' , ICON = N'm_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174097 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174097, N'Pangya Baseball Set (Nuri)', N'm_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Fur Coat Set (Nuri) -- Item ID: 608174102 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174102 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Fur Coat Set (Nuri)' , ICON = N'm_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174102 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174102, N'White Fur Coat Set (Nuri)', N'm_set_02', 10000000, 0, 9, 0 ) END -- Item Name: 2009 Swimsuit (Nuri) -- Item ID: 608174106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608174106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2009 Swimsuit (Nuri)' , ICON = N'm_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608174106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608174106, N'2009 Swimsuit (Nuri)', N'm_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Gold Butterfly Set -- Item ID: 608182281 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182281 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gold Butterfly Set' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182281 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182281, N'Gold Butterfly Set', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Curl Set (ÎҹР¤ÃºªØ´) -- Item ID: 608182284 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182284 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Curl Set (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182284 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182284, N'Black Curl Set (ÎҹР¤ÃºªØ´)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Curl Set (ÎҹР¤ÃºªØ´) -- Item ID: 608182285 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182285 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Curl Set (ÎҹР¤ÃºªØ´)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182285 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182285, N'White Curl Set (ÎҹР¤ÃºªØ´)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608182287 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182287 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182287 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182287, N'???????(??)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Swimsuit Set (Hana) -- Item ID: 608182291 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182291 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Swimsuit Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182291 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182291, N'White Swimsuit Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Pajamas Set (Hana) -- Item ID: 608182293 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182293 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Pajamas Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182293 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182293, N'Pink Pajamas Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Yellow Cat Set -- Item ID: 608182294 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182294 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Cat Set' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182294 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182294, N'Yellow Cat Set', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Crelic Set -- Item ID: 608182296 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182296 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crelic Set' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182296 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182296, N'Crelic Set', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: pink Crelic Set -- Item ID: 608182297 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182297 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'pink Crelic Set' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182297 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182297, N'pink Crelic Set', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Gothic Dress Set (Hana) -- Item ID: 608182298 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182298 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gothic Dress Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182298 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182298, N'Gothic Dress Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Wild Pirate Set (Hana) -- Item ID: 608182299 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182299 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Wild Pirate Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182299 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182299, N'Wild Pirate Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ??????????(??) -- Item ID: 608182301 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182301 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(??)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182301 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182301, N'??????????(??)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Tennis Uniform Set (Hana) -- Item ID: 608182302 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182302 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tennis Uniform Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182302 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182302, N'Tennis Uniform Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ?????????(??) -- Item ID: 608182304 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182304 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????????(??)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182304 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182304, N'?????????(??)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Flower Dress Set (Hana) -- Item ID: 608182310 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182310 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Flower Dress Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182310 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182310, N'Snow Flower Dress Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Nurse Dres(Hana) -- Item ID: 608182312 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182312 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Nurse Dres(Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182312 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182312, N'Pink Nurse Dres(Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Fruit Style Swimsuit Set (Hana) -- Item ID: 608182316 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182316 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fruit Style Swimsuit Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182316 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182316, N'Fruit Style Swimsuit Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Hana) -- Item ID: 608182317 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182317 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182317 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182317, N'Funky Waiter Set(Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Concert Set(Hana) -- Item ID: 608182319 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182319 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Concert Set(Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182319 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182319, N'Concert Set(Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: IDOL Set(Hana) -- Item ID: 608182324 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182324 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IDOL Set(Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182324 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182324, N'IDOL Set(Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Alice Set (Hana) -- Item ID: 608182325 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182325 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Alice Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182325 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182325, N'Alice Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Wedding Set (Hana) -- Item ID: 608182326 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182326 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wedding Set (Hana)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182326 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182326, N'Black Wedding Set (Hana)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Cyber Amarelo (H) -- Item ID: 608182327 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608182327 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cyber Amarelo (H)' , ICON = N'f_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608182327 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608182327, N'Cyber Amarelo (H)', N'f_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608190476 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190476 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'a_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190476 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190476, N'???????(??)', N'a_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Pajamas Set (Arthur) -- Item ID: 608190477 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190477 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pajamas Set (Arthur)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190477 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190477, N'Pajamas Set (Arthur)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Fantasy Set (Arthur) -- Item ID: 608190478 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190478 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fantasy Set (Arthur)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190478 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190478, N'Fantasy Set (Arthur)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pirate Set (Arthur) -- Item ID: 608190479 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190479 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirate Set (Arthur)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190479 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190479, N'Pirate Set (Arthur)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Sor.Arthur Set (ÍÒà¸ÍÃì ¤ÃºªØ´) -- Item ID: 608190480 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190480 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sor.Arthur Set (ÍÒà¸ÍÃì ¤ÃºªØ´)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190480 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190480, N'Sor.Arthur Set (ÍÒà¸ÍÃì ¤ÃºªØ´)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Flower Set (Arthur) -- Item ID: 608190485 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190485 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Flower Set (Arthur)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190485 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190485, N'Snow Flower Set (Arthur)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Marine guard set (Arthur) -- Item ID: 608190487 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190487 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Marine guard set (Arthur)' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190487 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190487, N'Marine guard set (Arthur)', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Franken Set -- Item ID: 608190494 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608190494 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Franken Set' , ICON = N'a_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608190494 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608190494, N'Franken Set', N'a_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Rose Wedding Set -- Item ID: 608198667 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198667 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Rose Wedding Set' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198667 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198667, N'White Rose Wedding Set', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ??????????? -- Item ID: 608198670 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198670 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????????' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198670 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198670, N'???????????', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ?????????? -- Item ID: 608198671 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198671 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198671 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198671, N'??????????', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(????) -- Item ID: 608198675 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198675 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(????)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198675 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198675, N'???????(????)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(????) -- Item ID: 608198676 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198676 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(????)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198676 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198676, N'???????(????)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????(????) -- Item ID: 608198678 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198678 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(????)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198678 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198678, N'????????(????)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Grey Cat Set -- Item ID: 608198679 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198679 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Grey Cat Set' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198679 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198679, N'Grey Cat Set', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Fantasy Set (Cesillia) -- Item ID: 608198680 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198680 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fantasy Set (Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198680 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198680, N'Fantasy Set (Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Gothic Dress Set (Cesillia) -- Item ID: 608198681 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198681 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gothic Dress Set (Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198681 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198681, N'Gothic Dress Set (Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pirate Set (Cesillia) -- Item ID: 608198682 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198682 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirate Set (Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198682 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198682, N'Pirate Set (Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Star Night Bikini Set(Cesillia) -- Item ID: 608198683 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198683 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Star Night Bikini Set(Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198683 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198683, N'Star Night Bikini Set(Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????(????) -- Item ID: 608198684 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198684 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(????)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198684 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198684, N'????????(????)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Flower Set (Cesillia) -- Item ID: 608198691 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198691 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Flower Set (Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198691 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198691, N'Snow Flower Set (Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Nurse Dres(Cesillia) -- Item ID: 608198692 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198692 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Nurse Dres(Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198692 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198692, N'Pink Nurse Dres(Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: 2009 Swimsuit (Cecilia) -- Item ID: 608198696 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198696 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2009 Swimsuit (Cecilia)' , ICON = N'c_set_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198696 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198696, N'2009 Swimsuit (Cecilia)', N'c_set_01', 10000000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Cesillia) -- Item ID: 608198697 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198697 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198697 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198697, N'Funky Waiter Set(Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: IDOL Set(Cesillia) -- Item ID: 608198704 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198704 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IDOL Set(Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198704 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198704, N'IDOL Set(Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Queen (Cesillia) -- Item ID: 608198705 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198705 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Queen (Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198705 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198705, N'Snow Queen (Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Wedding Set (Cesillia) -- Item ID: 608198706 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198706 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wedding Set (Cesillia)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198706 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198706, N'Black Wedding Set (Cesillia)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Cyber Amarelo (C) -- Item ID: 608198707 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608198707 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cyber Amarelo (C)' , ICON = N'c_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608198707 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608198707, N'Cyber Amarelo (C)', N'c_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Shark Set (áÁ¡«ì ¤ÃºªØ´) -- Item ID: 608206856 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206856 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Shark Set (áÁ¡«ì ¤ÃºªØ´)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206856 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206856, N'Shark Set (áÁ¡«ì ¤ÃºªØ´)', N'd_set_02', 10000000, 1, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608206862 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206862 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206862 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206862, N'???????(??)', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????(??) -- Item ID: 608206864 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206864 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(??)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206864 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206864, N'????????(??)', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Elf Archer Set -- Item ID: 608206865 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206865 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Elf Archer Set' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206865 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206865, N'Elf Archer Set', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: black Elf Archer Set -- Item ID: 608206866 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206866 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'black Elf Archer Set' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206866 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206866, N'black Elf Archer Set', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Wild Skeleton Set (Max) -- Item ID: 608206867 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206867 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Wild Skeleton Set (Max)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206867 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206867, N'Wild Skeleton Set (Max)', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Fur Coat Set (Max) -- Item ID: 608206870 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206870 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Fur Coat Set (Max)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206870 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206870, N'White Fur Coat Set (Max)', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Beach Set (Max) -- Item ID: 608206873 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206873 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Beach Set (Max)' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206873 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206873, N'White Beach Set (Max)', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Dark Lord Set -- Item ID: 608206881 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608206881 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dark Lord Set' , ICON = N'd_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608206881 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608206881, N'Dark Lord Set', N'd_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Rose Wedding Set (Kooh ¤ÃºªØ´) -- Item ID: 608215055 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215055 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Rose Wedding Set (Kooh ¤ÃºªØ´)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215055 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215055, N'Pink Rose Wedding Set (Kooh ¤ÃºªØ´)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Curl Set (Kooh ¤ÃºªØ´) -- Item ID: 608215058 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215058 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Curl Set (Kooh ¤ÃºªØ´)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215058 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215058, N'Pink Curl Set (Kooh ¤ÃºªØ´)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Red Wine Curl Set (Kooh ¤ÃºªØ´) -- Item ID: 608215059 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215059 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Wine Curl Set (Kooh ¤ÃºªØ´)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215059 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215059, N'Red Wine Curl Set (Kooh ¤ÃºªØ´)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(?) -- Item ID: 608215062 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215062 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(?)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215062 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215062, N'???????(?)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ??????????(?) -- Item ID: 608215064 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215064 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(?)' , ICON = N'e_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215064 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215064, N'??????????(?)', N'e_set_02', 1000000, 0, 9, 0 ) END -- Item Name: ??????????(?) -- Item ID: 608215066 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215066 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(?)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215066 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215066, N'??????????(?)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Cat Set -- Item ID: 608215067 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215067 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Cat Set' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215067 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215067, N'Black Cat Set', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Fantasy Set (Kooh) -- Item ID: 608215069 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215069 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fantasy Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215069 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215069, N'Fantasy Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Gothic Dress Set (Kooh) -- Item ID: 608215070 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215070 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gothic Dress Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215070 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215070, N'Gothic Dress Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pirate Set (Kooh) -- Item ID: 608215071 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215071 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirate Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215071 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215071, N'Pirate Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Shell Bikini Set(Kooh) -- Item ID: 608215073 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215073 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Shell Bikini Set(Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215073 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215073, N'Pink Shell Bikini Set(Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Shining Blue Gym Set (Kooh) -- Item ID: 608215075 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215075 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Shining Blue Gym Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215075 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215075, N'Shining Blue Gym Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Shining White Gym Set (Kooh) -- Item ID: 608215076 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215076 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Shining White Gym Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215076 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215076, N'Shining White Gym Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????????(?) -- Item ID: 608215079 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215079 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????????(?)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215079 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215079, N'???????????(?)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Flower Set (Kooh) -- Item ID: 608215087 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215087 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Flower Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215087 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215087, N'Snow Flower Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Nurse Dres(Kooh) -- Item ID: 608215088 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215088 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Nurse Dres(Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215088 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215088, N'Pink Nurse Dres(Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: 2009 Swimsuit (Kooh) -- Item ID: 608215092 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215092 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2009 Swimsuit (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215092 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215092, N'2009 Swimsuit (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Kooh) -- Item ID: 608215094 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215094 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215094 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215094, N'Funky Waiter Set(Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: IDOL Set(KooH) -- Item ID: 608215102 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215102 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IDOL Set(KooH)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215102 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215102, N'IDOL Set(KooH)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Little Red Cap Set(Kooh) -- Item ID: 608215104 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215104 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Little Red Cap Set(Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215104 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215104, N'Little Red Cap Set(Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Wedding Set (Kooh) -- Item ID: 608215105 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215105 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wedding Set (Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215105 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215105, N'Black Wedding Set (Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Zombie Set -- Item ID: 608215108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Zombie Set' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215108, N'Zombie Set', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Concert Set(Kooh) -- Item ID: 608215109 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215109 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Concert Set(Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215109 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215109, N'Concert Set(Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Red Tartan Set(Kooh) -- Item ID: 608215110 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215110 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Tartan Set(Kooh)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215110 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215110, N'Red Tartan Set(Kooh)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Cyber Amarelo (K) -- Item ID: 608215111 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608215111 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cyber Amarelo (K)' , ICON = N'e_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608215111 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608215111, N'Cyber Amarelo (K)', N'e_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Dandelion Wedding Set -- Item ID: 608223248 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223248 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dandelion Wedding Set' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223248 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223248, N'Dandelion Wedding Set', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Yellow Curl Set (ÍÒÃÔ¹ ¤ÃºªØ´) -- Item ID: 608223252 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223252 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Curl Set (ÍÒÃÔ¹ ¤ÃºªØ´)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223252 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223252, N'Yellow Curl Set (ÍÒÃÔ¹ ¤ÃºªØ´)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Curl Set (ÍÒÃÔ¹ ¤ÃºªØ´) -- Item ID: 608223253 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223253 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Curl Set (ÍÒÃÔ¹ ¤ÃºªØ´)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223253 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223253, N'Pink Curl Set (ÍÒÃÔ¹ ¤ÃºªØ´)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608223255 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223255 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223255 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223255, N'???????(??)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????????(??) -- Item ID: 608223259 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223259 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????????(??)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223259 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223259, N'????????????(??)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????(??) -- Item ID: 608223261 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223261 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(??)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223261 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223261, N'????????(??)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????(??) -- Item ID: 608223262 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223262 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????(??)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223262 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223262, N'????????(??)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Cat Set -- Item ID: 608223263 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223263 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Cat Set' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223263 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223263, N'White Cat Set', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Valkyrie Set -- Item ID: 608223264 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223264 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valkyrie Set' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223264 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223264, N'Valkyrie Set', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: silver Valkyrie Set -- Item ID: 608223266 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223266 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'silver Valkyrie Set' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223266 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223266, N'silver Valkyrie Set', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Gothic Dress Set (Arin) -- Item ID: 608223267 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223267 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gothic Dress Set (Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223267 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223267, N'Gothic Dress Set (Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Elegance Pirate Set (Arin) -- Item ID: 608223268 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223268 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Elegance Pirate Set (Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223268 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223268, N'Elegance Pirate Set (Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ????????????(??) -- Item ID: 608223269 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223269 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????????????(??)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223269 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223269, N'????????????(??)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Classic Riding Set (Arin) -- Item ID: 608223270 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223270 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Classic Riding Set (Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223270 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223270, N'Classic Riding Set (Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????????(??) -- Item ID: 608223272 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223272 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????????(??)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223272 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223272, N'???????????(??)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Flower Set (Arin) -- Item ID: 608223281 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223281 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Flower Set (Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223281 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223281, N'Snow Flower Set (Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Nurse Dres(Arin) -- Item ID: 608223282 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223282 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Nurse Dres(Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223282 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223282, N'Pink Nurse Dres(Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Orange Dot Bikini Set (Arin) -- Item ID: 608223286 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223286 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Orange Dot Bikini Set (Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223286 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223286, N'Orange Dot Bikini Set (Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Arin) -- Item ID: 608223287 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223287 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223287 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223287, N'Funky Waiter Set(Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: IDOL Set(Arin) -- Item ID: 608223294 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223294 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IDOL Set(Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223294 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223294, N'IDOL Set(Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow White Set(Arin) -- Item ID: 608223295 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223295 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow White Set(Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223295 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223295, N'Snow White Set(Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Wedding Set (Arin) -- Item ID: 608223296 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223296 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wedding Set (Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223296 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223296, N'Black Wedding Set (Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Concert Set(Arin) -- Item ID: 608223299 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223299 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Concert Set(Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223299 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223299, N'Concert Set(Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Xmas High Set(Arin) -- Item ID: 608223300 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223300 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Xmas High Set(Arin)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223300 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223300, N'Xmas High Set(Arin)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Cyber Amarelo (A) -- Item ID: 608223301 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608223301 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cyber Amarelo (A)' , ICON = N'g_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608223301 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608223301, N'Cyber Amarelo (A)', N'g_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608231433 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231433 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'h_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231433 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231433, N'???????(??)', N'h_set_02', 1000000, 0, 9, 0 ) END -- Item Name: ???????(??) -- Item ID: 608231434 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231434 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(??)' , ICON = N'h_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231434 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231434, N'???????(??)', N'h_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Fantasy Set (Kaz) -- Item ID: 608231435 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231435 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fantasy Set (Kaz) ' , ICON = N'h_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231435 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231435, N'Fantasy Set (Kaz) ', N'h_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pirate Set (Kaz) -- Item ID: 608231436 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231436 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirate Set (Kaz)' , ICON = N'h_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231436 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231436, N'Pirate Set (Kaz)', N'h_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Fur Coat Set (Kaz) -- Item ID: 608231444 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231444 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Fur Coat Set (Kaz)' , ICON = N'h_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231444 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231444, N'White Fur Coat Set (Kaz)', N'h_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ?????????? -- Item ID: 608231445 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231445 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????' , ICON = N'h_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231445 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231445, N'??????????', N'h_set_02', 10000000, 0, 9, 0 ) END -- Item Name: 2009 Swimsuit (Kaz) -- Item ID: 608231450 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608231450 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2009 Swimsuit (Kaz)' , ICON = N'h_set_02' , PRICE = 1000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608231450 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608231450, N'2009 Swimsuit (Kaz)', N'h_set_02', 1000000, 0, 9, 0 ) END -- Item Name: Violet Black Set (Lucia) -- Item ID: 608239618 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239618 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Violet Black Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239618 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239618, N'Violet Black Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: SSAF Set (Lucia) -- Item ID: 608239619 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239619 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'SSAF Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239619 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239619, N'SSAF Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Rose Wedding Set (Lucia) -- Item ID: 608239620 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239620 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rose Wedding Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239620 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239620, N'Rose Wedding Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Heart Pajamas Set (Lucia) -- Item ID: 608239621 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239621 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart Pajamas Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239621 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239621, N'Heart Pajamas Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Melody Set (Lucia) -- Item ID: 608239622 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239622 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Melody Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239622 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239622, N'Pink Melody Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pirate Set (Lucia) -- Item ID: 608239623 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239623 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pirate Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239623 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239623, N'Pirate Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: White Chiffon Set (Lucia) -- Item ID: 608239624 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239624 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Chiffon Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239624 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239624, N'White Chiffon Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ??????????(???) -- Item ID: 608239627 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239627 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????????(???)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239627 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239627, N'??????????(???)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Witch Set(Lucia) -- Item ID: 608239630 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239630 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Witch Set(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239630 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239630, N'Black Witch Set(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Snow Ribbon Dress Set (Lucia) -- Item ID: 608239633 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239633 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Ribbon Dress Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239633 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239633, N'Snow Ribbon Dress Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Cherry blossom Kimono Set(Lucia) -- Item ID: 608239634 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239634 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cherry blossom Kimono Set(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239634 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239634, N'Cherry blossom Kimono Set(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Pink Nurse Dres(Lucia) -- Item ID: 608239635 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239635 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Nurse Dres(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239635 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239635, N'Pink Nurse Dres(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ???????(???) -- Item ID: 608239636 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239636 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(???)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239636 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239636, N'???????(???)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Colorful Summer Set (Lucia) -- Item ID: 608239640 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239640 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Colorful Summer Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239640 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239640, N'Colorful Summer Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Funky Waiter Set(Lucia) -- Item ID: 608239643 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239643 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Funky Waiter Set(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239643 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239643, N'Funky Waiter Set(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: IDOL Set(Lucia) -- Item ID: 608239650 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239650 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IDOL Set(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239650 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239650, N'IDOL Set(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Mute Swan Set(Lucia) -- Item ID: 608239651 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239651 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mute Swan Set(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239651 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239651, N'Mute Swan Set(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Black Wedding Set (Lucia) -- Item ID: 608239652 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239652 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wedding Set (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239652 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239652, N'Black Wedding Set (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Succubus Set -- Item ID: 608239655 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239655 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Succubus Set' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239655 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239655, N'Succubus Set', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Concert Set(Lucia) -- Item ID: 608239656 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239656 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Concert Set(Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239656 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239656, N'Concert Set(Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Red Leopard (Lucia) -- Item ID: 608239657 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239657 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Leopard (Lucia)' , ICON = N'i_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239657 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239657, N'Red Leopard (Lucia)', N'i_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Tecmo Set (L) -- Item ID: 608239659 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608239659 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tecmo Set (L)' , ICON = N'i_set_02' , PRICE = 14900 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608239659 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608239659, N'Tecmo Set (L)', N'i_set_02', 14900, 0, 9, 0 ) END -- Item Name: 2010 Halloween Set (Nell) -- Item ID: 608247813 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608247813 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2010 Halloween Set (Nell)' , ICON = N'j_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608247813 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608247813, N'2010 Halloween Set (Nell)', N'j_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Concert Set(Nall) -- Item ID: 608247814 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608247814 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Concert Set(Nall)' , ICON = N'j_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608247814 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608247814, N'Concert Set(Nall)', N'j_set_02', 10000000, 0, 9, 0 ) END -- Item Name: Red White (Nell) -- Item ID: 608247815 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 608247815 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red White (Nell)' , ICON = N'j_set_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 608247815 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 608247815, N'Red White (Nell)', N'j_set_02', 10000000, 0, 9, 0 ) END -- Item Name: ?? ?? ??? -- Item ID: 612425728 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 612425728 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ?? ???' , ICON = N'item_set_05' , PRICE = 76 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 612425728 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 612425728, N'?? ?? ???', N'item_set_05', 76, 1, 9, 0 ) END -- Item Name: ?? ?? ??? -- Item ID: 612425729 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 612425729 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ?? ???' , ICON = N'item_set_05' , PRICE = 88 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 612425729 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 612425729, N'?? ?? ???', N'item_set_05', 88, 1, 9, 0 ) END -- Item Name: ?? ??? ??? -- Item ID: 612433920 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 612433920 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ??? ???' , ICON = N'item_set_05' , PRICE = 76 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 612433920 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 612433920, N'?? ??? ???', N'item_set_05', 76, 1, 9, 0 ) END -- Item Name: ?? ??? ??? -- Item ID: 612433921 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 612433921 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?? ??? ???' , ICON = N'item_set_05' , PRICE = 88 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 612433921 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 612433921, N'?? ??? ???', N'item_set_05', 88, 1, 9, 0 ) END -- Item Name: ? -- Item ID: 616546304 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 616546304 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?' , ICON = N'item_set_02' , PRICE = 15 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 616546304 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 616546304, N'?', N'item_set_02', 15, 1, 9, 0 ) END -- Item Name: ??-?? -- Item ID: 616546305 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 616546305 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??-??' , ICON = N'item_set_01' , PRICE = 15 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 616546305 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 616546305, N'??-??', N'item_set_01', 15, 1, 9, 0 ) END -- Item Name: ?? -- Item ID: 616546306 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 616546306 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??' , ICON = N'item_set_03' , PRICE = 15 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 616546306 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 616546306, N'??', N'item_set_03', 15, 1, 9, 0 ) END -- Item Name: ??Best -- Item ID: 616546307 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 616546307 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??Best' , ICON = N'item_set_04' , PRICE = 15 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 616546307 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 616546307, N'??Best', N'item_set_04', 15, 1, 9, 0 ) END -- Item Name: Chocolate Aztec(500pcs) -- Item ID: 616546309 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 616546309 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Chocolate Aztec(500pcs)' , ICON = N'item_set_01' , PRICE = 34900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 616546309 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 616546309, N'Chocolate Aztec(500pcs)', N'item_set_01', 34900, 1, 9, 0 ) END -- Item Name: Chocolate Aztec(1000pcs) -- Item ID: 616546310 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 616546310 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Chocolate Aztec(1000pcs)' , ICON = N'item_set_01' , PRICE = 65900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 616546310 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 616546310, N'Chocolate Aztec(1000pcs)', N'item_set_01', 65900, 1, 9, 0 ) END -- Item Name: New item Set 3 -- Item ID: 618643456 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618643456 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New item Set 3' , ICON = N'item_set_00' , PRICE = 19 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618643456 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618643456, N'New item Set 3', N'item_set_00', 19, 1, 9, 0 ) END -- Item Name: New item Set 3 -- Item ID: 618643457 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618643457 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New item Set 3' , ICON = N'item_set_05' , PRICE = 53 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618643457 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618643457, N'New item Set 3', N'item_set_05', 53, 1, 9, 0 ) END -- Item Name: New item Set 3 -- Item ID: 618651648 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651648 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New item Set 3' , ICON = N'item_set_00' , PRICE = 19 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651648 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651648, N'New item Set 3', N'item_set_00', 19, 1, 9, 0 ) END -- Item Name: Best of Best -- Item ID: 618651649 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651649 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Best of Best' , ICON = N'item_set_05' , PRICE = 53 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651649 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651649, N'Best of Best', N'item_set_05', 53, 1, 9, 0 ) END -- Item Name: StarBoost Candy(50EA) -- Item ID: 618651673 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651673 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'StarBoost Candy(50EA)' , ICON = N'item_set_00' , PRICE = 2900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651673 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651673, N'StarBoost Candy(50EA)', N'item_set_00', 2900, 1, 9, 0 ) END -- Item Name: StarBoost Candy(500EA) -- Item ID: 618651674 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651674 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'StarBoost Candy(500EA)' , ICON = N'item_set_00' , PRICE = 23900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651674 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651674, N'StarBoost Candy(500EA)', N'item_set_00', 23900, 1, 9, 0 ) END -- Item Name: StarBoost Candy(1000EA) -- Item ID: 618651675 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651675 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'StarBoost Candy(1000EA)' , ICON = N'item_set_00' , PRICE = 39900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651675 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651675, N'StarBoost Candy(1000EA)', N'item_set_00', 39900, 1, 9, 0 ) END -- Item Name: Love Chocolate(200pcs) -- Item ID: 618651703 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651703 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Chocolate(200pcs)' , ICON = N'item_set_00' , PRICE = 5700 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651703 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651703, N'Love Chocolate(200pcs)', N'item_set_00', 5700, 1, 9, 0 ) END -- Item Name: Love Chocolate(350pcs) -- Item ID: 618651704 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651704 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Chocolate(350pcs)' , ICON = N'item_set_00' , PRICE = 9500 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651704 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651704, N'Love Chocolate(350pcs)', N'item_set_00', 9500, 1, 9, 0 ) END -- Item Name: Love Chocolate(5000pcs) -- Item ID: 618651705 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651705 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Chocolate(5000pcs)' , ICON = N'item_set_00' , PRICE = 129900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651705 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651705, N'Love Chocolate(5000pcs)', N'item_set_00', 129900, 1, 9, 0 ) END -- Item Name: Delight Chocolate(200pcs) -- Item ID: 618651706 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651706 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Delight Chocolate(200pcs)' , ICON = N'item_set_00' , PRICE = 5700 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651706 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651706, N'Delight Chocolate(200pcs)', N'item_set_00', 5700, 1, 9, 0 ) END -- Item Name: Delight Chocolate(350pcs) -- Item ID: 618651707 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651707 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Delight Chocolate(350pcs)' , ICON = N'item_set_00' , PRICE = 9500 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651707 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651707, N'Delight Chocolate(350pcs)', N'item_set_00', 9500, 1, 9, 0 ) END -- Item Name: Delight Chocolate(5000pcs) -- Item ID: 618651708 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 618651708 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Delight Chocolate(5000pcs)' , ICON = N'item_set_00' , PRICE = 129900 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 618651708 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 618651708, N'Delight Chocolate(5000pcs)', N'item_set_00', 129900, 1, 9, 0 ) END -- Item Name: ??? ????? -- Item ID: 622829568 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 622829568 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ?????' , ICON = N'item_set_00' , PRICE = 60 , ISCASH = 1 , TYPE = 9 , IS_SALABLE = 0 WHERE TYPEID = 622829568 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 622829568, N'??? ?????', N'item_set_00', 60, 1, 9, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia