Mir2 2.3 Server Files

Mu online season 21 - grand opening

Tasha

LOMCN Veteran
Veteran
Loyal Member
May 13, 2003
498
0
93
thats alot of tbl's to add lol ><
is there n e quick way to add em?
 
Last edited:

johnyl1

Golden Oldie
Golden Oldie
Apr 24, 2003
755
42
165
Portugal
most of the tables are already on the db's, i noticed that they match mir3 tables. U just need to add some of them.
 

Tasha

LOMCN Veteran
Veteran
Loyal Member
May 13, 2003
498
0
93
yea they gonna be working towards mir3 rdy for the changes that never happened lol :)
 

Killmaster

Legend
Legendary
Golden Oldie
Loyal Member
Nov 13, 2003
3,967
27
274
Killmaster said:
========================================
ready to load ini file..
!setup.txt loaded..
loading client version information..
Ok. Mir2.dat(1000218078) (0) (0)
loading StdItem.DB...
starttimer exception...
Not ready 127.0.0.1

i get this error now, it used to work before i formatted pc and havent done anything different in the setup side of thing, well i dont think i have :err:

someone have an idea how to fix this?
 

Primal

LOMCN VIP
VIP
Jun 28, 2004
1,756
102
289
Killmaster said:
someone have an idea how to fix this?
i had that when i put wrong sql id + pass in in one of the files, check ur files and make sure all ur sql id's + pass's are correct + the same
 

Elvin

Golden Oldie
Golden Oldie
May 14, 2003
1,155
1
175
middlesex
Nightwolf said:
you know the TBL_M2PREMIUMUSER are you not mssing any fields here all what should be in it i think

FLD_LOGINID
FLD_SERVERNAME
FLD_CHARNAME
FLD_SPECIALFLAG
FLD_BASICFLAG
FLD_ENDDATE
FLD_BIRTHDAY
FLD_FORCEDATE
EVENT_COMEBACK2005
FLD_FORCEFLAG
FLD_FIRSTLOGIN
yousure these 2 are sposed to be in ?
thought id seen em somewhere else
 

Elvin

Golden Oldie
Golden Oldie
May 14, 2003
1,155
1
175
middlesex
johnyl1 said:
most of the tables are already on the db's, i noticed that they match mir3 tables. U just need to add some of them.

so if we look thru the ei dbs and add some stuff that might be missing especially in lom2game and lom2account we will be able to make saves to the db .. just an inquisitive question
 

Nightwolf

Developer
VIP
Jul 16, 2003
2,133
21
265
Manchester, UK
ok managed to find some more db values as below still need to find holy for the holytaowheel yet



EFFTYPE1 3 EFFVALUE1 1 = luck+1

which can be added to armor and complete the heavenarmor stats


EFFTYPE1 5 EFFRATE1 2 EFFVALUE1 2 = HPR+20% MPR+20%

Which can be added to armor also will complete the mirarmor stats

hope this helps afew ppl out :)
 
Last edited:

xsoffee

Dedicated Member
Dedicated Member
Dec 1, 2005
38
0
32
Mars
@market_0 All Items Market
@market_1 Weapons Market
@market_2 Necklaces Market
@market_3 Rings Market
@market_4 Bracelets Market
@market_5 Charms Market
@market_6 Helmets Market
@market_7 Belts Market
@market_8 Shoes Market
@market_9 Armors Market
@market_10 Drugs Market
@market_11 Gems & Orbs Market
@market_12 Books Market
@market_13 Minerals Market
@market_14 Quests Market
@market_15 Other Items Market
 

Primal

LOMCN VIP
VIP
Jun 28, 2004
1,756
102
289
xsoffee said:
@market_0 All Items Market
@market_1 Weapons Market
@market_2 Necklaces Market
@market_3 Rings Market
@market_4 Bracelets Market
@market_5 Charms Market
@market_6 Helmets Market
@market_7 Belts Market
@market_8 Shoes Market
@market_9 Armors Market
@market_10 Drugs Market
@market_11 Gems & Orbs Market
@market_12 Books Market
@market_13 Minerals Market
@market_14 Quests Market
@market_15 Other Items Market
dont suppose you could post a working TrustMerchant and GuildTerritory npc? :) any language doesnt matter
 

spunky05

LOMCN Veteran
Veteran
Loyal Member
Oct 7, 2003
271
1
95
Smallville
xsoffee said:
@market_0 All Items Market
@market_1 Weapons Market
@market_2 Necklaces Market
@market_3 Rings Market
@market_4 Bracelets Market
@market_5 Charms Market
@market_6 Helmets Market
@market_7 Belts Market
@market_8 Shoes Market
@market_9 Armors Market
@market_10 Drugs Market
@market_11 Gems & Orbs Market
@market_12 Books Market
@market_13 Minerals Market
@market_14 Quests Market
@market_15 Other Items Market

Got any info on the tables needed to make this work?

also heres a EuroMir TradeMerchent and GuildTerritory NPC i made, cant test it though untill the correct tables are added.
 

Attachments

  • Bichon_TrustMerchant-0.txt
    4 KB · Views: 43
  • Bichon_GTMerchant-0.txt
    2.3 KB · Views: 34

Primal

LOMCN VIP
VIP
Jun 28, 2004
1,756
102
289
spunky05 said:
Got any info on the tables needed to make this work?

also heres a EuroMir TradeMerchent and GuildTerritory NPC i made, cant test it though untill the correct tables are added.
ty for npcs, lol e-mail GNOnline or LegendOfMir staff and ask for the tables from them XD
 

NickAKAVexus

Golden Oldie
Golden Oldie
Apr 16, 2005
1,427
1
125
New york
Why do you have

#IF
#SAY

What does the #IF do? shouldn't be there it does nothing and just takes up more processing time. :X
 

spunky05

LOMCN Veteran
Veteran
Loyal Member
Oct 7, 2003
271
1
95
Smallville
NickAKAVexus said:
Why do you have

#IF
#SAY

What does the #IF do? shouldn't be there it does nothing and just takes up more processing time. :X

Because I find it easyer to read and edit with them there :P (starts to look messy if you dont add them imo).
also you would have to have a REALLLLLLY bad pc for it to affect processing time...
 

NickAKAVexus

Golden Oldie
Golden Oldie
Apr 16, 2005
1,427
1
125
New york
spunky05 said:
Because I find it easyer to read and edit with them there :P (starts to look messy if you dont add them imo).
also you would have to have a REALLLLLLY bad pc for it to affect processing time...

Why not use:
[@test]
;#IF
#SAY
bla bla


; is ignored. lol bit pointless making it process that crap.:X
 

Primal

LOMCN VIP
VIP
Jun 28, 2004
1,756
102
289
LOM2Game->
TBL_ITEMMARKET->
FLD_SERVER nchar 14 1
FLD_MARKETNAME nchar 25 1
FLD_SELLINDEX int 4 0
FLD_ITEMNAME nchar 25 1
FLD_SELLWHO nchar 25 1
FLD_SELLPRICE int 4 1
FLD_SELLDATE datetime 8 1
FLD_ITEMTYPE int 4 1
FLD_ITEM_MAKEINDEX int 4 1
FLD_ITEM_INDEX int 4 1
FLD_ITEM_DURA int 4 1
FLD_ITEM_DURAMAX int 4 1
FLD_ITEM_DESC0 int 4 1
FLD_ITEM_DESC1 int 4 1
FLD_ITEM_DESC2 int 4 1
FLD_ITEM_DESC3 int 4 1
FLD_ITEM_DESC4 int 4 1
FLD_ITEM_DESC5 int 4 1
FLD_ITEM_DESC6 int 4 1
FLD_ITEM_DESC7 int 4 1
FLD_ITEM_DESC8 int 4 1
FLD_ITEM_DESC9 int 4 1
FLD_ITEM_DESC10 int 4 1
FLD_ITEM_DESC11 int 4 1
FLD_ITEM_DESC12 int 4 1
FLD_ITEM_DESC13 int 4 1
FLD_ITEM_LEVELR int 4 1
FLD_ITEM_AMOUNTGB int 4 1
FLD_ITEM_PREFIX nchar 13 1
FLD_TEXT nchar 121 1
FLD_CHECK nchar 20 1
FLD_BUYER nchar 25 1
FLD_BUYDATE datetime 8 1
FLD_SELLOK smallint 2 1

can sum1 try that and post if it allows u to consign items in the TrustMerchant, ty
 

spunky05

LOMCN Veteran
Veteran
Loyal Member
Oct 7, 2003
271
1
95
Smallville
badboyadam said:
LOM2Game->
TBL_ITEMMARKET->
FLD_SERVER nchar 14 1
FLD_MARKETNAME nchar 25 1
FLD_SELLINDEX int 4 0
FLD_ITEMNAME nchar 25 1
FLD_SELLWHO nchar 25 1
FLD_SELLPRICE int 4 1
FLD_SELLDATE datetime 8 1
FLD_ITEMTYPE int 4 1
FLD_ITEM_MAKEINDEX int 4 1
FLD_ITEM_INDEX int 4 1
FLD_ITEM_DURA int 4 1
FLD_ITEM_DURAMAX int 4 1
FLD_ITEM_DESC0 int 4 1
FLD_ITEM_DESC1 int 4 1
FLD_ITEM_DESC2 int 4 1
FLD_ITEM_DESC3 int 4 1
FLD_ITEM_DESC4 int 4 1
FLD_ITEM_DESC5 int 4 1
FLD_ITEM_DESC6 int 4 1
FLD_ITEM_DESC7 int 4 1
FLD_ITEM_DESC8 int 4 1
FLD_ITEM_DESC9 int 4 1
FLD_ITEM_DESC10 int 4 1
FLD_ITEM_DESC11 int 4 1
FLD_ITEM_DESC12 int 4 1
FLD_ITEM_DESC13 int 4 1
FLD_ITEM_LEVELR int 4 1
FLD_ITEM_AMOUNTGB int 4 1
FLD_ITEM_PREFIX nchar 13 1
FLD_TEXT nchar 121 1
FLD_CHECK nchar 20 1
FLD_BUYER nchar 25 1
FLD_BUYDATE datetime 8 1
FLD_SELLOK smallint 2 1

can sum1 try that and post if it allows u to consign items in the TrustMerchant, ty

Nope, still wont let me :(