Shion
Legendário XPZ
versão refeita do script Lich King. Todos os recursos visuais são úteis, saltos Tirion para destruir Frostmourne, canais de jogadores Lich Rei para que ele possa criá-los dentre os mortos, a introdução foi refeita.
OBS: Frostmourne Câmara (eu preciso de descrição deste coisa, nenhuma idéia do que deve acontecer lá)
OBS: Defile (não funciona em ArcEmu)
OBS: O visual correto para reviver os mortos.
THE LICH KING SCRIPT:
SQL FILES:
THE FROZEN THRONE RECALL:
INSERT INTO `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`, `Orientation`) VALUES ('867', 'Frozen Throne', '631', '431.038', '-2124.07', '1596.06', '0.0986058');
THE FROZEN THRONE GAMEOBJECT SPAWNS:
# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 127.0.0.1
# Database: world
# Server version: 5.1.36-community-log
# Server OS: Win32
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0
# Date/time: 2010-04-06 08:17:58
# --------------------------------------------------------
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/
#
# Database structure for database 'world'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ "world" /*!40100 DEFAULT CHARACTER SET latin1 */;
USE "world";
#
# Table structure for table 'gameobject_spawns'
#
CREATE TABLE /*!32312 IF NOT EXISTS*/ "gameobject_spawns" (
"id" int(11) unsigned NOT NULL AUTO_INCREMENT,
"Entry" int(10) unsigned NOT NULL DEFAULT '0',
"map" int(10) unsigned NOT NULL DEFAULT '0',
"position_x" float NOT NULL DEFAULT '0',
"position_y" float NOT NULL DEFAULT '0',
"position_z" float NOT NULL DEFAULT '0',
"Facing" float NOT NULL DEFAULT '0',
"orientation1" float NOT NULL DEFAULT '0',
"orientation2" float NOT NULL DEFAULT '0',
"orientation3" float NOT NULL DEFAULT '0',
"orientation4" float NOT NULL DEFAULT '0',
"State" int(10) unsigned NOT NULL DEFAULT '0',
"Flags" int(10) unsigned NOT NULL DEFAULT '0',
"Faction" int(10) unsigned NOT NULL DEFAULT '0',
"Scale" float NOT NULL DEFAULT '0',
"stateNpcLink" int(10) unsigned NOT NULL DEFAULT '0',
"phase" int(10) unsigned NOT NULL DEFAULT '1',
"overrides" int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ("id")
) AUTO_INCREMENT=5125130 COMMENT='Spawn System';
#
# Dumping data for table 'gameobject_spawns'
#
LOCK TABLES "gameobject_spawns" WRITE;
/*!40000 ALTER TABLE "gameobject_spawns" DISABLE KEYS;*/
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
('58324','2957197','631','507.006','-2122.61','1567.79','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58322','15081081','631','519.289','-2118.19','1564.97','3.3348','0','0','0.995337','-0.0964536','8449','0','0','1','0','1','0');
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
('58323','15078109','631','519.289','-2118.19','1564.97','3.3348','0','0','0.995337','-0.0964536','8449','0','0','1','0','1','0');
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
('58325','1515081','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58326','2620862','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58327','19571971','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58328','15081081','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58329','15078109','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58330','1560725','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','1281','0','0','1','0','1','0');
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
('58335','95781057','631','477.985','-2150.19','1572.04','4.02613','0','0','0.903782','-0.427993','1281','0','0','1','0','1','0');
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
('5125127','95781057','631','476.01','-2094.78','1572.04','3.17779','0','0','0.999836','-0.0180988','1281','0','0','1','0','1','0');
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
('58344','2508221','631','428.758','-2124.4','1594.69','0.00392532','0','0','0.00196266 ','0.999998','1281','0','0','1','0','1','0');
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
('5125128','188415','580','1652.95','636.461','28. 091','5.95309','0','0','0.1643','-0.98641','257','0','0','1','0','1','0');
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
('5125123','500003','631','500.988','-2126.01','951.008','0.0732412','0','0','0.0366124' ,'0.99933','3585','0','0','1','0','1','0');
/*!40000 ALTER TABLE "gameobject_spawns" ENABLE KEYS;*/
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/
DBC extractor (você deve usar este ou o script não vai funcionar)
(Ignore a pasta mapas que será criado, basta apagá-lo.)
OBS: Frostmourne Câmara (eu preciso de descrição deste coisa, nenhuma idéia do que deve acontecer lá)
OBS: Defile (não funciona em ArcEmu)
OBS: O visual correto para reviver os mortos.
THE LICH KING SCRIPT:
SQL FILES:
THE FROZEN THRONE RECALL:
INSERT INTO `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`, `Orientation`) VALUES ('867', 'Frozen Throne', '631', '431.038', '-2124.07', '1596.06', '0.0986058');
THE FROZEN THRONE GAMEOBJECT SPAWNS:
# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 127.0.0.1
# Database: world
# Server version: 5.1.36-community-log
# Server OS: Win32
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0
# Date/time: 2010-04-06 08:17:58
# --------------------------------------------------------
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/
#
# Database structure for database 'world'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ "world" /*!40100 DEFAULT CHARACTER SET latin1 */;
USE "world";
#
# Table structure for table 'gameobject_spawns'
#
CREATE TABLE /*!32312 IF NOT EXISTS*/ "gameobject_spawns" (
"id" int(11) unsigned NOT NULL AUTO_INCREMENT,
"Entry" int(10) unsigned NOT NULL DEFAULT '0',
"map" int(10) unsigned NOT NULL DEFAULT '0',
"position_x" float NOT NULL DEFAULT '0',
"position_y" float NOT NULL DEFAULT '0',
"position_z" float NOT NULL DEFAULT '0',
"Facing" float NOT NULL DEFAULT '0',
"orientation1" float NOT NULL DEFAULT '0',
"orientation2" float NOT NULL DEFAULT '0',
"orientation3" float NOT NULL DEFAULT '0',
"orientation4" float NOT NULL DEFAULT '0',
"State" int(10) unsigned NOT NULL DEFAULT '0',
"Flags" int(10) unsigned NOT NULL DEFAULT '0',
"Faction" int(10) unsigned NOT NULL DEFAULT '0',
"Scale" float NOT NULL DEFAULT '0',
"stateNpcLink" int(10) unsigned NOT NULL DEFAULT '0',
"phase" int(10) unsigned NOT NULL DEFAULT '1',
"overrides" int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ("id")
) AUTO_INCREMENT=5125130 COMMENT='Spawn System';
#
# Dumping data for table 'gameobject_spawns'
#
LOCK TABLES "gameobject_spawns" WRITE;
/*!40000 ALTER TABLE "gameobject_spawns" DISABLE KEYS;*/
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
('58324','2957197','631','507.006','-2122.61','1567.79','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58322','15081081','631','519.289','-2118.19','1564.97','3.3348','0','0','0.995337','-0.0964536','8449','0','0','1','0','1','0');
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
('58323','15078109','631','519.289','-2118.19','1564.97','3.3348','0','0','0.995337','-0.0964536','8449','0','0','1','0','1','0');
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
('58325','1515081','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58326','2620862','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58327','19571971','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58328','15081081','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58329','15078109','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','8449','0','0','1','0','1','0');
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
('58330','1560725','631','507.006','-2122.61','1567.65','3.17301','0','0','0.999877','-0.0157075','1281','0','0','1','0','1','0');
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
('58335','95781057','631','477.985','-2150.19','1572.04','4.02613','0','0','0.903782','-0.427993','1281','0','0','1','0','1','0');
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
('5125127','95781057','631','476.01','-2094.78','1572.04','3.17779','0','0','0.999836','-0.0180988','1281','0','0','1','0','1','0');
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
('58344','2508221','631','428.758','-2124.4','1594.69','0.00392532','0','0','0.00196266 ','0.999998','1281','0','0','1','0','1','0');
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
('5125128','188415','580','1652.95','636.461','28. 091','5.95309','0','0','0.1643','-0.98641','257','0','0','1','0','1','0');
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
('5125123','500003','631','500.988','-2126.01','951.008','0.0732412','0','0','0.0366124' ,'0.99933','3585','0','0','1','0','1','0');
/*!40000 ALTER TABLE "gameobject_spawns" ENABLE KEYS;*/
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/
DBC extractor (você deve usar este ou o script não vai funcionar)
(Ignore a pasta mapas que será criado, basta apagá-lo.)