-- ----------------------------------------------- -- -- 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 "Auxpart.iff" -- -- Last update of the IFF: 2022-02-16 01:28:49 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Auxpart.iff contains 31 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Power Ring -- Item ID: 1879048192 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048192 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Ring' , ICON = N'auxpart0_128' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048192 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048192, N'Power Ring', N'auxpart0_128', 10000000, 0, 28, 0 ) END -- Item Name: Control Ring -- Item ID: 1879048193 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048193 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Control Ring' , ICON = N'auxpart0_129' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048193 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048193, N'Control Ring', N'auxpart0_129', 10000000, 0, 28, 0 ) END -- Item Name: Impact Ring -- Item ID: 1879048194 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048194 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Impact Ring' , ICON = N'auxpart0_130' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048194 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048194, N'Impact Ring', N'auxpart0_130', 10000000, 0, 28, 0 ) END -- Item Name: Spin Ring -- Item ID: 1879048195 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048195 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spin Ring' , ICON = N'auxpart0_131' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048195 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048195, N'Spin Ring', N'auxpart0_131', 10000000, 0, 28, 0 ) END -- Item Name: Curve Ring -- Item ID: 1879048196 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048196 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Curve Ring' , ICON = N'auxpart0_132' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048196 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048196, N'Curve Ring', N'auxpart0_132', 10000000, 0, 28, 0 ) END -- Item Name: Fortune Ring -- Item ID: 1879048197 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048197 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fortune Ring' , ICON = N'auxpart0_133' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048197 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048197, N'Fortune Ring', N'auxpart0_133', 10000000, 0, 28, 0 ) END -- Item Name: Pangya Ring -- Item ID: 1879048198 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048198 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Ring' , ICON = N'auxpart0_134' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048198 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048198, N'Pangya Ring', N'auxpart0_134', 10000000, 0, 28, 0 ) END -- Item Name: Bonus Ring -- Item ID: 1879048199 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048199 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bonus Ring' , ICON = N'auxpart0_135' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048199 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048199, N'Bonus Ring', N'auxpart0_135', 10000000, 0, 28, 0 ) END -- Item Name: Platinum ring -- Item ID: 1879048204 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048204 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Platinum ring ' , ICON = N'auxpart0_012' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048204 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048204, N'Platinum ring ', N'auxpart0_012', 10000000, 0, 28, 0 ) END -- Item Name: Platinum ring -- Item ID: 1879048205 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048205 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Platinum ring ' , ICON = N'auxpart0_013' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048205 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048205, N'Platinum ring ', N'auxpart0_013', 10000000, 0, 28, 0 ) END -- Item Name: Platinum ring -- Item ID: 1879048206 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048206 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Platinum ring ' , ICON = N'auxpart0_014' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048206 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048206, N'Platinum ring ', N'auxpart0_014', 10000000, 0, 28, 0 ) END -- Item Name: Platinum ring -- Item ID: 1879048207 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048207 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Platinum ring ' , ICON = N'auxpart0_015' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048207 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048207, N'Platinum ring ', N'auxpart0_015', 10000000, 0, 28, 0 ) END -- Item Name: Power Ring (JP) -- Item ID: 1879048320 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048320 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Power Ring (JP)' , ICON = N'auxpart0_128' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048320 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048320, N'Power Ring (JP)', N'auxpart0_128', 10000000, 0, 28, 0 ) END -- Item Name: Control Ring (JP) -- Item ID: 1879048321 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048321 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Control Ring (JP)' , ICON = N'auxpart0_129' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048321 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048321, N'Control Ring (JP)', N'auxpart0_129', 10000000, 0, 28, 0 ) END -- Item Name: Impact Ring (JP) -- Item ID: 1879048322 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048322 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Impact Ring (JP)' , ICON = N'auxpart0_130' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048322 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048322, N'Impact Ring (JP)', N'auxpart0_130', 10000000, 0, 28, 0 ) END -- Item Name: Spin Ring (JP) -- Item ID: 1879048323 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048323 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Spin Ring (JP)' , ICON = N'auxpart0_131' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048323 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048323, N'Spin Ring (JP)', N'auxpart0_131', 10000000, 0, 28, 0 ) END -- Item Name: Curve Ring (JP) -- Item ID: 1879048324 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048324 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Curve Ring (JP)' , ICON = N'auxpart0_132' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048324 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048324, N'Curve Ring (JP)', N'auxpart0_132', 10000000, 0, 28, 0 ) END -- Item Name: Fortune Ring (JP) -- Item ID: 1879048325 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048325 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fortune Ring (JP)' , ICON = N'auxpart0_133' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048325 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048325, N'Fortune Ring (JP)', N'auxpart0_133', 10000000, 0, 28, 0 ) END -- Item Name: Pangya Ring (JP) -- Item ID: 1879048326 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048326 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pangya Ring (JP)' , ICON = N'auxpart0_134' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048326 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048326, N'Pangya Ring (JP)', N'auxpart0_134', 10000000, 0, 28, 0 ) END -- Item Name: PangUp_Tw -- Item ID: 1879048327 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879048327 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangUp_Tw' , ICON = N'auxpart0_135' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879048327 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879048327, N'PangUp_Tw', N'auxpart0_135', 10000000, 0, 28, 0 ) END -- Item Name: Midnight Ring -- Item ID: 1879113736 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113736 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Midnight Ring' , ICON = N'auxpart1_136' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113736 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113736, N'Midnight Ring', N'auxpart1_136', 10000000, 0, 28, 0 ) END -- Item Name: Cat Ring -- Item ID: 1879113737 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113737 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cat Ring' , ICON = N'auxpart0_009' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113737 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113737, N'Cat Ring', N'auxpart0_009', 10000000, 0, 28, 0 ) END -- Item Name: Mystic Ring -- Item ID: 1879113739 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113739 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Mystic Ring' , ICON = N'auxpart0_011' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113739 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113739, N'Mystic Ring', N'auxpart0_011', 10000000, 0, 28, 0 ) END -- Item Name: Hybrid Ring -- Item ID: 1879113744 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113744 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hybrid Ring' , ICON = N'auxpart0_016' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113744 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113744, N'Hybrid Ring', N'auxpart0_016', 10000000, 0, 28, 0 ) END -- Item Name: Promise Ring -- Item ID: 1879113745 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113745 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Promise Ring' , ICON = N'auxpart0_017' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113745 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113745, N'Promise Ring', N'auxpart0_017', 10000000, 0, 28, 0 ) END -- Item Name: Crimson Ring -- Item ID: 1879113856 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113856 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Crimson Ring' , ICON = N'auxpart0_1_128' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113856 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113856, N'Crimson Ring', N'auxpart0_1_128', 10000000, 0, 28, 0 ) END -- Item Name: ??? ?? -- Item ID: 1879113857 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113857 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ??' , ICON = N'auxpart0_1_129' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113857 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113857, N'??? ??', N'auxpart0_1_129', 10000000, 0, 28, 0 ) END -- Item Name: Aeon Ring -- Item ID: 1879113858 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113858 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Aeon Ring' , ICON = N'auxpart0_1_130' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113858 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113858, N'Aeon Ring', N'auxpart0_1_130', 10000000, 0, 28, 0 ) END -- Item Name: Smart Ring -- Item ID: 1879113859 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113859 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Smart Ring' , ICON = N'auxpart0_019' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113859 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113859, N'Smart Ring', N'auxpart0_019', 10000000, 0, 28, 0 ) END -- Item Name: Anel Preto Angel -- Item ID: 1879113860 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113860 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Anel Preto Angel' , ICON = N'auxpart0_1_131' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113860 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113860, N'Anel Preto Angel', N'auxpart0_1_131', 10000000, 0, 28, 0 ) END -- Item Name: Anel Diamante do Poder -- Item ID: 1879113861 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 1879113861 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Anel Diamante do Poder' , ICON = N'auxpart1_000' , PRICE = 10000000 , ISCASH = 0 , TYPE = 28 , IS_SALABLE = 0 WHERE TYPEID = 1879113861 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 1879113861, N'Anel Diamante do Poder', N'auxpart1_000', 10000000, 0, 28, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia