Sticky mysql problem

Discussion in 'Plugin Development' started by BaumwolleHD, Oct 12, 2013.

Thread Status:
Not open for further replies.
  1. Offline

    BaumwolleHD

    Hi, the code:

    Code:
    try {
                PreparedStatement worldupdatequery = MySQLManager.c.prepareStatement("REPLACE INTO  `minecraft`.`worlds` (  `name` ,  `world` ,  `hp` ,  `hunger` ,  `air` ,  `gamemode` ,  `flying`  ,  `location` ,  `xp` ,  `maxhp` ,  `exhaustion` ) VALUES ('?','?','?','?','?','?','?','?','?','?','?')");
                worldupdatequery.setString(1, getPlayer().getLocation().getWorld().getName());
                worldupdatequery.setString(2, getPlayer().getName()+"','"+getPlayer().getLocation().getWorld().getName());
                worldupdatequery.setDouble(3, ((Damageable)getPlayer()).getHealth());
                worldupdatequery.setFloat(4, getPlayer().getSaturation());
                worldupdatequery.setInt(5, getPlayer().getRemainingAir());
                worldupdatequery.setString(6, getPlayer().getGameMode().name());
                worldupdatequery.setBoolean(7, getPlayer().isFlying());
                worldupdatequery.setString(8, Loc2Str(getPlayer().getLocation()));
                worldupdatequery.setFloat(9, getPlayer().getExp());
                worldupdatequery.setDouble(10, ((Damageable)getPlayer()).getMaxHealth());
                worldupdatequery.setFloat(11, getPlayer().getExhaustion());
                worldupdatequery.execute();
            } catch (SQLException e) {}
    with this table :

    Code:
    name          varchar(64) PRIMARY KEY
    world          varchar(64) PRIMARY KEY
    hp            double
    hunger        float
    air            int(64)
    gamemode      varchar(64)
    flying        tinyint(1)
    worldsave_id  int(128)
    location      varchar(64)
    xp            float
    maxhp          double
    exhaustion    float
    wont add something to the table please help

    Found out Location was to short and the ? has just to be a ? not a '?'

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 4, 2016
Thread Status:
Not open for further replies.

Share This Page