-- ----------------------------------------------- -- -- 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 "Caddie.iff" -- -- Last update of the IFF: 2022-02-16 01:28:49 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Caddie.iff contains 27 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Bogo -- Item ID: 469762048 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762048 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo' , ICON = N'caddie_00' , PRICE = 0 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762048 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762048, N'Bogo', N'caddie_00', 0, 0, 7, 0 ) END -- Item Name: Nina -- Item ID: 469762049 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762049 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nina' , ICON = N'caddie_01' , PRICE = 8200 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762049 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762049, N'Nina', N'caddie_01', 8200, 0, 7, 0 ) END -- Item Name: Kuko -- Item ID: 469762050 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762050 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuko' , ICON = N'caddie_02' , PRICE = 70000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762050 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762050, N'Kuko', N'caddie_02', 70000, 0, 7, 0 ) END -- Item Name: PomPom -- Item ID: 469762051 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762051 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PomPom' , ICON = N'caddie_03' , PRICE = 7900 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762051 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762051, N'PomPom', N'caddie_03', 7900, 0, 7, 0 ) END -- Item Name: Joana -- Item ID: 469762052 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762052 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Joana' , ICON = N'caddie_04' , PRICE = 27500 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762052 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762052, N'Joana', N'caddie_04', 27500, 1, 7, 0 ) END -- Item Name: Zuma -- Item ID: 469762053 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762053 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Zuma' , ICON = N'caddie_05' , PRICE = 19900 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762053 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762053, N'Zuma', N'caddie_05', 19900, 1, 7, 0 ) END -- Item Name: Lili -- Item ID: 469762054 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762054 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lili' , ICON = N'caddie_06' , PRICE = 25000 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762054 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762054, N'Lili', N'caddie_06', 25000, 1, 7, 0 ) END -- Item Name: Carla -- Item ID: 469762055 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762055 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Carla' , ICON = N'caddie_07' , PRICE = 80000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762055 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762055, N'Carla', N'caddie_07', 80000, 0, 7, 0 ) END -- Item Name: Hamberker -- Item ID: 469762056 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762056 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hamberker' , ICON = N'caddie_07' , PRICE = 80000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762056 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762056, N'Hamberker', N'caddie_07', 80000, 0, 7, 0 ) END -- Item Name: Copo de macarrão -- Item ID: 469762057 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762057 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Copo de macarrão' , ICON = N'caddie_09' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762057 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762057, N'Copo de macarrão', N'caddie_09', 10000000, 0, 7, 0 ) END -- Item Name: Bogo Preto -- Item ID: 469762058 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762058 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Preto' , ICON = N'caddie_10' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762058 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762058, N'Bogo Preto', N'caddie_10', 10000000, 0, 7, 0 ) END -- Item Name: Conj. Azul Nina -- Item ID: 469762059 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762059 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Azul Nina' , ICON = N'caddie_11' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762059 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762059, N'Conj. Azul Nina', N'caddie_11', 10000000, 0, 7, 0 ) END -- Item Name: Bogo Gigante -- Item ID: 469762060 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762060 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Gigante' , ICON = N'caddie_12' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762060 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762060, N'Bogo Gigante', N'caddie_12', 10000000, 0, 7, 0 ) END -- Item Name: Bogo Gigante Vermelho -- Item ID: 469762061 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762061 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Gigante Vermelho' , ICON = N'caddie_13' , PRICE = 85000 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762061 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762061, N'Bogo Gigante Vermelho', N'caddie_13', 85000, 1, 7, 0 ) END -- Item Name: Bogo Gigante Preto -- Item ID: 469762062 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762062 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Gigante Preto' , ICON = N'caddie_14' , PRICE = 85000 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762062 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762062, N'Bogo Gigante Preto', N'caddie_14', 85000, 1, 7, 0 ) END -- Item Name: Bogo Transparente -- Item ID: 469762063 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762063 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Transparente' , ICON = N'caddie_15' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762063 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762063, N'Bogo Transparente', N'caddie_15', 10000000, 0, 7, 0 ) END -- Item Name: Nina -- Item ID: 469762064 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762064 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nina' , ICON = N'caddie_01' , PRICE = 80000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762064 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762064, N'Nina', N'caddie_01', 80000, 0, 7, 0 ) END -- Item Name: Kuko -- Item ID: 469762065 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762065 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kuko' , ICON = N'caddie_02' , PRICE = 90000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762065 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762065, N'Kuko', N'caddie_02', 90000, 0, 7, 0 ) END -- Item Name: PomPom -- Item ID: 469762066 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762066 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PomPom' , ICON = N'caddie_03' , PRICE = 50000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762066 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762066, N'PomPom', N'caddie_03', 50000, 0, 7, 0 ) END -- Item Name: Joana -- Item ID: 469762067 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762067 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Joana' , ICON = N'caddie_04' , PRICE = 27500 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762067 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762067, N'Joana', N'caddie_04', 27500, 1, 7, 0 ) END -- Item Name: Zuma -- Item ID: 469762068 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762068 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Zuma' , ICON = N'caddie_05' , PRICE = 19900 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762068 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762068, N'Zuma', N'caddie_05', 19900, 1, 7, 0 ) END -- Item Name: Lili -- Item ID: 469762069 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762069 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lili' , ICON = N'caddie_06' , PRICE = 25000 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762069 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762069, N'Lili', N'caddie_06', 25000, 1, 7, 0 ) END -- Item Name: Carla -- Item ID: 469762070 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762070 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Carla' , ICON = N'caddie_07' , PRICE = 100000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762070 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762070, N'Carla', N'caddie_07', 100000, 0, 7, 0 ) END -- Item Name: Minty -- Item ID: 469762074 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762074 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Minty' , ICON = N'caddie_128' , PRICE = 100000 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762074 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762074, N'Minty', N'caddie_128', 100000, 1, 7, 0 ) END -- Item Name: Bogo Legend -- Item ID: 469762078 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762078 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Legend' , ICON = N'Caddie_Bon_008' , PRICE = 100000 , ISCASH = 1 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762078 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762078, N'Bogo Legend', N'Caddie_Bon_008', 100000, 1, 7, 0 ) END -- Item Name: Bogo Gigante 2000 -- Item ID: 469762079 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762079 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Gigante 2000' , ICON = N'caddie_138' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762079 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762079, N'Bogo Gigante 2000', N'caddie_138', 10000000, 0, 7, 0 ) END -- Item Name: Bogo Vermelho Natal -- Item ID: 469762080 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 469762080 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bogo Vermelho Natal' , ICON = N'caddie_139' , PRICE = 10000000 , ISCASH = 0 , TYPE = 7 , IS_SALABLE = 0 WHERE TYPEID = 469762080 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 469762080, N'Bogo Vermelho Natal', N'caddie_139', 10000000, 0, 7, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia