How are you with SQL? im trying to make a Warp npc for my server but im not douing a very good gob at it
iv tried a C++ one and a SQL one, my sql one almost works but its a mess, fancy a go at fixingit for me?
Code:
DELETE FROM `quest_template` WHERE `entry` = '93000';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93000', '3459', '1', '70', '1101', '1', 'Teleport to Stormwind', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93000');
DELETE FROM `quest_end_scripts` WHERE `id` = '93000';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93000', '0', '6', '', '0', '-8833.164063', '479.762543', '112.095619', '0.587327');
/* Ironforge Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93001';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93001', '3459', '1', '70', '1101', '1', 'Teleport to Ironforge', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93001');
DELETE FROM `quest_end_scripts` WHERE `id` = '93001';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93001', '0', '6', '', '0', '-4821.613281', '-1155.579468', '502.212250', '3.335226');
/* Darnassus Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93002';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93002', '3459', '1', '70', '1101', '1', 'Teleport to Darnassus', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93002');
DELETE FROM `quest_end_scripts` WHERE `id` = '93002';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93002', '0', '6', '', '1', '9947.525391', '2604.150879', '1316.187988', '4.223004');
/* Exodar Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93003';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93003', '3459', '1', '70', '1101', '1', 'Teleport to Exodar', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93003');
DELETE FROM `quest_end_scripts` WHERE `id` = '93003';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93003', '0', '6', '', '530', '-4054.751709', '-11793.398438', '11.113947', '1.515031');
/* Orgrimmar Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93004';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93004', '3459', '1', '70', '690', '1', 'Teleport to Orgrimmar', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93004');
DELETE FROM `quest_end_scripts` WHERE `id` = '93004';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93004', '0', '6', '', '1', '1677.910400', '-4314.788574', '62.500027', '2.669688');
/* Thunder Bluff Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93005';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93005', '3459', '1', '70', '690', '1', 'Teleport to Thunder Bluff', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93005');
DELETE FROM `quest_end_scripts` WHERE `id` = '93005';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93005', '0', '6', '', '1', '-1197.183716', '29.270617', '179.754837', '2.966604');
/* Undercity Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93006';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93006', '3459', '1', '70', '690', '1', 'Teleport to Undercity', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93006');
DELETE FROM `quest_end_scripts` WHERE `id` = '93006';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93006', '0', '6', '', '0', '1568.478760', '268.519928', '-42.138416', '1.697186');
/* Silvermoon Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93007';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93007', '3459', '1', '70', '690', '1', 'Teleport to Silvermoon', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93007');
DELETE FROM `quest_end_scripts` WHERE `id` = '93007';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93007', '0', '6', '', '530', '9373.077148', '-7166.074219', '11.476312', '5.386526');
/* Shattrath Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93008';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93008', '3459', '1', '70', '0', '1', 'Teleport to Shattrath', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93008');
DELETE FROM `quest_end_scripts` WHERE `id` = '93008';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93008', '0', '6', '', '530', '-1879.500977', '5409.461426', '-12.427713', '1.033202');
/* Gurubashi Arena Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93009';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93009', '3459', '1', '70', '0', '1', 'Teleport to Gurubashi Arena', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93009');
DELETE FROM `quest_end_scripts` WHERE `id` = '93009';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93009', '0', '6', '', '0', '-13234.119141', '217.386627', '31.675938', '1.068150');
/* Project Chaos Mall Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93010';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93010', '3459', '1', '70', '0', '1', 'Teleport to the Mall', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93010');
DELETE FROM `quest_end_scripts` WHERE `id` = '93010';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93010', '0', '6', '', '0', '6168.844238', '-59.702732', '388.177429', '1.921232');
/* The nexus Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93011';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93011', '3459', '1', '70', '0', '1', 'Teleport to the nexus', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93011');
DELETE FROM `quest_end_scripts` WHERE `id` = '93011';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93011', '0', '6', '', '0', '3891.766113', '6985.067383', '69.488747', '0.033922');
/* Dalaran Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93012';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93012', '3459', '1', '70', '0', '1', 'Teleport to dalaran', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93012');
DELETE FROM `quest_end_scripts` WHERE `id` = '93012';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93012', '0', '6', '', '0', '5809.048340', '494.794434', '650.250366', '1.512823');
/* Utgarde Pinnacle Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93013';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93013', '3459', '1', '70', '0', '1', 'Teleport to Utgarde Pinnacle', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93013');
DELETE FROM `quest_end_scripts` WHERE `id` = '93013';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93013', '0', '6', '', '0', '1258.589966', '-4852.410156', '214.839996', '3.501108');
/* Utgarde Keep Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93014';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93014', '3459', '1', '70', '0', '1', 'Teleport to Utgarde Keep', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93014');
DELETE FROM `quest_end_scripts` WHERE `id` = '93014';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93014', '0', '6', '', '0', '1214.013306', '-4866.510254', '41.247601', '0.272894');
/* Drak'Tharon Keep Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93015';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93015', '3459', '1', '70', '0', '1', 'Teleport to Drak'Tharon Keep', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93015');
DELETE FROM `quest_end_scripts` WHERE `id` = '93015';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93015', '0', '6', '', '0', '4759.188965', '-2045.868530', '299.393707', '6.253711');
/* Icecrown Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93016';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93016', '3459', '1', '70', '0', '1', 'Teleport to Icecrown', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93016');
DELETE FROM `quest_end_scripts` WHERE `id` = '93016';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('3016', '0', '6', '', '0', '6523.508301', '2417.283691', '455.459045', '3.561115');
/* Halls of Stone Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93017';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93017', '3459', '1', '70', '0', '1', 'Teleport to Halls of Stone', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93017');
DELETE FROM `quest_end_scripts` WHERE `id` = '93017';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93017', '0', '6', '', '0', '1152', '803', '196', '599');
/* Halls of Lightning Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '93018';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('93018', '3459', '1', '70', '0', '1', 'Teleport to Halls of Lightning', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '93018');
DELETE FROM `quest_end_scripts` WHERE `id` = '93018';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('93018', '0', '6', '', '0', '1340', '264', '53', '602');
/* Teleport Master NPC */
DELETE FROM `creature_template` WHERE `entry` = '91200';
INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `faction_A`, `faction_H`, `npcflag`, `speed`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `rangeattacktime`, `minrangedmg`, `maxrangedmg`, `type`, `civilian`, `InhabitType`, `RegenHealth`) VALUES ('91200', '24930', '24930', 'Toni', 'Teleport Master', '80', '80', '5000', '5000', '35', '35', '2', '1', '50', '200', '500', '1500', '1500', '50', '100', '7', '1', '3', '1');
DELETE FROM `creature_questrelation` WHERE `id` = '91200';
DELETE FROM `creature_involvedrelation` WHERE `id` = '91200';
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93000');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93001');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93002');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93003');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93004');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93005');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93006');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93007');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93008');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93009');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93010');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93011');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93012');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93013');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93014');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93015');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93016');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93017');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '93018');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93000');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93001');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93002');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93003');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93004');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93005');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93006');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93007');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93008');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93009');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93010');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93011');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93012');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93013');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93014');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93015');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93016');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '93017');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91218');