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

Whatever you want to talk :)

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Forum rules
You can talk about just whatever you want here.

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

Postby PurpleYouko on Thu Nov 19, 2009 8:36 pm

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.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

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

Postby amaedict on Wed Nov 25, 2009 8:36 am

very nice website, nice work :)
We Have it all ... Image
Image
User avatar
amaedict
Clown
Clown
 
Posts: 531
Joined: Thu Apr 23, 2009 2:44 pm

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

Postby Choseal on Wed Nov 25, 2009 2:22 pm

Awesome!

I don't play the official rose though, so I can't help with the drops at the moment.
Choseal
Electric Ghost
Electric Ghost
 
Posts: 837
Joined: Fri Jan 09, 2009 6:40 pm

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

Postby JDoeBoy on Tue Jun 15, 2010 11:51 pm

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
JDoeBoy
Smoulie
Smoulie
 
Posts: 69
Joined: Fri Apr 10, 2009 12:59 am

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

Postby PurpleYouko on Wed Jun 16, 2010 4:53 pm

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.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

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

Postby Sham1r0 on Wed Apr 17, 2013 12:03 pm

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?
Working on OsRose Dev revision II atm. Client v307

Image
User avatar
Sham1r0
Pomic
Pomic
 
Posts: 124
Joined: Sun Mar 29, 2009 5:34 pm
Location: Kaunas

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

Postby PurpleYouko on Wed Apr 17, 2013 1:54 pm

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.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

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

Postby Arefinalam18 on Wed Jun 12, 2013 3:32 pm

Wow..Thanks for sharing nice stuff.......i hope next time you will share something more... :D :D :D
Arefinalam18
Little soul
Little soul
 
Posts: 5
Joined: Wed Jun 12, 2013 10:05 am


Return to Whatever

Who is online

Users browsing this forum: No registered users and 2 guests

cron