Monster table in SQL

smoochy boys on tour

chimera

LOMCN VIP
VIP
Jul 30, 2003
1,054
23
235
UK
Can anyone fill in the blanks/give more details or correct the assumtions please, thank you.


Monster setup columns (left to right)

Name - Mob name

Race

RaceImg

Appr

lvl - mob lvl used for taming/turnundead, thrusting etc.

undead - 0=living 1=undead

tameable - 0=Tameable 1=not tameable

wz1

cooleye - % distance over the default distance mob can see a character

venomDC - dc damaged caused by magic hit

exp - experience points gained by killing mob

hp - health points of mob

mp - Magic points of mob?

wz3

wz3

ac - Armour class of mob (resistance to physical attack)

FireMAC - Resistance to Fire (if negative number make it weak to that element)

IceMAC - Ice resistance (as above)

LightMAC - Electic resistance (as above)

WindMAC - wind resistance (as above)

HolyMAC - Holy resistance (as above)

DarkMAC - Dark resistance (as above)

PhantomMAC Phantom resistance (as above)

DC - Minimum dc of mob

DCMax - maximum dc of mob

MCType - the magic type mob attacks with:
1:Fire, 2:Ice, 3:Electric, 4:Wind, 5:Holy,
6:Poison/Paralysis/Dark, 7:Phantom.

MC - minimum magic power of mob

MCMax - maximum magic power of mob

Speed - agility of mob (higher the number the harder it is to hit)

Hit - accuracy of mob (higher the number more likely it is to hit
character)

WalkSpd - movement speed of mob

WalkWait - how long mob waits between steps

WalkStep - how many steps mob makes between waits

AttackSpd - speed mob attacks character

Wz4

Wz5
 

Shaneypoo

Dedicated Member
Dedicated Member
Nov 24, 2006
61
0
52
i think wz1-5 is the spells it attacks with, say with JC it would attack with the blue swipe thingy and the Poison field thing lol. Just a guess ;)
 
Upvote 0

Demonic

LOMCN VIP
VIP
Dec 1, 2003
1,806
2
185
I posted this before many times but here we go again..


Monster setup columns (left to right)

Name - Mob name

Race
RaceImg
- This is the type of Attack the mob Does

Appr - What it looks like on screen

lvl - mob lvl used for taming/turnundead, thrusting etc.
(not just that, also HP regen etc..)

undead - 0 is NOT undead, 1 means you can use TU on it.

tameable
- 0 = Cannot Tame, 1=Tameable

wz1

cooleye - This is for use with Clear ring etc

venomDC - POSION attack Strength

exp - experience points gained by killing mob

hp - How Much HP it has
mp - how Much MP it has

wz2 -
Min AC
wz3 - Max AC

ac - MAC

FireMAC - Resistance to Fire (if negative number make it weak to that element)

IceMAC - Ice resistance (as above)

LightMAC - Electic resistance (as above)

WindMAC - wind resistance (as above)

HolyMAC - Holy resistance (as above)

DarkMAC - Dark resistance (as above)

PhantomMAC Phantom resistance (as above)

DC - Minimum dc of mob

DCMax - maximum dc of mob

MCType - the magic type mob attacks with:
1:Fire, 2:Ice, 3:Electric, 4:Wind, 5:Holy,
6 Poison/Paralysis/Dark, 7 -Pantom.

MC - minimum magic power of mob

MCMax - maximum magic power of mob

Speed - agility of mob (higher the number the harder it is to hit)

Hit - accuracy of mob (higher the number more likely it is to hit
character)

WalkSpd - movement speed of mob

WalkWait - how long mob waits between steps

WalkStep - how many steps mob makes between waits

AttackSpd - speed mob attacks character

Wz4
Wz5
Not used
 
Upvote 0

idaBigA

Holley Mir 3!!
VIP
Oct 28, 2003
1,966
110
310
Stoke, UK
WZ1= % of that creature that will walk through fire = 100% meaning none of them will walk through fire.
WZ4 = Distance that it can see you from (Changed it on EC and you had to go and smack it on the nose)
 
Upvote 0

chimera

LOMCN VIP
VIP
Jul 30, 2003
1,054
23
235
UK
Thank you Demonic/Ida - I did search but couldn't find it refered to on LOMCN.

Wonder if wz1 also applies to wind spell walk through...
 
Upvote 0