[Release] Optional meso dropping from database

[PurpleMadness]

Might be a bit confusing title, but it lets you set a min/max meso drop for a monster id in the database, so the monster drops an amount between min/max. Useful for e.g. leprechauns. Uses the normal formula if the monsterid isn't found in the database.

First, execute this query:

CREATE TABLE `mesodrops` (
`id` INT NOT NULL AUTO_INCREMENT ,
`monsterid` INT DEFAULT '0' NOT NULL ,
`min` INT DEFAULT '0' NOT NULL ,
`max` INT DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = innodb;

In MapleMap.java, replace this:

if (drop == -1) { // meso
                    final int mesoRate = ChannelServer.getInstance(dropOwner.getClient().getChannel()).getMesoRate();
                    Random r = new Random();
                    double mesoDecrease = Math.pow(0.93, monster.getExp() / 300.0);
                    if (mesoDecrease > 1.0) {
                        mesoDecrease = 1.0;
                    }
                    int tempmeso = Math.min(30000, (int) (mesoDecrease * (monster.getExp()) *
                        (1.0 + r.nextInt(20)) / 10.0));
                    if(dropOwner.getBuffedValue(MapleBuffStat.MESOUP) != null) {
                        tempmeso = (int) (tempmeso * dropOwner.getBuffedValue(MapleBuffStat.MESOUP).doubleValue() / 100.0);
                    }
                    
                    final int meso = tempmeso;

by this:

if (drop == -1) { // meso
                                    boolean dbmeso = false;
                                    int meso = 0;
                                    Random r = new Random();
                                    try{
                                        Connection con = DatabaseConnection.getConnection();
                                        PreparedStatement ps = con.prepareStatement("SELECT min, max FROM mesodrops WHERE monsterid = ?");
                                        ps.setInt(1, monster.getId());
                                        ResultSet rs = ps.executeQuery();
                                        while(rs.next()){
                                            int min = rs.getInt("min");
                                            int max = rs.getInt("max");
                                            meso = r.nextInt(max-min)+min;
                                            dbmeso = true;
                                        }
                                    }catch(Exception e){
                                        log.error("error in retrieving mesos dropped from db.", e);
                                    }
                                    if(!dbmeso){
                    double mesoDecrease = Math.pow(0.93, monster.getExp() / 300.0);
                    if (mesoDecrease > 1.0) {
                        mesoDecrease = 1.0;
                    }
                    int tempmeso = Math.min(30000, (int) (mesoDecrease * (monster.getExp()) *
                        (1.0 + r.nextInt(20)) / 10.0));
                    if(dropOwner.getBuffedValue(MapleBuffStat.MESOUP) != null) {
                        tempmeso = (int) (tempmeso * dropOwner.getBuffedValue(MapleBuffStat.MESOUP).doubleValue() / 100.0);
                    }
                    
                    meso = tempmeso;
                                    }
                                    final int mesoRate = ChannelServer.getInstance(dropOwner.getClient().getChannel()).getMesoRate();
                                    final int finalmeso = meso;

Replace:

spawnMesoDrop(meso * mesoRate, meso, dropPos, dropMonster, dropChar, isBoss);

by:

spawnMesoDrop(finalmeso * mesoRate, finalmeso, dropPos, dropMonster, dropChar, isBoss);

Add these imports on top:

import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.PreparedStatement;
import net.sf.odinms.database.DatabaseConnection;

Now, add any monster id with the min/max to the database you like! =)
Note: be aware of the meso rate, which is still in effect.

 

[Ridiculous]

Great release!

 

[binhao111]

Nice release!! I will use it in my database xD Thx.

 

[WhiteTigerX]

Might be handy, I might use it later.

 

[zephyic]

so what i done wrong o.0

init:
deps-jar:
Compiling 2 source files to C:\Documents and Settings\sTaT!cvX CeV\Desktop\CeVMs V2\build\classes
C:\Documents and Settings\sTaT!cvX CeV\Desktop\CeVMs V2\src\net\sf\odinms\server\maps\MapleMap.java:347: local variable meso is accessed from within inner class; needs to be declared final
                                                                spawnMesoDrop(meso * mesoRate, meso, dropPos, dropMonster, dropChar, isBoss);
                                                                              ^
C:\Documents and Settings\sTaT!cvX CeV\Desktop\CeVMs V2\src\net\sf\odinms\server\maps\MapleMap.java:347: local variable meso is accessed from within inner class; needs to be declared final
                                                                spawnMesoDrop(meso * mesoRate, meso, dropPos, dropMonster, dropChar, isBoss);
                                                                                               ^
2 errors
BUILD FAILED (total time: 0 seconds)

 

[xblackcat]

Interesting

 

[PurpleMadness]

People, I made an error which made normal money without database not show. I have fixed this in the first post. Just replace the part you added with the new part.

 

[xphire]

Great release, adding to my server ASAP!

 

[PurpleMadness]

Oh and btw:
replace:

spawnMesoDrop(meso * mesoRate, meso, dropPos, dropMonster, dropChar, isBoss);

by:

spawnMesoDrop(finalmeso * mesoRate, finalmeso, dropPos, dropMonster, dropChar, isBoss);

 

[Shadow26]

Awesome. Nice Release.

 

[ihatehaxor]

nice release i might add this soon

 

[zephyic]

work like a charm..
nice work dude!!

 

[PurpleMadness]

Thanks all =)

 

[lols1996]

nice man ima add this

 

[ongdeetz]

Wow work like just an instance ^^ great release!!

 

[Ducky]

Wow work like just an instance ^^ great release!!

You might wanna run.
//Turns on SelfFlame Shield

This is like a year old thread

 

[scarlet12379]

Pretty nice, now to remake the entire mesos drop for each monster! lol not really the thing everyone wants to do.