thanatos Posted July 24, 2007 Share Posted July 24, 2007 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? Link to comment Share on other sites More sharing options...
0 killer_007 Posted July 24, 2007 Share Posted July 24, 2007 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... Link to comment Share on other sites More sharing options...
0 thanatos Posted July 24, 2007 Author Share Posted July 24, 2007 ty killer. but what should i type to search? Link to comment Share on other sites More sharing options...
0 Angel Of Death Posted July 25, 2007 Share Posted July 25, 2007 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 Link to comment Share on other sites More sharing options...
0 killer_007 Posted July 25, 2007 Share Posted July 25, 2007 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... Link to comment Share on other sites More sharing options...
0 Angel Of Death Posted July 26, 2007 Share Posted July 26, 2007 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... Link to comment Share on other sites More sharing options...
0 thanatos Posted July 30, 2007 Author Share Posted July 30, 2007 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? Link to comment Share on other sites More sharing options...
0 Angel Of Death Posted July 30, 2007 Share Posted July 30, 2007 But the codes above don't make mobid*8 anyway... Link to comment Share on other sites More sharing options...
0 killer_007 Posted July 30, 2007 Share Posted July 30, 2007 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. Link to comment Share on other sites More sharing options...
0 Angel Of Death Posted July 30, 2007 Share Posted July 30, 2007 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',...) Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
9 answers to this question
Recommended Posts