-- ----------------------------------------------- -- -- 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 "Mascot.iff" -- -- Last update of the IFF: 2022-02-16 01:28:50 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Mascot.iff contains 23 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Rami -- Item ID: 1073741824 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741824 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rami' , ICON = N'mascot_00' , PRICE = 1900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741824 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741824, N'Rami', N'mascot_00', 1900, 1, 16, 0 ) END -- Item Name: White Jerry -- Item ID: 1073741825 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741825 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'White Jerry' , ICON = N'mascot_01' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741825 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741825, N'White Jerry', N'mascot_01', 3900, 1, 16, 0 ) END -- Item Name: Black Jerry -- Item ID: 1073741826 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741826 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Black Jerry' , ICON = N'mascot_02' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741826 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741826, N'Black Jerry', N'mascot_02', 3900, 1, 16, 0 ) END -- Item Name: Billy -- Item ID: 1073741827 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741827 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Billy' , ICON = N'mascot_03' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741827 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741827, N'Billy', N'mascot_03', 3900, 1, 16, 0 ) END -- Item Name: Elmo -- Item ID: 1073741828 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741828 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Elmo' , ICON = N'mascot_04' , PRICE = 10000000 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741828 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741828, N'Elmo', N'mascot_04', 10000000, 0, 16, 0 ) END -- Item Name: ?? -- Item ID: 1073741829 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741829 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??' , ICON = N'mascot_05' , PRICE = 10000000 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741829 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741829, N'??', N'mascot_05', 10000000, 0, 16, 0 ) END -- Item Name: Pu Chan -- Item ID: 1073741830 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741830 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pu Chan' , ICON = N'mascot_06' , PRICE = 10000000 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741830 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741830, N'Pu Chan', N'mascot_06', 10000000, 0, 16, 0 ) END -- Item Name: ??? -- Item ID: 1073741833 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741833 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???' , ICON = N'mascot_09' , PRICE = 9 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741833 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741833, N'???', N'mascot_09', 9, 1, 16, 0 ) END -- Item Name: ?????? -- Item ID: 1073741834 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741834 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????' , ICON = N'mascot_10' , PRICE = 9 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741834 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741834, N'??????', N'mascot_10', 9, 1, 16, 0 ) END -- Item Name: ??? -- Item ID: 1073741835 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741835 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???' , ICON = N'mascot_11' , PRICE = 9 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741835 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741835, N'???', N'mascot_11', 9, 1, 16, 0 ) END -- Item Name: ????? -- Item ID: 1073741836 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741836 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????' , ICON = N'mascot_12' , PRICE = 9 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741836 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741836, N'?????', N'mascot_12', 9, 1, 16, 0 ) END -- Item Name: ??2 -- Item ID: 1073741837 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741837 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??2' , ICON = N'mascot_13' , PRICE = 10000000 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741837 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741837, N'??2', N'mascot_13', 10000000, 0, 16, 0 ) END -- Item Name: Hallo -- Item ID: 1073741838 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741838 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hallo' , ICON = N'mascot_14' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741838 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741838, N'Hallo', N'mascot_14', 3900, 1, 16, 0 ) END -- Item Name: Lumo -- Item ID: 1073741839 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741839 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lumo' , ICON = N'mascot_15' , PRICE = 10000000 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741839 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741839, N'Lumo', N'mascot_15', 10000000, 0, 16, 0 ) END -- Item Name: 5th Anniversary Mascot -- Item ID: 1073741841 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741841 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5th Anniversary Mascot' , ICON = N'mascot_17' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741841 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741841, N'5th Anniversary Mascot', N'mascot_17', 3900, 1, 16, 0 ) END -- Item Name: Snow Ball -- Item ID: 1073741842 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741842 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Snow Ball' , ICON = N'mascot_18' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741842 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741842, N'Snow Ball', N'mascot_18', 3900, 1, 16, 0 ) END -- Item Name: Devid -- Item ID: 1073741843 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741843 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Devid' , ICON = N'mascot_08' , PRICE = 150000 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741843 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741843, N'Devid', N'mascot_08', 150000, 0, 16, 0 ) END -- Item Name: Lucas -- Item ID: 1073741844 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741844 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucas' , ICON = N'mascot_06' , PRICE = 18928 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741844 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741844, N'Lucas', N'mascot_06', 18928, 0, 16, 0 ) END -- Item Name: Taz -- Item ID: 1073741845 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741845 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taz' , ICON = N'mascot_09' , PRICE = 18928 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741845 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741845, N'Taz', N'mascot_09', 18928, 0, 16, 0 ) END -- Item Name: Gustavo e Alice -- Item ID: 1073741848 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741848 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Gustavo e Alice' , ICON = N'mascot_10' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741848 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741848, N'Gustavo e Alice', N'mascot_10', 3900, 1, 16, 0 ) END -- Item Name: Monica -- Item ID: 1073741846 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741846 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Monica' , ICON = N'mascot_11' , PRICE = 3900 , ISCASH = 1 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741846 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741846, N'Monica', N'mascot_11', 3900, 1, 16, 0 ) END -- Item Name: Zangado -- Item ID: 1073741847 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741847 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Zangado ' , ICON = N'mascot_12' , PRICE = 18928 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741847 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741847, N'Zangado ', N'mascot_12', 18928, 0, 16, 0 ) END -- Item Name: Anderson -- Item ID: 1073741849 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1073741849 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Anderson' , ICON = N'mascot_13' , PRICE = 3900 , ISCASH = 0 , TYPE = 16 , IS_SALABLE = 0 WHERE TYPEID = 1073741849 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1073741849, N'Anderson', N'mascot_13', 3900, 0, 16, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia