statement = con.prepareStatement("SELECT * FROM class_list, char_templates, lvlupgain WHERE class_list.id = char_templates.classId AND class_list.id = lvlupgain.classId ORDER BY class_list.id");
rset = statement.executeQuery();
while(rset.next())
{
StatsSet set = new StatsSet();
ClassId classId = ClassId.values()[rset.getInt("class_list.id")];
set.set("classId", rset.getInt("class_list.id"));
set.set("className", rset.getString("char_templates.className"));
set.set("raceId", rset.getByte("char_templates.RaceId"));
set.set("baseSTR", rset.getByte("char_templates.STR"));
set.set("baseCON", rset.getByte("char_templates.CON"));
set.set("baseDEX", rset.getByte("char_templates.DEX"));
set.set("baseINT", rset.getByte("char_templates._INT"));
set.set("baseWIT", rset.getByte("char_templates.WIT"));
set.set("baseMEN", rset.getByte("char_templates.MEN"));
set.set("baseHpMax", rset.getFloat("lvlupgain.defaultHpBase"));
set.set("lvlHpAdd", rset.getFloat("lvlupgain.defaultHpAdd"));
set.set("lvlHpMod", rset.getFloat("lvlupgain.defaultHpMod"));
set.set("baseMpMax", rset.getFloat("lvlupgain.defaultMpBase"));
set.set("baseCpMax", rset.getFloat("lvlupgain.defaultCpBase"));
set.set("lvlCpAdd", rset.getFloat("lvlupgain.defaultCpAdd"));
set.set("lvlCpMod", rset.getFloat("lvlupgain.defaultCpMod"));
set.set("lvlMpAdd", rset.getFloat("lvlupgain.defaultMpAdd"));
set.set("lvlMpMod", rset.getFloat("lvlupgain.defaultMpMod"));
set.set("baseHpReg", 0.01);
set.set("baseCpReg", 0.01);
set.set("baseMpReg", 0.01);
set.set("basePAtk", rset.getInt("char_templates.p_atk"));
set.set("basePDef", /* classId.isMage()? 77 : 129 */rset.getInt("char_templates.p_def"));
set.set("baseMAtk", rset.getInt("char_templates.m_atk"));
set.set("baseMDef", 41 /* rset.getInt("char_templates.m_def") */);
set.set("classBaseLevel", rset.getInt("lvlupgain.class_lvl"));
set.set("basePAtkSpd", rset.getInt("char_templates.p_spd"));
set.set("baseMAtkSpd", classId.isMage() ? 166 : 333 /* rset.getInt("char_templates.m_spd") */);
set.set("baseCritRate", rset.getInt("char_templates.critical"));
set.set("baseWalkSpd", rset.getInt("char_templates.walk_spd"));
set.set("baseRunSpd", rset.getInt("char_templates.run_spd"));
set.set("baseShldDef", 0);
set.set("baseShldRate", 0);