Runescape drop database

[crazykiwi]

After starting my drop database site a couple of weeks ago there's been over 1000 kills submitted, although spread across 20 monsters there's not a lot of interesting statistics (but mithril dragons look to be good charm droppers if you can handle them).

 

A basic bulk list submitting page has now been added too, for those of you who have made massive lists.

 

I still have a lot of ideas to work on, and not really a lot of spare time to code them, but the site has been an interesting project so far.

 

 

 

Come check it out at http://www.rsdrop.com if you haven't already. Check out the statistics on the drops recorded so far, and make an account to add your own drop data to the database. Let's see if we can work out the drop chance from some of runescape's commonly killed monsters.

[Xecer]

We don't care. This seems against the rules..

[DarkDude]

This topic was here before the downtime and had several pages, it is perfectly fine.

 

 

 

Good to see you've cleared the visage drop from miths, I'll start adding my drops again when i start up at miths.

[crazykiwi]

This topic was here before the downtime and had several pages, it is perfectly fine.

 

 

 

Good to see you've cleared the visage drop from miths, I'll start adding my drops again when i start up at miths.

 

 

 

Heh, re-reading my post it does look a bit spammy... good to see people remember the old topic from last week.

 

 

 

That visage drop really stood out, that person had only submitted one drop, so it was clearly wrong. The admin side of the site makes it easy to spot and remove such anomalies.

[Harrington]

I like the idea of that particular site, but it has virtually no content just now. Much of the data is based on just a few kills of each type of monster. You need at least a few hundred kills to gain an accurate drop rate of the common and semi-common drops.. several thousand kills for the rarer stuff.

[DarkDude]

I like the idea of that particular site, but it has virtually no content just now. Much of the data is based on just a few kills of each type of monster. You need at least a few hundred kills to gain an accurate drop rate of the common and semi-common drops.. several thousand kills for the rarer stuff.

 

 

 

Which is why you submit your drops as you go along, so that it does have content in the future. Just ignoring it and not adding content is not the point of the site, it's an interactive website.

 

 

 

All of those mith dragon drops (Other than maybe a few wealth kills maybe) were added by me, wasn't any trouble for me at all.

[Harrington]

I like the idea of that particular site, but it has virtually no content just now. Much of the data is based on just a few kills of each type of monster. You need at least a few hundred kills to gain an accurate drop rate of the common and semi-common drops.. several thousand kills for the rarer stuff.

 

 

 

Which is why you submit your drops as you go along, so that it does have content in the future. Just ignoring it and not adding content is not the point of the site, it's an interactive website.

 

 

 

All of those mith dragon drops (Other than maybe a few wealth kills maybe) were added by me, wasn't any trouble for me at all.

 

 

 

I'm not having a go... I like it, I'm just saying it needs a lot of work. My concern is people deliberately submitting false data, you have to rely on everyone being honest (not a trait that Runescape players are famous for lol). I think there should be a minimum number of kills to be submitted, say 50, which should cover most slaying tasks?

[DarkDude]

That's a good idea actually, have a user have to submit 50 drops before they're added to the database - after that point all drops are added (After being check to make sure they seem legit)

[Harrington]

That's a good idea actually, have a user have to submit 50 drops before they're added to the database - after that point all drops are added (After being check to make sure they seem legit)

 

 

 

Yer, that would be ideal :)

[crazykiwi]

I'm not having a go... I like it, I'm just saying it needs a lot of work. My concern is people deliberately submitting false data, you have to rely on everyone being honest (not a trait that Runescape players are famous for lol). I think there should be a minimum number of kills to be submitted, say 50, which should cover most slaying tasks?

 

False data has been my biggest concern when making the site too, currently I'm handling it by an automated scan that looks for drops that are too far out of line with others submissions, although with such a low number of recorded drops so far it's still not great. If I do find someone has recorded false data I can easily remove everything they submitted.

 

 

 

A minimum number of kills is an interesting idea, although right now it would eliminate most users so far. The way I've structured the database wouldn't make it that easy to implement without a bit of work, but I'll add it to my list of ideas.

[Harrington]

I'm not having a go... I like it, I'm just saying it needs a lot of work. My concern is people deliberately submitting false data, you have to rely on everyone being honest (not a trait that Runescape players are famous for lol). I think there should be a minimum number of kills to be submitted, say 50, which should cover most slaying tasks?

 

False data has been my biggest concern when making the site too, currently I'm handling it by an automated scan that looks for drops that are too far out of line with others submissions, although with such a low number of recorded drops so far it's still not great. If I do find someone has recorded false data I can easily remove everything they submitted.

 

 

 

A minimum number of kills is an interesting idea, although right now it would eliminate most users so far. The way I've structured the database wouldn't make it that easy to implement without a bit of work, but I'll add it to my list of ideas.

 

 

 

Nice work. Well I've added it to my bookmarks and will contribue whenever I can. Good job :)

[Were]

All 100 f2p lesser demon kills are mine :P

 

 

 

Could you add:

 

 

 

Cockroaches

 

Ice giants/warriors

 

Ankous?

[coenvg]

The website looks really sad,

 

 

 

come on make a decent background :?

 

 

 

:roll: oops :D

[Ezz]

I'll start using this when I start doing Slayer again :D

[crazykiwi]

The website looks really sad,

 

 

 

come on make a decent background :?

 

 

 

:roll: oops :D

 

I have the drawing and design skills of a monkey smoking too much crack :? . Seriously, you're lucky it even looks this good. Maybe I'll get around to making it look better one day. Maybe I should learn CSS?

[Laps9]

This was a really good idea. Only problem is the time it will take before it gets even remotely accurate but at the moment it can still give a very good idea of drops etc...

 

 

 

One suggestion, ignoring the amount of monsters to get drops from, what about loot from implings? This would take longer for higher leveled ones but would help out all those who do the impling roulette on the ge.

[palas1]

We don't care. This seems against the rules..

 

The only thing that is/should be against the rules is rude behaviour like this from tipit staff towards tipit members. :shame:

[Atroxide]

We don't care. This seems against the rules..

 

I am so glad Tip.it staff is is a great mood. :|

 

 

 

 

 

I have logs of 100 black dragons (in process of doing more atm also).

 

 

 

If you could add those then that would be wonderful :)

 

 

 

And by chance could you post how you structured your database? I can't seem to find any possible way without having it not dynamic. (Database structure as in how you set your database)

[daigotsu]

A couple of feedback issues:

 

 

 

• On my first use of the system, I took the checkboxes to mean "if you have ever received this as a drop, check it" and selected multiple items for the Kalphite Queen. If the drops are meant to be singular it would be better to use radio buttons instead of checkboxes; you could even have a link option for a monster that drops multiple items at the same time.

 

 

 

• After I submit a drop and wait for the redirect, the page it redirects to fails to load. In Internet Explorer 7, I get a blank white screen -- from my own experienced with PHP, that means the page is bugged somewhere; I wish you luck with the debugging.

 

 

 

• Would it be possible for users to see their own submitted list of drops? Could be helpful in determining if the system is being used properly.

 

 

 

Neat idea, hope it catches on.

 

 

 

D

[Atroxide]

The website looks really sad,

 

 

 

come on make a decent background :?

 

 

 

:roll: oops :D

 

I have the drawing and design skills of a monkey smoking too much crack :? . Seriously, you're lucky it even looks this good. Maybe I'll get around to making it look better one day. Maybe I should learn CSS?

 

I created a basic HTML/CSS template, if you want to use it MSN me at [email protected] or email me at [email protected].

 

http://www.dvclan.org/rsdrop/

[mchainmail]

I'm not sure how you're going to integrate clue scrolls. Once someone has a scroll, they won't get another. Maybe keep a separate count of kills where the player *could* get a clue scroll for the average?

[DarkDude]

A couple of feedback issues:

 

 

 

• On my first use of the system, I took the checkboxes to mean "if you have ever received this as a drop, check it" and selected multiple items for the Kalphite Queen. If the drops are meant to be singular it would be better to use radio buttons instead of checkboxes; you could even have a link option for a monster that drops multiple items at the same time.

 

 

 

 

A lot of monsters have "multiple" drops, most clue drops are seperate to the main drops, then things such as charms added to this. With mith dragons pretty much every drop had atleast two boxes to check, sometimes 3 as they can drop a shark with their drop too.

 

 

 

Maximum possible is Mith dragons I think - Dragon Bones, Mith Bars, clue, Normal Drop, Shark, Visage. Or KBD Dragon Bones, Dragonhide, clue, normal drop, visage and kbd head.

[Junkmutt]

I'll put some data in when I start my slaying again after this dumb rocking out quest.....

[crazykiwi]

• After I submit a drop and wait for the redirect, the page it redirects to fails to load. In Internet Explorer 7, I get a blank white screen -- from my own experienced with PHP, that means the page is bugged somewhere; I wish you luck with the debugging.

 

 

I use firefox, and thought my html was basic enough to work with anything... guess I was wrong. It turns out IE7 has "meta refresh redirect" turned off by default, and that's how I was doing the redirect. After a little research I've now got a javascript redirect in there instead, this now works in IE7, and still have the meta refresh redirect in there for anyone who has javascript turned off. Let me know if there are any more problems like this, bugs suck!

 

 

 

• Would it be possible for users to see their own submitted list of drops? Could be helpful in determining if the system is being used properly.

 

I've added an "options" page that tells you how many total drops you've submitted. The way the database works I'm adding the drops together rather than keeping each individual drop, so a full list is now impossible, but I could add something like "56 Lesser demon kills, 32 Green dragon kills", and even list the total for each item eg."56 Lesser demon kills with 32 coin drops, 10 chaos runes, 5 gold charms..." although that could get rather big.

 

I'll think about it and add it to the growing list of ideas for improvements (must get around to implementing some of those...)

[crazykiwi]

All 100 f2p lesser demon kills are mine :P

 

 

 

Could you add:

 

 

 

Cockroaches

 

Ice giants/warriors

 

Ankous?

 

Ah, the great f2p player! I wanted to make sure I had a few good f2p monsters in there so everyone could use this.

 

Added all those now.