Oceanic Trader Example

Oceanic Trader.sql

-- Oceanic Trader
SET @OCEANTRADER_ENTRY:=441101;
SET @OCEANTRADER_NAME:='Oceanic Trader';
SET @OCEANTRADER_DISPLAYID:=1985; -- Guard

DELETE FROM `creature_template` WHERE (`entry` = @OCEANTRADER_ENTRY);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `speed_swim`, `speed_flight`, `detection_range`, `scale`, `rank`, `dmgschool`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
(@OCEANTRADER_ENTRY, 0, 0, 0, 0, 0, @OCEANTRADER_DISPLAYID, 0, 0, 0, @OCEANTRADER_NAME, NULL, NULL, 0, 1, 1, 0, 35, 3, 1, 1.14286, 1, 1, 20, 1, 0, 0, 1, 2000, 2000, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 0, '', -1);



 -- Oceanic Trader Example Quest 1
SET @OCEANTRADER_EXQ1_ENTRY:=441102;
SET @OCEANTRADER_EXQ1_TITLE:='Swift Spectral Tiger';
SET @OCEANTRADER_EXQ1_REQUESTTEXT:='Give me 2500 tokens or else.';
SET @OCEANTRADER_EXQ1_REWARDTEXT:='Thank you for the tokens.';
SET @OCEANTRADER_EXQ1_REWARDITEM:=33225; -- Reins of the Swift Spectral Tiger (Untradable)
SET @OCEANTRADER_EXQ1_REWARDCOUNT:=1;
SET @OCEANTRADER_EXQ1_CURRENCYCOSTITEM:=37711; -- Currency Token Test Token 1
SET @OCEANTRADER_EXQ1_CURRENCYCOUNT:=2500;

DELETE FROM `quest_template` WHERE (`ID` = @OCEANTRADER_EXQ1_ENTRY);
INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardBonusMoney`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `RequiredPlayerKills`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `ItemDrop1`, `ItemDropQuantity1`, `ItemDrop2`, `ItemDropQuantity2`, `ItemDrop3`, `ItemDropQuantity3`, `ItemDrop4`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardTalents`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`) VALUES
(@OCEANTRADER_EXQ1_ENTRY, 0, 80, 1, 344, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, @OCEANTRADER_EXQ1_REWARDITEM, @OCEANTRADER_EXQ1_REWARDCOUNT, 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, @OCEANTRADER_EXQ1_TITLE, '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, @OCEANTRADER_EXQ1_CURRENCYCOSTITEM, 0, 0, 0, 0, 0, @OCEANTRADER_EXQ1_CURRENCYCOUNT, 0, 0, 0, 0, 0, 1, '', '', '', '', 1);
DELETE FROM `quest_template_addon` WHERE (`ID` = @OCEANTRADER_EXQ1_ENTRY);

INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES
(@OCEANTRADER_EXQ1_ENTRY, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);

DELETE FROM `creature_queststarter` WHERE (`quest` = @OCEANTRADER_EXQ1_ENTRY);
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
(@OCEANTRADER_ENTRY, @OCEANTRADER_EXQ1_ENTRY);

DELETE FROM `creature_questender` WHERE (`quest` = @OCEANTRADER_EXQ1_ENTRY);
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
(@OCEANTRADER_ENTRY, @OCEANTRADER_EXQ1_ENTRY);

DELETE FROM `quest_offer_reward` WHERE (`ID` = @OCEANTRADER_EXQ1_ENTRY);
INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
(@OCEANTRADER_EXQ1_ENTRY, 0, 0, 0, 0, 0, 0, 0, 0, @OCEANTRADER_EXQ1_REWARDTEXT, 0);

DELETE FROM `quest_request_items` WHERE (`ID` = @OCEANTRADER_EXQ1_ENTRY);
INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `CompletionText`, `VerifiedBuild`) VALUES
(@OCEANTRADER_EXQ1_ENTRY, 0, 0, @OCEANTRADER_EXQ1_REQUESTTEXT, 0);