Skip to content

Instantly share code, notes, and snippets.

View Jildor's full-sized avatar

Gildor Jildor

30 followers · 30 following
View GitHub Profile
@Jildor
Jildor / crash_reward_quest_5675.log
Created December 7, 2016 09:56
[New Thread 0x7493bfbea700 (LWP 33768)]
[New Thread 0x7493bf3d9700 (LWP 33769)]
[New Thread 0x7493beb3f700 (LWP 33770)]
[New Thread 0x7493be2a4700 (LWP 33771)]
[New Thread 0x7493bda02700 (LWP 33772)]
[New Thread 0x7493bd161700 (LWP 33773)]
[New Thread 0x74936f7d9700 (LWP 33815)]
[New Thread 0x74936ef2c700 (LWP 33816)]
[New Thread 0x74936e671700 (LWP 33817)]
@Jildor
Jildor / npc_air_force_bots_entrys.sql
Created October 31, 2016 13:38
-- entry NPCs npc_air_force_bots
2614
2615
21974
21993
21996
21997
21999
22001
22002
@Jildor
Jildor / Testeo Arenas con fix
Created May 5, 2016 09:58
Testeo Arenas con fix
Testeo con Fix
Equipo1: 1000 Rating Personal y de Equipo
Equipo2: 0 Rating Personal y de Equipo
Equipo2 gana Equipo1
Equipo1: 969 Rating Personal y de Equipo
Equipo2: 31 Rating Personal y de Equipo
@Jildor
Jildor / Testeo Arenas sin fix
Created May 5, 2016 09:58
Testeo Arenas sin fix
Testeo sin fix
Equipo1: 1000 Rating Personal y de Equipo
Equipo2: 0 Rating Personal y de Equipo
Equipo2 gana Equipo1
Equipo1: 999 Rating de Equipo, 969 Rating Personal
Equipo2: 31 Rating Personal y de Equipo
@Jildor
Jildor / loot mineria cata ejemplo
Created June 28, 2015 18:16
loot mineria cata ejemplo
-- Corregido loot de los Depósitos de Minería de Cataclysm
SET @OBSIDIUM := 202736;
SET @OBSIDIUM_RICO := 202739;
SET @ELEMENTIUM := 202738;
SET @ELEMENTIUM_RICO := 202741;
SET @PIRITA := 202737;
SET @PIRITA_RICA := 202740;
SET @OBSIDIUM_LOOT := 28490;
@Jildor
Jildor / gist:0fd2ce5ce262ff7c0ba1
Created June 27, 2015 12:41
export query rince
INSERT INTO `quest_template` (`Id`, `Method`, `Level`, `MinLevel`, `MaxLevel`, `ZoneOrSort`, `Type`, `SuggestedPlayers`, `LimitTime`, `RequiredClasses`, `RequiredRaces`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestIdChain`, `RewardXPId`, `RewardOrRequiredMoney`, `RewardMoneyMaxLevel`, `RewardSpell`, `RewardSpellCast`, `RewardHonor`, `RewardHonorMultiplier`, `RewardMailTemplateId`, `RewardMailDelay`, `SourceItemId`, `SourceItemCount`, `SourceSpellId`, `Flags`, `SpecialFlags`, `MinimapTargetMark`, `RewardTitleId`, `RequiredPlayerKills`, `RewardTalents`, `RewardArenaPoints`, `RewardSkillId`, `RewardSkillPoints`, `RewardReputationMask`, `QuestGiverPortrait`, `QuestTurnInPortrait`, `RewardItemId1`, `RewardItemId2`, `RewardItemId3`, `RewardItemId4`, `RewardItemCount1`, `Rew
@Jildor
Jildor / gist:daa577801314e88a2133
Created May 15, 2015 12:33
delay list
/* ----------------Spell Delay-------------------- */
// Rogue
1833: // Cheap Shot
408: // Kidney Shot
1776: // Gouge
2094: // Blind
31224: // Cloak of Shadows
6770: // Sap
/* ------------------------------------ */
// Warrior
@Jildor
Jildor / resistencias_binarias.patch
Created July 26, 2012 15:21 — forked from eilo/resistencias_binarias.patch
Resistencias binarias ingresado el 14 de marzo (Emulador de 24 diciembre)
From efc5c8e926a33b1b761bd8707a0059b728bb318f Mon Sep 17 00:00:00 2001
From: Eilo <[email protected]>
Date: Wed, 14 Mar 2012 13:04:14 -0500
Subject: [PATCH 17/27] 0.17 Resistencias Binarias
---
src/server/game/Entities/GameObject/GameObject.cpp | 2 +
src/server/game/Entities/Player/Player.cpp | 6 +-
src/server/game/Entities/Player/Player.h | 3 +-
src/server/game/Entities/Unit/StatSystem.cpp | 6 +
@Jildor
Jildor / gist:1858908
Created February 18, 2012 11:30
Arena rating system old
--- a/src/server/game/Battlegrounds/ArenaTeam.cpp
+++ b/src/server/game/Battlegrounds/ArenaTeam.cpp
@@ -575,29 +599,25 @@
uint32 ArenaTeam::GetAverageMMR(Group* group) const
{
if (!group)
return 0;
uint32 matchMakerRating = 0;
@Jildor
Jildor / gist:1858640
Created February 18, 2012 10:27
Fix Pick Lock
// skill bonus provided by casting spell (mostly item spells)
// add the damage modifier from the spell casted (cheat lock / skeleton key etc.)
- if (m_spellInfo->Effects[effIndex].TargetA.GetTarget() == TARGET_GAMEOBJECT_ITEM_TARGET || m_spellInfo->Effects[effIndex].TargetB.GetTarget() == TARGET_GAMEOBJECT_ITEM_TARGET)
- skillValue += uint32(CalculateDamage(effIndex, NULL));
+ if (m_spellInfo->Id != 1804)
+ if (m_spellInfo->Effects[effIndex].TargetA.GetTarget() == TARGET_GAMEOBJECT_ITEM_TARGET || m_spellInfo->Effects[effIndex].TargetB.GetTarget() == TARGET_GAMEOBJECT_ITEM_TARGET)
+ skillValue += uint32(CalculateDamage(effIndex, NULL));
if (skillValue < reqSkillValue)
return SPELL_FAILED_LOW_CASTLEVEL;