Heroes of Northrend 3.2.2

By grimeleven
WoW Client 3.2.2a
ArcEmu Core r2968
HybridDB rev11+ DB updates until r2934
Funserver

Here's my first repack . I started this project on May 15 and worked on it on my free time, from a clean HybridDB. I took my time to polish it, more and more but it was worth waiting, we got ArcEmu official core. A lot of content has been added since and i will update it when needed or new core revs. I wouldn't claim it's perfect but try it out. I am happy with result, hope you enjoy!

The original readme is in the file, my post was too long.

Important notice:

Okay this is a funserver repack because i did not want to claim it “Blizz-like” knowing it wouldn't be possible. It was my goal but there is no way i can fix everything in the DB to make it like "retail", they have a full team of programmers, i don't. I made it as much Blizzlike i could then i added custom stuff, anyways if people want everything working they would play on "retail"... duh.

The feature I wanted most to include is the mobs casting spells, lots of monsters are now casting their spells, i've included 2000+ scripts (not by me) but there will still be stuff not working right and mobs only fighting melee.

When you find incorrect data, bugs, duplicate spawns, please report them, i will try my best to fix it, i had no bug on my part on creating characters, logging on and playing normally but i did not test every classes/races combination with items, spells, talents etc, so report any bugs, thanks.

Features:

Quests to obtain several legendary item like, Gorribal the Dark Seether, Eye of Sargeras, Jeweled Scepter of Sargeras.

Dark Titan Legendary Battlegear armor that every classes can use which drops from the Lich King!

Epic Battle of Angrathar Wrathgate remade! Lich King LUA scripted fight, he has sounds too, defeat him and his army with the help of the Heroes of Northrend; Highlord Tirion Fordring, Highlord Darion Mograine and High Overlord Saurfang with all their special abilities/weapons voices and more!

Ulduar monsters with Bosses, working area triggers and portals, a lot of monsters are spawned but I won't say a percentage (laugh) see screenshots

Teleporter NPC with Northrend locations and Ulduar

Tier 8 and 8.5 from "Blizzlike" vendors

Over 611 missing items from 3.1, Ulduar etc. item added in the database and on the NPC's who drops them.

Blizzlike spells! Over 10000 monsters are now casting their spells on "percentage" including Ulduar NPC's and more will be added.

Dalaran Mall! Located at “Krasus landing” (.rec p mall) features:
-Armor/weapons vendors
-Twink vendors
-Spells (buffs) vendor
-Professions trainers
-Class trainers.
-Lottery NPC! buy coins at “Currency” NPC to become rich! or not!

Talents points are working. As for the talents themselves, a lot of them are working right, thanks to the Official Arcemu core, example Divine storm(heals) and Hammer of the Righteous, further testing required.

Glyphs works, overwriting a glyph works also. *edit* new core fixed the glyphs

As for the spells/talents/scripts, a lot of them are working but still, more work needs to be done “core” side.

Code:

[u][b]Fixes&modifications[/b][/u]

Applied my fix for MySQL so now you can start the server from any folder. No more errors “errmsg.sys”.

Applied my fix for recalls, they work fine now.

Fixed Blizzlike portals to cities etc.

Applied RDB fixed quests in Northrend.

Fixed teleporter NPC and modified it to remove unwanted stuff.

Removed all vendor on GM island, moved to Dalaran, Mall, which is now added to the Teleporter NPC.

Players no longer start on GM island, players spawn at default start location but with Teleporters.

Removed double spawns on NPC's, too many to list but there was a lot of them, i'm sure there is still a lot to remove.

Fixed Cold Weather trainers bug, now all 3 trainers are fixed and Cold Weather Flying works too.

Added some missing flying mounts to the custom mount vendor.

Added Tier 8 and 8.5 from my old project based on Aspire, i had to convert it to ArcEmu.

Dubin Clay in Dalaran now has the Tier 8 items (Warrior, DK, Pally) and with their proper extended costs.

Added tokens loot on Ulduar bosses. No vendor for free T8 :P

Fixed Dalaran's Blizzlike Arena Vendors

Waypoints added on some mobs.

Removed broken gameobjects that caused wow client crashes when the player would pass near it, some places in Northrend map and some in instances, report if more places are bugged.

Fixed a lot of NPC's which were not attackable, changed faction from neutral to hostile.

Fixed Colossal Abobination and Angrathar Aberration's damage, once they hit players the WoW client would crash with error #132.

Simple LUA scripts for Heroes at Angrathar :P

Recalls added for Northrend areas.

Corrected item ID's on some flasks and mixtures, their ID got mixed up (laugh)

Spawned Ultimate Teleporter NPC near cities, start areas and instances.

Added Blessing of Kings to Blizzlike Paladin trainers and custom trainers.

Update to 3.2.0 creatures/items/gameobjects failed to load, now fixed!

Instructions
Like all repacks, make sure you have Dotnet 3.5 installed [URL="http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe"]http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe[/URL]
Extract the folder "Heroes of Northrend" anywhere on your hard disk
Extract the maps with Heroes of Northrend\\tools\\Map extractor\\ad.exe
Copy it into "World of Warcraft" execute it and it will create a folder "maps" that you will have to move to Heroes of Northrend\\ArcEmu\\ after it's finished extracting. Or download em Maps Download Maps322.rar for free on uploading.com

Run
Heroes of Northrend\\Server\\MySQL.bat
Heroes of Northrend\\Server\\Apache.bat
Heroes of Northrend\\ArcEmu\\arcemu-logonserver.exe
Heroes of Northrend\\ArcEmu\\arcemu-world.exe

Open your browser and type "locahost" you will be taken to the account creation page, restart the server if account is not activated.

Login for WoW client: USER = admin PASS = admin

I've included the addon "ArcCorrect" (extract into "Addons" folder) to fix the item icons displaying a "?"

If you use any of this content please give the credits to the guys below.

Credits
grimeleven (Me) - for DB bug fixes, server startup, lots of db updates, adding missing NPC's/items/loot, adding custom stuff.
ArcEmu for 3.2.0 Core
Core compiles by grimeleven
Lordrob2k3 For HybridDb & a lot of Fixes
RDB AND NCDB
Wowhead.com
Faddix - WARP, Vendor, repacks ...
PaikProduction WOTLK VENDORs
GMI TEAM Global trainers
Knaur - for all in one class trainers
rkod420 - for quests fix from RivalDB
tikkit – gamble NPC LUA script
FinnZor – Twink Vendor NPC
lollardo – The Lich King LUA script (modified)
newmoon – Ulduar teleportation pads LUA script
Squire-DB - creature/items/gameobjects missing table fix
ArcCorrect - Ethos and BitByte, merged by HalestormXV
bljardkungen - Account creation website tutorial
Zolar - Isle of Conquest worldmapinfo
rofni - Item Grabber for 3.2
ZenX - tester/fixes
Adria61 - tester/fixes
deep6ixed - tester/fixes
Zotesh - tester/fixes

If I forgot someone let me know.

Here is a online server with this repack, hosted 24/7 by our friend ZenX, with blizzlike rates, try it out: Zantos Server

You don't need these if you use the newer version6 after October 11

Code:

Update4 fixes Elevators, Dungeons and some mobs.
[url=http://www.mediafire.com/?2ixkzjymgwu]Update4.sql[/url]
Ultimate Teleporter Repaired! Overwrite the old in HoN\\ArcEmu\\scripts
[url=http://www.mediafire.com/?mjnwlmkzjnl]Ultimate Teleporter NPC.rar[/url]
Update5 Fixes Bag vendor, Stable masters, Creatures, Custom "Gem I Vendor", Lot of NPC fixes etc read the details in the sql.
[url=http://www.mediafire.com/?yhmjxoyzoz5]Update5.sql[/url]
Update6 9/25/2009 Various fixes
[url=http://www.mediafire.com/?yzwjgjdy0lj]Update6.sql[/url]
Update7 10/07/2009 Various fixes *Re-apply it, fixed a query inside*
[url=http://www.mediafire.com/?kfqyyhxmd4h]Update7.sql[/url]
Update8 10/11/2009 2051 missing items, Scryers, T8 Vendors and more
[url=http://www.mediafire.com/?zvjztdzvni3]Update8.sql[/url]
Core r2957 Don't forget to apply \\HoN\\SQL Updates\\logon\\2934_characters.sql
[url=http://www.mediafire.com/?42hd3enyyq5]Grey69 - Core r2957 Official Client 3.2.2a.rar[/url]

Bugs already fixed
-Mail system fixed! ArcEmu
-Deeprun and Ulduar Trams fixed! ArcEmu
-Glyphs now show icon display! ArcEmu
-Bug which made characters naked, now fixed! ArcEmu
-Isle of Conquest partially fixed! but cannot join battle ArcEmu
-Godmode client crash (error #132) fixed! (Core edit)
-potions cooldown from Squire-DB
-vlack fixed maps fixes Fishing except in Northrend
-Core r2939 fixes Spellpower + Brewfest SQL
-Core r2952 Fixed Spell area requirements, Race/Class condition in Player, Knights Ebon rep fixed
-Core r2957 Fixes Auction house "Item not found", Fixed Party Loot "60000" (Core edit)Credits to alleycat who found it out! thanks (now official patch)



Download Link: Heroes of Northrend v6.rar

New Oct 25 2009
Core r2968
-My fix for Windfury/Flametongue Weapon Teleport home bug
-My fix for Brewfest music, it should now play when you enter the zone.
-Fixed aura display when a map change occurs - ArcEmu

Grey69 - Core r2968 Official Client 3.2.2a.rar
Update9.sql See the changes inside

AWSOME RUSS THANKS! is this the repack you are using?

no we dont use repacks but this repack is for Arcemu and has good database to it. I personally dont like arcemu for large server like mine, but this repack is great for small servers

Zanukan wrote:

no we dont use repacks but this repack is for Arcemu and has good database to it. I personally dont like arcemu for large server like mine, but this repack is great for small servers

so what ur saying is that i need another real repack to use this. This is only another DB?

hey the SQL updates>world doesnt work on my 3.2.2 repack( yes it is arc emu ) it says that some table doesnt exist

no this is a repack

what tables are you missing?

logon.creature_names - Brewfest_Active
logon.gameobject_names - Brewfest_SettingUp
logon.creature_spawns - HarvestFestival_Spawn
logon.creature_spawns - Update7
logon.quests - Update 8

and could u please send me ur msn?

btw if this is a repack what do i do to run it after ive used the ad.exe

seems like you not setting up your configs correctly.

logon is logon database, creature_names and others should be in world database bro

ill try again with something

ok now some of it worked i just had the wrong target in the DB

but now the otherone say

Update 7-8 - Column count doesnt match value count at row 1

Brewfest_SettingUp - Uknown column 'guardtype' in 'field list'

and hey russ PM you msn! ><