Дата: Четверг, 29.04.2010, 17:26 | Сообщение # 1
VIP Статус:
Группа: Администратор
Сообщений: 3088
I took Stoneharry's Lich King script and remade it. All visuals are working, Tirion jumps to destroy frostmourne, Lich King channels players so he can raise them from the dead, the Intro has been redone. TODO: Frostmourne Chamber (I need description of this thing, no idea what should happen there)
TODO: Defile ( doesn't work on ArcEmu)
TODO: The correct visual for raise dead
THE LICH KING SCRIPT:
http://pastebin.com/gTdzME5d
SQL FILES:
http://pastebin.com/05Z9UfdN
THE FROZEN THRONE RECALL:
Code
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 Code
# # -------------------------------------------------------- # 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;*/</pre>
DBC EXTRACTER: (YOU MUST USE THIS ONE OR THE SCRIPT WONT WORK) http://filebeam.com/a0b87c47fe0792684b0a87a20eb0e82d
(Ignore the maps folder that will be created, just delete it.)
Credits:
Hydroxis
Kjanko (for helping me with the channel part)
Stoneharry
Neglected(for helping me with some Lua commands)
ENJOY!
Some Screenshots: