Argent Quartermaster Lightspark

-- Argent Quartermaster Lightspark <The Argent Crusade> http://www.wowhead.com/npc=10857
-- SOME SETTINGS
UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "3441", `minhealth` = "3876", `maxhealth` = "3876", `armor` = "3379", `speed_walk` = "1", `mindmg` = "78", `maxdmg` = "117", `attackpower` = "29", `baseattacktime` = "1500", `rangeattacktime` = "1500", `minrangedmg` = "62", `maxrangedmg` = "94", `rangedattackpower` = "23", `lootid` = "0", `mingold` = "0", `maxgold` = "0", `flags_extra` = "2" WHERE entry=10857;

-- GOSSIP
DELETE FROM `gossip_menu` WHERE `entry`='3441';
INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
VALUES
('3441', '4193', '0', '0', '0', '0', '0', '0');

DELETE FROM `gossip_menu_option` WHERE `menu_id`='3441';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
VALUES
('3441', '0', '0', 'I need a new Argent Dawn Commission.', '1', '1', '-1', '0', '50009', '0', '0', '', '24', '12846', '1', '8', '5405', '0', '0', '0', '0'),
('3441', '2', '1', 'I want to browse your goods', '3', '128', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`)
VALUES
('50009', '0', '15', '17777', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');



-- Argent Officer Pureheart <The Argent Dawn> http://www.wowhead.com/npc=10840
-- SOME SETTINGS
UPDATE creature_template SET `modelid3` = "0", `minhealth` = "4120", `maxhealth` = "4120", `armor` = "3750", `speed_walk` = "1", `mindmg` = "96", `maxdmg` = "144", `attackpower` = "36", `baseattacktime` = "1500", `rangeattacktime` = "1500", `minrangedmg` = "77", `maxrangedmg` = "115", `rangedattackpower` = "29", `mingold` = "0", `maxgold` = "0", `flags_extra` = "2" WHERE entry=10840;