Quote:
Would this work?
UPDATE lootdrop_entries SET chance=chance*1;
UPDATE lootdrop_entries SET chance=100 WHERE chance>100;
|
No. This would basically do nothing. If you were to increase the multiplier in such a way as to actually alter the original value, it would apply to every drop on the server. You would need a WHERE clause in there for it to be effective, and I think it's safe to say that if Mort had the knowledge or the inclination to produce that data, he wouldn't be here asking how to do trivial tasks.
This is a case of examining the loot tables/drops and determining what drop chance you want. It is the simplest form of server modification: Database editing.
Now I'm not opposed to answering simple questions, everyone has to start somewhere, but there isn't enough information provided to do that.
Aonelyn seems to be privy to Mort's setup and has probably already provided more than enough information for him to take care of this.
What NPC's are involved? What are their loot table ID's? What probabilities and item chances are associated with those drop entries and drop lists?