Helpful Guide

Join Discord

azzi

Golden Oldie
Golden Oldie
Aug 16, 2005
1,662
19
145
Pls sticky this so it can help people out :)

FLD_Revesrved = 16 then the item stats will change with the level of the item.

eg.

MirSword = level 20

MirSword1 = level 30

MirSword2 = level 40

MirSword3 = level 50

the item will give the user the stats of itemname at level 20 and the stats of itemname1 at level 30 etc.



FLD_Revesrved = 32 then the item stats will change with the class of the player.

eg.

MirSword = in bag stats

MirSword1 = warrior

MirSword2 = wizzard

MirSword3 - taoist

depend on which classes where the item, depends on what stats the play gets. Also lets not forget to add the (M) or (F) after the name. =p



Armours:- pretty straight forward really.
ac=ac
amc=amc
dc=dc
sc=sc
mc=mc
source=luck
anicount=wings
MGAVOID =magic resistance
HPADD=hpadd (1-255 = +hp// 256, 512, 1024 etc etc = 10%, 20%, 30% recovery)
MPADD=mpadd same as above for hp
EXPADD=EXP Rate Increase
SLOWDOWN=SLOW
TOX=PA
TOXAVOID=PR

Weapon

ac=Luck
amc=Curse
dc=dc
sc=sc
mc=mc
source=Not completely sure
anicount=Aspeed ???
MGAVOID =Not Completely Sure
HPADD=hpadd (1-255 = +hp// 256, 512, 1024 etc etc = 10%, 20%, 30% recovery)
MPADD=mpadd same as above for hp
EXPADD=EXP Rate Increase
SLOWDOWN=SLOW
TOX=PA
TOXAVOID=PR

-------------------------------------------------------------------------

Find the First Number of the monster in the .Wil and divide by 1200 to get your look for DB, Same for Monster and Armour ect.

-------------------------------------------------------------------------

To wipe your server of Accounts , Items and Characters Follow these steps.

1. Delete the IDDB in the mirserver/DBServer/IDDB
2. Go to EnterPrise manager and Delete Everything in Tbl_UserItems and Tbl_UserMagic, Also delete Tbl_MAIL and TBL_GuildList also delete Tbl_GuildMemberList, also delete tbl_guilditems also delete Tbl_GTList, Tbl_Friend. Also remove Tbl_CharInfo and Tbl_CharList and finally Tbl_Auction.

-------------------------------------------------------------------------

To Create a GM go into EnterPrise manager and right click TBL_Admin , All tasks -> Return all rows.
For a Full GM Access Add 10 in the collumn FLD_ADMINLEVEL
Add The Character name into FLD_PLAYERNAME
To make the account IP Specific add it to FLD_IP So then it will only allow gm powers from that IP.

-------------------------------------------------------------------------

Usefull Sources

Map Edit
http://hometown.aol.co.uk/marieuttley/MapEdit.rar - Thanks Neptune

HH8
http://rapidshare.com/files/149621651/hh8.exe
http://downloads.jealy.co.uk/HH8.rar - Thanks JealY
https://elitemir.sslpowered.com/HH8.rar - Thanks Forspinki

SQLServer 2000
http://www.microsoft.com/downloads/...e1-f44c-4781-a6bb-f60e02dc1335&DisplayLang=en

Basic TD's Server files
http://hell23.servegame.com/Mirserver/Mirserver.rar - N1 Jasper on Providing link.

-------------------------------------------------------------------------

Will add more when i can.
 
Last edited:

azzi

Golden Oldie
Golden Oldie
Aug 16, 2005
1,662
19
145
UPDATE 15th October 2008

IF + ACT Statements all you need for NPC's

Global Shout NPC

Healer NPC
 
Last edited:
Upvote 0

azzi

Golden Oldie
Golden Oldie
Aug 16, 2005
1,662
19
145
TBL_ADMIN = All the GM's on the server should be written here
TBL_AUCTION = Trust Merchant Items are stored here.
TBL_BLOCKLIST = Banned Names? Not sure
TBL_CHARINFO = All the characters and their info.
TBL_CHARLIST = Just a list of all the chars
TBL_FRIEND = Ingame the friend button. Each characters friends is stored here.
TBL_GTFORUM = The Signpost in the GT, The messages are held here.
TBL_GTLIST = Every GT that is held by which guild
TBL_GTOBJECTS = Every item that is in the GT (Decorations)
TBL_GUARD = Mongen for Guards
TBL_GUILDITEMS = Guild store items are kept here.
TBL_GUILDLIST = Guilds that are ingame and held by who.
TBL_GUILDMEMBERLIST = Every Guild and what members are in each.
TBL_GUILDWARLOG = When a Guild Wars another guild, it shows how long here.
TBL_KEEPALIVE = Not really sure >.<
TBL_MAGIC = All the Magic Stats are kept here (Need the Item in TBL_StdItems to work)
TBL_MAIL = Players mail is kept here
TBL_MAPINFO = Each Map is kept here.
TBL_MERCHANT = Where NPC's are on each map is kept here
TBL_MONGEN = The places where Monsters spawn are kept here.
TBL_MONSTER = Each Monster and its stats are kept here.
TBL_MOVEMAPEVENt = This is where when its a event you teleport to a specific map.
TBL_NPC = Each NPC and where they are placed are kept here.
TBL_STARTPOINT = Where each class starts.
TBL_STATUSARRAY = Purple effect ect? Poison?
TBL_STDITEMS = Where all the items ingame are stored (The Stats ect)
TBL_USERITEMS = Every Users Items
TBL_USERMAGIC = Every users Magic

Hope this helped :S I wrote it all so if you need any more help drop us a pm
 
Upvote 0

Tom27

Golden Oldie
Golden Oldie
Sep 15, 2005
1,867
63
155
Norwich
Nice guide matey, When you're explaining about the server wipe, do you mean delete the full table its self? Or just delete everything inside of it?

And will it effect the table in any way?
And is there an easy way to delete the rows instead of block by block?

Need this info, cheers.
 
Upvote 0

Weikster

LOMCN Veteran
Veteran
Jan 21, 2009
421
11
44
36th chamber
Nice guide matey, When you're explaining about the server wipe, do you mean delete the full table its self? Or just delete everything inside of it?

And will it effect the table in any way?
And is there an easy way to delete the rows instead of block by block?

Need this info, cheers.
No, just delete all info inside table.
And to delete alot at once, click on a line, hold left mouse button down and drag all the way down to where you wanna stop, then right click and delete.
 
Upvote 0

Tom27

Golden Oldie
Golden Oldie
Sep 15, 2005
1,867
63
155
Norwich
Youre guide says

Anicount adds speed to weps, ive tried typing in 4/40/400 and reloaded the database, also tried rebooting the server and nothing gets added to the weps.
Just wondering if anybody has a correction for where the a.speed is altered from.

Need to know; what field adds acc+a.speed on weps
Need to know; what field adds acc on braces + neckys

cheers.
 
Upvote 0

Weikster

LOMCN Veteran
Veteran
Jan 21, 2009
421
11
44
36th chamber
Aspeed on weaps is FLD_MACMAX 1-10 will be -aspeed 11+ is +aspeed
So a 15 there would = aspeed+5
Accuracy on weaps is FLD_SLOWDOWN x256. 512 there would = ACC+2

ACC on necklaces and braces is same as weapons. FLD_SLOWDOWN x256
 
Upvote 0

azzi

Golden Oldie
Golden Oldie
Aug 16, 2005
1,662
19
145
Bump on my old thread as people are struggling with some piece in here :)
 
Upvote 0

Tai

HEAD CAPTAIN
Staff member
Administrator
May 11, 2003
14,300
2
2,682
515
United Kingdom
I have added this to this thread rather than sticky it, but I didn't really know what to call it as it's a bit of a mish-mash, so just called it frequently asked questions...
 
Upvote 0