Page 1 of 1
[BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 2:42 am
by 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 #1Link #2What 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
Re: [BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 2:48 am
by Cruor
Why not just use Access?
Re: [BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 2:49 am
by 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
Re: [BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 3:05 am
by Nixie
Cruor wrote: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. ^^'
Re: [BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 3:58 am
by Mango
ineedhelp wrote: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?
Re: [BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 4:09 am
by ineedhelp
Mango wrote:ineedhelp wrote: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
Re: [BETA] Gather monster stats from Media.pk2
Posted: Sun Sep 07, 2008 11:56 am
by Nixie
ineedhelp wrote:Mango wrote:ineedhelp wrote: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. =)
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 7:48 pm
by X3minater
How do i work with it? :S
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 8:00 pm
by Lempi
X3minater wrote:How do i work with it? :S
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 9:04 pm
by Nixie
It's old and you can do the same with access.
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 9:10 pm
by X3minater
Nixie wrote: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!
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 9:30 pm
by 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.
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 9:42 pm
by X3minater
Nixie wrote: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??
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 9:49 pm
by Nixie
X3minater wrote:Nixie wrote: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.
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 10:19 pm
by /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_Kingdomhttp://silkroadwiki.com/wiki/Asia_Minorhttp://silkroadwiki.com/wiki/Central_Asiahttp://silkroadwiki.com/wiki/Donwhang_Cavehttp://silkroadwiki.com/wiki/Taklamakan
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 10:29 pm
by 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.
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 11:06 pm
by X3minater
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 =\
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 11:07 pm
by AznFury
i thought
http://www.sro.mmosite.com had these stats :/
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 11:19 pm
by Nixie
Re: [BETA] Gather monster stats from Media.pk2
Posted: Wed Jan 28, 2009 11:54 pm
by /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?
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 6:27 am
by Nixie
Prophet Izaach wrote: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
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 5:28 pm
by Konpaku
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 6:30 pm
by SwordCloud
Konpaku always there for us,thx you man.
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 9:28 pm
by X3minater
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
)
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 10:06 pm
by Nixie
So it actually didn't work at all? You could mentioned that earlier... ><
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 10:17 pm
by X3minater
Nixie wrote: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
)
Re: [BETA] Gather monster stats from Media.pk2
Posted: Thu Jan 29, 2009 10:51 pm
by nohunta
what is this used for..?
Re: [BETA] Gather monster stats from Media.pk2
Posted: Fri Jan 30, 2009 12:38 pm
by X3minater
nohunta wrote: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.htmlI think you need to have MySQL server instaled... just follow these steps:
http://forums.mysql.com/read.php?11,195 ... msg-195569
Re: [BETA] Gather monster stats from Media.pk2
Posted: Fri Jan 30, 2009 1:55 pm
by Nixie
Updated the first post with the access database and queries, hope you'll like it in Access now.