Main Menu

[MOB-LIST] All MOBs/NPCs - Query by level range

Started by maethwyn, February 04, 2004, 04:36:31 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

maethwyn

Okay, so I went and pulled ALL NPC entries from Illia's bestiary and made a nice, big Access database (so I could use it at work, too - can't install mySQL at work... *sigh*).

Basically, I made a SQL query on the data to show ALL MOBs in ALL zones with a level range corresponding to the "low dark blue" /con range relative to my current level.

I.E. - My current level is 51, so I am searching for all "Animal", "Guard", "Monster", and "Undead" TYPE MOBs in all zones with a LOW-LEVEL range of 38-43 and a HIGH-LEVEL range of 38-46.

...but I did have a few questions.

01 - What is the exact/near-exact formula for MOB levels that are considered Dark Blue based on PC level?
02 - Would anyone be interested in a level-by-level report of what is within the PC's range... say in groups of 5 levels? ...kind of like an absolute end-all-be-all "01-65 leveling guide".
03 - Would anyone be interested in having access to this Access DB?

...of course, the DB will be amended once GoD goes live, but it is as current as Illia's is as of 09:00pm [CST] - 02-04-2004.



As a sample of what is available (in my specified range) at level 51... here are partial query results (I left off "TYPE", "LEVEL-LOW", and "LEVEL-HIGH" for this example):

[code:1]
ZONE   NAME
Acrylia Caverns   A Grimling Manacrafter
Acrylia Caverns   A Grimling Priest
Acrylia Caverns   A Grimling Summoner
Acrylia Caverns   A Wormbait Minnow
Ak'Anon   A Clockwork Priest
Ak'Anon   Clockwork XIIC
Ak'Anon   Clockwork XVIIC
Ak'Anon   Clockwork XXVIC
Ak'Anon   Clockwork XXVIIC
Ak'Anon   Dewis Caneal
Ak'Anon   Drigaz Grumblegrowl
Ak'Anon   Glerpella Gibblix
Ak'Anon   Manik Compolten
Ak'Anon   Mimtia Zethkog
Ak'Anon   Rebbie Romblerum
Ak'Anon   Windlebeck Tobokog
Any Zone   Basher Avisk
Any Zone   Basher Banzuk
Any Zone   Basher Bibeka
Any Zone   Basher Glaum
Any Zone   Basher Gobzin
Any Zone   Basher Razbaz
Any Zone   Basher Roruma
Any Zone   Basher Sutok
Any Zone   Basher Uvgin
Any Zone   Bukton
Burning Woods   A Forest Giant Ancient
Burning Woods   A Great Plague Skeleton
Burning Woods   A Moldering Gorilla
Burning Woods   A Sarnak Avenger
Burning Woods   A Sarnak Zealot
Burning Woods   A Scoriae Hornet
Burning Woods   An Ember Hornet
Burning Woods   Greater Plague Skeleton
Butcherblock Mountains   Guard Belg
Butcherblock Mountains   Guard Gabel
Butcherblock Mountains   Guard Haldin
Butcherblock Mountains   Guard Hartt
Butcherblock Mountains   Guard Kizzburr
Butcherblock Mountains   Guard Mandin
Butcherblock Mountains   Guard Norin
Butcherblock Mountains   Guard Sornn
Butcherblock Mountains   Guard Srinn
Butcherblock Mountains   Guard Zyburr
Cabilis East   The Toilmaster
Chardok   A Chokidai Sniffer
Chardok   A Chokidai Whelp
Chardok   A Di`Zok Invoker
Chardok   A Di`Zok Underling
Chardok   A Shai`din Partisan
City of Mist   A Haze Golem
City of Mist   A Lost One
City of Mist   A Mist Golem
City of Mist   An Aberrant
City of Mist   An Army Behemoth
Cobalt Scar   A Cobalt Drake
Cobalt Scar   A Haunted Seachest
Cobalt Scar   A Siren Seductress
Cobalt Scar   A Wyvern
Cobalt Scar   An Othmir Shaman
Cobalt Scar   An Othmir Warrior
Crypt of Dalnir   The Kly
Crypt of Nadox   A Broken Skull Sycophant
Crypt of Nadox   A Shrine Bruiser
Crystal Caverns   A Crystal Lurker
Crystal Caverns   A Life Leech
Crystal Caverns   Queen Dracnia
Dawnshroud Peaks   A Berserk Rockhopper
Dawnshroud Peaks   A Blasting Stonegrabber
Dawnshroud Peaks   A Bloody Wolf
Dawnshroud Peaks   A Blue Sky Stonegrabber
Dawnshroud Peaks   A Clay Stonegrabber
Dawnshroud Peaks   A Crazed Zelniak
Dawnshroud Peaks   A Cunning Rockhopper
Dawnshroud Peaks   A Dazed Zelniak
Dawnshroud Peaks   A Dire Wolf (Luclin Version)
Dawnshroud Peaks   A Feral Wolf
Dawnshroud Peaks   A Fierce Rockhopper
Dawnshroud Peaks   A Furious Zelniak
Dawnshroud Peaks   A Glade Wolf
Dawnshroud Peaks   A Greater Rockhopper
Dawnshroud Peaks   A Light Stonegrabber
Dawnshroud Peaks   A Mountainous Stonegrabber
Dawnshroud Peaks   A Raging Zelniak
Dawnshroud Peaks   A Ravenous Rockhopper
Dawnshroud Peaks   A Restless Rockhopper
Dawnshroud Peaks   A Rockhopper Brute
Dawnshroud Peaks   A Rockhopper Ravager
Dawnshroud Peaks   A Sambata Faith Worker
Dawnshroud Peaks   A Sambata Gatherer
Dawnshroud Peaks   A Sambata Nectar Collector
Dawnshroud Peaks   A Sambata Spiritist
Dawnshroud Peaks   A Steel Stonegrabber
Dawnshroud Peaks   A Studded Stonegrabber
Dawnshroud Peaks   A Tribal Hunter
Dawnshroud Peaks   A Tribal Leader
Dawnshroud Peaks   A Vigorous Rockhopper
Dawnshroud Peaks   An Aggressive Rockhopper
Dawnshroud Peaks   An Enraged Zelniak
Dawnshroud Peaks   Fungi
Dawnshroud Peaks   Golden Shroom
Dawnshroud Peaks   Tribal Advisor
Dawnshroud Peaks   Tribal Hunter
Deepest Guk   A Living Curse
Dreadlands   A Plaguebone Thief
Dreadlands   A Ravishing Drolvarg
Dreadlands   A Wulfware Lonewolf
Dreadlands   Greater Plaguebone
Dreadlands   Remnant Spirit[/code:1]
Barb Beastlord Xarte - Tholuxe Paells

Noriko

I think the hardest question is not "Where are the dark blue mobs?"  The hardest question is "Where can I find the lowest few levels of dark blue mobs without having to deal with lots of light blues or green?"

That question is not easily answered without references to specific camp spots and certainly not "answerable" if the mob database has no reference to which "camp" a mob resides.  For example:

Is, say, Droga a good place for a level 65?

    If you just look at whether there are dark blue mobs, the answer is yes.

    But if you take into account the mob range of the zone, the answer might be no. (There are lots of greens and light blues in zone.)

    But if you know that all the dark blues are clumped in the west end of the zone, mixed with may be 1/3 light blues, the answere might be yes.
    [/list:u]
    So I'd say, just having mob levels and zones are insufficient.
http://www.magelo.com/eq_view_profile.html?num=774007">Noriko . http://www.celestialrising.com">Celestial Rising . http://pub228.ezboard.com/bxevserverboards">Xev . http://www.beastlords.org/forums/viewtopic.php?t=1593">BST65.80/Xv h++ 3khp 3km ft13 r9 G++<3 e++ o+ T+++ L++ H+++@ f g b- t++>++++ D- !X

maethwyn

Ahh, very good point... initially, I had designed this only because I hate contested camps... and am looking for low dk blues ANYWHERE... and then do all the "extra" research after-the-fact.

BUT, it would seem something like a report that shows zone names and percentages of the different /con MOBs (ani/guard/mons/und) would be more useful.

For instance, at level 51, Acrylia Caverns has roughly 6% *possible* green spawns, 41% *possible* db spawns (28% low db - 13% higher db), ~0% even & yellow, and 54% *possible* red spawns.  So eventhough the statistics are not entirely specific, it would give one the impression that AC is NOT a safe place to hunt at level 51.

...whereas at level 51, The Scarlet Dessert has roughly 7% green, 24% lb, 69% low db, ~0% higher con... which would lead one to believe this would be an ideal zone to hunt.

While this still does not address the "distribution" across the zone issue... I am trying to keep it as automated as possible - then again, I don't think it could ever be fully addressed as zones and spawn distributions are eratic.... ahhh, what a tough problem!

Hmmm... thank you for bringing that to my attention... I'll need to do some more work when I have some time.
Barb Beastlord Xarte - Tholuxe Paells

Hrann

A quick, unrelated nitpick - I think Noriko is thinking of Nurga, not Droga.