-- ----------------------------------------------- -- -- 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 "Clubset.iff" -- -- Last update of the IFF: 2022-02-16 01:28:49 -- -- ----------------------------------------------- -- USE [Pangya_S4_TH] GO -- Clubset.iff contains 86 records. BEGIN TRAN InsertUpdateTypelist -- Item Name: Cavaleiro do Vento 1 -- Item ID: 268435456 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435456 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento 1' , ICON = N'club01_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435456 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435456, N'Cavaleiro do Vento 1', N'club01_01', 10000000, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento 2 -- Item ID: 268435457 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435457 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento 2' , ICON = N'club01_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435457 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435457, N'Cavaleiro do Vento 2', N'club01_02', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de BaseBall -- Item ID: 268435458 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435458 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de BaseBall' , ICON = N'club01_03' , PRICE = 24900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435458 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435458, N'Taqueira de BaseBall', N'club01_03', 24900, 1, 4, 0 ) END -- Item Name: Taqueira de Ferramentas -- Item ID: 268435459 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435459 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Ferramentas' , ICON = N'club01_05' , PRICE = 29900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435459 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435459, N'Taqueira de Ferramentas', N'club01_05', 29900, 1, 4, 0 ) END -- Item Name: Taqueira Medieval -- Item ID: 268435460 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435460 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Medieval' , ICON = N'club01_08' , PRICE = 97000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435460 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435460, N'Taqueira Medieval', N'club01_08', 97000, 0, 4, 0 ) END -- Item Name: Taqueira Space Vermelha -- Item ID: 268435461 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435461 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Space Vermelha' , ICON = N'club01_06' , PRICE = 88000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435461 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435461, N'Taqueira Space Vermelha', N'club01_06', 88000, 0, 4, 0 ) END -- Item Name: Taqueira Space Azul -- Item ID: 268435462 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435462 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Space Azul' , ICON = N'club01_07' , PRICE = 29900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435462 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435462, N'Taqueira Space Azul', N'club01_07', 29900, 1, 4, 0 ) END -- Item Name: Taqueira de Pena 2 -- Item ID: 268435463 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435463 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Pena 2' , ICON = N'club02_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435463 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435463, N'Taqueira de Pena 2', N'club02_01', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Chapolin -- Item ID: 268435464 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435464 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Chapolin ' , ICON = N'club01_10' , PRICE = 15000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435464 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435464, N'Taqueira de Chapolin ', N'club01_10', 15000, 0, 4, 0 ) END -- Item Name: Taqueira Guarda-Chuvas -- Item ID: 268435465 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435465 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Guarda-Chuvas' , ICON = N'club02_03' , PRICE = 52900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435465 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435465, N'Taqueira Guarda-Chuvas', N'club02_03', 52900, 1, 4, 0 ) END -- Item Name: Cavaleiro do Vento 3 -- Item ID: 268435466 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435466 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento 3' , ICON = N'club01_11' , PRICE = 500000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435466 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435466, N'Cavaleiro do Vento 3', N'club01_11', 500000, 0, 4, 0 ) END -- Item Name: Taqueira de Pena Especial -- Item ID: 268435467 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435467 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Pena Especial' , ICON = N'club02_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435467 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435467, N'Taqueira de Pena Especial', N'club02_02', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Magical -- Item ID: 268435468 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435468 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Magical' , ICON = N'club02_04' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435468 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435468, N'Taqueira Magical', N'club02_04', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Piratas -- Item ID: 268435469 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435469 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Piratas ' , ICON = N'club02_05' , PRICE = 24900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435469 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435469, N'Taqueira de Piratas ', N'club02_05', 24900, 1, 4, 0 ) END -- Item Name: Taqueira de Espadas -- Item ID: 268435470 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435470 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Espadas' , ICON = N'club02_06' , PRICE = 29900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435470 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435470, N'Taqueira de Espadas', N'club02_06', 29900, 1, 4, 0 ) END -- Item Name: Taqueira de Espadas Preta -- Item ID: 268435471 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435471 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Espadas Preta' , ICON = N'club02_07' , PRICE = 91000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435471 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435471, N'Taqueira de Espadas Preta', N'club02_07', 91000, 0, 4, 0 ) END -- Item Name: Taqueira de Microfone -- Item ID: 268435472 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435472 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Microfone' , ICON = N'club02_08' , PRICE = 32900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435472 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435472, N'Taqueira de Microfone', N'club02_08', 32900, 1, 4, 0 ) END -- Item Name: Taqueira de Natal -- Item ID: 268435473 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435473 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Natal' , ICON = N'club02_09' , PRICE = 32900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435473 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435473, N'Taqueira de Natal', N'club02_09', 32900, 1, 4, 0 ) END -- Item Name: Cavaleiro do Vento Verde -- Item ID: 268435474 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435474 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Verde' , ICON = N'club01_12' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435474 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435474, N'Cavaleiro do Vento Verde', N'club01_12', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Halloween -- Item ID: 268435475 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435475 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Halloween' , ICON = N'club02_13' , PRICE = 23000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435475 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435475, N'Taqueira Halloween', N'club02_13', 23000, 0, 4, 0 ) END -- Item Name: Taqueira de Chocolate -- Item ID: 268435476 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435476 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Chocolate' , ICON = N'club02_12' , PRICE = 32900 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435476 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435476, N'Taqueira de Chocolate', N'club02_12', 32900, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento Dourada -- Item ID: 268435477 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435477 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Dourada' , ICON = N'club01_13' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435477 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435477, N'Cavaleiro do Vento Dourada', N'club01_13', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Vocal Miracle -- Item ID: 268435479 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435479 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Vocal Miracle' , ICON = N'club02_14' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435479 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435479, N'Taqueira Vocal Miracle', N'club02_14', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Natal 2 -- Item ID: 268435480 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435480 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Natal 2' , ICON = N'club02_15' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435480 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435480, N'Taqueira de Natal 2', N'club02_15', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Patas -- Item ID: 268435481 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435481 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Patas' , ICON = N'club03_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435481 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435481, N'Taqueira de Patas', N'club03_01', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Especial -- Item ID: 268435483 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435483 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Especial' , ICON = N'club03_03' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435483 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435483, N'Taqueira Especial', N'club03_03', 10000000, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento Preta -- Item ID: 268435484 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435484 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Preta' , ICON = N'club01_15' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435484 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435484, N'Cavaleiro do Vento Preta', N'club01_15', 10000000, 0, 4, 0 ) END -- Item Name: Taqueiras Ferramentas 2 -- Item ID: 268435487 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435487 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueiras Ferramentas 2' , ICON = N'club03_06' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435487 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435487, N'Taqueiras Ferramentas 2', N'club03_06', 10000000, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento Ruby -- Item ID: 268435494 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435494 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Ruby' , ICON = N'club01_18' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435494 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435494, N'Cavaleiro do Vento Ruby', N'club01_18', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Foice Especial -- Item ID: 268435495 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435495 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Foice Especial' , ICON = N'club03_12' , PRICE = 52000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435495 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435495, N'Taqueira Foice Especial', N'club03_12', 52000, 1, 4, 0 ) END -- Item Name: Taqueira Foice -- Item ID: 268435497 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435497 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Foice' , ICON = N'club03_13' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435497 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435497, N'Taqueira Foice', N'club03_13', 10000000, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento Dourada 2 -- Item ID: 268435498 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435498 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Dourada 2' , ICON = N'club01_13' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435498 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435498, N'Cavaleiro do Vento Dourada 2', N'club01_13', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Doces -- Item ID: 268435499 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435499 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Doces' , ICON = N'club03_15' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435499 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435499, N'Taqueira de Doces', N'club03_15', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Dourada Siam -- Item ID: 268435505 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435505 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Dourada Siam' , ICON = N'club02_18' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435505 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435505, N'Taqueira Dourada Siam', N'club02_18', 10000000, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento Cristal -- Item ID: 268435508 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435508 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Cristal' , ICON = N'club01_22' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435508 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435508, N'Cavaleiro do Vento Cristal', N'club01_22', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Guitarras -- Item ID: 268435509 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435509 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Guitarras' , ICON = N'club02_11' , PRICE = 50084 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435509 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435509, N'Taqueira de Guitarras', N'club02_11', 50084, 0, 4, 0 ) END -- Item Name: Cavaleiro do Vento Dourada 3 -- Item ID: 268435510 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435510 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Cavaleiro do Vento Dourada 3' , ICON = N'club01_13' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435510 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435510, N'Cavaleiro do Vento Dourada 3', N'club01_13', 10000000, 0, 4, 0 ) END -- Item Name: PangYa World Champions -- Item ID: 268435511 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435511 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'PangYa World Champions' , ICON = N'club02_19' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435511 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435511, N'PangYa World Champions', N'club02_19', 10000000, 0, 4, 0 ) END -- Item Name: Medieval Dourada -- Item ID: 268435584 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435584 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Medieval Dourada' , ICON = N'club01_09' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435584 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435584, N'Medieval Dourada', N'club01_09', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Capim -- Item ID: 268435585 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435585 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Capim' , ICON = N'club03_02' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435585 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435585, N'Taqueira Capim', N'club03_02', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira De Voz Rosa -- Item ID: 268435586 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435586 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira De Voz Rosa' , ICON = N'club01_14' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435586 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435586, N'Taqueira De Voz Rosa', N'club01_14', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira De Ferramentas 3 -- Item ID: 268435512 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435512 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira De Ferramentas 3' , ICON = N'club03_07' , PRICE = 97000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435512 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435512, N'Taqueira De Ferramentas 3', N'club03_07', 97000, 0, 4, 0 ) END -- Item Name: Taqueira De Peixe Vermelha -- Item ID: 268435588 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435588 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira De Peixe Vermelha' , ICON = N'club03_08' , PRICE = 5000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435588 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435588, N'Taqueira De Peixe Vermelha', N'club03_08', 5000000, 0, 4, 0 ) END -- Item Name: Taqueira De Peixe Azul -- Item ID: 268435589 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435589 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira De Peixe Azul' , ICON = N'club03_09' , PRICE = 1500000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435589 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435589, N'Taqueira De Peixe Azul', N'club03_09', 1500000, 0, 4, 0 ) END -- Item Name: Taqueira Crystal Especial -- Item ID: 268435590 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435590 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Crystal Especial' , ICON = N'club01_21' , PRICE = 5000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435590 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435590, N'Taqueira Crystal Especial', N'club01_21', 5000000, 0, 4, 0 ) END -- Item Name: Taqueira Infinity Verde -- Item ID: 268435591 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435591 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Infinity Verde' , ICON = N'club01_16' , PRICE = 5000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435591 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435591, N'Taqueira Infinity Verde', N'club01_16', 5000000, 0, 4, 0 ) END -- Item Name: Taqueira Ecológica -- Item ID: 268435592 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435592 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Ecológica' , ICON = N'club03_04' , PRICE = 20612 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435592 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435592, N'Taqueira Ecológica', N'club03_04', 20612, 0, 4, 0 ) END -- Item Name: Taqueira Demons Pack -- Item ID: 268435593 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435593 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Demons Pack' , ICON = N'club03_05' , PRICE = 5000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435593 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435593, N'Taqueira Demons Pack', N'club03_05', 5000000, 0, 4, 0 ) END -- Item Name: Taqueira Flower L?bera -- Item ID: 268435594 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435594 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Flower L?bera' , ICON = N'club03_18' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435594 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435594, N'Taqueira Flower L?bera', N'club03_18', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Hello Kitty -- Item ID: 268435595 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435595 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Hello Kitty' , ICON = N'club03_17' , PRICE = 52900 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435595 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435595, N'Taqueira Hello Kitty', N'club03_17', 52900, 1, 4, 0 ) END -- Item Name: Novo Conjunto Patas -- Item ID: 268435596 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435596 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Novo Conjunto Patas' , ICON = N'club03_20' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435596 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435596, N'Novo Conjunto Patas', N'club03_20', 10000000, 0, 4, 0 ) END -- Item Name: Estrela Do Sul Rosa -- Item ID: 268435597 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435597 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Estrela Do Sul Rosa' , ICON = N'club01_19' , PRICE = 43000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435597 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435597, N'Estrela Do Sul Rosa', N'club01_19', 43000, 0, 4, 0 ) END -- Item Name: Estrela Do Sul Verde -- Item ID: 268435598 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435598 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Estrela Do Sul Verde' , ICON = N'club01_20' , PRICE = 100000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435598 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435598, N'Estrela Do Sul Verde', N'club01_20', 100000, 0, 4, 0 ) END -- Item Name: Taqueira Nipes de Baralho -- Item ID: 268435599 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435599 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Nipes de Baralho' , ICON = N'club03_22' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435599 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435599, N'Taqueira Nipes de Baralho', N'club03_22', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Tribus Azul -- Item ID: 268435600 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435600 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Tribus Azul' , ICON = N'club03_11' , PRICE = 100000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435600 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435600, N'Taqueira Tribus Azul', N'club03_11', 100000, 0, 4, 0 ) END -- Item Name: Taqueira Tribus Verde -- Item ID: 268435601 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435601 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Tribus Verde' , ICON = N'club03_10' , PRICE = 100000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435601 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435601, N'Taqueira Tribus Verde', N'club03_10', 100000, 0, 4, 0 ) END -- Item Name: Taqueira Vocal Dourada -- Item ID: 268435602 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435602 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Vocal Dourada' , ICON = N'club03_25' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435602 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435602, N'Taqueira Vocal Dourada', N'club03_25', 10000000, 0, 4, 0 ) END -- Item Name: Conj. Material Escolar -- Item ID: 268435604 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435604 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Material Escolar' , ICON = N'club03_26' , PRICE = 74000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435604 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435604, N'Conj. Material Escolar', N'club03_26', 74000, 0, 4, 0 ) END -- Item Name: Prism Scope Club Set -- Item ID: 268435605 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435605 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Prism Scope Club Set' , ICON = N'club03_27' , PRICE = 75000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435605 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435605, N'Prism Scope Club Set', N'club03_27', 75000, 1, 4, 0 ) END -- Item Name: Taqueira Foice Power -- Item ID: 268435606 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435606 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Foice Power' , ICON = N'club03_14' , PRICE = 68000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435606 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435606, N'Taqueira Foice Power', N'club03_14', 68000, 1, 4, 0 ) END -- Item Name: Conj. Aniversario 2 Anos -- Item ID: 268435607 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435607 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Aniversario 2 Anos' , ICON = N'club01_28' , PRICE = 15000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435607 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435607, N'Conj. Aniversario 2 Anos', N'club01_28', 15000, 1, 4, 0 ) END -- Item Name: Taqueira Base Ball Evo -- Item ID: 268435603 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435603 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Base Ball Evo' , ICON = N'club01_17' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435603 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435603, N'Taqueira Base Ball Evo', N'club01_17', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Infinity Azul -- Item ID: 268435608 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435608 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Infinity Azul' , ICON = N'club01_23' , PRICE = 900000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435608 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435608, N'Taqueira Infinity Azul', N'club01_23', 900000, 0, 4, 0 ) END -- Item Name: Conj Vocal Negima! -- Item ID: 268435609 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435609 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj Vocal Negima!' , ICON = N'club03_21_01' , PRICE = 65000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435609 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435609, N'Conj Vocal Negima!', N'club03_21_01', 65000, 1, 4, 0 ) END -- Item Name: Conj Frutos do Mar -- Item ID: 268435610 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435610 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj Frutos do Mar' , ICON = N'club03_28' , PRICE = 65000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435610 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435610, N'Conj Frutos do Mar', N'club03_28', 65000, 1, 4, 0 ) END -- Item Name: Taqueira Especial 2 -- Item ID: 268435611 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435611 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Especial 2' , ICON = N'club01_34' , PRICE = 59 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435611 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435611, N'Taqueira Especial 2', N'club01_34', 59, 1, 4, 0 ) END -- Item Name: Taqueira de Estrumentos -- Item ID: 268435612 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435612 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Estrumentos' , ICON = N'club03_23' , PRICE = 52000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435612 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435612, N'Taqueira de Estrumentos', N'club03_23', 52000, 1, 4, 0 ) END -- Item Name: Taqueira Sleipnir Azul -- Item ID: 268435613 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435613 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Sleipnir Azul' , ICON = N'club01_47' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435613 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435613, N'Taqueira Sleipnir Azul', N'club01_47', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Foice Power 2 -- Item ID: 268435614 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435614 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Foice Power 2' , ICON = N'club01_48' , PRICE = 68000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435614 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435614, N'Taqueira Foice Power 2', N'club01_48', 68000, 0, 4, 0 ) END -- Item Name: Taqueira Sleipnir Azul -- Item ID: 268435615 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435615 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Sleipnir Azul' , ICON = N'club01_47' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435615 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435615, N'Taqueira Sleipnir Azul', N'club01_47', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira Rio 2016 -- Item ID: 268435616 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435616 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Rio 2016' , ICON = N'club01_50' , PRICE = 68000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435616 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435616, N'Taqueira Rio 2016', N'club01_50', 68000, 0, 4, 0 ) END -- Item Name: Taqueira de Ouro 2 -- Item ID: 268435617 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435617 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Ouro 2' , ICON = N'club01_26' , PRICE = 68000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435617 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435617, N'Taqueira de Ouro 2', N'club01_26', 68000, 0, 4, 0 ) END -- Item Name: Conjunto Boys Especial -- Item ID: 268435618 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435618 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conjunto Boys Especial' , ICON = N'club01_52' , PRICE = 68000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435618 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435618, N'Conjunto Boys Especial', N'club01_52', 68000, 0, 4, 0 ) END -- Item Name: Taqueira Invisivel -- Item ID: 268435619 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435619 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Invisivel' , ICON = N'club03_16' , PRICE = 68000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435619 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435619, N'Taqueira Invisivel', N'club03_16', 68000, 0, 4, 0 ) END -- Item Name: Taqueira de Ouro -- Item ID: 268435620 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435620 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Ouro' , ICON = N'club01_57' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435620 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435620, N'Taqueira de Ouro', N'club01_57', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Patas -- Item ID: 268435621 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435621 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Patas' , ICON = N'club03_01' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435621 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435621, N'Taqueira de Patas', N'club03_01', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Esmeralda -- Item ID: 268435622 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435622 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Esmeralda' , ICON = N'club01_59' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435622 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435622, N'Taqueira de Esmeralda', N'club01_59', 10000000, 0, 4, 0 ) END -- Item Name: Conj. Aniversario 7 Anos -- Item ID: 268435623 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435623 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Aniversario 7 Anos' , ICON = N'club01_27' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435623 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435623, N'Conj. Aniversario 7 Anos', N'club01_27', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Prata -- Item ID: 268435624 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435624 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Prata' , ICON = N'club02_21' , PRICE = 10000000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435624 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435624, N'Taqueira de Prata', N'club02_21', 10000000, 1, 4, 0 ) END -- Item Name: Taqueira Especial 3 -- Item ID: 268435625 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435625 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Especial 3' , ICON = N'club01_58' , PRICE = 10000000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435625 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435625, N'Taqueira Especial 3', N'club01_58', 10000000, 1, 4, 0 ) END -- Item Name: Conj. Aniversario 8 Anos -- Item ID: 268435626 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435626 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Aniversario 8 Anos' , ICON = N'club01_29' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435626 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435626, N'Conj. Aniversario 8 Anos', N'club01_29', 10000000, 0, 4, 0 ) END -- Item Name: Taqueira de Pascoa -- Item ID: 268435627 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435627 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira de Pascoa' , ICON = N'club03_24' , PRICE = 10000000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435627 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435627, N'Taqueira de Pascoa', N'club03_24', 10000000, 1, 4, 0 ) END -- Item Name: Conj. Aniversario 9 Anos -- Item ID: 268435628 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435628 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Aniversario 9 Anos' , ICON = N'club01_33' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435628 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435628, N'Conj. Aniversario 9 Anos', N'club01_33', 10000000, 0, 4, 0 ) END -- Item Name: Conj. Taqueira Mars -- Item ID: 268435629 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435629 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conj. Taqueira Mars' , ICON = N'club01_24' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435629 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435629, N'Conj. Taqueira Mars', N'club01_24', 10000000, 0, 4, 0 ) END -- Item Name: Conjunto Marie Schrader -- Item ID: 268435630 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435630 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Conjunto Marie Schrader ' , ICON = N'club02_22' , PRICE = 10000000 , ISCASH = 1 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435630 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435630, N'Conjunto Marie Schrader ', N'club02_22', 10000000, 1, 4, 0 ) END -- Item Name: Taqueira Espada de Gelo -- Item ID: 268435631 IF EXISTS ( SELECT TYPEID FROM PANGYA_ITEM_TYPELIST WHERE TYPEID = 268435631 ) BEGIN UPDATE PANGYA_ITEM_TYPELIST SET NAME = N'Taqueira Espada de Gelo' , ICON = N'club02_47' , PRICE = 10000000 , ISCASH = 0 , TYPE = 4 , IS_SALABLE = 0 WHERE TYPEID = 268435631 END ELSE BEGIN INSERT INTO PANGYA_ITEM_TYPELIST ( [TYPEID], [NAME], [ICON], [PRICE], [ISCASH], [TYPE], [IS_SALABLE] ) VALUES ( 268435631, N'Taqueira Espada de Gelo', N'club02_47', 10000000, 0, 4, 0 ) END COMMIT TRAN InsertUpdateTypelist GO -- See you on http://pangya.tsukasa.eu/encyclopedia