﻿
INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES
(108, '2007-08-12 19:00:00', '2020-12-31 00:00:00', 1440, 60, 'Cravchick want to eat');

INSERT INTO `game_event_creature` VALUES
(4455493, 108),
(4455495, 108),
(4455498, 108),
(4455499, 108),
(4455500, 108),
(4455501, 108),
(4455502, 108),
(4455503, 108),
(4455504, 108),
(4455505, 108),
(4455506, 108),
(4455507, 108),
(4455508, 108),
(4455509, 108),
(4455510, 108),
(4455511, 108),
(4455512, 108),
(4455513, 108),
(4455514, 108),
(4455515, 108),
(4455516, 108),
(4455517, 108),
(4455518, 108),
(4455519, 108),
(4455520, 108),
(4455521, 108),
(4455522, 108),
(4455523, 108),
(4455524, 108),
(4455525, 108),
(4455526, 108),
(4455527, 108),
(4455528, 108),
(4455529, 108),
(4455531, 108),
(4455532, 108),
(4455533, 108),
(4455534, 108),
(4455535, 108),
(4455536, 108),
(4455537, 108),
(4455538, 108),
(4455539, 108),
(4455540, 108),
(4455541, 108),
(4455542, 108),
(4455543, 108),
(4455544, 108),
(4455545, 108),
(4455546, 108),
(4455547, 108),
(4455548, 108),
(4455549, 108),
(4455550, 108),
(4455551, 108),
(4455552, 108),
(4455553, 108),
(4455554, 108),
(4455555, 108),
(4455556, 108),
(4455557, 108),
(4455558, 108),
(4455559, 108),
(4455560, 108),
(4455561, 108);

INSERT INTO `creature` (`guid` ,`id` ,`map` ,`modelid` ,`equipment_id` ,`position_x` ,`position_y` ,`position_z` ,`orientation` ,`spawntimesecs` ,`spawndist` ,`currentwaypoint` ,`trash1` ,`trash2` ,`trash3` ,`trash4` ,`curhealth` ,`curmana` ,`DeathState` ,`MovementType` ) VALUES
(4455493, 666555, 1, 0, 0, 1610.04, -4402.57, 10.4797, 1.83496, 25, 0, 0, 1610.04, -4402.57, 10.4797, 0, 12500, 0, 0, 0),
(4455495, 666556, 1, 0, 0, 1529.68, -4410.6, 13.0939, 3.43025, 124, 0, 0, 1529.68, -4410.6, 13.0939, 3.43025, 450, 0, 0, 2),
(4455498, 666556, 1, 0, 0, 1527.37, -4418.89, 13.5556, 0.720621, 124, 0, 0, 1527.37, -4418.89, 13.5556, 0, 450, 0, 0, 2),
(4455499, 666556, 1, 0, 0, 1530.35, -4422.71, 13.1111, 2.44767, 124, 0, 0, 1530.35, -4422.71, 13.1111, 2.44767, 450, 0, 0, 2),
(4455500, 666556, 1, 0, 0, 1529.07, -4398.44, 13.9571, 5.11959, 124, 0, 0, 1529.07, -4398.44, 13.9571, 0, 450, 0, 0, 1),
(4455501, 666556, 1, 0, 0, 1537.01, -4408.05, 11.5556, 3.61948, 124, 0, 0, 1537.01, -4408.05, 11.5556, 0, 450, 0, 0, 1),
(4455502, 666556, 1, 0, 0, 1527.06, -4425.47, 14.1591, 1.29389, 124, 0, 0, 1527.06, -4425.47, 14.1591, 0, 450, 0, 0, 1),
(4455503, 666556, 1, 0, 0, 1558.84, -4390.3, 4.38414, 4.80462, 124, 0, 0, 1558.84, -4390.3, 4.38414, 0, 450, 0, 0, 1),
(4455504, 666556, 1, 0, 0, 1556.66, -4393.57, 5.34517, 0.569754, 124, 0, 0, 1556.66, -4393.57, 5.34517, 0, 450, 0, 0, 1),
(4455505, 666556, 1, 0, 0, 1559.17, -4398.88, 6.07728, 1.39913, 124, 0, 0, 1559.17, -4398.88, 6.07728, 0, 450, 0, 0, 1),
(4455506, 666556, 1, 0, 0, 1597.27, -4443.98, 6.54882, 2.46931, 124, 0, 0, 1597.27, -4443.98, 6.54882, 0, 450, 0, 0, 2),
(4455507, 666556, 1, 0, 0, 1598.38, -4436.62, 6.51986, 3.94821, 124, 0, 0, 1598.38, -4436.62, 6.51986, 0, 450, 0, 0, 1),
(4455508, 666556, 1, 0, 0, 1594.37, -4435.55, 6.56077, 5.40591, 124, 0, 0, 1594.37, -4435.55, 6.56077, 0, 450, 0, 0, 1),
(4455509, 666556, 1, 0, 0, 1616.86, -4438.2, 9.67019, 2.95232, 124, 0, 0, 1616.86, -4438.2, 9.67019, 0, 450, 0, 0, 2),
(4455510, 666556, 1, 0, 0, 1629.3, -4432.2, 13.7304, 3.28612, 124, 0, 0, 1629.3, -4432.2, 13.7304, 0, 450, 0, 0, 1),
(4455511, 666556, 1, 0, 0, 1617.87, -4423.24, 13.8088, 4.44929, 124, 0, 0, 1617.87, -4423.24, 13.8088, 0, 450, 0, 0, 1),
(4455512, 666556, 1, 0, 0, 1614.79, -4340.02, 3.55577, 1.32214, 124, 0, 0, 1614.79, -4340.02, 3.55577, 0, 450, 0, 0, 1),
(4455513, 666556, 1, 0, 0, 1604.35, -4326.69, 2.07787, 5.79106, 124, 0, 0, 1604.35, -4326.69, 2.07787, 0, 450, 0, 0, 1),
(4455514, 666556, 1, 0, 0, 1611.86, -4332.08, 1.49184, 3.40207, 124, 0, 0, 1611.86, -4332.08, 1.49184, 3.40207, 450, 0, 0, 2),
(4455515, 666556, 1, 0, 0, 1610.74, -4338.79, 3.40153, 0.841232, 124, 0, 0, 1610.74, -4338.79, 3.40153, 0, 450, 0, 0, 1),
(4455516, 666556, 1, 0, 0, 1698.35, -4310.04, 11.8251, 5.73426, 124, 0, 0, 1698.35, -4310.04, 11.8251, 0, 450, 0, 0, 1),
(4455517, 666556, 1, 0, 0, 1708.08, -4313.01, 16.3175, 2.97516, 124, 0, 0, 1708.08, -4313.01, 16.3175, 0, 450, 0, 0, 1),
(4455518, 666556, 1, 0, 0, 1712.33, -4328.65, 21.4984, 1.95021, 124, 0, 0, 1712.33, -4328.65, 21.4984, 0, 450, 0, 0, 1),
(4455519, 666556, 1, 0, 0, 1705.84, -4379.24, 27.5283, 3.31838, 124, 0, 0, 1705.84, -4379.24, 27.5283, 0, 450, 0, 0, 1),
(4455520, 666556, 1, 0, 0, 1703.92, -4368.23, 25.6411, 4.71638, 124, 0, 0, 1703.92, -4368.23, 25.6411, 0, 450, 0, 0, 1),
(4455521, 666556, 1, 0, 0, 1706.96, -4369.69, 26.2256, 5.1837, 124, 0, 0, 1706.96, -4369.69, 26.2256, 0, 450, 0, 0, 2),
(4455522, 666556, 1, 0, 0, 1649.38, -4389.72, 21.149, 4.06179, 124, 0, 0, 1649.38, -4389.72, 21.149, 0, 450, 0, 0, 1),
(4455523, 666556, 1, 0, 0, 1653.01, -4394.33, 21.5632, 2.82243, 124, 0, 0, 1653.01, -4394.33, 21.5632, 0, 450, 0, 0, 1),
(4455524, 666556, 1, 0, 0, 1647.9, -4359.07, 22.1783, 0.564411, 124, 0, 0, 1647.9, -4359.07, 22.1783, 0, 450, 0, 0, 1),
(4455525, 666556, 1, 0, 0, 1658.69, -4359.65, 25.6253, 2.62608, 124, 0, 0, 1658.69, -4359.65, 25.6253, 0, 450, 0, 0, 1),
(4455526, 666556, 1, 0, 0, 1653.78, -4354.48, 25.4375, 4.69953, 124, 0, 0, 1653.78, -4354.48, 25.4375, 0, 450, 0, 0, 2),
(4455527, 666556, 1, 0, 0, 1726.47, -4465.07, 35.2026, 4.9218, 124, 0, 0, 1726.47, -4465.07, 35.2026, 0, 450, 0, 0, 1),
(4455528, 666556, 1, 0, 0, 1733.84, -4473.99, 32.9108, 2.48236, 124, 0, 0, 1733.84, -4473.99, 32.9108, 0, 450, 0, 0, 1),
(4455529, 666556, 1, 0, 0, 1720.75, -4472.51, 35.4599, 0.191349, 124, 0, 0, 1720.75, -4472.51, 35.4599, 0, 450, 0, 0, 1),
(4455531, 666556, 1, 0, 0, 1754.74, -4506.53, 27.4523, 2.77216, 124, 0, 0, 1754.74, -4506.53, 27.4523, 0, 450, 0, 0, 1),
(4455532, 666556, 1, 0, 0, 1755.73, -4501.19, 27.4637, 4.06572, 124, 0, 0, 1755.73, -4501.19, 27.4637, 0, 450, 0, 0, 1),
(4455533, 666556, 1, 0, 0, 1745.77, -4529.28, 29.319, 0.605252, 124, 0, 0, 1745.77, -4529.28, 29.319, 0, 450, 0, 0, 1),
(4455534, 666556, 1, 0, 0, 1751.81, -4533.2, 29.2589, 1.70167, 124, 0, 0, 1751.81, -4533.2, 29.2589, 0, 450, 0, 0, 1),
(4455535, 666556, 1, 0, 0, 1796.23, -4514.33, 22.037, 5.11344, 124, 0, 0, 1796.23, -4514.33, 22.037, 0, 450, 0, 0, 1),
(4455536, 666556, 1, 0, 0, 1801.55, -4517.26, 20.879, 3.08161, 124, 0, 0, 1801.55, -4517.26, 20.879, 0, 450, 0, 0, 1),
(4455537, 666556, 1, 0, 0, 1829.42, -4506.58, 21.3733, 4.90373, 124, 0, 0, 1829.42, -4506.58, 21.3733, 0, 450, 0, 0, 1),
(4455538, 666556, 1, 0, 0, 1848.04, -4512.59, 23.4302, 6.12895, 124, 0, 0, 1848.04, -4512.59, 23.4302, 0, 450, 0, 0, 1),
(4455539, 666556, 1, 0, 0, 1852.13, -4519.37, 24.046, 1.587, 124, 0, 0, 1852.13, -4519.37, 24.046, 0, 450, 0, 0, 1),
(4455540, 666556, 1, 0, 0, 1869.36, -4518.1, 26.7279, 3.05412, 124, 0, 0, 1869.36, -4518.1, 26.7279, 0, 450, 0, 0, 1),
(4455541, 666556, 1, 0, 0, 1873.66, -4520.62, 27.2815, 5.59646, 124, 0, 0, 1873.66, -4520.62, 27.2815, 0, 450, 0, 0, 1),
(4455542, 666556, 1, 0, 0, 1918.7, -4548.09, 30.5801, 2.45957, 124, 0, 0, 1918.7, -4548.09, 30.5801, 0, 450, 0, 0, 1),
(4455543, 666556, 1, 0, 0, 1910.24, -4547.13, 29.7889, 1.12283, 124, 0, 0, 1910.24, -4547.13, 29.7889, 0, 450, 0, 0, 1),
(4455544, 666556, 1, 0, 0, 1891.03, -4549.76, 28.6685, 1.78335, 124, 0, 0, 1891.03, -4549.76, 28.6685, 0, 450, 0, 0, 1),
(4455545, 666556, 1, 0, 0, 1892.82, -4504.73, 25.9089, 0.91941, 124, 0, 0, 1892.82, -4504.73, 25.9089, 0, 450, 0, 0, 1),
(4455546, 666556, 1, 0, 0, 1886.93, -4495.52, 23.5984, 6.00879, 124, 0, 0, 1886.93, -4495.52, 23.5984, 0, 450, 0, 0, 1),
(4455547, 666556, 1, 0, 0, 1917.72, -4456.63, 22.9972, 0.220406, 124, 0, 0, 1917.72, -4456.63, 22.9972, 0, 450, 0, 0, 1),
(4455548, 666556, 1, 0, 0, 1921.89, -4453.36, 22.4578, 3.70757, 124, 0, 0, 1921.89, -4453.36, 22.4578, 0, 450, 0, 0, 1),
(4455549, 666556, 1, 0, 0, 1920.25, -4451.55, 23.2967, 4.51182, 124, 0, 0, 1920.25, -4451.55, 23.2967, 0, 450, 0, 0, 1),
(4455550, 666556, 1, 0, 0, 1956.1, -4431.29, 25.9937, 3.79739, 124, 0, 0, 1956.1, -4431.29, 25.9937, 0, 450, 0, 0, 1),
(4455551, 666556, 1, 0, 0, 1958.61, -4425.45, 26.9187, 2.70019, 124, 0, 0, 1958.61, -4425.45, 26.9187, 0, 450, 0, 0, 1),
(4455552, 666556, 1, 0, 0, 1951.59, -4451.27, 24.4901, 4.55844, 124, 0, 0, 1951.59, -4451.27, 24.4901, 0, 450, 0, 0, 1),
(4455553, 666556, 1, 0, 0, 1946.54, -4454.7, 24.3835, 6.06248, 124, 0, 0, 1946.54, -4454.7, 24.3835, 0, 450, 0, 0, 1),
(4455554, 666556, 1, 0, 0, 1944.46, -4455.75, 24.281, 5.05324, 124, 0, 0, 1944.46, -4455.75, 24.281, 0, 450, 0, 0, 1),
(4455555, 666556, 1, 0, 0, 1918.13, -4420.17, 22.7156, 1.03122, 124, 0, 0, 1918.13, -4420.17, 22.7156, 0, 450, 0, 0, 1),
(4455556, 666556, 1, 0, 0, 1912, -4413.03, 21.6256, 6.06169, 124, 0, 0, 1912, -4413.03, 21.6256, 0, 450, 0, 0, 1),
(4455557, 666556, 1, 0, 0, 1951.96, -4403.53, 25.3078, 3.91599, 124, 0, 0, 1951.96, -4403.53, 25.3078, 0, 450, 0, 0, 1),
(4455558, 666556, 1, 0, 0, 1957.29, -4402.15, 27.7188, 2.81486, 124, 0, 0, 1957.29, -4402.15, 27.7188, 0, 450, 0, 0, 1),
(4455559, 666556, 1, 0, 0, 1953.86, -4392.91, 24.7859, 2.11821, 124, 0, 0, 1953.86, -4392.91, 24.7859, 0, 450, 0, 0, 1),
(4455560, 666556, 1, 0, 0, 1591.73, -4414.6, 8.8382, 0.973894, 124, 0, 0, 1591.73, -4414.6, 8.8382, 0, 450, 0, 0, 1),
(4455561, 666556, 1, 0, 0, 1587.9, -4416.63, 8.61047, 2.25566, 124, 0, 0, 1587.9, -4416.63, 8.61047, 0, 450, 0, 0, 1);

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`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `trash`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `RacialLeader`, `equipment_id`, `ScriptName`) VALUES
(666555, 19931, 0, 19931, 0, 'Cravchick', 'Horde Civilian', 60, 60, 12500, 12500, 0, 0, 0, 35, 35, 2, 1, 0, 15, 17, 0, 5, 6, 9, 0, 0, 0, 0, 0, 0, 0, 15.0345, 17.3793, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, ''),
(666556, 503, 0, 503, 0, 'White Boar', '', 25, 25, 450, 450, 0, 0, 0, 1275, 1275, 0, 0.58, 0, 32, 42, 0, 140, 1960, 2156, 0, 0, 5, 0, 0, 0, 0, 31.7931, 41.858, 100, 1, 0, 16, 666556, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, 0, 1, 0, '');

INSERT INTO `creature_loot_template` VALUES
(666556, 555333, 100, 0, 1, 1, 0, 0, 0, 0);

INSERT INTO `item_template` VALUES
(555333, 7, 0, -1, 'Fresh Boar Meat', 6348, 1, 0, 1, 15, 3, 0, -1, -1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 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, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 'Bring this to Cravchick, Cravchick want to eat!', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '', 0, 0, 0, 0);

INSERT INTO `creature_questrelation` VALUES 
(666555, 777999);

INSERT INTO `creature_involvedrelation` VALUES 
(666555, 777999);

INSERT INTO `quest_template` VALUES
(777999, 1637, 20, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33, 0, 0, 0, 0, 0, 0, 0, 'Cravchick want to eat!', 'Hey.  $Gboy:girl;? I have many land to get here and I am very tired. Cravchick want to eat. Kill for me a couple of 10 White Boar. I love meat done. Cravchick loves eating. Making picking me and I will make you the most respected people in Horde! Now go and do good work. Cravchick waiting...', 'Bring to 10 Pieces of Meat for Cravchick. In Orgrimmar just black boars season.', 'Ahhhh! Excellent! You brought food. Cravchick will eat! Cravchick do you distinguished man!', 'Cravchick want to eat! Now go and do good work. Cravchick waiting...', '', '', '', '', '', 555333, 0, 0, 0, 10, 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, 21, 577, 369, 470, 76, 200, 200, 200, 200, 200, 0, 4000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1);
