public void loadchar()
    {
        try {
            ResultSet rs = sql.doquery("SELECT * FROM bout_characters WHERE username='"+ this.account +"' LIMIT 1");
            if(rs.next())
            {
                this.id = rs.getInt("id");
                this.botname = rs.getString("name");
                this.bottype = rs.getInt("bot");
                this.exp = rs.getInt("exp");
                this.level = rs.getInt("level");
                this.hp = rs.getInt("hp");
                this.gigas = rs.getInt("gigas");
                this.attmin = rs.getInt("attmin");
                this.attmax = rs.getInt("attmax");
                this.attmintrans = rs.getInt("attmintrans");
                this.attmaxtrans = rs.getInt("attmaxtrans");
                this.transgauge = rs.getInt("transgauge");
                this.crit = rs.getInt("crit");
                this.evade = rs.getInt("evade");
                this.spectrans = rs.getInt("specialtrans");
                this.speed = rs.getInt("speed");
                this.transdef = rs.getInt("transdef");
                this.transbotatt = rs.getInt("transbotatt");
                this.transspeed = rs.getInt("transspeed");
                this.rangeatt = rs.getInt("rangeatt");
                this.luk = rs.getInt("luk");
                this.botstract = rs.getInt("botstract");

                this.equipitemspart[0] = rs.getInt("equiphead");
                this.equipitemspart[1] = rs.getInt("equipbody");
                this.equipitemspart[2] = rs.getInt("equiparm");
                this.equipitemsgear[0] = rs.getInt("equipminibot");
                this.equipitemsgear[1] = rs.getInt("equipgun");
                this.equipitemsgear[2] = rs.getInt("equipefield");
                this.equipitemsgear[3] = rs.getInt("equipwing");
                this.equipitemsgear[4] = rs.getInt("equipshield");
                this.equipitemsgear[5] = rs.getInt("equiparmpart");
                this.equipitemsgear[6] = rs.getInt("equipflag1");
                this.equipitemsgear[7] = rs.getInt("equipflag2");
                this.equipitemspack[0] = rs.getInt("equippassivskill");
                this.equipitemspack[1] = rs.getInt("equipaktivskill");
                this.equipitemspack[2] = rs.getInt("equippack");
                this.equipitemspack[3] = rs.getInt("equiptransbot");
                this.equipitemspack[4] = rs.getInt("equipmerc");
                this.equipitemspack[5] = rs.getInt("equipmerc2");
                this.equipitemscoin[0] = rs.getInt("equipheadcoin");
                this.equipitemscoin[1] = rs.getInt("equipminibotcoin");
            }
            rs = sql.doquery("SELECT * FROM bout_inventory WHERE name='"+ this.botname +"' LIMIT 1");
            if(rs.next())
            {
                for(int i=2; i<12; i++)
                {
                    this.inventitems[i-2] = rs.getInt(i);
                    //debug(""+inventitems[i-2]);
                }
            }

            rs = sql.doquery("SELECT coins FROM bout_users WHERE username='"+ this.account +"' LIMIT 1");
            if(rs.next())
            {
                this.coins = rs.getInt("coins");
            }
           //debug(""+this.coins);

            //debug("Gigas : "+this.gigas+" Botname: "+this.botname+" Bottype :"+this.bottype+" level : "+this.level+" hp : "+this.hp);
            //debug("attmin : "+this.attmin+" attmax : "+this.attmax);
        } catch (Exception e)
        {

        }
    }