[HUGE REPACK!]Hallow's End - Headless Horseman + GMscripts + Loot + Sounds!

[latruwski]

Ok i made 1 hell big repack with all the stuff i found on ascentemu.com and from my own server...
enjoy this one

The Pumpkin Helmet:

Download sql:
Hallowed Helm-33292.sql
The Headless Horseman Helmet:

Download sql:
The Horseman--'s Helm-33808.sql
The Rings that drop from the Headless Horseman:
Ring of Ghoulish Delight-14052.sql

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (14052,4,0,-1,"Ring of Ghoulish Delight","Ring of Ghoulish Delight","Ring of Ghoulish Delight","Ring of Ghoulish Delight",47325,4,0,0000,0000,11,-1,-1,110,70,0,0,0,0,0,0,0,1,1,0,7,31,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,14052,1,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,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

The Horseman--'s Signet Ring-34073.sql:

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (34073,4,0,-1,"The Horseman's Signet Ring","The Horseman's Signet Ring","The Horseman's Signet Ring","The Horseman's Signet Ring",47325,4,0,0000,0000,11,-1,-1,110,70,0,0,0,0,0,0,0,1,1,0,7,19,5,17,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,14055,1,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,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

Witching Band-34074.sql:

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (34074,4,0,-1,"Witching Band","Witching Band","Witching Band","Witching Band",47325,4,0,0000,0000,11,-1,-1,110,70,0,0,0,0,0,0,0,1,1,0,7,22,5,21,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,18033,1,0,0,0,0,21627,1,0,0,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,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

The brooms!:

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `item1slotdisplay`, `item1info1`, `item1info2`, `item2slotdisplay`, `item2info1`, `item2info2`, `item3slotdisplay`, `item3info1`, `item3info2`, `respawntime`, `resistance0_armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('23952','1','1','35','1','1','0','1','0','1200','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','1','','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `item1slotdisplay`, `item1info1`, `item1info2`, `item2slotdisplay`, `item2info1`, `item2info2`, `item3slotdisplay`, `item3info1`, `item3info2`, `respawntime`, `resistance0_armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('23966','1','1','35','1','1','0','1','0','1200','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','1','','0','0','0','0','2.5','8','14','0');
insert into `creature_names` (`entry`, `creature_name`, `Subname`, `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `unknown_int1`, `unknown_int2`, `unknown_float1`, `unknown_float2`, `Civilian`, `Leader`) values('23952','Broom','','0','7','0','0','0',NULL,'21939','0','0','0','0','0',NULL,NULL);
insert into `creature_names` (`entry`, `creature_name`, `Subname`, `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `male_displayid`, `female_displayid`, `unknown_int1`, `unknown_int2`, `unknown_float1`, `unknown_float2`, `Civilian`, `Leader`) values('23966','Broom','','0','7','0','0','0',NULL,'21939','0','0','0','0','0',NULL,NULL);
INSERT INTO `items` VALUES ('33183', '15', '0', '-1', 'Magic Broom', 'Magic Broom', 'Magic Broom', 'Magic Broom', '47504', '3', '64', '10000000', '1', '0', '262143', '2147483647', '40', '40', '762', '75', '0', '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', '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', '42680', '0', '0', '0', '330', '3000', '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', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0');
INSERT INTO `items` VALUES ('33182', '15', '0', '-1', 'Swift Flying Broom', 'Swift Flying Broom', 'Swift Flying Broom', 'Swift Flying Broom', '47504', '4', '64', '2000000', '400000', '0', '-1', '-1', '70', '70', '762', '300', '0', '0', '0', '0', '0', '1', '1', '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', '42668', '0', '0', '0', '330', '3000', '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', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0');
INSERT INTO `items` VALUES ('33176', '15', '0', '-1', 'Flying Broom', 'Flying Broom', 'Flying Broom', 'Flying Broom', '47504', '3', '64', '1000000', '200000', '0', '-1', '-1', '70', '70', '762', '225', '0', '0', '0', '0', '0', '1', '1', '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', '42667', '0', '0', '0', '330', '3000', '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', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0');
INSERT INTO `items` VALUES ('33184', '15', '0', '-1', 'Swift Magic Broom', 'Swift Magic Broom', 'Swift Magic Broom', 'Swift Magic Broom', '47504', '4', '64', '10000000', '1', '0', '262143', '2147483647', '60', '60', '762', '150', '0', '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', '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', '42683', '0', '0', '0', '330', '3000', '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', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0');

________________________________________________________________________________ ________________________

NEW HEADLESS HORSEMAN!!!!
He works but does not go through phases as I dont know how to do that. This has been modified from the Doomwalker script in the GMScripts SVN.

/* 
* Copyright © 2007 GMScripts <svn://emupedia.com/svn/gmscripts>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/
// Horseman
// Earth Quake
global Horseman_Earthquake = function(plr)
{
 .CastSpell(32686);
 .SendYellMessage("Feel the wrath of my steed.");
 .PlaySoundToSet(11972);
};
// Over run
global Horseman_Overrun = function(plr)
{
 .CastSpell(30546);
 .SendYellMessage("Your soul shall burn!");
 .PlaySoundToSet(11965);
};
// Conflagrate Target
global Horseman_Conflagrate_Target = function(plr)
{
 plr = .GetClosestPlayer();
 if(plr != null)
 {
  .CastSpellOnTarget(27215, plr);
 }
 .PlaySoundToSet(11967);
};
// Sunder Armor
global Horseman_Pumpkin_Treat= function(plr)
{
 plr = .GetClosestPlayer();
 if(plr != null)
 {
  .CastSpellOnTarget(30459, plr);
 }
};
 
// Enter combat.
global Horseman_Enter_Combat = function(plr)
{
 .SendYellMessage("It is over, your search is done! Let fate choose now, the righteous one.");
 .PlaySoundToSet(11961);
 // Register spell timers.
 .RegisterTimer(10000, Horseman_Pumpkin_Treat, 0);  // Casts Chain Lightning every 10 seconds.
 .RegisterTimer(23000, Horseman_Conflagrate_Target , 0); // Casts Chain Lightning every 23 seconds.
 .RegisterTimer(50000, Horseman_Earthquake, 0);  // Cast Earth Quake every 50 seconds.
 .RegisterTimer(120000, Horseman_Overrun, 0);   // Casts Over run Every 2 minutes.
};
.RegisterUnitEvent(30000, 1, Horseman_Enter_Combat);
// Horseman Leave combat
global Horseman_Leave_Combat = function(plr)
{
 .DeregisterTimer();
};
.RegisterUnitEvent(30000, 2, Horseman_Leave_Combat);
// Horseman kills Player
global Horseman_Killed_Target = function(plr)
{
 .SendYellMessage("Your body lays beaten, battered and broken. Let my curse be with you, fate has spoken!");
 .PlaySoundToSet(11962);
};
.RegisterUnitEvent(30000, 3, Horseman_Killed_Target);
// Horseman died.
global Horseman_Died = function(plr)
{
 .SendYellMessage("This end have I reached before. What new adventure lies in store?");
 .PlaySoundToSet(11964);
};
.RegisterUnitEvent(30000, 4, Horseman_Died);

I had to give him some warlock spells because the ones listed for him on wowhead mostly don't seem to work, these are close I guess. If anyone can help make him phase like throwing his head and all that the info is here: Headless Horseman - WoWWiki, the Warcraft wiki and his spells are here: headless - Wowhead Search . I could not find his creature ID in the DBC so I just gave him 30000 and I guess at some point he should unmount. Lastly the sword is not his and for some reason it only shows when he attacks.

INSERT INTO `creature_names` VALUES ('30000', 'Headless Horseman', 'The deathbringer', '0', '7', '0', '1', '0', null, '22351', '0', '0', '0', '1', '1', null, null);
INSERT INTO `creature_proto` VALUES ('30000', '72', '72', '14', '96000', '96000', '10000', '1', '0', '1750', '546', '586', '0', '0', '0', '0', '32443', '33488898', '781', '0', '0', '0', '0', '0', '0', '3180000', '0', '10', '10', '0', '0', '0', '0', '2', '2', '', '1', '35000', '0', '0', '2.5', '8', '14', '0');

Rook -
(this is a qoute from ascent forums: Board Message)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NPC ID's:
Horseman 23682
Sir Thomas 23904 (undead)
Pulsing Pumpkin 23694
Pumpkin Fiend 23545
Horseman Loot:

INSERT INTO `creatureloot` VALUES ('', '23682', '33154', '2.15', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '33292', '8.43', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '33808', '3.11', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '34068', '29.96', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '34073', '27.87', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '34074', '27.93', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '34075', '27.57', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '33182', '6.16', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '33176', '13.34', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '33184', '22.61', '0', '1', '1');
INSERT INTO `creatureloot` VALUES ('', '23682', '33183', '30.8', '0', '1', '1');

Horseman Loot Items (minus brooms, those were already released):

INSERT INTO `items` VALUES (33154, 15, 0, -1, "Sinister Squashling", "Sinister Squashling", "Sinister Squashling", "Sinister Squashling", 32955, 3, 32768, 0, 0, 0, -1, -1, 20, 0, 0, 0, 0, 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, 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, 42609, 0, 0, 1500, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 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, -1, 0); 
INSERT INTO `items` VALUES (33292, 4, 1, -1, "Hallowed Helm", "Hallowed Helm", "Hallowed Helm", "Hallowed Helm", 46514, 3, 32768, 2, 10, 1, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 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, 54, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -1, 0, -1, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "There's a hole for your head...", 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0); 
INSERT INTO `items` VALUES (33808, 4, 4, -1, "The Horseman's Helm", "The Horseman's Helm", "The Horseman's Helm", "The Horseman's Helm", 47014, 4, 32768, 0, 0, 1, 262143, 2147483647, 110, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 40, 7, 46, 32, 30, -1, 0, -1, 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, 1129, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43873, 0, 0, 30000, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 2927, 0, 0, -1, 0); 
INSERT INTO `items` VALUES (34068, 0, 0, 0, "Weighted Jack-o'-Lantern", "Weighted Jack-o'-Lantern", "Weighted Jack-o'-Lantern", "Weighted Jack-o'-Lantern", 47314, 1, 64, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 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, 44212, 0, 0, 1500, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, -1, 0, -1, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0); 
INSERT INTO `items` VALUES (34073, 4, 0, -1, "The Horseman's Signet Ring", "The Horseman's Signet Ring", "The Horseman's Signet Ring", "The Horseman's Signet Ring", 47325, 4, 32768, 0, 0, 11, -1, -1, 110, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 7, 19, 5, 17, -1, 0, -1, 0, -1, 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, 14055, 1, 0,  -1, 0, -1, 0, 1, 0, -1, 0, -1, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0); 
INSERT INTO `items` VALUES (34074, 4, 0, -1, "Witching Band", "Witching Band", "Witching Band", "Witching Band", 47325, 4, 32768, 0, 0, 11, -1, -1, 110, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 7, 22, 5, 21, -1, 0, -1, 0, -1, 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, 18033, 1, 0,  -1, 0, -1, 21627, 1, 0, -1, 0, -1, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1016, -1, 0); 
INSERT INTO `items` VALUES (34075, 4, 0, -1, "Ring of Ghoulish Delight", "Ring of Ghoulish Delight", "Ring of Ghoulish Delight", "Ring of Ghoulish Delight", 47325, 4, 32768, 0, 0, 11, 262143, 32767, 110, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 7, 31, -1, 0, -1, 0, -1, 0, -1, 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, 14052, 1, -1, 0, -1, 0, 1, -1, 0, 0, -1, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0);

quote from: Board Message
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Here is the candle with blizz id and model

INSERT INTO `items` VALUES ('33985', '12', '0', '-1', 'Dreary Candle', 'Dreary Candle', 'Dreary Candle', 'Dreary Candle', '7066', '1', '0', '0', '0', '0', '-1', '-1', '1', '70', '0', '0', '0', '0', '0', '0', '0', '1', '1', '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', '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', '4', 'There were many Candles around the Shrine', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', null, '0', null, null, '0', null, '0', null, '0', null, null, null, '-1', '0');

quote from same topic....
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a script with thoose Candles... (Untested)
First SQL Datas:

 INSERT INTO `gameobject_names` VALUES ('630001', '10', '259', 'Earth', '7050010', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `items` VALUES ('705003', '12', '0', '-1', 'Candle', 'Candle', 'Candle', 'Candle', '6677', '1', '0', '0', '0', '0', '-1', '-1', '1', '70', '0', '0', '0', '0', '0', '0', '0', '1', '1', '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', '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', '4', 'There were many Candles around the Shrine', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', null, '0', null, null, '0', null, '0', null, '0', null, null, null, '-1', '0');

and now the script:

/*
* Copyright (C) 2007 GMScripts <svn://emupedia.com/svn/gmscripts>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/
// // Horseman Shrine
global HorsemanShrine_OnUse = function(plr, unit)
{
plr.AddItem(705003, 1);
};
.RegisterGameObjectEvent(630000, 2, HorsemanShrine_OnUse);

//earth
global Earth = function(plr)
{
if(plr.HasItem(705003) == 1)
{
plr.SendChatMessage("Rider...");
plr.SendChatMessage("...now it's time...");
plr.SendChatMessage("...to leave our world...");
plr.SendChatMessage("...completly");
.RegisterTimer(3000, Horseman);
plr.RemoveItem(705003, 1);
}
};
.RegisterGameObjectEvent(630001, 2, Earth);
global Horseman = function(unit)
{
.SpawnMonster(30000, 1798.235718, 1318.293091, 18.835508);
};

PS: For the "Earth" I didn't found DispID, so I took one from a Chest -.-
again quote from the same topic.....

________________________________________________________________________________ ________________

If someone uses this to make the horseman 100% working, PM me !
DO NOT ASK ME ANY QUESTIONS ! this is not my work! i only made a repack!
for questions: Board Message

enjoy this

grtz

[Zokmag]

Nice! +rep (again)
EDIT: Can't have to wait...
ok im noob but how do i add the SQL's that aint downloads?

[Herzeleid]

4 +Rep whenever I can. Nice job. <3 Halloween stuff.

[grandslam312]

Nice! +rep (again)
EDIT: Can't have to wait...
ok im noob but how do i add the SQL's that aint downloads?

DO you use SQLyog or Navicat?

[Condor]

I have a problem, if i spawn 30000 he comes and fights etc, but when he's dead no chest comes and he just drops gold...

[OMGPWN]

No credit for me? Both those screen shots are mine from my forum lol http://www.mmowned.com/forums/emulat...helm-test.html

and this http://www.mmowned.com/forums/emulat...in-helmet.html

[godkiller7]

very nice, but wheres the repack with the DB?

[latruwski]

very nice, but wheres the repack with the DB?

no repack with this in it... the writer of the scripts wants to wait till ascent supports lua fully... then she gonna rewrite the script

and yes credit to you for that stuff OMGPWN....but i really searched for that topic xD anyway i only made a repack of this that is all...

grtz

[godkiller7]

no repack with this in it... the writer of the scripts wants to wait till ascent supports lua fully... then she gonna rewrite the script

and yes credit to you for that stuff OMGPWN....but i really searched for that topic xD anyway i only made a repack of this that is all...

grtz

do you know when that will be?

[latruwski]

do you know when that will be?

not really, soon i hope
but didnt you hear the news? Ascent is dropping GMscripts and they gonna start use LUA now
So that is why rewriting the script in GM is not really good
I post a LUA repack asap

grtz

[Illidan1]

Nice dude, but all your doing is taking stuff from different site
and getting Rep out of it
but lol you don't ask for rep and you say it is from Ascent svn so its
all good lol +Rep

[Condor]

Could somebody tell me exactly what to do cus i inserted all the things in my db and save the scripts as .gm files in my ascent folder but i dont see the horseman and if i spawn him it sais the id does not excist.

[lolmaster]

How do i make the text for the horseman script into a GM file???? i dont understand what to do with the script text.

P.S= good job otherwise, ive been trying to find the hallow's end sql's

[latruwski]

well the gm scripts you save as gm files and put them in your scripts folder...

grtz

[lolmaster]

well how do i save them as a GM file?
do i copy the text from codes you gave me and put it in a text document i dont know what you mean.