// Create Table that contains all fish rewards (drop of fish)
int count2 = 0;
try
{
_fishRewards = new GArray<FishDropData>();
FishDropData fishreward;
statement = con.prepareStatement("SELECT fishid, rewardid, min, max, chance FROM fishreward ORDER BY fishid");
resultSet = statement.executeQuery();
while(resultSet.next())
{
short fishid = resultSet.getShort("fishid");
short rewardid = resultSet.getShort("rewardid");
int mindrop = resultSet.getInt("min");
int maxdrop = resultSet.getInt("max");
int chance = resultSet.getInt("chance");
fishreward = new FishDropData(fishid, rewardid, mindrop, maxdrop, chance);
_fishRewards.add(fishreward);
}
count2 = _fishRewards.size();
}
catch(Exception e)