Skip to content

Instantly share code, notes, and snippets.

DELETE FROM creature_template WHERE entry = '90006';
INSERT INTO `creature_template` VALUES ('90006', '0', '0', '0', '0', '0', '42063', '42061', '0', '0', 'Teleporter', 'Locations', 'Directions', '55555', '90', '90', '4', '0', '35', '3', '1', '1.14286', '1', '1', '0', '0', '0', '0', '1', '0', '0', '1', '0', '2048', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '3', '1', '12', '0', '0', '0', '0', '0', '0', '', '0', '1', '0', '0', '', '1', '1', '1', '1', '0');
DELETE FROM creature_template_addon WHERE Entry = '90006' ;
INSERT INTO creature_template_addon (entry, mount, bytes1, bytes2, emote, path_id, auras) VALUES
('90006', 0, 0, 0, 0, 0, '35766');
DELETE FROM gossip_menu WHERE entry>'55555'-1 AND entry<'55555'+9;
DELETE FROM npc_text WHERE ID>'333333'-1 AND ID<'333333'+5;
INSERT INTO gossip_menu (entry, text_id) VALUES
('55555'+4, '333333'+3),
('55555'+3, '333333'+2),
@JadaDev
JadaDev / World_chat.cpp
Last active February 21, 2019 18:43
World Chat 3.3.5 TrinityCore
//Created by : parranoia
//Updated & Modified by : JadaDev
//This world_chat sciprt used for EmuCoreCraft Repack
//DO NOT REMOVE CREDITS
//Shared : 2016 / 07 / 27
#include "ScriptPCH.h"
#include "Chat.h"
@JadaDev
JadaDev / gist:c4fe18c9f94a14debe78
Created October 21, 2014 06:11
Made by Rochet2 Rewritten by mthsena updated by JadaDev
/*
** Made by Rochet2(Eluna)
** Rewritten by mthsena(C++)
*/
#include "ScriptPCH.h"
using namespace std;
#define DEFAULT_MESSAGE 907
@JadaDev
JadaDev / gist:e074941558109b14aa15
Created October 14, 2014 00:28
Honorable Kills Shop updated by JadaDev
class honorable_kills_shop : public CreatureScript
{
public:
honorable_kills_shop() : CreatureScript("hk_kills_shop") { }
bool OnGossipHello(Player* player, Creature* creature)
{
player->ADD_GOSSIP_ITEM(4, "[5,000 Lifetime Kills are required in order to view my goods. Make sure you have it, or you won't be able to view nor purchase anything.]", GOSSIP_SENDER_MAIN, 1001); //first menu option - a note for what this creature is
player->ADD_GOSSIP_ITEM(4, "[5k kills] Show me what you got!", GOSSIP_SENDER_MAIN, 1002); //second option, click to send to the vendor (if he has 5k kills)
player->SEND_GOSSIP_MENU(1, creature->GetGUID()); // This sends the menu to the player
@JadaDev
JadaDev / gist:77eb796d30971f7139e6
Created October 14, 2014 00:18
Tools NPC Updated by JadaDev created by SymbolixDev
/*
Made by: SymboliXDEV
Edited by: Rochet2
Work %: UnMiniTeleportered
Compile: Success
*/
#include "ScriptPCH.h"
static const uint32 buffIdstools[] = { 43223, 5862, 33377, 33779, 31305, 70692, 42995 };
@JadaDev
JadaDev / VIP Commands Script Created by Ghostcrawler
Last active August 29, 2015 14:07
VIP Commands Script Created by Ghostcrawler Updated by JadaDev
/*
Made by: Ghostcrawler
Updated by : JadaDev
Script Info : VIP Commands Script
Compile : Success.
Note : Contacted Ghostcrawler via skype - ac-web.org & he allowed me to post / update it.
*/
#include "ScriptMgr.h"
#include "ObjectMgr.h"
#include "MapManager.h"
@JadaDev
JadaDev / C++ Profession Script created by AddeDev
Created October 13, 2014 05:46
C++ Profession Script created by AddeDev updated by JadaDev
#include "ScriptPCH.h"
#include "Language.h"
class Professions_NPC : public CreatureScript
{
public:
Professions_NPC () : CreatureScript("Professions_NPC") {}
void CreatureWhisperBasedOnBool(const char *text, Creature *_creature, Player *pPlayer, bool value)
{