[Release] Battle for Hillsbrad for MaNGOS 4854+ (for fun servers)

[Arachnia]

The citizens of Southshore and Tarren Mill have rekindled their old rivalries and have gone to war once again. It all started with the death of the Crimson Courier. High Executor Darthalia of Tarren Mill suspects Southshore was involved. Southshore claims it was Defias. The Defias deny ever being in Hillsbrad. Warlord Dante and Marshall Oro lead the call to arms and formed a militia in their respective towns. The fight is on and the stakes are high. Its the perfect situation for mercenaries like yourselves to profit!

TO WAR!!!




Note to Ascent/Antrix admins: We did not create the event for use on such servers, nor will we update it for it. However if anyone wishes to convert the SQL scripts for use with Antrix we will provide you with +rep and thanks in the v1.1 credits.

Myself and Jasperjag attempted recreating the feel of Tarren Mill vs. Southshore for implementation on small private servers. It comes complete with pvp items and quests for the level 30 range.

We finished this about a month ago but after exporting all the SQL entries from our old DB and updating them for compatibility with the new format of the 4847-4854 DB, we realized we had the whole thing sitting there conveniently for release. You NEED 4854 or later for this to work properly as that is the format the SQL entries are designed for.

What we did NOT include however is the scripting we use to handle the movement of the npcs involved (mainly because we do not want to sit here telling people how to compile), so the mobs are just standing there not attacking. I will get to how to set it up ingame a little later in this post. (We did not include the scripting because we are not done writing it and some aspects of the scripting is broken and exploitable, we'll release the fully scripted event in v1.1 in a week or two)

Battle for Hillsbrad v1.0 for MaNGOS 4854+ :
Filebeam - Free Fast File Hosting

Installing:
I assume if you're running a server you already know how to run batch on your database so for the sake of making my post smaller, simply import the SQL scripts on to your mangos database.

Restart your server obviously since you can not .reload creature_template.

Once @ location, to get them to attack each other, you need to create 2 waypoints for each raider. So lets start in Southshore. Select your first Tarren Mill Raider and stand on top of him. Type '.addwp' and hit enter. This will respawn your raider so reselect him, then move to the nearest Southshore Defender and type '.addwp' and hit enter. Repeat this for all raiders in the zone, including Marshal Oro, Warlord Dante, and the Southshore Raiders located @ Tarren Mill's entrance. The reason this works is because in order to attack eachother, one side has to SEE the other side moving. For better control over things (ie: if they default to standing still sometimes) create a waypoint for 1 defender in each group).

notes:
*Dante and Oro are at the tower between TM & SS
*The quest givers for both factions are near the Town Hall in Southshore, and near the Church in Tarren Mill. Named Aevan, and Lyx.
*Just incase some of you out there are concerned about overwriting existing entries you have created in your DB, our entries are as follows:
item_template 80000-80046
creature_template 80001-80008
quest_template 80007-80012
creature_loot_template 80001-80004
creature_addon_template 80001+80002

That's all you have to do, enjoy!

If you have any problems getting it to work feel free to ask away and I'll answer what I can. There are always unforseen issues with such releases and will do my best to address them.

[jasperjag]

This is Arachnia and my first release. We are currently developing more such world PvP events for our server. Any feedback we could get would be greatly apriciated.

This event works great on our server and has given us an easy way to get gear for leveling to 60 and begining raiding. The event is still being tweaked and when we finish fully scripting the two bosses we will release the updates here. Enjoy and let us know what you think!!!

[Gastricpenguin]

Looking good,
Id love to see a movie of the scripted event

[jasperjag]

Haha actually that was what I was thinking of adding... I will try and work one up tomorow when I am on a good connection, to give everyone a look at the event.

[Arachnia]

I have something in mind Jag, I'll work on it since you're out @ tcat's tonight.

(well it's done, just gotta wait a bit to free up some bandwidth )

[Arachnia]

By request:

Well here's a video of the thing. During the creation of the video I turned off the scripting for all involved NPCs except Dante and Oro which I only show a brief clip of. Did this so that people could see what it looks like for the majority of the event as they would see it using the waypoint system.

You can see Dante yelling. His script is set to yell on aggro, when he dies, when he kills someone/thing+sound, and at 75/50/25% health. mostly taunts (basic bare-bones scripting). Like I said before we'll release the .cpp files with 1.1.

Remember that not everyone has the same taste in music. If you don't like it, mute it :P (and I only added the beginning cuz it just goes too well with the song lol)

higher quality video (you can also stream it from this link):
battle_for_hillsbrad.avi - FileFront.com

[ame]http://www.youtube.com/watch?v=r4xq_a0YhnA[/ame]

[Illidan1]

this is Really nice, even though no one has Downloaded it, unless they made a new Thing on Filebeam

[Arachnia]

this is Really nice, even though no one has Downloaded it, unless they made a new Thing on Filebeam
But i am Going to Make the SQL for Ascent 2.3.0
Wish me luck

Right on man! I look forward to seeing it.

[Illidan1]

lol nvm, i just Checked out the SQL, and it is little Different that i Remember
So yeah, lol and i am Work on my own Project right now, But this is Really nice

[Arachnia]

rofl, no worries it will get done eventually

[Viter]

This would be great for ascent

[Illidan1]

Indeed it Would Viter, i might get Gastric or Chrispee To Re SQL it

[Viter]

Indeed it Would Viter, i might get Gastric or Chrispee To Re SQL it

Sounds good

[jasperjag]

If anyone get the sql reformated please pass it along, we will post it with our updates and proper credit will be given.

We should be releasing some slight updates for this event in the next few days. At the moment we are finishing up a server upgrade and looking at adding some better AI to the mobs. There is a slight quest tweak in the works to fix a minor problem.

If you need something from us for the sql reformat let us know!