[BETA] Gather monster stats from Media.pk2

[Nixie]

First off all, this has been just finished, so code is still messy, it takes a bit long to load (40~60 seconds on my computer). But after all, this is supposed to be run only once to create a database or something like that, nothing more. The table in the program is just to show what the results look like.



And the link to the project source (used Visual C++ from VS2005):
Link #1
Link #2

What does it do? It collects all monster data from characterdata.txt (in newer media.pk2 you'll have to merge the 5 files together) and textdataname.txt (for the real names, not the ID like once). You will also notice than you can get a list of NPCs or anything else if you change the filter variable.

I'll keep the thread updated if I should have any improvement for the application. Until then, have fun by exploring the mess of my source (not a big mess, but surely there is some unneeded code). ^^

Update (30.1.2009): As some of you really need the information, here's the MS Access packet with 3 queries which will gather information about pets, thiefs/hunters and all other monsters (normal, unique, FW etc.).

Link #1

[Cruor]

Why not just use Access?

[ineedhelp]

wow most mobs have double even the ammount of mag def than phy def
damn wonder how much a pure int spear nuker will do to mob whos phy def is the same as mag def

[Nixie]

Why not just use Access?

Huh? How would access help here? o_O

(didn't really work a lot with access so far...)

Edit: just tried it and... blah. I failed at this project, access can get all the data. x[
But at least I learned some more coding if not anything else, lol. ^^'

[Mango]

wow most mobs have triple double even quadruple the ammount of mag def than phy def

Not really, they have about 50% more mag defence. Have you looked at your defence recently?

[ineedhelp]

wow most mobs have triple double even quadruple the ammount of mag def than phy def

Not really, they have about 50% more mag defence. Have you looked at your defence recently?

loool damn i was looking at the diff of lvl and phy def lool

[Nixie]

wow most mobs have triple double even quadruple the ammount of mag def than phy def

Not really, they have about 50% more mag defence. Have you looked at your defence recently?

loool damn i was looking at the diff of lvl and phy def lool

lol ^^

Btw... I'll make the connections within these 2 files with Access when I'll have time. Should be faster and easier to do. And what's more important, it will be loading faster. =)

[X3minater]

How do i work with it? :S

[Lempi]

How do i work with it? :S

[Nixie]

It's old and you can do the same with access.

[X3minater]

It's old and you can do the same with access.

OK

But where do i get the data?

The program looks cool on the SS!

[Nixie]

What does it do? It collects all monster data from characterdata.txt (in newer media.pk2 you'll have to merge the 5 files together) and textdataname.txt (for the real names, not the ID like once). You will also notice than you can get a list of NPCs or anything else if you change the filter variable.

[X3minater]

What does it do? It collects all monster data from characterdata.txt (in newer media.pk2 you'll have to merge the 5 files together) and textdataname.txt (for the real names, not the ID like once). You will also notice than you can get a list of NPCs or anything else if you change the filter variable.

I know...i read that!

But its kinda messy in those files... i think your program was supose to organize that "trash" and show it in a cleaner form ... like in the screen shot u put there.

So... i was just wondering how do i get your program to start? Do i need any extra program, like Visual C++ for instance??

[Nixie]

What does it do? It collects all monster data from characterdata.txt (in newer media.pk2 you'll have to merge the 5 files together) and textdataname.txt (for the real names, not the ID like once). You will also notice than you can get a list of NPCs or anything else if you change the filter variable.

I know...i read that!

But its kinda messy in those files... i think your program was supose to organize that "trash" and show it in a cleaner form ... like in the screen shot u put there.

So... i was just wondering how do i get your program to start? Do i need any extra program, like Visual C++ for instance??

You can use Microsoft Access to open the file and parse it.

[/Pi]

I did this a few months back but with Excel >.<" I had to cross reference the info that's already in the wiki to find out what the numbers mean.

If any of you guys are interested in completing the mob stats on the wiki with this program, here's the link to the pages that are incomplete:

http://silkroadwiki.com/wiki/Oasis_Kingdom
http://silkroadwiki.com/wiki/Asia_Minor
http://silkroadwiki.com/wiki/Central_Asia
http://silkroadwiki.com/wiki/Donwhang_Cave
http://silkroadwiki.com/wiki/Taklamakan

[Nixie]

Just checked it. I'd edit it, if there was a template for those pages. Maybe I'll later check the wiki syntax and make a template for monsters.

[X3minater]

I did this a few months back but with Excel >.<" I had to cross reference the info that's already in the wiki to find out what the numbers mean.

If any of you guys are interested in completing the mob stats on the wiki with this program, here's the link to the pages that are incomplete:

http://silkroadwiki.com/wiki/Oasis_Kingdom
http://silkroadwiki.com/wiki/Asia_Minor
http://silkroadwiki.com/wiki/Central_Asia
http://silkroadwiki.com/wiki/Donwhang_Cave
http://silkroadwiki.com/wiki/Taklamakan

Can you share your knoledge I found a couple of them but im still missing some..

I think access parsses it in a wierd form =\

[AznFury]

i thought http://www.sro.mmosite.com had these stats :/

[Nixie]

http://silkroadwiki.com/wiki/Test#Testi ... e_template
What do you think?

[/Pi]

That looks excellent! If this makes it much easier to input the data, then by all means, implement it. There are just a few things to note. This template would be used on the monster spawn map pages such as the ones that I linked. We already have templates for these data though they're separated for some reason (e.g. Mangyang).

We're trying to limit the amount of info on the monster spawn map pages since each monster will be getting their own page where we can put as much information as we can.

Oh, and is there a way to change the orange bar on the name?

[Nixie]

That looks excellent! If this makes it much easier to input the data, then by all means, implement it. There are just a few things to note. This template would be used on the monster spawn map pages such as the ones that I linked. We already have templates for these data though they're separated for some reason (e.g. Mangyang).

We're trying to limit the amount of info on the monster spawn map pages since each monster will be getting their own page where we can put as much information as we can.

Oh, and is there a way to change the orange bar on the name?

http://silkroadwiki.com/wiki/Template:Creature

[Konpaku]

^^

http://www.silkroadonline.wiki.br/mob.a ... na&tipo=ch
http://www.silkroadonline.wiki.br/mob_i ... ghost_clon

i am remake model mobs ^^

[SwordCloud]

Konpaku always there for us,thx you man.

[X3minater]

^^

http://www.silkroadonline.wiki.br/mob.a ... na&tipo=ch
http://www.silkroadonline.wiki.br/mob_i ... ghost_clon

i am remake model mobs ^^

LOL, now that i found a way to use Nixie's Tool (I had to install Visual C++... i was going to install it anyways )

[Nixie]

So it actually didn't work at all? You could mentioned that earlier... ><

[X3minater]

So it actually didn't work at all? You could mentioned that earlier... ><

I thought you knew

I just build the stuff u linked into a Release form and copyed the data files to that folder and runned the SilkMobEdit thing...


I tryed to parse it with access but i was too much work eventualy i found the level, hp, hit and parry ratio, etc. columns but it had too much "trash"


But it looks good now (a little slow to load though )

[nohunta]

what is this used for..?

[X3minater]

what is this used for..?

Its just what you see on the screen shot! To check the mobs stats.



BTW, I uploaded the SilkMobEdit (working ), so if you want to link it on the first post feel free to do it

http://files.filefront.com/SilkMobEditb ... einfo.html

I think you need to have MySQL server instaled... just follow these steps:
http://forums.mysql.com/read.php?11,195 ... msg-195569

[Nixie]

Updated the first post with the access database and queries, hope you'll like it in Access now.