[Release] No more MySQL editing for login

[Jvlaple]

I made a shutdown hook for logging all accounts out. Takes away having to edit your database if you forced your batches shut.

public class MapleLogoutHook extends java.lang.Thread {
 public void run() {
  try {
    Connection con = DatabaseConnection.getConnection();
    PreparedStatement ps = con.prepareStatement("UPDATE accounts SET loggedin = 0");
    ps.executeUpdate();
    ps.close();
  } catch (Exception ex) {
    throw new RuntimeException(ex);
  }
}

 

[MrMysterious]

lol might aswell shove it inside the shutdown hook

 

[Jvlaple]

xD Lol you do that

 

[Traitor]

I was going to make something similar to this a long time ago, but never got around to it.

 

[Leaf Story]

lol traitor your so damn lazy xD
but this is awsome
its so anoying to have to reset evreyone to 0

 

[Jvlaple]

thank you.

 

[xbLazE]

Very nice, saves the trouble to go MySQL

 

[TookTook123]

you're on fire man ;D
thanks

 

[Yosher]

Simple and easy. you can just run the query anyway <_<.

 

[watzmename]

sinems has it so everytime you open your server, it does that.

 

[Jvlaple]

thanks for the replies

 

[GMLooney]

Jvlaple, you'll have to give some info for these guys. They're not smart enough to actually add stuff, hence all the repacks -_-

Ummm Leech Protection FTW?

Anyways Nice release, I think I had tried to do this, back when I didn't know SQL and I failed, anyways Nice Release Again.

catch (Exception ex) {
    throw new RuntimeException(ex);
  }

Forgive me if I'm mistaken but shouldn't it be throw then catch?


By the way, you're missing a closing brace at the end.

 

[purpleNblack2]

wait, where do i put this stuff,
sorry idk :

 

[MiniAxel]

You don't need to do this. You can update it inside ChannelServer.java inside the run() function.

 

[RMZero213]

You could just remove the entire loggedin thing and get on with it..

 

[MiniAxel]

You could just remove the entire loggedin thing and get on with it..

OdinMS already sets loggedin to 0 on server start, so this was never needed anyway; and loggedin probably has some sort of use.

 

[zzlawlzz]

[QUOTE=iPwnage

 

[RMZero213]

OdinMS already sets loggedin to 0 on server start, so this was never needed anyway; and loggedin probably has some sort of use.

No it doesn't. Only some repacks do.

And that comment was in reply to the release. If you make a hook for resetting to 0 then you obviously have no use for it and thus it's better to just remove loggedin itself..

 

[MiniAxel]

No it doesn't. Only some repacks do.

@Override
    public void run() {
        try {
            cwi = new ChannelWorldInterfaceImpl(this);
            wci = worldRegistry.registerChannelServer(key, cwi);
            props = wci.getGameProperties();
            expRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.exp"));
            mesoRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.meso"));
            dropRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.drop"));
            bossdropRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.bossdrop"));
            petExpRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.petExp"));
            serverMessage = props.getProperty("net.sf.odinms.world.serverMessage");
            dropUndroppables = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.alldrop", "false"));
            moreThanOne = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.morethanone", "false"));
            eventSM = new EventScriptManager(this, props.getProperty("net.sf.odinms.channel.events").split(","));
            gmWhiteText = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.gmWhiteText", "false"));
            cashshop = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.cashshop", "false"));
            Properties dbProp = new Properties();
            FileReader fileReader = new FileReader("db.properties");
            dbProp.load(fileReader);
            fileReader.close();
            DatabaseConnection.setProps(dbProp);
            DatabaseConnection.getConnection();
            Connection c = DatabaseConnection.getConnection();
            PreparedStatement ps;
            try {
                ps = c.prepareStatement("UPDATE accounts SET loggedin = 0");
                ps.executeUpdate();
                ps.close();
            } catch (SQLException ex) {
                log.error("Could not reset databases",ex);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

From Valhalla, and old version too.

 

[RMZero213]

@Override
    public void run() {
        try {
            cwi = new ChannelWorldInterfaceImpl(this);
            wci = worldRegistry.registerChannelServer(key, cwi);
            props = wci.getGameProperties();
            expRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.exp"));
            mesoRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.meso"));
            dropRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.drop"));
            bossdropRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.bossdrop"));
            petExpRate = Integer.parseInt(props.getProperty("net.sf.odinms.world.petExp"));
            serverMessage = props.getProperty("net.sf.odinms.world.serverMessage");
            dropUndroppables = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.alldrop", "false"));
            moreThanOne = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.morethanone", "false"));
            eventSM = new EventScriptManager(this, props.getProperty("net.sf.odinms.channel.events").split(","));
            gmWhiteText = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.gmWhiteText", "false"));
            cashshop = Boolean.parseBoolean(props.getProperty("net.sf.odinms.world.cashshop", "false"));
            Properties dbProp = new Properties();
            FileReader fileReader = new FileReader("db.properties");
            dbProp.load(fileReader);
            fileReader.close();
            DatabaseConnection.setProps(dbProp);
            DatabaseConnection.getConnection();
            Connection c = DatabaseConnection.getConnection();
            PreparedStatement ps;
            try {
                ps = c.prepareStatement("UPDATE accounts SET loggedin = 0");
                ps.executeUpdate();
                ps.close();
            } catch (SQLException ex) {
                log.error("Could not reset databases",ex);
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

From Valhalla, and old version too.

You said OdinMS, not Valhalla.