Skip to content

Instantly share code, notes, and snippets.

@saqirmdev
saqirmdev / spell_target_spells.sql
Created August 20, 2013 12:52
Spell_target_spells With fixed Harvest Soul last rev.
CREATE TABLE `spell_target_position` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Identifier',
`effindex` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`target_map` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`target_position_x` FLOAT NOT NULL DEFAULT '0',
`target_position_y` FLOAT NOT NULL DEFAULT '0',
`target_position_z` FLOAT NOT NULL DEFAULT '0',
`target_orientation` FLOAT NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
float SpellEffectInfo::CalcRadius(bool positive, Unit* caster, Spell* spell) const
{
uint32 oldMSTime = getMSTime();
float radius;
// 1 2
QueryResult result = WorldDatabase.Query("SELECT id, radius FROM spell_radius");
if (result)
do
{
// npc_flame_orb
enum FlameOrb
{
SPELL_FLAME_ORB_DAMAGE = 86719,
FLAME_ORB_DISTANCE = 120
};
class npc_flame_orb : public CreatureScript
{
public:
@saqirmdev
saqirmdev / gist:5233401
Last active December 15, 2015 08:49
Drain Life 4.3.4
DELETE FROM `spell_script_names` WHERE spell_id IN (689, 89420);
INSERT INTO `spell_script_names` VALUES (689, 'spell_warl_drain_life');
INSERT INTO `spell_script_names` VALUES (89420, 'spell_warl_drain_life');
&&spell_warlock.cpp
SPELL_WARLOCK_IMPROVED_HEALTH_FUNNEL_R2 = 18704,
SPELL_WARLOCK_LIFE_TAP_ENERGIZE = 31818,
@saqirmdev
saqirmdev / gist:4772221
Last active December 12, 2015 12:29
MMaps/Core - Blade edge arena pillars tempfix
@@PathGenerator.cpp && void PathGenerator::BuildPointPath(const float *startPoint, const float *endPoint)
if (Dist3DSqr(GetActualEndPosition(), GetEndPosition()) < 0.3f * Dist3DSqr(GetStartPosition(), GetEndPosition()))
{
SetActualEndPosition(GetEndPosition());
_pathPoints[_pathPoints.size()-1] = GetEndPosition();
}
else
{
SetActualEndPosition(GetEndPosition());
BuildShortcut();
@saqirmdev
saqirmdev / gist:4189665
Created December 2, 2012 16:35
Early Frost
@@ 1,0 && spell_script_names
-- Early Frost Spell_Script_Name.sql
INSERT INTO `spell_script_names` VALUES (116, 'spell_mage_frost_bolt');
@@ 49,1 && enum MageSpells spell_mage.cpp
SPELL_MAGE_CAUTERIZE_DOT = 87023,
SPELL_MAGE_GLYPH_OF_BLAST_WAVE = 62126,
Fix Cautarize Spell_mage.cpp
@40,58 && enum MageSpells
+ SPELL_MAGE_CAUTERIZE = 86949,
+ SPELL_MAGE_CAUTERIZE_DOT = 87023,
@78,1 && void();
+// Cauterize
@saqirmdev
saqirmdev / gist:3981930
Created October 30, 2012 18:06
By Saqirmdev. MoveMaps Fix Blade edge Arena && Dalaran Sewer Point
@486,13 &PathGenerator::BuildPointPath(const float *startPoint, const float *endPoint) PathGenerator.cpp
else
{
SetActualEndPosition(GetEndPosition());
BuildShortcut();
}
_type = PathType(PATHFIND_NORMAL | PATHFIND_NOT_USING_PATH);
}