Page 1 of 1

Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Thu Nov 19, 2009 8:36 pm
by PurpleYouko
Well i finally have a workable drops list posted up at my rose fan site :D
http://rose.kuro-tejina.com

guru_screenshot.png


It is cross linked in both directions so that you can look at an item and see what monsters drop it OR you can look at the monsters, get all their stats and stuff and see what items they have been known to drop in order of probability.

Thanks to Rob and anyone else who has contributed to the drops data.
Actually 99% of it is actually from Rob or myself so Image to the rest of you who haven't contributed yet.

Anyway this is the same data that will eventually be used in the dev rev drops table.

It's still not too late help out with this. We need a shed load more data to make it anything like complete
All you have to do is run the proxy recorder while logged in to NARose then send us you log files. Rob and I will extract the data from them

OK So I have Christmas trees showing up in the monsters list :?
They will be gone soon as i work out the correct way to run all the queries.

Also the missing monster images will all be filled in as i have time to take the screen shots.

In fact you guys can help with that too if you like.
I need images that are exactly square and are somewhere around 150 pixels wide.
I prefer .png but I can convert types if you can't save that way. please name them with the monster number so a mini jelly bean will be 1.png and a woopie king would be 205.png. Get the idea?

If you have any piccies just upload them in this thread.

And please people.... Submit those logs with our proxy program. It's so easy to do and we need teh data.

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Wed Nov 25, 2009 8:36 am
by amaedict
very nice website, nice work :)

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Wed Nov 25, 2009 2:22 pm
by Choseal
Awesome!

I don't play the official rose though, so I can't help with the drops at the moment.

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Tue Jun 15, 2010 11:51 pm
by JDoeBoy
Very nice job!!!!

Any chance of maybe helping us out and maybe making a guide to do this for other servers? I have been trying to make a very similar type of interface to my excell and sql files, but I have not had any luck making something automatic like this. What I have to do is look up items I want manualy, then reference them to the drop table and find the id of the mob or map, then back to the npc stb to look up the drop type and write down all of the maps and mobs that drop what I am looking for.

Does this by chance work directly with the stb files you have collected?
What software did you use to interact with the information?
Are you willing to help get this working for other servers (irose etc)?

Thanks for showing me that this isnt beyond what I want to do :-)

JD

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Wed Jun 16, 2010 4:53 pm
by PurpleYouko
I have built an addon to my Excel STB editor that dumps data directly from STBs into MySQL database tables which I then read into my website via PHP

The actual drops information as shown in this thread is collected by means of a proxy server that dumps data from various packets into text files which can then be parsed by special utilities and again converted to MySQL database files for use in the website.
(Yes Microsoft Excel can communicate directly with your database :))

This drops information has since been replaced by "Official" drops data which I am getting from the NA rose dev team directly.

And before you ask. I'm sorry but I cannot release the information contained in that database. They made me promise lol.

However, there's nothing stopping you from checking out the data on my website to build your own tables. Unfortunately the actual drop chance for each item is not included in the data. This, again is information that NA Rose did not want displayed.

As for helping to build informational stuff for other servers.
yes I would be willing to help... BUT (and it's a big BUT) since I started working on my web site and online game development company, my time is actually quite valuable to me so I'm afraid I can't do anything such as tools or web sites completely for free any more.

I don't mind making some tutorials on this site but you will have to either do the actual work yourself or break out your wallets. :D

PM me if you want more information.

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Wed Apr 17, 2013 12:03 pm
by Sham1r0
Youko the database is amazing.
I would like to ask you about the implementation of the system. Is it difficult to code the core of such a database.
I mean I would like to develop a game database, but unfortunately I don't have enough php knowledge to do that. Maybe you would help me a little bit with the core.
Is there for example such a thing like CMS for a database like that?

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Wed Apr 17, 2013 1:54 pm
by PurpleYouko
All my databases are created and maintained using PhpMyAdmin which is a free tool that comes with Xampp
It's really easy to use. Way easier than Navicat.

The actual databases are pretty simple. Just lists of stuff.
The complex stuff is in the way that the PHP code reads, compares and cross references it all.

Re: Drops list added to Kuro-Tejina R.O.S.E. Compendium

PostPosted: Wed Jun 12, 2013 3:32 pm
by Arefinalam18
Wow..Thanks for sharing nice stuff.......i hope next time you will share something more... :D :D :D