Another eiserver.exe i found

[Mrklawz]

in the loginSRV theres a menu entry under the config one that clears a log, if you click it it gives an error about an invalid object. Looking thru the databases tho the invalid object it refers to is a table in the Manage database, thats why i used Manage as the other DSN entry, it still gives the error tho lol but i guess i have an incorrect permission set.

Not been able to import the stditem, magic & monster files yet, they gotta be table data but dont know if we are supposed to use Game1 or what and create missing tables. It does look tho from looking thru the components with a hex editor that some of the tables are missing from the databases. Ah well early days yet eh?

Just wonder how the L337 server scientists are getting on and if they will give us some clues. I cant help thinking that this post is being laffed at by the uber server coders who's comments are conspicuous by their absence.

c'mon guys throw us a friken bone here :P

 

[Nightwolf]

there tables missing i think as what it says in login server anyway
TBL_PUBIPS
TBL_USERSTATUS
TBL_GMIP
TBL_SERVERINFO

 

[¤]´)÷¤--§îr Äürøñ--¤÷(`[¤]

These files are not EuroEi files.

Tip: JOB = Judgement of Blood.

 

[Nightwolf]

o.O oh tabled not missing they in other dbs Account

 

[iamdeath]

there tables missing i think as what it says in login server anyway
TBL_PUBIPS
TBL_USERSTATUS
TBL_GMIP
TBL_SERVERINFO

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

login server name is Account 2 times with your db p/word i can login just fine now but still not got the game server to run

--------------------------------------------------------------------------------
Last edited by iamdeath : Today at 11:51 AM.

lol read old posts m8 btw i'm at makechar with euromir client

 

[Mrklawz]

When did the Ingame messaging and commissioner appear? JOB? because looking thru StrRes.txt all the system messages for them, plus marriage, guild war matches, streangthening oil etc are there. Dont see any reason why these files would not work with the euromir data tbh. Once the component configuration is sussed then its just down to hard graft of re-doing table data and the define .txt's to suit.

Out of interest, what version is Mir3.CN using right now?

*edit*

Still cant get DbServer to work, looking thru the hex it only seems to access Game1 data but theres a few missing tables, which ive added dummy ones for. Still no luck tho... Getting past this is the major goal i rekon.

 

[Nightwolf]

well login server working ok just the db server that come up with this

[Win32 Error] The operation completed successfully.
DB Server finalized.

 

[Mrklawz]

yup, same for me =/
Must be fault of Game1 dbase?

 

[Nightwolf]

well looking at the db server with a hex editor the tables that dont seem tobe in are
TBL_CHANGEDNAME
TBL_CHAR_INFO
TBL_CURRENTABILITY
TBL_SKILL
TBL_ITEMGIVE

 

[Mrklawz]

made those tables in Game1 and tried to use the fields that are mentioned in the code but still no go ><

 

[Scribe]

lol, least ur login gate connects :P DB i can sort out 1nce im past that, gota feelin it's my sql but dunno wat 2 change.

Night Wolf, where did you get these files? not meaning to be rude but if you got them off a chinese sight, a lot of us have experience in working out more stuff from the sights, if you know, could you either post or PM the site plz? Cheers

 

[Nightwolf]

read thread i already posted the ftp site

 

[Kaori]

I am writing program for viewing/editing the (decoded)stditem etc. I need some testings done... I have found some few fields that's killing me... let me know if you are interested in testing things... only if you have the stuff working. msn is kaorimir@hotmail...

 

[Nightwolf]

what prob are you having with it

 

[Mrklawz]

All i can say is i added all the sources to ODBC as both a USER DSN and a SYSTEM DSN plus made sure all of them connected with SQL verification, plus added Login entries to the Security catagory in MSSQL EntManager for each database and made sure thay all had permissions to access their database.

Kaori, out of interest, the output view of the decoded files, does it show it in its correct formatting? Whenever i've used the CLI tools to Decrypt, the text is a bloody mess (strung out across page) and is most likely why its being a pain to get the gameserver working.

Anybody worked out which component is querying the HeroCommon1, Manage & Conlog databases? It looks to me that Manage is used by LogSRV as the error u get when u click on the "clear usage information" option refers to a TBL in that database, still gives an error tho even if you use Manage as the second DSN entry.

 

[iamdeath]

i'v been looking at the dbserver in hex and there are alot of errors in the tbl so iv made all my tbl's like they are in the dbserver and iv add TBL_ITEMGIVE , TBL_CHAR_INFO , TBL_SKILL , TBL_CURRENTABILITY , TBL_CHANGEDNAME , TBL_BONUSABILITY the TBL's and FLD's are there just like the dbserver is looking for still not running right some of the FLD data is wrong type, cant get the IP to to work in the db server
let me know if you wont the NEW TBL's and FLD's ? or this how to find out for your self if you look at the dbserver in hex and find the start of the FLD goto the end of the list there you will see the TBL names so the first TBL is CHAR_INFO and the first TBL is CHAR_INFO and so on down the file check all the TBL's with the data in the game1 db there are about 6 error's in from the data in the dbserver list just takes a bit of time to look at it all
now do you know why some of the txt files are encrypted and some not i'v encrypted StrRev.txt and it dont like it but you need the encrypt !setup.txt be nice if some can get the encryption out

 

[Scribe]

how'd u get rid of the annoyin win32 error? thx guys

 

[iamdeath]

i'v looked at the server.exe and the stditem,mon.magic db's are not in sql now they use the encrypted files in the envir folder so if we cant decrypt them then we will only have a chines server and we cant change anything in them and it looks the same for all the files we need to make this server in to a euro 1, so we need a server edit exe to make this server work for us

 

[Scribe]

damn lol, every1 shud post ny possible useful links they hav.

 

[Kaori]

Here it is... 3 apps in the zip...
KGSE is for stditem
KGME is for magic
KGMoE is for monster

You have to use command prompt (cmd) for now... still under development

sample usage...
KGSE -d stditem.dat stditemdecrypt.dat
KGSE -c stditemdecrypt.dat stditem.txt
KGSE -m stditemdecrypt.dat stditemrename.txt

after -d and -c, you can open the txt file in excel and say you want chinese simplified encoding for the text and tab as delimitor.

stditemrename.txt only renames the "name" of the item for now... file format is
idxnumber<tab>newname
idxnumber<tab>newname

KGME and KGMoE works just like KGSE... they are for the other 2 files. good luck

Edit: I have decided to take it out until further notice. Others please don't share or post it.