diff options
| -rw-r--r-- | sql/updates/5036_character_updates_dual_spec.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/updates/5036_character_updates_dual_spec.sql b/sql/updates/5036_character_updates_dual_spec.sql index 37e5366453f..1718a70c554 100644 --- a/sql/updates/5036_character_updates_dual_spec.sql +++ b/sql/updates/5036_character_updates_dual_spec.sql @@ -23,7 +23,8 @@ CREATE TABLE `character_talent` ( /* The below DELETE query should remove all known talents from `character_spell`, talents gathered by rockzOr of getmangos.com and updated/fixed by oc_redfox of trinitycore.org. This update should (probably) only be run once, on your characters database before enabling Dual Spec.. */ -DELETE FROM `character_spell` WHERE `spell` IN (11078,18459,11069,11119,54747,11108,11100,11103,11366,11083,11095,11094,29074,31638,11115,11113,31641,11124,34293,11129,31679,64353,31656,44442,31661,44445,44449,44457,11071,11070,31670,11207,11189,29438,11175,11151,12472,11185,16757,11160,11170,11958,11190,31667,55091,11180,44745,11426,31674,31682,44543,44546,31687,44557,44566,44572,11210,11222,11237,28574,29441,11213,11247,11242,44397,54646,11252,11255,18462,29447,31569,12043,11232,31574,15058,31571,31579,12042,44394,44378,31584,31589,44404,44400,35578,44425,12282,16462,12286,12285,12300,12295,12290,12296,16493,12834,12163,56636,12700,12328,12284,12281,20504,12289,46854,29834,12294,46865,12862,64976,35446,46859,29723,29623,29836,46867,46924,12301,12298,12287,50685,12297,12975,12797,29598,12299,59088,12313,12308,12312,12809,12311,16538,29593,50720,29787,29140,46945,57499,20243,47294,46951,58872,46968,61216,12321,12320,12324,12322,12329,12323,16487,12318,23584,20502,12317,29590,12292,29888,20500,12319,46908,23881,29721,46910,29759,60970,29801,46913,56927,46917,13741,13732,13715,14165,13713,13705,13742,14251,13706,13754,13743,13712,18427,13709,13877,13960,30919,31124,31122,13750,31130,5952,35541,51672,32601,51682,51685,51690,14162,14144,14138,14156,51632,13733,14983,14168,14128,16513,14113,31208,14177,14174,31244,14186,14158,51625,58426,31380,51634,31234,31226,1329,51627,51664,51662,14179,13958,14057,30892,14076,13975,13981,14278,14171,13983,13976,14079,30894,14185,14082,16511,31221,30902,31211,14183,31228,31216,51692,51698,36554,58414,51708,51713,14522,47586,14523,14747,14749,14531,14521,14751,14748,33167,14520,14750,33201,18551,63574,33186,34908,45234,10060,63504,57470,47535,47507,47509,33206,47516,52795,47540,14913,14908,14889,27900,18530,19236,27811,14892,27789,14912,14909,14911,20711,14901,33150,14898,34753,724,33142,64127,33158,63730,63534,34861,47558,47562,47788,15270,15337,15259,15318,15275,15260,15392,15273,15407,15274,17322,15257,15487,15286,27839,33213,14910,63625,15473,33221,47569,33191,64044,34914,47580,47573,47585,16039,16035,16038,28996,30160,16040,16164,16089,16086,29062,28999,16041,30664,30672,16578,16166,51483,63370,51466,30675,51474,30706,51480,62097,51490,16182,16173,16184,29187,16179,16180,16181,55198,16176,16187,16194,29206,16188,30864,16178,30881,16190,51886,51554,30872,30867,51556,974,51560,51562,61295,16259,16043,17485,16258,16255,16262,16261,16266,43338,16254,16256,16252,29192,16268,51883,30802,29082,63373,30816,30798,17364,51525,60103,51521,30812,30823,51523,51528,51533,16934,16858,16947,16998,16929,17002,61336,16942,16966,16972,37116,48409,16940,49377,33872,57878,17003,33853,17007,34297,33851,57873,33859,48483,48492,33917,48532,48432,63503,50334,17050,17063,17056,17069,17118,16833,17106,16864,48411,24968,17111,17116,17104,17123,33879,17074,34151,18562,33881,33886,48496,48539,65139,48535,63410,51179,48438,16814,57810,16845,35363,16821,16836,16880,57865,16819,16909,16850,33589,5570,57849,33597,16896,33592,24858,48384,33600,48389,33603,48516,50516,33831,48488,48506,48505,17793,17788,18119,63349,17778,18126,17877,17959,18135,17917,17927,34935,17815,18130,30299,17954,17962,30293,18096,30288,54117,47258,30283,47220,47266,50796,18827,18174,17810,18179,18213,18182,17804,53754,17783,18288,18218,18094,32381,32385,63108,18223,54037,18271,47195,30060,18220,30054,32477,47198,30108,58435,47201,48181,18692,18694,18697,47230,18703,18705,18731,18754,19028,18708,30143,18769,18709,30326,18767,23785,47245,30319,47193,35691,30242,63156,54347,30146,63117,47236,59672,19552,19583,35029,19549,19609,24443,19559,53265,19616,19572,19598,19578,19577,19590,34453,19621,34455,19574,34462,53252,34466,53262,34692,53256,56314,53270,52783,19498,19159,19290,19184,19376,34494,19255,19503,19295,19286,56333,56342,56339,19370,19306,19168,34491,34500,19386,34497,34506,53295,53298,3674,53302,53290,53301,19407,53620,19426,34482,19421,19485,34950,19454,19434,34948,19464,19416,35100,23989,19461,34475,19507,53234,19506,35104,34485,53228,53215,34490,53221,53241,53209,20060,20101,25956,20335,20042,9452,20117,20375,26022,9799,32043,31866,20111,31869,20049,31871,53486,20066,31876,31879,53375,53379,35395,53501,53380,53385,20205,20224,20237,20257,9453,31821,20210,20234,20254,20244,53660,31822,20216,20359,31825,5923,31833,20473,31828,53551,31837,31842,53671,53569,53556,53563,63646,20262,31844,20174,20096,64205,20468,20143,53527,20487,20138,20911,20177,31848,20196,31785,20925,31850,20127,31858,53590,31935,53583,53709,53695,53595,48979,48997,49182,48978,49004,55107,48982,48987,49467,48985,49145,49015,48977,49006,49005,48988,53137,49027,49016,50365,62905,49018,55233,49189,55050,49023,61154,49028,49175,49455,49042,55061,49140,49226,50880,49039,51468,51123,49149,49137,49186,49471,49796,55610,49024,49188,50040,49203,50384,54639,51271,49200,49143,50187,49202,49184,51745,48962,55129,49036,48963,49588,48965,49013,51459,49158,49146,49219,55620,49194,49220,49223,49224,49208,52143,55666,51052,50391,63560,49032,49222,49217,51099,55090,50117,49206,61682,61685,61686,61689,53182,19596,53481,53175,61680,53178,53409,63900,53450,53427,53478,53477,53480,53476,62764,62758,61682,61684,23145,61686,61689,53180,53186,53182,19596,61680,53409,61685,52825,55709,53203,53427,53401,53426,53434,62759,62758,61682,61684,23145,61686,61689,19596,53483,53554,53514,53182,61680,53409,54044,53427,52234,53511,53508,53517,53490,53450,62758,53480,11080,18460,12338,11120,54749,12349,12353,12357,12351,12872,13043,29075,31639,11367,31642,12378,34295,31680,64357,31657,44443,44446,44469,12496,12473,31672,12672,28332,29439,12569,12952,12487,16758,12518,12982,12489,31668,55092,28592,54787,31675,31683,44545,44548,44560,44567,12592,12839,12463,54658,29444,12574,12606,12467,44398,12605,12598,18463,55339,31570,12500,31575,15059,31572,31582,44395,44379,31585,54486,44402,35581,12663,16463,12658,12697,12959,12676,12963,16494,12849,12711,56637,12781,12701,12812,20505,12668,46855,29838,46866,12330,35448,46860,29725,29859,56611,12818,12724,12665,50686,12750,12799,29599,12761,59089,12804,12810,12803,12958,16539,29594,29790,29143,46949,47295,46952,58874,61221,12835,12852,12876,12999,12950,16489,12857,23585,20503,13045,29591,29889,20501,12971,46909,29776,46911,29760,46914,56929,13793,13863,13848,14166,13853,13832,13872,13804,13867,13875,13788,18428,13800,13961,30920,31126,31123,31131,51679,35550,51674,58413,51686,14163,14148,14139,14160,51633,13865,14169,14132,16514,14114,31209,14175,31245,14190,14159,51626,31382,51635,31235,31227,51628,51665,58422,13970,14072,30893,14094,14062,14066,14172,14070,13979,14080,30895,14083,31222,30903,31212,31229,31217,51696,51700,58415,51709,14788,47587,14784,14770,14767,14774,14776,14768,33171,14780,14772,33202,18552,33190,34909,45243,63505,57472,47536,47508,47511,47517,52797,15012,15020,15008,27901,18531,27815,15362,27790,15013,15017,15018,15028,33154,15349,34859,33145,64129,33159,63733,63542,47559,47564,15335,15338,15307,15272,15317,15327,15448,15312,15311,17323,15331,27840,33214,33371,63626,33222,47570,33192,47581,47577,16109,16105,16160,28997,29179,16113,60184,16544,29064,29000,30665,30673,16579,51485,63372,51470,30678,51478,51481,62098,16226,16222,16209,29189,16214,16196,16230,16235,16205,16218,29205,30865,16210,30883,51555,30873,30868,51557,51561,51563,16295,16130,17486,16293,16302,16287,16290,29079,16271,16281,16306,29193,51884,30808,29084,63374,30818,51526,51522,30813,51524,51529,16935,16859,16948,16999,16930,24866,16943,16968,16974,37117,48410,16941,33873,57880,17004,33855,34300,33852,57876,33866,48484,48494,48489,48433,17051,17065,17058,17070,17119,16834,17107,48412,24969,17112,24943,17124,33880,17075,34152,33882,33887,48499,48544,48536,63411,51180,16815,57811,16846,35364,16822,16839,61345,16820,16910,16923,33590,57850,33599,16897,33596,48395,33601,48392,33604,48521,48514,48510,17796,17789,18120,63350,17779,18127,59738,18136,17918,17929,34938,17833,30301,17955,30295,18073,30289,54118,47259,47221,47267,18829,18175,17811,18180,18372,18183,17805,53759,17784,18219,18095,32382,32387,54038,18272,47196,30061,30057,32483,47199,47202,18693,18695,18698,47231,18704,18706,18743,18755,30144,18770,18710,18768,23822,47246,30320,35692,30245,63158,54348,63121,47237,19553,19584,35030,19550,19610,19575,19560,19617,19573,19599,20895,19592,34454,19622,34459,34464,53253,34467,53263,53259,56315,52785,19499,19160,19294,19387,63457,34496,19256,19297,19287,56336,56343,56340,19371,19180,34492,34502,34498,34507,53296,53299,53303,53291,19412,53621,19427,34483,19422,19487,34954,19455,34949,19465,19417,35102,19462,34476,19508,53237,35110,34486,53232,53216,53222,53243,20061,20102,25957,20336,20045,26016,20118,26023,25988,35396,31867,20112,20056,31872,53488,31877,31880,53376,53484,53502,53381,20206,20225,20238,20258,25836,20212,20235,20255,20245,53661,31823,20360,31826,5924,31835,31829,53552,31838,53673,53576,53557,63647,20263,31845,20175,20097,20469,20144,53530,20488,20139,20179,31849,20197,33776,31851,20130,31859,53591,53585,53710,53696,49483,49490,49500,49390,49508,55108,49477,50033,49488,49495,50154,49394,49526,49503,53138,49542,50371,62908,49529,50149,49533,61155,50031,50147,49786,55062,49661,50137,50884,51472,51127,50115,49657,51108,49790,49538,56822,50041,50385,54638,50151,50190,50127,51746,49567,55130,49562,49564,49589,49571,55236,51462,51267,49627,55623,49633,49599,49610,56834,55667,50392,49631,49654,51160,50118,61683,61687,61690,53183,53482,53176,61681,53179,53411,53451,53429,62765,62762,61683,61687,61690,53181,53187,53183,61681,53411,53204,53429,62760,62762,61683,61687,61690,53485,53555,53516,53183,61681,53411,53429,53497,53512,53451,62762,54734,12339,12846,12350,12358,12873,29076,31640,11368,12398,34296,31658,44448,44470,12497,16763,55094,15047,29440,12571,12953,12488,12519,12983,12490,31669,28593,31676,44549,44561,44568,12840,12464,54659,12575,12469,44399,18464,55340,12501,54354,15060,31583,44396,31586,54488,44403,12664,16464,12960,12677,12867,12712,56638,12783,12702,12813,23695,35449,29724,56612,12725,12666,50687,12751,12762,12811,16540,29792,29144,47296,46953,61222,12853,12877,13000,20496,16492,12858,23586,13046,29592,12972,56924,29761,46915,56930,13792,13849,13854,13843,13805,13789,18429,13801,13962,61329,35551,51687,14164,14140,14161,13866,14135,16515,14115,14176,14193,31383,51636,31236,58410,51629,51667,58423,13971,14063,14173,14071,13980,31223,30904,31213,31230,31218,51701,51710,14789,47588,14785,14771,14777,14769,33172,14781,18553,34910,45244,63506,47537,47515,52798,17191,15009,27902,18533,27816,15363,15014,15029,15354,34860,33146,33160,63737,63543,47560,47565,15336,15308,15320,15328,15313,15332,33215,63627,33223,33193,47582,47578,16110,16106,16161,28998,29180,16114,60185,29065,30666,30674,16580,51486,30679,51479,51482,62099,16227,16223,29191,16215,16198,16232,16240,16206,16219,29202,30866,16211,30884,30869,51558,51564,52456,17487,16303,51881,29080,16272,16282,16307,51885,30809,29086,30819,51527,30814,51530,16936,16860,16949,16931,16944,16975,57881,17005,33856,33957,57877,33867,48485,48495,48491,48434,17066,17059,17071,17120,16835,17108,24970,17113,24944,17076,34153,33883,33888,48500,48545,48537,51181,16816,57812,16847,16840,61346,16911,16924,33591,57851,33956,16899,48396,33602,48393,33605,48525,48511,17801,17790,63351,17780,59739,17930,34939,17834,30302,17956,30296,63245,30290,47260,47223,47268,18176,17812,17785,32383,32392,18273,47197,30062,32484,47200,47203,18696,18699,18707,18744,18756,30145,18771,23823,47247,30321,35693,30246,54349,63123,47238,19554,19585,19551,19612,19618,19600,19623,34460,34465,34468,53264,53260,56316,52786,19500,24283,19388,63458,19257,19298,56337,56344,56341,19373,19181,34493,34503,34499,34508,53297,53304,53292,53622,19429,34484,19423,19488,19456,19466,19418,24691,19509,53238,35111,34487,53217,53224,53244,20062,20103,20337,20119,35397,31868,20113,20057,31878,31881,53648,53503,53382,20207,20330,20239,20259,20213,20256,20361,5925,31836,31830,53553,31839,54151,63648,20264,53519,20098,20470,20145,20140,20181,20198,31852,20135,31860,53592,53711,49491,49501,49391,49509,49478,50034,49489,49497,55136,49395,50029,49504,49543,49530,50150,49534,61156,51456,49787,49662,50138,50885,51473,51128,51109,49791,59057,50043,54637,50152,50191,50128,49568,55131,49565,49572,55237,51463,49628,49635,49611,56835,55668,49632,49655,51161,50119,61688,53184,52858,53430,61688,53184,52858,53205,53430,61688,53184,52858,53430,12340,12847,12399,44471,16765,31677,44570,16769,12576,12502,31587,54489,16465,12784,12703,12814,56613,12726,12752,12763,16541,12855,12878,13001,12860,23587,13047,12973,29762,56931,13851,13844,13806,61330,13802,13963,35552,51688,14141,14136,14116,14194,51668,58424,30905,31219,51711,14790,52802,18554,52799,15010,27903,18534,15030,15355,33161,47566,15309,15314,33224,51166,16111,16107,16115,60187,16581,62100,16228,16224,16216,16220,16212,30885,51565,17488,16304,16283,16308,51531,16937,16861,17006,51268,17060,17072,24971,24945,17077,33889,51182,16817,57813,16912,33606,17802,17791,59740,17957,30291,47269,17813,32393,18274,30063,47204,18772,23824,30247,47239,19555,19586,19619,19601,19624,34469,56317,52787,19258,24296,34838,19430,19489,19419,34488,53245,20063,20104,20120,20209,20331,20260,20214,5926,31840,54154,63649,20265,20099,20146,20180,55225,49392,49479,61157,49788,49663,50886,51129,61433,50129,55132,51464,49636,55669,50120,12341,12848,12400,44472,16766,31678,44571,16770,12577,12503,31588,54490,16466,12785,12704,12815,56614,12727,12753,12764,16542,12856,12879,13002,12861,23588,13048,12974,29763,56932,13852,13845,13807,61331,13803,13964,35553,51689,14142,14137,14117,14195,51669,58425,30906,31220,51712,14791,52803,18555,52800,15011,27904,18535,15031,15356,33162,47567,15310,15316,33225,51167,16112,16108,16116,60188,16582,62101,16229,16225,16217,16221,16213,30886,51566,17489,16305,16284,16309,51532,16938,16862,24894,51269,17061,17073,24972,24946,17078,33890,51183,16818,57814,16913,33607,17803,17792,59741,17958,30292,47270,17814,32394,18275,30064,47205,18773,23825,30248,47240,19556,19587,19620,19602,19625,34470,56318,52788,19259,24297,34839,19431,19490,19420,34489,53246,20064,20105,20121,20208,20332,20261,20215,25829,31841,54155,63650,20266,20100,20147,20182,55226,49393,49480,61158,49789,49664,50887,51130,61434,50130,55133,51465,49638,55670,50121);ALTER TABLE `characters` ADD `speccount` tinyint(3) unsigned NOT NULL default 1 AFTER `arena_pending_points`; +DELETE FROM `character_spell` WHERE `spell` IN (724,974,1329,3674,5570,5923,5924,5925,5926,5952,9452,9453,9799,10060,11069,11070,11071,11078,11080,11083,11094,11095,11100,11103,11108,11113,11115,11119,11120,11124,11129,11151,11160,11170,11175,11180,11185,11189,11190,11207,11210,11213,11222,11232,11237,11242,11247,11252,11255,11366,11367,11368,11426,11958,12042,12043,12163,12281,12282,12284,12285,12286,12287,12289,12290,12292,12294,12295,12296,12297,12298,12299,12300,12301,12308,12311,12312,12313,12317,12318,12319,12320,12321,12322,12323,12324,12328,12329,12330,12338,12339,12340,12341,12349,12350,12351,12353,12357,12358,12378,12398,12399,12400,12463,12464,12467,12469,12472,12473,12487,12488,12489,12490,12496,12497,12500,12501,12502,12503,12518,12519,12569,12571,12574,12575,12576,12577,12592,12598,12605,12606,12658,12663,12664,12665,12666,12668,12672,12676,12677,12697,12700,12701,12702,12703,12704,12711,12712,12724,12725,12726,12727,12750,12751,12752,12753,12761,12762,12763,12764,12781,12783,12784,12785,12797,12799,12803,12804,12809,12810,12811,12812,12813,12814,12815,12818,12834,12835,12839,12840,12846,12847,12848,12849,12852,12853,12855,12856,12857,12858,12860,12861,12862,12867,12872,12873,12876,12877,12878,12879,12950,12952,12953,12958,12959,12960,12963,12971,12972,12973,12974,12975,12982,12983,12999,13000,13001,13002,13043,13045,13046,13047,13048,13705,13706,13709,13712,13713,13715,13732,13733,13741,13742,13743,13750,13754,13788,13789,13790,13791,13792,13793,13800,13801,13802,13803,13804,13805,13806,13807,13832,13843,13844,13845,13848,13849,13851,13852,13853,13854,13863,13865,13866,13867,13872,13875,13877,13958,13960,13961,13962,13963,13964,13970,13971,13975,13976,13979,13980,13981,13983,14057,14062,14063,14066,14070,14071,14072,14076,14079,14080,14082,14083,14094,14113,14114,14115,14116,14117,14128,14132,14135,14136,14137,14138,14139,14140,14141,14142,14144,14148,14156,14158,14159,14160,14161,14162,14163,14164,14165,14166,14168,14169,14171,14172,14173,14174,14175,14176,14177,14179,14183,14185,14186,14190,14193,14194,14195,14251,14278,14520,14521,14522,14523,14531,14747,14748,14749,14750,14751,14752,14767,14768,14769,14770,14771,14772,14774,14776,14777,14780,14781,14782,14783,14784,14785,14788,14789,14790,14791,14889,14892,14898,14901,14908,14909,14910,14911,14912,14913,14983,15008,15009,15010,15011,15012,15013,15014,15017,15018,15020,15028,15029,15030,15031,15047,15058,15059,15060,15257,15259,15260,15268,15270,15272,15273,15274,15275,15286,15307,15308,15309,15310,15311,15312,15313,15314,15316,15317,15318,15320,15323,15324,15325,15326,15327,15328,15331,15332,15335,15336,15337,15338,15349,15354,15355,15356,15362,15363,15392,15407,15448,15473,15487,16035,16038,16039,16040,16041,16043,16086,16089,16105,16106,16107,16108,16109,16110,16111,16112,16113,16114,16115,16116,16130,16160,16161,16164,16166,16173,16176,16178,16179,16180,16181,16182,16184,16187,16188,16190,16194,16196,16198,16205,16206,16207,16208,16209,16210,16211,16212,16213,16214,16215,16216,16217,16218,16219,16220,16221,16222,16223,16224,16225,16226,16227,16228,16229,16230,16232,16235,16240,16252,16254,16255,16256,16258,16259,16261,16262,16266,16268,16271,16272,16281,16282,16283,16284,16287,16290,16293,16295,16302,16303,16304,16305,16306,16307,16308,16309,16462,16463,16464,16465,16466,16487,16489,16492,16493,16494,16511,16513,16514,16515,16538,16539,16540,16541,16542,16544,16578,16579,16580,16581,16582,16757,16758,16763,16765,16766,16769,16770,16814,16815,16816,16817,16818,16819,16820,16821,16822,16833,16834,16835,16836,16839,16840,16845,16846,16847,16850,16858,16859,16860,16861,16862,16864,16880,16896,16897,16899,16909,16910,16911,16912,16913,16923,16924,16929,16930,16931,16934,16935,16936,16937,16938,16940,16941,16942,16943,16944,16947,16948,16949,16966,16968,16972,16974,16975,16998,16999,17002,17003,17004,17005,17006,17007,17050,17051,17056,17058,17059,17060,17061,17063,17065,17066,17069,17070,17071,17072,17073,17074,17075,17076,17077,17078,17104,17106,17107,17108,17111,17112,17113,17116,17118,17119,17120,17123,17124,17191,17322,17323,17364,17485,17486,17487,17488,17489,17778,17779,17780,17783,17784,17785,17788,17789,17790,17791,17792,17793,17796,17801,17802,17803,17804,17805,17810,17811,17812,17813,17814,17815,17833,17834,17877,17917,17918,17927,17929,17930,17954,17955,17956,17957,17958,17959,17962,18073,18094,18095,18096,18119,18120,18126,18127,18130,18135,18136,18174,18175,18176,18179,18180,18182,18183,18213,18218,18219,18220,18223,18265,18271,18272,18273,18274,18275,18288,18372,18427,18428,18429,18459,18460,18462,18463,18464,18530,18531,18533,18534,18535,18551,18552,18553,18554,18555,18562,18692,18693,18694,18695,18696,18697,18698,18699,18700,18701,18703,18704,18705,18706,18707,18708,18709,18710,18731,18743,18744,18754,18755,18756,18767,18768,18769,18770,18771,18772,18773,18788,18821,18822,18827,18829,19028,19159,19160,19168,19180,19181,19184,19228,19232,19233,19236,19255,19256,19257,19258,19259,19286,19287,19290,19294,19295,19297,19298,19306,19370,19371,19373,19376,19386,19387,19388,19407,19412,19416,19417,19418,19419,19420,19421,19422,19423,19426,19427,19429,19430,19431,19434,19454,19455,19456,19461,19462,19464,19465,19466,19485,19487,19488,19489,19490,19498,19499,19500,19503,19506,19507,19508,19509,19510,19511,19549,19550,19551,19552,19553,19554,19555,19556,19559,19560,19572,19573,19574,19575,19577,19578,19583,19584,19585,19586,19587,19590,19592,19596,19596,19596,19598,19599,19600,19601,19602,19609,19610,19612,19616,19617,19618,19619,19620,19621,19622,19623,19624,19625,20042,20045,20049,20056,20057,20060,20061,20062,20063,20064,20066,20091,20092,20096,20097,20098,20099,20100,20101,20102,20103,20104,20105,20111,20112,20113,20117,20118,20119,20120,20121,20127,20130,20135,20138,20139,20140,20143,20144,20145,20146,20147,20174,20175,20177,20179,20180,20181,20182,20196,20197,20198,20199,20200,20205,20206,20207,20208,20209,20210,20212,20213,20214,20215,20216,20217,20224,20225,20234,20235,20237,20238,20239,20243,20244,20245,20254,20255,20256,20257,20258,20259,20260,20261,20262,20263,20264,20265,20266,20330,20331,20332,20335,20336,20337,20359,20360,20361,20375,20468,20469,20470,20473,20487,20488,20489,20496,20500,20501,20502,20503,20504,20505,20711,20895,20911,20925,23145,23145,23584,23585,23586,23587,23588,23695,23785,23822,23823,23824,23825,23881,23989,24283,24296,24297,24443,24691,24858,24866,24894,24943,24944,24945,24946,24968,24969,24970,24971,24972,25829,25836,25956,25957,25988,26016,26022,26023,27789,27790,27811,27815,27816,27839,27840,27900,27901,27902,27903,27904,28332,28574,28592,28593,28996,28997,28998,28999,29000,29062,29064,29065,29074,29075,29076,29079,29080,29082,29084,29086,29140,29143,29144,29179,29180,29187,29189,29191,29192,29193,29202,29205,29206,29438,29439,29440,29441,29444,29447,29590,29591,29592,29593,29594,29598,29599,29623,29721,29723,29724,29725,29759,29760,29761,29762,29763,29776,29787,29790,29792,29801,29834,29836,29838,29859,29888,29889,30054,30057,30060,30061,30062,30063,30064,30108,30143,30144,30145,30146,30160,30242,30245,30246,30247,30248,30283,30288,30289,30290,30291,30292,30293,30295,30296,30299,30301,30302,30319,30320,30321,30326,30327,30328,30664,30665,30666,30672,30673,30674,30675,30678,30679,30680,30681,30706,30798,30802,30808,30809,30810,30811,30812,30813,30814,30816,30818,30819,30823,30864,30865,30866,30867,30868,30869,30872,30873,30881,30883,30884,30885,30886,30892,30893,30894,30895,30902,30903,30904,30905,30906,30919,30920,31122,31123,31124,31126,31130,31131,31208,31209,31211,31212,31213,31216,31217,31218,31219,31220,31221,31222,31223,31226,31227,31228,31229,31230,31234,31235,31236,31244,31245,31380,31382,31383,31569,31570,31571,31572,31574,31575,31579,31582,31583,31584,31585,31586,31587,31588,31589,31638,31639,31640,31641,31642,31656,31657,31658,31661,31667,31668,31669,31670,31672,31674,31675,31676,31677,31678,31679,31680,31682,31683,31687,31785,31821,31822,31823,31825,31826,31828,31829,31830,31833,31835,31836,31837,31838,31839,31840,31841,31842,31844,31845,31848,31849,31850,31851,31852,31853,31854,31858,31859,31860,31866,31867,31868,31869,31871,31872,31876,31877,31878,31879,31880,31881,31882,31883,31935,32043,32381,32382,32383,32385,32387,32392,32393,32394,32477,32483,32484,32601,33142,33145,33146,33150,33154,33158,33159,33160,33161,33162,33167,33171,33172,33174,33182,33186,33190,33191,33192,33193,33201,33202,33203,33206,33213,33214,33215,33221,33222,33223,33224,33225,33371,33589,33590,33591,33592,33596,33597,33599,33600,33601,33602,33603,33604,33605,33606,33607,33776,33831,33851,33852,33853,33855,33856,33859,33866,33867,33872,33873,33879,33880,33881,33882,33883,33886,33887,33888,33889,33890,33891,33917,33956,33957,34151,34152,34153,34293,34295,34296,34297,34300,34453,34454,34455,34459,34460,34462,34464,34465,34466,34467,34468,34469,34470,34475,34476,34482,34483,34484,34485,34486,34487,34488,34489,34490,34491,34492,34493,34494,34496,34497,34498,34499,34500,34502,34503,34506,34507,34508,34692,34753,34838,34839,34859,34860,34861,34908,34909,34910,34911,34912,34914,34935,34938,34939,34948,34949,34950,34954,35029,35030,35100,35102,35103,35104,35110,35111,35363,35364,35395,35396,35397,35446,35448,35449,35541,35550,35551,35552,35553,35578,35581,35691,35692,35693,36554,37116,37117,43338,44378,44379,44394,44395,44396,44397,44398,44399,44400,44402,44403,44404,44425,44440,44441,44442,44443,44445,44446,44448,44449,44457,44469,44470,44471,44472,44543,44545,44546,44548,44549,44557,44560,44561,44566,44567,44568,44570,44571,44572,44745,45234,45243,45244,46854,46855,46859,46860,46865,46866,46867,46908,46909,46910,46911,46913,46914,46915,46917,46924,46945,46949,46951,46952,46953,46968,47193,47195,47196,47197,47198,47199,47200,47201,47202,47203,47204,47205,47220,47221,47223,47230,47231,47236,47237,47238,47239,47240,47245,47246,47247,47258,47259,47260,47266,47267,47268,47269,47270,47294,47295,47296,47507,47508,47509,47511,47515,47516,47517,47535,47536,47537,47538,47539,47540,47549,47551,47552,47555,47556,47557,47558,47559,47560,47562,47564,47565,47566,47567,47569,47570,47571,47572,47573,47577,47578,47580,47581,47582,47585,47586,47587,47588,47788,48079,48080,48081,48181,48384,48389,48392,48393,48395,48396,48409,48410,48411,48412,48432,48433,48434,48438,48483,48484,48485,48488,48489,48491,48492,48494,48495,48496,48499,48500,48505,48506,48510,48511,48514,48516,48521,48525,48532,48535,48536,48537,48539,48544,48545,48962,48963,48965,48977,48978,48979,48982,48985,48987,48988,48997,49004,49005,49006,49013,49015,49016,49018,49023,49024,49027,49028,49032,49036,49039,49042,49137,49140,49143,49145,49146,49149,49157,49158,49175,49182,49184,49186,49188,49189,49194,49200,49202,49203,49206,49208,49217,49219,49220,49222,49223,49224,49226,49377,49390,49391,49392,49393,49394,49395,49455,49467,49471,49477,49478,49479,49480,49483,49488,49489,49490,49491,49495,49497,49500,49501,49503,49504,49508,49509,49526,49529,49530,49531,49532,49533,49534,49538,49542,49543,49562,49564,49565,49567,49568,49571,49572,49588,49589,49599,49610,49611,49612,49614,49627,49628,49631,49632,49633,49635,49636,49638,49654,49655,49657,49661,49662,49663,49664,49786,49787,49788,49789,49790,49791,49796,50029,50031,50033,50034,50040,50041,50043,50115,50117,50118,50119,50120,50121,50127,50128,50129,50130,50137,50138,50147,50148,50149,50150,50151,50152,50154,50187,50190,50191,50334,50365,50371,50384,50385,50391,50392,50516,50685,50686,50687,50720,50796,50880,50884,50885,50886,50887,51052,51099,51108,51109,51123,51127,51128,51129,51130,51160,51161,51166,51167,51179,51180,51181,51182,51183,51267,51268,51269,51271,51456,51459,51462,51463,51464,51465,51466,51468,51470,51472,51473,51474,51478,51479,51480,51481,51482,51483,51485,51486,51490,51521,51522,51523,51524,51525,51526,51527,51528,51529,51530,51531,51532,51533,51554,51555,51556,51557,51558,51560,51561,51562,51563,51564,51565,51566,51625,51626,51627,51628,51629,51632,51633,51634,51635,51636,51662,51664,51665,51667,51668,51669,51672,51674,51679,51682,51685,51686,51687,51688,51689,51690,51692,51696,51698,51700,51701,51708,51709,51710,51711,51712,51713,51745,51746,51881,51883,51884,51885,51886,52143,52234,52456,52783,52785,52786,52787,52788,52795,52797,52798,52799,52800,52802,52803,52825,52858,52858,52858,53137,53138,53175,53176,53178,53179,53180,53181,53182,53182,53182,53183,53183,53183,53184,53184,53184,53186,53187,53203,53204,53205,53209,53215,53216,53217,53221,53222,53224,53228,53232,53234,53237,53238,53241,53243,53244,53245,53246,53252,53253,53256,53259,53260,53262,53263,53264,53265,53270,53290,53291,53292,53293,53294,53295,53296,53297,53298,53299,53301,53302,53303,53304,53375,53376,53379,53380,53381,53382,53383,53384,53385,53401,53409,53409,53409,53411,53411,53411,53426,53427,53427,53427,53429,53429,53429,53430,53430,53430,53434,53450,53451,53476,53477,53478,53480,53481,53482,53483,53484,53485,53486,53488,53490,53497,53501,53502,53503,53508,53511,53512,53514,53516,53517,53519,53527,53530,53551,53552,53553,53554,53555,53556,53557,53563,53569,53576,53583,53585,53590,53591,53592,53595,53620,53621,53622,53648,53660,53661,53671,53673,53695,53696,53709,53710,53711,53754,53759,54037,54038,54044,54117,54118,54151,54154,54155,54347,54348,54349,54354,54486,54488,54489,54490,54637,54638,54639,54646,54658,54659,54734,54747,54749,54787,55050,55061,55062,55090,55091,55092,55094,55107,55108,55129,55130,55131,55132,55133,55136,55198,55225,55226,55233,55236,55237,55339,55340,55610,55620,55623,55666,55667,55668,55669,55670,55709,56314,56315,56316,56317,56318,56333,56336,56337,56339,56340,56341,56342,56343,56344,56611,56612,56613,56614,56636,56637,56638,56822,56834,56835,56924,56927,56929,56930,56931,56932,57470,57472,57499,57810,57811,57812,57813,57814,57849,57850,57851,57865,57873,57876,57877,57878,57880,57881,58410,58413,58414,58415,58422,58423,58424,58425,58426,58435,58436,58437,58872,58874,59057,59088,59089,59295,59296,59297,59298,59672,59738,59739,59740,59741,60103,60184,60185,60187,60188,60970,61154,61155,61156,61157,61158,61216,61221,61222,61295,61329,61330,61331,61336,61345,61346,61433,61434,61680,61680,61680,61681,61681,61681,61682,61682,61682,61683,61683,61683,61684,61684,61685,61685,61686,61686,61686,61687,61687,61687,61688,61688,61688,61689,61689,61689,61690,61690,61690,62097,62098,62099,62100,62101,62758,62759,62760,62762,62764,62765,62905,62908,63108,63117,63121,63123,63156,63158,63245,63349,63350,63351,63370,63372,63373,63374,63410,63411,63457,63458,63503,63504,63505,63506,63534,63542,63543,63560,63574,63625,63626,63627,63646,63647,63648,63649,63650,63730,63733,63737,63900,64044,64127,64129,64205,64353,64357,64976,65139); +ALTER TABLE `characters` ADD `speccount` tinyint(3) unsigned NOT NULL default 1 AFTER `arena_pending_points`; ALTER TABLE `characters` ADD `activespec` tinyint(3) unsigned NOT NULL default 0 AFTER `speccount`; ALTER TABLE `character_action` RENAME `character_action_old`; |