Stditems/Monster DB Appearances

[Somebody Else]

Stditems/Monster DB Functions

Ok, once and for all we should create a proper thread showing what exactly the shapes are for the Stditems DB. I'm specifically having trouble with Armours, and would like to know all the different ones for adding HP Drain, MP-HP convert and the like to items (for example if there is a way of adding more than one of the effects).

Armours
Images 1-12, same image numbers will give correct ones for (M) and (F) based on Stdmode.
1 Demon?
2 BasicDress
3 MediumArmour
4 FlameRobe
5 TaoistRobe
6 Heavy/Conqueror/HadesSteel
7 MageRobe/DecalogueRobe
8 AbsolutionRobe/UniRobe/GVR
9-12 Glowing Armours?

Helmets
Same deal as weapons, Helm1 is 1-10, Helm2 is 11-20, but using the CharLooks column instead, Shapes column deals with same stuff as Jewellery.

Jewellery
What Shape numbers are functional??
111 Clear Ring
112 Teleport Ring
113 Paralysis Ring
114 Revival Ring
115 Flame Ring
116 Recovery Ring
117 ???
118 Protection Ring
119 Muscle Ring
120 Skill Necklace
121 Probe Necklace
122-125 Recall Set (122 Ring, 123 Necklace, 124 Bracelet, 125 Helm)
130-132 Mystery Item (130 Ring, 131 Brace, 132 Helm)
136 Ring, 137 Bracelet, 138 Necklace HP Drain, use Anicount Column to decide what % of damage done is stolen. << Must be under 90!!
133 Ring, 134 Bracelet, 135 Necklace MP-HP Conver, use Anicount column to decide what HP is gained.
Both will create full sets when all three numbers are worn regardless of what items have them, increasing both of them by 50 points. (?)
139-143 Adamantine/Enmity Sets (139 Adam Necklace, 140 Enmity Helm/AdamNRing, 141 EnmityNeck/AdamSRing, 142 EnmityBrace/AdamArmorBrace, 143 EnmityRing/AdamHolyBrace)
144 - Poisons
145 - HP Steal
146??
147-151 Numa Set (147 Necklace, 148 HuntaClaw, 149 TempClaw, 150 WisdomRing, 151 JusticeRing)

Reserved column
8 - Disappears on death
12 - ???
132 - Can't be removed (use with disappear time)

Stdmode differences
Necklaces:
19: Allows Adding Luck, using max MR Column
20: Allows Acc/Agil, using max AC/MR columns
21: Allows Att Spd, HPR/MPR, and ???;
Att Spd use ACmin, HPR ACmax, ??? MRmin, MPR MRmax
Rings:
22: AC/MR work as normal
23: Allows Att Spd, use ACmin column.
Bracelets:
24: Allows Acc/Agil, using ACmax/MRmax
26: AC/MR work as normal

Potions
Stdmode 0:
Shape 0 - Normal
Shape 1 - Ginseng/Sun
Shape 3 - Pills
ACmin column for HP, MRmin for MP. Use AC/MRmax for HP/MP x 256 , eg. a 1 in ACmax and 44 in ACmin will give (256 + 44) = 300HP.

I believe these three shapes just define the cooldown time. However...

Shape 2 - MysteryWater

Stdmode 3:
Drugs. Columns:
ACmin - HP
ACmax - Att Spd
MRmin - MP
MRmax - Duration (minutes)
DCmin - DC
MCtype - MCtype
MCmin - M-All/MC/SC
Can all be used in combination.

Roses
Stdmode 60 - AC/MR/DC/MC/SC work as normal.

Throw Column
0 - Normal
1 - ?? - Necessary for script item
2 - Stackable item - like booty!
3 - Stackable item - all potions use this one

Copied from http://www.lomcn.co.uk/forum/showthread.php?t=51224 :

This also might be useful....colour guide for script text:

Colours

2=middle green
12=white
4=Middle grey
10=bright green
11=Bright Blue
1=Red
5=Dark Red
6=Pale Blue
7=Very Dark blue(unreadable on black background)
8=Light Grey
9=Middle Purple
13=Bright Purple
14=Pale Blue
15=Bright Yellow

Other things I use to speed up dev:

Weapon1 Shape

0000 1
3000 2
6000 3
9000 4
12000 5
15000 6
18000 7
21000 8
24000 9
27000 10

weapon2 Shapes 11-20

weapon3 Shapes 21-30

weapon4 Shapes 31-40

weapon5 Shapes 41-50

................
Mob files: (1000 image spaces per mob)

Mon1=Images 0-9 (eg: image 0 is 0000 -> 1000)
Mon2=10-19
Mon3=20-29
Mon4=30-38
Mon5=40-49
Mon6=50-59
Mon7=60-69
Mon8=70-79
Mon9=80-89
Mon10=90-99
Mon11=100-109
Mon12=110-119
Mon13=120-129
Mon14=130-139
Mon15=140-149
Mon16=150-159
Mon17=160-169
Mon18=170-179
Mon19=180-189
Mon20=190-199
Mon21=200-209
Mon22=210-219

DMon1=2000-2090

Info on Anicount column
Copied from http://www.lomcn.co.uk/forum/showthread.php?t=41250&highlight=anicount :

HL_Stditems 表Anicount字段的意义
90 两种会员的装备
91 VIP会员装备
92 IP会员装备
93 转生装备
94 沙巴克成员装备
95 沙漠土城成员装备
96 沙巴克城主装备
97 沙漠土城城主装备
98 两个城的成员装备
99 两个城的城主装备
100 一般行会成员装备
101 一般行会掌门装备
102 师徒装备
103 夫妻装备

90 kind of members' equipment (not sure)
91- VIP Person
92 - IP Person
93 - Reincarnation Member
94 - SW guild members
95 - MW guild members
96 - SW guild owners
97 - MW guild owners
98 - Sabuk-Mudwall Members equipment
99 - Sabuk-Mudwall HOST equipment
100 - any guild member
101 common guilds to equip (not sure)
102 - Master and Apprentice can equip
103 - husbands and wives can equip

104 - 1st lvl of reincarnation can wear
105 - 2nd lvl of reincarnation can wear
and so on, and it comes with message: Holley_msg83=

Holley_msg36=This is member equipment, you cannot Use!
Holley_msg37=This is V.I.P members equipment, you cannot Use!
Holley_msg38=This is I.P. members equipment, you cannot Use!
Holley_msg39=This is Reincarnation members equipment, you cannot Use!
Holley_msg40=This is Sabuk members equipment, you cannot Use!
Holley_msg41=This is MudWall members equipment, you cannot Use!
Holley_msg42=This is Sabuk Host equipment, you cannot Use!£¡
Holley_msg43=This is MudWall Host equipment, you cannot Use!£¡
Holley_msg44=This is Sabuk-Mudwall Members equipment, you cannot Use
Holley_msg45=This is Sabuk-Mudwall HOST equipment, you cannot Use
Holley_msg46=This is good meeting member equipment, you cannot Use
Holley_msg47=This is general line can hold the gate equipment, you cannot Use!
Holley_msg48=This is Master & Student Equipment, you cannot Use!
Holley_msg49=This is Married People equipment, you cannot Use!

How do the mob settings work? Race, Raceimg, Appr, etc?

Don't have access to my current server files so can't check up on a few, but please add your own.

 

[Nightwolf]

the only thing you can really do is use the latest set of files that work such as cd 3.55 or cd 3.56 I think any others files created on top of that are not cracked fully yet but not sure and test all the numbers in the db and see what you come up with in the way of stats.

 

[Amenovis]

btw there are much db infos out and u found it here have a look with using search and look for stats or stats.xml (xml dunno if its now the right for exel files) can also be xls im not sure. also u can look under chimera´s signature he have also a exel file where u see what does what colum in ur sql ( its nearly the same for 3.38 3.55 and 3.56 so u have it easier to test if u see where to start with the number count) lol

greetz Ameno

 

[Somebody Else]

I've done searches for the DB info you are talking about but couldn't find any, tried searching for "stats.xls", "stats.xml" and no results. Chimera's .xls file appears to me as a simple template of the column names and nothing else, apart from showing the Comfort/HCWeight/WWeight columns for shoes, which probably means it isn't coming out right on OpenOffice, can anyone just post the info from it?

There is another thing, which is how different Stdmodes for rings/necklaces/bracelets work:
Stdmodes
Necklaces:
19: Allows Adding Luck, using max MR Column
20: Allows Acc/Agil, using max AC/MR columns
21: Allows Att Spd, HPR/MPR, and ???; Att Spd use ACmin, HPR ACmax, ??? MRmin, MPR MRmax
Rings:
22: AC/MR work as normal
23: Allows Att Spd, use ACmin column.
Bracelets:
24: Allows Acc/Agil, using ACmax/MRmax
25: Poisons/Talismans
26: AC/MR work as normal

What about bundles of items? How do you decide which item it will unbundle into?

 

[chimera]

I used MS Excel notes for certain column headings, basically covering what you said above

 

[Somebody Else]

Now updated with everything I know for sure. What allows the EnmitySword to fit in with the rest of the set?? Is it the 8 in the Reserved column??

 

[chimera]

8 in reserve means breaks on death so yes

 

[jet20]

any 1 can tell me if i wanna make a Weapon whit poison stats on hero server need to add 144 - Poisons on shape anicount or?? any help pls

---------- Post Merged at 04:03 PM ---------- Previous Post was at 01:36 PM ----------

or a neck ring whit poison green