Skip to content

Instantly share code, notes, and snippets.

-- Item Id: 14388
-- Item Name: [Exquisite Frostseer Pants]
-- Note: Cloth - 10% EXP
DELETE FROM `item_template` WHERE `entry`=14388;
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `h
local ZONE_QUEL_THALAS = 2037
local PLAYER_EVENT_ON_UPDATE_ZONE = 27
local PLAYER_EVENT_ON_PACKET_SEND = 5
local PACKET_CMSG_REPOP_REQUEST = 0x15A
local SPELL_SAFE_FALL = 24350
local function OnPlayerUpdateZone(event, player, newZone, newArea)
using Microsoft.Extensions.Options;
using OceanicWar.Configuration;
using System.Text;
using System.Xml;
namespace OceanicWar.Services.Soap
{
public class SoapClient
@AnchyDev
AnchyDev / WorldBosses.cpp
Created February 7, 2024 03:35
Buffs a melee creature when there is 10 or more players nearby.
#include "WorldBosses.h"
#include <GridNotifiers.h>
CreatureAI* WorldBossesScript::GetAI(Creature* creature) const
{
return new WorldBossesAIScript(creature);
}
void WorldBossesScript::WorldBossesAIScript::UpdateAI(uint32 diff)
{

Hello World

This is a test header

  • Test Item
  • Test Item
Thread 7 "worldserver" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7f8dce9ff700 (LWP 1471)]
0x00000000012ba52c in Acore::Assert (file=..., line=<optimized out>, line@entry=339, function=..., debugInfo="", message="IsInGrid()", fmtMessage="") at /home/anchydev/azerothcore-wotlk/src/common/Debugging/Errors.cpp:112
112 Crash(formattedMessage.c_str());
#0 0x00000000012ba52c in Acore::Assert (file=..., line=<optimized out>, line@entry=339, function=..., debugInfo="", message="IsInGrid()", fmtMessage="") at /home/anchydev/azerothcore-wotlk/src/common/Debugging/Errors.cpp:112
#1 0x0000000000eb7b46 in GridObject<Player>::RemoveFromGrid (this=this@entry=0x7f8cf0c47030) at /home/anchydev/azerothcore-wotlk/src/server/game/Entities/Object/Object.h:339
#2 0x0000000000eab353 in Map::PlayerRelocation (this=0x7f8dfb3fb580, player=0x7f8cf0c44780, x=-9702.8457, y=-2715.15405, z=65.4960022, o=2.1746943) at /home/anchydev/azerothcore-wotlk/src/server/game/Maps/Map.cpp:1010
#3 0x0000000000cef8dc in
@AnchyDev
AnchyDev / Oceanic Trader.sql
Created February 8, 2023 05:48
Oceanic Trader Example
-- Oceanic Trader
SET @OCEANTRADER_ENTRY:=441101;
SET @OCEANTRADER_NAME:='Oceanic Trader';
SET @OCEANTRADER_DISPLAYID:=1985; -- Guard
DELETE FROM `creature_template` WHERE (`entry` = @OCEANTRADER_ENTRY);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifi
-- *0 [4]Gorilla --
Enchant_00: [103]Gorilla's.
Enchant_01: [98]Raw.
- Drops item [2050]Animal Flesh with 100% drop rate.
-- Enchant_00: [103]Gorilla's with 100% enchant rate.
-- Enchant_01: [98]Raw with 100% enchant rate.
--------------------------