Classic or era-based server content

[AdrianD]

I can tell you many quest are just flat out missing

Perfection is impossible.

PEQ uses Magelo for drop rates but from my experience they are not accurate, even for the current era.

It's easy to drop any magelo generated loottable/lootdrop. There are quite a few of the above table entries that go unused which could be matched up with a bit of work.

It's also easy to drop all items outside of an expansion if those items are labelled with an expansion - like I have done for 60k+ items - so some of the magelo gen data dropping isn't necessary.

This is what I'm basically talking about. Getting the data proper in the database is huge as everyone has said. I've made some of it so simple a caveman can help!

[provocating]

I am pretty sure the Magelo issue has to lie with multiple items dropping off of creatures. Magelo drop rates do not show quantities so if a Crag Spider drops 8 silks, that would be a 800% drop rate on that one drop. I do not think Magelo's website ever shows above 100%

[AdrianD]

Originally Posted by provocating

I am pretty sure the Magelo issue has to lie with multiple items dropping off of creatures. Magelo drop rates do not show quantities so if a Crag Spider drops 8 silks, that would be a 800% drop rate on that one drop. I do not think Magelo's website ever shows above 100%

It seems that lootdrop.ids were added along with existing one when this was done. There are several columns in `loottable_entries` and `lootdrop_entries` which control this. <chance, multiplier, mindrop, probability> all of these combined create an environment that when you kill `a_large_rat` you get twelve items.

[provocating]

I do not think you understood what I was saying. Look at...

http://eq.magelo.com/npc/7155

See the spider shows it drops silk 85% of the time? What the emulator would translate that to is dropping 1 silk 85% of the time. I am not sure how the Magelo import routine works but I would think it could possibly get the percentages right on multiples. A Crag spider can possibly drop up to 8 silks. It may be 15% with an 8x multiplier, but it is possible.

[AdrianD]

I've never looked at magelo grabs so perhaps I misunderstood you.

I know what I see in the DB though. A multiplier value was assigned somehow.

As far as crag spiders specifically: they have dropped large numbers of silks since back in PoP days if not earlier, I'm unsure exactly how far back

[AdrianD]

If you have virgin ears, click out of this thread...

...................

A snippet from a convo I had recently regarding this general issue:

I seem to be met on many sides by people unwilling.

...................

Sounds good. Although, I like the structure of git with a master and branches. For example: Adrian has table x1,y1,z1 in his branch, <soandso> has x2,y2,z2 and these can be combined or chosen separately as a more complete data set to Master xm,ym,zm.

Agreed

Those people should go away. Fucked up to say that to someone in your "community." I've seen some of the comments made in your direction. Fucked up people.

Agreed

My comments: I can't say this enough... Why on earth would someone want to do this more than once?! It's tedious, boring - I'd rather pull my fingernails out than know you are editing the same exact DB entry with virtually the same new data. It's fucking stupid man!

I am not going to spend 5 years of my free time to repeat what someone else has done but is too stubborn or stingy to share, when what they have was shared with them. It contradicts everything about why this EMU started.

I hear you on all that other stuff but this is the bottom line for me. <above >

Egos abound!

[provocating]

I am "egobound" ? Not hardly.

You wanted to start this project, you started the thread, not me.

That entire PM, was sent you you in confidence. There again I do not send anything in a PM that I would be ashamed of. You are definitely not going about this endeavor of yours in a fashion that would encourage people to help you.

Several PM's you sent me were pretty narcissistic but I will not post these here in a public forum. Good luck on your project, I definitely will not be contributing to it. You are showing your true colors.

And yes you have to do it yourself. As I said before I have been faced with much negativity on my project but I stick to my guns on what I want. I put in countless hours of GM'ing, server maintenance, bug reports. I am not going to stop what I am doing to help you. No one stopped what they were doing to help me. As I said my server comes first above everything else except my day job.

[AdrianD]

This is what I'm basically talking about. Getting the data proper in the database is huge as everyone has said. I've made some of it so simple a caveman can help!

To add:

I don't feel like carrying on and on about what I have done because I'm not an self-centered egomaniac like some. But, I also feel that I am doing a disservice to the segment of the community that wants classic/progression by not harping about what I have done (started).

It's very important to get these things (lootdrops, items, npcs, other database stuff) correct. I've spent about as much time developing my system as I have changing data (maybe not, but I said this for effect).

P99 has done it with whoever they have.

I see no fucking reason a much larger community can't!

Get with it...

[MarcusD]

Originally Posted by AdrianD

Perfection is impossible.



It's easy to drop any magelo generated loottable/lootdrop. There are quite a few of the above table entries that go unused which could be matched up with a bit of work.

It's also easy to drop all items outside of an expansion if those items are labelled with an expansion - like I have done for 60k+ items - so some of the magelo gen data dropping isn't necessary.

This is what I'm basically talking about. Getting the data proper in the database is huge as everyone has said. I've made some of it so simple a caveman can help!

I have not yet graduated to caveman level but I will be helping at some point lol. I need to learn more about databases...learning how to use Heidisql would probably help .

[AdrianD]

Contact me bro!

It's in my selfish nature to assist people where I can so I can achieve my self-righteous goal of getting classic content?

Yeah, that's it...