|
|
Модератор форума: staford11 |
Форум CMaNGOS Патчи / Моды / Фиксы CMaNGOS Скрипты для Фан сервера |
Скрипты для Фан сервера |
Вот скриптик на 46 талов ДК (КВЕСТ), я его вешал на тренера дк (Amal'thazad)!!!
Code 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); Низнаю боян или нет. Но кто будет юзать запрос на квест на все таланты ДК, сначала советую выполнить такой запрос: Code UPDATE FROM `quest_template` SET `BonusTalents` = 0 WHERE `BonusTalents` > 0; --------------------------------------------- Code /* MySQL Backup Source Host: localhost Source Server Version: 5.0.37-community-nt Source Database: mangos Date: 2008.10.13 17:19:15 */ SET FOREIGN_KEY_CHECKS=0; use mangos; #---------------------------- # Table structure for 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 for table playercreateinfo #---------------------------- insert into playercreateinfo values (1, 1, 0, 1519, '-8964.6', '513.078', '96.3554'), (1, 2, 0, 1519, '-8964.6', '513.078', '96.3554'), (1, 4, 0, 1519, '-8964.6', '513.078', '96.3554'), (1, 5, 0, 1519, '-8964.6', '513.078', '96.3554'), (1, 8, 0, 1519, '-8964.6', '513.078', '96.3554'), (1, 9, 0, 1519, '-8964.6', '513.078', '96.3554'), (2, 1, 1, 1637, '1470.97', '-4418.7', '25.2355'), (2, 3, 1, 1637, '1470.97', '-4418.7', '25.2355'), (2, 4, 1, 1637, '1470.97', '-4418.7', '25.2355'), (2, 7, 1, 1637, '1470.97', '-4418.7', '25.2355'), (2, 9, 1, 1637, '1470.97', '-4418.7', '25.2355'), (3, 1, 0, 1519, '-8964.6', '513.078', '96.3554'), (3, 2, 0, 1519, '-8964.6', '513.078', '96.3554'), (3, 3, 0, 1519, '-8964.6', '513.078', '96.3554'), (3, 4, 0, 1519, '-8964.6', '513.078', '96.3554'), (3, 5, 0, 1519, '-8964.6', '513.078', '96.3554'), (4, 1, 0, 1519, '-8964.6', '513.078', '96.3554'), (4, 3, 0, 1519, '-8964.6', '513.078', '96.3554'), (4, 4, 0, 1519, '-8964.6', '513.078', '96.3554'), (4, 5, 0, 1519, '-8964.6', '513.078', '96.3554'), (4, 11, 0, 1519, '-8964.6', '513.078', '96.3554'), (5, 1, 1, 1637, '1470.97', '-4418.7', '25.2355'), (5, 4, 1, 1637, '1470.97', '-4418.7', '25.2355'), (5, 5, 1, 1637, '1470.97', '-4418.7', '25.2355'), (5, 8, 1, 1637, '1470.97', '-4418.7', '25.2355'), (5, 9, 1, 1637, '1470.97', '-4418.7', '25.2355'), (6, 1, 1, 1637, '1470.97', '-4418.7', '25.2355'), (6, 3, 1, 1637, '1470.97', '-4418.7', '25.2355'), (6, 7, 1, 1637, '1470.97', '-4418.7', '25.2355'), (6, 11, 1, 1637, '1470.97', '-4418.7', '25.2355'), (7, 1, 0, 1519, '-8964.6', '513.078', '96.3554'), (7, 4, 0, 1519, '-8964.6', '513.078', '96.3554'), (7, 8, 0, 1519, '-8964.6', '513.078', '96.3554'), (7, 9, 0, 1519, '-8964.6', '513.078', '96.3554'), (8, 1, 1, 1637, '1470.97', '-4418.7', '25.2355'), (8, 3, 1, 1637, '1470.97', '-4418.7', '25.2355'), (8, 4, 1, 1637, '1470.97', '-4418.7', '25.2355'), (8, 5, 1, 1637, '1470.97', '-4418.7', '25.2355'), (8, 7, 1, 1637, '1470.97', '-4418.7', '25.2355'), (8, 8, 1, 1637, '1470.97', '-4418.7', '25.2355'), (10, 2, 1, 1637, '1470.97', '-4418.7', '25.2355'), (10, 3, 1, 1637, '1470.97', '-4418.7', '25.2355'), (10, 4, 1, 1637, '1470.97', '-4418.7', '25.2355'), (10, 5, 1, 1637, '1470.97', '-4418.7', '25.2355'), (10, 8, 1, 1637, '1470.97', '-4418.7', '25.2355'), (10, 9, 1, 1637, '1470.97', '-4418.7', '25.2355'), (11, 1, 0, 1519, '-8964.6', '513.078', '96.3554'), (11, 2, 0, 1519, '-8964.6', '513.078', '96.3554'), (11, 3, 0, 1519, '-8964.6', '513.078', '96.3554'), (11, 5, 0, 1519, '-8964.6', '513.078', '96.3554'), (11, 7, 0, 1519, '-8964.6', '513.078', '96.3554'), (11, 8, 0, 1519, '-8964.6', '513.078', '96.3554'); Выкладуем сюда все для фан серверов (буду переделывать для любой версий) за 10р=) |
steks, млять это патч на ядро!
Сообщение # 3 написано 08.05.2010 в 01:15
|
| |||
| |||