[Mangos] A couple of questions with edditing Mangos

[wardain]

Atm im running a Mangos server with high XP and drop rates, XP is 50X and droprate is 20X.

But the problem i have is that i want to increse the chanse of getting more of blue drops and such, as now i mostly see only gray items drops and most drops seems to be the same.

I SQLyog up but i cant seem to find any rates or numbers that can be changed in loot_templates.

Any help in this matter or a kick in the right direction would be great, i do know some programming skills so im not totaly lost there.


Thanks in advance

[MentaL]

[Shozokui]

It's kind of complicated. what the monsters drops is under creature_template, There will be a column to change which loot template you want to use. You see, Loot_template is just a compilation of different lists of what can drop. if you want it to be more enemy specific to what drops off of what mobs, just create a couple new lines with the items you want, but all the lines must have the same ID. then, go under creature_template and find the monster you want to have that certain template, and put the ID of the template you made in it's loot temp id column(that name can vary, I don't know the exact name)

[wardain]

Thanks alot!

If anybody have anything more to add i would be happy :)

[kennythekid]

why don't use a slq query :))

update creature_loot_template SET chanceorref=100 WHERE entry IN (mobs ids);

or figure another way


but first backup tables

EDIT:

if u take a look at ur creature_loot_table u have maxcount column that can be 0 or 1 now the easyer way to get ur drop count bigger u have to do like

update creature_loot_template SET chanceorref=100 WHERE maxcount=1;
and one more where maxcount 0
update creature_loot_template SET chanceorref=100 WHERE maxcount=0;
REMEMBER THIS IS A MASS LOOT TEMPLATE CHANGE

for specific items u have to do like

UPDATE creature_loot_template SET chanceorref=100 WHERE item IN (items ids);

CHeerz

KEn!

[wardain]

Thanks Kenny.

I found this code at the SDB forum that altered the green drops to a lower % as some revs ago they were way to high and modified it abit.

Here is my modified:

UPDATE creature_template,creature_loot_template,item_template SET creature_loot_template.chanceorref=creature_template.maxlevel/60*20
WHERE creature_template.lootid=creature_loot_template.entry
AND (item_template.entry=creature_loot_template.item AND item_template.Quality=2)
AND creature_template.rank<1;

But can i use the same one and just modify the template.quality=2 to 3 to make blue ones drop more often?

Dont know how this is gonna affect the green drops as SQLyog is still queryingl (been going on for 1 hour)

Btw anybody know how much more it will querying ? :D got a fast comp.

thanks again