• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[Trinity SQL] Crazy Doctor

Synth

Synth

Exalted Member
Hello Emudevs,today i'm going to share a "Crazy Doctor" made by Mthsena.

SQL Info:
●Buffs - Custom Buffs
●Heal - Full heal.
●Remove Sickness - Remove the resurrection sickness.
●Die - Madness!, it kills you.
●Repair & Trade Goods - Vendor- Repair option, you can add what you want.

SQL:
Crazy Doctor - SQL - Mthsena.info​

If you find any error once running query's or another errors feel free to ask me!

Thank you!
Best regards,
Synth !
 
F

freza

Emulation Addict
Code: 
SET @Name := 'Crazy Doctor';
SET @Subname := '';

SET @ID :='200000'; 
SET @Gossip := '21224';
SET @modelid := '16063';

     
-- creature_template
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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
(@ID,'0','0','0','0','0',@modelid,'0','0','0',@Name,@Subname,'Speak',@Gossip,'80','80','0','35','35','4225','1','1.14286','1.4','3','0','0','0','0','1','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','4','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','1','1','1','0','0','0','0','0','0','0','0','1','0','0','','1');
 
 
 -- gossip_menu
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES(@Gossip,'14128');


	-- gossip_menu_option
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
(@Gossip,'0','0','Buffs','1','1','0','0','0','0',NULL),
(@Gossip,'1','0','Heal','1','1','0','0','0','0',NULL),
(@Gossip,'2','0','Remove Sickness','1','1','0','0','0','0',NULL),
(@Gossip,'3','0','Die','1','1','0','0','0','0',NULL),
(@Gossip,'4','0','Repair & Trade Goods','3','4225','0','0','0','0',NULL),
(@Gossip,'5','4','Close Window.','1','1','0','0','0','0',NULL);

	
	-- smart_scripts
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@ID,'0','0','0','62','0','100','0',@Gossip,'0','0','0','75','15366','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','1','0','62','0','100','0',@Gossip,'0','0','0','75','16609','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','2','0','62','0','100','0',@Gossip,'0','0','0','75','48162','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','3','0','62','0','100','0',@Gossip,'0','0','0','75','48074','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','4','0','62','0','100','0',@Gossip,'0','0','0','75','43223','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','5','0','62','0','100','0',@Gossip,'0','0','0','75','36880','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','6','0','62','0','100','0',@Gossip,'0','0','0','75','33081','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','7','0','62','0','100','0',@Gossip,'0','0','0','75','24705','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','8','0','62','0','100','0',@Gossip,'0','0','0','75','26035','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','9','0','62','0','100','0',@Gossip,'0','0','0','75','48469','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','10','0','62','0','100','0',@Gossip,'0','0','0','75','57399','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','11','0','62','0','100','0',@Gossip,'0','0','0','75','16612','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','12','0','62','0','100','0',@Gossip,'0','0','0','75','17013','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','13','0','62','0','100','0',@Gossip,'0','0','0','75','70235','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','14','0','62','0','100','0',@Gossip,'0','0','0','75','70234','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','15','0','62','0','100','0',@Gossip,'0','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script'),
(@ID,'0','16','0','62','0','100','0',@Gossip,'1','0','0','11','69693','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script- Heal'),
(@ID,'0','17','0','62','0','100','0',@Gossip,'1','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script- Heal'),
(@ID,'0','18','0','62','0','100','0',@Gossip,'2','0','0','28','15007','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script- Remove Sickness'),
(@ID,'0','19','0','62','0','100','0',@Gossip,'2','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script - Remove Sickness'),
(@ID,'0','20','0','62','0','100','0',@Gossip,'3','0','0','51','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script - Die'),
(@ID,'0','21','0','62','0','100','0',@Gossip,'3','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script - Die'),
(@ID,'0','22','0','62','0','100','0',@Gossip,'5','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script - Close Window');


-- npc_vendor
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(@ID,'0','44719','0','0','2'),
(@ID,'0','44606','0','0','2'),
(@ID,'0','20769','0','0','2'),
(@ID,'0','10684','0','0','2');

NOT FOUND! =[
 
You must log in or register to reply here.
Top