Jump to content

WoW Source uses cookies. Read the Privacy Policy for more info. To remove this message, please click the button to the right:    I accept the use of cookies

Toggle shoutbox
General Chat Box
Open the Shoutbox in a popup

@  Kalimdor : (29 May 2018 - 08:10 PM) we are waiting the new patch of wow guys
@  Kalimdor : (30 March 2018 - 12:40 AM) hello
@  Rusas : (30 March 2018 - 12:08 AM) Hi )
@  Kalimdor : (19 March 2018 - 07:43 AM) Hey guys your all invited to our new private server of legion, patch 7.3.5 http://wowargus.com/ before start playing make sure you have an account and have the right client but for more info read this please http://wowargus.com/news/1 if you find bug inside your free to post them here http://wowargus.com/bugtracker and for pvp statistics here http://wowargus.com/pvp
@  Kalimdor : (14 March 2018 - 04:58 PM) Who needs me just use discord and add Ozeneu#7067 or skype geany_100
@  Kalimdor : (09 March 2018 - 05:28 PM) hi check your gm level and also check the command for level what gm rank required
@  gmacken : (07 March 2018 - 10:17 AM) silly question but a new to this, got server 4.3.4 and i have set admin account etc. It does not appear to recognise command for levelling up ?
@  Kalimdor : (11 February 2018 - 05:32 PM) look guys there is no team so i wontwork alone any more but if any of you wish to work with me and you have skills in c++ and sql, send me a reply or a PM
@  Kalimdor : (25 January 2018 - 07:47 AM) hey guys my youtube channel it is https://www.youtube....w_as=subscriber
@  remamakiller : (18 December 2017 - 01:40 PM) testear quest , agregar o buscar el phaseid que se necesita para que se puedan completar
@  remamakiller : (18 December 2017 - 01:38 PM) Me ofresco desinteresadamente , para arreglar quest de salida de personajes
Mas no se
@  Kalimdor : (06 December 2017 - 09:48 PM) guess what? the legion update is working well i have add lots of missing objects and mobs but this will work faster if i have a sniffer 7.2 and if i have people who work with me to this project because for 1 person is very hard
@  Kalimdor : (02 November 2017 - 04:20 PM) hi guys good news about legion it will be public source with updates we start work in legion patch 7.2.5 me and 2 friends the source will be public and updates, if any of you wish to join give me a PM or a reply, the address for download it is https://github.com/WoWSource
@  Kalimdor : (02 November 2017 - 01:02 PM) english please
@  samaelsacred : (01 November 2017 - 02:10 AM) alguien vende un source 4.3.4?
@  Kalimdor : (14 October 2017 - 02:17 PM) guys some time when register the activation is not instant coz i must accept or not the new members so this could take between 1 hour and a few days
@  Kalimdor : (20 September 2017 - 02:01 PM) por supuesto si 4.3.4 - 5.4.8
@  Dirkwein : (20 September 2017 - 05:33 AM) Kalimdor la 4.3.4 la siguieron actualizando para los vip?
@  Kalimdor : (12 September 2017 - 09:23 PM) 2 big updates was made today into 5.4.8 source check the github commits if your a vip
@  Kalimdor : (29 August 2017 - 07:57 PM) We have so far live 2 servers 2 patches like 4.3.4 and 5.4.8 you can visit and play in http://5.196.199.233/ and 5.4.8 http://pandemowow.com/ and we will start legion server in short time

Photo

Crazy Doctor 4.3.4 Sql


  • Please log in to reply
11 replies to this topic

#1 Kalimdor

Kalimdor

    The First

  • Administrators
  • 3,945 posts
  • 1610 thanks
  • LocationNorth Pole
  • Time Online: 48D 11H 30M 25S

User's Awards

                                

Posted 29 October 2012 - 07:55 AM

Thanks to Germo , credit goes to him 100% , he share with us hes Npc buffer , healer , resurection sickness remove etc
was made for trinity 4.3.4
  • 1

facebook-icon.png  YouTube-icon.png

 

 

 


#2 Guest_Germo_*

Guest_Germo_*
  • Guests
  • thanks

Posted 06 November 2012 - 03:00 PM

First i will say thanks and give credits to mthsena who started this nice litlle npc.

The Crazy doctor posted above i have modyfied it, and changed some stuff in it, put in some new spells etc etc. here it is...!
OOh. He also have Repair / Vendor buy options now :-)


/*
- Made by mthsena -
*/
-- creature_template
REPLACE 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`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES('200000','0','0','0','0','0','16063','0','0','0','Crazy Doctor','- Buffer Service -','Speak','65000','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','0','','1');
-- gossip_menu
REPLACE INTO `gossip_menu` (`entry`, `text_id`) VALUES('65000','14128');
-- gossip_menu_option
REPLACE 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('65000','5','4','- Close window.','1','1','0','0','0','0',NULL);
REPLACE 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('65000','4','0','- Repair & Trade Goods','3','4225','0','0','0','0',NULL);
REPLACE 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('65000','3','0','- Die','1','1','0','0','0','0','Are you sure want this?');
REPLACE 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('65000','2','0','- Remove Sickness','1','1','0','0','0','0','Are you sure want this?');
REPLACE 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('65000','1','0','- Heal','1','1','0','0','0','0','Are you sure want this?');
REPLACE 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('65000','0','0','- Buffs','1','1','0','0','0','0','Are you sure want this?');
-- smart_scripts
REPLACE 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('200000','0','0','0','62','0','100','0','65000','0','0','0','75','71200','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','1','0','62','0','100','0','65000','0','0','0','75','16609','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','2','0','62','0','100','0','65000','0','0','0','75','43939','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','3','0','62','0','100','0','65000','0','0','0','75','15366','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','4','0','62','0','100','0','65000','0','0','0','75','43223','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','5','0','62','0','100','0','65000','0','0','0','75','36880','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','6','0','62','0','100','0','65000','0','0','0','75','33081','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','7','0','62','0','100','0','65000','0','0','0','75','24705','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','8','0','62','0','100','0','65000','0','0','0','75','26035','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','9','0','62','0','100','0','65000','0','0','0','75','79060','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','10','0','62','0','100','0','65000','0','0','0','75','57399','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','11','0','62','0','100','0','65000','0','0','0','75','16612','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','12','0','62','0','100','0','65000','0','0','0','75','17013','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','13','0','62','0','100','0','65000','0','0','0','75','70235','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','14','0','62','0','100','0','65000','0','0','0','75','70234','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','15','0','62','0','100','0','65000','0','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','16','0','62','0','100','0','65000','1','0','0','11','69693','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','17','0','62','0','100','0','65000','1','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','18','0','62','0','100','0','65000','2','0','0','28','15007','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','19','0','62','0','100','0','65000','2','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','20','0','62','0','100','0','65000','3','0','0','51','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','21','0','62','0','100','0','65000','3','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','22','0','62','0','100','0','65000','5','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
-- npc_vendor
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','44719','0','0','2');
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','44606','0','0','2');
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','20769','0','0','2');
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','10684','0','0','2');

  • 0

#3 Adde

Adde

    Sql_Developer

  • Members
  • 35 posts
  • 0 thanks
  • :

Posted 21 December 2012 - 07:30 PM

what is the npc entry id?
  • 0

#4 Guest_Germo_*

Guest_Germo_*
  • Guests
  • thanks

Posted 29 December 2012 - 11:25 PM

what is the npc entry id?



200000
  • 0

Thanked by 1 Member:

#5 Spaceace

Spaceace

    Member

  • Members
  • 14 posts
  • 0 thanks
  • Time Online: 2D 11H 34M 33S

Posted 29 April 2014 - 12:00 PM

where is the sql file. cant find it


  • 0

#6 jade

jade

    Veteran

  • Members
  • 329 posts
  • 54 thanks
  • Time Online: 19D 13H 37M 38S

User's Awards

           

Posted 29 April 2014 - 12:16 PM

Copy the code into a txt file and rename doctor.sql

 

/*
- Made by mthsena -
*/
-- creature_template
REPLACE 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`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES('200000','0','0','0','0','0','16063','0','0','0','Crazy Doctor','- Buffer Service -','Speak','65000','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','0','','1');
-- gossip_menu
REPLACE INTO `gossip_menu` (`entry`, `text_id`) VALUES('65000','14128');
-- gossip_menu_option
REPLACE 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('65000','5','4','- Close window.','1','1','0','0','0','0',NULL);
REPLACE 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('65000','4','0','- Repair & Trade Goods','3','4225','0','0','0','0',NULL);
REPLACE 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('65000','3','0','- Die','1','1','0','0','0','0','Are you sure want this?');
REPLACE 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('65000','2','0','- Remove Sickness','1','1','0','0','0','0','Are you sure want this?');
REPLACE 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('65000','1','0','- Heal','1','1','0','0','0','0','Are you sure want this?');
REPLACE 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('65000','0','0','- Buffs','1','1','0','0','0','0','Are you sure want this?');
-- smart_scripts
REPLACE 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('200000','0','0','0','62','0','100','0','65000','0','0','0','75','71200','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','1','0','62','0','100','0','65000','0','0','0','75','16609','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','2','0','62','0','100','0','65000','0','0','0','75','43939','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','3','0','62','0','100','0','65000','0','0','0','75','15366','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','4','0','62','0','100','0','65000','0','0','0','75','43223','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','5','0','62','0','100','0','65000','0','0','0','75','36880','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','6','0','62','0','100','0','65000','0','0','0','75','33081','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','7','0','62','0','100','0','65000','0','0','0','75','24705','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','8','0','62','0','100','0','65000','0','0','0','75','26035','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','9','0','62','0','100','0','65000','0','0','0','75','79060','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','10','0','62','0','100','0','65000','0','0','0','75','57399','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','11','0','62','0','100','0','65000','0','0','0','75','16612','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','12','0','62','0','100','0','65000','0','0','0','75','17013','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','13','0','62','0','100','0','65000','0','0','0','75','70235','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','14','0','62','0','100','0','65000','0','0','0','75','70234','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','15','0','62','0','100','0','65000','0','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','16','0','62','0','100','0','65000','1','0','0','11','69693','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','17','0','62','0','100','0','65000','1','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','18','0','62','0','100','0','65000','2','0','0','28','15007','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','19','0','62','0','100','0','65000','2','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','20','0','62','0','100','0','65000','3','0','0','51','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','21','0','62','0','100','0','65000','3','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
REPLACE 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('200000','0','22','0','62','0','100','0','65000','5','0','0','72','0','0','0','0','0','0','0','0','0','0','0','0','0','0','Crazy Doctor Script');
-- npc_vendor
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','44719','0','0','2');
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','44606','0','0','2');
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','20769','0','0','2');
REPLACE INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES('200000','0','10684','0','0','2');

  • 0

#7 Spaceace

Spaceace

    Member

  • Members
  • 14 posts
  • 0 thanks
  • Time Online: 2D 11H 34M 33S

Posted 29 April 2014 - 01:05 PM

what is the .npc add id of the creature


  • 0

#8 jade

jade

    Veteran

  • Members
  • 329 posts
  • 54 thanks
  • Time Online: 19D 13H 37M 38S

User's Awards

           

Posted 29 April 2014 - 01:29 PM

.npc add 200000


  • 0

#9 Spaceace

Spaceace

    Member

  • Members
  • 14 posts
  • 0 thanks
  • Time Online: 2D 11H 34M 33S

Posted 29 April 2014 - 04:18 PM

ty


  • 0

#10 Spaceace

Spaceace

    Member

  • Members
  • 14 posts
  • 0 thanks
  • Time Online: 2D 11H 34M 33S

Posted 29 April 2014 - 04:40 PM

works perfect, and i like the doktor, only 1 thing, those trainset and others, are free, i would like them to pay 8g, each for it.

 

ty


  • 0

#11 Spaceace

Spaceace

    Member

  • Members
  • 14 posts
  • 0 thanks
  • Time Online: 2D 11H 34M 33S

Posted 29 April 2014 - 04:59 PM

lol lvl 12 gets me 2019 hp, good for me me make a extreme wow server blizz 1x, custom,

 

and also the hogger bug. epic npc. so maby 5players got now a change fully buffed ;-)


  • 0

#12 Spaceace

Spaceace

    Member

  • Members
  • 14 posts
  • 0 thanks
  • Time Online: 2D 11H 34M 33S

Posted 30 April 2014 - 07:16 AM

when i teleport to westfall i drop out of the world.  i dont die but its buggie


  • 0