elite*gold: 0
Join Date: Jan 2010
Posts: 55
Received Thanks: 15
|
DELETE FROM `quest_template` WHERE `entry` = '99990';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99990', '876', '1', '1', '1101', '136', '1', 'port nach sw', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99990');
DELETE FROM `quest_end_scripts` WHERE `id` = '99990';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99990', '0', '6', '0', '-8833.164063', '479.762543', '112.095619', '0.587327');
DELETE FROM `quest_template` WHERE `entry` = '99901';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99901', '876', '1', '1', '1101', '136', '1', 'port nach if', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99901');
DELETE FROM `quest_end_scripts` WHERE `id` = '99901';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99901', '0', '6', '0', '-4821.613281', '-1155.579468', '502.212250', '3.335226');
DELETE FROM `quest_template` WHERE `entry` = '99902';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99902', '876', '1', '1', '1101', '136', '1', 'port nach darnassus', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99902');
DELETE FROM `quest_end_scripts` WHERE `id` = '99902';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99902', '0', '6', '1', '9947.525391', '2604.150879', '1316.187988', '4.223004');
DELETE FROM `quest_template` WHERE `entry` = '99903';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99903', '876', '1', '1', '1101', '136', '1', 'port nach exodar', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99903');
DELETE FROM `quest_end_scripts` WHERE `id` = '99903';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99903', '0', '6', '530', '-4054.751709', '-11793.398438', '11.113947', '1.515031');
DELETE FROM `quest_template` WHERE `entry` = '99904';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99904', '876', '1', '1', '690', '136', '1', 'port nach orgrimmar', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99904');
DELETE FROM `quest_end_scripts` WHERE `id` = '99904';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99904', '0', '6', '1', '1677.910400', '-4314.788574', '62.500027', '2.669688');
DELETE FROM `quest_template` WHERE `entry` = '99905';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99905', '876', '1', '1', '690', '136', '1', 'port nach donnerfels', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', 'Du bist dir sicher das du teleportiert werden willst?', '0', '99905');
DELETE FROM `quest_end_scripts` WHERE `id` = '99905';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99905', '0', '6', '1', '-1197.183716', '29.270617', '179.754837', '2.966604');
DELETE FROM `quest_template` WHERE `entry` = '99906';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99906', '876', '1', '1', '690', '136', '1', 'port nach unterstadt', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99906');
DELETE FROM `quest_end_scripts` WHERE `id` = '99906';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99906', '0', '6', '0', '1568.478760', '268.519928', '-42.138416', '1.697186');
DELETE FROM `quest_template` WHERE `entry` = '99907';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99907', '876', '1', '1', '690', '136', '1', 'port nach silbermond', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99907');
DELETE FROM `quest_end_scripts` WHERE `id` = '99907';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99907', '0', '6', '530', '9373.077148', '-7166.074219', '11.476312', '5.386526');
DELETE FROM `quest_template` WHERE `entry` = '99908';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99908', '876', '60', '70', '0', '136', '1', 'port nach shattrath', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99908');
DELETE FROM `quest_end_scripts` WHERE `id` = '99908';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99908', '0', '6', '530', '-1879.500977', '5409.461426', '-12.427713', '1.033202');
DELETE FROM `quest_template` WHERE `entry` = '99909';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99909', '876', '1', '70', '0', '136', '1', 'port zur gurubashi arena', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99909');
DELETE FROM `quest_end_scripts` WHERE `id` = '99909';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99909', '0', '6', '0', '-13234.119141', '217.386627', '31.675938', '1.068150');
DELETE FROM `quest_template` WHERE `entry` = '99910';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99910', '876', '1', '70', '0', '136', '1', 'port nach dalaran', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99910');
DELETE FROM `quest_end_scripts` WHERE `id` = '99910';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99910', '0', '6', '571', '5807.82', '645.0798', '647.55', '4.05597');
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('999900', '21661', '21661', '21661', '21661', "Teleporter", "Porter", '78', '85', '1000000', '1000000', '10000', '10000', '3000', '35', '35', '2', '8.00', '1.5', '1', '1200', '2000', '2000', '0', '10', '55', '55', '55', '55', '55', '55', '500000', '500000');
DELETE FROM `creature_questrelation` WHERE `id` = '999900';
DELETE FROM `creature_involvedrelation` WHERE `id` = '999900';
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99900');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99901');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99902');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99903');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99904');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99905');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99906');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99907');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99908');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99909');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99910');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99900');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99901');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99902');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99903');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99904');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99905');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99906');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99907');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91208');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91209');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91210');
viel spaß =)
|