DROP Rate

[thanatos]

If u make the drop rate x8 then all the drops drop with x8 time more but this includes unique jewels too. how to change the drop rate without droping 8 ring of baiums or 8 earing of antharas for example?

[killer_007]

You will have to change the rates manually with an sql query... All drops *8 except ids x xx xxx xxxx

 

Search on google, it isn't difficult to make such a query... There is some pro documentation...

[thanatos]

ty killer. but what should i type to search?

[Angel Of Death]

If you want to manually multiply all the drops in the list except the ones you want...

The code should be like this:

Update `droplist` SET `min` = `min`*8 Where NOT `itemId` IN (ITEM IDS);
Update `droplist` SET `max` = `max`*8 Where NOT `itemId` IN (ITEM IDS);
Update `droplist` SET `chance` = `chance`*8 Where NOT `itemId` IN (ITEM IDS);

 

But You could actually do the opposite...Divide the items you don't want to be multiplied...

After you have set the Rate to x8...

 

This code should look like this:

Update `droplist` SET `min` = `min`/8 Where `itemId` IN (ITEM IDS);
Update `droplist` SET `max` = `max`/8 Where `itemId` IN (ITEM IDS);

 

Where ITEM IDS are the ids of the items you don't want to be multiplied...

e.g.: ('1','2','3')

I hope you got what i mean...If you have any probs reply here :P

[killer_007]

http://www.w3schools.com/sql/default.asp

 

Angel of death, yes that's it, but it's better for him to learn something T.T If he followed that tut over there we would learn that and even more...

 

You can also use this to make it faster, as jewels are in a range...

 

Update `droplist` SET `min` = `min`*8 Where NOT `itemId` BETWEEN x1 AND x2;

Update `droplist` SET `max` = `max`*8 Where NOT `itemId` BETWEEN x1 AND x2;

Update `droplist` SET `chance` = `chance`*8 Where NOT `itemId` BETWEEN x1 AND x2;

 

You could even also do something like this...

 

Update `droplist` SET `min` = `min`*8 Where NOT `itemId` BETWEEN x1 AND x2 AND item_id2 NOT IN (x3,x4);

Update `droplist` SET `max` = `max`*8 Where NOT `itemId` BETWEEN x1 AND x2 AND item_id2 NOT IN (x3,x4);

Update `droplist` SET `chance` = `chance`*8 Where NOT `itemId` BETWEEN x1 AND x2 AND item_id2 NOT IN (x3,x4);

 

Simple operators usage :)

 

And for example, if you wish only item X15 not to get *8

 

Update `droplist` SET `min` = `min`*8 Where NOT `itemId` <> x15;

Update `droplist` SET `max` = `max`*8 Where NOT `itemId` <> x15;

Update `droplist` SET `chance` = `chance`*8 Where NOT `itemId` <> x15;

 

I can even give you more that this that you may need... For example, you could also use < or <= maybe > or >=. Or even using % (Where NOT `itemId` <> x1%). There are thousands of commands :P You can combine them!

 

Everything is described in that tutorial... You can also check this one: http://www.mckoi.com/database/SQLSyntax.html It's a little bit pro, but you will find more...

[Angel Of Death]

Hmm nice, i've actually never read any tutorial of SQL and i have no knowledge on it :P

I just try to find out how to learn myself...

Also , i didn't know the jewels where in a range , nice...

[thanatos]

I thinked something else. make (min*8,max*8,chance*8) but dont make *8 in mobId(baium,ant,valakas,antharas,zaken,orfen). how will that look like?

[Angel Of Death]

But the codes above don't make mobid*8 anyway...

[killer_007]

No, he says everything to get *8 except the raid bosses... Yeah, you can do that, it won't change all the drops of these mobs.

[Angel Of Death]

Oups, yeap got it, my bad, i woke up a few minutes before the post and so...

Well, it should look like this:

Update `droplist` SET `min` = `min`*8 Where NOT `mobId` IN ('1','2','3',...)
Update `droplist` SET `max` = `max`*8 Where NOT `mobId` IN ('1','2','3',...)
Update `droplist` SET `chance` = `chance`*8 Where NOT `mobId` IN ('1','2','3',...)