heugabel

May 12, 2011

move vehicle_id to the correct place

(AFTER `RegenHealth`)

the best way is delete the existant vehicle_id field and execute the queries again...

ALTER TABLE creature_template
 DROP COLUMN `vehicle_id`;
ALTER TABLE creature_template
 ADD COLUMN `vehicle_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RegenHealth`;

UPDATE creature_template SET
   spell1 = 52264,
   spell2 = 52268,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 123
WHERE entry IN (28605, 28606, 28607);

-- From jahangames
-- Massacre at Light's point quest
UPDATE creature_template SET
spell1 = 52435,
spell2 = 52576,
spell3 = 0,
spell4 = 0,
spell5 = 52588,
spell6 = 0,
vehicle_id = 79
WHERE entry IN (28833);

UPDATE creature_template SET
spell1 = 52435,
spell2 = 52576,
spell3 = 0,
spell4 = 0,
spell5 = 52588,
spell6 = 0,
vehicle_id = 68
WHERE entry IN (28887);

-- From Lanc
-- quest 12953
UPDATE `creature_template` SET
   spell1 = 55812,
   spell2 = 0,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 213
WHERE entry IN (30066);

-- From lanc
/* 7th Legion Chain Gun */
UPDATE creature_template SET
   IconName = 'Gunner',
   spell1 = 49190,
   spell2 = 49550,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 68
WHERE entry IN (27714);

/* Broken-down Shredder */
UPDATE creature_template SET
   IconName = 'vehichleCursor',
   spell1 = 48558,
   spell2 = 48604,
   spell3 = 48548,
   spell4 = 0,
   spell5 = 48610,
   spell6 = 0,
   vehicle_id = 49
WHERE entry IN (27354);

/* Forsaken Blight Spreader */
UPDATE creature_template SET
   IconName = 'vehichleCursor',
   spell1 = 48211,
   spell2 = 0,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 36
WHERE entry IN (26523);

/* Argent Tournament mount */
UPDATE creature_template SET
   spell1 = 62544,
   spell2 = 62575,
   spell3 = 63010,
   spell4 = 62552,
   spell5 = 64077,
   spell6 = 62863,
   vehicle_id = 349
WHERE entry IN (33844, 33845);


-- Quest vehicles Support: Going Bearback (12851)
UPDATE `creature_template` SET
   spell1 = 54897,
   spell2 = 54907,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 308
WHERE entry IN (29598);

/* Scourge Gryphon */
UPDATE creature_template SET
   spell1 = 0,
   spell2 = 0,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 146
WHERE entry IN (28864);

/* Frostbrood Vanquisher */
UPDATE creature_template SET
   spell1 = 53114,
   spell2 = 53110,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 156
WHERE entry IN (28670);

-- from lanc
-- Infected Kodo fix quest (11690)
UPDATE `creature_template` SET
spell1 = 45877,
spell2 = 0,
spell3 = 0,
spell4 = 0,
spell5 = 0,
spell6 = 0,
vehicle_id = 29
WHERE `entry` IN (25596);

-- Horde Siege Tank
UPDATE `creature_template` SET
spell1 = 50672,
spell2 = 45750,
spell3 = 50677,
spell4 = 47849,
spell5 = 47962,
spell6 = 0,
vehicle_id = 26
WHERE `entry` IN (25334);

-- from lanc
-- Refurbished Shredder (quest 12050)
UPDATE `creature_template` SET
spell1 = 47939,
spell2 = 47921,
spell3 = 47966,
spell4 = 47938,
spell5 = 0,
spell6 = 0,
vehicle_id = 300
WHERE `entry` IN (27061);

-- Argent Cannon (quest 13086)
UPDATE `creature_template` SET
   spell1 = 57485,
   spell2 = 57412,
   spell3 = 0,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 244
WHERE `entry` IN (30236);

-- Wyrmrest Vanquisher (quest 12498)
UPDATE `creature_template` SET
   spell1 = 55987,
   spell2 = 50348,
   spell3 = 50430,
   spell4 = 0,
   spell5 = 0,
   spell6 = 0,
   vehicle_id = 99
WHERE `entry` IN (27996);

-- from me
-- Quest Reclamation (12546)
UPDATE `creature_template` SET `spell1` = 50978,`spell2` = 50980,`spell3` = 50983,`spell4` = 50985,
`vehicle_id` = 111
WHERE  `entry` = 28222;

-- Quest 12996
UPDATE `creature_template` SET `spell1` = 54459,`spell2` = 54458,`spell3` = 54460,`vehicle_id` = 208 WHERE  `creature_template`.`entry` = 29918;

--
UPDATE `creature_template` SET `vehicle_id` = 23 WHERE `entry` = 23693;
UPDATE `creature_template` SET `vehicle_id` = 108 WHERE `entry` = 24083;
UPDATE `creature_template` SET `vehicle_id` = 8 WHERE `entry` = 24418;
UPDATE `creature_template` SET `vehicle_id` = 16 WHERE `entry` = 24705;
UPDATE `creature_template` SET `vehicle_id` = 17 WHERE `entry` = 24750;
UPDATE `creature_template` SET `vehicle_id` = 26 WHERE `entry` = 25334;
UPDATE `creature_template` SET `vehicle_id` = 29 WHERE `entry` = 25596;
UPDATE `creature_template` SET `vehicle_id` = 72 WHERE `entry` = 25743;
UPDATE `creature_template` SET `vehicle_id` = 27 WHERE `entry` = 25762;
UPDATE `creature_template` SET `vehicle_id` = 30 WHERE `entry` = 25968;
UPDATE `creature_template` SET `vehicle_id` = 62 WHERE `entry` = 26472;
UPDATE `creature_template` SET `vehicle_id` = 36 WHERE `entry` = 26523;
UPDATE `creature_template` SET `vehicle_id` = 33 WHERE `entry` = 26525;
UPDATE `creature_template` SET `vehicle_id` = 34 WHERE `entry` = 26572;
UPDATE `creature_template` SET `vehicle_id` = 53 WHERE `entry` = 26590;
UPDATE `creature_template` SET `vehicle_id` = 37 WHERE `entry` = 26777;
UPDATE `creature_template` SET `vehicle_id` = 38 WHERE `entry` = 26778;
UPDATE `creature_template` SET `vehicle_id` = 40 WHERE `entry` = 26893;
UPDATE `creature_template` SET `vehicle_id` = 53 WHERE `entry` = 27131;
UPDATE `creature_template` SET `vehicle_id` = 43 WHERE `entry` = 27213;
UPDATE `creature_template` SET `vehicle_id` = 48 WHERE `entry` = 27241;
UPDATE `creature_template` SET `vehicle_id` = 44 WHERE `entry` = 27258;
UPDATE `creature_template` SET `vehicle_id` = 50 WHERE `entry` = 27261;
UPDATE `creature_template` SET `vehicle_id` = 46 WHERE `entry` = 27270;
UPDATE `creature_template` SET `vehicle_id` = 50 WHERE `entry` = 27292;
UPDATE `creature_template` SET `vehicle_id` = 49 WHERE `entry` = 27354;
UPDATE `creature_template` SET `vehicle_id` = 55 WHERE `entry` = 27496;
UPDATE `creature_template` SET `vehicle_id` = 56 WHERE `entry` = 27587;
UPDATE `creature_template` SET `vehicle_id` = 57 WHERE `entry` = 27593;
UPDATE `creature_template` SET `vehicle_id` = 59 WHERE `entry` = 27626;
UPDATE `creature_template` SET `vehicle_id` = 60 WHERE `entry` = 27629;
UPDATE `creature_template` SET `vehicle_id` = 61 WHERE `entry` = 27661;
UPDATE `creature_template` SET `vehicle_id` = 154 WHERE `entry` = 27671;
UPDATE `creature_template` SET `vehicle_id` = 68 WHERE `entry` = 27714;
UPDATE `creature_template` SET `vehicle_id` = 70 WHERE `entry` = 27755;
UPDATE `creature_template` SET `vehicle_id` = 256 WHERE `entry` = 27761;
UPDATE `creature_template` SET `vehicle_id` = 68 WHERE `entry` = 27839;
UPDATE `creature_template` SET `vehicle_id` = 79 WHERE `entry` = 27881;
UPDATE `creature_template` SET `vehicle_id` = 160 WHERE `entry` = 27894;
UPDATE `creature_template` SET `vehicle_id` = 89 WHERE `entry` = 27924;
UPDATE `creature_template` SET `vehicle_id` = 97 WHERE `entry` = 27992;
UPDATE `creature_template` SET `vehicle_id` = 97 WHERE `entry` = 27993;
UPDATE `creature_template` SET `vehicle_id` = 99 WHERE `entry` = 27996;
UPDATE `creature_template` SET `vehicle_id` = 105 WHERE `entry` = 28009;
UPDATE `creature_template` SET `vehicle_id` = 100 WHERE `entry` = 28018;
UPDATE `creature_template` SET `vehicle_id` = 102 WHERE `entry` = 28054;
UPDATE `creature_template` SET `vehicle_id` = 106 WHERE `entry` = 28094;
UPDATE `creature_template` SET `vehicle_id` = 110 WHERE `entry` = 28192;
UPDATE `creature_template` SET `vehicle_id` = 117 WHERE `entry` = 28312;
UPDATE `creature_template` SET `vehicle_id` = 116 WHERE `entry` = 28319;
UPDATE `creature_template` SET `vehicle_id` = 244 WHERE `entry` = 28366;
UPDATE `creature_template` SET `vehicle_id` = 200 WHERE `entry` = 28605;
UPDATE `creature_template` SET `vehicle_id` = 123 WHERE `entry` = 28606;
UPDATE `creature_template` SET `vehicle_id` = 200 WHERE `entry` = 28607;
UPDATE `creature_template` SET `vehicle_id` = 124 WHERE `entry` = 28614;
UPDATE `creature_template` SET `vehicle_id` = 156 WHERE `entry` = 28670;
UPDATE `creature_template` SET `vehicle_id` = 158 WHERE `entry` = 28781;
UPDATE `creature_template` SET `vehicle_id` = 145 WHERE `entry` = 28851;
UPDATE `creature_template` SET `vehicle_id` = 68 WHERE `entry` = 28887;
UPDATE `creature_template` SET `vehicle_id` = 153 WHERE `entry` = 29043;
UPDATE `creature_template` SET `vehicle_id` = 25 WHERE `entry` = 29144;
UPDATE `creature_template` SET `vehicle_id` = 166 WHERE `entry` = 29414;
UPDATE `creature_template` SET `vehicle_id` = 168 WHERE `entry` = 29433;
UPDATE `creature_template` SET `vehicle_id` = 190 WHERE `entry` = 29679;
UPDATE `creature_template` SET `vehicle_id` = 192 WHERE `entry` = 29691;
UPDATE `creature_template` SET `vehicle_id` = 193 WHERE `entry` = 29698;
UPDATE `creature_template` SET `vehicle_id` = 207 WHERE `entry` = 29753;
UPDATE `creature_template` SET `vehicle_id` = 202 WHERE `entry` = 29857;
UPDATE `creature_template` SET `vehicle_id` = 208 WHERE `entry` = 29918;
UPDATE `creature_template` SET `vehicle_id` = 318 WHERE `entry` = 29929;
UPDATE `creature_template` SET `vehicle_id` = 196 WHERE `entry` = 30013;
UPDATE `creature_template` SET `vehicle_id` = 213 WHERE `entry` = 30066;
UPDATE `creature_template` SET `vehicle_id` = 222 WHERE `entry` = 30174;
UPDATE `creature_template` SET `vehicle_id` = 225 WHERE `entry` = 30204;
UPDATE `creature_template` SET `vehicle_id` = 234 WHERE `entry` = 30228;
UPDATE `creature_template` SET `vehicle_id` = 233 WHERE `entry` = 30275;
UPDATE `creature_template` SET `vehicle_id` = 177 WHERE `entry` = 30320;
UPDATE `creature_template` SET `vehicle_id` = 228 WHERE `entry` = 30330;
UPDATE `creature_template` SET `vehicle_id` = 229 WHERE `entry` = 30337;
UPDATE `creature_template` SET `vehicle_id` = 245 WHERE `entry` = 30342;
UPDATE `creature_template` SET `vehicle_id` = 230 WHERE `entry` = 30343;
UPDATE `creature_template` SET `vehicle_id` = 236 WHERE `entry` = 30403;
UPDATE `creature_template` SET `vehicle_id` = 242 WHERE `entry` = 30470;
UPDATE `creature_template` SET `vehicle_id` = 247 WHERE `entry` = 30564;
UPDATE `creature_template` SET `vehicle_id` = 248 WHERE `entry` = 30585;
UPDATE `creature_template` SET `vehicle_id` = 250 WHERE `entry` = 30645;
UPDATE `creature_template` SET `vehicle_id` = 262 WHERE `entry` = 31125;
UPDATE `creature_template` SET `vehicle_id` = 270 WHERE `entry` = 31137;
UPDATE `creature_template` SET `vehicle_id` = 263 WHERE `entry` = 31139;
UPDATE `creature_template` SET `vehicle_id` = 265 WHERE `entry` = 31224;
UPDATE `creature_template` SET `vehicle_id` = 267 WHERE `entry` = 31262;
UPDATE `creature_template` SET `vehicle_id` = 279 WHERE `entry` = 31583;
UPDATE `creature_template` SET `vehicle_id` = 280 WHERE `entry` = 31641;
UPDATE `creature_template` SET `vehicle_id` = 109 WHERE `entry` = 31689;
UPDATE `creature_template` SET `vehicle_id` = 284 WHERE `entry` = 31702;
UPDATE `creature_template` SET `vehicle_id` = 174 WHERE `entry` = 31722;
UPDATE `creature_template` SET `vehicle_id` = 312 WHERE `entry` = 31857;
UPDATE `creature_template` SET `vehicle_id` = 312 WHERE `entry` = 31858;
UPDATE `creature_template` SET `vehicle_id` = 315 WHERE `entry` = 31861;
UPDATE `creature_template` SET `vehicle_id` = 315 WHERE `entry` = 31862;
UPDATE `creature_template` SET `vehicle_id` = 290 WHERE `entry` = 31881;
UPDATE `creature_template` SET `vehicle_id` = 291 WHERE `entry` = 31884;
UPDATE `creature_template` SET `vehicle_id` = 294 WHERE `entry` = 32189;
UPDATE `creature_template` SET `vehicle_id` = 312 WHERE `entry` = 32212;
UPDATE `creature_template` SET `vehicle_id` = 312 WHERE `entry` = 32213;
UPDATE `creature_template` SET `vehicle_id` = 298 WHERE `entry` = 32225;
UPDATE `creature_template` SET `vehicle_id` = 318 WHERE `entry` = 32286;
UPDATE `creature_template` SET `vehicle_id` = 113 WHERE `entry` = 32323;
UPDATE `creature_template` SET `vehicle_id` = 304 WHERE `entry` = 32490;
UPDATE `creature_template` SET `vehicle_id` = 165 WHERE `entry` = 32535;
UPDATE `creature_template` SET `vehicle_id` = 324 WHERE `entry` = 32627;
UPDATE `creature_template` SET `vehicle_id` = 116 WHERE `entry` = 32629;
UPDATE `creature_template` SET `vehicle_id` = 312 WHERE `entry` = 32633;
UPDATE `creature_template` SET `vehicle_id` = 313 WHERE `entry` = 32640;
UPDATE `creature_template` SET `vehicle_id` = 160 WHERE `entry` = 32795;
UPDATE `creature_template` SET `vehicle_id` = 158 WHERE `entry` = 32796;
UPDATE `creature_template` SET `vehicle_id` = 328 WHERE `entry` = 32930;
UPDATE `creature_template` SET `vehicle_id` = 380 WHERE `entry` = 32934;
UPDATE `creature_template` SET `vehicle_id` = 336 WHERE `entry` = 33060;
UPDATE `creature_template` SET `vehicle_id` = 335 WHERE `entry` = 33062;
UPDATE `creature_template` SET `vehicle_id` = 337 WHERE `entry` = 33067;
UPDATE `creature_template` SET `vehicle_id` = 338 WHERE `entry` = 33109;
UPDATE `creature_template` SET `vehicle_id` = 387 WHERE `entry` = 33113;
UPDATE `creature_template` SET `vehicle_id` = 341 WHERE `entry` = 33114;
UPDATE `creature_template` SET `vehicle_id` = 342 WHERE `entry` = 33118;
UPDATE `creature_template` SET `vehicle_id` = 345 WHERE `entry` = 33167;
UPDATE `creature_template` SET `vehicle_id` = 348 WHERE `entry` = 33214;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE `entry` = 33217;
UPDATE `creature_template` SET `vehicle_id` = 353 WHERE `entry` = 33293;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE `entry` = 33319;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE `entry` = 33321;
UPDATE `creature_template` SET `vehicle_id` = 368 WHERE `entry` = 33513;
UPDATE `creature_template` SET `vehicle_id` = 372 WHERE `entry` = 33669;
UPDATE `creature_template` SET `vehicle_id` = 375 WHERE `entry` = 33687;
UPDATE `creature_template` SET `vehicle_id` = 108 WHERE `entry` = 33778;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE `entry` = 33844;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE `entry` = 33845;
UPDATE `creature_template` SET `vehicle_id` = 390 WHERE `entry` = 34120;
UPDATE `creature_template` SET `vehicle_id` = 397 WHERE `entry` = 34161;
UPDATE `creature_template` SET `vehicle_id` = 430 WHERE `entry` = 34658;
UPDATE `creature_template` SET `vehicle_id` = 477 WHERE `entry` = 34703;
UPDATE `creature_template` SET `vehicle_id` = 509 WHERE `entry` = 34775;
UPDATE `creature_template` SET `vehicle_id` = 438 WHERE `entry` = 34793;
UPDATE `creature_template` SET `vehicle_id` = 442 WHERE `entry` = 34796;
UPDATE `creature_template` SET `vehicle_id` = 446 WHERE `entry` = 34826;
UPDATE `creature_template` SET `vehicle_id` = 452 WHERE `entry` = 34929;
UPDATE `creature_template` SET `vehicle_id` = 453 WHERE `entry` = 34935;
UPDATE `creature_template` SET `vehicle_id` = 510 WHERE `entry` = 34944;
UPDATE `creature_template` SET `vehicle_id` = 447 WHERE `entry` = 35273;
UPDATE `creature_template` SET `vehicle_id` = 107 WHERE `entry` = 35373;
UPDATE `creature_template` SET `vehicle_id` = 487 WHERE `entry` = 35474;
UPDATE `creature_template` SET `vehicle_id` = 107 WHERE `entry` = 35491;
UPDATE `creature_template` SET `vehicle_id` = 477 WHERE `entry` = 35572;
UPDATE `creature_template` SET `vehicle_id` = 478 WHERE `entry` = 35633;
UPDATE `creature_template` SET `vehicle_id` = 479 WHERE `entry` = 35634;
UPDATE `creature_template` SET `vehicle_id` = 481 WHERE `entry` = 35636;
UPDATE `creature_template` SET `vehicle_id` = 482 WHERE `entry` = 35637;
UPDATE `creature_template` SET `vehicle_id` = 483 WHERE `entry` = 35638;
UPDATE `creature_template` SET `vehicle_id` = 484 WHERE `entry` = 35640;
UPDATE `creature_template` SET `vehicle_id` = 529 WHERE `entry` = 35644;
UPDATE `creature_template` SET `vehicle_id` = 489 WHERE `entry` = 35768;
UPDATE `creature_template` SET `vehicle_id` = 655 WHERE `entry` = 35819;
UPDATE `creature_template` SET `vehicle_id` = 436 WHERE `entry` = 36356;
UPDATE `creature_template` SET `vehicle_id` = 522 WHERE `entry` = 36476;
UPDATE `creature_template` SET `vehicle_id` = 529 WHERE `entry` = 36559;
UPDATE `creature_template` SET `vehicle_id` = 535 WHERE `entry` = 36661;
UPDATE `creature_template` SET `vehicle_id` = 551 WHERE `entry` = 36794;
UPDATE `creature_template` SET `vehicle_id` = 554 WHERE `entry` = 36838;
UPDATE `creature_template` SET `vehicle_id` = 560 WHERE `entry` = 36891;
UPDATE `creature_template` SET `vehicle_id` = 562 WHERE `entry` = 36896;
UPDATE `creature_template` SET `vehicle_id` = 622 WHERE `entry` = 37120;
UPDATE `creature_template` SET `vehicle_id` = 611 WHERE `entry` = 37968;
UPDATE `creature_template` SET `vehicle_id` = 636 WHERE `entry` = 38500;

-- Mechano-hog, Mekgineer's Chopper
UPDATE `creature_template` SET `vehicle_id` = 318, IconName = 'vehichleCursor' WHERE `entry` IN (29929, 32286);
-- Traveler's Tundra Mammoth
-- Grand Ice Mammoth
-- Grand Black War Mammoth
-- Grand Caravan Mammoth
UPDATE `creature_template` SET `vehicle_id` = 312, IconName = 'vehichleCursor' WHERE `entry` IN (32633, 32640, 31857, 31858, 31861, 31862, 32212, 32213);
-- X-53 Touring Rocket
UPDATE `creature_template` SET `vehicle_id` = 774, IconName = 'vehichleCursor' WHERE `entry` = 40725;

# Sniffed by zergtmn
UPDATE `creature_template` SET `vehicle_id` = 328 WHERE `entry` = 32930;
UPDATE `creature_template` SET `vehicle_id` = 380 WHERE `entry` = 32934;
UPDATE `creature_template` SET `vehicle_id` = 336 WHERE `entry` = 33060;
UPDATE `creature_template` SET `vehicle_id` = 335 WHERE `entry` = 33062;
UPDATE `creature_template` SET `vehicle_id` = 337 WHERE `entry` = 33067;
UPDATE `creature_template` SET `vehicle_id` = 347 WHERE `entry` = 33108;
UPDATE `creature_template` SET `vehicle_id` = 338 WHERE `entry` = 33109;
UPDATE `creature_template` SET `vehicle_id` = 387 WHERE `entry` = 33113;
UPDATE `creature_template` SET `vehicle_id` = 341 WHERE `entry` = 33114;
UPDATE `creature_template` SET `vehicle_id` = 342 WHERE `entry` = 33118;
UPDATE `creature_template` SET `vehicle_id` = 345 WHERE `entry` = 33167;
UPDATE `creature_template` SET `vehicle_id` = 348 WHERE `entry` = 33214;
UPDATE `creature_template` SET `vehicle_id` = 381 WHERE `entry` = 33288;
UPDATE `creature_template` SET `vehicle_id` = 353 WHERE `entry` = 33293;
UPDATE `creature_template` SET `vehicle_id` = 356 WHERE `entry` = 33364;
UPDATE `creature_template` SET `vehicle_id` = 357 WHERE `entry` = 33366;
UPDATE `creature_template` SET `vehicle_id` = 358 WHERE `entry` = 33369;
UPDATE `creature_template` SET `vehicle_id` = 371 WHERE `entry` = 33651;
UPDATE `creature_template` SET `vehicle_id` = 372 WHERE `entry` = 33669;
UPDATE `creature_template` SET `vehicle_id` = 108 WHERE `entry` = 33778;
UPDATE `creature_template` SET `vehicle_id` = 385 WHERE `entry` = 33983;
UPDATE `creature_template` SET `vehicle_id` = 390 WHERE `entry` = 34120;
UPDATE `creature_template` SET `vehicle_id` = 392 WHERE `entry` = 34146;
UPDATE `creature_template` SET `vehicle_id` = 395 WHERE `entry` = 34150;
UPDATE `creature_template` SET `vehicle_id` = 396 WHERE `entry` = 34151;
UPDATE `creature_template` SET `vehicle_id` = 397 WHERE `entry` = 34161;
UPDATE `creature_template` SET `vehicle_id` = 399 WHERE `entry` = 34183;

UPDATE `creature_template` SET `vehicle_id` = 143 WHERE `entry` = 28864; -- Scourge Gryphon
UPDATE `creature_template` SET `vehicle_id` = 123 WHERE `entry` = 28605; -- Havenshire Stallion
UPDATE `creature_template` SET `vehicle_id` = 135 WHERE `entry` = 28782; -- Acherus Deathcharger
UPDATE `creature_template` SET `vehicle_id` = 138 WHERE `entry` = 28817; -- Mine Car
UPDATE `creature_template` SET `vehicle_id` = 139 WHERE `entry` = 28833; -- Scarlet Cannon

UPDATE `creature_template` SET `vehicle_id` = 370 WHERE `entry` = 33432; -- Leviathan Mk II
UPDATE `creature_template` SET `vehicle_id` = 373 WHERE `entry` = 33670; -- Aerial Command Unit

UPDATE `creature_template` SET `vehicle_id` = 736 WHERE `entry` = 40305; -- Spirit of the Tiger

#
UPDATE `creature_template` SET `vehicle_id` = 220 WHERE `entry` = 30161;
UPDATE `creature_template` SET `vehicle_id` = 224 WHERE `entry` = 30234;
UPDATE `creature_template` SET `vehicle_id` = 223 WHERE `entry` = 30248;

-- From Timmit
-- bone spike
UPDATE `creature_template` SET `vehicle_id` = 647 WHERE `entry` IN (38711,38970,38971,38972);
UPDATE `creature_template` SET `vehicle_id` = 533 WHERE `entry` IN (36619,38233,38459,38460);

-- Putricide
UPDATE `creature_template` SET `vehicle_id` = 587 WHERE `entry` IN (36678,38431,38585,38586);
UPDATE `creature_template` SET `vehicle_id` = 591 WHERE `entry` IN (37672,38605,38786,38787);

# full fix
UPDATE `creature_template` SET `IconName` = 'vehichleCursor' WHERE `vehicle_id` > 0 AND `IconName` IS NULL;

-- from Lordron
-- Spectral tiger
UPDATE `creature_template` SET `vehicle_id` = 354 WHERE `entry` = 33357;
-- Shalewing
UPDATE `creature_template` SET `vehicle_id` = 146 WHERE `entry` = 28875;
-- Drakkari Skullcrusher
UPDATE `creature_template` SET `vehicle_id` = 774 WHERE `entry` = 28844;
-- ICC
UPDATE `creature_template` SET `vehicle_id` = 531 WHERE `entry` IN (36598);
UPDATE `creature_template` SET `vehicle_id` = 532 WHERE `entry` IN (36609,39120,39121,39122);

-- from YTDB/TC 570
UPDATE `creature_template` SET `vehicle_id` = 51  WHERE  `entry` = 27409;
UPDATE `creature_template` SET `vehicle_id` = 107 WHERE  `entry` = 28135;
UPDATE `creature_template` SET `vehicle_id` = 206 WHERE  `entry` = 28379;
UPDATE `creature_template` SET `vehicle_id` = 121 WHERE  `entry` = 28468;
UPDATE `creature_template` SET `vehicle_id` = 492 WHERE  `entry` = 25765;
UPDATE `creature_template` SET `vehicle_id` = 25  WHERE  `entry` = 27516;
UPDATE `creature_template` SET `vehicle_id` = 156 WHERE  `entry` = 26788;
UPDATE `creature_template` SET `vehicle_id` = 129 WHERE  `entry` = 28710;
UPDATE `creature_template` SET `vehicle_id` = 25  WHERE  `entry` = 28446;
UPDATE `creature_template` SET `vehicle_id` = 22  WHERE  `entry` = 24825;
UPDATE `creature_template` SET `vehicle_id` = 22  WHERE  `entry` = 24821;
UPDATE `creature_template` SET `vehicle_id` = 22  WHERE  `entry` = 24823;
UPDATE `creature_template` SET `vehicle_id` = 22  WHERE  `entry` = 24806;
UPDATE `creature_template` SET `vehicle_id` = 200 WHERE  `entry` = 26191;
UPDATE `creature_template` SET `vehicle_id` = 113 WHERE  `entry` = 28246;
UPDATE `creature_template` SET `vehicle_id` = 156 WHERE  `entry` = 27850;
UPDATE `creature_template` SET `vehicle_id` = 156 WHERE  `entry` = 27838;
UPDATE `creature_template` SET `vehicle_id` = 30  WHERE  `entry` = 25881;
UPDATE `creature_template` SET `vehicle_id` = 156 WHERE  `entry` = 26807;
UPDATE `creature_template` SET `vehicle_id` = 34  WHERE  `entry` = 26585;
UPDATE `creature_template` SET `vehicle_id` = 39  WHERE  `entry` = 26813;
UPDATE `creature_template` SET `vehicle_id` = 127 WHERE  `entry` = 28669;
UPDATE `creature_template` SET `vehicle_id` = 203 WHERE  `entry` = 29863;
UPDATE `creature_template` SET `vehicle_id` = 200 WHERE  `entry` = 27883;
UPDATE `creature_template` SET `vehicle_id` = 111 WHERE  `entry` = 28222;
UPDATE `creature_template` SET `vehicle_id` = 115 WHERE  `entry` = 28308;
UPDATE `creature_template` SET `vehicle_id` = 191 WHERE  `entry` = 29306;
UPDATE `creature_template` SET `vehicle_id` = 176 WHERE  `entry` = 29351;
UPDATE `creature_template` SET `vehicle_id` = 177 WHERE  `entry` = 29358;
UPDATE `creature_template` SET `vehicle_id` = 165 WHERE  `entry` = 29403;
UPDATE `creature_template` SET `vehicle_id` = 169 WHERE  `entry` = 29460;
UPDATE `creature_template` SET `vehicle_id` = 173 WHERE  `entry` = 29500;
UPDATE `creature_template` SET `vehicle_id` = 175 WHERE  `entry` = 29555;
UPDATE `creature_template` SET `vehicle_id` = 179 WHERE  `entry` = 29579;
UPDATE `creature_template` SET `vehicle_id` = 181 WHERE  `entry` = 29602;
UPDATE `creature_template` SET `vehicle_id` = 183 WHERE  `entry` = 29625;
UPDATE `creature_template` SET `vehicle_id` = 186 WHERE  `entry` = 29677;
UPDATE `creature_template` SET `vehicle_id` = 198 WHERE  `entry` = 29708;
UPDATE `creature_template` SET `vehicle_id` = 194 WHERE  `entry` = 29709;
UPDATE `creature_template` SET `vehicle_id` = 243 WHERE  `entry` = 29736;
UPDATE `creature_template` SET `vehicle_id` = 197 WHERE  `entry` = 29754;
UPDATE `creature_template` SET `vehicle_id` = 201 WHERE  `entry` = 29838;
UPDATE `creature_template` SET `vehicle_id` = 205 WHERE  `entry` = 29884;
UPDATE `creature_template` SET `vehicle_id` = 209 WHERE  `entry` = 29931;
UPDATE `creature_template` SET `vehicle_id` = 214 WHERE  `entry` = 30090;
UPDATE `creature_template` SET `vehicle_id` = 217 WHERE  `entry` = 30124;
UPDATE `creature_template` SET `vehicle_id` = 219 WHERE  `entry` = 30134;
UPDATE `creature_template` SET `vehicle_id` = 221 WHERE  `entry` = 30165;
UPDATE `creature_template` SET `vehicle_id` = 227 WHERE  `entry` = 30301;
UPDATE `creature_template` SET `vehicle_id` = 25  WHERE  `entry` = 30378;
UPDATE `creature_template` SET `vehicle_id` = 316 WHERE  `entry` = 30468;
UPDATE `creature_template` SET `vehicle_id` = 252 WHERE  `entry` = 30719;
UPDATE `creature_template` SET `vehicle_id` = 259 WHERE  `entry` = 31110;
UPDATE `creature_template` SET `vehicle_id` = 265 WHERE  `entry` = 31163;
UPDATE `creature_template` SET `vehicle_id` = 265 WHERE  `entry` = 31220;
UPDATE `creature_template` SET `vehicle_id` = 265 WHERE  `entry` = 31221;
UPDATE `creature_template` SET `vehicle_id` = 269 WHERE  `entry` = 31268;
UPDATE `creature_template` SET `vehicle_id` = 268 WHERE  `entry` = 31269;
UPDATE `creature_template` SET `vehicle_id` = 273 WHERE  `entry` = 31406;
UPDATE `creature_template` SET `vehicle_id` = 277 WHERE  `entry` = 31407;
UPDATE `creature_template` SET `vehicle_id` = 274 WHERE  `entry` = 31408;
UPDATE `creature_template` SET `vehicle_id` = 278 WHERE  `entry` = 31409;
UPDATE `creature_template` SET `vehicle_id` = 282 WHERE  `entry` = 31784;
UPDATE `creature_template` SET `vehicle_id` = 282 WHERE  `entry` = 31785;
UPDATE `creature_template` SET `vehicle_id` = 736 WHERE  `entry` = 31788;
UPDATE `creature_template` SET `vehicle_id` = 512 WHERE  `entry` = 31830;
UPDATE `creature_template` SET `vehicle_id` = 287 WHERE  `entry` = 31838;
UPDATE `creature_template` SET `vehicle_id` = 291 WHERE  `entry` = 32227;
UPDATE `creature_template` SET `vehicle_id` = 300 WHERE  `entry` = 32326;
UPDATE `creature_template` SET `vehicle_id` = 301 WHERE  `entry` = 32344;
UPDATE `creature_template` SET `vehicle_id` = 302 WHERE  `entry` = 32348;
UPDATE `creature_template` SET `vehicle_id` = 273 WHERE  `entry` = 32512;
UPDATE `creature_template` SET `vehicle_id` = 369 WHERE  `entry` = 32531;
UPDATE `creature_template` SET `vehicle_id` = 40  WHERE  `entry` = 30775;
UPDATE `creature_template` SET `vehicle_id` = 201 WHERE  `entry` = 30935;
UPDATE `creature_template` SET `vehicle_id` = 209 WHERE  `entry` = 30936;
UPDATE `creature_template` SET `vehicle_id` = 191 WHERE  `entry` = 31368;
UPDATE `creature_template` SET `vehicle_id` = 108 WHERE  `entry` = 31669;
UPDATE `creature_template` SET `vehicle_id` = 380 WHERE  `entry` = 32933;
UPDATE `creature_template` SET `vehicle_id` = 342 WHERE  `entry` = 33190;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33297;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33298;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33300;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33301;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33316;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33317;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33318;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33320;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33322;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33323;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33324;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33408;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33409;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33414;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33416;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 33418;
UPDATE `creature_template` SET `vehicle_id` = 368 WHERE  `entry` = 33519;
UPDATE `creature_template` SET `vehicle_id` = 369 WHERE  `entry` = 33531;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33790;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33791;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33792;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33793;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33794;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33795;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33796;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33798;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33799;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33800;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33842;
UPDATE `creature_template` SET `vehicle_id` = 349 WHERE  `entry` = 33843;
UPDATE `creature_template` SET `vehicle_id` = 353 WHERE  `entry` = 33885;
UPDATE `creature_template` SET `vehicle_id` = 328 WHERE  `entry` = 33909;
UPDATE `creature_template` SET `vehicle_id` = 380 WHERE  `entry` = 33910;
UPDATE `creature_template` SET `vehicle_id` = 380 WHERE  `entry` = 33911;
UPDATE `creature_template` SET `vehicle_id` = 381 WHERE  `entry` = 33955;
UPDATE `creature_template` SET `vehicle_id` = 385 WHERE  `entry` = 33984;
UPDATE `creature_template` SET `vehicle_id` = 387 WHERE  `entry` = 34003;
UPDATE `creature_template` SET `vehicle_id` = 335 WHERE  `entry` = 34045;
UPDATE `creature_template` SET `vehicle_id` = 370 WHERE  `entry` = 34106;
UPDATE `creature_template` SET `vehicle_id` = 371 WHERE  `entry` = 34108;
UPDATE `creature_template` SET `vehicle_id` = 373 WHERE  `entry` = 34109;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 34125;
UPDATE `creature_template` SET `vehicle_id` = 397 WHERE  `entry` = 34162;
UPDATE `creature_template` SET `vehicle_id` = 399 WHERE  `entry` = 34214;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 36557;
UPDATE `creature_template` SET `vehicle_id` = 485 WHERE  `entry` = 35641;
UPDATE `creature_template` SET `vehicle_id` = 480 WHERE  `entry` = 35635;
UPDATE `creature_template` SET `vehicle_id` = 106 WHERE  `entry` = 34802;
UPDATE `creature_template` SET `vehicle_id` = 0 WHERE  `entry` = 36558;
UPDATE `creature_template` SET `vehicle_id` = 477 WHERE  `entry` = 36087;
UPDATE `creature_template` SET `vehicle_id` = 477 WHERE  `entry` = 36089;
UPDATE `creature_template` SET `vehicle_id` = 442 WHERE  `entry` = 35438;
UPDATE `creature_template` SET `vehicle_id` = 442 WHERE  `entry` = 35439;
UPDATE `creature_template` SET `vehicle_id` = 442 WHERE  `entry` = 35440;
UPDATE `creature_template` SET `vehicle_id` = 446 WHERE  `entry` = 35270;
UPDATE `creature_template` SET `vehicle_id` = 446 WHERE  `entry` = 35271;
UPDATE `creature_template` SET `vehicle_id` = 446 WHERE  `entry` = 35272;
UPDATE `creature_template` SET `vehicle_id` = 555 WHERE  `entry` = 36839;
UPDATE `creature_template` SET `vehicle_id` = 599 WHERE  `entry` = 37187;
UPDATE `creature_template` SET `vehicle_id` = 648 WHERE  `entry` = 38712;
UPDATE `creature_template` SET `vehicle_id` = 562 WHERE  `entry` = 37636;
UPDATE `creature_template` SET `vehicle_id` = 560 WHERE  `entry` = 37626;
UPDATE `creature_template` SET `vehicle_id` = 522 WHERE  `entry` = 37627;
UPDATE `creature_template` SET `vehicle_id` = 648 WHERE  `entry` = 38974;
UPDATE `creature_template` SET `vehicle_id` = 648 WHERE  `entry` = 38973;
UPDATE `creature_template` SET `vehicle_id` = 648 WHERE  `entry` = 38975;
UPDATE `creature_template` SET `vehicle_id` = 106 WHERE  `entry` = 35419;
UPDATE `creature_template` SET `vehicle_id` = 106 WHERE  `entry` = 35421;
UPDATE `creature_template` SET `vehicle_id` = 106 WHERE  `entry` = 35415;
UPDATE `creature_template` SET `vehicle_id` = 436 WHERE  `entry` = 36358;
UPDATE `creature_template` SET `vehicle_id` = 36  WHERE  `entry` = 35413;
UPDATE `creature_template` SET `vehicle_id` = 452 WHERE  `entry` = 35410;
UPDATE `creature_template` SET `vehicle_id` = 591 WHERE  `entry` = 38285;
UPDATE `creature_template` SET `vehicle_id` = 718 WHERE  `entry` = 40081;
UPDATE `creature_template` SET `vehicle_id` = 718 WHERE  `entry` = 40470;
UPDATE `creature_template` SET `vehicle_id` = 718 WHERE  `entry` = 40471;
UPDATE `creature_template` SET `vehicle_id` = 718 WHERE  `entry` = 40472;
UPDATE `creature_template` SET `vehicle_id` = 79  WHERE  `entry` = 35427;
UPDATE `creature_template` SET `vehicle_id` = 79  WHERE  `entry` = 35429;
UPDATE `creature_template` SET `vehicle_id` = 591 WHERE  `entry` = 38788;
UPDATE `creature_template` SET `vehicle_id` = 591 WHERE  `entry` = 38789;
UPDATE `creature_template` SET `vehicle_id` = 591 WHERE  `entry` = 38790;
UPDATE `creature_template` SET `vehicle_id` = 700 WHERE  `entry` = 39682;
UPDATE `creature_template` SET `vehicle_id` = 745 WHERE  `entry` = 39713;
UPDATE `creature_template` SET `vehicle_id` = 745 WHERE  `entry` = 39714;
UPDATE `creature_template` SET `vehicle_id` = 753 WHERE  `entry` = 39759;
UPDATE `creature_template` SET `vehicle_id` = 763 WHERE  `entry` = 39819;
UPDATE `creature_template` SET `vehicle_id` = 711 WHERE  `entry` = 39860;
UPDATE `creature_template` SET `vehicle_id` = 747 WHERE  `entry` = 40479;
-- YTDB updates 571-578
UPDATE `creature_template` SET `vehicle_id` = 265 WHERE  `entry` = 31225;
UPDATE `creature_template` SET `vehicle_id` = 224 WHERE  `entry` = 31748;
UPDATE `creature_template` SET `vehicle_id` = 223 WHERE  `entry` = 31749;
UPDATE `creature_template` SET `vehicle_id` = 220 WHERE  `entry` = 31752;

February 17, 2011

its possible to hide the "unused parameter" warnings within enabled debug mode?

and i become a few warnings:

/home/mangos/src/shared/Database/DBCStore.h: In constructor 'SqlDbc::SqlDbc(const std::string*, const std::string*, const std::string*, const char*)':
/home/mangos/src/shared/Database/DBCStore.h:33: warning: 'SqlDbc::sqlIndexPos' will be initialized after
/home/mangos/src/shared/Database/DBCStore.h:30: warning:   'const std::string* SqlDbc::indexName'
/home/mangos/src/shared/Database/DBCStore.h:34: warning:   when initialized here
/home/mangos/src/shared/Database/DBCStore.h:56: warning: comparison between signed and unsigned integer expressions

/home/mangos/src/game/GridNotifiers.h: At global scope:
/home/mangos/src/game/GridNotifiers.h:48: warning: unused parameter 'm'
/home/mangos/src/game/GridNotifiers.h: In constructor 'MaNGOS::NearestGameObjectEntryInPosRangeCheck::NearestGameObjectEntryInPosRangeCheck(const WorldObject&, uint32, float, float, float, float)':
/home/mangos/src/game/GridNotifiers.h:739: warning: 'MaNGOS::NearestGameObjectEntryInPosRangeCheck::i_z' will be initialized after
/home/mangos/src/game/GridNotifiers.h:738: warning:   'uint32 MaNGOS::NearestGameObjectEntryInPosRangeCheck::i_entry'
/home/mangos/src/game/GridNotifiers.h:717: warning:   when initialized here
/home/mangos/src/game/GridNotifiers.h: In constructor 'MaNGOS::GameObjectEntryInPosRangeCheck::GameObjectEntryInPosRangeCheck(const WorldObject&, uint32, float, float, float, float)':
/home/mangos/src/game/GridNotifiers.h:768: warning: 'MaNGOS::GameObjectEntryInPosRangeCheck::i_z' will be initialized after
/home/mangos/src/game/GridNotifiers.h:767: warning:   'uint32 MaNGOS::GameObjectEntryInPosRangeCheck::i_entry'
/home/mangos/src/game/GridNotifiers.h:750: warning:   when initialized here
/home/mangos/src/game/GridNotifiers.h: In member function 'bool MaNGOS::NearestCreatureEntryWithLiveStateInObjectRangeCheck::operator()(Creature*)':
/home/mangos/src/game/GridNotifiers.h:1144: warning: suggest parentheses around && within ||
In file included from /home/mangos/src/game/GridNotifiersImpl.h:28,
                from /home/mangos/src/bindings/ScriptDev2/include/sc_grid_searchers.h:14,
                from /home/mangos/src/bindings/ScriptDev2/include/precompiled.h:11,
                from /home/mangos/src/bindings/ScriptDev2/scripts/outland/coilfang_reservoir/steam_vault/instance_steam_vault.cpp:24:
/home/mangos/src/game/SpellAuras.h: At global scope:
/home/mangos/src/game/SpellAuras.h:441: warning: type qualifiers ignored on function return type
/home/mangos/src/bindings/ScriptDev2/scripts/outland/coilfang_reservoir/steam_vault/instance_steam_vault.cpp:39: warning: unused parameter 'pPlayer'
In file included from /home/mangos/src/game/Creature.h:23,
                from /home/mangos/src/bindings/ScriptDev2/include/sc_creature.h:9,
                from /home/mangos/src/bindings/ScriptDev2/include/precompiled.h:9,

September 13, 2010

Notice: Undefined index: displayid in /var/www/web6/html/armory/item-info.php on line 57

August 17, 2010

../../../src/game/Unit.cpp: In member function 'int32 Unit::DealHeal(Unit*, uint32, const SpellEntry*, bool)':

../../../src/game/Unit.cpp:6119: error: 'Battleground' was not declared in this scope

../../../src/game/Unit.cpp:6119: error: 'bgV' was not declared in this scope

../../../src/game/Unit.cpp:6119: error: 'class Player' has no member named 'GetBattleground'

mangos R10366 (armory arena chart)

August 6, 2010

Rev: 10321

Uptime near 22 Minutes

MAngos + SD2 + YTDB R559

Core was generated by `/home/fun/server/bin/mangos-worldd'.
Program terminated with signal 11, Segmentation fault.

[New process 23596]

[New process 23601]

[New process 23600]

[New process 23599]

[New process 23598]

[New process 23597]

[New process 23586]

[New process 23595]

[New process 23591]

[New process 23590]

[New process 23588]

#0 0x00000000009aeb73 in Aura::GetId (this=0x7fcba8769120)

at ../../../src/game/SpellAuras.h:376

376 uint32 GetId() const{ return GetHolder()->GetSpellProto()->Id; }

#0 0x00000000009aeb73 in Aura::GetId (this=0x7fcba8769120)

at ../../../src/game/SpellAuras.h:376

No locals.

#1 0x0000000000bb5d76 in Unit::MeleeDamageBonusTaken (this=0x7fcba841c100,

pCaster=0x2e2c000, pdamage=1234, attType=BASE_ATTACK,

spellProto=0x7fcbcec65c1c, damagetype=SPELL_DIRECT_DAMAGE, stack=1)

at ../../../src/game/Unit.cpp:7459

i = {_M_node = 0x7fcba8811f60}

isWeaponDamageBasedSpell = false

schoolMask = 1

mechanicMask = 0

TakenFlat = 0

TakenPercent = 1

mDummyAuras = (

const std::list<Aura*, std::allocator<Aura*> > &) @0x7fcba841c4a0: {<std::_List_base<Aura*, std::allocator<Aura*> >> = {

_M_impl = {<std::allocator<std::_List_node<Aura*> >> = {<__gnu_cxx::new_allocator<std::_List_node<Aura*> >> = {<No data fields>}, <No data fields>},

_M_node = {_M_next = 0x7fcba8811f60,

_M_prev = 0x7fcba8811f60}}}, <No data fields>}

tmpDamage = 3.3317918e-37

#2 0x0000000000bc1b06 in Unit::CalculateSpellDamage (this=0x2e2c000,

damageInfo=0x428028a0, damage=1234, spellInfo=0x7fcbcec65c1c,

attackType=BASE_ATTACK) at ../../../src/game/Unit.cpp:1368

damageSchoolMask = SPELL_SCHOOL_MASK_NORMAL

pVictim = (Unit *) 0x7fcba841c100

crit = true

#3 0x0000000000b360c5 in Spell::DoAllEffectOnTarget (this=0x7fcba87ce200,

target=0x7fcbd2f3b620) at ../../../src/game/Spell.cpp:1092

damageInfo = {target = 0x7fcba841c100, attacker = 0x2e2c000,

SpellID = 48562, damage = 0, overkill = 0,

schoolMask = SPELL_SCHOOL_MASK_NORMAL, absorb = 0, resist = 0,

physicalLog = false, unused = false, blocked = 0, HitInfo = 0}

mask = 1

unit = (class Unit *) 0x7fcba841c100

real_caster = (class Unit *) 0x2e2c000

caster = (class Unit *) 0x2e2c000

missInfo = SPELL_MISS_NONE

procAttacker = 16

procVictim = 32

procEx = 0

#4 0x0000000000b3e03a in Spell::handle_immediate (this=0x7fcba87ce200)

at ../../../src/game/Spell.cpp:3117

ihit = {_M_node = 0x7fcbd2f3b610}

#5 0x0000000000b3d228 in Spell::cast (this=0x7fcba87ce200, skipCheck=false)

at ../../../src/game/Spell.cpp:3090

castResult = SPELL_CAST_OK

#6 0x0000000000b4491b in Spell::update (this=0x7fcba87ce200, difftime=101)

at ../../../src/game/Spell.cpp:3289

No locals.

#7 0x0000000000b44cd3 in SpellEvent::Execute (this=0x7fcbd2ecd490,

e_time=1212655, p_time=101) at ../../../src/game/Spell.cpp:6561

No locals.

#8 0x0000000000cfb0fc in EventProcessor::Update (this=0x2e2c130, p_time=101)

at ../../../src/framework/Utilities/EventProcessor.cpp:47

Event = (BasicEvent *) 0x7fcbd2ecd490

i = {_M_node = 0x7fcbd2f381f0}

#9 0x0000000000bcf8fd in Unit::Update (this=0x2e2c000, p_time=101)

at ../../../src/game/Unit.cpp:293

No locals.

#10 0x0000000000ace9e5 in Player::Update (this=0x2e2c000, p_time=101)

at ../../../src/game/Player.cpp:1217

now = 1115696336

pet = (class Pet *) 0x9d4109

#11 0x00000000009d0b88 in Map::Update (this=0x2bac000, t_diff=@0x4280400c)

at ../../../src/game/Map.cpp:520

plr = (class Player *) 0x2e2c000

updater = {i_timeDiff = 1115700848}

grid_object_update = {i_visitor = @0x42803e50}

world_object_update = {i_visitor = @0x42803e50}

__FUNCTION__ = "Update"

__PRETTY_FUNCTION__ = "virtual void Map::Update(const uint32&)"

#12 0x00000000009d1351 in InstanceMap::Update (this=0x2bac000,

t_diff=@0x4280400c) at ../../../src/game/Map.cpp:1812

No locals.

#13 0x0000000000c7aefc in MapInstanced::Update (this=0x2b8c000, t=@0x4280400c)

at ../../../src/game/MapInstanced.cpp:63

i = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, Map*>, false>> = {_M_cur_node = 0x7fcbd02d7eb0,

_M_cur_bucket = 0x7fcbd024f5c0}, <No data fields>}

#14 0x00000000009e9b28 in MapManager::Update (this=0x7fcbb83b51a0, diff=46)

at ../../../src/game/MapManager.cpp:250

iter = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, Map*>, false>> = {_M_cur_node = 0x7fcbd02d7ef8,

_M_cur_bucket = 0x7fcbd3433a70}, <No data fields>}

#15 0x0000000000bfc8b7 in World::Update (this=0x7fcbd5b1f900, diff=46)

at ../../../src/game/World.cpp:1496

autobroadcaston = 1

#16 0x000000000081efdc in WorldRunnable::run (this=0x7fcbd33cb240)

at ../../../src/mangosd/WorldRunnable.cpp:60

diff = 46

realCurrTime = 1191253445

realPrevTime = 1191253399

prevSleepTime = 45

#17 0x0000000000cd695e in ACE_Based::Thread::ThreadTask (param=0x7fcbd33cb240)

at ../../../src/shared/Threading.cpp:187

_task = (class ACE_Based::Runnable *) 0x7fcbd33cb240

#18 0x00007fcbd70edfc7 in start_thread () from /lib/libpthread.so.0

No symbol table info available.

#19 0x00007fcbd66bd64d in clone () from /lib/libc.so.6

No symbol table info available.

#20 0x0000000000000000 in ?? ()

No symbol table info available.

July 24, 2010

hi, i have a lot of crashes in last time but i dont know what it is.

Core was generated by `/home/fun/server/bin/mangos-worldd'.
Program terminated with signal 6, Aborted.

[New process 7062]

[New process 7067]

[New process 7066]

[New process 7065]

[New process 7064]

[New process 7063]

[New process 7049]

[New process 7061]

[New process 7052]

[New process 7051]

[New process 7050]

#0 0x00007f9a6cf34ed5 in raise () from /lib/libc.so.6

#0 0x00007f9a6cf34ed5 in raise () from /lib/libc.so.6

No symbol table info available.

#1 0x00007f9a6cf363f3 in abort () from /lib/libc.so.6

No symbol table info available.

#2 0x00007f9a6cf2ddc9 in __assert_fail () from /lib/libc.so.6

No symbol table info available.

#3 0x0000000000aa8e18 in Player::BuildPlayerRepop (this=0x1403c000)

at ../../../src/game/Player.cpp:4467

st = {static SYMBUFSIZ = 4096,

buf_ = "/home/fun/server/bin/mangos-worldd(_ZN12WorldSession6UpdateEj+0x572) [0xbf6f0a]\\n/home/fun/server/bin/mangos-worldd(_ZN5World14UpdateSessionsEj+0x9a) [0xbe9f5c]\\n/home/fun/server/bin/mangos-worldd(_ZN5W"..., buflen_ = 479,

static UNSUPPORTED = 0x7f9a6f51a540 "<stack traces unsupported platform>",

static UNABLE_TO_GET_TRACE = 0x7f9a6f51a570 "<unable to get trace>"}

data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 0,

_wpos = 4,

_storage = {<std::_Vector_base<unsigned char, std::allocator<unsigned char> >> = {

_M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>},

_M_start = 0x7f9a25b61718 "\\a¿~Ë\\232\\177",

_M_finish = 0x7f9a25b6171c "\\232\\177",

_M_end_of_storage = 0x7f9a25b6171c "\\232\\177"}}, <No data fields>}}, m_opcode = 1172}

corpse = (class Corpse *) 0x1403da40

__FUNCTION__ = "BuildPlayerRepop"

__PRETTY_FUNCTION__ = "void Player::BuildPlayerRepop()"

#4 0x0000000000bf5e59 in WorldSession::LogoutPlayer (this=0x7f9a4b178b80,

Save=true) at ../../../src/game/WorldSession.cpp:302

guild = (Guild *) 0x80f8d3

_map = (class Map *) 0x7f9a4b178ca0

data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096,

_rpos = 1115703632, _wpos = 140301250676352,

_storage = {<std::_Vector_base<unsigned char, std::allocator<unsigned char> >> = {

_M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>},

_M_start = 0x42803d70 "\\220=\\200B",

_M_finish = 0x826fc1 "ÉÃ\\220UH\\211åH\\211}øH\\213EøÉÃUH\\211åSH\\203ì\\030H\\211}ðH\\211uèH\\213}ðèØÿÿÿH\\213",

_M_end_of_storage = 0x7f9a25b61718 "\\a¿~Ë\\232\\177"}}, <No data fields>}}, m_opcode = 15920}

#5 0x0000000000bf6f0a in WorldSession::Update (this=0x7f9a4b178b80)

at ../../../src/game/WorldSession.cpp:272

packet = (WorldPacket *) 0x7f9a357838e0

currTime = 1279997723

#6 0x0000000000be9f5c in World::UpdateSessions (this=0x7f9a6c433900, diff=50)

at ../../../src/game/World.cpp:1924

itr = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, WorldSession*>, false>> = {_M_cur_node = 0x7f9a24aac508,

_M_cur_bucket = 0x7f9a415f5ac0}, <No data fields>}

next = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, WorldSession*>, false>> = {_M_cur_node = 0x7f9a4b22fe50,

_M_cur_bucket = 0x7f9a415f5ac8}, <No data fields>}

sess = (WorldSession *) 0xbe33b2

#7 0x0000000000bea1e7 in World::Update (this=0x7f9a6c433900, diff=50)

at ../../../src/game/World.cpp:1459

autobroadcaston = 0

#8 0x000000000081575c in WorldRunnable::run (this=0x7f9a4b46d800)

at ../../../src/mangosd/WorldRunnable.cpp:60

diff = 50

realCurrTime = 97468826

realPrevTime = 97468776

prevSleepTime = 50

#9 0x0000000000cc2fe2 in ACE_Based::Thread::ThreadTask (param=0x7f9a4b46d800)

at ../../../src/shared/Threading.cpp:187

_task = (class ACE_Based::Runnable *) 0x7f9a4b46d800

#10 0x00007f9a6da02fc7 in start_thread () from /lib/libpthread.so.0

No symbol table info available.

#11 0x00007f9a6cfd264d in clone () from /lib/libc.so.6

No symbol table info available.

#12 0x0000000000000000 in ?? ()

No symbol table info available.

pls help

July 16, 2010

hi, our server crashes permanently after updating to 10198. its a clean core +sd2 (and some little additions like armory, broadcast)

             Core was generated by `/home/instant/server/bin/mangos-worldd2'.
Program terminated with signal 6, Aborted.
[New process 13484]
[New process 13489]
[New process 13488]
[New process 13487]
[New process 13486]
[New process 13485]
[New process 13475]
[New process 13483]
[New process 13478]
[New process 13477]
[New process 13476]
#0  0x00007fd63b432ed5 in raise () from /lib/libc.so.6
#0  0x00007fd63b432ed5 in raise () from /lib/libc.so.6
No symbol table info available.
#1  0x00007fd63b4343f3 in abort () from /lib/libc.so.6
No symbol table info available.
#2  0x00007fd63b42bdc9 in __assert_fail () from /lib/libc.so.6
No symbol table info available.
#3  0x00000000009cfdcd in MotionMaster::UpdateMotion (this=0x2989920, 
   diff=100) at ../../../src/game/MotionMaster.cpp:72
   st = {static SYMBUFSIZ = 4096, 
 buf_ = "/home/instant/server/bin/mangos-worldd2(_ZN6Player6UpdateEj+0xdf) [0xaa12f1]\\n/home/instant/server/bin/mangos-worldd2(_ZN3Map6UpdateERKj+0xc4) [0x9b28ba]\\n/home/instant/server/bin/mangos-worldd2(_ZN10Ma"..., buflen_ = 569, 
 static UNSUPPORTED = 0x7fd63da16540 "<stack traces unsupported platform>", 
 static UNABLE_TO_GET_TRACE = 0x7fd63da16570 "<unable to get trace>"}
   __FUNCTION__ = "UpdateMotion"
   __PRETTY_FUNCTION__ = "void MotionMaster::UpdateMotion(uint32)"
#4  0x0000000000b9d1d3 in Unit::Update (this=0x2988000, p_time=100)
   at ../../../src/game/Unit.cpp:328
No locals.
#5  0x0000000000aa12f1 in Player::Update (this=0x2988000, p_time=100)
   at ../../../src/game/Player.cpp:1217
   now = 1115696464
   pet = (class Pet *) 0x9b5e37
#6  0x00000000009b28ba in Map::Update (this=0x1630000, t_diff=@0x4280400c)
   at ../../../src/game/Map.cpp:520
   plr = (class Player *) 0x2988000
   updater = {i_timeDiff = 1115700976}
   grid_object_update = {i_visitor = @0x1000}
   world_object_update = {i_visitor = @0x0}
   __FUNCTION__ = "Update"
   __PRETTY_FUNCTION__ = "virtual void Map::Update(const uint32&)"
#7  0x00000000009cb858 in MapManager::Update (this=0x7fd629010c60, diff=47)
   at ../../../src/game/MapManager.cpp:250
   iter = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, Map*>, false>> = {_M_cur_node = 0x7fd62549c790, 
   _M_cur_bucket = 0x7fd625106688}, <No data fields>}
#8  0x0000000000bc785b in World::Update (this=0x7fd63a933900, diff=47)
   at ../../../src/game/World.cpp:1486
   autobroadcaston = 0
#9  0x000000000080407c in WorldRunnable::run (this=0x7fd62512e070)
   at ../../../src/mangosd/WorldRunnable.cpp:60
   diff = 47
   realCurrTime = 3637508842
   realPrevTime = 3637508795
   prevSleepTime = 47
#10 0x0000000000c95a46 in ACE_Based::Thread::ThreadTask (param=0x7fd62512e070)
   at ../../../src/shared/Threading.cpp:187
   _task = (class ACE_Based::Runnable *) 0x7fd62512e070
#11 0x00007fd63bf00fc7 in start_thread () from /lib/libpthread.so.0
No symbol table info available.
#12 0x00007fd63b4d064d in clone () from /lib/libc.so.6
No symbol table info available.
#13 0x0000000000000000 in ?? ()
No symbol table info available.

is this a map problem?

July 9, 2010

are newlines supportet? (\\r, \\n)

July 5, 2010

should be fixed in 10154, thank you

July 5, 2010

http://github.com/mangos/mangos/commit/db2a6b23167dd8c9a65c29c501b178e3e1e15160

in the linux crashdumps i already posted a log.

It crashes permanently at the same point, thank you for fixing.

July 5, 2010

Revision: 10152

Core: MaNGOS + SD2

ACE: builtin

OS: debian lenny

Core was generated by `/home/fun/server/bin/mangos-worldd'.
Program terminated with signal 11, Segmentation fault.

[New process 15137]

[New process 15142]

[New process 15141]

[New process 15140]

[New process 15139]

[New process 15138]

[New process 11307]

[New process 15130]

[New process 11327]

[New process 11325]

[New process 11315]

#0 Object::GetUInt32Value (this=0x0, index=3)

at ../../../src/game/Object.h:153

153 ASSERT( index < m_valuesCount || PrintIndexError( index , false) );

#0 Object::GetUInt32Value (this=0x0, index=3)

at ../../../src/game/Object.h:153

__FUNCTION__ = "GetUInt32Value"

__PRETTY_FUNCTION__ = "const uint32& Object::GetUInt32Value(uint16) const"

#1 0x00000000005d9afe in Item::GetProto (this=0x0)

at ../../../src/game/Object.h:118

No locals.

#2 0x00000000006af9f5 in Player::_CanStoreItem (this=0x33e8000, bag=0 '\\0',

slot=255 'ÿ', dest=@0x42803f00, entry=44159, count=1, pItem=0x0,

swap=false, no_space_count=0x0) at ../../../src/game/Item.h:251

pProto = (const ItemPrototype *) 0x7fe812693670

no_similar_count = 0

res = <value optimized out>

#3 0x00000000006fc85a in Player::CanStoreNewItem (this=0x0, bag=3 '\\003',

slot=112 'p', dest=@0x0, item=1115700772, count=1, no_space_count=0x0)

at ../../../src/game/Player.h:1247

No locals.

#4 0x00000000006e4039 in Player::BuyItemFromVendorSlot (this=0x33e8000,

vendorguid=<value optimized out>, vendorslot=2, item=44159,

count=1 '\\001', bag=<value optimized out>, slot=255 'ÿ')

at ../../../src/game/Player.cpp:18613

dest = {<std::_Vector_base<ItemPosCount, std::allocator<ItemPosCount> >> = {

_M_impl = {<std::allocator<ItemPosCount>> = {<__gnu_cxx::new_allocator<ItemPosCount>> = {<No data fields>}, <No data fields>}, _M_start = 0x0,

_M_finish = 0x0, _M_end_of_storage = 0x0}}, <No data fields>}

msg = <value optimized out>

pProto = (const ItemPrototype *) 0x7fe812693670

pCreature = <value optimized out>

vItems = <value optimized out>

price = 1500000

#5 0x00000000005e4a34 in WorldSession::HandleBuyItemOpcode (

this=0x7fe822627e40, recv_data=@0x7fe824fbe350)

at ../../../src/game/ItemHandler.cpp:694

vendorguid = 3

item = 0

slot = <value optimized out>

count = <value optimized out>

#6 0x00000000007bee61 in WorldSession::ExecuteOpcode (this=0x7fe822627e40,

opHandle=<value optimized out>, packet=0x7fe824fbe350)

at ../../../src/game/WorldSession.cpp:870

No locals.

#7 0x00000000007c22db in WorldSession::Update (this=0x7fe822627e40)

at ../../../src/game/WorldSession.cpp:221

opHandle = (const OpcodeHandler &) @0x3: <error reading variable>

packet = (WorldPacket *) 0x7fe824fbe350

currTime = <value optimized out>

#8 0x00000000007baf0f in World::UpdateSessions (this=0x7fe82777b900, diff=50)

at ../../../src/game/World.cpp:1875

itr = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, WorldSession*>, false>> = {_M_cur_node = 0x7fe82777b900,

_M_cur_bucket = 0xffffffffff600424}, <No data fields>}

sess = <value optimized out>

#9 0x00000000007bb107 in World::Update (this=0x7fe82777b900, diff=50)

at ../../../src/game/World.cpp:1421

No locals.

#10 0x0000000000513071 in WorldRunnable::run (this=<value optimized out>)

at ../../../src/mangosd/WorldRunnable.cpp:60

diff = 50

realCurrTime = 2694109508

realPrevTime = <value optimized out>

prevSleepTime = 50

#11 0x000000000087110c in ACE_Based::Thread::ThreadTask (param=0x0)

at ../../../src/shared/Threading.cpp:187

_task = (class ACE_Based::Runnable *) 0x7fe825504220

#12 0x00007fe828d4afc7 in start_thread () from /lib/libpthread.so.0

No symbol table info available.

#13 0x00007fe82831a64d in clone () from /lib/libc.so.6

No symbol table info available.

#14 0x0000000000000000 in ?? ()

No symbol table info available.

July 3, 2010

Hi,

I have forund a ScriptDev2 Repo from RSA but i dont know if its better as the Orginal SD2.

What do you think about it?

http://github.com/rsa/scriptdev2

June 29, 2010

same here, crashlog (linux) already posted by me :-)

June 29, 2010

REv 10117 with anticheat, innormative logs and wowarmory

uptime: around 2 minutes

Core was generated by `/home/fun/server/bin/mangos-worldd'.
Program terminated with signal 6, Aborted.
[New process 5173]
[New process 5178]
[New process 5177]
[New process 5176]
[New process 5175]
[New process 5174]
[New process 5166]
[New process 5169]
[New process 5168]
[New process 5167]
#0  0x00007fd63d3f7ed5 in raise () from /lib/libc.so.6
#0  0x00007fd63d3f7ed5 in raise () from /lib/libc.so.6
No symbol table info available.
#1  0x00007fd63d3f93f3 in abort () from /lib/libc.so.6
No symbol table info available.
#2  0x00007fd63d3f0dc9 in __assert_fail () from /lib/libc.so.6
No symbol table info available.
#3  0x000000000062acf0 in InstanceMap::Add (this=0x1, player=0x7fd627a204f0)
   at ../../../src/game/Map.cpp:1866
   st = {static SYMBUFSIZ = 4096, 
 buf_ = "/home/fun/server/bin/mangos-worldd(_ZN12WorldSession13ExecuteOpcodeERK13OpcodeHandlerP11WorldPacket+0x31) [0x7befe1]\\n/home/fun/server/bin/mangos-worldd(_ZN12WorldSession6UpdateEj+0x1db) [0x7c245b]\\n/ho"..., buflen_ = 595, 
 static UNSUPPORTED = 0x7fd63f3cd540 "<stack traces unsupported platform>", 
 static UNABLE_TO_GET_TRACE = 0x7fd63f3cd570 "<unable to get trace>"}
   groupBind = (InstanceGroupBind *) 0x7fd63a053328
   pGroup = <value optimized out>
   playerBind = <value optimized out>
   __FUNCTION__ = "Add"
   __PRETTY_FUNCTION__ = "virtual bool InstanceMap::Add(Player*)"
#4  0x00000000008209cb in WorldSession::HandleMoveWorldportAckOpcode (
   this=0xfa2bd0) at ../../../src/game/MovementHandler.cpp:257
   mEntry = (const MapEntry *) 0x7fd638373b10
   mInstance = (const InstanceTemplate *) 0x7fd638c44804
   corpse = <value optimized out>
#5  0x00000000007befe1 in WorldSession::ExecuteOpcode (this=0xfa2bd0, 
   opHandle=<value optimized out>, packet=0xfb54d0)
   at ../../../src/game/WorldSession.cpp:870
No locals.
#6  0x00000000007c245b in WorldSession::Update (this=0xfa2bd0)
   at ../../../src/game/WorldSession.cpp:221
   opHandle = (const OpcodeHandler &) @0x1435: <error reading variable>
   packet = (WorldPacket *) 0xfb54d0
   currTime = <value optimized out>
#7  0x00000000007bb08f in World::UpdateSessions (this=0x7fd638019370, diff=50)
   at ../../../src/game/World.cpp:1867
   itr = {<std::tr1::__detail::_Hashtable_iterator_base<std::Pair<const unsigned int, WorldSession*>, false>> = {_M_cur_node = 0x7fd638019370, 
   _M_cur_bucket = 0xffffffffff600424}, <No data fields>}
   sess = <value optimized out>
#8  0x00000000007bb287 in World::Update (this=0x7fd638019370, diff=50)
   at ../../../src/game/World.cpp:1413
No locals.
#9  0x0000000000512ba1 in WorldRunnable::run (this=<value optimized out>)
   at ../../../src/mangosd/WorldRunnable.cpp:60
   diff = 50
   realCurrTime = 2180560742
   realPrevTime = <value optimized out>
   prevSleepTime = 50
#10 0x000000000087129c in ACE_Based::Thread::ThreadTask (param=0x142e)
   at ../../../src/shared/Threading.cpp:187
   _task = (class ACE_Based::Runnable *) 0xf76720
#11 0x00007fd63dec5fc7 in start_thread () from /lib/libpthread.so.0
No symbol table info available.
#12 0x00007fd63d49564d in clone () from /lib/libc.so.6
No symbol table info available.
#13 0x0000000000000000 in ?? ()
No symbol table info available.

MAP.CPP:1847-1867

                        // cannot jump to a different instance without resetting it
                       if (groupBind->save != GetInstanceSave())
                       {
                           sLog.outError("InstanceMap::Add: player %s(%d) is being put in instance %d,%d,%d but he is in group %d which is bound to instance %d,%d,%d!",
                               player->GetName(), player->GetGUIDLow(), GetInstanceSave()->GetMapId(),
                               GetInstanceSave()->GetInstanceId(), GetInstanceSave()->GetDifficulty(),
                               GUID_LOPART(pGroup->GetLeaderGUID()), groupBind->save->GetMapId(),
                               groupBind->save->GetInstanceId(), groupBind->save->GetDifficulty());

                           if (GetInstanceSave())
                               sLog.outError("MapSave players: %d, group count: %d",
                                   GetInstanceSave()->GetPlayerCount(), GetInstanceSave()->GetGroupCount());
                           else
                               sLog.outError("MapSave NULL");

                           if (groupBind->save)
                               sLog.outError("GroupBind save players: %d, group count: %d", groupBind->save->GetPlayerCount(), groupBind->save->GetGroupCount());
                           else
                               sLog.outError("GroupBind save NULL");
                           ASSERT(false);
                       }

ERRORLOG:

2010-06-29 06:51:22 ERROR:InstanceMap::Add: player Ã‚nimahcs(13333925) is being put in instance 632,83,1 but he is in group 13333924 which is bound to instance 632,82,1!

2010-06-29 06:51:22 ERROR:MapSave players: 0, group count: 0

2010-06-29 06:51:22 ERROR:GroupBind save players: 0, group count: 1

June 2, 2010

read howto´s, you find here enough howto´s (look at yum)

May 29, 2010

thank you :-)

May 28, 2010

Hi,

its possible to modify the core for filtering words and links in the chat?

thank you.

May 19, 2010

It works the same way as before

before this commit doesn´t exist a patchsystem.

May 19, 2010

[9935] ACE realmd, thanks to Zor and Vladimir for windows.

but how does work the patch system?

May 19, 2010

if the Mysql server stop...the MaNGOS server cannot work, with or without auto reconnect ^^

but a restart of mysql is what i mean :-)

May 16, 2010

Hi Devs,

Its possible to implement a reconnect feature at realmd and mangosd for mysql?

When the Server runs and mysql have a restart, the realmd and mangosd process does not reconnect to mysql. only a restart solves this.

i hope you know what i mean

tested with debian 5 and centos 5.4 cpanel

May 7, 2010

[9849] Implement character database clean up.
This can be disabled by config option.

Flag for clean up can be set for example on client version change.

how this work?

Its mean to DELETE ALL the chars on startup or delete all data for non existend chars?

wich flags are useable

April 21, 2010

Debian Lenny

Rev. 9770

../../../src/mangosd/CliRunnable.cpp:320: error: no match for âoperator>>â in âstd::basic_istringstream<char, std::char_traits<char>, std::allocator<char> >(((const std::basic_string<char, std::char_traits<char>, std::allocator<char> >&)(& std::basic_string<char, std::char_traits<char>, std::allocator<char> >(args, ((const std::allocator<char>&)((const std::allocator<char>*)(& std::allocator<char>())))))), _S_in) >> searchStringâ
/usr/include/c++/4.3/istream:123: note: candidates are: std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(std::basic_istream<_CharT, _Traits>& (*)(std::basic_istream<_CharT, _Traits>&)) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:127: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(std::basic_ios<_CharT, _Traits>& (*)(std::basic_ios<_CharT, _Traits>&)) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:134: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(std::ios_base& (*)(std::ios_base&)) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:170: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(bool&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:174: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(short int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:177: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(short unsigned int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:181: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:184: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(unsigned int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:188: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(long int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:192: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(long unsigned int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:197: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(long long int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:201: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(long long unsigned int&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:206: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(float&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:210: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(double&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:214: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(long double&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:218: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(void*&) [with _CharT = char, _Traits = std::char_traits<char>]
/usr/include/c++/4.3/istream:242: note:                 std::basic_istream<_CharT, _Traits>& std::basic_istream<_CharT, _Traits>::operator>>(std::basic_streambuf<_CharT, _Traits>*) [with _CharT = char, _Traits = std::char_traits<char>]
../../../src/mangosd/../game/ObjectGuid.h:268: note:                 ByteBuffer& operator>>(ByteBuffer&, ObjectGuid&)
../../../src/mangosd/../game/ObjectGuid.h:271: note:                 ByteBuffer& operator>>(ByteBuffer&, const PackedGuidReader&)
../../../src/mangosd/../game/Unit.h:812: note:                 ByteBuffer& operator>>(ByteBuffer&, MovementInfo&)
/usr/include/c++/4.3/bits/basic_string.h:2407: note:                 std::basic_istream<_CharT, _Traits>& std::operator>>(std::basic_istream<_CharT, _Traits>&, std::basic_string<_CharT, _Traits, _Alloc>&) [with _CharT = char, _Traits = std::char_traits<char>, _Alloc = std::allocator<char>]
make[3]: *** [CliRunnable.o] Error 1

April 10, 2010

no comment? :-)

current column id "ID" but core searches "GUID"

April 9, 2010

SQL: SELECT * FROM character_pet_declinedname WHERE guid = '50321'

query ERROR: Unknown column 'guid' in 'where clause'

Sign In

Profiles

Bug Tracker

Wiki

Release Notes

Forums

Downloads

Blogs

Events

Posts posted by heugabel

Contact Us

Repositories

Important Information