DELETE FROM `creature_template` WHERE `entry` =13;
REPLACE INTO `creature_template` VALUES
(13, 0, 18748, 5525, 20711, 17895, 'Bruenno Guilde', 'Guildhouse Keeper', NULL, 52, 82, 6700, 24000, 5598, 5875, 20, 35, 35, 1, 1.48, 0, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, 'guildmaster');

REPLACE INTO `locales_creature` VALUES
(13, '', '', '', '', '', '', '', 'ءً‏ييî أèëüنه', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'صًàيèٍهëü أèëüنهéٌêèُ ؤîىîâ');

REPLACE INTO `creature` VALUES
(131001, 13, 0, 1, 0, 0, -8888.29, 607.158, 102.304, 1.83473, 25, 0, 0, 8588, 5662, 0, 0),
(131002, 13, 1, 1, 0, 0, 1585.22, -4295.73, 37.8993, 2.62324, 25, 0, 0, 14124, 5773, 0, 0),
(131003, 13, 530, 1, 5525, 0, -4083.11, -11629.9, -138.654, 3.41019, 25, 0, 0, 9512, 5681, 0, 0),
(131004, 13, 530, 1, 5525, 0, 9469.36, -7353.5, 23.4994, 1.98703, 25, 0, 0, 10434, 5699, 0, 0),
(131005, 13, 1, 1, 0, 0, 10078.7, 2184.92, 1346.62, 1.63859, 25, 0, 0, 5360, 5598, 0, 0),
(131006, 13, 0, 1, 5525, 0, -5011.4, -992.523, 503.882, 3.81506, 25, 0, 0, 18276, 5856, 0, 0),
(131007, 13, 530, 1, 0, 0, -1867.98, 5421.33, -10.4635, 1.10935, 25, 0, 0, 10434, 5699, 0, 0),
(131008, 13, 0, 1, 0, 0, 1591.84, 202.21, -55.3424, 1.66698, 25, 0, 0, 19200, 5875, 0, 0),
(131009, 13, 1, 1, 0, 0, -1299.16, 131.465, 131.464, 5.34853, 25, 0, 0, 18276, 5856, 0, 0);

delete from `gameobject` where `map` = 618;
insert into `gameobject` values
-- buffs
('200070','184663','618','1','1','735.551819','-284.794678','28.276682','0.034906','0','0','0','0','-120','100','1'),
('200071','184 664','618','1','1','791.224487','-284.794464','28.276682','2.600535','0','0','0','0','-120','100','1'),
-- elevators
('200072','194582','618','1','1','763.536377','-294.535767','0.505383','3.141593','0','0','0','0','120','100','1'),
('200073','1 94586','618','1','1','763.506348','-273.873352','0.505383','0','0','0','0','0','120','100','1'),
-- fire
('200074','192704','618','1','1','743.543457','-283.799469','28.286655','0','0','0','0','0','120','100','1'),
('200075','192705','618 ','1','1','782.971802','-283.799469','28.286655','0','0','0','0','0','120','100','1'),
('200076','192388','618','1','1','743.711060','-284. 099609','27.542587','3.141593','0','0','0','0','120','100','1'),
('200077','192387','618','1','1','783.221252','-284.133362','27.535686','0 ','0','0','0','0','120','100','1'),
-- gears
('200078','192393','618','1','1','763.664551','-261.872986','26.686588','0','0','0','0','0','120','100','1'),
('200079','192394','61 8','1','1','763.578979','-306.146149','26.665222','3.141593','0','0','0','0','120','100','1'),
-- pillars
('200080','194583','618','1','1','763.632385','-306.162384','25.909504','3.141593','0','0','0','0','120','100','1'),
('200081','19 4584','618','1','1','723.644287','-284.493256','24.648525','3.141593','0','0','0','0','120','100','1'),
('200082','194585','618','1','1','7 63.611145','-261.856750','25.909504','0','0','0','0','0','120','100','1'),
('200083','194587','618','1','1','802.211609','-284.493256','24. 648525','0','0','0','0','0','120','100','1'),
-- pulley
('200088','192389','618','1','1','700.722290','-283.990662','39.517582','3.141593','0','0','0','0','120','100','1'),
('200089','192 390','618','1','1','826.303833','-283.996429','39.517582','0','0','0','0','0','120','100','1');

delete from `gameobject_battleground` where `guid` in (200070,200071,200072,200073);
insert into `gameobject_battleground` values
-- buffs
('200070','252','0'),
('200071','252','0'),
-- elevators
('200072','254','0'),
('200073','254','0');

delete from `battleground_events` where `map` = 618;
insert into `battleground_events` values
('618','252','0','buffs'),
('618','254','0','doors');

update `gameobject_template` set `faction` = 114, `flags` = 32 where `entry` in (192704,192705,192388,192387,192393,192394,192389,192390);

INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(131001, 13, 0, 1, 1, 0, 0, -8888.29, 607.158, 102.304, 1.83473, 360, 0, 0, 6700, 5598, 0, 0),
(131002, 13, 1, 1, 1, 0, 0, 1585.22, -4295.73, 37.8993, 2.62324, 360, 0, 0, 6700, 5598, 0, 0),
(131003, 13, 530, 1, 1, 5525, 0, -4083.11, -11629.9, -138.654, 3.41019, 360, 0, 0, 6700, 5598, 0, 0),
(131004, 13, 530, 1, 1, 5525, 0, 9469.36, -7353.5, 23.4994, 1.98703, 360, 0, 0, 6700, 5598, 0, 0),
(131005, 13, 1, 1, 1, 0, 0, 10078.7, 2184.92, 1346.62, 1.63859, 360, 0, 0, 6700, 5598, 0, 0),
(131006, 13, 0, 1, 1, 5525, 0, -5011.4, -992.523, 503.882, 3.81506, 360, 0, 0, 6700, 5598, 0, 0),
(131007, 13, 530, 1, 1, 0, 0, -1867.98, 5421.33, -10.4635, 1.10935, 360, 0, 0, 6700, 5598, 0, 0),
(131008, 13, 0, 1, 1, 0, 0, 1591.84, 202.21, -55.3424, 1.66698, 360, 0, 0, 6700, 5598, 0, 0),
(131009, 13, 1, 1, 1, 0, 0, -1299.16, 131.465, 131.464, 5.34853, 360, 0, 0, 6700, 5598, 0, 0),
(131010, 13, 1, 1, 1, 0, 0, 16212.6, 16256.7, 14.7189, 0.270119, 300, 0, 0, 6700, 5598, 0, 0),
(131011, 13, 1, 1, 1, 0, 0, 16211.3, 16262.3, 14.7766, 0.346283, 300, 0, 0, 6700, 5598, 0, 0);

using System;
using System.Linq;
using System.Text;
using System.IO;

namespace ConsoleApplication1
{
      class Program
      {
          static void Main(string[] args)
          {
              Console.Write("Введите размер файла (в байтах) которые надо пропустить: ");
              int size = int.Parse(Console.ReadLine());

              using (StreamWriter sw = new StreamWriter("mmaps_convert.bat", false, Encoding.ASCII))
              {
                  foreach (var file in new DirectoryInfo("maps").GetFiles("*.map").Where(n => (n.Length > size)))
                  {
                      string str = String.Format("generator.exe {0} {1} {2}", file.Name.Substring(0, 3), file.Name.Substring(3, 2), file.Name.Substring(5, 2));
                      sw.WriteLine(str);
                      Console.WriteLine(str);
                  }
              }

              Console.ReadLine();
          }
      }
}