API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 4th, 2010
2,912
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 56.84 KB | None | 0 0
raw download clone embed print report
  1. # HeidiSQL Dump
  2. #
  3. # --------------------------------------------------------
  4. # Host:                         127.0.0.1
  5. # Database:                     world
  6. # Server version:               5.1.36-community-log
  7. # Server OS:                    Win32
  8. # Target compatibility:         ANSI SQL
  9. # HeidiSQL version:             4.0
  10. # Date/time:                    2010-04-05 00:40:06
  11. # --------------------------------------------------------
  12.  
  13. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/
  15.  
  16.  
  17. #
  18. # Database structure for database 'world'
  19. #
  20.  
  21. CREATE DATABASE /*!32312 IF NOT EXISTS*/ "world" /*!40100 DEFAULT CHARACTER SET latin1 */;
  22.  
  23. USE "world";
  24.  
  25.  
  26. #
  27. # Table structure for table 'creature_names'
  28. #
  29.  
  30. CREATE TABLE /*!32312 IF NOT EXISTS*/ "creature_names" (
  31.   "entry" int(10) unsigned NOT NULL DEFAULT '0',
  32.   "name" varchar(100) NOT NULL,
  33.   "subname" varchar(100) NOT NULL,
  34.   "info_str" varchar(500) NOT NULL,
  35.   "flags1" int(10) unsigned NOT NULL DEFAULT '0',
  36.   "type" int(10) unsigned NOT NULL DEFAULT '0',
  37.   "family" int(10) unsigned NOT NULL DEFAULT '0',
  38.   "rank" int(10) unsigned NOT NULL DEFAULT '0',
  39.   "killcredit1" int(10) unsigned NOT NULL DEFAULT '0',
  40.   "killcredit2" int(10) unsigned NOT NULL DEFAULT '0',
  41.   "male_displayid" int(30) unsigned NOT NULL DEFAULT '0',
  42.   "female_displayid" int(30) unsigned NOT NULL DEFAULT '0',
  43.   "male_displayid2" int(30) unsigned NOT NULL DEFAULT '0',
  44.   "female_displayid2" int(30) unsigned NOT NULL DEFAULT '0',
  45.   "unknown_float1" float NOT NULL DEFAULT '1',
  46.   "unknown_float2" float NOT NULL DEFAULT '1',
  47.   "leader" tinyint(3) unsigned NOT NULL DEFAULT '0',
  48.   "questitem1" int(11) unsigned NOT NULL DEFAULT '0',
  49.   "questitem2" int(11) unsigned NOT NULL DEFAULT '0',
  50.   "questitem3" int(11) unsigned NOT NULL DEFAULT '0',
  51.   "questitem4" int(11) unsigned NOT NULL DEFAULT '0',
  52.   "questitem5" int(11) unsigned NOT NULL DEFAULT '0',
  53.   "questitem6" int(11) unsigned NOT NULL DEFAULT '0',
  54.   "waypointid" int(10) unsigned NOT NULL DEFAULT '0',
  55.   PRIMARY KEY ("entry")
  56. ) COMMENT='Creature System';
  57.  
  58.  
  59.  
  60. #
  61. # Dumping data for table 'creature_names'
  62. #
  63.  
  64. LOCK TABLES "creature_names" WRITE;
  65. /*!40000 ALTER TABLE "creature_names" DISABLE KEYS;*/
  66. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  67.     ('31021151','Terenas Menethil','','','108','7','0','3','0','0','31021','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  68. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  69.     ('26529762','Tirion Fordring','Supreme Commander of the Argent Crusade','','108','7','0','3','0','0','31011','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  70. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  71.     ('25452151','Val''kyr Shadowguard','','','0','0','0','1','0','0','25452','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  72. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  73.     ('5078151','Vile Spirit','','','0','0','0','0','0','0','10701','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  74. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  75.     ('3769813','Raging Spirit','','','0','0','0','1','0','0','21300','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  76. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  77.     ('3769812','Ice Shard','','','0','0','0','1','0','0','30243','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  78. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  79.     ('3769811','Shambling Horror','','','0','0','0','1','0','0','25297','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  80. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  81.     ('3769511','Drudge Ghoul','','','0','0','0','1','0','0','25001','25000','0','0','1','1',0,'0','0','0','0','0','0','0');
  82. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  83.     ('3072111','The Lich King','','','108','0','0','3','0','0','30721','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  84. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  85.     ('3072110','Trigger','','','0','0','0','0','0','0','4','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  86. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  87.     ('2626262','Quake','','','0','0','0','0','0','0','11686','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  88. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  89.     ('100001','b','','','0','4','0','3','0','0','15880','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  90. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  91.     ('100000','Venom Spider','','','0','1','3','0','0','0','958','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  92. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  93.     ('25315','Kil''Jaeden','The Deceiver','','0','10','0','3','0','0','23200','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  94. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  95.     ('26046','Anveena','','','0','10','0','3','0','0','23503','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  96. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  97.     ('25319','Kalecgos','The Blue Dragonflight','','0','10','0','3','0','0','23345','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  98. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  99.     ('100002','a','','','0','4','0','3','0','0','15880','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  100. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  101.     ('100006','Hand of the Deceiver','','','0','10','0','1','0','0','19294','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  102. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  103.     ('100007','Hand of the Deceiver','','','0','10','0','1','0','0','19294','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  104. REPLACE INTO "creature_names" ("entry", "name", "subname", "info_str", "flags1", "type", "family", "rank", "killcredit1", "killcredit2", "male_displayid", "female_displayid", "male_displayid2", "female_displayid2", "unknown_float1", "unknown_float2", "leader", "questitem1", "questitem2", "questitem3", "questitem4", "questitem5", "questitem6", "waypointid") VALUES
  105.     ('100008','Hand of the Deceiver','','','0','10','0','1','0','0','19294','0','0','0','1','1',0,'0','0','0','0','0','0','0');
  106. /*!40000 ALTER TABLE "creature_names" ENABLE KEYS;*/
  107. UNLOCK TABLES;
  108.  
  109.  
  110. #
  111. # Table structure for table 'creature_proto'
  112. #
  113.  
  114. CREATE TABLE /*!32312 IF NOT EXISTS*/ "creature_proto" (
  115.   "entry" int(30) unsigned NOT NULL DEFAULT '0',
  116.   "minlevel" int(30) unsigned NOT NULL,
  117.   "maxlevel" int(30) unsigned NOT NULL,
  118.   "faction" int(30) unsigned NOT NULL DEFAULT '0',
  119.   "minhealth" int(30) unsigned NOT NULL,
  120.   "maxhealth" int(30) unsigned NOT NULL,
  121.   "mana" int(30) unsigned NOT NULL DEFAULT '0',
  122.   "scale" float NOT NULL DEFAULT '0',
  123.   "npcflags" int(30) unsigned NOT NULL DEFAULT '0',
  124.   "attacktime" int(30) unsigned NOT NULL DEFAULT '0',
  125.   "attacktype" int(4) NOT NULL DEFAULT '0',
  126.   "mindamage" float NOT NULL DEFAULT '0',
  127.   "maxdamage" float NOT NULL DEFAULT '0',
  128.   "can_ranged" int(11) unsigned NOT NULL DEFAULT '0',
  129.   "rangedattacktime" int(30) unsigned NOT NULL DEFAULT '0',
  130.   "rangedmindamage" float unsigned NOT NULL DEFAULT '0',
  131.   "rangedmaxdamage" float unsigned NOT NULL DEFAULT '0',
  132.   "respawntime" int(30) unsigned NOT NULL DEFAULT '0',
  133.   "armor" int(30) unsigned NOT NULL DEFAULT '0',
  134.   "resistance1" int(30) unsigned NOT NULL DEFAULT '0',
  135.   "resistance2" int(30) unsigned NOT NULL DEFAULT '0',
  136.   "resistance3" int(30) unsigned NOT NULL DEFAULT '0',
  137.   "resistance4" int(30) unsigned NOT NULL DEFAULT '0',
  138.   "resistance5" int(30) unsigned NOT NULL DEFAULT '0',
  139.   "resistance6" int(30) unsigned NOT NULL DEFAULT '0',
  140.   "combat_reach" float NOT NULL DEFAULT '0',
  141.   "bounding_radius" float NOT NULL DEFAULT '0',
  142.   "auras" longtext NOT NULL,
  143.   "boss" int(11) unsigned NOT NULL DEFAULT '0',
  144.   "money" int(30) NOT NULL DEFAULT '0',
  145.   "invisibility_type" int(30) unsigned NOT NULL,
  146.   "death_state" int(30) unsigned NOT NULL,
  147.   "walk_speed" float NOT NULL DEFAULT '2.5',
  148.   "run_speed" float NOT NULL DEFAULT '8',
  149.   "fly_speed" float NOT NULL DEFAULT '14',
  150.   "extra_a9_flags" int(30) NOT NULL DEFAULT '0',
  151.   "spell1" int(30) NOT NULL DEFAULT '0',
  152.   "spell2" int(30) NOT NULL DEFAULT '0',
  153.   "spell3" int(30) NOT NULL DEFAULT '0',
  154.   "spell4" int(30) NOT NULL DEFAULT '0',
  155.   "spell_flags" int(30) NOT NULL DEFAULT '0',
  156.   "modImmunities" int(30) unsigned NOT NULL DEFAULT '0',
  157.   "isTrainingDummy" int(10) unsigned NOT NULL DEFAULT '0',
  158.   "guardtype" int(10) unsigned NOT NULL DEFAULT '0',
  159.   "summonguard" int(10) unsigned NOT NULL DEFAULT '0',
  160.   PRIMARY KEY ("entry")
  161. ) COMMENT='Creature System';
  162.  
  163.  
  164.  
  165. #
  166. # Dumping data for table 'creature_proto'
  167. #
  168.  
  169. LOCK TABLES "creature_proto" WRITE;
  170. /*!40000 ALTER TABLE "creature_proto" DISABLE KEYS;*/
  171. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  172.     ('31021151','83','83','35','315000','315000','59910','1','0','1500',0,'6308','6708','0','0','0','0','0','360','0','0','0','0','0','0','1','1','','1',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  173. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  174.     ('26529762','83','83','35','13945000','13945000','4258000','1','0','1800',0,'10000','20000','0','0','0','0','0','15081','0','0','0','0','0','0','1','1','','1',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  175. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  176.     ('25452151','80','80','22','450000','450000','2508202','1','0','1500',0,'532','908','0','0','0','0','0','582','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','2.5','2.5',0,0,0,0,0,0,'0','0','0','0');
  177. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  178.     ('5078151','80','80','22','66000','66000','0','1','0','1500',0,'1','1','0','0','0','0','0','0','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  179. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  180.     ('3769813','80','80','21','200000','200000','208620','1','0','1700',0,'10851','20821','0','0','0','0','0','1597','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  181. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  182.     ('3769812','83','83','21','8000','8000','9000','1','0','1500',0,'1','1','0','0','0','0','0','0','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  183. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  184.     ('3769811','83','83','21','2000006','2000006','0','1','0','1600',0,'10000','20000','0','0','0','0','0','1208','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  185. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  186.     ('3769511','80','80','21','252000','252000','0','1','0','1700',0,'510','1082','0','0','0','0','0','1682','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  187. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  188.     ('3072111','83','83','35','17431250','17431250','0','1','0','1500',0,'40000','55000','0','0','0','0','0','12082','0','0','0','0','0','0','1','1','','1',156165,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  189. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  190.     ('3072110','1','1','35','1','1','1','0.01','0','1500',0,'1','1','0','0','0','0','0','0','0','0','0','0','0','0','1','1','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  191. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  192.     ('2626262','99','99','15','1000','1000','0','0.01','0','1500',0,'1','1','0','0','0','0','0','0','0','0','0','0','0','0','1','0.01','','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  193. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  194.     ('100001','80','83','35','54321567','55321567','0','1E-6','0','2500',0,'4352','5234','0','0','0','0','3600000','7424','0','200','0','0','0','0','0','0','0','1',43250000,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  195. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  196.     ('100000','80','80','14','27231','29671','0','1.5','0','3000',0,'689','1240','0','0','0','0','300000','3412','0','0','0','0','0','0','0','0','0','0',1000000,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  197. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  198.     ('25315','83','80','14','6624125','9525125','1251252','1','0','1242',0,'1234','5234','0','0','0','0','3600000','1512','0','0','0','0','0','0','0','0','0','1',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  199. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  200.     ('26046','83','80','35','6624125','9525125','1251252','1','0','1242',0,'1234','5234','0','0','0','0','3600000','1512','0','0','0','0','0','0','0','0','0','1',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  201. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  202.     ('25319','83','80','35','6624125','9525125','1251252','1','0','1242',0,'1234','5234','0','0','0','0','3600000','1512','0','0','0','0','0','0','0','0','0','1',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  203. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  204.     ('100006','83','80','14','144624','144624','251252','1','0','1242',0,'421','642','0','0','0','0','3600000','5421','0','0','0','0','0','0','0','0','0','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  205. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  206.     ('100007','83','80','14','144624','144624','251252','1','0','1242',0,'421','642','0','0','0','0','3600000','5421','0','0','0','0','0','0','0','0','0','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  207. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  208.     ('100008','83','80','14','144624','144624','251252','1','0','1242',0,'421','642','0','0','0','0','3600000','5421','0','0','0','0','0','0','0','0','0','0',0,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  209. REPLACE INTO "creature_proto" ("entry", "minlevel", "maxlevel", "faction", "minhealth", "maxhealth", "mana", "scale", "npcflags", "attacktime", "attacktype", "mindamage", "maxdamage", "can_ranged", "rangedattacktime", "rangedmindamage", "rangedmaxdamage", "respawntime", "armor", "resistance1", "resistance2", "resistance3", "resistance4", "resistance5", "resistance6", "combat_reach", "bounding_radius", "auras", "boss", "money", "invisibility_type", "death_state", "walk_speed", "run_speed", "fly_speed", "extra_a9_flags", "spell1", "spell2", "spell3", "spell4", "spell_flags", "modImmunities", "isTrainingDummy", "guardtype", "summonguard") VALUES
  210.     ('100002','80','83','35','54321567','55321567','0','1','0','2500',0,'4352','5234','0','0','0','0','3600000','7424','0','200','0','0','0','0','0','0','0','1',43250000,'0','0','2.5','8','14',0,0,0,0,0,0,'0','0','0','0');
  211. /*!40000 ALTER TABLE "creature_proto" ENABLE KEYS;*/
  212. UNLOCK TABLES;
  213.  
  214.  
  215. #
  216. # Table structure for table 'creature_spawns'
  217. #
  218.  
  219. CREATE TABLE /*!32312 IF NOT EXISTS*/ "creature_spawns" (
  220.   "id" int(30) unsigned NOT NULL AUTO_INCREMENT,
  221.   "entry" int(30) NOT NULL,
  222.   "map" int(30) NOT NULL,
  223.   "position_x" float NOT NULL,
  224.   "position_y" float NOT NULL,
  225.   "position_z" float NOT NULL,
  226.   "orientation" float NOT NULL,
  227.   "movetype" int(30) NOT NULL DEFAULT '0',
  228.   "displayid" int(10) unsigned NOT NULL DEFAULT '0',
  229.   "faction" int(30) NOT NULL DEFAULT '14',
  230.   "flags" int(30) NOT NULL DEFAULT '0',
  231.   "bytes0" int(30) NOT NULL DEFAULT '0',
  232.   "bytes1" int(30) NOT NULL DEFAULT '0',
  233.   "bytes2" int(30) NOT NULL DEFAULT '0',
  234.   "emote_state" int(30) NOT NULL DEFAULT '0',
  235.   "npc_respawn_link" int(30) NOT NULL DEFAULT '0',
  236.   "channel_spell" int(30) NOT NULL DEFAULT '0',
  237.   "channel_target_sqlid" int(30) NOT NULL DEFAULT '0',
  238.   "channel_target_sqlid_creature" int(30) NOT NULL DEFAULT '0',
  239.   "standstate" int(10) NOT NULL DEFAULT '0',
  240.   "mountdisplayid" int(10) unsigned NOT NULL DEFAULT '0',
  241.   "slot1item" int(10) unsigned NOT NULL DEFAULT '0',
  242.   "slot2item" int(10) unsigned NOT NULL DEFAULT '0',
  243.   "slot3item" int(10) unsigned NOT NULL DEFAULT '0',
  244.   "CanFly" smallint(3) NOT NULL DEFAULT '0',
  245.   "phase" int(10) unsigned NOT NULL DEFAULT '1',
  246.   PRIMARY KEY ("id")
  247. ) AUTO_INCREMENT=391694 COMMENT='Spawn System';
  248.  
  249.  
  250.  
  251. #
  252. # Dumping data for table 'creature_spawns'
  253. #
  254.  
  255. LOCK TABLES "creature_spawns" WRITE;
  256. /*!40000 ALTER TABLE "creature_spawns" DISABLE KEYS;*/
  257. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  258.     ('1',19044,565,'237.502','357.739','-4.95819','3.13922',0,'18698',14,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  259. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  260.     ('391501',26529762,631,'506.748','-2122.71','1572.78','3.14359',0,'31011',35,0,0,0,1,0,0,0,0,0,0,'0','13262','0','0',0,'1');
  261. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  262.     ('391502',3072111,631,'431.262','-2124.18','1596.06','0.0436275',0,'30721',35,0,0,0,1,0,0,0,0,0,0,'0','36942','0','0',0,'1');
  263. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  264.     ('391514',100008,580,'1695.03','659.756','28.0504','5.00353',0,'19294',14,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  265. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  266.     ('391515',26046,580,'1699.48','628.054','42.4649','-3.10511',0,'23503',35,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',1,'1');
  267. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  268.     ('391507',100000,1,'-1822.77','1575.53','61.6709','0.108767',0,'958',14,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  269. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  270.     ('391512',100006,580,'1683.42','597.471','28.0505','0.962666',0,'19294',14,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  271. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  272.     ('391513',100007,580,'1731.82','627.493','28.0502','3.45945',0,'19294',14,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  273. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  274.     ('391552',100001,631,'505.135','-2121.51','1583.14','0.892952',0,'15880',35,26,0,0,0,0,0,0,0,0,0,'0','0','0','0',1,'1');
  275. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  276.     ('391654',100002,631,'505.383','-2122.75','1571.9','6.06327',0,'15880',35,26,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  277. REPLACE INTO "creature_spawns" ("id", "entry", "map", "position_x", "position_y", "position_z", "orientation", "movetype", "displayid", "faction", "flags", "bytes0", "bytes1", "bytes2", "emote_state", "npc_respawn_link", "channel_spell", "channel_target_sqlid", "channel_target_sqlid_creature", "standstate", "mountdisplayid", "slot1item", "slot2item", "slot3item", "CanFly", "phase") VALUES
  278.     ('391693',31021151,631,'437.02','-2120.79','1593.51','3.02787',0,'31021',35,0,0,0,0,0,0,0,0,0,0,'0','0','0','0',0,'1');
  279. /*!40000 ALTER TABLE "creature_spawns" ENABLE KEYS;*/
  280. UNLOCK TABLES;
  281.  
  282.  
  283. #
  284. # Table structure for table 'gameobject_names'
  285. #
  286.  
  287. CREATE TABLE /*!32312 IF NOT EXISTS*/ "gameobject_names" (
  288.   "entry" int(10) unsigned NOT NULL DEFAULT '0',
  289.   "Type" int(10) unsigned NOT NULL DEFAULT '0',
  290.   "DisplayID" int(10) unsigned NOT NULL DEFAULT '0',
  291.   "Name" varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  292.   "Category" varchar(100) NOT NULL,
  293.   "CastBarText" varchar(100) NOT NULL,
  294.   "UnkStr" varchar(100) NOT NULL,
  295.   "spellfocus" int(10) unsigned NOT NULL DEFAULT '0',
  296.   "sound1" int(10) unsigned NOT NULL DEFAULT '0',
  297.   "sound2" int(10) unsigned NOT NULL DEFAULT '0',
  298.   "sound3" int(10) unsigned NOT NULL DEFAULT '0',
  299.   "sound4" int(10) unsigned NOT NULL DEFAULT '0',
  300.   "sound5" int(10) unsigned NOT NULL DEFAULT '0',
  301.   "sound6" int(10) unsigned NOT NULL DEFAULT '0',
  302.   "sound7" int(10) unsigned NOT NULL DEFAULT '0',
  303.   "sound8" int(10) unsigned NOT NULL DEFAULT '0',
  304.   "sound9" int(10) unsigned NOT NULL DEFAULT '0',
  305.   "unknown1" int(10) unsigned NOT NULL DEFAULT '0',
  306.   "unknown2" int(10) unsigned NOT NULL DEFAULT '0',
  307.   "unknown3" int(10) unsigned NOT NULL DEFAULT '0',
  308.   "unknown4" int(10) unsigned NOT NULL DEFAULT '0',
  309.   "unknown5" int(10) unsigned NOT NULL DEFAULT '0',
  310.   "unknown6" int(10) unsigned NOT NULL DEFAULT '0',
  311.   "unknown7" int(10) unsigned NOT NULL DEFAULT '0',
  312.   "unknown8" int(10) unsigned NOT NULL DEFAULT '0',
  313.   "unknown9" int(10) unsigned NOT NULL DEFAULT '0',
  314.   "unknown10" int(10) unsigned NOT NULL DEFAULT '0',
  315.   "unknown11" int(10) unsigned NOT NULL DEFAULT '0',
  316.   "unknown12" int(10) unsigned NOT NULL DEFAULT '0',
  317.   "unknown13" int(10) unsigned NOT NULL DEFAULT '0',
  318.   "unknown14" int(10) unsigned NOT NULL DEFAULT '0',
  319.   "Size" float NOT NULL DEFAULT '1',
  320.   "QuestItem1" int(11) unsigned NOT NULL DEFAULT '0',
  321.   "QuestItem2" int(11) unsigned NOT NULL DEFAULT '0',
  322.   "QuestItem3" int(11) unsigned NOT NULL DEFAULT '0',
  323.   "QuestItem4" int(11) unsigned NOT NULL DEFAULT '0',
  324.   "QuestItem5" int(11) unsigned NOT NULL DEFAULT '0',
  325.   "QuestItem6" int(11) unsigned NOT NULL DEFAULT '0',
  326.   PRIMARY KEY ("entry")
  327. ) COMMENT='Gameobject System';
  328.  
  329.  
  330.  
  331. #
  332. # Dumping data for table 'gameobject_names'
  333. #
  334.  
  335. LOCK TABLES "gameobject_names" WRITE;
  336. /*!40000 ALTER TABLE "gameobject_names" DISABLE KEYS;*/
  337. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  338.     ('2957197','33','9276','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  339. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  340.     ('15081081','33','9260','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  341. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  342.     ('15078109','33','9294','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  343. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  344.     ('1515081','33','9256','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  345. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  346.     ('2620862','33','9257','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  347. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  348.     ('19571971','33','9258','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  349. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  350.     ('1560725','5','9264','Lich King Object','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  351. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  352.     ('95781057','5','9227','Ice Block','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  353. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  354.     ('2508221','5','9332','Bolvar - Chains','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  355. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  356.     ('500000','14','9256','world\wmo\dungeon\icecrownraid\icecrownraid_arthas_precipice.wmo','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  357. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  358.     ('500001','14','9257','world\wmo\dungeon\icecrownraid\icecrownraid_arthas_precipice_phase1.wmo','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  359. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  360.     ('500002','14','9258','world\wmo\dungeon\icecrownraid\icecrownraid_arthas_precipice_phase2.wmo','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  361. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  362.     ('500003','14','9276','world\wmo\dungeon\icecrownraid\icecrownraid_arthas_precipice_phase0.wmo','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  363. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  364.     ('500004','33','64086','Broken Frostmourne','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  365. REPLACE INTO "gameobject_names" ("entry", "Type", "DisplayID", "Name", "Category", "CastBarText", "UnkStr", "spellfocus", "sound1", "sound2", "sound3", "sound4", "sound5", "sound6", "sound7", "sound8", "sound9", "unknown1", "unknown2", "unknown3", "unknown4", "unknown5", "unknown6", "unknown7", "unknown8", "unknown9", "unknown10", "unknown11", "unknown12", "unknown13", "unknown14", "Size", "QuestItem1", "QuestItem2", "QuestItem3", "QuestItem4", "QuestItem5", "QuestItem6") VALUES
  366.     ('500005','33','9331','Bolvar - Sitting','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0');
  367. /*!40000 ALTER TABLE "gameobject_names" ENABLE KEYS;*/
  368. UNLOCK TABLES;
  369.  
  370.  
  371. #
  372. # Table structure for table 'gameobject_spawns'
  373. #
  374.  
  375. CREATE TABLE /*!32312 IF NOT EXISTS*/ "gameobject_spawns" (
  376.   "id" int(11) unsigned NOT NULL AUTO_INCREMENT,
  377.   "Entry" int(10) unsigned NOT NULL DEFAULT '0',
  378.   "map" int(10) unsigned NOT NULL DEFAULT '0',
  379.   "position_x" float NOT NULL DEFAULT '0',
  380.   "position_y" float NOT NULL DEFAULT '0',
  381.   "position_z" float NOT NULL DEFAULT '0',
  382.   "Facing" float NOT NULL DEFAULT '0',
  383.   "orientation1" float NOT NULL DEFAULT '0',
  384.   "orientation2" float NOT NULL DEFAULT '0',
  385.   "orientation3" float NOT NULL DEFAULT '0',
  386.   "orientation4" float NOT NULL DEFAULT '0',
  387.   "State" int(10) unsigned NOT NULL DEFAULT '0',
  388.   "Flags" int(10) unsigned NOT NULL DEFAULT '0',
  389.   "Faction" int(10) unsigned NOT NULL DEFAULT '0',
  390.   "Scale" float NOT NULL DEFAULT '0',
  391.   "stateNpcLink" int(10) unsigned NOT NULL DEFAULT '0',
  392.   "phase" int(10) unsigned NOT NULL DEFAULT '1',
  393.   "overrides" int(10) unsigned NOT NULL DEFAULT '0',
  394.   PRIMARY KEY ("id")
  395. ) AUTO_INCREMENT=5125130 COMMENT='Spawn System';
  396.  
  397.  
  398.  
  399. #
  400. # Dumping data for table 'gameobject_spawns'
  401. #
  402.  
  403. LOCK TABLES "gameobject_spawns" WRITE;
  404. /*!40000 ALTER TABLE "gameobject_spawns" DISABLE KEYS;*/
  405. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  406.     ('58324','2957197','631','507.006','-2122.61','1567.79','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
  407. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  408.     ('58322','15081081','631','519.289','-2118.19','1564.97','3.3348','0','0','0.995337','-0.0964536','8449','0','0','1','0','1','0');
  409. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  410.     ('58323','15078109','631','519.289','-2118.19','1564.97','3.3348','0','0','0.995337','-0.0964536','8449','0','0','1','0','1','0');
  411. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  412.     ('58325','1515081','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
  413. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  414.     ('58326','2620862','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
  415. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  416.     ('58327','19571971','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
  417. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  418.     ('58328','15081081','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
  419. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  420.     ('58329','15078109','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
  421. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  422.     ('58330','1560725','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','1281','0','0','1','0','1','0');
  423. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  424.     ('58335','95781057','631','477.985','-2150.19','1572.04','4.02613','0','0','0.903782','-0.427993','1281','0','0','1','0','1','0');
  425. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  426.     ('5125127','95781057','631','476.01','-2094.78','1572.04','3.17779','0','0','0.999836','-0.0180988','1281','0','0','1','0','1','0');
  427. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  428.     ('58344','2508221','631','428.758','-2124.4','1594.69','0.00392532','0','0','0.00196266','0.999998','1281','0','0','1','0','1','0');
  429. REPLACE INTO "gameobject_spawns" ("id", "Entry", "map", "position_x", "position_y", "position_z", "Facing", "orientation1", "orientation2", "orientation3", "orientation4", "State", "Flags", "Faction", "Scale", "stateNpcLink", "phase", "overrides") VALUES
  430.     ('5125123','500003','631','500.988','-2126.01','951.008','0.0732412','0','0','0.0366124','0.99933','3585','0','0','1','0','1','0');
  431. /*!40000 ALTER TABLE "gameobject_spawns" ENABLE KEYS;*/
  432. UNLOCK TABLES;
  433. /*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
  434. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!