EQEmulator Forums - Omens of War(OoW) Info

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Omens of War(OoW) Info - Zones, mob IDs, epic IDs (https://www.eqemulator.org/forums/showthread.php?t=16174)

Omens of War(OoW) Info - Zones, mob IDs, epic IDs

This is a pretty extensive bit of info that I've found so far for OoW...figured I'd share it with the world building community. Firstly the zones...run this in sql:

Code:

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('wallofslaughter', 'Wall of Slaughter', '60', '500', '15', '300', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('bloodfields', 'The Bloodfields', '-1766', '2133', '-929', '301', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksscar', 'Dranik's Scar', '-1491', '-1325', '224', '302', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('causeway', 'Nobles\' Causeway', '-53', '-2011', '316', '303', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersa', 'Muramite Proving Grounds', '0', '0', '0', '304', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersb', 'Muramite Proving Grounds', '0', '0', '0', '305', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersc', 'Muramite Proving Grounds', '0', '0', '0', '306', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersd', 'Muramite Proving Grounds', '0', '0', '0', '307', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chamberse', 'Muramite Proving Grounds', '0', '0', '0', '308', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersf', 'Muramite Proving Grounds', '0', '0', '0', '309', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('provinggrounds', 'Muramite Proving Grounds', '-158', '-5671', '-304', '316', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('anguish', 'Asylum of Anguish', '-11', '-2453', '-78', '317', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikhollowsa', 'Dranik\'s Hollows', '0', '0', '0', '318', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikhollowsb', 'Dranik\'s Hollows', '0', '-447', '-36', '319', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikhollowsc', 'Dranik\'s Hollows', '5', '-51', '-41', '320', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikcatacombsa', 'Catacombs of Dranik', '-14', '-9', '-8', '328', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikcatacombsb', 'Catacombs of Dranik', '-68', '-30', '-6', '329', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikcatacombsc', 'Catacombs of Dranik', '55', '-214', '0', '330', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksewersa', 'Sewers of Dranik', '2', '0', '-4', '331', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksewersb', 'Sewers of Dranik', '0', '0', '-5', '332', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksewersc', 'Sewers of Dranik', '0', '0', '-5', '333', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('riftseekers', 'Riftseekers\' Sanctum', '7', '122', '-235', '334', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('harbingers', 'Harbingers\' Spire', '-30', '7', '2', '335', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranik', 'The Ruined City of Dranik', '-1112', '-1944', '-367', '336', '-2030', '450', '2000', '450', '2000');

Now on to mob model numbers...there are some that may be missing, but I haven't found that the number uses a model thus far in my testing. If anyone finds a zone that model number works in, please share what the model is, thanks!

405 - Discord Golem
406 - Dragon Man(possibly the Mata Muram model)
407 - Lightning Armor
408 - Pyrilen Demon
409 - Bazu(huge gorilla type monster)
410 - Feran(big madusa type dog)
411 - Pyrilen Demon(yes, it's used twice)
412 - Manticore(I dunno, is this what it's called?)
413 - Dragorn
414 - Murkglider
415 - ??(no model found)
416 - ??(no model found)
417 - Gelidran Demon
418 - Discordling(dog type creature)
419 - Girplan(fat winged creature)
420 - Minotaur(I guess?)
421 - Some box type object
422 - Some object
423 - Bazu Remains(??)
424 - Lightning Armor Remains
425 - Floating Crystal
426 - Portal
427 - ??(no model found)
428 - Pile of Brown Rocks(I hope they're rocks)
429 - Glob of Slime(I guess...)

The models I found stopped at 429. Like I said above, if you find any models I didn't, please post them.

And finally, on to the epics...the follow are their IDFILE, generic name for reference, and the icon they use:

IT10751 - Bard epic 1.5 (1507)
IT10752 - Beastlord epic 1.5 (1508)
IT10753 - Berserker epic 1.5 (1509)
IT10754 - Cleric epic 1.5 (1510)
IT10755 - Druid epic 1.5 (1511)
IT10756 - Enchanter epic 1.5 (1512)
IT10757 - Mage epic 1.5 (1513)
IT10758 - Monk epic 1.5 (1514)
IT10759 - Necro epic 1.5 (1515)
IT10760 - Paladin epic 1.5 (1516)
IT10761 - Ranger epic 1.5 (1517)
IT10762 - Rogue epic 1.5 (1518)
IT10763 - Shadowknight epic 1.5 (1519)
IT10764 - Shaman epic 1.5 (1520)
IT10765 - Warrior epic 1.5 (1521)
IT10766 - Wizard epic 1.5 (1522)

IT10735 - Bard epic 2.0 (1507)
IT10736 - Beastlord epic 2.0 (1508)
IT10737 - Berserker epic 2.0 (1509)
IT10738 - Cleric epic 2.0 (1510)
IT10739 - Druid epic 2.0 (1511)
IT10740 - Enchanter epic 2.0 (1512)
IT10741 - Mage epic 2.0 (1513)
IT10742 - Monk epic 2.0 (1514)
IT10743 - Necro epic 2.0 (1515)
IT10744 - Paladin epic 2.0 (1516)
IT10745 - Ranger epic 2.0 (1517)
IT10746 - Rogue epic 2.0 (1518)
IT10747 - Shadowknight epic 2.0 (1519)
IT10748 - Shaman epic 2.0 (1520)
IT10749 - Warrior epic 2.0 (1521)
IT10750 - Wizard epic 2.0 (1522)

Enjoy!

Gunna use these modles on live :twisted: :twisted: :twisted:

Little error here in your sql script. under long_name you need to put a \ (Backslash) before each apostrophe in the word.

example : Dranik\'s not Dranik's

Heres edited file:

Code:

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('wallofslaughter', 'Wall of Slaughter', '60', '500', '15', '300', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('bloodfields', 'The Bloodfields', '-1766', '2133', '-929', '301', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksscar', 'Dranik\'s Scar', '-1491', '-1325', '224', '302', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('causeway', 'Nobles\' Causeway', '-53', '-2011', '316', '303', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersa', 'Muramite Proving Grounds', '0', '0', '0', '304', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersb', 'Muramite Proving Grounds', '0', '0', '0', '305', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersc', 'Muramite Proving Grounds', '0', '0', '0', '306', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersd', 'Muramite Proving Grounds', '0', '0', '0', '307', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chamberse', 'Muramite Proving Grounds', '0', '0', '0', '308', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('chambersf', 'Muramite Proving Grounds', '0', '0', '0', '309', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('provinggrounds', 'Muramite Proving Grounds', '-158', '-5671', '-304', '316', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('anguish', 'Asylum of Anguish', '-11', '-2453', '-78', '317', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikhollowsa', 'Dranik\'s Hollows', '0', '0', '0', '318', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikhollowsb', 'Dranik\'s Hollows', '0', '-447', '-36', '319', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikhollowsc', 'Dranik\'s Hollows', '5', '-51', '-41', '320', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikcatacombsa', 'Catacombs of Dranik', '-14', '-9', '-8', '328', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikcatacombsb', 'Catacombs of Dranik', '-68', '-30', '-6', '329', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranikcatacombsc', 'Catacombs of Dranik', '55', '-214', '0', '330', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksewersa', 'Sewers of Dranik', '2', '0', '-4', '331', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksewersb', 'Sewers of Dranik', '0', '0', '-5', '332', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('draniksewersc', 'Sewers of Dranik', '0', '0', '-5', '333', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('riftseekers', 'Riftseekers\' Sanctum', '7', '122', '-235', '334', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('harbingers', 'Harbingers\' Spire', '-30', '7', '2', '335', '-2030', '450', '2000', '450', '2000');

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranik', 'The Ruined City of Dranik', '-1112', '-1944', '-367', '336', '-2030', '450', '2000', '450', '2000');

Great info tho :D

whoops, forgot about that...thanks for fixing it

Incorrect Icons?

Is probably a problem on my end but when I go to add these items into my database (Mangoo's editor) the Icons that you list give things that I would imagine being wrong, like for the monk epic, the icon is a shield and for the bard its a helm.... Like I said, its probably my problem. :-)

What is the ID file used for?

That's only a visual error in the item editor, the actual icon it uses in EQ is correct. The cause of this is the item editor doesn't support that many icon numbers, so it wraps around once it reaches the end and uses icons from the beginning.

I really really feel dumb, I thought I had done it before, but apparently I hadn't patched up to OoW or GoD haha, so I did that and it works great. Good job here Killspree :-)

And for people who hadn't already figured this out, most of the models must be spawned as gender 2 (neuter) or else they will just be a human.

Hmm that's weird. I couldn't get any of those mob races to work. What I have found for races that worked for me so far is (not knowing the actual model names):

387 = golem
388 = dog
389 = turtle
390 = lizard
391 = bug
392 = crawling creeper
393 = horse lady
394 = snake lady
395 = tall chain man
396 = archer
397 = skinny tusk man
398 = giant dog man
400 = 2 headed beast
402 = pony tail strong beast

In my findings I could not locate the GoD ghosts though.

415 = Rat (The Forgotten Halls Model)
416 = Bat (The Forgotten Halls Model)
427 = Still unknown

Want to add them to any zone? Just add this to your zoneshortname_chr.txt file in your EQ directory. If the zone does not have a file, just make one and paste this as is, if it does, add everyone on to the end and add the number 34 to the number on top (of course remove the number 34 from my code).

Code:

34

bat,bat

btn,btn

chm,chm

clv,clv

crs,crs

cst,cst

dbp,dbp

dbx,dbx

ddm,ddm

ddv,ddv

dma,dma

dbp,dbp

dbx,dbx

dsf,dsf

dsg,dsg

fra,fra

frd,frd

ddm,ddm

ddv,ddv

dsg,dsg

fra,fra

frd,frd

map,map

mes,mes

mnt,mnt

mur,mur

prt,prt

rat,rat

rtn,rtn

rkp,rkp

rob,rob

scu,scu

tgo,tgo

tln,tln

Quote:

Originally Posted by ajb20

415 = Big ugly rat
416 = Bat that had too much caffeine and can't sit still
427 = Still unknown

Want to add them to any zone? Just add this to your zoneshortname_chr.txt file in your EQ directory. If the zone does not have a file, just make one and paste this as is, if it does, add everyone on to the end and add the number 34 to the number on top (of course remove the number 34 from my code).

Code:

34

bat,bat

btn,btn

chm,chm

clv,clv

crs,crs

cst,cst

dbp,dbp

dbx,dbx

ddm,ddm

ddv,ddv

dma,dma

dbp,dbp

dbx,dbx

dsf,dsf

dsg,dsg

fra,fra

frd,frd

ddm,ddm

ddv,ddv

dsg,dsg

fra,fra

frd,frd

map,map

mes,mes

mnt,mnt

mur,mur

prt,prt

rat,rat

rtn,rtn

rkp,rkp

rob,rob

scu,scu

tgo,tgo

tln,tln

not really smart to have 34 models force loaded into one zone, can cause problems.

Its not that big of a deal. EQ just about does it by default anyway. Nadox has 29 forced by default so I can't see 34 hurting anytning anymore than that would do. Also, I wasn't telling them to go do it to every zone, I was just saying if they want all the new models in a zone there it is :)

Default Nadox_chr.txt:

Code:

29

gdm,unrest_chr

gem,paineel_chr

gef,paineel_chr

sdf,sdf_chr

sdm,sdm_chr

wbu,wbu_chr

dpm,dpm_chr

dpf,dpf_chr

epm,epm_chr

epf,epf_chr

gpm,gpm_chr

gpf,gpf_chr

hpm,hpm_chr

hpf,hpf_chr

opm,opm_chr

opf,opf_chr

fbm,fbm_chr

fbf,fbf_chr

tbm,tbm_chr

tbf,tbf_chr

tpb,tpb_chr

tpo,tpo_chr

tsm,tsm_chr

lug,lug_chr

lga,lga_chr

lgr,lgr_chr

tzm,tzm_chr

tzf,tzf_chr

tvp,tvp_chr

Yeah, you can use GoD models in OoW zones just by using the zonename_chr.txt files that you get when patching, but I left them out because they aren't really "new"...only reason I even posted 405 as one of the models is because the golem got new texturing to allow use of pixel shaders for OoW.

Hi, I know I probably have no right to use this if I have to ask but, how would I go about adding this stuff to my database?
I assume for the zones i'd save it as an .sql and source it in, but what about the epic 2.0's and what not?

Thank you if you can help and...sorry if my asking bugs you? :oops:

Quote:

Originally Posted by Maulgak

I would read over the tutorials in length. Will probably find everything you need. If not, search is a good bet too. I have never made items for my server yet, but am sure 15 minutes of searching and I would be able to do it easily.