ArcEmu Core (rev 2196) + 3.0.9 DBC

Hi all :)

Here is my release of the current arcemu core and 3.0.9 dbc files

Hope it will help you guys (this is only the core and DBC nothing else)

PS: 3.0.9 patch compatible : >>> set your logon config data to :

Code:

---

MaxBuild = "9551">

---

<<<

Have fun!!! :D

ArcEmu Core (rev 2196) <<--- OLD
ArcEmu Core (rev 2203) <<--- OLD
*make sure you execute the 2199_gosandquests.sql file on your world database ;) (you can find it in the world_updates folder in my release)

Arcemu Core (rev 2204) <<--- OLD
+ Optional in-game unstuck and revive, with a variable cooldown rate was added to the ExtraScripts module. Enable via the optional config file.

Arcemu Core (rev 2206) <<--- OLD
* Bug fix: Once a return value is set false, it must remain false. The prior code allowed the return value to be set back to true. * Bug fix: OnLogoutRequest can now halt the logout request * Bug fix: OnChat can now block chat messages * Bug fix: OnCastSpell, no longer displays bad error message * Removed a useless check from ScriptMgr HookInterface events * Removed the use of defines in these HookIntereface events, you can actually tell what's going on now. :)

Arcemu Core (rev 2208) <<--- OLD
*(Optional) Damage Cap settings <<--- Don't forget to change your config files two ;)

Arcemu 2222 Core <<--- OLD
*Added ".character learn all" update for level 80 by Robbis - thanks alot mate :)
*Fixed Dancing Rune Weapon
*Fixed Raise Dead
*Fixed Army of the Dead
*Fixed Feral Spirit
*Fixed Death Grip And some other things

ArcEmu 2226 Core <<---OLD
*pets should work now as usual

ArcEmu 2238 Core <<---OLD
*** ADD THE NEW WORLD UPDATE ***


ArcEmu 2278 Core <<--- OLD

*** ADD THE NEW WORLD UPDATE ***
- Shaman spells Bloodlust and Heroism target raid members,
not only party members.
- Send gender in guild roster, thx Hardbass (HS)
- Crash fix that occur with CalcResistance.
- Arcane Shot fix
- Added fix for blood pact
-- Added a new class called ObjectContainer, inherits from Object. This class acts as a single object, but actually consists of multiple child-objects that all orient around the location of the the container object's (x, y) position. The z position, for child-objects, is calculated by using use the roll and pitch of the container object, and the distance from the container object's (x,y). A change in parent object orientation needs to rotate each child-object (along its y axis) by a value equal to the revolution (around parent-container) radians. The container object can also set a single "primary" object. One application for this class would be vehicles. Another would be for NPC's on transports. This code is under development, and is not fully implemented yet. --
- Mind Sear rank 2 will now deal damage to the target
(not completely correct behavior but at least it's doing some damage, like rank 1)
- Mind Flay should mostly work:
* Rank 7 will cast the slow effect on the target and on the caster
(it's channel so it shouldn't hurt the caster, but it still shouldn't go there)
* Rank 1 doesn't cast slow effect on target
* All ranks deal damage, but don't show the damage dealt.
This still needs more work, this is only a start...
- crashfix - expiring pets have no PlayerPet struct
- Alterac Valley (enabled? / Test? / incomplete)
* implemented AURASTATE_FLAG_HEALTH75 (hp above 75%)
* implemented AURASTATE_FLAG_ENRAGED
* removed aurastate switch from spellfixes (warnings not needed)
* aurastate enum in hex format (only for better visualisation and simpler understanding)
* implemented MECHANIC_ENRAGED
* implement AURA_INTERRUPT_ON_LEAVE_AREA
* delete fake pets
* implemented SMSG_PET_ACTION_FEEDBACK
* hunter pets get automatically Growl on creation
* implemented AURA_INTERRUPT_ON_PVP_ENTER
* Auto-Equip 2h weapon without titan's grip should correctly swap current weapon with new weapon.
* removed obsolete Unit::set<uint32> m_SpellList
* mplemented spell effect 65 - used existing Spell::SpellEffectApplyAA()
* deletion of totem/guardian tweaks (mem. leaks)
* UI is now sent the correct information about arena charter costs as defined in Guild.h
* Titan's Grip should work correctly for Auto-Equip (right-click item) opcode. (only 2h axe sword or mace are counted as 1h, allows shield to be worn also).


ARCEMU 2294 <<<--- NEW


runiker Asked me to upload all the SQL updates in a different rar (only the sql files) so here they are:

Arcemu latest SQL updates <<--- Added on 02/14/2009
ArcEmu latest SQL updates <<--- Added on 02/20/2009 (so far latest)


I will try to update this post every day :)



PS: Moderator(s)/Admin(s) pls rename this thread to "Arcemu Lates Core Compiles [Daily Updates]"



Credits:

* Arcemu for the fantastic core :)
* Me (time to compile + upload + editing/posting the new data)

hehe really nice ! :) u Compiled before me ! :D +rep ! :)

thx m8 :)

Quote:

---

ArcEmu Core (rev 2196) <<--- OLD
ArcEmu Core (rev 2203) <<--- NEW

*make sure you execute the 2199_gosandquests.sql file on your world database ;) (you can find it in the world_updates folder in my release)

I will try to update this post every day :)

---

Updated to the new 2203 Arcemu core + Sql update (<<<--- Don't forget to apply)


Regards
BloodLord

Thanks and hey can you possible to post the updated format of sql (just the sqls nothing else) i ask this because i am trying to make a nice website that works upto-date with current arcemu db layout (might expand to mangos next)

Quote:

---

Originally Posted by runiker

Thanks and hey can you possible to post the updated format of sql (just the sqls nothing else) i ask this because i am trying to make a nice website that works upto-date with current arcemu db layout (might expand to mangos next)

---

Here is the 2199_gosandquests.sql source

Code:

---

alter table `gameobject_names` add column `Name2` varchar(100) DEFAULT '' NOT NULL after `Name`;
alter table `gameobject_names` add column `Name3` varchar(100) DEFAULT '' NOT NULL after `Name2`;
alter table `gameobject_names` add column `Name4` varchar(100) DEFAULT '' NOT NULL after `Name3`;
alter table `gameobject_names` add column `Category` varchar(100) DEFAULT '' NOT NULL after `Name4`;
alter table `gameobject_names` add column `CastBarText` varchar(100) DEFAULT '' NOT NULL after `Category`;
alter table `gameobject_names` add column `UnkStr` varchar(100) DEFAULT '' NOT NULL after `CastBarText`;

alter table `quests` add column `detailemotecount` int UNSIGNED DEFAULT '0' NOT NULL after `suggestedplayers`;
alter table `quests` add column `detailemote1` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotecount`;
alter table `quests` add column `detailemote2` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote1`;
alter table `quests` add column `detailemote3` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote2`;
alter table `quests` add column `detailemote4` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote3`;
alter table `quests` add column `detailemotedelay1` int UNSIGNED DEFAULT '0' NOT NULL after `detailemote4`;
alter table `quests` add column `detailemotedelay2` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay1`;
alter table `quests` add column `detailemotedelay3` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay2`;
alter table `quests` add column `detailemotedelay4` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay3`;
alter table `quests` add column `completionemotecnt` int UNSIGNED DEFAULT '0' NOT NULL after `detailemotedelay4`;
alter table `quests` add column `completionemote1` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotecnt`;
alter table `quests` add column `completionemote2` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote1`;
alter table `quests` add column `completionemote3` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote2`;
alter table `quests` add column `completionemote4` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote3`;
alter table `quests` add column `completionemotedelay1` int UNSIGNED DEFAULT '0' NOT NULL after `completionemote4`;
alter table `quests` add column `completionemotedelay2` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay1`;
alter table `quests` add column `completionemotedelay3` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay2`;
alter table `quests` add column `completionemotedelay4` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay3`;
alter table `quests` add column `completeemote` int UNSIGNED DEFAULT '0' NOT NULL after `completionemotedelay4`;
alter table `quests` add column `incompleteemote` int UNSIGNED DEFAULT '0' NOT NULL after `completeemote`;

CREATE TABLE `vendor_restrictions` (
 `entry` int(10) unsigned NOT NULL,
 `racemask` int(11) NOT NULL default '-1',
 `reqrepfaction` int(10) unsigned NOT NULL default '0',
 `reqrepfactionvalue` int(10) unsigned NOT NULL default '0',
 `canbuyattextid` int(10) unsigned NOT NULL default '0',
 `cannotbuyattextid` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `itemnames` (
 `entry` int(10) unsigned NOT NULL default '0',
 `name` varchar(100) NOT NULL default '',
 `slotid` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

Hehe thanks what i meant was from not on just posting a download to the sql and keep updating that as well. But this works too :P

Quote:

---

Originally Posted by runiker

Hehe thanks what i meant was from not on just posting a download to the sql and keep updating that as well. But this works too :P

---

Here they are:

Arcemu latest SQL updates <<--- Added on 02/14/2009


Edited 1st post two ;)

oh well if u keep updateing ArcEmu now i wont be needing anymore :S well so u know i started first so i call it like stealing man..

Quote:

---

Originally Posted by Hyldran0

oh well if u keep updateing ArcEmu now i wont be needing anymore :S well so u know i started first so i call it like stealing man..

---

Sry :/

I saw that you have an older rev so I relesed the new one

Sry again m8