add Valdeholm NPC loots

[javewow]

NO 1----- open http://everquest.allakhazam.com/db/npc.html?id=22410

NO 2------- find a butcher

NO3 ----- copy Known Loot: all to *.txt

icon Amber
icon Black Sapphire
icon Bloodstone
icon Blue Diamond
icon Curzon
icon Diamond
icon Elaborate Defiant Claymore
icon Elaborate Defiant Leather Gloves
icon Elaborate Defiant Plate Gauntlets
icon Elaborate Defiant Plate Helm
icon Elaborate Defiant Silk Sandals
icon Elaborate Defiant Silk Wristband
icon Elegant Adept's Shard
icon Elegant Defiant Forked Spear
icon Elegant Defiant Leather Gloves
icon Elegant Defiant Silk Sleeves ........

Replace icon

NO4 -----to EXCEL tools

SELECT * FROM `items` WHERE `Name` = ' Amber
OR `Name` = ' Black Sapphire
OR `Name` = ' Bloodstone
OR `Name` = ' Blue Diamond
OR `Name` = ' Curzon
.......................
LIMIT 0, 1000

COPY to HeidiSQL tools Check out ALL items's Number

NO5-----Made with Excel watches

sub EVENT_SPAWN {
my $randa = quest::ChooseRandom(10022,10036,10019,22503,35085, 10037,50613,50198,50182,50184);
my $randb = quest::ChooseRandom(50208,50205,50459,50627,50232, 50244,10029,12899);
my $randc = quest::ChooseRandom(46642,97328,97327,97329,97003, 46641,10023,35084);
my $randd = quest::ChooseRandom(10015,10028,97001,37859,58067, 37858,58068,45891);
my $rande = quest::ChooseRandom(97380,97379,80399,46643,97002, 35088,34234,34221);
my $randw = quest::ChooseRandom(97286,37847,37844,37846,37845, 37851,37848,37850,37849,37852,35087);
my $rewardr = quest::ChooseRandom(1,2,3,4,5,6,7,8,9,11,12,13,14, 15,16,17,18,19,20);

if($NPCRace!=54)
{

if($rewardr < 4)
{
quest::addloot($randa,1);
quest::addloot($randb,1); }

if($rewardr < 7 && $rewardr > 3) {
quest::addloot($randc,1);}
if($rewardr < 10 && $rewardr > 6) {
quest::addloot($randd,1);}
if($rewardr < 13 && $rewardr > 9) {
quest::addloot($rande,1);}
if($rewardr < 16 && $rewardr > 12) {
quest::addloot($rande,1); }

if($rewardr > 17)
{
quest::addloot($randw,1);
quest::addloot($randd,1);

}
}
}

copy save a_butcher .pl to C:\EQEmuServer\quests\Valdeholm\

[javewow]

a butcher ALL loot
---------------------------------------
SELECT * FROM `items` WHERE `Name` = 'Amber'
OR `Name` = 'Black Sapphire'
OR `Name` = 'Bloodstone'
OR `Name` = 'Blue Diamond'
OR `Name` = 'Curzon'
OR `Name` = 'Diamond'
OR `Name` = 'Elaborate Defiant Claymore'
OR `Name` = 'Elaborate Defiant Leather Gloves'
OR `Name` = 'Elaborate Defiant Plate Gauntlets'
OR `Name` = 'Elaborate Defiant Plate Helm'
OR `Name` = 'Elaborate Defiant Silk Sandals'
OR `Name` = 'Elaborate Defiant Silk Wristband'
OR `Name` = "Elegant Adept's Shard"
OR `Name` = 'Elegant Defiant Forked Spear'
OR `Name` = 'Elegant Defiant Leather Gloves'
OR `Name` = 'Elegant Defiant Silk Sleeves'
OR `Name` = 'Emerald'
OR `Name` = 'Frostmantle'
OR `Name` = 'Giant Blood'
OR `Name` = 'Giant Bones'
OR `Name` = 'Giant Parts'
OR `Name` = 'Harmonagate'
OR `Name` = 'Icehaven Pauldron'
OR `Name` = 'Jade'
OR `Name` = 'Lucidem'
OR `Name` = 'Malachite'
OR `Name` = 'Peridot'
OR `Name` = 'Prestidigitase'
OR `Name` = 'Raw Amber Nihilite'
OR `Name` = 'Raw Crimson Nihilite'
OR `Name` = 'Raw Indigo Nihilite'
OR `Name` = 'Raw Shimmering Nihilite'
OR `Name` = 'Scale Ore'
OR `Name` = 'Serpent Spine Diamond'
OR `Name` = 'Serpent Spine Geode'
OR `Name` = 'Shard of Phenomenal Power'
OR `Name` = 'Starlight Crystal'
OR `Name` = 'Staurolite'
OR `Name` = 'Sunshard Powder'
OR `Name` = 'Superb Animal Pelt'
OR `Name` = 'Superb Silk'
OR `Name` = 'Taaffeite'
OR `Name` = 'Uncut Alexandrite'
OR `Name` = 'Uncut Amethyst'
OR `Name` = 'Uncut Black Sapphire'
OR `Name` = 'Uncut Combine Star'
OR `Name` = 'Uncut Demantoid'
OR `Name` = 'Uncut Goshenite'
OR `Name` = 'Uncut Jacinth'
OR `Name` = 'Uncut Morganite'
OR `Name` = 'Uncut Rubellite'
OR `Name` = 'Versluierd Fungus'

LIMIT 0, 1000

[The_Beast]

That loot already came with the database. At least with the one I installed anyway.