-- ----------------------------------------------- -- -- 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 "Caddieitem.iff" -- -- Last update of the IFF: 2022-02-16 01:28:49 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Caddieitem.iff contains 57 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Scribble Pang Bag -- Item ID: 536879105 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 536879105 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Scribble Pang Bag' , ICON = N'caddie_00_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 536879105 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 536879105, N'Scribble Pang Bag', N'caddie_00_01', 900, 1, 8, 0 ) END -- Item Name: White Pang Bag -- Item ID: 536879106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 536879106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Pang Bag' , ICON = N'caddie_00_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 536879106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 536879106, N'White Pang Bag', N'caddie_00_02', 900, 1, 8, 0 ) END -- Item Name: Fatty Pang Bag -- Item ID: 536879107 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 536879107 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fatty Pang Bag' , ICON = N'caddie_00_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 536879107 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 536879107, N'Fatty Pang Bag', N'caddie_00_03', 900, 1, 8, 0 ) END -- Item Name: XMas Bondari -- Item ID: 536879108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 536879108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'XMas Bondari' , ICON = N'caddie_00_05' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 536879108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 536879108, N'XMas Bondari', N'caddie_00_05', 900, 1, 8, 0 ) END -- Item Name: BlueStar -- Item ID: 538968065 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 538968065 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'BlueStar' , ICON = N'caddie_01_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 538968065 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 538968065, N'BlueStar', N'caddie_01_01', 900, 1, 8, 0 ) END -- Item Name: Black Wing Dress -- Item ID: 538968066 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 538968066 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wing Dress' , ICON = N'caddie_01_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 538968066 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 538968066, N'Black Wing Dress', N'caddie_01_02', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Pippin) -- Item ID: 538992643 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 538992643 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Pippin)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 538992643 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 538992643, N'Caddie Upgrade(Pippin)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Ivory Sweater -- Item ID: 541073409 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 541073409 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Ivory Sweater' , ICON = N'caddie_02_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 541073409 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 541073409, N'Ivory Sweater', N'caddie_02_01', 900, 1, 8, 0 ) END -- Item Name: Ribera Scarf -- Item ID: 541073410 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 541073410 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Ribera Scarf' , ICON = N'caddie_02_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 541073410 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 541073410, N'Ribera Scarf', N'caddie_02_02', 900, 1, 8, 0 ) END -- Item Name: Redstripes Vest -- Item ID: 541073411 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 541073411 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Redstripes Vest' , ICON = N'caddie_02_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 541073411 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 541073411, N'Redstripes Vest', N'caddie_02_03', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Titan Boo) -- Item ID: 541089796 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 541089796 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Titan Boo)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 541089796 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 541089796, N'Caddie Upgrade(Titan Boo)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Cherry Dolphini -- Item ID: 543170561 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 543170561 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cherry Dolphini' , ICON = N'caddie_03_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 543170561 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 543170561, N'Cherry Dolphini', N'caddie_03_01', 900, 1, 8, 0 ) END -- Item Name: Crow Dolphini -- Item ID: 543170562 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 543170562 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crow Dolphini' , ICON = N'caddie_03_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 543170562 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 543170562, N'Crow Dolphini', N'caddie_03_02', 900, 1, 8, 0 ) END -- Item Name: Panda Dolphini -- Item ID: 543170563 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 543170563 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Panda Dolphini' , ICON = N'caddie_03_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 543170563 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 543170563, N'Panda Dolphini', N'caddie_03_03', 900, 1, 8, 0 ) END -- Item Name: Skullphini -- Item ID: 543170564 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 543170564 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Skullphini' , ICON = N'caddie_03_04' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 543170564 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 543170564, N'Skullphini', N'caddie_03_04', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Dolphini) -- Item ID: 543186948 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 543186948 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Dolphini)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 543186948 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 543186948, N'Caddie Upgrade(Dolphini)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Close Chest -- Item ID: 545259521 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 545259521 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Close Chest' , ICON = N'caddie_04_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 545259521 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 545259521, N'Close Chest', N'caddie_04_01', 900, 1, 8, 0 ) END -- Item Name: Crystal Dress -- Item ID: 545259522 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 545259522 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crystal Dress' , ICON = N'caddie_04_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 545259522 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 545259522, N'Crystal Dress', N'caddie_04_02', 900, 1, 8, 0 ) END -- Item Name: Crow Lolo -- Item ID: 545259523 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 545259523 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crow Lolo' , ICON = N'caddie_04_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 545259523 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 545259523, N'Crow Lolo', N'caddie_04_03', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Lolo) -- Item ID: 545284100 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 545284100 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Lolo)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 545284100 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 545284100, N'Caddie Upgrade(Lolo)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Feast Band -- Item ID: 547356673 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 547356673 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Feast Band' , ICON = N'caddie_05_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 547356673 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 547356673, N'Feast Band', N'caddie_05_01', 900, 1, 8, 0 ) END -- Item Name: Desert Band -- Item ID: 547356674 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 547356674 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Desert Band' , ICON = N'caddie_05_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 547356674 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 547356674, N'Desert Band', N'caddie_05_02', 900, 1, 8, 0 ) END -- Item Name: Jungle Band -- Item ID: 547356675 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 547356675 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Jungle Band' , ICON = N'caddie_05_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 547356675 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 547356675, N'Jungle Band', N'caddie_05_03', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Kuma) -- Item ID: 547381252 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 547381252 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Kuma)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 547381252 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 547381252, N'Caddie Upgrade(Kuma)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Japan Clothes -- Item ID: 549453825 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 549453825 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Japan Clothes' , ICON = N'caddie_06_01' , PRICE = 1000000 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 549453825 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 549453825, N'Japan Clothes', N'caddie_06_01', 1000000, 0, 8, 0 ) END -- Item Name: Pink Clothes -- Item ID: 549453826 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 549453826 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Clothes' , ICON = N'caddie_06_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 549453826 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 549453826, N'Pink Clothes', N'caddie_06_02', 900, 1, 8, 0 ) END -- Item Name: Sailor Dress -- Item ID: 549453827 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 549453827 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sailor Dress' , ICON = N'caddie_06_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 549453827 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 549453827, N'Sailor Dress', N'caddie_06_03', 900, 1, 8, 0 ) END -- Item Name: Sepia Clothes -- Item ID: 549453828 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 549453828 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sepia Clothes' , ICON = N'caddie_06_04' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 549453828 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 549453828, N'Sepia Clothes', N'caddie_06_04', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Tiki) -- Item ID: 549478405 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 549478405 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Tiki)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 549478405 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 549478405, N'Caddie Upgrade(Tiki)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Blue Hat -- Item ID: 551550977 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 551550977 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Hat' , ICON = N'caddie_07_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 551550977 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 551550977, N'Blue Hat', N'caddie_07_01', 900, 1, 8, 0 ) END -- Item Name: BlaceLace Hat -- Item ID: 551550978 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 551550978 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'BlaceLace Hat' , ICON = N'caddie_07_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 551550978 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 551550978, N'BlaceLace Hat', N'caddie_07_02', 900, 1, 8, 0 ) END -- Item Name: Tuxedo Hat -- Item ID: 551550979 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 551550979 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tuxedo Hat' , ICON = N'caddie_07_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 551550979 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 551550979, N'Tuxedo Hat', N'caddie_07_03', 900, 1, 8, 0 ) END -- Item Name: Caddie Upgrade(Cadie) -- Item ID: 551575556 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 551575556 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Caddie Upgrade(Cadie)' , ICON = N'caddie_upgrade_icon' , PRICE = 0 , ISCASH = 0 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 551575556 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 551575556, N'Caddie Upgrade(Cadie)', N'caddie_upgrade_icon', 0, 0, 8, 0 ) END -- Item Name: Magenta Winkle -- Item ID: 559939585 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 559939585 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Magenta Winkle' , ICON = N'caddie_11_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 559939585 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 559939585, N'Magenta Winkle', N'caddie_11_01', 900, 1, 8, 0 ) END -- Item Name: BlueStar(G) -- Item ID: 570425345 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 570425345 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'BlueStar(G)' , ICON = N'caddie_01_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 570425345 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 570425345, N'BlueStar(G)', N'caddie_01_01', 900, 1, 8, 0 ) END -- Item Name: Black Wing Dress(G) -- Item ID: 570425346 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 570425346 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Wing Dress(G)' , ICON = N'caddie_01_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 570425346 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 570425346, N'Black Wing Dress(G)', N'caddie_01_02', 900, 1, 8, 0 ) END -- Item Name: Ivory Sweater(G) -- Item ID: 572530689 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 572530689 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Ivory Sweater(G)' , ICON = N'caddie_02_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 572530689 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 572530689, N'Ivory Sweater(G)', N'caddie_02_01', 900, 1, 8, 0 ) END -- Item Name: Ribera Scarf(G) -- Item ID: 572530690 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 572530690 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Ribera Scarf(G)' , ICON = N'caddie_02_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 572530690 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 572530690, N'Ribera Scarf(G)', N'caddie_02_02', 900, 1, 8, 0 ) END -- Item Name: Redstripes Vest(G) -- Item ID: 572530691 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 572530691 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Redstripes Vest(G)' , ICON = N'caddie_02_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 572530691 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 572530691, N'Redstripes Vest(G)', N'caddie_02_03', 900, 1, 8, 0 ) END -- Item Name: Cherry Dolphini(G) -- Item ID: 574627841 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 574627841 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cherry Dolphini(G)' , ICON = N'caddie_03_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 574627841 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 574627841, N'Cherry Dolphini(G)', N'caddie_03_01', 900, 1, 8, 0 ) END -- Item Name: Crow Dolphini(G) -- Item ID: 574627842 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 574627842 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crow Dolphini(G)' , ICON = N'caddie_03_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 574627842 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 574627842, N'Crow Dolphini(G)', N'caddie_03_02', 900, 1, 8, 0 ) END -- Item Name: Panda Dolphini(G) -- Item ID: 574627843 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 574627843 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Panda Dolphini(G)' , ICON = N'caddie_03_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 574627843 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 574627843, N'Panda Dolphini(G)', N'caddie_03_03', 900, 1, 8, 0 ) END -- Item Name: Close Chest(G) -- Item ID: 576716801 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 576716801 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Close Chest(G)' , ICON = N'caddie_04_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 576716801 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 576716801, N'Close Chest(G)', N'caddie_04_01', 900, 1, 8, 0 ) END -- Item Name: Crystal Dress(G) -- Item ID: 576716802 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 576716802 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crystal Dress(G)' , ICON = N'caddie_04_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 576716802 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 576716802, N'Crystal Dress(G)', N'caddie_04_02', 900, 1, 8, 0 ) END -- Item Name: Crow Lolo(G) -- Item ID: 576716803 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 576716803 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crow Lolo(G)' , ICON = N'caddie_04_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 576716803 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 576716803, N'Crow Lolo(G)', N'caddie_04_03', 900, 1, 8, 0 ) END -- Item Name: Feast Band(G) -- Item ID: 578813953 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 578813953 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Feast Band(G)' , ICON = N'caddie_05_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 578813953 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 578813953, N'Feast Band(G)', N'caddie_05_01', 900, 1, 8, 0 ) END -- Item Name: Desert Band(G) -- Item ID: 578813954 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 578813954 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Desert Band(G)' , ICON = N'caddie_05_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 578813954 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 578813954, N'Desert Band(G)', N'caddie_05_02', 900, 1, 8, 0 ) END -- Item Name: Jungle Band(G) -- Item ID: 578813955 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 578813955 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Jungle Band(G)' , ICON = N'caddie_05_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 578813955 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 578813955, N'Jungle Band(G)', N'caddie_05_03', 900, 1, 8, 0 ) END -- Item Name: Pink Clothes(G) -- Item ID: 580911106 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 580911106 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pink Clothes(G)' , ICON = N'caddie_06_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 580911106 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 580911106, N'Pink Clothes(G)', N'caddie_06_02', 900, 1, 8, 0 ) END -- Item Name: Sailor Dress(G) -- Item ID: 580911107 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 580911107 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sailor Dress(G)' , ICON = N'caddie_06_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 580911107 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 580911107, N'Sailor Dress(G)', N'caddie_06_03', 900, 1, 8, 0 ) END -- Item Name: Sepia Clothes(G) -- Item ID: 580911108 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 580911108 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sepia Clothes(G)' , ICON = N'caddie_06_04' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 580911108 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 580911108, N'Sepia Clothes(G)', N'caddie_06_04', 900, 1, 8, 0 ) END -- Item Name: Blue Hat(G) -- Item ID: 583008257 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 583008257 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Hat(G)' , ICON = N'caddie_07_01' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 583008257 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 583008257, N'Blue Hat(G)', N'caddie_07_01', 900, 1, 8, 0 ) END -- Item Name: BlaceLace Hat(G) -- Item ID: 583008258 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 583008258 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'BlaceLace Hat(G)' , ICON = N'caddie_07_02' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 583008258 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 583008258, N'BlaceLace Hat(G)', N'caddie_07_02', 900, 1, 8, 0 ) END -- Item Name: Tuxedo Hat(G) -- Item ID: 583008259 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 583008259 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tuxedo Hat(G)' , ICON = N'caddie_07_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 583008259 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 583008259, N'Tuxedo Hat(G)', N'caddie_07_03', 900, 1, 8, 0 ) END -- Item Name: Christmas Minty -- Item ID: 591396865 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 591396865 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Christmas Minty' , ICON = N'caddie_06_05' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 591396865 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 591396865, N'Christmas Minty', N'caddie_06_05', 900, 1, 8, 0 ) END -- Item Name: Peppermint Boo -- Item ID: 591396866 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 591396866 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Peppermint Boo' , ICON = N'caddie_02_03' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 591396866 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 591396866, N'Peppermint Boo', N'caddie_02_03', 900, 1, 8, 0 ) END -- Item Name: Bogo Legend (24k) -- Item ID: 599785473 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 599785473 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Legend (24k)' , ICON = N'Caddie_Bon_011' , PRICE = 900 , ISCASH = 1 , TYPE = 8 , IS_SALABLE = 0 WHERE TYPEID = 599785473 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 599785473, N'Bogo Legend (24k)', N'Caddie_Bon_011', 900, 1, 8, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia