EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Quests::Custom (https://www.eqemulator.org/forums/forumdisplay.php?f=671)
-   -   add Valdeholm NPC loots (https://www.eqemulator.org/forums/showthread.php?t=41470)

javewow 08-08-2017 08:30 PM

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

NO 2------- find a butcher http://zam.zamimg.com/images/4/2/422...1ec2ffc642.png

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


Quote:

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 08-08-2017 08:37 PM

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 08-09-2017 05:51 PM

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


All times are GMT -4. The time now is 06:40 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.