-- ----------------------------------------------- -- -- 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 "Skin.iff" -- -- Last update of the IFF: 2022-02-16 01:28:51 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Skin.iff contains 235 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Rabbit & Orange -- Item ID: 939524096 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524096 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rabbit & Orange' , ICON = N'skin_001i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524096 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524096, N'Rabbit & Orange', N'skin_001i', 1900, 1, 14, 0 ) END -- Item Name: Tea Time -- Item ID: 939524097 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524097 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tea Time' , ICON = N'skin_002i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524097 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524097, N'Tea Time', N'skin_002i', 1900, 1, 14, 0 ) END -- Item Name: Rabbit & Carrot -- Item ID: 939524098 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524098 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rabbit & Carrot' , ICON = N'skin_003i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524098 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524098, N'Rabbit & Carrot', N'skin_003i', 1200, 1, 14, 0 ) END -- Item Name: Mattress -- Item ID: 939524099 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524099 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mattress' , ICON = N'skin_004i' , PRICE = 10000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524099 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524099, N'Mattress', N'skin_004i', 10000, 0, 14, 0 ) END -- Item Name: The Best Rice -- Item ID: 939524100 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524100 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'The Best Rice' , ICON = N'skin_005i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524100 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524100, N'The Best Rice', N'skin_005i', 1900, 1, 14, 0 ) END -- Item Name: Ivy Vines -- Item ID: 939524101 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524101 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Ivy Vines' , ICON = N'skin_006i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524101 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524101, N'Ivy Vines', N'skin_006i', 1200, 1, 14, 0 ) END -- Item Name: Purple Tiki -- Item ID: 939524102 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524102 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Purple Tiki' , ICON = N'skin_007i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524102 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524102, N'Purple Tiki', N'skin_007i', 1900, 1, 14, 0 ) END -- Item Name: Green Tiki -- Item ID: 939524103 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524103 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Tiki' , ICON = N'skin_008i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524103 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524103, N'Green Tiki', N'skin_008i', 1900, 1, 14, 0 ) END -- Item Name: Valentineday 1 -- Item ID: 939524104 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524104 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday 1' , ICON = N'skin_009i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524104 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524104, N'Valentineday 1', N'skin_009i', 10000000, 0, 14, 0 ) END -- Item Name: Valentineday 2 -- Item ID: 939524105 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524105 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday 2' , ICON = N'skin_010i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524105 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524105, N'Valentineday 2', N'skin_010i', 10000000, 0, 14, 0 ) END -- Item Name: Buble Pang Bag -- Item ID: 939524106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Buble Pang Bag' , ICON = N'skin_129i_jp' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524106, N'Buble Pang Bag', N'skin_129i_jp', 1900, 1, 14, 0 ) END -- Item Name: Blue Lagoon -- Item ID: 939524107 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524107 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Lagoon' , ICON = N'skin_131i_jp' , PRICE = 5000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524107 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524107, N'Blue Lagoon', N'skin_131i_jp', 5000, 0, 14, 0 ) END -- Item Name: Blue Sky -- Item ID: 939524108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Sky' , ICON = N'skin_139i_jp' , PRICE = 4000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524108, N'Blue Sky', N'skin_139i_jp', 4000, 0, 14, 0 ) END -- Item Name: Chuthamat Wall -- Item ID: 939524224 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524224 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Chuthamat Wall' , ICON = N'skin_128i_th' , PRICE = 1000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524224 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524224, N'Chuthamat Wall', N'skin_128i_th', 1000, 0, 14, 0 ) END -- Item Name: Prawwaree Wall -- Item ID: 939524225 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524225 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Prawwaree Wall' , ICON = N'skin_129i_th' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524225 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524225, N'Prawwaree Wall', N'skin_129i_th', 1200, 1, 14, 0 ) END -- Item Name: NB2 -- Item ID: 939524226 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524226 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'NB2' , ICON = N'skin_130i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524226 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524226, N'NB2', N'skin_130i', 10000000, 0, 14, 0 ) END -- Item Name: Magic Stars(USA) -- Item ID: 939524227 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524227 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Magic Stars(USA)' , ICON = N'skin_131i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524227 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524227, N'Magic Stars(USA)', N'skin_131i', 18, 1, 14, 0 ) END -- Item Name: Dolfini(USA) -- Item ID: 939524228 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524228 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolfini(USA)' , ICON = N'skin_132i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524228 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524228, N'Dolfini(USA)', N'skin_132i', 18, 1, 14, 0 ) END -- Item Name: Orange(USA) -- Item ID: 939524229 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524229 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Orange(USA)' , ICON = N'skin_133i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524229 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524229, N'Orange(USA)', N'skin_133i', 18, 1, 14, 0 ) END -- Item Name: Blue Eagle(PH) -- Item ID: 939524230 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524230 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Eagle(PH)' , ICON = N'skin_134i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524230 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524230, N'Blue Eagle(PH)', N'skin_134i', 750, 1, 14, 0 ) END -- Item Name: Green Archer(PH) -- Item ID: 939524231 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524231 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Archer(PH)' , ICON = N'skin_135i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524231 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524231, N'Green Archer(PH)', N'skin_135i', 750, 1, 14, 0 ) END -- Item Name: Yellow Tiger(PH) -- Item ID: 939524232 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524232 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Tiger(PH)' , ICON = N'skin_136i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524232 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524232, N'Yellow Tiger(PH)', N'skin_136i', 750, 1, 14, 0 ) END -- Item Name: Singapore Theme(SG) -- Item ID: 939524233 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524233 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Singapore Theme(SG)' , ICON = N'skin_137i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524233 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524233, N'Singapore Theme(SG)', N'skin_137i', 750, 1, 14, 0 ) END -- Item Name: Malaysia Theme(SG) -- Item ID: 939524234 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524234 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Malaysia Theme(SG)' , ICON = N'skin_138i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524234 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524234, N'Malaysia Theme(SG)', N'skin_138i', 750, 1, 14, 0 ) END -- Item Name: Hallow(PH) -- Item ID: 939524235 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524235 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hallow(PH)' , ICON = N'skin_139i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524235 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524235, N'Hallow(PH)', N'skin_139i', 750, 1, 14, 0 ) END -- Item Name: New Year Skin(SG) -- Item ID: 939524236 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 939524236 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New Year Skin(SG)' , ICON = N'skin_140i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 939524236 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 939524236, N'New Year Skin(SG)', N'skin_140i', 750, 1, 14, 0 ) END -- Item Name: Bird Cage Frame -- Item ID: 943718400 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718400 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bird Cage Frame' , ICON = N'frame_001i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718400 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718400, N'Bird Cage Frame', N'frame_001i', 1900, 1, 14, 0 ) END -- Item Name: Stamp Frame -- Item ID: 943718401 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718401 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Stamp Frame' , ICON = N'frame_002i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718401 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718401, N'Stamp Frame', N'frame_002i', 1900, 1, 14, 0 ) END -- Item Name: Teakwood Frame -- Item ID: 943718402 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718402 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Teakwood Frame' , ICON = N'frame_003i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718402 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718402, N'Teakwood Frame', N'frame_003i', 1900, 1, 14, 0 ) END -- Item Name: Antic Frame -- Item ID: 943718403 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718403 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Antic Frame' , ICON = N'frame_004i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718403 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718403, N'Antic Frame', N'frame_004i', 1200, 1, 14, 0 ) END -- Item Name: Log Round Frame -- Item ID: 943718404 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718404 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Log Round Frame' , ICON = N'frame_005i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718404 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718404, N'Log Round Frame', N'frame_005i', 1900, 1, 14, 0 ) END -- Item Name: Jungle Frame -- Item ID: 943718405 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718405 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Jungle Frame' , ICON = N'frame_006i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718405 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718405, N'Jungle Frame', N'frame_006i', 1900, 1, 14, 0 ) END -- Item Name: Golden Frame -- Item ID: 943718406 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718406 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Golden Frame' , ICON = N'frame_007i' , PRICE = 1000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718406 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718406, N'Golden Frame', N'frame_007i', 1000, 0, 14, 0 ) END -- Item Name: Star Force Frame -- Item ID: 943718407 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718407 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Star Force Frame' , ICON = N'frame_008i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718407 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718407, N'Star Force Frame', N'frame_008i', 1900, 1, 14, 0 ) END -- Item Name: Bronze Frame -- Item ID: 943718408 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718408 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bronze Frame' , ICON = N'frame_009i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718408 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718408, N'Bronze Frame', N'frame_009i', 1200, 1, 14, 0 ) END -- Item Name: Pink Water Frame -- Item ID: 943718409 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718409 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Water Frame' , ICON = N'frame_010i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718409 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718409, N'Pink Water Frame', N'frame_010i', 1900, 1, 14, 0 ) END -- Item Name: Green Water Frame -- Item ID: 943718410 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718410 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Water Frame' , ICON = N'frame_011i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718410 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718410, N'Green Water Frame', N'frame_011i', 1900, 1, 14, 0 ) END -- Item Name: Flower Garden Frame -- Item ID: 943718411 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718411 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Flower Garden Frame' , ICON = N'frame_012i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718411 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718411, N'Flower Garden Frame', N'frame_012i', 1200, 1, 14, 0 ) END -- Item Name: Movie Film Frame -- Item ID: 943718412 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718412 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Movie Film Frame' , ICON = N'frame_013i' , PRICE = 1900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718412 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718412, N'Movie Film Frame', N'frame_013i', 1900, 1, 14, 0 ) END -- Item Name: Valentineday Frame -- Item ID: 943718413 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718413 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday Frame' , ICON = N'frame_014i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718413 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718413, N'Valentineday Frame', N'frame_014i', 10000000, 0, 14, 0 ) END -- Item Name: Caddie Land Frame -- Item ID: 943718414 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718414 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Land Frame' , ICON = N'frame_132i_jp' , PRICE = 3000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718414 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718414, N'Caddie Land Frame', N'frame_132i_jp', 3000, 0, 14, 0 ) END -- Item Name: Star Round Frame -- Item ID: 943718415 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718415 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Star Round Frame' , ICON = N'frame_135i_jp' , PRICE = 2000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718415 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718415, N'Star Round Frame', N'frame_135i_jp', 2000, 0, 14, 0 ) END -- Item Name: New Year Frame -- Item ID: 943718528 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718528 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New Year Frame' , ICON = N'frame_128i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718528 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718528, N'New Year Frame', N'frame_128i', 10000000, 0, 14, 0 ) END -- Item Name: Autumn Blossorn(USA) -- Item ID: 943718529 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718529 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Autumn Blossorn(USA)' , ICON = N'frame_129i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718529 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718529, N'Autumn Blossorn(USA)', N'frame_129i', 18, 1, 14, 0 ) END -- Item Name: Just A Squares(USA) -- Item ID: 943718530 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718530 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Just A Squares(USA)' , ICON = N'frame_130i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718530 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718530, N'Just A Squares(USA)', N'frame_130i', 18, 1, 14, 0 ) END -- Item Name: Household(USA) -- Item ID: 943718531 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718531 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Household(USA)' , ICON = N'frame_131i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718531 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718531, N'Household(USA)', N'frame_131i', 18, 1, 14, 0 ) END -- Item Name: SS-3(USA) -- Item ID: 943718532 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718532 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'SS-3(USA)' , ICON = N'frame_132i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718532 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718532, N'SS-3(USA)', N'frame_132i', 18, 1, 14, 0 ) END -- Item Name: Singapore Theme(SG) -- Item ID: 943718533 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718533 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Singapore Theme(SG)' , ICON = N'frame_133i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718533 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718533, N'Singapore Theme(SG)', N'frame_133i', 18, 1, 14, 0 ) END -- Item Name: Malaysia Theme(SG) -- Item ID: 943718534 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718534 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Malaysia Theme(SG)' , ICON = N'frame_134i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718534 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718534, N'Malaysia Theme(SG)', N'frame_134i', 18, 1, 14, 0 ) END -- Item Name: New Year Frame(SG) -- Item ID: 943718535 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 943718535 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New Year Frame(SG)' , ICON = N'frame_135i' , PRICE = 18 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 943718535 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 943718535, N'New Year Frame(SG)', N'frame_135i', 18, 1, 14, 0 ) END -- Item Name: Kuma Sticker -- Item ID: 947912704 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912704 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuma Sticker' , ICON = N'sticker_001i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912704 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912704, N'Kuma Sticker', N'sticker_001i', 4900, 1, 14, 0 ) END -- Item Name: Heart Sticker -- Item ID: 947912705 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912705 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart Sticker' , ICON = N'sticker_002i' , PRICE = 2900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912705 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912705, N'Heart Sticker', N'sticker_002i', 2900, 1, 14, 0 ) END -- Item Name: Bag Gang Sticker -- Item ID: 947912706 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912706 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bag Gang Sticker' , ICON = N'sticker_003i' , PRICE = 5000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912706 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912706, N'Bag Gang Sticker', N'sticker_003i', 5000, 0, 14, 0 ) END -- Item Name: Lease Sticker -- Item ID: 947912707 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912707 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lease Sticker' , ICON = N'sticker_004i' , PRICE = 2900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912707 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912707, N'Lease Sticker', N'sticker_004i', 2900, 1, 14, 0 ) END -- Item Name: Moji Sticker -- Item ID: 947912708 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912708 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Moji Sticker' , ICON = N'sticker_005i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912708 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912708, N'Moji Sticker', N'sticker_005i', 4900, 1, 14, 0 ) END -- Item Name: Piggy Bank Sticker -- Item ID: 947912709 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912709 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Piggy Bank Sticker' , ICON = N'sticker_006i' , PRICE = 2900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912709 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912709, N'Piggy Bank Sticker', N'sticker_006i', 2900, 1, 14, 0 ) END -- Item Name: Pink Flower Sticker -- Item ID: 947912710 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912710 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Flower Sticker' , ICON = N'sticker_007i' , PRICE = 2900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912710 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912710, N'Pink Flower Sticker', N'sticker_007i', 2900, 1, 14, 0 ) END -- Item Name: Blue Flower Sticker -- Item ID: 947912711 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912711 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Flower Sticker' , ICON = N'sticker_008i' , PRICE = 2900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912711 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912711, N'Blue Flower Sticker', N'sticker_008i', 2900, 1, 14, 0 ) END -- Item Name: Victory Sticker -- Item ID: 947912712 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912712 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Victory Sticker' , ICON = N'sticker_009i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912712 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912712, N'Victory Sticker', N'sticker_009i', 4900, 1, 14, 0 ) END -- Item Name: Pang Bag Sticker -- Item ID: 947912713 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912713 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pang Bag Sticker' , ICON = N'sticker_010i' , PRICE = 3990 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912713 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912713, N'Pang Bag Sticker', N'sticker_010i', 3990, 1, 14, 0 ) END -- Item Name: Cat Bag Sticker -- Item ID: 947912714 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912714 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cat Bag Sticker' , ICON = N'sticker_011i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912714 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912714, N'Cat Bag Sticker', N'sticker_011i', 4900, 1, 14, 0 ) END -- Item Name: Black Bag Sticker -- Item ID: 947912715 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912715 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Bag Sticker' , ICON = N'sticker_012i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912715 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912715, N'Black Bag Sticker', N'sticker_012i', 4900, 1, 14, 0 ) END -- Item Name: Red Bag Sticker -- Item ID: 947912716 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912716 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Bag Sticker' , ICON = N'sticker_013i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912716 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912716, N'Red Bag Sticker', N'sticker_013i', 4900, 1, 14, 0 ) END -- Item Name: Santa Bag Sticker -- Item ID: 947912717 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912717 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Santa Bag Sticker' , ICON = N'sticker_014i' , PRICE = 4990 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912717 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912717, N'Santa Bag Sticker', N'sticker_014i', 4990, 1, 14, 0 ) END -- Item Name: Dolphini Sticker -- Item ID: 947912718 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912718 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini Sticker' , ICON = N'sticker_015i' , PRICE = 3900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912718 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912718, N'Dolphini Sticker', N'sticker_015i', 3900, 1, 14, 0 ) END -- Item Name: Titan Boo Sticker -- Item ID: 947912719 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912719 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Titan Boo Sticker' , ICON = N'sticker_016i' , PRICE = 6900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912719 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912719, N'Titan Boo Sticker', N'sticker_016i', 6900, 1, 14, 0 ) END -- Item Name: Tiki Sticker -- Item ID: 947912720 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912720 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tiki Sticker' , ICON = N'sticker_017i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912720 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912720, N'Tiki Sticker', N'sticker_017i', 4900, 1, 14, 0 ) END -- Item Name: Pippin Sticker -- Item ID: 947912721 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912721 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pippin Sticker' , ICON = N'sticker_018i' , PRICE = 3900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912721 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912721, N'Pippin Sticker', N'sticker_018i', 3900, 1, 14, 0 ) END -- Item Name: Lolo Sticker -- Item ID: 947912722 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912722 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lolo Sticker' , ICON = N'sticker_019i' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912722 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912722, N'Lolo Sticker', N'sticker_019i', 4900, 1, 14, 0 ) END -- Item Name: Cadie Sticker -- Item ID: 947912723 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912723 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cadie Sticker' , ICON = N'sticker_020i' , PRICE = 6900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912723 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912723, N'Cadie Sticker', N'sticker_020i', 6900, 1, 14, 0 ) END -- Item Name: Birthday Sticker -- Item ID: 947912724 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912724 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Birthday Sticker' , ICON = N'sticker_021i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912724 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912724, N'Birthday Sticker', N'sticker_021i', 10000000, 0, 14, 0 ) END -- Item Name: Valentineday Sticker1 -- Item ID: 947912725 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912725 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday Sticker1' , ICON = N'sticker_022i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912725 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912725, N'Valentineday Sticker1', N'sticker_022i', 10000000, 0, 14, 0 ) END -- Item Name: Valentineday Sticker2 -- Item ID: 947912726 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912726 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday Sticker2' , ICON = N'sticker_023i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912726 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912726, N'Valentineday Sticker2', N'sticker_023i', 10000000, 0, 14, 0 ) END -- Item Name: Sleeping Boo Sticker -- Item ID: 947912727 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912727 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sleeping Boo Sticker' , ICON = N'sticker_133i_jp' , PRICE = 5000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912727 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912727, N'Sleeping Boo Sticker', N'sticker_133i_jp', 5000, 0, 14, 0 ) END -- Item Name: Gauge Sticker -- Item ID: 947912728 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912728 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gauge Sticker' , ICON = N'sticker_137i_jp' , PRICE = 4900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912728 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912728, N'Gauge Sticker', N'sticker_137i_jp', 4900, 1, 14, 0 ) END -- Item Name: ???? ? ??? -- Item ID: 947912729 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912729 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???? ? ???' , ICON = N'sticker_25i_jp' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912729 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912729, N'???? ? ???', N'sticker_25i_jp', 10000000, 0, 14, 0 ) END -- Item Name: Give me choclate -- Item ID: 947912730 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912730 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Give me choclate' , ICON = N'sticker_26i_jp' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912730 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912730, N'Give me choclate', N'sticker_26i_jp', 10000000, 0, 14, 0 ) END -- Item Name: New Year Sticker -- Item ID: 947912832 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912832 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New Year Sticker' , ICON = N'sticker_128i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912832 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912832, N'New Year Sticker', N'sticker_128i', 10000000, 0, 14, 0 ) END -- Item Name: Tomahawk Hero(USA) -- Item ID: 947912852 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912852 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tomahawk Hero(USA)' , ICON = N'sticker_148i' , PRICE = 13 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912852 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912852, N'Tomahawk Hero(USA)', N'sticker_148i', 13, 1, 14, 0 ) END -- Item Name: King of Cobra(USA) -- Item ID: 947912853 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912853 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'King of Cobra(USA)' , ICON = N'sticker_149i' , PRICE = 13 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912853 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912853, N'King of Cobra(USA)', N'sticker_149i', 13, 1, 14, 0 ) END -- Item Name: Surfer's Delight(USA) -- Item ID: 947912854 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912854 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Surfer''s Delight(USA)' , ICON = N'sticker_150i' , PRICE = 13 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912854 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912854, N'Surfer''s Delight(USA)', N'sticker_150i', 13, 1, 14, 0 ) END -- Item Name: Philippine Flag(Ph) -- Item ID: 947912855 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912855 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Philippine Flag(Ph)' , ICON = N'sticker_151i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912855 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912855, N'Philippine Flag(Ph)', N'sticker_151i', 750, 1, 14, 0 ) END -- Item Name: Blue Eagle(PH) -- Item ID: 947912856 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912856 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Eagle(PH)' , ICON = N'sticker_152i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912856 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912856, N'Blue Eagle(PH)', N'sticker_152i', 750, 1, 14, 0 ) END -- Item Name: Green Archer(PH) -- Item ID: 947912857 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912857 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Archer(PH)' , ICON = N'sticker_153i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912857 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912857, N'Green Archer(PH)', N'sticker_153i', 750, 1, 14, 0 ) END -- Item Name: Yellow Tiger(PH) -- Item ID: 947912858 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912858 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Tiger(PH)' , ICON = N'sticker_154i' , PRICE = 750 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912858 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912858, N'Yellow Tiger(PH)', N'sticker_154i', 750, 1, 14, 0 ) END -- Item Name: Jasmin Flower -- Item ID: 947912859 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912859 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Jasmin Flower' , ICON = N'sticker_155i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912859 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912859, N'Jasmin Flower', N'sticker_155i', 10000000, 1, 14, 0 ) END -- Item Name: FFL Faith(PH) -- Item ID: 947912860 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912860 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'FFL Faith(PH)' , ICON = N'sticker_156i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912860 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912860, N'FFL Faith(PH)', N'sticker_156i', 10000000, 1, 14, 0 ) END -- Item Name: FFL Hope(PH) -- Item ID: 947912861 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912861 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'FFL Hope(PH)' , ICON = N'sticker_157i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912861 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912861, N'FFL Hope(PH)', N'sticker_157i', 10000000, 1, 14, 0 ) END -- Item Name: FFL Love(PH) -- Item ID: 947912862 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912862 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'FFL Love(PH)' , ICON = N'sticker_158i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912862 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912862, N'FFL Love(PH)', N'sticker_158i', 10000000, 1, 14, 0 ) END -- Item Name: Singapore Theme(SG) -- Item ID: 947912863 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912863 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Singapore Theme(SG)' , ICON = N'sticker_159i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912863 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912863, N'Singapore Theme(SG)', N'sticker_159i', 10000000, 1, 14, 0 ) END -- Item Name: Malaysia Theme(SG) -- Item ID: 947912864 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912864 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Malaysia Theme(SG)' , ICON = N'sticker_160i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912864 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912864, N'Malaysia Theme(SG)', N'sticker_160i', 10000000, 1, 14, 0 ) END -- Item Name: Blue Moon Sticker(PH) -- Item ID: 947912865 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912865 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Moon Sticker(PH)' , ICON = N'sticker_161i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912865 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912865, N'Blue Moon Sticker(PH)', N'sticker_161i', 10000000, 1, 14, 0 ) END -- Item Name: P2 Club Sticker(PH) -- Item ID: 947912866 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912866 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'P2 Club Sticker(PH)' , ICON = N'sticker_162i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912866 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912866, N'P2 Club Sticker(PH)', N'sticker_162i', 10000000, 1, 14, 0 ) END -- Item Name: WCG Sticker(PH) -- Item ID: 947912867 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912867 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'WCG Sticker(PH)' , ICON = N'sticker_163i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912867 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912867, N'WCG Sticker(PH)', N'sticker_163i', 10000000, 1, 14, 0 ) END -- Item Name: Bat Sticker(PH) -- Item ID: 947912868 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912868 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bat Sticker(PH)' , ICON = N'sticker_164i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912868 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912868, N'Bat Sticker(PH)', N'sticker_164i', 10000000, 1, 14, 0 ) END -- Item Name: Pumpkin Sticker(PH) -- Item ID: 947912869 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912869 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pumpkin Sticker(PH)' , ICON = N'sticker_165i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912869 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912869, N'Pumpkin Sticker(PH)', N'sticker_165i', 10000000, 1, 14, 0 ) END -- Item Name: Spider Sticker(PH) -- Item ID: 947912870 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912870 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spider Sticker(PH)' , ICON = N'sticker_166i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912870 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912870, N'Spider Sticker(PH)', N'sticker_166i', 10000000, 1, 14, 0 ) END -- Item Name: PH Master(PH) -- Item ID: 947912871 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912871 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PH Master(PH)' , ICON = N'sticker_167i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912871 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912871, N'PH Master(PH)', N'sticker_167i', 10000000, 1, 14, 0 ) END -- Item Name: New Year Sticker(SG) -- Item ID: 947912872 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912872 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New Year Sticker(SG)' , ICON = N'sticker_168i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912872 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912872, N'New Year Sticker(SG)', N'sticker_168i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912873 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912873 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912873 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912873, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912874 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912874 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912874 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912874, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912875 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912875 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912875 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912875, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912876 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912876 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912876 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912876, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912877 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912877 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912877 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912877, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912878 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912878 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912878 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912878, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912879 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912879 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912879 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912879, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912880 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912880 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912880 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912880, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912881 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912881 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_168i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912881 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912881, N'Guild Sticker(USA)??? ????', N'sticker_168i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912882 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912882 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912882 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912882, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912883 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912883 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912883 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912883, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912884 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912884 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912884 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912884, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912885 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912885 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912885 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912885, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912886 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912886 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912886 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912886, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912887 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912887 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912887 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912887, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912888 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912888 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912888 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912888, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912889 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912889 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912889 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912889, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912890 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912890 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912890 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912890, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912891 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912891 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912891 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912891, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912892 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912892 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912892 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912892, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912893 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912893 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912893 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912893, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912894 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912894 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912894 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912894, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912895 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912895 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912895 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912895, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912896 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912896 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912896 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912896, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912897 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912897 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912897 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912897, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912898 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912898 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912898 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912898, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912899 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912899 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912899 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912899, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Guild Sticker(USA)??? ???? -- Item ID: 947912900 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912900 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Guild Sticker(USA)??? ????' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912900 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912900, N'Guild Sticker(USA)??? ????', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: TUFF_GL -- Item ID: 947912901 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912901 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'TUFF_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912901 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912901, N'TUFF_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: DemonsOfPangya_GL -- Item ID: 947912902 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912902 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'DemonsOfPangya_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912902 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912902, N'DemonsOfPangya_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: PangyaClub_GL -- Item ID: 947912903 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912903 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangyaClub_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912903 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912903, N'PangyaClub_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: WAFCCLAN_GL -- Item ID: 947912904 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912904 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'WAFCCLAN_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912904 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912904, N'WAFCCLAN_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: FIE_GL -- Item ID: 947912905 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912905 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'FIE_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912905 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912905, N'FIE_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: InsaneGolfers_GL -- Item ID: 947912906 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912906 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'InsaneGolfers_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912906 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912906, N'InsaneGolfers_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: AmericanEagles_GL -- Item ID: 947912907 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912907 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'AmericanEagles_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912907 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912907, N'AmericanEagles_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Norway_GL -- Item ID: 947912908 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912908 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Norway_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912908 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912908, N'Norway_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: GALS_GL -- Item ID: 947912909 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912909 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'GALS_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912909 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912909, N'GALS_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: OriginalGamers_GL -- Item ID: 947912910 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912910 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'OriginalGamers_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912910 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912910, N'OriginalGamers_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Ebichu_GL -- Item ID: 947912911 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912911 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Ebichu_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912911 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912911, N'Ebichu_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: IronEagles2_GL -- Item ID: 947912912 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912912 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IronEagles2_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912912 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912912, N'IronEagles2_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Diabolique_GL -- Item ID: 947912913 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912913 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Diabolique_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912913 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912913, N'Diabolique_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Nippon_GL -- Item ID: 947912914 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 947912914 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nippon_GL' , ICON = N'sticker_169i' , PRICE = 10000000 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 947912914 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 947912914, N'Nippon_GL', N'sticker_169i', 10000000, 1, 14, 0 ) END -- Item Name: Blue Sky Slot -- Item ID: 952107008 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107008 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Sky Slot' , ICON = N'slot_001i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107008 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107008, N'Blue Sky Slot', N'slot_001i', 1200, 1, 14, 0 ) END -- Item Name: Biscuit Slot -- Item ID: 952107009 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107009 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Biscuit Slot' , ICON = N'slot_002i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107009 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107009, N'Biscuit Slot', N'slot_002i', 1200, 1, 14, 0 ) END -- Item Name: Spade Slot -- Item ID: 952107010 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107010 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spade Slot' , ICON = N'slot_003i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107010 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107010, N'Spade Slot', N'slot_003i', 1200, 1, 14, 0 ) END -- Item Name: Club Slot -- Item ID: 952107011 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107011 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Club Slot' , ICON = N'slot_004i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107011 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107011, N'Club Slot', N'slot_004i', 1200, 1, 14, 0 ) END -- Item Name: Heart Slot -- Item ID: 952107012 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107012 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Heart Slot' , ICON = N'slot_005i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107012 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107012, N'Heart Slot', N'slot_005i', 1200, 1, 14, 0 ) END -- Item Name: Pink Bag Slot -- Item ID: 952107013 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107013 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Bag Slot' , ICON = N'slot_006i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107013 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107013, N'Pink Bag Slot', N'slot_006i', 1200, 1, 14, 0 ) END -- Item Name: Blue Bag Slot -- Item ID: 952107014 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107014 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Bag Slot' , ICON = N'slot_007i' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107014 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107014, N'Blue Bag Slot', N'slot_007i', 1200, 1, 14, 0 ) END -- Item Name: Green Bag Slot -- Item ID: 952107015 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107015 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Bag Slot' , ICON = N'slot_008i' , PRICE = 5000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107015 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107015, N'Green Bag Slot', N'slot_008i', 5000, 0, 14, 0 ) END -- Item Name: Valentineday Slot1 -- Item ID: 952107016 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107016 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday Slot1' , ICON = N'slot_009i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107016 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107016, N'Valentineday Slot1', N'slot_009i', 10000000, 0, 14, 0 ) END -- Item Name: Valentineday Slot2 -- Item ID: 952107017 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107017 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Valentineday Slot2' , ICON = N'slot_010i' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107017 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107017, N'Valentineday Slot2', N'slot_010i', 10000000, 0, 14, 0 ) END -- Item Name: Sleeping Boo Slot -- Item ID: 952107018 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107018 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sleeping Boo Slot' , ICON = N'slot_129i_jp' , PRICE = 2900 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107018 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107018, N'Sleeping Boo Slot', N'slot_129i_jp', 2900, 1, 14, 0 ) END -- Item Name: Dolphini2000 Slot -- Item ID: 952107019 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107019 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Dolphini2000 Slot' , ICON = N'slot_131i_jp' , PRICE = 8000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107019 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107019, N'Dolphini2000 Slot', N'slot_131i_jp', 8000, 0, 14, 0 ) END -- Item Name: Blue Pang Bag Slot -- Item ID: 952107136 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107136 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Pang Bag Slot' , ICON = N'slot_128i_th' , PRICE = 1000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107136 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107136, N'Blue Pang Bag Slot', N'slot_128i_th', 1000, 0, 14, 0 ) END -- Item Name: Snapy2000 Slot -- Item ID: 952107137 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107137 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snapy2000 Slot' , ICON = N'slot_129i_th' , PRICE = 1200 , ISCASH = 1 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107137 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107137, N'Snapy2000 Slot', N'slot_129i_th', 1200, 1, 14, 0 ) END -- Item Name: Friendly Warning(USA) -- Item ID: 952107138 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107138 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Friendly Warning(USA)' , ICON = N'slot_130i' , PRICE = 13 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107138 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107138, N'Friendly Warning(USA)', N'slot_130i', 13, 0, 14, 0 ) END -- Item Name: Rhymes With Orange(USA) -- Item ID: 952107139 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107139 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rhymes With Orange(USA)' , ICON = N'slot_131i' , PRICE = 13 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107139 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107139, N'Rhymes With Orange(USA)', N'slot_131i', 13, 0, 14, 0 ) END -- Item Name: Blue Eagle(PH) -- Item ID: 952107140 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107140 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Eagle(PH)' , ICON = N'slot_132i' , PRICE = 750 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107140 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107140, N'Blue Eagle(PH)', N'slot_132i', 750, 0, 14, 0 ) END -- Item Name: Green Archer(PH) -- Item ID: 952107141 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107141 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Archer(PH)' , ICON = N'slot_133i' , PRICE = 750 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107141 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107141, N'Green Archer(PH)', N'slot_133i', 750, 0, 14, 0 ) END -- Item Name: Yellow Tiger(PH) -- Item ID: 952107142 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107142 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow Tiger(PH)' , ICON = N'slot_134i' , PRICE = 750 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107142 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107142, N'Yellow Tiger(PH)', N'slot_134i', 750, 0, 14, 0 ) END -- Item Name: New Year Slot(SG) -- Item ID: 952107143 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 952107143 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New Year Slot(SG)' , ICON = N'slot_135i' , PRICE = 750 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 952107143 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 952107143, N'New Year Slot(SG)', N'slot_135i', 750, 0, 14, 0 ) END -- Item Name: Power Shot I (Nuri) -- Item ID: 960495616 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495616 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Nuri)' , ICON = N'icon_cutin_001m' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495616 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495616, N'Power Shot I (Nuri)', N'icon_cutin_001m', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Hana) -- Item ID: 960495617 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495617 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Hana)' , ICON = N'icon_cutin_001f' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495617 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495617, N'Power Shot I (Hana)', N'icon_cutin_001f', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Cesillia) -- Item ID: 960495618 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495618 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Cesillia)' , ICON = N'icon_cutin_001c' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495618 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495618, N'Power Shot I (Cesillia)', N'icon_cutin_001c', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Kooh) -- Item ID: 960495619 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495619 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Kooh)' , ICON = N'icon_cutin_001k' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495619 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495619, N'Power Shot I (Kooh)', N'icon_cutin_001k', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Arin) -- Item ID: 960495620 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495620 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Arin)' , ICON = N'icon_cutin_001g' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495620 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495620, N'Power Shot I (Arin)', N'icon_cutin_001g', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Kaz) -- Item ID: 960495621 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495621 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Kaz)' , ICON = N'icon_cutin_001h' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495621 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495621, N'Power Shot I (Kaz)', N'icon_cutin_001h', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Lucia) -- Item ID: 960495622 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495622 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Lucia)' , ICON = N'icon_cutin_001i' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495622 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495622, N'Power Shot I (Lucia)', N'icon_cutin_001i', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Max) -- Item ID: 960495623 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495623 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Max)' , ICON = N'icon_cutin_001d' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495623 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495623, N'Power Shot I (Max)', N'icon_cutin_001d', 30000, 0, 14, 0 ) END -- Item Name: Power Shot I (Arthur) -- Item ID: 960495624 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 960495624 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Shot I (Arthur)' , ICON = N'icon_cutin_001a' , PRICE = 30000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 960495624 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 960495624, N'Power Shot I (Arthur)', N'icon_cutin_001a', 30000, 0, 14, 0 ) END -- Item Name: OnGameNet -- Item ID: 964689921 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689921 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'OnGameNet' , ICON = N'title_001' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689921 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689921, N'OnGameNet', N'title_001', 10000000, 0, 14, 0 ) END -- Item Name: OnGameNet -- Item ID: 964689922 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689922 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'OnGameNet' , ICON = N'title_002' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689922 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689922, N'OnGameNet', N'title_002', 10000000, 0, 14, 0 ) END -- Item Name: WCG 2003 -- Item ID: 964689923 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689923 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'WCG 2003' , ICON = N'title_003' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689923 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689923, N'WCG 2003', N'title_003', 10000000, 0, 14, 0 ) END -- Item Name: WCG 2004 -- Item ID: 964689924 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689924 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'WCG 2004' , ICON = N'title_004' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689924 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689924, N'WCG 2004', N'title_004', 10000000, 0, 14, 0 ) END -- Item Name: NetCaf? -- Item ID: 964689925 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689925 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'NetCaf?' , ICON = N'title_005' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689925 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689925, N'NetCaf?', N'title_005', 10000000, 0, 14, 0 ) END -- Item Name: Captain -- Item ID: 964689926 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689926 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Captain' , ICON = N'title_006' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689926 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689926, N'Captain', N'title_006', 10000000, 0, 14, 0 ) END -- Item Name: Officer -- Item ID: 964689927 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689927 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Officer' , ICON = N'title_007' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689927 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689927, N'Officer', N'title_007', 10000000, 0, 14, 0 ) END -- Item Name: MC -- Item ID: 964689928 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689928 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'MC' , ICON = N'title_008' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689928 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689928, N'MC', N'title_008', 10000000, 0, 14, 0 ) END -- Item Name: GM -- Item ID: 964689929 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689929 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'GM' , ICON = N'title_009' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689929 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689929, N'GM', N'title_009', 10000000, 0, 14, 0 ) END -- Item Name: PJC_SILVER(JPN) -- Item ID: 964689930 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689930 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PJC_SILVER(JPN)' , ICON = N'title_010' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689930 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689930, N'PJC_SILVER(JPN)', N'title_010', 10000000, 0, 14, 0 ) END -- Item Name: PJC_BRONZE(JPN) -- Item ID: 964689931 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689931 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PJC_BRONZE(JPN)' , ICON = N'title_011' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689931 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689931, N'PJC_BRONZE(JPN)', N'title_011', 10000000, 0, 14, 0 ) END -- Item Name: PJC_NORMAL(JPN) -- Item ID: 964689932 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689932 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PJC_NORMAL(JPN)' , ICON = N'title_012' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689932 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689932, N'PJC_NORMAL(JPN)', N'title_012', 10000000, 0, 14, 0 ) END -- Item Name: Seed_PJC(JPN) -- Item ID: 964689933 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689933 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Seed_PJC(JPN)' , ICON = N'title_013' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689933 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689933, N'Seed_PJC(JPN)', N'title_013', 10000000, 0, 14, 0 ) END -- Item Name: WishPass -- Item ID: 964689934 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689934 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'WishPass' , ICON = N'title_014' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689934 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689934, N'WishPass', N'title_014', 10000000, 0, 14, 0 ) END -- Item Name: Rookie -- Item ID: 964689935 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689935 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rookie' , ICON = N'title_015' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689935 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689935, N'Rookie', N'title_015', 10000000, 0, 14, 0 ) END -- Item Name: Frontier Gold -- Item ID: 964689936 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689936 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Frontier Gold' , ICON = N'title_016' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689936 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689936, N'Frontier Gold', N'title_016', 10000000, 0, 14, 0 ) END -- Item Name: Frontier Silver -- Item ID: 964689937 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689937 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Frontier Silver' , ICON = N'title_017' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689937 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689937, N'Frontier Silver', N'title_017', 10000000, 0, 14, 0 ) END -- Item Name: Frontier -- Item ID: 964689938 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689938 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Frontier' , ICON = N'title_018' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689938 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689938, N'Frontier', N'title_018', 10000000, 0, 14, 0 ) END -- Item Name: Frontier Platinum -- Item ID: 964689939 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689939 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Frontier Platinum' , ICON = N'title_019' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689939 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689939, N'Frontier Platinum', N'title_019', 10000000, 0, 14, 0 ) END -- Item Name: ???? -- Item ID: 964689940 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689940 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????' , ICON = N'title_020' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689940 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689940, N'????', N'title_020', 10000000, 0, 14, 0 ) END -- Item Name: Pangya Shot(Bronze) -- Item ID: 964689941 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689941 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Shot(Bronze)' , ICON = N'title_021' , PRICE = 50000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689941 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689941, N'Pangya Shot(Bronze)', N'title_021', 50000, 0, 14, 0 ) END -- Item Name: FairWay (Bronze) -- Item ID: 964689942 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689942 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'FairWay (Bronze)' , ICON = N'title_022' , PRICE = 50000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689942 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689942, N'FairWay (Bronze)', N'title_022', 50000, 0, 14, 0 ) END -- Item Name: Green Master (Bronze) -- Item ID: 964689943 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689943 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Green Master (Bronze)' , ICON = N'title_023' , PRICE = 50000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689943 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689943, N'Green Master (Bronze)', N'title_023', 50000, 0, 14, 0 ) END -- Item Name: GOLD -- Item ID: 964689945 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689945 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'GOLD' , ICON = N'title_025' , PRICE = 100000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689945 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689945, N'GOLD', N'title_025', 100000, 0, 14, 0 ) END -- Item Name: SILVER -- Item ID: 964689946 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689946 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'SILVER' , ICON = N'title_026' , PRICE = 50000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689946 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689946, N'SILVER', N'title_026', 50000, 0, 14, 0 ) END -- Item Name: BRONZE -- Item ID: 964689947 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689947 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'BRONZE' , ICON = N'title_027' , PRICE = 10000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689947 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689947, N'BRONZE', N'title_027', 10000, 0, 14, 0 ) END -- Item Name: Manner Angle (Bronze) -- Item ID: 964689948 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689948 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Manner Angle (Bronze)' , ICON = N'title_028' , PRICE = 10000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689948 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689948, N'Manner Angle (Bronze)', N'title_028', 10000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Kooh) -- Item ID: 964689950 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689950 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Kooh)' , ICON = N'title_030' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689950 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689950, N'Happy Birthday(Kooh)', N'title_030', 1000000, 0, 14, 0 ) END -- Item Name: We love Thai -- Item ID: 964689954 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689954 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'We love Thai' , ICON = N'title_034' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689954 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689954, N'We love Thai', N'title_034', 1000000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Hana) -- Item ID: 964689956 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689956 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Hana)' , ICON = N'title_036' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689956 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689956, N'Happy Birthday(Hana)', N'title_036', 1000000, 0, 14, 0 ) END -- Item Name: 5th Anniversary Title -- Item ID: 964689957 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964689957 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5th Anniversary Title' , ICON = N'title_037' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964689957 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964689957, N'5th Anniversary Title', N'title_037', 1000000, 0, 14, 0 ) END -- Item Name: LadderExpert -- Item ID: 964690020 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690020 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'LadderExpert' , ICON = N'title_100' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690020 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690020, N'LadderExpert', N'title_100', 1000000, 0, 14, 0 ) END -- Item Name: PGC -- Item ID: 964690021 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690021 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PGC' , ICON = N'title_101' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690021 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690021, N'PGC', N'title_101', 1000000, 0, 14, 0 ) END -- Item Name: IPCT(IDNE) -- Item ID: 964690022 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690022 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'IPCT(IDNE)' , ICON = N'title_102' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690022 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690022, N'IPCT(IDNE)', N'title_102', 1000000, 0, 14, 0 ) END -- Item Name: VIP -- Item ID: 964690023 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690023 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'VIP' , ICON = N'title_103' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690023 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690023, N'VIP', N'title_103', 1000000, 0, 14, 0 ) END -- Item Name: New VIP -- Item ID: 964690024 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690024 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'New VIP' , ICON = N'title_104' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690024 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690024, N'New VIP', N'title_104', 1000000, 0, 14, 0 ) END -- Item Name: Goal post -- Item ID: 964690096 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690096 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Goal post' , ICON = N'title_176' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690096 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690096, N'Goal post', N'title_176', 1000000, 0, 14, 0 ) END -- Item Name: Yellow card -- Item ID: 964690097 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690097 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Yellow card' , ICON = N'title_177' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690097 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690097, N'Yellow card', N'title_177', 1000000, 0, 14, 0 ) END -- Item Name: Red card -- Item ID: 964690098 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690098 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red card' , ICON = N'title_178' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690098 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690098, N'Red card', N'title_178', 1000000, 0, 14, 0 ) END -- Item Name: Soccer -- Item ID: 964690099 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690099 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Soccer' , ICON = N'title_179' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690099 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690099, N'Soccer', N'title_179', 1000000, 0, 14, 0 ) END -- Item Name: Golden Goal -- Item ID: 964690100 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690100 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Golden Goal' , ICON = N'title_180' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690100 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690100, N'Golden Goal', N'title_180', 1000000, 0, 14, 0 ) END -- Item Name: Winner -- Item ID: 964690103 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690103 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Winner' , ICON = N'title_183' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690103 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690103, N'Winner', N'title_183', 1000000, 0, 14, 0 ) END -- Item Name: Goal Hand -- Item ID: 964690104 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690104 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Goal Hand' , ICON = N'title_184' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690104 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690104, N'Goal Hand', N'title_184', 1000000, 0, 14, 0 ) END -- Item Name: Soccer field -- Item ID: 964690105 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690105 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Soccer field' , ICON = N'title_185' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690105 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690105, N'Soccer field', N'title_185', 1000000, 0, 14, 0 ) END -- Item Name: 2010 Title -- Item ID: 964690106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2010 Title' , ICON = N'title_186' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690106, N'2010 Title', N'title_186', 1000000, 0, 14, 0 ) END -- Item Name: Out of Goal -- Item ID: 964690107 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690107 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Out of Goal' , ICON = N'title_187' , PRICE = 1000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690107 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690107, N'Out of Goal', N'title_187', 1000000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Cecillia) -- Item ID: 964690108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Cecillia)' , ICON = N'title_188' , PRICE = 27000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690108, N'Happy Birthday(Cecillia)', N'title_188', 27000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Lucia) -- Item ID: 964690109 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690109 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Lucia)' , ICON = N'title_189' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690109 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690109, N'Happy Birthday(Lucia)', N'title_189', 10000000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Nuri) -- Item ID: 964690174 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690174 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Nuri)' , ICON = N'title_254' , PRICE = 27000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690174 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690174, N'Happy Birthday(Nuri)', N'title_254', 27000, 0, 14, 0 ) END -- Item Name: PWC Tile -- Item ID: 964690177 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690177 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PWC Tile' , ICON = N'title_257' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690177 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690177, N'PWC Tile', N'title_257', 10000000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Arin) -- Item ID: 964690182 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690182 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Arin)' , ICON = N'title_262' , PRICE = 11000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690182 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690182, N'Happy Birthday(Arin)', N'title_262', 11000, 0, 14, 0 ) END -- Item Name: Arthur Birthday Title -- Item ID: 964690183 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690183 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur Birthday Title' , ICON = N'title_263' , PRICE = 27000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690183 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690183, N'Arthur Birthday Title', N'title_263', 27000, 0, 14, 0 ) END -- Item Name: Together Love Dad Title -- Item ID: 964690184 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690184 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Together Love Dad Title' , ICON = N'title_264' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690184 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690184, N'Together Love Dad Title', N'title_264', 10000000, 0, 14, 0 ) END -- Item Name: Happy Birthday(Kaz) -- Item ID: 964690185 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690185 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Happy Birthday(Kaz)' , ICON = N'title_265' , PRICE = 20100 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690185 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690185, N'Happy Birthday(Kaz)', N'title_265', 20100, 0, 14, 0 ) END -- Item Name: Thailand Title -- Item ID: 964690209 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690209 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Thailand Title' , ICON = N'title_289' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690209 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690209, N'Thailand Title', N'title_289', 10000000, 0, 14, 0 ) END -- Item Name: Lider Title Teste -- Item ID: 964690210 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690210 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lider Title Teste' , ICON = N'title_290' , PRICE = 10000000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690210 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690210, N'Lider Title Teste', N'title_290', 10000000, 0, 14, 0 ) END -- Item Name: Tag Extra PBR -- Item ID: 964690211 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690211 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tag Extra PBR' , ICON = N'title_291' , PRICE = 50000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690211 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690211, N'Tag Extra PBR', N'title_291', 50000, 0, 14, 0 ) END -- Item Name: Tag Extra PBR2 -- Item ID: 964690212 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 964690212 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tag Extra PBR2' , ICON = N'title_292' , PRICE = 50000 , ISCASH = 0 , TYPE = 14 , IS_SALABLE = 0 WHERE TYPEID = 964690212 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 964690212, N'Tag Extra PBR2', N'title_292', 50000, 0, 14, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia