heugabel

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;

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,

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

mangos R10366 (armory arena chart)

Rev: 10321 Uptime near 22 Minutes MAngos + SD2 + YTDB R559

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

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?

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

should be fixed in 10154, thank you

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.

Revision: 10152 Core: MaNGOS + SD2 ACE: builtin OS: debian lenny

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

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

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

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

thank you :-)

Hi, its possible to modify the core for filtering words and links in the chat? thank you.

before this commit doesn´t exist a patchsystem.

[9935] ACE realmd, thanks to Zor and Vladimir for windows. but how does work the patch system?

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

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

how this work? Its mean to DELETE ALL the chars on startup or delete all data for non existend chars? wich flags are useable

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

no comment? :-) current column id "ID" but core searches "GUID"

SQL: SELECT * FROM character_pet_declinedname WHERE guid = '50321' query ERROR: Unknown column 'guid' in 'where clause'