Показать сообщение отдельно
Старый 06.05.2011, 01:22   #25
Mediv
Ученый
 
Аватар для Mediv
 
Регистрация: 17.11.2010
Сообщений: 204
Сказал(а) спасибо: 40
Поблагодарили 20 раз(а) в 14 сообщениях
Записей в дневнике: 1
Mediv На верном пути
Отправить сообщение для Mediv с помощью ICQ
По умолчанию

Start Zone MOD

Меняет стартовые зоны игроков на оргриммар и голдшир.

Код:
DELETE FROM `playercreateinfo` WHERE `race` IN (1,2,3,4,5,6,7,8);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES

(1,1,0,12,-9448.55,68.236,56.3225,2.1115),
(1,2,0,12,-9448.55,68.236,56.3225,2.1115),
(1,4,0,12,-9448.55,68.236,56.3225,2.1115),
(1,5,0,12,-9448.55,68.236,56.3225,2.1115),
(1,8,0,12,-9448.55,68.236,56.3225,2.1115),
(1,9,0,12,-9448.55,68.236,56.3225,2.1115),
(2,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(3,1,0,12,-9448.55,68.236,56.3225,2.1115),
(3,2,0,12,-9448.55,68.236,56.3225,2.1115),
(3,3,0,12,-9448.55,68.236,56.3225,2.1115),
(3,4,0,12,-9448.55,68.236,56.3225,2.1115),
(3,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,1,0,12,-9448.55,68.236,56.3225,2.1115),
(4,3,0,12,-9448.55,68.236,56.3225,2.1115),
(4,4,0,12,-9448.55,68.236,56.3225,2.1115),
(4,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,11,0,12,-9448.55,68.236,56.3225,2.1115),
(5,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,11,1,1637,1629.36,-4373.39,31.2564,3.54839),
(7,1,0,12,-9448.55,68.236,56.3225,2.1115),
(7,4,0,12,-9448.55,68.236,56.3225,2.1115),
(7,8,0,12,-9448.55,68.236,56.3225,2.1115),
(7,9,0,12,-9448.55,68.236,56.3225,2.1115),
(8,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,8,1,1637,1629.36,-4373.39,31.2564,3.54839);
BC Версия:

Код:
DELETE FROM `playercreateinfo` WHERE `race` IN (1,2,3,4,5,6,7,8,10,11);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES

(1,1,0,12,-9448.55,68.236,56.3225,2.1115),
(1,2,0,12,-9448.55,68.236,56.3225,2.1115),
(1,4,0,12,-9448.55,68.236,56.3225,2.1115),
(1,5,0,12,-9448.55,68.236,56.3225,2.1115),
(1,8,0,12,-9448.55,68.236,56.3225,2.1115),
(1,9,0,12,-9448.55,68.236,56.3225,2.1115),
(2,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(2,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(3,1,0,12,-9448.55,68.236,56.3225,2.1115),
(3,2,0,12,-9448.55,68.236,56.3225,2.1115),
(3,3,0,12,-9448.55,68.236,56.3225,2.1115),
(3,4,0,12,-9448.55,68.236,56.3225,2.1115),
(3,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,1,0,12,-9448.55,68.236,56.3225,2.1115),
(4,3,0,12,-9448.55,68.236,56.3225,2.1115),
(4,4,0,12,-9448.55,68.236,56.3225,2.1115),
(4,5,0,12,-9448.55,68.236,56.3225,2.1115),
(4,11,0,12,-9448.55,68.236,56.3225,2.1115),
(5,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(5,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(6,11,1,1637,1629.36,-4373.39,31.2564,3.54839),
(7,1,0,12,-9448.55,68.236,56.3225,2.1115),
(7,4,0,12,-9448.55,68.236,56.3225,2.1115),
(7,8,0,12,-9448.55,68.236,56.3225,2.1115),
(7,9,0,12,-9448.55,68.236,56.3225,2.1115),
(8,1,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,7,1,1637,1629.36,-4373.39,31.2564,3.54839),
(8,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,2,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,3,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,4,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,5,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,8,1,1637,1629.36,-4373.39,31.2564,3.54839),
(10,9,1,1637,1629.36,-4373.39,31.2564,3.54839),
(11,1,0,12,-9448.55,68.236,56.3225,2.1115),
(11,2,0,12,-9448.55,68.236,56.3225,2.1115),
(11,3,0,12,-9448.55,68.236,56.3225,2.1115),
(11,5,0,12,-9448.55,68.236,56.3225,2.1115),
(11,7,0,12,-9448.55,68.236,56.3225,2.1115),
(11,8,0,12,-9448.55,68.236,56.3225,2.1115);
Вещи не ломаются:
Код:
UPDATE `item_template` SET `MaxDurability` = 0 WHERE `MaxDurability` > 0;
__________________
Ололо, мангос сила :D

Последний раз редактировалось Mediv; 20.06.2011 в 21:28.
Mediv вне форума   Ответить с цитированием