WoW-ExStReMe

�� : 3D ��

mybb@mybb.ru (zbcjcfwywe) — Tue, 12 Apr 2022 17:09:17 +0300

�� . � �� . �� , �� ? �� , �� ? �� , �� ? � �� 20-�� . �� 15 ��. �� , �� 11 �� : 3D ��, �� : -�� . - �� - �� - ��, �� - �� ? -�� , �� , �� . �� : -�� .- �� .- �� .- �� .- �� : https://byyf111.wixsite.com/website1631 �� https://is.gd/GmeoP0

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 16:07:24 +0400

�� Shattrath City

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 16:03:47 +0400

�� ,�� ...�� ,�� ...�� !!!

��:

/*
MySQL Data Transfer
Source Host: localhost
Source Database: mangos
Target Host: localhost
Target Database: mangos
Date: 07.08.2008 9:26:36
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playercreateinfo
-- ----------------------------
DROP TABLE IF EXISTS `playercreateinfo`;
CREATE TABLE `playercreateinfo` (
     `race` tinyint(3) unsigned NOT NULL default '0',
     `class` tinyint(3) unsigned NOT NULL default '0',
     `map` smallint(5) unsigned NOT NULL default '0',
     `zone` mediumint(8) 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',
     PRIMARY KEY  (`race`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records    
-- ----------------------------
INSERT INTO `playercreateinfo` VALUES ('1', '1', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('1', '2', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('1', '4', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('1', '5', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('1', '8', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('1', '9', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('2', '1', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('2', '3', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('2', '4', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('2', '7', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('2', '9', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('3', '1', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('3', '2', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('3', '3', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('3', '4', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('3', '5', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('4', '1', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('4', '3', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('4', '4', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('4', '5', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('4', '11', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('5', '1', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('5', '4', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('5', '5', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('5', '8', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('5', '9', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('6', '1', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('6', '3', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('6', '7', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('6', '11', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('7', '1', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('7', '4', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('7', '8', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('7', '9', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('8', '1', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('8', '3', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('8', '4', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('8', '5', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('8', '7', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('8', '8', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('10', '2', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('10', '3', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('10', '4', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('10', '5', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('10', '8', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('10', '9', '530', '481', '-1881.987793', '5375.109375', '-12.428329');
INSERT INTO `playercreateinfo` VALUES ('11', '1', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('11', '2', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('11', '3', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('11', '5', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('11', '7', '530', '481', '-1843.961060', '5489.236816', '-12.428216');
INSERT INTO `playercreateinfo` VALUES ('11', '8', '530', '481', '-1843.961060', '5489.236816', '-12.428216');

�� .

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 16:03:05 +0400

�� !
�� .
�� -��
�� http://www.wowhead.com/?npc=28474 . �� .txt �� "��: 46 �� .sql" �� .sql,�� mangos. �� +

��:

DELETE FROM `creature_questrelation` WHERE `quest` = 12738;    
DELETE FROM `gameobject_questrelation` WHERE `quest` = 12738;    
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 12738;    
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28474, 12738);    
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 28474;    
DELETE FROM `creature_involvedrelation` WHERE `quest` = 12738;    
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 12738;    
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28474, 12738);    
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=28474;    
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (12738, 2, -372, 0, 55, 55, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 46, 12727, 0, 0, 0, 0, 0, 0, 'A Cry For Vengeance!', 'The cry for vengeance must be heard, $N. Commander Plaguefist and a company of death knights are on their way to raze the Chapel of the Crimson Flame. If there are any death knights imprisoned at the chapel, Plaguefist will get them out.$B$BYou can still catch up to them if you hurry. The chapel is due west of here.', 'Report to Knight Commander Plaguefist at the Chapel of the Crimson Flame.', 'They\'re only flesh and bone - no match for the Scourge.$B$BWe didn\'t find any of our brothers, but we did stumble upon something special.', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4950, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

�� fix ��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 16:02:25 +0400

��:

UPDATE `gameobject_template` SET `size` = 3, `data3` = 65536, `data10` = 54620, `data13` = 1, `data14` = 19700 WHERE `entry` = 191230;
UPDATE `gameobject_template` SET `size` = 2, `data3` = 65536, `data10` = 42953, `data13` = 1, `data14` = 19700 WHERE `entry` = 191229;

�� 1�1

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 16:01:56 +0400

�� 1�1

��:

INSERT INTO `battleground_template` VALUES ('1', '1', '40', '611', '2.72532', '610', '2.27452');
INSERT INTO `battleground_template` VALUES ('2', '1', '10', '769', '3.14159', '770', '3.14159');
INSERT INTO `battleground_template` VALUES ('3', '1', '15', '890', '3.40156', '889', '0.263892');
INSERT INTO `battleground_template` VALUES ('4', '1', '5', '929', '0', '936', '3.14159');
INSERT INTO `battleground_template` VALUES ('5', '1', '5', '939', '0', '940', '3.14159');
INSERT INTO `battleground_template` VALUES ('6', '1', '5', '0', '0', '0', '0');
INSERT INTO `battleground_template` VALUES ('7', '1', '15', '1103', '3.40156', '1104', '0.263892');
INSERT INTO `battleground_template` VALUES ('8', '1', '5', '1258', '0', '1259', '3.14159');
INSERT INTO `battleground_template` VALUES ('9', '1', '15', '1367', '0', '1368', '0');
INSERT INTO `battleground_template` VALUES ('10', '1', '5', '1362', '0', '1363', '0');
INSERT INTO `battleground_template` VALUES ('11', '1', '5', '1364', '0', '1365', '0');
INSERT INTO `battleground_template` VALUES ('30', '1', '40', '1485', '0', '1486', '0');
INSERT INTO `battleground_template` VALUES ('32', '1', '40', '0', '0', '0', '0');

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 16:01:23 +0400

�� 3-2 ��
��
��

��:

DELETE FROM `creature_loot_template` WHERE (`entry`=25840);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=29434);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 29434, 100, 0, 2, 2, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34233);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34233, 43, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=35283);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 35283, 43, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34430);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34430, 36, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=35284);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 35284, 36, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34429);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34429, 29, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34228);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34228, 29, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34215);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34215, 29, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34231);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34231, 21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34214);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34214, 21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=35282);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 35282, 21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34232);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34232, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34213);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34213, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34230);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34230, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34428);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34428, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34427);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34427, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=32227);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 32227, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34229);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34229, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34240);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34240, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34211);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34211, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34216);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34216, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34234);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34234, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34212);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34212, 7, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34664);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34664, 7, 0, 1, 1, 0, 0, 0);

Grand Warlock Alythess

��:

DELETE FROM `creature_loot_template` WHERE (`entry`=25166);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=29434);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 29434, 93, 0, 2, 2, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34664);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34664, 67, 0, 4, 0, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=35290);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 35290, 38, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=35291);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 35291, 35, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=35292);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 35292, 25, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34196);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34196, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34209);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34209, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34208);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34208, 23, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34210);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34210, 22, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34193);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34193, 22, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34194);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34194, 21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34202);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34202, 20, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34195);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34195, 20, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34206);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34206, 20, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34198);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34198, 20, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34204);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34204, 18, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34203);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34203, 17, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34192);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34192, 17, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34199);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34199, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34189);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34189, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34205);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34205, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34848);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34848, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34190);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34190, 14, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34857);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34857, 13, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34197);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34197, 13, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34858);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34858, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34852);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34852, 11, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34855);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34855, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34851);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34851, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34853);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34853, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34856);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34856, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34854);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34854, 8, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32229);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32229, 4, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32228);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32228, 4, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32231);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32231, 2, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32227);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32227, 1.4, 0, 1, 1, 0, 0, 0);

Kil'Jaeden

��:

DELETE FROM `creature_loot_template` WHERE (`entry`=25315);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=29434);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 29434, 24, 0, 3, 3, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34345);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34345, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34329);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34329, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34241);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34241, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34335);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34335, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34247);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34247, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34341);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34341, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34334);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34334, 15, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34333);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34333, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34245);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34245, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34332);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34332, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34339);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34339, 24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34340);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34340, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34244);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34244, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34337);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34337, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34331);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34331, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34344);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34344, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34342);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34342, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34243);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34243, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34336);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34336, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34242);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34242, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34343);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34343, 19, 0, 1, 1, 0, 0, 0);

Lady Sacrolash

��:

DELETE FROM `creature_loot_template` WHERE (`entry`=25165);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=29434);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 29434, 100, 0, 2, 2, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=35290);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 35290, 31, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=35292);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 35292, 28, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34190);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34190, 37, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34208);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34208, 22, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34203);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34203, 21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34851);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34851, 19, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34206);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34206, 18, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34858);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34858, 18, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34197);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34197, 18, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34199);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34199, 16, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34189);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34189, 16, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34192);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34192, 16, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34209);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34209, 16, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34202);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34202, 13, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34205);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34205, 13, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34204);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34204, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34848);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34848, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34196);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34196, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34194);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34194, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34195);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34195, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34193);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34193, 12, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34210);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34210, 10, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34853);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34853, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34855);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34855, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34856);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34856, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34857);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34857, 9, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34854);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34854, 6, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34852);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34852, 6, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34198);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34198, 6, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34664);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34664, 6, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=32227);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 32227, 1.5, 0, 1, 1, 0, 0, 0);

�.�. �.�. M'uru �� Entropius, �� Entropius, ��
�� mangos.ru

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:59:03 +0400

�� "��" �� , ��

��:

UPDATE `quest_template` SET `Method`=0 WHERE `entry`=���� ������;

�� , �� , �� . �� , �� . ��: �� ??? �� ??? �� .

��!!!
�� (�� -��)

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:58:10 +0400

�� : �� wowhead

��:

DELETE FROM `gameobject` WHERE `id`=191708;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio  n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(786349, 191708, 571, 1, 1, 7157.71, -722.593, 893.356, 1.51468, 0, 0, 0.686991, 0.726666, 25, 0, 1);

[Fix] ��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:56:50 +0400

��:

DELETE FROM `gameobject` WHERE `id`=179786;
DELETE FROM `gameobject` WHERE `id`=179831;
DELETE FROM `gameobject` WHERE `id`=179785;
DELETE FROM `gameobject` WHERE `id`=179830;
DELETE FROM `gameobject_template` WHERE `entry`=179786;
DELETE FROM `gameobject_template` WHERE `entry`=179831;
DELETE FROM `gameobject_template` WHERE `entry`=179785;
DELETE FROM `gameobject_template` WHERE `entry`=179830;
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (179786, 26, 5913, 'Warsong Flag', '', 0, 0, 2.5, 0, 0, 0, 131072, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (179831, 24, 5913, 'Warsong Flag', '', 210, 0, 2.5, 0, 23384, 11, 23335, 23389, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (179785, 26, 5912, 'Silverwing Flag', '', 0, 0, 2.5, 0, 0, 23383, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (179830, 24, 5912, 'Silverwing Flag', '', 1314, 0, 2.5, 0, 23383, 11, 23333, 23390, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

[Fixes] ��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:56:18 +0400

-- Alterac Valley Battlemaster

��:

DELETE FROM creature_template WHERE entry = 17506;
DELETE FROM creature WHERE id IN (19906, 19907);
INSERT INTO creature (id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras) VALUES
(19906, 0, 0, 0, 537.672, -1085.234, 106.339, 4.234, 180, 0, 0, 537.672, -1085.234, 106.339, 4.234, 5300, 0, 0, 0, ''),
(19907, 0, 0, 0, 102.679, -182.953, 127.548, 5.483, 180, 0, 0, 102.679, -182.953, 127.548, 5.483, 5100, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 20271;
UPDATE creature_template SET minhealth = 6400, maxhealth = 6400, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 7410;
UPDATE creature_template SET minhealth = 8500, maxhealth = 8500, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 12197;
UPDATE creature_template SET minhealth = 5100, maxhealth = 5100, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 19907;
UPDATE creature_template SET minhealth = 9700, maxhealth = 9700, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 20119;
UPDATE creature_template SET minhealth = 5400, maxhealth = 5400, npcflag = 2048, faction_A = 1216, faction_H = 1216 WHERE entry = 5118;
UPDATE creature_template SET minhealth = 5300, maxhealth = 5300, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 19906;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 20276;
UPDATE creature_template SET minhealth = 7700, maxhealth = 7700, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 16695;
UPDATE creature_template SET minhealth = 9100, maxhealth = 9100, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 347;
UPDATE creature_template SET minhealth = 6200, maxhealth = 6200, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 14942;
UPDATE creature_template SET minhealth = 6500, maxhealth = 6500, npcflag = 2048, faction_A = 1214, faction_H = 1214 WHERE entry = 7427;
UPDATE creature SET curhealth = 6700 WHERE id = 20271;
UPDATE creature SET spawntimesecs = 180, curhealth = 6400 WHERE id = 7410;
UPDATE creature SET spawntimesecs = 180, curhealth = 6500 WHERE id = 12197;
UPDATE creature SET spawntimesecs = 180, curhealth = 9700 WHERE id = 20119;
UPDATE creature SET spawntimesecs = 180, curhealth = 5400 WHERE id = 5118;
UPDATE creature SET curhealth = 7000 WHERE id = 20276;
UPDATE creature SET curhealth = 7700 WHERE id = 16695;
UPDATE creature SET spawntimesecs = 180, curhealth = 9100 WHERE id = 347;
UPDATE creature SET spawntimesecs = 180, curhealth = 6200 WHERE id = 14942;
UPDATE creature SET spawntimesecs = 180, curhealth = 6500 WHERE id = 7427

-- Arathi Basin Battlemaster

��:

DELETE FROM creature_template WHERE entry = 16711;
DELETE FROM creature WHERE id IN (19855, 19905);
INSERT INTO creature (id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras) VALUES
(19855, 0, 0, 0, -1198.507, -2532.533, 22.393, 3.177, 180, 0, 0, -1198.507, -2532.533, 22.393, 3.177, 9700, 0, 0, 0, ''),
(19905, 0, 0, 0, -817.882, -3510.191, 72.733, 3.786, 180, 0, 0, -817.882, -3510.191, 72.733, 3.786, 4200, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 3500, maxhealth = 3500, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 907;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 15008;
UPDATE creature_template SET minhealth = 9700, maxhealth = 9700, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 19855;
UPDATE creature_template SET minhealth = 7300, maxhealth = 7300, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 857;
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 20273;
UPDATE creature_template SET minhealth = 12000, maxhealth = 12000, npcflag = 2048, faction_A = 1577, faction_H = 1577 WHERE entry = 20120;
UPDATE creature_template SET minhealth = 3000, maxhealth = 3000, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 15007;
UPDATE creature_template SET minhealth = 4400, maxhealth = 4400, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 16694;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 20274;
UPDATE creature_template SET minhealth = 4200, maxhealth = 4200, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 15006;
UPDATE creature_template SET minhealth = 4200, maxhealth = 4200, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 19905;
UPDATE creature_template SET minhealth = 4100, maxhealth = 4100, npcflag = 2048, faction_A = 412, faction_H = 412 WHERE entry = 12198;
UPDATE creature SET spawntimesecs = 180, curhealth = 3500 WHERE id = 907;
UPDATE creature SET curhealth = 7000 WHERE id = 15008;
UPDATE creature SET spawntimesecs = 180, curhealth = 7300 WHERE id = 857;
UPDATE creature SET curhealth = 6700 WHERE id = 20273;
UPDATE creature SET curhealth = 12000 WHERE id = 20120;
UPDATE creature SET curhealth = 3000 WHERE id = 15007;
UPDATE creature SET curhealth = 4400 WHERE id = 16694;
UPDATE creature SET curhealth = 7000 WHERE id = 20274;
UPDATE creature SET spawntimesecs = 180, curhealth = 4200 WHERE id = 15006;
UPDATE creature SET curhealth = 4100 WHERE id = 12198;

-- Eye of the Storm Battlemaster

��:

DELETE FROM creature WHERE id IN (20381, 20385, 20386, 20388);
INSERT INTO creature (id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras) VALUES
(20381, 0, 0, 0, -8415.062, 284.552, 120.886, 0.495, 180, 0, 0, -8415.062, 284.552, 120.886, 0.495, 8200, 0, 0, 0, ''),
(20385, 1, 0, 0, 1987.411, -4802.022, 55.820, 2.168, 180, 0, 0, 1987.411, -4802.022, 55.820, 2.168, 7900, 0, 0, 0, ''),
(20386, 0, 0, 0, 1278.476, 285.318, -63.706, 1.267, 180, 0, 0, 1278.476, 285.318, -63.706, 1.267, 7100, 0, 0, 0, ''),
(20388, 1, 0, 0, -1400.021, -95.095, 158.934, 0.289, 180, 0, 0, -1400.021, -95.095, 158.934, 0.289, 9900, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 8200, maxhealth = 8200, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20381;
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20362;
UPDATE creature_template SET minhealth = 13000, maxhealth = 13000, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20382;
UPDATE creature_template SET minhealth = 6500, maxhealth = 6500, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20374;
UPDATE creature_template SET minhealth = 7000, maxhealth = 7000, npcflag = 2048, faction_A = 534, faction_H = 534 WHERE entry = 20383;
UPDATE creature_template SET minhealth = 6700, maxhealth = 6700, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20384;
UPDATE creature_template SET minhealth = 9900, maxhealth = 9900, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20388;
UPDATE creature_template SET minhealth = 7900, maxhealth = 7900, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20385;
UPDATE creature_template SET minhealth = 10000, maxhealth = 10000, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20390;
UPDATE creature_template SET minhealth = 7100, maxhealth = 7100, npcflag = 2048, faction_A = 83, faction_H = 83 WHERE entry = 20386;
UPDATE creature SET curhealth = 6700 WHERE id = 20362;
UPDATE creature SET spawntimesecs = 180, curhealth = 13000 WHERE id = 20382;
UPDATE creature SET spawntimesecs = 180, curhealth = 6500 WHERE id = 20374;
UPDATE creature SET spawntimesecs = 180, curhealth = 7000 WHERE id = 20383;
UPDATE creature SET curhealth = 6700 WHERE id = 20384;
UPDATE creature SET curhealth = 10000 WHERE id = 20390;

-- Warsong Gulch Battlemaster

��:

DELETE FROM creature_template WHERE entry IN (17507, 20002);
DELETE FROM creature WHERE id IN (19908, 19910);
INSERT INTO creature (id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras) VALUES
(19908, 1, 0, 0, 1434.383, -1856.436, 133.574, 6.200, 180, 0, 0, 1434.383, -1856.436, 133.574, 6.200, 1800, 0, 0, 0, ''),
(19910, 1, 0, 0, 1034.386, -2093.156, 124.765, 4.668, 180, 0, 0, 1034.386, -2093.156, 124.765, 4.668, 1500, 0, 0, 0, '');
UPDATE creature_template SET minhealth = 7900, maxhealth = 7900, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 20118;
UPDATE creature_template SET minhealth = 7400, maxhealth = 7400, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 14982;
UPDATE creature_template SET minhealth = 6600, maxhealth = 6600, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 20272;
UPDATE creature_template SET minhealth = 3700, maxhealth = 3700, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 14981;
UPDATE creature_template SET minhealth = 2700, maxhealth = 2700, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 2302;
UPDATE creature_template SET minhealth = 1800, maxhealth = 1800, npcflag = 2048, faction_A = 1514, faction_H = 1514 WHERE entry = 19908;
UPDATE creature_template SET minhealth = 1500, maxhealth = 1500, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 19910;
UPDATE creature_template SET minhealth = 7100, maxhealth = 7100, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 20269;
UPDATE creature_template SET minhealth = 3800, maxhealth = 3800, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 3890;
UPDATE creature_template SET minhealth = 3200, maxhealth = 3200, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 10360;
UPDATE creature_template SET minhealth = 1800, maxhealth = 1800, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 16696;
UPDATE creature_template SET minhealth = 2400, maxhealth = 2400, npcflag = 2048, faction_A = 1641, faction_H = 1641 WHERE entry = 2804;
UPDATE creature SET spawntimesecs = 180, curhealth = 7900 WHERE id = 20118;
UPDATE creature SET spawntimesecs = 180, curhealth = 7400 WHERE id = 14982;
UPDATE creature SET curhealth = 6600 WHERE id = 20272;
UPDATE creature SET curhealth = 3700 WHERE id = 14981;
UPDATE creature SET spawntimesecs = 180, curhealth = 2700 WHERE id = 2302;
UPDATE creature SET curhealth = 7100 WHERE id = 20269;
UPDATE creature SET spawntimesecs = 180, curhealth = 3800 WHERE id = 3890;
UPDATE creature SET spawntimesecs = 180, curhealth = 3200 WHERE id = 10360;
UPDATE creature SET curhealth = 1800 WHERE id = 16696;
UPDATE creature SET spawntimesecs = 180, curhealth = 2400 WHERE id = 2804;

SQL ��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:54:11 +0400

��, �� , �� .�. �� , �� .
�� , � �� depositfiles.com ss

�� http://depositfiles.com/files/vrmpicr3z

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:53:46 +0400

�� ....

��:

DELETE FROM `creature_questrelation` WHERE `quest` = 5290;     
DELETE FROM `gameobject_questrelation` WHERE `quest` = 5290;     
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (29194, 5290);     
UPDATE `creature_template` SET `npcflag`= 2  WHERE `entry` = 29194;     
DELETE FROM `creature_involvedrelation` WHERE `quest` = 5290;     
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 5290;     
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29194, 5290);     
DELETE FROM `quest_template` WHERE `entry` = 5290;     
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`)     
VALUES (5290, 2, 0, 6, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46, 0, 0, 0, 0, 0, 0, 0, '46 Talantes DK!!!', 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

spell_script_target

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:53:06 +0400

insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '51959','1','28161');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '52908','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '51840','1','28466');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '52793','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '51152','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '52791','1','28408');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '54323','1','29338');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '32087','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '48287','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '46222','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '48345','1','0');
insert into `spell_script_target`(`entry`,`type`,`targetEntry`) values ( '59008','1','0');

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:52:33 +0400

�� 3 �� 90%
�� :)
http://depositfiles.com/files/zwyecyggf

[YTDB]Thunder bluff mailbox

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:52:02 +0400

��:

DELETE FROM gameobject WHERE guid = '157077';

�� 3.0.3

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:51:34 +0400

�� , �� , �� 1 ��.
�� , �� :

��:

UPDATE `gameobject_template` SET `type` = 6 WHERE `entry` = 191539;
UPDATE `gameobject_template` SET `type` = 6 WHERE `entry` = 191538;

�� 3.1.3

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:50:49 +0400

��:

update quest_template set questflags=0, ReqCreatureOrGoid1=0, ReqCreatureOrGoid2=0, ReqCreatureOrGoid3=0, ReqCreatureOrGoid4=0, ReqCreatureOrGoCount1=0, ReqCreatureOrGoCount2=0, ReqCreatureOrGoCount3=0, ReqCreatureOrGoCount4=0 where entry=12641;
update creature_template set faction_A=122, faction_H=122 where entry=29611;
update creature_template set faction_A=126, faction_H=126 where entry=4949;
insert into creature_ai_scripts values
('2855701','28557','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Peasant - Quest Kill Credit'),
('2857601','28576','6','0','100','0','0','0','0','0','33','28764','6','0','0','0','0','0','0','0','0','0','Citizen of Havenshire - Quest Kill Credit'),
('2857701','28577','6','0','100','0','0','0','0','0','33','28764','6','0','0','0','0','0','0','0','0','0','Citizen of Havenshire - Quest Kill Credit'),
('2860801','28608','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Medic - Quest Kill Credit'),
('2860901','28609','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Infantryman - Quest Kill Credit'),
('2861001','28610','8','0','100','0','52781','-1','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Set Phase 1 on Spell Hit'),
('2861002','28610','0','510','100','0','0','0','0','0','31','2','8','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Random In-Combat Say (Phase 1)'),
('2861003','28610','0','509','100','0','0','0','0','0','1','-555','0','0','20','0','0','0','18','2','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861004','28610','0','509','100','0','5000','5000','0','0','1','-556','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861005','28610','0','509','100','0','14000','14000','0','0','1','-557','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861006','28610','0','509','100','0','20000','20000','0','0','1','-558','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861007','28610','0','509','100','0','30000','30000','0','0','1','-559','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say (Phase 2)'),
('2861008','28610','6','509','100','0','31500','34000','0','0','26','12720','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Quest Event on Death (Phase 2)'),
('2861009','28610','0','509','100','0','32000','32000','0','0','37','0','0','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Die (Phase 2)'),
('2861010','28610','0','507','100','0','0','0','0','0','1','-560','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 3)'),
('2861011','28610','0','503','100','0','0','0','0','0','1','-561','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 4)'),
('2861012','28610','0','495','100','0','0','0','0','0','1','-562','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 5)'),
('2861013','28610','0','479','100','0','0','0','0','0','1','-563','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 6)'),
('2861014','28610','0','447','100','0','0','0','0','0','1','-564','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 7)'),
('2861015','28610','0','383','100','0','0','0','0','0','1','-565','0','0','22','0','0','0','0','0','0','0','Scarlet Marksman - In-Combat Say and Set Phase 0 (Phase 8)'),
('2861016','28610','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Marksman - Quest Kill Credit'),
('2861101','28611','6','0','100','0','0','0','0','0','33','28763','6','0','0','0','0','0','0','0','0','0','Scarlet Captain - Quest Kill Credit'),
('2883401','28834','6','0','100','0','0','0','0','0','33','28849','6','0','0','0','0','0','0','0','0','0','Scarlet Fleet Defender - Quest Kill Credit'),
('2885601','28856','6','0','100','0','0','0','0','0','33','28849','6','0','0','0','0','0','0','0','0','0','Scarlet Fleet Guardian - Quest Kill Credit'),
('2893601','28936','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Commander - Quest Kill Credit'),
('2893901','28939','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Preacher - Quest Kill Credit'),
('2894001','28940','6','0','100','0','0','0','0','0','33','28984','6','0','0','0','0','0','0','0','0','0','Scarlet Crusader - Quest Kill Credit'),
('2894101','28941','6','0','100','0','0','0','0','0','33','28986','6','0','0','0','0','0','0','0','0','0','Citizen of New Avalon - Quest Kill Credit'),
('2894201','28942','6','0','100','0','0','0','0','0','33','28986','6','0','0','0','0','0','0','0','0','0','Citizen of New Avalon - Quest Kill Credit'),
('2910201','29102','6','0','100','0','0','0','0','0','33','29150','6','0','0','0','0','0','0','0','0','0','Hearthglen Crusader - Quest Kill Credit'),
('2910301','29103','6','0','100','0','0','0','0','0','33','29150','6','0','0','0','0','0','0','0','0','0','Hearthglen Crusader - Quest Kill Credit'),
('3109501','31095','6','0','100','0','0','0','0','0','33','31100','6','0','0','0','0','0','0','0','0','0','Valkyr Battle-maiden - Quest Kill Credit'),
('3109601','31096','6','0','100','0','0','0','0','0','33','31100','6','0','0','0','0','0','0','0','0','0','Scourge Necromancer - Quest Kill Credit'),
('3109801','31098','6','0','100','0','0','0','0','0','33','31100','6','0','0','0','0','0','0','0','0','0','Terrifying Abomination - Quest Kill Credit');
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` IN (28557,28576,28577,28608,28609,28610,28611,28834,28856,28936,28939,28940,28941,28942,29102,29103,31095,31096,31098);
UPDATE `creature_template` SET `ScriptName`='' WHERE (`ScriptName`='generic_creature' AND `AIName`='EventAI');

�� "StatsCount" �� .

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:50:03 +0400

��:

UPDATE `item_template` SET `StatsCount`=1 WHERE `stat_type1`>0 AND `stat_value1`>0;
UPDATE `item_template` SET `StatsCount`=2 WHERE `stat_type2`>0 AND `stat_value2`>0;
UPDATE `item_template` SET `StatsCount`=3 WHERE `stat_type3`>0 AND `stat_value3`>0;
UPDATE `item_template` SET `StatsCount`=4 WHERE `stat_type4`>0 AND `stat_value4`>0;
UPDATE `item_template` SET `StatsCount`=5 WHERE `stat_type5`>0 AND `stat_value5`>0;
UPDATE `item_template` SET `StatsCount`=6 WHERE `stat_type6`>0 AND `stat_value6`>0;
UPDATE `item_template` SET `StatsCount`=7 WHERE `stat_type7`>0 AND `stat_value7`>0;
UPDATE `item_template` SET `StatsCount`=8 WHERE `stat_type8`>0 AND `stat_value8`>0;
UPDATE `item_template` SET `StatsCount`=9 WHERE `stat_type9`>0 AND `stat_value9`>0;
UPDATE `item_template` SET `StatsCount`=10 WHERE `stat_type10`>0 AND `stat_value10`>0;

��
��
�� +1 ��

�� !

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:47:37 +0400

�� ! �� (��) �� ! �� !
�� , �� .
�� - �� . ��: �� /��/�� - �� .
�� - �� . ��: �� , �� .
��! �� !

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:47:01 +0400

��:

�� .
�� .

�� :

�� : ��, �� .�. ��
�� , ��, �� , �� . �� : ��, ��, �� .�. �� , ��
�� , �� , �� (��), �� CAPS LOCK (�� ).
�� . �� : �� , �� /c�� - 127.0.0.1�
�� , �� , � �� , �� . � ��, �� "��", �� .
�� . �� -�� , �� .
�� (icq, skype, email) �� .

�� Mangos�

�� , �� . �� , �� , � �� .
�� .
��
�� - ��, �� , ��
� �� .

��

��(�� 300�) [10] [10]

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:44:49 +0400

��
. �� , � ��!
�� .� �� !
�� 300� (�� )
��

�� 50� ( �� )
��

�� 40� ( �� )
��

�� 15� ( �� )
��

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:42:56 +0400

�� !!!
�� :
20�
95�
150�
�� )))
��

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:42:12 +0400

�� 10 ��

��

mybb@mybb.ru (Andrqha) — Sun, 07 Aug 2011 15:41:38 +0400

��:

�� .
�� .

�� :

�� Mangos�

�� , �� , � �� , �� .�. �� , �� , � �� .
�� .
��
�� - �� , �� , ��
��

��

�� .

WoW-ExStReMe

��� ��� �� ��������� �����: 3D ������

������� �� ��� � �� ������

��������� � Shattrath City

���� �� ������� ��.

������ � ������� fix ��������

���� ��� ����������� ������ �� 1�1

���� �� ���� � �������

��� �� �����

���������� ����� �� ������ ������

[Fix] ����� �� ���

[Fixes] ������� ��

SQL ��� ����������

��� ��� �������� ������

spell_script_target

����� �������

[YTDB]Thunder bluff mailbox

���� ���� ��������� � �� �� 3.0.3

����� �� �� � ���� �� �� 3.1.3

���� "StatsCount" ������� ��� ���� ���������.

������� ����� ������� � �������!

��������� �������

�������(�� 300�) [10] [10]

������� � ��������� �������

����� �� ���� �������

������ ����������

�� : 3D ��

��

�� Shattrath City

�� .

�� fix ��

�� 1�1

��

��

��

[Fix] ��

[Fixes] ��

SQL ��

��

��

�� 3.0.3

�� 3.1.3

�� "StatsCount" �� .

�� !

��

��(�� 300�) [10] [10]

��

��

��