Arkadus

As title describes REPLACE INTO `game_graveyard_zone` (`id`, `ghost_zone`, `faction`) VALUES (852, 1537, 469), (853, 1497, 67); UPDATE `game_graveyard_zone` SET `id` = 469 WHERE `faction` = 67 AND `ghost_zone` = 1657; UPDATE `game_graveyard_zone` SET `id` = 429 WHERE `faction` = 469 AND `ghost_zone` = 85; UPDATE `game_graveyard_zone` SET `id` = 229 WHERE `faction` = 469 AND `ghost_zone` = 1638; INSERT INTO `game_graveyard_zone` (`id`,`ghost_zone`,`faction`) VALUES (101,1537,67),(429,1497,469);

As title describes UPDATE `creature_ai_scripts` SET `action1_param2` = 1, `action1_param3` = 0, `event_flags` = 1, `event_param3` = 15000, `event_param4` = 30000 WHERE (`id` = 43101 OR `id` = 446601 OR `id` = 463702 OR `id` = 536401 OR `id` = 562301 OR `id` = 598201 OR `id` = 1474801 OR `id` = 178703 OR `id` = 255603 OR `id` = 260602 OR `id` = 264906 OR `id` = 402402 OR `id` = 648803 OR `id` = 702702 OR `id` = 727404 OR `id` = 779703) AND `action1_param1` = 7160; UPDATE `creature_ai_scripts` SET `action1_param1` = 8242 WHERE `id` = 184605 AND `action1_param1` = 15655; UPDATE `creature_ai_scripts` SET `action1_param2` = 0 WHERE `event_type` = 10 AND `action1_type` = 12 AND `action1_param1` = 15138; UPDATE `creature_ai_scripts` SET `action1_param1` = 20537, `action1_param2` = 1, `action1_param3` = 0, `event_flags` = 1, `event_param1` = 15000, `event_param2` = 30000 WHERE (`action1_param1` = 15122 OR `action1_param1` = 20537) AND `event_type` = 13 AND `action1_type` = 11; UPDATE `creature_ai_scripts` SET `action1_param2` = 1, `action1_param2` = 0, `event_flags` = 1 WHERE (`action1_param1` = 12555 OR `action1_param1` = 15615 OR `action1_param1` = 15621 OR `action1_param1` = 11978 OR `action1_param1` = 15614 OR `action1_param1` = 25788) AND `event_type` = 13 AND `action1_type` = 11; UPDATE `creature_ai_scripts` SET `action1_param2` = 1, `action1_param2` = 0, `action1_param3` = 0, `event_flags` = 1, `event_param1` = 4000, `event_param2` = 8000 WHERE (`id` = 184504 OR `id` = 184605) AND `action1_param1` = 8242; UPDATE `creature_ai_scripts` SET `action1_param2` = 1, `action1_param2` = 0, `action1_param3` = 0, `event_flags` = 1, `event_param1` = 15000, `event_param2` = 30000 WHERE (`id` = 1432105 OR `id` = 1432305 OR `id` = 1432605 OR `id` = 58702 OR `id` = 154004 OR `id` = 166404 OR `id` = 1383908 OR `id` = 312902 OR `id` = 319204 OR `id` = 373906 OR `id` = 432806 OR `id` = 560106 OR `id` = 580903 OR `id` = 606906) AND `action1_param1` = 11972 OR `action1_param1` = 72; UPDATE `creature_ai_scripts` SET `action1_type` = 32, `action2_type` = 32, `action3_type` = 32, `action1_param2` = 1, `action2_param2` = 1, `action3_param2` = 1, `action1_param3` = 4, `action2_param3` = 5, `action3_param3` = 6 WHERE `id` = 684602; UPDATE `creature_ai_scripts` SET `action1_param2` = 1, `action1_param3` = 0 WHERE `id` = 1082406 OR `id` = 1082407 OR `id` = 1571802; UPDATE `creature_ai_scripts` SET `action1_param1` = 11976 WHERE `id` = 1082407; UPDATE `creature_ai_scripts` SET `event_type` = 9, `event_flags` = 1, `event_param1` = 0, `event_param2` = 5, `event_param3` = 7000, `event_param4` = 14000, `action1_param2` = 1, `action1_param3` = 0 WHERE `action1_type` = 11 AND `action1_param1` = 11978; UPDATE `creature_ai_scripts` SET `action1_param2` = 0, `action1_param3` = 0 WHERE `id` = 1145502; UPDATE `creature_template` SET `AIName` = "" WHERE `Entry` = 4509; UPDATE `creature_ai_scripts` SET `event_flags` = 0 WHERE `id` = 1521501; UPDATE `creature_ai_scripts` SET `action2_type` = 32, `event_chance` = 5 WHERE `id` = 327402 OR `id` = 327502 OR `id` = 339703; UPDATE `creature_ai_scripts` SET `action1_type` = 32, `action2_type` = 0 WHERE `id` = 177203 OR `id` = 177303; UPDATE `creature_ai_scripts` SET `action2_type` = 0, `action2_param2` = 0 WHERE `id` = 494903; DELETE FROM `creature_ai_scripts` WHERE `id` = 1018206;

As title describes UPDATE `gameobject_template` SET `faction` = 0 WHERE `entry` = 179900 OR `data2` = 2061 OR `data2` = 2066 OR `name` = "Fire" OR `name` = "Campfire" OR `name` = "Bonfire Damage" OR `entry` = 176510 OR `entry` = 178559 OR `entry` = 179065 OR `entry` = 181029 OR `entry` = 181376;

As title describes UPDATE `creature_template` SET `ExtraFlags` = 2 WHERE `Entry` = 69 OR `Entry` = 5912 OR `Entry` = 8297 OR `Entry` = 1508 OR `Entry` = 1509; UPDATE `item_template` SET `subclass` = 0 WHERE `class` = 15; DELETE FROM `creature_equip_template` WHERE `equipentry1` = 27524; UPDATE `creature_template` SET `FactionAlliance` = 115, `FactionHorde` = 115, `UnitClass` = 1 WHERE `Entry` = 14755 OR `Entry` = 14756; DELETE FROM `gameobject` WHERE `GUID` = 5315 OR `GUID` = 5431; DELETE FROM `conditions` WHERE `condition_entry` = 717 OR `condition_entry` = 718; DELETE FROM `creature_loot_template` WHERE `entry` = 68 OR `entry` = 325 OR `entry` = 466 OR `entry` = 467 OR `entry` = 468 OR `entry` = 469 OR `entry` = 487 OR `entry` = 488 OR `entry` = 489 OR `entry` = 490 OR `entry` = 494 OR `entry` = 495 OR `entry` = 499 OR `entry` = 754 OR `entry` = 826 OR `entry` = 827 OR `entry` = 828 OR `entry` = 853 OR `entry` = 861 OR `entry` = 862 OR `entry` = 863 OR `entry` = 864 OR `entry` = 865 OR `entry` = 866 OR `entry` = 867 OR `entry` = 868 OR `entry` = 869 OR `entry` = 870 OR `entry` = 874 OR `entry` = 876 OR `entry` = 885 OR `entry` = 886 OR `entry` = 887 OR `entry` = 932 OR `entry` = 933 OR `entry` = 934 OR `entry` = 935 OR `entry` = 936 OR `entry` = 999 OR `entry` = 1064 OR `entry` = 1245 OR `entry` = 1278 OR `entry` = 1280 OR `entry` = 1337 OR `entry` = 1338 OR `entry` = 1414 OR `entry` = 1421 OR `entry` = 1434 OR `entry` = 1437 OR `entry` = 1476 OR `entry` = 1477 OR `entry` = 1481 OR `entry` = 1483 OR `entry` = 1642 OR `entry` = 1733 OR `entry` = 1741 OR `entry` = 1754 OR `entry` = 1756 OR `entry` = 1777 OR `entry` = 1949 OR `entry` = 1975 OR `entry` = 2058 OR `entry` = 2099 OR `entry` = 2105 OR `entry` = 2112 OR `entry` = 2153 OR `entry` = 2238 OR `entry` = 2239 OR `entry` = 2361 OR `entry` = 2362 OR `entry` = 2363 OR `entry` = 2378 OR `entry` = 2379 OR `entry` = 2386 OR `entry` = 2392 OR `entry` = 2395 OR `entry` = 2396 OR `entry` = 2398 OR `entry` = 2400 OR `entry` = 2402 OR `entry` = 2466 OR `entry` = 2468 OR `entry` = 2469 OR `entry` = 2470 OR `entry` = 2506 OR `entry` = 2507 OR `entry` = 2508 OR `entry` = 2509 OR `entry` = 2510 OR `entry` = 2511 OR `entry` = 2527 OR `entry` = 2608 OR `entry` = 2714 OR `entry` = 2721 OR `entry` = 2787 OR `entry` = 3083 OR `entry` = 3338 OR `entry` = 3501 OR `entry` = 3691 OR `entry` = 3695 OR `entry` = 3732 OR `entry` = 3733 OR `entry` = 3734 OR `entry` = 3804 OR `entry` = 3806 OR `entry` = 3807 OR `entry` = 3808 OR `entry` = 3893 OR `entry` = 4966 OR `entry` = 4979 OR `entry` = 4995 OR `entry` = 5546 OR `entry` = 7489 OR `entry` = 7730 OR `entry` = 7843 OR `entry` = 7865 OR `entry` = 7939 OR `entry` = 7975 OR `entry` = 7980 OR `entry` = 8015 OR `entry` = 8016 OR `entry` = 8096 OR `entry` = 8147 OR `entry` = 8154 OR `entry` = 8155 OR `entry` = 8310 OR `entry` = 9118 OR `entry` = 9119 OR `entry` = 9525 OR `entry` = 10036 OR `entry` = 10037 OR `entry` = 10684 OR `entry` = 10696 OR `entry` = 11040 OR `entry` = 11053 OR `entry` = 11180 OR `entry` = 11276 OR `entry` = 11328 OR `entry` = 11609 OR `entry` = 11615 OR `entry` = 11979 OR `entry` = 11994 OR `entry` = 12047 OR `entry` = 12160 OR `entry` = 12657 OR `entry` = 12658 OR `entry` = 12736 OR `entry` = 12858 OR `entry` = 12862 OR `entry` = 12863 OR `entry` = 12903 OR `entry` = 13817 OR `entry` = 14983 OR `entry` = 15443 OR `entry` = 17070 OR `entry` = 17079 OR `entry` = 17080 OR `entry` = 2512 OR `entry` = 2513 OR `entry` = 2514 OR `entry` = 2515 OR `entry` = 2516 OR `entry` = 2517 OR `entry` = 2518 OR `entry` = 2525 OR `entry` = 2526; DELETE FROM `gameobject_loot_template` WHERE `entry` = 164885 OR `entry` = 164887 OR `entry` = 173324 OR `entry` = 173327 OR `entry` = 174599 OR `entry` = 174600 OR `entry` = 174601 OR `entry` = 174602 OR `entry` = 174603 OR `entry` = 174604 OR `entry` = 174608 OR `entry` = 174684 OR `entry` = 174708 OR `entry` = 174709 OR `entry` = 182114; DELETE FROM `gossip_menu_option` WHERE `condition_id` = 718 OR `condition_id` = 717 OR `menu_id` = 10360; DELETE FROM `gossip_menu` WHERE `condition_id` = 718; DELETE FROM `dbscripts_on_gossip` WHERE `id` = 2908 OR `id` = 66442 OR `id` = 66441; DELETE FROM `dbscripts_on_quest_start` WHERE `datalong` = 317 OR `datalong` = 318; DELETE FROM `db_script_string` WHERE `entry` = 2000000016 OR `entry` = 2000005019 OR `entry` = 2000005020; UPDATE `creature_movement` SET `script_id` = 0 WHERE `script_id` = 1018206; UPDATE `npc_vendor` SET `incrtime` = 0 WHERE `entry` = 491 AND `item` = 4496; UPDATE `creature_template` SET `npcflags` = 2 WHERE `entry` = 3209; UPDATE `creature_template` SET `npcflags` = 135 WHERE `entry` = 9087; UPDATE `creature_item_template` SET `class` = 2, `subclass` = 16, `inventory_type` = 25, `sheath_type` = 0, `material` = 1 WHERE `entry` = 2945 OR `entry` = 3109 OR `entry` = 3128 OR `entry` = 4959 OR `entry` = 5559 OR `entry` = 20814 OR `entry` = 21135 OR `entry` = 25497 OR `entry` = 25641 OR `entry` = 25665; UPDATE `creature_item_template` SET `sheath_type` = 0, `inventory_type` = 27, `class` = 11, `subclass` = 2, `material` = 8 WHERE `entry` = 2101 OR `entry` = 2662 OR `entry` = 3573 OR `entry` = 3605 OR `entry` = 5439 OR `entry` = 7278 OR `entry` = 7371 OR `entry` = 8217 OR `entry` = 11362 OR `entry` = 18714 OR `entry` = 19319 OR `entry` = 34100; UPDATE `creature_item_template` SET `class` = 2, `subclass` = 5, `inventory_type` = 17,`sheath_type` = 1, `material` = 1 WHERE `entry` = 9464; UPDATE `creature_item_template` SET `class` = 2, `subclass` = 7, `inventory_type` = 13,`sheath_type` = 3, `material` = 1 WHERE `entry` = 9719 OR `entry` = 32674; UPDATE `creature_item_template` SET `class` = 12, `subclass` = 0, `inventory_type` = 23,`sheath_type` = 2, `material` = 2 WHERE `entry` = 11885; UPDATE `creature_item_template` SET `class` = 4, `subclass` = 0, `inventory_type` = 23,`sheath_type` = 2, `material` = 4 WHERE `entry` = 11905 OR `entry` = 12065 OR `entry` = 13544; UPDATE `creature_item_template` SET `class` = 15, `subclass` = 0, `inventory_type` = 23,`sheath_type` = 0, `material` = 0 WHERE `entry` = 13876 OR `entry` = 13877 OR `entry` = 13878 OR `entry` = 13879 OR `entry` = 13880 OR `entry` = 21169 OR `entry` = 21170 OR `entry` = 21171 OR `entry` = 21172 OR `entry` = 21173 OR `entry` = 21174 OR `entry` = 32911 OR `entry` = 32921 OR `entry` = 21713; UPDATE `creature_item_template` SET `class` = 0, `subclass` = 0, `inventory_type` = 26,`sheath_type` = 0, `material` = 0 WHERE `entry` = 20908; UPDATE `creature_item_template` SET `material` = 0 WHERE `material` = 255;

As title describes UPDATE `gameobject` SET `spawntimesecs` = 604800 WHERE `id` = 180690; REPLACE INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES (180690, 21156, 100, 0, 1, 1, 0), (180690, 20874, 20, 0, 1, 1, 0), (180690, 20876, 20, 0, 1, 1, 0), (180690, 20877, 20, 0, 1, 1, 0), (180690, 20878, 20, 0, 1, 1, 0), (180690, 20881, 20, 0, 1, 1, 0); REPLACE INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES (180691, 21156, 100, 0, 1, 1, 0), (180691, 20873, 12.5, 0, 1, 1, 0), (180691, 20869, 12.5, 0, 1, 1, 0), (180691, 20866, 12.5, 0, 1, 1, 0), (180691, 20870, 12.5, 0, 1, 1, 0), (180691, 20868, 12.5, 0, 1, 1, 0), (180691, 20871, 12.5, 0, 1, 1, 0), (180691, 20867, 12.5, 0, 1, 1, 0), (180691, 20872, 12.5, 0, 1, 1, 0); DELETE FROM `gameobject_loot_template` WHERE `entry` = 17533 OR `entry` = 17532; UPDATE `gameobject_template` SET `data1` = 180690 WHERE `entry` = 180690; UPDATE `gameobject_template` SET `data1` = 180691 WHERE `entry` = 180691;

AQ40 Skeram Image FIX In boss_skeram.cpp make this change; void DoInitializeImage() { if (!m_pInstance) { return; } // Initialize the health of the clone if (Creature* pProphet = m_pInstance->GetSingleCreatureFromStorage(NPC_SKERAM)) { float fHealthPct = pProphet->GetHealthPercent(); float fMaxHealthPct = 0; // The max health depends on the split phase. It's percent * original boss health if (fHealthPct { fMaxHealthPct = 0.50f; } else if (fHealthPct { fMaxHealthPct = 0.20f; } else { fMaxHealthPct = 0.10f; } // Set the same health percent as the original boss m_creature->SetMaxHealth(m_creature->GetMaxHealth()*fMaxHealthPct); m_creature->SetHealthPercent(fHealthPct); +m_creature->SetCorpseDelay(0); // } }

Error in source code ap_bonus/ap_dot_bonus In Void SpellMgr::LoadSpellBonuses() SpellBonusEntry sbe; sbe.direct_damage = fields[1].GetFloat(); sbe.one_hand_direct_damage = fields[2].GetFloat(); sbe.two_hand_direct_damage = fields[3].GetFloat(); sbe.direct_damage_done = fields[4].GetFloat(); sbe.one_hand_direct_damage_done = fields[5].GetFloat(); sbe.two_hand_direct_damage_done = fields[6].GetFloat(); sbe.direct_damage_taken = fields[7].GetFloat(); -sbe.one_hand_direct_damage_taken = fields[7].GetFloat(); -sbe.two_hand_direct_damage_taken = fields[8].GetFloat(); -sbe.dot_damage = fields[9].GetFloat(); -sbe.ap_bonus = fields[10].GetFloat(); -sbe.ap_dot_bonus = fields[11].GetFloat(); Should actually be: SpellBonusEntry sbe; sbe.direct_damage = fields[1].GetFloat(); sbe.one_hand_direct_damage = fields[2].GetFloat(); sbe.two_hand_direct_damage = fields[3].GetFloat(); sbe.direct_damage_done = fields[4].GetFloat(); sbe.one_hand_direct_damage_done = fields[5].GetFloat(); sbe.two_hand_direct_damage_done = fields[6].GetFloat(); sbe.direct_damage_taken = fields[7].GetFloat(); +sbe.one_hand_direct_damage_taken = fields[8].GetFloat(); +sbe.two_hand_direct_damage_taken = fields[9].GetFloat(); +sbe.dot_damage = fields[10].GetFloat(); +sbe.ap_bonus = fields[11].GetFloat(); +sbe.ap_dot_bonus = fields[12].GetFloat();

Level 60 Stats Also Druid's base stats are, 65 str 60 agi 70 stam 100 int 115 spirit You can also determine what the base health and base mana for each class is by subtracting the basehealth - stam * 10 or the basemana - int * 15. Mage = 1190 / 933 Priest = 1217 / 1096 Warrior = 1509 Warlock = 1234 / 1093 Hunter = 1287 / 1440 Druid = 1303 / 1121 Rogue = ? Paladin = ? / ? Shaman = ? / ?