• Anuncios

    • Guest

      RGPD (LEY DE 25 DE MAYO DE 2018)   24/05/2018

      Pueden ver el original RGPD del servidor en este enlace (inglés). Opcionalmente, pueden ver una versión adaptada al español aquí: ¡Es muy importante leer y aceptar esto antes de seguir jugando!
    • Terënas

      ¿Necesitas ayuda?   16/08/2018

      Bienvenidos al foro en español de Firestorm
      Si es tu primera vez y no sabes dónde solicitar ayuda para resolver tu problema, te dejamos unos enlaces que seguro te serán de utilidad.   ¿Tienes un problema dentro del juego? ¿No puedes entrar al juego? ¿Compraste puntos y no te han llegado? ¿Fuiste sancionado y quieres apelar? ¿Perdiste una montura u objetos? ¿Encontraste a un jugador haciendo trampa? ¿Compraste algo en la tienda y no te ha llegado? ¿Encontraste un bug (error o fallo) en el juego?   Si deseas contactar con un miembro del Staff puedes ver la lista completa de miembros en el siguiente enlace:    
    • Guest

      ¡Avatares personalizados ahora disponibles!   12/04/2020

      ¡Saludos, usuarios del foro de Firestorm!   ¡A petición popular de los usuarios y debido a los múltiples problemas con la sincronización de avatares del foro con los avatares de la cuenta de los jugadores, ahora los usuarios del foro podrán seleccionar un avatar personalizado y una imagen de fondo en sus perfiles del foro! Para poder cambiar vuestro avatar, deberán acceder a vuestro perfil del foro y pulsar en el icono de imagen que encontrarán junto a vuestro avatar: 1) La imagen no podrá superar los 250 Kb de tamaño. 2) La resolución máxima será de 170x170px.   Para poder cambiar vuestro fondo de perfil, deberán pulsar en el botón de Foto de portada (deberán pulsar a la derecha de dicho botón, por alguna extraña razón): 1) La imagen no podrá superar los 750 Kb de tamaño.   ¡No olviden respetar las normas de cortesía y normas sociales especificadas tanto en el post de normas del foro como en el post de código de conducta del servidor, o su cuenta del foro será sancionada acorde a la gravedad de la falta cometida!   Un saludo y pasen un buen día.
    • Guest

      ¡Cambios de nombre del foro!   27/05/2020

             Nos alegra comunicarles que todo aquel que quiera cambiar su nombre, ya sea porque tenga su correo en su perfil de foro, o simplemente porque haya decidido cambiarlo, ahora podrá hacerlo.   Simplemente tendrá que comentar en este post con el nombre que desea tener en el foro para que su solicitud sea atendida.   No se admitirán nombres que resulten ofensivos y/o inapropiados (sexual, racista, terrorista, etc).                       ¡Un saludo a todos!
kroxirex

[WoD] Bestias tameables

3 posts en este tema

Todas las bestias tameables (menos el lobo, que solo hice los de draenor me dio mucha pereza :v xDDD) pd: hypnos subeme el sueldo que no me pagas suficiente.

por cierto el rylak sale como que no es exotico en wowhead pero si que lo es, fallito de wowhead ajaja

-- Basilisk
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=130,`type_flags`=1 WHERE `entry` IN
(11785,11786,66188,4044,71721,6215,690,20607,42543,689,18461,18463,8302,83405,5419,5420,43339,35245,20924,4728,39186,14227,4729,69358,5935,44113,1551,19730,21816,21854,19729,43981,44138,4863,72329,28145,20283,19706,85694,77492,20783,20279,20280,5990,35409,51013,20987,88481,20925,1552,4041,43181,35750,48724,39658,40403,688,18648,74962,84805,8120,8138,8095,8149,65236,1550,66448,86134);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=130,`type_flags`=1 WHERE `entry` IN
(56650,28203,70858); 


--Bat
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=24,`type_flags`=1 WHERE `entry` IN
(16180,59235,3868,59197,75467,80242,8927,23959,89788,26622,11897,79895,84935,50328,79643,75247,80192,50330,16355,16353,8602,8601,
8600,48456,92627,10357,50329,16173,4861,42338,59984,1554,16354,16175,75466,3866,42714);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=24,`type_flags`=1 WHERE `entry` IN
(1512,61415,1553,1513,87085,42523,28233);


--Bear
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=4,`type_flags`=1 WHERE `entry` IN
(45613,8956,8958,1961,26482,3809,14280,1130,1186,51972,1189,17345,11836,44016,34302,33009,33905,17661,32975,1815,3810,17348,2356,1778,1797,50926,17347,2165,27131,50930,44638,24547,44482,33978,1196,29319,26706,56200,47204,5268,50929,50931,56200,14344,1225,5352,40819,39049,24633,26643,7446,2164,48765,34500,44473,7444,7443,42336,51962,33024,10806,12037,26644,49249,2354,42713,822,34417);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=4,`type_flags`=1 WHERE `entry` IN
(33024,40819);


--Beetle
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=53,`type_flags`=1 WHERE `entry` IN
(51058,40310,8932,10699,5457,5459,16698,6555,5451,5453,11721,11731,11726,40458,51062,47079,15718,51063,15316,51061,15461,47390,3253,10177,15462,39440,51057,15621);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=53,`type_flags`=1 WHERE `entry` IN
(46129,21306,63587,46128,51053,51674,46127,7269,47801,46126,15168);


--Birds of prey
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=26,`type_flags`=1 WHERE `entry` IN
(79854,79851,30988,82354,58457,82175,21804,48450,86750,56034,60866,40194,29453,38154,88677,22979,79398,85852,82312,48448,50345,50335,27249,32481,19429,21891,21904,59384,48449,50337,84013,86748,44481,82829,82828,87651,27244,34982,17034,24787,87652,29044,28004,57215,64937,56171,17129,82758,18257,50044,50342,90245,56396,18257,50044,50342,90245,34886,17035,85753,17053,56199,17039,87671,48447,59641,80226,87649,77442,59700,48451,58910,83436,50343,18220);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=26,`type_flags`=1 WHERE `entry` IN
(44020,85856,48138,44475,91050,59528,60198,59782,24172,58231,69349,87088,59112,21042,59757,64551,23693,60196,60200,56751,23945,24747,66451,44628,86747,89718,56396,42660,42657,42664,42663,42658,42659,26369,7099,7097,59774,61747,85564,48137,25748,25817,14343,47680,85417,48155,22265,70172,57216,1997,1995,1996,92912,46162,62480,62479,62476,79061,17128,19055,7455);
UPDATE `creatre_template´ SET `faction´=84,`type`=1,`family`=26,`type_flags`=1 WHERE `entry` IN
(2597);


--Boar
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=5,`type_flags`=1 WHERE `entry` IN
(75241,82728,93903,74620,345,75241,6021,75416,76914,77124,50948,16863,89689,92875,92876,77129,21878,84893,8303,50937,50946,89688,16880,86153,80174,88589,83897,86151,22180,82617,50942,16879,92887,82726,72934,77298,50947,83719);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=5,`type_flags`=1 WHERE `entry` IN
(75037,36696,34647,44089,77994,1125,46575,3099,38141,21195,3100,50949,157,547,42357,50302,39224,119,42504,3098,44627,44627,330,86150,524,88508,37559,1689,50945,77478,708,113,50940,1985,42859,454,86850,1984);


--Carrion bird
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=7,`type_flags`=1 WHERE `entry` IN
(50812,34640,50803,18470,5983,16972,16973,51760,26174,4695,66368,50807,50814,42235,47202,26483,4693,4694,4692,26838,8207,50810,50813,5429,1109,2831,154,51726,77626,50809,74414,77430,61843,14268,2830,50804,5430,7376,8299,2829,59672,2970,2971,79746,58111,57851,18707,21515,77306,72650,59251,40650,462,2969,199,2931);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=7,`type_flags`=1 WHERE `entry` IN
(428,2580,78108,75348,76819,77627,44184,2579,79752,79920,84233,65629,2578);


--Cat
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=2,`type_flags`=1 WHERE `entry` IN
(24530,24043,52839,24064,14222,728,21723,698,62945,44188,2850,63767,72807,28404,5865,66187,66184,28001,50833,47053,14430,3475,2033,79909,1713,15652,1085,2034,50825,3035,3566,2385,59102,56272,29327,70595,7431,7433,7434,7432,56652,3619,16348,16349,59753,58432,58950,21022,5828,50819,17202,55236,2522,31636,50837,56329,731,58070,59116,58887,59196,58641,58221,59037,977,976,33127,2071,2070,2237,2042,2043,17203,736,28097,37207,37206,62131,52345,88579,72805,77741,10200,66622,2732,79703,2731,2734,20671,66617,66633,18982,50159,50850,3243,3415,3416,3241,3425,58884,66668,2175,684,28297,76685,76687,10737,10741,729,50815,1201,42170,15651,16347,682,772,60875,59534,34034,50838,45096,50818,5807,56198,47726,54700,54699,54688,72808,54988,55238,56655,56653,56683,56654,38046,67085,63538,65612,63537,47687,7430,683,79705,66799,681,63540,66164);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=2,`type_flags`=1 WHERE `entry` IN
(42171,15366,15372,4067,67071,2031,42286,35904,40064,51663,2032);
UPDATE `creatre_template´ SET `faction´=84,`type`=1,`family`=2,`type_flags`=1 WHERE `entry` IN
(43498);


--Clefthoof
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=43,`type_flags`=1 WHERE `entry` IN
(17132,29931,29838,90124,28288,83483,50993,77519,30445,29469,78920,78919,32361,78364,86731,81898,78575,30447,28009,86520,79034,76389,75771,78528,78572,78570,78571,72162,17133,78574,76711,76710,18259,82119,86732,50997,76326,72881,18398,50995);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=43,`type_flags`=1 WHERE `entry` IN
(25489,25488,25487,86847,73234,18205,19183,77513,22105,86000,85537,76576,78918,80420,86730,78576,85031,80136,50990);


--Crab
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=8,`type_flags`=1 WHERE `entry` IN
(40238,54557,72766,50952,24287,41520,40239,46369,93226,65823,58809,74508,34369,50957,50959,26521,66472,73166,67896,68583,68584,83840,60401,46606);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=8,`type_flags`=1 WHERE `entry` IN
(63723,60437,63722,17217,63347,50955,3812,89216,32935,18241,40764,40527,87283,61091,3108,2233,12347,93058,45087,24478,23929,84432,33712,39418,44116,51714,25481,69384,3107,1088,84341,61446,41295,39004,41922,66476,33713,40276,830,88076,40889,831,1216,922,41609,17216,2544,64436,3814,40798,44390,88926,40685,87268,3106,88922,66748,58880,61090,58881);


--Crane
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=125,`type_flags`=1 WHERE `entry` IN
(72762,73158,57299,58766,58741,59763,63796,50885,58885);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=125,`type_flags`=1 WHERE `entry` IN
(58116,60616,63584,59665,58694,67128,59786,59787,65819,59105,58450,56752,71143,72761);


--Crocolisk
UPDATE `creature_template` SET `faction`=16,`type`=1,`family`=6,`type_flags`=1 WHERE `entry` IN
(13596,3581,50964,50967,17952,24138,56183,58455,47591,54558,45321,41419,45896,46317,51675,44108,36882,37078,1693,28002,28325,43658,45807,5053,20773,3110,1150,73476,62023,1152,2635,4341,4344,17144,4345,2476,60282,41420,46281,4841,58755,62008,46278,60203,14233,39452,52413,60201,4343,46280,60202,58804);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=6,`type_flags`=1 WHERE `entry` IN
(24047,51662);


--Direhorn
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=138,`type_flags`=1 WHERE `entry` IN
(69277,70493,70018,70017,69983,70019,70016,69992,70014,70015,70012,70013);
UPDATE `creature_template` SET `faction`=7,`type`=1,`family`=138,`type_flags`=1 WHERE `entry` IN
(67576,69246);


--Dog
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=52,`type_flags`=1 WHERE `entry` IN
(16181,9042,51045,30664,31010,30963,31404,10356,25355,51042,45453,8921,8922,53614,25718,1548,22394,1547,23994,16177,51046,8598,32163,30952,51037,26730,53414,26281,37718,59309,27329,16178,51044,8597,1549,51048,819,16176,51040,58876,51031,29452,29889);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=52,`type_flags`=1 WHERE `entry` IN
(58674,45367,41561);
UPDATE `creatre_template´ SET `faction´=84,`type`=1,`family`=52,`type_flags`=1 WHERE `entry` IN
(44476,83815);


--Dragonhawk
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=30,`type_flags`=1 WHERE `entry` IN
(23834,23598,18155,20502,50353,20038,25867,50357);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=30,`type_flags`=1 WHERE `entry` IN
(15650,15649);


--Fox
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=50,`type_flags`=1 WHERE `entry` IN
(51077,55565,51076,44551,58548,58549);
PDATE `creature_template´ SET `faction`=7,`type`=1,`family`=50,`type_flags`=1 WHERE `entry` IN
(45380,47676,37492,43084,38881,36512,45335,44635,43083,49565,44474);


--Goat
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=129,`type_flags`=1 WHERE `entry` IN
(59680,60748,60668,60493,50998);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=129,`type_flags`=1 WHERE `entry` IN
(58448,72275,69523,59139,60242,60511,58892,66208,66464);


--Gorilla
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=9,`type_flags`=1 WHERE `entry` IN
(1557,1511,50986,5260,28096,28213,1559,1516,14491,1558,2521,59742,59747,9622,6585,6514,6513,6516);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=9,`type_flags`=1 WHERE `entry` IN
(28098,51661);


--Hydra
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=68,`type_flags`=1 WHERE `entry` IN
(43296,7273,18105,3652,28003,80401,80372,80558,80559,88489,80560,79020,18214,80122,80471,3398,84955,80398,80405,80404,80403,80453,81537,80370,85693,80541,80542,80543,22884,52418,20775,18213,18286,3722,3721,20324,4374,86265,12207,89031,83393,85473,85429,86266,12940,);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=68,`type_flags`=1 WHERE `entry` IN
(93010,82050);


--hyena
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=25,`type_flags`=1 WHERE `entry` IN
(60932,5426,45353,4688,35811,4250,14228,13036,12418,4127,37086,50855,4316,47327,45202,4660,5427,4690,51671,8300,45204,39185,50856,5985,78489,5829,4689,60800,27294);


--Monkey
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=51,`type_flags`=1 WHERE `entry` IN
(51052,87362,43417,35812);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=51,`type_flags`=1 WHERE `entry` IN
(34699,52441,48442,48278,48440,48441,43050);


--Moth
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=37,`type_flags`=1 WHERE `entry` IN
(76668,25498,77441,79595,78390,77719,21839,57421,57422,18438,86810,21373,87425,50864,18437);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=37,`type_flags`=1 WHERE `entry` IN
(25464,17349,63725,57232,77331,50858,77328,66319,27421,66514,65799,82192,86757,87089,17350,18469,79910,20611,79923,59785,18468,16520);


--Nether ray
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=34,`type_flags`=1 WHERE `entry` IN
(18285,50362,20196,21128,17731,18130,18131,18880,21901,23501,50361,75487);


--Porcupine
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=127,`type_flags`=1 WHERE `entry` IN
(50944,64745,65839,59772);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=127,`type_flags`=1 WHERE `entry` IN
(54896,64745,65118);


-Raptor
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=11,`type_flags`=1 WHERE `entry` IN
(50876,20728,20729,4357,4351,4356,4352,88495,37956,3123,3122,50882,22052,20751,14232,85565,3632,3637,3636,3633,3634,37090,26641,26824,26628,29698,1019,21124,34543,23873,86425,29334,64638,2561,1016,41400,41401,2559,2560,687,86423,34829,9684,9683,686,41343,41342,50875,6505,6507,6581,6506,1140,85970,50865,89742,89745,89744,39385,20634,38187,685,44165,3254,44167,44164,3255,3256,5842,50874,730,36740,37083,37084,92694,65428,6508,88956,88951,88957);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=11,`type_flags`=1 WHERE `entry` IN
(37961,87084);


--Ravenger
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=31,`type_flags`=1 WHERE `entry` IN
(50725,84058,86286,86294,89741,17525,78856,78857,88630,86455,92429,85516,88578,80715,50728,17527,21423,83522,80779,80782,79726,50726,50370,50320,50731,23326,85756,16934,19189,88523,16932,16933,22123,78931,80224,50724,82632,82632,83517,50727,81561,19349,19350,85453,86263,50730,85779);
UPDATE `creature_template´ SET `faction`=83,`type`=1,`family`31,`type_flags`=1 WHERE `entry` IN
(19461);


--River beast
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=150,`type_flags`=1 WHERE `entry` IN
(92981,85907,77715,85743,77431,83388,88669,93002,79587,88586,87666,86780,85906,79662,79577,72606,92979,75468,83455,87021);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=150,`type_flags`=1 WHERE `entry` IN
(83841,85762,82905,82310,88075,87020,86848);


--Scorpid
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=20,`type_flags`=1 WHERE `entry` IN
(3126,51000,8301,3125,7078,91314,7405,5823,15196,8926,44599,44546,40717,40656,44587,40581,15336,62162,63728,65632,62759,14476,50154,51403,51404,51402,51401,63833,63726,63586,15317,63588,47803,21864,4697,4696,4699,22100,48130,7803,39183,51002,61299,51007,85562,51010,11737,11736,11735,51008,51004,15240,45859,51001,7022,51673,3127,9691,5937,64982);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=20,`type_flags`=1 WHERE `entry` IN
(64983,53240,3281,3124);


--Serpent
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=35,`type_flags`=1 WHERE `entry` IN
(50737,25721,26322,40657,50735,19784,5048,5762,5755,28011,52224,5225,48131,48132,52085,52173,7268,50738,25711,44594,28358);


--Spider
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=3,`type_flags`=1 WHERE `entry` IN
(10376,10596,54338,67087,58568,58475,58459,58588,47115,45582,930,18983,58474,84097,84190,30206,15975,8933,92532,4040,22044,616,52146,53753,52648,49346,16170,14279,4412,4414,45227,4378,4379,4376,4380,26625,46507,46508,51983,51987,18647,78291,78864,82356,77957,75258,4005,4007,4006,89791,54322,15974,18466,18467,62000,61981,66686,66695,64321,64323,74583,58883,2350,1195,30,80212,80247,80211,4415,2565,2001,1994,5856,5858,16352,14472,76891,50759,50778,54323,78872,12433,7319,1111,1112,50775,22132,50765,43,76473,471,17523,17522,574,31747,50777,50764,1824,74584,2563,41185,47117,8277,20998,20714,23958,11739,37045,11738,5857,50763,2707,43007,14266,56070,54324,1781,44906,46751,1780,54321,858,48248,42879,59488,16351,16350,10375,10359,67099,42337,77634,86507,50752,442,20682,32475,28342,28221,89756,1822,15976,217,75113,76517,1555,36813,58808,1998,2000,1986,1999,65622,65653,3821,3819,3820,17683,50770);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=3,`type_flags`=1 WHERE `entry` IN
(1504,44284,1505,1688,52981,65658);
UPDATE `creature_template´ SET `faction`=83,`type`=1,`family`=3,`type_flags`=1 WHERE `entry` IN
(48268,47205,2349);


--Sporebat
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=33,`type_flags`=1 WHERE `entry` IN
(84856,82323,83720,50779,18280,17724,75482,73013,79332);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=33,`type_flags`=1 WHERE `entry` IN
(18129,81138,18128,84639,20387);


--Stag
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=151,`type_flags`=1 WHERE `entry` IN
(18258,26616,78279,78278,33311,86729,82778,46970,48184,76442,27230,59743,59744,78274,78276,78275,20777,82116,26363,56532,86728,86727,51961,82513,34318,58489,48918);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=151,`type_flags`=1 WHERE `entry` IN
(66605,4018,78277,83843,83470,37786,31236,3818,58454,48455,47263,4166,4019,39588,18964,51713,25680,17201,17200,8761,25750,66421,82031,62763,3817,40193,59104,12296,59745,26615,45302,20610,17130,17131,35096,3816,58490,86801);


--Tallstrider
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=12,`type_flags`=1 WHERE `entry` IN
(17374,22807,3068,17373,17372);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=12,`type_flags`=1 WHERE `entry` IN
(2956,37091,50884,2957,32997,3246,2321,3244,56753,3245,2955,50886,2172,37085,39337,45825);
 


--Turtle
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=21,`type_flags`=1 WHERE `entry` IN
(50854,38845,22885,64726,7977,74446,69998,56833,56447,3461,76954,56832,74722,67763,51014,50058);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=21,`type_flags`=1 WHERE `entry` IN
(3653,36732,63981,58431,62160,6352,14223,72765,58940,72764,73161,72763,8213,58811,33710,44626,67895,4397,59084,33711,66462,61619,66099,58218,58219,2505,25482,58941,58942,61971,64725,67703,2408,45950,14123,13599,48128,5431,56256);


--Warp Stalker
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=32,`type_flags`=1 WHERE `entry` IN
(80081,86774,23219,80082,41645,77443,86773,50313,79745,51017,23163,83553,86772,20906,75483,93236,93003,79721,79779,51021,18884,18465,18464,51018);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=32,`type_flags`=1 WHERE `entry` IN
(87086);

--Wasp
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=44,`type_flags`=1 WHERE `entry` IN
(15369,15509,18283,89789,20197,50891,83681,77146,5455,50905,81168,85403,50892,83444,86264,20198,51712,50897,52442,75471,81557,6554,6551,5450,5441,84852,13136,11698,15546,15325,11727,58363,89837,48038,76438,65802,65814,19632,44620,18133,50906,45402,65616,56201,50903,5350,14475,28085,28086,83447,48179,14661,83520,84912,82371,77314,82370,50901,18132,15235,15236,86833,86834,52379,50895,66194,84865,84866,86835,65617,14474,5244,5245);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=44,`type_flags`=1 WHERE `entry` IN
(85807,56283,85532,84905,84909,62386,85695,59768,54559,52377,52375,52373,52376,59351,85526);


--Wind serpent
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=27,`type_flags`=1 WHERE `entry` IN
(50784,28477,29693,50785,48249,50786,46146,63543,20673,37557,5307,4118,50797,20749,50788,4348,5349,5834,50792,55317,4117,19428,3630,20797,5056,3631,5756,21123,26806,5291,8336,14234,26446,50790,4346,4347);


--Wolf (only draenor)
UPDATE `creature_template´ SET `faction`=16,`type`=1,`family`=1,`type_flags`=1 WHERE `entry` IN
(81001,86932,81000,86931,90427,91250,95305,86414,82209,82205,81902,80263,81718,80160,82912,79755,84044,76707,76705,74206,74712,74169,74208,82307,76593,76597,81774,82308,82535);
UPDATE `creature_template´ SET `faction`=7,`type`=1,`family`=1,`type_flags`=1 WHERE `entry` IN
(76181,87107,92521,84045,86851,74748);
UPDATE `creature_template´ SET `faction`=35,`type`=1,`family`=1,`type_flags`=1 WHERE `entry` IN
(84793,92906);
UPDATE `creature_template´ SET `faction`=83,`type`=1,`family`=1,`type_flags`=1 WHERE `entry` IN
(77886,73619,76150,76337);

Editado por kroxirex

Compartir este post


Enlace al post
Compartir en otros sitios

Muy buen trabajo, si señor. A ver si mañana lo chekeo para que este en los lives este lunes.

Eres un figura ;) . 

Pdta: el aumento de sueldo pideselo al jefe que yo no soy :D:P .

Compartir este post


Enlace al post
Compartir en otros sitios

Aceptado. Unas cosillas. No creo que vuelvas a hacer parches asi grandes pero si se diera el caso te recomiendo bajarte la db de wod de trinity, un gestor de sql como sqlyog por ejemplo y probar los parches ahi antes de ponerlos en el foro. Tienes la guia1 si por un casual quisieras hacerlo. ¿por que te comento esto? Pues porque tiene unos cuantos fallos, que son normales cuando haces parches grandes pero por eso se prueba antes para que el que los tenga que ver no se encuentre con que tiene que arreglarlo para meterlo :P .

Esos fallos son despistes sin importancia pero hay uno que vienes haciendo a menudo y te lo comento para que lo corrijas. El acento que se pone antes y despues del nombre de una columna o tabla, es siempre el mismo.Es el de la tecla a la derecha de la p. El otro no se pone nunca, te lo comento porque lo haces mucho y da error al meter el parche.

Por lo demas,he verificado alguno y aunque en los osos he visto que hay 70 criaturas en lugar de 67 ( no se de donde salieron las otras 3...) en general cuento con que los fallos en numeros fueron nulos o minimos. Asi es que te felicito porque este parche aunque no era complicado, tenia mucho curro.

Muchas gracias por ayudar a hacer el server mejor ;). Good done!!!!

Compartir este post


Enlace al post
Compartir en otros sitios
Guest
Este tema esta cerrado para más respuestas.