-- ----------------------------------------------- -- -- 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 "Ball.iff" -- -- Last update of the IFF: 2022-02-16 01:28:49 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Ball.iff contains 87 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Aztec -- Item ID: 335544320 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544320 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Aztec' , ICON = N'ball_01' , PRICE = 0 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544320 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544320, N'Aztec', N'ball_01', 0, 0, 5, 0 ) END -- Item Name: Bomber -- Item ID: 335544321 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544321 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bomber' , ICON = N'ball_02' , PRICE = 7900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544321 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544321, N'Bomber', N'ball_02', 7900, 1, 5, 0 ) END -- Item Name: Blue Star -- Item ID: 335544322 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544322 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Star' , ICON = N'ball_03' , PRICE = 6900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544322 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544322, N'Blue Star', N'ball_03', 6900, 1, 5, 0 ) END -- Item Name: Love Love -- Item ID: 335544323 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544323 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Love' , ICON = N'ball_04' , PRICE = 7900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544323 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544323, N'Love Love', N'ball_04', 7900, 1, 5, 0 ) END -- Item Name: Afro Aztec -- Item ID: 335544324 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544324 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Afro Aztec' , ICON = N'ball_06' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544324 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544324, N'Afro Aztec', N'ball_06', 3900, 1, 5, 0 ) END -- Item Name: Water Aztec -- Item ID: 335544325 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544325 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Water Aztec' , ICON = N'ball_128' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544325 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544325, N'Water Aztec', N'ball_128', 3900, 1, 5, 0 ) END -- Item Name: Firework Aztec -- Item ID: 335544326 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544326 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Firework Aztec' , ICON = N'ball_05' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544326 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544326, N'Firework Aztec', N'ball_05', 3900, 1, 5, 0 ) END -- Item Name: G-Star Aztec -- Item ID: 335544327 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544327 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'G-Star Aztec' , ICON = N'ball_07' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544327 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544327, N'G-Star Aztec', N'ball_07', 3900, 0, 5, 0 ) END -- Item Name: Fortune Aztec -- Item ID: 335544328 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544328 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fortune Aztec' , ICON = N'ball_08' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544328 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544328, N'Fortune Aztec', N'ball_08', 3900, 0, 5, 0 ) END -- Item Name: Fortune Aztec (Gift) -- Item ID: 335544329 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544329 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Fortune Aztec (Gift)' , ICON = N'ball_08' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544329 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544329, N'Fortune Aztec (Gift)', N'ball_08', 3900, 1, 5, 0 ) END -- Item Name: Christmas -- Item ID: 335544330 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544330 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Christmas' , ICON = N'ball_10' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544330 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544330, N'Christmas', N'ball_10', 3900, 1, 5, 0 ) END -- Item Name: HG Aztec (JP) -- Item ID: 335544331 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544331 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'HG Aztec (JP)' , ICON = N'ball_11' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544331 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544331, N'HG Aztec (JP)', N'ball_11', 3900, 1, 5, 0 ) END -- Item Name: Clover Aztec -- Item ID: 335544332 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544332 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Clover Aztec' , ICON = N'ball_12' , PRICE = 6900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544332 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544332, N'Clover Aztec', N'ball_12', 6900, 1, 5, 0 ) END -- Item Name: Blue Star Aztec (Gift) -- Item ID: 335544333 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544333 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Star Aztec (Gift)' , ICON = N'ball_03' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544333 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544333, N'Blue Star Aztec (Gift)', N'ball_03', 10000000, 0, 5, 0 ) END -- Item Name: 2nd Anniversary Aztec -- Item ID: 335544334 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544334 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2nd Anniversary Aztec' , ICON = N'ball_14' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544334 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544334, N'2nd Anniversary Aztec', N'ball_14', 10000000, 0, 5, 0 ) END -- Item Name: Blue Aztec(PH) -- Item ID: 335544335 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544335 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Aztec(PH)' , ICON = N'ball_03' , PRICE = 1000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544335 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544335, N'Blue Aztec(PH)', N'ball_03', 1000, 1, 5, 0 ) END -- Item Name: Clover Aztec -- Item ID: 335544336 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544336 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Clover Aztec' , ICON = N'ball_12' , PRICE = 6900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544336 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544336, N'Clover Aztec', N'ball_12', 6900, 1, 5, 0 ) END -- Item Name: Aztec Winning Ball -- Item ID: 335544337 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544337 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Aztec Winning Ball' , ICON = N'ball_17' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544337 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544337, N'Aztec Winning Ball', N'ball_17', 3900, 1, 5, 0 ) END -- Item Name: Aztec Soccer Ball -- Item ID: 335544338 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544338 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Aztec Soccer Ball' , ICON = N'ball_18' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544338 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544338, N'Aztec Soccer Ball', N'ball_18', 3900, 1, 5, 0 ) END -- Item Name: Blue Star (Gift)(PH) -- Item ID: 335544339 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544339 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Blue Star (Gift)(PH)' , ICON = N'ball_03' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544339 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544339, N'Blue Star (Gift)(PH)', N'ball_03', 10000000, 0, 5, 0 ) END -- Item Name: ?????????? ???(BRS) -- Item ID: 335544340 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544340 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????????? ???(BRS)' , ICON = N'ball_18' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544340 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544340, N'?????????? ???(BRS)', N'ball_18', 10000000, 0, 5, 0 ) END -- Item Name: ?????(USA) -- Item ID: 335544341 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544341 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????(USA)' , ICON = N'ball_21' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544341 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544341, N'?????(USA)', N'ball_21', 10000000, 0, 5, 0 ) END -- Item Name: Watermelon Aztec -- Item ID: 335544342 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544342 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Watermelon Aztec' , ICON = N'ball_22' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544342 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544342, N'Watermelon Aztec', N'ball_22', 3900, 1, 5, 0 ) END -- Item Name: ??????? ??? (JP) -- Item ID: 335544343 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544343 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????? ??? (JP)' , ICON = N'ball_03' , PRICE = 10000000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544343 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544343, N'??????? ??? (JP)', N'ball_03', 10000000, 1, 5, 0 ) END -- Item Name: FFL Love Aztec (PH) -- Item ID: 335544344 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544344 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'FFL Love Aztec (PH)' , ICON = N'ball_04' , PRICE = 10000000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544344 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544344, N'FFL Love Aztec (PH)', N'ball_04', 10000000, 1, 5, 0 ) END -- Item Name: WCG2006 Aztec -- Item ID: 335544345 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544345 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'WCG2006 Aztec' , ICON = N'ball_25' , PRICE = 12 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544345 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544345, N'WCG2006 Aztec', N'ball_25', 12, 1, 5, 0 ) END -- Item Name: Halloween Aztec -- Item ID: 335544346 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544346 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Halloween Aztec' , ICON = N'ball_26' , PRICE = 1900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544346 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544346, N'Halloween Aztec', N'ball_26', 1900, 0, 5, 0 ) END -- Item Name: Pumpkin Aztec (Gift) -- Item ID: 335544347 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544347 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Pumpkin Aztec (Gift)' , ICON = N'ball_26' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544347 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544347, N'Pumpkin Aztec (Gift)', N'ball_26', 10000000, 0, 5, 0 ) END -- Item Name: ???????(JP) -- Item ID: 335544348 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544348 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'???????(JP)' , ICON = N'ball_28' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544348 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544348, N'???????(JP)', N'ball_28', 10000000, 0, 5, 0 ) END -- Item Name: ?????(JP) -- Item ID: 335544349 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544349 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????(JP)' , ICON = N'ball_29' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544349 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544349, N'?????(JP)', N'ball_29', 10000000, 0, 5, 0 ) END -- Item Name: Sakura Aztec -- Item ID: 335544350 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544350 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Sakura Aztec' , ICON = N'ball_30' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544350 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544350, N'Sakura Aztec', N'ball_30', 3900, 1, 5, 0 ) END -- Item Name: 3rd Anniversary Aztec -- Item ID: 335544351 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544351 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'3rd Anniversary Aztec' , ICON = N'ball_31' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544351 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544351, N'3rd Anniversary Aztec', N'ball_31', 3900, 0, 5, 0 ) END -- Item Name: Rainbow Aztec -- Item ID: 335544352 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544352 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rainbow Aztec' , ICON = N'ball_32' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544352 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544352, N'Rainbow Aztec', N'ball_32', 3900, 1, 5, 0 ) END -- Item Name: ??????(CN) -- Item ID: 335544353 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544353 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????(CN)' , ICON = N'ball_32' , PRICE = 44 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544353 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544353, N'??????(CN)', N'ball_32', 44, 1, 5, 0 ) END -- Item Name: Chocolate Aztec -- Item ID: 335544354 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544354 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Chocolate Aztec' , ICON = N'ball_34' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544354 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544354, N'Chocolate Aztec', N'ball_34', 3900, 1, 5, 0 ) END -- Item Name: ??????_??(JPN) -- Item ID: 335544355 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544355 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_??(JPN)' , ICON = N'ball_35' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544355 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544355, N'??????_??(JPN)', N'ball_35', 9, 1, 5, 0 ) END -- Item Name: ??????_??(JPN) -- Item ID: 335544356 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544356 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_??(JPN)' , ICON = N'ball_36' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544356 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544356, N'??????_??(JPN)', N'ball_36', 9, 1, 5, 0 ) END -- Item Name: ??????_???(JPN) -- Item ID: 335544358 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544358 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_???(JPN)' , ICON = N'ball_38' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544358 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544358, N'??????_???(JPN)', N'ball_38', 9, 1, 5, 0 ) END -- Item Name: ??????_???(JPN) -- Item ID: 335544359 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544359 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_???(JPN)' , ICON = N'ball_39' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544359 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544359, N'??????_???(JPN)', N'ball_39', 9, 1, 5, 0 ) END -- Item Name: ??????_??(JPN) -- Item ID: 335544360 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544360 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_??(JPN)' , ICON = N'ball_40' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544360 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544360, N'??????_??(JPN)', N'ball_40', 9, 1, 5, 0 ) END -- Item Name: ??????_??(JPN) -- Item ID: 335544361 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544361 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_??(JPN)' , ICON = N'ball_41' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544361 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544361, N'??????_??(JPN)', N'ball_41', 9, 1, 5, 0 ) END -- Item Name: ??????_?(JPN) -- Item ID: 335544362 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544362 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_?(JPN)' , ICON = N'ball_42' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544362 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544362, N'??????_?(JPN)', N'ball_42', 9, 1, 5, 0 ) END -- Item Name: ??????_??(JPN) -- Item ID: 335544363 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544363 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????_??(JPN)' , ICON = N'ball_43' , PRICE = 9 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544363 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544363, N'??????_??(JPN)', N'ball_43', 9, 1, 5, 0 ) END -- Item Name: ??????(TW) -- Item ID: 335544364 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544364 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??????(TW)' , ICON = N'ball_44' , PRICE = 23 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544364 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544364, N'??????(TW)', N'ball_44', 23, 1, 5, 0 ) END -- Item Name: Halloween Skull Aztec -- Item ID: 335544369 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544369 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Halloween Skull Aztec' , ICON = N'ball_49' , PRICE = 1900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544369 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544369, N'Halloween Skull Aztec', N'ball_49', 1900, 1, 5, 0 ) END -- Item Name: Halloween Skull Aztec -- Item ID: 335544370 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544370 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Halloween Skull Aztec' , ICON = N'ball_50' , PRICE = 1900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544370 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544370, N'Halloween Skull Aztec', N'ball_50', 1900, 1, 5, 0 ) END -- Item Name: 4th Anniversary Aztec -- Item ID: 335544371 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544371 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'4th Anniversary Aztec' , ICON = N'ball_51' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544371 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544371, N'4th Anniversary Aztec', N'ball_51', 3900, 1, 5, 0 ) END -- Item Name: Canna Aztec -- Item ID: 335544372 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544372 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Canna Aztec' , ICON = N'ball_52' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544372 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544372, N'Canna Aztec', N'ball_52', 3900, 1, 5, 0 ) END -- Item Name: Talk Play Love ??? -- Item ID: 335544374 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544374 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Talk Play Love ???' , ICON = N'ball_54' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544374 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544374, N'Talk Play Love ???', N'ball_54', 10000000, 0, 5, 0 ) END -- Item Name: ??? ??? -- Item ID: 335544375 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544375 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ???' , ICON = N'ball_55' , PRICE = 13 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544375 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544375, N'??? ???', N'ball_55', 13, 1, 5, 0 ) END -- Item Name: ??? ??? -- Item ID: 335544376 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544376 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'??? ???' , ICON = N'ball_56' , PRICE = 13 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544376 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544376, N'??? ???', N'ball_56', 13, 1, 5, 0 ) END -- Item Name: ????? ??? -- Item ID: 335544377 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544377 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'????? ???' , ICON = N'ball_57' , PRICE = 13 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544377 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544377, N'????? ???', N'ball_57', 13, 1, 5, 0 ) END -- Item Name: ?????? ??? -- Item ID: 335544378 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544378 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'?????? ???' , ICON = N'ball_58' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544378 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544378, N'?????? ???', N'ball_58', 10000000, 0, 5, 0 ) END -- Item Name: Chihuahua Aztec -- Item ID: 335544379 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544379 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Chihuahua Aztec' , ICON = N'ball_59' , PRICE = 1900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544379 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544379, N'Chihuahua Aztec', N'ball_59', 1900, 1, 5, 0 ) END -- Item Name: Light Aztec -- Item ID: 335544380 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544380 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Light Aztec' , ICON = N'ball_60' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544380 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544380, N'Light Aztec', N'ball_60', 3900, 1, 5, 0 ) END -- Item Name: Shadow Aztec -- Item ID: 335544381 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544381 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Shadow Aztec' , ICON = N'ball_61' , PRICE = 4108 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544381 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544381, N'Shadow Aztec', N'ball_61', 4108, 0, 5, 0 ) END -- Item Name: Tiger Aztec -- Item ID: 335544384 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544384 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Tiger Aztec' , ICON = N'ball_64' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544384 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544384, N'Tiger Aztec', N'ball_64', 10000000, 0, 5, 0 ) END -- Item Name: Kooh Aztec -- Item ID: 335544385 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544385 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kooh Aztec' , ICON = N'ball_65' , PRICE = 1000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544385 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544385, N'Kooh Aztec', N'ball_65', 1000000, 0, 5, 0 ) END -- Item Name: Hana Aztec -- Item ID: 335544387 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544387 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hana Aztec' , ICON = N'ball_67' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544387 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544387, N'Hana Aztec', N'ball_67', 3900, 1, 5, 0 ) END -- Item Name: Cesillia Aztec -- Item ID: 335544391 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544391 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cesillia Aztec' , ICON = N'ball_71' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544391 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544391, N'Cesillia Aztec', N'ball_71', 3900, 0, 5, 0 ) END -- Item Name: Lucia Birthday Aztec -- Item ID: 335544392 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544392 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Lucia Birthday Aztec' , ICON = N'ball_72' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544392 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544392, N'Lucia Birthday Aztec', N'ball_72', 3900, 1, 5, 0 ) END -- Item Name: Nuri Aztec -- Item ID: 335544397 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544397 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Nuri Aztec' , ICON = N'ball_77' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544397 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544397, N'Nuri Aztec', N'ball_77', 3900, 0, 5, 0 ) END -- Item Name: Arin Aztec -- Item ID: 335544398 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544398 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arin Aztec' , ICON = N'ball_78' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544398 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544398, N'Arin Aztec', N'ball_78', 3900, 0, 5, 0 ) END -- Item Name: Arthur Birthday Aztec -- Item ID: 335544399 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544399 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Arthur Birthday Aztec' , ICON = N'ball_79' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544399 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544399, N'Arthur Birthday Aztec', N'ball_79', 3900, 0, 5, 0 ) END -- Item Name: Together Love Dad Aztec -- Item ID: 335544401 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544401 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Together Love Dad Aztec' , ICON = N'ball_81' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544401 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544401, N'Together Love Dad Aztec', N'ball_81', 3900, 1, 5, 0 ) END -- Item Name: Kaz Birthday Aztec -- Item ID: 335544402 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544402 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Kaz Birthday Aztec' , ICON = N'ball_82' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544402 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544402, N'Kaz Birthday Aztec', N'ball_82', 3900, 0, 5, 0 ) END -- Item Name: Water Aztec -- Item ID: 335544448 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544448 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Water Aztec' , ICON = N'ball_128' , PRICE = 1000000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544448 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544448, N'Water Aztec', N'ball_128', 1000000, 1, 5, 0 ) END -- Item Name: Bomber -- Item ID: 335544449 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544449 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bomber' , ICON = N'ball_02' , PRICE = 15800 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544449 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544449, N'Bomber', N'ball_02', 15800, 1, 5, 0 ) END -- Item Name: Bomber -- Item ID: 335544450 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544450 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Bomber' , ICON = N'ball_02' , PRICE = 47400 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544450 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544450, N'Bomber', N'ball_02', 47400, 1, 5, 0 ) END -- Item Name: Love Love -- Item ID: 335544451 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544451 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Love' , ICON = N'ball_04' , PRICE = 15900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544451 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544451, N'Love Love', N'ball_04', 15900, 1, 5, 0 ) END -- Item Name: Love Love -- Item ID: 335544452 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544452 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Love Love' , ICON = N'ball_04' , PRICE = 39500 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544452 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544452, N'Love Love', N'ball_04', 39500, 1, 5, 0 ) END -- Item Name: 2???????(ID) -- Item ID: 335544453 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544453 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2???????(ID)' , ICON = N'ball_14' , PRICE = 10000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544453 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544453, N'2???????(ID)', N'ball_14', 10000000, 0, 5, 0 ) END -- Item Name: LoveMom Aztec -- Item ID: 335544454 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544454 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'LoveMom Aztec' , ICON = N'ball_134' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544454 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544454, N'LoveMom Aztec', N'ball_134', 3900, 1, 5, 0 ) END -- Item Name: Wooo Hooo Aztec -- Item ID: 335544455 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544455 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Wooo Hooo Aztec' , ICON = N'ball_11' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544455 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544455, N'Wooo Hooo Aztec', N'ball_11', 3900, 1, 5, 0 ) END -- Item Name: Smiling Goblin Aztec -- Item ID: 335544465 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544465 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Smiling Goblin Aztec' , ICON = N'Ball_HW' , PRICE = 1900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544465 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544465, N'Smiling Goblin Aztec', N'Ball_HW', 1900, 1, 5, 0 ) END -- Item Name: TGS Aztec -- Item ID: 335544489 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544489 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'TGS Aztec' , ICON = N'ball_169' , PRICE = 1000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544489 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544489, N'TGS Aztec', N'ball_169', 1000000, 0, 5, 0 ) END -- Item Name: Red Cross Aztec -- Item ID: 335544490 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544490 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Red Cross Aztec' , ICON = N'ball_170' , PRICE = 1000000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544490 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544490, N'Red Cross Aztec', N'ball_170', 1000000, 0, 5, 0 ) END -- Item Name: We love Thai Aztec -- Item ID: 335544491 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544491 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'We love Thai Aztec' , ICON = N'ball_171' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544491 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544491, N'We love Thai Aztec', N'ball_171', 3900, 1, 5, 0 ) END -- Item Name: 5th Anniversary Aztec -- Item ID: 335544493 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544493 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'5th Anniversary Aztec' , ICON = N'ball_62' , PRICE = 3900 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544493 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544493, N'5th Anniversary Aztec', N'ball_62', 3900, 0, 5, 0 ) END -- Item Name: 2010 WC Aztec -- Item ID: 335544495 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544495 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'2010 WC Aztec' , ICON = N'ball_173' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544495 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544495, N'2010 WC Aztec', N'ball_173', 3900, 1, 5, 0 ) END -- Item Name: Rabbit Aztec -- Item ID: 335544497 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544497 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Rabbit Aztec' , ICON = N'ball_177' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544497 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544497, N'Rabbit Aztec', N'ball_177', 3900, 1, 5, 0 ) END -- Item Name: PWC Aztec(Black) -- Item ID: 335544498 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544498 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PWC Aztec(Black)' , ICON = N'ball_178' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544498 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544498, N'PWC Aztec(Black)', N'ball_178', 3900, 1, 5, 0 ) END -- Item Name: PWC Aztec(White) -- Item ID: 335544499 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544499 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PWC Aztec(White)' , ICON = N'ball_179' , PRICE = 3900 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544499 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544499, N'PWC Aztec(White)', N'ball_179', 3900, 1, 5, 0 ) END -- Item Name: Hello Kitty -- Item ID: 335544500 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544500 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hello Kitty' , ICON = N'ball_68' , PRICE = 1000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544500 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544500, N'Hello Kitty', N'ball_68', 1000, 1, 5, 0 ) END -- Item Name: Hello Kitty 2 -- Item ID: 335544501 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544501 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hello Kitty 2' , ICON = N'ball_69' , PRICE = 1000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544501 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544501, N'Hello Kitty 2', N'ball_69', 1000, 1, 5, 0 ) END -- Item Name: Hello Kitty 2 -- Item ID: 335544501 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544501 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Hello Kitty 2' , ICON = N'ball_69' , PRICE = 1000 , ISCASH = 1 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544501 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544501, N'Hello Kitty 2', N'ball_69', 1000, 1, 5, 0 ) END -- Item Name: Homen-Aranha -- Item ID: 335544503 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 335544503 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Homen-Aranha' , ICON = N'ball_70' , PRICE = 1000 , ISCASH = 0 , TYPE = 5 , IS_SALABLE = 0 WHERE TYPEID = 335544503 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 335544503, N'Homen-Aranha', N'ball_70', 1000, 0, 5, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia